#调试

lty

2025-05-17 af4b93104f60c8061b3887cce627730f29e983ac

 src/main/java/com/zy/third/erp/task/ERPInHedTBScheduler.java

@@ -40,7 +40,7 @@
        //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) {
@@ -48,7 +48,7 @@
                    //continue;
                }
                HashMap<String, String> condition = new HashMap<>();
                condition.put("BillNo", "'" + inHed.getBillNo() + "'");
                condition.put("bill_no", "'" + inHed.getBillNo() + "'");
                List<InDetTB> inDetTBS = erpSqlServer.selectList(InDetTB.class, condition);
                HashMap<String, Object> hedAndDet = new HashMap<>();
                hedAndDet.put("hed", inHed);
@@ -63,7 +63,7 @@
                } catch (Exception e) {
                    log.info(e.getMessage());
                    //e.printStackTrace();
                    String sql = "UPDATE erp_InHedTB SET Temp3 = 'fault' WHERE BillNo = '" + inHed.getBillNo() + "'";
                    String sql = "UPDATE erp_InHedTB SET Temp3 = 'fault' WHERE bill_no = '" + inHed.getBillNo() + "'";
                        erpSqlServer.update(sql);
                }
            }
@@ -76,12 +76,12 @@
        InHedTB hed = (InHedTB) hedAndDet.get("hed");
        ArrayList<InDetTB> dets = (ArrayList<InDetTB>) hedAndDet.get("det");
        HashMap<String, String> condition = new HashMap<>();
        condition.put("BillNo", "'" + hed.getBillNo() + "'");
        condition.put("bill_no", "'" + hed.getBillNo() + "'");
        erpSqlServer.delete(InHedTB.class, condition);
        for (InDetTB det : dets) {
            HashMap<String, String> condition2 = new HashMap<>();
            condition2.put("BillNo", "'" + det.getBillNo() + "'");
            condition2.put("iNo", String.valueOf(det.getINO()));
            condition2.put("bill_no", "'" + det.getBillNo() + "'");
            condition2.put("i_no", String.valueOf(det.getINO()));
            erpSqlServer.delete(InDetTB.class, condition2);
        }