From e7d8e2c64facfa261e8b168b84e81ef6c835f57d Mon Sep 17 00:00:00 2001
From: pang.jiabao <pang_jiabao@163.com>
Date: 星期三, 03 九月 2025 09:25:19 +0800
Subject: [PATCH] 许可证到期提醒，系统30分钟无操作下线账号
---
src/main/java/com/zy/third/erp/task/ERPInHedTBScheduler.java | 21 ++++++++++++---------
1 files changed, 12 insertions(+), 9 deletions(-)
diff --git a/src/main/java/com/zy/third/erp/task/ERPInHedTBScheduler.java b/src/main/java/com/zy/third/erp/task/ERPInHedTBScheduler.java
index 28a8308..08ea63c 100644
--- a/src/main/java/com/zy/third/erp/task/ERPInHedTBScheduler.java
+++ b/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,16 +53,19 @@
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);
}
- log.info("鍏ュ簱鍗曟嵁鎴愬姛,{}", inHed);
- move(hedAndDet);
-
}
}
}
@@ -74,7 +78,6 @@
HashMap<String, String> condition = new HashMap<>();
condition.put("BillNo", "'" + hed.getBillNo() + "'");
erpSqlServer.delete(InHedTB.class, condition);
-
for (InDetTB det : dets) {
HashMap<String, String> condition2 = new HashMap<>();
condition2.put("BillNo", "'" + det.getBillNo() + "'");
--
Gitblit v1.9.1