From 417c2e6247704736e79db39414abd4e2f0f9ecc6 Mon Sep 17 00:00:00 2001 From: “linengliang” <vanSuperEnergy@163.com> Date: 星期二, 05 十二月 2023 17:19:26 +0800 Subject: [PATCH] 优化 --- lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/MaintenanceStandardController.java | 27 ++++++++++++++++++++++----- 1 files changed, 22 insertions(+), 5 deletions(-) diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/MaintenanceStandardController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/MaintenanceStandardController.java index 3606d73..b4c92dd 100644 --- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/MaintenanceStandardController.java +++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/MaintenanceStandardController.java @@ -302,14 +302,17 @@ equipmentNum =cellEquipmentNum.getText(); equipment = equipmentService.getOne(new QueryWrapper<Equipment>().eq("num",equipmentNum).eq("del_flag",0),false); if(ObjectUtils.isNotNull(equipment)){ - maintenanceStandard = maintenanceStandardService.getOne(new QueryWrapper<MaintenanceStandard>().eq("version_status",2).eq("del_flag",0).eq("equipment_id",equipment.getId()),false); + maintenanceStandard = maintenanceStandardService.getOne(new QueryWrapper<MaintenanceStandard>().eq("version_status","2").eq("del_flag",0).eq("equipment_id",equipment.getId()),false); if(ObjectUtils.isNull(maintenanceStandard)){ maintenanceStandard = new MaintenanceStandard(); maintenanceStandard.setNum(sysIdentityService.getNumByTypeAndLength("DailyMaintenanceStandard",4)); maintenanceStandard.setEquipmentId(equipment.getId()); maintenanceStandard.setAssignMode("1"); maintenanceStandard.setVersion("1.0"); + maintenanceStandard.setType("daily"); maintenanceStandard.setVersionStatus("2"); + maintenanceStandard.setDelFlag(0); + maintenanceStandard.setApprovalStatus("5"); maintenanceStandardService.save(maintenanceStandard); } else { @@ -327,11 +330,17 @@ else { continue; } + String role0 = ""; for (XWPFTableRow row : table.getRows()) { XWPFTableCell cell0 = row.getCell(0); XWPFTableCell cell2 = row.getCell(2); - if(rowNumber>3){ - String role = getMergedCellValue(cell0); + if(rowNumber>1){ + String role = cell0.getText(); + if(StringUtils.isNotBlank(role)){ + role0=role; + } + } + if(rowNumber>2){ String projectName = cell2.getText(); MaintenanceStandardDetail maintenanceStandardDetail = new MaintenanceStandardDetail(); MaintenanceProjectCategory maintenanceProjectCategory = maintenanceProjectCategoryService.getOne(new QueryWrapper<MaintenanceProjectCategory>().eq("name","浜岀骇淇濆吇").eq("del_flag",0),false); @@ -347,15 +356,18 @@ maintenanceProjectService.save(maintenanceProject); } maintenanceStandardDetail.setMaintenanceProjectId(maintenanceProject.getId()); - if(role.equals("缁翠慨浜哄憳淇濆吇鍐呭")){ + if(role0.equals("缁翠慨浜哄憳淇濆吇鍐呭")){ maintenanceStandardDetail.setMaintenanceRole("maintenance"); - } else if(role.equals("鎿嶄綔浜哄憳淇濆吇鍐呭")){ + } else if(role0.equals("鎿嶄綔浜哄憳淇濆吇鍐呭")){ maintenanceStandardDetail.setMaintenanceRole("operator"); } if(ObjectUtils.isNotNull(maintenanceCycle)){ maintenanceStandardDetail.setMaintenanceCycleId(maintenanceCycle.getId()); } + maintenanceStandardDetail.setDelFlag(0); + maintenanceStandardDetail.setMaintenanceStandardId(maintenanceStandard.getId()); maintenanceStandardDetailService.save(maintenanceStandardDetail); + } } @@ -363,6 +375,7 @@ } } } + return Result.OK("瀵煎叆鎴愬姛"); } else { System.out.println("鏃犳硶瑙f瀽璇ユ枃浠�"); } @@ -420,6 +433,8 @@ maintenanceStandard.setAssignMode("1"); maintenanceStandard.setVersion("1.0"); maintenanceStandard.setVersionStatus("2"); + maintenanceStandard.setType("daily"); + maintenanceStandard.setApprovalStatus("5"); maintenanceStandardService.save(maintenanceStandard); } else { @@ -467,6 +482,7 @@ maintenanceStandardDetail.setMaintenanceProjectId(maintenanceProject.getId()); maintenanceStandardDetail.setLocation(location); maintenanceStandardDetail.setMaintenanceCycleId(maintenanceCycle.getId()); + maintenanceStandardDetail.setMaintenanceStandardId(maintenanceStandard.getId()); maintenanceStandardDetailService.save(maintenanceStandardDetail); } @@ -644,4 +660,5 @@ return cell.getParagraphs().get(0).getText(); } + } -- Gitblit v1.9.3