/// <summary> /// 带条件查询所有 /// </summary> public async Task <List <LogLoginEntity> > GetList(LogLoginListParam param) { #region 查询条件 var query = _logLoginEntityDB.AsQueryable(); /* * // ip地址 * if (!string.IsNullOrEmpty(param.IpAddress)) * query = query.Where(p => p.IpAddress.Contains(param.IpAddress)); * // 浏览器 * if (!string.IsNullOrEmpty(param.Browser)) * query = query.Where(p => p.Browser.Contains(param.Browser)); * // 操作系统 * if (!string.IsNullOrEmpty(param.OS)) * query = query.Where(p => p.OS.Contains(param.OS)); * */ #endregion var data = await query.ToListAsync(); return(data); }
/// <summary> /// 分页查询 /// </summary> public async Task <List <LogLoginEntity> > GetPageList(LogLoginListParam param, Pagination pagination) { #region 查询条件 var query = _logLoginEntityDB.AsQueryable(); /* * // ip地址 * if (!string.IsNullOrEmpty(param.IpAddress)) * query = query.Where(p => p.IpAddress.Contains(param.IpAddress)); * // 浏览器 * if (!string.IsNullOrEmpty(param.Browser)) * query = query.Where(p => p.Browser.Contains(param.Browser)); * // 操作系统 * if (!string.IsNullOrEmpty(param.OS)) * query = query.Where(p => p.OS.Contains(param.OS)); * */ var data = await query.OrderByDescending(a => a.Id) .ToPagedListAsync(pagination.PageIndex, pagination.PageSize); #endregion // 分页参数赋值 pagination.TotalCount = data.TotalCount; return(data.Items.ToList()); }
public async Task <TData <List <LogLoginEntity> > > GetPageListJson([FromQuery] LogLoginListParam param, [FromQuery] Pagination pagination) { var obj = await _logLoginBLL.GetPageList(param, pagination); return(obj); }
public async Task <List <LogLoginEntity> > GetPageList(LogLoginListParam param, Pagination pagination) { var strSql = new StringBuilder(); List <DbParameter> filter = ListFilter(param, strSql); var list = await this.BaseRepository().FindList <LogLoginEntity>(strSql.ToString(), filter.ToArray(), pagination); return(list.ToList()); }
public async Task <TData <List <LogLoginEntity> > > GetList(LogLoginListParam param) { TData <List <LogLoginEntity> > obj = new TData <List <LogLoginEntity> >(); obj.Data = await logLoginService.GetList(param); obj.Tag = 1; return(obj); }
public async Task <TData <List <LogLoginEntity> > > GetPageList(LogLoginListParam param, Pagination pagination) { TData <List <LogLoginEntity> > obj = new TData <List <LogLoginEntity> >(); obj.Data = await logLoginService.GetPageList(param, pagination); obj.Total = pagination.TotalCount; obj.Tag = 1; return(obj); }
public async Task <TData <List <LogLoginEntity> > > GetList(LogLoginListParam param) { var obj = new TData <List <LogLoginEntity> >(); obj.Data = await _logLoginService.GetList(param); obj.Data.ForEach(a => a.IpLocation = IpLocationHelper.GetIpLocation(a.IpAddress)); obj.Tag = 1; return(obj); }
private List <DbParameter> ListFilter(LogLoginListParam param, StringBuilder strSql) { strSql.Append(@"SELECT a.id as Id, a.base_modify_time as BaseModifyTime, a.base_modifier_id as BaseModifierId, a.log_status as LogStatus, a.ip_address as IpAddress, a.ip_location as IpLocation, a.browser as Browser, a.os as OS, a.remark as Remark, b.user_name as UserName FROM sys_log_login a LEFT JOIN sys_user b ON a.base_modifier_id = b.id WHERE 1 = 1"); var parameter = new List <DbParameter>(); if (param != null) { if (!string.IsNullOrEmpty(param.UserName)) { strSql.Append(" AND b.user_name like @UserName"); parameter.Add(DbParameterExtension.CreateDbParameter("@UserName", '%' + param.UserName + '%')); } if (param.LogStatus > -1) { strSql.Append(" AND a.log_status = @LogStatus"); parameter.Add(DbParameterExtension.CreateDbParameter("@LogStatus", param.LogStatus)); } if (!string.IsNullOrEmpty(param.IpAddress)) { strSql.Append(" AND a.ip_address like @IpAddress"); parameter.Add(DbParameterExtension.CreateDbParameter("@IpAddress", '%' + param.IpAddress + '%')); } if (!string.IsNullOrEmpty(param.StartTime.ParseToString())) { strSql.Append(" AND a.base_modify_time >= @StartTime"); parameter.Add(DbParameterExtension.CreateDbParameter("@StartTime", param.StartTime)); } if (!string.IsNullOrEmpty(param.EndTime.ParseToString())) { param.EndTime = (param.EndTime.Value.ToString("yyyy-MM-dd") + " 23:59:59").ParseToDateTime(); strSql.Append(" AND a.base_modify_time <= @EndTime"); parameter.Add(DbParameterExtension.CreateDbParameter("@EndTime", param.EndTime)); } } return(parameter); }
private List <DbParameter> ListFilter(LogLoginListParam param, StringBuilder strSql) { strSql.Append(@"SELECT a.Id, a.BaseCreateTime, a.BaseCreatorId, a.LogStatus, a.IpAddress, a.IpLocation, a.Browser, a.OS, a.Remark, b.UserName FROM SysLogLogin a LEFT JOIN SysUser b ON a.BaseCreatorId = b.Id WHERE 1 = 1"); var parameter = new List <DbParameter>(); if (param != null) { if (!string.IsNullOrEmpty(param.UserName)) { strSql.Append(" AND b.UserName like @UserName"); parameter.Add(DbParameterExtension.CreateDbParameter("@UserName", '%' + param.UserName + '%')); } if (param.LogStatus > -1) { strSql.Append(" AND a.LogStatus = @LogStatus"); parameter.Add(DbParameterExtension.CreateDbParameter("@LogStatus", param.LogStatus)); } if (!string.IsNullOrEmpty(param.IpAddress)) { strSql.Append(" AND a.IpAddress like @IpAddress"); parameter.Add(DbParameterExtension.CreateDbParameter("@IpAddress", '%' + param.IpAddress + '%')); } if (!string.IsNullOrEmpty(param.StartTime.ParseToString())) { strSql.Append(" AND a.BaseCreateTime >= @StartTime"); parameter.Add(DbParameterExtension.CreateDbParameter("@StartTime", param.StartTime)); } if (!string.IsNullOrEmpty(param.EndTime.ParseToString())) { param.EndTime = (param.EndTime.Value.ToString("yyyy-MM-dd") + " 23:59:59").ParseToDateTime(); strSql.Append(" AND a.BaseCreateTime <= @EndTime"); parameter.Add(DbParameterExtension.CreateDbParameter("@EndTime", param.EndTime)); } } return(parameter); }
private IQueryable <LogLoginEntity> ListFilter(LogLoginListParam param) { var query = from a in _logLoginEntityDB.AsQueryable() join b in _userEntityDB.AsQueryable() on a.CreatorId equals b.Id into ab from res in ab.DefaultIfEmpty() select new LogLoginEntity { Id = a.Id, Browser = a.Browser, ExtraRemark = a.ExtraRemark, IpAddress = a.IpAddress, IpLocation = a.IpLocation, LogStatus = a.LogStatus, OS = a.OS, Remark = a.Remark, UserName = res.UserName, CreateTime = a.CreateTime }; if (!string.IsNullOrEmpty(param.UserName)) { query = query.Where(p => p.UserName.Contains(param.UserName)); } if (param.LogStatus > -1) { query = query.Where(p => p.LogStatus == param.LogStatus); } if (!string.IsNullOrEmpty(param.IpAddress)) { query = query.Where(p => p.IpAddress.Contains(param.IpAddress)); } if (param.StartTime.HasValue) { query = query.Where(p => p.CreateTime >= param.StartTime); } if (param.EndTime.HasValue) { query = query.Where(p => p.CreateTime <= param.EndTime.Value.AddDays(1)); } return(query); }
public async Task <IActionResult> GetPageListJson(LogLoginListParam param, Pagination pagination) { TData <List <LogLoginEntity> > obj = await logLoginBLL.GetPageList(param, pagination); return(Json(obj)); }
public async Task <TData <List <LogLoginEntity> > > GetListJson([FromQuery] LogLoginListParam param) { var obj = await _logLoginBLL.GetList(param); return(obj); }