⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 leftrobin.jsp

📁 管理会计系统 主要功能在主页面左侧的菜单面中
💻 JSP
📖 第 1 页 / 共 2 页
字号:
//			padding = "2px";
		}
	}
}

function overSubItem(el) {
	el.style.textDecoration = "underline";
}

function outSubItem(el) {
	el.style.textDecoration = "none";
}

function highlightSubItem(el) {
//	el.style.background = "buttonshadow";
//	el.style.color      = "white"; //"highlighttext";
	selectedItem = el;
}

function restoreSubItem(el) {
//	el.style.background = "url(/images/tileback.gif) buttonface";
	el.style.color      = "menutext";
	selectedItem = null;
}

function overscrollButton(el) {
	overTopItem(el);
	el.style.padding = "0px";
}

function outscrollButton(el) {
	outTopItem(el);
	el.style.padding = "0px";
}

function downscrollButton(el) {
	with (el.style) {
//		borderRight   = "1px solid buttonhighlight";
//		borderLeft  = "1px solid buttonshadow";
//		borderBottom    = "1px solid buttonhighlight";
//		borderTop = "1px solid buttonshadow";
	}
}

function upscrollButton(el) {
	overTopItem(el);
	el.style.padding = "0px";
}

// ...颜色修改到此

function getReal(el, type, value) {
	var temp = el;
	while ((temp != null) && (temp.tagName != "BODY")) {
		if (eval("temp." + type) == value) {
			el = temp;
			return el;
		}
		temp = temp.parentElement;
	}
	return el;
}

// Fix the scrollbars
// Needed because the object is called through windwow.setTimeout

var globalScrollContainer;
var overflowTimeout = 1;

function fixScroll(el) {
	globalScrollContainer = el;
	window.setTimeout('changeOverflow(globalScrollContainer)', overflowTimeout);
}

function changeOverflow(el) {
	if (el.offsetHeight > el.parentElement.clientHeight)
		window.setTimeout('globalScrollContainer.parentElement.style.overflow = "auto";', overflowTimeout);
	else
		window.setTimeout('globalScrollContainer.parentElement.style.overflow = "hidden";', overflowTimeout);
}


 function Exit() {
     if (confirm("确实退出本系统吗?")) {
       document.PAGE1.target="_top";
       document.PAGE1.TXCODE.value="100201";
       document.PAGE1.submit();
     }  
  }

</SCRIPT>
<%
  int i=0;//计数器
  java.lang.String czydm="";
  java.lang.String sql="";
  java.lang.String yhzqx="";
  java.sql.ResultSet rs=null;
  //支持十几级以内的动态菜单
  java.sql.ResultSet result[]=new java.sql.ResultSet[3];
  for(i=0;i<3;i++) result[i]=null;  
  i=0;//计数器复位,以备后用
  java.lang.String[] menu={"","",""};
  java.lang.String[] tmp_menu={"","",""};
  java.lang.String[] subbegin={"","",""}; 
  java.lang.String[] subend={"","",""}; 
  java.lang.String[] cdxbm={"","",""};
  java.lang.String[] cdxmc={"","",""};
  java.lang.String[] sjdm ={"","",""};
  int zxgs=0;
  java.lang.String[] gnxdz={"","",""};
  java.lang.String czyxm="";

