public IActionResult List(UserRequestPayload payload) { using (_dbContext) { var query = _dbContext.DncUser.AsQueryable(); if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.LoginName.Contains(payload.Kw.Trim()) || x.DisplayName.Contains(payload.Kw.Trim())); } if (payload.IsDeleted > CommonEnum.IsDeleted.All) { query = query.Where(x => x.IsDeleted == payload.IsDeleted); } if (payload.Status > UserStatus.All) { query = query.Where(x => x.Status == payload.Status); } var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); var data = list.Select(_mapper.Map <DncUser, UserJsonModel>); var response = ResponseModelFactory.CreateResultInstance; response.SetData(data, totalCount); return(Ok(response)); } }
public IActionResult List(UserRequestPayload payload) { using (_dbContext) { IQueryable <DncUser> query = _dbContext.DncUser.AsQueryable(); if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.LoginName.Contains(payload.Kw.Trim()) || x.DisplayName.Contains(payload.Kw.Trim())); } if (payload.IsDeleted > CommonEnum.IsDeleted.All) { query = query.Where(x => x.IsDeleted == payload.IsDeleted); } if (payload.Status > UserStatus.All) { query = query.Where(x => x.Status == payload.Status); } if (payload.FirstSort != null) { query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC"); } System.Collections.Generic.List <DncUser> list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); int totalCount = query.Count(); System.Collections.Generic.IEnumerable <UserJsonModel> data = list.Select(_mapper.Map <DncUser, UserJsonModel>); ResponseResultModel response = ResponseModelFactory.CreateResultInstance; response.SetData(data, totalCount); return(Ok(response)); } }
public IActionResult List(UserRequestPayload payload) { using (_dbContext) { var query = from u in _dbContext.SystemUser join d in _dbContext.Department on u.DepartmentUuid equals d.DepartmentUuid join ro in _dbContext.SystemRole on u.SystemRoleUuid equals ro.SystemRoleUuid.ToString() select new { SystemUserUuid = u.SystemUserUuid, LoginName = u.LoginName, RealName = u.RealName, UserIdCard = u.UserIdCard, DepartmentName = d.Name, SystemRoleUuid = u.SystemRoleUuid, SystemRoleName = ro.RoleName, AddTime = u.AddTime, AddPeople = u.AddPeople, UserType = u.UserType, IsDeleted = u.IsDeleted, Id = u.Id }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.LoginName.Contains(payload.Kw.Trim()) || x.RealName.Contains(payload.Kw.Trim())); } if (payload.IsDeleted > CommonEnum.IsDeleted.All) { query = query.Where(x => (CommonEnum.IsDeleted)x.IsDeleted == payload.IsDeleted); } //if (payload.Status > UserStatus.All) //{ // query = query.Where(x => x.Status == payload.Status); //} if (payload.FirstSort != null) { query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC"); } var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); //var data = list.Select(_mapper.Map<SystemUser, UserJsonModel>); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); ToLog.AddLog("查询", "成功:查询:系统用户信息数据", _dbContext); return(Ok(response)); } }
public IActionResult List(UserRequestPayload payload) { using (_dbContext) { var roles = _dbContext.SystemRole.Where(x => x.IsDeleted == 0).ToList(); var query = from u in _dbContext.SystemUser where u.UserType != 5 select new { SystemUserUuid = u.SystemUserUuid, LoginName = u.LoginName, RealName = u.RealName, UserIdCard = u.UserIdCard, AddTime = u.AddTime, AddPeople = u.AddPeople, UserType = GetRoleName(u.SystemRoleUuid, roles), IsDeleted = u.IsDeleted, u.OldCard, Id = u.Id }; if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.LoginName.Contains(payload.Kw.Trim()) || x.RealName.Contains(payload.Kw.Trim())); } if (payload.IsDeleted > CommonEnum.IsDeleted.All) { query = query.Where(x => (CommonEnum.IsDeleted)x.IsDeleted == payload.IsDeleted); } //if (payload.Status > UserStatus.All) //{ // query = query.Where(x => x.Status == payload.Status); //} if (payload.FirstSort != null) { query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC"); } var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); //var data = list.Select(_mapper.Map<SystemUser, UserJsonModel>); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); return(Ok(response)); } }
public IActionResult List(UserRequestPayload payload) { using (_dbContext) { var roles = _dbContext.SystemRole.Where(x => x.IsDeleted == 0).ToList(); var query = from u in _dbContext.SystemUser select new { SystemUserUuid = u.SystemUserUuid, LoginName = u.LoginName, RealName = u.RealName, UserIdCard = u.UserIdCard, AddTime = u.AddTime, AddPeople = u.AddPeople, UserType = GetRoleName(u.SystemRoleUuid, roles), IsDeleted = u.IsDeleted, SchoolUUID = u.SchoolUuid, SchoolName = u.SchoolUu.SchoolName, Type = u.UserType, //u.OldCard, _disabled = IsDisabled(u.IsCreEdu.Value, u.UserType), Id = u.Id, u.IsUploadVideo, u.IsUploadPicture, u.IsAddPrecord, u.Phone, u.IsFlow, }; if (payload.UserType == 0 && AuthContextService.CurrentUser.SchoolGuid != null) { query = query.Where(x => x.Type != 5 && x.SchoolUUID == AuthContextService.CurrentUser.SchoolGuid); } if (payload.UserType == 0 && AuthContextService.CurrentUser.SchoolGuid == null) { query = query.Where(x => x.Type != 5); } if (payload.UserType == 1) { query = query.Where(x => x.Type == 5); } if ((!string.IsNullOrEmpty(payload.Phone.Trim())) && payload.UserType == 1) { query = query.Where(x => x.Phone.Contains(payload.Phone)); } if (!string.IsNullOrEmpty(payload.Kw)) { query = query.Where(x => x.LoginName.Contains(payload.Kw.Trim()) || x.RealName.Contains(payload.Kw.Trim())); } if (payload.IsDeleted > CommonEnum.IsDeleted.All) { query = query.Where(x => (CommonEnum.IsDeleted)x.IsDeleted == payload.IsDeleted); } //if (payload.Status > UserStatus.All) //{ // query = query.Where(x => x.Status == payload.Status); //} if (payload.FirstSort != null) { query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC"); } var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList(); var totalCount = query.Count(); //var data = list.Select(_mapper.Map<SystemUser, UserJsonModel>); var response = ResponseModelFactory.CreateResultInstance; response.SetData(list, totalCount); return(Ok(response)); } }