From 35c26fb50cc90b85a8cf924f7b47e3ab412cabb5 Mon Sep 17 00:00:00 2001
From: chen.llin <1442464845@qq.comm>
Date: 星期六, 10 一月 2026 19:41:14 +0800
Subject: [PATCH] 事务粒度调整
---
src/main/java/com/zy/mapper/WrkMastMapper.java | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/mapper/WrkMastMapper.java b/src/main/java/com/zy/mapper/WrkMastMapper.java
index cddcc58..729fa9a 100644
--- a/src/main/java/com/zy/mapper/WrkMastMapper.java
+++ b/src/main/java/com/zy/mapper/WrkMastMapper.java
@@ -112,4 +112,25 @@
WrkMast selectPickStep2(@Param("barcode")String barcode);
WrkMast selectByWrkNo(@Param("wrkNo")Integer wrkNo);
+
+ /**
+ * 鑾峰彇涓�鏉″埌104绔欑偣鐨勫嚭搴撲换鍔�
+ * @return 宸ヤ綔涓绘。
+ */
+ WrkMast selectBy104();
+
+ @Update({
+ "<script>",
+ "UPDATE asr_wrk_mast",
+ "SET call_agv = 1",
+ "WHERE wrk_no IN",
+ "<foreach item='item' collection='workNos' open='(' separator=',' close=')'>",
+ "#{item}",
+ "</foreach>",
+ "AND io_type IN (101,110,103,104,107)",
+ "AND wrk_sts IN (14,15)",
+ "AND call_agv = 0",
+ "</script>"
+ })
+ void updateCallAgvBatch(@Param("workNos") List<Integer> workNos);
}
--
Gitblit v1.9.1