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 ++++++--
src/main/java/com/zy/asrs/task/handler/OrderSyncHandler.java | 4 ++++
2 files changed, 10 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/zy/asrs/task/handler/OrderSyncHandler.java b/src/main/java/com/zy/asrs/task/handler/OrderSyncHandler.java
index f245ab7..ea0f316 100644
--- a/src/main/java/com/zy/asrs/task/handler/OrderSyncHandler.java
+++ b/src/main/java/com/zy/asrs/task/handler/OrderSyncHandler.java
@@ -1,6 +1,7 @@
package com.zy.asrs.task.handler;
import com.alibaba.fastjson.JSON;
+import com.core.common.DateUtils;
import com.core.exception.CoolException;
import com.zy.asrs.entity.DocType;
import com.zy.asrs.entity.Order;
@@ -20,6 +21,7 @@
import org.springframework.transaction.annotation.Transactional;
import org.springframework.transaction.interceptor.TransactionAspectSupport;
+import java.util.Date;
import java.util.List;
/**
@@ -73,11 +75,13 @@
if (!erpService.updateStateForVoucher(order.getOrderNo(), state)) {
throw new CoolException(order.getOrderNo() + "璁㈠崟淇敼State涓�"+state+"澶辫触");
} else {
+ Date now = new Date();
for (OrderDetl orderDetl : orderDetls) {
VoucherDetail voucherDetail = new VoucherDetail();
voucherDetail.setVoucherID(order.getOrderNo());
voucherDetail.setPickID("fepvnn0496");
voucherDetail.setBarcode(orderDetl.getBatch());
+ voucherDetail.setBarcode(DateUtils.convert(now));
if (!erpService.insertVoucherDetail(voucherDetail)) {
throw new CoolException(order.getOrderNo() + "璁㈠崟娣诲姞VoucherDetail"+ JSON.toJSONString(voucherDetail)+"澶辫触");
}
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