From ab389a5a6b329b15a655340ba7b87bce7fd7871d Mon Sep 17 00:00:00 2001
From: huang <1532065656@qq.com>
Date: 星期三, 24 十二月 2025 17:16:19 +0800
Subject: [PATCH] 添加新增设备自动生成编码
---
mes-processes/mes-plcSend/src/main/java/com/mes/device/mapper/DeviceConfigMapper.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/mes-processes/mes-plcSend/src/main/java/com/mes/device/mapper/DeviceConfigMapper.java b/mes-processes/mes-plcSend/src/main/java/com/mes/device/mapper/DeviceConfigMapper.java
index dddf712..accea99 100644
--- a/mes-processes/mes-plcSend/src/main/java/com/mes/device/mapper/DeviceConfigMapper.java
+++ b/mes-processes/mes-plcSend/src/main/java/com/mes/device/mapper/DeviceConfigMapper.java
@@ -13,6 +13,12 @@
public interface DeviceConfigMapper extends BaseMapper<DeviceConfig> {
/**
+ * 鑾峰彇璁惧缂栫爜鏈�澶у簭鍙凤紙DEV_xxxxxx 涓殑鏁板瓧閮ㄥ垎锛�
+ */
+ @Select("SELECT IFNULL(MAX(CAST(SUBSTRING(device_code, 5) AS UNSIGNED)), 0) FROM device_config WHERE device_code LIKE 'DEV_%'")
+ Long selectMaxDeviceCodeNumber();
+
+ /**
* 鏍规嵁椤圭洰ID鍜岃澶囩被鍨嬫煡璇㈣澶囬厤缃垪琛�
* @param projectId 椤圭洰ID
* @param deviceType 璁惧绫诲瀷
--
Gitblit v1.8.0