数据库字段做映射

快乐的昕的电脑

2025-10-16 00b6ee0318f62da3ca5200f6a1eb7aeaddf42433

 Services/MesOrderStaManager.cs

@@ -104,15 +104,18 @@
        // 如果标记为1,需要处理首检相关逻辑
        if (entity.Flag == 1)
        {
            // 调用存储过程执行自动首检
            // Db.Ado.ExecuteCommand(
            //     "BEGIN AUTOMATIC_IPQC_FIRST_CHECK(:BILL_NO); END;",
            //     new SugarParameter("BILL_NO", womdaa.Daa001,
            //         DbType.String));
            //调用存储过程执行自动首检
             Db.Ado.ExecuteCommand(
                 "BEGIN AUTOMATIC_IPQC_FIRST_CHECK(:BILL_NO); END;",
                 new SugarParameter("BILL_NO", womdaa.Daa001, System.Data.DbType.String));
            var automaticIpqcFirstCheck =
                mesQaItemsDetect02Manager
                    .AutomaticIpqcFirstCheck(womdaa.Daa001);
            if (!automaticIpqcFirstCheck) throw new Exception("首检生成失败");
            if (!automaticIpqcFirstCheck)
            {
                Console.WriteLine($"自动首检失败，工单号：{womdaa.Daa001}");
                throw new Exception("首检生成失败");
            }

            // 获取当前时间
            var s1 = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
@@ -204,6 +207,9 @@
            // 如果有调机开始时间则更新
            .SetColumnsIF(entity.MaStartTime != null,
                s => s.MaStartTime == entity.MaStartTime)
            // 如果有调机完成时间则更新
            .SetColumnsIF(entity.MaEndTime != null,
                s => s.MaEndTime == entity.MaEndTime)
            // 如果标记为1则更新备注信息
            .SetColumnsIF(entity.Flag == 1,
                s => s.remark == "于" + entity.MaShoutTime + "时间有一次送检")
@@ -581,7 +587,7 @@

        if (binding)
            return Db.Updateable<MesOrderSta>()
                .SetColumns(s => s.MaEndTime == endDate)
                .SetColumns(s => s.MaEndTime == endDate) // 自动写入调机完成时间
                .SetColumns(s => s.StartTime == entity.MaShoutTime)
                .Where(s => s.OrderId == query.OrderId).ExecuteCommand() > 0;