From 22e17b6db03ca58bc477a35ca067e55a09cffce7 Mon Sep 17 00:00:00 2001
From: huang <1532065656@qq.com>
Date: 星期三, 10 十二月 2025 17:04:08 +0800
Subject: [PATCH] 添加工程表及相关逻辑,防止重复导入Excel表序号重复生成
---
mes-processes/mes-plcSend/src/main/java/com/mes/device/service/GlassInfoService.java | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/mes-processes/mes-plcSend/src/main/java/com/mes/device/service/GlassInfoService.java b/mes-processes/mes-plcSend/src/main/java/com/mes/device/service/GlassInfoService.java
index 827d87c..497e6bd 100644
--- a/mes-processes/mes-plcSend/src/main/java/com/mes/device/service/GlassInfoService.java
+++ b/mes-processes/mes-plcSend/src/main/java/com/mes/device/service/GlassInfoService.java
@@ -70,5 +70,26 @@
* @return 鐜荤拑ID鍒楄〃
*/
List<String> getRecentScannedGlassIds(Integer minutesAgo, Integer maxCount, String workLine);
+
+ /**
+ * 鎵归噺鏇存柊鐜荤拑鐘舵��
+ */
+ boolean updateGlassStatus(List<String> glassIds, String status);
+
+ /**
+ * 鑾峰彇 MES 宸ョ▼瀵煎叆 URL
+ *
+ * @return MES 宸ョ▼瀵煎叆 URL
+ */
+ String getMesEngineeringImportUrl();
+
+ /**
+ * 灏嗗墠绔笂浼犵殑 Excel 琛屾暟鎹浆鎹负 MES 瀵煎叆宸ョ▼鎵�闇�鐨� JSON 缁撴瀯
+ *
+ * @param excelRows 鍓嶇瑙f瀽鍚庣殑琛屾暟鎹紝瀛楁绀轰緥锛�
+ * glassId,width,height,thickness,quantity,orderNumber,filmsId,flowCardId,productName,customerName
+ * @return 绗﹀悎 MES 鎺ュ彛瑕佹眰鐨勮姹備綋 Map
+ */
+ Map<String, Object> buildEngineerImportPayload(List<Map<String, Object>> excelRows);
}
--
Gitblit v1.8.0