From 2ae5aa151f7b40a082e34aa7ed22b4b64edd1d3c Mon Sep 17 00:00:00 2001
From: dengjunjie <dengjunjie@hnkhzn.com>
Date: 星期三, 11 六月 2025 17:13:56 +0800
Subject: [PATCH] 修改堆垛机通讯协议及交互逻辑

---
 代码管理/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs |  267 ++++++++++++++++++++++++++--------------------------
 1 files changed, 134 insertions(+), 133 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 af65e7b..d6a78b3 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"
@@ -17,24 +17,12 @@
 
 using AutoMapper;
 using Newtonsoft.Json;
-using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
 using SqlSugar;
-using System;
-using System.Collections.Generic;
-using System.ComponentModel;
 using System.Diagnostics.CodeAnalysis;
-using System.Linq;
-using System.Reflection;
-using System.Reflection.Emit;
-using System.Security.Policy;
-using System.Text;
-using System.Threading.Tasks;
 using WIDESEA_Comm.Http;
 using WIDESEA_Common.Log;
 using WIDESEAWCS_Core;
 using WIDESEAWCS_Core.BaseServices;
-using WIDESEAWCS_Core.DB.Models;
-using WIDESEAWCS_Core.Enums;
 using WIDESEAWCS_DTO.TaskInfo;
 using WIDESEAWCS_ITaskInfoRepository;
 using WIDESEAWCS_ITaskInfoService;
@@ -44,6 +32,8 @@
 using WIDESEAWCS_Core.Helper;
 using WIDESEA_Core.Enums;
 using WIDESEAWCS_Core.BaseRepository;
+using WIDESEAWCS_DTO.TaskEnum;
+
 
 namespace WIDESEAWCS_TaskInfoService
 {
@@ -59,7 +49,7 @@
 
         private Dictionary<string, OrderByType> _taskOrderBy = new()
             {
-                {nameof(Dt_Task.Grade),OrderByType.Desc },
+                {nameof(Dt_Task.Grade),OrderByType.Asc },
                 {nameof(Dt_Task.CreateDate),OrderByType.Asc},
             };
 
@@ -111,6 +101,10 @@
             {
                 _unitOfWorkManage.RollbackTran();
                 content = WebResponseContent.Instance.Error($"{ex.Message}");
+            }
+            finally
+            {
+                WriteLog.GetLog("鎺ユ敹浠诲姟").Write($"鎺ユ敹鍙傛暟锛歿JsonConvert.SerializeObject(taskDTOs)}{Environment.NewLine}鎶ユ枃锛歿JsonConvert.SerializeObject(content)}", "鎺ユ敹浠诲姟");
             }
             return content;
         }
@@ -205,20 +199,9 @@
         /// <param name="deviceNo">璁惧缂栧彿</param>
         /// <param name="currentAddress">褰撳墠鍦板潃</param>
         /// <returns>杩斿洖浠诲姟瀹炰綋瀵硅薄锛屽彲鑳戒负null</returns>
-        public Dt_Task QueryStackerCraneTask(string deviceNo, string currentAddress = "")
+        public Dt_Task? QueryStackerCraneTask(string deviceNo, string currentAddress = "")
         {
-            Dt_Task taskGrade = BaseDal.QueryFirst(x => x.Grade == 0, TaskOrderBy);
-            if (taskGrade != null)
-            {
-                return taskGrade;
-            }
-            else
-            {
-                if (string.IsNullOrEmpty(currentAddress))
-                    return BaseDal.QueryFirst(x => x.Roadway == deviceNo && (TaskTypeEnums.Contains(x.TaskType) && (x.TaskStatus == (int)TaskInStatusEnum.InNew ||  x.TaskStatus == (int)TaskOutStatusEnum.OutNew)), TaskOrderBy);
-                else
-                    return BaseDal.QueryFirst(x => x.Roadway == deviceNo && x.CurrentAddress == currentAddress && (TaskTypeEnums.Contains(x.TaskType) && x.TaskStatus == (int)TaskInStatusEnum.Line_InFinish || TaskOutboundTypes.Contains(x.TaskType) && x.TaskStatus == (int)TaskOutStatusEnum.OutNew), TaskOrderBy);
-            }
+            return BaseDal.QueryFirst(x => true, TaskOrderBy);
         }
 
         /// <summary>
