Excel导出优化

zhangchao

2024-11-05 cef894f7e1489cd776a9ebd91c1b358c9a241dcf

 src/main/java/com/zy/asrs/task/handler/NotifyLogHandler.java

@@ -21,13 +21,14 @@
    public ReturnT<String> start() {
        try {
            // 入库通知档转历史档
            int pakInLog = jdbcTemplate.update("insert into cust_wait_pakin_log select * from cust_wait_pakin where status = 'Y';");
            int pakInLog = jdbcTemplate.update("insert into cust_wait_pakin_log select * from cust_wait_pakin where io_status = 'F';");
            if (pakInLog > 0) {
                int pakInDelete = jdbcTemplate.update("delete from cust_wait_pakin where status = 'Y';");
                int pakInDelete = jdbcTemplate.update("delete from cust_wait_pakin where io_status = 'F';");
                if (pakInDelete <= 0) {
                    exceptionHandle("入库通知档转历史档失败");
                }
            }
            // todo:luxiaotao
            // 出库通知档转历史档

            // 盘点通知档转历史档