/// <summary>
/// 执行数据库包体操作，返回结果
/// </summary>
/// <param name="cmdText">包体函数或存储过程</param>
/// <param name="commandParameters">参数集合</param>
/// <returns></returns>
public static int ExecuteNonQuery_package(string cmdText,string canshu)
{
int result;
OracleConnection conn = new OracleConnection(connstr);
OracleCommand cmd = conn.CreateCommand();
try
{
OracleParameter[] parameters = {
new OracleParameter("返回参数",OracleDbType.Int32,,ParameterDirection.ReturnValue,true,,,"",DataRowVersion.Default,Convert.DBNull),
new OracleParameter("参数名与数据库一致",OracleDbType.Varchar2,)
};
parameters[].Value = canshu;
cmd.CommandText = cmdText;
cmd.CommandType = CommandType.StoredProcedure;
foreach (OracleParameter param in parameters) cmd.Parameters.Add(param);
conn.Open();
cmd.ExecuteNonQuery();
var aaa = parameters[].Value.ToString();
result= Convert.ToInt32(aaa);
}
catch (Exception)
{ throw;
}
finally
{
cmd.Dispose();
conn.Close();
conn.Dispose();
}
return result;
}