protected void Page_Load(object sender, EventArgs e) { LoadParameters(); if (!Page.IsPostBack) { if (userId != 0) { Member member = UnderlingHelper.GetMember(userId); if (member != null) { litBalance.Text = member.Balance.ToString("F2"); litDrawBalance.Text = member.RequestBalance.ToString("F2"); litUserBalance.Text = (member.Balance - member.RequestBalance).ToString("F2"); MemberGradeInfo memberGrade = UnderlingHelper.GetMemberGrade(member.GradeId); if (memberGrade != null) { litUser.Text = member.Username + "(" + memberGrade.Name + ")"; } else { litUser.Text = member.Username; } } } BindBalanceDetails(); } }
protected override void AttachChildControls() { PageTitle.AddSiteNameTitle("推广员"); Member member = HiContext.Current.User as Member; if (member == null) { return; } this.litUserLink = (System.Web.UI.WebControls.Literal) this.FindControl("litUserLink"); this.litUserName = (System.Web.UI.WebControls.Literal) this.FindControl("litUserName"); this.litPaymentBalance = (System.Web.UI.WebControls.Literal) this.FindControl("litPaymentBalance"); this.litExpenditure = (System.Web.UI.WebControls.Literal) this.FindControl("litExpenditure"); this.litExpenditure.SetWhenIsNotNull(member.Expenditure.ToString("F2")); this.litPaymentBalance.SetWhenIsNotNull(member.Balance.ToString("F2")); this.litPoints = (System.Web.UI.WebControls.Literal) this.FindControl("litPoints"); this.litPoints.SetWhenIsNotNull(member.Points.ToString("F2")); this.litMemberGrade = (System.Web.UI.WebControls.Literal) this.FindControl("litMemberGrade"); MemberGradeInfo memberGrade = MemberProcessor.GetMemberGrade(member.GradeId); if (memberGrade != null) { this.litMemberGrade.SetWhenIsNotNull(memberGrade.Name); } this.litUserName.Text = (string.IsNullOrEmpty(member.RealName) ? member.Username : member.RealName); }
public static bool CreateMemberGrade(MemberGradeInfo memberGrade) { bool result; if (null == memberGrade) { result = false; } else { Globals.EntityCoding(memberGrade, true); bool flag = MemberHelper.IsCanSetThisGrade(memberGrade); if (!flag) { throw new Exception("交易次数的上下级别,与交易额的上下级别不是同一个!"); } flag = new MemberGradeDao().CreateMemberGrade(memberGrade); if (flag) { EventLogs.WriteOperationLog(Privilege.AddMemberGrade, string.Format(CultureInfo.InvariantCulture, "添加了名为 “{0}” 的会员等级", new object[] { memberGrade.Name })); } result = flag; } return(result); }
private static bool IsCanSetThisGrade(MemberGradeInfo memberGrade) { List <MemberGradeInfo> list = MemberHelper.GetMemberGrades().ToList <MemberGradeInfo>(); int num = 0; int num2 = 0; foreach (MemberGradeInfo current in list) { if (current.GradeId != memberGrade.GradeId) { if (current.TranVol.HasValue && memberGrade.TranVol.HasValue) { if (current.TranVol.Value > memberGrade.TranVol.Value) { num++; } } if (current.TranTimes.HasValue && memberGrade.TranTimes.HasValue) { if (current.TranTimes.Value > memberGrade.TranTimes.Value) { num2++; } } } } return(num == num2); }
private void LoadMemberInfo() { MemberInfo member = MemberHelper.GetMember(this.currentUserId); if (member == null) { base.GotoResourceNotFound(); } else { Uri url = HttpContext.Current.Request.Url; this.litUserName.Text = member.UserName; MemberGradeInfo memberGrade = MemberHelper.GetMemberGrade(member.GradeId); if (memberGrade != null) { this.litGrade.Text = memberGrade.Name; } this.litCreateDate.Text = member.CreateDate.ToString(); this.litRealName.Text = member.RealName; this.litAddress.Text = RegionHelper.GetFullRegion(member.RegionId, "") + member.Address; this.litQQ.Text = member.QQ; this.litCellPhone.Text = member.CellPhone; this.litEmail.Text = member.Email; this.litOpenId.Text = member.OpenId; this.litAlipayOpenid.Text = member.AlipayOpenid; this.txtCardID.Text = member.CardID; this.litUserBindName.Text = member.UserBindName; } }
public override bool HasSamePointMemberGrade(MemberGradeInfo memberGrade) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT COUNT(GradeId) as Count FROM aspnet_MemberGrades WHERE Points=@Points AND GradeId<>@GradeId;"); this.database.AddInParameter(sqlStringCommand, "Points", System.Data.DbType.Int32, memberGrade.Points); this.database.AddInParameter(sqlStringCommand, "GradeId", System.Data.DbType.Int32, memberGrade.GradeId); return((int)this.database.ExecuteScalar(sqlStringCommand) > 0); }
protected void Page_Load(object sender, EventArgs e) { if (!int.TryParse(this.Page.Request.QueryString["GradeId"], out this.gradeId)) { base.GotoResourceNotFound(); } else if (!this.Page.IsPostBack) { MemberGradeInfo memberGrade = MemberHelper.GetMemberGrade(this.gradeId); if (memberGrade == null) { base.GotoResourceNotFound(); } else { Globals.EntityCoding(memberGrade, false); this.txtRankName.Text = memberGrade.Name; this.txtRankDesc.Text = memberGrade.Description; TextBox textBox = this.txtPoint; int num = memberGrade.Points; textBox.Text = num.ToString(); TextBox textBox2 = this.txtValue; num = memberGrade.Discount; textBox2.Text = num.ToString(); } } }
protected void Page_Load(object sender, System.EventArgs e) { this.LoadParameters(); if (!this.Page.IsPostBack) { if (this.userId != 0) { Hidistro.Membership.Context.Member member = UnderlingHelper.GetMember(this.userId); if (member != null) { this.litBalance.Text = member.Balance.ToString("F2"); this.litDrawBalance.Text = member.RequestBalance.ToString("F2"); this.litUserBalance.Text = (member.Balance - member.RequestBalance).ToString("F2"); MemberGradeInfo memberGrade = UnderlingHelper.GetMemberGrade(member.GradeId); if (memberGrade != null) { this.litUser.Text = member.Username + "(" + memberGrade.Name + ")"; } else { this.litUser.Text = member.Username; } } } this.BindBalanceDetails(); } }
public override bool HasSamePointMemberGrade(MemberGradeInfo memberGrade) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(string.Format("SELECT COUNT(GradeId) as Count FROM distro_MemberGrades WHERE Points=@Points AND CreateUserId = {0} AND GradeId<>@GradeId;", HiContext.Current.User.UserId)); this.database.AddInParameter(sqlStringCommand, "Points", System.Data.DbType.Int32, memberGrade.Points); this.database.AddInParameter(sqlStringCommand, "GradeId", System.Data.DbType.Int32, memberGrade.GradeId); return((int)this.database.ExecuteScalar(sqlStringCommand) > 0); }
public virtual bool AddMemberGrade(MemberGradeInfo entity) { string SqlAdd = null; DataTable DtAdd = null; DataRow DrAdd = null; SqlAdd = "SELECT TOP 0 * FROM Member_Grade"; DtAdd = DBHelper.Query(SqlAdd); DrAdd = DtAdd.NewRow(); DrAdd["Member_Grade_ID"] = entity.Member_Grade_ID; DrAdd["Member_Grade_Name"] = entity.Member_Grade_Name; DrAdd["Member_Grade_Percent"] = entity.Member_Grade_Percent; DrAdd["Member_Grade_Default"] = entity.Member_Grade_Default; DrAdd["Member_Grade_RequiredCoin"] = entity.Member_Grade_RequiredCoin; DrAdd["Member_Grade_CoinRate"] = entity.Member_Grade_CoinRate; DrAdd["Member_Grade_Addtime"] = entity.Member_Grade_Addtime; DrAdd["Member_Grade_Site"] = entity.Member_Grade_Site; DtAdd.Rows.Add(DrAdd); try { DBHelper.SaveChanges(SqlAdd, DtAdd); return(true); } catch (Exception ex) { throw ex; } finally { DtAdd.Dispose(); } }
public virtual MemberGradeInfo GetMemberGradeByID(int ID) { MemberGradeInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Member_Grade WHERE Member_Grade_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new MemberGradeInfo(); entity.Member_Grade_ID = Tools.NullInt(RdrList["Member_Grade_ID"]); entity.Member_Grade_Name = Tools.NullStr(RdrList["Member_Grade_Name"]); entity.Member_Grade_Percent = Tools.NullInt(RdrList["Member_Grade_Percent"]); entity.Member_Grade_Default = Tools.NullInt(RdrList["Member_Grade_Default"]); entity.Member_Grade_RequiredCoin = Tools.NullInt(RdrList["Member_Grade_RequiredCoin"]); entity.Member_Grade_CoinRate = Tools.NullDbl(RdrList["Member_Grade_CoinRate"]); entity.Member_Grade_Addtime = Tools.NullDate(RdrList["Member_Grade_Addtime"]); entity.Member_Grade_Site = Tools.NullStr(RdrList["Member_Grade_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public void EditMemberGrade() { int Member_Grade_ID = tools.CheckInt(Request.Form["Member_Grade_ID"]); string Member_Grade_Name = tools.CheckStr(Request.Form["Member_Grade_Name"]); int Member_Grade_Percent = tools.CheckInt(Request.Form["Member_Grade_Percent"]); int Member_Grade_Default = tools.CheckInt(Request.Form["Member_Grade_Default"]); int Member_Grade_RequiredCoin = tools.CheckInt(Request.Form["Member_Grade_RequiredCoin"]); double Member_Grade_CoinRate = tools.CheckFloat(Request.Form["Member_Grade_CoinRate"]); MemberGradeInfo entity = new MemberGradeInfo(); entity.Member_Grade_ID = Member_Grade_ID; entity.Member_Grade_Name = Member_Grade_Name; entity.Member_Grade_Percent = Member_Grade_Percent; entity.Member_Grade_Default = Member_Grade_Default; entity.Member_Grade_RequiredCoin = Member_Grade_RequiredCoin; entity.Member_Grade_CoinRate = Member_Grade_CoinRate; entity.Member_Grade_Addtime = DateTime.Now; entity.Member_Grade_Site = Public.GetCurrentSite(); if (MyBLL.EditMemberGrade(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "member_grade_list.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
protected override void AttachChildControls() { PageTitle.AddSiteNameTitle("我是买家"); MemberInfo currentMember = MemberProcessor.GetCurrentMember(); if (currentMember != null) { this.litUserName = (Literal)this.FindControl("litUserName"); this.litExpenditure = (Literal)this.FindControl("litExpenditure"); this.litExpenditure.SetWhenIsNotNull(currentMember.Expenditure.ToString("F2")); this.litMemberGrade = (Literal)this.FindControl("litMemberGrade"); MemberGradeInfo memberGrade = MemberProcessor.GetMemberGrade(currentMember.GradeId); if (memberGrade != null) { this.litMemberGrade.SetWhenIsNotNull(memberGrade.Name); } this.litUserName.Text = string.IsNullOrEmpty(currentMember.RealName) ? currentMember.UserName : currentMember.RealName; this.Page.Session["stylestatus"] = "1"; this.litWaitForRecieveCount = (Literal)this.FindControl("litWaitForRecieveCount"); this.litWaitForPayCount = (Literal)this.FindControl("litWaitForPayCount"); OrderQuery query = new OrderQuery { Status = OrderStatus.WaitBuyerPay }; int userOrderCount = MemberProcessor.GetUserOrderCount(Globals.GetCurrentMemberUserId(), query); this.litWaitForPayCount.SetWhenIsNotNull(userOrderCount.ToString()); query.Status = OrderStatus.SellerAlreadySent; this.litWaitForRecieveCount.SetWhenIsNotNull(MemberProcessor.GetUserOrderCount(Globals.GetCurrentMemberUserId(), query).ToString()); } }
public bool HasSameMemberGrade(MemberGradeInfo memberGrade) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT COUNT(GradeId) as Count FROM aspnet_MemberGrades WHERE ((TranVol=@TranVol and TranVol is not null ) or (TranTimes=@TranTimes and TranTimes is not null)) AND GradeId<>@GradeId;"); this.database.AddInParameter(sqlStringCommand, "TranVol", System.Data.DbType.Double, memberGrade.TranVol); this.database.AddInParameter(sqlStringCommand, "TranTimes", System.Data.DbType.Int32, memberGrade.TranTimes); this.database.AddInParameter(sqlStringCommand, "GradeId", System.Data.DbType.Int32, memberGrade.GradeId); return((int)this.database.ExecuteScalar(sqlStringCommand) > 0); }
protected override void AttachChildControls() { this.litUserName = (Literal)this.FindControl("litUserName"); this.litUserPoint = (Literal)this.FindControl("litUserPoint"); this.litUserRank = (Literal)this.FindControl("litUserRank"); this.litUserLink = (Literal)this.FindControl("litUserLink"); this.litNoPayOrderNum = (Literal)this.FindControl("litNoPayOrderNum"); this.litNoReplyLeaveWordNum = (Literal)this.FindControl("litNoReplyLeaveWordNum"); this.litAccountAmount = (FormatedMoneyLabel)this.FindControl("litAccountAmount"); this.litRequestBalance = (FormatedMoneyLabel)this.FindControl("litRequestBalance"); this.litUseableBalance = (FormatedMoneyLabel)this.FindControl("litUseableBalance"); this.hpOrder = (HyperLink)this.FindControl("hpOrder"); this.hpMes = (HyperLink)this.FindControl("hpMes"); this.hpRepay = (HyperLink)this.FindControl("hpRepaly"); this.divBalance = (HtmlGenericControl)this.FindControl("divBalance"); this.divOpenBalance = (HtmlGenericControl)this.FindControl("divOpenBalance"); PageTitle.AddSiteNameTitle("会员中心首页", HiContext.Current.Context); if (!this.Page.IsPostBack) { Member user = Users.GetUser(HiContext.Current.User.UserId, false) as Member; if (!user.IsOpenBalance) { this.divBalance.Visible = false; this.divOpenBalance.Visible = true; } this.litUserPoint.Text = user.Points.ToString(); this.litUserName.Text = user.Username; MemberGradeInfo memberGrade = PersonalHelper.GetMemberGrade(user.GradeId); if (memberGrade != null) { this.litUserRank.Text = memberGrade.Name; } int noPayOrderNum = 0; int noReadMessageNum = 0; int noReplyLeaveCommentNum = 0; PersonalHelper.GetStatisticsNum(out noPayOrderNum, out noReadMessageNum, out noReplyLeaveCommentNum); this.litNoPayOrderNum.Text = noPayOrderNum.ToString(); this.litNoReplyLeaveWordNum.Text = noReplyLeaveCommentNum.ToString(); this.hpMes.Text = noReadMessageNum.ToString(); this.litAccountAmount.Money = user.Balance; this.litRequestBalance.Money = user.RequestBalance; this.litUseableBalance.Money = user.Balance - user.RequestBalance; if (noPayOrderNum > 0) { this.hpOrder.Visible = true; this.hpOrder.NavigateUrl = "UserOrders.aspx?orderStatus=" + 1; } this.hpMes.NavigateUrl = "UserReceivedMessages.aspx"; if (noReplyLeaveCommentNum > 0) { this.hpRepay.Visible = true; this.hpRepay.NavigateUrl = "UserConsultations.aspx"; } Uri url = HttpContext.Current.Request.Url; string str = (url.Port == 80) ? string.Empty : (":" + url.Port.ToString(CultureInfo.InvariantCulture)); this.litUserLink.Text = string.Concat(new object[] { string.Format(CultureInfo.InvariantCulture, "{0}://{1}{2}", new object[] { url.Scheme, HiContext.Current.SiteSettings.SiteUrl, str }), Globals.ApplicationPath, "/?ReferralUserId=", HiContext.Current.User.UserId }); } }
public bool HasSamePointMemberGrade(MemberGradeInfo memberGrade) { DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT COUNT(GradeId) as Count FROM aspnet_MemberGrades WHERE Points=@Points AND GradeId<>@GradeId and wid=@wid;"); this.database.AddInParameter(sqlStringCommand, "Points", DbType.Int32, memberGrade.Points); this.database.AddInParameter(sqlStringCommand, "GradeId", DbType.Int32, memberGrade.GradeId); this.database.AddInParameter(sqlStringCommand, "wid", DbType.String, memberGrade.wid); return(((int)this.database.ExecuteScalar(sqlStringCommand)) > 0); }
private bool DoAdd() { bool result = false; SF.BLL.sf_website bll = new SF.BLL.sf_website(); SF.Model.sf_website model = new SF.Model.sf_website(); ManagerInfo model1 = (ManagerInfo)Session[DTKeys.SESSION_ADMIN_INFO]; //model.businessNum = model1.businessNum; model.sitename = txtsitename.Text.Trim(); //model.appid_name = txtappid_name.Text.Trim(); //model.appid_origin_id = txtappid_origin_id.Text.Trim(); //model.weixin_account = txtweixin_account.Text.Trim(); //model.avatar = txtavatar.Text; //model.interface_url = txtinterface_url.Text.Trim(); //model.token_value = txttoken_value.Text.Trim(); //if (string.IsNullOrEmpty(model.token_value)) //{ // //model.token_value = this.CreateKey(8); //} //model.encodingaeskey = txtencodingaeskey.Text.Trim(); //model.appid = txtappid.Text.Trim().Trim(); //model.appsecret = txtappsecret.Text.Trim(); //model.payment_name = txtpayment_name.Text; ////model.state = cbstate.Checked ? 1 : 0; //model.weixin_pay_account = txtweixin_pay_account.Text.Trim(); //model.account_pay_key = txtaccount_pay_key.Text.Trim(); //model.send_type = int.Parse(rblsend_type.SelectedValue); //model.logo = txtlogo.Text; //model.description = txtdescription.Text; model.create_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.create_user = model1.realname; model.mid = model1.UserId; model.wid = "W" + SFUtils.GetCheckCode(4).ToString() + DateTime.Now.ToString("yyyyMMddHHmmss"); if (bll.Add(model) > 0) { //AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加公众服务号:" + model.appid_name); //记录日志 //1.拷贝默认模板 CopyTemplate(model.wid); //2.增加默认会员类别 MemberGradeInfo memberGrade = new MemberGradeInfo(); memberGrade.wid = model.wid; memberGrade.Name = "普通会员"; memberGrade.Description = "普通会员"; memberGrade.IsDefault = true; memberGrade.TranVol = 999999999.00; memberGrade.TranTimes = 999999999; //折扣 memberGrade.Discount = 100; result = MemberHelper.CreateMemberGrade(memberGrade); } return(result); }
public override bool UpdateMemberGrade(MemberGradeInfo memberGrade) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("UPDATE aspnet_MemberGrades SET [Name] = @Name, Description = @Description, Points = @Points, Discount = @Discount WHERE GradeId = @GradeId"); this.database.AddInParameter(sqlStringCommand, "Name", System.Data.DbType.String, memberGrade.Name); this.database.AddInParameter(sqlStringCommand, "Description", System.Data.DbType.String, memberGrade.Description); this.database.AddInParameter(sqlStringCommand, "Points", System.Data.DbType.Int32, memberGrade.Points); this.database.AddInParameter(sqlStringCommand, "Discount", System.Data.DbType.Int32, memberGrade.Discount); this.database.AddInParameter(sqlStringCommand, "GradeId", System.Data.DbType.Int32, memberGrade.GradeId); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
private void btnSubmitMemberRanks_Click(object sender, System.EventArgs e) { string text = string.Empty; if (this.txtValue.Text.Trim().Contains(".")) { this.ShowMsg("折扣必须为正整数", false); return; } MemberGradeInfo memberGradeInfo = new MemberGradeInfo(); memberGradeInfo.Name = this.txtRankName.Text.Trim(); memberGradeInfo.Description = this.txtRankDesc.Text.Trim(); int points; if (int.TryParse(this.txtPoint.Text.Trim(), out points)) { memberGradeInfo.Points = points; } else { text += Formatter.FormatErrorMessage("积分设置无效或不能为空,必须大于等于0的整数"); } memberGradeInfo.IsDefault = this.chkIsDefault.SelectedValue; int discount; if (int.TryParse(this.txtValue.Text, out discount)) { memberGradeInfo.Discount = discount; } else { text += Formatter.FormatErrorMessage("等级折扣设置无效或不能为空,等级折扣必须在1-10之间"); } if (!string.IsNullOrEmpty(text)) { this.ShowMsg(text, false); return; } if (!this.ValidationMemberGrade(memberGradeInfo)) { return; } if (MemberHelper.HasSamePointMemberGrade(memberGradeInfo)) { this.ShowMsg("已经存在相同积分的等级,每个会员等级的积分不能相同", false); return; } if (MemberHelper.CreateMemberGrade(memberGradeInfo)) { this.ShowMsg("成功添加了一个会员等级", true); return; } this.ShowMsg("添加会员等级失败", false); }
private void btnSubmitMemberRanks_Click(object sender, EventArgs e) { string str = string.Empty; if (this.txtValue.Text.Trim().Contains(".")) { this.ShowMsg("折扣必须为正整数", false); } else { int num; int num2; MemberGradeInfo memberGrade = new MemberGradeInfo { GradeId = this.gradeId, Name = this.txtRankName.Text.Trim(), Description = this.txtRankDesc.Text.Trim(), recharge = int.Parse(this.txtRecharge.Text), }; if (int.TryParse(this.txtPoint.Text.Trim(), out num)) { memberGrade.Points = num; } else { str = str + Formatter.FormatErrorMessage("积分设置无效或不能为空,必须大于等于0的整数"); } if (int.TryParse(this.txtValue.Text, out num2)) { memberGrade.Discount = num2; } else { str = str + Formatter.FormatErrorMessage("等级折扣设置无效或不能为空,等级折扣必须在1-10之间"); } if (!string.IsNullOrEmpty(str)) { this.ShowMsg(str, false); } else if (this.ValidationMemberGrade(memberGrade)) { if (MemberHelper.HasSamePointMemberGrade(memberGrade)) { this.ShowMsg("已经存在相同积分的等级,每个会员等级的积分不能相同", false); } else if (MemberHelper.UpdateMemberGrade(memberGrade)) { this.ShowMsg("修改会员等级成功", true); } else { this.ShowMsg("修改会员等级失败", false); } } } }
public virtual bool EditMemberGrade(MemberGradeInfo entity, RBACUserInfo UserPrivilege) { if (RBAC.CheckPrivilege(UserPrivilege, "73df03fa-ef43-486a-9b4c-b9c3e834cbbb")) { return(MyDAL.EditMemberGrade(entity)); } else { throw new TradePrivilegeException("没有权限,权限代码:73df03fa-ef43-486a-9b4c-b9c3e834cbbb错误"); } }
private void IsDefault(HttpContext context) { int value = base.GetIntParam(context, "GradeId", false).Value; MemberGradeInfo memberGrade = MemberHelper.GetMemberGrade(value); if (!memberGrade.IsDefault) { MemberHelper.SetDefalutMemberGrade(value); base.ReturnSuccessResult(context, "", 0, true); } }
private void GetMember(System.Web.HttpContext context) { string text = context.Request["sessionid"]; if (string.IsNullOrEmpty(text)) { context.Response.Write(this.GetErrorJosn(101, "缺少必填参数")); return; } Member member = Users.GetUserBySessionId(text) as Member; if (member == null) { context.Response.Write(this.GetErrorJosn(107, "sessionid过期或不存在,请重新登录")); return; } string name = "Vshop-Member"; HttpCookie httpCookie = new HttpCookie("Vshop-Member"); httpCookie.Value = Globals.UrlEncode(member.Username); httpCookie.Expires = System.DateTime.Now.AddDays(7); httpCookie.Domain = HttpContext.Current.Request.Url.Host; if (HttpContext.Current.Response.Cookies[name] != null) { HttpContext.Current.Response.Cookies.Remove(name); } HttpContext.Current.Response.Cookies.Add(httpCookie); HiContext.Current.User = member; member.OnLogin(); MemberGradeInfo memberGrade = MemberProcessor.GetMemberGrade(member.GradeId); string arg = (memberGrade == null) ? "" : memberGrade.Name; OrderQuery orderQuery = new OrderQuery(); orderQuery.Status = OrderStatus.WaitBuyerPay; int userOrderCount = MemberProcessor.GetUserOrderCount(member.UserId, orderQuery); orderQuery.Status = OrderStatus.SellerAlreadySent; int userOrderCount2 = MemberProcessor.GetUserOrderCount(member.UserId, orderQuery); System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder(); stringBuilder.Append("{\"result\":{"); stringBuilder.AppendFormat("\"uid\":{0},", member.UserId); stringBuilder.AppendFormat("\"sessionid\":\"{0}\",", member.SessionId); stringBuilder.AppendFormat("\"gradeName\":\"{0}\",", arg); stringBuilder.AppendFormat("\"realName\":\"{0}\",", string.IsNullOrEmpty(member.RealName) ? member.Username : member.RealName); stringBuilder.AppendFormat("\"waitPayCount\":\"{0}\",", userOrderCount); stringBuilder.AppendFormat("\"waitFinishCount\":\"{0}\",", userOrderCount2); stringBuilder.AppendFormat("\"orderNumber\":\"{0}\",", member.OrderNumber); stringBuilder.AppendFormat("\"expenditure\":\"{0}\",", member.Expenditure.ToString("F2")); stringBuilder.AppendFormat("\"points\":\"{0}\"", member.Points); stringBuilder.Append("}}"); context.Response.Write(stringBuilder.ToString()); }
public virtual bool AddMemberGrade(MemberGradeInfo entity, RBACUserInfo UserPrivilege) { if (RBAC.CheckPrivilege(UserPrivilege, "603eef98-3a55-46d6-9e8e-81772645adeb")) { return(MyDAL.AddMemberGrade(entity)); } else { throw new TradePrivilegeException("没有权限,权限代码:603eef98-3a55-46d6-9e8e-81772645adeb错误"); } }
protected void Page_Load(object sender, EventArgs e) { if (!int.TryParse(this.Page.Request.QueryString["UserId"], out this.userid)) { base.GotoResourceNotFound(); } else { this.ListImage1.ImageUrl = "/Templates/common/images/user.png"; MemberInfo member = MemberHelper.GetMember(this.userid); if (member == null) { base.GotoResourceNotFound(); } else { if (!string.IsNullOrEmpty(member.UserHead)) { this.ListImage1.ImageUrl = member.UserHead; } this.txtUserName.InnerText = member.UserName; MemberGradeInfo memberGrade = MemberHelper.GetMemberGrade(member.GradeId); if (memberGrade != null) { this.txtGrade.InnerText = memberGrade.Name; } this.txtCellPhone.InnerText = member.CellPhone; this.txtCreateTime.InnerText = member.CreateDate.ToString(); this.txtMicroName.InnerText = member.UserName; this.txtRealName.InnerText = member.RealName; if (member.ReferralUserId <= 0) { this.txtRefStoreName.InnerText = "主站"; } else { DistributorsInfo userIdDistributors = VShopHelper.GetUserIdDistributors(member.ReferralUserId); if (userIdDistributors != null) { this.txtRefStoreName.InnerText = userIdDistributors.StoreName; } } this.txtAddress.InnerText = RegionHelper.GetFullRegion(member.RegionId, "") + member.Address; this.txtQQ.InnerText = member.QQ; this.txtOpenId.InnerText = member.OpenId; this.TotalReferral.InnerText = member.AvailableAmount.ToString("F2"); Dictionary <string, decimal> dataByUserId = MemberAmountProcessor.GetDataByUserId(this.userid); this.ReferralOrders.InnerText = dataByUserId["OrderCount"].ToString(); this.OrdersTotal.InnerText = dataByUserId["OrderTotal"].ToString("F2"); this.ReferralBlance.InnerText = dataByUserId["RequestAmount"].ToString("F2"); } } }
public MemberGradeInfo GetMemberGrade(int gradeId) { System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM aspnet_MemberGrades WHERE GradeId = @GradeId"); this.database.AddInParameter(sqlStringCommand, "GradeId", System.Data.DbType.Int32, gradeId); MemberGradeInfo result = null; using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { result = ReaderConvert.ReaderToModel <MemberGradeInfo>(dataReader); } return(result); }
public int CreateMemberGrade(MemberGradeInfo memberGrade) { string empty = string.Empty; if (memberGrade.IsDefault) { empty += "UPDATE aspnet_MemberGrades SET IsDefault = 0"; DbCommand sqlStringCommand = base.database.GetSqlStringCommand(empty); base.database.ExecuteNonQuery(sqlStringCommand); } return((int)this.Add(memberGrade, null)); }
public override bool UpdateUnderlingGrade(MemberGradeInfo underlingGrade) { string query = "UPDATE distro_MemberGrades SET [Name] = @Name, Description = @Description, Points = @Points, Discount = @Discount WHERE GradeId = @GradeId;"; DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query); this.database.AddInParameter(sqlStringCommand, "Name", DbType.String, underlingGrade.Name); this.database.AddInParameter(sqlStringCommand, "Description", DbType.String, underlingGrade.Description); this.database.AddInParameter(sqlStringCommand, "Points", DbType.Int32, underlingGrade.Points); this.database.AddInParameter(sqlStringCommand, "GradeId", DbType.Int32, underlingGrade.GradeId); this.database.AddInParameter(sqlStringCommand, "Discount", DbType.Currency, underlingGrade.Discount); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
private void btnSubmitMemberRanks_Click(object sender, EventArgs e) { string str = string.Empty; if (this.txtValue.Text.Trim().Contains(".")) { this.ShowMsg("折扣必须为正整数", false); } else { int num; int num2; MemberGradeInfo memberGrade = new MemberGradeInfo(); memberGrade.Name = this.txtRankName.Text.Trim(); memberGrade.Description = this.txtRankDesc.Text.Trim(); if (int.TryParse(this.txtPoint.Text.Trim(), out num)) { memberGrade.Points = num; } else { str = str + Formatter.FormatErrorMessage("积分设置无效或不能为空,必须大于等于0的整数"); } memberGrade.IsDefault = this.chkIsDefault.SelectedValue; if (int.TryParse(this.txtValue.Text, out num2)) { memberGrade.Discount = num2; } else { str = str + Formatter.FormatErrorMessage("等级折扣设置无效或不能为空,等级折扣必须在1-100之间"); } if (!string.IsNullOrEmpty(str)) { this.ShowMsg(str, false); } else if (this.ValidationMemberGrade(memberGrade)) { if (UnderlingHelper.HasSamePointMemberGrade(memberGrade)) { this.ShowMsg("已经存在相同积分的等级,每个会员等级的积分不能相同", false); } else if (UnderlingHelper.CreateUnderlingGrade(memberGrade)) { this.ShowMsg("成功添加了一个会员等级", true); } else { this.ShowMsg("添加会员等级失败", false); } } } }
private void btnSubmitMemberRanks_Click(object sender, EventArgs e) { string text = string.Empty; if (this.txtValue.Text.Trim().Contains(".")) { this.ShowMsg("折扣必须为正整数", false); } else { MemberGradeInfo memberGrade = MemberHelper.GetMemberGrade(this.gradeId); memberGrade.Name = this.txtRankName.Text.Trim(); memberGrade.Description = this.txtRankDesc.Text.Trim(); int points = default(int); if (int.TryParse(this.txtPoint.Text.Trim(), out points)) { memberGrade.Points = points; } else { text += Formatter.FormatErrorMessage("积分设置无效或不能为空,必须大于等于0的整数"); } int discount = default(int); if (int.TryParse(this.txtValue.Text, out discount)) { memberGrade.Discount = discount; } else { text += Formatter.FormatErrorMessage("等级折扣设置无效或不能为空,等级折扣必须在1-10之间"); } if (!string.IsNullOrEmpty(text)) { this.ShowMsg(text, false); } else if (this.ValidationMemberGrade(memberGrade)) { if (MemberHelper.HasSamePointMemberGrade(memberGrade)) { this.ShowMsg("已经存在相同积分的等级,每个会员等级的积分不能相同", false); } else if (MemberHelper.UpdateMemberGrade(memberGrade)) { this.ShowMsg("修改会员等级成功", true); } else { this.ShowMsg("修改会员等级失败", false); } } } }