public List <Gallery> GetGalleries() { using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext()) { var list = from l in db.Galleries.AsEnumerable() select l; return(list.ToList()); } }
public List <Video> GetVideos() { using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext()) { var list = from l in db.Videos.AsEnumerable() select l; return(list.ToList()); } }
public List <GalleryDetail> GetGalleryDetails() { using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext()) { var list = from l in db.GalleryDetails.AsEnumerable() where l.GalleryID == 2 select l; return(list.ToList()); } }
public List <BlogCategory> GetCategories() { using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext()) { var list = from l in db.BlogCategories.AsEnumerable() where l.CategoryName != "公司介绍" select l; return(list.ToList()); } }
public List <Blog> GetBulletin() { using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext()) { var list = from l in db.Blogs.AsEnumerable() where l.CategoryID == 7 select l; return(list.ToList()); } }
public List <Blog> GetBlogs(int id) { using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext()) { var list = from l in db.Blogs.AsEnumerable() where l.CategoryID == id orderby l.SortOrder descending select l; return(list.ToList()); } }
public List <SelectListItem> GetCourse() { using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext()) { var list = from l in db.Blogs.AsEnumerable() where l.CategoryID == 1 && l.IsPublic == true orderby l.BlogID descending select new SelectListItem { Text = l.BlogTitle, Value = l.BlogID.ToString() }; return(list.ToList()); } }
public List <SelectListItem> GetBlogCategoryList() { using (Hammer.Core.Models.SiteDataContext db = new Hammer.Core.Models.SiteDataContext()) { var list = from l in db.BlogCategories.AsEnumerable() where l.CategoryName != "公司介绍" orderby l.CategoryName select new SelectListItem { Value = l.CategoryID.ToString(), Text = l.CategoryName }; return(list.ToList()); } }