@@ -229,7 +212,7 @@
         /// <returns>杩斿洖浠诲姟瀹炰綋瀵硅薄锛屽彲鑳戒负null</returns>
         public Dt_Task QueryStackerCraneInTask(string deviceNo, string currentAddress = "")
         {
-            Dt_Task taskGrade = BaseDal.QueryFirst(x => x.Grade == 0, TaskOrderBy);
+            Dt_Task taskGrade = BaseDal.QueryFirst(x =>true, TaskOrderBy);
             if (taskGrade != null)
             {
                 return taskGrade;
@@ -262,20 +245,6 @@
             }
         }
         /// <summary>
-        /// 鏍规嵁璁惧缂栧彿銆佸綋鍓嶅湴鍧�鎸夌収浼樺厛绾т互鍙婂垱寤烘椂闂存帓搴忔煡璇换鍔℃睜鍏ュ簱绫诲瀷鐨勬柊澧炵殑浠诲姟
-        /// </summary>
-        /// <param name="deviceNo">璁惧缂栧彿</param>
-        /// <param name="currentAddress">褰撳墠鍦板潃</param>
-        /// <returns>杩斿洖浠诲姟瀹炰綋瀵硅薄锛屽彲鑳戒负null</returns>
-        public Dt_Task QueryStackerCraneRelocationTask(string deviceNo, string currentAddress = "")
-        {
-            if (string.IsNullOrEmpty(currentAddress))
-                return BaseDal.QueryFirst(x => x.Roadway == deviceNo && TaskOutboundTypes.Contains(x.TaskType) && x.TaskStatus == (int)TaskOutStatusEnum.OutNew, TaskOrderBy);
-            else
-                return BaseDal.QueryFirst(x => x.Roadway == deviceNo && TaskInboundTypes.Contains(x.TaskType) && x.TaskStatus == (int)TaskInStatusEnum.InNew && x.CurrentAddress == currentAddress, TaskOrderBy);
-        }
-
-        /// <summary>
         /// 鏍规嵁璁惧缂栧彿銆佸綋鍓嶅湴鍧�鎸夌収浼樺厛绾т互鍙婂垱寤烘椂闂存帓搴忔煡璇换鍔℃睜鍑哄簱绫诲瀷鐨勬柊澧炵殑浠诲姟
         /// </summary>
         /// <param name="deviceNo">璁惧缂栧彿</param>
