| | |
| | | Row row = sheet.getRow(i); |
| | | // 订单编号 |
| | | String uuid = dataFormatter.formatCellValue(row.getCell(0)); |
| | | // 商品名称 |
| | | // 品名 |
| | | String maktx = dataFormatter.formatCellValue(row.getCell(1)); |
| | | // 商品编码 |
| | | // 品号 |
| | | String matnr = dataFormatter.formatCellValue(row.getCell(2)); |
| | | // 商品编码 |
| | | // 品号 |
| | | String batch = dataFormatter.formatCellValue(row.getCell(3)); |
| | | // 数量 |
| | | Double anfme = Double.parseDouble(dataFormatter.formatCellValue(row.getCell(4))); |
| | |
| | | |
| | | Mat mat = matService.selectByMatnr(matnr); |
| | | if (null == mat) { |
| | | throw new CoolException(matnr + "商品编码的商品不存在,请重新导入!"); |
| | | throw new CoolException(matnr + "品号的商品不存在,请重新导入!"); |
| | | } |
| | | |
| | | Order order = orderService.selectByNo(uuid); |