From 2afd0de5d9a8d0a339e26b8084a7d17110a1e84e Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期三, 04 一月 2023 14:32:35 +0800
Subject: [PATCH] #中间表对接：日志文件优化
---
src/main/java/com/zy/ints/task/scheduler/ErpLkScheduler.java | 28 +++++++++++++++++++++-------
1 files changed, 21 insertions(+), 7 deletions(-)
diff --git a/src/main/java/com/zy/ints/task/scheduler/ErpLkScheduler.java b/src/main/java/com/zy/ints/task/scheduler/ErpLkScheduler.java
index e2adc02..1f2fd0f 100644
--- a/src/main/java/com/zy/ints/task/scheduler/ErpLkScheduler.java
+++ b/src/main/java/com/zy/ints/task/scheduler/ErpLkScheduler.java
@@ -1,5 +1,7 @@
package com.zy.ints.task.scheduler;
+import com.zy.asrs.service.ApiLogService;
+import com.zy.ints.entity.ErpDetTb;
import com.zy.ints.entity.ErpLk;
import com.zy.ints.erp.ErpSqlServer;
import lombok.extern.slf4j.Slf4j;
@@ -8,6 +10,7 @@
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;
+import java.util.Date;
import java.util.List;
/**
@@ -22,20 +25,24 @@
*/
@Value("${erp.enabled}")
private Boolean erpEnabled;
+ @Value("${erp.useName.ip}")
+ private String ip;
+ @Autowired
+ private ApiLogService apiLogService;
@Autowired
private ErpSqlServer erpSqlServer;
/**
- * 鑾峰彇鍏ュ嚭搴撹鍗曚俊鎭�
+ * ERP涓巐k搴撳瓨鏁版嵁姣斿
*/
@Scheduled(cron = "${erp.refreshtime}")
- public void InOrOutOrder() {
+ public void proofread() {
if (!erpEnabled) return;
- String sqlSelecterpLk = "select prd_no as prdNo,prd_mark as prdMark,qty,wh,status,temp1,temp2,temp3 from bas_erp_lk where 1=1";
- String sqlUpDateerpLkOne = "update bas_erp_lk set status=1 where prd_no=";
- String sqlUpDateerpLkTwo = "update bas_erp_lk set status=2 where prd_no=";
+ String sqlSelectErpLk = "select prd_no as prdNo,prd_mark as prdMark,qty,wh,status,temp1,temp2,temp3 from bas_erp_lk where 1=1";
+ String sqlUpDateErpLkOne = "update bas_erp_lk set status=1 where prd_no=";
+ String sqlUpDateErpLkTwo = "update bas_erp_lk set status=2 where prd_no=";
try {
- List<ErpLk> erpLks = erpSqlServer.select(sqlSelecterpLk, ErpLk.class);
+ List<ErpLk> erpLks = erpSqlServer.select(sqlSelectErpLk, ErpLk.class);
if (erpLks.size() > 0){
for (ErpLk erpLk:erpLks){
Integer status = erpLk.getStatus();
@@ -51,7 +58,14 @@
}
}
}catch (Exception e){
-
+ Date date = new Date();
+ log.error(date + ": 琛ㄥ悕锛歜as_erp_lk :" + e);
}
}
+
+ public void callApiLogSave(ErpLk erpLk, String tableName, String response, Boolean bool) {
+ apiLogService.save("ERP涓嬪彂璁㈠崟淇℃伅", tableName, "null", ip,
+ "鍝佸彿锛�" + erpLk.getPrdNo() + "銆佽揣鍝佺壒寰侊細" + erpLk.getPrdMark() + "銆佹暟閲忥細" + erpLk.getQty() + "銆佺姸鎬侊細" + erpLk.getStatus(),
+ response, bool);
+ }
}
--
Gitblit v1.9.1