public LoginInfo GetLoginInfo(Guid Token) { return CacheHelper.Get<LoginInfo>(string.Format(_LoginInfoKeyFormat, Token), () => { using (AccountDBContext db = new AccountDBContext()) { //超时处理 var timeOutList = db.FindAll<LoginInfo>(p => DbFunctions.DiffMinutes(DateTime.Now, p.LastAccessTime) > _UserLoginTimeoutMinutes); if (timeOutList.Count() > 0) { foreach (var item in timeOutList) { db.LoginInfos.Remove(item); } db.SaveChanges(); } var loginInfo = db.FindAll<LoginInfo>(s => s.LoginToken == Token).FirstOrDefault(); if (loginInfo != null) { loginInfo.LastAccessTime = DateTime.Now; db.Update<LoginInfo>(loginInfo); } return loginInfo; } }); }
public Role GetRole(int id) { using (var dbContext = new AccountDBContext()) { return dbContext.Find<Role>(id); } }
public void DeleteRole(List<int> ids) { using (var dbContext = new AccountDBContext()) { dbContext.Roles.Include("Users").Where(u => ids.Contains(u.id)).ToList().ForEach(a => { a.Users.Clear(); dbContext.Roles.Remove(a); }); dbContext.SaveChanges(); } }
public void DeleteUser(List<int> ids) { try { using (var dbContext = new AccountDBContext()) { dbContext.Users.Include("Role").Where(u => ids.Contains(u.id)).ToList().ForEach(a => { a.Roles.Clear(); dbContext.Users.Remove(a); }); dbContext.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public IEnumerable<Role> GetRoleList(RoleRequest request = null) { request = request ?? new RoleRequest(); using (var dbContext = new AccountDBContext()) { IQueryable<Role> role = dbContext.Roles; if (!string.IsNullOrEmpty(request.RoleName)) role = role.Where(u => u.Name.Contains(request.RoleName)); return role.OrderByDescending(u => u.id).ToList(); } }
public void SaveRole(Role role) { using (var dbContext = new AccountDBContext()) { if (role.id > 0) { dbContext.Update<Role>(role); } else { dbContext.Insert<Role>(role); } } }
public void SaveUser(User user) { using (var dbContext = new AccountDBContext()) { if (user.id > 0) { dbContext.Update<User>(user); var roles = dbContext.Roles.Where(r => user.RoleIds.Contains(r.id)).ToList(); user.Roles = roles; dbContext.SaveChanges(); } else { var existUser = dbContext.FindAll<User>(u => u.LoginName == user.LoginName); if (existUser.Count > 0) { throw new BusinessException("LoginName", "此登录名已存在!"); } else { dbContext.Insert<User>(user); var roles = dbContext.Roles.Where(r => user.RoleIds.Contains(r.id)).ToList(); user.Roles = roles; dbContext.SaveChanges(); } } } }
public void ModifyPwd(Contract.Model.User user) { using (var dbContext = new AccountDBContext()) { if (dbContext.Users.Any(t => t.id == user.id && t.Password == user.Password)) { if (!string.IsNullOrEmpty(user.NewPassword)) { user.Password = Encrypt.Encode(user.NewPassword); dbContext.Update(user); } } else { throw new BusinessException("输入的原始密码不正确"); } } }
public void Logout(Guid token) { using (var dbContext = new AccountDBContext()) { var loginInfo = dbContext.FindAll<LoginInfo>(l => l.LoginToken == token).FirstOrDefault(); if (loginInfo != null) { dbContext.Delete<LoginInfo>(loginInfo); } } CacheHelper.Remove(string.Format(_LoginInfoKeyFormat, token)); }
public LoginInfo Login(string loginName, string password) { LoginInfo loginInfo = null; try { loginName = loginName.Trim(); using (var dbContext = new AccountDBContext()) { var user = dbContext.Users.Include("Roles").Where(u => u.LoginName == loginName && u.Password == password && u.IsActive).FirstOrDefault(); if (user != null) { string ip = Fetch.UserIp; loginInfo = dbContext.FindAll<LoginInfo>(p => p.LoginName == loginName && p.ClientIP == ip).FirstOrDefault(); if (loginInfo != null) { loginInfo.LastAccessTime = DateTime.Now; } else { loginInfo = new LoginInfo(user.id, user.LoginName); loginInfo.ClientIP = ip; loginInfo.BusinessPermissionList = user.BusinessPermissionList; dbContext.Insert<LoginInfo>(loginInfo); } } } return loginInfo; } catch (Exception ex) { Logger.Error(LoggerType.ServiceException, ex); return loginInfo; } }
public IEnumerable<User> GetUserList(UserRequest request = null) { request = request ?? new UserRequest(); using (var dbContext = new AccountDBContext()) { IQueryable<User> users = dbContext.Users.Include("Roles"); if (!string.IsNullOrEmpty(request.LoginName)) users = users.Where(u => u.LoginName.Contains(request.LoginName)); if (!string.IsNullOrEmpty(request.Mobile)) users = users.Where(u => u.Mobile.Contains(request.Mobile)); return users.OrderByDescending(u => u.id).ToList(); } }
public User GetUser(int id) { using (var dbContext = new AccountDBContext()) { return dbContext.Users.Include("Role").Where(t => t.id == id).SingleOrDefault(); } }