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;
|
using Tiger.Model.MES.Yada;
|
|
namespace Tiger.Business.MES.WorkAction
|
{
|
public class YadaAssembly : IYadaAssembly
|
{
|
#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 List<BAS_PROD_BOM> Boms { get; set; } = new();
|
public AssemblyInfo CurAssembly { get; set; } = new();
|
public List<mes_MOPickList> MoPickList { 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
|
|
//获取产品BOM
|
Boms = MainDB.Queryable<BAS_PROD_BOM>().Where(q => q.PROD_CODE == CurPosition.WorkBatch.WO.ITEM_CODE).ToList();
|
//获取上料物料
|
var assyList = new List<AssemblySetting>();
|
try
|
{
|
assyList = (setting.ITEM_CODE ?? "").JsonToObject<List<AssemblySetting>>();
|
}
|
catch (System.Exception ex)
|
{
|
var codeList = setting.ITEM_CODE.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
|
foreach (var code in codeList)
|
{
|
assyList.Add(new(){ ITEM_CODE = code, QTY = 1 });
|
}
|
}
|
var codes = assyList.Select(q => q.ITEM_CODE).ToList();
|
var items = MainDB.Queryable<BAS_ITEM>().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.ITEM_CODE);
|
if (!info.IsNullOrEmpty())
|
{
|
var item = new AssemblyItem {
|
ItemInfo = info,
|
RuleCode = assy.RULE_CODE,
|
LoadQty = assy.QTY,
|
IsBatchItem = assy.IsBatchItem,
|
};
|
var bom = Boms.FirstOrDefault(q => q.ITEM_CODE == assy.ITEM_CODE);
|
if (!bom.IsNullOrEmpty())
|
{
|
var subs = bom.SUB_CODE.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
|
var surItems = MainDB.Queryable<BAS_ITEM>().Where(q => subs.Contains(q.ITEM_CODE) && q.AUTH_ORG == CurPosition.WorkBatch.WO.AUTH_ORG).ToList();
|
foreach (var sub in surItems)
|
{
|
if (!item.SubItems.Any(q => q.ITEM_CODE == sub.ITEM_CODE))
|
{
|
item.SubItems.Add(sub);
|
}
|
}
|
}
|
CurAssembly.Items.Add(item);
|
}
|
}
|
//获取工单备料信息
|
MoPickList = Biz.DataSource["YadaU9C"].Client.Queryable<mes_MOPickList>().Where(q => q.MoDocNo == CurPosition.WorkBatch.WO.ORDER_NO).ToList();
|
|
CurStep.Message = Biz.L("扫描上料物料");
|
CurStep.Status = StepStatus.Normal;
|
}
|
|
/// <summary>
|
/// 获取行为开始的提示信息
|
/// </summary>
|
/// <returns></returns>
|
public Locale GetBeginMsg()
|
{
|
var msg = new Locale("MES.WorkAction.Assembly.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;
|
}
|
|
/// <summary>
|
/// 尝试开始执行工序行为
|
/// </summary>
|
/// <returns></returns>
|
public ApiAction<SubmitOutput> TryBegin(SubmitInput input)
|
{
|
var action = new ApiAction<SubmitOutput>(new SubmitOutput());
|
|
if (!CurPosition.CurWipSNs.Any(w => w.SN == input.SN))
|
{
|
action = SaveAssembly(input, action);
|
return action;
|
}
|
|
//如果返回成功则认为当前行为可以开始执行，否则返回失败
|
CurStep.Message = Biz.L("等待上料");
|
CurStep.Status = StepStatus.Normal;
|
action.IsSuccessed = false;
|
action.Data.ShortMsg = new("等待上料", ShortMessage.Types.Normal);
|
return action;
|
}
|
|
/// <summary>
|
/// 工序行为提交数据
|
/// </summary>
|
/// <returns></returns>
|
public ApiAction<SubmitOutput> Submit(SubmitInput input)
|
{
|
var action = new ApiAction<SubmitOutput>(new SubmitOutput());
|
|
action = SaveAssembly(input, action);
|
//上料数据保存失败
|
if (!action.IsSuccessed)
|
{
|
//如果行为设置为出错需要重置工序操作
|
if (NodeAct.NEED_RESET == "Y")
|
{
|
CurPosition.ResetNode();
|
}
|
}
|
return action;
|
}
|
|
public ApiAction<SubmitOutput> SaveAssembly(SubmitInput input, ApiAction<SubmitOutput> action)
|
{
|
try
|
{
|
foreach (var item in CurAssembly.Items.Where(q => !q.IsFinished))
|
{
|
var isOK = true;
|
var matchItem = item.ItemInfo;
|
//根据条码规则验证上料是否正确
|
if (!item.RuleCode.IsNullOrEmpty())
|
{
|
if (!Cache.CodeRule[item.RuleCode].IsNullOrEmpty())
|
{
|
var result = Cache.CodeRule[item.RuleCode].Verify(input.SN);
|
if (!result.IsSuccessed)
|
{
|
isOK = false;
|
}
|
}
|
//不存在条码规则，则判断是否有自定义规则，没有则返回失败
|
else
|
{
|
switch (item.RuleCode)
|
{
|
case "自行验证":
|
break;
|
default:
|
isOK = false;
|
break;
|
}
|
}
|
}
|
//主料验证不通过，则尝试验证替代料
|
if (!isOK && item.SubItems.Any())
|
{
|
foreach (var subItem in item.SubItems)
|
{
|
if (!subItem.RULE_CODE.IsNullOrEmpty())
|
{
|
if (!Cache.CodeRule[subItem.RULE_CODE].IsNullOrEmpty())
|
{
|
var result = Cache.CodeRule[item.RuleCode].Verify(input.SN);
|
//只要有一个替代料通过验证则可以上料
|
if (result.IsSuccessed)
|
{
|
isOK = true;
|
matchItem = subItem;
|
break;
|
}
|
}
|
}
|
}
|
}
|
//如果当前物料存在备料表中存在推荐批次，则上料物料必须属于其推荐批次的物料
|
var suggest = MoPickList.Where(q => q.Code == item.ItemInfo.ITEM_CODE && !q.SuggestedBatch.IsNullOrEmpty()).Select(q => q.SuggestedBatch).ToList();
|
if (isOK && suggest.Any())
|
{
|
isOK = false;
|
//在推荐批次所属工单的条码中存在
|
if (MainDB.Queryable<BIZ_MES_WO_SN>().Any(q => suggest.Contains(q.WORK_ORDER) && (q.SN == input.SN || q.FLOW_SN == input.SN || q.TRAY_SN == input.SN)))
|
{
|
isOK = true;
|
}
|
}
|
//验证通过则保存上料信息
|
if (isOK)
|
{
|
//批次物料则只记录一次，非批次物料则要按个数验证数量
|
if (item.IsBatchItem)
|
{
|
foreach (var wipSn in CurPosition.CurWipSNs)
|
{
|
var record = new MES_WIP_ASSY()
|
{
|
AUTH_ORG = CurPosition.WorkBatch.WO.AUTH_ORG,
|
AUTH_PROD = CurPosition.CurLine.LINE_CODE,
|
WIP_ID = wipSn.ID,
|
SN = input.SN,
|
PROD_SN = wipSn.SN,
|
ITEM_CODE = matchItem.ITEM_CODE,
|
QTY = 1,
|
UNIT = matchItem.UNIT,
|
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,
|
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,
|
};
|
item.Records.Add(record);
|
}
|
item.IsFinished = true;
|
}
|
else
|
{
|
foreach (var wipSn in CurPosition.CurWipSNs)
|
{
|
var record = new MES_WIP_ASSY()
|
{
|
AUTH_ORG = CurPosition.WorkBatch.WO.AUTH_ORG,
|
AUTH_PROD = CurPosition.CurLine.LINE_CODE,
|
WIP_ID = wipSn.ID,
|
SN = input.SN,
|
PROD_SN = wipSn.SN,
|
ITEM_CODE = matchItem.ITEM_CODE,
|
QTY = 1,
|
UNIT = matchItem.UNIT,
|
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,
|
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,
|
};
|
item.Records.Add(record);
|
}
|
|
if (item.Records.Sum(q => q.QTY) / item.Records.Count >= item.LoadQty * CurPosition.CurWipSNs.Count)
|
{
|
item.IsFinished = true;
|
}
|
}
|
|
CurStep.Message = Biz.L("上料成功");
|
CurStep.Status = StepStatus.Success;
|
action.IsSuccessed = true;
|
action.Data.ShortMsg = new("上料成功", ShortMessage.Types.Success);
|
action.Data.Data = CurAssembly;
|
//action.LocaleMsg = new Locale($"扫描物料[{matchItem.ITEM_NAME}({matchItem.ITEM_CODE})的条码[{input.SN}]成功，请继续上料");
|
action.LocaleMsg = new Locale("MES.WorkAction.Assembly.LoadSuccess", matchItem.ITEM_NAME, matchItem.ITEM_CODE);
|
|
//上料完成
|
if (CurAssembly.IsFinished)
|
{
|
action = End(input);
|
}
|
return action;
|
}
|
}
|
//都没有物料验证通过，则返回错误信息
|
CurStep.Message = Biz.L("上料失败");
|
CurStep.Status = StepStatus.Error;
|
action.IsSuccessed = false;
|
action.Data.ShortMsg = new("上料失败", ShortMessage.Types.Failed);
|
//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.Assembly.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)
|
{
|
CurStep.Message = Biz.L("上料异常");
|
CurStep.Status = StepStatus.Error;
|
action.Data.ShortMsg = new("上料异常", ShortMessage.Types.Exception);
|
action.CatchExceptionWithLog(ex, $"上料行为：验证条码[{input.SN}]并保存数据异常");
|
action.IsSuccessed = false;
|
//action.LocaleMsg = new($"验证条码[{input.SN}]并保存数据异常，工序已重置，请重新扫描进站产品条码");
|
action.LocaleMsg = new("MES.WorkAction.Assembly.SaveAssemblyException", input.SN);
|
CurPosition.ResetNode();
|
}
|
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_VALUE_1 = CurAssembly.ToJson(),
|
ACT_RESULT = "Y",
|
ELAPSED_TIME = CurStep.GetElapsedTime().TotalMilliseconds.ToInt64(),
|
TRACE_INFO = $"以下物料上料完成：{string.Join(",", CurAssembly.Items.Select(q => $"{q.ItemInfo.ITEM_NAME}({q.ItemInfo.ITEM_CODE})"))}",
|
};
|
wipActs.Add(wipAct);
|
}
|
|
|
//创建变量克隆对象用于传入DBSubmitAction中保存当前需要暂存的数据值
|
var _wipActs = wipActs.Clone();
|
//整理上料记录
|
var _records = new List<MES_WIP_ASSY>();
|
foreach (var item in CurAssembly.Items)
|
{
|
_records.AddRange(item.Records.Clone());
|
}
|
//保存数据
|
CurStep.DBSubmitAction = () =>
|
{
|
var db = CurPosition.GetCommitDB();
|
db.Storageable(_wipActs, CurPosition.UserCode).ExecuteCommand();
|
db.Insertable(_records, CurPosition.UserCode).ExecuteCommand();
|
};
|
|
IsFinished = true;
|
CurStep.Message = Biz.L("上料完成");
|
CurStep.Status = StepStatus.Finished;
|
action.Data.ShortMsg = new("上料完成", ShortMessage.Types.Success);
|
//action.LocaleMsg = new($"以下物料上料完成：{string.Join("，", CurAssembly.Items.Select(q => $"{q.ItemInfo.ITEM_NAME}({q.ItemInfo.ITEM_CODE})"))}");
|
action.LocaleMsg = new("MES.WorkAction.Assembly.LoadFinish", string.Join("，", CurAssembly.Items.Select(q => $"{q.ItemInfo.ITEM_NAME}({q.ItemInfo.ITEM_CODE})")));
|
return action;
|
}
|
|
#endregion Functions
|
}
|
}
|
