完成并测试抽检出库的逻辑，修复相关问题

kazelee

2025-05-12 968d603a08117e7e6707ffe07c6da9c325e36c08

 Services/DebugService.cs

@@ -16,6 +16,7 @@
using static HH.WCS.Mobox3.DSZSH.Dtos.Request.DebugRequest;
using static HH.WCS.Mobox3.DSZSH.Dtos.Response.AgvResponse;
using static HH.WCS.Mobox3.DSZSH.Dtos.Response.DebugResponse;
using static HH.WCS.Mobox3.DSZSH.Models.DebugModel;

namespace HH.WCS.Mobox3.DSZSH.Services {
    public class DebugService {
@@ -79,22 +80,24 @@
        /// 初始数据库建立
        /// </summary>
        /// <returns></returns>
        public string CreateDatabase() {
        public static string CreateDatabase() {
            try {
                var db = DbHelper.GetDbClient();

                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>();
                //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>();

                db.CodeFirst.InitTables<TN_Outbound_Order>();
                db.CodeFirst.InitTables<TN_Outbound_Detail>();
                db.CodeFirst.InitTables<TN_Outbound_Task>();
                //db.CodeFirst.InitTables<TN_Outbound_Order>();
                //db.CodeFirst.InitTables<TN_Outbound_Detail>();
                //db.CodeFirst.InitTables<TN_Check_Order>();
                db.CodeFirst.InitTables<TN_Check_Detail>();

            }
            catch (Exception ex) {
                LogHelper.Info($"发生了异常");
@@ -118,12 +121,12 @@
                    BadDataFound = context => { }  // 处理错误数据
                };

                var locCntrCgList = new List<DebugModel.LocCntrCg>();
                var locCntrCgList = new List<LocCntrCg>();

                using (var reader = new StreamReader(filePath))
                using (var csv = new CsvReader(reader, configuration)) {
                    // 读取记录
                    locCntrCgList = csv.GetRecords<DebugModel.LocCntrCg>().ToList();
                    locCntrCgList = csv.GetRecords<LocCntrCg>().ToList();
                }

                using (var tran = db.UseTran()) {