From 9ec715d2deb18a269dd49c48da91a36632d08c81 Mon Sep 17 00:00:00 2001
From: wangxinhui <wangxinhui@hnkhzn.com>
Date: 星期三, 18 六月 2025 00:56:26 +0800
Subject: [PATCH] 最新代码上传,优化功能等

---
 代码管理/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs |  286 ++++++++++++++++++++++++++++++++++++++++++++++++---------
 1 files changed, 240 insertions(+), 46 deletions(-)

diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs"
index ebdb88a..47af224 100644
--- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs"
+++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs"
@@ -16,6 +16,7 @@
 #endregion << 鐗� 鏈� 娉� 閲� >>
 
 using AutoMapper;
+using HslCommunication.Enthernet;
 using Newtonsoft.Json;
 using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
 using SqlSugar;
@@ -65,6 +66,7 @@
         private Dictionary<string, OrderByType> _taskOrderBy = new()
             {
                 {nameof(Dt_Task.Grade),OrderByType.Desc },
+                {nameof(Dt_Task.TaskNum),OrderByType.Asc},
                 {nameof(Dt_Task.CreateDate),OrderByType.Asc},
             };
 
@@ -135,7 +137,53 @@
                 return WebResponseContent.Instance.Error(ex.Message);
             }
         }
+        public WebResponseContent AgvCarrying(int row,int startColumn, int endColumn, int startlayer,int targetLayer)
+        {
+            try
+            {
+                List<Dt_Task> tasks = new List<Dt_Task>();
+                for (int i = startColumn; i <= endColumn; i++)
+                {
+                    string column = i.ToString();
+                    if (i<10)
+                    {
+                        column = "0" + i.ToString();
+                    }
+                    string layer = targetLayer.ToString();
+                    if (targetLayer<10)
+                    {
+                        layer = "0"+targetLayer.ToString();
+                    }
+                    Dt_Task task = new Dt_Task()
+                    {
+                        WarehouseId = 7,
+                        TaskNum = DateTime.Now.ToString("yyMMddHHmm").ObjToInt() + i,
+                        PalletCode= DateTime.Now.ToString("yyMMddHHmm") +i,
+                        PalletType=0,
+                        DeviceCode="AGV_CP",
+                        Roadway= "AGV_CP",
+                        TaskType =999,
+                        SourceAddress=string.Format($"AGV_CP-00{row}-0{column}-00{startlayer}-01"),
+                        CurrentAddress=string.Format($"AGV_CP-00{row}-0{column}-00{startlayer}-01"),
+                        TargetAddress= string.Format($"AGV_CP-00{row}-0{column}-00{layer}-01"),
+                        NextAddress= string.Format($"AGV_CP-00{row}-0{column}-00{layer}-01"),
+                        Grade=0,
+                        WMSId=0,
+                        AgvTaskNum = "CP" + DateTime.Now.ToString("yyMMddHHmm").ObjToInt() + i,
+                        TaskState = TaskStatusEnum.New.ObjToInt(),
+                        Remark= "娴嬭瘯绌烘"
+                    };
+                    tasks.Add(task);
+                }
+                BaseDal.AddData(tasks);
+                return WebResponseContent.Instance.OK("");
+            }
+            catch (Exception ex)
+            {
+                return WebResponseContent.Instance.Error(ex.Message);
+            }
 
+        }
         /// <summary>
         /// 鎺ユ敹WMS浠诲姟淇℃伅
         /// </summary>
@@ -169,10 +217,18 @@
                         if (taskTypeGroup == TaskTypeGroup.InboundGroup)
                         {
                             stationManger = _stationMangerRepository.QueryFirst(x => x.StationCode == item.SourceAddress || x.StationDeviceCode == item.SourceAddress);
+                            if (stationManger==null && task.TaskType==TaskTypeEnum.InProduct.ObjToInt())
+                            {
+                                stationManger = _stationMangerRepository.QueryFirst(x => x.StackerCraneCode==task.SourceAddress);
+                                //杞崲鎴愬搧浠撹捣鐐圭珯鍙�
+                                item.SourceAddress = stationManger.StationCode;
+                                task.CurrentAddress = stationManger.StationCode;
+                                task.SourceAddress = stationManger.StationCode;
+                            }
                         }
                         else
                         {
-                            stationManger = _stationMangerRepository.QueryFirst(x => x.StackerCraneCode == item.RoadWay);
+                            stationManger = _stationMangerRepository.QueryFirst(x => x.StackerCraneCode == item.RoadWay || x.Remark==item.RoadWay);
                         }
                         if (stationManger == null)
                         {
@@ -198,19 +254,46 @@
                                 task.NextAddress = router.NextPosi;
                                 task.DeviceCode = router.ChildPosi;
                             }
