#

lty

8 天以前 3ff680c755e797879d0629efec67f109d233a857

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

@@ -37,14 +37,15 @@
    //@Transactional(rollbackFor = Throwable.class)
    @Scheduled(cron = "${erp.refreshtime}")
    public void InHedTBScheduler() {
        //log.info("InHedTBScheduler开始了");
        //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) {
                if (!Cools.isEmpty(inHed.getTemp3()) && inHed.getTemp3().equals("fault")) {
                    continue;
                    //continue;
                }
                HashMap<String, String> condition = new HashMap<>();
                condition.put("BillNo", "'" + inHed.getBillNo() + "'");
@@ -52,14 +53,18 @@
                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);
                    move(hedAndDet);
                } catch (Exception e) {
                    e.printStackTrace();
                    log.info(e.getMessage());
                    //e.printStackTrace();
                    String sql = "UPDATE erp_InHedTB SET Temp3 = 'fault' WHERE BillNo = '" + inHed.getBillNo() + "'";
                    erpSqlServer.update(sql);
                        erpSqlServer.update(sql);
                }
            }
        }