public DbQueryResult GetWKMList(WhoKnowMeQuery page)
{
StringBuilder builder = new StringBuilder();
if (page.StartDate.HasValue)
{
builder.AppendFormat("StartDate>={0}", (DateTime)page.StartDate);
}
if (page.EndDate.HasValue)
{
builder.AppendFormat("EndDate<={0}", (DateTime)page.EndDate);
}
return(DataHelper.PagingByRownumber(page.PageIndex, page.PageSize, page.SortBy, page.SortOrder, page.IsCount, "WKM_main", "StartTime", builder.ToString(), "*"));
}
protected void BindMaterial()
{
WhoKnowMeQuery page = new WhoKnowMeQuery
{
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortBy = "StartDate",
SortOrder = SortAction.Desc
};
DbQueryResult WKMList = VShopHelper.GetWKMList(page);
//如果当前人已经设置了答案,并且活动id重复,则不允许重复答题, 直接刷新页面跳到type2
this.rpWhoKnowMe.DataSource = WKMList.Data;
this.rpWhoKnowMe.DataBind();
this.pager.TotalRecords = WKMList.TotalRecords;
}
public static DbQueryResult GetWKMList(WhoKnowMeQuery page)
{
return(new LotteryActivityDao().GetWKMList(page));
}
