//public IActionResult KeyNote(long postId) //{ // var result = _postDetialView.Execute(new PostDetailDataBind { PostId = postId }); // if (result == null) // { // RedirectToAction("Error", "Home"); // } // TagCloudDataBind tagCloudDataBind = new TagCloudDataBind(); // var tagResult = _tagCloudView.Execute(tagCloudDataBind); // Tuple<PostDetialViewModel, List<TagCloudViewModel>> tuple = new Tuple<PostDetialViewModel, List<TagCloudViewModel>>(result, tagResult); // return View(tuple); //} public IActionResult Index(int page = 1, int pageSize = 10) { PostListDataBind postListDataBind = new PostListDataBind(); postListDataBind.PageIndex = page; postListDataBind.PageSize = pageSize; TagCloudDataBind tagCloudDataBind = new TagCloudDataBind(); var tagResult = _tagCloudView.Execute(tagCloudDataBind); var resultModel = _postListView.Execute(postListDataBind); //var ipAddr = _netWorkTool.GetRemoteIp(); Tuple <PageInfo <PostListViewModel>, List <TagCloudViewModel> > tuple = new Tuple <PageInfo <PostListViewModel>, List <TagCloudViewModel> >(resultModel, tagResult); return(View(tuple)); }
public List <TagCloudViewModel> Execute(TagCloudDataBind command) { const string sql = "SELECT t.tag as TagName,count(t.post_id) as TagPostCount from tag t GROUP BY t.tag"; using (var conn = _dapperConnection.GetDataBaseConnection()) { var result = conn.Query <TagCloudViewModel>(sql); if (result != null && result.Count() > 0) { return(result.ToList()); } } return(null); }
public IActionResult PostDetail(long postId) { var result = _postDetialView.Execute(new PostDetailDataBind { PostId = postId }); if (result == null) { RedirectToAction("Error", "Home"); } TagCloudDataBind tagCloudDataBind = new TagCloudDataBind(); var tagResult = _tagCloudView.Execute(tagCloudDataBind); Tuple <PostDetialViewModel, List <TagCloudViewModel> > tuple = new Tuple <PostDetialViewModel, List <TagCloudViewModel> >(result, tagResult); return(View(tuple)); }