From d599942e79ea0198898bdfde049b908418debf54 Mon Sep 17 00:00:00 2001 From: lty <876263681@qq.com> Date: 星期五, 13 六月 2025 10:13:14 +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