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