一.执行事务处理
private static string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["Conn"].ToString();
private static OracleConnection conn = new OracleConnection(connStr);
public static bool ExecuteTransactionBySqls(string[] sqlArray)
{
bool isSuccess = false;
try
{
conn.Open();
OracleTransaction transaction = conn.BeginTransaction();
foreach (var itemSql in sqlArray)
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = conn;
cmd.CommandText = itemSql;
cmd.Transaction = transaction;
cmd.ExecuteNonQuery();
}
}
transaction.Commit();
conn.Close();
isSuccess = true;
}
catch
{
conn.Close();
}
return isSuccess;
}