private void BindPayData() { StringBuilder sWhere = new StringBuilder(); sWhere.AppendFormat(" WHERE UserID = {0} ", Fetch.GetUserCookie().UserID); if (Convert.ToInt32(ddlShareType.SelectedValue) != 0) { sWhere.AppendFormat(" AND CardTypeID = {0}", Convert.ToInt32(ddlShareType.SelectedValue)); } sWhere.AppendFormat(" AND ApplyDate >= '{0}' AND ApplyDate <= '{1}'", Convert.ToDateTime(CtrlHelper.GetText(txtStartDate) + " 00:00:00"), Convert.ToDateTime(CtrlHelper.GetText(txtEndDate) + " 23:59:59")); int sPageIndex = anpPage.CurrentPageIndex; int sPageSize = anpPage.PageSize; PagerSet pagerSet = treasureFacade.GetPayRecord(sWhere.ToString(), sPageIndex, sPageSize); anpPage.RecordCount = pagerSet.RecordCount; if (pagerSet.PageSet.Tables[0].Rows.Count > 0) { rptPayList.DataSource = pagerSet.PageSet; rptPayList.DataBind(); this.rptPayList.Visible = true; this.trNoData.Visible = false; } else { this.rptPayList.Visible = false; this.trNoData.Visible = true; } }