From 0925a458d92d33aa05b2fb03aec3ac8c13e5d763 Mon Sep 17 00:00:00 2001 From: LSH Date: 星期三, 04 一月 2023 11:23:16 +0800 Subject: [PATCH] #中间表对接:订单完结上报完成 --- src/main/java/com/zy/ints/task/scheduler/ErpLkScheduler.java | 10 +++++----- 1 files changed, 5 insertions(+), 5 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..2f53d22 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() { 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