From b079910e5de15863c26e479ffab15cc45d706f1a Mon Sep 17 00:00:00 2001
From: kazelee <1847801760@qq.com>
Date: 星期一, 19 五月 2025 16:25:22 +0800
Subject: [PATCH] 测试修复轮询出库、抽检流程的问题

---
 Controllers/DebugController.cs |  129 +------------------------------------------
 1 files changed, 3 insertions(+), 126 deletions(-)

diff --git a/Controllers/DebugController.cs b/Controllers/DebugController.cs
index 174d012..a4b1496 100644
--- a/Controllers/DebugController.cs
+++ b/Controllers/DebugController.cs
@@ -35,63 +35,9 @@
         /// </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 "鎴愬姛";
-        }
-
-        [HttpPost]
-        [Route("InsertLocation")]
-        public string InsertLocation(InsertLocationInfo model) {
-            try {
-                var db = DbHelper.GetDbClient();
-                
-                var locList = new List<TN_Location>();
-                locList.Add(new TN_Location { S_AREA_CODE = model.AreaCode, S_CODE = model.Code});
-
-                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>
@@ -103,74 +49,5 @@
         public string InsertLocCntrCg() {
             return DebugService.InsertLocCntrCg();
         }
-
-        public string AddCgCntrLocRel(CgInfo model) {
-            var db = DbHelper.GetDbClient();
-
-            try {
-                using (var tran = db.Ado.UseTran()) {
-                    var loc = db.Queryable<TN_Location>().First(a => a.S_CODE == model.LocId);
-                    if (loc == null) {
-                        var newLoc = new TN_Location { S_CODE = model.LocId, N_CURRENT_NUM = 1 };
-                        if (db.Insertable<TN_Location>(newLoc).ExecuteCommand() <= 0) {
-                            tran.RollbackTran();
-                            return $"鎻掑叆浣嶇疆{model.LocId}澶辫触";
-                        }
-                        loc = db.Queryable<TN_Location>().First(a => a.S_CODE == 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) {
-                            tran.RollbackTran();
-                            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 (locCntrRel == 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) {
-                            tran.RollbackTran();
-                            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) {
-                            tran.RollbackTran();
-                            return $"鎻掑叆鎵樼洏鐗╂枡鍏崇郴{model.CntId}-{model.CgId}澶辫触";
-                        }
-                    }
-
-                    tran.CommitTran();
-                }
-            }
-            catch (Exception ex) {
-                return $"鍑洪敊锛歿ex}";
-            }
-
-            return "success";
-        }
-    }
-
-    public class CgInfo {
-        public string CgId { get; set; }
-        public string CntId { get; set; }
-        public string LocId { get; set; }
-    }
-
-    public class InsertLocationInfo {
-        public string Code { set; get; } 
-        public string AreaCode { set; get; }
-    }
-
-    public class UpdateTaskWeightInfo {
-        public string TaskID { set; get; }
-        public float Weight { set; get; }
     }
 }

--
Gitblit v1.9.1