From 3ff680c755e797879d0629efec67f109d233a857 Mon Sep 17 00:00:00 2001 From: lty <876263681@qq.com> Date: 星期三, 23 七月 2025 11:05:34 +0800 Subject: [PATCH] # --- 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