using Microsoft.AspNetCore.DataProtection.KeyManagement;
using Newtonsoft.Json;
using PlcSiemens.Core.Extension;
using ServiceCenter.Extensions;
using ServiceCenter.Logs;
using ServiceCenter.Redis;
using ServiceCenter.SqlSugars;
using SqlSugar;
using System.ComponentModel;
using WCS.Core;
using WCS.Entity;
using WCS.Entity.Protocol.SRM;
using WCS.Entity.Protocol.Station;
using WCS.WorkEngineering.Extensions;
using WCS.WorkEngineering.WebApi.Controllers;
using WCS.WorkEngineering.Worlds;
using static System.Runtime.InteropServices.JavaScript.JSType;
using DeviceFlags = WCS.WorkEngineering.Extensions.DeviceFlags;
namespace WCS.WorkEngineering.Systems
{
///
/// Agv交互系统
///
[BelongTo(typeof(AgvWorld))]
[Description("Agv交互系统")]
public class AgvSystems : DeviceSystem
{
protected override bool ParallelDo => true;
protected override bool SaveLogsToFile => true;
private List devs = new List();
private List srms = new List();
public AgvSystems()
{
var stations = new List() { "1011", "1012", "1013", "1014", "1015", "1016", "1021", "1022", "1023", "1024", "1025", "1026", "1117", "1118",
"1131", "1132", "1133", "1134", "1135", "1136", "1137", "1138", "1139","1127" };
devs = Device.All.Where(v => stations.Contains(v.Code)).Select(v => new Station(v, this.World)).ToList();
srms = Device.All.Where(v => v.Code is "SRM1" or "SRM2" or "SRM3" or "SRM4").Select(v => new SRM(v, this.World)).ToList();
}
public override void Do(Station obj)
{
if (obj.Entity.Code == "1018"/*.HasFlag(DeviceFlags.出库)*/)
{
List agvTaskInfos = new List();
//获取所有未结束的叫料及背负式补空AGV任务
SqlSugarHelper.Do(db =>
{
agvTaskInfos = db.Default.Queryable().Where(v => (v.TaskType == AGVTaskType.CallMaterial || v.TaskType == AGVTaskType.CallForMaterial || v.TaskType == AGVTaskType.ForkliftFilling))
.Where(v => v.Status < AGVTaskStatus.MissionCompleted)
.SplitTable(tabs => tabs.Take(2)).OrderBy(v => v.AddTime).ToList();
});
//有需要处理的AGV任务
if (agvTaskInfos.Any())
{
//this.ExRecord(obj.Entity.Code, "可用出库AGV任务列表", agvTaskInfos.Select(v => v.ID).ToList());
//List taskInfos = new List();
foreach (var agv in agvTaskInfos)
{
try
{
SqlSugarHelper.Do(db =>
{
//取货点安全交互
if (agv.AgvStatus == AGVTaskStatus.RequestOrPermission2 && agv.Status != AGVTaskStatus.Complete2)
{
var taskInfo = db.Default.Queryable().First(v => v.AgvTaskID == agv.ID);
agv.Status = AGVTaskStatus.Complete2;
db.Default.Updateable(agv).SplitTable(x => x.Take(2)).ExecuteCommand();
taskInfo.AddWCS_TASK_DTL(db, "agv", $"允许AGV任务{agv.ID}在站台{agv.Station}取货");
AgvApi.ContinueTask(agv.AgvID, agv.Station);
}
//完成任务
else if (agv.AgvStatus == AGVTaskStatus.MissionCompleted && agv.Status != AGVTaskStatus.MissionCompleted)
{
if (agv.TaskType is AGVTaskType.CallForMaterial or AGVTaskType.ForkliftFilling or AGVTaskType.CallMaterial)
{
var taskInfo = db.Default.Queryable().First(v => v.AgvTaskID == agv.ID);
if (taskInfo == null) throw new Exception($"未找到AGV任务{agv.ID}对应WCS任务");
//更新AGV任务状态
agv.Status = AGVTaskStatus.MissionCompleted;
db.Default.Updateable(agv).SplitTable(x => x.Take(2)).ExecuteCommand();
//更新WCS任务状态
taskInfo.Status = Entity.TaskStatus.Finish;
taskInfo.EedTime = DateTime.Now;
db.Default.Updateable(taskInfo).ExecuteCommand();
taskInfo.AddWCS_TASK_DTL(db, "agv", "任务完成");
//通知WMS任务完成
WmsApi.CompleteTask(taskInfo.ID);
taskInfo.CompleteOrCancelTasks(db);
//taskInfos.Add(taskInfo);
}
else
{
agv.Status = AGVTaskStatus.MissionCompleted;
db.Default.Updateable(agv).SplitTable(x => x.Take(2)).ExecuteCommand();
}
}
});
}
catch (Exception ex)
{
World.Log(ex.Message, LogLevelEnum.Mid);
this.ExRecord(obj.Entity.Code, ex.Message);
continue;
}
}
//foreach (var item in taskInfos)
//{
// WmsApi.CompleteTask(item.ID);
//}
}
}
else if (obj.Entity.Code == "1017"/*.HasFlag(DeviceFlags.入库)*/)
{
List agvTaskInfos = new List();
//获取所有未结束的入库AGV任务
SqlSugarHelper.Do(db =>
{
agvTaskInfos = db.Default.Queryable().Where(v => v.Status < AGVTaskStatus.MissionCompleted && v.TaskType == AGVTaskType.EnterDepot).SplitTable(tabs => tabs.Take(2)).OrderBy(v => v.EditTime).ToList();
});
if (agvTaskInfos.Any())
{
//this.ExRecord(obj.Entity.Code, "可用入库AGV任务列表", agvTaskInfos.Select(v => v.ID).ToList());
var guid = Guid.NewGuid();
World.Log($"agv任务处理:开始[{guid}]", LogLevelEnum.Mid);
foreach (var agv in agvTaskInfos)
{
try
{
int isApplyContainue = 0;
string agvid = "";
string nextpos = "";
SqlSugarHelper.Do(db =>
{
//找到对应WCS任务
//var task = db.Default.Queryable().First(v => v.AgvTaskID == agv.ID);
//if (task == null) throw new Exception($"AGV任务{agv.ID}未找到对应WCS任务");
var agvInfo = db.Default.Queryable().Where(x => x.ID == agv.ID).SplitTable(s => s.Take(3)).First();
#region 开始跟据AGV状态做出处理
//巷道分配
if (agvInfo.AgvStatus == AGVTaskStatus.RequestOrPermission1 && agvInfo.Status != AGVTaskStatus.Complete1)
{
//找到对应WCS任务
var task = db.Default.Queryable().First(v => v.AgvTaskID == agvInfo.ID);
if (task == null) throw new Exception($"AGV任务{agvInfo.ID}未找到对应WCS任务");
this.ExRecord(obj.Entity.Code, $"AGV任务{agvInfo.ID}开始进行巷道分配");
//向WMS获取巷道优先级'
var res = WmsApi.GetTunnelPriorityList(task.ID);
this.ExRecord(obj.Entity.Code, $"AGV任务{agvInfo.ID},WMS返回巷道优先级{res.ResData}");
var tunnelNo = res.ResData.Split(",").Select(v => "SRM" + v).ToList();
//开始获取堆垛机与可用站台信息
SRM srm = null;
List stations = new List();
if (task.Floor == 1) //一楼
{
//一楼三个入库口 新增一个巷道,两个入库口
//proline 6-12
if (agvInfo.WorkShop == 1138)
{
stations = devs.Where(v => v.Entity.Code is "1138").ToList();
//过滤有任务的站台
var taskinstations = db.Default.Queryable().Where(v => v.TaskType == AGVTaskType.EnterDepot && v.Status < AGVTaskStatus.MissionCompleted && (v.Position == "1138")).SplitTable(v => v.Take(2)).Select(v => v.Position).ToList();
stations = stations.Where(p => !taskinstations.Contains(p.Entity.Code)).ToList();
//筛选出可用站台
stations = stations.Where(v => v.Data.VoucherNo == v.Data2.VoucherNo && v.Data3.Status.HasFlag(StatusEunm.Auto))
.Where(v => !v.Data3.Status.HasFlag(StatusEunm.PH_Status) && !v.Data3.Status.HasFlag(StatusEunm.OT_Status))
.Where(v => !v.Data3.Status.HasFlag(StatusEunm.Run)).ToList(); // 筛选出可用站台
//可用堆垛机
srm = stations.Select(v => v.Entity.Sources).SelectMany(v => v).Where(v => v.IsTunnel()) //上一个地址是巷道的
.Select(v => v.Sources).SelectMany(v => v).Where(v => v.HasProtocol(typeof(ISRM520))) //筛选出堆垛机
.Select(v => new SRM(v, this.World)) //转换为SRM
.Where(v => v != null && !v.Data2.Status.HasFlag(SrmStatus.Alarm) && v.Data2.AutoStatus == SrmAutoStatus.Automatic) //筛选出可用堆垛机
.Where(v => tunnelNo.Contains(v.Entity.Code)) //筛选出巷道优先级最高的堆垛机
.MinBy(v => tunnelNo.IndexOf(v.Entity.Code));//按照巷道优先级排序
if (srm == null)
{
stations = devs.Where(v => v.Entity.Code is "1011" or "1013" or "1015" or "1117").ToList();
//过滤有任务的站台
var taskinstations1 = db.Default.Queryable().Where(v => v.TaskType == AGVTaskType.EnterDepot && v.Status < AGVTaskStatus.MissionCompleted && (v.Position == "1011" || v.Position == "1013" || v.Position == "1015" || v.Position == "1117")).SplitTable(v => v.Take(2)).Select(v => v.Position).ToList();
stations = stations.Where(p => !taskinstations1.Contains(p.Entity.Code)).ToList();
//筛选出可用站台
stations = stations.Where(v => v.Data.VoucherNo == v.Data2.VoucherNo && v.Data3.Status.HasFlag(StatusEunm.Auto))
.Where(v => !v.Data3.Status.HasFlag(StatusEunm.PH_Status) && !v.Data3.Status.HasFlag(StatusEunm.OT_Status))
.Where(v => !v.Data3.Status.HasFlag(StatusEunm.Run)).ToList(); // 筛选出可用站台
//可用堆垛机
srm = stations.Select(v => v.Entity.Sources).SelectMany(v => v).Where(v => v.IsTunnel()) //上一个地址是巷道的
.Select(v => v.Sources).SelectMany(v => v).Where(v => v.HasProtocol(typeof(ISRM520))) //筛选出堆垛机
.Select(v => new SRM(v, this.World)) //转换为SRM
.Where(v => v != null && !v.Data2.Status.HasFlag(SrmStatus.Alarm) && v.Data2.AutoStatus == SrmAutoStatus.Automatic) //筛选出可用堆垛机
.Where(v => tunnelNo.Contains(v.Entity.Code)) //筛选出巷道优先级最高的堆垛机
.MinBy(v => tunnelNo.IndexOf(v.Entity.Code));//按照巷道优先级排序
}
}
else
{
stations = devs.Where(v => v.Entity.Code is "1011" or "1013" or "1015" or "1117").ToList();
//过滤有任务的站台
var taskinstations = db.Default.Queryable().Where(v => v.TaskType == AGVTaskType.EnterDepot && v.Status < AGVTaskStatus.MissionCompleted && (v.Position == "1011" || v.Position == "1013" || v.Position == "1015" || v.Position == "1117")).SplitTable(v => v.Take(2)).Select(v => v.Position).ToList();
stations = stations.Where(p => !taskinstations.Contains(p.Entity.Code)).ToList();
//筛选出可用站台
stations = stations.Where(v => v.Data.VoucherNo == v.Data2.VoucherNo && v.Data3.Status.HasFlag(StatusEunm.Auto))
.Where(v => !v.Data3.Status.HasFlag(StatusEunm.PH_Status) && !v.Data3.Status.HasFlag(StatusEunm.OT_Status))
.Where(v => !v.Data3.Status.HasFlag(StatusEunm.Run)).ToList(); // 筛选出可用站台
this.ExRecord(obj.Entity.Code, $"AGV任务{agvInfo.ID},可用放货站台", stations.Select(v => v.Entity.Code).ToList());
//可用堆垛机
srm = stations.Select(v => v.Entity.Sources).SelectMany(v => v).Where(v => v.IsTunnel()) //上一个地址是巷道的
.Select(v => v.Sources).SelectMany(v => v).Where(v => v.HasProtocol(typeof(ISRM520))) //筛选出堆垛机
.Select(v => new SRM(v, this.World)) //转换为SRM
.Where(v => v != null && !v.Data2.Status.HasFlag(SrmStatus.Alarm) && v.Data2.AutoStatus == SrmAutoStatus.Automatic) //筛选出可用堆垛机
.Where(v => tunnelNo.Contains(v.Entity.Code)) //筛选出巷道优先级最高的堆垛机
.MinBy(v => tunnelNo.IndexOf(v.Entity.Code));//按照巷道优先级排序
}
}
else //二楼
{
//二楼三个入库口 新增一个巷道,1个入库口
stations = devs.Where(v => v.Entity.Code is "1021" or "1023" or "1025" or "1127").ToList();
//过滤有任务的站台
var taskinstations = db.Default.Queryable().Where(v => v.TaskType == AGVTaskType.EnterDepot && v.Status < AGVTaskStatus.MissionCompleted && (v.Position == "1021" || v.Position == "1023" || v.Position == "1025" || v.Position == "1127")).SplitTable(v => v.Take(2)).Select(v => v.Position).ToList();
stations = stations.Where(p => !taskinstations.Contains(p.Entity.Code)).ToList();
//筛选出可用站台
stations = stations.Where(v => v.Data.VoucherNo == v.Data2.VoucherNo && v.Data3.Status.HasFlag(StatusEunm.Auto))
.Where(v => !v.Data3.Status.HasFlag(StatusEunm.PH_Status) && !v.Data3.Status.HasFlag(StatusEunm.OT_Status))
.Where(v => !v.Data3.Status.HasFlag(StatusEunm.Run)).ToList(); // 筛选出可用站台
//var putS1 = stations.Select(v => v.Entity.Code);
var dev = devs.Find(v => v.Entity.Code == "1127");
World.Log($"放货站台1127信号凭证号{dev.Data.VoucherNo}-{dev.Data2.VoucherNo}-自动{dev.Data3.Status.HasFlag(StatusEunm.Auto)}-光电{dev.Data3.Status.HasFlag(StatusEunm.PH_Status)}-有货光电{dev.Data3.Status.HasFlag(StatusEunm.OT_Status)}-{dev.Data3.Status.HasFlag(StatusEunm.Run)}");
this.ExRecord(obj.Entity.Code, $"AGV任务{agvInfo.ID},可用放货站台", stations.Select(v => v.Entity.Code).ToList());
//可用堆垛机
srm = stations.Select(v => v.Entity.Sources).SelectMany(v => v).Where(v => v.IsTunnel()) //上一个地址是巷道的
.Select(v => v.Sources).SelectMany(v => v).Where(v => v.HasProtocol(typeof(ISRM520))) //筛选出堆垛机
.Select(v => new SRM(v, this.World)) //转换为SRM
.Where(v => v != null && !v.Data2.Status.HasFlag(SrmStatus.Alarm) && v.Data2.AutoStatus == SrmAutoStatus.Automatic) //筛选出可用堆垛机
.Where(v => tunnelNo.Contains(v.Entity.Code)) //筛选出巷道优先级最高的堆垛机
.MinBy(v => tunnelNo.IndexOf(v.Entity.Code));//按照巷道优先级排序
}
if (srm == null) throw new Exception($"agv任务{agvInfo.ID}无可用堆垛机");
//筛选出堆垛机的放货站台
var nextPos = stations.FirstOrDefault(v => v.Entity.Sources.Where(t => t.IsTunnel()).Select(t => t.Sources).SelectMany(v => v) //获取所有巷道
.Where(t => t.HasProtocol(typeof(ISRM520)))//筛选出堆垛机
.SelectMany(v => v.Sources).Any(t => t.Code == srm.Entity.Parent.Code));
this.ExRecord(obj.Entity.Code, $"AGV任务{agvInfo.ID},放货站台{nextPos}");
bool flag = false;
var agvs = db.Default.Queryable().Where(v => v.Status < AGVTaskStatus.MissionCompleted && v.Position == nextPos.Entity.Code).SplitTable(v => v.Take(2)).ToList();
if (agvs.Any())
{
var msg = "已无可用放货站台,任务正在执行中:";
foreach (var ag in agvs)
{
msg = msg + $"[任务号:{ag.ID},目标地址:{ag.Position}]";
}
throw new Exception(msg);
}
//wcs任务状态卡控,防止因光电异常误判
if (db.Default.Queryable().Any(v => v.AddrNext == nextPos.Entity.Code && v.Status == Entity.TaskStatus.ConveyorExecution)) return;
//if (db.Default.Queryable().SplitTable(v => v.Take(2)).Any(v => v.NextPoint == nextPos.Entity.Code && v.Desc.Contains("任务分配至堆垛机"))) return;
if (RedisHub.Default.Get("TaskTun:" + task.ID) != null && RedisHub.Default.Get("TaskTun:" + task.ID) != nextPos.Entity.Code)
{
throw new Exception("WCS任务:" + task.ID + "已经分配过巷道,不允许重新分配不同巷道");
}
if (task.BusType == "二楼湿拉空轮回立库")
{
//获取在途任务
var n = db.Default.Queryable().Count(v => v.BusType == "二楼湿拉空轮回立库" && v.Status == Entity.TaskStatus.AGVExecution && v.AddrTo == "srm" && v.AddrNext == null);
var config = db.Default.Queryable().First(v => v.Code == "MaxAgvTaskNum");
if (nextPos.Entity.Code != "1127" && config != null && config.SContent.ToShort() > n)
{
throw new Exception($"当前在途任务数{n}不足{config.SContent.ToShort()},需在此等待或修改配置数量");
}
}
//更新AGV任务状态
agvInfo.Status = AGVTaskStatus.Complete1;
//agv.Position = flag == true ? "1025" : nextPos.Entity.Code;
agvInfo.Position = nextPos.Entity.Code;
var upres1 = db.Default.Updateable(agvInfo).SplitTable(x => x.Take(2)).ExecuteCommand();
//更新WCS任务状态
//if (flag)
//{
// srm.Entity.Code = "SRM3";
// task.Device = srm.Entity.Code;
// task.Tunnel = "3";
// task.AddrNext = "1025";
// task.SrmStation = "1025";
//}
//else
{
task.Device = srm.Entity.Code;
task.Tunnel = task.Device.GetLastDigit().ToString();
task.AddrNext = agvInfo.Position;
task.SrmStation = nextPos.Entity.Code;
}
var upres = db.Default.Updateable(task).ExecuteCommand();
task.AddWCS_TASK_DTL(db, "AGV巷道分配点", nextPos.Entity.Code, $"任务分配至堆垛机:{srm.Entity.Code}");
this.ExRecord(obj.Entity.Code, $"AGV任务{agvInfo.ID}分配至堆垛机:{srm.Entity.Code}");
if (upres > 0 && upres1 > 0)
{
//调继续执行任务接口(监控发现海康接口有不响应的情况,会导致事务不执行,把接口调用拿到事务外面)
//AgvApi.ContinueTask(agvInfo.AgvID, nextPos.Entity.Code);
isApplyContainue = 1;
agvid = agvInfo.AgvID;
nextpos = nextPos.Entity.Code;
RedisHub.Default.Set("TaskTun:" + task.ID, nextPos.Entity.Code, 600);
}
}
//放货站点安全交互
else if (agvInfo.AgvStatus == AGVTaskStatus.RequestOrPermission2 && agvInfo.Status != AGVTaskStatus.Complete2)
{
//找到对应WCS任务
var task = db.Default.Queryable().First(v => v.AgvTaskID == agvInfo.ID);
if (task == null) throw new Exception($"AGV任务{agvInfo.ID}未找到对应WCS任务");
if (agvInfo.Position.IsNullOrEmpty()) throw new Exception($"无有效放货地址");
if (db.Default.Queryable().Any(v => v.AddrNext == agvInfo.Position && v.Status == Entity.TaskStatus.ConveyorExecution)) throw new Exception($"AGV请求放货,但{agvInfo.Position}上任务状态异常"); ;
var dev = devs.Find(v => v.Entity.Code == agvInfo.Position);
if (dev.Data.VoucherNo != dev.Data2.VoucherNo) throw new Exception($"AGV请求放货,但{dev.Entity.Code}凭证号不一致");
if (!dev.Data3.Status.HasFlag(StatusEunm.Auto)) throw new Exception($"AGV请求放货,但{dev.Entity.Code}不在自动状态");
if (dev.Data3.Status.HasFlag(StatusEunm.PH_Status)) throw new Exception($"AGV请求放货,但{dev.Entity.Code}光电有货");
if (dev.Data3.Status.HasFlag(StatusEunm.OT_Status)) throw new Exception($"AGV请求放货,但{dev.Entity.Code}任务有货");
if (dev.Data3.Status.HasFlag(StatusEunm.Run)) throw new Exception($"AGV请求放货,但{dev.Entity.Code}在运行状态");
agvInfo.Status = AGVTaskStatus.Complete2;
db.Default.Updateable(agvInfo).SplitTable(x => x.Take(2)).ExecuteCommand();
dev.Data.TaskNumber = task.ID;
World.Log($"agvRequestOrPermission2:taskid[{dev.Data.TaskNumber}]", LogLevelEnum.Mid);
//调继续执行任务接口
AgvApi.ContinueTask(agvInfo.AgvID, dev.Entity.Code);
}
//完成任务
else if (agvInfo.AgvStatus == AGVTaskStatus.MissionCompleted && agvInfo.Status != AGVTaskStatus.MissionCompleted)
{
agvInfo.Status = AGVTaskStatus.MissionCompleted;
db.Default.Updateable(agvInfo).SplitTable(x => x.Take(2)).ExecuteCommand();
}
#endregion 开始跟据AGV状态做出处理
});
if (isApplyContainue > 0)
{
SqlSugarHelper.Do(db =>
{
var agvInfo = db.Default.Queryable().Where(x => x.AgvID == agvid).SplitTable(s => s.Take(2)).First();
if (agvInfo.Status == AGVTaskStatus.Complete1)
{
AgvApi.ContinueTask(agvid, nextpos);
}
});
//AgvApi.ContinueTask(agvid, nextpos);
}
}
catch (Exception ex)
{
World.Log(ex.Message, LogLevelEnum.Mid);
this.ExRecord(obj.Entity.Code, ex.Message);
continue;
}
}
World.Log($"agv任务处理:结束[{guid}]", LogLevelEnum.Mid);
}
}
}
///
/// 配置信息表
///
[Tenant("hj")]
[SugarTable("sys_config", "配置信息表")]
public class hjSysConfig : BaseModel
{
///
/// 编号
///
[SugarColumn(ColumnName = "code", Length = 100)]
public string Code { get; set; }
///
/// 名称
///
[SugarColumn(ColumnName = "name", Length = 100)]
public string Name { get; set; }
///
/// 内容
///
[SugarColumn(ColumnName = "scontent", Length = 100)]
public string SContent { get; set; }
///
/// 类型
///
[SugarColumn(ColumnName = "stype", Length = 50)]
public string SType { get; set; }
[SugarColumn(ColumnName = "default1", Length = 100, IsNullable = true)]
public string Default1 { get; set; }
[SugarColumn(ColumnName = "default2", Length = 100, IsNullable = true)]
public string Default2 { get; set; }
[SugarColumn(ColumnName = "default3", Length = 100, IsNullable = true)]
public string Default3 { get; set; }
}
public override bool Select(Device dev)
{
return dev.Code is "1017" or "1018";
}
}
}