From 2f63acadcd111fe47b2feedf13adb9cffcd64b2c Mon Sep 17 00:00:00 2001 From: pang.jiabao <pang_jiabao@163.com> Date: 星期五, 25 十月 2024 13:28:50 +0800 Subject: [PATCH] mes调用立即出库修改 --- src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java | 17 +++++++++++------ 1 files changed, 11 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 ad54500..fc3f44c 100644 --- a/src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java +++ b/src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java @@ -1,5 +1,6 @@ package com.zy.third.erp.task; +import com.core.common.Cools; import com.zy.common.service.erp.ErpSqlServer; import com.zy.third.erp.entity.OutDetTB; import com.zy.third.erp.entity.OutHedTB; @@ -36,24 +37,28 @@ @Transactional(rollbackFor = Throwable.class) @Scheduled(cron = "${erp.refreshtime}") public void OutHedTBScheduler() { - log.info("OutHedTBScheduler寮�濮嬩簡"); + //log.info("OutHedTBScheduler寮�濮嬩簡"); if (!erpEnabled) return; String sqlInHed = "select * from erp_OutHedTB where LKName='涓壃浜屾湡'"; List<OutHedTB> inHeds = erpSqlServer.select(sqlInHed, OutHedTB.class); if (!inHeds.isEmpty()) { for (OutHedTB inHed : inHeds) { - System.out.println(inHed); + if (!Cools.isEmpty(inHed.getTemp3()) && inHed.getTemp3().equals("fault")) { + //continue; + } HashMap<String, String> condition = new HashMap<>(); condition.put("BillNo", "'" + inHed.getBillNo() + "'"); List<OutDetTB> inDetTBS = erpSqlServer.selectList(OutDetTB.class, condition); HashMap<String, Object> hedAndDet = new HashMap<>(); hedAndDet.put("hed", inHed); hedAndDet.put("det", inDetTBS); - boolean result = inMS.createOutOrder(inHed, inDetTBS); - if (result) { + try { + inMS.createOutOrder(inHed, inDetTBS); + log.info("鍑哄簱鍗曟嵁鎴愬姛,{}", inHed); move(hedAndDet); - } else { - String sql = "UPDATE erp_OutHedTB SET Temp3 = 鈥榝ault鈥� WHERE BillNo = '" + inHed.getBillNo() + "'"; + } catch (Exception e) { + e.printStackTrace(); + String sql = "UPDATE erp_OutHedTB SET Temp3 = 'fault' WHERE BillNo = '" + inHed.getBillNo() + "'"; erpSqlServer.update(sql); } } -- Gitblit v1.9.1