public DataSet CreateDataSet(string query)
{
DbCommand sqlcom = null;
DbConnection myConn = null;
IFactoryDbPool pool = OracleConnectionSingletion.CreateInstance();
try
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["OracleConnectionString"];
OracleConnectionSingletion.ConnectionString = settings.ConnectionString;
//Borrow the SqlConnection object from the pool
myConn = pool.BorrowDBConnection();
sqlcom = new OracleCommand(query, (OracleConnection)myConn);
DataSet ds = new DataSet();
OracleDataAdapter oda = new OracleDataAdapter();
oda.SelectCommand = (OracleCommand)sqlcom;
oda.Fill(ds);
return(ds);
}
catch (Exception)
{
if (sqlcom != null)
{
sqlcom.Dispose();
}
return(null);
}
finally
{
pool.ReturnDBConnection(myConn);
}
}
public string UpDate(string query)
{
DbCommand sqlcom = null;
DbConnection myConn = null;
IFactoryDbPool pool = OracleConnectionSingletion.CreateInstance();
try
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["OracleConnectionString"];
OracleConnectionSingletion.ConnectionString = settings.ConnectionString;
//Borrow the SqlConnection object from the pool
myConn = pool.BorrowDBConnection();
sqlcom = new OracleCommand(query, (OracleConnection)myConn);
sqlcom.ExecuteNonQuery();
return("Success");
}
catch (Exception ee)
{
if (sqlcom != null)
{
sqlcom.Dispose();
}
return(ee.Message);
}
finally
{
pool.ReturnDBConnection(myConn);
}
}
public static OracleConnectionSingletion CreateInstance()
{
if (instance == null)
{
lock (locker)
{
if (instance == null)
{
instance = new OracleConnectionSingletion();
}
}
}
return(instance);
}
public string ExecProcedures(string procedure, string[] seg, object[] value, string result)
{
DbCommand sqlcom = null;
DbConnection myConn = null;
IFactoryDbPool pool = OracleConnectionSingletion.CreateInstance();
try
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["OracleConnectionString"];
OracleConnectionSingletion.ConnectionString = settings.ConnectionString;
//Borrow the SqlConnection object from the pool
myConn = pool.BorrowDBConnection();
sqlcom = myConn.CreateCommand();;
sqlcom.CommandType = CommandType.StoredProcedure;
sqlcom.CommandText = procedure;
if (seg.Length == value.Length)
{
for (int i = 0; i < seg.Length; i++)
{
OracleParameter p = new OracleParameter(seg[i], value[i]);
p.Direction = ParameterDirection.Input;
sqlcom.Parameters.Add(p);
}
}
sqlcom.Parameters.Add(new OracleParameter("result",
OracleType.VarChar, 3000));
sqlcom.Parameters["result"].Direction = ParameterDirection.Output;
sqlcom.ExecuteNonQuery();
return(sqlcom.Parameters["result"].Value.ToString());
}
catch (Exception)
{
if (sqlcom != null)
{
sqlcom.Dispose();
}
return(null);
}
finally
{
pool.ReturnDBConnection(myConn);
}
}
public string TransactionCommand(List <String> commandStringList)
{
IFactoryDbPool pool = OracleConnectionSingletion.CreateInstance();
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["OracleConnectionString"];
OracleConnectionSingletion.ConnectionString = settings.ConnectionString;
//Borrow the SqlConnection object from the pool
DbConnection myConn = pool.BorrowDBConnection();
OracleTransaction m_OraTrans = ((OracleConnection)myConn).BeginTransaction();//创建事务对象
DbCommand sqlcom = new OracleCommand();
sqlcom.Connection = myConn;
sqlcom.Transaction = m_OraTrans;
int influenceRowCount = 0;
try
{
foreach (string commandString in commandStringList)
{
sqlcom.CommandText = commandString;
influenceRowCount += sqlcom.ExecuteNonQuery();
}
m_OraTrans.Commit();
return("Success");
}
catch (Exception ee)
{
m_OraTrans.Rollback();
return(ee.Message);
}
finally
{
sqlcom.Dispose();
pool.ReturnDBConnection(myConn);
}
}
