public void addChildren(String parentKey, int orgId, int parentId, String oName, String pName) { try { level++; Query query = getSession().getNamedQuery("core.department.getchildren"); query.setParameter("orgId", orgId); query.setParameter("parentId", parentId); Iterator<?> it = query.list().iterator(); int id; String name; int i = 1; while (it.hasNext()) { Object obj[] = (Object[]) it.next(); id = 0; name = ""; if (obj[0] != null) id = Integer.valueOf(String.valueOf(obj[0])); if (obj[1] != null) name = String.valueOf(obj[1]); bf.append(parentKey + "." + i + "=depa," + id + "," + FunctionLib.gb23122Unicode(name) + "\r\n"); if (hasChild(orgId, id)) addChildren(parentKey + "." + i, orgId, id, oName, name); i++; } } catch (Exception ex) { ex.printStackTrace(); } }
public void buildTreeFile() { try { bf = new StringBuffer(); rootNode = new TreeNodeImpl<Department>(); Query query = getSession().getNamedQuery("core.org.records"); Iterator<?> it = query.list().iterator(); int id; String name; level = 1; int i = 1; while (it.hasNext()) { Object obj[] = (Object[]) it.next(); id = 0; name = ""; if (obj[0] != null) id = Integer.valueOf(String.valueOf(obj[0])); if (obj[6] != null) name = String.valueOf(obj[6]); bf.append(i + "=org," + id + "," + FunctionLib.gb23122Unicode(name) + "\r\n"); addChildren(String.valueOf(i), id, 0, name, name); i++; } it = null; String filename = FunctionLib.getBaseDir() + "department.properties"; File f = new File(filename); if (f.exists()) f.delete(); FileWriter fstream = new FileWriter(filename); BufferedWriter out = new BufferedWriter(fstream); out.write(bf.toString()); out.close(); String msg = getLang().getProp().get(getMySession().getL()).get("success"); getMySession().setMsg(msg, 1); } catch (Exception ex) { String msg = getLang().getProp().get(getMySession().getL()).get("faield"); getMySession().setMsg(msg, 2); ex.printStackTrace(); } }