-                            else if (item.TaskType == TaskTypeEnum.MesOutbound.ObjToInt() || item.TaskType == TaskTypeEnum.MesHandOutbound.ObjToInt() || item.TaskType == TaskTypeEnum.MesHandPickOutbound.ObjToInt())
+                            else if ((item.TaskType == TaskTypeEnum.MesPalletLargeReturn.ObjToInt() || item.TaskType == TaskTypeEnum.MesPalletSmallReturn.ObjToInt()) && router.IsEnd)
                             {
                                 task.NextAddress = router.NextPosi;
+                                task.DeviceCode = router.ChildPosi;
+                            }
+                            else if (item.TaskType == TaskTypeEnum.MesOutbound.ObjToInt() || item.TaskType == TaskTypeEnum.MesHandOutbound.ObjToInt() || item.TaskType == TaskTypeEnum.MesHandPickOutbound.ObjToInt() || ((item.TaskType == TaskTypeEnum.OutAllocate.ObjToInt() || item.TaskType == TaskTypeEnum.OutQuality.ObjToInt() || item.TaskType == TaskTypeEnum.OutInventory.ObjToInt()) && item.RoadWay.Contains("BC")))
+                            {
+                                task.NextAddress = router.NextPosi;
+                                task.DeviceCode = stationManger.StackerCraneCode;
+                                if (item.TaskType == TaskTypeEnum.MesOutbound.ObjToInt() && task.TargetAddress== "SCUTL-001")
+                                {
+                                    task.TaskState = TaskStatusEnum.MesPending.ObjToInt();
+                                }
+                                else
+                                {
+                                    task.TaskState = TaskStatusEnum.SC_Execute.ObjToInt();
+                                }
+                            }
+                            else if (item.TaskType == TaskTypeEnum.MesOutbound.ObjToInt() && item.RoadWay.Contains("ZH"))
+                            {
+                                task.NextAddress = stationManger.StackerCraneStationCode;
                                 task.DeviceCode = stationManger.StackerCraneCode;
                                 task.TaskState = TaskStatusEnum.SC_Execute.ObjToInt();
                             }
                             else
                             {
                                 task.NextAddress = taskTypeGroup == TaskTypeGroup.InboundGroup ? task.TargetAddress : router.NextPosi;
-                                if (item.RoadWay.Contains("AGV"))
+                                if (item.RoadWay.Contains("AGV_FL")|| (item.RoadWay.Contains("AGV_CP") && taskTypeGroup == TaskTypeGroup.OutbondGroup))
                                 {
                                     task.DeviceCode = item.RoadWay;
-                                    task.AgvTaskNum = task.DeviceCode + DateTime.Now.ToString("yyyyMMdd") + item.TaskNum;
+                                    task.AgvTaskNum = item.RoadWay + DateTime.Now.ToString("yyyyMMdd") + item.TaskNum;
+                                }
+                                else if(item.RoadWay.Contains("AGV_CP") && taskTypeGroup == TaskTypeGroup.InboundGroup)
+                                {
+                                    task.DeviceCode = stationManger.StationDeviceCode;
+                                    task.AgvTaskNum = task.Roadway + DateTime.Now.ToString("yyyyMMdd") + item.TaskNum;
+                                }
+                                else if (item.RoadWay.Contains("PP") && taskTypeGroup == TaskTypeGroup.OutbondGroup)
+                                {
+                                    task.DeviceCode = router.StartPosi;
                                 }
                                 else
                                 {
@@ -220,16 +303,33 @@
                         }
                         else
                         {
-                            List<Dt_Router> dt_Routers = _routerService.QueryNextRoutes(item.SourceAddress, item.RoadWay, item.TaskType);
-                            if (dt_Routers != null && dt_Routers.Count > 0)
+                            if (item.RoadWay=="AGV_CP")
                             {
-                                task.NextAddress = dt_Routers.FirstOrDefault().NextPosi;
-                                task.DeviceCode = dt_Routers.FirstOrDefault().ChildPosi;
+                                Dt_Router routerSelect = _routerRepository.QueryFirst(x => x.InOutType == item.TaskType && item.RoadWay == x.StartPosi && x.NextPosi==item.TargetAddress);
+                                if (routerSelect != null)
+                                {
+                                    task.NextAddress = routerSelect.NextPosi;
+                                    task.DeviceCode = routerSelect.ChildPosi;
+                                    task.AgvTaskNum = item.RoadWay + DateTime.Now.ToString("yyyyMMdd") + item.TaskNum;
+                                }
+                                else
+                                {
+                                    return content.Error("鏈壘鍒拌矾鐢变俊鎭�");
+                                }
                             }
                             else
                             {
-                                task.NextAddress = "";
-                                task.DeviceCode = "";
+                                List<Dt_Router> dt_Routers = _routerService.QueryNextRoutes(item.SourceAddress, item.RoadWay, item.TaskType);
+                                if (dt_Routers != null && dt_Routers.Count > 0)
+                                {
+                                    task.NextAddress = dt_Routers.FirstOrDefault().NextPosi;
+                                    task.DeviceCode = dt_Routers.FirstOrDefault().ChildPosi;
+                                }
+                                else
+                                {
+                                    task.NextAddress = "";
+                                    task.DeviceCode = "";
+                                }
                             }
                         }
                     }
