/** * 查询最顶级的类别 * * @param supervisorId * @param error * @return */ public static List<NewsType> queryTopTypes(ErrorInfo error) { error.clear(); List<t_content_news_types> types = new ArrayList<t_content_news_types>(); List<NewsType> childTypes = new ArrayList<NewsType>(); try { types = t_content_news_types.find("parent_id = -1 order by _order").fetch(); } catch (Exception e) { e.printStackTrace(); error.code = -1; error.msg = "查询类别失败"; return null; } NewsType childType = null; for (t_content_news_types type : types) { childType = new NewsType(); childType._id = type.id; childType.name = type.name; childType.parentId = type.parent_id; childType.description = type.description; childType.status = type.status; childType.order = type._order; childTypes.add(childType); } error.code = 0; return childTypes; }
/** * 根据父类别id查询子类别信息(列表显示) * * @param parentId 父类别id * @param error * @return */ public static List<NewsType> queryChildTypes( long supervisorId, String parentIdStr, ErrorInfo error) { error.clear(); if (!NumberUtil.isNumericInt(parentIdStr)) { error.code = -1; error.msg = "传入类型参数有误!"; } long parentId = Long.parseLong(parentIdStr); List<t_content_news_types> types = new ArrayList<t_content_news_types>(); List<NewsType> childTypes = new ArrayList<NewsType>(); try { types = t_content_news_types.find("parent_id = ? order by _order", parentId).fetch(); } catch (Exception e) { e.printStackTrace(); error.code = -1; error.msg = "查询类别失败"; return null; } NewsType childType = null; for (t_content_news_types type : types) { childType = new NewsType(); childType._id = type.id; childType.name = type.name; childType.parentId = type.parent_id; childType.description = type.description; childType.status = type.status; childType.order = type._order; childTypes.add(childType); } error.code = 0; return childTypes; }