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;
}
