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