public List <CameraTable> GetByCondition(RequestCamera camera) { List <CameraTable> list = _dbcontext.CameraTable.WhereIf(!string.IsNullOrWhiteSpace(camera.IpAddr), t => t.IpAddr.Contains(camera.IpAddr)) .WhereIf(!string.IsNullOrWhiteSpace(camera.CameraName), t => t.CameraName.Contains(camera.CameraName)) .WhereIf(camera.CameraTypeTableId.HasValue, t => t.CameraTypeTableId == camera.CameraTypeTableId).ToList(); return(list); }
public IActionResult SelectCondition([FromBody] RequestCamera camera) { try { List <CameraTable> list = _repository.GetByCondition(camera); return(Json(new { table = list, state = "0", msg = "获取数据成功" })); } catch (Exception ex) { return(Json(new { state = "-1", msg = "获取数据出现错误", error = ex.Message })); } }