/// <summary>
/// 提供通用的调用存储过程的方法(通过参数查询数据)
/// </summary>
/// <param name="procedureName">存储过程名称</param>
/// <param name="sqlParameters">存储过程参数数组</param>
/// <param name="dt">返回表</param>
/// <returns></returns>
public static bool ExecuteStoredProcedure(string procedureName, ref SqlParameter[] sqlParameters, out DataTable dt, out string errorMessage)
{
return(SQLCommon.ExecuteStoredProcedure(procedureName, ApplicationConfig.connectionString, ref sqlParameters, out dt, out errorMessage));
}
/// <summary>
/// 通过存储过程查询数据
/// </summary>
/// <param name="procedureName">存储过程名称</param>
/// <param name="dt">返回表</param>
/// <returns></returns>
public static bool ExecuteStoredProcedure(string procedureName, out DataTable dt)
{
string errMessage;
return(SQLCommon.ExecuteStoredProcedure(procedureName, ApplicationConfig.connectionString, out dt, out errMessage));
}