Criteria criteria = session.createCriteria(Bill.class, "b");
DetachedCriteria categoryCriteria = DetachedCriteria.forClass(SxfWeChat.class, "s");
categoryCriteria.add(Property.forName("s.id").eqProperty("b.id"));
categoryCriteria.add(Restrictions.eq("s.status", "10"));
criteria.add(Subqueries.exists(categoryCriteria.setProjection(Projections.property("s.id"))));
List criteriaList = criteria.list();
DetachedCriteria categoryCriteria = DetachedCriteria.forClass(SxfWeChat.class, "s");
categoryCriteria.add(Property.forName("s.id").eqProperty("b.id"));
categoryCriteria.add(Restrictions.eq("s.status", "10"));
criteria.add(Subqueries.exists(categoryCriteria.setProjection(Projections.property("s.id"))));
List criteriaList = criteria.list();