/// <summary>
/// 获取所有的词库
/// </summary>
/// <returns></returns>
public List <Model.Article_Words> GetAll()
{
string sql = "select * from Articel_Words";
using (SqlDataReader reader = DbHelperSQL.ExecuteReader(sql))
{
List <Model.Article_Words> list = new List <BookShop.Model.Article_Words>();
while (reader.Read())
{
Model.Article_Words mode = new BookShop.Model.Article_Words();
mode.Id = Convert.ToInt32(reader["Id"]);
mode.IsForbid = Convert.ToBoolean(reader["IsForbid"]);
mode.IsMod = Convert.ToBoolean(reader["IsMod"]);
mode.ReplaceWord = reader["ReplaceWord"].ToString();
mode.WordPattern = reader["WordPattern"].ToString();
list.Add(mode);
}
return(list);
}
}
/// <summary>
/// 查找指定的词
/// </summary>
/// <param name="word"></param>
/// <returns></returns>
public Model.Article_Words GetWord(string word)
{
string sql = "select * from Articel_Words where WordPattern=@WordPattern";
using (SqlDataReader reader = DbHelperSQL.ExecuteReader(sql, new SqlParameter("@WordPattern", word)))
{
if (reader.Read())
{
Model.Article_Words mode = new BookShop.Model.Article_Words();
mode.Id = Convert.ToInt32(reader["Id"]);
mode.IsForbid = Convert.ToBoolean(reader["IsForbid"]);
mode.IsMod = Convert.ToBoolean(reader["IsMod"]);
mode.ReplaceWord = reader["ReplaceWord"].ToString();
mode.WordPattern = reader["WordPattern"].ToString();
return(mode);
}
else
{
return(null);
}
}
}
