menuselect.jsp

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

<%@ page contentType="text/html; charset=GBK" %>
<%!
	public String getStrTreeOut(String strType,String strSearchLike,String strParentId,String strLastType){
		String strResult = "";
		//System.out.println("SELECT ID,TITLE,(SELECT COUNT(*) FROM TAB_IGECMENU WHERE PARENTID=a.ID AND POSTYPE='" + strType + "' AND FTSTR LIKE '" + strSearchLike + "%') FROM TAB_IGECMENU a WHERE PARENTID='" + strParentId + "' AND POSTYPE='" + strType + "' AND FTSTR LIKE '" + strSearchLike + "%' ORDER BY XH");
		String strDataArray[][] = igec.site.base.business.DataUtilBusiness.getValues("SELECT ID,TITLE,(SELECT COUNT(*) FROM TAB_IGECMENU WHERE PARENTID=a.ID AND POSTYPE='" + strType + "' AND FTSTR LIKE '" + strSearchLike + "%') FROM TAB_IGECMENU a WHERE PARENTID='" + strParentId + "' AND POSTYPE='" + strType + "' AND FTSTR LIKE '" + strSearchLike + "%' 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(strType,strSearchLike,strDataArray[i][0],strCurLastType);
			}
		}
		return strResult;
	}
%>
<%
	String strMenuType = igec.util.Tool.getStr(request.getParameter("type"));
	if(igec.util.Tool.IsEmpty(strMenuType)) strMenuType = "0";
	
	String strPos = igec.util.Tool.getStr(request.getParameter("pos"));
	if(igec.util.Tool.IsEmpty(strPos)) strPos = igec.site.base.business.DataUtilBusiness.getFieldValue("POS","TAB_IGECINDTYPE","WHERE ISDEFAULT='1'");//使用默认的菜单类型
	/*
	组合对应的搜索时的
	*/
	String strSearchLike = igec.util.Tool.setSafeChar("",'_',Integer.parseInt(strPos,10),'1');		
	
	out.println(getStrTreeOut(strMenuType,strSearchLike,"0",""));
%>