private void SelfLink(PagedListResult <Product> products, SrvObj.ProductsResponse productResponse)
{
productResponse
.Links
.Add(NewLink("self", "products?page={0}&size={1}"
.Fmt(products.Page, products.Size)));
}
public ReportResultsResponse GetResultsPage(Guid resultId, IRequestedPage requestedPage)
{
var resultRepo = context.GetRepository<ReportResult>();
var reportResult = resultRepo.Get(resultId);
reportResult.ValidateNotNull();
var fieldRepo = context.GetRepository<Field>();
var reportFields = fieldRepo.GetWhere(f => reportResult.FieldIds.Any(id => id == f.SourceId));
var columns = reportFields.Select(x => new ReportResultColumn { FieldId = x.SourceId, FieldName = x.Name, UnitName = x.Unit });
var resultRowRepo = context.GetRepository<ReportResultRow>();
var results = resultRowRepo.GetWhere(x => x.ReportResultId, resultId, requestedPage);
var count = resultRowRepo.Count(x => x.ReportResultId, resultId);
var pagedResults = new PagedListResult<ReportResultRow>(results, count);
return new ReportResultsResponse
{
Count = pagedResults.Count,
Pages = pagedResults.Pages,
Rows = pagedResults.Results,
FieldColumns = columns,
ReportName = reportResult.ReportName
};
}
/// <summary>
/// Converts the specified source to <see cref="IPagedListResult{T}"/> by the specified <paramref name="pageNumber"/> and <paramref name="pageSize"/>.
/// </summary>
/// <typeparam name="T">The type of the source.</typeparam>
/// <param name="source">The source to paging.</param>
/// <param name="pageNumber">The number of the page, index from 1.</param>
/// <param name="pageSize">The size of the page.</param>
/// <returns>An instance of implements <see cref="IPagedListResult{T}"/> interface.</returns>
public static IPagedListResult <T> ToPagedList <T>([NotNull] this IQueryable <T> source, int pageNumber, int pageSize)
{
if (pageNumber <= 0)
{
pageNumber = 1;
}
if (pageSize <= 0)
{
pageSize = 10;
}
var count = source.Count();
if (count == 0)
{
return(PagedListResult <T> .Empty);
}
if (pageNumber > 1)
{
source = source.Skip((pageNumber - 1) * pageSize);
}
var items = source
.Take(pageSize)
.ToArray();
var pagedList = new PagedListResult <T>()
{
PageNumber = pageNumber,
PageSize = pageSize,
TotalCount = count,
Data = items
};
return(pagedList);
}
// GET: DCBooking
public async Task <ActionResult> Index(int?pageIndex, string DestinationPort = null, string bookingref = null, DateTime?bookingdatefrom = null, DateTime?bookingdateto = null, string DC = null, DateTime?arrivaldatefrom = null, DateTime?arrivaldateto = null, string Status = null, string Container = null, bool checkClick = false)
{
ViewBag.DC = new List <string> {
"Market Hong Kong", "Gas Customer Center", "JSI Logistics"
};
ViewBag.Haulier = new List <string> {
"123 Cargo", "Cargo Core"
};
SearchingDCBooking searchingDCBooking = await _dCBookingService.getItem();
ViewBag.DestPort = new List <string> {
"Crooked Harbour", "Aberdeen", "Double Haven", "Gin Drinkers Bay", "Inner Port Shelter", "Cam Pha", "Cua Lo", "Hai Phong", "Hon Gai", "Nghi Son"
};
ViewBag.HongKongPorts = new List <string> {
"Crooked Harbour", "Aberdeen", "Double Haven", "Gin Drinkers Bay", "Inner Port Shelter"
};
ViewBag.VNPorts = new List <string> {
"Cam Pha", "Cua Lo", "Hai Phong", "Hon Gai", "Nghi Son"
};
ViewBag.Status = searchingDCBooking.Status;
int current = pageIndex ?? 1;
ViewBag.pageIndex = current;
PagedListResult <DCBookingDtos> pagedListResult = await _dCBookingService.ListDCBookingDtosAsync(current, 10, DestinationPort, bookingref, bookingdatefrom, bookingdateto, DC, arrivaldatefrom, arrivaldateto, Status, Container);
pagedListResult.CurrentFilter = current.ToString();
if (checkClick == true)
{
return(PartialView("_SearchingDCBookingPartial", pagedListResult));
}
return(View(pagedListResult));
}
public async Task <PagedListResult <OrderDTO> > DisplaysAsync(string poNumber, int?pageIndex, int?pageSize)
{
Expression <Func <Order, bool> > query = (p => p.Id > 0);
if (poNumber != null)
{
query = (p => p.PONumber.Contains(poNumber));
}
string sortStr = "OrderDate DESC";
var poResult = await _orderDataProvider.ListAsync(query, sortStr, true, pageIndex, pageSize);
var pagedResult = new PagedListResult <OrderDTO>
{
TotalCount = poResult.TotalCount,
PageCount = poResult.PageCount,
CurrentFilter = poNumber,
Items = Mapper.Map <List <OrderDTO> >(poResult.Items)
};
foreach (var item in pagedResult.Items)
{
item.POQuantity = TotalQuantity(item);
}
return(pagedResult);
}
public static IPagedList <TEntity> ToPagedList <TEntity>(this IEnumerable <TEntity> list, int page, int pageSize, long total) where TEntity : class, new()
{
PagedListResult <TEntity> result = new PagedListResult <TEntity>(page, pageSize, total);
result.AddRange(list);
return(result);
}
private static async Task GetPageResults(PagedListResult <StarShip> pagedList)
{
/// start at 2 as we already have the first paged results
for (var i = 2; i <= pagedList.Pages; i++)
{
ConsoleViewUtil.WriteFullLine(" Load more ? (type y or yes to continue)", "green");
var res = Console.ReadLine();
if (res == "y" || res == "yes" || res == "Y" || res == "YES")
{
//getting the next paged result
var temp = await _swDataService.GetStarShipsAsync(i);
_swDataService.CalculateSupplyStops(ref temp, MGLT);
PrintResults(temp.Results);
}
else
{
/// end paging for loop
i = pagedList.Pages;
}
}
}
public void CalculateSupplyStops(ref PagedListResult <StarShip> pagedList, Int64 MGLT)
{
foreach (var item in pagedList.Results)
{
item.CalculateDistance(MGLT);
}
}
public JsonResult GetLocationsByDistance(LocationUtilsFilterOptions locationFilterOptions, ResultsFilter resultsFilter, PagedListOptions pagedListOptions)
{
var locationFilter = locationFilterOptions.ToLocationFilter();
var minutes = resultsFilter.Minutes;
pagedListOptions.SortBy = pagedListOptions.SortBy ?? "Distance";
var locationsQuery = db.Locations
.Where(x => x.Coordinate.Distance(locationFilter.Origin) <= locationFilter.Radius)
.Select(x => new LocationModel
{
LocationId = x.LocationID,
AddressLine1 = x.Address,
AddressLine2 = x.Address,
AddressLine3 = x.Address,
AddressLine4 = x.Address,
AddressLine5 = x.Address,
PostalCode = "BS234",
Distance = x.Coordinate.Distance(locationFilter.Origin)
});
var data = locationsQuery.ToPagedListData(pagedListOptions)
.Select(x => new ResultModel
{
LocationId = x.LocationId,
Address = x.Address,
Miles = x.Miles
});
var result = new PagedListResult<ResultModel>(data, locationsQuery.ToPagedListDetails());
return Json(result, JsonRequestBehavior.AllowGet);
}
// GET: ProgressCheckDto
public async Task <ActionResult> Index(string PONumberSearch = null, string ItemSearch = null, string Suppliers = null, string Factories = null, string Origins = null, string OriginPorts = null, string Depts = null)
{
GetItemSearchDto getSearchItem = await _prcService.SearchItem();
ViewBag.Suppliers = getSearchItem.Suppliers;
ViewBag.Origins = getSearchItem.Origins;
ViewBag.OriginPorts = getSearchItem.OriginPorts;
ViewBag.Factories = getSearchItem.Factories;
ViewBag.Depts = getSearchItem.Depts;
ViewBag.ErrorList = "No result match, please try again";
PagedListResult <ProgressCheckDto> lstPrc = await _prcService.ListProgressCheckDtoAsync();
List <ProgressCheckDto> progressCheckDtos = lstPrc.Items;
if (PONumberSearch != null)
{
progressCheckDtos = progressCheckDtos.Where(p => p.PONumber == PONumberSearch).ToList();
}
if (!String.IsNullOrEmpty(Suppliers) || !String.IsNullOrEmpty(Factories))
{
progressCheckDtos = progressCheckDtos.Where(p => p.Supplier == Suppliers || p.Factory == Factories).ToList();
}
if (!String.IsNullOrEmpty(Origins) || !String.IsNullOrEmpty(OriginPorts))
{
progressCheckDtos = progressCheckDtos.Where(p => p.Origin == Origins || p.OriginPort == OriginPorts).ToList();
}
List <ProgressCheckDto> model = progressCheckDtos;
return(View("Index", model));
}
private void LastLink(PagedListResult <Product> products, SrvObj.ProductsResponse productResponse)
{
var lastPage = products.LastPage();
productResponse
.Links
.Add(NewLink("last", "products?page={0}&size={1}".Fmt(lastPage, products.Size)));
}
public override PagedListResultBuilder <TItem> MergeWith(PagedListResult <TItem> result)
{
this.result.Items = result.Items;
this.result.PageIndex = result.PageIndex;
this.result.PageSize = result.PageSize;
this.result.TotalCount = result.TotalCount;
return(base.MergeWith(result));
}
public async Task <IActionResult> Display(string poNumberFilter, int?pageIndex)
{
int current = pageIndex ?? 1;
PagedListResult <OrderDTO> pagedlistResult = await _orderService.DisplaysAsync(poNumberFilter, current, pageSize);
ViewBag.CurrentPage = current;
return(View(pagedlistResult));
}
public static IPagedList <TEntity> ToPagedList <TEntity, TKey>(this SqlExpression <TEntity> expression, IDbConnection connection, int page, int pageSize)
where TEntity : CopterBaseEntity <TKey>, new()
where TKey : struct
{
long total = connection.Count(expression);
PagedListResult <TEntity> result = new PagedListResult <TEntity>(page, pageSize, total);
result.AddRange(connection.Select(expression.Skip((page - 1) * pageSize).Take(pageSize)));
return(result);
}
public static PagedListResult <NoticeViewModel> FromEntityList(PagedListResult <NoticeInfo> noticesInfo)
{
return(new PagedListResult <NoticeViewModel>
{
HasNext = noticesInfo.HasNext,
HasPrevious = noticesInfo.HasPrevious,
Count = noticesInfo.Count,
Entities = noticesInfo.Entities.Select(FromEntity).ToList()
});
}
private void NextLink(PagedListResult <Product> products, SrvObj.ProductsResponse productResponse)
{
if (products.HasNext)
{
productResponse
.Links
.Add(NewLink("next", "products?page={0}&size={1}"
.Fmt(products.Page + 1, products.Size)));
}
}
internal static PagedListResult <UserViewModel> FromEntityList(PagedListResult <Student> students)
{
return(new PagedListResult <UserViewModel>
{
HasNext = students.HasNext,
HasPrevious = students.HasPrevious,
Count = students.Count,
Entities = students.Entities.Select(FromEntity).ToList()
});
}
internal static PagedListResult <UserViewModel> FromEntityList(PagedListResult <Teacher> teachers)
{
return(new PagedListResult <UserViewModel>
{
HasNext = teachers.HasNext,
HasPrevious = teachers.HasPrevious,
Count = teachers.Count,
Entities = teachers.Entities.Select(FromEntity).ToList()
});
}
internal static PagedListResult <ClassViewModel> FromEntityList(PagedListResult <Class> classes)
{
return(new PagedListResult <ClassViewModel>
{
HasNext = classes.HasNext,
HasPrevious = classes.HasPrevious,
Count = classes.Count,
Entities = classes.Entities.Select(FromEntity).ToList()
});
}
internal static PagedListResult <CourseViewModel> FromEntityList(PagedListResult <Course> courses)
{
return(new PagedListResult <CourseViewModel>
{
HasNext = courses.HasNext,
HasPrevious = courses.HasPrevious,
Count = courses.Count,
Entities = courses.Entities.Select(item => FromEntity(item, 0)).ToList()
});
}
public static PagedListResult <AccessViewModel> FromEntityList(PagedListResult <AccessInfo> accesses)
{
return(new PagedListResult <AccessViewModel>
{
HasNext = accesses.HasNext,
HasPrevious = accesses.HasPrevious,
Count = accesses.Count,
Entities = accesses.Entities.Select(FromEntity).ToList()
});
}
private void PreviousLink(PagedListResult <Product> products, SrvObj.ProductsResponse productResponse)
{
if (products.HasPrevious)
{
productResponse
.Links
.Add(NewLink("previous", "products?page={0}&size={1}"
.Fmt(products.Page - 1, products.Size)));
}
}
/// <summary>
/// 异步查询分页数据
/// </summary>
/// <param name="sql"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="paras"></param>
/// <returns></returns>
public async Task <PagedListResult <T> > QueryPagedAsync(string sql, int pageIndex, int pageSize, DynamicParameters paras, IDbTransaction transaction = null, IDbConnection connection = null)
{
Log.Write("QueryFirst:" + sql);
try
{
var strSelCountSql = $@"select count(0) From ({sql}) t"; //查询总数
var strSelPagedSql = $@"select * From ({sql}) t limit @SkipRows,@PageSize"; //分页查询
var list = default(IEnumerable <T>);
var total = 0;
if (paras != null)
{
//添加分页参数
paras.Add("@SkipRows", (pageIndex - 1) * pageSize);
paras.Add("@PageSize", pageSize);
}
//查询
if (transaction != null)
{
list = await connection.QueryAsync <T>(strSelPagedSql, paras);
total = await connection.QueryFirstAsync <int>(strSelCountSql, paras);
return(new PagedListResult <T>(pageIndex, pageSize, total, list));
}
else
{
using (var myConn = DapperBuilder.Instance.GetConnection(Source, SlaveId))
{
list = await myConn.QueryAsync <T>(strSelPagedSql, paras);
total = await myConn.QueryFirstAsync <int>(strSelCountSql, paras);
var ret = new PagedListResult <T>(pageIndex, pageSize, total, list);
if (transaction == null)
{
//没有事务，需要单独关闭
myConn.Close();
myConn.Dispose();
}
return(ret);
}
}
}
catch (MySqlException ex)
{
Log.Write("QueryPagedAsync:" + sql, ex);
throw ex;
}
catch (Exception ex)
{
Log.Write("QueryPagedAsync:" + sql, ex);
throw ex;
}
}
internal static PagedListResult <KnowledgeAreaViewModel> FromEntityList(
PagedListResult <KnowledgeArea> knowledgeAreas)
{
return(new PagedListResult <KnowledgeAreaViewModel>
{
HasNext = knowledgeAreas.HasNext,
HasPrevious = knowledgeAreas.HasPrevious,
Count = knowledgeAreas.Count,
Entities = knowledgeAreas.Entities.Select(item => FromEntity(item, 0)).ToList()
});
}
public async Task <ActionResult> CreateOrUpdate(PagedListResult <DCBookingDtos> pagedListResult)
{
ViewBag.DC = new List <string> {
"Market Hong Kong", "Gas Customer Center", "JSI Logistics"
};
ViewBag.Haulier = new List <string> {
"123 Cargo", "Cargo Core"
};
SearchingDCBooking searchingDCBooking = await _dCBookingService.getItem();
ViewBag.DestPort = new List <string> {
"Crooked Harbour", "Aberdeen", "Double Haven", "Gin Drinkers Bay", "Inner Port Shelter", "Cam Pha", "Cua Lo", "Hai Phong", "Hon Gai", "Nghi Son"
};
ViewBag.Status = searchingDCBooking.Status;
ViewBag.HongKongPorts = new List <string> {
"Crooked Harbour", "Aberdeen", "Double Haven", "Gin Drinkers Bay", "Inner Port Shelter"
};
ViewBag.VNPorts = new List <string> {
"Cam Pha", "Cua Lo", "Hai Phong", "Hon Gai", "Nghi Son"
};
ViewBag.ShowResult = "empty";
int current = int.Parse(pagedListResult.CurrentFilter);
ViewBag.pageIndex = current;
for (int i = 0; i < pagedListResult.Items.Count(); i++)
{
if (pagedListResult.Items[i].selected == false)
{
string bookingdate = "Items[" + i + "].BookingDate";
string id = "Items[" + i + "].Id";
ModelState[bookingdate].ValidationState = ModelState[id].ValidationState;
}
}
if (ModelState.IsValid)
{
foreach (var item in pagedListResult.Items)
{
if (item.selected == true)
{
await _dCBookingService.CreateOrUpdate(item);
ViewBag.ShowResult = "success";
}
}
ModelState.Clear();
}
else
{
ViewBag.ShowResult = "invalid";
}
return(PartialView("_AvchieveDCBookingPartial", pagedListResult));
}
public async Task <PagedListResult <PurchaseOrderDto> > ListPurchaseOrdersAsync(string searchTerm)
{
var poResult = await _poDataProvider.ListAsync();
var result = new PagedListResult <PurchaseOrderDto>
{
TotalCount = poResult.TotalCount,
PageCount = poResult.PageCount,
Items = Mapper.Map <List <PurchaseOrderDto> >(poResult.Items)
};
return(result);
}
private static async Task GetStarShipCalculation()
{
PagedListResult <StarShip> pagedList = await _swDataService.GetStarShipsAsync(null);
_swDataService.CalculateSupplyStops(ref pagedList, MGLT);
PrintResults(pagedList.Results);
if (pagedList.Pages > 1)
{
await GetPageResults(pagedList);
}
}
public void PagedModelToJsonTest()
{
var model = new PagedListResult <int>()
{
PageNumber = 1,
PageSize = 3,
TotalCount = 10,
Data = new[] { 1, 2, 3 }
};
var json = model.ToJson();
var dModel = json.JsonToObject <PagedListResult <int> >();
Assert.Equal(model.PageSize, dModel.PageSize);
}
public PagedListResult <T> GetPaginated(QueryBase <T> query)
{
PagedListResult <T> result = new PagedListResult <T>();
using (var context = new AppContext())
{
IQueryable <T> dbQuery = context.Set <T>();
dbQuery = ManageFilters(query, dbQuery);
dbQuery = ManageIncludeProperties(query, dbQuery);
dbQuery = ManageSortCriterias(query, dbQuery);
result = GetTheResult(query, dbQuery);
}
return(result);
}
protected IPagedListResult <T> GetDefaultPagingDtoResult <T, K>(IMapper mapper, IPagedListResult <K> pagingEntitiesResult)
where T : DTOBase
where K : class
{
var pagingDtosResult = new PagedListResult <T>
{
CurrentPage = pagingEntitiesResult.CurrentPage,
TotalRows = pagingEntitiesResult.TotalRows,
TotalPages = pagingEntitiesResult.TotalPages,
HasNext = pagingEntitiesResult.HasNext,
HasPrevious = pagingEntitiesResult.HasPrevious,
DTOs = mapper.Map <List <T> >(pagingEntitiesResult.DTOs.ToList())
};
return(pagingDtosResult);
}
public async Task <ActionResult> Search(VesselDepartureDtos model, string page = null)
{
SetDropDownList();
if (page == null)
{
page = "1";
}
int pageIndex = int.Parse(page);
ViewBag.Page = pageIndex;
model.ResultDtos = new PagedListResult <ContainerDto>();
model.ResultDtos = await _vesselDepartureService.ListContainerDtoAsync(pageIndex, model.FilterDto.Origin, model.FilterDto.OriginPort, model.FilterDto.Container,
model.FilterDto.Status, model.FilterDto.ETDFrom, model.FilterDto.ETDTo);
PagedListResult <ContainerDto> nextPage = new PagedListResult <ContainerDto>();
PagedListResult <ContainerDto> previousPage = new PagedListResult <ContainerDto>();
previousPage.Items = new List <ContainerDto>();
if (pageIndex - 1 > 0)
{
previousPage = await _vesselDepartureService.ListContainerDtoAsync(pageIndex - 1, model.FilterDto.Origin, model.FilterDto.OriginPort, model.FilterDto.Container,
model.FilterDto.Status, model.FilterDto.ETDFrom, model.FilterDto.ETDTo);
}
nextPage = await _vesselDepartureService.ListContainerDtoAsync(pageIndex + 1, model.FilterDto.Origin, model.FilterDto.OriginPort, model.FilterDto.Container,
model.FilterDto.Status, model.FilterDto.ETDFrom, model.FilterDto.ETDTo);
if ((model.ResultDtos.Items.Count > 0) && (nextPage.Items.Count > 0))
{
if (SameGroup(model.ResultDtos.Items[model.ResultDtos.Items.Count - 1], nextPage.Items[0]))
{
ViewBag.ToBeContinued = true;
}
}
if ((model.ResultDtos.Items.Count > 0) && (previousPage.Items.Count > 0))
{
if (SameGroup(model.ResultDtos.Items[0], previousPage.Items[previousPage.Items.Count - 1]))
{
ViewBag.ContinuedFromPrevious = true;
}
}
return(PartialView("_Result", model));
}
public async Task <ActionResult> Search(ConfirmArrivalDtos model, string page = null)
{
SetDropDownList();
if (page == null)
{
page = "1";
}
int pageIndex = int.Parse(page);
ViewBag.Page = pageIndex;
model.Containers = new PagedListResult <ConfirmArrivalResultDtos>();
model.Containers = await _CAService.ListContainerFilterAsync(pageIndex, model.FilterDtos.ETAFrom, model.FilterDtos.ETATo, model.FilterDtos.Origin,
model.FilterDtos.Mode, model.FilterDtos.Vendor, model.FilterDtos.Container, model.FilterDtos.Status);
PagedListResult <ConfirmArrivalResultDtos> nextPage = new PagedListResult <ConfirmArrivalResultDtos>();
PagedListResult <ConfirmArrivalResultDtos> previousPage = new PagedListResult <ConfirmArrivalResultDtos>();
previousPage.Items = new List <ConfirmArrivalResultDtos>();
if (pageIndex - 1 > 0)
{
previousPage = await _CAService.ListContainerFilterAsync(pageIndex - 1, model.FilterDtos.ETAFrom, model.FilterDtos.ETATo, model.FilterDtos.Origin,
model.FilterDtos.Mode, model.FilterDtos.Vendor, model.FilterDtos.Container, model.FilterDtos.Status);
}
nextPage = await _CAService.ListContainerFilterAsync(pageIndex + 1, model.FilterDtos.ETAFrom, model.FilterDtos.ETATo, model.FilterDtos.Origin,
model.FilterDtos.Mode, model.FilterDtos.Vendor, model.FilterDtos.Container, model.FilterDtos.Status);
if ((model.Containers.Items.Count > 0) && (nextPage.Items.Count > 0))
{
if (SameGroup(model.Containers.Items[model.Containers.Items.Count - 1], nextPage.Items[0]))
{
ViewBag.ToBeContinued = true;
}
}
if ((model.Containers.Items.Count > 0) && (previousPage.Items.Count > 0))
{
if (SameGroup(model.Containers.Items[0], previousPage.Items[previousPage.Items.Count - 1]))
{
ViewBag.ContinuedFromPrevious = true;
}
}
return(PartialView("_Result", model));
}
