public ActionResult List(string articleId, int?page = 1) { try { if (string.IsNullOrEmpty(articleId)) { return(Json(new { code = 401, msg = "articleId不能为空" })); } CommentListQuery listModel = new CommentListQuery(); listModel.PageIndex = Convert.ToInt32(page); listModel.PageSize = 10; listModel.ArticleId = articleId; CommentListModelResult result = _commentService.GetPaged(listModel); StaticPagedList <Comment> pageList = new StaticPagedList <Comment>(result.List, listModel.PageIndex, listModel.PageSize, result.TotalCount); GetChildren(result.List.ToList()); return(Json(new { code = 200, data = result.List, pageNumber = pageList.PageNumber, pageCount = pageList.PageCount }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { LogService.Instance.AddAsync(Level.Error, ex); return(Json(new { code = 500, msg = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public CommentListModelResult GetPaged(CommentListQuery listModel) { CommentListModelResult result = new CommentListModelResult(); result.List = new List <Comment>(); StringBuilder builder = new StringBuilder("select * from Comment where Enable = 1 and parentId = 0"); if (!string.IsNullOrEmpty(listModel.ArticleId)) { builder.Append(" and ArticleId = ?"); } if (string.IsNullOrEmpty(listModel.Order)) { builder.Append(" order by createtime desc,CommentId asc"); } object[] para = { listModel.ArticleId }; DataTable dt = SQLiteHelper.ExecutePager(listModel.PageIndex, listModel.PageSize, builder.ToString(), para); foreach (DataRow item in dt.Rows) { result.List.Add(RowToModel(item)); } StringBuilder countSql = new StringBuilder("select count(1) from Comment where Enable = 1 and parentId = 0"); if (!string.IsNullOrEmpty(listModel.ArticleId)) { countSql.Append(" and ArticleId = ?"); } object countNum = SQLiteHelper.ExecuteScalar(countSql.ToString(), para); result.TotalCount = Convert.ToInt32(countNum); return(result); }
public CommentListModelResult GetPaged(CommentListQuery listModel) { return(_commentRepository.GetPaged(listModel)); }