/// <summary> /// 用户登录验证 /// </summary> /// <param name="userLoginName"></param> /// <param name="pwd"></param> /// <returns></returns> public static UserLoginData Login(string userLoginName, string pwd) { UserLoginData loginData = new UserLoginData(); SQLHelper helper = new SQLHelper("select * from XT_USER where USER_NAME=@0 and PWD=@1", userLoginName, MD5Ulits.GetMd5Hash(pwd)); XT_UserService service = ServiceManage.GetService <XT_UserService>(); XT_USER user = service.SelectFirstOrDefault(helper); if (user == null && userLoginName == AppConfigManage.GetSysUserInfo()[0]) { user = service.SelectByLoginName(userLoginName); if (user != null) { loginData.Message = "用户名或密码错误"; loginData.LoginState = false; return(loginData); } user = new XT_USER() { USER_NAME = userLoginName, PWD = MD5Ulits.GetMd5Hash(pwd), CREATE_BY = "system_", CREATE_TIME = DateTime.Now, LOGIN_NAME = userLoginName, MODIFY_BY = "system_", MODIFY_TIME = DateTime.Now, PING_YIN = "" }; service.Insert(user); } else { if (user == null) { loginData.Message = "用户名或密码错误"; loginData.LoginState = false; return(loginData); } } loginData.Message = "登录成功"; loginData.LoginState = true; loginData.Data = user; return(loginData); }
/// <summary> /// 根据用户编号查询用户可授予别的用户角色 /// </summary> /// <param name="userId"></param> public List <XT_ROLE> SelectByUser(string userId) { XT_USER user = ServiceManage.GetService <XT_UserService>().SelectById(userId); if (user == null) { return(new List <XT_ROLE>()); } if (user.LOGIN_NAME == AppConfigManage.GetSysUserInfo()[0]) { return(SelectAll()); } SQLHelper helper = new SQLHelper("select c.* from XT_USER a,XT_USER_ROLE b, XT_ROLE c)"); helper.Append("where a.ID = b.USER_ID"); helper.Append("and b.ROLE_ID = c.ID "); helper.Append("and a.ID=@0", userId); return(Select(helper)); }