From 6e042d7f0e1982cf54deedba6fe4ddfe8353af13 Mon Sep 17 00:00:00 2001 From: zyx <zyx123456> Date: 星期四, 27 六月 2024 09:37:11 +0800 Subject: [PATCH] 自动清空agv空库位库存 --- src/main/java/com/zy/asrs/task/ErrorStockScheduler.java | 8 ++++++++ src/main/java/com/zy/asrs/task/handler/ErrorStockHandler.java | 12 ++++++++++++ 2 files changed, 20 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/task/ErrorStockScheduler.java b/src/main/java/com/zy/asrs/task/ErrorStockScheduler.java index deb20bf..6961994 100644 --- a/src/main/java/com/zy/asrs/task/ErrorStockScheduler.java +++ b/src/main/java/com/zy/asrs/task/ErrorStockScheduler.java @@ -28,6 +28,14 @@ } } + @Scheduled(cron = "0/60 * * * * ? ") + private void executeAgv(){ + ReturnT<String> returnT = errorStockHandler.startAgv(); + if (!returnT.isSuccess()) { + log.error(returnT.getMsg()); + } + } + // @Autowired // private BasErrLogService basErrLogService; // @Autowired 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