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("积分明细"); }