/**
* 设置ProductCategory的treepath和grade属性。例如根级分类的treepath为',',grade为‘0’表示顶级分类，
* 次级分类的treepath为‘,1,’，其中这个1表示根级分类中第一个元素，grade为'1'表示一级分类，以此类推。
*
* @param paramProductCategory 某个等级的实例
* @return
*/
private void setProductCategoryOfTreepathAndGrade(ProductCategory paramProductCategory) {
if (paramProductCategory == null) return;
ProductCategory localProductCategory = paramProductCategory.getParent();
if (localProductCategory != null)
paramProductCategory.setTreePath(
localProductCategory.getTreePath() + localProductCategory.getId() + ",");
else paramProductCategory.setTreePath(",");
paramProductCategory.setGrade(Integer.valueOf(paramProductCategory.getTreePaths().size()));
}
@Override
public List<ProductCategory> findParents(ProductCategory productCategory, Integer count) {
if ((productCategory == null) || (productCategory.getParent() == null))
return Collections.emptyList();
String str =
"select productCategory from ProductCategory productCategory where productCategory.id in (:ids) order by productCategory.grade asc";
TypedQuery<ProductCategory> localTypedQuery =
this.getEntityManager()
.createQuery(str, ProductCategory.class)
.setFlushMode(FlushModeType.COMMIT)
.setParameter("ids", productCategory.getTreePaths());
if (count != null) localTypedQuery.setMaxResults(count.intValue());
return localTypedQuery.getResultList();
}