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>升级";
}
}
}
