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