编程语言

img web_gus

用到的几个调用存储过程例子

发表于2004/10/18 9:10:00  903人阅读

分类: little case

   OmTransactionManager.SetConnectionAndTransaction(myCMD);
   myCMD.CommandText  ="{call curspkg_join.open_join_cursor1(?, {resultset 0, io_cursor})}";
   myCMD.Parameters.Add("ID", OleDbType.Numeric, 4).Value = 0;
   OleDbDataReader myReader;
   myReader = myCMD.ExecuteReader();
   int x;
   int i=0;

   while (myReader.Read())
    
   {
    for (x = 0; x <= myReader.FieldCount - 1; x++)
    {
     scEntity[i] =new GCEEDAT00SCIRAIEntity ();
     scEntity[i].MiseName =myReader.GetValue (x++).ToString ();
     scEntity[i].MiseCode =myReader.GetValue (x++).ToString ();
     scEntity[i].MinCount =myReader.GetValue (x++).ToString ();
     scEntity[i].Success =myReader.GetValue (x++).ToString ();

    }
    i++;
    
   }


   myReader.Close();


  public int EXECORASQL(GCEEDAT00CSData argCSData)
  {
   string constring="Data Source='SE';User ID='mhs';Password='mhs'";
   OracleConnection con=new OracleConnection (constring);
   con.Open ();
   oraexecsql=new OracleCommand ("COUNT_CUSTOM",con);
   oraexecsql.CommandType =CommandType.StoredProcedure;
   oraexecsql.Parameters .Add("reccount",OracleType.Int16);
   oraexecsql.Parameters ["reccount"].Direction =ParameterDirection.Output ;
   oraexecsql.ExecuteNonQuery();
   int result=Convert.ToInt32 (oraexecsql.Parameters ["reccount"].Value.ToString ());
   con.Close ();
   return result;
  }

阅读全文
0 0

相关文章推荐

img
取 消
img