From b0978a62cf2050170793e87fbd01db1760808043 Mon Sep 17 00:00:00 2001
From: xiaoyi <908147524@qq.com>
Date: 星期三, 04 十一月 2026 09:50:30 +0800
Subject: [PATCH] feat: 从长辉移植新高缺失的六个业务模块(安全生产/能耗/数采/备件/质检台账/售后问题回访)

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/machinery/MesDvMachineryMapper.java |   16 ++++++++++++++++
 1 files changed, 16 insertions(+), 0 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/machinery/MesDvMachineryMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/machinery/MesDvMachineryMapper.java
index 56c2161..2ec5c50 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/machinery/MesDvMachineryMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/machinery/MesDvMachineryMapper.java
@@ -37,4 +37,20 @@
         return selectCount(MesDvMachineryDO::getMachineryTypeId, machineryTypeId);
     }
 
+    /**
+     * 鎸夋暟閲囪澶囩紪鍙锋煡璇㈣澶囷紙MQTT devId锛�
+     */
+    default MesDvMachineryDO selectByCollectDeviceCode(String collectDeviceCode) {
+        return selectOne(MesDvMachineryDO::getCollectDeviceCode, collectDeviceCode);
+    }
+
+    /**
+     * 鏌ヨ鎵�鏈夊凡閰嶇疆鏁伴噰璁惧缂栧彿鐨勮澶�
+     */
+    default java.util.List<MesDvMachineryDO> selectListWithCollectDeviceCode() {
+        return selectList(new LambdaQueryWrapperX<MesDvMachineryDO>()
+                .isNotNull(MesDvMachineryDO::getCollectDeviceCode)
+                .orderByAsc(MesDvMachineryDO::getId));
+    }
+
 }

--
Gitblit v1.9.3