| | |
| | | public synchronized R excelImport(MultipartFile file, HashMap<String, Object> hashMap, Long loginUserId) throws Exception { |
| | | ExcelImportResult result = ExcelImportUtil.importExcelMore(file.getInputStream(), AsnOrderTemplate.class, ExcelUtil.getDefaultImportParams()); |
| | | if (result.getList().isEmpty()) { |
| | | throw new CoolException("物料导入失败!!"); |
| | | } |
| | | if (result.getList().isEmpty()) { |
| | | throw new CoolException("表格内容不能为空!!"); |
| | | } |
| | | List<AsnOrderTemplate> resultList = result.getList(); |
| | |
| | | .setMemo(template.getMemo()) |
| | | .setArrTime(date) |
| | | .setUpdateBy(loginUserId) |
| | | .setLogisNo(template.getLogicNo()) |
| | | .setCreateBy(loginUserId) |
| | | .setType(OrderType.getTypeVal(template.getType())) |
| | | .setWkType(OrderWorkType.getWorkType(template.getWkType())); |
| | |
| | | .setIsptResult(QlyIsptResult.getDescVal(orderTemplate.getIsptResult())) |
| | | // .setTrackCode(trackCode) |
| | | .setBarcode(trackCode) |
| | | .setPlatOrderCode(orderTemplate.getPlatOrderCode()) |
| | | .setPlatWorkCode(orderTemplate.getPlatWorkCode()) |
| | | .setProjectCode(orderTemplate.getProjectCode()) |
| | | .setPoCode(orderTemplate.getPoCode()) |
| | | .setPurUnit(matnr.getUnit()) |
| | | .setCreateBy(loginUserId) |