生产入库增加批量批准

cnf

2025-11-19 7e33342b2b1c9b8aa40a4caf693bbca8e5c3a5a8

生产入库增加批量批准

 WebApi/.vs/GsMesSolution/CopilotIndices/17.14.786.1071/CodeChunks.db

Binary files differ

 WebApi/.vs/GsMesSolution/CopilotIndices/17.14.786.1071/CodeChunks.db-shm

Binary files differ

 WebApi/.vs/GsMesSolution/CopilotIndices/17.14.786.1071/CodeChunks.db-wal

Binary files differ

 WebApi/.vs/GsMesSolution/CopilotIndices/17.14.786.1071/SemanticSymbols.db

Binary files differ

 WebApi/.vs/GsMesSolution/CopilotIndices/17.14.786.1071/SemanticSymbols.db-shm

Binary files differ

 WebApi/.vs/GsMesSolution/CopilotIndices/17.14.786.1071/SemanticSymbols.db-wal

Binary files differ

 WebApi/Gs.Wom/Service/MesScrkDjManager.cs

@@ -252,4 +252,142 @@
        return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg);
    }

    /// <summary>
    ///     批准
    /// </summary>
    /// <param name="mode"></param> 
    /// <returns></returns>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<ExpandoObject> EditModelPiZhun([FromBody] dynamic mode)
    {
        string _billNo = mode.billNo;
        string _inFieldValue = mode.inFieldValue;
        string _proName = "prc_scrk_pizhun";
        dynamic m = new ExpandoObject();
        m.outSum = -1;
        m.outMsg = "";

        if (!Guid.TryParse(_userGuid, out Guid userGuid))
            throw new ArgumentException("无效的 UserGuid");
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            using (var cmd = new SqlCommand(_proName, conn))
            {
                try
                {
                    conn.Open();
                    cmd.CommandType = CommandType.StoredProcedure;
                    // 按照存储过程定义的顺序添加参数
                    SqlParameter[] parameters =
                    {
                         // 输入参数（按顺序）
                         new SqlParameter("@inEdtUserGuid", SqlDbType.UniqueIdentifier) { Value = userGuid },
                         new SqlParameter("@inOrderGuids", SqlDbType.NVarChar, -1) { Value = _billNo ?? (object)DBNull.Value },
                        new SqlParameter("@inFieldValue", SqlDbType.NVarChar) { Value = _inFieldValue ?? (object)DBNull.Value },
                         new SqlParameter("@in1", SqlDbType.NVarChar, 100) { Value = string.Empty },
                         new SqlParameter("@in2", SqlDbType.NVarChar, 100) { Value = string.Empty },
                         new SqlParameter("@in3", SqlDbType.NVarChar, 100) { Value = string.Empty },
                
                         // 输出参数（最后）
                         new SqlParameter("@outMsg", SqlDbType.NVarChar, 2000) { Direction = ParameterDirection.Output },
                         new SqlParameter("@outSum", SqlDbType.Int) { Direction = ParameterDirection.Output }
                    };

                    foreach (var parameter in parameters)
                        cmd.Parameters.Add(parameter);

                    cmd.ExecuteNonQuery();

                    m.outMsg = parameters[6].Value?.ToString() ?? ""; // @outMsg是第8个参数（索引7）
                    if (parameters[7].Value != DBNull.Value && parameters[7].Value != null)
                    {
                        m.outSum = Convert.ToInt32(parameters[7].Value); // @outSum是第9个参数（索引8）
                    }
                }
                catch (Exception ex)
                {
                    LogHelper.Debug(ToString(),
                        "prc_scrk_pizhun error：" + ex.Message);
                    m.outMsg = ex.Message;
                    return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default,
                        ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        }
        return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "操作成功！");
    }

    /// <summary>
    ///    反批准
    /// </summary>
    /// <param name="mode"></param> 
    /// <returns></returns>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<ExpandoObject> EditModelFPiZhun([FromBody] dynamic mode)
    {
        string _billNo = mode.billNo;
        string _inFieldValue = mode.inFieldValue;
        string _proName = "prc_scrk_pizhun";
        dynamic m = new ExpandoObject();
        m.outSum = -1;
        m.outMsg = "";

        if (!Guid.TryParse(_userGuid, out Guid userGuid))
            throw new ArgumentException("无效的 UserGuid");
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            using (var cmd = new SqlCommand(_proName, conn))
            {
                try
                {
                    conn.Open();
                    cmd.CommandType = CommandType.StoredProcedure;
                    // 按照存储过程定义的顺序添加参数
                    SqlParameter[] parameters =
                    {
                         // 输入参数（按顺序）
                         new SqlParameter("@inEdtUserGuid", SqlDbType.UniqueIdentifier) { Value = userGuid },
                         new SqlParameter("@inOrderGuids", SqlDbType.NVarChar, -1) { Value = _billNo ?? (object)DBNull.Value },
                         new SqlParameter("@inFieldValue", SqlDbType.NVarChar) { Value = _inFieldValue ?? (object)DBNull.Value },
                         new SqlParameter("@in1", SqlDbType.NVarChar, 100) { Value = string.Empty },
                         new SqlParameter("@in2", SqlDbType.NVarChar, 100) { Value = string.Empty },
                         new SqlParameter("@in3", SqlDbType.NVarChar, 100) { Value = string.Empty },
                
                         // 输出参数（最后）
                         new SqlParameter("@outMsg", SqlDbType.NVarChar, 2000) { Direction = ParameterDirection.Output },
                         new SqlParameter("@outSum", SqlDbType.Int) { Direction = ParameterDirection.Output }
                    };

                    foreach (var parameter in parameters)
                        cmd.Parameters.Add(parameter);

                    cmd.ExecuteNonQuery();

                    m.outMsg = parameters[6].Value?.ToString() ?? ""; // @outMsg是第8个参数（索引7）
                    if (parameters[7].Value != DBNull.Value && parameters[7].Value != null)
                    {
                        m.outSum = Convert.ToInt32(parameters[7].Value); // @outSum是第9个参数（索引8）
                    }
                }
                catch (Exception ex)
                {
                    LogHelper.Debug(ToString(),
                        "prc_scrk_pizhun error：" + ex.Message);
                    m.outMsg = ex.Message;
                    return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default,
                        ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        }
        return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "操作成功！");
    }

}