/// <summary>
/// 执行存储过程方法
/// </summary>
/// <param name="storedProcName"></param>
/// <param name="lists"></param>
/// <returns></returns>
public string[] GetOutRunProcedure(string storedProcName, string rid, string SDIId, string limit)
{
DataSet ds = new DataSet();
IDataParameter[] iData = null;
string[] nums = new string[3];
try
{
iData = new MySqlParameter[6];
iData[0] = new MySqlParameter("p_rid", rid);
iData[1] = new MySqlParameter("p_SDIId", SDIId);
iData[2] = new MySqlParameter("p_limit", limit);
iData[3] = new MySqlParameter("p_better",
MySqlDbType.Int32, 4, ParameterDirection.Output,
false, 0, 0, string.Empty, DataRowVersion.Default, null);
iData[4] = new MySqlParameter("p_Worse",
MySqlDbType.Int32, 4, ParameterDirection.Output,
false, 0, 0, string.Empty, DataRowVersion.Default, null);
iData[5] = new MySqlParameter("p_equal",
MySqlDbType.Int32, 4, ParameterDirection.Output,
false, 0, 0, string.Empty, DataRowVersion.Default, null);
iData = MySqlHelpers.RunProcedureInOut(storedProcName, iData);
nums[0] = iData[3].Value.ToString();
nums[1] = iData[4].Value.ToString();
nums[2] = iData[5].Value.ToString();
}
catch (Exception ex)
{
FileLog.WriteLog(ex.ToString());
}
return(nums);
}
