/// <summary> /// 更新商品关键词 /// </summary> public ActionResult UpdateProductKeyword(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个字")); } ProductKeywordInfo productKeywordInfo = new ProductKeywordInfo { Keyword = keyword, Pid = pid, Relevancy = relevancy }; Searches.UpdateProductKeyword(productKeywordInfo); AddMallAdminLog("修改商品关键词", "修改商品关键词,商品ID:" + pid); return(Content("1")); }
/// <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); AddMallAdminLog("添加商品关键词", "添加商品关键词,商品ID为:" + pid); return(PromptView(Url.Action("productkeywordlist", new { pid = pid }), "商品关键词添加成功")); }
/// <summary> /// 从IDataReader创建ProductKeywordInfo /// </summary> private ProductKeywordInfo BuildProductKeyWordFromReader(IDataReader reader) { ProductKeywordInfo productKeywordInfo = new ProductKeywordInfo(); productKeywordInfo.Keyword = reader["keyword"].ToString(); productKeywordInfo.Pid = TypeHelper.ObjectToInt(reader["pid"]); productKeywordInfo.Relevancy = TypeHelper.ObjectToInt(reader["relevancy"]); return(productKeywordInfo); }
/// <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="pid">商品id</param> /// <param name="text">文本</param> /// <param name="relevancy">相关性</param> public void CreateProductKeyword(int pid, string text, int relevancy) { List <string> keywordList = Analyse(text); foreach (string keyword in keywordList) { ProductKeywordInfo productKeywordInfo = new ProductKeywordInfo() { Keyword = keyword, Pid = pid, Relevancy = relevancy }; CreateProductKeyword(productKeywordInfo); } }
/// <summary> /// 获得商品关键词列表 /// </summary> /// <param name="pid">商品id</param> /// <returns></returns> public List <ProductKeywordInfo> GetProductKeywordList(int pid) { List <ProductKeywordInfo> productKeywordList = new List <ProductKeywordInfo>(); DbParameter[] parms = { GenerateInParam("@pid", SqlDbType.Int, 4, pid) }; string commandText = string.Format("SELECT [keyword],[pid],[relevancy] FROM [{0}productkeywords] WHERE [pid]=@pid", RDBSHelper.RDBSTablePre); IDataReader reader = RDBSHelper.ExecuteReader(CommandType.Text, commandText, parms); while (reader.Read()) { ProductKeywordInfo productKeywordInfo = BuildProductKeyWordFromReader(reader); productKeywordList.Add(productKeywordInfo); } reader.Close(); return(productKeywordList); }
/// <summary> /// 更新商品关键词 /// </summary> /// <param name="productKeywordInfo">商品关键词信息</param> public static void UpdateProductKeyword(ProductKeywordInfo productKeywordInfo) { BrnShop.Data.Products.UpdateProductKeyword(productKeywordInfo); }
/// <summary> /// 更新商品关键词 /// </summary> /// <param name="productKeywordInfo">商品关键词信息</param> public static void UpdateProductKeyword(ProductKeywordInfo productKeywordInfo) { _isearchstrategy.UpdateProductKeyword(productKeywordInfo); }
/// <summary> /// 更新商品关键词 /// </summary> /// <param name="productKeywordInfo">商品关键词信息</param> public void UpdateProductKeyword(ProductKeywordInfo productKeywordInfo) { DeleteProductKeyword(productKeywordInfo.Pid, productKeywordInfo.Keyword); CreateProductKeyword(productKeywordInfo); }
/// <summary> /// 更新商品关键词 /// </summary> /// <param name="productKeywordInfo">商品关键词信息</param> public static void UpdateProductKeyword(ProductKeywordInfo productKeywordInfo) { NStore.Data.Products.UpdateProductKeyword(productKeywordInfo); }
/// <summary> /// 创建商品关键词 /// </summary> /// <param name="productKeywordInfo">商品关键词信息</param> public static void CreateProductKeyword(ProductKeywordInfo productKeywordInfo) { BrnMall.Data.Products.CreateProductKeyword(productKeywordInfo); }