public void List()
{
var request = new LoginLogQueryRequest
{
PageSize = 1,
PageIndex = 1
};
var list = service.List(request);
Assert.Equals(request.Records, 3);
}
//1.1 登录日志列表
public List <LoginLogResponse> List(LoginLogQueryRequest request)
{
List <LoginLogResponse> list = new List <LoginLogResponse>();
try
{
StringBuilder join = new StringBuilder();
if (request.Account.IsNotEmpty())
{
request.Account = $"%{request.Account}%";
join.Append(" and account like @Account");
}
if (request.DataType > 0)
{
join.Append(" and dataType = @DataType");
}
if (request.CreateStart.HasValue)
{
join.Append(" and createtime >= @CreateStart");
}
if (request.CreateEnd.HasValue)
{
request.CreateEnd = request.CreateEnd.Value.AddDays(1).AddSeconds(-1);
join.Append(" and createtime<=@CreateEnd");
}
var sql = $"select * from t_sys_loginlog where isdelete=0 {join.ToString()} order by createtime desc";
int totalCount = 0;
list = _dbContext.Page <LoginLogResponse>(sql, out totalCount, request.PageIndex, request.PageSize, request);
request.Records = totalCount;
}
catch (Exception ex)
{
LogUtils.LogError("LoginLogService.List", ex);
}
return(list);
}
