11

啊鑫

2025-07-29 cabbae559dcce428781a3951ab42bf4a458fc66c

 MES.Service/service/QC/MesOqcItemsDetect02Manager.cs

@@ -229,6 +229,47 @@
        return 0;
    }

    public bool Regenerate(MesOqcItemsDetect02 from)
    {
        // 定义输出参数
        var outputResult = new SugarParameter("PO_RESULT", null,
            DbType.Int32, ParameterDirection.Output, 4000);
        var outputMessage = new SugarParameter("PO_TEXT", null,
            DbType.String,
            ParameterDirection.Output, 4000);

        // 定义输入参数
        var parameters = new List<SugarParameter>
        {
            new("P_RELEASE_NO", from.ReleaseNo, DbType.String,
                ParameterDirection.Input),
            new("P_ITEM_ID", from.ItemId, DbType.Int32,
                ParameterDirection.Input),
            new("P_BILL_NO  ", "", DbType.String,
                ParameterDirection.Input),
            outputResult,
            outputMessage
        };

        var db = SqlSugarHelper.GetInstance();

        // 使用 SqlSugar 执行存储过程
        db.Ado.ExecuteCommand(
            "BEGIN PRC_OQC_ITEM_INSERT_BTN(:P_RELEASE_NO,:P_ITEM_ID,:P_BILL_NO,:PO_RESULT, :PO_TEXT); END;",
            parameters.ToArray());

        // 获取输出参数的值
        var resultValue = outputResult.Value?.ToString();
        var messageValue = outputMessage.Value?.ToString();

        if ("1".Equals(resultValue))
            // 处理失败情况，返回错误信息
            throw new Exception($"操作失败: {messageValue}");

        // 当 resultValue 为 "0" 时返回成功状态
        return true;
    }

    public OQCDto getXjDetail02ById(decimal? id)
    {
        var rkjDto = new OQCDto();
@@ -454,7 +495,7 @@
            throw new Exception(ex.Message);
        }
    }
    

    public int saveRemarksGid(LLJDto dto)
    {
        return SqlSugarHelper.UseTransactionWithOracle(db =>
@@ -466,7 +507,7 @@
                .ExecuteCommand();
        });
    }
    

    public int SetQSItemDetail(MesOqcItemsDetectDetail12 detail)
    {
        var oracle = SqlSugarHelper.UseTransactionWithOracle(db =>
@@ -490,7 +531,7 @@
        });

        detail.CreateBy = detail.LastupdateBy;
        

        autoResult(detail);

        return oracle;