private void BindInfoData() { StringBuilder sWhere = new StringBuilder(); sWhere.AppendFormat(" WHERE DrawID IN (SELECT DrawID FROM RecordDrawScore WHERE UserID = {0}) ", Fetch.GetUserCookie().UserID); if (txtStartDate.Text.Trim() != "") { sWhere.AppendFormat(" AND StartTime >= '{0}'", Convert.ToDateTime(CtrlHelper.GetText(txtStartDate))); } if (txtEndDate.Text.Trim() != "") { sWhere.AppendFormat(" AND ConcludeTime < '{0}'", Convert.ToDateTime(CtrlHelper.GetText(txtEndDate)).AddDays(1).ToString("yyyy-MM-dd")); } int sPageIndex = anpPage.CurrentPageIndex; int sPageSize = anpPage.PageSize; PagerSet pagerSet = treasureFacade.GetDrawInfoRecord(sWhere.ToString(), sPageIndex, sPageSize); anpPage.RecordCount = pagerSet.RecordCount; if (pagerSet.PageSet.Tables[0].Rows.Count > 0) { this.rptDrawInfoList.DataSource = pagerSet.PageSet; this.rptDrawInfoList.DataBind(); this.rptDrawInfoList.Visible = true; this.trNoData.Visible = false; } else { this.rptDrawInfoList.Visible = false; this.trNoData.Visible = true; } }