增加更新条码数量行为

Rodney Chen

2025-01-01 77771c41aa9f7f1f242c79b95fc2a8c82bd7c6c8

增加更新条码数量行为

 Tiger.Api/Language.db

Binary files differ

 Tiger.Business.MES/WorkAction/InputQty.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,265 @@
using Rhea.Common;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Tiger.IBusiness;
using Tiger.IBusiness.MES.WorkAction;
using Tiger.Model;
using Tiger.Model.Entitys.MES.Position;

namespace Tiger.Business.MES.WorkAction
{
    public class InputQty : IInputQty
    {
        #region Propertys & Variables
        #region å›ºå®šå†™æ³•ï¼Œå·¥åºä¸­çš„必要信息
        public DbClient MainDB { get; set; }
        public bool IsFinished { get; set; } = false;
        public IWorkStep CurStep { get; set; }
        public IPosition CurPosition { get; set; }
        public MES_WO_NODE_ACT NodeAct { get; set; }
        public MES_WO_ACTION Setting { get; set; }
        #endregion
        public double NewQty { get; set; }
        public double NewWoInputQty { get; set; }
        public double NewBatchInputQty { get; set; }
        #endregion Propertys & Variables

        #region Functions
        /// <summary>
        /// åˆå§‹åŒ–工序行为
        /// </summary>
        /// <returns></returns>
        public void Init(IWorkStep curStep, IPosition position, MES_WO_NODE_ACT nodeAct, MES_WO_ACTION setting)
        {
            #region å›ºå®šå†™æ³•ï¼Œç»™é»˜è®¤å˜é‡èµ‹å€¼
            MainDB = position.MainDB;
            CurStep = curStep;
            CurPosition = position;
            NodeAct = nodeAct;
            Setting = setting;
            #endregion

            CurStep.Message = Biz.L("等待输入条码数量");
            CurStep.Status = StepStatus.Normal;
        }

        /// <summary>
        /// èŽ·å–行为开始的提示信息
        /// </summary>
        /// <returns></returns>
        public Locale GetBeginMsg()
        {
            //var msg = new Locale($"请输入条码[{0}]的数量");
            var msg = new Locale("MES.WorkAction.InputQty.BeginMsg", CurPosition.CurSN);
            
            return msg;
        }

        /// <summary>
        /// å°è¯•å¼€å§‹æ‰§è¡Œå·¥åºè¡Œä¸º
        /// </summary>
        /// <returns></returns>
        public ApiAction<SubmitOutput> TryBegin(SubmitInput input)
        {
            var action = new ApiAction<SubmitOutput>(new SubmitOutput());

            action.LocaleMsg = GetBeginMsg();

            //如果返回成功则认为当前行为可以开始执行，否则返回失败
            CurStep.Message = Biz.L("请输入数量");
            CurStep.Status = StepStatus.Normal;
            action.IsSuccessed = true;
            action.Data.ShortMsg = new("请输入数量", ShortMessage.Types.Success);
            return action;
        }

        /// <summary>
        /// å·¥åºè¡Œä¸ºæäº¤æ•°æ®
        /// </summary>
        /// <returns></returns>
        public ApiAction<SubmitOutput> Submit(SubmitInput input)
        {
            var action = new ApiAction<SubmitOutput>(new SubmitOutput());

            action = SaveSnQty(input, action);
            //上料数据保存失败
            if (!action.IsSuccessed)
            {
                //如果行为设置为出错需要重置工序操作
                if (NodeAct.NEED_RESET == "Y")
                {
                    CurPosition.ResetNode();
                }
            }
            else
            {
                action = End(input);
            }
            return action;
        }

