From 856be870ad89178508d70d6f9b41dfc588ce5c6c Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期四, 27 二月 2025 19:54:23 +0800
Subject: [PATCH] #修复拣料回库小概率出现源库位库存明细不存在异常

---
 src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java |   12 ++++++++++++
 1 files changed, 12 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java b/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java
index 77cfa9e..8f49780 100644
--- a/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java
+++ b/src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java
@@ -34,4 +34,16 @@
         return SUCCESS;
     }
 
+    public ReturnT<String> startAgv() {
+        try {
+            int update = jdbcTemplate.update("DELETE agv_loc_detl FROM agv_loc_detl JOIN agv_loc_mast ON agv_loc_detl.loc_no = agv_loc_mast.loc_no WHERE agv_loc_mast.loc_sts = 'O'");
+//            log.info("(ErrorStockHandler)鍒犻櫎鏉℃暟涓猴紱" + update);
+        } catch (Exception e) {
+            e.printStackTrace();
+            TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
+            return FAIL.setMsg(e.getMessage());
+        }
+        return SUCCESS;
+    }
+
 }

--
Gitblit v1.9.1