public async Task <int> Update(T entity, string updateSql)
{
using (IDbConnection conn = DataBaseConfig.GetMySqlConnection())
{
return(await conn.ExecuteAsync(updateSql, entity));
}
}
public async Task <int> Insert(T entity, string insertSql)
{
using (IDbConnection conn = DataBaseConfig.GetMySqlConnection())
{
return(await conn.ExecuteAsync(insertSql, entity));
}
}
/// <summary>
/// 无参存储过程
/// </summary>
/// <param name="SPName"></param>
/// <returns></returns>
public async Task <List <T> > ExecQuerySP(string SPName)
{
using (IDbConnection conn = DataBaseConfig.GetMySqlConnection())
{
return(await Task.Run(() => conn.Query <T>(SPName, null, null, true, null, CommandType.StoredProcedure).ToList()));
}
}
public async Task <int> Delete(int PKID, string deleteSql)
{
using (IDbConnection conn = DataBaseConfig.GetMySqlConnection())
{
return(await conn.ExecuteAsync(deleteSql, new { PKID }));
}
}
public async Task <List <T> > Select(string selectSql)
{
using (IDbConnection conn = DataBaseConfig.GetMySqlConnection())
{
//string selectSql = @"SELECT Id, UserName, Password, Gender, Birthday, CreateDate, IsDelete FROM dbo.Users";
return(await Task.Run(() => conn.Query <T>(selectSql).ToList()));
}
}
public async Task <T> Detail(int PKID, string detailSql)
{
using (IDbConnection conn = DataBaseConfig.GetMySqlConnection())
{
//string querySql = @"SELECT Id, UserName, Password, Gender, Birthday, CreateDate, IsDelete FROM dbo.Users WHERE Id=@Id";
return(await conn.QueryFirstOrDefaultAsync <T>(detailSql, new { PKID }));
}
}
