protected override void AttachChildControls() { int num; int num2; PageTitle.AddSiteNameTitle("我的优惠券"); this.txtTotal = (HtmlInputHidden)this.FindControl("txtTotal"); this.txtShowTabNum = (HtmlInputHidden)this.FindControl("txtShowTabNum"); this.rptActivity = (VshopTemplatedRepeater)this.FindControl("rptActivity"); this.txtShowTabNum.Value = "0"; PrizesDeliveQuery query = new PrizesDeliveQuery(); if (!int.TryParse(this.Page.Request.QueryString["page"], out num)) { num = 1; } if (!int.TryParse(this.Page.Request.QueryString["size"], out num2)) { num2 = 20; } MemberCouponsSearch search = new MemberCouponsSearch { CouponName = "", Status = "0", MemberId = Globals.GetCurrentMemberUserId(), IsCount = true, PageIndex = num, PageSize = num2, SortBy = "CouponId", SortOrder = SortAction.Desc }; int total = 0; DataTable memberCoupons = CouponHelper.GetMemberCoupons(search, ref total); if ((memberCoupons != null) && (memberCoupons.Rows.Count > 0)) { memberCoupons.Columns.Add("useConditon"); memberCoupons.Columns.Add("sStatus"); for (int i = 0; i < memberCoupons.Rows.Count; i++) { decimal num5 = decimal.Parse(memberCoupons.Rows[i]["ConditionValue"].ToString()); if (num5 == 0M) { memberCoupons.Rows[i]["useConditon"] = "无消费限制"; } else { memberCoupons.Rows[i]["useConditon"] = "满" + num5.ToString("F2") + "可使用"; } memberCoupons.Rows[i]["sStatus"] = (int.Parse(memberCoupons.Rows[i]["Status"].ToString()) == 0) ? "已领用" : "已使用"; } } MemberInfo currentMember = MemberProcessor.GetCurrentMember(); this.rptActivity.DataSource = memberCoupons; this.rptActivity.DataBind(); this.txtTotal.SetWhenIsNotNull(total.ToString()); }
private void BindData() { string str = Globals.RequestQueryStr("cname").Trim(); string str2 = Globals.RequestQueryStr("cno").Trim(); if (!string.IsNullOrEmpty(str)) { this.txt_name.Text = str; } if (!string.IsNullOrEmpty(str2)) { this.txt_orderNo.Text = str2; } string text = this.txt_name.Text; string text2 = this.txt_orderNo.Text; int total = 0; MemberCouponsSearch search = new MemberCouponsSearch { CouponName = str, OrderNo = str2, IsCount = true, PageIndex = this.pager1.PageIndex, PageSize = this.pager1.PageSize, SortBy = "CouponId", SortOrder = SortAction.Desc }; DataTable memberCoupons = CouponHelper.GetMemberCoupons(search, ref total); if ((memberCoupons != null) && (memberCoupons.Rows.Count > 0)) { memberCoupons.Columns.Add("useConditon"); memberCoupons.Columns.Add("sStatus"); for (int i = 0; i < memberCoupons.Rows.Count; i++) { decimal num3 = decimal.Parse(memberCoupons.Rows[i]["ConditionValue"].ToString()); if (num3 == 0M) { memberCoupons.Rows[i]["useConditon"] = "不限制"; } else { memberCoupons.Rows[i]["useConditon"] = "满" + num3.ToString("F2") + "可使用"; } memberCoupons.Rows[i]["sStatus"] = (int.Parse(memberCoupons.Rows[i]["Status"].ToString()) == 0) ? "已领取" : "已使用"; } } this.grdCoupondsList.DataSource = memberCoupons; this.grdCoupondsList.DataBind(); this.pager1.TotalRecords = total; }
public DbQueryResult GetMemberCoupons(MemberCouponsSearch search) { try { StringBuilder builder = new StringBuilder(" 1=1 "); if (!string.IsNullOrEmpty(search.CouponName)) { builder.Append(" and CouponName like '% " + search.CouponName.ReplaceSingleQuoteMark() + " %' "); } if (!string.IsNullOrEmpty(search.OrderNo)) { builder.Append(" and OrderNo='" + search.OrderNo.ReplaceSingleQuoteMark() + "' "); } return(DataHelper.PagingByRownumber(search.PageIndex, search.PageSize, search.SortBy, search.SortOrder, search.IsCount, "Hishop_Coupon_MemberCoupons", "Id", builder.ToString(), "*")); } catch (Exception) { return(null); } }
public static DataTable GetMemberCoupons(MemberCouponsSearch search, ref int total) { return((new CouponDao()).GetMemberCoupons(search, ref total)); }
public System.Data.DataTable GetMemberCoupons(MemberCouponsSearch search, ref int total) { System.Data.DataTable result; try { StringBuilder stringBuilder = new StringBuilder(" 1=1 "); total = 0; if (!string.IsNullOrEmpty(search.CouponName)) { stringBuilder.Append(" and a.CouponName like '%" + search.CouponName.ReplaceSingleQuoteMark() + "%' "); } if (!string.IsNullOrEmpty(search.OrderNo)) { stringBuilder.Append(" and OrderNo='" + search.OrderNo.ReplaceSingleQuoteMark() + "' "); } if (search.MemberId > 0) { stringBuilder.Append(" and MemberId='" + search.MemberId.ToString() + "' "); } int num = 0; if (!string.IsNullOrEmpty(search.Status) && int.TryParse(search.Status, out num)) { stringBuilder.Append(" and a.Status='" + num.ToString() + "' "); } string query = "select count(id) as total from Hishop_Coupon_MemberCoupons a where " + stringBuilder.ToString(); System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query); using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { System.Data.DataTable dataTable = DataHelper.ConverDataReaderToDataTable(dataReader); total = int.Parse(dataTable.Rows[0][0].ToString()); } if (total <= 0) { result = null; } else { int num2 = 0; int num3 = search.PageIndex * search.PageSize; if (search.PageIndex != 0 && search.PageSize != 0) { num2 = search.PageSize; if ((double)search.PageIndex >= Math.Ceiling((double)total / (double)search.PageSize)) { search.PageIndex = int.Parse(Math.Ceiling((double)total / (double)search.PageSize).ToString()); } int num4 = search.PageIndex * search.PageSize; if (num4 > total) { num2 = search.PageSize - (num4 - total); } } string str = "order by a.CouponId desc "; string text = "order by CouponId desc"; string text2 = "order by CouponId desc "; string str2 = string.Format("select top {0} a.* , b.userName,c.IsAllProduct from Hishop_Coupon_MemberCoupons a inner join Hishop_Coupon_Coupons c on c.CouponId=a.CouponId left join aspnet_Members b on a.memberid=b.userId where ", num3); string query2 = string.Format("select * from ( select top {0} * from ( {1} ) as t1 {2} ) as t2 {3} ", new object[] { num2, str2 + stringBuilder.ToString() + str, text2, text }); sqlStringCommand = this.database.GetSqlStringCommand(query2); using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { System.Data.DataTable dataTable = DataHelper.ConverDataReaderToDataTable(dataReader); result = dataTable; } } } catch (Exception) { result = null; } return(result); }
public DataTable GetMemberCoupons(MemberCouponsSearch search, ref int total) { DataTable table2; try { IDataReader reader; StringBuilder builder = new StringBuilder(" 1=1 "); total = 0; if (!string.IsNullOrEmpty(search.CouponName)) { builder.Append(" and a.CouponName like '%" + search.CouponName.ReplaceSingleQuoteMark() + "%' "); } if (!string.IsNullOrEmpty(search.OrderNo)) { builder.Append(" and OrderNo='" + search.OrderNo.ReplaceSingleQuoteMark() + "' "); } if (search.MemberId > 0) { builder.Append(" and MemberId='" + search.MemberId.ToString() + "' "); } int result = 0; if (!(string.IsNullOrEmpty(search.Status) || !int.TryParse(search.Status, out result))) { builder.Append(" and a.Status='" + result.ToString() + "' "); } string query = "select count(id) as total from Hishop_Coupon_MemberCoupons a where " + builder.ToString(); DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query); using (reader = this.database.ExecuteReader(sqlStringCommand)) { DataTable table = DataHelper.ConverDataReaderToDataTable(reader); total = int.Parse(table.Rows[0][0].ToString()); } if (total <= 0) { return(null); } int pageSize = 0; int num3 = search.PageIndex * search.PageSize; if ((search.PageIndex != 0) && (search.PageSize != 0)) { pageSize = search.PageSize; if (search.PageIndex >= Math.Ceiling((double)(((double)total) / ((double)search.PageSize)))) { search.PageIndex = int.Parse(Math.Ceiling((double)(((double)total) / ((double)search.PageSize))).ToString()); } int num4 = search.PageIndex * search.PageSize; if (num4 > total) { pageSize = search.PageSize - (num4 - total); } } string str2 = "order by a.CouponId desc "; string str3 = "order by CouponId desc"; string str4 = "order by CouponId desc "; string str5 = string.Format("select top {0} a.* , b.userName,c.IsAllProduct from Hishop_Coupon_MemberCoupons a inner join Hishop_Coupon_Coupons c on c.CouponId=a.CouponId left join aspnet_Members b on a.memberid=b.userId where ", num3); string str6 = string.Format("select * from ( select top {0} * from ( {1} ) as t1 {2} ) as t2 {3} ", new object[] { pageSize, str5 + builder.ToString() + str2, str4, str3 }); sqlStringCommand = this.database.GetSqlStringCommand(str6); using (reader = this.database.ExecuteReader(sqlStringCommand)) { table2 = DataHelper.ConverDataReaderToDataTable(reader); } } catch (Exception) { table2 = null; } return(table2); }
public DataTable GetMemberCoupons(MemberCouponsSearch search, ref int total) { DataTable table3; try { StringBuilder builder = new StringBuilder(" 1=1 "); total = 0; if (!string.IsNullOrEmpty(search.CouponName)) { builder.Append(" and a.CouponName like '%" + search.CouponName.ReplaceSingleQuoteMark() + "%' "); } if (!string.IsNullOrEmpty(search.OrderNo)) { builder.Append(" and OrderNo='" + search.OrderNo.ReplaceSingleQuoteMark() + "' "); } if (search.MemberId > 0) { builder.Append(" and MemberId='" + search.MemberId.ToString() + "' "); } int result = 0; if (!string.IsNullOrEmpty(search.Status) && int.TryParse(search.Status, out result)) { builder.Append(" and a.Status='" + result.ToString() + "' "); } if (search.MemberId > 0) { builder.Append(" and getdate()<=a.EndDate "); } string query = "select count(id) as total from Hishop_Coupon_MemberCoupons a where " + builder.ToString(); DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query); using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand)) { DataTable table = DataHelper.ConverDataReaderToDataTable(reader); total = int.Parse(table.Rows[0][0].ToString()); } if (total <= 0) { return(null); } int num2 = search.PageIndex * search.PageSize; if ((search.PageIndex != 0) && (search.PageSize != 0)) { int pageSize = search.PageSize; if (search.PageIndex >= Math.Ceiling((double)(((double)total) / ((double)search.PageSize)))) { search.PageIndex = int.Parse(Math.Ceiling((double)(((double)total) / ((double)search.PageSize))).ToString()); } int num3 = search.PageIndex * search.PageSize; if (num3 > total) { int num8 = search.PageSize; } } int num4 = ((search.PageIndex - 1) * search.PageSize) + 1; int num5 = (num4 + search.PageSize) - 1; string.Format("select top {0} a.* , b.userName,c.IsAllProduct from Hishop_Coupon_MemberCoupons a inner join Hishop_Coupon_Coupons c on c.CouponId=a.CouponId left join aspnet_Members b on a.memberid=b.userId where ", num2); string str2 = string.Empty; str2 = string.Concat(new object[] { "with cr as (select ROW_NUMBER() OVER (ORDER BY a.ReceiveDate desc) as [RowIndex] ,a.* , b.userName,c.IsAllProduct from Hishop_Coupon_MemberCoupons a inner join Hishop_Coupon_Coupons c on c.CouponId=a.CouponId left join aspnet_Members b on a.memberid=b.userId where ", builder.ToString(), " ) select * from cr where [RowIndex] BETWEEN ", num4, " AND ", num5, " order by RowIndex" }); sqlStringCommand = this.database.GetSqlStringCommand(str2); using (IDataReader reader2 = this.database.ExecuteReader(sqlStringCommand)) { table3 = DataHelper.ConverDataReaderToDataTable(reader2); } } catch (Exception) { table3 = null; } return(table3); }
protected override void AttachChildControls() { PageTitle.AddSiteNameTitle("我的优惠券"); this.txtTotal = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("txtTotal"); this.txtShowTabNum = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("txtShowTabNum"); this.rptActivity = (VshopTemplatedRepeater)this.FindControl("rptActivity"); string value = "0"; this.txtShowTabNum.Value = value; PrizesDeliveQuery prizesDeliveQuery = new PrizesDeliveQuery(); int pageIndex; if (!int.TryParse(this.Page.Request.QueryString["page"], out pageIndex)) { pageIndex = 1; } int pageSize; if (!int.TryParse(this.Page.Request.QueryString["size"], out pageSize)) { pageSize = 20; } MemberCouponsSearch memberCouponsSearch = new MemberCouponsSearch(); memberCouponsSearch.CouponName = ""; memberCouponsSearch.Status = "0"; memberCouponsSearch.MemberId = Globals.GetCurrentMemberUserId(false); memberCouponsSearch.IsCount = true; memberCouponsSearch.PageIndex = pageIndex; memberCouponsSearch.PageSize = pageSize; memberCouponsSearch.SortBy = "CouponId"; memberCouponsSearch.SortOrder = SortAction.Desc; int num = 0; DataTable memberCoupons = CouponHelper.GetMemberCoupons(memberCouponsSearch, ref num); if (memberCoupons != null) { if (memberCoupons.Rows.Count > 0) { memberCoupons.Columns.Add("useConditon"); memberCoupons.Columns.Add("sStatus"); for (int i = 0; i < memberCoupons.Rows.Count; i++) { decimal d = decimal.Parse(memberCoupons.Rows[i]["ConditionValue"].ToString()); if (d == 0m) { memberCoupons.Rows[i]["useConditon"] = "无消费额限制"; } else { memberCoupons.Rows[i]["useConditon"] = "满" + d.ToString("F2") + "可使用"; } memberCoupons.Rows[i]["sStatus"] = ((int.Parse(memberCoupons.Rows[i]["Status"].ToString()) == 0) ? "已领用" : "已使用"); } } } MemberInfo currentMember = MemberProcessor.GetCurrentMember(); this.rptActivity.DataSource = memberCoupons; this.rptActivity.DataBind(); this.txtTotal.SetWhenIsNotNull(num.ToString()); }
protected override void AttachChildControls() { PageTitle.AddSiteNameTitle("会员中心"); MemberInfo currentMemberInfo = this.CurrentMemberInfo; if (currentMemberInfo == null) { this.Page.Response.Redirect("/logout.aspx"); } else { int currentMemberUserId = Globals.GetCurrentMemberUserId(false); this.UserBindName = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("UserBindName"); this.UserBindName.Value = currentMemberInfo.UserBindName; this.UpClassInfo = (System.Web.UI.HtmlControls.HtmlContainerControl) this.FindControl("UpClassInfo"); this.litUserName = (System.Web.UI.WebControls.Literal) this.FindControl("litUserName"); this.litPoints = (System.Web.UI.WebControls.Literal) this.FindControl("litPoints"); this.litPoints.Text = currentMemberInfo.Points.ToString(); this.image = (System.Web.UI.WebControls.Image) this.FindControl("image"); this.usePoints = (System.Web.UI.WebControls.Literal) this.FindControl("usePoints"); this.usePoints.Text = currentMemberInfo.Points.ToString(); this.litAmount = (System.Web.UI.WebControls.Literal) this.FindControl("litAmount"); this.litAmount.Text = System.Math.Round(currentMemberInfo.AvailableAmount, 2).ToString(); MemberCouponsSearch memberCouponsSearch = new MemberCouponsSearch(); memberCouponsSearch.CouponName = ""; memberCouponsSearch.Status = "0"; memberCouponsSearch.MemberId = currentMemberUserId; memberCouponsSearch.IsCount = true; memberCouponsSearch.PageIndex = 1; memberCouponsSearch.PageSize = 10; memberCouponsSearch.SortBy = "CouponId"; memberCouponsSearch.SortOrder = SortAction.Desc; int num = 0; DataTable memberCoupons = CouponHelper.GetMemberCoupons(memberCouponsSearch, ref num); this.litCoupon = (System.Web.UI.WebControls.Literal) this.FindControl("litCoupon"); this.litCoupon.Text = num.ToString(); //将coupon改为奶券数量 this.litCoupon.Text = VShopHelper.GetMilkCardCount(currentMemberInfo.UserId).ToString(); this.litBindUser = (System.Web.UI.WebControls.Literal) this.FindControl("litBindUser"); this.litExpenditure = (System.Web.UI.WebControls.Literal) this.FindControl("litExpenditure"); this.litExpenditure.SetWhenIsNotNull("¥" + currentMemberInfo.Expenditure.ToString("F2")); if (!string.IsNullOrEmpty(currentMemberInfo.UserBindName)) { this.litBindUser.Text = " style=\"display:none\""; } MemberGradeInfo memberGrade = MemberProcessor.GetMemberGrade(currentMemberInfo.GradeId); this.litrGradeName = (System.Web.UI.WebControls.Literal) this.FindControl("litrGradeName"); if (memberGrade != null) { this.litrGradeName.Text = memberGrade.Name; } else { this.litrGradeName.Text = "普通会员"; } this.litUserName.Text = (string.IsNullOrEmpty(currentMemberInfo.OpenId) ? (string.IsNullOrEmpty(currentMemberInfo.RealName) ? currentMemberInfo.UserName : currentMemberInfo.RealName) : currentMemberInfo.UserName); SiteSettings masterSettings = SettingsManager.GetMasterSettings(true); this.fxCenter = (System.Web.UI.WebControls.Literal) this.FindControl("fxCenter"); this.fxCenter.Text = masterSettings.DistributorCenterName; this.IsSign = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("IsSign"); if (!masterSettings.sign_score_Enable) { this.IsSign.Value = "-1"; } else if (!UserSignHelper.IsSign(currentMemberInfo.UserId)) { this.IsSign.Value = "1"; } if (!string.IsNullOrEmpty(currentMemberInfo.UserHead)) { this.image.ImageUrl = currentMemberInfo.UserHead; } this.txtWaitForstr = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("txtWaitForstr"); OrderQuery orderQuery = new OrderQuery(); orderQuery.Status = OrderStatus.WaitBuyerPay; int userOrderCount = MemberProcessor.GetUserOrderCount(currentMemberUserId, orderQuery); orderQuery.Status = OrderStatus.SellerAlreadySent; int userOrderCount2 = MemberProcessor.GetUserOrderCount(currentMemberUserId, orderQuery); orderQuery.Status = OrderStatus.BuyerAlreadyPaid; int userOrderCount3 = MemberProcessor.GetUserOrderCount(currentMemberUserId, orderQuery); int waitCommentByUserID = ProductBrowser.GetWaitCommentByUserID(currentMemberUserId); int userOrderReturnCount = MemberProcessor.GetUserOrderReturnCount(currentMemberUserId); this.txtWaitForstr.Value = string.Concat(new string[] { userOrderCount.ToString(), "|", userOrderCount3.ToString(), "|", userOrderCount2.ToString(), "|", waitCommentByUserID.ToString(), "|", userOrderReturnCount.ToString() }); DistributorsInfo userIdDistributors = DistributorsBrower.GetUserIdDistributors(currentMemberUserId); this.txtShowDis = (System.Web.UI.HtmlControls.HtmlInputHidden) this.FindControl("txtShowDis"); if (userIdDistributors == null || userIdDistributors.ReferralStatus != 0) { this.txtShowDis.Value = "false"; } else { this.txtShowDis.Value = "true"; } System.Collections.Generic.IList <MemberGradeInfo> memberGrades = MemberHelper.GetMemberGrades(); MemberGradeInfo memberGradeInfo = null; foreach (MemberGradeInfo current in memberGrades) { double?tranVol = memberGrade.TranVol; double?tranVol2 = current.TranVol; if (tranVol.GetValueOrDefault() < tranVol2.GetValueOrDefault() || !(tranVol.HasValue & tranVol2.HasValue) || !(memberGrade.TranTimes >= current.TranTimes)) { tranVol = memberGrade.TranVol; tranVol2 = current.TranVol; if ((tranVol.GetValueOrDefault() < tranVol2.GetValueOrDefault() && (tranVol.HasValue & tranVol2.HasValue)) || memberGrade.TranTimes < current.TranTimes) { if (memberGradeInfo == null) { memberGradeInfo = current; } else { tranVol = memberGradeInfo.TranVol; tranVol2 = current.TranVol; if ((tranVol.GetValueOrDefault() > tranVol2.GetValueOrDefault() && (tranVol.HasValue & tranVol2.HasValue)) || memberGradeInfo.TranTimes > current.TranTimes) { memberGradeInfo = current; } } } } } if (memberGradeInfo == null) { this.UpClassInfo.Visible = false; } else { int num2 = 0; if (memberGradeInfo.TranTimes.HasValue) { num2 = memberGradeInfo.TranTimes.Value - currentMemberInfo.OrderNumber; } if (num2 <= 0) { num2 = 1; } decimal d = 0m; if (memberGradeInfo.TranVol.HasValue) { d = (decimal)memberGradeInfo.TranVol.Value - currentMemberInfo.Expenditure; } if (d <= 0m) { d = 0.01m; } this.UpClassInfo.InnerHtml = string.Concat(new string[] { "再交易<span>", num2.ToString(), "次 </span>或消费<span> ", System.Math.Round(d + 0.49m, 0).ToString(), "元 </span>升级" }); } } }
public System.Data.DataTable GetMemberCoupons(MemberCouponsSearch search, ref int total) { System.Data.DataTable result; try { StringBuilder stringBuilder = new StringBuilder(" 1=1 "); total = 0; if (!string.IsNullOrEmpty(search.CouponName)) { stringBuilder.Append(" and a.CouponName like '%" + search.CouponName.ReplaceSingleQuoteMark() + "%' "); } if (!string.IsNullOrEmpty(search.OrderNo)) { stringBuilder.Append(" and OrderNo='" + search.OrderNo.ReplaceSingleQuoteMark() + "' "); } if (search.MemberId > 0) { stringBuilder.Append(" and MemberId='" + search.MemberId.ToString() + "' "); } int num = 0; if (!string.IsNullOrEmpty(search.Status) && int.TryParse(search.Status, out num)) { stringBuilder.Append(" and a.Status='" + num.ToString() + "' "); } if (search.MemberId > 0) { stringBuilder.Append(" and getdate()<=a.EndDate "); } string query = "select count(id) as total from Hishop_Coupon_MemberCoupons a where " + stringBuilder.ToString(); System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query); using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { System.Data.DataTable dataTable = DataHelper.ConverDataReaderToDataTable(dataReader); total = int.Parse(dataTable.Rows[0][0].ToString()); } if (total <= 0) { result = null; } else { int num2 = search.PageIndex * search.PageSize; if (search.PageIndex != 0 && search.PageSize != 0) { int num3 = search.PageSize; if ((double)search.PageIndex >= Math.Ceiling((double)total / (double)search.PageSize)) { search.PageIndex = int.Parse(Math.Ceiling((double)total / (double)search.PageSize).ToString()); } int num4 = search.PageIndex * search.PageSize; if (num4 > total) { num3 = search.PageSize - (num4 - total); } } int num5 = (search.PageIndex - 1) * search.PageSize + 1; int num6 = num5 + search.PageSize - 1; string text = string.Format("select top {0} a.* , b.userName,c.IsAllProduct from Hishop_Coupon_MemberCoupons a inner join Hishop_Coupon_Coupons c on c.CouponId=a.CouponId left join aspnet_Members b on a.memberid=b.userId where ", num2); string query2 = string.Empty; query2 = string.Concat(new object[] { "with cr as (select ROW_NUMBER() OVER (ORDER BY a.ReceiveDate desc) as [RowIndex] ,a.* , b.userName,c.IsAllProduct from Hishop_Coupon_MemberCoupons a inner join Hishop_Coupon_Coupons c on c.CouponId=a.CouponId left join aspnet_Members b on a.memberid=b.userId where ", stringBuilder.ToString(), " ) select * from cr where [RowIndex] BETWEEN ", num5, " AND ", num6, " order by RowIndex" }); sqlStringCommand = this.database.GetSqlStringCommand(query2); using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { System.Data.DataTable dataTable = DataHelper.ConverDataReaderToDataTable(dataReader); result = dataTable; } } } catch (Exception) { result = null; } return(result); }
protected override void AttachChildControls() { PageTitle.AddSiteNameTitle("会员中心"); MemberInfo currentMemberInfo = base.CurrentMemberInfo; if (currentMemberInfo == null) { this.Page.Response.Redirect("/logout.aspx"); } else { int currentMemberUserId = Globals.GetCurrentMemberUserId(false); this.UserBindName = (HtmlInputHidden)this.FindControl("UserBindName"); this.UserBindName.Value = currentMemberInfo.UserBindName; this.UpClassInfo = (HtmlContainerControl)this.FindControl("UpClassInfo"); this.litUserName = (Literal)this.FindControl("litUserName"); this.litPoints = (Literal)this.FindControl("litPoints"); this.litPoints.Text = currentMemberInfo.Points.ToString(); this.image = (Image)this.FindControl("image"); this.usePoints = (Literal)this.FindControl("usePoints"); this.usePoints.Text = currentMemberInfo.Points.ToString(); this.litAmount = (Literal)this.FindControl("litAmount"); this.litAmount.Text = Math.Round(currentMemberInfo.AvailableAmount, 2).ToString(); MemberCouponsSearch search = new MemberCouponsSearch { CouponName = "", Status = "0", MemberId = currentMemberUserId, IsCount = true, PageIndex = 1, PageSize = 10, SortBy = "CouponId", SortOrder = SortAction.Desc }; int total = 0; CouponHelper.GetMemberCoupons(search, ref total); this.litCoupon = (Literal)this.FindControl("litCoupon"); this.litCoupon.Text = total.ToString(); this.litBindUser = (Literal)this.FindControl("litBindUser"); this.litExpenditure = (Literal)this.FindControl("litExpenditure"); this.litExpenditure.SetWhenIsNotNull("¥" + currentMemberInfo.Expenditure.ToString("F2")); if (!string.IsNullOrEmpty(currentMemberInfo.UserBindName)) { this.litBindUser.Text = " style=\"display:none\""; } MemberGradeInfo memberGrade = MemberProcessor.GetMemberGrade(currentMemberInfo.GradeId); this.litrGradeName = (Literal)this.FindControl("litrGradeName"); if (memberGrade != null) { this.litrGradeName.Text = memberGrade.Name; } else { this.litrGradeName.Text = "普通会员"; } this.litUserName.Text = string.IsNullOrEmpty(currentMemberInfo.OpenId) ? (string.IsNullOrEmpty(currentMemberInfo.RealName) ? currentMemberInfo.UserName : currentMemberInfo.RealName) : currentMemberInfo.UserName; SiteSettings masterSettings = SettingsManager.GetMasterSettings(true); this.fxCenter = (Literal)this.FindControl("fxCenter"); this.fxCenter.Text = masterSettings.DistributorCenterName; this.IsSign = (HtmlInputHidden)this.FindControl("IsSign"); if (!masterSettings.sign_score_Enable) { this.IsSign.Value = "-1"; } else if (!UserSignHelper.IsSign(currentMemberInfo.UserId)) { this.IsSign.Value = "1"; } if (!string.IsNullOrEmpty(currentMemberInfo.UserHead)) { this.image.ImageUrl = currentMemberInfo.UserHead; } this.txtWaitForstr = (HtmlInputHidden)this.FindControl("txtWaitForstr"); OrderQuery query = new OrderQuery { Status = OrderStatus.WaitBuyerPay }; int userOrderCount = MemberProcessor.GetUserOrderCount(currentMemberUserId, query); query.Status = OrderStatus.SellerAlreadySent; int num4 = MemberProcessor.GetUserOrderCount(currentMemberUserId, query); query.Status = OrderStatus.BuyerAlreadyPaid; int num5 = MemberProcessor.GetUserOrderCount(currentMemberUserId, query); int waitCommentByUserID = ProductBrowser.GetWaitCommentByUserID(currentMemberUserId); int userOrderReturnCount = MemberProcessor.GetUserOrderReturnCount(currentMemberUserId); this.txtWaitForstr.Value = userOrderCount.ToString() + "|" + num5.ToString() + "|" + num4.ToString() + "|" + waitCommentByUserID.ToString() + "|" + userOrderReturnCount.ToString(); DistributorsInfo userIdDistributors = DistributorsBrower.GetUserIdDistributors(currentMemberUserId); this.txtShowDis = (HtmlInputHidden)this.FindControl("txtShowDis"); if ((userIdDistributors == null) || (userIdDistributors.ReferralStatus != 0)) { this.txtShowDis.Value = "false"; } else { this.txtShowDis.Value = "true"; } IList <MemberGradeInfo> memberGrades = MemberHelper.GetMemberGrades(); MemberGradeInfo info4 = null; foreach (MemberGradeInfo info5 in memberGrades) { double?tranVol = memberGrade.TranVol; double?nullable2 = info5.TranVol; if ((tranVol.GetValueOrDefault() >= nullable2.GetValueOrDefault()) && (tranVol.HasValue & nullable2.HasValue)) { int?tranTimes = memberGrade.TranTimes; int?nullable4 = info5.TranTimes; if ((tranTimes.GetValueOrDefault() >= nullable4.GetValueOrDefault()) && (tranTimes.HasValue & nullable4.HasValue)) { continue; } } double?nullable5 = memberGrade.TranVol; double?nullable6 = info5.TranVol; if ((nullable5.GetValueOrDefault() >= nullable6.GetValueOrDefault()) || !(nullable5.HasValue & nullable6.HasValue)) { int?nullable7 = memberGrade.TranTimes; int?nullable8 = info5.TranTimes; if ((nullable7.GetValueOrDefault() >= nullable8.GetValueOrDefault()) || !(nullable7.HasValue & nullable8.HasValue)) { continue; } } if (info4 == null) { info4 = info5; } else { double?nullable9 = info4.TranVol; double?nullable10 = info5.TranVol; if ((nullable9.GetValueOrDefault() <= nullable10.GetValueOrDefault()) || !(nullable9.HasValue & nullable10.HasValue)) { int?nullable11 = info4.TranTimes; int?nullable12 = info5.TranTimes; if ((nullable11.GetValueOrDefault() <= nullable12.GetValueOrDefault()) || !(nullable11.HasValue & nullable12.HasValue)) { continue; } } info4 = info5; } } if (info4 == null) { this.UpClassInfo.Visible = false; } else { int num8 = 0; if (info4.TranTimes.HasValue) { num8 = info4.TranTimes.Value - currentMemberInfo.OrderNumber; } if (num8 <= 0) { num8 = 1; } decimal num9 = 0M; if (info4.TranVol.HasValue) { num9 = ((decimal)info4.TranVol.Value) - currentMemberInfo.Expenditure; } if (num9 <= 0M) { num9 = 0.01M; } this.UpClassInfo.InnerHtml = "再交易<span>" + num8.ToString() + "次 </span>或消费<span> " + Math.Round((decimal)(num9 + 0.49M), 0).ToString() + "元 </span>升级"; } } }