public Boolean importMaterial(MultipartFile excel/*,String selectedCompanyName*/) throws IOException { Workbook workbook; UserContext.UserInfo currentUserInfo = UserContext.getCurrentUserInfo(); String currentUserName = null == currentUserInfo ? null : currentUserInfo.getUserName(); try { File file = multiPartFileToFile2(excel); FileInputStream excelFile = new FileInputStream(file); workbook = new XSSFWorkbook(excelFile); Sheet sheet = workbook.getSheetAt(0); Project project = new Project(); project.setCreatedTime(ZonedDateTime.now(ZoneId.of("UTC"))); project.setUpdatedTime(ZonedDateTime.now(ZoneId.of("UTC"))); project.setCreatedBy(StringUtils.isBlank(project.getCreatedBy()) ? currentUserName : project.getCreatedBy()); project.setUpdatedBy(StringUtils.isBlank(project.getUpdatedBy()) ? currentUserName : project.getUpdatedBy()); //project.setCompany_name(selectedCompanyName); project.setIs_ask(IsAskEnum.待审批); List<MaterialApply> materialApplyList = new ArrayList<>(); boolean projectDataFound = false; boolean materialDataFound = false; for (Row row : sheet) { if (!projectDataFound) { if (isDataRow(row, 0, "申请单号：")) { project.setId(UniqueIdGenerator.generateUniqueId()); extractProjectData(row, project); projectDataFound = true; } } else { if (isDataRow(row, 1, "物料编码")) { materialDataFound = true; continue; } if (materialDataFound && isMaterialDataRow(row)) { MaterialApply materialApply = new MaterialApply(); materialApply.setId(UniqueIdGenerator.generateUniqueId()); materialApply.setProject_id(project.getId()); materialApply.setRequest_no(project.getRequest_no()); materialApply.setData_from("Excel导入"); materialApply.setCreated_by(StringUtils.isBlank(materialApply.getCreated_by()) ? currentUserName : materialApply.getCreated_by()); materialApply.setUpdated_by(StringUtils.isBlank(materialApply.getUpdated_by()) ? currentUserName : materialApply.getUpdated_by()); extractMaterialData(row, materialApply); materialApplyList.add(materialApply); //handleItemcode(materialApply.getMaterial_code()); } else if (isDataRow(row, 0, "下单原因")) { String applyReason = getCellStringValue(row, 2); project.setApply_reason(applyReason); break; // 假设下单原因之后没有更多数据 } } } workbook.close(); QueryWrapper<Project> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("request_no", project.getRequest_no()); queryWrapper.eq("is_del", 0); boolean equals = projectService.exists(queryWrapper); if (equals){ throw new RuntimeException("申请单号已存在"); } //保存申请单数据 projectService.save(project); //保存物料申请单数据 boolean savedBatch = materialApplyService.saveBatch(materialApplyList); List<MultipartFile> excels = new ArrayList<>(); excels.add(excel); SendApproved(project, excels); return savedBatch; } catch (Exception e) { throw new RuntimeException(e); } }