private void btnEditDistrbutor_Click(object sender, EventArgs e) { int num; DistributorGradeInfo distributorGrade = new DistributorGradeInfo(); distributorGrade.Name = txtRankName.Text.Trim(); distributorGrade.Description = txtRankDesc.Text.Trim(); distributorGrade.GradeId = gradeId; if (!(!int.TryParse(txtValue.Text, out num) || txtValue.Text.Contains("."))) { distributorGrade.Discount = num; } else { ShowMsg("等级折扣必须为正整数", false); return; } if (ValidationMemberGrade(distributorGrade)) { if (DistributorHelper.UpdateDistributorGrade(distributorGrade)) { ShowMsg("修改分销商等级成功", true); } else { ShowMsg("修改分销商等级失败", false); } } }
private void btnAddDistrbutor_Click(object sender, EventArgs e) { if (DistributorHelper.ExistGradeName(txtRankName.Text.Trim())) { ShowMsg("已经存在相同名称的分销商等级", false); } else { int num; DistributorGradeInfo distributorGrade = new DistributorGradeInfo(); distributorGrade.Name = txtRankName.Text.Trim(); distributorGrade.Description = txtRankDesc.Text.Trim(); if (!(!int.TryParse(txtValue.Text, out num) || txtValue.Text.Contains("."))) { distributorGrade.Discount = num; } else { ShowMsg("等级折扣必须只能为正整数", false); return; } if (ValidationMemberGrade(distributorGrade)) { if (DistributorHelper.AddDistributorGrade(distributorGrade)) { ResetText(); ShowMsg("成功添加了一个分销商等级", true); } else { ShowMsg("添加分销商等级失败", false); } } } }
public override bool AddDistributorGrade(DistributorGradeInfo distributorGrade) { DbCommand sqlStringCommand = database.GetSqlStringCommand("INSERT INTO aspnet_DistributorGrades(Name, Description, Discount) VALUES(@Name,@Description,@Discount)"); database.AddInParameter(sqlStringCommand, "Name", DbType.String, distributorGrade.Name); database.AddInParameter(sqlStringCommand, "Description", DbType.String, distributorGrade.Description); database.AddInParameter(sqlStringCommand, "Discount", DbType.Int32, distributorGrade.Discount); return (database.ExecuteNonQuery(sqlStringCommand) == 1); }
public static bool AddDistributorGrade(DistributorGradeInfo distributorGrade) { Globals.EntityCoding(distributorGrade, true); bool flag = DistributorProvider.Instance().AddDistributorGrade(distributorGrade); if (flag) { EventLogs.WriteOperationLog(Privilege.AddDistributorGrade, string.Format(CultureInfo.InvariantCulture, "添加了名为 “{0}” 的分销商等级", new object[] { distributorGrade.Name })); } return flag; }
private bool ValidationMemberGrade(DistributorGradeInfo distributorGrade) { ValidationResults results = Hishop.Components.Validation.Validation.Validate<DistributorGradeInfo>(distributorGrade, new string[] { "ValDistributorGrade" }); 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 static DistributorGradeInfo PopulDistributorGrade(IDataReader reader) { DistributorGradeInfo info = new DistributorGradeInfo(); info.GradeId = (int) reader["GradeId"]; info.Discount = (int) reader["Discount"]; info.Name = (string) reader["Name"]; if (reader["Description"] != DBNull.Value) { info.Description = (string) reader["Description"]; } return info; }
public abstract bool AddDistributorGrade(DistributorGradeInfo distributorGrade);
public abstract bool UpdateDistributorGrade(DistributorGradeInfo distributorGrade);
public override bool UpdateDistributorGrade(DistributorGradeInfo distributorGrade) { DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE aspnet_DistributorGrades SET Name =@Name,Description = @Description,Discount = @Discount WHERE GradeId = @GradeId"); database.AddInParameter(sqlStringCommand, "Name", DbType.String, distributorGrade.Name); database.AddInParameter(sqlStringCommand, "Description", DbType.String, distributorGrade.Description); database.AddInParameter(sqlStringCommand, "Discount", DbType.Int32, distributorGrade.Discount); database.AddInParameter(sqlStringCommand, "GradeId", DbType.Currency, distributorGrade.GradeId); return (database.ExecuteNonQuery(sqlStringCommand) == 1); }
public override DistributorGradeInfo GetDistributorGradeInfo(int gradeId) { DistributorGradeInfo info = new DistributorGradeInfo(); DbCommand sqlStringCommand = database.GetSqlStringCommand("SELECT * FROM aspnet_DistributorGrades WHERE GradeId=@GradeId"); database.AddInParameter(sqlStringCommand, "GradeId", DbType.Int32, gradeId); using (IDataReader reader = database.ExecuteReader(sqlStringCommand)) { if (reader.Read()) { info = DataMapper.PopulDistributorGrade(reader); } } return info; }