#

wang..123

2022-03-15 75666e8866ad319bddd787ff2cc9aea1d6a80f84

 src/main/java/com/zy/common/service/erp/ErpService.java

@@ -1,5 +1,6 @@
package com.zy.common.service.erp;

import com.baomidou.mybatisplus.MybatisSqlSessionTemplate;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.core.common.Cools;
import com.core.common.DateUtils;
@@ -451,12 +452,25 @@
                    }
                }
                if (complete) {
                    if (!completeCPakOut(FBillNo)) {
                        log.error("{}出库单标记完成失败", FBillNo);
                    sql = "select * from OutStockbillEntry where 1=1 and FInterID = {1,number,#}";
                    sql = MessageFormat.format(sql, Fnumber, FInterID);
                    List<OutStockBillEntry> select1 = erpSqlServer.select(sql, OutStockBillEntry.class);

                    boolean flag = true;
                    for(OutStockBillEntry outStockBillEntry1 : select1){
                        if (outStockBillEntry1.getFAuxCommitQty().compareTo(outStockBillEntry1.getFQty()) == -1) {
                            flag = false;
                        }
                    }
                    int updateCount = jdbcTemplate.update("update OutStockbill set Fflag_finish=1 where FBillNo='" + FBillNo + "'");
                    if(updateCount<=0){
                        throw new CoolException("更新出库通知档完成标记失败[FBillNo="+FBillNo+"]");

                    if(flag){
                        if (!completeCPakOut(FBillNo) ) {
                            log.error("{}出库单标记完成失败", FBillNo);
                        }
                        int updateCount = jdbcTemplate.update("update OutStockbill set Fflag_finish=1 where FBillNo='" + FBillNo + "'");
                        if(updateCount<=0){
                            throw new CoolException("更新出库通知档完成标记失败[FBillNo="+FBillNo+"]");
                        }
                    }
                }
                return true;