public BaseListResponse <SPGetDocumentDeliveredStatistics_Result> DocumentDeliveredStatisticsList([FromUri] DocumentDeliveredStatisticsQuery query)
 {
     return(documentService.GetDocumentDeliveredStatisticsList(query));
 }
 public BaseResponse <string> DocumentDeliveredStatisticsListDownLoadFile([FromUri] DocumentDeliveredStatisticsQuery query)
 {
     return(documentService.GetDocumentDeliveredStatisticsDownload(query));
 }
        public List <SPGetDocumentDeliveredStatistics_Result> GetDocumentDeliveredStatisticsDownload(DocumentDeliveredStatisticsQuery query, out int count)
        {
            int pageNumber = query.PageNumber != 0 ? query.PageNumber : 1;
            var keyword    = string.IsNullOrEmpty(query.Keyword) != true ? query.Keyword : "";
            var userId     = string.IsNullOrEmpty(query.UserId) != true ? query.UserId : "";
            var start      = 0;
            var limit      = 1000;

            start = (pageNumber - 1) * limit;
            int totalRow = 0;
            List <SPGetDocumentDeliveredStatistics_Result> result = new List <SPGetDocumentDeliveredStatistics_Result>();
            ObjectParameter prTotalRow = new ObjectParameter("Total", totalRow);

            result = _entities.SPGetDocumentDeliveredStatistics(query.Keyword,
                                                                query.StartDate,
                                                                query.EndDate,
                                                                query.DepartmentId,
                                                                query.ListSignById,
                                                                query.ListDocumentFieldId,
                                                                query.ListDocumentTypeId,
                                                                start,
                                                                limit,
                                                                prTotalRow).ToList();
            count = (prTotalRow.Value == null) ? 0 : Convert.ToInt32(prTotalRow.Value);
            return(result);
        }