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