public bool HasSamePointMemberGrade(MemberGradeInfo memberGrade) { DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT COUNT(GradeId) as Count FROM aspnet_MemberGrades WHERE Points=@Points AND GradeId<>@GradeId;"); this.database.AddInParameter(sqlStringCommand, "Points", DbType.Int32, memberGrade.Points); this.database.AddInParameter(sqlStringCommand, "GradeId", DbType.Int32, memberGrade.GradeId); return (((int) this.database.ExecuteScalar(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 { GradeId = this.gradeId, Name = this.txtRankName.Text.Trim(), Description = this.txtRankDesc.Text.Trim() }; 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); } } } }
private void btnSubmitMemberRanks_Click(object sender, EventArgs e) { string str = string.Empty; if (txtValue.Text.Trim().Contains(".")) { ShowMsg("折扣必须为正整数", false); } else { int num; int num2; MemberGradeInfo memberGrade = new MemberGradeInfo(); memberGrade.Name = txtRankName.Text.Trim(); memberGrade.Description = txtRankDesc.Text.Trim(); if (int.TryParse(txtPoint.Text.Trim(), out num)) { memberGrade.Points = num; } else { str = str + Formatter.FormatErrorMessage("积分设置无效或不能为空,必须大于等于0的整数"); } memberGrade.IsDefault = chkIsDefault.SelectedValue; if (int.TryParse(txtValue.Text, out num2)) { memberGrade.Discount = num2; } else { str = str + Formatter.FormatErrorMessage("等级折扣设置无效或不能为空,等级折扣必须在1-10之间"); } if (!string.IsNullOrEmpty(str)) { ShowMsg(str, false); } else if (ValidationMemberGrade(memberGrade)) { if (MemberHelper.HasSamePointMemberGrade(memberGrade)) { ShowMsg("已经存在相同积分的等级,每个会员等级的积分不能相同", false); } else if (MemberHelper.CreateMemberGrade(memberGrade)) { ShowMsg("成功添加了一个会员等级", true); } else { ShowMsg("添加会员等级失败", false); } } } }
public static bool CreateMemberGrade(MemberGradeInfo memberGrade) { if (null == memberGrade) { return false; } Globals.EntityCoding(memberGrade, true); bool flag = new MemberGradeDao().CreateMemberGrade(memberGrade); if (flag) { EventLogs.WriteOperationLog(Privilege.AddMemberGrade, string.Format(CultureInfo.InvariantCulture, "添加了名为 “{0}” 的会员等级", new object[] { memberGrade.Name })); } return flag; }
private bool ValidationMemberGrade(MemberGradeInfo memberGrade) { ValidationResults results = Hishop.Components.Validation.Validation.Validate<MemberGradeInfo>(memberGrade, new string[] { "ValMemberGrade" }); string msg = string.Empty; if (!results.IsValid) { foreach (ValidationResult result in (IEnumerable<ValidationResult>)results) { msg = msg + Formatter.FormatErrorMessage(result.Message); } ShowMsg(msg, false); } return results.IsValid; }
public bool CreateMemberGrade(MemberGradeInfo memberGrade) { string query = string.Empty; if (memberGrade.IsDefault) { query = query + "UPDATE aspnet_MemberGrades SET IsDefault = 0"; } query = query + " INSERT INTO aspnet_MemberGrades ([Name], Description, Points, IsDefault, Discount) VALUES (@Name, @Description, @Points, @IsDefault, @Discount)"; DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query); this.database.AddInParameter(sqlStringCommand, "Name", DbType.String, memberGrade.Name); this.database.AddInParameter(sqlStringCommand, "Description", DbType.String, memberGrade.Description); this.database.AddInParameter(sqlStringCommand, "Points", DbType.Int32, memberGrade.Points); this.database.AddInParameter(sqlStringCommand, "IsDefault", DbType.Boolean, memberGrade.IsDefault); this.database.AddInParameter(sqlStringCommand, "Discount", DbType.Int32, memberGrade.Discount); return (this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
public override bool CreateUnderlingGrade(MemberGradeInfo underlingGrade) { StringBuilder builder = new StringBuilder(); if (underlingGrade.IsDefault) { builder.AppendFormat("UPDATE distro_MemberGrades SET IsDefault = 0 WHERE CreateUserId = {0};", HiContext.Current.User.UserId); } builder.AppendFormat("INSERT INTO distro_MemberGrades(CreateUserId, [Name], Description, Points, IsDefault, Discount) VALUES (@CreateUserId, @Name, @Description, @Points, @IsDefault, @Discount);", new object[0]); DbCommand sqlStringCommand = database.GetSqlStringCommand(builder.ToString()); database.AddInParameter(sqlStringCommand, "Name", DbType.String, underlingGrade.Name); database.AddInParameter(sqlStringCommand, "Description", DbType.String, underlingGrade.Description); database.AddInParameter(sqlStringCommand, "Points", DbType.Int32, underlingGrade.Points); database.AddInParameter(sqlStringCommand, "IsDefault", DbType.Boolean, underlingGrade.IsDefault); database.AddInParameter(sqlStringCommand, "Discount", DbType.Currency, underlingGrade.Discount); database.AddInParameter(sqlStringCommand, "CreateUserId", DbType.Int32, HiContext.Current.User.UserId); return (database.ExecuteNonQuery(sqlStringCommand) > 0); }
public static bool CreateUnderlingGrade(MemberGradeInfo underlingGrade) { Globals.EntityCoding(underlingGrade, true); return UnderlingProvider.Instance().CreateUnderlingGrade(underlingGrade); }
public static bool HasSamePointMemberGrade(MemberGradeInfo memberGrade) { return UnderlingProvider.Instance().HasSamePointMemberGrade(memberGrade); }
public static MemberGradeInfo PopulateMemberGrade(IDataReader reader) { if (null == reader) { return null; } MemberGradeInfo info = new MemberGradeInfo(); info.GradeId = (int) reader["GradeId"]; info.Name = (string) reader["Name"]; if (reader["Description"] != DBNull.Value) { info.Description = (string) reader["Description"]; } info.Points = (int) reader["Points"]; info.IsDefault = (bool) reader["IsDefault"]; info.Discount = (int) reader["Discount"]; return info; }
public static bool HasSamePointMemberGrade(MemberGradeInfo memberGrade) { return new MemberGradeDao().HasSamePointMemberGrade(memberGrade); }
public abstract bool UpdateMemberGrade(MemberGradeInfo memberGrade);
public static bool UpdateMemberGrade(MemberGradeInfo memberGrade) { if (null == memberGrade) { return false; } Globals.EntityCoding(memberGrade, true); bool flag = MemberProvider.Instance().UpdateMemberGrade(memberGrade); if (flag) { EventLogs.WriteOperationLog(Privilege.EditMemberGrade, string.Format(CultureInfo.InvariantCulture, "修改了编号为 “{0}” 的会员等级", new object[] { memberGrade.GradeId })); } return flag; }
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 = database.GetSqlStringCommand(query); database.AddInParameter(sqlStringCommand, "Name", DbType.String, underlingGrade.Name); database.AddInParameter(sqlStringCommand, "Description", DbType.String, underlingGrade.Description); database.AddInParameter(sqlStringCommand, "Points", DbType.Int32, underlingGrade.Points); database.AddInParameter(sqlStringCommand, "GradeId", DbType.Int32, underlingGrade.GradeId); database.AddInParameter(sqlStringCommand, "Discount", DbType.Currency, underlingGrade.Discount); return (database.ExecuteNonQuery(sqlStringCommand) > 0); }
public override bool HasSamePointMemberGrade(MemberGradeInfo memberGrade) { DbCommand sqlStringCommand = 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)); database.AddInParameter(sqlStringCommand, "Points", DbType.Int32, memberGrade.Points); database.AddInParameter(sqlStringCommand, "GradeId", DbType.Int32, memberGrade.GradeId); return (((int)database.ExecuteScalar(sqlStringCommand)) > 0); }
public bool UpdateMemberGrade(MemberGradeInfo memberGrade) { 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", DbType.String, memberGrade.Name); this.database.AddInParameter(sqlStringCommand, "Description", DbType.String, memberGrade.Description); this.database.AddInParameter(sqlStringCommand, "Points", DbType.Int32, memberGrade.Points); this.database.AddInParameter(sqlStringCommand, "Discount", DbType.Int32, memberGrade.Discount); this.database.AddInParameter(sqlStringCommand, "GradeId", DbType.Int32, memberGrade.GradeId); return (this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
public abstract bool HasSamePointMemberGrade(MemberGradeInfo memberGrade);
public abstract bool UpdateUnderlingGrade(MemberGradeInfo underlingGrade);