public async Task <IList <LoginLogEntity> > Query(LoginLogQueryModel model) { var paging = model.Paging(); var query = Db.Find(); query.WhereNotNull(model.AccountId, m => m.AccountId == model.AccountId.Value); query.WhereNotNull(model.Platform, m => m.Platform == model.Platform.Value); query.WhereNotNull(model.LoginMode, m => m.LoginMode == model.LoginMode.Value); query.WhereNotNull(model.StartDate, m => m.LoginTime >= model.StartDate.Value.Date); query.WhereNotNull(model.EndDate, m => m.LoginTime < model.EndDate.Value.Date.AddDays(1)); if (!paging.OrderBy.Any()) { query.OrderByDescending(m => m.Id); } //导出全部 if (model.IsExport && model.Export.Mode == ExportMode.All) { model.ExportCount = await query.CountAsync(); if (model.IsOutOfExportCountLimit) { return(new List <LoginLogEntity>()); } return(await query.ToListAsync()); } var list = await query.PaginationAsync(paging); model.TotalCount = paging.TotalCount; return(list); }
public async Task <QueryResultModel <LoginLogEntity> > Query(LoginLogQueryModel model) { var paging = model.Paging(); var query = dbSet.AsQueryable(); if (!model.LoginName.IsNull()) { query = query.Where(a => a.LoginName.Equals(model.LoginName)); } if (!model.LoginIp.IsNull()) { query = query.Where(a => a.LoginIp.Equals(model.LoginIp)); } if (model.time_min != null) { query = query.Where(a => model.time_min < a.LoginTime); } if (model.time_max != null) { query = query.Where(a => model.time_max > a.LoginTime); } if (!paging.OrderBy.Any()) { query = query.OrderByDescending(m => m.Id); } return(await query.PaginationGetResult(paging)); }
public async Task <IResultModel <QueryResultModel <LoginLogEntity> > > Query(LoginLogQueryModel model) { var result = new ResultModel <QueryResultModel <LoginLogEntity> >(); var data = await _repository.Query(model); return(result.Success(data)); }
public async Task <IResultModel> QueryLogin(LoginLogQueryModel model) { var result = new QueryResultModel <LoginLogEntity> { Rows = await _loginLogRepository.Query(model), Total = model.TotalCount }; return(ResultModel.Success(result)); }
public async Task <IActionResult> LoginExport(LoginLogQueryModel model) { var result = await _service.ExportLogin(model); if (result.Successful) { return(ExportExcel(result.Data.Path, result.Data.FileName)); } return(Ok(result)); }
public async Task <IResultModel <ExcelExportResultModel> > ExportLogin(LoginLogQueryModel model) { var result = new ResultModel <ExcelExportResultModel>(); var list = await _loginLogRepository.Query(model); if (model.IsOutOfExportCountLimit) { return(result.Failed($"导出数据不能超过{model.ExportCountLimit}条")); } return(result.Success(_excelHandler.Export(model.Export, list))); }
public ActionResult GetLogList(LoginLogQueryModel model) { var result = new StandardJsonResult <ResultModel>(); result.Try(() => { LoginStatus _status; if (model.Status == null) { _status = LoginStatus.GetAll; } else { _status = (LoginStatus)model.Status; } if (model.rows < 1) { model.rows = 10; } if (model.page < 1) { model.page = 1; } result.Value = new ResultModel(); result.Value.rows = new List <LoginLogShowModel>(); int amount; List <UserLoginLogDto> tempList; try { tempList = _logService.SearchUserLoginLog(model.BeginTime, model.EndTime, model.UserName ?? "", model.EnterpriseName ?? "", _status, model.page, model.rows, out amount); } catch (Exception e) { //tempList = new List<UserLoginLogDto>(); //result.Fail("Service发生异常:" + e.Message ?? "" + "."); throw e; } result.Value.total = amount; foreach (var dto in tempList) { var r = (LoginLogShowModel)dto; result.Value.rows.Add(r); } //result.Value.rows.OrderBy(l => l.Time).Reverse(); }); return(result); }
public async Task <IList <LoginLogEntity> > Query(LoginLogQueryModel model) { var conditions = await _filter.GetConditions <LoginLogEntity, LoginLogQueryModel>(model); var query = _dbContext.Db.Queryable <LoginLogEntity>() .Where(conditions) .OrderBy(model.OrderFileds); RefAsync <int> totalCount = 0; var data = await query.ToPageListAsync(model.PageIndex, model.PageSize, totalCount); model.TotalCount = totalCount; return(data); }
public PagingResultModel <LoginLogDetailResultModel> GetLoginLogDetail(LoginLogQueryModel queryModel) { var logs = from detail in _logDetailRepository.Get(false) .AndIfHaveValue(queryModel.Account, l => l.OperatorAccount.Contains(queryModel.Account)) orderby detail.OperateAt descending select new LoginLogDetailResultModel { OperatorAccount = detail.OperatorAccount, OperateAt = detail.OperateAt, IpAddress = detail.IpAddress, IsSuccess = detail.IsSuccess }; return(new PagingResultModel <LoginLogDetailResultModel> { Count = logs.Count(), Data = logs.Skip((queryModel.Page - 1) * queryModel.Size).Take(queryModel.Size).ToList() }); }
public IActionResult GetLoginLog([FromQuery] LoginLogQueryModel queryModel) { var resultModel = _loginLogService.GetLoginLogDetail(queryModel); return(Ok(resultModel)); }
//[DisableAuditing] public async Task <QueryResultModel <LoginLogEntity> > Query(LoginLogQueryModel model) { var result = await _service.Query(model); return(result.Data); }
public Task <IResultModel> Query([FromQuery] LoginLogQueryModel model) { return(_service.Query(model)); }