修复字段类型bug，入库检提交更新结果

zyf

2025-12-04 174707ef5fb6cc8e2b0f973b5f7345e7b89b2d77

 MES.Service/service/QC/RKJService.cs

@@ -2,6 +2,7 @@
using MES.Service.Dto.service;
using MES.Service.Modes;
using MES.Service.util;
using Microsoft.VisualStudio.TestPlatform.CommunicationUtilities;
using SqlSugar;
using SqlSugar.Extensions;

@@ -925,9 +926,29 @@
                    .ExecuteCommand();
            });

        var P_NO = new SugarParameter("P_NO", dto.releaseNo);

        var db = SqlSugarHelper.GetInstance();
        var FRes = new SugarParameter("c_result", null, true); // 输出参数
        var FMsg = new SugarParameter("c_msg", null, true);

        // 执行存储过程
        db.Ado.UseStoredProcedure().GetDataTable("PRC_RKJ_UPDATE_RESU_JK",P_NO,FRes, FMsg);

        // 获取输出结果
        var Res = Convert.ToInt32(FRes.Value);
        var Msg = FMsg.Value?.ToString();

        Console.WriteLine($"结果: {Res}, 返回消息: {Msg}");

        if ( Res == 1 )
        {
            throw new Exception(Msg);
        }

        if (useTransactionWithOracle > 0)
        {
            var db = SqlSugarHelper.GetInstance();
            
            // 成功提交后推送钉钉消息
            var qaRkj = db.Queryable<QaRkj>()
                .Where(s => s.ReleaseNo == dto.releaseNo)
@@ -959,6 +980,8 @@
            }
        }



        return useTransactionWithOracle;
    }