Example #1
0
        /// <summary>
        /// 获取 消息中心的 通知公告 公司新闻 事务通知
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public async Task <PagedResultDto <NoticeList> > GetPage(GetNoticeListInput input)
        {
            var query = CreateNoticeQuery(input.NoticeType);

            if (query == null)
            {
                return(new PagedResultDto <NoticeList>(0, new List <NoticeList>()));
            }
            query = query.WhereIf(!input.SearchKey.IsNullOrWhiteSpace(), r => r.Title.Contains(input.SearchKey) || r.CreateUserName.Contains(input.SearchKey));
            query =
                (from a in query
                 join b in _followRepository.GetAll().Where(x => x.BusinessType == FollowType.公告 && x.CreatorUserId == AbpSession.UserId.Value) on a.LogId equals b.BusinessId into tmp1
                 from c in tmp1.DefaultIfEmpty()
                 where (input.IsFollow ? c != null : true)
                 select new NoticeList()
            {
                LogId = a.LogId,
                TextId = a.TextId,
                Title = a.Title,
                Content = a.Content,
                IsRead = a.IsRead,
                ProjectId = a.ProjectId,
                Type = a.Type,
                CreateUserName = a.CreateUserName,
                CreateUserId = a.CreateUserId,
                IsFollow = c != null,
                CreationTime = a.CreationTime
            }
                );

            var total = await query.CountAsync();

            var list = await query.Skip(input.SkipCount).Take(input.MaxResultCount).ToListAsync();

            if (input.NoticeType == 1)
            {
                foreach (var m in list)
                {
                    if (m.IsRead)
                    {
                        continue;
                    }
                    var log = await _noticeLogRepository.GetAsync(m.LogId);

                    if (log != null)
                    {
                        log.Status   = 2;
                        log.ReadTime = DateTime.Now;
                        await _noticeLogRepository.UpdateAsync(log);
                    }
                }
            }

            return(new PagedResultDto <NoticeList>(total, list));
        }
Example #2
0
        public async Task <PagedResultDto <NoticeList> > GetNoticeTextsAsync(GetNoticeListInput input)
        {
            var queryBase = _noticeTextRepository.GetAll().Where(a => a.NoticeType == 2);

            if (input.IsNew)
            {
                var newNotice = queryBase.OrderByDescending(a => a.CreationTime).FirstOrDefault();
                if (newNotice != null)
                {
                    queryBase = queryBase.Where(x => x.Id != newNotice.Id);
                }
            }
            var query =
                (from a in queryBase
                 join b in _followRepository.GetAll().Where(x => x.BusinessType == FollowType.公告 && x.CreatorUserId == AbpSession.UserId.Value) on a.Id equals b.BusinessId into tmp1
                 from c in tmp1.DefaultIfEmpty()
                 join d in _userRepository.GetAll() on a.CreatorUserId equals d.Id
                 where (input.IsFollow?c != null:true)
                 select new NoticeList()
            {
                TextId = a.Id,
                Title = a.Title,
                CreateUserName = d.Name,
                CreateUserId = a.CreatorUserId.Value,
                Content = a.MsgConent,
                IsFollow = c != null,
                CreationTime = a.CreationTime
            }
                );

            if (!string.IsNullOrWhiteSpace(input.SearchKey))
            {
                query = query.Where(r => r.Title.Contains(input.SearchKey) || r.CreateUserName.Contains(input.SearchKey));
            }
            var count = await query.CountAsync();

            var notices = await query.OrderByDescending(r => r.CreationTime).PageBy(input).ToListAsync();

            return(new PagedResultDto <NoticeList>()
            {
                TotalCount = count, Items = notices
            });
        }