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); } }