抽检合格回库/不合格移库开发完成

kazelee

2025-05-13 38a8b2931abd72ee04285794aacbea7ed7c49228

 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; }
    }