服务端的TigerApi 框架，基于.NET6 2024 版本
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
Ben Lin
30 分钟以前 0c0309afae85b72746bd2431c10c7f5982e210e3 
 Tiger.Business.MES/Common/WorkBatch.cs


@@ -10,7 +10,6 @@


using Tiger.IBusiness;


using Tiger.Model.Entitys.MES.Position;


using Tiger.Business.MES;


using static Microsoft.CodeAnalysis.CSharp.SyntaxTokenParser;


using Org.BouncyCastle.Ocsp;


using System.IO;




@@ -50,7 +49,7 @@




        #region Functions


        /// <summary>


        /// 初始化工单资料


        /// 初始化工单批次资料


        /// </summary>


        /// <returns></returns>


        public WorkBatch Init(string lineCode)


@@ -63,6 +62,10 @@


            return this;


        }




        /// <summary>


        /// 更新工单批次资料


        /// </summary>


        /// <param name="updateAll"></param>


        public void Update(bool updateAll = false)


        {


            var strat = DateTime.Now;


@@ -149,6 +152,7 @@




            Update();




            var woSNs = Biz.Db.Queryable<BIZ_MES_WO_SN>().Where(q => q.WORK_ORDER == OrderNo).ToList();


            //工单批次状态不是已下发或者生产中，则不允许生产


            if (Batch.STATUS != BIZ_MES_WO_BATCH.STATUSs.Release.GetValue() && Batch.STATUS != BIZ_MES_WO_BATCH.STATUSs.Working.GetValue())


            {


@@ -166,24 +170,25 @@


                action.LocaleMsg = new("MES.WorkBatch.WoStatusCanNotWork", WO.ORDER_NO, Batch.STATUS.GetEnumDesc<BIZ_MES_WO.STATUSs>());


            }


            //工单批次投入数量减去报废数量如果大于等于计划数量，则不允许生产


            var batchInput = WoSNs.Where(q => q.BATCH_NO == Batch.BATCH_NO && BIZ_MES_WO_SN.STATUSs.NotInput.GetValue() < q.STATUS && q.STATUS <= BIZ_MES_WO_SN.STATUSs.Finished.GetValue()).DistinctBy(q => q.WIP_ID).Sum(q => q.QTY);


            var batchInput = woSNs.Where(q => q.BATCH_NO == Batch.BATCH_NO && BIZ_MES_WO_SN.STATUSs.NotInput.GetValue() < q.STATUS && q.STATUS <= BIZ_MES_WO_SN.STATUSs.Finished.GetValue()).DistinctBy(q => q.WIP_ID).Sum(q => q.QTY);


            if (curNode.IS_FIRST_NODE == "Y" && batchInput >= Batch.PLAN_QTY)


            {


                action.IsSuccessed = false;


                action.Data.SetValue(this, null);


                //action.LocaleMsg = new($"工单批次[{0}]已投入 {1}，其中报废 {2}，以满足计划数量[{3}]，无需继续投入");


                action.LocaleMsg = new("MES.WorkBatch.BatchInputEnough", Batch.BATCH_NO, batchInput, WoSNs.Where(q => q.BATCH_NO == Batch.BATCH_NO && q.STATUS > BIZ_MES_WO_SN.STATUSs.Finished.GetValue()).DistinctBy(q => q.WIP_ID).Sum(q => q.QTY), Batch.PLAN_QTY);


                action.LocaleMsg = new("MES.WorkBatch.BatchInputEnough", Batch.BATCH_NO, batchInput, woSNs.Where(q => q.BATCH_NO == Batch.BATCH_NO && q.STATUS > BIZ_MES_WO_SN.STATUSs.Finished.GetValue()).DistinctBy(q => q.WIP_ID).Sum(q => q.QTY), Batch.PLAN_QTY);


            }


            //工单投入数量减去报废数量如果大于等于计划数量，则不允许生产


            var woInput = WoSNs.Where(q => q.WORK_ORDER == WO.ORDER_NO && BIZ_MES_WO_SN.STATUSs.NotInput.GetValue() < q.STATUS && q.STATUS <= BIZ_MES_WO_SN.STATUSs.Finished.GetValue()).DistinctBy(q => q.WIP_ID).Sum(q => q.QTY);


            var woInput = woSNs.Where(q => q.WORK_ORDER == WO.ORDER_NO && BIZ_MES_WO_SN.STATUSs.NotInput.GetValue() < q.STATUS && q.STATUS <= BIZ_MES_WO_SN.STATUSs.Finished.GetValue()).DistinctBy(q => q.WIP_ID).Sum(q => q.QTY);


            if (curNode.IS_FIRST_NODE == "Y" && woInput >= WO.PLAN_QTY)


            {


                action.IsSuccessed = false;


                action.Data.SetValue(this, null);


                //action.LocaleMsg = new($"工单[{0}]已投入 {1}，其中报废 {2}，以满足计划数量[{3}]，无需继续投入");


                action.LocaleMsg = new("MES.WorkBatch.WoInputEnough", WO.ORDER_NO, woInput, WoSNs.Where(q => q.WORK_ORDER == WO.ORDER_NO && q.STATUS > BIZ_MES_WO_SN.STATUSs.Finished.GetValue()).DistinctBy(q => q.WIP_ID).Sum(q => q.QTY), WO.PLAN_QTY);


                action.LocaleMsg = new("MES.WorkBatch.WoInputEnough", WO.ORDER_NO, woInput, woSNs.Where(q => q.WORK_ORDER == WO.ORDER_NO && q.STATUS > BIZ_MES_WO_SN.STATUSs.Finished.GetValue()).DistinctBy(q => q.WIP_ID).Sum(q => q.QTY), WO.PLAN_QTY);


            }




            WoSNs = woSNs;


            return action;


        }




