From 5e897ddc2d95be29dd322e53738a2d2157a9ee20 Mon Sep 17 00:00:00 2001 From: LSH Date: 星期三, 04 一月 2023 14:06:34 +0800 Subject: [PATCH] #中间表对接:日志文件优化 --- src/main/java/com/zy/ints/task/scheduler/ErpLkScheduler.java | 12 ++++++------ 1 files changed, 6 insertions(+), 6 deletions(-) diff --git a/src/main/java/com/zy/ints/task/scheduler/ErpLkScheduler.java b/src/main/java/com/zy/ints/task/scheduler/ErpLkScheduler.java index e2adc02..4264d62 100644 --- a/src/main/java/com/zy/ints/task/scheduler/ErpLkScheduler.java +++ b/src/main/java/com/zy/ints/task/scheduler/ErpLkScheduler.java @@ -25,17 +25,17 @@ @Autowired private ErpSqlServer erpSqlServer; /** - * 鑾峰彇鍏ュ嚭搴撹鍗曚俊鎭� + * ERP涓巐k搴撳瓨鏁版嵁姣斿 */ @Scheduled(cron = "${erp.refreshtime}") - public void InOrOutOrder() { + public void proofread() { if (!erpEnabled) return; - String sqlSelecterpLk = "select prd_no as prdNo,prd_mark as prdMark,qty,wh,status,temp1,temp2,temp3 from bas_erp_lk where 1=1"; - String sqlUpDateerpLkOne = "update bas_erp_lk set status=1 where prd_no="; - String sqlUpDateerpLkTwo = "update bas_erp_lk set status=2 where prd_no="; + String sqlSelectErpLk = "select prd_no as prdNo,prd_mark as prdMark,qty,wh,status,temp1,temp2,temp3 from bas_erp_lk where 1=1"; + String sqlUpDateErpLkOne = "update bas_erp_lk set status=1 where prd_no="; + String sqlUpDateErpLkTwo = "update bas_erp_lk set status=2 where prd_no="; try { - List<ErpLk> erpLks = erpSqlServer.select(sqlSelecterpLk, ErpLk.class); + List<ErpLk> erpLks = erpSqlServer.select(sqlSelectErpLk, ErpLk.class); if (erpLks.size() > 0){ for (ErpLk erpLk:erpLks){ Integer status = erpLk.getStatus(); -- Gitblit v1.9.1