@@ -244,30 +344,44 @@
                                 return WebResponseContent.Instance.Error($"鏈壘鍒拌矾鐢遍厤缃俊鎭�");
                             }
                             router = routers.FirstOrDefault();
-
                             task.NextAddress = router?.StartPosi ?? "";
                             task.DeviceCode = item.RoadWay;
-                            task.TaskState = TaskStatusEnum.SC_Execute.ObjToInt();
+                            if (item.RoadWay.Contains("ZH"))
+                            {
+                                task.TaskState = TaskStatusEnum.New.ObjToInt();
+                            }
+                            else
+                            {
+                                task.TaskState = TaskStatusEnum.SC_Execute.ObjToInt();
+                            }
                         }
                         else
                         {
-                            task.AgvTaskNum = item.AGVArea + DateTime.Now.ToString("yyyyMMdd") + item.TaskNum;
+                            if (task.Roadway!="SC01_ZH")
+                            {
+                                task.AgvTaskNum = item.AGVArea + DateTime.Now.ToString("yyyyMMdd") + item.TaskNum;
+                            }
                             List<Dt_Router> routers = _routerRepository.QueryData(x => x.InOutType == item.TaskType && item.AGVArea == x.StartPosi);
                             if (routers.FirstOrDefault() == null)
                             {
                                 return WebResponseContent.Instance.Error($"鏈壘鍒拌矾鐢遍厤缃俊鎭�");
                             }
                             router = routers.FirstOrDefault();
-                            string stationCode = router?.NextPosi ?? "";
-                            Dt_StationManger? stationManger = _stationMangerRepository.QueryFirst(x => x.StationCode == stationCode);
+                            Dt_StationManger? stationManger = _stationMangerRepository.QueryData(x => true).FirstOrDefault(x=>x.StationCode== router?.NextPosi);
                             if (stationManger == null)
                             {
                                 return WebResponseContent.Instance.Error($"鏈壘鍒扮珯鍙伴厤缃俊鎭�");
                             }
-
                             task.NextAddress = stationManger?.AGVStationCode ?? "";
                             task.DeviceCode = stationManger?.Remark ?? "";
-                            task.TaskState = TaskStatusEnum.AGV_Execute.ObjToInt();
+                            if (task.Roadway != "SC01_ZH")
+                            {
+                                task.TaskState = TaskStatusEnum.AGV_Execute.ObjToInt();
+                            }
+                            else
+                            {
+                                task.TaskState = TaskStatusEnum.AGV_Executing.ObjToInt();
+                            }
                         }
                     }
 
