public IActionResult GetList(NewsRequestPayload payload)
 {
     using (_dbContext)
     {
         var query = from p in _dbContext.ExternalLink
                     where p.IsDeleted != 1
                     orderby p.Id ascending
                     select new
         {
             p.ExternalLinkUuid,
             p.Link,
             p.IsDeleted,
             p.Staue,
             p.Remark
         };
         if (!string.IsNullOrEmpty(payload.Kw))
         {
             query = query.Where(x => x.Link.Contains(payload.Kw.Trim()));
         }
         var list       = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
         var totalCount = query.Count();
         var response   = ResponseModelFactory.CreateResultInstance;
         response.SetData(list, totalCount);
         ToLog.AddLog("查询", "成功:查询:外部链接列表信息数据", _dbContext);
         return(Ok(response));
     }
 }
        public IActionResult List(NewsRequestPayload payload)
        {
            using (_dbContext)
            {
                var query = _dbContext.Content.Where(x => x.ColumnModel == "列表栏目" && x.SuperiorUuid != null && x.SuperiorMenu != 1);

                if (!string.IsNullOrEmpty(payload.Kw))
                {
                    query = query.Where(x => x.ColumnTitle.Contains(payload.Kw.Trim()));
                }
                if (!string.IsNullOrEmpty(payload.Kw1))
                {
                    query = query.Where(x => x.SuperiorUuid == Guid.Parse(payload.Kw1.Trim()));
                }
                if (payload.Staue > -1)
                {
                    query = query.Where(x => x.Staue == payload.Staue.ToString());
                }
                if (payload.IsDeleted > CommonEnum.IsDeleted.All)
                {
                    query = query.Where(x => x.IsDeleted == Convert.ToInt32(((CommonEnum.IsDeleted)payload.IsDeleted)));
                }
                query = query.OrderByDescending(x => x.IsStick).ThenByDescending(x => x.Id);
                var list       = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
                var totalCount = query.Count();
                var response   = ResponseModelFactory.CreateResultInstance;
                response.SetData(list, totalCount);
                ToLog.AddLog("查询", "成功:查询:内容管理信息数据", _dbContext);
                return(Ok(response));
            }
        }
Пример #3
0
 public IActionResult List(NewsRequestPayload payload)
 {
     using (_dbContext)
     {
         var query = from p in _dbContext.Proclamation
                     where p.IsDeleted != 1
                     orderby p.Id ascending
                     select new
         {
             p.ProclamationUuid,
             p.ProclamationTitle,
             p.IsDeleted,
             p.SortId,
             p.ProclamationContent,
             p.Staue,
             p.IsStick
         };
         if (!string.IsNullOrEmpty(payload.Kw))
         {
             query = query.Where(x => x.ProclamationTitle.Contains(payload.Kw.Trim()));
         }
         query = query.OrderByDescending(x => x.IsStick).ThenBy(x => x.SortId);
         var list       = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
         var totalCount = query.Count();
         var response   = ResponseModelFactory.CreateResultInstance;
         response.SetData(list, totalCount);
         ToLog.AddLog("查询", "成功:查询:通知公告列表信息数据", _dbContext);
         return(Ok(response));
     }
 }
Пример #4
0
 public IActionResult List(NewsRequestPayload payload)
 {
     using (_dbContext)
     {
         var query = _dbContext.RestsData.Where(x => x.IsDeleted != 1);
         if (!string.IsNullOrEmpty(payload.Kw))
         {
             query = query.Where(x => x.Name.Contains(payload.Kw.Trim()));
         }
         var list       = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
         var totalCount = query.Count();
         var response   = ResponseModelFactory.CreateResultInstance;
         response.SetData(list, totalCount);
         ToLog.AddLog("查询", "成功:查询:其他数据信息数据", _dbContext);
         return(Ok(response));
     }
 }
Пример #5
0
 public IActionResult List(NewsRequestPayload payload)
 {
     using (_dbContext)
     {
         var query = from p in _dbContext.News
                     //where p.IsDeleted != 1
                     orderby p.Id ascending
                     select new
         {
             p.NewsUuid,
             p.NewsTitle,
             p.NewSubhead,
             p.SortId,
             p.NewsUrl,
             p.IsDeleted,
             p.Staue,
             p.IsStick
         };
         if (!string.IsNullOrEmpty(payload.Kw))
         {
             query = query.Where(x => x.NewsTitle.Contains(payload.Kw.Trim()));
         }
         if (payload.Staue > -1)
         {
             query = query.Where(x => x.Staue == payload.Staue);
         }
         if (payload.IsDeleted > CommonEnum.IsDeleted.All)
         {
             query = query.Where(x => x.IsDeleted == Convert.ToInt32(((CommonEnum.IsDeleted)payload.IsDeleted)));
         }
         query = query.OrderByDescending(x => x.IsStick).ThenByDescending(x => x.NewsUrl);
         var list       = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
         var totalCount = query.Count();
         var response   = ResponseModelFactory.CreateResultInstance;
         response.SetData(list, totalCount);
         ToLog.AddLog("查询", "成功:查询:新闻列表信息数据", _dbContext);
         return(Ok(response));
     }
 }