From cb62fe00ff0c80bce983b0aa7a2b320fdc26f85f Mon Sep 17 00:00:00 2001
From: huanghongfeng <huanghongfeng@hnkhzn.com>
Date: 星期一, 20 五月 2024 08:51:03 +0800
Subject: [PATCH] Merge branch 'master' of http://115.159.85.185:8098/r/SuZhouGuanHong/TaiYuanTaiZhong

---
 代码管理/PCS/WCS_Server/WIDESEA_WCS/JobsPart/Common/OutboundTask.cs |  186 ++++++++++++++++++++++++++++++----------------
 1 files changed, 120 insertions(+), 66 deletions(-)

diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_WCS/JobsPart/Common/OutboundTask.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_WCS/JobsPart/Common/OutboundTask.cs"
index 63bafd4..ca16830 100644
--- "a/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_WCS/JobsPart/Common/OutboundTask.cs"
+++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_WCS/JobsPart/Common/OutboundTask.cs"
@@ -5,12 +5,15 @@
 using System.Text;
 using System.Threading.Tasks;
 using WIDESEA_Comm;
+using WIDESEA_Comm.LogInfo;
 using WIDESEA_Comm.TaskNo;
 using WIDESEA_Core.EFDbContext;
-using WIDESEA_Core.FreeDB;
+using WIDESEA_Core.Extensions;
 using WIDESEA_Entity.DomainModels;
 using WIDESEA_WCS.IRepositories;
 using WIDESEA_WCS.Repositories;
+using WIDESEA_WMS.IRepositories;
+using WIDESEA_WMS.Repositories;
 using static FreeSql.Internal.GlobalFilter;
 using static System.Collections.Specialized.BitVector32;
 
