public async Task <IActionResult> GetSystemUsersAsync([FromQuery] SystemUsersQuery args) { var response = new Response <SystemUsers>(); try { var p = Express.Begin <SystemUsers>(true); if (!string.IsNullOrEmpty(args.UserName)) { p = p.And(e => e.UsersName.Contains(args.UserName)); } if (!string.IsNullOrEmpty(args.LoginName)) { p = p.And(e => e.LoginName == args.LoginName); } if (!string.IsNullOrEmpty(args.Email)) { p = p.And(e => e.Email.Contains(args.Email)); } if (args.IsEnable.HasValue) { p = p.And(e => e.IsEnable == args.IsEnable); } //var result = await this._ISystemUsersRepository.QueryPager(p, e => e.LoginTime, true, args.PageIndex.Value, args.PageSize.Value); response.Code = true; //response.Data.Entities = result.Item2; //response.Data.PageCount = result.Item1; } catch (Exception ex) { response.SetError(ex, this._ILogger); } return(response.ToHttpResponse()); }
public async Task <IActionResult> PostNewsDocLocalHostAsync([FromHeader] String source, [FromRoute] SiteRoute route) { var response = new Response <Object>(); try { var categories = await _IWebCategoryRepository.Query(a => a.SiteId == route.mark && a.IsEnable == 1, a => a.Sequence).ToListAsync(); await _IWebNewsElastic.AddIndexAsync(_IWebNewsElastic.IndexName); var lastNews = new WebNews(); var current = System.DateTime.Now; for (int pageIndex = 1; pageIndex <= 40; pageIndex++) { var news = new List <WebNews>(); var express = Express.Begin <WebNews>(true); express = express.And(a => a.SiteId == route.mark && a.IsEnable == 1 && a.PushTime <= current); news = await _IWebNewsRepository.Query(express) .OrderByDescending(a => a.PushTime) .ToPager(pageIndex, 30000) .ToListAsync(); lastNews = news.LastOrDefault(); if (lastNews != null) { var docs = new List <WebNewsDoc>(); news.ForEach(x => { var category = categories.SingleOrDefault(a => a.CategoryName == x.CategoryName); if (category != null) { docs.Add(GetWebNewsDoc(x)); } }); if (docs.Count > 0) { await _IWebNewsElastic.BatchAddDocumentAsync(_IWebNewsElastic.IndexName, docs); } } } response.Code = true; response.Other = null; } catch (Exception ex) { response.SetError(ex, this._ILogger); } return(response.ToHttpResponse()); }
public async Task <IActionResult> GetMemberCommentAsync([FromHeader] String source, [FromRoute] RouteIdString route, [FromQuery] CommentGet item) { var response = new Response <Object>(); try { var express = Express.Begin <MemberComment>(true); express = express.And(a => a.NewsId == route.id && a.ParentId == 0 && a.IsEnable == 1); var result = await _IMemberCommentRepository.Query(express) .Select(a => new { CommentId = a.CommentId, NewsId = a.NewsId, ParentId = a.ParentId, MemberId = a.MemberId, MemberName = a.MemberName, CommentBody = a.CommentBody, CommentTime = a.CommentTime, QuoteId = a.QuoteId, QuoteName = a.QuoteName, Up = a.Up, Number = a.Number, Avatar = a.MemberInfos.Avatar, IsUp = item.MemberId > 0 ? a.MemberCommentUps.Any(b => b.MemberId == item.MemberId) : false }) .OrderBy(a => a.CommentTime) .ToPager(item.PageIndex.Value, item.PageSize.Value) .ToListAsync(); if (result.Count <= 0) { return(NoContent()); } else { response.Code = true; response.Data = result; } } catch (Exception ex) { response.SetError(ex, this._ILogger); } return(response.ToHttpResponse()); }
public async Task <IActionResult> GetMessageAsync([FromHeader] String source, [FromQuery] PagerBase item) { var response = new Response <Object>(); try { var express = Express.Begin <MemberMessage>(true); express = express.And(a => a.MemberId == MemberId && a.IsEnable == 1); var result = await _IMemberMessageRepository.Query(express) .OrderByDescending(a => a.CreateTime) .ToPager(item.PageIndex.Value, item.PageSize.Value) .Select(a => new { MessageId = a.MessageId, MemberId = a.MemberId, MemberName = a.MemberName, LeaveBody = a.LeaveBody, LeaveType = a.LeaveType, CreateTime = a.CreateTime }) .ToListAsync(); if (result.Count <= 0) { return(NoContent()); } else { response.Code = true; response.Data = result; } } catch (Exception ex) { response.SetError(ex, this._ILogger); } return(response.ToHttpResponse()); }