/// <summary> /// 获取所有文章 /// </summary> /// <returns></returns> public override List <ArticleCategory> GetAllArticleCategories() { using (IDataReader dr = DataHelper.ExecuteReader(CommandType.StoredProcedure, "sp_ArticleCategory_GetAll")) { List <ArticleCategory> result = new List <ArticleCategory>(); for (; dr.Read();) { ArticleCategory info = ArticleReaderConverter.ParseArticleCategory(dr); result.Add(info); } return(result); } }
/// <summary> /// 获取制定文章 /// </summary> /// <param name="id"></param> /// <returns></returns> public override ArticleCategory GetArticleCategory(int id) { ELParameter idParam = new ELParameter("@CategoryID", DbType.Int32); idParam.Value = id; using (IDataReader dr = DataHelper.ExecuteReader(CommandType.StoredProcedure, "sp_ArticleCategory_Get", idParam)) { if (dr.Read()) { return(ArticleReaderConverter.ParseArticleCategory(dr)); } return(null); } }