From cdfb6025516e43275982780291b4c5bd866bd9d7 Mon Sep 17 00:00:00 2001 From: lty <876263681@qq.com> Date: 星期五, 25 七月 2025 09:24:16 +0800 Subject: [PATCH] #erp对接修改 --- src/main/java/com/zy/third/erp/task/ERPInHedTBScheduler.java | 15 ++++++++++----- 1 files changed, 10 insertions(+), 5 deletions(-) diff --git a/src/main/java/com/zy/third/erp/task/ERPInHedTBScheduler.java b/src/main/java/com/zy/third/erp/task/ERPInHedTBScheduler.java index 873ca15..08ea63c 100644 --- a/src/main/java/com/zy/third/erp/task/ERPInHedTBScheduler.java +++ b/src/main/java/com/zy/third/erp/task/ERPInHedTBScheduler.java @@ -37,14 +37,15 @@ //@Transactional(rollbackFor = Throwable.class) @Scheduled(cron = "${erp.refreshtime}") public void InHedTBScheduler() { - //log.info("InHedTBScheduler寮�濮嬩簡"); + //log.info("InHedTBScheduler寮�濮嬩簡" + // 7); if (!erpEnabled) return; - String sqlInHed = "select * from erp_InHedTB where LKName='涓壃浜屾湡'"; + String sqlInHed = "select * from erp_InHedTB where LKName='楂橀湒绔嬪簱'"; List<InHedTB> inHeds = erpSqlServer.select(sqlInHed, InHedTB.class); if (!inHeds.isEmpty()) { for (InHedTB inHed : inHeds) { if (!Cools.isEmpty(inHed.getTemp3()) && inHed.getTemp3().equals("fault")) { - continue; + //continue; } HashMap<String, String> condition = new HashMap<>(); condition.put("BillNo", "'" + inHed.getBillNo() + "'"); @@ -52,14 +53,18 @@ HashMap<String, Object> hedAndDet = new HashMap<>(); hedAndDet.put("hed", inHed); hedAndDet.put("det", inDetTBS); + if (inDetTBS == null || inDetTBS.isEmpty()) { + continue; + } try { inMS.createInOrder(inHed, inDetTBS); log.info("鍏ュ簱鍗曟嵁鎴愬姛,{}", inHed); move(hedAndDet); } catch (Exception e) { - e.printStackTrace(); + log.info(e.getMessage()); + //e.printStackTrace(); String sql = "UPDATE erp_InHedTB SET Temp3 = 'fault' WHERE BillNo = '" + inHed.getBillNo() + "'"; - erpSqlServer.update(sql); + erpSqlServer.update(sql); } } } -- Gitblit v1.9.1