NoInteractionSystems.cs 33 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532
  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.WebApi.Controllers;
  12. using WCS.WorkEngineering.WebApi.Models.WMS.Request;
  13. using WCS.WorkEngineering.Worlds;
  14. using DeviceFlags = WCS.WorkEngineering.Extensions.DeviceFlags;
  15. using TaskStatus = WCS.Entity.TaskStatus;
  16. namespace WCS.WorkEngineering.Systems
  17. {
  18. /// <summary>
  19. /// 无交互系统
  20. /// </summary>
  21. [BelongTo(typeof(NoInteractionWorld))]
  22. [Description("无交互系统")]
  23. public class NoInteractionSystems : DeviceSystem<Device<IStation520>>
  24. {
  25. protected override bool ParallelDo => true;
  26. public override void Do(Device<IStation520> obj)
  27. {
  28. var taskInfos = new List<int>();
  29. var sqlSugar = new SqlSugarHelper();
  30. SqlSugarHelper.Do(db =>
  31. {
  32. //获取所有的新建任务,组盘任务不需要
  33. taskInfos = db.Default.Queryable<WCS_TaskInfo>().ReadPastUpdLock().Where(x => x.Status == 0).ToList()
  34. .Where(x => x.Type != TaskType.SetPlate || (x.Type == TaskType.SetPlate && x.AddrFrom != "Robot")).Select(x => x.ID).ToList();
  35. var time = DateTime.Now.AddMinutes(-20);
  36. var time1 = DateTime.Now.AddMinutes(-40);
  37. var timeOut = db.Default.Queryable<WCS_TaskInfo>().NoLock().Count(x => x.BusType == "车间叫料" && x.Status < TaskStatus.StackerExecution && x.AddTime < time);
  38. if (timeOut > 0) World.Log($"共有{timeOut}个车间叫料任务超过二十分钟未执行,请检查相关相关任务对应的堆垛机是否正常、堆垛机放货点是否卡任务等", LogLevelEnum.High);
  39. var timeOut1 = db.Default.Queryable<WCS_TaskInfo>().NoLock().Count(x => x.BusType == "车间叫料" && x.Status < TaskStatus.StackerExecution && x.AddTime < time1);
  40. if (timeOut1 > 0) World.Log($"共有{timeOut1}个车间叫料任务超过四十分钟未执行,请检查相关相关任务对应的堆垛机是否正常、堆垛机放货点是否卡任务等", LogLevelEnum.High);
  41. var timeOut2 = db.Default.Queryable<WCS_TaskInfo>().NoLock().Count(x => x.BusType == "皮盘入库" && x.Status < TaskStatus.StackerExecution && x.AddTime < time);
  42. if (timeOut2 > 0) World.Log($"共有{timeOut2}个皮盘入库任务超过二十分钟未执行,请检查相关相关任务及对应agv设备", LogLevelEnum.High);
  43. var timeOut3 = db.Default.Queryable<WCS_TaskInfo>().NoLock().Count(x => x.BusType == "皮盘入库" && x.Status < TaskStatus.StackerExecution && x.AddTime < time1);
  44. if (timeOut3 > 0) World.Log($"共有{timeOut3}个皮盘入库任务超过四十分钟未执行,请检查相关相关任务及对应agv设备", LogLevelEnum.High);
  45. var time3 = DateTime.Now.AddHours(-24);
  46. var timeOut4 = db.Default.Queryable<BillInvnow>().NoLock().Count(x => x.AddTime < time3);
  47. if (timeOut4 > 0) World.Log($"共有{timeOut4}个库存信息超过24小时未执行,请检查相关库存信息并处理", LogLevelEnum.High);
  48. });
  49. if (!taskInfos.Any())
  50. {
  51. return;
  52. }
  53. var isEnd = false; //每个周期只处理一个任务
  54. foreach (var item in taskInfos)
  55. {
  56. if (isEnd) return;
  57. try
  58. {
  59. SqlSugarHelper.Do(db =>
  60. {
  61. var task = db.Default.Queryable<WCS_TaskInfo>().Where(t => t.ID == item).First();
  62. switch (task.Type)
  63. {
  64. case TaskType.SetPlate:
  65. if (task.AddrFrom != "Robot")
  66. {
  67. //更新任务状态
  68. task.Status = TaskStatus.WaitingToExecute;
  69. db.Default.UpdateableRowLock(task).UpdateColumns(x => new { x.Status }).ExecuteCommand();
  70. task.AddWCS_TASK_DTL(db.Default, task.Device, $"初始化入库任务信息");
  71. isEnd = true;
  72. }
  73. break;
  74. case TaskType.EnterDepot:
  75. if (task.LastInteractionPoint == "2")
  76. {
  77. var sta = GetAgvStation(task, db);
  78. var agv = new WCS_AgvTaskInfo()
  79. {
  80. ID = db.GetAgvTaskId(),
  81. TaskType = AGVTaskType.EnterDepot,
  82. Status = AGVTaskStatus.NewBuild,
  83. TaskId = task.ID,
  84. Position = task.WorkBench,
  85. Station = sta,
  86. AddWho = "WCS",
  87. AddTime = DateTime.Now
  88. };
  89. db.Default.InsertableRowLock(agv).SplitTable().ExecuteCommand();
  90. task.AgvTaskID = agv.ID;
  91. task.Status = Entity.TaskStatus.WaitingToExecute;
  92. db.Default.UpdateableRowLock(task).UpdateColumns(x => new { x.Status, x.AgvTaskID }).ExecuteCommand();
  93. task.AddWCS_TASK_DTL(db.Default, task.Device, $"初始化单独返皮盘任务");
  94. }
  95. else if (task.BusType == TaskBusType.芯股用空托盘入库.GetDescription()) return;
  96. else if (task.BusType == TaskBusType.人工满托入库.GetDescription())
  97. {
  98. var agv = new WCS_AgvTaskInfo()
  99. {
  100. ID = db.GetAgvTaskId(),
  101. TaskType = AGVTaskType.EnterDepot,
  102. Status = AGVTaskStatus.NewBuild,
  103. TaskId = task.ID,
  104. Position = task.WorkBench,
  105. Station = task.WarehouseCode switch
  106. {
  107. "1N" => "2533",
  108. "1S" => "2733",
  109. "2N" => "2933",
  110. "2S" => "3133",
  111. _ => "2533"
  112. },
  113. AddWho = "WCS",
  114. AddTime = DateTime.Now
  115. };
  116. db.Default.InsertableRowLock(agv).SplitTable().ExecuteCommand();
  117. task.AgvTaskID = agv.ID;
  118. task.Device = task.WarehouseCode switch
  119. {
  120. "1N" => "TY1",
  121. "1S" => "TY2",
  122. "2N" => "TY3",
  123. "2S" => "TY4",
  124. _ => "TY1"
  125. };
  126. task.Height = 1;
  127. task.Status = Entity.TaskStatus.WaitingToExecute;
  128. db.Default.UpdateableRowLock(task).UpdateColumns(x => new { x.Status, x.AgvTaskID, x.Device, x.Height }).ExecuteCommand();
  129. task.AddWCS_TASK_DTL(db.Default, task.Device, $"初始化人工满托入库任务");
  130. }
  131. else if (task.BusType == TaskBusType.重绕满托入库.GetDescription())
  132. {
  133. task.Status = Entity.TaskStatus.WaitingToExecute;
  134. db.Default.UpdateableRowLock(task).UpdateColumns(x => new { x.Status }).ExecuteCommand();
  135. task.AddWCS_TASK_DTL(db.Default, task.Device, $"初始化入库任务信息");
  136. }
  137. else if (task.BusType == TaskBusType.帘线退料重绕.GetDescription())
  138. {
  139. var agv = new WCS_AgvTaskInfo()
  140. {
  141. ID = db.GetAgvTaskId(),
  142. TaskType = AGVTaskType.EnterDepot,
  143. Status = AGVTaskStatus.NewBuild,
  144. TaskId = task.ID,
  145. Position = task.WorkBench,
  146. WorkShop = 222,
  147. Station = "9001",
  148. AddWho = "WCS",
  149. AddTime = DateTime.Now
  150. };
  151. db.Default.InsertableRowLock(agv).SplitTable().ExecuteCommand();
  152. task.Status = Entity.TaskStatus.WaitingToExecute;
  153. db.Default.UpdateableRowLock(task).UpdateColumns(x => new { x.Status }).ExecuteCommand();
  154. task.AddWCS_TASK_DTL(db.Default, task.Device, $"初始化入库任务信息");
  155. }
  156. else
  157. {
  158. //更新任务状态
  159. task.Status = Entity.TaskStatus.WaitingToExecute;
  160. task.Device = task.WarehouseCode switch
  161. {
  162. "1N" => "SRM1",
  163. "1S" => "SRM2",
  164. "2N" => "SRM3",
  165. "2S" => "SRM4",
  166. "3N" => "SRM5",
  167. "3S" => "SRM6",
  168. _ => task.Device
  169. };
  170. task.Device = task.AddrFrom switch
  171. {
  172. "1666" or "1661" => "SRM1",
  173. "1681" or "1676" => "SRM2",
  174. "1696" or "1691" => "SRM3",
  175. "1711" or "1706" => "SRM4",
  176. "1726" or "1721" => "SRM5",
  177. "1741" or "1736" => "SRM6",
  178. _ => task.Device
  179. };
  180. //计算下一个地址
  181. var path1 = DevicePath.GetPath(task.AddrFrom, task.Device);
  182. task.AddrNext = path1.Points[1].Code;
  183. task.SrmStation = task.BarCode.Contains("TPA") || task.BarCode.Contains("TPB") ? task.AddrFrom : path1.Points[2].Code;
  184. db.Default.UpdateableRowLock(task).UpdateColumns(x => new { x.Status, x.Device, x.AddrNext, x.SrmStation }).ExecuteCommand();
  185. task.AddWCS_TASK_DTL(db.Default, task.Device, $"初始化入库任务信息");
  186. }
  187. isEnd = true;
  188. break;
  189. case TaskType.OutDepot:
  190. {
  191. if (task.Device.Contains("Robot")) //机器人任务
  192. {
  193. var lastTask = db.Default.Queryable<WCS_TaskInfo>().NoLock().First(x => x.Type == TaskType.OutDepot && x.AddrTo == task.AddrTo && x.Status > TaskStatus.WaitingToExecute && x.Status < TaskStatus.Finish);
  194. if (lastTask != null)
  195. {
  196. World.Log($"等待任务结束:{task.AddrTo}上一组码垛任务未结束,等待{lastTask.ID}任务完成后开始初始化当前任务{task.ID}");
  197. return;
  198. }
  199. var pos = task.AddrFrom.Split("-");
  200. task.Status = Entity.TaskStatus.WaitingToExecute;
  201. task.Line = pos[0].ToShort();
  202. task.Col = pos[1].ToShort();
  203. task.Layer = pos[2].ToShort();
  204. task.Depth = pos[3].ToShort();
  205. db.Default.UpdateableRowLock(task).UpdateColumns(x => new { x.Status, x.Line, x.Col, x.Layer, x.Depth }).ExecuteCommand();
  206. task.AddWCS_TASK_DTL(db.Default, task.Device, $"初始化出库任务信息,放货站台:{task.SrmStation}");
  207. isEnd = true;
  208. }
  209. else if (task.Device == "FJXG") //芯股仓库的任务
  210. {
  211. if (task.LastInteractionPoint != "3") //车间叫料任务,此值为3时是单独取满任务
  212. {
  213. var sta = GetAgvStation(task, db); //芯股任务,取货站台就是芯股站台
  214. var agv = new WCS_AgvTaskInfo()
  215. {
  216. ID = db.GetAgvTaskId(),
  217. TaskType = AGVTaskType.EnterDepot,
  218. Status = AGVTaskStatus.NewBuild,
  219. TaskId = task.ID,
  220. Position = task.WorkBench,
  221. Station = sta,
  222. AddWho = "WCS",
  223. AddTime = DateTime.Now
  224. };
  225. db.Default.InsertableRowLock(agv).SplitTable().ExecuteCommand();
  226. }
  227. var agvId = DateTime.Now.GetFormat(GetFormatterEnum.only) + task.ID;
  228. var agvTask = new WCS_AgvTaskInfo()
  229. {
  230. ID = db.GetAgvTaskId(),
  231. TaskType = AGVTaskType.CallMaterial,
  232. Status = AGVTaskStatus.NewBuild,
  233. TaskId = task.ID,
  234. Position = task.WorkBench,
  235. Station = task.AddrFrom,
  236. AddWho = "WCS",
  237. AddTime = DateTime.Now,
  238. AgvID = agvId
  239. };
  240. //开始处理车间叫料AGV任务任务
  241. db.Default.InsertableRowLock(agvTask).SplitTable().ExecuteCommand();
  242. agvTask = db.Default.Queryable<WCS_AgvTaskInfo>().UpdLock().SplitTable(x => x.Take(2)).Single(x => x.TaskId == task.ID && x.TaskType == AGVTaskType.CallMaterial);
  243. if (agvTask.Status != AGVTaskStatus.NewBuild)
  244. {
  245. World.Log($"AGV任务{agvTask.ID}状态不是新建", LogLevelEnum.High);
  246. return;
  247. }
  248. agvId = agvTask.AgvID;
  249. agvTask.Status = AGVTaskStatus.Confirm;
  250. agvTask.AgvStatus = AGVTaskStatus.Confirm;
  251. db.Default.UpdateableRowLock(agvTask).UpdateColumns(x => new { x.AgvID, x.Status, x.AgvStatus }).SplitTable(x => x.Take(2)).ExecuteCommand();
  252. task.Status = TaskStatus.AGVExecution;
  253. task.AgvTaskID = agvTask.ID;
  254. task.EditTime = DateTime.Now;
  255. task.EditWho = "WCS";
  256. db.Default.Updateable(task).UpdateColumns(x => new { x.Status, x.AgvTaskID, x.EditTime, x.EditWho }).ExecuteCommand();
  257. task.AddWCS_TASK_DTL(db.Default, task.AddrFrom, "AGV", $"任务下发至AGV{agvId}");
  258. var res = AgvApi.机台叫料(task.AddrFrom, task.WorkBench, agvId);
  259. isEnd = true;
  260. }
  261. else if (task.BusType == TaskBusType.芯股站台送空托.GetDescription())
  262. {
  263. if (task.SrmStation == "1")
  264. {
  265. var srmStation = new string[2];
  266. switch (task.Device)
  267. {
  268. case "SRM1":
  269. srmStation[0] = "2534";
  270. srmStation[1] = "2533";
  271. break;
  272. case "SRM2":
  273. srmStation[0] = "2734";
  274. srmStation[1] = "2733";
  275. break;
  276. case "SRM3":
  277. srmStation[0] = "2934";
  278. srmStation[1] = "2933";
  279. break;
  280. case "SRM4":
  281. srmStation[0] = "3134";
  282. srmStation[1] = "3133";
  283. break;
  284. case "SRM5":
  285. srmStation[0] = "3334";
  286. srmStation[1] = "3333";
  287. break;
  288. case "SRM6":
  289. srmStation[0] = "3534";
  290. srmStation[1] = "3533";
  291. break;
  292. }
  293. //开始计算当前这个任务要从哪个站台出
  294. //计算两个站台小于取货完成数量的AGV任务
  295. var agv1 = db.Default.Queryable<WCS_TaskInfo>().NoLock().Where(x => x.Status <= TaskStatus.StackerExecution && x.AddrTo == srmStation[0]).Count();
  296. var agv2 = db.Default.Queryable<WCS_TaskInfo>().NoLock().Where(x => x.Status <= TaskStatus.StackerExecution && x.AddrTo == srmStation[1]).Count();
  297. task.SrmStation = "";
  298. if (srmStation[0] == "2534" || srmStation[0] == "2934")
  299. {
  300. task.AddrTo = srmStation[0];
  301. }
  302. else
  303. {
  304. task.AddrTo = agv1 > agv2 ? srmStation[1] : srmStation[0];
  305. }
  306. }
  307. if (task.SrmStation.IsNullOrEmpty()) //如果没有指定放货站台
  308. {
  309. if (task.Device.IsNullOrEmpty())
  310. {
  311. task.Device = "SRM" + task.Tunnel.GetLastDigit();
  312. }
  313. //获取堆垛机到目标地址的路径信息
  314. var path = DevicePath.GetPath(task.Device, task.AddrTo);
  315. task.SrmStation = path.Points[1].Code;
  316. }
  317. //更新任务状态
  318. task.Status = Entity.TaskStatus.WaitingToExecute;
  319. db.Default.UpdateableRowLock(task).UpdateColumns(x => new { x.SrmStation, x.AddrTo, x.Status }).ExecuteCommand();
  320. task.AddWCS_TASK_DTL(db.Default, task.Device, $"初始化出库任务信息,放货站台:{task.SrmStation}");
  321. isEnd = true;
  322. }
  323. else //立库出库任务
  324. {
  325. if (task.SrmStation == "1")
  326. {
  327. var srmStation = new string[2];
  328. switch (task.Device)
  329. {
  330. case "SRM1":
  331. srmStation[0] = "2534";
  332. srmStation[1] = "2533";
  333. break;
  334. case "SRM2":
  335. srmStation[0] = "2734";
  336. srmStation[1] = "2733";
  337. break;
  338. case "SRM3":
  339. srmStation[0] = "2934";
  340. srmStation[1] = "2933";
  341. break;
  342. case "SRM4":
  343. srmStation[0] = "3134";
  344. srmStation[1] = "3133";
  345. break;
  346. case "SRM5":
  347. srmStation[0] = "3334";
  348. srmStation[1] = "3333";
  349. break;
  350. case "SRM6":
  351. srmStation[0] = "3534";
  352. srmStation[1] = "3533";
  353. break;
  354. }
  355. //开始计算当前这个任务要从哪个站台出
  356. //计算两个站台小于取货完成数量的AGV任务
  357. var agv1 = db.Default.Queryable<WCS_TaskInfo>().NoLock().Where(x => x.Status <= TaskStatus.StackerExecution && x.AddrTo == srmStation[0]).Count();
  358. var agv2 = db.Default.Queryable<WCS_TaskInfo>().NoLock().Where(x => x.Status <= TaskStatus.StackerExecution && x.AddrTo == srmStation[1]).Count();
  359. task.SrmStation = "";
  360. if (srmStation[0] == "2534" || srmStation[0] == "2934")
  361. {
  362. task.AddrTo = srmStation[0];
  363. }
  364. else
  365. {
  366. task.AddrTo = agv1 > agv2 ? srmStation[1] : srmStation[0];
  367. }
  368. }
  369. if (task.SrmStation.IsNullOrEmpty()) //如果没有指定放货站台
  370. {
  371. if (task.Device.IsNullOrEmpty())
  372. {
  373. task.Device = "SRM" + task.Tunnel.GetLastDigit();
  374. }
  375. //获取堆垛机到目标地址的路径信息
  376. var path = DevicePath.GetPath(task.Device, task.AddrTo);
  377. task.SrmStation = path.Points[1].Code;
  378. }
  379. var devs = Device.All.Where(x => x.HasFlag(DeviceFlags.AGV取货站台口)).Select(x => x.Code);
  380. if (devs.Contains(task.SrmStation) && task.LastInteractionPoint != "3") //车间叫料任务,此值为3时是单独取满任务
  381. {
  382. var sta = GetAgvStation(task, db);
  383. var agv = new WCS_AgvTaskInfo()
  384. {
  385. ID = db.GetAgvTaskId(),
  386. TaskType = AGVTaskType.EnterDepot,
  387. Status = AGVTaskStatus.NewBuild,
  388. TaskId = task.ID,
  389. Position = task.WorkBench,
  390. Station = sta,
  391. AddWho = "WCS",
  392. AddTime = DateTime.Now
  393. };
  394. db.Default.InsertableRowLock(agv).SplitTable().ExecuteCommand();
  395. }
  396. //更新任务状态
  397. task.Status = Entity.TaskStatus.WaitingToExecute;
  398. db.Default.UpdateableRowLock(task).UpdateColumns(x => new { x.SrmStation, x.AddrTo, x.Status }).ExecuteCommand();
  399. task.AddWCS_TASK_DTL(db.Default, task.Device, $"初始化出库任务信息,放货站台:{task.SrmStation}");
  400. isEnd = true;
  401. }
  402. break;
  403. }
  404. case TaskType.Delivery:
  405. break;
  406. case TaskType.EmptyInit:
  407. break;
  408. }
  409. });
  410. }
  411. catch (Exception ex)
  412. {
  413. if (ex.Message.Contains("Index")) World.Log($"{ex.Message}:{ex.StackTrace}");
  414. if (ex.Message.Contains("SqlTransaction")) World.Log($"{ex.Message}:{ex.StackTrace}");
  415. World.Log(ex.Message, LogLevelEnum.Mid);
  416. }
  417. }
  418. }
  419. public override bool Select(Device dev)
  420. {
  421. return dev.Code == nameof(NoInteractionSystems);
  422. }
  423. /// <summary>
  424. /// 获取AGV的目标站台
  425. /// </summary>
  426. /// <param name="task"></param>
  427. /// <param name="db"></param>
  428. /// <returns></returns>
  429. public string GetAgvStation(WCS_TaskInfo task, SqlSugarHelper db)
  430. {
  431. string sta = "";
  432. var n = 0;
  433. var s = 0;
  434. var warehouseCode = task.WarehouseCode;
  435. if (task.BusType == TaskBusType.皮盘入库.GetDescription() || task.BusType == TaskBusType.车间叫料.GetDescription())
  436. {
  437. warehouseCode = task.MaterialCode switch
  438. {
  439. "分拣库1北" => "1N",
  440. "分拣库1南" => "1S",
  441. "分拣库2北" => "2N",
  442. "分拣库2南" => "2S",
  443. "分拣库3北" => "3N",
  444. "分拣库3南" => "3S",
  445. _ => task.WarehouseCode
  446. };
  447. }
  448. //同侧之间均分
  449. if (warehouseCode.Contains("1"))
  450. {
  451. n = db.Default.Queryable<WCS_AgvTaskInfo>().NoLock().Where(v => v.Status >= AGVTaskStatus.Confirm && v.Status < AGVTaskStatus.Complete1 && v.TaskType == AGVTaskType.EnterDepot && v.Station.StartsWith("25"))
  452. .SplitTable(v => v.Take(2)).Count();
  453. s = db.Default.Queryable<WCS_AgvTaskInfo>().NoLock().Where(v => v.Status >= AGVTaskStatus.Confirm && v.Status < AGVTaskStatus.Complete1 && v.TaskType == AGVTaskType.EnterDepot && v.Station.StartsWith("27"))
  454. .SplitTable(v => v.Take(2)).Count();
  455. sta = n > s ? "2701" : "2501";
  456. }
  457. else if (warehouseCode.Contains("2"))
  458. {
  459. n = db.Default.Queryable<WCS_AgvTaskInfo>().NoLock().Where(v => v.Status >= AGVTaskStatus.Confirm && v.Status < AGVTaskStatus.Complete1 && v.TaskType == AGVTaskType.EnterDepot && v.Station.StartsWith("29"))
  460. .SplitTable(v => v.Take(2)).Count();
  461. s = db.Default.Queryable<WCS_AgvTaskInfo>().NoLock().Where(v => v.Status >= AGVTaskStatus.Confirm && v.Status < AGVTaskStatus.Complete1 && v.TaskType == AGVTaskType.EnterDepot && v.Station.StartsWith("31"))
  462. .SplitTable(v => v.Take(2)).Count();
  463. sta = n > s ? "3101" : "2901";
  464. }
  465. else if (warehouseCode.Contains("3"))
  466. {
  467. n = db.Default.Queryable<WCS_AgvTaskInfo>().NoLock().Where(v => v.Status >= AGVTaskStatus.Confirm && v.Status < AGVTaskStatus.Complete1 && v.TaskType == AGVTaskType.EnterDepot && v.Station.StartsWith("33"))
  468. .SplitTable(v => v.Take(2)).Count();
  469. s = db.Default.Queryable<WCS_AgvTaskInfo>().NoLock().Where(v => v.Status >= AGVTaskStatus.Confirm && v.Status < AGVTaskStatus.Complete1 && v.TaskType == AGVTaskType.EnterDepot && v.Station.StartsWith("35"))
  470. .SplitTable(v => v.Take(2)).Count();
  471. sta = n > s ? "3501" : "3301";
  472. }
  473. else
  474. {
  475. return default;
  476. }
  477. n = db.Default.Queryable<WCS_AgvTaskInfo>().NoLock().Where(v =>
  478. v.Status >= AGVTaskStatus.Confirm &&
  479. v.Status < AGVTaskStatus.Complete1 &&
  480. v.TaskType == AGVTaskType.EnterDepot && v.Station == sta)
  481. .SplitTable(v => v.Take(2)).Count();
  482. if (n > 5)
  483. {
  484. sta = db.Default.Queryable<WCS_AgvTaskInfo>().NoLock().Where(v => v.Status >= AGVTaskStatus.Confirm && v.Status < AGVTaskStatus.Complete1 && v.TaskType == AGVTaskType.EnterDepot
  485. && (v.Station != "2533" && v.Station != "2933"))
  486. .SplitTable(v => v.Take(2)).ToList().GroupBy(x => x.Station).Select(x => new { x.Key, Count = x.Count() }).MinBy(x => x.Count).Key;
  487. }
  488. return sta;
  489. }
  490. }
  491. }