@@ -283,7 +252,7 @@
         /// <returns>杩斿洖浠诲姟瀹炰綋瀵硅薄锛屽彲鑳戒负null</returns>
         public Dt_Task QueryStackerCraneOutTask(string deviceNo, string currentAddress = "")
         {
-            Dt_Task taskGrade = BaseDal.QueryFirst(x => x.Grade == 0, TaskOrderBy);
+            Dt_Task taskGrade = BaseDal.QueryFirst(x => true, TaskOrderBy);
             if (taskGrade != null)
             {
                 return taskGrade;
@@ -325,7 +294,7 @@
         /// <returns>杩斿洖浠诲姟瀹炰綋瀵硅薄闆嗗悎锛屽彲鑳戒负null</returns>
         public List<Dt_Task> QueryStackerCraneOutTasks(string deviceNo, string outStationCodes)
         {
-            List<Dt_Task> taskGrade = BaseDal.QueryData(x => x.Grade == 0, TaskOrderBy);
+            List<Dt_Task> taskGrade = BaseDal.QueryData(x => true, TaskOrderBy);
             if (taskGrade != null)
             {
                 return taskGrade;
@@ -358,7 +327,7 @@
                 }
                 else if (task.TaskType == (int)TaskTypeEnum.Relocation)
                 {
-                    task.TaskStatus = (int)InTaskStatusEnum.RelocationException;
+                    task.TaskStatus = (int)RelocationTaskStatusEnum.RelocationException;
                 }
 
                 task.ExceptionMessage = message;
@@ -400,7 +369,7 @@
             try
             {
                 Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
-                if (task == null) return WebResponseContent.Instance.Error($"鏈壘鍒拌浠诲姟淇℃伅,浠诲姟鍙�:銆恵taskNum}銆�");
+                if (task == null) return WebResponseContent.Instance.Error($"鏈壘鍒拌浠诲姟淇℃伅,浠诲姟鍙�:銆恵taskNum}銆�!");
                 return UpdateTaskStatusToNext(task);
             }
             catch (Exception ex)
@@ -431,7 +400,7 @@
                 }
                 else if (task.TaskType == (int)TaskTypeEnum.Relocation)
                 {
-                    task.TaskStatus = (int)InTaskStatusEnum.RelocationExecuting;
+                    task.TaskStatus = (int)RelocationTaskStatusEnum.RelocationExecuting;
                 }
                 else
                 {
@@ -512,68 +481,82 @@
                 Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
                 if (task == null) return WebResponseContent.Instance.Error($"鏈壘鍒拌浠诲姟淇℃伅,浠诲姟鍙�:銆恵taskNum}銆�");
 
+                task.ModifyDate = DateTime.Now;
+                task.Modifier = "WMS";
                 if (task.TaskType == (int)TaskTypeEnum.Outbound || task.TaskType == (int)TaskTypeEnum.PalletOutbound)
                 {
                     _unitOfWorkManage.BeginTran();
                     task.TaskStatus = (int)OutTaskStatusEnum.OutFinish;
-                    task.ModifyDate = DateTime.Now;
-                    task.Modifier = "System";
+                    _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"鍫嗗灈鏈哄嚭搴撳畬鎴�");
+                    if(App.User.UserId > 0)
+                    {
+                        task.Modifier = "System";
+                        var response = HttpHelpers.Post<WebResponseContent>(url + "TaskCompleted?taskNum=" + task.TaskNum, "", "浠诲姟瀹屾垚");
+                        if (response.Status)
+                        {
+                            _unitOfWorkManage.CommitTran();
+                            return content.OK();
+                        }
+                        else
+                        {
+                            _unitOfWorkManage.RollbackTran();
+                            return content = WebResponseContent.Instance.Error(response.Message);
+                        }
+                    }
                     BaseDal.DeleteData(task);
                     _task_HtyService.AddTaskHty(task);
-                    _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"鍫嗗灈鏈哄嚭搴撳畬鎴�");
-                    var response = HttpHelpers.Post<WebResponseContent>(url + "TaskCompleted?taskNum="+task.TaskNum,"" , "浠诲姟瀹屾垚");
-                    if (response.Status)
-                    {
-                        _unitOfWorkManage.CommitTran();
-                        return content.OK();
-                    }
-                    else
-                    {
-                        _unitOfWorkManage.RollbackTran();
-                        return content = WebResponseContent.Instance.Error(response.Message);
-                    }
+                    _unitOfWorkManage.CommitTran();
+                    return content.OK();
                 }
                 else if (task.TaskType == (int)TaskTypeEnum.Inbound  || task.TaskType == (int)TaskTypeEnum.PalletInbound)
                 {
                     _unitOfWorkManage.BeginTran();
                     task.TaskStatus = (int)InTaskStatusEnum.InFinish;
-                    task.ModifyDate = DateTime.Now;
-                    task.Modifier = "System";
+                    _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"鍫嗗灈鏈哄叆搴撳畬鎴�");
+                    if (App.User.UserId > 0)
+                    {
+                        task.Modifier = "System";
+                        var response = HttpHelpers.Post<WebResponseContent>(url + "TaskCompleted?taskNum=" + task.TaskNum, "", "浠诲姟瀹屾垚");
+                        if (response.Status)
+                        {
+                            _unitOfWorkManage.CommitTran();
+                            return content.OK();
+                        }
+                        else
+                        {
+                            _unitOfWorkManage.RollbackTran();
+                            return content = WebResponseContent.Instance.Error(response.Message);
+                        }
+                    }
                     BaseDal.DeleteData(task);
                     _task_HtyService.AddTaskHty(task);
-                    _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"鍫嗗灈鏈哄叆搴撳畬鎴�");
-                    var response = HttpHelpers.Post<WebResponseContent>(url + "TaskCompleted?taskNum="+ task.TaskNum,"", "浠诲姟瀹屾垚");
-                    if (response.Status)
-                    {
-                        _unitOfWorkManage.CommitTran();
-                        return content.OK();
-                    }
-                    else
-                    {
-                        _unitOfWorkManage.RollbackTran();
-                        return content = WebResponseContent.Instance.Error(response.Message);
-                    }
+                    _unitOfWorkManage.CommitTran();
+                    return content.OK();
                 }
                 else if (task.TaskType== (int)TaskTypeEnum.Relocation)
                 {
                     _unitOfWorkManage.BeginTran();
-                    task.TaskStatus = (int)InTaskStatusEnum.RelocationFinish;
-                    task.ModifyDate = DateTime.Now;
-                    task.Modifier = "System";
+                    task.TaskStatus = (int)RelocationTaskStatusEnum.RelocationFinish;
+                    _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"鍫嗗灈鏈虹Щ搴撳畬鎴�");
+                    if (App.User.UserId > 0)
+                    {
+                        task.Modifier = "System";
+                        var response = HttpHelpers.Post<WebResponseContent>(url + "TaskCompleted?taskNum=" + task.TaskNum, "", "浠诲姟瀹屾垚");
+                        if (response.Status)
+                        {
+                            _unitOfWorkManage.CommitTran();
+                            return content.OK();
+                        }
+                        else
+                        {
+                            _unitOfWorkManage.RollbackTran();
+                            return content = WebResponseContent.Instance.Error(response.Message);
+                        }
+                    }
                     BaseDal.DeleteData(task);
                     _task_HtyService.AddTaskHty(task);
