一楼入库.cs 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323
  1. using DBHelper;
  2. using Microsoft.EntityFrameworkCore;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.Diagnostics;
  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.Helpers;
  13. using WCS.Service.Log;
  14. namespace WCS.Service.Works.Station
  15. {
  16. [WorkTitle(typeof(ProductHandler), "扫码入库")]
  17. internal class 扫码入库 : Work<StationDeviceGroup>
  18. {
  19. protected override bool SelectDevice(WCS_DEVICE dev)
  20. {
  21. return dev.CODE == "G1028";
  22. }
  23. protected override void Do(StationDeviceGroup obj)
  24. {
  25. var timer = new Stopwatch();
  26. timer.Start();
  27. obj.EX(obj =>
  28. {
  29. if (!obj.BcrStationIsForbid()) return;
  30. if (!SystemConfigHelpers.GetDeviceConfig(obj.Entity.CODE)) throw new WarnException($"已禁止{obj.Entity.CODE}入库,请联系相关人员查询");
  31. //设备组无论单卷还是双卷都必须满足的条件
  32. if (obj.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) throw new WarnException($"等待任务执行--凭证号不一致");
  33. if (obj.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) throw new WarnException($"设备运行中");
  34. //成功创建的任务
  35. var finishTaskList = new List<FinishTaskList<int>>();
  36. var devs = obj.GetBcrValid();
  37. if (!devs.Valid(obj.Entity.CODE)) return;
  38. var infos = devs.GetWMSInTask();
  39. if (!infos.Any()) throw new WarnException($"{obj.Entity.CODE}: WMS未返回结果");
  40. //创建对应的任务
  41. DB.Do(db =>
  42. {
  43. foreach (var item in devs)
  44. {
  45. var dev = item.Station;
  46. var next = dev.Entity.GetPath("SRM").CODE;
  47. var info = infos.FirstOrDefault(v => item.FinishCode.Contains(v.ContainerCode + "}"));
  48. if (db.Default.Set<WCS_TASK>().AsNoTracking().Any(v => v.BARCODE == info.ContainerCode && v.STATUS < TaskStatus.已完成 && v.TYPE == TaskType.入库))
  49. throw new WarnException($"生产条码{info.ContainerCode}存在未完成任务,请检查是否为标签卡重复使用");
  50. var task = new WCS_TASK();
  51. task.BARCODE = info.ContainerCode;
  52. task.TYPE = TaskType.入库;
  53. task.STATUS = TaskStatus.执行中;
  54. task.ADDRFROM = dev.Entity.CODE;
  55. task.ADDRTO = info.EndPostion;
  56. task.STARTTIME = DateTime.Now;
  57. task.UPDATEUSER = "WCS";
  58. task.UPDATETIME = DateTime.Now;
  59. task.WMSTASK = int.Parse(info.WMSTaskNum);
  60. task.TaskGroupKey = info.TaskGroupKey;
  61. task.ADDRNEXT = next;
  62. task.HEIGHT = dev.Data2.GoodsSize;
  63. task.FLOOR = 1;
  64. db.Default.Set<WCS_TASK>().Add(task);
  65. finishTaskList.Add(new FinishTaskList<int>(task.WMSTASK, item.Station));
  66. }
  67. //两个任务一起创建
  68. db.Default.SaveChanges();
  69. });
  70. //检查对应的任务是否已创建成功
  71. DB.Do(db =>
  72. {
  73. foreach (var finishTask in finishTaskList)
  74. {
  75. var task = db.Default.Set<WCS_TASK>().FirstOrDefault(v => v.WMSTASK == finishTask.FinishCode);
  76. if (task == null) continue;
  77. finishTask.Station.Data.Tasknum = task.ID;
  78. finishTask.Station.Data.Goodsstart = task.ADDRFROM.ToShort();
  79. finishTask.Station.Data.Goodsend = task.ADDRNEXT.ToShort();
  80. finishTask.Station.Data.Goodsnum = finishTaskList.Count.ToShort();
  81. finishTask.Station.Data.CmdType = IstationCmdType.扫码入库;
  82. finishTask.Station.Data.VoucherNo++;
  83. task.CreateStatusLog(db, $"任务已下发给输送机[{task.ADDRFROM}]执行,起始地址[{task.ADDRFROM}],目标地址[{task.ADDRNEXT}]", this.GetType());
  84. }
  85. db.Default.SaveChanges();
  86. });
  87. if (finishTaskList.Any())
  88. {
  89. timer.Stop();
  90. InfoLog.INFO_TIMING($"{obj.Entity.CODE}--扫码入库,耗时{timer.ElapsedMilliseconds}");
  91. }
  92. });
  93. }
  94. }
  95. [WorkTitle(typeof(ProductHandler), "一楼分配巷道")]
  96. internal class 巷道分配 : Work<StationDeviceGroup>
  97. {
  98. protected override bool SelectDevice(WCS_DEVICE dev)
  99. {
  100. return dev.CODE == "G1030";
  101. }
  102. protected override void Do(StationDeviceGroup obj)
  103. {
  104. obj.EX(obj =>
  105. {
  106. var code = obj.Entity.CODE;
  107. //两个设备都必须满足的条件
  108. if (obj.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) throw new WarnException("等待任务执行,凭证号不一致");
  109. if (obj.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) throw new DoException("运行中");
  110. //成功分配巷道的任务的任务
  111. var finishTaskList = new List<FinishTaskList<int>>();
  112. var devs = obj.Items.Where(v => v.Data2.Status.HasFlag(IstationStatus.光电状态) && v.Data2.Request == IstationRequest.请求分配目标地址)
  113. .Where(v => v.Data2.Tasknum > 10000 && v.Data2.Goodsend != 0);
  114. if (!devs.Any()) return; //无可执行任务
  115. var taskIds = devs.Select(dev => dev.Data2.Tasknum).ToList();
  116. var devConvs = Device.Where(v => v.IsConv());
  117. //变更数据库信息
  118. DB.Do(db =>
  119. {
  120. var taskList = db.Default.Set<WCS_TASK>().Where(v => taskIds.Contains(v.ID)).ToList();
  121. taskList.ValidTaskCheck(devs.Count(), db);
  122. var res = WMS.GetTunnelList(taskList.Select(v => v.WMSTASK.ToString()).ToList(), code);
  123. if (string.IsNullOrEmpty(res.TunnelNum)) throw new WarnException($"WMS未返回巷道");
  124. var tunnelNo = res.TunnelNum.Split(',').Select(v => "TY" + v).ToList();
  125. var tunnels = Device.Where(v => tunnelNo.Contains(v.CODE)).ToList();
  126. List<TunnelInfo> tunnelInfos = new List<TunnelInfo>();
  127. foreach (var item in tunnels)
  128. {
  129. //当前巷道的取货点
  130. var allIn = Device.Where(v => v.Is(DF.SRM二级品取货)) //二楼所有取货点
  131. .Where(v => v.ROUTES.Any(p => p.NEXT == item)) //下一个点为当前巷道的取货点
  132. .Select(v => v.CODE)
  133. .ToList();
  134. //下一个目标地址包含取货点的设备,此时获得的数据是旋转台
  135. var turntable = devConvs.Where(v => v.ROUTES.Any(p => p.NEXT != null && allIn.Contains(p.NEXT.CODE))).Select(v => v.CODE);
  136. var putStation = devConvs.Where(v => v.ROUTES.Any(p => p.NEXT != null && turntable.Contains(p.NEXT.CODE))) //下一个目标地址包含取货点的设备
  137. .Select(v => v.Create<StationDevice>()) //取所有可以到达取货点设备的信息
  138. .Where(v => !v.Data3.Status.HasFlag(StationStatus.运行状态位) && !v.Data2.Status.HasFlag(IstationStatus.光电状态) && v.Data2.Tasknum < 10000)//筛选出空闲的路径点,此处因输送机都是一个动力,因此可以先找路径点再找设备组
  139. .Distinct()
  140. .FirstOrDefault();//去一次重
  141. if (putStation == null) continue;
  142. var taskInStation = Device.Where(v => v.IsDevGroup()).Where(p => p.DEVICEGROUP.Any(d => d.MEMBER == putStation.Entity)).OrderBy(p => p.CODE).FirstOrDefault();
  143. //RGV是否有正在前往这个地址的任务
  144. var rgv8 = Device.Find("RGV8").Create<RGVDevice>();
  145. if ((!rgv8.Data2.SystemStatus.HasFlag(WCS.Entity.Protocol.RGV.RGVRunStatus.空闲) || !rgv8.Data2.WorkMode.HasFlag(WCS.Entity.Protocol.RGV.RGVMode.自动))
  146. && rgv8.Data2.DestPosition_1 == taskInStation.CODE.Replace("G", "").ToShort()) continue;
  147. tunnelInfos.Add(new TunnelInfo
  148. {
  149. Tunnel = item,
  150. taskIN = taskInStation, //找到放货点设备所在组
  151. SRM = Device.Where(p => p.IsSC()).FirstOrDefault(p => item.ROUTES.Any(d => d.NEXT.CODE == p.CODE)).Create<SRMDevice>()
  152. });
  153. }
  154. //筛选出优先级最高的可用巷道
  155. 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; } })
  156. .Where(v => !db.Default.Set<WCS_TASK>().Any(p => p.Priority > 0 && p.DEVICE == v.SRM.Entity.CODE && p.STATUS < TaskStatus.堆垛机完成))
  157. .OrderBy(v => tunnelNo.IndexOf(v.Tunnel.CODE)).FirstOrDefault();
  158. if (tunnelInfo == null) throw new WarnException("无可用巷道");
  159. //开始变更任务信息
  160. foreach (var item in devs)
  161. {
  162. var dev = Device.Find(item.Entity.CODE).Create<StationDevice>();
  163. var task = taskList.FirstOrDefault(p => p.ID == dev.Data2.Tasknum);
  164. if (task == null) throw new WarnException($"WCS无该任务{dev.Data2.Tasknum}--{dev.Entity.CODE}");
  165. task.DEVICE = tunnelInfo.SRM.Entity.CODE;
  166. task.TUNNEL = tunnelInfo.Tunnel.CODE;
  167. task.ADDRNEXT = tunnelInfo.taskIN.CODE;
  168. task.TaskGroupKey = res.WMSTaskGroupKey;
  169. task.ADDRTO = task.DEVICE;
  170. task.CreateStatusLog(db, $"任务一次分配巷道[{tunnelInfo.Tunnel.CODE}]", this.GetType());
  171. finishTaskList.Add(new FinishTaskList<int>(task.ID, item.Entity.Create<StationDevice>()));
  172. }
  173. db.Default.SaveChanges();
  174. });
  175. // 开始将任务信息写入到设备
  176. DB.Do(db =>
  177. {
  178. foreach (var finishTask in finishTaskList)
  179. {
  180. var task = db.Default.Set<WCS_TASK>().Find(finishTask.FinishCode);
  181. if (task == null) continue;
  182. finishTask.Station.Data.Tasknum = task.ID;
  183. finishTask.Station.Data.Goodsstart = 1030;
  184. finishTask.Station.Data.Goodsend = task.ADDRNEXT.Replace("G", "").ToShort();
  185. finishTask.Station.Data.Goodsnum = finishTaskList.Count.ToShort();
  186. finishTask.Station.Data.CmdType = IstationCmdType.分配目标地址;
  187. finishTask.Station.Data.VoucherNo++;
  188. }
  189. });
  190. });
  191. }
  192. }
  193. [WorkTitle(typeof(ProductHandler), "一楼入库旋转台二次分配巷道")]
  194. internal class 一楼入库旋转台二次分配巷道 : Work<StationDeviceGroup>
  195. {
  196. protected override void Do(StationDeviceGroup obj)
  197. {
  198. obj.EX(obj =>
  199. {
  200. var code = obj.Entity.CODE;
  201. //两个设备都必须满足的条件
  202. if (obj.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) throw new WarnException("等待执行任务--凭证号不一致");
  203. if (obj.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) throw new DoException("运行中");
  204. //成功分配巷道的任务的任务
  205. var finishTaskList = new List<FinishTaskList<int>>();
  206. //变更数据库信息
  207. DB.Do(db =>
  208. {
  209. var devs = obj.Items.Where(v => v.Data2.Status.HasFlag(IstationStatus.光电状态) && v.Data2.Request == IstationRequest.请求分配目标地址)
  210. .Where(v => v.Data2.Tasknum > 10000);
  211. if (!devs.Any()) return; //无可执行任务
  212. var taskIds = devs.Select(dev => dev.Data2.Tasknum).ToList();
  213. var taskList = db.Default.Set<WCS_TASK>().Where(v => taskIds.Contains(v.ID)).ToList();
  214. taskList.ValidTaskCheck(devs.Count(), db);
  215. var res = WMS.GetTunnelList(taskList.Select(v => v.WMSTASK.ToString()).ToList(), code);
  216. if (string.IsNullOrEmpty(res.TunnelNum)) throw new WarnException($"WMS未返回巷道");
  217. var tunnelNo = res.TunnelNum.Split(',').Select(v => "TY" + v).ToList();
  218. var tunnels = Device.Where(v => tunnelNo.Contains(v.CODE)).ToList();
  219. List<TunnelInfo> tunnelInfos = new List<TunnelInfo>();
  220. foreach (var item in tunnels)
  221. {
  222. //当前巷道的取货点
  223. var allIn = Device.Where(v => v.Is(DF.SRM二级品取货)) //一楼所有取货点
  224. .Where(v => v.ROUTES.Any(p => p.NEXT == item)) //下一个点为当前巷道的取货点
  225. .Select(v => v.CODE)
  226. .ToList();
  227. //下一个目标地址包含取货点的设备,此时获得的数据是旋转台
  228. var turntable = Device.Where(v => v.IsConv() && v.ROUTES.Any(p => p.NEXT != null && allIn.Contains(p.NEXT.CODE)))
  229. .Where(v => obj.Items.Any(p => p.Entity == v))// 筛选出包含在当前设备组的设备
  230. .Distinct()
  231. .FirstOrDefault();//去一次重
  232. if (turntable == null) continue;
  233. var dev = Device.Where(p => p.CODE.StartsWith("G") && p.DEVICEGROUP.Any(d => d.MEMBER == turntable)).OrderBy(p => p.CODE).FirstOrDefault();
  234. tunnelInfos.Add(new TunnelInfo
  235. {
  236. Tunnel = item,
  237. taskIN = dev, //找到放货点设备所在组
  238. SRM = Device.Where(p => p.IsSC()).FirstOrDefault(p => item.ROUTES.Any(d => d.NEXT.CODE == p.CODE)).Create<SRMDevice>()
  239. });
  240. }
  241. //筛选出优先级最高的可用巷道
  242. 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; } })
  243. .OrderBy(v => tunnelNo.IndexOf(v.Tunnel.CODE)).FirstOrDefault();
  244. if (tunnelInfo == null) throw new WarnException("无可用巷道");
  245. //开始变更任务信息
  246. foreach (var item in devs)
  247. {
  248. var dev = item.Entity.Create<StationDevice>();
  249. var task = taskList.FirstOrDefault(p => p.ID == dev.Data2.Tasknum);
  250. if (task == null) throw new WarnException($"WCS无该任务{dev.Data2.Tasknum}--{dev.Entity.CODE}");
  251. task.DEVICE = tunnelInfo.SRM.Entity.CODE;
  252. task.TUNNEL = tunnelInfo.Tunnel.CODE;
  253. task.ADDRNEXT = tunnelInfo.taskIN.CODE;
  254. task.TaskGroupKey = res.WMSTaskGroupKey;
  255. task.ADDRTO = task.DEVICE;
  256. task.CreateStatusLog(db, $"任务二次分配巷道[{tunnelInfo.Tunnel.CODE}]", this.GetType());
  257. finishTaskList.Add(new FinishTaskList<int>(task.ID, dev));
  258. }
  259. db.Default.SaveChanges();
  260. });
  261. // 开始将任务信息写入到设备
  262. DB.Do(db =>
  263. {
  264. foreach (var finishTask in finishTaskList)
  265. {
  266. var task = db.Default.Set<WCS_TASK>().Find(finishTask.FinishCode);
  267. if (task == null) continue;
  268. finishTask.Station.Data.Tasknum = task.ID;
  269. finishTask.Station.Data.Goodsstart = obj.Entity.CODE.Replace("G", "").ToShort();
  270. finishTask.Station.Data.Goodsend = finishTask.Station.Entity.GetPath(task.DEVICE).CODE.ToShort();
  271. finishTask.Station.Data.Goodsnum = finishTaskList.Count.ToShort();
  272. finishTask.Station.Data.CmdType = IstationCmdType.分配目标地址;
  273. finishTask.Station.Data.VoucherNo++;
  274. }
  275. });
  276. });
  277. }
  278. protected override bool SelectDevice(WCS_DEVICE dev)
  279. {
  280. return devCodes.Contains(dev.CODE);
  281. }
  282. private List<string> devCodes = new List<string>() { "G1038", "G1047", "G1056", "G1065" };
  283. }
  284. }