/// <summary>
/// 获取所有文章
/// </summary>
/// <returns></returns>
public override List <Article> GetAllArticles()
{
using (IDataReader dr = DataHelper.ExecuteReader(CommandType.StoredProcedure, "sp_Article_GetAll"))
{
List <Article> result = new List <Article>();
for (; dr.Read();)
{
Article article = ArticleReaderConverter.ParseArticle(dr);
result.Add(article);
}
return(result);
}
}
/// <summary>
/// 获取制定文章
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public override Article GetArticle(int id)
{
ELParameter articleIDParam = new ELParameter("@ArticleID", DbType.Int32);
articleIDParam.Value = id;
using (IDataReader dr = DataHelper.ExecuteReader(CommandType.StoredProcedure, "sp_Article_Get", articleIDParam))
{
Article result = null;
if (dr.Read())
{
result = ArticleReaderConverter.ParseArticle(dr);
}
return(result);
}
}
/// <summary>
/// 获取文章列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public override List <Article> GetArticles(ArticleQuery query, out int totalRecord)
{
ELParameter[] elParameters = new ELParameter[] {
new ELParameter("@PageIndex", DbType.Int32, DataHelper.GetSafeSqlInt(query.PageIndex)),
new ELParameter("@PageSize", DbType.Int32, DataHelper.GetSafeSqlInt(query.PageSize)),
new ELParameter("@SqlPopulate", DbType.String, QueryGenerator.BuildArticleQuery(query))
};
using (IDataReader dr = DataHelper.ExecuteReader(CommandType.StoredProcedure, "sp_Articles_Get", elParameters))
{
List <Article> articleList = new List <Article>();
while (dr.Read())
{
articleList.Add(ArticleReaderConverter.ParseArticle(dr));
}
dr.NextResult();
dr.Read();
totalRecord = DataRecordHelper.GetInt32(dr, 0);
return(articleList);
}
}