private void BindSpreaderRecordData()
{
int userID = Utility.StrToInt(ViewState["ChildrenID"], 0);
StringBuilder sWhere = new StringBuilder();
sWhere.AppendFormat(" WHERE ChildrenID = {0} ", userID);
int sPageIndex = anpPage2.CurrentPageIndex;
int sPageSize = anpPage2.PageSize;
PagerSet pagerSet = treasureFacade.GetSpreaderRecord(sWhere.ToString(), sPageIndex, sPageSize);
anpPage2.RecordCount = pagerSet.RecordCount;
this.rptContributionList.DataSource = pagerSet.PageSet;
this.rptContributionList.DataBind();
}
private void BindSpreadRecordData()
{
StringBuilder sWhere = new StringBuilder();
sWhere.AppendFormat(" WHERE UserID = {0} AND Score < 0 ", Fetch.GetUserCookie().UserID);
if (txtStartDate.Text.Trim() != "")
{
sWhere.AppendFormat(" AND CollectDate >= '{0}' ", CtrlHelper.GetText(txtStartDate) + " 00:00:00");
}
if (txtEndDate.Text.Trim() != "")
{
sWhere.AppendFormat(" AND CollectDate < '{0}'", Convert.ToDateTime(CtrlHelper.GetText(txtEndDate)).AddDays(1));
}
int sPageIndex = anpPage.CurrentPageIndex;
int sPageSize = anpPage.PageSize;
PagerSet pagerSet = treasureFacade.GetSpreaderRecord(sWhere.ToString(), sPageIndex, sPageSize);
anpPage.RecordCount = pagerSet.RecordCount;
if (pagerSet.PageSet.Tables[0].Rows.Count > 0)
{
this.rptSpreaderList.DataSource = pagerSet.PageSet;
this.rptSpreaderList.DataBind();
this.rptSpreaderList.Visible = true;
this.trNoData.Visible = false;
this.trTotal.Visible = true;
}
else
{
this.rptSpreaderList.Visible = false;
this.trNoData.Visible = true;
this.trTotal.Visible = false;
}
}