自动化立体仓库 - WMS系统
zhangchao
2024-11-15 7c1af4c63e66754f0868c1a501f4895f9cbc9213
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();");