/**
*
* 增加品牌
*
* */
public bool addCategory(Category category)
{
try
{
// int brandId = this.findIdByColomn("brand","brand_name",category.getBrandName());
string sql = "insert into category (category_name,net_rate,brand) values(@categoryName,@netRate,@brandId)";
Dictionary<string, Object> parameters = new Dictionary<string, Object>();
parameters.Add("@categoryName", category.getCategoryName());
parameters.Add("@netRate", category.getNetRate());
parameters.Add("@brandId", category.getBrandId());
dbAccess.excute(sql, parameters);
return true;
}
catch (Exception e)
{
throw new MyException(e.Message);
}
}
/**
*
* 更新品牌
*
* */
public bool updateCategory(Category Category)
{
try
{
string sql = "update category set category_name = @categoryName, net_rate = @netRate, brand = @brandId where id = @id";
Dictionary<string, Object> parameters = new Dictionary<string, Object>();
parameters.Add("@categoryName", Category.getCategoryName());
parameters.Add("@netRate", Category.getNetRate());
parameters.Add("@brandId", Category.getBrandId());
parameters.Add("@id", Category.Id);
dbAccess.excute(sql, parameters);
return true;
}
catch (Exception e)
{
throw new MyException(e.Message);
}
}