From 49efcc39ef399f8f3b170f6b06ffc2177643f1b2 Mon Sep 17 00:00:00 2001
From: kazelee <1847801760@qq.com>
Date: 星期二, 27 五月 2025 17:27:39 +0800
Subject: [PATCH] 优化空托上线通过物料类型检查容器的功能

---
 api/DebugController.cs |  112 +++++++++++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 106 insertions(+), 6 deletions(-)

diff --git a/api/DebugController.cs b/api/DebugController.cs
index 2a5c8bd..425fc6e 100644
--- a/api/DebugController.cs
+++ b/api/DebugController.cs
@@ -3,6 +3,7 @@
 using System.Runtime.ConstrainedExecution;
 using System.Web.Http;
 
+using HH.WCS.Mobox3.DSZSH.core;
 using HH.WCS.Mobox3.DSZSH.models;
 using HH.WCS.Mobox3.DSZSH.util;
 
@@ -18,15 +19,45 @@
     public class DebugController : ApiController
     {
         /// <summary>
-        /// 妯℃嫙 AGV 澶氭鍥炴姤浠诲姟鐘舵�
+        /// AGV鐘舵�涓�敭鍥炴姤134562
         /// </summary>
         /// <param name="model">瀹瑰櫒鍙�/param>
         /// <returns></returns>
         [HttpPost]
-        [Route("AgvSeriesReports")]
-        public ReturnResults AgvSeriesReports(UpdateTaskState model)
-        {
-            return new ReturnResults();
+        [Route("AGVSeriesReports")]
+        public ReturnResults AGVSeriesReports(UpdateTaskState model) {
+            var agvTaskState = new AgvTaskState() {
+                task_no = model.TaskID,
+                forklift_no = model.ForkliftNo,
+                state = 1
+            };
+            ReturnResults returnResult = new ReturnResults();
+            returnResult.ResultList = new List<ReturnResult>();
+
+            var temp1 = WCSCore.OperateAgvTaskStatus(agvTaskState);
+            returnResult.ResultList.Add(temp1);
+
+            agvTaskState.state = 3;
+            var temp3 = WCSCore.OperateAgvTaskStatus(agvTaskState);
+            returnResult.ResultList.Add(temp3);
+
+            agvTaskState.state = 4;
+            var temp4 = WCSCore.OperateAgvTaskStatus(agvTaskState);
+            returnResult.ResultList.Add(temp4);
+
+            agvTaskState.state = 5;
+            var temp5 = WCSCore.OperateAgvTaskStatus(agvTaskState);
+            returnResult.ResultList.Add(temp5);
+
+            agvTaskState.state = 6;
+            var temp6 = WCSCore.OperateAgvTaskStatus(agvTaskState);
+            returnResult.ResultList.Add(temp6);
+
+            agvTaskState.state = 2;
+            var temp2 = WCSCore.OperateAgvTaskStatus(agvTaskState);
+            returnResult.ResultList.Add(temp2);
+
+            return returnResult;
         }
 
         /// <summary>
@@ -51,13 +82,15 @@
                     //typeof(SysHelper.OI_SYS_MAXID),
 
                     //typeof(TN_Inbound_Order),
-                    typeof(TN_Check_Detail),
+                    //typeof(TN_Check_Detail),
                     //typeof(TN_Check_Order),
                     //typeof(TN_CNTR_ITEM),
                     //typeof(TN_Outbound_Detail),
                     //typeof(TN_Outbound_Order),
                     //typeof(TN_Shift_Order),
                     //typeof(TN_Shift_Detail)
+
+                    typeof(TN_Container_Item),
                 };
 
                 using (var tran = db.Ado.UseTran()) {
@@ -172,6 +205,68 @@
                 return $"Error reading CSV file: {ex.Message}";
             }
         }
+
+        /// <summary>
+        /// DEBUG锛氭牴鎹鍣ㄧ墿鏂欎俊鎭〃锛屾彃鍏ュ鍣ㄧ墿鏂欑櫥璁颁俊鎭〃
+        /// </summary>
+        /// <returns></returns>
+        [HttpPost]
+        [Route("InsertContainerItemByCgDetail")]
+        public string InsertContainerItemByCgDetail(CoverInfo _) {
+            var db = new SqlHelper<object>().GetInstance();
+            try {
+                var cgDetailList = db.Queryable<TN_CG_Detail>().ToList();
+                var cntrItemList = new List<TN_Container_Item>();
+                foreach (var cgDetail in cgDetailList) {
+                    if (db.Queryable<TN_Container_Item>().Where(i => i.S_CNTR_CODE == cgDetail.S_CNTR_CODE).Any()) {
+                        continue;
+                    }
+
+                    cntrItemList.Add(new TN_Container_Item {
+                        S_CNTR_CODE = cgDetail.S_CNTR_CODE,
+                        S_ITEM_CODE = cgDetail.S_ITEM_CODE,
+                    });
+                }
+
+                if (db.Insertable<TN_Container_Item>(cntrItemList).ExecuteCommand() <= 0) {
+                    return "鎻掑叆澶辫触";
+                }
+
+                return "鎻掑叆鎴愬姛";
+            }
+            catch (Exception ex) {
+
+                LogHelper.InfoEx(ex);
+                return ex.Message;
+            }
+        }
+
+        /// <summary>
+        /// DEBUG锛氭牴鎹鍣ㄧ墿鏂欎俊鎭〃锛屾彃鍏ュ鍣ㄧ墿鏂欑櫥璁颁俊鎭〃
+        /// </summary>
+        /// <returns></returns>
+        [HttpPost]
+        [Route("InsertContainerItem")]
+        public string InsertContainerItem(InsertCntrItemInfo cgDetail) {
+            var db = new SqlHelper<object>().GetInstance();
+            try {
+                var cntrItem = new TN_Container_Item {
+                    S_CNTR_CODE = cgDetail.Cntr,
+                    S_ITEM_CODE = cgDetail.Item,
+                };
+
+                if (db.Insertable<TN_Container_Item>(cntrItem).ExecuteCommand() <= 0) {
+                    return "鎻掑叆澶辫触";
+                }
+
+                return "鎻掑叆鎴愬姛";
+            }
+            catch (Exception ex) {
+
+                LogHelper.InfoEx(ex);
+                return ex.Message;
+            }
+        }
     }
 
     /// <summary>
@@ -196,6 +291,11 @@
         public bool IsCover { set; get; } = false;
     }
 
+    public class InsertCntrItemInfo {
+        public string Cntr { set; get; }
+        public string Item { set; get; }
+    }
+
     /// <summary>
     /// 
     /// </summary>

--
Gitblit v1.9.1