/// <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 }), "商品关键词添加成功"); }