/// <summary>
/// 登录验证帐号和密码
/// </summary>
/// <param name="userId"></param>
/// <param name="userPwd"></param>
/// <returns></returns>
public async Task <Tuple <OpResult <string>, SysUser> > VerifyPassword(string userId, string userPwd)
{
var userInfo = await _iSysUserRepository.QueryBySql($"select * from SysUser where UserId='{userId}' and UserPwd='{userPwd}' and UserStatus=1");//验证用户id和密码
var sysUser = userInfo.FirstOrDefault();
if (sysUser != null)
{
var roleList = _iSysUserRoleRepository.QueryBySql($"SELECT * from SysUserRole where SysUserId='{sysUser.SysUserId}'").Result.Select(x => x.SysRoleId).ToList(); //获取用户角色
var roleNameList = _iSysRoleRepository.QueryAsNoTracking(x => roleList.Contains(x.SysRoleId) && x.IsDelete != true && x.RoleStatus == true).Result.Select(x => x.RoleName).ToList(); //获取用户角色名称
var roleName = string.Join(',', roleNameList);
return(new Tuple <OpResult <string>, SysUser>(new OpResult <string>(OpResultType.Success, roleName), sysUser));
}
return(new Tuple <OpResult <string>, SysUser>(new OpResult <string>(OpResultType.AuthInvalid, "帐号或密码不正确！"), sysUser));
}