From c2b00f05b70c2c089c1b37f20e10df9c87058a0b Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@63.com>
Date: 星期三, 14 十二月 2022 10:14:18 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/common/service/erp/ErpService.java | 8 ++++++--
1 files changed, 6 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 c4c8d79..e26992c 100644
--- a/src/main/java/com/zy/common/service/erp/ErpService.java
+++ b/src/main/java/com/zy/common/service/erp/ErpService.java
@@ -123,8 +123,12 @@
* 鏂板 VoucherDetail 琛�
*/
public boolean insertVoucherDetail(VoucherDetail voucherDetail){
- String sql = "update VoucherDetail set LastUpdatedDate = ''{1}'' where VoucherID = ''{0}''";
- sql = MessageFormat.format(sql, voucherID, DateUtils.convert(new Date()));
+ String sql = "insert [VoucherDetail] ([VoucherID], [Barcode], [PickID], [LastUpdatedDate]) values (''{0}'', ''{1}'', ''{2}'', ''{3}'');";
+ sql = MessageFormat.format(sql
+ , voucherDetail.getVoucherID()
+ , voucherDetail.getBarcode()
+ , voucherDetail.getPickID()
+ , voucherDetail.getLastUpdatedDate());
return erpSqlServer.update(sql) > 0;
}
--
Gitblit v1.9.1