protected void BindData()
{
if (!this.Page.IsPostBack)
{
int num = 0;
if (int.TryParse(this.Page.Request.QueryString["userId"], out num))
{
this.userId = num;
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["startDate"]))
{
this.startDate = new DateTime?(DateTime.Parse(this.Page.Request.QueryString["startDate"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["endDate"]))
{
this.endDate = new DateTime?(DateTime.Parse(this.Page.Request.QueryString["endDate"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["IntegralStatus"]))
{
this.IntegralStatus = int.Parse(this.Page.Request.QueryString["IntegralStatus"]);
}
this.calendarStartDate.SelectedDate = this.startDate;
this.calendarEndDate.SelectedDate = this.endDate;
this.drIntegralStatus.SelectedValue = this.IntegralStatus.ToString();
IntegralDetailQuery query = new IntegralDetailQuery
{
PageIndex = this.pager.PageIndex,
UserId = this.userId,
SortBy = this.grdMemberList.SortOrderBy,
PageSize = this.pager.PageSize,
IntegralStatus = this.IntegralStatus,
StartTime = this.startDate,
EndTime = this.endDate
};
if (this.grdMemberList.SortOrder.ToLower() == "desc")
{
query.SortOrder = SortAction.Desc;
}
DbQueryResult integralDetail = MemberHelper.GetIntegralDetail(query);
this.grdMemberList.DataSource = integralDetail.Data;
this.grdMemberList.DataBind();
this.pager1.TotalRecords = this.pager.TotalRecords = integralDetail.TotalRecords;
}
else
{
this.startDate = this.calendarStartDate.SelectedDate;
this.endDate = this.calendarEndDate.SelectedDate;
this.IntegralStatus = int.Parse(this.drIntegralStatus.SelectedValue);
}
}
public DbQueryResult GetIntegralDetail(IntegralDetailQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
if (query.IntegralSourceType > 0)
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" IntegralSourceType = {0}", query.IntegralSourceType);
}
if (query.IntegralStatus > 0)
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" IntegralStatus = {0}", query.IntegralStatus);
}
if (query.StartTime.HasValue)
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" convert(date,TrateTime) >='{0}'", DataHelper.GetSafeDateTimeFormat(query.StartTime.Value));
}
if (query.EndTime.HasValue)
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" convert(date,TrateTime)<='{0}'", DataHelper.GetSafeDateTimeFormat(query.EndTime.Value));
}
if (query.UserId > 0)
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat("UserId = {0}", query.UserId);
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vshop_IntegralDetail", "Id", (stringBuilder.Length > 0) ? stringBuilder.ToString() : null, "*"));
}
private void BindConsultation()
{
IntegralDetailQuery integralDetailQuery = new IntegralDetailQuery();
integralDetailQuery.PageIndex = this.pager.PageIndex;
integralDetailQuery.UserId = this.userId;
integralDetailQuery.SortBy = this.grdMemberList.SortOrderBy;
integralDetailQuery.PageSize = this.pager.PageSize;
integralDetailQuery.IntegralStatus = this.IntegralStatus;
integralDetailQuery.StartTime = this.startDate;
integralDetailQuery.EndTime = this.endDate;
if (this.grdMemberList.SortOrder.ToLower() == "desc")
{
integralDetailQuery.SortOrder = SortAction.Desc;
}
DbQueryResult integralDetail = MemberHelper.GetIntegralDetail(integralDetailQuery);
this.grdMemberList.DataSource = integralDetail.Data;
this.grdMemberList.DataBind();
this.pager1.TotalRecords = (this.pager.TotalRecords = integralDetail.TotalRecords);
}
private void BindConsultation()
{
IntegralDetailQuery query = new IntegralDetailQuery {
PageIndex = this.pager.PageIndex,
UserId = this.userId,
SortBy = this.grdMemberList.SortOrderBy,
PageSize = this.pager.PageSize,
IntegralStatus = this.IntegralStatus,
StartTime = this.startDate,
EndTime = this.endDate
};
if (this.grdMemberList.SortOrder.ToLower() == "desc")
{
query.SortOrder = SortAction.Desc;
}
DbQueryResult integralDetail = MemberHelper.GetIntegralDetail(query);
this.grdMemberList.DataSource = integralDetail.Data;
this.grdMemberList.DataBind();
this.pager1.TotalRecords = this.pager.TotalRecords = integralDetail.TotalRecords;
}
public DbQueryResult GetIntegralDetail(IntegralDetailQuery query)
{
StringBuilder builder = new StringBuilder();
if (query.IntegralSourceType > 0)
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat(" IntegralSourceType = {0}", query.IntegralSourceType);
}
if (query.UserId > 0)
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat("UserId = {0}", query.UserId);
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vshop_IntegralDetail", "Id", (builder.Length > 0) ? builder.ToString() : null, "*"));
}
public static DbQueryResult GetIntegralDetail(IntegralDetailQuery query)
{
return(new IntegralDetailDao().GetIntegralDetail(query));
}
protected override void AttachChildControls()
{
int num2;
int num3;
this.litSurplusIntegral = (Literal)this.FindControl("litSurplusIntegral");
this.litSumIntegral = (Literal)this.FindControl("litSumIntegral");
this.litStatus0 = (Literal)this.FindControl("litStatus0");
this.litStatus1 = (Literal)this.FindControl("litStatus1");
this.litStatus2 = (Literal)this.FindControl("litStatus2");
this.littableList0 = (Literal)this.FindControl("littableList0");
this.littableList1 = (Literal)this.FindControl("littableList1");
this.littableList2 = (Literal)this.FindControl("littableList2");
this.txtTotal = (HtmlInputHidden)this.FindControl("txtTotal");
this.txtShowTabNum = (HtmlInputHidden)this.FindControl("txtShowTabNum");
this.rptIntegarlDetail0 = (VshopTemplatedRepeater)this.FindControl("rptIntegarlDetail0");
this.rptIntegarlDetail1 = (VshopTemplatedRepeater)this.FindControl("rptIntegarlDetail1");
this.rptIntegarlDetail2 = (VshopTemplatedRepeater)this.FindControl("rptIntegarlDetail2");
int num = 0;
if (!int.TryParse(this.Page.Request.QueryString["page"], out num2))
{
num2 = 1;
}
if (!int.TryParse(this.Page.Request.QueryString["size"], out num3))
{
num3 = 10;
}
IntegralDetailQuery query = new IntegralDetailQuery();
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
this.litSurplusIntegral.Text = currentMember.Points.ToString();
this.litSumIntegral.Text = Convert.ToInt32(MemberProcessor.GetIntegral(currentMember.UserId)).ToString();
query.UserId = currentMember.UserId;
query.PageIndex = num2;
query.PageSize = num3;
if (int.TryParse(this.Page.Request.QueryString["IntegralSourceType"], out num))
{
DbQueryResult integralDetail;
if (num == 0)
{
query.IntegralSourceType = num;
integralDetail = MemberProcessor.GetIntegralDetail(query);
this.rptIntegarlDetail0.DataSource = integralDetail.Data;
this.rptIntegarlDetail0.DataBind();
this.litStatus0.Text = "class=\"active\"";
this.litStatus1.Text = "";
this.litStatus2.Text = "";
this.littableList0.Text = "style=\"display: block;\"";
this.littableList1.Text = "style=\"display: none;\"";
this.littableList2.Text = "style=\"display: none;\"";
this.txtTotal.SetWhenIsNotNull(integralDetail.TotalRecords.ToString());
}
else if (num == 1)
{
query.IntegralSourceType = num;
integralDetail = MemberProcessor.GetIntegralDetail(query);
this.rptIntegarlDetail1.DataSource = integralDetail.Data;
this.rptIntegarlDetail1.DataBind();
this.litStatus0.Text = "";
this.litStatus1.Text = "class=\"active\"";
this.litStatus2.Text = "";
this.littableList0.Text = "style=\"display: none ;\"";
this.littableList1.Text = "style=\"display:block;\"";
this.littableList2.Text = "style=\"display: none;\"";
this.txtTotal.SetWhenIsNotNull(integralDetail.TotalRecords.ToString());
}
else
{
query.IntegralSourceType = num;
integralDetail = MemberProcessor.GetIntegralDetail(query);
this.rptIntegarlDetail2.DataSource = integralDetail.Data;
this.rptIntegarlDetail2.DataBind();
this.litStatus0.Text = "";
this.litStatus1.Text = "";
this.litStatus2.Text = "class=\"active\"";
this.littableList0.Text = "style=\"display: none ;\"";
this.littableList1.Text = "style=\"display:none;\"";
this.littableList2.Text = "style=\"display: block;\"";
this.txtTotal.SetWhenIsNotNull(integralDetail.TotalRecords.ToString());
}
}
PageTitle.AddSiteNameTitle("积分明细");
}
