/// <summary>
/// 更新商品关键词
/// </summary>
/// <param name="productKeywordInfo">商品关键词信息</param>
public static void UpdateProductKeyword(ProductKeywordInfo productKeywordInfo)
{
BrnShop.Data.Products.UpdateProductKeyword(productKeywordInfo);
}
/// <summary>
/// 更新商品关键词
/// </summary>
/// <param name="productKeywordInfo">商品关键词信息</param>
public void UpdateProductKeyword(ProductKeywordInfo productKeywordInfo)
{
DbParameter[] parms = {
GenerateInParam("@keyword", SqlDbType.NChar,40,productKeywordInfo.Keyword),
GenerateInParam("@pid", SqlDbType.Int,4,productKeywordInfo.Pid),
GenerateInParam("@relevancy", SqlDbType.Int,4,productKeywordInfo.Relevancy),
GenerateInParam("@keywordid", SqlDbType.Int, 4, productKeywordInfo.KeywordId)
};
string commandText = string.Format("UPDATE [{0}productkeywords] SET [keyword]=@keyword,[pid]=@pid,[relevancy]=@relevancy WHERE [keywordid]=@keywordid",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 创建商品关键词
/// </summary>
/// <param name="productKeywordInfo">商品关键词信息</param>
public void CreateProductKeyword(ProductKeywordInfo productKeywordInfo)
{
DbParameter[] parms = {
GenerateInParam("@keyword", SqlDbType.NChar,40,productKeywordInfo.Keyword),
GenerateInParam("@pid", SqlDbType.Int,4,productKeywordInfo.Pid),
GenerateInParam("@relevancy", SqlDbType.Int,4,productKeywordInfo.Relevancy)
};
string commandText = string.Format("INSERT INTO [{0}productkeywords]([keyword],[pid],[relevancy]) VALUES(@keyword,@pid,@relevancy)",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 创建商品关键词
/// </summary>
/// <param name="productKeywordInfo">商品关键词信息</param>
public static void CreateProductKeyword(ProductKeywordInfo productKeywordInfo)
{
BrnShop.Core.BSPData.RDBS.CreateProductKeyword(productKeywordInfo);
}
/// <summary>
/// 从IDataReader创建ProductKeyWordInfo
/// </summary>
public static ProductKeywordInfo BuildProductKeyWordFromReader(IDataReader reader)
{
ProductKeywordInfo productKeyWordInfo = new ProductKeywordInfo();
productKeyWordInfo.KeywordId = TypeHelper.ObjectToInt(reader["keywordid"]);
productKeyWordInfo.Keyword = reader["keyword"].ToString();
productKeyWordInfo.Pid = TypeHelper.ObjectToInt(reader["pid"]);
productKeyWordInfo.Relevancy = TypeHelper.ObjectToInt(reader["relevancy"]);
return productKeyWordInfo;
}
/// <summary>
/// 添加商品关键词
/// </summary>
public ActionResult AddProductKeyword(string keyword, int relevancy = 0, int pid = -1)
{
PartProductInfo partProductInfo = AdminProducts.AdminGetPartProductById(pid);
if (partProductInfo == null)
return PromptView(Url.Action("productkeywordlist", new { pid = pid }), "商品不存在");
if (string.IsNullOrWhiteSpace(keyword))
return PromptView(Url.Action("productkeywordlist", new { pid = pid }), "关键词不能为空");
if (keyword.Length > 20)
return PromptView(Url.Action("productkeywordlist", new { pid = pid }), "关键词最多只能输入20个字");
if (AdminProducts.IsExistProductKeyWord(pid, keyword))
return PromptView(Url.Action("productkeywordlist", new { pid = pid }), "关键词已经存在");
ProductKeywordInfo productKeywordInfo = new ProductKeywordInfo
{
Keyword = keyword,
Pid = pid,
Relevancy = relevancy
};
AdminProducts.CreateProductKeyword(productKeywordInfo);
AddAdminOperateLog("添加商品关键词", "添加商品关键词,商品ID为:" + pid);
return PromptView(Url.Action("productkeywordlist", new { pid = pid }), "商品关键词添加成功");
}