@@ -18,7 +21,6 @@
 {
     public class OutboundTask
     {
-        static FreeDB freeDB = new FreeDB();
         /// <summary>
         /// 鍒涘缓鍑哄簱浠诲姟
         /// </summary>
@@ -28,79 +30,131 @@
             {
                 VOLContext context = new VOLContext();
                 Idt_stationinfoRepository stationinfoRepository = new dt_stationinfoRepository(context);
-                var mes_heads = freeDB.Select<dt_mes_head>().Where(x => x.processCode == "28").OrderBy(x => x.expectedStartTime).ToList();
-                foreach (var mes_head in mes_heads)
+                Idt_inventoryRepository inventoryRepository = new dt_inventoryRepository(context);
+                Idt_agvtaskRepository agvtaskRepository = new dt_agvtaskRepository(context);
+                IVV_Mes_WorkinfoRepository workinfoRepository = new VV_Mes_WorkinfoRepository(context);
+
+                var Mes_Works = workinfoRepository.Find(x => x.processCode == "28").OrderByDescending(x => x.CreateTime).ToList();
+                foreach (var Mes_Work in Mes_Works)
                 {
-                    //var inventorys = freeDB.Select<dt_inventory>().Where(x => x.FigureNumber == mes_head.drawingNo).OrderBy.ToList();
-                    var station = stationinfoRepository.Find(x => x.stationType == mes_head.drawingNo && x.line != x.line).OrderBy(x => x.line).ThenByDescending(x => x.column).FirstOrDefault();
-                    bool ok = false;
-                    List<string> list = new List<string>();
-                    if (station != null && station.location_state == LocationStateEnum.Stroge.ToString() && station.enable)
+                    var inventory = inventoryRepository.Find(x => x.SN == Mes_Work.SN).FirstOrDefault();
+                    if (inventory != null)
                     {
-                        var SNS = station.bindSN.Split(",");
-                        foreach (var SN in SNS)
+                        var Station = stationinfoRepository.Find(x => x.stationCode == inventory.stationCode).FirstOrDefault();//鏌ユ壘搴撳瓨璐т綅
+                        if (Station != null)
                         {
-                            if (!string.IsNullOrEmpty(SN))
-                                list.Add(SN);
+
+                            #region 
+
+                            dt_stationinfo stationinfo = null;
+                            //鏌ユ壘褰撳墠璐т綅鍚岃鏄惁瀛樺湪鍏ュ簱浠诲姟
+                            if (GetStation.InBusyStation(Station.stationCode)) continue;
+
+                            stationinfo = stationinfoRepository.Find(x => x.line == Station.line && x.area == Station.area && x.enable && x.location_state == LocationStateEnum.Stroge.ToString() && x.quantity > 0).OrderByDescending(x => x.column).FirstOrDefault();
+                            if (stationinfo != null)
+                            {
+                                if (agvtaskRepository.Find(x => x.agv_fromaddress == stationinfo.stationCode).Any()) continue;
+
+                                if (stationinfoRepository.Find(x => x.line == stationinfo.line && x.area == stationinfo.area && x.column > stationinfo.column && !x.enable).Any())
+                                    continue;
+                                if (string.IsNullOrEmpty(stationinfo.bindSN))
+                                {
+                                    stationinfo.remark = "杞﹁疆SN鍙蜂俊鎭紓甯�";
+                                    stationinfo.location_state = "Abnormal";
+                                    stationinfoRepository.Update(stationinfo, true);
+                                    continue;
+                                }
+
+                                if (agvtaskRepository.Find(x => x.agv_fromaddress == stationinfo.stationCode).Any()) continue;
+
+                                List<string> lists = new List<string>();
+                                var SNS = stationinfo.bindSN.Split(",");
+                                foreach (var SN in SNS)
+                                {
+                                    if (!string.IsNullOrEmpty(SN))
+                                        lists.Add(SN);
+                                }
+
+                                #region 璐т綅杞﹁疆鍏ㄩ儴鍖呭惈鍦ㄥ伐鍗曞唴鍒欎笅鍙戜换鍔�
+                                var count = 0;
+                                foreach (var SN in lists)
+                                {
+                                    if (workinfoRepository.Find(x => x.processCode == "28" && x.SN == SN).Any()) count++;
+                                    //if (workinfoRepository.Find(x => x.processCode == "28" && x.SN.Contains(SN)).Any()) count++;
+
+                                }
+                                if (count != lists.Count) continue;
+                                dt_agvtask agvtask = new dt_agvtask()
+                                {
+                                    agv_fromaddress = stationinfo.stationCode,
+                                    agv_id = Guid.NewGuid(),
+                                    agv_tasknum = IdenxManager.GetTaskNo("KH-", "WMS"),
+                                    agv_grade = 2,
+                                    agv_createtime = DateTime.Now,
+                                    agv_taskstate = "Queue",
+                                    agv_materielid = stationinfo.stationType,
+                                    agv_qty = stationinfo.quantity,
+                                    agv_tasktype = "TaskType_Outbound",
+                                    agv_toaddress = "",
+                                    agv_userid = "绯荤粺",
+                                    bindSN = stationinfo.bindSN,
+                                    jobID = Mes_Work.workOrder,
+                                    agv_worktype = Convert.ToInt32(Mes_Work.processCode),
+                                    agv_materbarcode = Mes_Work.materialCode,
+                                    agv_Traytype = stationinfo.tray_type,
+                                    agv_TrayStatus = stationinfo.tray_status
+                                };
+                                stationinfo.location_state = LocationStateEnum.OutBusy.ToString();
+                                stationinfoRepository.Update(stationinfo, true);
+                                agvtaskRepository.Add(agvtask, true);
+                                WriteDBLog.Success("鍒涘缓鍑哄簱浠诲姟", $"浠诲姟缂栧彿锛歿agvtask.agv_tasknum}", "PCS");
+                                continue;
+
+                                #endregion
+
+                                #region 璐т綅杞﹁疆鏈変竴涓寘鍚湪宸ュ崟鍐呭垯涓嬪彂浠诲姟
+                                //foreach (var SN in lists)
+                                //{
+                                //    if (mes_DetailRepository.Find(x => x.jobID == mes_head.jobID && x.SN == SN).Any())
+                                //    {
+                                //        dt_agvtask agvtask = new dt_agvtask()
+                                //        {
+                                //            agv_fromaddress = stationinfo.stationCode,
+                                //            agv_id = Guid.NewGuid(),
+                                //            agv_tasknum = IdenxManager.GetTaskNo("KH-", "WMS"),
+                                //            agv_grade = 2,
+                                //            agv_createtime = DateTime.Now,
+                                //            agv_taskstate = "Queue",
+                                //            agv_materielid = stationinfo.stationType,
+                                //            agv_qty = stationinfo.quantity,
+                                //            agv_tasktype = "TaskType_Outbound",
+                                //            agv_toaddress = "",
+                                //            agv_userid = "绯荤粺",
+                                //            bindSN = stationinfo.bindSN,
+                                //            jobID = mes_head.jobID,
+                                //            agv_worktype = Convert.ToInt32(mes_head.processCode),
+                                //            agv_materbarcode = mes_head.materialCode,
+                                //            agv_Traytype = stationinfo.tray_type,
+                                //            agv_TrayStatus = stationinfo.tray_status
+                                //        };
+                                //        stationinfo.location_state = LocationStateEnum.OutBusy.ToString();
+                                //        stationinfoRepository.Update(stationinfo, true);
+                                //        agvtaskRepository.Add(agvtask, true);
+                                //        WriteDBLog.Success("鍒涘缓鍑哄簱浠诲姟", $"浠诲姟缂栧彿锛歿agvtask.agv_tasknum}", "PCS");
+                                //        continue;
+                                //    }
+                                //}
+                                #endregion
+                            }
+                            #endregion
                         }
-                    }
-                    foreach (var SN in list)
-                    {
-                        if (ok = freeDB.Select<dt_mes_detail>().Where(x => x.jobID == mes_head.jobID && x.SN == SN).Any()) continue;
-                    }
-                    if (ok)
-                    {
-                        dt_agvtask agvtask = new dt_agvtask()
-                        {
-                            agv_fromaddress = station.stationCode,
-                            agv_id = Guid.NewGuid(),
-                            agv_tasknum = IdenxManager.GetTaskNo("KH-", "WMS"),
-                            agv_grade = 1,
-                            agv_createtime = DateTime.Now,
-                            agv_taskstate = "Queue",
-                            agv_materielid = station.stationType,
-                            agv_qty = station.quantity,
-                            agv_tasktype = "TaskType_Outbound",
-                            agv_toaddress = "",
-                            agv_userid = "绯荤粺",
-                            bindSN = station.bindSN,
-                            agv_worktype = Convert.ToInt32(mes_head.processCode),
-                            agv_materbarcode = mes_head.materialCode,
-                            agv_barcode = station.tray_type
-                        };
-                        dt_stationinfo TargetLocation = GetEmptyLocation(stationinfoRepository);
-                        if (TargetLocation != null)
-                        {
-                            agvtask.agv_taskstate = "Create";
-                            agvtask.agv_toaddress = TargetLocation.stationCode;
-                            TargetLocation.location_state = LocationStateEnum.Busy.ToString();
-                            freeDB.Update(TargetLocation);
-                        }
-                        freeDB.Add(agvtask);
                     }
                 }
             }
-            catch (Exception)
+            catch (Exception ex)
             {
-
-                throw;
+                WriteDBLog.Error("鍒涘缓鍑哄簱浠诲姟", $"閿欒淇℃伅锛歿ex.Message}", "PCS");
             }
-        }
-        private static dt_stationinfo GetEmptyLocation(Idt_stationinfoRepository stationinfoRepository)
-        {
-            dt_stationinfo TargetLocation = null;
-            var stations = stationinfoRepository.Find(x => x.stationCode.Contains("S01001"));
-            foreach (var station in stations)
-            {
-                TargetLocation = stationinfoRepository.FindFirst(x => x.stationCode == station.stationCode && x.location_state == LocationStateEnum.Empty.ToString() && x.enable);
-                if (TargetLocation != null) continue;
-            }
-
-            if (TargetLocation == null)
-            {
-                throw new Exception("妫�娴嬬嚎涓婃枡浣嶅凡婊�");
-            }
-            return TargetLocation;
         }
     }
 }

--
Gitblit v1.9.3