一楼入库.cs 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389
  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. obj.BcrStationIsForbid();
  30. //设备组无论单卷还是双卷都必须满足的条件
  31. if (obj.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) throw new WarnException($"等待任务执行--凭证号不一致");
  32. if (obj.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) throw new WarnException($"设备运行中");
  33. //成功创建的任务
  34. var finishTaskList = new List<FinishTaskList<int>>();
  35. //创建对应的任务
  36. DB.Do(db =>
  37. {
  38. var devs = obj.GetBcrValid();
  39. devs.Valid();
  40. var infos = devs.GetWMSInTask();
  41. foreach (var item in devs)
  42. {
  43. var dev = item.Station;
  44. var next = dev.Entity.GetPath("SRM").CODE;
  45. var info = infos.FirstOrDefault(v => item.FinishCode.Contains(v.ContainerCode + "}"));
  46. if (db.Default.Set<WCS_TASK>().AsNoTracking().Any(v => v.BARCODE == info.ContainerCode && v.STATUS < TaskStatus.已完成 && v.TYPE == TaskType.入库))
  47. throw new WarnException($"生产条码{info.ContainerCode}存在未完成任务,请检查是否为标签卡重复使用");
  48. var task = new WCS_TASK();
  49. task.BARCODE = info.ContainerCode;
  50. task.TYPE = TaskType.入库;
  51. task.STATUS = TaskStatus.执行中;
  52. task.ADDRFROM = dev.Entity.CODE;
  53. task.ADDRTO = info.EndPostion;
  54. task.STARTTIME = DateTime.Now;
  55. task.UPDATEUSER = "WCS";
  56. task.UPDATETIME = DateTime.Now;
  57. task.WMSTASK = int.Parse(info.WMSTaskNum);
  58. task.TaskGroupKey = info.TaskGroupKey;
  59. task.ADDRNEXT = next;
  60. task.HEIGHT = dev.Data2.GoodsSize;
  61. task.FLOOR = 1;
  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. //InfoLog.INFO_CREATETASKIN($"[{obj.Entity.CODE}]--生成任务{JsonConvert.SerializeObject(finishTaskList)}");
  75. foreach (var finishTask in finishTaskList)
  76. {
  77. var task = db.Default.Set<WCS_TASK>().FirstOrDefault(v => v.WMSTASK == finishTask.FinishCode);
  78. if (task == null) continue;
  79. finishTask.Station.Data.Tasknum = task.ID;
  80. finishTask.Station.Data.Goodsstart = task.ADDRFROM.ToShort();
  81. finishTask.Station.Data.Goodsend = task.ADDRNEXT.ToShort();
  82. finishTask.Station.Data.Goodsnum = finishTaskList.Count.ToShort();
  83. finishTask.Station.Data.CmdType = IstationCmdType.扫码入库;
  84. finishTask.Station.Data.VoucherNo++;
  85. }
  86. });
  87. timer.Stop();
  88. InfoLog.INFO_TIMING($"{obj.Entity.CODE}--扫码入库,耗时{timer.ElapsedMilliseconds}");
  89. });
  90. }
  91. }
  92. [WorkTitle(typeof(ProductHandler), "一楼分配巷道")]
  93. internal class 巷道分配 : Work<StationDeviceGroup>
  94. {
  95. protected override bool SelectDevice(WCS_DEVICE dev)
  96. {
  97. return dev.CODE == "G1030";
  98. }
  99. protected override void Do(StationDeviceGroup obj)
  100. {
  101. obj.EX(obj =>
  102. {
  103. var code = obj.Entity.CODE;
  104. //两个设备都必须满足的条件
  105. if (obj.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) throw new WarnException("等待任务执行,凭证号不一致");
  106. if (obj.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) throw new DoException("运行中");
  107. //成功分配巷道的任务的任务
  108. var finishTaskList = new List<FinishTaskList<int>>();
  109. //变更数据库信息
  110. DB.Do(db =>
  111. {
  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 taskList = db.Default.Set<WCS_TASK>().Where(v => taskIds.Contains(v.ID)).ToList();
  117. taskList.ValidTaskCheck(devs.Count(), db);
  118. var res = WMS.GetTunnelList(taskList.Select(v => v.WMSTASK.ToString()).ToList(), code);
  119. if (string.IsNullOrEmpty(res.TunnelNum)) throw new WarnException($"WMS未返回巷道");
  120. var tunnelNo = res.TunnelNum.Split(',').Select(v => "TY" + v).ToList();
  121. var tunnels = Device.Where(v => tunnelNo.Contains(v.CODE)).ToList();
  122. List<TunnelInfo> tunnelInfos = new List<TunnelInfo>();
  123. foreach (var item in tunnels)
  124. {
  125. //当前巷道的取货点
  126. var allIn = Device.Where(v => v.Is(DF.SRM二级品取货)) //二楼所有取货点
  127. .Where(v => v.ROUTES.Any(p => p.NEXT == item)) //下一个点为当前巷道的取货点
  128. .Select(v => v.CODE)
  129. .ToList();
  130. //下一个目标地址包含取货点的设备,此时获得的数据是旋转台
  131. var turntable = Device.Where(v => v.IsConv() && v.ROUTES.Any(p => p.NEXT != null && allIn.Contains(p.NEXT.CODE))).Select(v => v.CODE);
  132. var putStation = Device.Where(v => v.IsConv() && v.ROUTES.Any(p => p.NEXT != null && turntable.Contains(p.NEXT.CODE))) //下一个目标地址包含取货点的设备
  133. .Select(v => v.Create<StationDevice>()) //取所有可以到达取货点设备的信息
  134. .Where(v => !v.Data3.Status.HasFlag(StationStatus.运行状态位) && !v.Data2.Status.HasFlag(IstationStatus.光电状态) && v.Data2.Tasknum < 10000)//筛选出空闲的路径点,此处因输送机都是一个动力,因此可以先找路径点再找设备组
  135. .Distinct()
  136. .FirstOrDefault();//去一次重
  137. if (putStation == null) continue;
  138. var taskInStation = Device.Where(p => p.CODE.StartsWith("G") && p.DEVICEGROUP.Any(d => d.MEMBER == putStation.Entity)).OrderBy(p => p.CODE).FirstOrDefault();
  139. //RGV是否有正在前往这个地址的任务
  140. var rgv8 = Device.Find("RGV8").Create<RGVDevice>();
  141. if ((!rgv8.Data2.SystemStatus.HasFlag(WCS.Entity.Protocol.RGV.RGVRunStatus.空闲) || !rgv8.Data2.WorkMode.HasFlag(WCS.Entity.Protocol.RGV.RGVMode.自动))
  142. && rgv8.Data2.DestPosition_1 == taskInStation.CODE.Replace("G", "").ToShort()) continue;
  143. tunnelInfos.Add(new TunnelInfo
  144. {
  145. Tunnel = item,
  146. taskIN = taskInStation, //找到放货点设备所在组
  147. SRM = Device.Where(p => p.IsSC()).FirstOrDefault(p => item.ROUTES.Any(d => d.NEXT.CODE == p.CODE)).Create<SRMDevice>()
  148. });
  149. }
  150. //筛选出优先级最高的可用巷道
  151. 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; } })
  152. .Where(v => !db.Default.Set<WCS_TASK>().Any(p => p.Priority > 0 && p.DEVICE == v.SRM.Entity.CODE && p.STATUS < TaskStatus.堆垛机完成))
  153. .OrderBy(v => tunnelNo.IndexOf(v.Tunnel.CODE)).FirstOrDefault();
  154. if (tunnelInfo == null) throw new WarnException("无可用巷道");
  155. //开始变更任务信息
  156. foreach (var item in devs)
  157. {
  158. var dev = Device.Find(item.Entity.CODE).Create<StationDevice>();
  159. var task = taskList.FirstOrDefault(p => p.ID == dev.Data2.Tasknum);
  160. if (task == null) throw new WarnException($"WCS无该任务{dev.Data2.Tasknum}--{dev.Entity.CODE}");
  161. task.DEVICE = tunnelInfo.SRM.Entity.CODE;
  162. task.TUNNEL = tunnelInfo.Tunnel.CODE;
  163. task.ADDRNEXT = tunnelInfo.taskIN.CODE;
  164. task.TaskGroupKey = res.WMSTaskGroupKey;
  165. task.ADDRTO = task.DEVICE;
  166. var msg = $"下达从G1030移动至{dev.Data.Goodsend}的PLC指令。同时将任务分配至[{task.TUNNEL}]-[{task.DEVICE}]";
  167. msg += $"[{dev.Data.Tasknum}][G1030][{dev.Data.Goodsend}][{tunnelInfo.SRM.Entity.CODE}][{dev.Data.VoucherNo}[{dev.Data2.VoucherNo}]";
  168. task.CreateStatusLog(db, msg, this.GetType());
  169. finishTaskList.Add(new FinishTaskList<int>(task.ID, item.Entity.Create<StationDevice>()));
  170. }
  171. db.Default.SaveChanges();
  172. });
  173. // 开始将任务信息写入到设备
  174. DB.Do(db =>
  175. {
  176. foreach (var finishTask in finishTaskList)
  177. {
  178. var task = db.Default.Set<WCS_TASK>().Find(finishTask.FinishCode);
  179. if (task == null) continue;
  180. finishTask.Station.Data.Tasknum = task.ID;
  181. finishTask.Station.Data.Goodsstart = 1030;
  182. finishTask.Station.Data.Goodsend = task.ADDRNEXT.Replace("G", "").ToShort();
  183. finishTask.Station.Data.Goodsnum = finishTaskList.Count.ToShort();
  184. finishTask.Station.Data.CmdType = IstationCmdType.分配目标地址;
  185. finishTask.Station.Data.VoucherNo++;
  186. }
  187. });
  188. });
  189. }
  190. }
  191. [WorkTitle(typeof(ProductHandler), "一楼入库旋转台二次分配巷道")]
  192. internal class 一楼入库旋转台二次分配巷道 : Work<StationDeviceGroup>
  193. {
  194. protected override void Do(StationDeviceGroup obj)
  195. {
  196. obj.EX(obj =>
  197. {
  198. var code = obj.Entity.CODE;
  199. //两个设备都必须满足的条件
  200. if (obj.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) throw new WarnException("等待执行任务--凭证号不一致");
  201. if (obj.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) throw new DoException("运行中");
  202. //成功分配巷道的任务的任务
  203. var finishTaskList = new List<FinishTaskList<int>>();
  204. //变更数据库信息
  205. DB.Do(db =>
  206. {
  207. var devs = obj.Items.Where(v => v.Data2.Status.HasFlag(IstationStatus.光电状态) && v.Data2.Request == IstationRequest.请求分配目标地址)
  208. .Where(v => v.Data2.Tasknum > 10000);
  209. if (!devs.Any()) return; //无可执行任务
  210. var taskIds = devs.Select(dev => dev.Data2.Tasknum).ToList();
  211. var taskList = db.Default.Set<WCS_TASK>().Where(v => taskIds.Contains(v.ID)).ToList();
  212. taskList.ValidTaskCheck(devs.Count(), db);
  213. var res = WMS.GetTunnelList(taskList.Select(v => v.WMSTASK.ToString()).ToList(), code);
  214. if (string.IsNullOrEmpty(res.TunnelNum)) throw new WarnException($"WMS未返回巷道");
  215. var tunnelNo = res.TunnelNum.Split(',').Select(v => "TY" + v).ToList();
  216. var tunnels = Device.Where(v => tunnelNo.Contains(v.CODE)).ToList();
  217. List<TunnelInfo> tunnelInfos = new List<TunnelInfo>();
  218. foreach (var item in tunnels)
  219. {
  220. //当前巷道的取货点
  221. var allIn = Device.Where(v => v.Is(DF.SRM二级品取货)) //一楼所有取货点
  222. .Where(v => v.ROUTES.Any(p => p.NEXT == item)) //下一个点为当前巷道的取货点
  223. .Select(v => v.CODE)
  224. .ToList();
  225. //下一个目标地址包含取货点的设备,此时获得的数据是旋转台
  226. var turntable = Device.Where(v => v.IsConv() && v.ROUTES.Any(p => p.NEXT != null && allIn.Contains(p.NEXT.CODE)))
  227. .Where(v => obj.Items.Any(p => p.Entity == v))// 筛选出包含在当前设备组的设备
  228. .Distinct()
  229. .FirstOrDefault();//去一次重
  230. if (turntable == null) continue;
  231. var dev = Device.Where(p => p.CODE.StartsWith("G") && p.DEVICEGROUP.Any(d => d.MEMBER == turntable)).OrderBy(p => p.CODE).FirstOrDefault();
  232. tunnelInfos.Add(new TunnelInfo
  233. {
  234. Tunnel = item,
  235. taskIN = dev, //找到放货点设备所在组
  236. SRM = Device.Where(p => p.IsSC()).FirstOrDefault(p => item.ROUTES.Any(d => d.NEXT.CODE == p.CODE)).Create<SRMDevice>()
  237. });
  238. }
  239. //筛选出优先级最高的可用巷道
  240. 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; } })
  241. .OrderBy(v => tunnelNo.IndexOf(v.Tunnel.CODE)).FirstOrDefault();
  242. if (tunnelInfo == null) throw new WarnException("无可用巷道");
  243. //开始变更任务信息
  244. foreach (var item in devs)
  245. {
  246. var dev = item.Entity.Create<StationDevice>();
  247. var task = taskList.FirstOrDefault(p => p.ID == dev.Data2.Tasknum);
  248. if (task == null) throw new WarnException($"WCS无该任务{dev.Data2.Tasknum}--{dev.Entity.CODE}");
  249. task.DEVICE = tunnelInfo.SRM.Entity.CODE;
  250. task.TUNNEL = tunnelInfo.Tunnel.CODE;
  251. task.ADDRNEXT = tunnelInfo.taskIN.CODE;
  252. task.TaskGroupKey = res.WMSTaskGroupKey;
  253. task.ADDRTO = task.DEVICE;
  254. var msg = $"下达从{obj.Entity.CODE}移动至{dev.Data.Goodsend}的PLC指令。同时将任务分配至[{task.TUNNEL}]-[{task.DEVICE}]";
  255. msg += $"[{dev.Data.Tasknum}][{obj.Entity.CODE}][{dev.Data.Goodsend}][{tunnelInfo.SRM.Entity.CODE}][{dev.Data.VoucherNo}[{dev.Data2.VoucherNo}]";
  256. task.CreateStatusLog(db, msg, 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. //[WorkTitle(typeof(ProductHandler), "一楼RGV放货结束分配目标地址")]
  285. internal class 一楼RGV放货结束分配目标地址 : Work<StationDeviceGroup>
  286. {
  287. protected override void Do(StationDeviceGroup obj)
  288. {
  289. obj.EX(obj =>
  290. {
  291. if (obj.Items.Any(v => v.Data.VoucherNo != v.Data2.VoucherNo)) throw new WarnException($"等待执行任务,凭证号不一致");
  292. if (obj.Items.Any(v => v.Data3.Status.HasFlag(StationStatus.运行状态位))) throw new DoException("运行中");
  293. var finishTaskList = new List<FinishTaskList<int>>();
  294. var devs = new List<FinishTaskList<string>>();
  295. foreach (var dev in obj.Items)
  296. {
  297. if (dev.Data2.Request != IstationRequest.请求分配目标地址)
  298. {
  299. InfoLog.INFO_INFO($"{obj.Entity.CODE}无请求-分配目标地址--2");
  300. continue;
  301. }
  302. if (!dev.Data2.Status.HasFlag(IstationStatus.光电状态))
  303. {
  304. InfoLog.INFO_WarnDb($"{dev.Entity.CODE}有请求无光电", obj.Entity.CODE, WCS_EXCEPTIONTYPE.设备异常);
  305. continue;
  306. }
  307. devs.Add(new FinishTaskList<string>(dev.Entity.CODE, dev.Entity.Create<StationDevice>()));
  308. }
  309. DB.Do(db =>
  310. {
  311. foreach (var dev in devs)
  312. {
  313. var task = db.Default.Set<WCS_TASK>().FirstOrDefault(v => v.ID == dev.Station.Data2.Tasknum);
  314. var next = dev.Station.Entity.GetPath(task.ADDRTO);
  315. task.ADDRNEXT = next.CODE;
  316. var msg = $"下达从{dev.Station.Data.Goodsstart}移动至{dev.Station.Data.Goodsend}的PLC指令";
  317. msg += $"[{dev.Station.Data.Tasknum}][{dev.Station.Data.Goodsstart}][{dev.Station.Data.Goodsend}][{dev.Station.Data.VoucherNo}[{dev.Station.Data2.VoucherNo}]";
  318. task.CreateStatusLog(db, msg, this.GetType());
  319. finishTaskList.Add(new FinishTaskList<int>(task.ID, dev.Station));
  320. }
  321. db.Default.SaveChanges();
  322. });
  323. DB.Do(db =>
  324. {
  325. foreach (var finish in finishTaskList)
  326. {
  327. var task = db.Default.Set<WCS_TASK>().FirstOrDefault(v => v.ID == finish.FinishCode);
  328. if (task == null) continue;
  329. finish.Station.Data.Tasknum = task.ID;
  330. finish.Station.Data.Goodsstart = finish.Station.Entity.CODE.ToShort();
  331. finish.Station.Data.Goodsend = task.ADDRNEXT.ToShort();
  332. finish.Station.Data.CmdType = IstationCmdType.分配目标地址;
  333. finish.Station.Data.VoucherNo++;
  334. }
  335. });
  336. });
  337. }
  338. protected override bool SelectDevice(WCS_DEVICE dev)
  339. {
  340. return devCodes.Contains(dev.CODE);
  341. }
  342. private List<string> devCodes = new List<string>() { "G1035", "G1044", "G1053", "G1062" };
  343. }
  344. }