public async Task Update(T entity, string updateSql)
{
using (IDbConnection conn = SqlDBConfig.GetSqlConnection())
{
await conn.ExecuteAsync(updateSql, entity);
}
}
public async Task <List <T> > Select(string selectSql)
{
using (IDbConnection conn = SqlDBConfig.GetSqlConnection())
{
return(await Task.Run(() => conn.Query <T>(selectSql).ToList()));
}
}
public async Task Insert(T entity, string insertSql)
{
using (IDbConnection conn = SqlDBConfig.GetSqlConnection())
{
await conn.ExecuteAsync(insertSql, entity);
}
}
public async Task <List <T> > ExecQuerySP(string SPName)
{
using (IDbConnection conn = SqlDBConfig.GetSqlConnection())
{
return(await Task.Run(() => conn.Query <T>(SPName, null, null, true, null, CommandType.StoredProcedure).ToList()));
}
}
public async Task <T> Detail(int Id, string detailSql)
{
using (IDbConnection conn = SqlDBConfig.GetSqlConnection())
{
return(await conn.QueryFirstOrDefaultAsync <T>(detailSql, new { Id }));
}
}
public async Task Delete(int Id, string deleteSql)
{
using (IDbConnection conn = SqlDBConfig.GetSqlConnection())
{
await conn.ExecuteAsync(deleteSql, new { Id });
}
}
public string ExecExecQueryParamSP(string spName, string name, int Id)
{
using (IDbConnection conn = SqlDBConfig.GetSqlConnection())
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@UserName", name, DbType.String, ParameterDirection.Output, 100);
parameters.Add("@Id", Id, DbType.String, ParameterDirection.Input);
conn.Execute(spName, parameters, null, null, CommandType.StoredProcedure);
string strUserName = parameters.Get <string>("@UserName");
return(strUserName);
}
}
public bool IfHasName(string username)
{
string selectsql = @"select count from USERS";
var result = 0;
using (IDbConnection conn = SqlDBConfig.GetSqlConnection())
{
result = int.Parse(conn.QueryFirstOrDefaultAsync <Users>(selectsql, new { username }).ToString());
}
if (result > 0)
{
return(true);
}
return(false);
}