Esempio n. 1
0
        public ActionResult Query(BcceSearchDTO dto)
        {
            UserLoginDTO lng = Session["UserLoginInfo"] as UserLoginDTO;

            dto.UserInfo = lng.UserInfo();
            var result = _BcceService.Query(dto);

            return(new JsonResult(result));
        }
Esempio n. 2
0
        /// <summary>
        /// 查询列表
        /// </summary>
        public PageableDTO <BcceResultDTO> Query(BcceSearchDTO q)
        {
            if (q.PublishDateTo.HasValue)
            {
                q.PublishDateTo = new DateTime(q.PublishDateTo.Value.Year, q.PublishDateTo.Value.Month, q.PublishDateTo.Value.Day, 23, 59, 59);
            }
            var token = q.UserInfo as UserInfoDTO;

            q.InitQuery("PublishDate", false);
            return(document.Document_Bcce
                   .Where(p => string.IsNullOrEmpty(q.Search) ? true : (p.ProductNo.Contains(q.Search) || p.Title.Contains(q.Search) || p.Publisher.Contains(q.Search)))//货号、标题、发布人
                   .Where(p => q.PublishDateFrom.HasValue ? p.PublishDate >= q.PublishDateFrom : true)
                   .Where(p => q.PublishDateTo.HasValue ? p.PublishDate <= q.PublishDateTo : true)
                   //.Where(p => token.UserType != 2 ? true : token.ProductLineIDs.Contains(p.ProductLineID.Value))
                   .Select(p => new BcceResultDTO
            {
                BcceID = p.BcceID,
                //ProductLineID = p.ProductLineID,
                //ProductTypeID = p.ProductTypeID,
                //ProductTypeName = p.ProductTypeName,
                //ProductLineName = p.ProductLineName,
                ProductNo = p.ProductNo,
                Title = p.Title,
                ValidDate = p.ValidDate,
                Publisher = p.Publisher,
                PublishDate = p.PublishDate,
                UpdateDate = p.UpdateDate,
                IsDownload = p.Document_BcceAttachment.All(att => att.Document_BcceAttachmentDownload.Count > 0 && att.Document_BcceAttachmentDownload.All(down => down.IsDownload == true && down.UserID == token.UserID)),
                Attachments = p.Document_BcceAttachment.Select(att => new BcceAttachmentDTO
                {
                    AttachmentID = att.AttachmentID,
                    AttachmentName = att.AttachmentName,
                    AttachmentSize = att.AttachmentSize
                })
            }).ToPageable(q));
        }