服务端的TigerApi 框架，基于.NET6 2024 版本
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
Rodney Chen
2025-02-22 fb726bc28268c7efb73629f6ae12b25232a18538 
 Tiger.Business.MES/Transaction/YadaPacking.cs


@@ -13,6 +13,7 @@


using Tiger.Business.MES.WorkAction;


using Tiger.Model.MES.Yada;


using System.Data;


using System.Diagnostics;




namespace Tiger.Business.MES.Transaction


{


@@ -24,6 +25,7 @@


        public new IYadaPacking Init(string id, string apiHost, string userCode, string postCode)


        {


            base.Init(id, apiHost, userCode, postCode);


            U9CDB = Biz.DataSource["YadaU9C"].Client;


            Logger.Console.Info($"User[{userCode}] start a {this.GetType().Name}[{postCode}] Transaction[ID: {TransID}]");


            return this;


        }


@@ -39,6 +41,10 @@


        public PackingAction TempPkgAction { get; set; }


        public bool IsPrintCustomerLabel { get; set; }


        public string ShippingOrder { get; set; }


        public DbClient U9CDB { get; set; }


        public Model.TraceDebug debug { get; set; }


        public DateTime curtime = DateTime.Now;


        public DateTime prevtime = DateTime.Now;


        #endregion Propertys & Variables




        #region Functions


@@ -49,6 +55,8 @@


        /// <returns></returns>


        public async Task<ApiAction<SubmitOutput>> Submit(SubmitInput input)


