From 0f478c31b5327ffe4bfdebd72fdf23a6df5d37e6 Mon Sep 17 00:00:00 2001 From: Junjie <fallin.jie@qq.com> Date: 星期五, 02 六月 2023 11:55:11 +0800 Subject: [PATCH] 随机获取可用且有空库位的堆垛机号,找新巷道时增加判断 --- src/main/java/com/zy/asrs/task/handler/PlcLogHandler.java | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/task/handler/PlcLogHandler.java b/src/main/java/com/zy/asrs/task/handler/PlcLogHandler.java index 547cedb..d2cecf1 100644 --- a/src/main/java/com/zy/asrs/task/handler/PlcLogHandler.java +++ b/src/main/java/com/zy/asrs/task/handler/PlcLogHandler.java @@ -20,6 +20,7 @@ @Transactional public ReturnT<String> start() { try { + // 涓嬩綅鏈哄懡浠よ浆鍘嗗彶妗� int updateCount = jdbcTemplate.update("insert into asr_stk_hplc select * from asr_stk_plcm where dateadd(day,7,appe_time) <= getdate();"); if (updateCount > 0) { int deleteCount = jdbcTemplate.update("delete from asr_stk_plcm where dateadd(day,7,io_time) <= getdate();"); -- Gitblit v1.9.1