public bool UpdateBrandTag(BrandTagInfo brandCategory) { DbCommand sqlStringCommand = this.database.GetSqlStringCommand("UPDATE Ecshop_BrandTag SET TagName = @TagName WHERE BrandTagId = @BrandTagId"); this.database.AddInParameter(sqlStringCommand, "BrandTagId", DbType.Int32, brandCategory.BrandTagId); this.database.AddInParameter(sqlStringCommand, "TagName", DbType.String, brandCategory.TagName); return(this.database.ExecuteNonQuery(sqlStringCommand) > 0); }
public static bool UpdateBrandTag(BrandTagInfo brandCategory) { BrandTagDao brandCategoryDao = new BrandTagDao(); bool flag = brandCategoryDao.UpdateBrandTag(brandCategory); if (flag && brandCategoryDao.DeleteBrandTagBrand(brandCategory.BrandTagId)) { brandCategoryDao.AddBrandAndBrandTags(brandCategory.BrandTagId, brandCategory.BrandCategoryInfos); } return(flag); }
public static bool AddBrandTag(BrandTagInfo brandTag) { BrandTagDao brandCategoryDao = new BrandTagDao(); int num = brandCategoryDao.AddBrandTag(brandTag); if (num > 0 && brandTag.BrandCategoryInfos.Count > 0) { brandCategoryDao.AddBrandBrandTags(num, brandTag.BrandCategoryInfos); } return(true); }
private void btnSave_Click(object sender, System.EventArgs e) { BrandTagInfo brandCategoryInfo = this.GetBrandCategoryInfo(); if (!this.ValidationBrandCategory(brandCategoryInfo)) { return; } if (CatalogHelper.AddBrandTag(brandCategoryInfo)) { base.Response.Redirect(Globals.GetAdminAbsolutePath("/product/BrandType.aspx"), true); return; } this.ShowMsg("添加品牌标签失败", true); return; }
private BrandTagInfo GetBrandCategoryInfo() { BrandTagInfo brandCategoryInfo = new BrandTagInfo(); brandCategoryInfo.TagName = Globals.HtmlEncode(Globals.StripHtmlXmlTags(Globals.StripScriptTags(this.txtBrandName.Text.Trim())).Replace("\\", "")); System.Collections.Generic.IList <int> list = new System.Collections.Generic.List <int>(); foreach (System.Web.UI.WebControls.ListItem listItem in this.chlistBrand.Items) { if (listItem.Selected) { list.Add(int.Parse(listItem.Value)); } } brandCategoryInfo.BrandCategoryInfos = list; return(brandCategoryInfo); }
private void loadData() { BrandTagInfo brandCategory = CatalogHelper.GetBrandTag(this.brandId); if (brandCategory == null) { base.GotoResourceNotFound(); return; } foreach (System.Web.UI.WebControls.ListItem listItem in this.chlistBrand.Items) { if (brandCategory.BrandCategoryInfos.Contains(int.Parse(listItem.Value))) { listItem.Selected = true; } } this.txtBrandName.Text = Globals.HtmlDecode(brandCategory.TagName); }
private bool ValidationBrandCategory(BrandTagInfo brandCategory) { ValidationResults validationResults = Validation.Validate <BrandTagInfo>(brandCategory, new string[] { "ValBrandCategory" }); string text = string.Empty; if (!validationResults.IsValid) { foreach (ValidationResult current in (System.Collections.Generic.IEnumerable <ValidationResult>)validationResults) { text += Formatter.FormatErrorMessage(current.Message); } this.ShowMsg(text, false); } return(validationResults.IsValid); }
public int AddBrandTag(BrandTagInfo model) { DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DECLARE @DisplaySequence AS INT SELECT @DisplaySequence = (CASE WHEN MAX(TagSort) IS NULL THEN 1 ELSE MAX(TagSort) + 1 END) FROM Ecshop_BrandTag;INSERT INTO dbo.Ecshop_BrandTag( TagName, TagSort )VALUES(@TagName,@DisplaySequence); SELECT @@IDENTITY"); this.database.AddInParameter(sqlStringCommand, "TagName", DbType.String, model.TagName); object obj = this.database.ExecuteScalar(sqlStringCommand); int result; if (obj != null) { result = Convert.ToInt32(obj); } else { result = 0; } return(result); }
public BrandTagInfo GetBrandTag(int brandTagId) { BrandTagInfo brandCategoryInfo = new BrandTagInfo(); DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Ecshop_BrandTag WHERE BrandTagId = @BrandId;SELECT * FROM Ecshop_BrandToBrandTag WHERE BrandTagId = @BrandId"); this.database.AddInParameter(sqlStringCommand, "BrandId", DbType.Int32, brandTagId); using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { brandCategoryInfo = ReaderConvert.ReaderToModel <BrandTagInfo>(dataReader); IList <int> list = new List <int>(); dataReader.NextResult(); while (dataReader.Read()) { list.Add((int)dataReader["BrandId"]); } brandCategoryInfo.BrandCategoryInfos = list; } return(brandCategoryInfo); }
protected void btnUpdateBrandCategory_Click(object sender, System.EventArgs e) { string value = Globals.HtmlEncode(Globals.StripHtmlXmlTags(Globals.StripScriptTags(this.txtBrandName.Text.Trim())).Replace("\\", "")); if (string.IsNullOrEmpty(value)) { this.ShowMsg("请填写品牌标签,品牌标签名称中不能包含HTML字符,脚本字符,以及\\", false); return; } BrandTagInfo brandCategoryInfo = this.GetBrandCategoryInfo(); if (!this.ValidationBrandCategory(brandCategoryInfo)) { return; } if (CatalogHelper.UpdateBrandTag(brandCategoryInfo)) { base.Response.Redirect(Globals.GetAdminAbsolutePath("/product/BrandType.aspx"), true); return; } this.ShowMsg("编辑品牌标签失败", true); }
protected void btnAddBrandCategory_Click(object sender, System.EventArgs e) { string value = Globals.HtmlEncode(Globals.StripHtmlXmlTags(Globals.StripScriptTags(this.txtBrandName.Text.Trim())).Replace("\\", "")); if (string.IsNullOrEmpty(value)) { this.ShowMsg("请填写品牌标签名称,品牌标签名称中不能包含HTML字符,脚本字符,以及\\", false); return; } BrandTagInfo brandCategoryInfo = this.GetBrandCategoryInfo(); if (!this.ValidationBrandCategory(brandCategoryInfo)) { return; } if (CatalogHelper.AddBrandTag(brandCategoryInfo)) { this.ShowMsg("成功添加品牌标签", true); return; } this.ShowMsg("添加品牌标签失败", true); return; }