typeselect.jsp

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

<%@ page contentType="text/html; charset=GBK" %>
<%!
	public String getStrTreeOut(String strType,String strParentId,String strLastType){
		String strResult = "";
		System.out.println("SELECT ID,NAME,(SELECT COUNT(*) FROM TAB_INDEXTYPE WHERE PARENTID=a.ID AND TYPE=" + strType + ") FROM TAB_INDEXTYPE a WHERE PARENTID='" + strParentId + "' AND TYPE=" + strType + " ORDER BY XH");
		String strDataArray[][] = igec.site.base.business.DataUtilBusiness.getValues("SELECT ID,NAME,(SELECT COUNT(*) FROM TAB_INDEXTYPE WHERE PARENTID=a.ID AND TYPE=" + strType + ") FROM TAB_INDEXTYPE a WHERE PARENTID='" + strParentId + "' AND TYPE=" + strType + " 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";
			}
			strResult += "document.write(\"<option value='" + strDataArray[i][0] + "' label='" + strDataArray[i][1] + "'>" + igec.util.TreeUtil.getTreeChar(strCurLastType) + strDataArray[i][1] + "</option>\");\r\n";
			if(!"0".equals(strDataArray[i][2])){//存在下级信息
				strResult += getStrTreeOut(strType,strDataArray[i][0],strCurLastType);
			}
		}
		return strResult;
	}
%>
<%
	String strIndexType = igec.util.Tool.getStr(request.getParameter("type"));
	if(igec.util.Tool.IsEmpty(strIndexType)) strIndexType = "0";
	out.println(getStrTreeOut(strIndexType,"0",""));
%>