/// <summary>
/// 新增返回主键
/// </summary>
/// <typeparam name="TParamter"></typeparam>
/// <param name="conn"></param>
/// <param name="sql"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public async Task <long> ExecuteNonQueryByKey <TParamter>(DbConnection conn, string sql, TParamter parameters, DbTransaction tran = null) where TParamter : class
{
long IdentityId = 0;
await CommonExecute(conn, sql, async (ClientDbCommand) => {
IdentityId = Convert.ToInt64(await ClientDbCommand.ExecuteScalarAsync());
}, parameters, tran);
return(IdentityId);
}
/// <summary>
/// 新增返回主键
/// </summary>
/// <param name="conn"></param>
/// <param name="sql"></param>
/// <returns></returns>
public async Task <long> ExecuteNonQueryByKey(DbConnection conn, string sql, DbTransaction tran = null)
{
long IdentityId = 0;
await CommonExecute(conn, sql, async (ClientDbCommand) => {
IdentityId = Convert.ToInt64(await ClientDbCommand.ExecuteScalarAsync());
}, tran);
return(IdentityId);
}
/// <summary>
/// 返回受影响行数
/// </summary>
/// <param name="conn"></param>
/// <param name="sql"></param>
/// <returns></returns>
public async Task <int> ExecuteNonQuery(DbConnection conn, string sql, DbTransaction tran = null)
{
int Rows = 0;
await CommonExecute <object>(conn, sql, async (ClientDbCommand) => {
Rows = await ClientDbCommand.ExecuteNonQueryAsync();
}, null, tran);
return(Rows);
}
/// <summary>
/// 返回受影响行数
/// </summary>
/// <typeparam name="TParamter"></typeparam>
/// <param name="conn"></param>
/// <param name="sql"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public async Task <int> ExecuteNonQuery <TParamter>(DbConnection conn, string sql, TParamter parameters, DbTransaction tran = null)
where TParamter : class
{
int Rows = 0;
await CommonExecute(conn, sql, async (ClientDbCommand) => {
Rows = await ClientDbCommand.ExecuteNonQueryAsync();
}, parameters, tran);
return(Rows);
}
/// <summary>
/// 新增返回主键
/// </summary>
/// <typeparam name="TParamter"></typeparam>
/// <param name="conn"></param>
/// <param name="sql"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public async Task <long> ExecuteNonQueryByKey <TParamter>(DbConnection conn, string sql, TParamter parameters, DbTransaction tran = null) where TParamter : class
{
long IdentityId = 0;
await CommonExecute(conn, sql, async (ClientDbCommand) => {
await ClientDbCommand.ExecuteNonQueryAsync();
IdentityId = ClientDbCommand.LastInsertedId;
}, parameters, tran);
return(IdentityId);
}
/// <summary>
/// 新增返回主键
/// </summary>
/// <param name="conn"></param>
/// <param name="sql"></param>
/// <returns></returns>
public async Task <long> ExecuteNonQueryByKey(DbConnection conn, string sql, DbTransaction tran = null)
{
long IdentityId = 0;
await CommonExecute(conn, sql, async (ClientDbCommand) => {
await ClientDbCommand.ExecuteNonQueryAsync();
IdentityId = ClientDbCommand.LastInsertedId;
}, tran);
return(IdentityId);
}
