public IActionResult List([FromBody] QueryArrayModel paras)
{
ResultArray <SystemConfig> result = new ResultArray <SystemConfig>();
IQueryable <SystemConfig> allList = null;
allList = _dbContext.SystemConfig.Where(m => (string.IsNullOrEmpty(paras.Code) ? true :
m.Key.Contains(paras.Code) ||
m.Name.Contains(paras.Code) ||
m.Value.Contains(paras.Code) ||
m.Memo.Contains(paras.Code)));
result.total = allList.Count();
result.success = true;
result.data = allList.Skip((paras.PageIndex - 1) * paras.PageSize).Take(paras.PageSize).ToList();
return(Json(result));
}
public IActionResult UserList([FromBody] QueryArrayModel paras)
{
var result = new ResultArray <Dictionary <string, object> >();
IQueryable <SystemUser> allList = null;
allList = _dbContext.SystemUser.Where(m => (string.IsNullOrEmpty(paras.Code) ? true : (m.Name.Contains(paras.Code) || m.Code.Contains(paras.Code))));
result.total = allList.Count();
result.success = true;
result.data = new List <Dictionary <string, object> >();
foreach (var item in allList.Skip((paras.PageIndex - 1) * paras.PageSize).Take(paras.PageSize))
{
var info = Common.ToDictionary(item);
var lastInfo = _dbContext.LoginRecord.LastOrDefault(m => m.UserId == item.Id);
if (lastInfo != null)
{
info.Add("lastTime", lastInfo.LoginTime.ToString("yyyy-MM-dd HH:mm:ss"));
info.Add("lastIp", lastInfo.Address);
info.Add("loginCount", _dbContext.LoginRecord.Count(m => m.UserId == item.Id).ToString());
}
result.data.Add(info);
}
return(Json(result));
}
