/// <summary>
/// 获取Model集合（没有Where条件）
/// </summary>
/// <typeparam name="T"></typeparam>
/// <returns></returns>
public static async Task <IEnumerable <T> > GetAllAsync <T>() where T : class, new()
{
using (var conn = ConnFactory.GetConnection())
{
return(await conn.GetAllAsync <T>());
}
}
/// <summary>
/// 获取Model-Key为string类型
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="id"></param>
/// <param name="transaction"></param>
/// <param name="commandTimeout"></param>
/// <returns></returns>
public static async Task <T> GetAsync <T>(string id, IDbTransaction transaction = null, int?commandTimeout = null) where T : class, new()
{
using (var conn = ConnFactory.GetConnection())
{
return(await conn.GetAsync <T>(id, transaction, commandTimeout));
}
}
/// <summary>
/// 插入一个Model
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="model"></param>
/// <param name="transaction"></param>
/// <param name="commandTimeout"></param>
/// <param name="sqlAdapter"></param>
/// <returns></returns>
public static async Task <int> InsertAsync <T>(T model, IDbTransaction transaction = null, int?commandTimeout = null) where T : class, new()
{
using (var conn = ConnFactory.GetConnection())
{
return(await conn.InsertAsync <T>(model, transaction, commandTimeout));
}
}
/// <summary>
/// 增删改系
/// </summary>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <param name="transaction"></param>
/// <param name="commandTimeout"></param>
/// <param name="commandType"></param>
/// <returns></returns>
public static async Task <int> ExecuteAsync(string sql, object param = null, IDbTransaction transaction = null, int?commandTimeout = default(int?), CommandType?commandType = default(CommandType?))
{
using (var conn = ConnFactory.GetConnection())
{
await conn.OpenAsync();
return(await conn.ExecuteAsync(sql, param, transaction, commandTimeout, commandType));
}
}
/// <summary>
/// 更新一个Model
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="connection"></param>
/// <param name="entityToUpdate"></param>
/// <param name="transaction"></param>
/// <param name="commandTimeout"></param>
/// <returns></returns>
public static async Task <T> UpdateAsync <T>(T model, IDbTransaction transaction = null, int?commandTimeout = null) where T : class, new()
{
using (var conn = ConnFactory.GetConnection())
{
bool b = await conn.UpdateAsync <T>(model, transaction, commandTimeout);
if (b)
{
return(model);
}
else
{
return(null);
}
}
}