public IActionResult Account(BeginEndRequest request) { var data = _context.Account.WhereIf(x => x.CreateTime >= request.Begin.Value.Date, request.Begin.HasValue) .WhereIf(x => x.CreateTime < request.End.Value.Date.AddDays(1), request.End.HasValue) .OrderByDescending(x => x.Id) .ToPageData <Account, AccountModel>(request.Page, request.PageSize); return(Json(data.Success())); }
public IActionResult Index(BeginEndRequest request) { var userCount = _context.Account.WhereIf(x => x.CreateTime >= request.Begin.Value.Date, request.Begin.HasValue) .WhereIf(x => x.CreateTime < request.End.Value.Date.AddDays(1), request.End.HasValue).Count(); var topicCount = _context.Topic.WhereIf(x => x.CreateTime >= request.Begin.Value.Date, request.Begin.HasValue) .WhereIf(x => x.CreateTime < request.End.Value.Date.AddDays(1), request.End.HasValue).Count(); var commentCount = _context.Comment.WhereIf(x => x.CreateTime >= request.Begin.Value.Date, request.Begin.HasValue) .WhereIf(x => x.CreateTime < request.End.Value.Date.AddDays(1), request.End.HasValue).Count(); var data = new { userCount, topicCount, commentCount }; return(Json(data.Success())); }
public IActionResult Index() { DateTime end = DateTime.Now, begin = end.AddDays(-7); BeginEndRequest model = new BeginEndRequest() { Begin = begin, End = end }; return(View(model)); }