public static IHtmlString PagerInfo(this HtmlHelper helper, PageResult page)
{
var html = "<input type=\"hidden\" class=\"total-pages\" value=\"" + page.TotalPages +
"\" /><input type=\"hidden\" class=\"page-index\" value=\"" + page.PageIndex + "\" />"
+ "<input type=\"hidden\" class=\"page-rows\" value=\"" + page.TotalCount + "\" />";
return helper.Raw(html);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["p"] != null)
PageIndex = Convert.ToInt32(Request["p"]);
else
PageIndex = 1;
//根据categoryid，分类显示列表
object cache = Cache[TableName + condition];
if (cache == null)
{
_DataSource = DataPager.PageState(TableName, PageSize, condition);
Cache.Add(TableName + condition, _DataSource, null, System.Web.Caching.Cache.NoAbsoluteExpiration, new TimeSpan(0, 0, 5), System.Web.Caching.CacheItemPriority.Default, null);
}
else
{
_DataSource = (PageResult)cache;
}
_BaseURL = Request.Url.AbsolutePath + '?';
foreach (var p in Request.QueryString.AllKeys)
{
if (p != "p")
_BaseURL += p + "=" + Request.QueryString[p] + '&';
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["p"] != null)
pageIndex = Convert.ToInt32(Request["p"]);
else
pageIndex = 1;
//根据categoryid，分类显示列表
if (Request["PlanClassifyID"] != null)//&& Request["month"] == "")
{
condition = "StationPlan.IsDelete = 0 and PlanClassifyID = " + Convert.ToInt32(Request["PlanClassifyID"]);
}
else
{
condition = "StationPlan.IsDelete = 0";
}
DataPager p = new ExclusiveDataPager();
result = p.PageData(pageIndex, pageSize, "StationPlan", "*", "StationPlanID", condition, "desc");
GridView1.DataSource = result.Result;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
// FAQList.DataSource = FAQ.GetQuestionCategory(false, Cache);
// FAQList.DataBind();
if (Request["p"] != null)
{
pageIndex = Convert.ToInt32(Request["p"]);
}
else
{
pageIndex = 1;
}
if (Request["OilProjectDirectionID"] != null)
{
condition = "OilProject.IsDelete = 0 and OilProject.Confirm = True and OilProject.OilProjectDirectionID = OilProjectDirection.OilProjectDirectionID and OilProjectDirection.OilProjectDirectionID=" + Convert.ToInt32(Request["OilProjectDirectionID"]);
}
else
{
condition = "OilProject.IsDelete = 0 and OilProject.Confirm = True and OilProject.OilProjectDirectionID = OilProjectDirection.OilProjectDirectionID ";
}
DataPager p = new ExclusiveDataPager();
result_direction = p.PageData(1, 100, "OilProjectDirection", "*", "OilProjectDirectionID", condition_direction, null);
result1 = p.PageData(pageIndex, pageSize, "OilProject,OilProjectDirection", "*", "OilProjectID", condition, "desc");
ProjectList.DataSource = result_direction.Result;
ProjectList.DataBind();
GridView1.DataSource = result1.Result;
GridView1.DataBind();
}
public async Task<HttpResponseMessage> GetProduct(ProductSearch Condition, PageCommand Page = null)
{
var page = Page ?? new PageCommand();
var Query = productRepo.Find(t => t.Input_Date >= Condition.Start, t => t.skus);
if (Condition.Brands != null && Condition.Brands.Count != 0)
Query = Query.Where(t => Condition.Brands.Contains(t.Brand));
if (Condition.End.HasValue)
Query = Query.Where(t => t.Input_Date <= Condition.End.Value);
try
{
var List = await Task.Factory.StartNew(() => Query.OrderBy(t => 1).AsNoTracking().ToPagedList(page.PageIndex, page.PageSize));
var Result = new PageResult<product>()
{
PageIndex = List.PageNumber,
PageSize = List.PageSize,
TotalItem = List.TotalItemCount,
TotalPage = List.PageCount,
PageList = List.Select(t => t.Convert())
};
return Request.CreateResponse(HttpStatusCode.OK, Result);
}
catch (Exception ex)
{
return Request.CreateResponse(HttpStatusCode.InternalServerError, new OperationResult() { err_code = ErrorEnum.sys_error, err_info = ex.Message });
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["p"] != null)
pageIndex = Convert.ToInt32(Request["p"]);
else
pageIndex = 1;
//根据categoryid，分类显示列表
if (Request["categoryid"] != null)//&& Request["month"] == "")
{
condition = "NewsCategoryID = " + Convert.ToInt32(Request["categoryid"]);
}
// 根据年份与月份显示
if (Request["NewsYear"] != null && Request["month"] == "")
{
condition = "NewsYear = " + Convert.ToInt32(Request["NewsYear"]);
}
if (Request["NewsYear"] != null && Request["month"] != "")
{
condition = "NewsYear = " + Convert.ToInt32(Request["NewsYear"]) + "And NewsMonth= " + Convert.ToInt32(Request["month"]);
}
DataPager p = new ExclusiveDataPager();
result = p.PageData(pageIndex, pageSize, "News", "*", "NewsID", condition, "desc");
GridView1.DataSource = result.Result;
GridView1.DataBind();
}
public PageResult<string> GetResult(int page, FieldCriteria[] criterias)
{
var provider = new DbDataProvider();
var result = new PageResult<string>();
result.TotalCount = Convert.ToInt32(provider.Count(criterias));
result.PageCount = result.TotalCount / pageSize + 1;
result.Page = page;
result.Result = provider.GetEntitiesId(page, pageSize, criterias);
return result;
}
private PageResult GetPageResult(string pagina)
{
var date = Regex.Match(pagina, @"<date>(\d+)</date>");
var number = Regex.Match(pagina, @"<td>Laat</td> <td class=""numeric last"">(\d+,\d+)</td>");
var pageResult = new PageResult();
if (date.Groups.Count == 2)
{
pageResult.Date = date.Groups[1].Value;
}
if (number.Groups.Count == 2)
{
pageResult.Price = number.Groups[1].Value;
}
return pageResult;
}
protected void Page_Load(object sender, EventArgs e)
{
XmlDocument document = new XmlDocument();
document.Load(Server.MapPath("~/Footer.xml"));
// picture = ResolveUrl(document.DocumentElement.SelectSingleNode("picture").InnerText);
if (Request["newsId"] != null)
{
newsFrame = "NewsContent.aspx?newsid=" + Request["newsId"];
}
else
{
newsFrame = "NewsTempate.aspx";
}
//新闻列表更新
if (Request["p"] != null)
pageIndex = Convert.ToInt32(Request["p"]);
else
pageIndex = 1;
//根据categoryid，分类显示列表
if (Request["categoryid"] != null)//&& Request["month"] == "")
{
condition += " and NewsCategoryID = " + Convert.ToInt32(Request["categoryid"]);
}
// 根据年份与月份显示
if (Request["NewsYear"] != null && Request["month"] == "")
{
condition += " and NewsYear = " + Convert.ToInt32(Request["NewsYear"]);
}
if (Request["NewsYear"] != null && Request["month"] != "")
{
condition += " and NewsYear = " + Convert.ToInt32(Request["NewsYear"]) + "And NewsMonth= " + Convert.ToInt32(Request["month"]);
}
DataPager p = new ExclusiveDataPager();
result = p.PageData(pageIndex, pageSize, "News", "*", "NewsID", condition, "desc");
GridView1.DataSource = result.Result;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
// FAQList.DataSource = FAQ.GetQuestionCategory(false, Cache);
// FAQList.DataBind();
if (Request["p"] != null)
{
pageIndex = Convert.ToInt32(Request["p"]);
i = (Convert.ToInt32(Request["p"]) - 1) * 7 + 1;
}
else
{
pageIndex = 1;
i = 1;
}
DataPager p = new ExclusiveDataPager();
result = p.PageData(pageIndex, pageSize, "FAQ", "*", "FAQID", condition, "desc");
FAQList.DataSource = result.Result;
FAQList.DataBind();
}
public PageResult<CharterOut> GetByFilter(long companyId, int pageSize, int pageIndex)
{
var res = new PageResult<CharterOut>();
var strategy = new ListFetchStrategy<Charter>(Enums.FetchInUnitOfWorkOption.NoTracking);
IQueryable<CharterOut> query = this.GetAll(strategy).OfType<CharterOut>().OrderBy(p => p.Id)
.Where(c => c.OwnerId == companyId && c.CharterType == CharterType.Start).AsQueryable();
res.Result = query.Skip(pageSize * (pageIndex - 1))
.Take(pageSize).ToList();
res.TotalCount = query.Count();
res.TotalPages = Convert.ToInt32(Math.Ceiling(decimal.Divide(res.TotalCount, pageSize)));
res.CurrentPage = pageIndex + 1;
return res;
}
protected void Page_Load(object sender, EventArgs e)
{
// XmlDocument document = new XmlDocument();
// document.Load(Server.MapPath("~/Footer.xml"));
// picture = ResolveUrl(document.DocumentElement.SelectSingleNode("picture").InnerText);
if (Request["p"] != null)
{
pageIndex = Convert.ToInt32(Request["p"]);
}
else
{
pageIndex = 1;
}
if (Request["NewRecruitsCategoryID"] != null)
{
condition = "NewRecruits.IsDelete = 0 and NewRecruits.NewRecruitsCategoryID = NewRecruitsCategory.NewRecruitsCategoryID and NewRecruits.OilProjectDirectionID = OilProjectDirection.OilProjectDirectionID and NewRecruitsCategory.NewRecruitsCategoryID=" + Convert.ToInt32(Request["NewRecruitsCategoryID"]);
}
else if (Request["OilProjectDirectionID"] != null)
{
condition = "NewRecruits.IsDelete = 0 and NewRecruits.NewRecruitsCategoryID = NewRecruitsCategory.NewRecruitsCategoryID and NewRecruits.OilProjectDirectionID = OilProjectDirection.OilProjectDirectionID and NewRecruits.OilProjectDirectionID=" + Convert.ToInt32(Request["OilProjectDirectionID"]);
}else
{
condition = "NewRecruits.IsDelete = 0 and NewRecruits.NewRecruitsCategoryID = NewRecruitsCategory.NewRecruitsCategoryID and NewRecruits.OilProjectDirectionID = OilProjectDirection.OilProjectDirectionID";
}
DataPager p = new ExclusiveDataPager();
result_category = p.PageData(1, 100, "NewRecruitsCategory", "*", "NewRecruitsCategoryID", condition_category, "asc");
// result_direction = p.PageData(1, 10, "OilProjectDirectionTitle", "*", "OilProjectDirectionID", condition_direction, "asc");
result1 = p.PageData(pageIndex, pageSize, "NewRecruits,NewRecruitsCategory,OilProjectDirection", "*", "NewRecruitsID", condition, "asc");
NewRecruitsList.DataSource = result_category.Result;
// OilProjectList.DataSource = result_direction.Result;
NewRecruitsList.DataBind();
// OilProjectList.DataBind();
GridView1.DataSource = result1.Result;
GridView1.DataBind();
}
//not completed
/// <summary>
/// 查询分页状态，如总页数、总记录条数。一般由.net进行缓存优化效率。
/// </summary>
/// <param name="table">数据库表</param>
/// <param name="pageSize">页大小</param>
/// <param name="condition">附加的查询条件</param>
/// <returns></returns>
public static PageResult PageState(string table,int pageSize, string condition)
{
PageResult pr = new PageResult()
{
PageIndex = -1,
Result = null,
PageSize = pageSize,
TotalPage = 0,
TotalRow = 0
};
string sql = "select count(*) from {0} {1}";
sql = string.Format(sql,
table,
condition == null ? "" : "where " + condition);
DbDataReader r = DBHelper.INST.ExecuteSqlDR(sql);
r.Read();
pr.TotalRow = r.GetInt32(0);
pr.TotalPage = pr.TotalRow % pr.PageSize == 0 ? pr.TotalRow / pr.PageSize : pr.TotalRow / pr.PageSize + 1;
return pr;
}
public void WriteObjectInline_Sets_InlineCount_OnWriteStart()
{
// Arrange
Mock<ODataEntrySerializer> customerSerializer = new Mock<ODataEntrySerializer>(_customersType.ElementType(), ODataPayloadKind.Entry);
ODataSerializerProvider provider = ODataTestUtil.GetMockODataSerializerProvider(customerSerializer.Object);
var mockWriter = new Mock<ODataWriter>();
Uri expectedNextLink = new Uri("http://nextlink.com");
long expectedInlineCount = 1000;
var result = new PageResult<Customer>(_customers, expectedNextLink, expectedInlineCount);
mockWriter
.Setup(m => m.WriteStart(It.Is<ODataFeed>(feed => feed.Count == expectedInlineCount)))
.Verifiable();
_serializer = new ODataFeedSerializer(_customersType, provider);
// Act
_serializer.WriteObjectInline(result, mockWriter.Object, _writeContext);
// Assert
mockWriter.Verify();
}
protected void Page_Load(object sender, EventArgs e)
{
// FAQList.DataSource = FAQ.GetQuestionCategory(false, Cache);
// FAQList.DataBind();
if (Request["p"] != null)
{
pageIndex = Convert.ToInt32(Request["p"]);
}
else
{
pageIndex = 1;
}
if (Request["ProjectID"] != null)//&& Request["month"] == "")
{
condition = "ProjectID = " + Convert.ToInt32(Request["ProjectID"]);
}
DataPager p = new ExclusiveDataPager();
result = p.PageData(pageIndex, pageSize, "NewRecruits", "*", "NewRecruitsID", condition, "desc");
NewRecruitsList.DataSource = result.Result;
NewRecruitsList.DataBind();
}
public void Does_replace_bindings()
{
var context = new TemplateContext
{
Args =
{
["contextTitle"] = "The title",
["contextPartial"] = "bind-partial",
["contextTag"] = "h2",
["a"] = "foo",
["b"] = "bar",
}
}.Init();
context.VirtualFiles.WriteFile("_layout.html", @"
<html>
<title>{{ title }}</title>
</head>
<body>
{{ contextPartial | partial({ title: contextTitle, tag: contextTag, items: [a,b] }) }}
{{ page }}
</body>");
context.VirtualFiles.WriteFile("bind-partial.html", @"
<{{ tag }}>{{ title | upper }}</{{ tag }}>
<p>{{ items | join(', ') }}</p>");
context.VirtualFiles.WriteFile("bind-page.html", @"
<section>
{{ pagePartial | partial({ tag: pageTag, items: items }) }}
</section>
");
var result = new PageResult(context.GetPage("bind-page"))
{
Args =
{
["title"] = "Page title",
["pagePartial"] = "bind-partial",
["pageTag"] = "h3",
["items"] = new[] { 1, 2, 3 },
}
}.Result;
Assert.That(result.NormalizeNewLines(), Is.EqualTo(@"
<html>
<title>Page title</title>
</head>
<body>
<h2>THE TITLE</h2>
<p>foo, bar</p>
<section>
<h3>PAGE TITLE</h3>
<p>1, 2, 3</p>
</section>
</body>
".NormalizeNewLines()));
}
/// <summary>
/// 查询工作联系单
/// </summary>
/// <param name="loginName"></param>
/// <param name="authority"></param>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <param name="orderBy"></param>
/// <param name="keyword"></param>
/// <param name="ContactDeper"></param>
/// <param name="ContactName"></param>
/// <param name="ContactDate"></param>
/// <returns></returns>
public PageResult GetWorkContactPageResult(string loginName, string UserName, string authority, int page, int rows, string orderBy, string keyword, string ContactDeper, string ContactConten, string startDate, string EndDate, string Type = "")
{
PageResult result = new PageResult();
try
{
PageInfo pageInfo = new PageInfo();
pageInfo.CurrentPageIndex = page;
pageInfo.PageSize = rows;
pageInfo.QueryFields = "*";
pageInfo.Orderby = orderBy;
if (Type == "2")
{
pageInfo.TableName = "View_ContactReply";
}
else
{
pageInfo.TableName = "TblContact";
}
StringBuilder strSql = new StringBuilder("1=1");
if (!string.IsNullOrEmpty(Type))
{
if (Type == "0")
{
strSql.AppendFormat(" and (State ='{0}' or State is NULL) and CreateName='{1}'", Type, UserName);
}
else if (Type == "1")
{
strSql.AppendFormat(" and State ='{0}' and (CreateName='{1}')", Type, UserName);
}
else if (Type == "2")
{
strSql.AppendFormat(" and (LoginName = '{0}')", loginName);
}
}
//if (!string.IsNullOrEmpty(ContactDeper))
//{
// strSql.AppendFormat(" and CreateNameDeper like '%" + ContactDeper + "%'");
//}
if (!string.IsNullOrEmpty(ContactConten))
{
strSql.AppendFormat(" and ContactConten like '%" + ContactConten + "%'");
}
if ((!string.IsNullOrEmpty(startDate)))
{
strSql.AppendFormat(" and ContactDate >='{0}' ", startDate);
}
if ((!string.IsNullOrEmpty(EndDate)))
{
strSql.AppendFormat(" and ContactDate <='{0}' ", EndDate);
}
pageInfo.Where = strSql.ToString();
//查询数据
if (Type == "2")
{
result = CommonHelper.ListPageResult <Bitshare.PTMM.Model.View_ContactReply>(pageInfo);
}
else
{
result = CommonHelper.ListPageResult <Bitshare.PTMM.Model.TblContact>(pageInfo);
}
}
catch (Exception ex)
{
LogManager.Error("GetWorkContactPageResult()", ex);
}
return(result);
}
void bindData()
{
if (Request["p"] != null)
pageIndex = Convert.ToInt32(Request["p"]);
else
pageIndex = 1;
DataPager p = new ExclusiveDataPager();
result = p.PageData(pageIndex, pageSize, "FAQ", "*", "FAQID", null, "desc");
GridView1.DataSource = result.Result;
GridView1.DataKeyNames = new string[] { "FAQID" };
GridView1.DataBind();
}
/// <summary>
/// Search Scheduled Student For Group Drop
/// </summary>
/// <param name="scheduleStudentListViewModel"></param>
/// <returns></returns>
public ScheduleStudentListViewModel SearchScheduledStudentForGroupDrop(PageResult pageResult)
{
ScheduleStudentListViewModel scheduleStudentListView = new ScheduleStudentListViewModel();
IQueryable <ScheduleStudentForView> transactionIQ = null;
try
{
var scheduledStudentData = this.context?.StudentCoursesectionSchedule.
Join(this.context?.StudentMaster,
scs => scs.StudentId, sm => sm.StudentId,
(scs, sm) => new { scs, sm }).Where(c => c.scs.TenantId == pageResult.TenantId && c.scs.SchoolId == pageResult.SchoolId && c.scs.CourseSectionId == pageResult.CourseSectionId && c.sm.SchoolId == pageResult.SchoolId && c.sm.TenantId == pageResult.TenantId).ToList().Select(ssv => new ScheduleStudentForView
{
SchoolId = ssv.sm.SchoolId,
TenantId = ssv.sm.TenantId,
StudentId = ssv.sm.StudentId,
FirstGivenName = ssv.sm.FirstGivenName,
LastFamilyName = ssv.sm.LastFamilyName,
AlternateId = ssv.sm.AlternateId,
StudentInternalId = ssv.sm.StudentInternalId,
GradeLevel = this.context.Gradelevels.FirstOrDefault(c => c.TenantId == ssv.sm.TenantId && c.SchoolId == ssv.sm.SchoolId && c.GradeId == ssv.scs.GradeId)?.Title,
Section = this.context.Sections.FirstOrDefault(c => c.TenantId == ssv.sm.TenantId && c.SchoolId == ssv.sm.SchoolId && c.SectionId == ssv.sm.SectionId)?.Name,
PhoneNumber = ssv.sm.MobilePhone,
Action = ssv.scs.IsDropped,
ScheduleDate = ssv.scs.CreatedOn,
StudentPhoto = (pageResult.ProfilePhoto == true)?ssv.sm.StudentPhoto:null
}).ToList();
if (scheduledStudentData.Count > 0)
{
if (pageResult.FilterParams == null || pageResult.FilterParams.Count == 0)
{
transactionIQ = scheduledStudentData.AsQueryable();
}
else
{
if (pageResult.FilterParams != null && pageResult.FilterParams.ElementAt(0).ColumnName == null && pageResult.FilterParams.Count == 1)
{
string Columnvalue = pageResult.FilterParams.ElementAt(0).FilterValue;
transactionIQ = scheduledStudentData.Where(x => x.FirstGivenName.ToLower().Contains(Columnvalue.ToLower()) || x.LastFamilyName.ToLower().Contains(Columnvalue.ToLower()) || x.GradeLevel.ToLower().Contains(Columnvalue.ToLower()) || x.ScheduleDate.ToString() == Columnvalue).AsQueryable();
}
else
{
transactionIQ = Utility.FilteredData(pageResult.FilterParams, scheduledStudentData).AsQueryable();
}
transactionIQ = transactionIQ.Distinct();
}
if (pageResult.SortingModel != null)
{
switch (pageResult.SortingModel.SortColumn.ToLower())
{
default:
transactionIQ = Utility.Sort(transactionIQ, pageResult.SortingModel.SortColumn, pageResult.SortingModel.SortDirection.ToLower());
break;
}
}
int totalCount = transactionIQ.Count();
if (pageResult.PageNumber > 0 && pageResult.PageSize > 0)
{
transactionIQ = transactionIQ.Skip((pageResult.PageNumber - 1) * pageResult.PageSize).Take(pageResult.PageSize);
}
scheduleStudentListView.scheduleStudentForView = transactionIQ.ToList();
scheduleStudentListView.TotalCount = totalCount;
}
else
{
scheduleStudentListView.scheduleStudentForView = scheduledStudentData;
scheduleStudentListView._failure = false;
scheduleStudentListView._message = NORECORDFOUND;
}
scheduleStudentListView.TenantId = pageResult.TenantId;
scheduleStudentListView.SchoolId = pageResult.SchoolId;
scheduleStudentListView.CourseSectionId = pageResult.CourseSectionId;
scheduleStudentListView.PageNumber = pageResult.PageNumber;
scheduleStudentListView._pageSize = pageResult.PageSize;
scheduleStudentListView._tenantName = pageResult._tenantName;
scheduleStudentListView._token = pageResult._token;
scheduleStudentListView._failure = false;
}
catch (Exception es)
{
scheduleStudentListView._failure = true;
scheduleStudentListView._message = es.Message;;
}
return(scheduleStudentListView);
}
//================================================================================
private PageResultDto<OffhireDto> mapPageResult(PageResult<Offhire> pageResult)
{
return new PageResultDto<OffhireDto>()
{
CurrentPage = pageResult.CurrentPage,
PageSize = pageResult.PageSize,
TotalCount = pageResult.TotalCount,
TotalPages = pageResult.TotalPages,
Result = offhireDtoMapper.MapToModel(pageResult.Result, this.setEditProperties).ToList()
};
}
public object Any(FreeDbMatchSearch request)
{
var sp = Stopwatch.StartNew();
var returnValue = new PageResult<List<Disk>>();
var results =
Client().Search<Disk>(
i =>
i.Index("disk")
.Skip((request.Offset) * request.Limit)
.Take(request.Limit)
.Query(q => q.Match(m => m.OnField(p => p.Artist).Query(request.Artist)) && q.Match(m => m.OnField(p => p.Genre).Query(request.Genre)))
.Aggregations((a => a.Terms("genre.raw", t => t.Field("genre.raw").Size(20)))));
returnValue.TimeElapsed = sp.Elapsed.TotalSeconds;
returnValue.CurrentPage = (request.Offset == 0) ? 1 : request.Offset;
returnValue.Result = results.Documents.ToList();
returnValue.ItemCount = results.Documents.Count();
returnValue.TotalItems = results.Total;
returnValue.TotalPages = (int)Math.Ceiling((double)results.Total / request.Limit);
return returnValue;
}
public ActionResult <ScheduleStudentListViewModel> SearchScheduledStudentForGroupDrop(PageResult pageResult)
{
ScheduleStudentListViewModel ScheduledStudentListView = new ScheduleStudentListViewModel();
try
{
ScheduledStudentListView = _studentScheduleService.SearchScheduledStudentForGroupDrop(pageResult);
}
catch (Exception es)
{
ScheduledStudentListView._failure = true;
ScheduledStudentListView._message = es.Message;
}
return(ScheduledStudentListView);
}
public void PageModelActionTester_TestPage_should_return_PageResult()
{
PageResult PageResult = _pageTester.Action(x => x.OnGet).TestPage();
Assert.IsNotNull(PageResult);
}
/// <summary>
/// 获取当前用户的视频列表 用于分页
/// </summary>
/// <param name="condtions"></param>
/// <param name="orderCondtions"></param>
/// <returns></returns>
public PageResult GetUserVideoList(int userId, IList <Condtion> condtions, IList <OrderCondtion> orderCondtions)
{
var videos = from v in _videoRepository.GetEntityList(CondtionEqualCreateManageId(userId))
where v.VideoState == 3
select new VideoView()
{
IsHot = v.IsHot,
IsRecommend = v.IsRecommend,
PlayCount = v.PlayCount,
About = v.About,
BigPicturePath = v.BigPicturePath,
CreateTime = v.CreateTime,
UpdateTime = v.UpdateTime ?? v.CreateTime,
Director = v.Director,
Id = v.Id,
IsOfficial = v.IsOfficial,
SmallPicturePath = v.SmallPicturePath,
Starring = v.Starring,
Tags = v.Tags,
Title = v.Title,
Filter = v.Filter
};
if (condtions != null && condtions.Count() > 0)
{
videos = videos.Query <VideoView>(condtions);
}
if (orderCondtions != null && orderCondtions.Count() > 0)
{
videos = videos.OrderBy <VideoView>(orderCondtions);
}
int totalCount = videos.Count();
int pageCount = 0;
if (this.PageSize > 0)
{
pageCount = totalCount % this.PageSize == 0
? (totalCount / this.PageSize)
: (totalCount / this.PageSize + 1);
if (this.PageIndex <= 0)
{
this.PageIndex = 1;
}
if (this.PageIndex >= pageCount)
{
this.PageIndex = pageCount;
}
videos = videos.Skip <VideoView>((this.PageIndex - 1) * this.PageSize).Take <VideoView>(this.PageSize);
}
var result = new PageResult()
{
PageSize = this.PageSize,
PageIndex = this.PageIndex,
TotalCount = totalCount,
TotalIndex = pageCount,
Data = videos.ToList()
};
return(result);
}
/// <summary>
/// Create the <see cref="ODataResourceSet"/> to be written for the given resourceSet instance.
/// </summary>
/// <param name="resourceSetInstance">The instance representing the resourceSet being written.</param>
/// <param name="resourceSetType">The EDM type of the resourceSet being written.</param>
/// <param name="writeContext">The serializer context.</param>
/// <returns>The created <see cref="ODataResourceSet"/> object.</returns>
public virtual ODataResourceSet CreateResourceSet(IEnumerable resourceSetInstance, IEdmCollectionTypeReference resourceSetType,
ODataSerializerContext writeContext)
{
ODataResourceSet resourceSet = new ODataResourceSet
{
TypeName = resourceSetType.FullName()
};
IEdmStructuredTypeReference structuredType = GetResourceType(resourceSetType).AsStructured();
if (writeContext.NavigationSource != null && structuredType.IsEntity())
{
ResourceSetContext resourceSetContext = new ResourceSetContext
{
Request = writeContext.Request,
Context = writeContext.Context,
EntitySetBase = writeContext.NavigationSource as IEdmEntitySetBase,
Url = writeContext.Url,
ResourceSetInstance = resourceSetInstance
};
IEdmEntityType entityType = structuredType.AsEntity().EntityDefinition();
var operations = writeContext.Model.GetAvailableOperationsBoundToCollection(entityType);
var odataOperations = CreateODataOperations(operations, resourceSetContext, writeContext);
foreach (var odataOperation in odataOperations)
{
ODataAction action = odataOperation as ODataAction;
if (action != null)
{
resourceSet.AddAction(action);
}
else
{
resourceSet.AddFunction((ODataFunction)odataOperation);
}
}
}
if (writeContext.ExpandedResource == null)
{
// If we have more OData format specific information apply it now, only if we are the root feed.
PageResult odataResourceSetAnnotations = resourceSetInstance as PageResult;
if (odataResourceSetAnnotations != null)
{
resourceSet.Count = odataResourceSetAnnotations.Count;
resourceSet.NextPageLink = odataResourceSetAnnotations.NextPageLink;
}
else if (writeContext.Request != null)
{
resourceSet.NextPageLink = writeContext.Context.ODataFeature().NextLink;
long?countValue = writeContext.Context.ODataFeature().TotalCount;
if (countValue.HasValue)
{
resourceSet.Count = countValue.Value;
}
}
}
else
{
// nested resourceSet
ITruncatedCollection truncatedCollection = resourceSetInstance as ITruncatedCollection;
if (truncatedCollection != null && truncatedCollection.IsTruncated)
{
resourceSet.NextPageLink = GetNestedNextPageLink(writeContext, truncatedCollection.PageSize);
}
ICountOptionCollection countOptionCollection = resourceSetInstance as ICountOptionCollection;
if (countOptionCollection != null && countOptionCollection.TotalCount != null)
{
resourceSet.Count = countOptionCollection.TotalCount;
}
}
return(resourceSet);
}
void bindData()
{
if (Request["p"] != null)
pageIndex = Convert.ToInt32(Request["p"]);
else
pageIndex = 1;
DataPager p = new ExclusiveDataPager();
result = p.PageData(pageIndex, pageSize, "CooperationEnterprises", "*", "EnterprisesID", null, "asc");
string dsStr = "select * from CooperationEnterprises where IsDelete=" + 0;
DataSet ds = DBHelper.INST.ExecuteSqlDS(dsStr);
GridView1.DataSource = ds;//result1.Result;
GridView1.DataBind();
ds.Dispose();
/*
GridView1.DataSource = result.Result;
GridView1.DataKeyNames = new string[] { "EnterprisesID" };
GridView1.DataBind();
*/
}
public async Task <IActionResult> GetPage(string url)
{
PageResult result = await _mediatr.Send(new GetPageQuery(url));
return(HandleResult(result, result.Page));
}
public PageResult<ProductInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize)
{
PageResult<ProductInfo> result = new PageResult<ProductInfo>();
int skip = (pageNumber - 1) * pageSize;
int take = pageSize;
List<ProductInfo> list = null;
using (var DbContext = new MRPDbContext())
{
var query = from i in DbContext.Product
join p in DbContext.ProductCatalog on i.ProductCatalogId equals p.Id
select new ProductInfo()
{
Id = i.Id,
ProductCode = i.ProductCode,
ProductName = i.ProductName,
ProductCatalogName = p.ProductCatalogName,
ProductCatalogId = i.ProductCatalogId,
ImageUrl = i.ImageUrl,
SearchKey = i.SearchKey,
Special = i.Special,
Size = i.Size,
MinStock = i.MinStock,
Stock = i.Stock,
MaxStock = i.MaxStock,
Texture = i.Texture,
Color = i.Color,
UnitId = i.UnitId,
SYS_IsValid = i.SYS_IsValid,
SYS_OrderSeq = i.SYS_OrderSeq,
SYS_AppId = i.SYS_AppId,
SYS_StaffId = i.SYS_StaffId,
SYS_StationId = i.SYS_StationId,
SYS_DepartmentId = i.SYS_DepartmentId,
SYS_CompanyId = i.SYS_CompanyId,
SYS_CreateTime = i.SYS_CreateTime
};
#region 条件
foreach (string key in searchCondtionCollection)
{
string condition = searchCondtionCollection[key];
switch (key.ToLower())
{
case "productname":
query = query.Where(x => x.ProductName.Contains(condition));
break;
case "productcatalogid":
query = query.Where(x => x.ProductCatalogId.Equals(condition));
break;
case "searchkey":
query = query.Where(x => x.SearchKey.Equals(condition));
break;
case "isvalid":
int value = Convert.ToInt32(condition);
query = query.Where(x => x.SYS_IsValid.Equals(value));
break;
default:
break;
}
}
#endregion
result.TotalRecords = query.Count();
#region 排序
foreach (string sort in sortCollection)
{
string direct = sortCollection[sort];
switch (sort.ToLower())
{
case "createtime":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
break;
case "productname":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => x.ProductName).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => x.ProductName).Skip(skip).Take(take);
}
break;
default:
query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take);
break;
}
}
#endregion
list = query.ToList();
}
result.PageSize = pageSize;
result.PageNumber = pageNumber;
result.Data = list;
return result;
}
public async Task <object> Any(ApiPages request)
{
if (string.IsNullOrEmpty(request.PageName))
{
throw new ArgumentNullException(nameof(request.PageName));
}
var parts = string.IsNullOrEmpty(request.PathInfo)
? TypeConstants.EmptyStringArray
: request.PathInfo.SplitOnLast('.');
var hasPathContentType = parts.Length > 1 && Host.ContentTypes.KnownFormats.Contains(parts[1]);
var pathInfo = hasPathContentType
? parts[0]
: request.PathInfo;
var pathArgs = string.IsNullOrEmpty(pathInfo)
? TypeConstants.EmptyStringArray
: pathInfo.Split('/');
parts = request.PageName.SplitOnLast('.');
var hasPageContentType = pathArgs.Length == 0 && parts.Length > 1 && Host.ContentTypes.KnownFormats.Contains(parts[1]);
var pageName = hasPageContentType
? parts[0]
: request.PageName;
// Change .csv download file name
base.Request.OperationName = pageName + (pathArgs.Length > 0 ? "_" + string.Join("_", pathArgs) : "");
var feature = HostContext.GetPlugin <TemplatePagesFeature>();
if (feature.ApiDefaultContentType != null &&
!hasPathContentType &&
!hasPageContentType &&
base.Request.QueryString[TemplateConstants.Format] == null && base.Request.ResponseContentType == MimeTypes.Html)
{
base.Request.ResponseContentType = feature.ApiDefaultContentType;
}
var pagePath = feature.ApiPath.CombineWith(pageName).TrimStart('/');
var page = base.Request.GetPage(pagePath);
if (page == null)
{
throw HttpError.NotFound($"No API Page was found at '{pagePath}'");
}
var requestArgs = base.Request.GetTemplateRequestParams();
requestArgs[TemplateConstants.PathInfo] = request.PathInfo;
requestArgs[TemplateConstants.PathArgs] = pathArgs;
var pageResult = new PageResult(page)
{
NoLayout = true,
RethrowExceptions = true,
Args = requestArgs
};
var discardedOutput = await pageResult.RenderToStringAsync();
if (!pageResult.Args.TryGetValue(TemplateConstants.Return, out var response))
{
throw HttpError.NotFound($"The API Page did not specify a response. Use the 'return' filter to set a return value for the page.");
}
if (response is Task <object> responseTask)
{
response = await responseTask;
}
if (response is IRawString raw)
{
response = raw.ToRawString();
}
var httpResult = ToHttpResult(pageResult, response);
return(httpResult);
}
public override async Task <PageResult <CompanyNewsDto> > Handle(GetCompanyNewsCommand request, CancellationToken cancellationToken)
{
var sb = new List <string>();
if (request.Id != 0)
{
sb.Add($"Id = {request.Id}");
}
if (request.Show.HasValue)
{
sb.Add($"Show = " + (request.Show.Value ? 1 : 0));
}
if (request.Status != -999)
{
sb.Add($"Status = " + request.Status);
}
if (request.CompanyId != 0)
{
sb.Add($"CompanyId = " + request.CompanyId);
}
if (!string.IsNullOrWhiteSpace(request.CompanyTypeId))
{
sb.Add($"CompanyTypeId = " + request.CompanyTypeId);
}
if (request.LoginUser != null && request.LoginUser.Type == 2)
{
sb.Add($"UserId = " + request.LoginUser.Id);
}
var where = string.Join(" and ", sb);
var pageData = await _companyNewsRepository.GetPageDataAsync <Domain.CompanyAggregate.CompanyNews>(
pageIndex : request.PageIndex,
pageSize : request.PageSize,
where : where,
order : "Status asc,Sort asc,Id desc"
);
var count = pageData.Total;
if (count < 1)
{
return(PageResult <CompanyNewsDto> .Success(null, count, request.PageIndex, request.PageSize, request.LinkUrl));
}
var types = await _companyTypeRepository.Set().ToListAsync();
var companyId_arr = pageData.Data.Select(x => x.CompanyId);
var companys = _companyRepository.Set().Where(x => companyId_arr.Contains(x.Id));
var data = pageData.Data.Select(x =>
new CompanyNewsDto()
{
CompanyId = x.CompanyId,
CompanyName = companys.FirstOrDefault(c => c.Id == x.CompanyId)?.Name,
Id = x.Id,
CompanyTypeId = x.CompanyTypeId,
Contact = x.Contact,
CooperationContent = x.CooperationContent,
Introduce = x.Introduce,
IntroduceImage = x.IntroduceImage,
MainBusiness = x.MainBusiness,
Show = x.Show,
Sort = x.Sort,
Status = x.Status,
Title = x.Title,
CreatedTime = x.CreatedTime,
UpdatedTime = x.UpdatedTime
}
);;
return(PageResult <CompanyNewsDto> .Success(data, count, request.PageIndex, request.PageSize, request.LinkUrl));
}
public PageResult<StaffInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize)
{
PageResult<StaffInfo> result = new PageResult<StaffInfo>();
int skip = (pageNumber - 1) * pageSize;
int take = pageSize;
List<StaffInfo> list = null;
using (var DbContext = new UCDbContext())
{
var query = from i in DbContext.Staff
join d in DbContext.Department on i.DepartmentId equals d.Id
join c in DbContext.Company on d.CompanyId equals c.Id
select new StaffInfo()
{
Id = i.Id,
UserCode = i.UserCode,
UserName = i.UserName,
Sex = i.Sex,
Mobile = i.Mobile,
DepartmentId = i.DepartmentId,
DepartmentName = d.DepartmentName,
CompanyId = d.CompanyId,
CompanyName = c.CompanyName,
SYS_IsValid = i.SYS_IsValid,
SYS_OrderSeq = i.SYS_OrderSeq,
SYS_AppId = i.SYS_AppId,
SYS_StaffId = i.SYS_StaffId,
SYS_StationId = i.SYS_StationId,
SYS_DepartmentId = i.SYS_DepartmentId,
SYS_CompanyId = i.SYS_CompanyId,
SYS_CreateTime = i.SYS_CreateTime
};
#region 条件
foreach (string key in searchCondtionCollection)
{
string condition = searchCondtionCollection[key];
switch (key.ToLower())
{
case "username":
query = query.Where(x => x.UserName.Contains(condition));
break;
case "departmentid":
query = query.Where(x => x.DepartmentId.Equals(condition));
break;
case "companyid":
query = query.Where(x => x.CompanyId.Equals(condition));
break;
case "isvalid":
int value = Convert.ToInt32(condition);
query = query.Where(x => x.SYS_IsValid.Equals(value));
break;
default:
break;
}
}
#endregion
result.TotalRecords = query.Count();
#region 排序
foreach (string sort in sortCollection)
{
string direct = sortCollection[sort];
switch (sort.ToLower())
{
case "createtime":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
break;
case "username":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => x.CompanyName).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => x.CompanyName).Skip(skip).Take(take);
}
break;
default:
query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take);
break;
}
}
#endregion
list = query.ToList();
}
result.PageSize = pageSize;
result.PageNumber = pageNumber;
result.Data = list;
return result;
}
/// <summary>
/// Ctor: init immutable instance.
/// </summary>
public IndexModel(PageResult pr, string gaCode)
{
PR = pr;
GACode = gaCode;
}
public void CreateODataFeed_Sets_NextPageLinkForPageResult()
{
// Arrange
ODataFeedSerializer serializer = new ODataFeedSerializer(new DefaultODataSerializerProvider());
Uri expectedNextLink = new Uri("http://nextlink.com");
const long ExpectedCountValue = 1000;
var result = new PageResult<Customer>(_customers, expectedNextLink, ExpectedCountValue);
// Act
ODataFeed feed = serializer.CreateODataFeed(result, _customersType, new ODataSerializerContext());
// Assert
Assert.Equal(expectedNextLink, feed.NextPageLink);
}
private PageResult GetPageResultData(PageResult pageParams)
{
#region 判断是否进行全部查询
string deleteFlag = ui.UiData.Crud.DeleteFlag;
var formParam = pdata.GetSelectParamFieldValue(this.Request.Form);
if (!string.IsNullOrWhiteSpace(deleteFlag))
{
if (formParam.ContainsKey(deleteFlag))
{
formParam[deleteFlag] = this.hiddenIsSearchAllInfo.Value;
}
else
{
formParam.Add(deleteFlag, this.hiddenIsSearchAllInfo.Value);
}
if (string.IsNullOrWhiteSpace(this.hiddenIsSearchAllInfo.Value.ToString()))
{
formParam.Remove(deleteFlag);
}
}
#endregion
#region 根据URL传递的参数进行查询
foreach (string name in this.Request.QueryString.AllKeys)
{
if (string.IsNullOrWhiteSpace(name))
{
continue;
}
string value = this.Request.QueryString[name];
bool isExeits = false;
string key = string.Empty;
foreach (KeyValuePair <string, object> keyvalue in formParam)
{
if (keyvalue.Key.Equals(name, StringComparison.CurrentCultureIgnoreCase))
{
key = keyvalue.Key;
formParam[key] = value;
isExeits = true;
break;
}
}
if (!isExeits)
{
key = name;
formParam.Add(key, value);
}
if (string.IsNullOrWhiteSpace(value))
{
formParam.Remove(key);
}
}
#endregion
#region 扩展功能
var commandParam = getCommandParam(ui.Select, formParam);
if (ExecuteCommands(commandParam).isBreak)
{
return(null);
}
#endregion
pageParams.ParameterObject = formParam;
return(manager.GetPageDataByReader(pageParams));
}
public PageResult<ArticleVideoInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize)
{
PageResult<ArticleVideoInfo> result = new PageResult<ArticleVideoInfo>();
int skip = (pageNumber - 1) * pageSize;
int take = pageSize;
List<ArticleVideo> list = null;
using (var DbContext = new CmsDbContext())
{
var query = from i in DbContext.ArticleVideo
select i;
#region 条件
foreach (string key in searchCondtionCollection)
{
string condition = searchCondtionCollection[key];
switch (key.ToLower())
{
case "isvalid":
int value = Convert.ToInt32(condition);
query = query.Where(x => x.SYS_IsValid.Equals(value));
break;
default:
break;
}
}
#endregion
result.TotalRecords = query.Count();
#region 排序
foreach (string sort in sortCollection)
{
string direct = string.Empty;
switch (sort.ToLower())
{
case "createtime":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
break;
default:
query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take);
break;
}
}
list = query.ToList();
}
#endregion
#region linq to entity
List<ArticleVideoInfo> ilist = new List<ArticleVideoInfo>();
list.ForEach(x =>
{
ArticleVideoInfo info = new ArticleVideoInfo();
DESwap.ArticleVideoETD(x, info);
ilist.Add(info);
});
#endregion
result.PageSize = pageSize;
result.PageNumber = pageNumber;
result.Data = ilist;
return result;;
}
public async Task <PageResult <UserDTO> > Handle(GetUsersCommand request, CancellationToken cancellationToken)
{
// Func<User, bool> condition = x => true;
var where = "";
var userSet = _userRepository.Set().AsQueryable();
if (!string.IsNullOrWhiteSpace(request.Key))
{
userSet = userSet.Where(x => x.UserName.Contains(request.Key));
//condition = x => x.UserName.Contains(request.Key);
where = $"UserName like '%{request.Key}%'";
}
// var count = await userSet.CountAsync();
//if (count < 1) return PageResult<UserDTO>.Success(null, 0, request.PageIndex, request.PageSize, "");
//var start = (request.PageIndex - 1) * request.PageSize;
//var end = start + request.PageSize;
//var query = userSet.OrderByDescending(x => x.Id)
// .Skip(start)
// .Take(request.PageSize)
// .AsQueryable();
//var data = await userSet.OrderByDescending(x => x.Id)
// .Skip(start)
// .Take(request.PageSize)
// .ToListAsync();
//var data = query.ToList();
var pageData = await _userRepository.GetPageDataAsync <User>(
pageIndex : request.PageIndex,
pageSize : request.PageSize,
where : where);
var count = pageData.Total;
if (count < 1)
{
return(PageResult <UserDTO> .Success(null, 0, request.PageIndex, request.PageSize, ""));
}
//_logger.LogInformation(query.ToSql());
var data = pageData.Data;
var ids = data.Select(x => x.Id);
var companyUserids = await _companyUserRepository.Set().Where(x => ids.Contains(x.UserId)).ToListAsync();
var user_company_arr = companyUserids.Select(x => new { x.CompanyId, x.UserId });
var cids = user_company_arr.Select(x => x.CompanyId);
var companys = await _companyRepository.Set().Where(x => cids.Contains(x.Id)).ToListAsync();
var _data = new List <UserDTO>();
data.ToList().ForEach(x =>
{
var u = new UserDTO
{
CreatedTime = x.CreatedTime,
Id = x.Id,
Type = x.Type,
UserName = x.UserName,
LoginCount = x.LoginCount,
Mobile = x.Mobile,
LastLoginTime = x.LastLoginTime
};
var user_company = user_company_arr.FirstOrDefault(y => y.UserId == x.Id);
if (user_company == null)
{
u.CompanyName = "未绑定";
}
else
{
u.CompanyId = user_company.CompanyId;
u.CompanyName = companys.FirstOrDefault(x => x.Id == user_company.CompanyId)?.Name;
}
_data.Add(u);
});
return(PageResult <UserDTO> .Success(_data, count, request.PageIndex, request.PageSize, $"/user/user/list/?PageIndex=__id__&PageSize={request.PageSize}&key={request.Key}"));
}
/// <summary>
/// Materialize a page result.
/// </summary>
public static async Task <PageResult <T> > MaterializeAsync <T>(this PageResult <T> pageResult)
{
pageResult.Results = await pageResult.Results.AsQueryable().ToListAsync();
return(pageResult);
}
/// <summary>
/// 将分页数据转换为表格数据格式
/// </summary>
public static GridData <TData> ToGridData <TData>(this PageResult <TData> pageResult)
{
return(new GridData <TData>(pageResult.Data, pageResult.Total));
}
public static List <PageResult> LoadPageResults(Service service)
{
//return new List<PageResult>();
try
{
string filename = service.Name.Replace(" ", "") + ".json";
string path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "data", filename);
string json = FileSystemHelper.ReadWithoutLock(path);
if (string.IsNullOrWhiteSpace(json))
{
return(new List <PageResult>());
}
List <PageResult> results = new List <PageResult>();
using (StringReader sr = new StringReader(json))
using (JsonTextReader reader = new JsonTextReader(sr))
{
if (!reader.Read() || reader.TokenType != JsonToken.StartArray)
{
throw new Exception("Invalid format");
}
while (reader.Read())
{
if (reader.TokenType != JsonToken.StartObject)
{
continue;
}
PageResult result = new PageResult();
while (reader.Read())
{
if (reader.TokenType == JsonToken.PropertyName)
{
string name = reader.Value as string;
reader.Read();
switch (name.ToLowerInvariant())
{
case "friendly-url":
result.FriendlyUrl = reader.Value as string;
break;
case "ip-address":
result.IPAddress = reader.Value as string;
break;
case "site-id":
result.SiteID = Convert.ToInt32(reader.Value);
break;
case "domain-id":
result.DomainID = Convert.ToInt32(reader.Value);
break;
case "result-type":
result.ResultType = (ResultType)Enum.Parse(typeof(ResultType), reader.Value as string);
break;
case "status-code":
result.StatusCode = Convert.ToInt32(reader.Value);
break;
}
}
else if (reader.TokenType == JsonToken.EndObject)
{
results.Add(result);
break;
}
}
}
}
return(results);
}
catch
{
return(new List <PageResult>());
}
}
public void Can_assign_to_variables_in_partials()
{
var context = new TemplateContext
{
Args =
{
["num"] = 1,
},
}.Init();
context.VirtualFiles.WriteFile("_layout.html", @"
<html>
<body>
<header>
layout num = {{ num }}
pageMetaTitle = {{ pageMetaTitle }}
inlinePageTitle = {{ inlinePageTitle }}
pageResultTitle = {{ pageResultTitle }}
</header>
{{ 'add-partial' | partial({ num: 100 }) }}
{{ page }}
{{ 'add-partial' | partial({ num: 400 }) }}
<footer>
layout num = {{ num }}
inlinePageTitle = {{ inlinePageTitle }}
</footer>
</body>
</html>
");
context.VirtualFiles.WriteFile("page.html", @"
<!--
pageMetaTitle: page meta title
-->
<section>
{{ 'page inline title' | upper | assignTo('inlinePageTitle') }}
{{ 'add-partial' | partial({ num: 200 }) }}
{{ num | add(1) | assignTo('num') }}
<h2>page num = {{ num }}</h2>
{{ 'add-partial' | partial({ num: 300 }) }}
</section>");
context.VirtualFiles.WriteFile("add-partial.html", @"
{{ num | add(10) | assignTo('num') }}
<h3>partial num = {{ num }}</h3>");
var result = new PageResult(context.GetPage("page"))
{
Args =
{
["pageResultTitle"] = "page result title"
}
}.Result;
/* NOTES:
* 1. Page Args and Page Result Args are *always* visible to Layout as they're known before page is executed
* 2. Args created during Page execution are *only* visible in Layout after page is rendered (i.e. executed)
* 3. Args assigned in partials are retained within their scope
*/
Assert.That(result.RemoveNewLines(), Is.EqualTo(@"
<html>
<body>
<header>
layout num = 1
pageMetaTitle = page meta title
inlinePageTitle = {{ inlinePageTitle }}
pageResultTitle = page result title
</header>
<h3>partial num = 110</h3>
<section>
<h3>partial num = 210</h3>
<h2>page num = 2</h2>
<h3>partial num = 310</h3>
</section>
<h3>partial num = 410</h3>
<footer>
layout num = 2
inlinePageTitle = PAGE INLINE TITLE
</footer>
</body>
</html>
".RemoveNewLines()));
}
private void btnConfirm_Click(object sender, RoutedEventArgs e)
{
_pageVM.StopTimer();
bool bSameWithHouse = PersonalData170["IsSameWithHouse"] == "Y";
string[] fundSrcs = GetFundSource();
string pcFlagadd = "";
if (PersonalData170["ShowStatementAddr"] == "Y")
{
pcFlagadd = PersonalData170["StatementAddrByHouse"] == "Y" ? "A" : "B";
}
var model = new
{
regzipcode = PersonalData170["HouseZipCode"],
regadr = PersonalData170["HouseCityName"],
regtown = PersonalData170["HouseTownName"],
reglin = PersonalData170["HouseLin"],
reglee = PersonalData170["HouseLi"],
regaddr = PersonalData170["HouseAddress"],
zipcode2 = PersonalData170["CommZipCode"],
adr2 = PersonalData170["CommCityName"],
town2 = PersonalData170["CommTownName"],
lee2 = PersonalData170["CommLi"],
addr2 = PersonalData170["CommAddress"],
zipcode1 = pcFlagadd == "A" ? PersonalData170["HouseZipCode"] : PersonalData170["CommZipCode"],
adr1 = pcFlagadd == "A" ? PersonalData170["HouseCityName"] : PersonalData170["CommCityName"],
town1 = pcFlagadd == "A" ? PersonalData170["HouseTownName"] : PersonalData170["CommTownName"],
lee1 = pcFlagadd == "A" ? PersonalData170["HouseLi"] : PersonalData170["CommLi"],
addr1 = pcFlagadd == "A" ? PersonalData170["HouseAddress"] : PersonalData170["CommAddress"],
hphnc = PersonalData170["HomeTelCountry"],
hpharea = PersonalData170["HomeTelArea"],
hphno = PersonalData170["HomeTelNumber"],
ophnc = PersonalData170["OfficeTelCountry"],
opharea = PersonalData170["OfficeTelArea"],
ophno = PersonalData170["OfficeTelNumber"],
ophext = PersonalData170["OfficeExtNumber"],
mphnc = PersonalData170["MobileCountry"],
mphno = PersonalData170["MobileNumber"].Replace("-", "").Trim(),
faxnc1 = PersonalData170["FaxTelCountry"],
faxarea1 = PersonalData170["FaxTelArea"],
faxno1 = PersonalData170["FaxTelNumber"],
email = PersonalData170["Email"],
pcFlag = PersonalData170["StatementCode"],
statement = PersonalData170["OldStatementCode"],
jobTitle = PersonalData172["JobTitleKey"],
serveCompany = PersonalData172["CompanyName"],
jobBusinessCode = PersonalData172["SubClassMegaCode"],
annualIncome = PersonalData172["AnnualIncomeCode"],
indviAmtRange = PersonalData172["MonthlyAvgCode"],
purpose1 = PersonalData172["PurposeCode1"],
purpose2 = PersonalData172["PurposeCode2"],
purpose3 = PersonalData172["PurposeCode3"],
purpose1Remark = PersonalData172["OtherPurpose"],
incomeResource1 = fundSrcs.Length > 0 ? fundSrcs[0] : "",
incomeResource2 = fundSrcs.Length > 1 ? fundSrcs[1] : "",
incomeResource3 = fundSrcs.Length > 2 ? fundSrcs[2] : "",
incomeResourceIncome = PersonalData175["FundSourceADesc"],
incomeResourceOther = PersonalData175["FundSourceBDesc"],
assetResource1 = PersonalData177["WealthySource1Code"],
assetResourceSub1 = PersonalData177["WealthySource1SubCode"],
assetResourceSub1Other = PersonalData177["WealthySource1Other"],
assetResource2 = PersonalData177["WealthySource2Code"],
assetResourceSub2 = PersonalData177["WealthySource2SubCode"],
assetResourceSub2Other = PersonalData177["WealthySource2Other"],
assetResource3 = PersonalData177["WealthySource3Code"],
assetResourceSub3 = PersonalData177["WealthySource3SubCode"],
assetResourceSub3Other = PersonalData177["WealthySource3Other"],
pbtransf = PersonalData177["StampRefAccNo"],
pbatmfg = PersonalData185["ApplyATMCard"],
wfCard = PersonalData185["ICCATMCard"],
lkkCard = PersonalData185["VISAAtomCard"],
lotusCard = PersonalData185["VISALotusCard"],
pb11nofg = PersonalData185["NonDealTRF"],
pb11stfg = PersonalData185["ConsumeDeduct"],
pb11trfg = PersonalData185["InternationTrade"],
appWebbank = PersonalData186["ApplyEBank"],
actfNbSsl = PersonalData186["ApplySSL"] == "Y" ? "1" : "?",
actfNbToSelf = PersonalData186["TRFSameNameAccount"] == "Y" ? "1" : "?",
actfNbFree = PersonalData186["EBankNonDealTRF"] == "Y" ? "1" : "?",
actfNbFxFlag = PersonalData186["ExchangeClaimService"] == "Y" ? "1" : "?",
actfNbRgFlag = PersonalData186["OnlineTRFAccount"] == "Y" ? "1" : "?",
actfNbDvPhid = PersonalData186["MobileBank"] == "Y" ? "5" : "?",
ecode = PersonalData186["ApplyEMobileService"],
mobile = PersonalData186["eMobile"].Replace("-", "").Trim(),
appPwd = PersonalData185["ApplyUniPayment"],
twAppPwd = PersonalData185["ApplyTWDAccountPswd"],
fappPwd = PersonalData185["ApplyFGDAccountPswd"],
commarkterm = PersonalData187["PromotionTerm"],
pcFlagadd,
engAddr = PersonalData170["OldEnglishAddress"],
engName = PersonalData170["OldEnglishName"],
PersonalData170 = Json2Base64(_pageVM.Page0170Data),
PersonalData172 = Json2Base64(_pageVM.Page0172Data),
PersonalData175 = Json2Base64(_pageVM.Page0175Data),
PersonalData177 = Json2Base64(_pageVM.Page0177Data),
PersonalData185 = Json2Base64(_pageVM.Page0185Data),
PersonalData186 = Json2Base64(_pageVM.Page0186Data),
PersonalData187 = Json2Base64(_pageVM.Page0187Data)
};
string json = JsonConvert.SerializeObject(model);
_kernelService.TransactionDataCache.Set(KioskDataCacheKey.ApplyConfirmData, json);
PageResult result = new PageResult("Confirm", KioskDataCacheKey.ApplyConfirmData);
_kernelService.NextPage(result);
}
public void Can_validate_person_in_code()
{
var context = new ScriptContext().Init();
var code = @"
['Name','Age'] |> to => requiredProps
#each requiredProps
#if !model[it]
it.throwArgumentNullException()
/if
/each
(Age < 13) |> ifThrowArgumentException('Must be 13 or over', 'Age')
";
try
{
var pageResult = new PageResult(context.CodeBlock(code))
{
Model = new Person()
};
pageResult.RenderToStream(Stream.Null);
Assert.Fail("Should throw");
}
catch (ScriptException e)
{
if (!(e.InnerException is ArgumentNullException ne))
{
throw;
}
Assert.That(ne.ParamName, Is.EqualTo(nameof(Person.Name)));
}
try
{
var pageResult = new PageResult(context.CodeBlock(code))
{
Model = new Person {
Name = "A"
}
};
pageResult.RenderToStream(Stream.Null);
Assert.Fail("Should throw");
}
catch (ScriptException e)
{
if (!(e.InnerException is ArgumentNullException ne))
{
throw;
}
Assert.That(ne.ParamName, Is.EqualTo(nameof(Person.Age)));
}
try
{
var pageResult = new PageResult(context.CodeBlock(code))
{
Model = new Person {
Name = "A", Age = 1
}
};
pageResult.RenderToStream(Stream.Null);
Assert.Fail("Should throw");
}
catch (ScriptException e)
{
if (!(e.InnerException is ArgumentException ae))
{
throw;
}
Assert.That(ae.Message.Replace("\r", ""),
Does.StartWith("Must be 13 or over"));
}
}
public PageResult<ClientTypeInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize)
{
PageResult<ClientTypeInfo> result = new PageResult<ClientTypeInfo>();
int skip = (pageNumber - 1) * pageSize;
int take = pageSize;
List<ClientTypeInfo> list = null;
using (var DbContext = new UCDbContext())
{
var query = from i in DbContext.ClientType
join p in DbContext.ClientType on i.ParentId equals p.Id into parent
from tp in parent.DefaultIfEmpty()
select new ClientTypeInfo()
{
Id = i.Id,
ClientTypeCode = i.ClientTypeCode,
ClientTypeName = i.ClientTypeName,
ParentId = i.ParentId,
TreeNode = i.TreeNode,
SYS_IsValid = i.SYS_IsValid,
SYS_OrderSeq = i.SYS_OrderSeq,
SYS_AppId = i.SYS_AppId,
SYS_StaffId = i.SYS_StaffId,
SYS_StationId = i.SYS_StationId,
SYS_DepartmentId = i.SYS_DepartmentId,
SYS_CompanyId = i.SYS_CompanyId,
SYS_CreateTime = i.SYS_CreateTime,
ParentName = tp.ClientTypeName == null ? "" : tp.ClientTypeName
};
#region 条件
foreach (string key in searchCondtionCollection)
{
string condition = searchCondtionCollection[key];
switch (key.ToLower())
{
case "clienttypename":
query = query.Where(x => x.ClientTypeName.Contains(condition));
break;
case "clienttypecode":
query = query.Where(x => x.ClientTypeCode.Contains(condition));
break;
case "parentid":
query = query.Where(x => x.ParentId.Equals(condition));
break;
case "isvalid":
int value = Convert.ToInt32(condition);
query = query.Where(x => x.SYS_IsValid.Equals(value));
break;
default:
break;
}
}
#endregion
result.TotalRecords = query.Count();
#region 排序
foreach (string sort in sortCollection)
{
string direct = sortCollection[sort];
switch (sort.ToLower())
{
case "createtime":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
break;
case "clienttypename":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => x.ClientTypeName).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => x.ClientTypeName).Skip(skip).Take(take);
}
break;
default:
query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take);
break;
}
}
#endregion
list = query.ToList();
}
result.PageSize = pageSize;
result.PageNumber = pageNumber;
result.Data = list;
return result;
}
private static async Task MainAsync()
{
// Start
Console.WriteLine("Jasmin rocks! Let's list the orders attributes using the OData...");
// Handle errors
try
{
// Create the HTTP client to send the request
using (HttpClient client = new HttpClient())
{
// Set the authorization header
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", AccessToken);
// URI of the endpoint
string endpoint = string.Format(CultureInfo.CurrentCulture, "{0}/{1}/{2}/sales/orders/odata?$inlinecount=allpages&$select=DocumentType,SeriesNumber,Company&$top=10&$orderby=Serie desc", ApiBaseAddress, AccountKey, SubscriptionKey);
// Send the request (GET)
Console.WriteLine("Kicking the Orders OData endpoint to list the orders attributes...");
Uri endpointUri = new Uri(endpoint);
using (HttpResponseMessage response = await client.GetAsync(endpointUri))
{
// Failed?
if (!response.IsSuccessStatusCode)
{
string errorContent = await response.Content.ReadAsStringAsync();
StringBuilder sb = new StringBuilder();
sb.AppendLine(string.Format(CultureInfo.CurrentCulture, "The requested failed with status code {0} ({1}).", (int)response.StatusCode, response.StatusCode));
if (!string.IsNullOrWhiteSpace(errorContent))
{
sb.Append(string.Format(CultureInfo.CurrentCulture, "Message: {0}.", errorContent));
}
throw new InvalidOperationException(sb.ToString());
}
// Succeeded
string json = await response.Content.ReadAsStringAsync();
JsonSerializerSettings settings = new JsonSerializerSettings()
{
ContractResolver = new CamelCasePropertyNamesContractResolver(),
Formatting = Formatting.Indented
};
PageResult <OrderResource> orders = JsonConvert.DeserializeObject <PageResult <OrderResource> >(json);
Console.WriteLine("The orders attributes were obtained with success.");
foreach (OrderResource order in orders.Items)
{
Console.WriteLine("Order: {0}.{1}.{2}", order.DocumentType, order.Company, order.SeriesNumber);
}
Console.WriteLine("Count: {0}", orders.Count);
}
}
}
catch (Exception exception)
{
ConsoleHelper.WriteErrorLine("Error found!");
ConsoleHelper.WriteErrorLine(exception.Message);
}
// End
Console.Write("Press any key to end... ");
Console.ReadKey();
}
public override async Task ProcessRequestAsync(IRequest httpReq, IResponse httpRes, string operationName)
{
var args = httpReq.GetTemplateRequestParams();
if (Args != null)
{
foreach (var entry in Args)
{
args[entry.Key] = entry.Value;
}
}
var pageResult = new PageResult(page)
{
Args = args,
LayoutPage = layoutPage,
Model = Model,
};
try
{
httpRes.ContentType = page.Format.ContentType;
if (OutputStream != null)
{
await pageResult.WriteToAsync(OutputStream);
}
else
{
// Buffering improves perf when running behind a reverse proxy (recommended for .NET Core)
using (var ms = MemoryStreamFactory.GetStream())
{
await pageResult.WriteToAsync(ms);
if (pageResult.Args.TryGetValue(TemplateConstants.Return, out var response))
{
if (response is Task <object> responseTask)
{
response = await responseTask;
}
if (response is IRawString raw)
{
response = raw.ToRawString();
}
if (response != null)
{
var httpResult = TemplateApiPagesService.ToHttpResult(pageResult, response);
await httpRes.WriteToResponse(httpReq, httpResult);
return;
}
}
ms.Position = 0;
await ms.WriteToAsync(httpRes.OutputStream);
}
}
}
catch (Exception ex)
{
await page.Format.OnViewException(pageResult, httpReq, ex);
}
}
public static PageResult <TResult> Convert <TSource, TResult>(this PageResult <TSource> source, Func <TSource, TResult> selector)
{
var data = source.Data.Select(selector);
return(new PageResult <TResult>(data, source.Request, source.Total));
}
public object Any(FreeDb request)
{
var sp = Stopwatch.StartNew();
var returnValue = new PageResult<List<Disk>>();
var results =
Client().Search<Disk>(
i =>
i.Index("disk")
.Type("disk")
.Skip((request.Offset) * request.Limit)
.Take(request.Limit)
.Query(
q =>
q.QueryString(
qs =>
qs.OnFields(new[] { "artist", "title", "tracks" })
.Query(request.Query))));
returnValue.TimeElapsed = sp.Elapsed.TotalSeconds;
returnValue.CurrentPage = (request.Offset == 0) ? 1 : request.Offset;
returnValue.Result = results.Documents.ToList();
returnValue.ItemCount = results.Documents.Count();
returnValue.TotalItems = results.Total;
returnValue.TotalPages = (int)Math.Ceiling((double)results.Total / request.Limit);
return returnValue;
}
private async Task OnSelectCommandAsync()
{
await PageResult.FinishAsync(SelectedItem);
}
public void CreateODataFeed_Sets_InlineCountForPageResult()
{
// Arrange
ODataFeedSerializer serializer = new ODataFeedSerializer(new DefaultODataSerializerProvider());
Uri expectedNextLink = new Uri("http://nextlink.com");
long expectedInlineCount = 1000;
var result = new PageResult<Customer>(_customers, expectedNextLink, expectedInlineCount);
// Act
ODataFeed feed = serializer.CreateODataFeed(result, _customersType, new ODataSerializerContext());
// Assert
Assert.Equal(1000, feed.Count);
}
private async Task OnCancelCommandAsync()
{
await PageResult.CancelAsync();
}
public PageResult<AppInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize)
{
PageResult<AppInfo> result = new PageResult<AppInfo>();
int skip = (pageNumber - 1) * pageSize;
int take = pageSize;
List<AppInfo> list = null;
using (var DbContext = new UCDbContext())
{
var query = from i in DbContext.App
select new AppInfo()
{
Id = i.Id,
AppCode = i.AppCode,
AppName = i.AppName,
PublicKey = i.PublicKey,
PrivateKey = i.PrivateKey,
SYS_IsValid = i.SYS_IsValid,
SYS_OrderSeq = i.SYS_OrderSeq,
SYS_AppId = i.SYS_AppId,
SYS_StaffId = i.SYS_StaffId,
SYS_StationId = i.SYS_StationId,
SYS_DepartmentId = i.SYS_DepartmentId,
SYS_CompanyId = i.SYS_CompanyId,
SYS_CreateTime = i.SYS_CreateTime
};
#region 条件
foreach (string key in searchCondtionCollection)
{
string condition = searchCondtionCollection[key];
switch (key.ToLower())
{
case "appname":
query = query.Where(x => x.AppName.Contains(condition));
break;
case "appcode":
query = query.Where(x => x.AppCode.Contains(condition));
break;
case "isvalid":
int value = Convert.ToInt32(condition);
query = query.Where(x => x.SYS_IsValid.Equals(value));
break;
default:
break;
}
}
#endregion
result.TotalRecords = query.Count();
#region 排序
foreach (string sort in sortCollection)
{
string direct = sortCollection[sort];
switch (sort.ToLower())
{
case "createtime":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
break;
case "appname":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => x.AppName).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => x.AppName).Skip(skip).Take(take);
}
break;
default:
query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take);
break;
}
}
#endregion
list = query.ToList();
}
result.PageSize = pageSize;
result.PageNumber = pageNumber;
result.Data = list;
return result; ;
}
public void WritePageResult(PageResult results)
{
_writer.Write(Protocol.FormatDocument(string.Format("{0}\n{1}\n{2}\n", results.Title, results.TestCounts.Description, results.Content)));
}
public PageResult<ArticleInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize)
{
PageResult<ArticleInfo> result = new PageResult<ArticleInfo>();
int skip = (pageNumber - 1) * pageSize;
int take = pageSize;
List<ArticleInfo> list = null;
using (var DbContext = new CmsDbContext())
{
var query = from i in DbContext.Article
join ac in DbContext.ArticleCatalog on i.ArticleCatalogId equals ac.Id
select new ArticleInfo()
{
Id = i.Id,
Title = i.Title,
FormDate = i.FormDate,
ArticleType = i.ArticleType,
ArticleCatalogId = i.ArticleCatalogId,
SignImage = i.SignImage,
SYS_IsValid = i.SYS_IsValid,
SYS_OrderSeq = i.SYS_OrderSeq,
SYS_AppId = i.SYS_AppId,
SYS_StaffId = i.SYS_StaffId,
SYS_StationId = i.SYS_StationId,
SYS_DepartmentId = i.SYS_DepartmentId,
SYS_CompanyId = i.SYS_CompanyId,
SYS_CreateTime = i.SYS_CreateTime,
ArticleCatalogName = ac.Name
};
#region 条件
foreach (string key in searchCondtionCollection)
{
string condition = searchCondtionCollection[key];
switch (key.ToLower())
{
case "titile":
query = query.Where(x => x.Title.Contains(condition));
break;
case "articlecatalogid":
query = query.Where(x => x.ArticleCatalogId.Equals(condition));
break;
case "isvalid":
int isvalid = Convert.ToInt32(condition);
query = query.Where(x => x.SYS_IsValid.Equals(isvalid));
break;
default:
break;
}
}
#endregion
result.TotalRecords = query.Count();
#region 排序
foreach (string sort in sortCollection)
{
string direct = sortCollection[sort];
switch (sort.ToLower())
{
case "createtime":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take);
}
break;
case "title":
if (direct.ToLower().Equals("asc"))
{
query = query.OrderBy(x => x.Title).Skip(skip).Take(take);
}
else
{
query = query.OrderByDescending(x => x.Title).Skip(skip).Take(take);
}
break;
default:
query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take);
break;
}
}
#endregion
list = query.ToList();
}
result.PageSize = pageSize;
result.PageNumber = pageNumber;
result.Data = list;
return result; ;
}
/// <summary>
/// Create the <see cref="ODataFeed"/> to be written for the given feed instance.
/// </summary>
/// <param name="feedInstance">The instance representing the feed being written.</param>
/// <param name="feedType">The EDM type of the feed being written.</param>
/// <param name="writeContext">The serializer context.</param>
/// <returns>The created <see cref="ODataFeed"/> object.</returns>
public virtual ODataFeed CreateODataFeed(IEnumerable feedInstance, IEdmCollectionTypeReference feedType,
ODataSerializerContext writeContext)
{
ODataFeed feed = new ODataFeed();
if (writeContext.EntitySet != null)
{
IEdmModel model = writeContext.Model;
EntitySetLinkBuilderAnnotation linkBuilder = model.GetEntitySetLinkBuilder(writeContext.EntitySet);
FeedContext feedContext = new FeedContext
{
Request = writeContext.Request,
RequestContext = writeContext.RequestContext,
EntitySet = writeContext.EntitySet,
Url = writeContext.Url,
FeedInstance = feedInstance
};
Uri feedSelfLink = linkBuilder.BuildFeedSelfLink(feedContext);
if (feedSelfLink != null)
{
feed.SetAnnotation(new AtomFeedMetadata()
{
SelfLink = new AtomLinkMetadata()
{
Relation = "self", Href = feedSelfLink
}
});
}
}
// TODO: Bug 467590: remove the hardcoded feed id. Get support for it from the model builder ?
feed.Id = "http://schemas.datacontract.org/2004/07/" + feedType.FullName();
if (writeContext.ExpandedEntity == null)
{
// If we have more OData format specific information apply it now, only if we are the root feed.
PageResult odataFeedAnnotations = feedInstance as PageResult;
if (odataFeedAnnotations != null)
{
feed.Count = odataFeedAnnotations.Count;
feed.NextPageLink = odataFeedAnnotations.NextPageLink;
}
else if (writeContext.Request != null)
{
feed.NextPageLink = writeContext.Request.ODataProperties().NextLink;
long?inlineCount = writeContext.Request.ODataProperties().TotalCount;
if (inlineCount.HasValue)
{
feed.Count = inlineCount.Value;
}
}
}
else
{
// nested feed
ITruncatedCollection truncatedCollection = feedInstance as ITruncatedCollection;
if (truncatedCollection != null && truncatedCollection.IsTruncated)
{
feed.NextPageLink = GetNestedNextPageLink(writeContext, truncatedCollection.PageSize);
}
}
return(feed);
}
//================================================================================
//public OffhireDetailDto AddOffhireDetail(OffhireDetailDto detailDto)
//{
// var result = offhireApplicationService.AddOffhireDetail(
// detailDto.Offhire.Id, detailDto.ROB, detailDto.Price, detailDto.Currency.Id, detailDto.Good.Id, detailDto.Unit.Id, detailDto.Tank.Id);
// return offhireDetailDtoMapper.MapToModel(result);
//}
//================================================================================
//public OffhireDetailDto UpdateOffhireDetail(OffhireDetailDto detailDto)
//{
// var result = offhireApplicationService.UpdateOffhireDetail(
// detailDto.Offhire.Id, detailDto.Id, detailDto.ROB, detailDto.Price, detailDto.Currency.Id, detailDto.Good.Id, detailDto.Unit.Id, detailDto.Tank.Id);
// return offhireDetailDtoMapper.MapToModel(result);
//}
//================================================================================
//public void DeleteOffhireDetail(long offhireId, long offhireDetailId)
//{
// offhireApplicationService.DeleteOffhireDetail(offhireId, offhireDetailId);
//}
//================================================================================
public PageResultDto<OffhireManagementSystemDto> GetOffhireManagementSystemPagedDataByFilter(long companyId, long vesselInCompanyId, DateTime? fromDate, DateTime? toDate, int pageSize, int pageIndex)
{
var result = offhireManagementSystemDomainService.GetFinalizedOffhires(companyId, vesselInCompanyId, fromDate, toDate);
var pageResult = new PageResult<OffhireManagementSystemEntity>()
{
CurrentPage = pageIndex,
PageSize = pageSize,
TotalCount = result.Count,
TotalPages = pageSize == 0 ? 0 : (int)Math.Ceiling((double)result.Count / pageSize),
Result = pageSize == 0 ? result : result.Skip(pageSize * pageIndex).Take(pageSize).ToList()
};
return mapPageResult(pageResult);
}
public async Task <IActionResult> Get(int take = 100, int skip = 0)
{
PageResult <ApiResourceDto> items = await _apiResourceService.Get(take, skip);
return(Ok(items));
}
//================================================================================
private PageResultDto<OffhireManagementSystemDto> mapPageResult(PageResult<OffhireManagementSystemEntity> pageResult)
{
return new PageResultDto<OffhireManagementSystemDto>()
{
CurrentPage = pageResult.CurrentPage,
PageSize = pageResult.PageSize,
TotalCount = pageResult.TotalCount,
TotalPages = pageResult.TotalPages,
Result = offhireManagementSystemDtoMapper.MapToModel(pageResult.Result).ToList()
};
}
public MvcPageResult(PageResult pageResult, Stream contents)
{
this.pageResult = pageResult;
this.contents = contents;
}
public async Task <PageResult <GetAllStatisticByDto> > GetAllStatisticBy(StatisticReportFilterByDto input)
{
var counts = 0;
var results = (from category in _categoryRepository.GetAll()
join book in _bookRepository.GetAll() on category.Id equals book.CategoryId
join brDetail in _borrowBookDetailRepository.GetAll() on book.Id equals brDetail.BookId into TempBrDetail
from brDetailTB in TempBrDetail.DefaultIfEmpty()
join borrow in _borrowBookRepository.GetAll() on brDetailTB.BorrowBookId equals borrow.Id into TempBr
from borrowTB in TempBr.DefaultIfEmpty()
join library in _libraryRepository.GetAll() on brDetailTB.LibraryId equals library.Id into TempLib
from libraryTB in TempLib.DefaultIfEmpty()
join district in _districtRepository.GetAll() on libraryTB.DistrictId equals district.Id into TempDistrict
from districtTB in TempDistrict.DefaultIfEmpty()
join province in _provinceRepository.GetAll() on districtTB.ProvinceId equals province.Id into TempProvince
from provinceTB in TempProvince.DefaultIfEmpty()
select new
{
CategoryId = category.Id,
CategoryName = category.Name,
LibraryId = libraryTB != null ? libraryTB.Id : Guid.Empty,
LibraryName = libraryTB != null ? libraryTB.Name : null,
DistrictId = districtTB != null ? districtTB.Id : Guid.Empty,
DistrictName = districtTB != null ? districtTB.Name : null,
ProvinceId = provinceTB != null ? provinceTB.Id : Guid.Empty,
ProvinceName = provinceTB != null ? provinceTB.Name : null,
Qty = brDetailTB != null ? brDetailTB.Qty : 0,
DateBorrow = borrowTB.DateBorrow
})
.ToList()
.WhereIf(
input.LibraryId != Guid.Empty || input.ProvinceId != Guid.Empty ||
input.DistrictId != Guid.Empty || input.FromDate.HasValue && input.ToDate.HasValue ||
input.Month != null || input.Quarter != null
,
x => x.LibraryId == input.LibraryId || x.ProvinceId == input.ProvinceId ||
x.DistrictId == input.DistrictId || x.DateBorrow.Date >= input.FromDate && x.DateBorrow.Date <= input.ToDate ||
x.DateBorrow.Month == input.Month ||
((1 <= x.DateBorrow.Month && x.DateBorrow.Month <= 3) ? 1 : ((4 <= x.DateBorrow.Month && x.DateBorrow.Month <= 6) ? 2 : ((7 <= x.DateBorrow.Month && x.DateBorrow.Month <= 9) ? 3 : ((10 <= x.DateBorrow.Month && x.DateBorrow.Month <= 12) ? 4 : 0)))) == input.Quarter
)
.GroupBy(x => x.CategoryId)
.Select(data => new GetAllStatisticByDto
{
CategoryId = data.Key,
CategoryName = data.Select(x => x.CategoryName).FirstOrDefault(),
LibraryId = data.Select(x => x.LibraryId).FirstOrDefault(),
LibraryName = data.Select(x => x.LibraryName).FirstOrDefault(),
DistrictId = data.Select(x => x.DistrictId).FirstOrDefault(),
DistrictName = data.Select(x => x.DistrictName).FirstOrDefault(),
ProvinceId = data.Select(x => x.ProvinceId).FirstOrDefault(),
ProvinceName = data.Select(x => x.ProvinceName).FirstOrDefault(),
Quantity = data.Sum(x => x == null ? 0 : x.Qty),
}).OrderByDescending(x => x.Quantity);
counts = results.Count();
var result = new PageResult <GetAllStatisticByDto>
{
Count = counts,
PageIndex = input.PageIndex,
PageSize = input.PageSize,
Items = await Task.FromResult(results.Skip((input.PageIndex - 1) * input.PageSize).Take(input.PageSize).ToList())
};
return(result);
}
public PageResult GetPageDataByReader(PageResult pageResult)
{
return(this.businessService.GetPageDataByReader(pageResult));
}