        public ApiAction<SubmitOutput> SaveSnQty(SubmitInput input, ApiAction<SubmitOutput> action)
        {
            try
            {
                NewQty = input?.Data?.ToInt32() ?? 0;
                if (NewQty > 0)
                {
                    var newInput = CurPosition.CurWipSNs.Sum(q => NewQty);
                    var woInput = CurPosition.WorkBatch.WoSNs.Where(q => q.WORK_ORDER == CurPosition.WorkBatch.WO.ORDER_NO && BIZ_MES_WO_SN.STATUSs.NotInput.GetValue() < q.STATUS && q.STATUS <= BIZ_MES_WO_SN.STATUSs.Finished.GetValue())
                                                                                           .Where(q => !CurPosition.CurWipSNs.Any(sn => sn.ID == q.WIP_ID)).DistinctBy(q => q.WIP_ID).Sum(q => q.QTY);
                    var batchInput = CurPosition.WorkBatch.WoSNs.Where(q => q.BATCH_NO == CurPosition.WorkBatch.Batch.BATCH_NO && BIZ_MES_WO_SN.STATUSs.NotInput.GetValue() < q.STATUS && q.STATUS <= BIZ_MES_WO_SN.STATUSs.Finished.GetValue())
                                                                                               .Where(q => !CurPosition.CurWipSNs.Any(sn => sn.ID == q.WIP_ID)).DistinctBy(q => q.WIP_ID).Sum(q => q.QTY);
                    
                    //工单批次投入数量减去报废数量如果大于等于计划数量，则不允许生产
                    if ((NewBatchInputQty = batchInput + newInput) > CurPosition.WorkBatch.Batch.PLAN_QTY)
                    {
                        CurStep.Message = Biz.L("重新输入数量");
                        CurStep.Status = StepStatus.Error;
                        action.IsSuccessed = false;
                        action.Data.ShortMsg = new("重新输入数量", ShortMessage.Types.Error);
                        //action.LocaleMsg = new($"条码更新数量[{0}]后，工单批次[{1}]投入数量[{2}]超出计划数量[{3}]，请重新输入正确的数量");
                        action.LocaleMsg = new("MES.WorkAction.InputQty.BatchInputEnough", input.Data, CurPosition.WorkBatch.Batch.BATCH_NO, batchInput + newInput, CurPosition.WorkBatch.Batch.PLAN_QTY);
                    }
                    //工单投入数量减去报废数量如果大于等于计划数量，则不允许生产
                    else if ((NewWoInputQty = woInput + newInput) > CurPosition.WorkBatch.WO.PLAN_QTY)
                    {
                        CurStep.Message = Biz.L("重新输入数量");
                        CurStep.Status = StepStatus.Error;
                        action.IsSuccessed = false;
                        action.Data.ShortMsg = new("重新输入数量", ShortMessage.Types.Error);
                        //action.LocaleMsg = new($"条码更新数量[{0}]后，工单[{1}]投入数量[{2}]超出计划数量[{3}]，请重新输入正确的数量");
                        action.LocaleMsg = new("MES.WorkAction.InputQty.WoInputEnough", input.Data, CurPosition.WorkBatch.WO.ORDER_NO, woInput + newInput, CurPosition.WorkBatch.WO.PLAN_QTY);
                    }
                    else
                    {
                        action = End(input);
                    }
                }
                else
                {
                    CurStep.Message = Biz.L("重新输入数量");
                    CurStep.Status = StepStatus.Error;
                    action.IsSuccessed = false;
                    action.Data.ShortMsg = new("重新输入数量", ShortMessage.Types.Error);
                    //action.LocaleMsg = new($"数量[{0}]必须是大于0的整数，请重新输入正确的数量");
                    action.LocaleMsg = new("MES.WorkAction.InputQty.QtyError", input.Data);

                }
            }
            catch (System.Exception ex)
            {
                CurStep.Message = Biz.L("更新数量异常");
                CurStep.Status = StepStatus.Error;
                action.Data.ShortMsg = new("更新数量异常", ShortMessage.Types.Error);
                //action.CatchExceptionWithLog(ex, $"更新数量行为：更新条码[{0}]数量[{1}]异常");
                action.LocaleMsg = new("MES.WorkAction.InputQty.SaveQtyException", CurPosition.CurSN, input?.Data.ToString());
            }
            return action;
        }

