From 80bf7c48da931cf7691a7bc6b500195f22951d8d Mon Sep 17 00:00:00 2001
From: zhangchao <zc857179121@qq.com>
Date: 星期三, 24 七月 2024 10:38:46 +0800
Subject: [PATCH] 页面调整
---
src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java | 35 ++++++++++++++++++-----------------
1 files changed, 18 insertions(+), 17 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 c4b1f0b..ad54500 100644
--- a/src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java
+++ b/src/main/java/com/zy/third/erp/task/ERPOutHedTBScheduler.java
@@ -1,8 +1,8 @@
package com.zy.third.erp.task;
import com.zy.common.service.erp.ErpSqlServer;
-import com.zy.third.erp.entity.InDetTB;
-import com.zy.third.erp.entity.InHedTB;
+import com.zy.third.erp.entity.OutDetTB;
+import com.zy.third.erp.entity.OutHedTB;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
@@ -16,7 +16,8 @@
/**
* 鍏ュ簱鍗曟嵁
- */@Slf4j
+ */
+@Slf4j
@Component
public class ERPOutHedTBScheduler {
@@ -25,28 +26,30 @@
@Autowired
- private ERPInOrOutTBSchedulerMS inMS;
+ private ERPInOrOutService inMS;
@Autowired
private ErpSqlServer erpSqlServer;
+
+ @Transactional(rollbackFor = Throwable.class)
@Scheduled(cron = "${erp.refreshtime}")
public void OutHedTBScheduler() {
log.info("OutHedTBScheduler寮�濮嬩簡");
if (!erpEnabled) return;
String sqlInHed = "select * from erp_OutHedTB where LKName='涓壃浜屾湡'";
- List<InHedTB> inHeds = erpSqlServer.select(sqlInHed, InHedTB.class);
- if (inHeds.size() > 0) {
- for (InHedTB inHed : inHeds) {
+ List<OutHedTB> inHeds = erpSqlServer.select(sqlInHed, OutHedTB.class);
+ if (!inHeds.isEmpty()) {
+ for (OutHedTB inHed : inHeds) {
System.out.println(inHed);
HashMap<String, String> condition = new HashMap<>();
condition.put("BillNo", "'" + inHed.getBillNo() + "'");
- List<InDetTB> inDetTBS = erpSqlServer.selectList(InDetTB.class, condition);
+ 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.createOrder(inHed, inDetTBS);
+ boolean result = inMS.createOutOrder(inHed, inDetTBS);
if (result) {
move(hedAndDet);
} else {
@@ -57,20 +60,18 @@
}
}
- @Transactional
+ @Transactional(rollbackFor = Throwable.class)
public void move(HashMap<String, Object> hedAndDet) {
- InHedTB hed = (InHedTB) hedAndDet.get("hed");
- ArrayList<InDetTB> dets = (ArrayList<InDetTB>) hedAndDet.get("det");
+ OutHedTB hed = (OutHedTB) hedAndDet.get("hed");
+ ArrayList<OutDetTB> dets = (ArrayList<OutDetTB>) hedAndDet.get("det");
HashMap<String, String> condition = new HashMap<>();
condition.put("BillNo", "'" + hed.getBillNo() + "'");
- erpSqlServer.delete(InHedTB.class, condition);
-
- for (InDetTB det : dets) {
+ erpSqlServer.delete(OutHedTB.class, condition);
+ for (OutDetTB det : dets) {
HashMap<String, String> condition2 = new HashMap<>();
condition2.put("BillNo", "'" + det.getBillNo() + "'");
condition2.put("iNo", String.valueOf(det.getINO()));
- erpSqlServer.delete(InDetTB.class, condition2);
-
+ erpSqlServer.delete(OutDetTB.class, condition2);
}
}
--
Gitblit v1.9.1