/// <summary>
/// ExecuteCommandNonQueryAsync
/// </summary>
/// <param name="Transaction"></param>
/// <param name="dbName"></param>
/// <param name="dbCommand"></param>
/// <returns></returns>
/// <exception cref="DatabaseException"></exception>
public Task <int> ExecuteCommandNonQueryAsync(IDbTransaction?Transaction, string dbName, IDbCommand dbCommand)
{
if (Transaction == null)
{
return(MySQLExecuter.ExecuteCommandNonQueryAsync(GetConnectionString(dbName, true), dbCommand));
}
else
{
return(MySQLExecuter.ExecuteCommandNonQueryAsync((MySqlTransaction)Transaction, dbCommand));
}
}
/// <summary>
/// ExecuteCommandScalarAsync
/// </summary>
/// <param name="Transaction"></param>
/// <param name="dbName"></param>
/// <param name="dbCommand"></param>
/// <param name="useMaster"></param>
/// <returns></returns>
/// <exception cref="DatabaseException"></exception>
public Task <object> ExecuteCommandScalarAsync(IDbTransaction?Transaction, string dbName, IDbCommand dbCommand, bool useMaster = false)
{
if (Transaction == null)
{
return(MySQLExecuter.ExecuteCommandScalarAsync(GetConnectionString(dbName, useMaster), dbCommand));
}
else
{
return(MySQLExecuter.ExecuteCommandScalarAsync((MySqlTransaction)Transaction, dbCommand));
}
}
/// <summary>
/// ExecuteSPScalarAsync
/// </summary>
/// <param name="Transaction"></param>
/// <param name="dbName"></param>
/// <param name="spName"></param>
/// <param name="parameters"></param>
/// <param name="useMaster"></param>
/// <returns></returns>
/// <exception cref="DatabaseException"></exception>
public Task <object> ExecuteSPScalarAsync(IDbTransaction?Transaction, string dbName, string spName, IList <IDataParameter> parameters, bool useMaster = false)
{
if (Transaction == null)
{
return(MySQLExecuter.ExecuteSPScalarAsync(GetConnectionString(dbName, useMaster), spName, parameters));
}
else
{
return(MySQLExecuter.ExecuteSPScalarAsync((MySqlTransaction)Transaction, spName, parameters));
}
}
/// <summary>
/// ExecuteSPNonQueryAsync
/// </summary>
/// <param name="Transaction"></param>
/// <param name="dbName"></param>
/// <param name="spName"></param>
/// <param name="parameters"></param>
/// <returns></returns>
/// <exception cref="DatabaseException"></exception>
public Task <int> ExecuteSPNonQueryAsync(IDbTransaction?Transaction, string dbName, string spName, IList <IDataParameter> parameters)
{
if (Transaction == null)
{
return(MySQLExecuter.ExecuteSPNonQueryAsync(GetConnectionString(dbName, true), spName, parameters));
}
else
{
return(MySQLExecuter.ExecuteSPNonQueryAsync((MySqlTransaction)Transaction, spName, parameters));
}
}
/// <summary>
/// 使用完毕后必须Dispose
/// </summary>
/// <param name="Transaction"></param>
/// <param name="spName"></param>
/// <param name="dbParameters"></param>
/// <returns></returns>
public IDataReader ExecuteSPReader(IDbTransaction Transaction, string dbName, string spName, IList <IDataParameter> dbParameters, bool useMaster)
{
if (Transaction == null)
{
return(MySQLExecuter.ExecuteSPReader(GetConnectionString(dbName, useMaster), spName, dbParameters));
}
else
{
return(MySQLExecuter.ExecuteSPReader((MySqlTransaction)Transaction, spName, dbParameters));
}
}
/// <summary>
/// ExecuteSPReaderAsync
/// </summary>
/// <param name="Transaction"></param>
/// <param name="dbName"></param>
/// <param name="spName"></param>
/// <param name="dbParameters"></param>
/// <param name="useMaster"></param>
/// <returns></returns>
/// <exception cref="DatabaseException"></exception>
public Task <Tuple <IDbCommand, IDataReader> > ExecuteSPReaderAsync(IDbTransaction?Transaction, string dbName, string spName, IList <IDataParameter> dbParameters, bool useMaster = false)
{
if (Transaction == null)
{
return(MySQLExecuter.ExecuteSPReaderAsync(GetConnectionString(dbName, useMaster), spName, dbParameters));
}
else
{
return(MySQLExecuter.ExecuteSPReaderAsync((MySqlTransaction)Transaction, spName, dbParameters));
}
}
public object ExecuteSqlScalar(IDbTransaction Transaction, string dbName, string SQL, bool useMaster)
{
if (Transaction == null)
{
return(MySQLExecuter.ExecuteSqlScalar(GetConnectionString(dbName, useMaster), SQL));
}
else
{
return(MySQLExecuter.ExecuteSqlScalar((MySqlTransaction)Transaction, SQL));
}
}
public int ExecuteSqlNonQuery(IDbTransaction Transaction, string dbName, string SQL)
{
if (Transaction == null)
{
return(MySQLExecuter.ExecuteSqlNonQuery(GetConnectionString(dbName, true), SQL));
}
else
{
return(MySQLExecuter.ExecuteSqlNonQuery((MySqlTransaction)Transaction, SQL));
}
}
public object ExecuteCommandScalar(IDbTransaction Transaction, string dbName, IDbCommand dbCommand, bool useMaster)
{
if (Transaction == null)
{
return(MySQLExecuter.ExecuteCommandScalar(GetConnectionString(dbName, useMaster), dbCommand));
}
else
{
return(MySQLExecuter.ExecuteCommandScalar((MySqlTransaction)Transaction, dbCommand));
}
}
/// <summary>
/// ExecuteCommandScalarAsync
/// </summary>
/// <param name="Transaction"></param>
/// <param name="dbName"></param>
/// <param name="engineCommand"></param>
/// <param name="useMaster"></param>
/// <returns></returns>
/// <exception cref="DatabaseException"></exception>
public async Task <object?> ExecuteCommandScalarAsync(IDbTransaction?Transaction, string dbName, EngineCommand engineCommand, bool useMaster = false)
{
using MySqlCommand command = CreateTextCommand(engineCommand);
if (Transaction == null)
{
return(await MySQLExecuter.ExecuteCommandScalarAsync(GetConnectionString(dbName, useMaster), command).ConfigureAwait(false));
}
else
{
return(await MySQLExecuter.ExecuteCommandScalarAsync((MySqlTransaction)Transaction, command).ConfigureAwait(false));
}
}
/// <summary>
/// ExecuteCommandNonQueryAsync
/// </summary>
/// <param name="Transaction"></param>
/// <param name="dbName"></param>
/// <param name="engineCommand"></param>
/// <returns></returns>
/// <exception cref="DatabaseException"></exception>
public async Task <int> ExecuteCommandNonQueryAsync(IDbTransaction?Transaction, string dbName, EngineCommand engineCommand)
{
using MySqlCommand command = CreateTextCommand(engineCommand);
if (Transaction == null)
{
return(await MySQLExecuter.ExecuteCommandNonQueryAsync(GetConnectionString(dbName, true), command).ConfigureAwait(false));
}
else
{
return(await MySQLExecuter.ExecuteCommandNonQueryAsync((MySqlTransaction)Transaction, command).ConfigureAwait(false));
}
}