优化数据库事务处理及收货单功能

Ben Lin

2025-03-27 a2f8c1434ba06a5231c4f9f8bc9373402f4228f7

优化数据库事务处理及收货单功能

在 `WmsTask.cs` 中，修改了数据库事务的处理逻辑，确保在保存成功后清空提交操作列表，并在事务失败时抛出异常。

在 `Print_BIZ_U9_ASN.cs` 中进行了多处重构，添加了 `SnList` 列表以存储扫描的条码，更新了 `Submit` 方法的逻辑，增强了异常处理机制，并确保在生成收货单时正确处理条码信息。

在 `IWMS_U9C.cs` 中新增了 `CreateReceivement` 方法的接口定义，以支持创建收货单的功能。

 Tiger.Business.WMS/Common/WmsTask.cs

@@ -116,12 +116,9 @@
                        }
                    }
                });
                if (dbTran.IsSuccess)
                {
                    //保存成功则清空提交操作列表
                    DBCommitList.Clear();
                }
                else
                if (!dbTran.IsSuccess)
                {
                    //抛出异常
                    throw dbTran.ErrorException;

 Tiger.Business.WMS/Transaction/Yada/Print_BIZ_U9_ASN.cs

@@ -14,6 +14,12 @@
using System.Security.Policy;
using Tiger.Model.Entitys.MES.Position;
using MailKit.Search;
using IronPython.Runtime.Operations;
using static IronPython.Modules._ast;
using System.Diagnostics;
using Tiger.Model.Minsun;
using static IronPython.Runtime.Profiler;
using static Microsoft.CodeAnalysis.CSharp.SyntaxTokenParser;

namespace Tiger.Business.WMS.Transaction
{
@@ -25,8 +31,6 @@
        public IPrint_BIZ_U9_ASN Init(string id, string userCode, string apiHost, string orgCode)
        {
            base.Init(id, userCode, apiHost, orgCode);
            //加载已经清点数据
            //LoadData();
            Logger.Console.Info($"Start {this.GetType().Name} Transaction[ID: {TransID}]");
            return this;
        }
@@ -36,17 +40,11 @@
        private List<string> OrderList = new();
        private BIZ_U9_ASN order = new();
        private List<BIZ_U9_ASN_SN> CurSn = new();
        List<string> SnList = new();
        private List<BIZ_U9_ASN_SN> ScanList = new();
        #endregion

        #region Functions
        /// <summary>
        /// 初始化清点数据
        /// </summary>
        private void LoadData()
        {
            OrderList = MainDB.Queryable<BIZ_U9_ASN_SN>().Where(q => q.RECEIVER == UserCode && SqlFunc.Subqueryable<BIZ_U9_ASN>().Where(s => s.ORDER_NO == q.ORDER_NO && s.STATUS == BIZ_U9_ASN.STATUSs.Counting.GetValue()).Any()).Select(q => q.ORDER_NO).ToList();
        }
        /// <summary>
        /// 扫描入口
        /// </summary>
@@ -70,15 +68,11 @@
                //如果是随单赠品或者样品
                else if (input.Data == "1")
                {
                    action = await Submit(input);

                }
                else if (input.Data == "Submit")
                {

                }
                else
                {
                    action = await ScanItem(input);
                    action = await Submit(input);
                }
            }
            catch (Exception ex)
@@ -102,7 +96,8 @@
            try
            {
                order = await MainDB.Queryable<BIZ_U9_ASN>().Where(q => q.ORDER_NO == input.SN).Includes(q => q.Details, d => d._ItemInfos).IncludesAllFirstLayer().FirstAsync();
                if (order==null) {
                if (order == null)
                {
                    action.IsSuccessed = false;
                    action.LocaleMsg = Biz.L($"查不到ASN单[{input.SN}]的数据");
                    return action;
@@ -119,345 +114,160 @@
        }

        /// <summary>
        /// 提交数据
        /// 提交数据生成SN并清点
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public async Task<ApiAction<ScanOutput>> Submit(BaseInput input)
        {
            var action = new ApiAction<ScanOutput>($"成功提交ASN单[{input.SN}]行数据，并完成清点，请点击打印按钮打印标签", new ScanOutput());
            var action = new ApiAction<ScanOutput>(new ScanOutput());
            try
            {
                var snlist = input.Options["Snlist"].ToString().JsonToObject<List<string>>();
                List<string> SnList = new();
                var snlist = input.Options["Snlist"].ToString().JsonToObject<List<BIZ_U9_ASN_SN>>();
                var reqType = input.Options["reqType"].ToString();
                var dtl = input.Options["record"].ToString().JsonToObject<BIZ_U9_ASN_DTL>();
                action.LocaleMsg = Biz.L($"成功提交ASN单[{dtl.ORDER_NO}]行数据，并完成清点，请点击打印按钮打印标签");

                if (MainDB.Queryable<BIZ_U9_ASN_SN>().Where(q => q.ORDER_NO == dtl.ORDER_NO && q.LINE_NO == dtl.LINE_NO && (q.STATUS == WMS_ITEM.STATUSs.Counted.GetValue() || q.STATUS == WMS_ITEM.STATUSs.Rejected.GetValue())).Sum(q => q.QTY) == dtl.QTY)
                {
                    action.IsSuccessed = false;
                    action.LocaleMsg = Biz.L($"ASN单[{dtl.ORDER_NO}]行[{dtl.LINE_NO}]数据已全部清点完成，如果未打印标签请点击打印按钮打印标签");
                    return action;
                }
                List<BIZ_U9_ASN_SN> sns = new();
                List<WMS_ITEM> items = new();
                List<WMS_ITEM_HIS> hiss = new();
                List<WMS_ITEM_EXT> itemExts = new();
                List<WMS_ITEM_PKG> pkgs = new();
                foreach (var sn in snlist)
                {
                    SnList.Add(DI.Resolve<ICodeRuleCache>()["InitialBarcode"]?.Generate($"{sn}").Data.ToString() ?? "");
                }
                action.Data.Data = SnList;
            }
            catch (Exception ex)
                    var _sn = DI.Resolve<ICodeRuleCache>()["NoSourceBarcode"]?.Generate($"/NoSourceBarcode/").Data.ToString() ?? "";
                    var metaSn = _sn.replace("/NoSourceBarcode/", sn.SN);
                    SnList.Add(metaSn);
                    var barcode = new Barcode(metaSn);
                    BIZ_U9_ASN_SN info = new()
            {
                //取消当前操作
                ResetScan();
                action.CatchExceptionWithLog(ex, Biz.L("WMS.Default.Scan.ScanException", input.SN));
            }
            return SetOutPutMqttMsg(action, input.Locale);
                        AUTH_ORG = dtl.AUTH_ORG,
                        CREATE_TIME = DateTime.Now,
                        CREATE_USER = UserCode,
                        UPDATE_TIME = DateTime.Now,
                        UPDATE_USER = UserCode,
                        STATUS = WMS_ITEM.STATUSs.Counted.GetValue(),
                        ORDER_NO = dtl.ORDER_NO,
                        LINE_NO = dtl.LINE_NO,
                        SN = barcode.SN,
                        META_SN = metaSn,
                        ITEM_CODE = barcode.ItemCode,
                        QTY = sn.QTY,
                        LOTNO = barcode.LotNo,
                        CARTON_NO = barcode.SN,
                        RECEIVER = UserCode,
                        RECEIVE_DATE = DateTime.Now,
                    };
                    sns.Add(info);
                    var item = new WMS_ITEM()
                    {
                        SN = barcode.SN,
                        ITEM_CODE = barcode.ItemCode,
                        AUTH_ORG = dtl.AUTH_ORG,
                        STATUS = WMS_ITEM.STATUSs.Counted.GetValue(),
                        QTY = sn.QTY,
                        PROD_DATE = barcode.ProdDate ?? BarcodeAnalysis.GetDateTime(dtl.SUPP_LOTNO) ?? DateTime.Now,
                        UNIT = barcode.Unit,
                        TRANS_CODE = nameof(BIZ_U9_ASN),
                        TRANS_NO = info.ORDER_NO,
                        TRANS_LINE = info.LINE_NO,
                        SUPP_CODE = dtl.SUPP_CODE,
                        SUPP_LOTNO = dtl.SUPP_LOTNO,
                    };
                    items.Add(item);
                    hiss.Add(new WMS_ITEM_HIS(item, $"条码[{barcode.SN}]导入，操作单据[{item.TRANS_NO}]"));
                    var ext = new WMS_ITEM_EXT()
                    {
                        SN = barcode.SN,
                        META_SN = metaSn,
                        QR_CODE = metaSn,
                    };
                    itemExts.Add(ext);
                    var pkg = new WMS_ITEM_PKG()
                    {
                        SN = barcode.SN,
                        ITEM_CODE = barcode.ItemCode,
                        AUTH_ORG = dtl.AUTH_ORG,
                        QTY = sn.QTY,
                        UNIT = barcode.Unit,
                        TRANS_CODE = nameof(BIZ_U9_ASN),
                        TRANS_NO = info.ORDER_NO,
                        TRANS_LINE = info.LINE_NO,
                        SUPP_CODE = dtl.SUPP_CODE,
                        SUPP_LOTNO = dtl.SUPP_LOTNO,
                    };
                    pkgs.Add(pkg);
        }

        /// <summary>
        /// 扫描条码分析类型
        /// </summary>
        public async Task<ApiAction<ScanOutput>> ScanItem(BaseInput input)
        {
            var action = new ApiAction<ScanOutput>(new ScanOutput() { Command = Command });
            try
            {
                //解析条码
                Barcode barcode = new Barcode(input.SN);
                if (barcode.IsException)
                {
                    throw barcode.AnalyseException;
                }
                //非法条码
                else if (!barcode.IsRegular)
                {
                    action.IsSuccessed = false;
                    //action.LocaleMsg = Biz.L("条码为非法条码");
                    action.LocaleMsg = Biz.L("WMS.WmsItem.Barcode.IllegalFailure", input.SN);
                    return SetOutPutMqttMsg(action, input.Locale); ;
                }

                if (barcode.Type == Barcode.Types.OuterPackage)
                {
                    CurSn = MainDB.Queryable<BIZ_U9_ASN_SN>().Where(q => q.CARTON_NO == barcode.SN).ToList();
                }
                else
                {
                    CurSn = MainDB.Queryable<BIZ_U9_ASN_SN>().Where(q => q.SN == barcode.SN).ToList();
                    foreach (var sn in CurSn)
                    {
                        sn.META_SN = input.SN;
                    }
                }

                if (CurSn.IsNullOrEmpty())
                {
                    action.IsSuccessed = false;
                    //action.LocaleMsg = Biz.L("ASN单中不存在条码[{0}]");
                    action.LocaleMsg = Biz.L("WMS.Print_BIZ_U9_ASN.SnNotExists", input.SN);
                    return SetOutPutMqttMsg(action, input.Locale); 
                }
                if (CurSn.First().AUTH_ORG != input.AuthOption.CurOrg)
                {
                    action.IsSuccessed = false;
                    //action.LocaleMsg = Biz.L($"条码所属组织[{0}]与当前登录组织[{1}]不一致，请重新选择组织");
                    action.LocaleMsg = Biz.L("WMS.Print_BIZ_U9_ASN.OrgNotCorrect", CurSn.First().AUTH_ORG, input.AuthOption.CurOrg);
                    return SetOutPutMqttMsg(action, input.Locale); ;
                }
                //验证条码是否正确
                if (CurSn.First().STATUS > WMS_ITEM.STATUSs.Incoming.GetValue())
                {
                    action.IsSuccessed = false;
                    //action.LocaleMsg = Biz.L("状态[{0}]异常，请重新扫描");
                    action.LocaleMsg = Biz.L("WMS.Default.ScanItem.StatusException", CurSn.First().STATUS.GetEnumDesc<WMS_ITEM.STATUSs>());
                    return SetOutPutMqttMsg(action, input.Locale); ;
                }

                //执行清点数据处理
                foreach (var sn in CurSn)
                {
                    sn.STATUS = WMS_ITEM.STATUSs.Counted.GetValue();
                    sn.RECEIVER = UserCode;
                    sn.RECEIVE_DATE = DateTime.Now;
                }

                //创建变量克隆对象用于传入DBSubmitAction中保存当前需要暂存的数据值
                var _CurSn = CurSn.Clone();
                AddCommitAction("Counted", () =>
                AddCommitAction("CountedAndPrint", () =>
                {
                    //使用统一的事务DB对象
                    var db = GetCommitDB();
                    //数据保存逻辑
                    db.Updateable<BIZ_U9_ASN>(UserCode).SetColumns(q => q.STATUS == BIZ_U9_ASN.STATUSs.Counting.GetValue()).Where(q => q.ORDER_NO == _CurSn.First().ORDER_NO).ExecuteCommand();
                    db.Storageable(_CurSn, UserCode).ExecuteCommand();
                    db.Updateable<BIZ_U9_ASN>(UserCode).SetColumns(q => q.STATUS == BIZ_U9_ASN.STATUSs.Counting.GetValue()).Where(q => q.ORDER_NO == dtl.ORDER_NO).ExecuteCommand();
                    db.Storageable(sns, UserCode).ExecuteCommand();
                    var s = db.Storageable(items, UserCode).WhereColumns(t => new { t.SN, t.GHOST_ROW }).ToStorage();
                    s.AsInsertable.ExecuteCommand();
                    s.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.ITEM_CODE, q.AUTH_ORG, q.STATUS, q.QTY, q.PROD_DATE, q.UNIT, q.TRANS_CODE, q.TRANS_NO, q.TRANS_LINE, q.SUPP_CODE, q.SUPP_LOTNO, q.UPDATE_TIME, q.UPDATE_USER, }).ExecuteCommand();
                    db.Insertable(hiss, UserCode).ExecuteCommand();
                    var o = db.Storageable(itemExts, UserCode).WhereColumns(t => new { t.SN, t.GHOST_ROW }).ToStorage();
                    o.AsInsertable.ExecuteCommand();
                    o.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.META_SN, q.QR_CODE, q.UPDATE_TIME, q.UPDATE_USER, }).ExecuteCommand();
                    var y = db.Storageable(pkgs, UserCode).WhereColumns(t => new { t.SN, t.GHOST_ROW }).ToStorage();
                    y.AsInsertable.ExecuteCommand();
                    y.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.ITEM_CODE, q.AUTH_ORG, q.QTY, q.UNIT, q.TRANS_CODE, q.TRANS_NO, q.TRANS_LINE, q.SUPP_CODE, q.SUPP_LOTNO, q.UPDATE_TIME, q.UPDATE_USER, }).ExecuteCommand();
                });

                //完成所有处理后使用事务保存数据
                action = DoIfFinish(action, input.Locale, () =>
                //清点完成调用接口生成无来源收货单
                Action generatedAction = () =>
                {
                    if (!OrderList.Contains(CurSn.First().ORDER_NO))
                    ApiAction<List<U9CReturnData2>> result = new ApiAction<List<U9CReturnData2>>();
                    //如果是随单赠品或者样品
                    if (reqType == "1")
                    {
                        OrderList.Add(CurSn.First().ORDER_NO);
                        var iInput = new CreateReceivementInput
                        {
                            userId = UserCode,
                            IsLogin = true,
                            Supplier = "",
                            RcvDocType = "",
                            RcvLines = new()
                            {
                                new(){
                                    ItemInfo = new(){m_itemCode="" },
                                    Wh= new(){ m_code=""},
                                    RcvLineLocations = new(){
                                        new(){
                                            Location = new(){ m_code="" },
                                            LocationQtyTU = 0,
                    }
                    ScanList.AddRange(CurSn);
                });
                                    },
                                    ArriveQtyTU = 0,
                                    ArriveQtyPU = 0,
                                    RcvQtyTU= 0,
                                    RcvQtyPU= 0,
                                    EyeballingQtyTU = 0,
                                    RcvProcedure = 0,
                                    StorageType = 0,
                                    RcvLotCode = "",
                                    InvLotCode  = "",
                                },
            }
            catch (Exception ex)
                        };
                        result = DI.Resolve<IWMS_U9C>().CreateReceivement(iInput).Result;
                        if (!result.IsSuccessed)
            {
                //取消当前操作
                ResetScan();
                //action.CatchExceptionWithLog(ex, $"扫描条码[{0}]复核异常");
                action.CatchExceptionWithLog(ex, Biz.L("WMS.Default.ScanItem.ScanException", input.SN));
            }
            return SetOutPutMqttMsg(action, input.Locale);
        }

        /// <summary>
        /// 完成所有处理后使用事务保存数据
        /// </summary>
        /// <param name="action"></param>
        /// <param name="locale"></param>
        /// <param name="doAfterSave"></param>
        /// <returns></returns>
        public ApiAction<ScanOutput> DoIfFinish(ApiAction<ScanOutput> action, string locale, Action doAfterSave = null)
        {
            //保存数据库
            SaveCommitListToDB();

            //保存数据成功后执行
            doAfterSave?.Invoke();

            // 返回数据
            action.Data.Data = ScanList;

            //action.LocaleMsg = Biz.L($"条码[{0}]清点成功！");
            action.LocaleMsg = Biz.L("WMS.Print_BIZ_U9_ASN.CountSuccess", CurSn.First().SN);

            //重置工序
            ResetScan();
            return SetOutPutMqttMsg(action, locale); ;
        }

        /// <summary>
        /// 删除当前所有已清点记录
        /// </summary>
        /// <returns></returns>
        public async Task<ApiAction> DeleteScannedList()
        {
            var action = new ApiAction();
            try
            {
                foreach (var sn in ScanList)
                {
                    sn.STATUS = WMS_ITEM.STATUSs.Incoming.GetValue();
                    sn.RECEIVER = null;
                    sn.RECEIVE_DATE = DateTime.MinValue;
                }

                //使用统一的事务DB对象
                var db = GetCommitDB();
                var dbTran = db.UseTran(() =>
                {
                    db.Updateable(ScanList, UserCode).UpdateColumns(q => new { q.UPDATE_TIME, q.UPDATE_USER, q.STATUS }).ExecuteCommandAsync();
                    //db.Updateable(items, UserCode).ExecuteCommand();
                    //db.Insertable(historys, UserCode).ExecuteCommand();
                });
                if (dbTran.IsSuccess)
                {
                    ScanList.Clear();
                }
                else
                {
                    Logger.Default.Fatal(dbTran.ErrorException, "Database transaction save exception");
                    //抛出异常
                    throw dbTran.ErrorException;
                            throw new Exception(Biz.T(result.LocaleMsg, input.Locale));
                }
            }
            catch (System.Exception ex)
                    //如果是未上门户
                    else if (reqType == "0")
            {
                //return action.CatchExceptionWithLog(ex, Biz.L("删除当前所有已清点记录异常"));
                return action.CatchExceptionWithLog(ex, Biz.L("WMS.Print_BIZ_U9_ASN.DeleteScanListException"));
            }
            return action;
        }

        /// <summary>
        /// 删除当前用户的已扫单个记录
        /// </summary>
        /// <returns></returns>
        public async Task<ApiAction> DeleteScannedSn(BaseInput input)
        {
            var action = new ApiAction();
            try
            {
                //使用统一的事务DB对象
                var db = GetCommitDB();
                var dbTran = db.UseTran(() =>
                {
                    db.Updateable<BIZ_U9_ASN_SN>(UserCode).SetColumns(q => q.STATUS == WMS_ITEM.STATUSs.Incoming.GetValue())
                        .SetColumns(q => q.RECEIVER == null)
                        .SetColumns(q => q.RECEIVE_DATE == DateTime.MinValue)
                        .Where(q => q.SN == input.SN).ExecuteCommand();
                    //db.Updateable(item, UserCode).ExecuteCommand();
                    //db.Insertable(new WMS_ITEM_HIS(item, $"条码[{item.SN}]取消清点，操作单据[{order}]"), UserCode).ExecuteCommand();
                });
                if (dbTran.IsSuccess)
                {
                    ScanList.RemoveAll(q => q.SN == input.SN);
                }
                else
                {
                    Logger.Default.Fatal(dbTran.ErrorException, "Database transaction save exception");
                    //抛出异常
                    throw dbTran.ErrorException;
                }
            }
            catch (System.Exception ex)
            {
                //return action.CatchExceptionWithLog(ex, Biz.L("删除已清点条码[{0}]异常"));
                return action.CatchExceptionWithLog(ex, Biz.L("WMS.Print_BIZ_U9_ASN.DeleteScannedSnException", input.SN));
            }
            return action;
        }

        /// <summary>
        ///  获取本次已清点的物料列表（带分页）
        /// </summary>
        /// <returns></returns>
        public async Task<ApiAction<PageAble<BIZ_U9_ASN_SN>>> GetScannedList(BaseInputWithPage input)
        {
            var action = new ApiAction<PageAble<BIZ_U9_ASN_SN>>();
            action.Data = new PageAble<BIZ_U9_ASN_SN>();
            action.Data.pageSize = input.pageSize;
            action.Data.pageIndex = input.pageIndex;
            action.Data.totals = ScanList.Count;
            action.Data.data = ScanList.Skip((input.pageIndex - 1) * input.pageSize).Take(input.pageSize).ToList();
            //action.Data = query;
            return action;
        }

        /// <summary>
        ///  获取当前所有单据信息
        /// </summary>
        /// <returns></returns>
        public async Task<ApiAction<List<BIZ_U9_ASN>>> GetOrderList()
        {
            var action = new ApiAction<List<BIZ_U9_ASN>>();
            action.Data = await Biz.Db.Queryable<BIZ_U9_ASN>().Where(q => OrderList.Contains(q.ORDER_NO)).IncludesAllFirstLayer().ToListAsync();
            if (!action.Data.IsNullOrEmpty())
            {
                foreach (var order in action.Data)
                {
                    foreach (var dtl in order.Details)
                    {
                        dtl.SnList = order.SnList.Where(q => q.LINE_NO == dtl.LINE_NO).OrderByDescending(q => q.STATUS).ToList();
                        dtl.QTY_COUNTED = dtl.SnList.Where(q => q.STATUS == WMS_ITEM.STATUSs.Counted.GetValue() || q.STATUS == WMS_ITEM.STATUSs.Rejected.GetValue()).Sum(q => q.QTY);
                    }
                    order.IsFinished = !order.Details.Where(q => q.QTY != q.QTY_COUNTED).Any();
                }
            }
            return action;
        }

        /// <summary>
        ///  生成收货单：调用U9新增收货单接口
        /// </summary>
        /// <returns></returns>
        public async Task<ApiAction> SetGiftQty(BaseInput input)
        {
            var action = new ApiAction();
            try
            {
                var dtl = input?.Data?.JsonToObject<BIZ_U9_ASN_DTL>();
                if ((dtl?.ID ?? "").IsNullOrEmpty())
                {
                    action.IsSuccessed = false;
                    //action.LocaleMsg = Biz.L($"提交的收货单明细ID不能为空");
                    action.LocaleMsg = Biz.L("WMS.Print_BIZ_U9_ASN.SetGiftQty.DetailIDIsNull");
                    return action;
                }

                //使用统一的事务DB对象
                var db = GetCommitDB();
                await db.Updateable(dtl, UserCode).UpdateColumns(q => new { q.UPDATE_TIME, q.UPDATE_USER, q.QTY_GIFT }).ExecuteCommandAsync();
            }
            catch (System.Exception ex)
            {
                //return action.CatchExceptionWithLog(ex, Biz.L("设置收货单明细赠品数量为异常"));
                return action.CatchExceptionWithLog(ex, Biz.L("WMS.Print_BIZ_U9_ASN.SetGiftQtyException"));
            }
            return action;
        }

        /// <summary>
        /// 生成收货单：调用U9新增收货单接口
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public async Task<ApiAction> GenerateReceipt(BaseInput input)
        {
            var action = new ApiAction();
            var orderNo = input.Data;
            try
            {
                var order = await MainDB.Queryable<BIZ_U9_ASN>().Where(q => q.ORDER_NO == orderNo).IncludesAllFirstLayer().FirstAsync();
                if (order.IsNullOrEmpty())
                {
                    action.IsSuccessed = false;
                    //action.LocaleMsg = Biz.L($"找不到送货单[{0}]的单据信息，请提交正确的单号");
                    action.LocaleMsg = Biz.L("WMS.Print_BIZ_U9_ASN.GenerateReceipt.ASNNotExists", orderNo);
                    return action;
                }
                //验证条码是否正确
                if (order.STATUS != BIZ_U9_ASN.STATUSs.Counting.GetValue())
                {
                    action.IsSuccessed = false;
                    //action.LocaleMsg = Biz.L("生成收货单：送货单状态[{0}]异常");
                    action.LocaleMsg = Biz.L("WMS.Print_BIZ_U9_ASN.GenerateReceipt.StatusException", order.STATUS.GetEnumDesc<BIZ_U9_ASN.STATUSs>());
                    return action;
                }

                //查询是否清点完成
                var noFinish = order.Details.Where(q => q.QTY != order.SnList.Where(s => s.LINE_NO == q.LINE_NO && (s.STATUS == WMS_ITEM.STATUSs.Counted.GetValue() || q.STATUS == WMS_ITEM.STATUSs.Rejected.GetValue())).Sum(s => s.QTY));
                if (noFinish.Any())
                {
                    action.IsSuccessed = false;
                    //action.LocaleMsg = Biz.L("送货单[{0}]未清点完成，请先清点完成，未完成清点的行号如下：{1}");
                    action.LocaleMsg = Biz.L("WMS.Print_BIZ_U9_ASN.GenerateReceipt.NoFinishCounting", orderNo, string.Join("，", noFinish.Select(q => q.LINE_NO)));
                    return action;
                }

                var iInput = new CreateRcvBySrcASNInput
                {
                    userId = UserCode,
@@ -467,12 +277,11 @@
                        aSNToRcvTransDTOs = order.Details.Select(q => new ASNToRcvTransDTO { ASNLineKey = q.ID, TransQty = new() { m_amount1 = q.QTY } }).ToList(),
                    }
                };
                var result = await DI.Resolve<IWMS_U9C>().CreateRcvBySrcASN(iInput);
                        result = DI.Resolve<IWMS_U9C>().CreateRcvBySrcASN(iInput).Result;
                if (!result.IsSuccessed)
                {
                    action.IsSuccessed = false;
                    action.LocaleMsg = result.LocaleMsg;
                    return action;
                            throw new Exception(Biz.T(result.LocaleMsg, input.Locale));
                        }
                }

                //根据接口返回收货单单号查询单据明细，并创建条码明细
