public int ExecuteCommands()
{
DatabaseReturn return2 = this.dbes.Execute(this._iDbCommandList);
if (return2.ReturnException != null)
{
throw new DBException(return2.ErrorSQL, return2.ReturnException);
}
return(return2.EffectRowCount);
}
public string IsExecuteVaild(string sql)
{
DatabaseReturn return2 = this.dbes.Execute(sql);
if (return2.ReturnException == null)
{
return(null);
}
return(return2.ReturnException.Message.Replace("沒有資料被影響異動。", "").Replace("没有数据被影响异动。", "").Replace("No data is affecting changes.", ""));
}
public int Execute(string sql, List <IDbDataParameter> parameters, bool showErrorSQL)
{
DatabaseReturn return2 = this.dbes.Execute(sql, parameters);
if (return2.ReturnException != null)
{
throw new Exception(this.GetAllInnerExceptionString(return2.ErrorSQL, return2.ReturnException));
}
return(return2.EffectRowCount);
}
public int ExecuteCommandAtOnce(List <IDbCommand> commands)
{
DatabaseReturn return2 = this.dbes.ExecuteCommandAtOnce(commands);
if (return2.ReturnException != null)
{
throw new Exception(this.GetAllInnerExceptionString(return2.ErrorSQL, return2.ReturnException));
}
return(return2.EffectRowCount);
}
public int DoTransaction(List <IDbCommand> commands, IDbTransaction transaction)
{
DatabaseReturn return2 = this.dbes.Execute(commands, transaction);
if (return2.ReturnException != null)
{
throw new Exception(this.GetAllInnerExceptionString(return2.ErrorSQL, return2.ReturnException));
}
return(return2.EffectRowCount);
}
public int DoTransaction(string[] sqls)
{
DatabaseReturn return2 = this.dbes.Execute(sqls);
if (return2.ReturnException != null)
{
throw new Exception(this.GetAllInnerExceptionString(return2.ErrorSQL, return2.ReturnException));
}
return(return2.EffectRowCount);
}
public DatabaseReturn Execute(List <IDbCommand> commandList)
{
this.errorSQL = "";
this.count = 0;
if ((this.connString == null) || (this.conn == null))
{
throw new Exception(Message.NoConnection);
}
DatabaseReturn return2 = new DatabaseReturn();
IDbTransaction transaction = this.conn.BeginTransaction();
if ((commandList != null) && (commandList.Count != 0))
{
try
{
foreach (IDbCommand command in commandList)
{
if ((command != null) && !(command.CommandText == ""))
{
this.errorSQL = command.CommandText;
command.Connection = this.conn;
command.Transaction = transaction;
this.count = command.ExecuteNonQuery();
if (this.count <= 0)
{
throw new Exception(Message.NoRowEffected);
}
return2.EffectRowCount += this.count;
}
}
this.errorSQL = "";
transaction.Commit();
return2.ReturnException = null;
}
catch (Exception exception)
{
transaction.Rollback();
return2.EffectRowCount = 0;
return2.ReturnException = exception;
return2.ErrorSQL = this.errorSQL;
}
}
return(return2);
}
public DatabaseReturn Execute(string sql, List <IDbDataParameter> parameterList)
{
this.errorSQL = "";
if ((this.connString == null) || (this.conn == null))
{
throw new Exception(Message.NoConnection);
}
DatabaseReturn return2 = new DatabaseReturn();
IDbCommand command = this.conn.CreateCommand();
command.CommandText = sql;
try
{
command.Parameters.Clear();
if ((parameterList != null) && (parameterList.Count != 0))
{
foreach (IDbDataParameter parameter in parameterList)
{
command.Parameters.Add(parameter);
}
}
return2.EffectRowCount = command.ExecuteNonQuery();
if (return2.EffectRowCount <= 0)
{
throw new Exception(Message.NoRowEffected);
}
return2.ReturnException = null;
}
catch (Exception exception)
{
this.errorSQL = command.CommandText;
return2.EffectRowCount = 0;
return2.ReturnException = exception;
return2.ErrorSQL = this.errorSQL;
}
finally
{
command.Dispose();
command = null;
}
return(return2);
}
public DatabaseReturn Execute(string[] sqls)
{
this.errorSQL = "";
this.count = 0;
if ((this.connString == null) || (this.conn == null))
{
throw new Exception(Message.NoConnection);
}
DatabaseReturn return2 = new DatabaseReturn();
IDbTransaction transaction = this.conn.BeginTransaction();
IDbCommand command = this.conn.CreateCommand();
command.Transaction = transaction;
try
{
foreach (string str in sqls)
{
if (str.Trim() != "")
{
this.errorSQL = str;
command.CommandText = str;
this.count = command.ExecuteNonQuery();
if (this.count <= 0)
{
throw new Exception(Message.NoRowEffected);
}
return2.EffectRowCount += this.count;
}
}
this.errorSQL = "";
transaction.Commit();
return2.ReturnException = null;
}
catch (Exception exception)
{
transaction.Rollback();
return2.EffectRowCount = 0;
return2.ReturnException = exception;
return2.ErrorSQL = this.errorSQL;
}
return(return2);
}
