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