新增iqc异常处置单接口

zjh

2025-09-12 d5d0d54d8ba486a5b2b669fb16df824a129faaeb

新增iqc异常处置单接口

 StandardPda/MES.Service/Dto/service/YCCZSubmit.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,10 @@
namespace MES.Service.Dto.service;

public class YCCZSubmit
{
    public string? PI_BILLNO { get; set; }
    public string? PI_USER { get; set; }
    public string? PI_QTY { get; set; }
    public string? PI_BADQTY { get; set; }

}

 StandardPda/MES.Service/service/QC/LljService.cs

@@ -365,6 +365,50 @@
        return msg;
    }


    public string[] SaveYCCZSubmit(YCCZSubmit sysSubmit)
    {
        // å®šä¹‰è¾“出参数
        var outputResult = new SugarParameter("o_Result", null,
            DbType.Int32, ParameterDirection.Output,
            4000);

        var outputMessage = new SugarParameter("o_Msg", null,
            DbType.String,
            ParameterDirection.Output, 4000);

        // å®šä¹‰è¾“入参数
        var parameters = new List<SugarParameter>
        {
            new("PI_BILLNO", sysSubmit.PI_BILLNO,
                DbType.String, ParameterDirection.Input),
            new("PI_USER", sysSubmit.PI_USER,
                DbType.String, ParameterDirection.Input),
            new("PTOTAL_QTY", sysSubmit.PI_QTY,
                DbType.String, ParameterDirection.Input),
            new("PNG_QTY", sysSubmit.PI_BADQTY,
                DbType.String, ParameterDirection.Input),

            outputResult,
            outputMessage
        };

        var db = SqlSugarHelper.GetInstance();

        // ä½¿ç”¨ SqlSugar æ‰§è¡Œå­˜å‚¨è¿‡ç¨‹
        db.Ado.ExecuteCommand(
            "BEGIN PRC_MES_IQC_QC_YCCZ(:PI_BILLNO,:PI_USER,:PTOTAL_QTY,:PNG_QTY,:o_Result, :o_Msg); END;",
            parameters.ToArray());

        // èŽ·å–输出参数的值
        var resultValue = outputResult.Value?.ToString();
        var messageValue = outputMessage.Value?.ToString();
        var msg = new string[2];
        msg[0] = resultValue;
        msg[1] = messageValue;
        return msg;
    }

    public static string BuildCurrentSign(string paramJson, string appSecret)
    {
        var commonDict = new Dictionary<string, string>();

 StandardPda/MESApplication/Controllers/QC/LljController.cs

@@ -594,6 +594,30 @@
            return ResponseResult.ResponseError(ex);
        }
    }
    /// <summary>
    ///     å¼‚常处置数据保存
    /// </summary>
    /// <param name="sysSubmit">异常处置数据</param>
    /// <returns></returns>
    [HttpPost("SaveYcczSubmit")]
    public ResponseResult SaveYcczSubmit(YCCZSubmit yCCZSubmit)
    {
        try
        {
            var msg = new LljService().SaveYCCZSubmit(yCCZSubmit);

            return new ResponseResult
            {
                status = int.Parse(msg[0]),
                message = msg[1],
                data = msg[1]
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     é€è´§å•ç­¾æ”¶å¹¶ç”Ÿæˆåˆ°è´§å•