public async Task <JsonResult> GetSysLoginRecord() { var jm = new AdminUiCallBack(); //获取数据 var list = await _sysLoginRecordServices.QueryPageAsync(p => p.id > 0, p => p.createTime, OrderByType.Desc, 1, 10); //返回数据 jm.data = list; jm.code = 0; jm.count = list.TotalCount; jm.msg = "数据调用成功!"; return(new JsonResult(jm)); }
public async Task <JsonResult> GetPageList() { var jm = new AdminUiCallBack(); var pageCurrent = Request.Form["page"].FirstOrDefault().ObjectToInt(1); var pageSize = Request.Form["limit"].FirstOrDefault().ObjectToInt(30); var where = PredicateBuilder.True <SysLoginRecord>(); //获取排序字段 var orderField = Request.Form["orderField"].FirstOrDefault(); Expression <Func <SysLoginRecord, object> > orderEx; switch (orderField) { case "id": orderEx = p => p.id; break; case "username": orderEx = p => p.username; break; case "os": orderEx = p => p.os; break; case "device": orderEx = p => p.device; break; case "browser": orderEx = p => p.browser; break; case "ip": orderEx = p => p.ip; break; case "operType": orderEx = p => p.operType; break; case "comments": orderEx = p => p.comments; break; case "createTime": orderEx = p => p.createTime; break; case "updateTime": orderEx = p => p.updateTime; break; default: orderEx = p => p.id; break; } //设置排序方式 var orderDirection = Request.Form["orderDirection"].FirstOrDefault(); var orderBy = orderDirection switch { "asc" => OrderByType.Asc, "desc" => OrderByType.Desc, _ => OrderByType.Desc }; //查询筛选 //主键 int var id = Request.Form["id"].FirstOrDefault().ObjectToInt(0); if (id > 0) { @where = @where.And(p => p.id == id); } //用户账号 nvarchar var username = Request.Form["username"].FirstOrDefault(); if (!string.IsNullOrEmpty(username)) { @where = @where.And(p => p.username.Contains(username)); } //操作系统 nvarchar var os = Request.Form["os"].FirstOrDefault(); if (!string.IsNullOrEmpty(os)) { @where = @where.And(p => p.os.Contains(os)); } //设备名 nvarchar var device = Request.Form["device"].FirstOrDefault(); if (!string.IsNullOrEmpty(device)) { @where = @where.And(p => p.device.Contains(device)); } //浏览器类型 nvarchar var browser = Request.Form["browser"].FirstOrDefault(); if (!string.IsNullOrEmpty(browser)) { @where = @where.And(p => p.browser.Contains(browser)); } //ip地址 nvarchar var ip = Request.Form["ip"].FirstOrDefault(); if (!string.IsNullOrEmpty(ip)) { @where = @where.And(p => p.ip.Contains(ip)); } //操作类型,0登录成功,1登录失败,2退出登录,3刷新token int var operType = Request.Form["operType"].FirstOrDefault().ObjectToInt(0); if (operType > 0) { @where = @where.And(p => p.operType == operType); } //备注 nvarchar var comments = Request.Form["comments"].FirstOrDefault(); if (!string.IsNullOrEmpty(comments)) { @where = @where.And(p => p.comments.Contains(comments)); } //登录时间 datetime var createTime = Request.Form["createTime"].FirstOrDefault(); if (!string.IsNullOrEmpty(createTime)) { if (createTime.Contains("到")) { var dts = createTime.Split("到"); var dtStart = dts[0].Trim().ObjectToDate(); where = where.And(p => p.createTime > dtStart); var dtEnd = dts[1].Trim().ObjectToDate(); where = where.And(p => p.createTime < dtEnd); } else { var dt = createTime.ObjectToDate(); where = where.And(p => p.createTime > dt); } } //修改时间 datetime var updateTime = Request.Form["updateTime"].FirstOrDefault(); if (!string.IsNullOrEmpty(updateTime)) { if (updateTime.Contains("到")) { var dts = updateTime.Split("到"); var dtStart = dts[0].Trim().ObjectToDate(); where = where.And(p => p.updateTime > dtStart); var dtEnd = dts[1].Trim().ObjectToDate(); where = where.And(p => p.updateTime < dtEnd); } else { var dt = updateTime.ObjectToDate(); where = where.And(p => p.updateTime > dt); } } //获取数据 var list = await _sysLoginRecordServices.QueryPageAsync(where, orderEx, orderBy, pageCurrent, pageSize); //返回数据 jm.data = list; jm.code = 0; jm.count = list.TotalCount; jm.msg = "数据调用成功!"; return(new JsonResult(jm)); }