#erp对接修改

lty

6 天以前 cdfb6025516e43275982780291b4c5bd866bd9d7

 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);
        }