        /// <summary>
        /// ç»“束执行工序行为
        /// </summary>
        /// <returns></returns>
        public ApiAction<SubmitOutput> End(SubmitInput input)
        {
            var action = new ApiAction<SubmitOutput>(new SubmitOutput());
            //记录行为操作记录
            var wipActs = new List<MES_WIP_ACT>();
            foreach (var wipSn in CurPosition.CurWipSNs)
            {
                var wipAct = new MES_WIP_ACT()
                {
                    AUTH_ORG = CurPosition.WorkBatch.WO.AUTH_ORG,
                    AUTH_PROD = CurPosition.CurLine.LINE_CODE,
                    WIP_ID = wipSn.ID,
                    HIS_ID = CurPosition.CurWipSNHiss.First(q => q.SN == wipSn.SN).ID,
                    SN = wipSn.SN,
                    STATUS = wipSn.STATUS,
                    ITEM_CODE = wipSn.ITEM_CODE,
                    WORK_ORDER = wipSn.WORK_ORDER,
                    BATCH_NO = wipSn.BATCH_NO,
                    ROT_CODE = wipSn.ROT_CODE,
                    NODE_ID = wipSn.NODE_ID,
                    NODE_NAME = wipSn.NODE_NAME,
                    ACT_ID = NodeAct.ID,
                    ACT_NAME = NodeAct.ACT_NAME,
                    FTY_CODE = wipSn.FTY_CODE,
                    WS_CODE = wipSn.WS_CODE,
                    LINE_CODE = wipSn.LINE_CODE,
                    POST_CODE = wipSn.POST_CODE,
                    OPER_CODE = wipSn.OPER_CODE,
                    SEGMENT = wipSn.SEGMENT,
                    FLOW_SN = wipSn.FLOW_SN,
                    TRAY_SN = wipSn.TRAY_SN,
                    INNER_SN = wipSn.INNER_SN,
                    CARTON_SN = wipSn.CARTON_SN,
                    PALLET_SN = wipSn.PALLET_SN,
                    OPERATION_TIME = DateTime.Now,
                    SFTS_CODE = wipSn.SFTS_CODE,
                    SFT_CODE = wipSn.SFT_CODE,
                    PRD_CODE = wipSn.PRD_CODE,
                    ACT_TYPE = NodeAct.ACT_TYPE,
                    ACT_SN = wipSn.SN,
                    ACT_RESULT = "Y",
                    ELAPSED_TIME = CurStep.GetElapsedTime().TotalMilliseconds.ToInt64(),
                    TRACE_INFO = $"条码[{CurPosition.CurSN}]更新数量为[{NewQty}]保存成功",
                };
                wipActs.Add(wipAct);
            }

            //创建变量克隆对象用于传入DBSubmitAction中保存当前需要暂存的数据值
            var _wipActs = wipActs.Clone();
            var wo = CurPosition.WorkBatch.WO.ORDER_NO;
            var batch = CurPosition.WorkBatch.Batch.BATCH_NO;
            var nodeID = NodeAct.NODE_ID;
            var _wipIDs = CurPosition.CurWipSNs.Select(q => q.ID).ToList().Clone();
            //保存数据
            CurStep.DBSubmitAction = () =>
            {
                var db = CurPosition.GetCommitDB();
                //在制品信息表
                db.Updateable<MES_WIP_DATA>(CurPosition.UserCode)
                    .SetColumns(q => q.QTY == NewQty)
                    .Where(q => q.WORK_ORDER == wo && _wipIDs.Contains(q.ID))
                    .ExecuteCommand();
                //生产过程记录
                db.Updateable<MES_WIP_HIS>(CurPosition.UserCode)
                    .SetColumns(q => q.QTY == NewQty)
                    .Where(q => q.WORK_ORDER == wo && q.NODE_ID == nodeID && _wipIDs.Contains(q.WIP_ID))
                    .ExecuteCommand();
                //工单表
                db.Updateable<BIZ_MES_WO>(CurPosition.UserCode)
                    .SetColumns(q => q.INPUT_QTY == NewWoInputQty)
                    .Where(q => q.ORDER_NO == wo)
                    .ExecuteCommand();
                //工单批次表
                db.Updateable<BIZ_MES_WO_BATCH>(CurPosition.UserCode)
                    .SetColumns(q => q.INPUT_QTY == NewBatchInputQty)
                    .Where(q => q.BATCH_NO == batch)
                    .ExecuteCommand();
                //工单条码明细表
                db.Updateable<BIZ_MES_WO_SN>(CurPosition.UserCode)
                    .SetColumns(q => q.QTY == NewQty)
                    .Where(q => q.WORK_ORDER == wo && _wipIDs.Contains(q.WIP_ID))
                    .ExecuteCommand();
                db.Storageable(_wipActs, CurPosition.UserCode).ExecuteCommand();
            };

            IsFinished = true;
            CurStep.Message = Biz.L("更新数量成功");
            CurStep.Status = StepStatus.Finished;
            action.Data.ShortMsg = new("更新数量成功", ShortMessage.Types.Success);
            //action.LocaleMsg = new($"条码[{0}]更新数量为[{1}]保存成功");
            action.LocaleMsg = new("MES.WorkAction.InputQty.SaveSuccess", CurPosition.CurSN, NewQty);
            return action;
        }

