/// <summary> /// 获得筛选词列表 /// </summary> /// <returns></returns> public static List<FilterWordInfo> GetFilterWordList() { List<FilterWordInfo> filterWordList = new List<FilterWordInfo>(); IDataReader reader = BrnMall.Core.BMAData.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); AddMallAdminLog("添加筛选词", "添加筛选词,筛选词为:" + model.Match); return PromptView("筛选词添加成功"); } ViewData["referer"] = MallUtils.GetMallAdminRefererCookie(); return View(model); }
/// <summary> /// 更新筛选词 /// </summary> public static void UpdateFilterWord(FilterWordInfo filterWordInfo) { BrnMall.Data.FilterWords.UpdateFilterWord(filterWordInfo); }
/// <summary> /// 添加筛选词 /// </summary> public static void AddFilterWord(FilterWordInfo filterWordInfo) { BrnMall.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 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> public static void UpdateFilterWord(FilterWordInfo filterWordInfo) { BrnMall.Core.BMAData.RDBS.UpdateFilterWord(filterWordInfo); }
/// <summary> /// 添加筛选词 /// </summary> public static void AddFilterWord(FilterWordInfo filterWordInfo) { BrnMall.Core.BMAData.RDBS.AddFilterWord(filterWordInfo); }