/// <summary> /// 绑定查询数据 /// </summary> private void DataBindInsure( ) { StringBuilder sWhere = new StringBuilder( ); sWhere.Append(" WHERE "); sWhere.AppendFormat("( SourceUserID = {0} OR TargetUserID = {0} ) and (TradeType = 3 or TradeType = 4)", Fetch.GetUserCookie( ).UserID); sWhere.AppendFormat(" AND CollectDate >= '{0}' AND CollectDate <= '{1}'", CtrlHelper.GetText(txtStartDate) + " 00:00:00", CtrlHelper.GetText(txtEndDate) + " 23:59:59"); int sPageIndex = anpPage.CurrentPageIndex; int sPageSize = anpPage.PageSize; PagerSet pagerSet = treasureFacade.GetInsureTradeRecord(sWhere.ToString( ), sPageIndex, sPageSize); anpPage.RecordCount = pagerSet.RecordCount; if (pagerSet.PageSet.Tables[0].Rows.Count > 0) { rptInsureList.DataSource = pagerSet.PageSet; rptInsureList.DataBind( ); this.rptInsureList.Visible = true; this.trNoData.Visible = false; } else { this.rptInsureList.Visible = false; this.trNoData.Visible = true; } }
/// <summary> /// 绑定查询数据 /// </summary> private void DataBindInsure() { StringBuilder sWhere = new StringBuilder(); sWhere.Append(" WHERE "); if (Convert.ToInt32(ddlType.SelectedValue) != 0) { if (Convert.ToInt32(ddlType.SelectedValue) < 3) { sWhere.AppendFormat(" TradeType = {0} AND SourceUserID = {1}", Convert.ToInt32(ddlType.SelectedValue) == 1 ? 1 : 2, Fetch.GetUserCookie().UserID); } else { if (Convert.ToInt32(ddlType.SelectedValue) == 3) { sWhere.AppendFormat(" SourceUserID = {0} AND TradeType = 3 and TargetUserID <> {0}", Fetch.GetUserCookie().UserID); } else if (Convert.ToInt32(ddlType.SelectedValue) == 4) { sWhere.AppendFormat(" SourceUserID <> {0} AND TradeType = 3 and TargetUserID = {0}", Fetch.GetUserCookie().UserID); } } } else { sWhere.AppendFormat("( SourceUserID = {0} OR TargetUserID = {0} )", Fetch.GetUserCookie().UserID); } sWhere.AppendFormat(" AND CollectDate >= '{0}' AND CollectDate <= '{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.GetInsureTradeRecord(sWhere.ToString(), sPageIndex, sPageSize); anpPage.RecordCount = pagerSet.RecordCount; if (pagerSet.PageSet.Tables[0].Rows.Count > 0) { rptInsureList.DataSource = pagerSet.PageSet; rptInsureList.DataBind(); this.rptInsureList.Visible = true; this.trNoData.Visible = false; } else { this.rptInsureList.Visible = false; this.trNoData.Visible = true; } }