        {


            debug = new(new StackFrame(true));


            debug.Log(new StackFrame(true), "***** 1", info => { ConsoleExt.WriteLine(info.ToString()); });


            var action = new ApiAction<SubmitOutput>(new SubmitOutput());


            try


            {


@@ -60,13 +68,13 @@


                //    action.IsSuccessed = false;


                //    action.LocaleMsg = new($"包装数量[{input.Qty}]不正确，请重新输入数量后继续包装操作");


                //    //action.LocaleMsg = new("MES.Transaction.PackingNode.Submit.QtyError", input.Qty);


                //    return action;


                //    return SetOutPutMqttMsg(action, input.Locale);


                //}


                if (input.Options.ContainsKey("IsPrintCustomerLabel"))


                {


                    IsPrintCustomerLabel = input.Options["IsPrintCustomerLabel"].ToBoolean();


                }


          


                //if (input.Options.ContainsKey("IsPrintCustomerLabel"))


                //{


                //    IsPrintCustomerLabel = input.Options["IsPrintCustomerLabel"].ToBoolean();


                //}




                //if (input.Options.ContainsKey("ShippingOrder"))


                //{


                //    ShippingOrder = IsPrintCustomerLabel ? input.Options["ShippingOrder"].ToString() : "";


@@ -87,17 +95,17 @@


                {


                    //工步列表为空或者工序节点工步有未完成时，优先完成工序节点工步


                    if (Steps.IsNullOrEmpty() || !IsFinishNodeSteps)


                    {   


                        var wosns = Biz.Db.Queryable<BIZ_MES_WO_BATCH, BIZ_MES_WO_SN>((q, s) => new JoinQueryInfos(JoinType.Inner, q.ORDER_NO == s.WORK_ORDER && q.BATCH_NO == s.BATCH_NO))


                    {


                        var wosns = MainDB.Queryable<BIZ_MES_WO_BATCH, BIZ_MES_WO_SN>((q, s) => new JoinQueryInfos(JoinType.Inner, q.ORDER_NO == s.WORK_ORDER && q.BATCH_NO == s.BATCH_NO))


                                                .ByAuth(input.AuthOption)//.Where((q, s) => s.STATUS < BIZ_MES_WO_SN.STATUSs.Finished.GetValue())


                                                .Where((q, s) => s.SN == input.SN || s.FLOW_SN == input.SN || s.TRAY_SN == input.SN).Select((q, s) => new { Batch = q, SN = s }).ToList();




                        debug.Log(new StackFrame(true), "***** 2", info => { ConsoleExt.WriteLine(info.ToString()); });


                        //先判断当前工单不为空且当前岗位在当前工单是不是首站，如果是则不允许变更当前工单，尝试把条码绑定到当前工单


                        if (!CurBatch.IsNullOrEmpty() && CurBatch.IsFirstNode(PostCode))


                        {


                            //更新CurBatch


                            CurBatch?.Update();




                            debug.Log(new StackFrame(true), "***** 3", info => { ConsoleExt.WriteLine(info.ToString()); });


                            var wosn = wosns.FirstOrDefault(q => q.Batch.ORDER_NO == CurBatch.WO.ORDER_NO && (q.SN.STATUS == BIZ_MES_WO_SN.STATUSs.Finished.GetValue() || q.SN.STATUS == BIZ_MES_WO_SN.STATUSs.Scrap.GetValue()));


                            if (!wosn.IsNullOrEmpty())


                            {


@@ -111,6 +119,7 @@


                            {


                                //提交数据


                                action = NodeSubmit(action, input);


                                debug.Log(new StackFrame(true), "***** 4", info => { ConsoleExt.WriteLine(info.ToString()); });


                                //更新工序信息


                                if (!action.IsSuccessed)


                                {


@@ -138,7 +147,7 @@


                                    action.IsSuccessed = false;


                                    //action.LocaleMsg = new($"条码[{0}]是载具条码，请扫描载具中的产品条码继续包装操作");


                                    action.LocaleMsg = new("MES.Transaction.PackingNode.Submit.OnlyMinPackage", input.SN);


                                    return action;


                                    return SetOutPutMqttMsg(action, input.Locale);


                                }


                                var curPkg = Context.ContainsKey("CurPackage") ? Context["CurPackage"] as WipPkg : null;


                                if (!curPkg.IsNullOrEmpty() && !curPkg.IsFinished && curPkg.WorkBatch != curSNs.First().Batch.BATCH_NO)


@@ -148,7 +157,7 @@


                                    action.IsSuccessed = false;


                                    //action.LocaleMsg = new($"正在包装工单批次[{0}]的产品，请先完成当前包装后再扫描其他批次[{1}]的产品[{2}]");


                                    action.LocaleMsg = new("MES.Transaction.PackingNode.Submit.BatchError", curPkg.WorkBatch, curSNs.First().Batch.BATCH_NO, input.SN);


                                    return action;


                                    return SetOutPutMqttMsg(action, input.Locale);


                                }


                                if (curSNs.First().Batch.ACT_LINE != CurLine.LINE_CODE)


                                {


@@ -170,7 +179,7 @@


                                            action.Data.OperInfo = new();


                                            action.IsSuccessed = result.IsSuccessed;


                                            action.LocaleMsg = result.LocaleMsg;


                                            return action;


                                            return SetOutPutMqttMsg(action, input.Locale);


                                        }


                                    }


                                    //更新CurBatch


@@ -231,20 +240,23 @@


                    {


                        //更新CurBatch


                        CurBatch?.Update();




                        debug.Log(new StackFrame(true), "***** 5", info => { ConsoleExt.WriteLine(info.ToString()); });


                        var submitStep = Steps.Where(q => q.ID == input.CurStepID && !q.IsFinished).FirstOrDefault();


                        //如果客户端返回的当前工步ID找不到未完成的行为工步，则直接开始下一个行为工步


                        if (submitStep.IsNullOrEmpty())


                        {


                            action = BeginNextActionStep(input);


                            debug.Log(new StackFrame(true), "***** 6", info => { ConsoleExt.WriteLine(info.ToString()); });


                        }


                        else


                        {


                            action = submitStep.Submit(input);


                            debug.Log(new StackFrame(true), "***** 7", info => { ConsoleExt.WriteLine(info.ToString()); });


                            //如果当前工步已完成，开始执行下一工步


                            if (action.IsSuccessed && submitStep.IsFinished)


                            {


                                action = BeginNextActionStep(input);


                                debug.Log(new StackFrame(true), "***** 8", info => { ConsoleExt.WriteLine(info.ToString()); });


                            }


                            //如果当前工步未完成


                            else


@@ -286,10 +298,14 @@


            {


                action.Data.ShortMsg = new("工序异常", ShortMessage.Types.Error);


                action.Data.OperInfo = CurOperInfo(input.Locale);


                RemoveCurSnFromCurPackage(Context.ContainsKey("CurPackage") ? (Context["CurPackage"] as WipPkg).Item : null);


                ResetNode();


                //action.CatchExceptionWithLog(ex, $"包装工序：提交操作数据异常");


                action.CatchExceptionWithLog(ex, Biz.L("MES.Transaction.PackingNode.SubmitException"));




            }


            return action;


            debug.Log(new StackFrame(true), "***** 9", info => { ConsoleExt.WriteLine(info.ToString()); });


            return SetOutPutMqttMsg(action, input.Locale);


        }




        /// <summary>


@@ -300,6 +316,7 @@


        /// <returns></returns>


        public ApiAction<SubmitOutput> NodeSubmit(ApiAction<SubmitOutput> action, SubmitInput input)


        {


            debug.Log(new StackFrame(true), "***** 10", info => { ConsoleExt.WriteLine(info.ToString()); });


            var curNode = CurBatch.GetNode(PostCode);


            try


            {


@@ -326,7 +343,7 @@


                        return woStatus;


                    }




                    var wipSNs = Biz.Db.Queryable<MES_WIP_DATA>().IncludesAllFirstLayer().Where(q => q.SN == input.SN || q.FLOW_SN == input.SN || q.TRAY_SN == input.SN).Where(q => q.FINISHED_FLAG != "Y").ToList();


                    var wipSNs = MainDB.Queryable<MES_WIP_DATA>().IncludesAllFirstLayer().Where(q => q.SN == input.SN || q.FLOW_SN == input.SN || q.TRAY_SN == input.SN).Where(q => q.FINISHED_FLAG != "Y").ToList();


                    if (wipSNs.IsNullOrEmpty())


                    {


                        var wipSN = new MES_WIP_DATA()


@@ -383,22 +400,44 @@




                    //设置当前指令为正常产品过站


                    NodeCmd = "NodeSubmit";


                    debug.Log(new StackFrame(true), "***** 11", info => { ConsoleExt.WriteLine(info.ToString()); });




                    //获取出货状态


                    DbClient db = Biz.DataSource["YadaU9C"].Client;


                    var ship = db.Queryable<mes_ShipList>().Where(q => q.MoDoc == CurBatch.WO.ORDER_NO && q.Status == 2 && SqlFunc.DateIsSame(q.BusinessDate, DateTime.Now)).First();


                    if (ship.IsNullOrEmpty()) { IsPrintCustomerLabel = false; } else


                    //var ship = U9CDB.Queryable<mes_ShipList>().Where(q => q.MoDoc == CurBatch.WO.ORDER_NO && q.Status == 2 && SqlFunc.DateIsSame(q.BusinessDate, DateTime.Now)).First();


                    var ships = U9CDB.Queryable<mes_ShipList>().Where(q => q.MoDoc == CurBatch.WO.ORDER_NO).ToList();


                    var shippingOrders = ships.Where(q=> q.Status != 2).Select(x=>x.ShipDoc).ToList();


                    var oldShipment = ships.Any(q => q.Status != 2) ? ships.Where(x => x.Status != 2).Sum(t => t.ShipQty) : 0;


                    var ship = ships.Where(q => q.Status == 2 && q.BusinessDate.Date == DateTime.Now.Date).FirstOrDefault();


                    decimal CurShipQty = 0;


                    int WaitShipmentCarton = 0;


                    int WaitShipment = 0;


                    int oWaitShipmentCarton = 0;


                    if (ship.IsNullOrEmpty()) { IsPrintCustomerLabel = false; }


                    else


                    {


                        SugarParameter[] pars = Biz.Db.Ado.GetParameters(new { BATCH = CurBatch.Batch.BATCH_NO, NodeIdOrName = curNode.NODE_NAME });


                        var list = Biz.Db.Ado.UseStoredProcedure().GetDataTable("SP_MES_GET_NODE_BATCH_COUNT", pars).AsEnumerable().ToList();


                        CurShipQty = ship.ShipQty;


                        IsPrintCustomerLabel = true;


                        SugarParameter[] pars = MainDB.Ado.GetParameters(new { BATCH = CurBatch.Batch.BATCH_NO, NodeIdOrName = curNode.NODE_NAME });


                        var list = MainDB.Ado.UseStoredProcedure().GetDataTable("SP_MES_GET_NODE_BATCH_COUNT", pars).AsEnumerable().ToList();


                        if (!list.IsNullOrEmpty())


                        {


                            var sublist = list.Where(q=> shippingOrders.Contains(q["SHIPPING_ORDER"]) && q["ProdDate"].ToString() != "Whole").ToList();


                            oWaitShipmentCarton = sublist.IsNullOrEmpty() ? 0 : sublist.Sum(q => q["WaitShipmentCarton"].ToInt32());


                            var batchCount = list.Where(q => q["ProdDate"].ToString() == "Whole").FirstOrDefault();


                            IsPrintCustomerLabel = batchCount.IsNullOrEmpty() ? false : batchCount["WaitShipment"].ToInt32() >= ship.ShipQty ? false : true;


                            WaitShipmentCarton = batchCount["WaitShipmentCarton"].ToInt32()- oWaitShipmentCarton;


                            WaitShipment = batchCount["WaitShipment"].ToInt32();


                            IsPrintCustomerLabel = batchCount.IsNullOrEmpty() ? IsPrintCustomerLabel : batchCount["WaitShipment"].ToInt32() - oldShipment >= ship.ShipQty ? false : true;


                        }


                    }


                    ShippingOrder = IsPrintCustomerLabel ? ship?.ShipDoc ?? "" : "";


                    //缓存出货数量


                    Context.SetOrAdd("CuroldShipment", oldShipment);


                    Context.SetOrAdd("CurShipQty", CurShipQty);


                    //缓存出货箱数


                    Context.SetOrAdd("CurWaitShipmentCarton", WaitShipmentCarton);


                    Context.SetOrAdd("CurWaitShipment", WaitShipment);




                    debug.Log(new StackFrame(true), "***** 12", info => { ConsoleExt.WriteLine(info.ToString()); });


                    //绑定条码到工单


                    foreach (var wipSN in wipSNs)


                    {


@@ -441,6 +480,7 @@


                        wipSN.OPER_CODE = curNode.OPER_CODE;


                        wipSN.SEGMENT = curNode.SEGMENT;


                        wipSN.OPERATION_TIME = DateTime.Now;


                        wipSN.OPERATION_END = DateTime.Now;


                        wipSN.SHIPPING_ORDER = ShippingOrder;


                        wipSN.UNBIND_FLAG = "N";


                        var curShiftPeriod = GetShiftPeriodForNow();


@@ -542,6 +582,7 @@


                    var _curNodeSetting = curNodeSetting.Clone();


                    var _Batch = CurBatch.Batch.Clone();




                    debug.Log(new StackFrame(true), "***** 13", info => { ConsoleExt.WriteLine(info.ToString()); });


                    //初始化工步列表


                    Steps.Clear();


                    var curStep = new WorkStep(IWorkStep.NodeTypes.Node, this)


@@ -661,10 +702,12 @@


            catch (Exception ex)


            {


                action.Data.ShortMsg = new("工步异常", ShortMessage.Types.Error);


                RemoveCurSnFromCurPackage(Context.ContainsKey("CurPackage") ? (Context["CurPackage"] as WipPkg).Item : null);


                ResetNode();


                //action.CatchExceptionWithLog(ex, $"{curNode.NODE_NAME}：工序节点工步提交数据异常，请检查工序节点设置");


                action.CatchExceptionWithLog(ex, Biz.L("MES.Transaction.PackingNode.NodeSubmitException", curNode.NODE_NAME));


            }


            debug.Log(new StackFrame(true), "***** 13.1", info => { ConsoleExt.WriteLine(info.ToString()); });


            return action;


        }




@@ -678,6 +721,7 @@


            var curPkg = Context.ContainsKey("CurPackage") ? Context["CurPackage"] as WipPkg : null;


            var operInfo = SetOperNodeInfo(CurOperInfo(locale));


            Action endAction = null;


            debug.Log(new StackFrame(true), "***** 14", info => { ConsoleExt.WriteLine(info.ToString()); });




            //如果当前条码已经走到流程终点则记录条码完工


            if (operInfo.IsReachedEndNode)


@@ -703,6 +747,7 @@


                    wipSN.OPER_CODE = curNode.OPER_CODE;


                    wipSN.SEGMENT = curNode.SEGMENT;


                    wipSN.OPERATION_TIME = DateTime.Now;


                    wipSN.OPERATION_END = DateTime.Now;


                }




                var wipHiss = new List<MES_WIP_HIS>();


@@ -726,7 +771,7 @@


                    var db = GetCommitDB();


                    //数据保存逻辑


                    db.Updateable(_woSns, UserCode).UpdateColumns(q => new { q.UPDATE_TIME, q.UPDATE_USER, q.STATUS }).ExecuteCommand();


                    db.Updateable(_wipSns, UserCode).UpdateColumns(q => new { q.UPDATE_TIME, q.UPDATE_USER, q.STATUS, q.NODE_ID, q.NODE_NAME, q.OPER_CODE, q.SEGMENT, q.OPERATION_TIME }).ExecuteCommand();


                    db.Updateable(_wipSns, UserCode).UpdateColumns(q => new { q.UPDATE_TIME, q.UPDATE_USER, q.STATUS, q.NODE_ID, q.NODE_NAME, q.OPER_CODE, q.SEGMENT, q.OPERATION_TIME, q.OPERATION_END }).ExecuteCommand();


                    db.Storageable(_wipHiss, UserCode).ExecuteCommand();


                    if (_pkgList.Any())


                    {


@@ -742,7 +787,7 @@


                    }


                };


            }




            //throw new Exception("哈");


            //保存数据库


            SaveStepsCommitActionToDB(endAction);




@@ -762,7 +807,7 @@




            //重置工序


            ResetNode();




            debug.Log(new StackFrame(true), "***** 15", info => { ConsoleExt.WriteLine(info.ToString()); });


            return action;


        }




@@ -862,7 +907,7 @@


                            action.IsSuccessed = false;


                            //action.LocaleMsg = new($"出货数量设定为[{0}]，目前包装了[{1}]，包装尾数的数量必需是[{2}]，请装够数量后再结束包装");


                            action.LocaleMsg = new("MES.Transaction.PackingNode.NotMatchShipQty", shipQty, curQty, shipQty % ruleQty);


                            return action;


                            return SetOutPutMqttMsg(action);


                        }




                        NodeCmd = "PkgSubmit";


@@ -895,7 +940,7 @@


                action.CatchExceptionWithLog(ex, $"包装工序：手动结束包装异常");


                NodeCmd = null;


            }


            return action;


            return SetOutPutMqttMsg(action);


        }




        /// <summary>


@@ -909,9 +954,9 @@


            try


            {


                var CurPkg = Context.ContainsKey("CurPackage") ? Context["CurPackage"] as WipPkg : null;


                var LabelPV = Biz.Db.Queryable<BAS_LABEL_PV>().ToList();


                var label = CurPkg.Item.LABEL_CODE.IsNullOrEmpty() ? null : Biz.Db.Queryable<BAS_LABEL_TEMP>().Where(q => q.LABEL_CODE == CurPkg.Item.LABEL_CODE).IncludesAllFirstLayer().First();


                var printLb =  SetLabelVariables(LabelPV, label, new PackingAction(), CurPkg);


                var LabelPV = MainDB.Queryable<BAS_PROCESS_VAR>().ToList();


                var label = CurPkg.Item.LABEL_CODE.IsNullOrEmpty() ? null : MainDB.Queryable<BAS_LABEL_TEMP>().Where(q => q.LABEL_CODE == CurPkg.Item.LABEL_CODE).IncludesAllFirstLayer().First();


                var printLb = SetLabelVariables(LabelPV, label, new PackingAction(), CurPkg);


                action.Data = new PackingActionOutput()


                {


                    ExecCode = "PrintTest",


@@ -926,6 +971,29 @@


            return action;


        }




        /// <summary>


        /// 获取是否打印客户标签还是入库标签


        /// </summary>


        /// <returns></returns>


        public async Task<ApiAction<ShipingInfo>> GetIsCustomerLabelAndShipQty()


        {


            var action = new ApiAction<ShipingInfo>();


            try


            {


                action.Data = new ShipingInfo()


                {


                    IsPrintCustomerLabel = IsPrintCustomerLabel,


                    OldShipQty = Context.GetOrDefault("CuroldShipment").ToInt32(),


                    ShipQty = Context.GetOrDefault("CurWaitShipment").ToInt32() - Context.GetOrDefault("CuroldShipment").ToInt32() >= Context.GetOrDefault("CurShipQty").ToInt32() ? CurBatch.Batch.PLAN_QTY - Context.GetOrDefault("CuroldShipment").ToInt32() - Context.GetOrDefault("CurShipQty").ToInt32() : Context.GetOrDefault("CurShipQty").ToInt32()


                };


            }


            catch (Exception ex)


            {


                action.CatchExceptionWithLog(ex, $"包装工序：获取是否打印客户标签还是入库标签异常");


            }


            return action;


        }




        #endregion Functions




        /// <summary>


@@ -937,6 +1005,26 @@


            NodeCmd = null;


        }




        public void RemoveCurSnFromCurPackage(WipPkgItem pkgItem)


        {


            if (!pkgItem.IsNullOrEmpty())


            {


                var delItem = pkgItem.Items.Where(q => CurWipSNs.Any(sn => q.WipSNs.ContainsKey(sn.ID))).ToList();


                if (delItem.Any())


                {


                    pkgItem.Items.RemoveAll(q => CurWipSNs.Any(sn => q.WipSNs.ContainsKey(sn.ID)));


                    pkgItem.IsFinished = false;


                }


                else


                {


                    foreach (var item in pkgItem.Items)


                    {


                        RemoveCurSnFromCurPackage(item);


                    }


                }


            }


        }




        public override bool Close(bool needSaveHistoryLog = false)


        {


            //needSaveHistoryLog = true;