protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
string msg = Request["msg"];
msg = msg.Trim();
string[] words = msg.Split(new char[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries);
BLL.Articel_WordsManager bll = new BLL.Articel_WordsManager();
foreach (string str in words)
{
string[] word = str.Split('=');
Model.Articel_Words model = new Model.Articel_Words();
model.WordPattern = word[0];
if (word[1] == "{BANNED}")
{
model.IsForbid = true;
}
else if (word[1] == "{MOD}")
{
model.IsMod = true;
}
else
{
model.ReplaceWord = word[1];
}
bll.Add(model);
}
}
}
public int Insert(Model.Articel_Words model)
{
string sql = "insert into Articel_Words(WordPattern, IsForbid, IsMod, ReplaceWord) values(@WordPattern, @IsForbid, @IsMod, @ReplaceWord)";
SqlParameter[] pars =
{
new SqlParameter("@WordPattern", SqlDbType.NVarChar, 50),
new SqlParameter("@IsForbid", SqlDbType.Bit),
new SqlParameter("@IsMod", SqlDbType.Bit),
new SqlParameter("@ReplaceWord", SqlDbType.NVarChar, 50)
};
pars[0].Value = model.WordPattern;
pars[1].Value = model.IsForbid;
pars[2].Value = model.IsMod;
pars[3].Value = model.ReplaceWord;
return(DbHelperSQL.ExecuteSql(sql, pars));
}
/// <summary>
/// 获取所有的审查词
/// </summary>
/// <returns></returns>
public List <Model.Articel_Words> GetReplaceWord()
{
string sql = "select WordPattern,ReplaceWord from Articel_Words where IsMod=0 and IsForbid=0";
List <Model.Articel_Words> list = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(sql))
{
if (dr.HasRows)
{
list = new List <Model.Articel_Words>();
while (dr.Read())
{
Model.Articel_Words articel = new Model.Articel_Words();
articel.WordPattern = dr["WordPattern"].ToString();
articel.ReplaceWord = dr["ReplaceWord"].ToString();
list.Add(articel);
}
}
}
return(list);
}
public bool Insert(Model.Articel_Words model)
{
return(dal.Insert(model) > 0);
}