@@ -292,7 +406,7 @@
         /// <param name="palletCode">鎵樼洏鍙�</param>
         /// <param name="sourceAddress">璧峰鍦板潃</param>
         /// <returns></returns>
-        public WebResponseContent RequestWMSTask(string palletCode, string sourceAddress)
+        public WebResponseContent RequestWMSTask(string palletCode, string sourceAddress, string materielBoxCode = "")
         {
             WebResponseContent content = new WebResponseContent();
             try
@@ -307,7 +421,15 @@
                 {
                     return WebResponseContent.Instance.Error($"鏈壘鍒癢MSApi鍦板潃");
                 }
-                string responseStr = HttpHelper.Get($"{address}/api/Task/DeviceRequestInboundTask?stationCode={sourceAddress}&roadwayNo={stationManger.StackerCraneCode}&palletCode={palletCode}");
+                string responseStr = "";
+                if (!string.IsNullOrEmpty(materielBoxCode))
+                {
+                    responseStr = HttpHelper.Get($"{address}/api/Task/DeviceRequestInboundTask?stationCode={sourceAddress}&roadwayNo={stationManger.StackerCraneCode}&palletCode={palletCode}&materielBoxCode={materielBoxCode}");
+                }
+                else
+                {
+                    responseStr = HttpHelper.Get($"{address}/api/Task/DeviceRequestInboundTask?stationCode={sourceAddress}&roadwayNo={stationManger.StackerCraneCode}&palletCode={palletCode}");
+                }
                 WebResponseContent? responseContent = JsonConvert.DeserializeObject<WebResponseContent>(responseStr);
                 if (responseContent != null && responseContent.Status && responseContent.Data != null)
                 {
@@ -325,7 +447,50 @@
             }
             return content;
         }
+        public WebResponseContent RequestWMSZHTask(string agvTaskCode, string palletCode, string palletType, string materialLot)
+        {
+            WebResponseContent content = new WebResponseContent();
+            try
+            {
+                Dt_Task task = BaseDal.QueryFirst(x => x.AgvTaskNum == agvTaskCode);
+                if (task != null)
+                {
+                    return WebResponseContent.Instance.Error($"浠诲姟鍙穥task.TaskNum}瀵瑰簲浠诲姟宸插瓨鍦�");
+                }
+                string address = AppSettings.Get("WMSApiAddress");
+                if (string.IsNullOrEmpty(address))
+                {
+                    return WebResponseContent.Instance.Error($"鏈壘鍒癢MSApi鍦板潃");
+                }
+                string responseStr = "";
+                if (string.IsNullOrEmpty(materialLot))
+                {
+                    return content.Error("鐗╂枡鎵规涓虹┖");
+                    
+                }
+                responseStr = HttpHelper.Get($"{address}/api/Task/RequestZHInboundTask?agvTaskCode={agvTaskCode}&palletCode={palletCode}&palletType={palletType}&materialLot={materialLot}");
+                WebResponseContent? responseContent = JsonConvert.DeserializeObject<WebResponseContent>(responseStr);
+                if (responseContent != null && responseContent.Status && responseContent.Data != null)
+                {
+                    WMSTaskDTO? taskDTO = JsonConvert.DeserializeObject<WMSTaskDTO>(responseContent.Data.ToString());
+                    if (taskDTO != null)
+                    {
+                        taskDTO.AGVTaskNum = agvTaskCode;
+                        content = ReceiveWMSTask(new List<WMSTaskDTO> { taskDTO });
+                    }
+                }
+                else
+                {
+                    content.Error(responseContent.Message);
+                }
 
+            }
+            catch (Exception ex)
+            {
+                content = WebResponseContent.Instance.Error(ex.Message);
+            }
+            return content;
+        }
         /// <summary>
         /// 
         /// </summary>
@@ -368,34 +533,34 @@
         /// <param name="sourceAddress"></param>
         /// <param name="roadway"></param>
         /// <returns></returns>
