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