/// <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); }