From 38a8b2931abd72ee04285794aacbea7ed7c49228 Mon Sep 17 00:00:00 2001 From: kazelee <1847801760@qq.com> Date: 星期二, 13 五月 2025 17:06:43 +0800 Subject: [PATCH] 抽检合格回库/不合格移库开发完成 --- Controllers/DebugController.cs | 48 ++++++++---------------------------------------- 1 files changed, 8 insertions(+), 40 deletions(-) diff --git a/Controllers/DebugController.cs b/Controllers/DebugController.cs index 174d012..90a1f58 100644 --- a/Controllers/DebugController.cs +++ b/Controllers/DebugController.cs @@ -29,47 +29,15 @@ { return DebugService.AgvSeriesReports(model); } - + /// <summary> /// 鍒濆鍖栨暟鎹簱 /// </summary> /// <returns></returns> [HttpPost] - [Route("BuildDB")] - public string BuildDB() - { - 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<SYSHelper.OI_SYS_MAXID>(); - - db.CodeFirst.InitTables<TN_CG_Detail>(); - db.CodeFirst.InitTables<TN_WorkOrder>(); - db.CodeFirst.InitTables<TN_CAR_IN>(); - - db.CodeFirst.InitTables<TN_Task_Action>(); - db.CodeFirst.InitTables<TN_Task>(); - db.CodeFirst.InitTables<TN_Location>(); - db.CodeFirst.InitTables<TN_Loc_Container>(); - - db.CodeFirst.InitTables<TN_Outbound_Order>(); - db.CodeFirst.InitTables<TN_Outbound_Detail>(); - db.CodeFirst.InitTables<TN_Outbound_Task>(); - } - catch (Exception ex) - { - LogHelper.Info($"鍙戠敓浜嗗紓甯�); - return "鍒濆鍖栨暟鎹簱閿欒" + ex.Message; - } - //return res ? "鎴愬姛" : "澶辫触"; - return "鎴愬姛"; + [Route("CreateDatabase")] + public string CreateDatabase() { + return DebugService.CreateDatabase(); } [HttpPost] @@ -137,13 +105,13 @@ } } - var cgDetail = db.Queryable<TN_CG_Detail>().First(a => a.S_CNTR_CODE == model.CntId && a.S_CG_ID == model.CgId); + var cgDetail = db.Queryable<TN_CG_Detail>().First(a => a.S_CNTR_CODE == model.CntId && a.S_ITEM_CODE == model.ItemCode); 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 }); + locList.Add(new TN_CG_Detail { S_CNTR_CODE = model.CntId, S_ITEM_CODE = model.ItemCode }); if (db.Insertable<TN_CG_Detail>(locList).ExecuteCommand() <= 0) { tran.RollbackTran(); - return $"鎻掑叆鎵樼洏鐗╂枡鍏崇郴{model.CntId}-{model.CgId}澶辫触"; + return $"鎻掑叆鎵樼洏鐗╂枡鍏崇郴{model.CntId}-{model.ItemCode}澶辫触"; } } @@ -159,7 +127,7 @@ } public class CgInfo { - public string CgId { get; set; } + public string ItemCode { get; set; } public string CntId { get; set; } public string LocId { get; set; } } -- Gitblit v1.9.1