| | |
| | | @ApiModelProperty(value= "物料类别") |
| | | private String type; |
| | | |
| | | @ApiModelProperty(value= "助记码") |
| | | private String mnemonic; |
| | | @ApiModelProperty(value= "颜色") |
| | | private String color; |
| | | |
| | | @ApiModelProperty(value= "供应商") |
| | | private String supplier; |
| | |
| | | /** |
| | | * 物料单位 |
| | | */ |
| | | @ApiModelProperty(value= "基本单位") |
| | | @ApiModelProperty(value= "物料单位") |
| | | private String str1; |
| | | |
| | | @ApiModelProperty(value= "物料类别") |
| | | @ApiModelProperty(value= "物料规格") |
| | | private String str2; |
| | | |
| | | @ApiModelProperty(value= "规格型号") |
| | | @ApiModelProperty(value= "颜色") |
| | | private String str3; |
| | | |
| | | @ApiModelProperty(value= "状态") |
| | | @ApiModelProperty(value= "客户") |
| | | private String str4; |
| | | |
| | | @ApiModelProperty(value= "助记码") |
| | | @ApiModelProperty(value= "") |
| | | private String str5; |
| | | |
| | | @ApiModelProperty(value= "默认供应商") |
| | | @ApiModelProperty(value= "") |
| | | private String str6; |
| | | |
| | | @ApiModelProperty(value= "默认仓库") |
| | | @ApiModelProperty(value= "") |
| | | private String str7; |
| | | |
| | | @ApiModelProperty(value= "品牌") |
| | | @ApiModelProperty(value= "") |
| | | private String str8; |
| | | |
| | | @ApiModelProperty(value= "采购员") |
| | | @ApiModelProperty(value= "") |
| | | private String str9; |
| | | |
| | | @ApiModelProperty(value= "产地") |
| | | @ApiModelProperty(value= "") |
| | | private String str10; |
| | | |
| | | @ApiModelProperty(value= "序列号管理") |
| | | @ApiModelProperty(value= "") |
| | | private String str11; |
| | | |
| | | @ApiModelProperty(value= "批次管理") |
| | | @ApiModelProperty(value= "") |
| | | private String str12; |
| | | |
| | | @ApiModelProperty(value= "保质期单位") |
| | | @ApiModelProperty(value= "") |
| | | private String str13; |
| | | |
| | | @ApiModelProperty(value= "保质期管理") |
| | | @ApiModelProperty(value= "") |
| | | private String str14; |
| | | |
| | | @ApiModelProperty(value= "保质期") |
| | | @ApiModelProperty(value= "") |
| | | private String str15; |
| | | |
| | | @ApiModelProperty(value= "可销售") |
| | | @ApiModelProperty(value= "") |
| | | private String str16; |
| | | |
| | | @ApiModelProperty(value= "可采购") |
| | | @ApiModelProperty(value= "") |
| | | private String str17; |
| | | |
| | | @ApiModelProperty(value= "可为子件") |
| | | @ApiModelProperty(value= "") |
| | | private String str18; |
| | | |
| | | @ApiModelProperty(value= "可为组件") |
| | | @ApiModelProperty(value= "") |
| | | private String str19; |
| | | |
| | | @ApiModelProperty(value= "辅助属性管理") |
| | | @ApiModelProperty(value= "") |
| | | private String str20; |
| | | |
| | | @ApiModelProperty(value= "成本计算方法") |
| | | @ApiModelProperty(value= "") |
| | | private String str21; |
| | | |
| | | @ApiModelProperty(value= "采购单位") |
| | | @ApiModelProperty(value= "") |
| | | private String str22; |
| | | |
| | | @ApiModelProperty(value= "销售单位") |
| | | @ApiModelProperty(value= "") |
| | | private String str23; |
| | | |
| | | @ApiModelProperty(value= "预警天数") |
| | | @ApiModelProperty(value= "重量") |
| | | private Double num1; |
| | | |
| | | @ApiModelProperty(value= "最低库存数量") |
| | | @ApiModelProperty(value= "") |
| | | private Double num2; |
| | | |
| | | @ApiModelProperty(value= "最高库存数量") |
| | | @ApiModelProperty(value= "") |
| | | private Double num3; |
| | | |
| | | @ApiModelProperty(value= "安全库存") |
| | | @ApiModelProperty(value= "") |
| | | private Double num4; |
| | | |
| | | @ApiModelProperty(value= "税率") |
| | | @ApiModelProperty(value= "") |
| | | private Double num5; |
| | | |
| | | @ApiModelProperty(value= "") |
| | |
| | | |
| | | private String lgnum; //规格 |
| | | private String type; // 物料类别 |
| | | private String mnemonic; // 助记码 |
| | | private String color; // 颜色 |
| | | private String supplier; // 供应商 |
| | | private String warehouse; // 仓库 |
| | | private String brand; // 品牌 |
| | |
| | | |
| | | private String lgnum; //规格 |
| | | private String type; // 物料类别 |
| | | private String mnemonic; // 助记码 |
| | | private String color; // 颜色 |
| | | private String supplier; // 供应商 |
| | | private String warehouse; // 仓库 |
| | | private String brand; // 品牌 |
| | |
| | | /** |
| | | * 仓库号 |
| | | */ |
| | | @ApiModelProperty(value= "助记码") |
| | | private String mnemonic; |
| | | @ApiModelProperty(value= "颜色") |
| | | private String color; |
| | | |
| | | /** |
| | | * 仓库号 |
| | |
| | | /** |
| | | * 仓库号 |
| | | */ |
| | | @ApiModelProperty(value= "助记码") |
| | | private String mnemonic; |
| | | @ApiModelProperty(value= "颜色") |
| | | private String color; |
| | | |
| | | /** |
| | | * 仓库号 |
| | |
| | | public static void setWrkDetl(WrkDetl wrkDetl, MatCode matCode) { |
| | | wrkDetl.setMatnr(matCode.getMatNo()); // 物料编号 |
| | | wrkDetl.setMaktx(matCode.getMatName()); // 物料描述 |
| | | wrkDetl.setLgnum(matCode.getStr3()); // 规格 |
| | | wrkDetl.setType(matCode.getStr2()); // 物料类别 |
| | | wrkDetl.setMnemonic(matCode.getStr5()); // 助记码 |
| | | wrkDetl.setSupplier(matCode.getStr6()); // 默认供应商 |
| | | wrkDetl.setWarehouse(matCode.getStr7()); // 默认仓库 |
| | | wrkDetl.setBrand(matCode.getStr8()); // 品牌 |
| | | wrkDetl.setLgnum(matCode.getStr2()); // 规格 |
| | | wrkDetl.setColor(matCode.getStr3()); // 助记码 |
| | | wrkDetl.setAltme(matCode.getStr1()); // 单位 |
| | | } |
| | | |
| | |
| | | wrkDetl.setMatnr(locDetl.getMatnr()); // 物料编号 |
| | | wrkDetl.setMaktx(locDetl.getMaktx()); // 物料描述 |
| | | wrkDetl.setLgnum(locDetl.getLgnum()); // 规格 |
| | | wrkDetl.setType(locDetl.getType()); // 物料类别 |
| | | wrkDetl.setMnemonic(locDetl.getMnemonic()); // 助记码 |
| | | wrkDetl.setSupplier(locDetl.getSupplier()); // 默认供应商 |
| | | wrkDetl.setWarehouse(locDetl.getWarehouse()); // 默认仓库 |
| | | wrkDetl.setBrand(locDetl.getBrand()); // 品牌 |
| | | wrkDetl.setColor(locDetl.getColor()); // 助记码 |
| | | wrkDetl.setAltme(locDetl.getAltme()); // 单位 |
| | | wrkDetl.setZpallet(locDetl.getZpallet()); // 托盘条码 |
| | | } |
| | |
| | | public static void setLocDetl(LocDetl locDetl, MatCode matCode) { |
| | | locDetl.setMatnr(matCode.getMatNo()); // 物料编号 |
| | | locDetl.setMaktx(matCode.getMatName()); // 物料描述 |
| | | locDetl.setLgnum(matCode.getStr3()); // 规格 |
| | | locDetl.setType(matCode.getStr2()); // 物料类别 |
| | | locDetl.setMnemonic(matCode.getStr5()); // 助记码 |
| | | locDetl.setSupplier(matCode.getStr6()); // 默认供应商 |
| | | locDetl.setWarehouse(matCode.getStr7()); // 默认仓库 |
| | | locDetl.setBrand(matCode.getStr8()); // 品牌 |
| | | locDetl.setLgnum(matCode.getStr2()); // 规格 |
| | | locDetl.setColor(matCode.getStr3()); // 助记码 |
| | | locDetl.setAltme(matCode.getStr1()); // 单位 |
| | | } |
| | | |
| | |
| | | locDetl.setMatnr(wrkDetl.getMatnr()); // 物料编号 |
| | | locDetl.setMaktx(wrkDetl.getMaktx()); // 物料描述 |
| | | locDetl.setLgnum(wrkDetl.getLgnum()); // 规格 |
| | | locDetl.setType(wrkDetl.getType()); // 物料类别 |
| | | locDetl.setMnemonic(wrkDetl.getMnemonic()); // 助记码 |
| | | locDetl.setSupplier(wrkDetl.getSupplier()); // 默认供应商 |
| | | locDetl.setWarehouse(wrkDetl.getWarehouse()); // 默认仓库 |
| | | locDetl.setBrand(wrkDetl.getBrand()); // 品牌 |
| | | locDetl.setColor(wrkDetl.getColor()); // 助记码 |
| | | locDetl.setAnfme(wrkDetl.getAnfme()); // 数量 |
| | | locDetl.setAltme(wrkDetl.getAltme()); // 单位 |
| | | locDetl.setZpallet(wrkDetl.getZpallet()); // 托盘条码 |
| | |
| | | @ExcelProperty(value= "物料名称", index = 2) |
| | | private String matName; |
| | | |
| | | @ExcelProperty(value= "基本单位", index = 8) |
| | | @ExcelProperty(value= "物料单位", index = 8) |
| | | private String str1; |
| | | |
| | | @ExcelProperty(value= "物料类别", index = 3) |
| | | @ExcelProperty(value= "物料规格", index = 3) |
| | | private String str2; |
| | | |
| | | @ExcelProperty(value= "规格型号", index = 5) |
| | | @ExcelProperty(value= "颜色", index = 5) |
| | | private String str3; |
| | | |
| | | @ExcelProperty(value= "状态", index = 6) |
| | | @ExcelProperty(value= "客户", index = 6) |
| | | private String str4; |
| | | |
| | | @ExcelProperty(value= "助记码", index = 7) |
| | | // @ExcelProperty(value= "助记码", index = 7) |
| | | private String str5; |
| | | |
| | | @ExcelProperty(value= "默认供应商", index = 10) |
| | | // @ExcelProperty(value= "默认供应商", index = 10) |
| | | private String str6; |
| | | |
| | | @ExcelProperty(value= "默认仓库", index = 13) |
| | | // @ExcelProperty(value= "默认仓库", index = 13) |
| | | private String str7; |
| | | |
| | | @ExcelProperty(value= "品牌", index = 9) |
| | | // @ExcelProperty(value= "品牌", index = 9) |
| | | private String str8; |
| | | |
| | | @ExcelProperty(value= "采购员", index = 11) |
| | | // @ExcelProperty(value= "采购员", index = 11) |
| | | private String str9; |
| | | |
| | | @ExcelProperty(value= "产地", index = 12) |
| | | // @ExcelProperty(value= "产地", index = 12) |
| | | private String str10; |
| | | |
| | | // @ExcelProperty(value= "序列号管理") |
| | |
| | | // @ExcelProperty(value= "保质期") |
| | | private String str15; |
| | | |
| | | @ExcelProperty(value= "可销售", index = 20) |
| | | // @ExcelProperty(value= "可销售", index = 20) |
| | | private String str16; |
| | | |
| | | @ExcelProperty(value= "可采购", index = 21) |
| | | // @ExcelProperty(value= "可采购", index = 21) |
| | | private String str17; |
| | | |
| | | @ExcelProperty(value= "可为子件", index = 22) |
| | | // @ExcelProperty(value= "可为子件", index = 22) |
| | | private String str18; |
| | | |
| | | @ExcelProperty(value= "可为组件", index = 23) |
| | | // @ExcelProperty(value= "可为组件", index = 23) |
| | | private String str19; |
| | | |
| | | // @ExcelProperty(value= "辅助属性管理") |
| | | private String str20; |
| | | |
| | | @ExcelProperty(value= "成本计算方法", index = 29) |
| | | // @ExcelProperty(value= "成本计算方法", index = 29) |
| | | private String str21; |
| | | |
| | | @ExcelProperty(value= "采购单位", index = 30) |
| | | // @ExcelProperty(value= "采购单位", index = 30) |
| | | private String str22; |
| | | |
| | | @ExcelProperty(value= "销售单位", index = 31) |
| | | // @ExcelProperty(value= "销售单位", index = 31) |
| | | private String str23; |
| | | |
| | | // @ExcelProperty(value= "预警天数") |
| | | @ExcelProperty(value= "重量", index = 7) |
| | | private Double num1; |
| | | |
| | | // @ExcelProperty(value= "最低库存数量") |
| | |
| | | <result column="maktx" property="maktx" /> |
| | | <result column="lgnum" property="lgnum" /> |
| | | <result column="type" property="type" /> |
| | | <result column="mnemonic" property="mnemonic" /> |
| | | <result column="color" property="color" /> |
| | | <result column="supplier" property="supplier" /> |
| | | <result column="warehouse" property="warehouse" /> |
| | | <result column="brand" property="brand" /> |
| | |
| | | <result column="maktx" property="maktx" /> |
| | | <result column="lgnum" property="lgnum" /> |
| | | <result column="type" property="type" /> |
| | | <result column="mnemonic" property="mnemonic" /> |
| | | <result column="color" property="color" /> |
| | | <result column="supplier" property="supplier" /> |
| | | <result column="warehouse" property="warehouse" /> |
| | | <result column="brand" property="brand" /> |
| | |
| | | <result column="maktx" property="maktx" /> |
| | | <result column="lgnum" property="lgnum" /> |
| | | <result column="type" property="type" /> |
| | | <result column="mnemonic" property="mnemonic" /> |
| | | <result column="color" property="color" /> |
| | | <result column="supplier" property="supplier" /> |
| | | <result column="warehouse" property="warehouse" /> |
| | | <result column="brand" property="brand" /> |
| | |
| | | |
| | | var matCols = [ |
| | | {field: 'matNo', align: 'center',title: '物料编码'} |
| | | ,{field: 'barcode', align: 'center',title: '条形码'} |
| | | ,{field: 'matName', align: 'center',title: '物料名称'} |
| | | ,{field: 'str1', align: 'center',title: '基本单位'} |
| | | ,{field: 'str2', align: 'center',title: '物料类别'} |
| | | ,{field: 'str3', align: 'center',title: '规格型号'} |
| | | ,{field: 'str4', align: 'center',title: '状态', hide: true} |
| | | ,{field: 'str5', align: 'center',title: '助记码'} |
| | | ,{field: 'str6', align: 'center',title: '默认供应商'} |
| | | ,{field: 'str7', align: 'center',title: '默认仓库'} |
| | | // ,{field: 'str8', align: 'center',title: '品牌'} |
| | | // ,{field: 'str9', align: 'center',title: '采购员'} |
| | | // ,{field: 'str10', align: 'center',title: '产地'} |
| | | // ,{field: 'str11', align: 'center',title: '序列号管理'} |
| | | // ,{field: 'str12', align: 'center',title: '批次管理'} |
| | | // ,{field: 'str13', align: 'center',title: '保质期单位'} |
| | | // ,{field: 'str14', align: 'center',title: '保质期管理'} |
| | | // ,{field: 'str15', align: 'center',title: '保质期'} |
| | | // ,{field: 'str16', align: 'center',title: '可销售'} |
| | | ,{field: 'str17', align: 'center',title: '可采购', hide: true} |
| | | ,{field: 'str18', align: 'center',title: '可为子件', hide: true} |
| | | // ,{field: 'str19', align: 'center',title: '可为组件'} |
| | | // ,{field: 'str20', align: 'center',title: '辅助属性管理'} |
| | | ,{field: 'str21', align: 'center',title: '成本计算方法', hide: true} |
| | | ,{field: 'str22', align: 'center',title: '采购单位', hide: true} |
| | | ,{field: 'str23', align: 'center',title: '销售单位', hide: true} |
| | | // ,{field: 'num1', align: 'center',title: '预警天数'} |
| | | // ,{field: 'num2', align: 'center',title: '最低库存数量'} |
| | | // ,{field: 'num3', align: 'center',title: '最高库存数量'} |
| | | // ,{field: 'num4', align: 'center',title: '安全库存'} |
| | | // ,{field: 'num5', align: 'center',title: '税率'} |
| | | ,{field: 'str2', align: 'center',title: '物料规格'} |
| | | ,{field: 'str3', align: 'center',title: '颜色'} |
| | | ,{field: 'num1', align: 'center',title: '重量'} |
| | | ,{field: 'str1', align: 'center',title: '物料单位'} |
| | | ,{field: 'str4', align: 'center',title: '客户'} |
| | | ] |
| | | |
| | | var detlCols = [ |
| | | {field: 'matnr', align: 'center',title: '物料编码'} |
| | | {field: 'matnr', align: 'center',title: '物料号'} |
| | | ,{field: 'maktx', align: 'center',title: '物料名称'} |
| | | ,{field: 'lgnum', align: 'center',title: '规格'} |
| | | ,{field: 'type', align: 'center',title: '物料类别'} |
| | | // ,{field: 'mnemonic', align: 'center',title: '助记码'} |
| | | // ,{field: 'supplier', align: 'center',title: '供应商'} |
| | | // ,{field: 'warehouse', align: 'center',title: '仓库'} |
| | | // ,{field: 'brand', align: 'center',title: '品牌'} |
| | | ,{field: 'anfme', align: 'center',title: '数量'} |
| | | ,{field: 'color', align: 'center',title: '颜色'} |
| | | ,{field: 'anfme', align: 'center',title: '重量'} |
| | | ,{field: 'altme', align: 'center',title: '单位'} |
| | | ,{field: 'zpallet', align: 'center',title: '托盘条码'} |
| | | ,{field: 'bname', align: 'center',title: '用户'} |
| | | ] |
| | | |
| | |
| | | removeBtn: true, |
| | | matnr: data[i].matNo, |
| | | maktx: data[i].matName, |
| | | lgnum: data[i].str3, |
| | | type: data[i].str2, |
| | | lgnum: data[i].str2, |
| | | color: data[i].str3, |
| | | altme: data[i].str1, |
| | | }) |
| | | } |