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; }

|