public OpResult <string> VerifyUserInfo(string userId, string userPwd, out SysUser sysUser) { var userInfo = _modelSvc.context.Set <SysUser>().FromSql("select * from SysUser where UserId={0} and UserPwd={1} and UserStatus=1", userId, userPwd).FirstOrDefault();//验证用户id和密码 sysUser = userInfo; if (userInfo != null) { var roleList = _modelSvc.context.Set <SysUserRole>().FromSql("SELECT * from SysUserRole where SysUserId={0}", userInfo.SysUserId).ToList().Select(x => x.SysRoleId).ToList(); //获取用户角色 var roleNameList = _modelRole.GetDatasNoTracking(x => roleList.Contains(x.SysRoleId) && x.IsDelete != true && x.RoleStatus == true).Select(x => x.RoleName).ToList(); //获取用户角色名称 var roleName = string.Join(',', roleNameList); return(new OpResult <string>(OpResultType.Success, roleName)); } return(new OpResult <string>(OpResultType.AuthInvalid, "帐号或密码不正确!")); }
/// <summary> /// 获取系统中所有的权限 /// </summary> /// <returns></returns> public List <SysRoleModuleButtonDto> GeRoleModule() { var roleModuleButton = _modelSvc.GetDatasNoTracking(x => x.ModuleType == 0).ToList().MapToList <SysRoleModuleButton, SysRoleModuleButtonDto>();// if (roleModuleButton.Count > 0) { foreach (var item in roleModuleButton) { item.SysRole = _modelSvc.context.Set <SysRole>().FromSql("select * from SysRole where SysRoleId={0} and IsDelete!=1 and RoleStatus=1", item.SysRoleId).FirstOrDefault(); item.SysModule = _modelSvc.context.Set <SysModule>().FromSql("select * from SysModule where SysModuleId={0} and ModuleStatus=1 and IsDelete!=1", item.SysModuleId).FirstOrDefault(); } } return(roleModuleButton); }