securityutil.java

VC++

	// Meta[] sub = SecurityFactory.getMetaManager().getMetasByParent(
	// smeta);
	// if (sub != null) {
	// for (int i = 0; i < sub.length; i++) {
	// List list = null;
	// // 档案系统
	// if (systemSwift.equalsIgnoreCase("dangan"))
	// list = NavTree.getService(sub[i], systemscope,
	// username, schemaId);
	// // 1.1系统
	// if (systemSwift.equalsIgnoreCase("dir"))
	// list = NavTree.getService(sub[i], schema);
	//
	// String xml = NaviXMLTreeEngine
	// .generateNoServiceXMLTreeWithNumber(sub[i], list);
	// if (treeNumber.equalsIgnoreCase("false")) {
	// xml = NaviXMLTreeEngine
	// .generateNoServiceXMLTree(sub[i]);
	// }
	// HashMap temp = new HashMap();
	// String key = sub[i].getSchemaValueCode() == null ? "none"
	// : sub[i].getSchemaValueCode();
	// temp.put(key, xml);
	// trees.add(temp);
	// }
	//
	// }
	//
	// }
	// // ArrayList
	// // Iterator iter = ((HashMap)trees.get(0)).keySet().iterator();
	// // while(iter.hasNext()){
	// // String key = (String)iter.next();
	// // String value = (String)((HashMap)trees.get(0)).get(key);
	// // }
	// return trees;
	//
	// }

	// public static ArrayList getSchemaTreeName(String sEname,
	// HttpServletRequest request) throws Exception {
	// ArrayList trees = new ArrayList();
	// Meta smeta = SecurityFactory.getMetaManager().getMetaByEName(sEname);
	// UserManage user = new UserManage(request.getSession());
	// String systemscope = user.getSystemscope();
	// String systemSwift = request.getSession().getServletContext()
	// .getInitParameter("systemSwift");
	//
	// if (smeta == null)
	// return null;
	// else {
	// Meta[] sub = SecurityFactory.getMetaManager().getMetasByParent(
	// smeta);
	// if (sub != null) {
	// for (int i = 0; i < sub.length; i++) {
	// // List list = null;
	// // 档案系统
	// // if (systemSwift.equalsIgnoreCase("dangan"))
	// // list = NavTree.getService(sub[i], systemscope);
	// // 1.1系统
	// // if (systemSwift.equalsIgnoreCase("dir"))
	// // list = NavTree.getService(sub[i]);
	// // String xml = NaviXMLTreeEngine
	// // .generateNoServiceXMLTreeWithNumber(sub[i], list);
	// HashMap temp = new HashMap();
	// String key = sub[i].getSchemaValueCode() == null ? "none"
	// : sub[i].getSchemaValueCode();
	// key = key
	// + ";"
	// + (sub[i].getMetaContext() == null ? "none"
	// : sub[i].getMetaContext());
	// temp.put(key, "");
	// trees.add(temp);
	// }
	//
	// }
	//
	// }
	// // ArrayList
	// // Iterator iter = ((HashMap)trees.get(0)).keySet().iterator();
	// // while(iter.hasNext()){
	// // String key = (String)iter.next();
	// // String value = (String)((HashMap)trees.get(0)).get(key);
	// // }
	// return trees;
	//
	// }

	public static String getPureMetaXTree(String rootid, boolean isXml)
			throws Exception {
		String xml = "";
		Meta root = SecurityFactory.getMetaManager().getMetaByHandle(rootid);
		Meta[] subs = SecurityFactory.getMetaManager().getMetasByParent(root);
		if (subs != null) {
			MaxTree tree = (MaxTree) MaxTreeFactory.getBean("MaxTree");
			tree.setSText(root.getName());
			for (int i = 0; i < subs.length; i++) {
				MaxTreeItem item = (MaxTreeItem) MaxTreeFactory
						.getBean("MaxTreeItem");
				item.setSText(subs[i].getName());
				item.setSXmlSrc("/DirXloadTreeServer?type=pure&nodeid="
						+ subs[i].getHandle());
				tree.addTreeItem(item);
			}
			if (isXml)
				xml = tree.toXML();
			else
				xml = tree.toScript();
		}
		return xml;

	}

	public static String getRocketTree(String treeType) {
		String xml = "";
		Connection conn = null;
		try {
			conn = DBManager.getConnect();
			if (treeType.equalsIgnoreCase("org")) {
				String sql = "select * from subjectsort where type=9 and parentid=0";
				System.out.println("select * from subjectsort where type=9 and parentid=0");
				ExeSQL es = new ExeSQL(conn);
				SSRS sr = es.execSQL(sql);
				if (sr.getMaxRow() > 0) {
					String treename = sr.GetText(1, 5);
					String treecode = sr.GetText(1, 4);
					String forwardid = sr.GetText(1, 7);
					String treeid = sr.GetText(1, 1);
					MaxTree tree = (MaxTree) MaxTreeFactory.getBean("MaxTree");
					tree.setSText(treename);
					tree.setSID(treecode);
					tree.setSAction("javascript:clickNode('" + treename + "','"
							+ forwardid + "')");
					String subsql = "select * from subjectsort where type=9 and parentid="
							+ treeid + " and name like '%市%' order by orderid";
					SSRS sr2 = es.execSQL(subsql);
					for (int i = 1; i <= sr2.getMaxRow(); i++) {
						String nodename = sr2.GetText(i, 5);
						String nodecode = sr.GetText(i, 4);
						String forwardid2 = sr2.GetText(i, 7);
						String nodeid = sr2.GetText(i, 1);
//						String number = "0";
//						if (!forwardid2.equalsIgnoreCase("")) {
//							String metasql = "select count(*) from metadata where length(metaid)=8 and examstatus='2' and regtype='0' and inforesno like '%"
//									+ forwardid2 + "%'";
//							SSRS sr3 = es.execSQL(metasql);
//							if (sr3.getMaxRow() > 0)
//								number = sr3.GetText(1, 1);
//						}
						MaxTreeItem item = (MaxTreeItem) MaxTreeFactory
								.getBean("MaxTreeItem");
//						item.setSText(nodename + "(" + number + ")");
						item.setSText(nodename);
						item.setSID(nodecode);
						item.setSXmlSrc("/OrgXloadTreeServer?nodeid=" + nodeid);
						item.setSAction("javascript:clickNode('" + nodename
								+ "','" + forwardid2 + "')");
						tree.addTreeItem(item);
					}
					xml = tree.toScript();
				}
			} else {

				String sql = "select * from subjectsort where type=9 and parentid=0";
				ExeSQL es = new ExeSQL(conn);
				SSRS sr = es.execSQL(sql);
				if (sr.getMaxRow() > 0) {
					String forwardid = sr.GetText(1, 7);
					String treename = sr.GetText(1, 5);
					String treecode = sr.GetText(1, 4);
					String treeid = sr.GetText(1, 1);
					MaxTree tree = (MaxTree) MaxTreeFactory.getBean("MaxTree");
					tree.setSText(treename);
					tree.setSID(treecode);
					tree.setSAction("javascript:clickNode('" + treename + "','"
							+ forwardid + "')");
					String subsql = "select * from subjectsort where type=9 and parentid="
							+ treeid + " and name like '%市%' order by orderid";
					SSRS sr2 = es.execSQL(subsql);
					for (int i = 1; i <= sr2.getMaxRow(); i++) {
						String forwardid2 = sr2.GetText(i, 7);
						String nodename = sr2.GetText(i, 5);
						String nodecode = sr2.GetText(i, 4);
						String nodeid = sr2.GetText(i, 1);
//						String number = "0";
//						if (!forwardid2.equalsIgnoreCase("")) {
//							String metasql = "select count(*) from metadata where length(metaid)=8 and examstatus='2' and regtype='0' and inforesno like '%"
//									+ forwardid2 + "%'";
//							SSRS sr3 = es.execSQL(metasql);
//							if (sr3.getMaxRow() > 0)
//								number = sr3.GetText(1, 1);
//						}
						MaxTreeItem item = (MaxTreeItem) MaxTreeFactory
								.getBean("MaxTreeItem");
//						item.setSText(nodename + "(" + number + ")");
						item.setSText(nodename);
						item.setSID(nodecode);
						item.setSXmlSrc("/OptXloadTreeServer?orgid=" + nodeid);
						item.setSAction("javascript:clickNode('" + nodename
								+ "','" + forwardid2 + "')");
						tree.addTreeItem(item);
					}
					xml = tree.toScript();
				}
				// String sql = "select distinct relatedeal from metadata ";
				// ExeSQL es = new ExeSQL(conn);
				// SSRS sr = es.execSQL(sql);
				// if (sr.getMaxRow() > 0) {
				// MaxTree tree = (MaxTree) MaxTreeFactory.getBean("MaxTree");
				// tree.setSText("机构资源");
				// tree.setSID("0");
				//
				// for (int i = 1; i <= sr.getMaxRow(); i++) {
				// String optname = sr.GetText(i, 1);
				// if (!optname.equalsIgnoreCase("")) {
				// MaxTreeItem item = (MaxTreeItem) MaxTreeFactory
				// .getBean("MaxTreeItem");
				// item.setSText(optname);
				// item.setSXmlSrc("/OptXloadTreeServer?opt="
				// + optname);
				// item.setSAction("javascript:clickOptNode('"
				// + optname + "')");
				// tree.addTreeItem(item);
				// }
				// }
				// xml = tree.toScript();

				// }
				// return xml;
				// }
			}
			return xml;
		} catch (MMException e) {
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}

		// Meta root = SecurityFactory.getMetaManager().getMetaByHandle(rootid);
		// Meta[] subs =
		// SecurityFactory.getMetaManager().getMetasByParent(root);
		// if (subs != null) {
		// MaxTree tree = (MaxTree) MaxTreeFactory.getBean("MaxTree");
		// tree.setSText(root.getName());
		// for (int i = 0; i < subs.length; i++) {
		// MaxTreeItem item = (MaxTreeItem) MaxTreeFactory
		// .getBean("MaxTreeItem");
		// item.setSText(subs[i].getName());
		// item.setSXmlSrc("/DirXloadTreeServer?type=pure&nodeid="
		// + subs[i].getHandle());
		// tree.addTreeItem(item);
		// }
		// if (isXml)
		// xml = tree.toXML();
		// else
		// xml = tree.toScript();
		// }
		return xml;

	}

	// 动态树
	private static String makeTreeScript(String xml, String treetype,
			HttpServletRequest request) throws Exception {
		byte[] b = xml.getBytes();
		InputStream ip = new ByteArrayInputStream(b);
		SAXBuilder builder = new SAXBuilder();
		Document doc = builder.build(ip);
		Element root = doc.getRootElement();
		XPath path = XPath.newInstance("./node[@nodetype='folder']");
		List sub1 = path.selectNodes(root);
		Element usernode = (Element) sub1.get(0);

		MaxTree tree = (MaxTree) MaxTreeFactory.getBean("MaxTree");
		tree.setSID(usernode.getAttributeValue("nodeid"));
		tree.setSText(usernode.getAttributeValue("name"));
		if (treetype.equalsIgnoreCase("2")) {
			tree.setSAction("javascript:expandNote('"
					+ usernode.getAttributeValue("nodeid") + "','"
					+ usernode.getAttributeValue("datevalue") + "','"
					+ treetype + "')");
		} else {
			tree.setSAction("javascript:expandNote('"
					+ usernode.getAttributeValue("nodeid") + "','"
					+ usernode.getAttributeValue("name") + "','" + treetype
					+ "')");
		}
		List sub2 = path.selectNodes(usernode);

		for (int i = 0; i < sub2.size(); i++) {
			MaxTreeItem sub = (MaxTreeItem) MaxTreeFactory
					.getBean("MaxTreeItem");
			Element node = (Element) sub2.get(i);
			sub.setSText(node.getAttributeValue("name"));
			sub.setSID(node.getAttributeValue("nodeid"));
			if (treetype.equalsIgnoreCase("2")) {
				sub.setSAction("javascript:expandNote('"
						+ node.getAttributeValue("nodeid") + "','"
						+ node.getAttributeValue("datevalue") + "','"
						+ treetype + "')");
			} else {
				sub.setSAction("javascript:expandNote('"
						+ node.getAttributeValue("nodeid") + "','"
						+ node.getAttributeValue("name") + "','" + treetype
						+ "')");

			}
			sub.setSXmlSrc("/DirXloadTreeServer?type=mxml&nodeid="
					+ node.getAttributeValue("nodeid") + "&treetype="
					+ treetype);
			tree.addTreeItem(sub);
		}
		request.getSession().setAttribute("xmlDoc", doc);
		return tree.toScript();

	}

	// 静态树
	private static String makeXTreeScript(String xml, String treetype,
			HttpServletRequest request) throws Exception {
		byte[] b = xml.getBytes();
		InputStream ip = new ByteArrayInputStream(b);
		SAXBuilder builder = new SAXBuilder();
		Document doc = builder.build(ip);
		Element root = doc.getRootElement();
		XPath path = XPath.newInstance("./node[@nodetype='folder']");
		List sub1 = path.selectNodes(root);
		Element usernode = (Element) sub1.get(0);

		MaxTree tree = (MaxTree) MaxTreeFactory.getBean("MaxTree");
		tree.setSID(usernode.getAttributeValue("nodeid"));
		tree.setSText(usernode.getAttributeValue("name"));
		tree.setSAction("javascript:expandNote('"
				+ usernode.getAttributeValue("nodeid") + "','"
				+ usernode.getAttributeValue("name") + "','" + treetype + "')");
		List sub2 = path.selectNodes(usernode);
		for (int i = 0; i < sub2.size(); i++) {
			MaxTreeItem sub = (MaxTreeItem) MaxTreeFactory
					.getBean("MaxTreeItem");
			Element node = (Element) sub2.get(i);
			sub.setSText(node.getAttributeValue("name"));
			sub.setSID(node.getAttributeValue("nodeid"));
			if (treetype.equalsIgnoreCase("2")) {
				sub.setSAction("javascript:expandNote('"
						+ node.getAttributeValue("nodeid") + "','"
						+ node.getAttributeValue("datevalue") + "','"
						+ treetype + "')");
			} else {
				sub.setSAction("javascript:expandNote('"
						+ node.getAttributeValue("nodeid") + "','"
						+ node.getAttributeValue("name") + "','" + treetype
						+ "')");

			}
			sub.setSXmlSrc("/DirXloadTreeServer?type=mxml&nodeid="
					+ node.getAttributeValue("nodeid"));
			appendChild(node, sub, treetype);
			tree.addTreeItem(sub);

		}
		request.getSession().setAttribute("xmlDoc", doc);
		return tree.toScript();

	}

	private static void appendChild(Element tnode, MaxTreeItem sub,
			String treetype) throws Exception {

		XPath path = XPath.newInstance("./node[@nodetype='folder']");
		List list = path.selectNodes(tnode);

		for (int i = 0; i < list.size(); i++) {
			MaxTreeItem sub1 = (MaxTreeItem) MaxTreeFactory
					.getBean("MaxTreeItem");
			Element node = (Element) list.get(i);
			sub1.setSID(node.getAttributeValue("nodeid"));
			sub1.setSText(node.getAttributeValue("name"));
			if (treetype.equalsIgnoreCase("2")) {
				sub1.setSAction("javascript:expandNote('"
						+ node.getAttributeValue("nodeid") + "','"
						+ node.getAttributeValue("datevalue") + "','"
						+ treetype + "')");
			} else {
				sub1.setSAction("javascript:expandNote('"
						+ node.getAttributeValue("nodeid") + "','"
						+ node.getAttributeValue("name") + "','" + treetype
						+ "')");

			}
			sub.addTreeItem(sub1);
			appendChild(node, sub1, treetype);

		}

	}
}