From 452b9b63ada7ef220952412613552d36ed477adc Mon Sep 17 00:00:00 2001
From: kazelee <1847801760@qq.com>
Date: 星期一, 19 五月 2025 17:30:29 +0800
Subject: [PATCH] 测试，修复部分数据表问题
---
Controllers/DebugController.cs | 254 +++-----------------------------------------------
1 files changed, 17 insertions(+), 237 deletions(-)
diff --git a/Controllers/DebugController.cs b/Controllers/DebugController.cs
index 7dda76b..d4ef008 100644
--- a/Controllers/DebugController.cs
+++ b/Controllers/DebugController.cs
@@ -16,6 +16,9 @@
using static HH.WCS.Mobox3.AnGang.Dtos.Request.AgvRequest;
using static HH.WCS.Mobox3.AnGang.Dtos.Response.AgvResponse;
using HH.WCS.Mobox3.AnGang.Helpers;
+using HH.WCS.Mobox3.AnGang.Debug;
+using static HH.WCS.Mobox3.AnGang.Dtos.Request.DebugRequest;
+using static HH.WCS.Mobox3.AnGang.Dtos.Response.DebugResponse;
namespace HH.WCS.Mobox3.AnGang.Controllers
{
@@ -26,108 +29,14 @@
public class DebugController : System.Web.Http.ApiController
{
/// <summary>
- /// AGV鐘舵�涓�敭鍥炴姤134562
+ /// 妯℃嫙 AGV 澶氭鍥炴姤浠诲姟鐘舵�
/// </summary>
/// <param name="model">瀹瑰櫒鍙�/param>
/// <returns></returns>
[HttpPost]
- [Route("AGVSeriesReports")]
- public ReturnResults AGVSeriesReports(UpdateTaskState model)
- {
- var agvTaskState = new AgvTaskState()
- {
- task_no = model.TaskID,
- forklift_no = model.ForkliftNo,
- state = 1
- };
- ReturnResults returnResults = new ReturnResults();
- returnResults.resultList = new List<ReturnResult>();
-
- var temp1 = AgvService.OperateAgvTaskStatus(agvTaskState);
- returnResults.resultList.Add(temp1);
-
- agvTaskState.state = 3;
- var temp3 = AgvService.OperateAgvTaskStatus(agvTaskState);
- returnResults.resultList.Add(temp3);
-
- agvTaskState.state = 4;
- var temp4 = AgvService.OperateAgvTaskStatus(agvTaskState);
- returnResults.resultList.Add(temp4);
-
- agvTaskState.state = 5;
- var temp5 = AgvService.OperateAgvTaskStatus(agvTaskState);
- returnResults.resultList.Add(temp5);
-
- agvTaskState.state = 6;
- var temp6 = AgvService.OperateAgvTaskStatus(agvTaskState);
- returnResults.resultList.Add(temp6);
-
- agvTaskState.state = 2;
- var temp2 = AgvService.OperateAgvTaskStatus(agvTaskState);
- returnResults.resultList.Add(temp2);
-
- return returnResults;
- }
-
- /// <summary>
- /// AGV鐘舵�涓�敭鍥炴姤134
- /// </summary>
- /// <param name="model"></param>
- /// <returns></returns>
- [HttpPost]
- [Route("AGVSeriesReportsPartA")]
- public ReturnResults AGVSeriesReportsPartA(UpdateTaskState model) {
- var agvTaskState = new AgvTaskState() {
- task_no = model.TaskID,
- forklift_no = model.ForkliftNo,
- state = 1
- };
- ReturnResults returnResults = new ReturnResults();
- returnResults.resultList = new List<ReturnResult>();
-
- var temp1 = AgvService.OperateAgvTaskStatus(agvTaskState);
- returnResults.resultList.Add(temp1);
-
- agvTaskState.state = 3;
- var temp3 = AgvService.OperateAgvTaskStatus(agvTaskState);
- returnResults.resultList.Add(temp3);
-
- agvTaskState.state = 4;
- var temp4 = AgvService.OperateAgvTaskStatus(agvTaskState);
- returnResults.resultList.Add(temp4);
-
- return returnResults;
- }
-
- /// <summary>
- /// AGV鐘舵�涓�敭鍥炴姤562
- /// </summary>
- /// <param name="model"></param>
- /// <returns></returns>
- [HttpPost]
- [Route("AGVSeriesReportsPartB")]
- public ReturnResults AGVSeriesReportsPartB(UpdateTaskState model) {
- var agvTaskState = new AgvTaskState() {
- task_no = model.TaskID,
- forklift_no = model.ForkliftNo,
- state = 4
- };
- ReturnResults returnResults = new ReturnResults();
- returnResults.resultList = new List<ReturnResult>();
-
- agvTaskState.state = 5;
- var temp5 = AgvService.OperateAgvTaskStatus(agvTaskState);
- returnResults.resultList.Add(temp5);
-
- agvTaskState.state = 6;
- var temp6 = AgvService.OperateAgvTaskStatus(agvTaskState);
- returnResults.resultList.Add(temp6);
-
- agvTaskState.state = 2;
- var temp2 = AgvService.OperateAgvTaskStatus(agvTaskState);
- returnResults.resultList.Add(temp2);
-
- return returnResults;
+ [Route("AgvSeriesReports")]
+ public ReturnResults AgvSeriesReports(UpdateTaskState model) {
+ return DebugService.AgvSeriesReports(model);
}
/// <summary>
@@ -135,154 +44,25 @@
/// </summary>
/// <returns></returns>
[HttpPost]
- [Route("BuildDB")]
- public string BuildDB()
- {
- //bool res = false;
- try
- {
- var db = DbHelper.GetDbClient();
- //db.CodeFirst.InitTables<WCSTask>(); //鎵�湁搴撻兘鏀寔
- //db.CodeFirst.InitTables<Zone>();
- //db.CodeFirst.InitTables<Area>();
- //db.CodeFirst.InitTables<Location>();
- //db.CodeFirst.InitTables<LocCntrRel>();
- //db.CodeFirst.InitTables<Container>();
- //db.CodeFirst.InitTables<TN_CG_Detail>();
- //db.CodeFirst.InitTables<TN_WorkOrder>();
- //db.CodeFirst.InitTables<TN_CAR_IN>();
- //db.CodeFirst.InitTables<SYSHelper.OI_SYS_MAXID>();
- //db.CodeFirst.InitTables<TN_Task_Action>();
- //db.CodeFirst.InitTables<TN_Task>();
- //db.CodeFirst.InitTables<TN_Location>();
- //db.CodeFirst.InitTables<TN_Loc_Container>();
-
- var locList = new List<TN_Location>();
- //foreach (var area in Settings.Areas.Skip(1).ToList()) {
- // for (int i = 0; i < 8; i++) {
- // for (int j = 0; j < 30; j++) {
- // locList.Add(new TN_Location { S_SHELF_CODE = area, S_CODE = $"{area}-{i + 1}-{j + 1}", S_NAME = $"{area}璐ф灦 绗瑊i + 1}灞�绗瑊j + 1}鍙疯揣浣�, S_AGV_SITE = $"{area}-{i + 1}-{j + 1}", N_HEIGHT = i + 1 });
- // }
- // }
- //}
- locList.Add(new TN_Location { S_AREA_CODE = "B111", S_CODE = "B111-1-1", S_NAME = "B111-1-1", S_AGV_SITE = "B111-1-1"});
- locList.Add(new TN_Location { S_AREA_CODE = "B111", S_CODE = "B111-4-1", S_NAME = "B111-4-1", S_AGV_SITE = "B111-4-1"});
- locList.Add(new TN_Location { S_AREA_CODE = "B112", S_CODE = "B112-1-1", S_NAME = "B112-1-1", S_AGV_SITE = "B112-1-1"});
-
- //locList.Add(new TN_Location { S_AREA_CODE = Settings.Areas[0], S_SHELF_CODE = Settings.Areas[0], S_CODE = Settings.Areas[0] + "-1", S_NAME = "鍙栨斁璐у尯-1", S_AGV_SITE = "P0-1"});
- //locList.Add(new TN_Location { S_AREA_CODE = Settings.Areas[0], S_SHELF_CODE = Settings.Areas[0], S_CODE = Settings.Areas[0] + "-2", S_NAME = "鍙栨斁璐у尯-2", S_AGV_SITE = "P0-2"});
- if (db.Insertable<TN_Location>(locList).ExecuteCommand() <= 0) {
- return "澶辫触";
- }
-
-
- }
- catch (Exception ex)
- {
- LogHelper.Info($"鍙戠敓浜嗗紓甯�);
- return "鍒濆鍖栨暟鎹簱閿欒" + ex.Message;
- }
- //return res ? "鎴愬姛" : "澶辫触";
- return "鎴愬姛";
+ [Route("CreateDatabase")]
+ public string CreateDatabase(CoverInfo model) {
+ return DebugService.CreateDatabase(model.IsCover);
}
/// <summary>
- /// 淇敼浠诲姟鐨勯噸閲忥紝渚夸簬娴嬭瘯
+ /// DEBUG锛氭彃鍏ヨ揣浣嶃�瀹瑰櫒銆佽揣鍝佷俊鎭� /// </summary>
/// <returns></returns>
[HttpPost]
- [Route("UpdateTaskWeight")]
-
- public string UpdateTaskWeight(UpdateTaskWeightInfo model) {
- var db = DbHelper.GetDbClient();
- var task = db.Queryable<TN_Task>().First(a => a.S_CODE == model.TaskID);
- if (task == null) {
- return "浠诲姟鍙蜂笉瀛樺湪";
- }
- task.F_WEIGHT = model.Weight;
-
- try {
- using (var trans = db.Ado.UseTran()) {
- if (db.Updateable<TN_Task>(task).ExecuteCommand() > 0) {
- trans.CommitTran();
- return $"鎴愬姛 | 淇敼浠诲姟{task.S_CODE}閲嶉噺涓簕task.F_WEIGHT}";
- }
- else {
- trans.RollbackTran();
- return $"澶辫触 | 淇敼浠诲姟{task.S_CODE}閲嶉噺涓簕task.F_WEIGHT}";
- }
- }
- }
- catch (Exception ex) {
- return ex.Message;
- }
+ [Route("InsertLocCntrCg")]
+ public string InsertLocCntrCg() {
+ return DebugService.InsertLocCntrCg();
}
[HttpPost]
- public string AddCgCntrLocRel(CgInfo model) {
- var db = DbHelper.GetDbClient();
-
- try {
- var loc = db.Queryable<TN_Location>().First(a => a.S_CODE == model.LocId);
- if (loc == null) {
- var locList = new List<TN_Location>();
- locList.Add(new TN_Location { S_CODE = model.LocId, N_CURRENT_NUM = 1 });
- if (db.Insertable<TN_Location>(locList).ExecuteCommand() <= 0) {
- return $"鎻掑叆浣嶇疆{model.LocId}澶辫触";
- }
- }
- if (loc.N_CURRENT_NUM == 0) {
- loc.N_CURRENT_NUM = 1;
- if (db.Updateable<TN_Location>(loc).UpdateColumns(it => new { it.N_CURRENT_NUM, it.T_MODIFY }).ExecuteCommand() <= 0) {
- return $"淇敼浣嶇疆{model.LocId}澶辫触";
- }
- }
-
- var locCntrRel = db.Queryable<TN_Loc_Container>().First(a => a.S_LOC_CODE == model.LocId && a.S_CNTR_CODE == model.CntId);
- if (loc == null) {
- var locList = new List<TN_Loc_Container>();
- locList.Add(new TN_Loc_Container { S_LOC_CODE = model.LocId, S_CNTR_CODE = model.CntId });
- if (db.Insertable<TN_Loc_Container>(locList).ExecuteCommand() <= 0) {
- return $"鎻掑叆浣嶇疆鎵樼洏鍏崇郴{model.LocId}-{model.CntId}澶辫触";
- }
- }
-
- var cgDetail = db.Queryable<TN_CG_Detail>().First(a => a.S_CNTR_CODE == model.CntId && a.S_CG_ID == model.CgId);
- if (cgDetail == null) {
- var locList = new List<TN_CG_Detail>();
- locList.Add(new TN_CG_Detail { S_CNTR_CODE = model.CntId, S_CG_ID = model.CntId });
- if (db.Insertable<TN_CG_Detail>(locList).ExecuteCommand() <= 0) {
- return $"鎻掑叆鎵樼洏鐗╂枡鍏崇郴{model.CntId}-{model.CgId}澶辫触";
- }
- }
- }
- catch (Exception ex) {
- return $"鍑洪敊锛歿ex}";
- }
-
- return "success";
+ [Route("SetTaskWeight")]
+ public string SetTaskWeight(SetTaskWeightInfo model) {
+ return DebugService.SetTaskWeight(model);
}
- }
-
- public class CgInfo {
- public string CgId { get; set; }
- public string CntId { get; set; }
- public string LocId { get; set; }
- }
-
- public class UpdateTaskState
- {
- public string TaskID { set; get; } // 浠诲姟ID
- public string ForkliftNo { set; get; } // AGV 灏忚溅鍙�- }
-
- public class UpdateTaskWeightInfo {
- public string TaskID { set; get; }
- public float Weight { set; get; }
- }
-
- public class ReturnResults
- {
- public List<ReturnResult> resultList { set; get; }
}
}
--
Gitblit v1.9.1