Oracle simple data connection Encapsulation

Public class OraDatabase
{
Private OracleConnection OraConn;
 
Private void Open ()
{
If (OraConn = null)
{
OraConn = new OracleConnection (ConnectionInf. GetSFISConString ());
}
If (OraConn. State = System. Data. ConnectionState. Closed)
OraConn. Open ();
}
 
Private void Close ()
{
If (OraConn! = Null)
OraConn. Close ();
}
 
Private void Dispose ()
{
If (OraConn! = Null)
{
OraConn. Dispose ();
OraConn = null;
}
}
 
 
Public OracleCommand mongomd (string ProcName, OracleParameter [] parms)
{
Open ();
 
OracleCommand cmd = new OracleCommand (ProcName, OraConn );
Cmd. CommandType = CommandType. StoredProcedure;
 
If (parms! = Null)
{
Foreach (OracleParameter parameter in parms)
Cmd. Parameters. Add (parameter );
}

Return cmd;
}
 
Public void RunProcedure (string ProcName)
{
OracleCommand cmd = cmdmd (ProcName, null );
Cmd. ExecuteNonQuery ();
This. Close ();
}
// Call the ORACLE function and return the value
Public string RunProcedure (string ProcName, OracleParameter [] parms)
{
String x = "";
OracleCommand cmd = cmdmd (ProcName, parms );
// Add oracle response parameters
OracleParameter p = new OracleParameter ("result", OracleType. Int32, 4 );
P. Direction = System. Data. ParameterDirection. ReturnValue;
Cmd. Parameters. Add (p );
 
Cmd. ExecuteNonQuery ();
This. Close ();
X = cmd. Parameters ["result"]. Value. ToString ();
Return x;
// Return cmd. Parameters ["result"]. Value. ToString ();
// Result is the automatic return value variable of the ORACLE function, similar to the returnvalue in SQL SERVER.

}

 
Public DataTable DT_Proc (string ProcName, OracleParameter [] parms)
{
OracleCommand cmd = cmdmd (ProcName, parms );

DataTable dt = null;
DataSet ds = new DataSet ();
OracleDataAdapter da = new OracleDataAdapter (cmd );
Da. Fill (ds );

Dt = ds. Tables [0];
Close ();
Return dt;
}
 
Public OracleParameter MakeInParam (string ParamName, OracleType DbType, object Value)
{
Return MakeParam (ParamName, DbType, ParameterDirection. Input, Value );
}
 
 
Public OracleParameter MakeOutParam (string ParamName, OracleType DbType)
{
Return MakeParam (ParamName, DbType, ParameterDirection. Output, null );
}
 
Public OracleParameter MakeParam (string ParamName, OracleType DbType, ParameterDirection Direction, object Value)
{
OracleParameter param;
 
// If (Size> 0)
// Param = new OracleParameter (ParamName, DbType, Size );
// Else
Param = new OracleParameter (ParamName, DbType );
 
Param. Direction = Direction;
If (! (Direction = ParameterDirection. Output & Value = null ))
Param. Value = Value;
 
Return param;
}
}
Public class OraDatabase
{
Private OracleConnection OraConn;
 
Private void Open ()
{
If (OraConn = null)
{
OraConn = new OracleConnection (ConnectionInf. GetSFISConString ());
}
If (OraConn. State = System. Data. ConnectionState. Closed)
OraConn. Open ();
}
 
Private void Close ()
{
If (OraConn! = Null)
OraConn. Close ();
}
 
Private void Dispose ()
{
If (OraConn! = Null)
{
OraConn. Dispose ();
OraConn = null;
}
}
 
 
Public OracleCommand mongomd (string ProcName, OracleParameter [] parms)
{
Open ();
 
OracleCommand cmd = new OracleCommand (ProcName, OraConn );
Cmd. CommandType = CommandType. StoredProcedure;
 
If (parms! = Null)
{
Foreach (OracleParameter parameter in parms)
Cmd. Parameters. Add (parameter );
}

Return cmd;
}
 
Public void RunProcedure (string ProcName)
{
OracleCommand cmd = cmdmd (ProcName, null );
Cmd. ExecuteNonQuery ();
This. Close ();
}
// Call the ORACLE function and return the value www.2cto.com
Public string RunProcedure (string ProcName, OracleParameter [] parms)
{
String x = "";
OracleCommand cmd = cmdmd (ProcName, parms );
// Add oracle response parameters
OracleParameter p = new OracleParameter ("result", OracleType. Int32, 4 );
P. Direction = System. Data. ParameterDirection. ReturnValue;
Cmd. Parameters. Add (p );
 
Cmd. ExecuteNonQuery ();
This. Close ();
X = cmd. Parameters ["result"]. Value. ToString ();
Return x;
// Return cmd. Parameters ["result"]. Value. ToString ();
// Result is the automatic return value variable of the ORACLE function, similar to the returnvalue in SQL SERVER.

}

 
Public DataTable DT_Proc (string ProcName, OracleParameter [] parms)
{
OracleCommand cmd = cmdmd (ProcName, parms );

DataTable dt = null;
DataSet ds = new DataSet ();
OracleDataAdapter da = new OracleDataAdapter (cmd );
Da. Fill (ds );

Dt = ds. Tables [0];
Close ();
Return dt;
}
 
Public OracleParameter MakeInParam (string ParamName, OracleType DbType, object Value)
{
Return MakeParam (ParamName, DbType, ParameterDirection. Input, Value );
}
 

Public OracleParameter MakeOutParam (string ParamName, OracleType DbType)
{
Return MakeParam (ParamName, DbType, ParameterDirection. Output, null );
}
 
Public OracleParameter MakeParam (string ParamName, OracleType DbType, ParameterDirection Direction, object Value)
{
OracleParameter param;
 
// If (Size> 0)
// Param = new OracleParameter (ParamName, DbType, Size );
// Else
Param = new OracleParameter (ParamName, DbType );
 
Param. Direction = Direction;
If (! (Direction = ParameterDirection. Output & Value = null ))
Param. Value = Value;
 
Return param;
}
}
 
 
From column liu_liu213