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 +++--
1 files changed, 3 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;
}
--
Gitblit v1.9.1