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 WipExtInfo : IWipExtInfo { #region Propertys & Variables #region 固定写法,工序中的必要信息 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 List Boms { get; set; } = new(); public Dictionary> SubItemDic { get; set; } = new(); public AssemblyInfo CurAssembly { get; set; } = new(); #endregion Propertys & Variables #region Functions /// /// 初始化工序行为 /// /// public void Init(IWorkStep curStep, IPosition position, MES_WO_NODE_ACT nodeAct, MES_WO_ACTION setting) { #region 固定写法,给默认变量赋值 CurStep = curStep; CurPosition = position; NodeAct = nodeAct; Setting = setting; #endregion //获取产品BOM Boms = Biz.Db.Queryable().Where(q => q.PROD_CODE == CurPosition.WorkBatch.WO.ITEM_CODE).ToList(); //获取上料物料 var assyList = new List(); try { assyList = setting.ITEM_CODE.JsonToObject>(); } catch (System.Exception ex) { var codeList = setting.ITEM_CODE.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); foreach (var code in codeList) { assyList.Add(new() { ItemCode = code }); } } var codes = assyList.Select(q => q.ItemCode).ToList(); var items = Biz.Db.Queryable().Where(q => codes.Contains(q.ITEM_CODE) && q.AUTH_ORG == CurPosition.WorkBatch.WO.AUTH_ORG).ToList(); //获取上料物料的替代料 foreach (var assy in assyList) { var info = items.FirstOrDefault(q => q.ITEM_CODE == assy.ItemCode); if (!info.IsNullOrEmpty()) { var item = new AssemblyItem { ItemInfo = info, RuleCode = assy.RuleCode, LoadQty = assy.Qty, }; var bom = Boms.FirstOrDefault(q => q.ITEM_CODE == assy.ItemCode); if (!bom.IsNullOrEmpty()) { var subs = bom.SUB_CODE.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); var surItems = Biz.Db.Queryable().Where(q => subs.Contains(q.ITEM_CODE) && q.AUTH_ORG == CurPosition.WorkBatch.WO.AUTH_ORG).ToList(); if (!SubItemDic.ContainsKey(assy.ItemCode)) { SubItemDic.Add(assy.ItemCode, surItems); } } CurAssembly.Items.Add(item); } } } /// /// 获取行为开始的提示信息 /// /// public Locale GetBeginMsg() { var msg = new Locale("MES.WorkAction.WipExtInfo.BeginMsg", string.Join(",", CurAssembly.Items.Select(q => $"{q.ItemInfo.ITEM_NAME}({q.ItemInfo.ITEM_CODE})"))); //var msg = new Locale($"请扫描以下需要上料的物料条码:{string.Join(",", CurAssembly.Items.Select(q => $"{q.ItemInfo.ITEM_NAME}({q.ItemInfo.ITEM_CODE})"))}"); return msg; } /// /// 尝试开始执行工序行为 /// /// public ApiAction TryBegin(SubmitInput input) { var action = new ApiAction(new SubmitOutput()); if (input.SN != CurPosition.CurWipSN.SN) { action = SaveAssembly(input, action); return action; } //如果返回成功则认为当前行为可以开始执行,否则返回失败 action.IsSuccessed = false; return action; } /// /// 工序行为提交数据 /// /// public ApiAction Submit(SubmitInput input) { var action = new ApiAction(new SubmitOutput()); action = SaveAssembly(input, action); //上料数据保存失败 if (!action.IsSuccessed) { //如果行为设置为出错需要重置工序操作 if (NodeAct.NEED_RESET == "Y") { CurPosition.ResetNode(); } } return action; } public ApiAction SaveAssembly(SubmitInput input, ApiAction action) { try { foreach (var item in CurAssembly.Items.Where(q => !q.IsFinished)) { var isOK = true; //根据条码规则验证上料是否正确 if (!item.RuleCode.IsNullOrEmpty()) { if (!Biz.CodeRule[item.RuleCode].IsNullOrEmpty()) { var result = Biz.CodeRule[item.RuleCode].Verify(input.SN); if (!result.IsSuccessed) { isOK = false; } } //不存在条码规则,则判断是否有自定义规则,没有则返回失败 else { switch (item.RuleCode) { case "自行验证": break; default: isOK = false; break; } } } //验证通过则保存上料信息 if (isOK) { var record = new MES_WIP_ASSY() { AUTH_ORG = CurPosition.WorkBatch.WO.AUTH_ORG, AUTH_PROD = CurPosition.CurLine.LINE_CODE, SN = input.SN, PROD_SN = CurPosition.CurWipSN.SN, ITEM_CODE = item.ItemInfo.ITEM_CODE, QTY = 1, UNIT = item.ItemInfo.UNIT, WORK_ORDER = CurPosition.CurWipSN.WORK_ORDER, BATCH_NO = CurPosition.CurWipSN.BATCH_NO, ROT_CODE = CurPosition.CurWipSN.ROT_CODE, NODE_ID = CurPosition.CurWipSN.NODE_ID, NODE_NAME = CurPosition.CurWipSN.NODE_NAME, FTY_CODE = CurPosition.CurWipSN.FTY_CODE, WS_CODE = CurPosition.CurWipSN.WS_CODE, LINE_CODE = CurPosition.CurWipSN.LINE_CODE, POST_CODE = CurPosition.CurWipSN.POST_CODE, OPER_CODE = CurPosition.CurWipSN.OPER_CODE, SEGMENT = CurPosition.CurWipSN.SEGMENT, }; item.Records.Add(record); if (item.Records.Sum(q => q.QTY) >= item.LoadQty) { item.IsFinished = true; } action.IsSuccessed = true; action.Data.Data = CurAssembly; action.LocaleMsg = new Locale($"扫描物料[{item.ItemInfo.ITEM_NAME}({item.ItemInfo.ITEM_CODE})的条码[{input.SN}]成功,请继续上料"); action.LocaleMsg = new Locale("MES.WorkAction.WipExtInfo.LoadSuccess", item.ItemInfo.ITEM_NAME, item.ItemInfo.ITEM_CODE); //上料完成 if (CurAssembly.IsFinished) { action = End(); } return action; } } //都没有物料验证通过,则返回错误信息 action.IsSuccessed = false; //action.LocaleMsg = new($"条码[{input.SN}]验证失败,不是以下物料的条码:{string.Join(",", CurAssembly.Items.Where(q => !q.IsFinished).Select(q => $"{q.ItemInfo.ITEM_NAME}({q.ItemInfo.ITEM_CODE})"))}"); action.LocaleMsg = new("MES.WorkAction.WipExtInfo.LoadFail", input.SN, string.Join(",", CurAssembly.Items.Where(q => !q.IsFinished).Select(q => $"{q.ItemInfo.ITEM_NAME}({q.ItemInfo.ITEM_CODE})"))); } catch (System.Exception ex) { action.CatchExceptionWithLog(ex, $"上料行为:验证条码[{input.SN}]并保存数据失败"); action.IsSuccessed = false; action.LocaleMsg = new($"验证条码[{input.SN}]并保存数据失败,工序已重置,请重新扫描进站产品条码"); action.LocaleMsg = new("MES.WorkAction.WipExtInfo.SaveAssemblyException", input.SN); CurPosition.ResetNode(); } return action; } /// /// 结束执行工序行为 /// /// public ApiAction End() { var action = new ApiAction(new SubmitOutput()); //记录行为操作记录 var wipAct = new MES_WIP_ACT() { AUTH_ORG = CurPosition.WorkBatch.WO.AUTH_ORG, AUTH_PROD = CurPosition.CurLine.LINE_CODE, HIS_ID = CurPosition.CurWipSNHis.ID, SN = CurPosition.CurWipSN.SN, STATUS = CurPosition.CurWipSN.STATUS, ITEM_CODE = CurPosition.CurWipSN.ITEM_CODE, WORK_ORDER = CurPosition.CurWipSN.WORK_ORDER, BATCH_NO = CurPosition.CurWipSN.BATCH_NO, ROT_CODE = CurPosition.CurWipSN.ROT_CODE, NODE_ID = CurPosition.CurWipSN.NODE_ID, NODE_NAME = CurPosition.CurWipSN.NODE_NAME, ACT_ID = NodeAct.ID, ACT_NAME = NodeAct.ACT_NAME, FTY_CODE = CurPosition.CurWipSN.FTY_CODE, WS_CODE = CurPosition.CurWipSN.WS_CODE, LINE_CODE = CurPosition.CurWipSN.LINE_CODE, POST_CODE = CurPosition.CurWipSN.POST_CODE, OPER_CODE = CurPosition.CurWipSN.OPER_CODE, SEGMENT = CurPosition.CurWipSN.SEGMENT, TRAY_SN = CurPosition.CurWipSN.TRAY_SN, OPERATION_TIME = DateTime.Now, SFTS_CODE = CurPosition.CurWipSN.SFTS_CODE, SFT_CODE = CurPosition.CurWipSN.SFT_CODE, PRD_CODE = CurPosition.CurWipSN.PRD_CODE, ACT_TYPE = NodeAct.ACT_TYPE, ACT_SN = CurPosition.CurWipSN.SN, ACT_VALUE_1 = CurAssembly.ToJson(), ACT_RESULT = "Y", TRACE_INFO = $"以下物料上料完成:{string.Join(",", CurAssembly.Items.Select(q => $"{q.ItemInfo.ITEM_NAME}({q.ItemInfo.ITEM_CODE})"))}", }; var records = new List(); foreach (var item in CurAssembly.Items) { records.AddRange(item.Records); } //保存数据 CurStep.DBSubmitAction = () => { var db = CurPosition.GetCommitDB(); db.Storageable(wipAct, CurPosition.UserCode).ExecuteCommand(); db.Insertable(records, CurPosition.UserCode).ExecuteCommand(); }; IsFinished = true; //action.LocaleMsg = new($"以下物料上料完成:{string.Join(",", CurAssembly.Items.Select(q => $"{q.ItemInfo.ITEM_NAME}({q.ItemInfo.ITEM_CODE})"))}"); action.LocaleMsg = new("MES.WorkAction.WipExtInfo.LoadFinish", string.Join(",", CurAssembly.Items.Select(q => $"{q.ItemInfo.ITEM_NAME}({q.ItemInfo.ITEM_CODE})"))); return action; } #endregion Functions } }