public PageResult <LoginListResp> GetLoginPageList(PagedSearch request, Guid merchantId) { var strSql = $@"SELECT L.LoginId, Login, L.Name, Tele, L.Editor, L.EditTime, L.Status, SR.Name AS RoleName FROM SysLogin L WITH (nolock) LEFT JOIN dbo.SysLoginRole LR WITH (NOLOCK) ON L.LoginID = LR.LoginID LEFT JOIN dbo.SysRole SR WITH (nolock) ON LR.RoleID = SR.RoleID" ; var where = new SearchCondition(); where.AddCondition("L.MerchantID", merchantId, SqlOperator.Equal, true); //where.AddSqlCondition("L.Login like '%' + @key + '%'", // true, // new SugarParameter("key", "a")); //where.AddCondition("L.status",1,SqlOperator.Equal,true); return(this.SelectListPage <LoginListResp>(strSql, where, request.Page, request.PageSize, "EditTime desc")); }
public ActionResult GroupList(PagedSearch model) { PagedData <GroupModel> groups = null; if (this.Me.GroupSort != GroupSort.Super) { groups = this.permissionQuery.GetPageGroup(model, this.Me.DepartmentId); } else { groups = this.permissionQuery.GetPageGroup(model); } if (groups == null) { groups = new PagedData <GroupModel>(); } var grid = new JsonGridModel() { TotalCount = groups.TotalCount, PageNow = groups.PageNow, PageSize = groups.PageSize, Records = groups.Records }; return(this.Json(ApiStatus.Success, grid)); }
public IActionResult Search([FromQuery] PagedSearch search) { ApiResult <PagedData <DivisionResp> > searchResult = _divisionService.Search(search); IEnumerable <CityResponse.City> cities = _cityService.Find(x => ((long)x.id).IsIn(searchResult.Result.Records.Select(o => o.CityId))); return(Ok(new { searchResult.Result.PageNow, searchResult.Result.PageSize, searchResult.Result.TotalCount, Records = searchResult.Result.Records.Select(x => { CityResponse.City city = cities.FirstOrDefault(c => c.id == x.CityId); return new { x.Name, x.CityId, x.DivisionId, x.CreateTime, x.TotalMember, City = city }; }) })); }
public IActionResult Search([FromQuery] PagedSearch search) { ApiResult <PagedData <WizardResp> > wizards = _wizardService.Search(new SearchWizardReqs() { PageSize = search.PageSize, PageNow = search.PageNow, IsAdmin = true }); ApiResult <IEnumerable <DivisionResp> > divisions = _divisionService.GetByIds(wizards.Result.Records.Select(x => x.DivisionId).Distinct().ToArray()); IEnumerable <CityResponse.City> cities = _cityService.Find(x => ((long)x.id).IsIn(divisions.Result.Select(o => o.CityId).Distinct())); return(Ok(new { wizards.Result.PageNow, wizards.Result.PageSize, wizards.Result.TotalCount, Records = wizards.Result.Records.Select(x => { DivisionResp division = divisions.Result.FirstOrDefault(o => o.DivisionId == x.DivisionId); CityResponse.City city = cities.FirstOrDefault(c => c.id == division.CityId); return new { x.WizardId, x.DivisionId, City = city?.nm, x.Account, x.Email, x.CreateTime, }; }) })); }
public PagedResponse(IQueryable <T2> query, PagedSearch search, IMapper mapper) { TotalCount = query.Count(); CurrentPage = search.Page; ItemsPerPage = search.PerPage; Items = mapper.Map <IEnumerable <T1> >( query .Skip(search.Skip()) .Take(search.PerPage) .ToList() ); }
public PageResult <RoleListResp> GetRolePageList(PagedSearch request, Guid merchantId) { var strSql = $@"SELECT RoleId, Name, Editor, EditTime, Status FROM sysrole WITH (nolock) WHERE merchantid = '{merchantId}'"; return(this.SelectListPage <RoleListResp>(strSql, request.Page, request.PageSize, "EditTime", true)); }
public static PagedResponse <TDto> Paged <TDto, TSource> (this IQueryable <TSource> query, PagedSearch search, IMapper mapper) where TDto : class { var skip = (search.Page - 1) * search.PerPage; return(new PagedResponse <TDto>() { TotalCount = query.Count(), ItemsPerPage = search.PerPage, CurrentPage = search.Page, Items = mapper.Map <IEnumerable <TDto> >(query.Skip(skip).Take(search.PerPage).ToList()) }); }
public static PagedResponse <TDto> Paged <TDto, TEntity>( this IQueryable <TEntity> query, PagedSearch search, IMapper mapper) where TDto : class { var skipCount = search.PerPage * (search.Page - 1); var skipped = query.Skip(skipCount).Take(search.PerPage); var response = new PagedResponse <TDto> { CurrentPage = search.Page, ItemsPerPage = search.PerPage, TotalCount = query.Count(), Items = mapper.Map <IEnumerable <TDto> >(skipped) }; return(response); }
public ActionResult DepartmentList(PagedSearch model) { var departments = this.permissionQuery.GetPageDeparement(model); if (departments == null) { departments = new PagedData <DepartmentModel>(); } var grid = new JsonGridModel() { TotalCount = departments.TotalCount, PageNow = departments.PageNow, PageSize = departments.PageSize, Records = departments.Records }; return(this.Json(ApiStatus.Success, grid)); }
public PagedData <GroupModel> GetPageGroup(PagedSearch scout) { var para = new { StartIndex = scout.StartIndex, EndIndex = scout.EndIndex, PageSize = scout.PageSize, PageNow = scout.PageNow, }; var totalCount = this.daoBuilder.Build().ToEasyXmlDao(para).QueryForObject <int>("qryGroupRootCount"); if (totalCount <= 0) { return(new PagedData <GroupModel>(scout.PageNow, scout.PageSize, 0, new GroupModel[0])); } return(new PagedData <GroupModel>(scout.PageNow, scout.PageSize, totalCount, this.daoBuilder.Build().ToEasyXmlDao(para).QueryForEnumerable <GroupModel>("qry_GroupRoot"))); }
public PagedData <EmployeeModel> GetPageEmployee(PagedSearch scout, string departmentId) { var para = new { StartIndex = scout.StartIndex, EndIndex = scout.EndIndex, PageSize = scout.PageSize, PageNow = scout.PageNow, DepartmentId = departmentId.ToNullableParameter(), }; var totalCount = this.daoBuilder.Build().ToEasyXmlDao(para).QueryForObject <int>("qryEmployeeRootCount"); if (totalCount <= 0) { return(new PagedData <EmployeeModel>(scout.PageNow, scout.PageSize, 0, new EmployeeModel[0])); } return(new PagedData <EmployeeModel>(scout.PageNow, scout.PageSize, totalCount, this.daoBuilder.Build().ToEasyXmlDao(para).QueryForEnumerable <EmployeeModel>("qry_EmployeeRoot"))); }
public override void Execute() { var pageSearch = new PagedSearch(); int pageIndex = 1; while (1 == 1) { var result = _jurisdictionService.GetLoginPageList(pageSearch, base.MerchantId); if (result == null || result.DataList == null || result.DataList.Count == 0) { break; } base.List = result.DataList; base.Execute(); pageSearch.Page = pageSearch.Page + 1; } }
public ActionResult DepartmentList() { var model = new PagedSearch(); return(this.View(model)); }
public ActionResult EmployeeList(PagedSearch model) { PagedData <EmployeeModel> employees = null; if (this.Me.GroupSort != GroupSort.Super) { employees = this.permissionQuery.GetPageEmployee(model, this.Me.DepartmentId); } else { employees = this.permissionQuery.GetPageEmployee(model); } if (employees == null) { employees = new PagedData <EmployeeModel>(); } var alldepartments = this.permissionQuery.GetAllDepartment(); if (alldepartments != null) { if (employees.Records != null) { foreach (var i in employees.Records) { if (i.GroupSort == GroupSort.Super) { if (i.AggregateId != this.Me.AggregateId) { i.Id = -1; i.AggregateId = ""; i.UserName = "******"; i.NickName = "地球很危险"; i.DepartmentId = "神秘部门"; } } else { i.DepartmentId = alldepartments.Any(t => t.AggregateId == i.DepartmentId) ? alldepartments.First(t => t.AggregateId == i.DepartmentId).Name : "未知部门"; } } } } else if (employees.Records != null) { foreach (var i in employees.Records) { if (i.GroupSort == GroupSort.Super) { if (i.AggregateId != this.Me.AggregateId) { i.Id = -1; i.AggregateId = ""; i.UserName = "******"; i.NickName = "地球很危险"; i.DepartmentId = "神秘部门"; } } else { i.DepartmentId = alldepartments.Any(t => t.AggregateId == i.DepartmentId) ? alldepartments.First(t => t.AggregateId == i.DepartmentId).Name : "未知部门"; } } } var grid = new JsonGridModel() { TotalCount = employees.TotalCount, PageNow = employees.PageNow, PageSize = employees.PageSize, Records = employees.Records }; return(this.Json(ApiStatus.Success, grid)); }
public PageResult <RoleListResp> GetRolePageList(PagedSearch request) { return(_jurisdictionService.GetRolePageList(request, CurrentLogin.MerchantId)); }
/// <summary> /// 查询用户标识的所有任务 /// </summary> /// <param name="commandType">命令类型</param> /// <param name="userSign">用户标识</param> /// <param name="statusArray">状态</param> /// <param name="paged">分页查询</param> /// <returns></returns> public virtual TaskschedNode[] GetList(PagedSearch paged, string userSign, string commandType, TaskschedStatus[] statusArray) { return(this.GetAll(userSign, commandType, statusArray)); }
/// <summary> /// 查询用户标识的所有任务 /// </summary> /// <param name="commandType">命令类型</param> /// <param name="statusArray">状态</param> /// <param name="paged">分页查询</param> /// <returns></returns> public virtual TaskschedNode[] GetList(PagedSearch paged, TaskschedStatus[] statusArray, string commandType) { return(this.GetAll(statusArray, commandType)); }
public PageResult <DistrictManagerListResp> GetDistrictManagerPageList(PagedSearch <DistrictManagerSearchRequest> request) { return(_districtManagerService.GetDistrictManagerPageList(request, CurrentUser.MerchantID)); }
public static List <T> FormatForPagedResponse <T>(this IQueryable <T> query, PagedSearch search) { return(query.Skip(search.PerPage * (search.Page - 1)).Take(search.PerPage).ToList()); }
public ActionResult GroupList() { var model = new PagedSearch(); return(this.View(model)); }
public static IQueryable <TDto> DefaultFilter <TDto>(this IQueryable <TDto> query, PagedSearch search) where TDto : BaseEntity { if (search.IsActive != null) { query = query.Where(x => x.IsActive == search.IsActive); } return(query); }
public PageResult <RoleListResp> GetRolePageList(PagedSearch request, Guid merchantId) { return(_sysRoleRepository.GetRolePageList(request, merchantId)); }
public PageResult <LoginListResp> GetLoginPageList(PagedSearch request, Guid merchantId) { return(_sysLoginRepository.GetLoginPageList(request, merchantId)); }
public PageResult <DistrictManagerInResp> GetDistrictManagerInPageList(PagedSearch <DistrictManagerInDependOnIdSearchRequest> request) { return(_districtManagerService.GetDistrictManagerInPageList(request)); }
public ApiResult <PagedData <DivisionResp> > Search(PagedSearch search) { PagedData <DivisionInfo> result = _divisionQueryService.QueryPaged(search); return(new ApiResult <PagedData <DivisionResp> >(ResultStatus.SUCCESS, Mapper.Map <PagedData <DivisionInfo>, PagedData <DivisionResp> >(result))); }
/// <summary> /// 查询用户标识的所有任务 /// </summary> /// <param name="statusArray">状态</param> /// <param name="paged">分页查询</param> /// <returns></returns> public virtual TaskschedNode[] GetList(PagedSearch paged, TaskschedStatus[] statusArray) { return(this.GetAll(statusArray)); }
public static PagedResponse <T> GeneratePagedResponse <T>(this List <T> items, PagedSearch search, IQueryable <EntityBase> query) where T : class { var skipCount = search.PerPage * (search.Page - 1); return(new PagedResponse <T> { CurrentPage = search.Page, ItemsPerPage = search.PerPage, Total = query.Count(), Items = items }); }
public PageResult <DistrictManagerInResp> GetCustomersInDistrictManagerPageList(PagedSearch <Guid> request) { return(_districtManagerService.GetDistrictManagerInPageList(request, CurrentUser.CustomerID.Value)); }