BOPP入库.cs 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358
  1. using DBHelper;
  2. using Microsoft.EntityFrameworkCore;
  3. using Newtonsoft.Json;
  4. using System;
  5. using System.Collections.Generic;
  6. using System.Linq;
  7. using WCS.Core;
  8. using WCS.Entity;
  9. using WCS.Entity.Protocol;
  10. using WCS.Entity.Protocol.SRM;
  11. using WCS.Service.Extensions;
  12. using WCS.Service.Handlers;
  13. using WCS.Service.Helpers;
  14. using TaskStatus = WCS.Entity.TaskStatus;
  15. namespace WCS.Service.Works.Station
  16. {
  17. /// <summary>
  18. /// BOPP扫码入库
  19. /// </summary>
  20. [WorkTitle(typeof(BOPPHandler), "BOPP扫码入库")]
  21. public class Bopp扫码入库 : Work<StationDeviceGroup>
  22. {
  23. protected override void Do(StationDeviceGroup obj)
  24. {
  25. obj.EX(stationDeviceGroup =>
  26. {
  27. stationDeviceGroup.BcrStationIsForbid();
  28. //设备组无论单卷还是双卷都必须满足的条件
  29. if (stationDeviceGroup.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) throw new WarnException($"等待任务执行--凭证号不一致");
  30. if (stationDeviceGroup.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) throw new WarnException($"设备运行中");
  31. //成功创建的任务
  32. var finishTaskList = new List<FinishTaskList<int>>();
  33. //创建对应的任务
  34. DB.Do(db =>
  35. {
  36. var devise = stationDeviceGroup.GetBcrValid();
  37. devise.Valid();
  38. var infos = devise.GetWMSInTask();
  39. foreach (var item in devise)
  40. {
  41. var dev = item.Station;
  42. var next = dev.Entity.GetPath("SRM");
  43. var info = infos.FirstOrDefault(v => item.FinishCode.Contains(v.ContainerCode + "}"));
  44. if (db.Default.Set<WCS_TASK>().AsNoTracking().Any(v => v.BARCODE == info.ContainerCode && v.STATUS < TaskStatus.已完成 && v.TYPE == TaskType.入库))
  45. throw new WarnException($"生产条码{info?.ContainerCode}存在未完成任务,请检查是否为标签卡重复使用");
  46. var task = new WCS_TASK
  47. {
  48. BARCODE = info?.ContainerCode,
  49. TYPE = TaskType.入库,
  50. STATUS = TaskStatus.执行中,
  51. ADDRFROM = dev.Entity.CODE,
  52. ADDRTO = info?.EndPostion,
  53. STARTTIME = DateTime.Now,
  54. UPDATEUSER = "WCS",
  55. UPDATETIME = DateTime.Now,
  56. WMSTASK = int.Parse(info?.WMSTaskNum!),
  57. TaskGroupKey = info?.TaskGroupKey,
  58. ADDRNEXT = next.CODE,
  59. HEIGHT = dev.Data2.GoodsSize,
  60. FLOOR = 2
  61. };
  62. db.Default.Set<WCS_TASK>().Add(task);
  63. finishTaskList.Add(new FinishTaskList<int>(task.WMSTASK, item.Station));
  64. var msg = $"下达从{dev.Entity.CODE}移动至{next}的PLC指令。";
  65. msg += $"[{dev.Data.Tasknum}][{dev.Data.Goodsstart}][{dev.Data.Goodsend}][{dev.Data.VoucherNo}[{dev.Data2.VoucherNo}]";
  66. task.CreateStatusLog(db, msg, this.GetType());
  67. }
  68. //两个任务一起创建
  69. db.Default.SaveChanges();
  70. });
  71. //检查对应的任务是否已创建成功
  72. DB.Do(db =>
  73. {
  74. foreach (var finishTask in finishTaskList)
  75. {
  76. var task = db.Default.Set<WCS_TASK>().FirstOrDefault(v => v.WMSTASK == finishTask.FinishCode);
  77. if (task == null) continue;
  78. finishTask.Station.Data.Tasknum = task.ID;
  79. finishTask.Station.Data.Goodsstart = task.ADDRFROM.ToShort();
  80. finishTask.Station.Data.Goodsend = task.ADDRNEXT.ToShort();
  81. finishTask.Station.Data.Goodsnum = finishTaskList.Count.ToShort();
  82. finishTask.Station.Data.CmdType = IstationCmdType.扫码入库;
  83. finishTask.Station.Data.VoucherNo++;
  84. }
  85. });
  86. });
  87. }
  88. protected override bool SelectDevice(WCS_DEVICE dev)
  89. {
  90. return dev.CODE == "G1157";
  91. }
  92. }
  93. /// <summary>
  94. /// BOPP巷道分配
  95. /// </summary>
  96. [WorkTitle(typeof(BOPPHandler), "BOPP巷道分配")]
  97. public class Bopp巷道分配 : Work<StationDeviceGroup>
  98. {
  99. protected override void Do(StationDeviceGroup obj)
  100. {
  101. obj.EX(stationDeviceGroup =>
  102. {
  103. var code = stationDeviceGroup.Entity.CODE;
  104. //两个设备都必须满足的条件
  105. if (stationDeviceGroup.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) throw new WarnException($"等待任务执行--凭证号不一致");
  106. if (stationDeviceGroup.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) throw new WarnException($"设备运行中");
  107. //成功分配巷道的任务的任务
  108. var finishTaskList = new List<FinishTaskList<int>>();
  109. //变更数据库信息
  110. DB.Do(db =>
  111. {
  112. var devise = stationDeviceGroup.GetAddressValid();
  113. if (!devise.Any()) return; //无可执行任务
  114. var taskList = devise.ValidTaskCheck(db);
  115. var res = WMS.GetTunnelList(taskList.Select(v => v.WMSTASK.ToString()).ToList(), code);
  116. if (string.IsNullOrEmpty(res.TunnelNum)) throw new WarnException($"WMS未返回巷道");
  117. var tunnelNo = res.TunnelNum.Split(',').Select(v => "TY" + v).ToList();
  118. var tunnels = Device.Where(v => tunnelNo.Contains(v.CODE)).ToList();
  119. var tunnelInfos = new List<TunnelInfo>();
  120. foreach (var item in tunnels)
  121. {
  122. //当前巷道的取货点
  123. var allIn = Device.Where(v => v.Is(DF.SRMBOPP取货)) //一楼所有取货点
  124. .Where(v => v.ROUTES.Any(p => p.NEXT == item)) //下一个点为当前巷道的取货点
  125. .Select(v => v.CODE)
  126. .ToList();
  127. //下一个目标地址包含取货点的设备,此时获得的数据是旋转台
  128. var turntable = Device.Where(v => v.IsConv() && v.ROUTES.Any(p => p.NEXT != null && allIn.Contains(p.NEXT.CODE))).Select(v => v.CODE);
  129. //获得RGV的交货点
  130. StationDevice rgvDeliveryPoint = null;
  131. if (item.CODE == "TY1")
  132. {
  133. rgvDeliveryPoint = Device.Where(v => v.IsConv() && v.ROUTES.Any(p => p.NEXT != null && turntable.Contains(p.NEXT.CODE)))
  134. .Select(v => v.Create<StationDevice>()) //取所有可以到达取货点设备的信息
  135. .Where(v => v.Data3.Status.HasFlag(StationStatus.自动))//筛选出空闲的路径点,此处因输送机都是一个动力,因此可以先找路径点再找设备组
  136. .Distinct()
  137. .FirstOrDefault();//去一次重
  138. }
  139. else
  140. {
  141. rgvDeliveryPoint = Device.Where(v => v.IsConv() && v.ROUTES.Any(p => p.NEXT != null && turntable.Contains(p.NEXT.CODE)))
  142. .Select(v => v.Create<StationDevice>()) //取所有可以到达取货点设备的信息
  143. .Where(v => !v.Data3.Status.HasFlag(StationStatus.运行状态位)
  144. && !v.Data2.Status.HasFlag(IstationStatus.光电状态)
  145. && v.Data2.Tasknum < 10000
  146. && v.Data3.Status.HasFlag(StationStatus.自动))//筛选出空闲的路径点,此处因输送机都是一个动力,因此可以先找路径点再找设备组
  147. .Distinct()
  148. .FirstOrDefault();//去一次重
  149. }
  150. if (rgvDeliveryPoint == null) continue;
  151. var taskInStation = Device.Where(p => p.CODE.StartsWith("G") && p.DEVICEGROUP.Any(d => d.MEMBER == rgvDeliveryPoint.Entity)).MinBy(p => p.CODE);
  152. //RGV是否有正在前往这个地址的任务
  153. var rgvList = Device.Where(v => v.Is(DF.BOPPRGV)).Select(v => v.Create<RGVDevice>());
  154. var rgvTaskCount = ProtocolProxy.YGWMS150Redis.Get("BoppRgvTaskCount").ToInt();
  155. if (rgvList.Count(v => (!v.Data2.SystemStatus.HasFlag(WCS.Entity.Protocol.RGV.RGVRunStatus.空闲) || !v.Data2.WorkMode.HasFlag(WCS.Entity.Protocol.RGV.RGVMode.自动))
  156. && v.Data2.TaskType_1 == WCS.Entity.Protocol.RGV.RGVTaskType.放货
  157. && v.Data2.DestPosition_1 == taskInStation?.CODE.Replace("G", "").ToShort())>rgvTaskCount) continue;
  158. tunnelInfos.Add(new TunnelInfo
  159. {
  160. Tunnel = item,
  161. taskIN = taskInStation, //找到放货点设备所在组
  162. SRM = Device.Where(p => p.IsSC()).FirstOrDefault(p => item.ROUTES.Any(d => d.NEXT.CODE == p.CODE)).Create<SRMDevice>()
  163. });
  164. }
  165. //筛选出优先级最高的可用巷道
  166. var tunnelInfo = tunnelInfos.Where(v => { try { return (v.SRM.Data3.SCAlarm == 0 && v.SRM.Data2.SRMMode == SCMode.远程) || v.SRM.Entity.CODE == "SRM1"; } catch { return false; } })
  167. .Where(v => !db.Default.Set<WCS_TASK>().Any(p => p.Priority > 0 && p.DEVICE == v.SRM.Entity.CODE && p.STATUS < TaskStatus.堆垛机完成)).MinBy(v => tunnelNo.IndexOf(v.Tunnel.CODE));
  168. if (tunnelInfo == null) throw new WarnException("无可用巷道");
  169. //开始变更任务信息
  170. foreach (var item in devise)
  171. {
  172. var dev = Device.Find(item.Station.Entity.CODE).Create<StationDevice>();
  173. var task = taskList.FirstOrDefault(p => p.ID == dev.Data2.Tasknum);
  174. if (task == null) throw new WarnException($"WCS无该任务{dev.Data2.Tasknum}--{dev.Entity.CODE}");
  175. task.DEVICE = tunnelInfo.SRM.Entity.CODE;
  176. task.TUNNEL = tunnelInfo.Tunnel.CODE;
  177. task.ADDRNEXT = tunnelInfo.taskIN.CODE;
  178. task.TaskGroupKey = res.WMSTaskGroupKey;
  179. task.ADDRTO = task.DEVICE;
  180. var msg = $"下达从G23移动至{dev.Data.Goodsend}的PLC指令。同时将任务分配至[{task.TUNNEL}]-[{task.DEVICE}]";
  181. msg += $"[{dev.Data.Tasknum}][G23][{dev.Data.Goodsend}][{tunnelInfo.SRM.Entity.CODE}][{dev.Data.VoucherNo}[{dev.Data2.VoucherNo}]";
  182. task.CreateStatusLog(db, msg, this.GetType());
  183. finishTaskList.Add(new FinishTaskList<int>(task.ID, item.Station));
  184. }
  185. db.Default.SaveChanges();
  186. });
  187. // 开始将任务信息写入到设备
  188. DB.Do(db =>
  189. {
  190. foreach (var finishTask in finishTaskList)
  191. {
  192. var task = db.Default.Set<WCS_TASK>().Find(finishTask.FinishCode);
  193. if (task == null) continue;
  194. finishTask.Station.Data.Tasknum = task.ID;
  195. finishTask.Station.Data.Goodsstart = stationDeviceGroup.Entity.CODE.Replace("G", "").ToShort();
  196. finishTask.Station.Data.Goodsend = task.ADDRNEXT.Replace("G", "").ToShort();
  197. finishTask.Station.Data.Goodsnum = finishTaskList.Count.ToShort();
  198. finishTask.Station.Data.CmdType = IstationCmdType.分配目标地址;
  199. finishTask.Station.Data.VoucherNo++;
  200. }
  201. });
  202. });
  203. }
  204. protected override bool SelectDevice(WCS_DEVICE dev)
  205. {
  206. return dev.CODE == "G23";
  207. }
  208. }
  209. /// <summary>
  210. /// 涂布入库旋转台二次分配巷道
  211. /// </summary>
  212. [WorkTitle(typeof(BOPPHandler), "BOPP入库旋转台二次分配巷道")]
  213. public class Bopp入库旋转台二次分配巷道 : Work<StationDeviceGroup>
  214. {
  215. protected override void Do(StationDeviceGroup obj)
  216. {
  217. obj.EX(stationDeviceGroup =>
  218. {
  219. var code = stationDeviceGroup.Entity.CODE;
  220. //两个设备都必须满足的条件
  221. if (stationDeviceGroup.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) throw new WarnException($"等待任务执行--凭证号不一致");
  222. if (stationDeviceGroup.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) throw new WarnException($"设备运行中");
  223. //成功分配巷道的任务的任务
  224. var finishTaskList = new List<FinishTaskList<int>>();
  225. //变更数据库信息
  226. DB.Do(db =>
  227. {
  228. var devise = stationDeviceGroup.GetAddressValid();
  229. if (!devise.Any()) return; //无可执行任务
  230. var taskList = devise.ValidTaskCheck(db);
  231. var res = WMS.GetTunnelList(taskList.Select(v => v.WMSTASK.ToString()).ToList(), code);
  232. if (string.IsNullOrEmpty(res.TunnelNum)) throw new WarnException($"WMS未返回巷道");
  233. var tunnelNo = res.TunnelNum.Split(',').Select(v => "TY" + v).ToList();
  234. var tunnels = Device.Where(v => tunnelNo.Contains(v.CODE)).ToList();
  235. var tunnelInfos = new List<TunnelInfo>();
  236. var setting = new JsonSerializerSettings();
  237. setting.ReferenceLoopHandling = ReferenceLoopHandling.Ignore;
  238. setting.PreserveReferencesHandling = PreserveReferencesHandling.Objects;
  239. code.infolog($"{res.WMSTaskGroupKey}第二次分配:WMS返回{JsonConvert.SerializeObject(tunnelNo, setting)}。");
  240. foreach (var item in tunnels)
  241. {
  242. //当前巷道的取货点
  243. var allIn = Device.Where(v => v.Is(DF.SRMBOPP取货))
  244. .Where(v => v.ROUTES.Any(p => p.NEXT.CODE == item.CODE)) //下一个点为当前巷道的取货点
  245. .Select(v => v.CODE)
  246. .ToList();
  247. code.infolog($"allIn:{JsonConvert.SerializeObject(allIn, setting)};item:{item.CODE}");
  248. //下一个目标地址包含取货点的设备,此时获得的数据是旋转台
  249. var turntable = Device.Where(v => v.IsConv() && v.ROUTES.Any(p => p.NEXT != null && allIn.Contains(p.NEXT.CODE)))
  250. .Where(v => stationDeviceGroup.Items.Any(p => p.Entity == v))// 筛选出包含在当前设备组的设备
  251. .Distinct()
  252. .FirstOrDefault();//去一次重
  253. if (turntable == null) continue;
  254. code.infolog($"turntable:{turntable.CODE};item:{item.CODE}");
  255. var dev = Device.Where(p => p.CODE.StartsWith("G") && p.DEVICEGROUP.Any(d => allIn.Contains(d.MEMBER.CODE))).MinBy(p => p.CODE);
  256. code.infolog($"dev:{dev.CODE};item:{item.CODE}");
  257. tunnelInfos.Add(new TunnelInfo
  258. {
  259. Tunnel = item,
  260. taskIN = dev, //找到放货点设备所在组
  261. SRM = Device.Where(p => p.IsSC()).FirstOrDefault(p => item.ROUTES.Any(d => d.NEXT.CODE == p.CODE)).Create<SRMDevice>()
  262. });
  263. }
  264. code.infolog($"tunnelInfo:{JsonConvert.SerializeObject(tunnelInfos.Select(v => new { taskIN = v.taskIN.CODE, Tunnel = v.Tunnel.CODE, SRM = v.SRM.Entity.CODE }), setting)};");
  265. //筛选出优先级最高的可用巷道
  266. var tunnelInfo = tunnelInfos.Where(v =>
  267. {
  268. try
  269. {
  270. code.infolog($"SCAlarm:{v.SRM.Data3.SCAlarm};SRMMode:{v.SRM.Data2.SRMMode};SRMStatus:{v.SRM.Data2.SRMStatus};CODE:{v.SRM.Entity.CODE}");
  271. 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";
  272. }
  273. catch { return false; }
  274. }).MinBy(v => tunnelNo.IndexOf(v.Tunnel.CODE));
  275. if (tunnelInfo == null) throw new WarnException("无可用巷道");
  276. code.infolog($"tunnelNo:{JsonConvert.SerializeObject(tunnelNo, setting)}。");
  277. code.infolog($"tunnelInfo:{JsonConvert.SerializeObject(new { taskIN = tunnelInfo.taskIN.CODE, Tunnel = tunnelInfo.Tunnel.CODE, SRM = tunnelInfo.SRM.Entity.CODE }, setting)};");
  278. code.infolog($"{res.WMSTaskGroupKey}第二次分配:WCS选择{tunnelInfo.Tunnel.CODE}。");
  279. //开始变更任务信息
  280. foreach (var item in devise)
  281. {
  282. var dev = Device.Find(item.Station.Entity.CODE).Create<StationDevice>();
  283. var task = taskList.FirstOrDefault(p => p.ID == dev.Data2.Tasknum);
  284. if (task == null) throw new WarnException($"WCS无该任务{dev.Data2.Tasknum}--{dev.Entity.CODE}");
  285. task.DEVICE = tunnelInfo.SRM.Entity.CODE;
  286. task.TUNNEL = tunnelInfo.Tunnel.CODE;
  287. task.ADDRNEXT = dev.Entity.GetPath(task.DEVICE).CODE;
  288. task.TaskGroupKey = res.WMSTaskGroupKey;
  289. task.ADDRTO = task.DEVICE;
  290. var msg = $"下达从{stationDeviceGroup.Entity.CODE}移动至{dev.Data.Goodsend}的PLC指令。同时将任务分配至[{task.TUNNEL}]-[{task.DEVICE}]";
  291. msg += $"[{dev.Data.Tasknum}][{stationDeviceGroup.Entity.CODE}][{dev.Data.Goodsend}][{tunnelInfo.SRM.Entity.CODE}][{dev.Data.VoucherNo}[{dev.Data2.VoucherNo}]";
  292. task.CreateStatusLog(db, msg, GetType());
  293. finishTaskList.Add(new FinishTaskList<int>(task.ID, item.Station));
  294. }
  295. db.Default.SaveChanges();
  296. });
  297. // 开始将任务信息写入到设备
  298. DB.Do(db =>
  299. {
  300. foreach (var finishTask in finishTaskList)
  301. {
  302. var task = db.Default.Set<WCS_TASK>().Find(finishTask.FinishCode);
  303. if (task == null) continue;
  304. finishTask.Station.Data.Tasknum = task.ID;
  305. finishTask.Station.Data.Goodsstart = stationDeviceGroup.Entity.CODE.Replace("G", "").ToShort();
  306. finishTask.Station.Data.Goodsend = finishTask.Station.Entity.GetPath(task.DEVICE).CODE.ToShort();
  307. finishTask.Station.Data.Goodsnum = finishTaskList.Count.ToShort();
  308. finishTask.Station.Data.CmdType = IstationCmdType.分配目标地址;
  309. finishTask.Station.Data.VoucherNo++;
  310. code.infolog($"{task.TaskGroupKey}第二次分配:WCS目标地址{finishTask.Station.Data.Goodsend}。");
  311. }
  312. });
  313. });
  314. }
  315. protected override bool SelectDevice(WCS_DEVICE dev)
  316. {
  317. return _devCodes.Contains(dev.CODE);
  318. }
  319. private readonly List<string> _devCodes = new() { "G1190", "G1199", "G1208", "G1217", "G1225" };
  320. }
  321. }