using DBHelper;
using Microsoft.EntityFrameworkCore;
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;
namespace WCS.Service.Works.Station
{
///
/// 涂布入库AGV交互
///
[WorkTitle(typeof(CoatingHandler), "涂布入库AGV交互")]
public class 涂布入库AGV交互 : Work
{
protected override void Do(StationDeviceGroup obj)
{
obj.EX(obj =>
{
var station = obj.Entity.CODE;
#region 处理新增AGV任务
DB.Do(db =>
{
//找到所有的AGV任务
var agvTasks = db.Default.Set().Where(v => v.TaskType == AGVTaskType.入库)
.Where(v => v.Status < AGVTaskStatus.完成).ToArray();
foreach (var agvtask in agvTasks)
{
var position = agvtask.Position;
if (!ProtocolProxy.AllDatas.ContainsKey(position))
ProtocolProxy.AllDatas[position] = new ProdLineData();
var pld = ProtocolProxy.AllDatas[position] as ProdLineData;
pld.Frame = LogicHandler.Frame;
pld.Code = position;
pld.TaskList.Add(agvtask);
if (agvtask.Status == AGVTaskStatus.新建)
{
if (obj.Items.Any(v => !v.Data3.Status.HasFlag(StationStatus.自动))) continue;
//TODO:暂时不管控产线任务数
var qty = db.Default.Set().Where(v => v.TaskType == AGVTaskType.入库 && v.Status > AGVTaskStatus.新建 && v.Status < AGVTaskStatus.完成);
if (qty.Count() >= 10) //同时最多只能有10个任务被确认
{
throw new Exception($"{obj.Entity.CODE}正在执行的入库任务数量已达{qty},暂停入库");
}
if (qty.Count(v => v.Station == obj.Entity.CODE) > qty.Count(v => v.Station != obj.Entity.CODE)) continue;
agvtask.Station = obj.Entity.CODE;
agvtask.Status = AGVTaskStatus.确认;
agvtask.UpdateTime = DateTime.Now;
db.Default.SaveChanges();
}
else if (agvtask.Status == AGVTaskStatus.确认 && agvtask.Status > agvtask.AGVStatus)
{
//TODO:暂时直接执行,不再管控,后续如有需求,再行启用
//if (agvtask.Station != obj.Entity.CODE) continue;
//if (obj.Items.Any(v => !v.Data3.Status.HasFlag(StationStatus.高位))) continue;
//if (obj.Items.Any(v => !v.Data3.Status.HasFlag(StationStatus.自动))) continue;
//if (obj.Items.Any(v => v.Data2.Status.HasFlag(IstationStatus.光电状态))) continue;
//if (obj.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) continue;
//if (obj.Items.Any(v => v.Data2.Tasknum > 10000)) continue;
//暂时管控同一时间被执行的任务数为1
//if (db.Default.Set().Count(v => v.Status == AGVTaskStatus.执行 && v.Station == obj.Entity.CODE && v.ID != agvtask.ID) >= 2) continue;
agvtask.Status = AGVTaskStatus.执行;
agvtask.UpdateTime = DateTime.Now;
db.Default.SaveChanges();
}
else if (agvtask.Status < agvtask.AGVStatus)
{
if (agvtask.Station != obj.Entity.CODE) continue;
if (agvtask.AGVStatus == AGVTaskStatus.请求_允许)
{
if (obj.Items.Any(v => !v.Data3.Status.HasFlag(StationStatus.高位))) continue;
if (obj.Items.Any(v => !v.Data3.Status.HasFlag(StationStatus.自动))) continue;
if (obj.Items.Any(v => v.Data2.Status.HasFlag(IstationStatus.光电状态))) continue;
if (obj.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) continue;
if (obj.Items.Any(v => v.Data2.Tasknum > 10000)) continue;
if (db.Default.Set().Any(v => v.Station == agvtask.Station && v.Status == agvtask.AGVStatus && v.ID != agvtask.ID)) continue;
agvtask.Status = agvtask.AGVStatus;
agvtask.UpdateTime = DateTime.Now;
db.Default.SaveChanges();
}
else if (agvtask.AGVStatus == AGVTaskStatus.取放完成)
{
if (obj.Items.Any(v => v.Data2.Status.HasFlag(IstationStatus.AGV放货完成信号))) throw new WarnException("顶升下降信号未清除");
if (!obj.Items.Any(v => v.Data2.Status.HasFlag(IstationStatus.光电状态))) throw new WarnException("放货完成设备无光电");
agvtask.Status = agvtask.AGVStatus;
agvtask.UpdateTime = DateTime.Now;
db.Default.SaveChanges();
foreach (var dev in obj.Items)
{
if (dev.Data2.Status.HasFlag(IstationStatus.光电状态))
{
dev.Data.Goodsnum = (short)agvtask.Goodsnum;
dev.Data.Istation521Status = IstationStatus.AGV放货完成信号;
}
}
}
else if (Ltc.Do(agvtask, v => v.AGVStatus == AGVTaskStatus.完成))
{
//if (agvtask.Status != AGVTaskStatus.取放完成) throw new WarnException("RGV未上报取放完成状态,不允许跳状态");
agvtask.Status = agvtask.AGVStatus;
agvtask.UpdateTime = DateTime.Now;
db.Default.SaveChanges();
var devs = Device.Find(agvtask.Station).Create();
foreach (var dev in devs.Items)
{
dev.Data.Goodscode = agvtask.ID;
}
}
else if (Ltc.Do(agvtask, v => v.AGVStatus == AGVTaskStatus.取消))
{
agvtask.Status = agvtask.AGVStatus;
agvtask.UpdateTime = DateTime.Now;
db.Default.SaveChanges();
}
}
}
});
#endregion 处理新增AGV任务
});
}
protected override bool SelectDevice(WCS_DEVICE dev)
{
//return dev.CODE == "G1386";
return dev.CODE == "G1394" || dev.CODE == "G1386";
}
}
///
/// 涂布扫码入库
///
[WorkTitle(typeof(CoatingHandler), "涂布入库")]
public class 涂布扫码入库 : Work
{
protected override void Do(StationDeviceGroup obj)
{
var now = DateTime.Now;
obj.EX(obj =>
{
//设备组无论单卷还是双卷都必须满足的条件
if (obj.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) throw new WarnException($"等待任务执行--凭证号不一致");
if (obj.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) throw new WarnException($"设备运行中");
if (obj.Items.Any(v => !v.Data3.Status.HasFlag(StationStatus.低位))) throw new DoException("不在低位");
//成功创建的任务
var finishTaskList = new List>();
//创建对应的任务
DB.Do(db =>
{
var devs = obj.GetBcrValid();
devs.Valid();
var infos = devs.GetWMSInTask();
var agvTask = db.Default.Set().Where(v => v.ID == devs[0].Station.Data.Goodscode).FirstOrDefault() ?? throw new WarnException("无完成AGV任务");
if (agvTask.Status != AGVTaskStatus.完成扫码)
{
agvTask.Status = AGVTaskStatus.完成扫码;
agvTask.UpdateTime = DateTime.Now;
}
foreach (var item in devs)
{
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();
task.BARCODE = info.ContainerCode;
task.TYPE = TaskType.入库;
task.STATUS = TaskStatus.执行中;
task.ADDRFROM = dev.Entity.CODE;
task.ADDRTO = info.EndPostion;
task.STARTTIME = DateTime.Now;
task.UPDATEUSER = "WCS";
task.UPDATETIME = DateTime.Now;
task.WMSTASK = int.Parse(info.WMSTaskNum);
task.TaskGroupKey = info.TaskGroupKey;
task.ADDRNEXT = next.CODE;
task.HEIGHT = dev.Data2.GoodsSize;
task.AgvTask = agvTask.ID;
db.Default.Set().Add(task);
finishTaskList.Add(new FinishTaskList { FinishCode = task.WMSTASK, Station = item.Station });
var msg = $"下达从{dev.Entity.CODE}移动至{next}的PLC指令。";
msg += $"[{dev.Data.Tasknum}][{dev.Data.Goodsstart}][{dev.Data.Goodsend}][{dev.Data.VoucherNo}[{dev.Data2.VoucherNo}]";
task.CreateStatusLog(db, msg, this.GetType());
}
//两个任务一起创建
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 = (short)finishTaskList.Count;
finishTask.Station.Data.CmdType = IstationCmdType.扫码入库;
finishTask.Station.Data.VoucherNo++;
}
InfoLog.INFO_TIMING($"{obj.Entity.CODE}--扫码入库,耗时{(DateTime.Now - now).TotalMilliseconds}");
});
});
}
protected override bool SelectDevice(WCS_DEVICE dev)
{
return dev.CODE == "G1386" || dev.CODE == "G1394";
//return dev.CODE == "1386" || dev.CODE == "1387" || dev.CODE == "1394" || dev.CODE == "1395";
}
}
///
/// 涂布入库分配巷道
///
[WorkTitle(typeof(CoatingHandler), "涂布入库分配巷道")]
public class 涂布入库分配巷道 : Work
{
protected override void Do(StationDeviceGroup obj)
{
obj.EX(obj =>
{
var code = obj.Entity.CODE;
//两个设备都必须满足的条件
if (obj.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) return;
if (obj.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) return;
//成功分配巷道的任务的任务
var finishTaskList = new List>();
//变更数据库信息
DB.Do(db =>
{
var devs = obj.Items.Where(v => v.Data2.Status.HasFlag(IstationStatus.光电状态) && v.Data2.Request == IstationRequest.请求分配目标地址)
.Where(v => v.Data2.Tasknum > 10000 && v.Data2.Goodsend != 0);
if (!devs.Any()) return; //无可执行任务
var taskIds = devs.Select(dev => dev.Data2.Tasknum).ToList();
var taskList = db.Default.Set().Where(v => taskIds.Contains(v.ID)).ToList();
taskList.ValidTaskCheck(devs.Count(), 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();
List tunnelInfos = new List();
foreach (var item in tunnels)
{
//当前巷道的取货点
var allIn = Device.Where(v => v.Is(DF.SRM涂布取货)) //二楼所有取货点
.Where(v => v.ROUTES.Any(p => p.NEXT == item)) //下一个点为当前巷道的取货点
.Select(v => v.CODE)
.ToList();
//下一个目标地址包含取货点的设备,此时获得的数据是旋转台
var turntable = Device.Where(v => v.IsConv() && v.ROUTES.Any(p => p.NEXT != null && allIn.Contains(p.NEXT.CODE))).Select(v => v.CODE);
//获得RGV的交货点
var rgvDeliveryPoint = Device.Where(v => v.IsConv() && v.ROUTES.Any(p => p.NEXT != null && turntable.Contains(p.NEXT.CODE)))
.Select(v => v.Create()) //取所有可以到达取货点设备的信息
.Where(v => !v.Data3.Status.HasFlag(StationStatus.运行状态位) && !v.Data2.Status.HasFlag(IstationStatus.光电状态) && v.Data2.Tasknum < 10000)//筛选出空闲的路径点,此处因输送机都是一个动力,因此可以先找路径点再找设备组
.Distinct()
.FirstOrDefault();//去一次重
if (rgvDeliveryPoint == null) continue;
var taskInStation = Device.Where(p => p.CODE.StartsWith("G") && p.DEVICEGROUP.Any(d => d.MEMBER == rgvDeliveryPoint.Entity)).OrderBy(p => p.CODE).FirstOrDefault();
//RGV是否有正在前往这个地址的任务
var rgvList = Device.Where(v => v.Is(DF.涂布RGV)).Select(v => v.Create());
if (rgvList.Any(v => !v.Data2.SystemStatus.HasFlag(WCS.Entity.Protocol.RGV.RGVRunStatus.空闲)
&& !v.Data2.WorkMode.HasFlag(WCS.Entity.Protocol.RGV.RGVMode.自动)
&& v.Data2.TaskType_1 == WCS.Entity.Protocol.RGV.RGVTaskType.放货
&& v.Data2.DestPosition_1 == taskInStation.CODE.Replace("G", "").ToShort())) continue;
tunnelInfos.Add(new TunnelInfo
{
Tunnel = item,
taskIN = taskInStation, //找到放货点设备所在组
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.空闲; } catch { return false; } })
.Where(v => !db.Default.Set().Any(p => p.Priority > 0 && p.DEVICE == v.SRM.Entity.CODE && p.STATUS < TaskStatus.堆垛机完成))
.OrderBy(v => tunnelNo.IndexOf(v.Tunnel.CODE)).FirstOrDefault();
if (tunnelInfo == null) throw new WarnException("无可用巷道");
//开始变更任务信息
foreach (var item in devs)
{
var dev = Device.Find(item.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 = tunnelInfo.taskIN.CODE;
task.TaskGroupKey = res.WMSTaskGroupKey;
task.ADDRTO = task.DEVICE;
var msg = $"下达从{obj.Entity.CODE}移动至{dev.Data.Goodsend}的PLC指令。同时将任务分配至[{ task.TUNNEL }]-[{task.DEVICE}]";
msg += $"[{dev.Data.Tasknum}][{obj.Entity.CODE}][{dev.Data.Goodsend}][{tunnelInfo.SRM.Entity.CODE}][{dev.Data.VoucherNo}[{dev.Data2.VoucherNo}]";
task.CreateStatusLog(db, msg, this.GetType());
finishTaskList.Add(new Tuple(task.ID, item.Entity.Create()));
}
db.Default.SaveChanges();
});
// 开始将任务信息写入到设备
DB.Do(db =>
{
foreach (var finishTask in finishTaskList)
{
var task = db.Default.Set().Find(finishTask.Item1);
if (task == null) continue;
finishTask.Item2.Data.Tasknum = task.ID;
finishTask.Item2.Data.Goodsstart = obj.Entity.CODE.Replace("G", "").ToShort();
finishTask.Item2.Data.Goodsend = task.ADDRNEXT.Replace("G", "").ToShort();
finishTask.Item2.Data.Goodsnum = (short)finishTaskList.Count;
finishTask.Item2.Data.CmdType = IstationCmdType.分配目标地址;
finishTask.Item2.Data.VoucherNo++;
}
});
});
}
protected override bool SelectDevice(WCS_DEVICE dev)
{
return dev.CODE == "G2" || dev.CODE == "G3";
}
}
///
/// 涂布入库旋转台二次分配巷道
///
[WorkTitle(typeof(CoatingHandler), "涂布入库旋转台二次分配巷道")]
public class 涂布入库旋转台二次分配巷道 : Work
{
protected override void Do(StationDeviceGroup obj)
{
obj.EX(obj =>
{
var code = obj.Entity.CODE;
//两个设备都必须满足的条件
if (obj.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) return;
if (obj.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) return;
//成功分配巷道的任务的任务
var finishTaskList = new List>();
//变更数据库信息
DB.Do(db =>
{
var devs = obj.Items.Where(v => v.Data2.Status.HasFlag(IstationStatus.光电状态) && v.Data2.Request == IstationRequest.请求分配目标地址)
.Where(v => v.Data2.Tasknum > 10000);
if (!devs.Any()) return; //无可执行任务
var taskIds = devs.Select(dev => dev.Data2.Tasknum).ToList();
var taskList = db.Default.Set().Where(v => taskIds.Contains(v.ID)).ToList();
taskList.ValidTaskCheck(devs.Count(), 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();
List tunnelInfos = new List();
foreach (var item in tunnels)
{
//当前巷道的取货点
var allIn = Device.Where(v => v.Is(DF.SRM涂布取货)) //一楼所有取货点
.Where(v => v.ROUTES.Any(p => p.NEXT == item)) //下一个点为当前巷道的取货点
.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 => obj.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 => d.MEMBER == turntable)).OrderBy(p => p.CODE).FirstOrDefault();
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.空闲; } catch { return false; } })
.OrderBy(v => tunnelNo.IndexOf(v.Tunnel.CODE)).FirstOrDefault();
if (tunnelInfo == null) throw new WarnException("无可用巷道");
//开始变更任务信息
foreach (var item in devs)
{
var dev = Device.Find(item.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 = tunnelInfo.taskIN.CODE;
task.TaskGroupKey = res.WMSTaskGroupKey;
task.ADDRTO = task.DEVICE;
var msg = $"下达从{obj.Entity.CODE}移动至{dev.Data.Goodsend}的PLC指令。同时将任务分配至[{ task.TUNNEL }]-[{task.DEVICE}]";
msg += $"[{dev.Data.Tasknum}][{obj.Entity.CODE}][{dev.Data.Goodsend}][{tunnelInfo.SRM.Entity.CODE}][{dev.Data.VoucherNo}[{dev.Data2.VoucherNo}]";
task.CreateStatusLog(db, msg, this.GetType());
finishTaskList.Add(new Tuple(task.ID, item.Entity.Create()));
}
db.Default.SaveChanges();
});
// 开始将任务信息写入到设备
DB.Do(db =>
{
foreach (var finishTask in finishTaskList)
{
var task = db.Default.Set().Find(finishTask.Item1);
if (task == null) continue;
finishTask.Item2.Data.Tasknum = task.ID;
finishTask.Item2.Data.Goodsstart = obj.Entity.CODE.Replace("G", "").ToShort();
finishTask.Item2.Data.Goodsend = finishTask.Item2.Entity.GetPath(task.DEVICE).CODE.ToShort();
finishTask.Item2.Data.Goodsnum = (short)finishTaskList.Count;
finishTask.Item2.Data.CmdType = IstationCmdType.分配目标地址;
finishTask.Item2.Data.VoucherNo++;
}
});
});
}
protected override bool SelectDevice(WCS_DEVICE dev)
{
return devCodes.Contains(dev.CODE);
}
private List devCodes = new List() {
"G1404",
"G1413",
"G1420",
"G1429",
};
}
}