c# 调用存储过程

1.调���返回OUT的存储过程

a.调用OUT字符串的存储过程；

      #region 连接数据库      ///       /// 连接数据库      ///       ///       ///       ///       public OracleConnection OpenConn(ref string connStatus, DBConnEntity dbNode)      {          try          {              if (conn == null || conn.State == ConnectionState.Closed)              {                  //默认端口                  if (dbNode.Port.Length  
b.调用OUT 数值的存储过程；
（） 
 public int execZLProcedure(string proceName, DBConnEntity dbNode,string model_name, ref string strNGPASS)        {            int batch_Id = 0;            try            {                conn = OpenConn(ref strNGPASS, dbNode);//连接数据库；                if (strNGPASS == "success")                {                    using (conn)                    {                        using (OracleCommand cmd = new OracleCommand(proceName, conn))  //proceName存储过程名称                        {                            cmd.CommandType = CommandType.StoredProcedure;                            OracleParameter modelName = new OracleParameter("modelName", OracleDbType.Varchar2);                            modelName.Direction = ParameterDirection.Input;                            modelName.Value = model_name;                            cmd.Parameters.Add(modelName);                            OracleParameter batchId = new OracleParameter("batchId", OracleDbType.Int64);//                            batchId.Direction = ParameterDirection.Output;                            cmd.Parameters.Add(batchId);                            cmd.ExecuteNonQuery();                            batch_Id = int.Parse(batchId.Value.ToString());                            strNGPASS = "OK";                        }                    }                }                else    //连接数据库异常                {                    strNGPASS = "NG";                }            }            catch (Exception ex)            {                strNGPASS = "NG";            }            return batch_Id;        }