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; } }