public async Task <ActionResult> LoginAction(string username, string password)
{
return(await RunActionAsync(async() =>
{
if (!ValidateHelper.IsAllPlumpString(username, password))
{
return GetJsonRes("请输入账号密码");
}
using (var db = new SSODB())
{
var md5 = password.ToMD5().ToUpper();
var model = await db.T_UserInfo.Where(x => x.UserName == username && x.PassWord == md5).FirstOrDefaultAsync();
if (model == null)
{
return GetJsonRes("账户密码错误");
}
if (model.IsActive <= 0 || model.IsRemove > 0)
{
return GetJsonRes("用户被删除，或者被禁用");
}
var loginuser = model.LoginUserInfo();
loginStatus.SetUserLogin(this.X.context, loginuser);
return GetJsonRes(string.Empty);
}
}));
}
public override LoginUserInfo FindUser(HttpContext context)
{
try
{
var uid = ls.GetCookieUID(context);
var token = ls.GetCookieToken(context);
if (!ValidateHelper.IsAllPlumpString(uid, token))
{
return(null);
}
var user = IocContext.Instance.Scope(s =>
{
var key = CacheKeyManager.AuthSSOUserInfoKey(uid);
var cache = s.Resolve_ <ICacheProvider>();
return(cache.GetOrSet(key, () =>
{
using (var db = new SSODB())
{
var model = db.T_UserInfo.Where(x => x.UID == uid).FirstOrDefault();
if (model == null)
{
return null;
}
//load permission
//这里只拿了角色关联的权限，部门关联的权限没有拿
var roleslist = db.Auth_UserRole.Where(x => x.UserID == uid)
.Select(x => x.RoleID).ToList()
.Select(x => $"role:{x}").ToList();
model.Permissions = db.Auth_PermissionMap.Where(x => roleslist.Contains(x.MapKey))
.Select(x => x.PermissionID).ToList()
.Distinct().ToList();
return model;
}
}, TimeSpan.FromSeconds(60)));
});
if (user == null || user.CreateToken() != token)
{
return(null);
}
return(user.LoginUserInfo());
}
catch (Exception e)
{
e.AddErrorLog();
return(null);
}
}
public ActionResult excel()
{
return(RunAction(() =>
{
using (var db = new SSODB())
{
var list = db.T_UserInfo.Take(1000).ToList();
var data = Lib.io.ExcelHelper.ObjectToExcel(list, "用户列表");
return File(data, Lib.io.ExcelHelper.ContentType, $"用户列表导出-{DateTime.Now.ToDateTimeString()}.xls");
}
}));
}