try
{
        czydm=(( java.lang.String)session.getValue("czydm")).trim();
	//czydm="13000001";
        //查询出操作员的岗位代码以构造生成菜单的sql语句
        sql="SELECT  DBO.CZYZD.YHZBM AS YHZBM,DBO.CZYZD.CZYXM AS CZYXM  FROM  DBO.CZYZD WHERE DBO.CZYZD.CZYBM='"+czydm+"'";        
        rs=DbBean.sqlQuery(sql);
        while(rs.next())
        {
            if(i==0) yhzqx=" (DBO.YHZQXB.YHZBM ='"+rs.getString("YHZBM")+"'";
            else     yhzqx+=" OR DBO.YHZQXB.YHZBM='"+rs.getString("YHZBM")+"'";
            i++;
            czyxm=rs.getString("CZYXM");
        }
        yhzqx+=")";
        i=0;//计数器复位,以备后用
        rs.close();//释放资源
        rs=null;
%>
<TABLE cellSpacing=0 cellPadding=0 width=120 border=0>
  <TBODY>
  <TR>
    <TD width=21><IMG height="13" src="/resources/images/left/line_left.gif" width="21"></TD>
    <TD align=middle><FONT class=v9><%=czyxm%></FONT></TD>
    <TD width=20><IMG height="13" src="/resources/images/left/line_right.gif" width="20"></TD></TR></TBODY></TABLE>
<IMG src="/resources/images/left/main_select.gif" width="133" height="29">
<DIV style="MARGIN: 1px; WIDTH: 180px">
<DIV style="WIDTH: 180px">
<DIV class="favMenu" id="aMenu" style="color : white;">
<%

        if(yhzqx.length()<5) 
        {
             java.sql.SQLException exception = new java.sql.SQLException("请与系统维护员联系,目前您在本系统中没有任何权限!");
	     exception.fillInStackTrace();
	     throw exception;
        }

        //下面动态生成菜单
        i=0;
        sql="SELECT  DBO.CDXZD.CDXBM AS CDXBM,DBO.CDXZD.CDXMC AS CDXMC,DBO.CDXZD.ZXGS AS ZXGS,DBO.CDXZD.GNXDZ AS GNXDZ  FROM  DBO.CDXZD WHERE DBO.CDXZD.SJDM='000' ORDER BY CDXBM";
        result[0]=DbBean.sqlQuery(sql);
        while(result[0].next())
        {
         	 cdxbm[0]=((java.lang.String)(result[0].getString("CDXBM"))).trim(); 
          	 cdxmc[0]=((java.lang.String)(result[0].getString("CDXMC"))).trim();   
         	 zxgs=result[0].getInt("ZXGS");
         	 if(zxgs==0)  
          	 {       //如果是终节点,根据用户组权限表中的菜单项代码,检查是否有此权限;
            	         gnxdz[0]=((java.lang.String)(result[0].getString("GNXDZ"))).trim(); 
                 	 sql="SELECT  COUNT(*) AS NUM FROM  DBO.YHZQXB WHERE ((DBO.YHZQXB.CDXBM='"+cdxbm[0]+"') AND ("+yhzqx+"))";
                 	 rs=DbBean.sqlQuery(sql);
                	 rs.next();
                 	 if(rs.getInt("NUM")>0)
                    	 {  
                      	  	tmp_menu[0]="<DIV class='topItem'><IMG class='icon' height='17' src='/resources/images/left/home.gif'  width='16'><A href='"+gnxdz[0]+"' target='rightFrame'>"+cdxmc[0]+"</A></DIV>";
                     	 }
                  	 rs.close();//释放资源
             	  	 rs=null;   
	         }
         	 else
	         {//文件夹1        	         
			  subbegin[0]="<DIV class='topFolder'  id='a"+cdxbm[0]+"'><IMG   class='icon' height='17' src='/resources/images/left/folderClose.gif' width='16'>"+cdxmc[0]+"</DIV><DIV class='sub'  id='a"+cdxbm[0]+"Sub'>";
                	  subend[0]="</DIV>";                     
	                  i=1;
	                  sql="SELECT  DBO.CDXZD.CDXBM AS CDXBM,DBO.CDXZD.CDXMC AS CDXMC,DBO.CDXZD.ZXGS AS ZXGS,DBO.CDXZD.GNXDZ AS GNXDZ  FROM  DBO.CDXZD WHERE DBO.CDXZD.SJDM='"+cdxbm[0]+"' ORDER BY CDXBM";
	                  result[1]=DbBean.sqlQuery(sql);
	                  while(result[1].next())
        	          { 
                	        cdxbm[1]=((java.lang.String)(result[1].getString("CDXBM"))).trim();
                        	cdxmc[1]=((java.lang.String)(result[1].getString("CDXMC"))).trim();
	                        zxgs=result[1].getInt("ZXGS");
	                        if(zxgs==0)  
        	                {    //各个节点之间可能不同的地方class='***Item' or '***Folder';src='';href=; 
                	               //如果是终节点,根据操作员的岗位和该功能项的代码从岗位功能表中检查是否有此权限
                        	       gnxdz[1]=((java.lang.String)(result[1].getString("GNXDZ"))).trim();
                               	       sql="SELECT  COUNT(*) AS NUM FROM  DBO.YHZQXB WHERE ((DBO.YHZQXB.CDXBM='"+cdxbm[1]+"') AND ("+yhzqx+"))";
	                               rs=DbBean.sqlQuery(sql);
        	                       rs.next();
                	               if(rs.getInt("NUM")>0)
                        	       {  
                                	     tmp_menu[1]="<DIV class='subItem'><IMG class='icon' height='17' src='/resources/images/left/folder_line.gif'  width='16'><A href='"+gnxdz[1]+"' target='rightFrame'>"+cdxmc[1]+"</A></DIV>";
	                                }
        	                        rs.close();//释放资源
                	                rs=null;
                        	 }
	                         else
        	                 {//文件夹2
                	                 subbegin[1]="<DIV class='subFolder' id='a"+cdxbm[1]+"'><IMG class='icon' height='17' src='/resources/images/left/folderClose.gif' width='16'>"+cdxmc[1]+"</DIV><DIV class='sub'  id='a"+cdxbm[1]+"Sub'>";
                        	         subend[1]="</DIV>";  
	                                 i=2;
        	                         sql="SELECT  DBO.CDXZD.CDXBM AS CDXBM,DBO.CDXZD.CDXMC AS CDXMC,DBO.CDXZD.ZXGS AS ZXGS,DBO.CDXZD.GNXDZ AS GNXDZ  FROM  DBO.CDXZD WHERE DBO.CDXZD.SJDM='"+cdxbm[1]+"' ORDER BY CDXBM";
                	                 result[2]=DbBean.sqlQuery(sql);
                        	         while(result[2].next())
                                	 { //现在金支持到这一级菜单
	                                       //如果是终节点,根据操作员的岗位和该功能项的代码从岗位功能表中检查是否有此权限
	                                       cdxbm[2]=((java.lang.String)(result[2].getString("CDXBM"))).trim();
        	                               cdxmc[2]=((java.lang.String)(result[2].getString("CDXMC"))).trim();
                	                       zxgs=result[2].getInt("ZXGS");
	                                       sql="SELECT  COUNT(*) AS NUM FROM  DBO.YHZQXB WHERE ((DBO.YHZQXB.CDXBM='"+cdxbm[2]+"') AND ("+yhzqx+"))";
        	                               rs=DbBean.sqlQuery(sql);
                	                       rs.next();
                        	               if(rs.getInt("NUM")>0)
                                	       { 
                                        	     gnxdz[2]=((java.lang.String)(result[2].getString("GNXDZ"))).trim(); 
	                                             menu[2]+="<DIV class='subItem'><IMG class='icon' height='17' src='/resources/images/left/folder_line.gif'  width='16'><A href='"+gnxdz[2]+"' target='rightFrame'>"+cdxmc[2]+"</A></DIV>";
        	                                }
                	                        rs.close();//释放资源
                        	                rs=null;
                                	 }
	                                 result[2].close();//释放资源
        	                         result[2]=null;
                	                 if(menu[2].equals("")) tmp_menu[1]="";
                        	         else tmp_menu[1]=tmp_menu[1]+subbegin[1]+menu[2]+subend[1];
                                	 menu[2]="";//交接以后迅速恢复默认值
	                                 subbegin[1]="";//交接以后迅速恢复默认值
        	                         subend[1]="";//交接以后迅速恢复默认值                                 
                	         }
                        	 menu[1]=menu[1]+tmp_menu[1];
	                         tmp_menu[1]="";
        	          }
	                  result[1].close();//释放资源
        	          result[1]=null;
                	  if(menu[1].equals("")) 
				tmp_menu[0]="";
		          else
				tmp_menu[0]=tmp_menu[0]+subbegin[0]+menu[1]+subend[0];
	                  menu[1]="";//交接以后迅速恢复默认值
	                  subbegin[0]="";//交接以后迅速恢复默认值
	                  subend[0]="";//交接以后迅速恢复默认值                                                
        	     }
	             menu[0]=menu[0]+tmp_menu[0];
	             tmp_menu[0]="";               
               }
	       result[0].close();//释放资源
	       result[0]=null;
	       

               //menu[0]+="<DIV class='topItem'><IMG class='icon' height='25' src='/resources/images/left/exit.gif'   width=133 border=0><A href='javascript:Exit();' target='rightFrame'></A></DIV>";	       
               //menu[0]+="<DIV class='topItem'><A href='javascript:Exit();' target='rightFrame'><IMG class='icon' height='25' src='/resources/images/left/exit.gif'   width=133 border=0></A></DIV>";	       
               //menu[0]+="<DIV class='topItem'><IMG class='icon' height='25' src='/resources/images/left/exit.gif'   width=133 border=0 onclick='javascript:Exit()' target='parent'></DIV>";	
              // menu[0]+="<DIV class='topItem'><IMG class='icon' height='25' src='/resources/images/left/exit.gif'   width=133 border=0 onclick='window.close()'></DIV>";	   
              menu[0]+="<DIV class='topItem'><A href='leave.jsp' target='_top'><IMG class='icon' height='25' src='/resources/images/left/exit.gif'   width=133 border=0></A></DIV>";	                  
	       out.println(menu[0]);   
      }catch( Throwable e){  
            out.println("<p>error when operating database!</p>");
            out.println(e.getMessage());
            return;
     }
%></DIV>
</DIV>
</DIV>
</FORM>
</BODY>
</HTML>


⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -