环形库分流点.cs 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667
  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. foreach (var maDuoZhanTai in maDuoZhanTaiList)
  267. {
  268. if (!maDuoXinXiList.Any(x => x.MaDuoGongWei == maDuoZhanTai))
  269. {
  270. if (CreateStackingInfo(db, taskInfo, wareHouse, maDuoZhanTai)) continue;
  271. }
  272. }
  273. #endregion 判断两个位置是否都有码垛信息,为没有的创建码垛信息
  274. #region 选取创建事件已分分配任务数量较多、或者创建事件较早的码垛信息,默认一个库就跑一个垛型,多个垛型会混料
  275. maDuoXinXiList = db.Queryable<BillRingPalletizingInfo>().Where(x => maDuoZhanTaiList.Contains(x.MaDuoGongWei) && x.Out == false).ToList().OrderByDescending(x => x.HaveQty).ThenBy(x => x.AddTime).ToList();
  276. if (maDuoXinXiList.Any(x => x.HWCountQty != x.HaveQty))
  277. {
  278. var maDuoXinXi = maDuoXinXiList.Where(x => x.HWCountQty != x.HaveQty).First(); //获取一个应该分配目标
  279. //分配当前轮子在垛形中的位置
  280. if (wareHouse.Code.Contains("N")) //北侧由大到小,出的时候刚好可用反过来;
  281. {
  282. //取当前任务SKU在任务中已有的信息
  283. var taksList = db.Queryable<WCS_TaskInfo>().Where(x => x.TaskGroupKey == maDuoXinXi.Id.ToString()).ToList();
  284. if (taksList.Count != maDuoXinXi.HaveQty)
  285. {
  286. World.Log($"码垛信息组【{maDuoXinXi.Id}】记录已有【{maDuoXinXi.HaveQty}】个轮子,但对应的任务信息有【{taksList.Count}】,请在WMS检查对应的任务信息", LogLevelEnum.High);
  287. return;
  288. }
  289. var cellMatCodeList = taksList.Where(x => x.MatCode == taskInfo.MatCode);
  290. //取当前SKU在垛形明细中所有的信息
  291. var bomSetInfos = db.Queryable<BillBomsetinfo>().Where(x =>
  292. x.BomSetHdrId == maDuoXinXi.BomSetGrpId && x.IsEmpty == 0 &&
  293. x.MatCode == taskInfo.MatCode).ToList();
  294. //取当前SKU在垛形明细中最大的一个坐标号,初始化时默认取第一个
  295. var lastXYNO = Convert.ToInt32(bomSetInfos.Select(x => Convert.ToInt32(x.XYNo))
  296. .OrderByDescending(x => x).First());
  297. if (cellMatCodeList.Any()) //货位中已有当前SKU的产品,取最小数,最小数表示最近入库的
  298. {
  299. lastXYNO = cellMatCodeList.OrderBy(x => x.WmsTask).First().WmsTask;
  300. var xyNo = bomSetInfos.Select(x => Convert.ToInt32(x.XYNo)).Where(x => x < lastXYNO).OrderByDescending(x => x).First();
  301. maDuoXinXi.LastXYNO = xyNo;
  302. }
  303. else
  304. {
  305. maDuoXinXi.LastXYNO = lastXYNO;
  306. }
  307. }
  308. else //南侧小到大,出的时候刚好可用反过来;
  309. {
  310. //取当前任务SKU在任务中已有的信息
  311. var taksList = db.Queryable<WCS_TaskInfo>().Where(x => x.TaskGroupKey == maDuoXinXi.Id.ToString()).ToList();
  312. if (taksList.Count != maDuoXinXi.HaveQty)
  313. {
  314. World.Log($"码垛信息组【{maDuoXinXi.Id}】记录已有【{maDuoXinXi.HaveQty}】个轮子,但对应的任务信息有【{taksList.Count}】,请在WMS检查对应的任务信息", LogLevelEnum.High);
  315. return;
  316. }
  317. var cellMatCodeList = taksList.Where(x => x.MatCode == taskInfo.MatCode);
  318. //取当前SKU在垛形明细中所有的信息
  319. var bomSetInfos = db.Queryable<BillBomsetinfo>().Where(x =>
  320. x.BomSetHdrId == maDuoXinXi.BomSetGrpId && x.IsEmpty == 0 &&
  321. x.MatCode == taskInfo.MatCode).ToList();
  322. //取当前SKU在垛形明细中最小的一个坐标号 ,初始化时默认取第一个
  323. var lastXYNO = Convert.ToInt32(bomSetInfos.Select(x => Convert.ToInt32(x.XYNo)).OrderBy(x => x).First());
  324. if (cellMatCodeList.Any()) //货位中已有当前SKU的产品,取最大数 最大数表示最近入库的
  325. {
  326. lastXYNO = cellMatCodeList.OrderByDescending(x => x.WmsTask).First().WmsTask;
  327. var xyNo = bomSetInfos.Select(x => Convert.ToInt32(x.XYNo)).Where(x => x > lastXYNO)
  328. .OrderBy(x => x).First();
  329. maDuoXinXi.LastXYNO = xyNo;
  330. }
  331. else
  332. {
  333. maDuoXinXi.LastXYNO = lastXYNO;
  334. }
  335. }
  336. //检查分配位置是否已经分配过
  337. if (db.Queryable<WCS_TaskInfo>().NoLock().Any(x => x.TaskGroupKey == maDuoXinXi.Id.ToString() && x.WmsTask == maDuoXinXi.LastXYNO))
  338. {
  339. World.Log($"当前位置已经被分配过了,请检查异常码垛信息{maDuoXinXi.Id}-{maDuoXinXi.LastXYNO}", LogLevelEnum.High);
  340. return;
  341. }
  342. #region 更新码垛、任务相关信息
  343. // 获取下一个地址
  344. nextAdd = maDuoXinXi.MaDuoGongWei switch
  345. {
  346. "1661" => 435,
  347. "1666" => 444,
  348. "1676" => 635,
  349. "1681" => 644,
  350. "1691" => 835,
  351. "1696" => 844,
  352. "1706" => 1035,
  353. "1711" => 1044,
  354. "1721" => 1235,
  355. "1726" => 1244,
  356. "1736" => 1435,
  357. "1741" => 1444,
  358. _ => 9999
  359. };
  360. maDuoXinXi.HaveQty += 1;
  361. taskInfo.AddrNext = nextAdd.ToString();
  362. taskInfo.Status = TaskStatus.FinishOfShunt;
  363. taskInfo.EditTime = DateTime.Now;
  364. taskInfo.WarehouseCode = taskInfo.WarehouseCode.Contains("R") ? taskInfo.WarehouseCode : taskInfo.WarehouseCode + "R";
  365. taskInfo.AddrTo = "Robot";
  366. taskInfo.WmsTask = maDuoXinXi.LastXYNO;
  367. taskInfo.TaskGroupKey = maDuoXinXi.Id.ToString();
  368. taskInfo.GoodsType = goodsType;
  369. db.UpdateableRowLock(taskInfo).UpdateColumns(x => new { x.AddrNext, x.Status, x.EditTime, x.WarehouseCode, x.AddrTo, x.GoodsType, x.WmsTask, x.TaskGroupKey }).ExecuteCommand();
  370. taskInfo.AddWCS_TASK_DTL(db, obj.Entity.Code, nextAdd.ToString(), "工字轮完成环形库分流");
  371. db.Updateable(maDuoXinXi).UpdateColumns(x => new { x.LastXYNO, x.HaveQty }).ExecuteCommand();
  372. #endregion 更新码垛、任务相关信息
  373. }
  374. else //创建一个码垛信息
  375. {
  376. var maDuoXinXi = maDuoXinXiList.Where(x => x.HWCountQty == x.HaveQty).OrderBy(x => x.AddTime).First(); //获取一个已分配完成,但未码垛结束的目标
  377. CreateStackingInfo(db, taskInfo, wareHouse, maDuoXinXi.MaDuoGongWei);
  378. return;
  379. }
  380. #endregion 选取创建事件已分分配任务数量较多、或者创建事件较早的码垛信息,默认一个库就跑一个垛型,多个垛型会混料
  381. }
  382. else
  383. {
  384. taskInfo.AddrNext = nextAdd.ToString();
  385. taskInfo.Status = TaskStatus.FinishOfShunt;
  386. taskInfo.EditTime = DateTime.Now;
  387. taskInfo.WarehouseCode = taskInfo.WarehouseCode.Contains("R") ? taskInfo.WarehouseCode : taskInfo.WarehouseCode + "R";
  388. taskInfo.AddrTo = "Robot";
  389. taskInfo.GoodsType = goodsType;
  390. db.UpdateableRowLock(taskInfo).UpdateColumns(x => new { x.AddrNext, x.Status, x.EditTime, x.WarehouseCode, x.AddrTo, x.GoodsType }).ExecuteCommand();
  391. taskInfo.AddWCS_TASK_DTL(db, obj.Entity.Code, nextAdd.ToString(), "工字轮完成环形库分流");
  392. }
  393. }
  394. else
  395. {
  396. taskInfo.AddrNext = nextAdd.ToString();
  397. taskInfo.EditTime = DateTime.Now;
  398. taskInfo.GoodsType = goodsType;
  399. db.UpdateableRowLock(taskInfo).UpdateColumns(x => new { x.AddrNext, x.EditTime, x.GoodsType }).ExecuteCommand();
  400. taskInfo.AddWCS_TASK_DTL(db, obj.Entity.Code, nextAdd.ToString(), "工字轮途径环形库分流点");
  401. }
  402. isPut = true;
  403. });
  404. if (!isPut) return;
  405. obj.Data.TaskNumber = taskId;
  406. obj.Data.TaskNumber = taskId;
  407. obj.Data.GoodsStart = obj.Entity.Code.ToShort();
  408. obj.Data.GoodsStart = obj.Entity.Code.ToShort();
  409. obj.Data.GoodsEnd = nextAdd;
  410. obj.Data.GoodsEnd = nextAdd;
  411. obj.Data.SetVoucherNo();
  412. World.Log($"执行记录:任务号[{taskId}]-[{obj.Data.VoucherNo}]");
  413. }
  414. private void WriteInfo(Device<IStation520, IStation521, IStation523, IStation91> device, WCS_TaskInfo task)
  415. {
  416. device.Data.TaskNumber = 2;
  417. device.Data.GoodsEnd = device.Entity.Code.ToShort();
  418. device.Data.VoucherNo++;
  419. World.Log($"南北流错执行记录:任务号[{task.ID}]-[{device.Data.TaskNumber}]-[{device.Data.VoucherNo}]");
  420. }
  421. /// <summary>
  422. /// 编辑流向
  423. /// </summary>
  424. public void EditFlow(WCS_TaskInfo task, string warehouseCode, SqlSugarScopeProvider db, string locCode)
  425. {
  426. WmsApi.EditorialFlow(new FjEditorialFlowRequest() { TaskId = task.ID, LocCode = locCode, WareCode = warehouseCode });
  427. task.WarehouseCode = warehouseCode;
  428. db.UpdateableRowLock(task).UpdateColumns(x => new { x.WarehouseCode }).ExecuteCommand();
  429. task.AddWCS_TASK_DTL(db, locCode, $"变更流向至{warehouseCode}");
  430. }
  431. public override bool Select(Device dev)
  432. {
  433. return dev.Code is "418" or "618" or "818" or "1018" or "1218" or "1418";
  434. }
  435. /// <summary>
  436. /// 检查凭证号是否满足条件
  437. /// </summary>
  438. /// <param name="obj"></param>
  439. /// <returns></returns>
  440. private bool CheckVoucherNoMismatch(Device<IStation520, IStation521, IStation523, IStation91> obj)
  441. {
  442. if (obj.Data.VoucherNo != obj.Data2.VoucherNo)
  443. {
  444. if (obj.Data2.TaskNumber != 0 && obj.Data2.TaskNumber != 2)
  445. {
  446. obj.Data.TaskNumber = obj.Data2.TaskNumber;
  447. World.Log($"复写:{obj.Data.TaskNumber}");
  448. }
  449. World.Log($"凭证号不一致,DB520:{obj.Data.VoucherNo}-DB521:{obj.Data2.VoucherNo}", LogLevelEnum.Mid);
  450. return true;
  451. }
  452. return false;
  453. }
  454. /// <summary>
  455. /// 处理异常任务
  456. /// </summary>
  457. /// <param name="db">数据库连接</param>
  458. /// <param name="taskInfo">任务信息</param>
  459. /// <param name="addrFrom">异常任务起始地址,即当前设备号</param>
  460. /// <param name="devTaskNumber">设备中的任务号</param>
  461. /// <param name="goodsType">产品类型,即外检结果</param>
  462. /// <returns></returns>
  463. private bool HandleExceptionTask(SqlSugarScopeProvider db, WCS_TaskInfo? taskInfo, string addrFrom, int devTaskNumber, int goodsType)
  464. {
  465. var type = goodsType.ToString();
  466. //找到一条起点是当前位置且状态小于2的任务
  467. 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);
  468. if (taskInfo == null)
  469. {
  470. switch (devTaskNumber)
  471. {
  472. case 1:
  473. WmsApi.PalletizingCreateseErrorTasks(addrFrom, type);
  474. break;
  475. case 3: //bc质量
  476. WmsApi.PalletizingCreateseErrorTasks(addrFrom, type, 3);
  477. break;
  478. case 2: //南北流错
  479. WmsApi.PalletizingCreateseErrorTasks(addrFrom, type, 2);
  480. break;
  481. }
  482. return true;
  483. }
  484. if (taskInfo.Status == TaskStatus.NewBuild)
  485. {
  486. //更新任务状态
  487. taskInfo.Status = TaskStatus.WaitingToExecute;
  488. taskInfo.EditTime = DateTime.Now;
  489. taskInfo.EditWho = "WCS";
  490. db.UpdateableRowLock(taskInfo).ExecuteCommand();
  491. taskInfo.AddWCS_TASK_DTL(db, addrFrom, $"初始化异常轮入库任务信息");
  492. return true;
  493. }
  494. return false;
  495. }
  496. /// <summary>
  497. /// 创建一条码垛信息
  498. /// </summary>
  499. /// <param name="db">数据库连接</param>
  500. /// <param name="taskInfo">任务信息</param>
  501. /// <param name="wareHouse">仓库信息</param>
  502. /// <param name="maDuoGongWei">码垛工位</param>
  503. /// <returns></returns>
  504. private bool CreateStackingInfo(SqlSugarScopeProvider db, WCS_TaskInfo taskInfo, BaseWarehouse wareHouse, string maDuoGongWei)
  505. {
  506. var bomsetGrp = db.Queryable<BillBomsetgrp>().NoLock().First(x => x.IsStop == 0 && x.BomCode.Contains(taskInfo.MatCode));
  507. if (bomsetGrp == null)
  508. {
  509. World.Log($"未找到对应垛型信息,请确认是否被禁用", LogLevelEnum.High);
  510. return true;
  511. }
  512. var xyNo = db.Queryable<BillBomsetinfo>().NoLock().Where(x => x.BomSetHdrId == bomsetGrp.Id && x.IsEmpty == 0)
  513. .ToList().Select(x => Convert.ToInt32(x.XYNo)).OrderByDescending(x => x).First();
  514. //跟据垛形信息生成
  515. var ringPalletizingInfo = new BillRingPalletizingInfo
  516. {
  517. Id = IdFactory.NewId(),
  518. WareHouseId = wareHouse.Id,
  519. BomSetGrpId = bomsetGrp.Id,
  520. HWCountQty = bomsetGrp.HWCountQty,
  521. BomCode = bomsetGrp.BomCode,
  522. HaveQty = 0,
  523. Out = false,
  524. LastXYNO = wareHouse.Code.Contains("N") ? xyNo + 1 : 0,
  525. MaDuoGongWei = maDuoGongWei
  526. };
  527. db.Insertable(ringPalletizingInfo);
  528. return false;
  529. }
  530. /// <summary>
  531. /// 计算非零九的去向
  532. /// </summary>
  533. /// <param name="obj"></param>
  534. /// <returns></returns>
  535. public short GetNext(Device<IStation520, IStation521, IStation523, IStation91> obj)
  536. {
  537. return obj.Data4.Length switch
  538. {
  539. 9 => obj.Entity.Code switch
  540. {
  541. "418" => 455,
  542. "618" => 655,
  543. "818" => 855,
  544. "1018" => 1055,
  545. "1218" => 1255,
  546. "1418" => 1455,
  547. _ => 9999
  548. },
  549. 18 => obj.Entity.Code switch
  550. {
  551. "418" => 444,
  552. "618" => 644,
  553. "818" => 844,
  554. "1018" => 1044,
  555. "1218" => 1244,
  556. "1418" => 1444,
  557. _ => 9999
  558. },
  559. 50 => obj.Entity.Code switch
  560. {
  561. "418" => 426,
  562. "618" => 626,
  563. "818" => 826,
  564. "1018" => 1026,
  565. "1218" => 1226,
  566. "1418" => 1426,
  567. _ => 9999
  568. },
  569. 34 => obj.Entity.Code switch
  570. {
  571. "418" => 435,
  572. "618" => 635,
  573. "818" => 835,
  574. "1018" => 1035,
  575. "1218" => 1235,
  576. "1418" => 1435,
  577. _ => 9999
  578. },
  579. _ => 9999
  580. };
  581. }
  582. public Device? GetRobotDevice(Device dev)
  583. {
  584. var robotCode = dev.Code switch
  585. {
  586. "418" => "Robot1",
  587. "618" => "Robot2",
  588. "818" => "Robot3",
  589. "1018" => "Robot4",
  590. "1218" => "Robot5",
  591. "1418" => "Robot6",
  592. _ => "99999"
  593. };
  594. return Device.All.FirstOrDefault(v => v.Code == robotCode);
  595. }
  596. }
  597. }