departlist.jsp

华东粮油电子交易市场网站源码华东粮油电子交易市场网站源码华东粮油电子交易市场网站源码

<%@ page contentType="text/html; charset=GBK" %>
<%!
	public String getStrTreeOut(String strParentId,String strLastType){
		String strResult = "";		
		String strDataArray[][] = igec.site.base.business.DataUtilBusiness.getValues("SELECT ID,NAME,(SELECT COUNT(*) FROM TAB_IGECDEPT WHERE PID=a.ID) FROM TAB_IGECDEPT a WHERE PID='" + strParentId + "' ORDER BY XH");
		String strCurLastType = "";//最后一个位置的类型
		for(int i=0;i<strDataArray.length;i++){
			if(i==(strDataArray.length-1)){
				strCurLastType = strLastType + "1";
			}else{
				strCurLastType = strLastType + "0";
			}
			strDataArray[i][1] = igec.util.TreeUtil.getTreeChar(strCurLastType) + strDataArray[i][1];
			strResult += "document.write(\"<option value='" + strDataArray[i][0] + "'>" + strDataArray[i][1] + "</option>\");\r\n";
			if(!"0".equals(strDataArray[i][2])){//存在下级信息
				strResult += getStrTreeOut(strDataArray[i][0],strCurLastType);
			}
		}
		return strResult;
	}
%>
<%
	out.println(getStrTreeOut("0",""));
%>