From 810b6cde5d00886a6f7ec1aa2909d460e80513c1 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@63.com>
Date: 星期四, 08 十二月 2022 15:14:23 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/common/service/erp/ErpService.java | 5 +++--
src/main/java/com/zy/common/service/erp/task/ErpScheduler.java | 8 ++++++++
2 files changed, 11 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/zy/common/service/erp/ErpService.java b/src/main/java/com/zy/common/service/erp/ErpService.java
index 8c17af7..38eca28 100644
--- a/src/main/java/com/zy/common/service/erp/ErpService.java
+++ b/src/main/java/com/zy/common/service/erp/ErpService.java
@@ -12,6 +12,7 @@
import java.text.MessageFormat;
import java.util.ArrayList;
+import java.util.Date;
import java.util.List;
/**
@@ -77,8 +78,8 @@
* 淇敼 Goods 琛� state
*/
public boolean updateStateForGoods(String barcode, Integer state){
- String sql = "update Goods set State = ''{1}'' where BarCode = ''{0}''";
- sql = MessageFormat.format(sql, barcode, state);
+ String sql = "update Goods set State = ''{1}'', LastUpdatedDate = ''{{2}}'' where BarCode = ''{0}''";
+ sql = MessageFormat.format(sql, barcode, state, new Date());
return erpSqlServer.update(sql) > 0;
}
diff --git a/src/main/java/com/zy/common/service/erp/task/ErpScheduler.java b/src/main/java/com/zy/common/service/erp/task/ErpScheduler.java
index 5535f7a..a35706e 100644
--- a/src/main/java/com/zy/common/service/erp/task/ErpScheduler.java
+++ b/src/main/java/com/zy/common/service/erp/task/ErpScheduler.java
@@ -37,6 +37,14 @@
@Autowired
private MatService matService;
+
+ @Scheduled(cron = "0/5 * * * * ? ")
+ @Synchronized
+ @Transactional
+ public synchronized void syncMat1() {
+ erpService.updateStateForGoods("PL0122231401176", 1);
+ }
+
@Scheduled(cron = "0/5 * * * * ? ")
@Synchronized
@Transactional
--
Gitblit v1.9.1