asp.net oracle 存储过程 out,asp.net 调用ORACLE存储过程方法

///

/// 创建 OracleCommand 对象实例(用来返回一个整数值)

///

/// 存储过程名

/// 存储过程参数

/// OracleCommand 对象实例

private static OracleCommand BuildIntCommand(OracleConnection connection, string storedProcName, OracleParameter[] parameters)

{

OracleCommand command = BuildQueryCommand(connection, storedProcName, parameters);

command.Parameters.Add(new OracleParameter("ReturnValue",

OracleType.Int32, 4, ParameterDirection.ReturnValue,

false, 0, 0, string.Empty, DataRowVersion.Default, null));

return command;

}

///

/// 构建 OracleCommand 对象(用来返回一个结果集，而不是一个整数值)

///

/// 数据库连接

/// 存储过程名

/// 存储过程参数

/// OracleCommand

private static OracleCommand BuildQueryCommand(OracleConnection connection, string storedProcName, OracleParameter[] parameters)

{

OracleCommand command = new OracleCommand(storedProcName, connection);

command.CommandType = CommandType.StoredProcedure;

if (parameters != null)

{

foreach (OracleParameter parameter in parameters)

{

if (parameter.OracleType == OracleType.DateTime)

{

if (parameter.Value != System.DBNull.Value && (DateTime)parameter.Value == DateTime.MinValue)

parameter.Value = System.DBNull.Value;

}

command.Parameters.Add(parameter);

}

}

return command;

}

///

/// 执行存储过程

///

/// 存储过程名

/// 存储过程参数

/// OracleDataReader

public static OracleDataReader RunProcedure(string connectionString, string storedProcName, OracleParameter[] parameters)

{

OracleConnection connection = new OracleConnection(connectionString);

OracleDataReader returnReader;

connection.Open();

OracleCommand command = BuildQueryCommand(connection, storedProcName, parameters);

command.CommandType = CommandType.StoredProcedure;

returnReader = command.ExecuteReader();

return returnReader;

}

调用：

//prm.Direction = ParameterDirection.Input;        OracleParameter[] parameters = {     new OracleParameter("zBeginDate", OracleType.VarChar,50),     new OracleParameter("zEndDate", OracleType.VarChar,50),     new OracleParameter("Suppliers", OracleType.VarChar,100),                    new OracleParameter("Userid", OracleType.VarChar,20),                    new OracleParameter("Maxids", OracleType.VarChar,20)};        if (Text_BeginDate.Text != String.Empty)        {            parameters[0].Value =Text_BeginDate.Text;        }        if (Text_EndDate.Text != String.Empty)        {            parameters[1].Value = Text_EndDate.Text;         }        if (stritem != null)        {            parameters[2].Value = stritem.ToString();        }        //存储过程返回的参数        parameters[4].Direction = ParameterDirection.Output;                user=(XT_TC_USER)Session["USER_MODEL"];        parameters[3].Value = user.StafferCode;        DbHelperSQL.ExcProcedure(DbHelperSQL.LocalSqlServer, "CONLLIGATE_MAIN", parameters);        //接受返回参数        string Maxids = parameters[4].Value.ToString();