Ejemplo n.º 1
0
        public LoginInfo Login(string loginName, string password)
        {
            LoginInfo loginInfo = null;
            password = Encrypt.MD5(password);
            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)
                {
                    var 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);
                        if (user.Roles != null && user.Roles.Count > 0 && user.Roles.Exists(u => u.Name == "系统管理员"))   //判断是否系统管理员
                            loginInfo.EnumLoginAccountType = (int)EnumLoginAccountType.Administrator;
                        loginInfo.ClientIP = ip;
                        loginInfo.BusinessPermissionList = user.BusinessPermissionList;
                        dbContext.Insert<LoginInfo>(loginInfo);
                    }
                }
            }

            return loginInfo;
        }
Ejemplo n.º 2
0
        public LoginInfo GetLoginInfo(Guid token)
        {
            return CacheHelper.Get<LoginInfo>(string.Format(_LoginInfoKeyFormat, token), () =>
            {
                using (var dbContext = new AccountDbContext())
                {
                    //如果有超时的,启动超时处理
                    var timeoutList = dbContext.FindAll<LoginInfo>(p => DbFunctions.DiffMinutes(DateTime.Now, p.LastAccessTime) > _UserLoginTimeoutMinutes);
                    if (timeoutList.Count > 0)
                    {
                        foreach (var li in timeoutList)
                            dbContext.LoginInfos.Remove(li);
                    }

                    dbContext.SaveChanges();


                    var loginInfo = dbContext.FindAll<LoginInfo>(l => l.LoginToken == token).FirstOrDefault();
                    if (loginInfo != null)
                    {
                        loginInfo.LastAccessTime = DateTime.Now;
                        dbContext.Update<LoginInfo>(loginInfo);
                    }

                    return loginInfo;
                }
            });
        }
Ejemplo n.º 3
0
        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));
        }
Ejemplo n.º 4
0
 /// <summary>
 /// 编辑保存
 /// </summary>
 public void SaveMenu(Menu model)
 {
     string cachingKey = "ConfigFile_AdminMenuConfig";
     using (var dbContext = new AccountDbContext())
     {
         model.ParentId = model.ParentId ?? 0;
         if (model.ID > 0)
         {
             dbContext.Update<Menu>(model);
         }
         else
         {
             dbContext.Insert<Menu>(model);
         }
         Caching.Remove(cachingKey); //删除菜单缓存
     }
 }
Ejemplo n.º 5
0
        /// <summary>
        /// 查询列表(分页)
        /// </summary>
        public IEnumerable<Menu> GetMenuList(MenuRequest request = null)
        {
            request = request ?? new MenuRequest();
            using (var dbContext = new AccountDbContext())
            {
                IQueryable<Menu> queryList = dbContext.Menus;

                if (!string.IsNullOrEmpty(request.Name))
                    queryList = queryList.Where(o => o.Name.Contains(request.Name));
                if (request.ParentId.HasValue)
                    queryList = queryList.Where(o => o.ParentId == request.ParentId);

                return queryList.OrderBy(u => new { u.ParentId, u.Orderby }).ToPagedList(request.PageIndex, request.PageSize);
            }
        }
Ejemplo n.º 6
0
 /// <summary>
 /// 权限对应的菜单
 /// </summary>
 public IEnumerable<Menu> PermissionMenu(string Permission)
 {
     using (var dbContext = new AccountDbContext())
     {
         return dbContext.Menus.Where(o => o.Permission == Permission).ToList<Menu>();
     }
 }
Ejemplo n.º 7
0
 /// <summary>
 /// 查询单个对象
 /// </summary>
 public Menu GetMenu(int id)
 {
     using (var dbContext = new AccountDbContext())
     {
         return dbContext.Find<Menu>(id);
     }
 }
Ejemplo n.º 8
0
 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();
     }
 }
Ejemplo n.º 9
0
        public bool CheckVerifyCode(string verifyCodeText, Guid guid)
        {
            using (var dbContext = new AccountDbContext())
            {
                var verifyCode = dbContext.FindAll<VerifyCode>(v => v.Guid == guid && v.VerifyText == verifyCodeText).LastOrDefault();
                if (verifyCode != null)
                {
                    dbContext.VerifyCodes.Remove(verifyCode);
                    dbContext.SaveChanges();

                    //清除验证码大于2分钟还没请求的
                    var expiredTime = DateTime.Now.AddMinutes(-2);
                    dbContext.VerifyCodes.Where(v => v.CreateTime < expiredTime).Delete();
                    return true;
                }
                else
                {
                    return false;
                }
            }
        }
Ejemplo n.º 10
0
 public Role GetRole(int id)
 {
     using (var dbContext = new AccountDbContext())
     {
         return dbContext.Find<Role>(id);
     }
 }
