From 7700682fff12026bee8b884a99366b5b64994b65 Mon Sep 17 00:00:00 2001
From: zhangc <zc@123>
Date: 星期六, 23 十一月 2024 15:32:09 +0800
Subject: [PATCH] 修复ERP任务调度中空数据校验

---
 src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java |    6 ++++--
 src/main/java/com/zy/third/erp/task/ERPInHedTBScheduler.java  |    3 +++
 2 files changed, 7 insertions(+), 2 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 483371a..b065e50 100644
--- a/src/main/java/com/zy/third/erp/task/ERPInHedTBScheduler.java
+++ b/src/main/java/com/zy/third/erp/task/ERPInHedTBScheduler.java
@@ -52,6 +52,9 @@
                 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);
diff --git a/src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java b/src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java
index 31326fe..e36b912 100644
--- a/src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java
+++ b/src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java
@@ -54,6 +54,9 @@
                 HashMap<String, Object> hedAndDet = new HashMap<>();
                 hedAndDet.put("hed", inHed);
                 hedAndDet.put("det", inDetTBS);
+                if (inDetTBS == null || inDetTBS.isEmpty()) {
+                    continue;
+                }
                 try {
                     inMS.createOutOrder(inHed, inDetTBS);
                     log.info("鍑哄簱鍗曟嵁鎴愬姛,{}", inHed);
@@ -70,11 +73,10 @@
     }
 
 
-
     public void OutHedTBScheduler(String orderNo) {
         //log.info("OutHedTBScheduler寮�濮嬩簡");
         if (!erpEnabled) return;
-        String sqlInHed = "select * from erp_OutHedTB where LKName='涓壃浜屾湡' and BillNo = '"+ orderNo +"'";
+        String sqlInHed = "select * from erp_OutHedTB where LKName='涓壃浜屾湡' and BillNo = '" + orderNo + "'";
         List<OutHedTB> inHeds = erpSqlServer.select(sqlInHed, OutHedTB.class);
         if (!inHeds.isEmpty()) {
             for (OutHedTB inHed : inHeds) {

--
Gitblit v1.9.1