From f13ba9e05f653bc3083c4d17fe8658e67054131e Mon Sep 17 00:00:00 2001
From: huang <1532065656@qq.com>
Date: 星期一, 08 十二月 2025 17:06:23 +0800
Subject: [PATCH] 添加导入Excel表数据功能
---
mes-processes/mes-plcSend/src/main/java/com/mes/device/service/GlassInfoService.java | 14 ++++++++++++++
1 files changed, 14 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..53a6f5c 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,19 @@
* @return 鐜荤拑ID鍒楄〃
*/
List<String> getRecentScannedGlassIds(Integer minutesAgo, Integer maxCount, String workLine);
+
+ /**
+ * 鎵归噺鏇存柊鐜荤拑鐘舵��
+ */
+ boolean updateGlassStatus(List<String> glassIds, String status);
+
+ /**
+ * 灏嗗墠绔笂浼犵殑 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