-                    _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"鍫嗗灈鏈虹Щ搴撳畬鎴�");
-                    var response = HttpHelpers.Post<WebResponseContent>(url + "TaskCompleted?taskNum=" + task.TaskNum, "", "浠诲姟瀹屾垚");
-                    if (response.Status)
-                    {
-                        _unitOfWorkManage.CommitTran();
-                        return content.OK();
-                    }
-                    else
-                    {
-                        _unitOfWorkManage.RollbackTran();
-                        return content = WebResponseContent.Instance.Error(response.Message);
-                    }
+                    _unitOfWorkManage.CommitTran();
+                    return content.OK();
                 }
                 else
                 {
@@ -587,10 +570,11 @@
             }
             finally
             {
-                WriteLog.GetLog("瀹屾垚浠诲姟").Write(JsonConvert.SerializeObject(content), "瀹屾垚浠诲姟");
+                WriteLog.GetLog("瀹屾垚浠诲姟").Write($"鎿嶄綔浜猴細{(App.User.UserId > 0 ? App.User.UserName : "")}{Environment.NewLine}浠诲姟鍙凤細{taskNum}{Environment.NewLine}{JsonConvert.SerializeObject(content)}", "瀹屾垚浠诲姟");
             }
             return content;
         }
+
         public WebResponseContent TaskCancel(int taskNum)
         {
             WebResponseContent content = new WebResponseContent();
@@ -599,68 +583,85 @@
                 Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
                 if (task == null) return WebResponseContent.Instance.Error($"鏈壘鍒拌浠诲姟淇℃伅,浠诲姟鍙�:銆恵taskNum}銆�");
 
+                task.ModifyDate = DateTime.Now;
+                task.Modifier = "WMS";
                 if (task.TaskType == (int)TaskTypeEnum.Outbound  || task.TaskType == (int)TaskTypeEnum.PalletOutbound)
                 {
                     _unitOfWorkManage.BeginTran();
                     task.TaskStatus = (int)OutTaskStatusEnum.OutCancel;
-                    task.ModifyDate = DateTime.Now;
-                    task.Modifier = "System";
-                    BaseDal.DeleteData(task);
-                    _task_HtyService.AddTaskHty(task);
                     _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"鍫嗗灈鏈哄嚭搴撳彇娑�");
-                    var response = HttpHelpers.Post<WebResponseContent>(url + "TaskCancel?taskNum=" + task.TaskNum, "", "浠诲姟鍙栨秷");
-                    if (response.Status)
+                    if (App.User.UserId > 0)
                     {
-                        _unitOfWorkManage.CommitTran();
-                        return content.OK();
+                        BaseDal.DeleteData(task);
+                        _task_HtyService.AddTaskHty(task);
+                        task.Modifier = "System";
+                        var response = HttpHelpers.Post<WebResponseContent>(url + "TaskCancel?taskNum=" + task.TaskNum, "", "鍙栨秷浠诲姟");
+                        if (response.Status)
+                        {
+                            _unitOfWorkManage.CommitTran();
+                            return content.OK();
+                        }
+                        else
+                        {
+                            UpdateTaskExceptionMessage(task.TaskNum, $"鍫嗗灈鏈轰换鍔″彇娑堝け璐�");
+                            _unitOfWorkManage.RollbackTran();
+                            return content = WebResponseContent.Instance.Error(response.Message);
+                        }
                     }
-                    else
-                    {
-                        _unitOfWorkManage.RollbackTran();
-                        return content = WebResponseContent.Instance.Error(response.Message);
-                    }
+                    _unitOfWorkManage.CommitTran();
+                    return content.OK();
                 }
                 else if (task.TaskType == (int)TaskTypeEnum.Inbound || task.TaskType == (int)TaskTypeEnum.PalletInbound)
                 {
                     _unitOfWorkManage.BeginTran();
                     task.TaskStatus = (int)InTaskStatusEnum.InCancel;
-                    task.ModifyDate = DateTime.Now;
-                    task.Modifier = "System";
+                    _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"鍫嗗灈鏈哄叆搴撳彇娑�");
+                    if (App.User.UserId > 0)
+                    {
+                        task.Modifier = "System";
+                        var response = HttpHelpers.Post<WebResponseContent>(url + "TaskCancel?taskNum=" + task.TaskNum, "", "鍙栨秷浠诲姟");
+                        if (response.Status)
+                        {
+                            _unitOfWorkManage.CommitTran();
+                            return content.OK();
+                        }
+                        else
+                        {
+                            UpdateTaskExceptionMessage(task.TaskNum, $"鍫嗗灈鏈轰换鍔″彇娑堝け璐�");
+                            _unitOfWorkManage.RollbackTran();
+                            return content = WebResponseContent.Instance.Error(response.Message);
+                        }
+                    }
                     BaseDal.DeleteData(task);
                     _task_HtyService.AddTaskHty(task);
