+ " order by sort";
List<Map<String, Object>> listMap = this.baseDaoEntity.getJdbcTemplate().queryForList(sql);
List<TreeNode> listTreeNode = new ArrayList<TreeNode>();
for(Map map:listMap) {
String id = (String)map.get("ID");
TreeNode node = new TreeNode(id,(String)map.get("JDMC"),(String)map.get("FID"));
for(Map mapXtgn:gnidList) {
if (id.equals((String)mapXtgn.get("GNID"))) {
node.setChecked(true);
break;
}
}
listTreeNode.add(node);
}