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