public override List <ArticleAttachment> GetAllArticleAttachments()
{
using (IDataReader dr = DataHelper.ExecuteReader(CommandType.StoredProcedure, "sp_ArticleAttachment_GetAll"))
{
List <ArticleAttachment> result = new List <ArticleAttachment>();
for (; dr.Read();)
{
ArticleAttachment article = ArticleReaderConverter.ParseArticleAttachment(dr);
result.Add(article);
}
return(result);
}
}
/// <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);
}
}
public override ArticleAttachment GetArticleAttachment(int id)
{
ELParameter idParam = new ELParameter("@AttachmentID", DbType.Int32);
idParam.Value = id;
using (IDataReader dr = DataHelper.ExecuteReader(CommandType.StoredProcedure, "sp_ArticleAttachment_Get", idParam))
{
ArticleAttachment result = null;
if (dr.Read())
{
result = ArticleReaderConverter.ParseArticleAttachment(dr);
}
return(result);
}
}
public override List <ArticleAttachment> GetAllArticleAttachments(AttachmentQuery 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.BuildAttachmentQuery(query))
};
using (IDataReader dr = DataHelper.ExecuteReader(CommandType.StoredProcedure, "sp_ArticleAttachments_Get", elParameters))
{
List <ArticleAttachment> attachmentList = new List <ArticleAttachment>();
while (dr.Read())
{
attachmentList.Add(ArticleReaderConverter.ParseArticleAttachment(dr));
}
dr.NextResult();
dr.Read();
totalRecord = DataRecordHelper.GetInt32(dr, 0);
return(attachmentList);
}
}
