BOPP入库.cs 20 KB

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