/// <summary> /// 帖子管理列表 /// </summary> /// <returns></returns> // GET: /<controller>/ public IActionResult Index() { ViewModels.PostsViewModel model = new ViewModels.PostsViewModel(); //查询帖子数据 int pageIndex = Framework.Core.Transform.GetInt(Request.Query["p"], 1); int pageSize = 10; PostsRepository repository = new PostsRepository(); var query = repository.GetPostsPageList(); model.ListData = query.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList(); model.TotalCount = query.Count(); return(View(model)); }
public ViewModels.PostsViewModel LoadMainData(int id) { ViewModels.PostsViewModel model = new ViewModels.PostsViewModel(); //查询帖子数据 int pageIndex = Framework.Core.Transform.GetInt(Request.Query["p"], 1); int pageSize = 10; PostsRepository repository = new PostsRepository(); var query = repository.GetPostsPageList(); model.ListData = query.Where(m => (id > 0 ? m.ChannelId == id : m.ChannelId > 0) && m.IsShow == true).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList(); model.TotalCount = query.Where(m => (id > 0 ? m.ChannelId == id : m.ChannelId > 0) && m.IsShow == true).Count(); //加载帖子频道 Common.PostsChannel postsProperty = new Common.PostsChannel(); model.PostsChannelData = postsProperty.GetListByCache(); //加载热门帖子 model.HotListData = query.OrderByDescending(m => m.ReadCount).Where(m => m.PostDate >= DateTime.Now.AddDays(-7)).Skip(0).Take(10).ToList(); return(model); }
public IActionResult Index(int id = 0) { ViewModels.PostsViewModel model = LoadMainData(id); return(View(model)); }