#

luxiaotao1123

2022-12-14 c2b00f05b70c2c089c1b37f20e10df9c87058a0b

#

 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)+"失败");
                        }

 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;
    }