From 1f97a20465e29c4ae1824aa66408c77213812c40 Mon Sep 17 00:00:00 2001
From: lty <876263681@qq.com>
Date: 星期三, 19 十一月 2025 16:38:18 +0800
Subject: [PATCH] #新增erp中间表库存同步功能
---
src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java | 12 ++++++------
1 files changed, 6 insertions(+), 6 deletions(-)
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 abe3b38..8fb4790 100644
--- a/src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java
+++ b/src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java
@@ -49,7 +49,7 @@
//continue;
}
HashMap<String, String> condition = new HashMap<>();
- condition.put("bill_no", "'" + inHed.getBillNo() + "'");
+ condition.put("BillNO", "'" + inHed.getBillNo() + "'");
List<OutDetTB> inDetTBS = erpSqlServer.selectList(OutDetTB.class, condition);
HashMap<String, Object> hedAndDet = new HashMap<>();
hedAndDet.put("hed", inHed);
@@ -64,7 +64,7 @@
} catch (Exception e) {
log.info(e.getMessage());
// e.printStackTrace();
- String sql = "UPDATE erp_OutHedTB SET Temp3 = 'fault' WHERE BillNo = '" + inHed.getBillNo() + "'";
+ String sql = "UPDATE erp_OutHedTB SET Remark = 'fault' WHERE BillNo = '" + inHed.getBillNo() + "'";
erpSqlServer.update(sql);
//
}
@@ -96,7 +96,7 @@
} catch (Exception e) {
log.info(e.getMessage());
// e.printStackTrace();
- String sql = "UPDATE erp_OutHedTB SET Temp3 = 'fault' WHERE BillNo = '" + inHed.getBillNo() + "'";
+ String sql = "UPDATE erp_OutHedTB SET Remark = 'fault' WHERE BillNo = '" + inHed.getBillNo() + "'";
erpSqlServer.update(sql);
//
}
@@ -109,12 +109,12 @@
OutHedTB hed = (OutHedTB) hedAndDet.get("hed");
ArrayList<OutDetTB> dets = (ArrayList<OutDetTB>) hedAndDet.get("det");
HashMap<String, String> condition = new HashMap<>();
- condition.put("bill_no", "'" + hed.getBillNo() + "'");
+ condition.put("BillNo", "'" + hed.getBillNo() + "'");
erpSqlServer.delete(OutHedTB.class, condition);
for (OutDetTB det : dets) {
HashMap<String, String> condition2 = new HashMap<>();
- condition2.put("bill_no", "'" + det.getBillNo() + "'");
- condition2.put("i_no", String.valueOf(det.getINO()));
+ condition2.put("BillNo", "'" + det.getBillNo() + "'");
+ condition2.put("iNo", String.valueOf(det.getINO()));
erpSqlServer.delete(OutDetTB.class, condition2);
}
--
Gitblit v1.9.1