| | |
| | | |
| | | import com.alibaba.excel.annotation.ExcelIgnoreUnannotated; |
| | | import com.alibaba.excel.annotation.ExcelProperty; |
| | | import com.zy.asrs.entity.Mat; |
| | | import lombok.Data; |
| | | |
| | | /** |
| | | * 0.A 1.B 2.C 3.D 4.E 5.F 6.G 7.H 8.I |
| | | * 9.J 10.K 11.L 12.M 13.N 14.O 15.P 16.Q 17.R 18.S |
| | | * 19.T 20.U 21.V 22.W 23.X 24.Y 25.Z |
| | | */ |
| | | @Data |
| | | @ExcelIgnoreUnannotated |
| | | public class MatExcel extends Mat { |
| | | public class MatExcel { |
| | | |
| | | @ExcelProperty(index = 0, value = "一级分类") |
| | | private String priClass; |
| | |
| | | @ExcelProperty(index = 1, value = "二级分类") |
| | | private String secClass; |
| | | |
| | | @ExcelProperty(index = 2, value = "商品编码") |
| | | private String matnr; |
| | | |
| | | @ExcelProperty(index = 3, value = "商品名称") |
| | | private String maktx; |
| | | |
| | | @ExcelProperty(index = 4, value = "归零阀值") |
| | | private Double safeQty; |
| | | |
| | | @ExcelProperty(index = 5, value = "每公斤长度") |
| | | private Double volume; |
| | | |
| | | @ExcelProperty(index = 6, value = "库存预警数量上限") |
| | | private Double storeMax; |
| | | |
| | | @ExcelProperty(index = 7, value = "库存预警数量下限") |
| | | private Double storeMin; |
| | | } |