/// <summary>
/// SQL事物执行（增/改/删）相关操作
/// </summary>
/// <param name="transaction">SQL事物对象</param>
/// <param name="dbHelper">数据库引擎</param>
/// <param name="commandText">执行的SQL语句</param>
/// <param name="commandParameters">携带的参数可以是Null</param>
/// <returns></returns>
public static DbTransResult ExecuteNonQuery(this DbTransaction transaction, DbHelper dbHelper, string commandText, params DbParameter[] commandParameters)
{
if (string.IsNullOrWhiteSpace(commandText))
{
throw new ArgumentException("执行SQL为空！", nameof(commandText));
}
return(transaction.ExecuteNonQuery(dbHelper, new SqlTextParameter(commandText, commandParameters)));
}
public int MergePerson(DbTransaction transaction, PersonRowData oldPerson, Person newPerson)
{
return
(transaction.ExecuteNonQuery(
tables.Join(";\n\n\n", t => t.UpdateSql)
+ ";\n\n\nUPDATE Data.MasterDirectory SET StripeId = @oldStripeId WHERE Id = @newId AND StripeId IS NULL"
+ ";\n\n\nDELETE FROM Data.MasterDirectory WHERE Id = @oldId", new { oldId = oldPerson.Person.Id, newId = newPerson.Id, oldStripeId = oldPerson.StripeId }));
}
///<summary>Executes a SQL statement against a connection.</summary>
///<param name="transaction">The transaction to the database. The connection is not closed.</param>
///<param name="sql">The SQL to execute.</param>
///<returns>The number of rows affected by the statement.</returns>
public static int ExecuteNonQuery(this DbTransaction transaction, string sql)
{
return(transaction.ExecuteNonQuery <object>(sql, null));
}
/// <summary>
/// SQL事物执行（增/改/删）相关操作
/// </summary>
/// <param name="transaction">SQL事物对象</param>
/// <param name="dbHelper">数据库引擎</param>
/// <param name="commandText">执行的SQL语句</param>
/// <param name="parameters">携带的参数可以是Null，虚构参数</param>
/// <returns></returns>
public static DbTransResult ExecuteNonQuery(this DbTransaction transaction, DbHelper dbHelper, string commandText, object parameters)
{
return(transaction.ExecuteNonQuery(dbHelper, commandText, dbHelper.SetParameters(parameters)));
}
public int DeletePerson(DbTransaction transaction, Person person)
{
return(transaction.ExecuteNonQuery(tables.Join(";\n", t => t.DeleteSql) + ";\n\nDELETE FROM Data.MasterDirectory WHERE Id = @Id", new { person.Id }));
}