From f6bcf1ba29b88c32b23def2bd6f3cee08905ce07 Mon Sep 17 00:00:00 2001
From: lyh <925863403@qq.com>
Date: 星期二, 08 七月 2025 21:17:46 +0800
Subject: [PATCH] 修改设备查询

---
 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamTechnicalStatusEvaluationStandardServiceImpl.java |    2 +-
 lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/service/impl/EamEquipmentServiceImpl.java                  |    6 +++---
 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamInspectionOrderServiceImpl.java                   |    2 +-
 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamMaintenanceStandardServiceImpl.java               |   37 +++++++++++--------------------------
 4 files changed, 16 insertions(+), 31 deletions(-)

diff --git a/lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/service/impl/EamEquipmentServiceImpl.java b/lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/service/impl/EamEquipmentServiceImpl.java
index 4976c34..0d3a6d7 100644
--- a/lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/service/impl/EamEquipmentServiceImpl.java
+++ b/lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/service/impl/EamEquipmentServiceImpl.java
@@ -169,7 +169,7 @@
             if(!CollectionUtils.isEmpty(baseFactoryUserList)){
                 List<String> factoryIds = baseFactoryUserList.stream().map(BaseFactoryUser::getFactoryId).collect(Collectors.toList());
                 List<String> factoryCode= baseFactoryService.listByIds(factoryIds).stream().map(BaseFactory::getFactoryCode).collect(Collectors.toList());
-                queryWrapper.in("e.factory_code", factoryCode);
+                queryWrapper.in("e.factory_org_code", factoryCode);
             }
         }
         //鏌ヨ鏉′欢杩囨护
@@ -257,7 +257,7 @@
             if(!CollectionUtils.isEmpty(baseFactoryUserList)){
                 List<String> factoryIds = baseFactoryUserList.stream().map(BaseFactoryUser::getFactoryId).collect(Collectors.toList());
                 List<String> factoryCode= baseFactoryService.listByIds(factoryIds).stream().map(BaseFactory::getFactoryCode).collect(Collectors.toList());
-                queryWrapper.in("e.factory_code", factoryCode);
+                queryWrapper.in("e.factory_org_code", factoryCode);
             }
         }
 
@@ -336,7 +336,7 @@
             if(!CollectionUtils.isEmpty(baseFactoryUserList)){
                 List<String> factoryIds = baseFactoryUserList.stream().map(BaseFactoryUser::getFactoryId).collect(Collectors.toList());
                 List<String> factoryCode= baseFactoryService.listByIds(factoryIds).stream().map(BaseFactory::getFactoryCode).collect(Collectors.toList());
-                queryWrapper.in("e.factory_code", factoryCode);
+                queryWrapper.in("e.factory_org_code", factoryCode);
             }
 
         }
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamInspectionOrderServiceImpl.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamInspectionOrderServiceImpl.java
index ab31904..4065bf5 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamInspectionOrderServiceImpl.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamInspectionOrderServiceImpl.java
@@ -104,7 +104,7 @@
             if (!CollectionUtils.isEmpty(baseFactoryUserList)) {
                 List<String> factoryIds = baseFactoryUserList.stream().map(BaseFactoryUser::getFactoryId).collect(Collectors.toList());
                 List<String> factoryCode = baseFactoryService.listByIds(factoryIds).stream().map(BaseFactory::getFactoryCode).collect(Collectors.toList());
-                queryWrapper.in("e.factory_code", factoryCode);
+                queryWrapper.in("e.factory_org_code", factoryCode);
             }
         }
         //鏌ヨ鏉′欢杩囨护
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamMaintenanceStandardServiceImpl.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamMaintenanceStandardServiceImpl.java
index bd7f285..d6c9e23 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamMaintenanceStandardServiceImpl.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamMaintenanceStandardServiceImpl.java
@@ -129,7 +129,7 @@
             if(!CollectionUtils.isEmpty(baseFactoryUserList)){
                 List<String> factoryIds = baseFactoryUserList.stream().map(BaseFactoryUser::getFactoryId).collect(Collectors.toList());
                 List<String> factoryCode= baseFactoryService.listByIds(factoryIds).stream().map(BaseFactory::getFactoryCode).collect(Collectors.toList());
-                queryWrapper.in("e.factory_code", factoryCode);
+                queryWrapper.in("e.factory_org_code", factoryCode);
             }
         }
         if(eamMaintenanceStandard != null) {
@@ -667,22 +667,14 @@
         }
 
         // 鍏宠仈璁惧ID
-        if (isNotBlank(standard.getEquipmentCode()) &&
-                isNotBlank(standard.getEquipmentName())) {
-
-            List<EamEquipment> equipments = eamEquipmentService.list(
-                    new QueryWrapper<EamEquipment>()
-                            .eq("equipment_code", standard.getEquipmentCode())
-                            .eq("equipment_name", standard.getEquipmentName())
-            );
-
-            if (!equipments.isEmpty()) {
-                standard.setEquipmentId(equipments.get(0).getId());
-            }else {
+        if (StrUtil.isNotEmpty(standard.getEquipmentCode())) {
+            EamEquipment equipments = eamEquipmentService.selectByEquipmentCode(standard.getEquipmentCode());
+            if (equipments == null) {
                 return null;
+            }else {
+                standard.setEquipmentId(equipments.getId());
             }
         }
-
         String codeSeq = businessCodeRuleService.generateBusinessCodeSeq(BusinessCodeConst.MAINTENANCE_STANDARD_CODE_RULE);
         standard.setStandardCode(codeSeq);
         standard.setMaintenanceCategory("POINT_INSPECTION");
@@ -1066,19 +1058,12 @@
         standard.setEquipmentModel(row2Data.get("璁惧鍨嬪彿"));
 
         // 鍏宠仈璁惧ID
-        if (isNotBlank(standard.getEquipmentCode()) &&
-                isNotBlank(standard.getEquipmentName())) {
-
-            List<EamEquipment> equipments = eamEquipmentService.list(
-                    new QueryWrapper<EamEquipment>()
-                            .eq("equipment_code", standard.getEquipmentCode())
-                            .eq("equipment_name", standard.getEquipmentName())
-            );
-
-            if (!equipments.isEmpty()) {
-                standard.setEquipmentId(equipments.get(0).getId());
-            }else {
+        if (StrUtil.isNotEmpty(standard.getEquipmentCode())) {
+            EamEquipment equipments = eamEquipmentService.selectByEquipmentCode(standard.getEquipmentCode());
+            if (equipments == null) {
                 return null;
+            }else {
+                standard.setEquipmentId(equipments.getId());
             }
         }
 
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamTechnicalStatusEvaluationStandardServiceImpl.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamTechnicalStatusEvaluationStandardServiceImpl.java
index 341f040..2f52af9 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamTechnicalStatusEvaluationStandardServiceImpl.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/EamTechnicalStatusEvaluationStandardServiceImpl.java
@@ -70,7 +70,7 @@
             if (!CollectionUtils.isEmpty(baseFactoryUserList)) {
                 List<String> factoryIds = baseFactoryUserList.stream().map(BaseFactoryUser::getFactoryId).collect(Collectors.toList());
                 List<String> factoryCode = baseFactoryService.listByIds(factoryIds).stream().map(BaseFactory::getFactoryCode).collect(Collectors.toList());
-                queryWrapper.in("e.factory_code", factoryCode);
+                queryWrapper.in("e.factory_org_code", factoryCode);
             } else {
                 return page;
             }

--
Gitblit v1.9.3