public static System.Data.DataSet Query(string connectionString, string SQLString, params OracleParameter[] cmdParms)
{
System.Data.DataSet result;
using (OracleConnection oracleConnection = new OracleConnection(connectionString))
{
OracleCommand oracleCommand = new OracleCommand();
OracleHelper.PrepareCommand(oracleCommand, oracleConnection, null, SQLString, cmdParms);
using (OracleDataAdapter oracleDataAdapter = new OracleDataAdapter(oracleCommand))
{
System.Data.DataSet dataSet = new System.Data.DataSet();
try
{
oracleDataAdapter.Fill(dataSet, "ds");
oracleCommand.Parameters.Clear();
}
catch (OracleException ex)
{
throw new Exception(ex.Message);
}
finally
{
if (oracleConnection.State != System.Data.ConnectionState.Closed)
{
oracleConnection.Close();
}
}
result = dataSet;
}
}
return(result);
}
public static object ExecuteScalar(OracleConnection connectionString, System.Data.CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)
{
OracleCommand oracleCommand = new OracleCommand();
OracleHelper.PrepareCommand(oracleCommand, connectionString, null, cmdType, cmdText, commandParameters);
object result = oracleCommand.ExecuteScalar();
oracleCommand.Parameters.Clear();
return(result);
}
public static int ExecuteNonQuery(OracleTransaction trans, System.Data.CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)
{
OracleCommand oracleCommand = new OracleCommand();
OracleHelper.PrepareCommand(oracleCommand, trans.Connection, trans, cmdType, cmdText, commandParameters);
int result = oracleCommand.ExecuteNonQuery();
oracleCommand.Parameters.Clear();
return(result);
}
public static int ExecuteNonQuery(string connectionString, string cmdText)
{
OracleCommand oracleCommand = new OracleCommand();
OracleConnection conn = new OracleConnection(connectionString);
OracleHelper.PrepareCommand(oracleCommand, conn, null, System.Data.CommandType.Text, cmdText, null);
int result = oracleCommand.ExecuteNonQuery();
oracleCommand.Parameters.Clear();
return(result);
}
public static int ExecuteNonQuery(string connectionString, System.Data.CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)
{
OracleCommand oracleCommand = new OracleCommand();
int result;
using (OracleConnection oracleConnection = new OracleConnection(connectionString))
{
OracleHelper.PrepareCommand(oracleCommand, oracleConnection, null, cmdType, cmdText, commandParameters);
int num = oracleCommand.ExecuteNonQuery();
oracleConnection.Close();
oracleCommand.Parameters.Clear();
result = num;
}
return(result);
}
public static object ExecuteScalar(OracleTransaction transaction, System.Data.CommandType commandType, string commandText, params OracleParameter[] commandParameters)
{
if (transaction == null)
{
throw new ArgumentNullException("transaction");
}
if (transaction != null && transaction.Connection == null)
{
throw new ArgumentException("The transaction was rollbacked\tor commited, please\tprovide\tan open\ttransaction.", "transaction");
}
OracleCommand oracleCommand = new OracleCommand();
OracleHelper.PrepareCommand(oracleCommand, transaction.Connection, transaction, commandType, commandText, commandParameters);
object result = oracleCommand.ExecuteScalar();
oracleCommand.Parameters.Clear();
return(result);
}
public static OracleDataReader ExecuteReader(string connectionString, System.Data.CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)
{
OracleCommand oracleCommand = new OracleCommand();
OracleConnection oracleConnection = new OracleConnection(connectionString);
OracleDataReader result;
try
{
OracleHelper.PrepareCommand(oracleCommand, oracleConnection, null, cmdType, cmdText, commandParameters);
OracleDataReader oracleDataReader = oracleCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
oracleCommand.Parameters.Clear();
result = oracleDataReader;
}
catch
{
oracleConnection.Close();
throw;
}
return(result);
}
public static bool ExecuteSqlTran(string conStr, List <CommandInfo> cmdList)
{
bool result;
using (OracleConnection oracleConnection = new OracleConnection(conStr))
{
oracleConnection.Open();
OracleCommand oracleCommand = new OracleCommand();
oracleCommand.Connection = oracleConnection;
OracleTransaction oracleTransaction = oracleConnection.BeginTransaction();
oracleCommand.Transaction = oracleTransaction;
try
{
foreach (CommandInfo current in cmdList)
{
if (!string.IsNullOrEmpty(current.CommandText))
{
OracleHelper.PrepareCommand(oracleCommand, oracleConnection, oracleTransaction, System.Data.CommandType.Text, current.CommandText, (OracleParameter[])current.Parameters);
if (current.EffentNextType == EffentNextType.WhenHaveContine || current.EffentNextType == EffentNextType.WhenNoHaveContine)
{
if (current.CommandText.ToLower().IndexOf("count(") == -1)
{
oracleTransaction.Rollback();
throw new Exception("Oracle:违背要求" + current.CommandText + "必须符合select count(..的格式");
}
object obj = oracleCommand.ExecuteScalar();
if (obj == null && obj == DBNull.Value)
{
}
bool flag = Convert.ToInt32(obj) > 0;
if (current.EffentNextType == EffentNextType.WhenHaveContine && !flag)
{
oracleTransaction.Rollback();
throw new Exception("Oracle:违背要求" + current.CommandText + "返回值必须大于0");
}
if (current.EffentNextType == EffentNextType.WhenNoHaveContine && flag)
{
oracleTransaction.Rollback();
throw new Exception("Oracle:违背要求" + current.CommandText + "返回值必须等于0");
}
}
else
{
int num = oracleCommand.ExecuteNonQuery();
if (current.EffentNextType == EffentNextType.ExcuteEffectRows && num == 0)
{
oracleTransaction.Rollback();
throw new Exception("Oracle:违背要求" + current.CommandText + "必须有影像行");
}
}
}
}
oracleTransaction.Commit();
result = true;
}
catch (OracleException ex)
{
oracleTransaction.Rollback();
throw ex;
}
finally
{
if (oracleConnection.State != System.Data.ConnectionState.Closed)
{
oracleConnection.Close();
}
}
}
return(result);
}