-        public WebResponseContent RequestWMSTask(string palletCode, string sourceAddress, string roadway)
-        {
-            WebResponseContent content = new WebResponseContent();
-            try
-            {
-                string address = AppSettings.Get("WMSApiAddress");
-                if (string.IsNullOrEmpty(address))
-                {
-                    return WebResponseContent.Instance.Error($"鏈壘鍒癢MSApi鍦板潃");
-                }
-                string responseStr = HttpHelper.Get($"{address}/api/Task/DeviceRequestInboundTask?stationCode={sourceAddress}&roadwayNo={roadway}&palletCode={palletCode}");
-                WebResponseContent? responseContent = JsonConvert.DeserializeObject<WebResponseContent>(responseStr);
-                if (responseContent != null && responseContent.Status && responseContent.Data != null)
-                {
-                    WMSTaskDTO? taskDTO = JsonConvert.DeserializeObject<WMSTaskDTO>(responseContent.Data.ToString());
-                    if (taskDTO != null)
-                    {
-                        content = ReceiveWMSTask(new List<WMSTaskDTO> { taskDTO });
-                    }
-                }
+        //public WebResponseContent RequestWMSTask(string palletCode, string sourceAddress, string roadway)
+        //{
+        //    WebResponseContent content = new WebResponseContent();
+        //    try
+        //    {
+        //        string address = AppSettings.Get("WMSApiAddress");
+        //        if (string.IsNullOrEmpty(address))
+        //        {
+        //            return WebResponseContent.Instance.Error($"鏈壘鍒癢MSApi鍦板潃");
+        //        }
+        //        string responseStr = HttpHelper.Get($"{address}/api/Task/DeviceRequestInboundTask?stationCode={sourceAddress}&roadwayNo={roadway}&palletCode={palletCode}");
+        //        WebResponseContent? responseContent = JsonConvert.DeserializeObject<WebResponseContent>(responseStr);
+        //        if (responseContent != null && responseContent.Status && responseContent.Data != null)
+        //        {
+        //            WMSTaskDTO? taskDTO = JsonConvert.DeserializeObject<WMSTaskDTO>(responseContent.Data.ToString());
+        //            if (taskDTO != null)
+        //            {
+        //                content = ReceiveWMSTask(new List<WMSTaskDTO> { taskDTO });
+        //            }
+        //        }
 
-            }
-            catch (Exception ex)
-            {
-                content = WebResponseContent.Instance.Error(ex.Message);
-            }
-            return content;
-        }
+        //    }
+        //    catch (Exception ex)
+        //    {
+        //        content = WebResponseContent.Instance.Error(ex.Message);
+        //    }
+        //    return content;
+        //}
 
         /// <summary>
         /// 
@@ -813,5 +978,34 @@
                 return WebResponseContent.Instance.Error(ex.Message);
             }
         }
+        /// <summary>
+        /// //鍒ゆ柇绉诲簱璐т綅浠诲姟鏄惁宸插瓨鍦紝濡傚瓨鍦ㄥ厛鎵ц
+        /// </summary>
+        public Dt_Task QueryStackerExistTask(string PalletCode, string locationCode)
+        {
+            return BaseDal.QueryFirst(x => x.PalletCode == PalletCode && x.SourceAddress == locationCode && (x.TaskState == (int)TaskStatusEnum.SC_Execute || x.TaskState == (int)TaskStatusEnum.SC_Executing));
+        }
+        /// <summary>
+        /// 鎺ュ彈WMS鎵嬪姩瀹屾垚浠诲姟
+        /// </summary>
+        /// <param name="taskNum"></param>
+        /// <returns></returns>
+        public WebResponseContent RecWMSTaskCompleted(int taskNum)
+        {
+            try
+            {
+                Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
+                if (task != null)
+                {
+                    task.TaskState = TaskStatusEnum.Finish.ObjToInt();
+                    BaseDal.DeleteAndMoveIntoHty(task, OperateTypeEnum.浜哄伐瀹屾垚);
+                }
+                return WebResponseContent.Instance.OK();
+            }
+            catch (Exception ex)
+            {
+                return WebResponseContent.Instance.Error(ex.Message);
+            }
+        }
     }
 }

--
Gitblit v1.9.3