public T_SYS_CONFIG GetConfig(int configType, int subBlogID)
{
string strSql = "SELECT * FROM T_SYS_CONFIG WHERE ID=" + configType + " and SUB_ID=" + subBlogID;
using (var conn = ConnentionFactory.GetOpenSqlConnection(ConnStr))
{
var config = conn.QueryFirst <T_SYS_CONFIG>(strSql);
return(config);
}
}
public List <T_SYS_CONFIG> GetConfigList(int configType)
{
string strSql = "SELECT * FROM T_SYS_CONFIG WHERE ID=" + configType;
using (var conn = ConnentionFactory.GetOpenSqlConnection(ConnStr))
{
var list = conn.Query <T_SYS_CONFIG>(strSql).ToList();
return(list);
}
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(T_SYS_USER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_SYS_USER set ");
strSql.Append("Password=@Password");
strSql.Append(" where UserID=@UserID");
using (var conn = ConnentionFactory.GetOpenSqlConnection(ConnStr))
{
int resUserId = conn.Execute(strSql.ToString(), model);
return(resUserId > 0);
}
}
/// <summary>
/// 根据用户名和密码获取用户信息
/// </summary>
/// <param name="userName"></param>
/// <param name="passWord"></param>
/// <returns></returns>
public List <T_SYS_USER> GetList(string userName, string passWord)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select UserID,UserName,Password,PersonalID,QQOpenid,CreateUser,CreateTime,UpdateUser,UpdateTime ");
strSql.Append(" FROM T_SYS_USER ");
strSql.Append(" where UserName=@userName and Password=@passWord");
using (var conn = ConnentionFactory.GetOpenSqlConnection(ConnStr))
{
var list = conn.Query <T_SYS_USER>(strSql.ToString(), new { UserName = userName, PassWord = passWord }).ToList();
return(list);
}
}