Ejemplo n.º 11
0
        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();
                    }
                }
            }
        }
Ejemplo n.º 12
0
 /// <summary>
 /// 查找拥有某一权限的所有用户(不包括系统管理员)
 /// </summary>
 /// <param name="perssion">权限</param>
 public IEnumerable<User> GetUserListByPermission(string perssion)
 {
     using (var db = new AccountDbContext())
     {
         var menus = PermissionMenu(perssion);
         if (menus == null || menus.Count() < 1)
             throw new Exception(string.Format("权限'{0}'没有对应的菜单.", perssion));
         var id = menus.First().ID.ToString();
         var roles = db.Roles.Where(o => o.BusinessPermissionString.Contains(id));
         IQueryable<User> queryList = db.Users.Include("Roles").Include("DepartMent")
             .Where(o => o.IsActive && o.ID != 7 && roles.Any(r => o.Roles.Contains(r)));    //排除系统管理员
         return queryList.ToList();
     }
 }
Ejemplo n.º 13
0
        public IEnumerable<User> GetUserList(UserRequest request = null)
        {
            request = request ?? new UserRequest();

            using (var dbContext = new AccountDbContext())
            {
                IQueryable<User> queryList = dbContext.Users.Include("Roles").Include("DepartMent").Where(o => o.IsActive);

                if (!string.IsNullOrEmpty(request.LoginName))
                    queryList = queryList.Where(u => u.LoginName.Contains(request.LoginName));

                if (!string.IsNullOrEmpty(request.Mobile))
                    queryList = queryList.Where(u => u.Mobile.Contains(request.Mobile));

                if (request.Role != null)
                    queryList = queryList.Where(u => u.Roles.Count(o => o.ID == request.Role.ID) > 0);

                return queryList.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize);
            }
        }
Ejemplo n.º 14
0
 public User GetUserByIp(string ip)
 {
     using (var dbContext = new AccountDbContext())
     {
         return dbContext.Users.Include("Roles").Include("DepartMent").Where(o => o.IsActive).OrderByDescending(o => o.ID).FirstOrDefault<User>(u => u.IpAddress == ip);
     }
 }
Ejemplo n.º 15
0
 public User GetUser(int id)
 {
     using (var dbContext = new AccountDbContext())
     {
         return dbContext.Users.Include("Roles").Include("DepartMent").Where(u => u.ID == id).SingleOrDefault();
     }
 }
Ejemplo n.º 16
0
 /// <summary>
 /// 删除
 /// </summary>
 public void DeleteMenu(List<int> ids)
 {
     string cachingKey = "ConfigFile_AdminMenuConfig";
     using (var dbContext = new AccountDbContext())
     {
         dbContext.Menus.Where(u => ids.Contains(u.ID)).Delete();
         Caching.Remove(cachingKey);
     }
 }
Ejemplo n.º 17
0
        public IEnumerable<Role> GetRoleList(RoleRequest request = null)
        {
            request = request ?? new RoleRequest();
            using (var dbContext = new AccountDbContext())
            {
                IQueryable<Role> queryList = dbContext.Roles;

                if (!string.IsNullOrEmpty(request.RoleName))
                {
                    queryList = queryList.Where(u => u.Name.Contains(request.RoleName));
                }

                return queryList.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize);
            }
        }
Ejemplo n.º 18
0
 public void SaveRole(Role model)
 {
     using (var dbContext = new AccountDbContext())
     {
         if (model.ID > 0)
         {
             dbContext.Update<Role>(model);
         }
         else
         {
             dbContext.Insert<Role>(model);
         }
     }
 }
Ejemplo n.º 19
0
        public void ModifyPwd(User user)
        {
            user.Password = Encrypt.MD5(user.Password);

            using (var dbContext = new AccountDbContext())
            {
                if (dbContext.Users.Any(l => l.ID == user.ID && user.Password == l.Password))
                {
                    if (!string.IsNullOrEmpty(user.NewPassword))
                        user.Password = Encrypt.MD5(user.NewPassword);

                    dbContext.Update<User>(user);
                }
                else
                {
                    throw new BusinessException("Password", "原密码不正确!");
                }
            }
        }
Ejemplo n.º 20
0
 public Guid SaveVerifyCode(string verifyCodeText)
 {
     if (string.IsNullOrWhiteSpace(verifyCodeText))
         throw new BusinessException("verifyCode", "输入的验证码不能为空!");
     using (var dbContext = new AccountDbContext())
     {
         var verifyCode = new VerifyCode() { VerifyText = verifyCodeText, Guid = Guid.NewGuid() };
         dbContext.Insert<VerifyCode>(verifyCode);
         return verifyCode.Guid;
     }
 }