CriteriaQuery

CriteriaQuery subCq = new CriteriaQuery(TSRoleUser.class);
subCq.setProjection(Property.forName("TSUser.id"));
subCq.eq("TSRole.id", roleId);
subCq.add();
cq.add(Property.forName("id").in(subCq.getDetachedCriteria()));
cq.add();
CriteriaQuery query = new CriteriaQuery(ProductPurchaseRecordEntity.class);

query.eq("userId",userId);

query.add();

query.isNull("end");

query.setPageSize(1);

query.setCurPage(1);

query.add();

List<ProductPurchaseRecordEntity> results = systemService.getListByCriteriaQuery(query, true);