///
/// 执行一个存贮过程，返回第一行的第一列
///
/// 连接字符串
/// 存贮过程名
/// parameterValues
/// 返回第一行的第一列
public static object ExecuteScalar(string connectionString, string spName, params object[] parameterValues)
{
if ((parameterValues != null) && (parameterValues.Length > 0))
{
OdbcParameter[] commandParameters = OdbcHelperParameterCache.GetSpParameterSet(connectionString, spName);
AssignParameterValues(commandParameters, parameterValues);
return(ExecuteScalar(connectionString, CommandType.StoredProcedure, spName, commandParameters));
}
else
{
return(ExecuteScalar(connectionString, CommandType.StoredProcedure, spName));
}
}
///
/// 执行一个存贮过程，返回OdbcDataReader
///
/// OdbcTransaction
/// 存贮过程名
/// parameterValues
/// 返回OdbcDataReader
public static OdbcDataReader ExecuteReader(OdbcTransaction transaction, string spName, params object[] parameterValues)
{
if ((parameterValues != null) && (parameterValues.Length > 0))
{
OdbcParameter[] commandParameters = OdbcHelperParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName);
AssignParameterValues(commandParameters, parameterValues);
return(ExecuteReader(transaction, CommandType.StoredProcedure, spName, commandParameters));
}
else
{
return(ExecuteReader(transaction, CommandType.StoredProcedure, spName));
}
}
