From 557cda61a3c85a620335d28b9c0e1f0d482cd41e Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@63.com>
Date: 星期四, 08 十二月 2022 15:58:39 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/common/service/erp/ErpService.java | 23 +++++++++++++++++++++--
1 files changed, 21 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..4f03054 100644
--- a/src/main/java/com/zy/common/service/erp/ErpService.java
+++ b/src/main/java/com/zy/common/service/erp/ErpService.java
@@ -1,6 +1,7 @@
package com.zy.common.service.erp;
import com.core.common.Cools;
+import com.core.common.DateUtils;
import com.zy.common.service.erp.dto.VoucherDto;
import com.zy.common.service.erp.entity.Goods;
import com.zy.common.service.erp.entity.Voucher;
@@ -12,6 +13,7 @@
import java.text.MessageFormat;
import java.util.ArrayList;
+import java.util.Date;
import java.util.List;
/**
@@ -77,10 +79,27 @@
* 淇敼 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, DateUtils.convert(new Date()));
return erpSqlServer.update(sql) > 0;
}
+ /**
+ * 淇敼 Voucher 琛� state
+ */
+ public boolean updateStateForVoucher(String voucherID, Integer state){
+ String sql = "update Voucher set State = ''{1}'', LastUpdatedDate = ''{2}'' where VoucherID = ''{0}''";
+ sql = MessageFormat.format(sql, voucherID, state, DateUtils.convert(new Date()));
+ return erpSqlServer.update(sql) > 0;
+ }
+
+ /**
+ * 淇敼 VoucherDetail 琛�
+ */
+ public boolean updateTimeForVoucherDetail(String voucherID){
+ String sql = "update VoucherDetail set LastUpdatedDate = ''{1}'' where VoucherID = ''{0}''";
+ sql = MessageFormat.format(sql, voucherID, DateUtils.convert(new Date()));
+ return erpSqlServer.update(sql) > 0;
+ }
}
--
Gitblit v1.9.1