-                    _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"鍫嗗灈鏈哄叆搴撳彇娑�");
-                    var response = HttpHelpers.Post<WebResponseContent>(url + "TaskCancel?taskNum=" + task.TaskNum, "", "浠诲姟鍙栨秷");
-                    if (response.Status)
-                    {
-                        _unitOfWorkManage.CommitTran();
-                        return content.OK();
-                    }
-                    else
-                    {
-                        _unitOfWorkManage.RollbackTran();
-                        return content = WebResponseContent.Instance.Error(response.Message);
-                    }
+                    _unitOfWorkManage.CommitTran();
+                    return content.OK();
                 }
                 else if (task.TaskType == (int)TaskTypeEnum.Relocation)
                 {
                     _unitOfWorkManage.BeginTran();
-                    task.TaskStatus = (int)InTaskStatusEnum.RelocationCancel;
-                    task.ModifyDate = DateTime.Now;
-                    task.Modifier = "System";
+                    task.TaskStatus = (int)RelocationTaskStatusEnum.RelocationCancel;
+                    _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"鍫嗗灈鏈虹Щ搴撳彇娑�");
+                    if (App.User.UserId > 0)
+                    {
+                        task.Modifier = "System";
+                        var response = HttpHelpers.Post<WebResponseContent>(url + "TaskCancel?taskNum=" + task.TaskNum, "", "鍙栨秷浠诲姟");
+                        if (response.Status)
+                        {
+                            _unitOfWorkManage.CommitTran();
+                            return content.OK();
+                        }
+                        else
+                        {
+                            UpdateTaskExceptionMessage(task.TaskNum, $"鍫嗗灈鏈轰换鍔″彇娑堝け璐�");
+                            _unitOfWorkManage.RollbackTran();
+                            return content = WebResponseContent.Instance.Error(response.Message);
+                        }
+                    }
                     BaseDal.DeleteData(task);
                     _task_HtyService.AddTaskHty(task);
-                    _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"鍫嗗灈鏈虹Щ搴撳彇娑�");
-                    var response = HttpHelpers.Post<WebResponseContent>(url + "TaskCancel?taskNum=" + task.TaskNum, "", "浠诲姟鍙栨秷");
-                    if (response.Status)
-                    {
-                        _unitOfWorkManage.CommitTran();
-                        return content.OK();
-                    }
-                    else
-                    {
-                        _unitOfWorkManage.RollbackTran();
-                       return content = WebResponseContent.Instance.Error(response.Message);
-                    }
+                    _unitOfWorkManage.CommitTran();
+                    return content.OK();
                 }
                 else
                 {
@@ -674,7 +675,7 @@
             }
             finally
             {
-                WriteLog.GetLog("鍙栨秷浠诲姟").Write(JsonConvert.SerializeObject(content), "鍙栨秷浠诲姟");
+                WriteLog.GetLog("鍙栨秷浠诲姟").Write($"鎿嶄綔浜猴細{(App.User.UserId > 0 ? App.User.UserName : "")}{Environment.NewLine}浠诲姟鍙凤細{taskNum}{Environment.NewLine}{JsonConvert.SerializeObject(content)}", "鍙栨秷浠诲姟");
             }
         }
         /// <summary>

--
Gitblit v1.9.3