/// <summary>
/// 查询总数
/// </summary>
/// <returns></returns>
public async Task <int> GetDataCount()
{
using (var sysUserDao = new DAL.System.SysUserDao())
{
return(await sysUserDao.GetAllAsync().CountAsync());
}
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="userName">用户名称</param>
/// <param name="password">用户密码</param>
/// <returns></returns>
public bool Login(string userName, string password)
{
using (var sysUserDao = new DAL.System.SysUserDao())
{
var user = sysUserDao.JoinDepart(userName, password);
if (user != null)
{
//SysUser = user;
UserId = user.Id;
SysDepartId = user.SysDepartId;
SysDepartType = user.SysDepart.DepartType;
SysDepartName = user.SysDepart.DepartName;
RegionCity = user.SysDepart.RegionCity;
RegionCounty = user.SysDepart.RegionCounty;
var userRole = sysUserDao.JoinUserRole(UserId);
if (userRole != null)
{
SysUserRole = userRole;
SysRole = userRole.Select(m => m.SysRole).ToList();
user.SysUserRoles = userRole;
SysUser = user;
}
}
return(user != null);
}
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="userName"></param>
/// <param name="oldPwd"></param>
/// <param name="newPwd"></param>
/// <returns></returns>
public async Task ChangePassword(string userName, string oldPwd, string newPwd)
{
using (ISysUserDao sysUserDao = new DAL.System.SysUserDao())
{
if (await sysUserDao.GetAllAsync().AnyAsync(m => m.UserName == userName && m.Password == oldPwd))
{
var user = await sysUserDao.GetAllAsync().FirstAsync(m => m.UserName == userName);
user.Password = newPwd;
await sysUserDao.EditAsync(user);
}
}
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="userName">用户名称</param>
/// <param name="password">用户密码</param>
/// <returns></returns>
public bool Login(string userName, string password)
{
using (ISysUserDao sysUserDao = new DAL.System.SysUserDao())
{
var query = sysUserDao.GetAllAsync()
.Where(m => m.UserName == userName && m.Password == password && !m.IsRemoved)
.Include(p => p.SysDepart)
.Include(p => p.SysUserRoles)
.Include(p => p.SysUserRoles.Select(a => a.SysRole))
.Include(p => p.SysUserRoles.Select(a => a.SysRole).Select(b => b.SysNavRoles))
.Include(p => p.SysUserRoles.Select(a => a.SysRole).Select(b => b.SysNavRoles.Select(c => c.SysNavItem)))
.Select(p => new
{
SysUser = p,
SysUserRole = p.SysUserRoles.Where(c => !c.IsRemoved).ToList(),
SysRole = p.SysUserRoles.Where(c => !c.IsRemoved).Select(m => m.SysRole).Where(c => !c.IsRemoved).ToList(),
});
var user = query.ToList().Select(m => m.SysUser).FirstOrDefault();
if (user != null)
{
SysUser = user;
UserId = user.Id;
var depart = user.SysDepart;
if (depart != null && !depart.IsRemoved)
{
SysDepartId = depart.Id;;
RegionCity = depart.RegionCity;
RegionCounty = depart.RegionCounty;
}
SysUserRole = query.ToList().Select(m => m.SysUserRole).ToList().FirstOrDefault();
SysRole = query.ToList().Select(m => m.SysRole).ToList().FirstOrDefault();
}
return(user != null);
}
}
