/**
* 用于前台
*
* @param supervisorId
* @param parentId
* @param error
* @return
*/
public static List<NewsType> queryChildTypes(long parentId, ErrorInfo error) {
error.clear();
List<t_content_news_types> types = new ArrayList<t_content_news_types>();
List<NewsType> childTypes = new ArrayList<NewsType>();
String sql =
"select new t_content_news_types(id, name) from t_content_news_types type where "
+ "type.parent_id = ? and type.status = true order by _order";
try {
types = t_content_news_types.find(sql, 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;
childTypes.add(childType);
}
NewsType latestNewsType = new NewsType();
latestNewsType.setParentId(3L);
latestNewsType.name = "最新动态";
childTypes.add(latestNewsType);
error.code = 0;
return childTypes;
}
