public List <ArticleImageEntity> GetArticleImageList(GetReportExportDataParams param)
{
DataSet ds = MSSqlHelper.GetReportExportData("ArticleImageList", param.Where, param.Order);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <ArticleImageEntity>());
}
var article = (from l in dt.AsEnumerable()
select new ArticleImageEntity
{
Author = l.Field <string>("Author"),
UpdateUser = l.Field <string>("username"),
Title = l.Field <string>("Title"),
Source = l.Field <string>("Source"),
SortOrder = l.Field <int>("SortOrder"),
Slug = l.Field <string>("Slug"),
ShortTitle = l.Field <string>("ShortTitle"),
PageVisits = l.Field <int>("PageVisits"),
PageTitle = l.Field <string>("PageTitle"),
MetaKeywords = l.Field <string>("MetaKeywords"),
MetaDescription = l.Field <string>("MetaDescription"),
DateCreated = l.Field <DateTime>("DateCreated"),
//Content = l.Field<string>("Content"),
//IsDelete = l.IsDelete,
Overview = l.Field <string>("Overview"),
Photo = l.Field <string>("Photo"),
ColumnID = l.Field <int>("ColumnID"),
ID = l.Field <int>("ID")
}).ToList();
return(article.ToList());
}
public List <ArticleList> GetHomeArticleList(int id)
{
GetReportDataParams param = new GetReportDataParams();
param.Where.Add(new KeyValue()
{
Key = "ColumnID", Value = id.UString()
});
DataSet ds = MSSqlHelper.GetReportExportData("ArticleList", param.Where, param.Order);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <ArticleList>());
}
List <ArticleList> article = (from l in dt.AsEnumerable()
select new ArticleList
{
ID = l.Field <int>("ID"),
ColumnName = l.Field <string>("ColumnName"),
PageVisits = l.Field <int>("PageVisits"),
UpdateTime = l.Field <DateTime>("UpdateTime"),
UpdateUser = l.Field <string>("UpdateUser"),
ShortTitle = l.Field <string>("ShortTitle"),
SortOrder = l.Field <int>("SortOrder"),
Title = l.Field <string>("Title")
}).ToList();
return(article.ToList());
}
