using DBHelper; using Microsoft.EntityFrameworkCore; using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Linq; using WCS.Core; using WCS.Entity; using WCS.Entity.Protocol; using WCS.Entity.Protocol.SRM; using WCS.Service.Extensions; using WCS.Service.Handlers; using WCS.Service.Helpers; using WCS.Service.Log; using TaskStatus = WCS.Entity.TaskStatus; namespace WCS.Service.Works.Station { /// /// BOPP扫码入库 /// [WorkTitle(typeof(BOPPHandler), "BOPP扫码入库")] public class Bopp扫码入库 : Work { protected override void Do(StationDeviceGroup obj) { obj.EX(stationDeviceGroup => { if (!stationDeviceGroup.BcrStationIsForbid()) return; if (!SystemConfigHelpers.GetDeviceConfig(obj.Entity.CODE)) throw new WarnException($"已禁止{obj.Entity.CODE}入库,请联系相关人员查询"); //设备组无论单卷还是双卷都必须满足的条件 if (stationDeviceGroup.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) { InfoLog.INFO_WarnDb($"等待任务执行--凭证号不一致", obj.Entity.CODE, WCS_EXCEPTIONTYPE.设备异常); return; } if (stationDeviceGroup.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) { InfoLog.INFO_INFO($"设备运行中"); return; } //成功创建的任务 var finishTaskList = new List>(); //创建对应的任务 DB.Do(db => { var devise = stationDeviceGroup.GetBcrValid(); if (!devise.Valid(stationDeviceGroup.Entity.CODE)) return; var infos = devise.GetWMSInTask(); foreach (var item in devise) { var dev = item.Station; var next = dev.Entity.GetPath("SRM"); var info = infos.FirstOrDefault(v => item.FinishCode.Contains(v.ContainerCode + "}")); if (db.Default.Set().AsNoTracking().Any(v => v.BARCODE == info.ContainerCode && v.STATUS < TaskStatus.已完成 && v.TYPE == TaskType.入库)) throw new WarnException($"生产条码{info?.ContainerCode}存在未完成任务,请检查是否为标签卡重复使用"); var task = new WCS_TASK { BARCODE = info?.ContainerCode, TYPE = TaskType.入库, STATUS = TaskStatus.执行中, ADDRFROM = dev.Entity.CODE, ADDRTO = info?.EndPostion, STARTTIME = DateTime.Now, UPDATEUSER = "WCS", UPDATETIME = DateTime.Now, WMSTASK = int.Parse(info?.WMSTaskNum!), TaskGroupKey = info?.TaskGroupKey, ADDRNEXT = next.CODE, HEIGHT = dev.Data2.GoodsSize, FLOOR = 2 }; db.Default.Set().Add(task); finishTaskList.Add(new FinishTaskList(task.WMSTASK, item.Station)); } //两个任务一起创建 db.Default.SaveChanges(); }); //检查对应的任务是否已创建成功 DB.Do(db => { foreach (var finishTask in finishTaskList) { var task = db.Default.Set().FirstOrDefault(v => v.WMSTASK == finishTask.FinishCode); if (task == null) continue; finishTask.Station.Data.Tasknum = task.ID; finishTask.Station.Data.Goodsstart = task.ADDRFROM.ToShort(); finishTask.Station.Data.Goodsend = task.ADDRNEXT.ToShort(); finishTask.Station.Data.Goodsnum = finishTaskList.Count.ToShort(); finishTask.Station.Data.CmdType = IstationCmdType.扫码入库; finishTask.Station.Data.VoucherNo++; task.CreateStatusLog(db, $"任务已下发给输送机[{task.ADDRFROM}]执行,起始地址[{task.ADDRFROM}],目标地址[{task.ADDRNEXT}]", this.GetType()); } db.Default.SaveChanges(); }); }); } protected override bool SelectDevice(WCS_DEVICE dev) { return dev.CODE == "G1157"; } } /// /// BOPP巷道分配 /// //[WorkTitle(typeof(BOPPHandler), "BOPP巷道分配")] public class Bopp巷道分配 : Work { protected override void Do(StationDeviceGroup obj) { obj.EX(stationDeviceGroup => { var code = stationDeviceGroup.Entity.CODE; //两个设备都必须满足的条件 if (stationDeviceGroup.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) throw new WarnException($"等待任务执行--凭证号不一致"); if (stationDeviceGroup.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) throw new WarnException($"设备运行中"); //成功分配巷道的任务的任务 var finishTaskList = new List>(); //变更数据库信息 DB.Do(db => { var devise = stationDeviceGroup.GetAddressValid(); if (!devise.Any()) return; //无可执行任务 var taskList = devise.ValidTaskCheck(db); //开始变更任务信息 foreach (var item in devise) { var dev = Device.Find(item.Station.Entity.CODE).Create(); var task = taskList.FirstOrDefault(p => p.ID == dev.Data2.Tasknum); if (task == null) throw new WarnException($"WCS无该任务{dev.Data2.Tasknum}--{dev.Entity.CODE}"); string from = "G"; from = obj.Entity.CODE == "G23" ? "G23" : "G19"; finishTaskList.Add(new FinishTaskList(task.ID, item.Station)); } }); // 开始将任务信息写入到设备 DB.Do(db => { foreach (var finishTask in finishTaskList) { var task = db.Default.Set().Find(finishTask.FinishCode); if (task == null) { InfoLog.INFO_WarnDb($"WCS未找到任务{finishTask.FinishCode}", finishTask.Station.Entity.CODE, WCS_EXCEPTIONTYPE.设备异常); continue; } finishTask.Station.Data.Tasknum = task.ID; finishTask.Station.Data.Goodsstart = stationDeviceGroup.Entity.CODE.Replace("G", "").ToShort(); finishTask.Station.Data.Goodsend = 12; finishTask.Station.Data.Goodsnum = finishTaskList.Count.ToShort(); finishTask.Station.Data.CmdType = IstationCmdType.分配目标地址; finishTask.Station.Data.VoucherNo++; } }); }); } protected override bool SelectDevice(WCS_DEVICE dev) { return dev.CODE is "G23" or "G19"; } } /// /// 涂布入库旋转台二次分配巷道 /// [WorkTitle(typeof(BOPPHandler), "BOPP入库旋转台二次分配巷道")] public class Bopp入库旋转台二次分配巷道 : Work { protected override void Do(StationDeviceGroup obj) { obj.EX(stationDeviceGroup => { var code = stationDeviceGroup.Entity.CODE; //两个设备都必须满足的条件 if (stationDeviceGroup.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) throw new WarnException($"等待任务执行--凭证号不一致"); if (stationDeviceGroup.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) throw new WarnException($"设备运行中"); //成功分配巷道的任务的任务 var finishTaskList = new List>(); //变更数据库信息 DB.Do(db => { var devise = stationDeviceGroup.GetAddressValid(); if (!devise.Any()) return; //无可执行任务 var taskList = devise.ValidTaskCheck(db); var res = WMS.GetTunnelList(taskList.Select(v => v.WMSTASK.ToString()).ToList(), code); if (string.IsNullOrEmpty(res.TunnelNum)) throw new WarnException($"WMS未返回巷道"); var tunnelNo = res.TunnelNum.Split(',').Select(v => "TY" + v).ToList(); var tunnels = Device.Where(v => tunnelNo.Contains(v.CODE)).ToList(); var tunnelInfos = new List(); var setting = new JsonSerializerSettings(); setting.ReferenceLoopHandling = ReferenceLoopHandling.Ignore; setting.PreserveReferencesHandling = PreserveReferencesHandling.Objects; foreach (var item in tunnels) { //当前巷道的取货点 var allIn = Device.Where(v => v.Is(DF.SRMBOPP取货)) .Where(v => v.ROUTES.Any(p => p.NEXT.CODE == item.CODE)) //下一个点为当前巷道的取货点 .Select(v => v.CODE) .ToList(); //下一个目标地址包含取货点的设备,此时获得的数据是旋转台 var turntable = Device.Where(v => v.IsConv() && v.ROUTES.Any(p => p.NEXT != null && allIn.Contains(p.NEXT.CODE))) .Where(v => stationDeviceGroup.Items.Any(p => p.Entity == v))// 筛选出包含在当前设备组的设备 .Distinct() .FirstOrDefault();//去一次重 if (turntable == null) continue; var dev = Device.Where(p => p.CODE.StartsWith("G") && p.DEVICEGROUP.Any(d => allIn.Contains(d.MEMBER.CODE))).MinBy(p => p.CODE); tunnelInfos.Add(new TunnelInfo { Tunnel = item, taskIN = dev, //找到放货点设备所在组 SRM = Device.Where(p => p.IsSC()).FirstOrDefault(p => item.ROUTES.Any(d => d.NEXT.CODE == p.CODE)).Create() }); } //筛选出优先级最高的可用巷道 var tunnelInfo = tunnelInfos.Where(v => { try { return (v.SRM.Data3.SCAlarm == 0 && v.SRM.Data2.SRMMode == SCMode.远程 && v.SRM.Data2.SRMStatus == SCRunStatus.空闲) || v.SRM.Entity.CODE == "SRM1" || v.SRM.Entity.CODE == "SRM2"; } catch { return false; } }).MinBy(v => tunnelNo.IndexOf(v.Tunnel.CODE)); if (tunnelInfo == null) throw new WarnException("无可用巷道"); //开始变更任务信息 foreach (var item in devise) { var dev = Device.Find(item.Station.Entity.CODE).Create(); var task = taskList.FirstOrDefault(p => p.ID == dev.Data2.Tasknum); if (task == null) throw new WarnException($"WCS无该任务{dev.Data2.Tasknum}--{dev.Entity.CODE}"); task.DEVICE = tunnelInfo.SRM.Entity.CODE; task.TUNNEL = tunnelInfo.Tunnel.CODE; task.ADDRNEXT = dev.Entity.GetPath(task.DEVICE).CODE; task.TaskGroupKey = res.WMSTaskGroupKey; task.ADDRTO = task.DEVICE; //var msg = $"下达从{stationDeviceGroup.Entity.CODE}移动至{dev.Data.Goodsend}的PLC指令。同时将任务分配至[{task.TUNNEL}]-[{task.DEVICE}]"; //msg += $"[{dev.Data.Tasknum}][{stationDeviceGroup.Entity.CODE}][{dev.Data.Goodsend}][{tunnelInfo.SRM.Entity.CODE}][{dev.Data.VoucherNo}[{dev.Data2.VoucherNo}]"; var msg = $"任务二次分配巷道[{task.TUNNEL}]"; task.CreateStatusLog(db, msg, GetType()); finishTaskList.Add(new FinishTaskList(task.ID, item.Station)); } db.Default.SaveChanges(); }); // 开始将任务信息写入到设备 DB.Do(db => { foreach (var finishTask in finishTaskList) { var task = db.Default.Set().Find(finishTask.FinishCode); if (task == null) continue; finishTask.Station.Data.Tasknum = task.ID; finishTask.Station.Data.Goodsstart = stationDeviceGroup.Entity.CODE.Replace("G", "").ToShort(); finishTask.Station.Data.Goodsend = finishTask.Station.Entity.GetPath(task.DEVICE).CODE.ToShort(); finishTask.Station.Data.Goodsnum = finishTaskList.Count.ToShort(); finishTask.Station.Data.CmdType = IstationCmdType.分配目标地址; finishTask.Station.Data.VoucherNo++; } }); }); } protected override bool SelectDevice(WCS_DEVICE dev) { return _devCodes.Contains(dev.CODE); } private readonly List _devCodes = new() { "G1190", "G1199", "G1208" }; } }