public ActionResult GetPosts([FromQuery] int offset, [FromQuery] int count) { try { var posts = postsRepository.GetPosts(offset, count) .Select(p => new PostDto(p, albumsRepository.GetAlbumAttachment(p.AlbumId))).ToArray(); var response = new PostsResponse(posts, postsRepository.PostsCount); return(new JsonResult(response)); } catch (Exception x) { return(new ContentResult { Content = x.ToString(), StatusCode = (int)HttpStatusCode.InternalServerError, ContentType = "text/plain" }); } }
/// <summary> /// 帖子内容阅读 /// </summary> /// <param name="id"></param> /// <returns></returns> public IActionResult Read(string id) { int postsId = Framework.Core.Transform.GetInt(id, 0); ViewModels.PostsReadViewModel model = new ViewModels.PostsReadViewModel(); if (postsId != 0) { PostsRepository repository = new PostsRepository(); model.PostsData = repository.GetPosts(postsId)[0]; int pageSize = 10; int pageIndex = Framework.Core.Transform.GetInt(Request.Query["p"], 1); var query = repository.GetAnswerPageList(); model.AnswerListData = query.Where(m => m.PostsId == postsId).Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList(); model.TotalCount = query.Where(m => m.PostsId == postsId).Count(); //加载帖子频道 Common.PostsChannel postsProperty = new Common.PostsChannel(); model.PostsChannelData = postsProperty.GetListByCache(); //加载热门帖子 model.HotListData = repository.GetPostsListByHot().OrderByDescending(m => m.PlusCount).Where(m => m.PostDate >= DateTime.Now.AddDays(-7)).Skip(0).Take(10).ToList(); } return(View(model)); }
public IActionResult Index() { var repo = new PostsRepository(_connectionString); return(View(repo.GetPosts())); }
// GET: Posts public ActionResult Index() { var posts = postRepository.GetPosts(); return(View(posts)); }