环形库分流点.cs 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670
  1. using PlcSiemens.Core.Extension;
  2. using ServiceCenter.Extensions;
  3. using ServiceCenter.Logs;
  4. using ServiceCenter.SqlSugars;
  5. using SqlSugar;
  6. using System.ComponentModel;
  7. using WCS.Core;
  8. using WCS.Entity;
  9. using WCS.Entity.Protocol.Station;
  10. using WCS.WorkEngineering.Extensions;
  11. using WCS.WorkEngineering.Model.WMS;
  12. using WCS.WorkEngineering.WebApi.Controllers;
  13. using WCS.WorkEngineering.WebApi.Models.WMS.Request;
  14. using WCS.WorkEngineering.Worlds;
  15. using TaskStatus = WCS.Entity.TaskStatus;
  16. namespace WCS.WorkEngineering.Systems
  17. {
  18. /// <summary>
  19. /// 分流点
  20. /// </summary>
  21. [BelongTo(typeof(SortingBranchWorld))]
  22. [Description("环形库分流点")]
  23. public class 环形库分流点 : DeviceSystem<Device<IStation520, IStation521, IStation523, IStation91>>
  24. {
  25. protected override bool ParallelDo => true;
  26. public override void Do(Device<IStation520, IStation521, IStation523, IStation91> obj)
  27. {
  28. #region 执行条件检查
  29. if (CheckVoucherNoMismatch(obj)) return;
  30. if (obj.Data3.Status.HasFlag(StationStatus.Run))
  31. {
  32. World.Log("设备运行中");
  33. return;
  34. }
  35. if (!obj.Data3.Status.HasFlag(StationStatus.OT_Status))
  36. {
  37. World.Log("站台货物信息与实际占用不一致", LogLevelEnum.Mid);
  38. return;
  39. }
  40. if (!obj.Data3.Status.HasFlag(StationStatus.PH_Status))
  41. {
  42. World.Log("站台无光电信息", LogLevelEnum.Mid);
  43. return;
  44. }
  45. if (obj.Data2.Request != 1)
  46. {
  47. World.Log("无请求", LogLevelEnum.Mid);
  48. return;
  49. }
  50. #endregion 执行条件检查
  51. var isPut = false;
  52. var nextAdd = GetNext(obj);
  53. if (nextAdd == 9999) return;
  54. var goodsType = obj.Data4.Length.ToInt();
  55. int taskId = 0;
  56. SqlSugarHelper.Do(_db =>
  57. {
  58. var db = _db.Default;
  59. WCS_TaskInfo? taskInfo = null;
  60. #region 处理异常任务
  61. if (obj.Data2.TaskNumber == 1 || obj.Data2.TaskNumber == 3 || obj.Data2.TaskNumber == 2)
  62. {
  63. if (HandleExceptionTask(db, taskInfo, obj.Entity.Code, obj.Data2.TaskNumber, goodsType)) return;
  64. }
  65. #endregion 处理异常任务
  66. taskInfo = db.Queryable<WCS_TaskInfo>().NoLock().First(v => v.ID == obj.Data2.TaskNumber && v.Status < TaskStatus.FinishOfShunt);
  67. if (taskInfo == null)
  68. {
  69. taskInfo = db.Queryable<WCS_TaskInfo>().NoLock().First(x => x.AddrFrom == obj.Entity.Code && x.BarCode.Contains("Error") && x.Status == TaskStatus.WaitingToExecute && x.AddrNext == null && x.GoodsType == goodsType);
  70. if (taskInfo == null)
  71. {
  72. World.Log($"未找到对应的WCS任务{obj.Data2.TaskNumber},1", LogLevelEnum.High);
  73. return;
  74. }
  75. }
  76. if (taskInfo.AddTime < DateTime.Now.AddHours(-12) && obj.Data2.TaskNumber == taskInfo.ID)
  77. {
  78. obj.Data.TaskNumber = 1;
  79. obj.Data.GoodsEnd = obj.Entity.Code.ToShort();
  80. obj.Data.VoucherNo++;
  81. World.Log($"超时执行记录:任务号[{taskInfo.ID}]-[{obj.Data.TaskNumber}]-[{obj.Data.VoucherNo}]");
  82. return;
  83. }
  84. if (taskInfo.Grade != null && (taskInfo.Grade.ToUpper() != "A") && obj.Data2.TaskNumber == taskInfo.ID)
  85. {
  86. obj.Data.TaskNumber = 3;
  87. obj.Data.GoodsEnd = obj.Entity.Code.ToShort();
  88. obj.Data.VoucherNo++;
  89. World.Log($"BC执行记录:任务号[{taskInfo.ID}]-[{obj.Data.TaskNumber}]-[{obj.Data.VoucherNo}]");
  90. return;
  91. }
  92. if (!taskInfo.BarCode.Contains("Error"))
  93. {
  94. switch (goodsType)
  95. {
  96. case 9 when !taskInfo.BarCode.Contains("HAWS09"):
  97. World.Log($"外检结果与任务条码不匹配--外检结果:[{goodsType}]-条码[{taskInfo.BarCode}]", LogLevelEnum.High);
  98. return;
  99. case 18 when !taskInfo.BarCode.Contains("HAWS18"):
  100. World.Log($"外检结果与任务条码不匹配--外检结果:[{goodsType}]-条码[{taskInfo.BarCode}]", LogLevelEnum.High);
  101. return;
  102. case 34 when !taskInfo.BarCode.Contains("HAWS34"):
  103. World.Log($"外检结果与任务条码不匹配--外检结果:[{goodsType}]-条码[{taskInfo.BarCode}]", LogLevelEnum.High);
  104. return;
  105. case 50 when !taskInfo.BarCode.Contains("HAWS50"):
  106. World.Log($"外检结果与任务条码不匹配--外检结果:[{goodsType}]-条码[{taskInfo.BarCode}]", LogLevelEnum.High);
  107. return;
  108. }
  109. }
  110. switch (obj.Entity.Code)
  111. {
  112. case "418":
  113. if (taskInfo.WarehouseCode != "1N")
  114. {
  115. if (taskInfo.WarehouseCode.Contains("N"))
  116. {
  117. EditFlow(taskInfo, "1N", db, obj.Entity.Code);
  118. return;
  119. }
  120. WriteInfo(obj, taskInfo);
  121. return;
  122. }
  123. break;
  124. case "618":
  125. if (taskInfo.WarehouseCode != "1S")
  126. {
  127. if (taskInfo.WarehouseCode.Contains("S"))
  128. {
  129. EditFlow(taskInfo, "1S", db, obj.Entity.Code);
  130. return;
  131. }
  132. WriteInfo(obj, taskInfo);
  133. return;
  134. }
  135. break;
  136. case "818":
  137. if (taskInfo.WarehouseCode != "2N")
  138. {
  139. if (taskInfo.WarehouseCode.Contains("N"))
  140. {
  141. EditFlow(taskInfo, "2N", db, obj.Entity.Code);
  142. return;
  143. }
  144. WriteInfo(obj, taskInfo);
  145. return;
  146. }
  147. break;
  148. case "1018":
  149. if (taskInfo.WarehouseCode != "2S")
  150. {
  151. if (taskInfo.WarehouseCode.Contains("S"))
  152. {
  153. EditFlow(taskInfo, "2S", db, obj.Entity.Code);
  154. return;
  155. }
  156. WriteInfo(obj, taskInfo);
  157. return;
  158. }
  159. break;
  160. case "1218":
  161. if (taskInfo.WarehouseCode != "3N")
  162. {
  163. if (taskInfo.WarehouseCode.Contains("N"))
  164. {
  165. EditFlow(taskInfo, "3N", db, obj.Entity.Code);
  166. return;
  167. }
  168. WriteInfo(obj, taskInfo);
  169. return;
  170. }
  171. break;
  172. case "1418":
  173. if (taskInfo.WarehouseCode != "3S")
  174. {
  175. if (taskInfo.WarehouseCode.Contains("S"))
  176. {
  177. EditFlow(taskInfo, "3S", db, obj.Entity.Code);
  178. return;
  179. }
  180. WriteInfo(obj, taskInfo);
  181. return;
  182. }
  183. break;
  184. }
  185. var isTruss = false; //表示这个工字轮是要去桁架区域码垛的,默认不作处理
  186. if (goodsType == 18)
  187. {
  188. //判断这个垛型是否是到桁架区域进行码垛
  189. var toTruss = db.Queryable<BillBomsetgrp>().NoLock().First(x => x.BomCode.Contains(taskInfo.MatCode) && x.IsStop == 0);
  190. if (toTruss == null)
  191. {
  192. World.Log($"未找到任务{taskInfo.ID}对应垛型信息,请确认垛型是否停用", LogLevelEnum.Mid);
  193. return;
  194. }
  195. if (toTruss.IsTruss)
  196. {
  197. nextAdd = obj.Entity.Code switch
  198. {
  199. "418" => 455,
  200. "618" => 655,
  201. "818" => 855,
  202. "1018" => 1055,
  203. "1218" => 1255,
  204. "1418" => 1455,
  205. _ => 9999
  206. };
  207. isTruss = true;
  208. }
  209. }
  210. taskInfo = db.Queryable<WCS_TaskInfo>().ReadPastUpdLock().First(v => v.ID == obj.Data2.TaskNumber && v.Status < TaskStatus.FinishOfShunt && !v.BarCode.Contains("Error"));
  211. if (taskInfo == null)
  212. {
  213. taskInfo = db.Queryable<WCS_TaskInfo>().ReadPastUpdLock().First(x => x.AddrFrom == obj.Entity.Code && x.BarCode.Contains("Error") && x.Status == TaskStatus.WaitingToExecute && x.AddrNext == null && x.GoodsType == goodsType);
  214. if (taskInfo == null)
  215. {
  216. World.Log($"未找到对应的WCS任务{obj.Data2.TaskNumber},2", LogLevelEnum.Mid);
  217. return;
  218. }
  219. ;
  220. }
  221. taskId = taskInfo.ID;
  222. if (goodsType != 9 && !isTruss) //09工字轮在环形库分流点只分配下一个地址,不作任何变更
  223. {
  224. //判断是否为直接码垛
  225. var robot = GetRobotDevice(obj.Entity);
  226. if (robot == null)
  227. {
  228. World.Log($"未检索到对应的机械臂设备号", LogLevelEnum.High);
  229. return;
  230. }
  231. if (robot.GetIsDirectPalletizing(db)) //是直接码垛
  232. {
  233. var warehouseCode = taskInfo.WarehouseCode.Contains("R") ? taskInfo.WarehouseCode : taskInfo.WarehouseCode + "R";
  234. var wareHouse = db.Queryable<BaseWarehouse>().First(x => x.Code == warehouseCode);
  235. //获取两个对应的环形库码垛工位
  236. List<string> maDuoZhanTaiList = new List<string>();
  237. switch (robot.Code)
  238. {
  239. case "Robot1":
  240. maDuoZhanTaiList.Add("1661");
  241. maDuoZhanTaiList.Add("1666");
  242. break;
  243. case "Robot2":
  244. maDuoZhanTaiList.Add("1676");
  245. maDuoZhanTaiList.Add("1681");
  246. break;
  247. case "Robot3":
  248. maDuoZhanTaiList.Add("1691");
  249. maDuoZhanTaiList.Add("1696");
  250. break;
  251. case "Robot4":
  252. maDuoZhanTaiList.Add("1706");
  253. maDuoZhanTaiList.Add("1711");
  254. break;
  255. case "Robot5":
  256. maDuoZhanTaiList.Add("1721");
  257. maDuoZhanTaiList.Add("1726");
  258. break;
  259. case "Robot6":
  260. maDuoZhanTaiList.Add("1736");
  261. maDuoZhanTaiList.Add("1741");
  262. break;
  263. }
  264. #region 判断两个位置是否都有码垛信息,为没有的创建码垛信息
  265. var maDuoXinXiList = db.Queryable<BillRingPalletizingInfo>().Where(x => maDuoZhanTaiList.Contains(x.MaDuoGongWei) && x.Out == false).ToList();
  266. bool isCreateStackingInfo = false;
  267. foreach (var maDuoZhanTai in maDuoZhanTaiList)
  268. {
  269. if (!maDuoXinXiList.Any(x => x.MaDuoGongWei == maDuoZhanTai))
  270. {
  271. if (CreateStackingInfo(db, taskInfo, wareHouse, maDuoZhanTai)) continue;
  272. isCreateStackingInfo = true;
  273. }
  274. }
  275. if (isCreateStackingInfo) return;
  276. #endregion 判断两个位置是否都有码垛信息,为没有的创建码垛信息
  277. #region 选取创建事件已分分配任务数量较多、或者创建事件较早的码垛信息,默认一个库就跑一个垛型,多个垛型会混料
  278. maDuoXinXiList = db.Queryable<BillRingPalletizingInfo>().Where(x => maDuoZhanTaiList.Contains(x.MaDuoGongWei) && x.Out == false).ToList().OrderByDescending(x => x.HaveQty).ThenBy(x => x.AddTime).ToList();
  279. if (maDuoXinXiList.Any(x => x.HWCountQty != x.HaveQty))
  280. {
  281. var maDuoXinXi = maDuoXinXiList.Where(x => x.HWCountQty != x.HaveQty).First(); //获取一个应该分配目标
  282. //分配当前轮子在垛形中的位置
  283. if (wareHouse.Code.Contains("N")) //北侧由大到小,出的时候刚好可用反过来;
  284. {
  285. //取当前任务SKU在任务中已有的信息
  286. var taksList = db.Queryable<WCS_TaskInfo>().Where(x => x.TaskGroupKey == maDuoXinXi.Id.ToString()).ToList();
  287. if (taksList.Count != maDuoXinXi.HaveQty)
  288. {
  289. World.Log($"码垛信息组【{maDuoXinXi.Id}】记录已有【{maDuoXinXi.HaveQty}】个轮子,但对应的任务信息有【{taksList.Count}】,请在WMS检查对应的任务信息", LogLevelEnum.High);
  290. return;
  291. }
  292. var cellMatCodeList = taksList.Where(x => x.MatCode == taskInfo.MatCode);
  293. //取当前SKU在垛形明细中所有的信息
  294. var bomSetInfos = db.Queryable<BillBomsetinfo>().Where(x =>
  295. x.BomSetHdrId == maDuoXinXi.BomSetGrpId && x.IsEmpty == 0 &&
  296. x.MatCode == taskInfo.MatCode).ToList();
  297. //取当前SKU在垛形明细中最大的一个坐标号,初始化时默认取第一个
  298. var lastXYNO = Convert.ToInt32(bomSetInfos.Select(x => Convert.ToInt32(x.XYNo))
  299. .OrderByDescending(x => x).First());
  300. if (cellMatCodeList.Any()) //货位中已有当前SKU的产品,取最小数,最小数表示最近入库的
  301. {
  302. lastXYNO = cellMatCodeList.OrderBy(x => x.WmsTask).First().WmsTask;
  303. var xyNo = bomSetInfos.Select(x => Convert.ToInt32(x.XYNo)).Where(x => x < lastXYNO).OrderByDescending(x => x).First();
  304. maDuoXinXi.LastXYNO = xyNo;
  305. }
  306. else
  307. {
  308. maDuoXinXi.LastXYNO = lastXYNO;
  309. }
  310. }
  311. else //南侧小到大,出的时候刚好可用反过来;
  312. {
  313. //取当前任务SKU在任务中已有的信息
  314. var taksList = db.Queryable<WCS_TaskInfo>().Where(x => x.TaskGroupKey == maDuoXinXi.Id.ToString()).ToList();
  315. if (taksList.Count != maDuoXinXi.HaveQty)
  316. {
  317. World.Log($"码垛信息组【{maDuoXinXi.Id}】记录已有【{maDuoXinXi.HaveQty}】个轮子,但对应的任务信息有【{taksList.Count}】,请在WMS检查对应的任务信息", LogLevelEnum.High);
  318. return;
  319. }
  320. var cellMatCodeList = taksList.Where(x => x.MatCode == taskInfo.MatCode);
  321. //取当前SKU在垛形明细中所有的信息
  322. var bomSetInfos = db.Queryable<BillBomsetinfo>().Where(x =>
  323. x.BomSetHdrId == maDuoXinXi.BomSetGrpId && x.IsEmpty == 0 &&
  324. x.MatCode == taskInfo.MatCode).ToList();
  325. //取当前SKU在垛形明细中最小的一个坐标号 ,初始化时默认取第一个
  326. var lastXYNO = Convert.ToInt32(bomSetInfos.Select(x => Convert.ToInt32(x.XYNo)).OrderBy(x => x).First());
  327. if (cellMatCodeList.Any()) //货位中已有当前SKU的产品,取最大数 最大数表示最近入库的
  328. {
  329. lastXYNO = cellMatCodeList.OrderByDescending(x => x.WmsTask).First().WmsTask;
  330. var xyNo = bomSetInfos.Select(x => Convert.ToInt32(x.XYNo)).Where(x => x > lastXYNO)
  331. .OrderBy(x => x).First();
  332. maDuoXinXi.LastXYNO = xyNo;
  333. }
  334. else
  335. {
  336. maDuoXinXi.LastXYNO = lastXYNO;
  337. }
  338. }
  339. //检查分配位置是否已经分配过
  340. if (db.Queryable<WCS_TaskInfo>().NoLock().Any(x => x.TaskGroupKey == maDuoXinXi.Id.ToString() && x.WmsTask == maDuoXinXi.LastXYNO))
  341. {
  342. World.Log($"当前位置已经被分配过了,请检查异常码垛信息{maDuoXinXi.Id}-{maDuoXinXi.LastXYNO}", LogLevelEnum.High);
  343. return;
  344. }
  345. #region 更新码垛、任务相关信息
  346. // 获取下一个地址
  347. nextAdd = maDuoXinXi.MaDuoGongWei switch
  348. {
  349. "1661" => 435,
  350. "1666" => 444,
  351. "1676" => 635,
  352. "1681" => 644,
  353. "1691" => 835,
  354. "1696" => 844,
  355. "1706" => 1035,
  356. "1711" => 1044,
  357. "1721" => 1235,
  358. "1726" => 1244,
  359. "1736" => 1435,
  360. "1741" => 1444,
  361. _ => 9999
  362. };
  363. maDuoXinXi.HaveQty += 1;
  364. taskInfo.AddrNext = nextAdd.ToString();
  365. taskInfo.Status = TaskStatus.FinishOfShunt;
  366. taskInfo.EditTime = DateTime.Now;
  367. taskInfo.WarehouseCode = taskInfo.WarehouseCode.Contains("R") ? taskInfo.WarehouseCode : taskInfo.WarehouseCode + "R";
  368. taskInfo.AddrTo = "Robot";
  369. taskInfo.WmsTask = maDuoXinXi.LastXYNO;
  370. taskInfo.TaskGroupKey = maDuoXinXi.Id.ToString();
  371. taskInfo.GoodsType = goodsType;
  372. db.UpdateableRowLock(taskInfo).UpdateColumns(x => new { x.AddrNext, x.Status, x.EditTime, x.WarehouseCode, x.AddrTo, x.GoodsType, x.WmsTask, x.TaskGroupKey }).ExecuteCommand();
  373. taskInfo.AddWCS_TASK_DTL(db, obj.Entity.Code, nextAdd.ToString(), "工字轮完成环形库分流");
  374. db.Updateable(maDuoXinXi).UpdateColumns(x => new { x.LastXYNO, x.HaveQty }).ExecuteCommand();
  375. #endregion 更新码垛、任务相关信息
  376. }
  377. else //创建一个码垛信息
  378. {
  379. var maDuoXinXi = maDuoXinXiList.Where(x => x.HWCountQty == x.HaveQty).OrderBy(x => x.AddTime).FirstOrDefault(); //获取一个已分配完成,但未码垛结束的目标
  380. CreateStackingInfo(db, taskInfo, wareHouse, maDuoXinXi.MaDuoGongWei);
  381. return;
  382. }
  383. #endregion 选取创建事件已分分配任务数量较多、或者创建事件较早的码垛信息,默认一个库就跑一个垛型,多个垛型会混料
  384. }
  385. else
  386. {
  387. taskInfo.AddrNext = nextAdd.ToString();
  388. taskInfo.Status = TaskStatus.FinishOfShunt;
  389. taskInfo.EditTime = DateTime.Now;
  390. taskInfo.WarehouseCode = taskInfo.WarehouseCode.Contains("R") ? taskInfo.WarehouseCode : taskInfo.WarehouseCode + "R";
  391. taskInfo.AddrTo = "Robot";
  392. taskInfo.GoodsType = goodsType;
  393. db.UpdateableRowLock(taskInfo).UpdateColumns(x => new { x.AddrNext, x.Status, x.EditTime, x.WarehouseCode, x.AddrTo, x.GoodsType }).ExecuteCommand();
  394. taskInfo.AddWCS_TASK_DTL(db, obj.Entity.Code, nextAdd.ToString(), "工字轮完成环形库分流");
  395. }
  396. }
  397. else
  398. {
  399. taskInfo.AddrNext = nextAdd.ToString();
  400. taskInfo.EditTime = DateTime.Now;
  401. taskInfo.GoodsType = goodsType;
  402. db.UpdateableRowLock(taskInfo).UpdateColumns(x => new { x.AddrNext, x.EditTime, x.GoodsType }).ExecuteCommand();
  403. taskInfo.AddWCS_TASK_DTL(db, obj.Entity.Code, nextAdd.ToString(), "工字轮途径环形库分流点");
  404. }
  405. isPut = true;
  406. });
  407. if (!isPut) return;
  408. obj.Data.TaskNumber = taskId;
  409. obj.Data.TaskNumber = taskId;
  410. obj.Data.GoodsStart = obj.Entity.Code.ToShort();
  411. obj.Data.GoodsStart = obj.Entity.Code.ToShort();
  412. obj.Data.GoodsEnd = nextAdd;
  413. obj.Data.GoodsEnd = nextAdd;
  414. obj.Data.SetVoucherNo();
  415. World.Log($"执行记录:任务号[{taskId}]-[{obj.Data.VoucherNo}]");
  416. }
  417. private void WriteInfo(Device<IStation520, IStation521, IStation523, IStation91> device, WCS_TaskInfo task)
  418. {
  419. device.Data.TaskNumber = 2;
  420. device.Data.GoodsEnd = device.Entity.Code.ToShort();
  421. device.Data.VoucherNo++;
  422. World.Log($"南北流错执行记录:任务号[{task.ID}]-[{device.Data.TaskNumber}]-[{device.Data.VoucherNo}]");
  423. }
  424. /// <summary>
  425. /// 编辑流向
  426. /// </summary>
  427. public void EditFlow(WCS_TaskInfo task, string warehouseCode, SqlSugarScopeProvider db, string locCode)
  428. {
  429. WmsApi.EditorialFlow(new FjEditorialFlowRequest() { TaskId = task.ID, LocCode = locCode, WareCode = warehouseCode });
  430. task.WarehouseCode = warehouseCode;
  431. db.UpdateableRowLock(task).UpdateColumns(x => new { x.WarehouseCode }).ExecuteCommand();
  432. task.AddWCS_TASK_DTL(db, locCode, $"变更流向至{warehouseCode}");
  433. }
  434. public override bool Select(Device dev)
  435. {
  436. return dev.Code is "418" or "618" or "818" or "1018" or "1218" or "1418";
  437. }
  438. /// <summary>
  439. /// 检查凭证号是否满足条件
  440. /// </summary>
  441. /// <param name="obj"></param>
  442. /// <returns></returns>
  443. private bool CheckVoucherNoMismatch(Device<IStation520, IStation521, IStation523, IStation91> obj)
  444. {
  445. if (obj.Data.VoucherNo != obj.Data2.VoucherNo)
  446. {
  447. if (obj.Data2.TaskNumber != 0 && obj.Data2.TaskNumber != 2)
  448. {
  449. obj.Data.TaskNumber = obj.Data2.TaskNumber;
  450. World.Log($"复写:{obj.Data.TaskNumber}");
  451. }
  452. World.Log($"凭证号不一致,DB520:{obj.Data.VoucherNo}-DB521:{obj.Data2.VoucherNo}", LogLevelEnum.Mid);
  453. return true;
  454. }
  455. return false;
  456. }
  457. /// <summary>
  458. /// 处理异常任务
  459. /// </summary>
  460. /// <param name="db">数据库连接</param>
  461. /// <param name="taskInfo">任务信息</param>
  462. /// <param name="addrFrom">异常任务起始地址,即当前设备号</param>
  463. /// <param name="devTaskNumber">设备中的任务号</param>
  464. /// <param name="goodsType">产品类型,即外检结果</param>
  465. /// <returns></returns>
  466. private bool HandleExceptionTask(SqlSugarScopeProvider db, WCS_TaskInfo? taskInfo, string addrFrom, int devTaskNumber, int goodsType)
  467. {
  468. var type = goodsType.ToString();
  469. //找到一条起点是当前位置且状态小于2的任务
  470. taskInfo = db.Queryable<WCS_TaskInfo>().NoLock().OrderBy(x => x.AddTime).First(x => x.Status < TaskStatus.FinishOfShunt && x.AddrFrom == addrFrom && x.BarCode.Contains("Error") && x.AddrNext == null && x.GoodsType == goodsType);
  471. if (taskInfo == null)
  472. {
  473. switch (devTaskNumber)
  474. {
  475. case 1:
  476. WmsApi.PalletizingCreateseErrorTasks(addrFrom, type);
  477. break;
  478. case 3: //bc质量
  479. WmsApi.PalletizingCreateseErrorTasks(addrFrom, type, 3);
  480. break;
  481. case 2: //南北流错
  482. WmsApi.PalletizingCreateseErrorTasks(addrFrom, type, 2);
  483. break;
  484. }
  485. return true;
  486. }
  487. if (taskInfo.Status == TaskStatus.NewBuild)
  488. {
  489. //更新任务状态
  490. taskInfo.Status = TaskStatus.WaitingToExecute;
  491. taskInfo.EditTime = DateTime.Now;
  492. taskInfo.EditWho = "WCS";
  493. db.UpdateableRowLock(taskInfo).ExecuteCommand();
  494. taskInfo.AddWCS_TASK_DTL(db, addrFrom, $"初始化异常轮入库任务信息");
  495. return true;
  496. }
  497. return false;
  498. }
  499. /// <summary>
  500. /// 创建一条码垛信息
  501. /// </summary>
  502. /// <param name="db">数据库连接</param>
  503. /// <param name="taskInfo">任务信息</param>
  504. /// <param name="wareHouse">仓库信息</param>
  505. /// <param name="maDuoGongWei">码垛工位</param>
  506. /// <returns></returns>
  507. private bool CreateStackingInfo(SqlSugarScopeProvider db, WCS_TaskInfo taskInfo, BaseWarehouse wareHouse, string maDuoGongWei)
  508. {
  509. var bomsetGrp = db.Queryable<BillBomsetgrp>().NoLock().First(x => x.IsStop == 0 && x.BomCode.Contains(taskInfo.MatCode));
  510. if (bomsetGrp == null)
  511. {
  512. World.Log($"未找到对应垛型信息,请确认是否被禁用", LogLevelEnum.High);
  513. return true;
  514. }
  515. var xyNo = db.Queryable<BillBomsetinfo>().NoLock().Where(x => x.BomSetHdrId == bomsetGrp.Id && x.IsEmpty == 0)
  516. .ToList().Select(x => Convert.ToInt32(x.XYNo)).OrderByDescending(x => x).First();
  517. //跟据垛形信息生成
  518. var ringPalletizingInfo = new BillRingPalletizingInfo
  519. {
  520. Id = IdFactory.NewId(),
  521. WareHouseId = wareHouse.Id,
  522. BomSetGrpId = bomsetGrp.Id,
  523. HWCountQty = bomsetGrp.HWCountQty,
  524. BomCode = bomsetGrp.BomCode,
  525. HaveQty = 0,
  526. Out = false,
  527. LastXYNO = wareHouse.Code.Contains("N") ? xyNo + 1 : 0,
  528. MaDuoGongWei = maDuoGongWei
  529. };
  530. db.Insertable(ringPalletizingInfo);
  531. return false;
  532. }
  533. /// <summary>
  534. /// 计算非零九的去向
  535. /// </summary>
  536. /// <param name="obj"></param>
  537. /// <returns></returns>
  538. public short GetNext(Device<IStation520, IStation521, IStation523, IStation91> obj)
  539. {
  540. return obj.Data4.Length switch
  541. {
  542. 9 => obj.Entity.Code switch
  543. {
  544. "418" => 455,
  545. "618" => 655,
  546. "818" => 855,
  547. "1018" => 1055,
  548. "1218" => 1255,
  549. "1418" => 1455,
  550. _ => 9999
  551. },
  552. 18 => obj.Entity.Code switch
  553. {
  554. "418" => 444,
  555. "618" => 644,
  556. "818" => 844,
  557. "1018" => 1044,
  558. "1218" => 1244,
  559. "1418" => 1444,
  560. _ => 9999
  561. },
  562. 50 => obj.Entity.Code switch
  563. {
  564. "418" => 426,
  565. "618" => 626,
  566. "818" => 826,
  567. "1018" => 1026,
  568. "1218" => 1226,
  569. "1418" => 1426,
  570. _ => 9999
  571. },
  572. 34 => obj.Entity.Code switch
  573. {
  574. "418" => 435,
  575. "618" => 635,
  576. "818" => 835,
  577. "1018" => 1035,
  578. "1218" => 1235,
  579. "1418" => 1435,
  580. _ => 9999
  581. },
  582. _ => 9999
  583. };
  584. }
  585. public Device? GetRobotDevice(Device dev)
  586. {
  587. var robotCode = dev.Code switch
  588. {
  589. "418" => "Robot1",
  590. "618" => "Robot2",
  591. "818" => "Robot3",
  592. "1018" => "Robot4",
  593. "1218" => "Robot5",
  594. "1418" => "Robot6",
  595. _ => "99999"
  596. };
  597. return Device.All.FirstOrDefault(v => v.Code == robotCode);
  598. }
  599. }
  600. }