@@ -599,13 +408,44 @@
                    //抛出异常
                    throw dbTran.ErrorException;
                }
                };

                //完成所有处理后使用事务保存数据
                action = DoIfFinish(action, input.Locale, generatedAction);
            }
            catch (System.Exception ex)
            catch (Exception ex)
            {
                //return action.CatchExceptionWithLog(ex, Biz.L("送货单[{0}]生成收货单异常"));
                return action.CatchExceptionWithLog(ex, Biz.L("WMS.Print_BIZ_U9_ASN.GenerateReceiptException", orderNo));
                //取消当前操作
                ResetScan();
                action.CatchExceptionWithLog(ex, Biz.L("WMS.Default.Scan.ScanException", input.SN));
            }
            return action;
            return SetOutPutMqttMsg(action, input.Locale);
        }

        /// <summary>
        /// 完成所有处理后使用事务保存数据
        /// </summary>
        /// <param name="action"></param>
        /// <param name="locale"></param>
        /// <param name="doAfterSave"></param>
        /// <returns></returns>
        public ApiAction<ScanOutput> DoIfFinish(ApiAction<ScanOutput> action, string locale, Action doAfterSave = null)
        {
            //保存数据库
            SaveCommitListToDB();

            //保存数据成功后执行
            doAfterSave?.Invoke();

            // 返回数据
            action.Data.Data = SnList;

            //action.LocaleMsg = Biz.L($"条码[{0}]清点成功！");
            action.LocaleMsg = Biz.L("WMS.Print_BIZ_U9_ASN.CountSuccess", string.Join(",", SnList));

            //重置工序
            ResetScan();
            return SetOutPutMqttMsg(action, locale); ;
        }

        #endregion

 Tiger.IBusiness.WMS/iERP/IWMS_U9C.cs

@@ -13,6 +13,7 @@
    public interface IWMS_U9C
    {
        public Task<ApiAction<List<U9CReturnData2>>> CreateRcvBySrcASN(CreateRcvBySrcASNInput input);
        public Task<ApiAction<List<U9CReturnData2>>> CreateReceivement(CreateReceivementInput input);
        public Task<ApiAction<List<U9CReturnData2>>> ReceivementApproveLine(SubmitLineInput input);
        public Task<ApiAction<List<U9CReturnData>>> CreateProdMaterialReq(CreateProdMaterialReqInput input);
        public Task<ApiAction<List<U9CReturnData>>> CreateProdReturnOrder(CreateProdReturnOrderInput input);