/// <summary>
/// 添加筛选词
/// </summary>
public void AddFilterWord(FilterWordInfo filterWordInfo)
{
DbParameter[] parms = {
GenerateInParam("@match", SqlDbType.NVarChar, 250, filterWordInfo.Match),
GenerateInParam("@replace", SqlDbType.NVarChar, 250, filterWordInfo.Replace)
};
string commandText = string.Format("INSERT INTO [{0}filterwords]([match],[replace]) VALUES(@match,@replace)",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 获得筛选词列表
/// </summary>
/// <returns></returns>
public static List<FilterWordInfo> GetFilterWordList()
{
List<FilterWordInfo> filterWordList = new List<FilterWordInfo>();
IDataReader reader = BrnShop.Core.BSPData.RDBS.GetFilterWordList();
while (reader.Read())
{
FilterWordInfo filterWordInfo = new FilterWordInfo();
filterWordInfo.Id = TypeHelper.ObjectToInt(reader["id"]);
filterWordInfo.Match = reader["match"].ToString();
filterWordInfo.Replace = reader["replace"].ToString();
filterWordList.Add(filterWordInfo);
}
reader.Close();
return filterWordList;
}
public ActionResult Add(FilterWordModel model)
{
if (!string.IsNullOrWhiteSpace(model.Match) && AdminFilterWords.GetFilterWordList().Find(x => x.Match == model.Match.Trim()) != null)
ModelState.AddModelError("Match", "匹配词已经存在");
if (ModelState.IsValid)
{
FilterWordInfo filterWordInfo = new FilterWordInfo()
{
Match = model.Match.Trim(),
Replace = model.Replace.Trim()
};
AdminFilterWords.AddFilterWord(filterWordInfo);
AddAdminOperateLog("添加筛选词", "添加筛选词,筛选词为:" + model.Match);
return PromptView("筛选词添加成功");
}
ViewData["referer"] = ShopUtils.GetAdminRefererCookie();
return View(model);
}
/// <summary>
/// 更新筛选词
/// </summary>
public static void UpdateFilterWord(FilterWordInfo filterWordInfo)
{
BrnShop.Data.FilterWords.UpdateFilterWord(filterWordInfo);
}
/// <summary>
/// 添加筛选词
/// </summary>
public static void AddFilterWord(FilterWordInfo filterWordInfo)
{
BrnShop.Data.FilterWords.AddFilterWord(filterWordInfo);
}
/// <summary>
/// 更新筛选词
/// </summary>
public void UpdateFilterWord(FilterWordInfo filterWordInfo)
{
DbParameter[] parms = {
GenerateInParam("@match", SqlDbType.NVarChar, 250, filterWordInfo.Match),
GenerateInParam("@replace", SqlDbType.NVarChar, 250, filterWordInfo.Replace),
GenerateInParam("@id", SqlDbType.Int, 4, filterWordInfo.Id)
};
string commandText = string.Format("UPDATE [{0}filterwords] SET [match]=@match,[replace]=@replace WHERE [id]=@id",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 更新筛选词
/// </summary>
public static void UpdateFilterWord(FilterWordInfo filterWordInfo)
{
BrnShop.Core.BSPData.RDBS.UpdateFilterWord(filterWordInfo);
}
/// <summary>
/// 添加筛选词
/// </summary>
public static void AddFilterWord(FilterWordInfo filterWordInfo)
{
BrnShop.Core.BSPData.RDBS.AddFilterWord(filterWordInfo);
}
