public async Task <PageAPIResult <UserInfoDTO> > Query(UserQuery query) { var isSys = baseService.IsManager(); var users = await db.UserInfo.Where(a => a.IsEnabled == true).ToListAsync(); var count = users.Count; if (!string.IsNullOrWhiteSpace(query.Name)) { users = users.Where(a => a.Name.Contains(query.Name)).Skip((query.PageIndex - 1) * query.PageSize).Take(query.PageSize).ToList(); } else { users = users.Skip((query.PageIndex - 1) * query.PageSize).Take(query.PageSize).ToList(); } var dto = mapper.Map <List <UserInfoDTO> >(users); var result = new PageAPIResult <UserInfoDTO> { data = dto, Count = count }; result.Success(); return(result); }
public async Task <PageAPIResult <RoleInfo> > Query() { var users = await db.RoleInfo.ToListAsync(); var result = new PageAPIResult <RoleInfo> { data = users }; result.Success(); return(result); }
/// <summary> /// /// </summary> /// <returns></returns> public async Task <PageAPIResult <SystemLog> > Query() { var result = new PageAPIResult <SystemLog> { data = new List <SystemLog>() }; result.data = await db.SystemLog.ToListAsync(); result.Success(); return(result); }
/// <summary> /// list /// </summary> /// <returns></returns> public async Task <PageAPIResult <UserInfoDTO> > Query() { var users = await db.UserInfo.Where(a => a.IsEnabled == true).ToListAsync(); var dto = mapper.Map <List <UserInfoDTO> >(users); var result = new PageAPIResult <UserInfoDTO> { data = dto }; result.Success(); return(result); }
public async Task <PageAPIResult <MenuInfoDTO> > Query() { var menus = await db.MenuInfo.Where(a => string.IsNullOrEmpty(a.ParentID)).ToListAsync(); var result = new PageAPIResult <MenuInfoDTO> { data = mapper.Map <List <MenuInfoDTO> >(menus) }; var parentIds = result.data.Select(a => a.GUID).ToList(); var childMneu = await db.MenuInfo.Where(a => parentIds.Contains(a.ParentID)).ToListAsync(); result.data.ToList().ForEach(a => { var childdto = childMneu.Where(b => b.ParentID == a.GUID).ToList(); a.ChildMenu = mapper.Map <List <MenuInfoDTO> >(childdto).ToList(); }); result.data = mapper.Map <List <MenuInfoDTO> >(result.data); result.Success(); return(result); }