        #endregion Functions
    }
}

 Tiger.Business.MES/WorkAction/Weighing.cs

@@ -134,7 +134,7 @@
                CurStep.Message = Biz.L("称重异常");
                CurStep.Status = StepStatus.Error;
                action.Data.ShortMsg = new("称重异常", ShortMessage.Types.Error);
                action.CatchExceptionWithLog(ex, $"称重行为：条码[{CurPosition.CurSN}]称重数据[{input?.Data?.ToString()}]保存异常");
                //action.CatchExceptionWithLog(ex, $"称重行为：条码[{0}]称重数据[{1}]保存异常");
                action.LocaleMsg = new("MES.WorkAction.Weighing.SaveWeightInfoException", CurPosition.CurSN, input?.Data.ToString());
            }
            return action;

 Tiger.IBusiness.MES/WorkAction/IInputQty.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,12 @@
using Newtonsoft.Json;
using Rhea.Common;
using System;
using Tiger.Model;

namespace Tiger.IBusiness.MES.WorkAction
{
    public interface IInputQty : IWorkAction
    {

    }
}

 Tiger.Model.Net/Entitys/MES/MES_WO_NODE_ACT.cs

@@ -161,6 +161,8 @@
        */
        [Navigate(NavigateType.OneToOne, nameof(ACT_CODE), nameof(MES_CUSTOM_ACT.ACT_CODE), "GHOST_ROW = 0")]//一对一 ClassAId是MES_WO_NODE_ACT类里面的外键ID字段
        public MES_CUSTOM_ACT Definition { get; set; } //注意禁止手动赋值，只能是null
        [Navigate(NavigateType.OneToMany, nameof(MES_WO_ACT_VAR.ACT_ID), nameof(ID), "GHOST_ROW = 0")]//ClassA表中的MES_WO_NODE_ACTId
        public List<MES_WO_ACT_VAR> Variables { get; set; } //注意禁止手动赋值，只能是null
        #endregion

        #region æžšä¸¾å˜é‡

 Tiger.Model.Net/Entitys/MES/ParameterEntity/PositionParameter.cs

@@ -46,9 +46,9 @@
        /// </summary>
        public string DFT_CODE { get; set; }
        /// <summary>
        /// å½“前操作需要提交的选项
        /// å½“前操作的行为的变量字典，如果是不是行为，否则留空
        /// </summary>
        public Dictionary<string, string> Options { get; set; } = new Dictionary<string, string>();
        public Dictionary<string, string> ActionDic { get; set; } = new Dictionary<string, string>();
        /// <summary>
        /// å½“前操作需要提交的数据
        /// </summary>
@@ -74,6 +74,10 @@
        /// </summary>
        public string ActionType { get; set; }
        /// <summary>
        /// å½“前操作的行为的变量字典，如果是不是行为，否则留空
        /// </summary>
        public Dictionary<string, string> ActionDic { get; set; }
        /// <summary>
        /// ä¸‹ä¸€ä¸ªæ“ä½œçš„工步ID
        /// </summary>
        public string NextStepID { get; set; }