/// <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);
}
