コード例 #1
0
        public ExecuteResult<CommentCollectionResponse> GetList(CommentListRequest request)
        {
            int totalCount;
            var data = this._commentRepository.GetPagedList(request.PagerRequest.PageIndex, request.PagerRequest.PageSize,
                                                 out totalCount, request.SortOrder, request.Timestamp, request.SourceId, request.SType);

            var result = new ExecuteResult<CommentCollectionResponse>();
            var response = new CommentCollectionResponse(request.PagerRequest, totalCount)
                {
                    Comments = MappingManager.CommentInfoResponseMapping(data, request.Version).ToList()
                };

            result.Data = response;

            return result;
        }
コード例 #2
0
        public ActionResult List(CommentListRequest request)
        {
            var linq = _commentRepo.Get(c => c.Status != (int)DataStatus.Deleted && c.SourceId == request.SourceId && c.SourceType == request.SourceType)
                           .GroupJoin(_resourceRepo.Get(r => r.Status != (int)DataStatus.Deleted && r.SourceType == (int)SourceType.CommentAudio),
                                       o => o.Id,
                                       i => i.SourceId,
                                       (o, i) => new { C = o, Aud = i })
                           .GroupJoin(_customerRepo.Get(cu => cu.Status != (int)DataStatus.Deleted),
                                       o => o.C.User_Id,
                                       i => i.Id,
                                       (o, i) => new { C = o.C, Aud = o.Aud, U = i.FirstOrDefault() })
                            .GroupJoin(_customerRepo.Get(cu => cu.Status != (int)DataStatus.Deleted),
                                       o => o.C.ReplyUser,
                                       i => i.Id,
                                       (o, i) => new { C = o.C, Aud = o.Aud, U = o.U, RU = i.FirstOrDefault() })
                            .GroupJoin(_commentRepo.Get(cr => cr.Status != (int)DataStatus.Deleted), o => o.C.ReplyId, i => i.Id,
                                      (o, i) => new { C = o.C, Aud = o.Aud, U = o.U, RU =o.RU,CR=i.FirstOrDefault()});
            
            int totalCount = linq.Count();
            int skipCount = request.Page > 0 ? (request.Page - 1) * request.Pagesize : 0;
            linq = linq.OrderByDescending(c => c.C.CreatedDate).Skip(skipCount).Take(request.Pagesize);
            var responseData = from l in linq.ToList()
                               select new CommentInfoResponse().FromEntity<CommentInfoResponse>(l.C,
                                           c =>
                                           {
                                               c.Customer = new ShowCustomerInfoResponse().FromEntity<ShowCustomerInfoResponse>(l.U);
                                               if (l.RU !=null)
                                               {
                                                   c.ReplyUserNickname = l.RU.Nickname;
                                                   c.ReplyUser = l.RU.Id;
                                               }
                                               c.ResourceInfoResponses=l.Aud.Select(ca=>new ResourceInfoResponse().FromEntity<ResourceInfoResponse>(ca)).ToList();

                                           });
            var response = new CommentCollectionResponse(request.PagerRequest, totalCount)
            {
               Comments = responseData.ToList()
            };
            return this.RenderSuccess<CommentCollectionResponse>(r => r.Data = response);
                
        }