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