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