@@ -199,7 +204,7 @@


                WO.STATUS = BIZ_MES_WO.STATUSs.Working.GetValue();


                WO.ACT_START_TIME = WO.ACT_START_TIME < new DateTime(2000, 1, 1) ? DateTime.Now : WO.ACT_START_TIME;


                Batch.STATUS = BIZ_MES_WO_BATCH.STATUSs.Working.GetValue();


                Batch.ACT_START_TIME = WO.ACT_START_TIME < new DateTime(2000, 1, 1) ? DateTime.Now : WO.ACT_START_TIME;


                Batch.ACT_START_TIME = Batch.ACT_START_TIME < new DateTime(2000, 1, 1) ? DateTime.Now : Batch.ACT_START_TIME;


                //保存数据库


                var db = Biz.Db;


                var dbTran = db.UseTran(() =>


@@ -254,7 +259,7 @@




            //判断当前工单批次是否已完工


            if (!woSNs.Any(q => q.BATCH_NO == Batch.BATCH_NO && q.STATUS < BIZ_MES_WO_SN.STATUSs.Finished.GetValue()) && 


                 woSNs.Count(q => q.BATCH_NO == Batch.BATCH_NO && q.STATUS == BIZ_MES_WO_SN.STATUSs.Finished.GetValue()) == Batch.PLAN_QTY)


                 woSNs.Where(q => q.BATCH_NO == Batch.BATCH_NO && q.STATUS == BIZ_MES_WO_SN.STATUSs.Finished.GetValue()).Sum(q=>q.QTY) == Batch.PLAN_QTY)


            {


                Batch.STATUS = BIZ_MES_WO_BATCH.STATUSs.Closed.GetValue();


                Batch.ACT_END_TIME = DateTime.Now;


@@ -262,7 +267,7 @@




            //判断当前工单是否已完工


            if (!woSNs.Any(q => q.STATUS < BIZ_MES_WO_SN.STATUSs.Finished.GetValue()) && 


                 woSNs.Count(q => q.STATUS == BIZ_MES_WO_SN.STATUSs.Finished.GetValue()) == WO.PLAN_QTY)


                 woSNs.Where(q => q.STATUS == BIZ_MES_WO_SN.STATUSs.Finished.GetValue()).Sum(q => q.QTY) == WO.PLAN_QTY)


            {


                WO.STATUS = BIZ_MES_WO.STATUSs.Closed.GetValue();


                WO.ACT_END_TIME = DateTime.Now;


@@ -642,7 +647,7 @@


                            .ExecuteCommand();


                //MES_WIP_DATA & MES_WIP_HIS


                var wipHiss = new List<MES_WIP_HIS>();


                foreach (var wipSN in wipList.Where(q => q.STATUS != MES_WIP_DATA.STATUSs.Offline.GetValue()))


                foreach (var wipSN in wipList) //.Where(q => q.STATUS != MES_WIP_DATA.STATUSs.Offline.GetValue())


                {


                    wipSN.STATUS = MES_WIP_DATA.STATUSs.Offline.GetValue();


                    wipSN.TRAY_SN = wipSN.INNER_SN = wipSN.CARTON_SN = wipSN.PALLET_SN = wipSN.SHIPPING_ORDER = null;


@@ -651,6 +656,7 @@


                    wipSN.NODE_ID = "";


                    wipSN.NODE_NAME = "下线退库";


                    wipSN.OPERATION_TIME = DateTime.Now;


                    wipSN.OPERATION_END = DateTime.Now;


                    var his = new MES_WIP_HIS(wipSN, $"工单[{wipSN.WORK_ORDER}]条码[{wipSN.SN}]下线");


                    wipHiss.Add(his);


                }