📄 zrzxzd.jsp

📁 管理会计系统主要功能在主页面左侧的菜单面中
💻 JSP
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<%
/*************************************************************
*调用时需要参数isFirst=1:从菜单直接调用时为'1'，从页面中调用时为'0';
*************************************************************/
%>

<%
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
%>
<%@page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="DbBean" class="publib.OperDbBean" scope="page"></jsp:useBean>

<%
if((session.getValueNames()).length==0) 
 {
	out.println("<SCRIPT language='JavaScript'>");	
	out.println("self.location='/sysmang/loginagain.html';");
	out.println("</SCRIPT>"); 	
  	return;
 }
try
{
	java.lang.String sql="";
	java.sql.ResultSet rs=null;


	int checknum=0;
	int i=0;//计数器
	java.lang.String czydm=(( java.lang.String)session.getValue("czydm")).trim();
	java.lang.String strZrzxbm="";				//责任中心编码
	java.lang.String strZrzxmc="";
        java.lang.String strSjzrzxbm="";				//责任中心名称;
	java.lang.String strZrzxbz="";				//责任中心标志

	java.lang.String resulttable="";
	java.lang.String delResulttable="";


	//i=0;//计数器复位，以备后用
	//下面查询出所选机构以及所有直接下属机构的人员信息;
	sql="SELECT DBO.ZRZXZD.ZRZXBM, DBO.ZRZXZD.ZRZXMC, DBO.ZRZXZD.SJZRZXBM, DBO.ZRZXZD.ZRZXBZ FROM DBO.ZRZXZD ORDER BY DBO.ZRZXZD.ZRZXBM";
	rs=DbBean.sqlQuery(sql);
	while(rs.next())
	{
		checknum++;
		resulttable+="<TR>";
		delResulttable+="<TR>";
		strZrzxbm=((java.lang.String)(rs.getString("ZRZXBM"))).trim();
		strZrzxmc=((java.lang.String)(rs.getString("ZRZXMC"))).trim();
                strSjzrzxbm=((java.lang.String)(rs.getString("SJZRZXBM"))).trim();
		strZrzxbz=((java.lang.String)(rs.getString("ZRZXBZ"))).trim();

		//显示列表////////////////////////
		resulttable+="<TD align='center'><INPUT size='8' type='text' maxlength='4' name='OZRZXBM' value='"+strZrzxbm+"' readonly></TD>";
		resulttable+="<TD align='center'><INPUT size='30' type='text' maxlength='50' name='OZRZXMC' value='"+strZrzxmc+"'></TD>";
		resulttable+="<TD align='center'><INPUT size='8' type='text' maxlength='4' name='OSJZRZXBM' value='"+strSjzrzxbm+"'></TD>";
		resulttable+="<TD align='center' onclick='DispHelp()' onmouseout='CancelHelp()'><INPUT size='10' type='text' maxlength='8' name='OZRZXBZ' value='"+strZrzxbz+"'></TD>";	

		//resulttable+="<TD><SELECT name='ORYBZFIRST'>" + DbBean.selOptionS(rybzdmfirst, rybzmcfirst, strRybz.substring(0,1)) +"</SELECT></TD>";	
		//resulttable+="<TD><SELECT name='OJGBM'>" + DbBean.selOptionE("DBO.JGZD","JGBM","JGMC",strJgbm,"WHERE ((JGBM='" + selectedJgbm + "' OR SJJGBM='" + selectedJgbm + "') AND (JGBZ LIKE '0%')) ORDER BY JGBM") +"</SELECT></TD>";	

		//删除情况下的显示列表//////////////////
		delResulttable+="<TD align='center'><INPUT type='checkbox' name='DZRZXBMCHECK'  value='" + strZrzxbm + "'></TD>";
		delResulttable+="<TD align='center'><INPUT size='8' type='text' maxlength='4' name='DZRZXBM' value='"+strZrzxbm+"' readonly></TD>";
		delResulttable+="<TD align='center'><INPUT size='30' type='text' maxlength='50' name='DZRZXMC' value='"+strZrzxmc+"'></TD>";
		delResulttable+="<TD align='center'><INPUT size='8' type='text' maxlength='4' name='DSJZRZXBM' value='"+strSjzrzxbm+"'></TD>";
		delResulttable+="<TD align='center' onclick='DispHelp()' onmouseout='CancelHelp()'><INPUT size='10' type='text' maxlength='8' name='DZRZXBZ' value='"+strZrzxbz+"'></TD>";	

		resulttable+="</TR>";
		delResulttable+="</TR>";
	}
	if(checknum==0)
	{
		resulttable+="<TR><TD></TD><TD></TD><TD></TD><TD></TD></TR>";
		delResulttable+="<TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>";
	}
	rs.close();//释放资源
	rs=null;

%>

<HTML>
<HEAD>
<META http-equiv="Content-Style-Type" content="text/css">
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">
<TITLE>
责任中心字典维护
</TITLE>

<!-- 2002-04-25 控制显示信息框位置需要 -->
<STYLE type=text/css>
<!--
.box {BACKGROUND:#FBE3FD; color:#00ffff; FONT: 9pt "宋体"; POSITION: absolute;}
-->
</STYLE>

<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">

<SCRIPT language="JavaScript">
var actionurl="";
var checknum=<%=checknum%>;
function FindObj(doc, lId)
{
	for (var i=0; i < doc.layers.length; i++)
	{
		var w_str = "doc.layers[i].document." + lId;
		var obj;obj=new Array;
		obj[lId] = eval(w_str);
		if (!obj[lId]) obj[lId] = FindObj(doc.layers[i], lId);
		if (obj[lId]) return obj[lId];
	}
	return null;
}
function ShowObj(lId)
{
	var ob;ob=new Array;
	var appVer=parseInt(navigator.appVersion);
	var isNC=(document.layers && (appVer >= 4));
	var isIE=(document.all    && (appVer >= 4));
	if (isNC)
	{
		w_str = "document." + lId;ob[lId] = eval(w_str);
		if (!ob[lId]) ob[lId] = FindObj(document, lId);
		if (ob[lId]) ob[lId].visibility = "show";
	}
	if (isIE)
	{
		w_str = "document.all.item(\"" + lId + "\").style";ob[lId] = eval(w_str);
		ob[lId].visibility = "visible";
	}
}

function HideObj(lId)
{
	var ob;ob=new Array;
	var appVer=parseInt(navigator.appVersion);
	var isNC=(document.layers && (appVer >= 4));
	var isIE=(document.all    && (appVer >= 4));
	if (isNC)
	{
		w_str = "document." + lId;ob[lId] = eval(w_str);
		if (!ob[lId]) ob[lId] = FindObj(document, lId);
		if (ob[lId]) ob[lId].visibility = "hide";
	}
	if (isIE)
	{
		w_str = "document.all.item(\"" + lId + "\").style";ob[lId] = eval(w_str);
		ob[lId].visibility = "hidden";
	}
}

//显示帮助信息* 2002-04-25 **************************************************************************
function DispHelp()
{
	document.all.clock.innerHTML="第一位：标志<BR>0__叶;<BR>1__枝; <BR><BR> 第二位：级别<BR>0__最低级;<BR> 1__一级;<BR> 2__二级;";

	newX = window.event.x + document.body.scrollLeft;
	newY = window.event.y + document.body.scrollTop;

	menu = document.all.messagetable;

	menu.style.pixelLeft = newX - 50;
	menu.style.pixelTop = newY + 40;
	menu.style.display = "";
}

function CancelHelp()
{
	menu = document.all.messagetable
	if ( menu.style.display == "")
	{
		menu.style.display = "none"
	}
}
//********************************************************************************************

function btnClick(i)
{
	czform.quebtn.disabled=false;		
	czform.chabtn.disabled=false;
	czform.newbtn.disabled=false;
	czform.delbtn.disabled=false;
	czform.subbtn.disabled=true;

	switch(i)
	{
		case 1:
			czform.ACT.value='1';
			czform.quebtn.disabled=true;
			HideObj("Lxz");
			HideObj("Ldel");
			ShowObj("Lcxgx");
			break;
		case 2:
			czform.ACT.value='2';
			czform.chabtn.disabled=true;
			czform.subbtn.disabled=false;
			HideObj("Lxz");
			HideObj("Ldel");
			ShowObj("Lcxgx");
			actionurl="zrzxzd_save.jsp";
			czform.action=actionurl;
			break;
		case 3:
			czform.ACT.value='3';
			czform.newbtn.disabled=true;
			czform.subbtn.disabled=false;
			HideObj("Lcxgx");
			HideObj("Ldel");
			ShowObj("Lxz");
            document.czform.NZRZXBM.focus();
			actionurl="zrzxzd_save.jsp";
			czform.action=actionurl;
			break;
		case 4:
			czform.ACT.value='4';
			czform.delbtn.disabled=true;
			czform.subbtn.disabled=false;
			HideObj("Lxz");
			HideObj("Lcxgx");
			ShowObj("Ldel");
			actionurl="zrzxzd_save.jsp";
			czform.action=actionurl;
			break;
	}
}

/*
function openpop()
{
	window.open('search.jsp?yhzbm='+document.czform.yhzmclist.value,'PopupWindow','menubar=no,toolbar=no,location=no,directories=no,\
	status=yes,resizable=yes,scrollbars=yes,width=40,height=40,top=11200,left=11200');
}
function checkque()
{
	openpop();
}

function doChange()
{
	czform.action='cszd.jsp?isFirst=0';
	czform.submit();
}
*/

</SCRIPT>
</HEAD>

<BODY>
<FORM method="post" name="czform" >
 <DIV style="width:400px; height:5px; top:0px; left:20px;
  position:absolute;
  z-index:1;
  visibility : visible;" id="O_NoUse">
  <H2>责任中心字典维护</H2>
  <INPUT type="button" name="quebtn"  value="查询" onclick="btnClick(1)" disabled>
  <INPUT type="button" name="chabtn"  value="修改" onclick="btnClick(2)">
  <INPUT type="button" name="newbtn"  value="增加" onclick="btnClick(3)">
  <INPUT type="button" name="delbtn"  value="删除" onclick="btnClick(4)">
  <INPUT type="submit" name="subbtn"  value="提交" disabled>
  <INPUT type="button" name="bangzhu"  value="帮助"  onClick="window.open('/help/2.8/2.8.10.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');"> 
  <INPUT TYPE='hidden' NAME='ACT' VALUE='1'>
  <BR>
</DIV>

<!-- 2002-04-25 增加显示信息需要的TABLE -->
<table class=box id=messagetable style="display: none" width="120" height="150">
<tbody><tr><td width="120" height="150" valign="top"><span id="clock"></span></td></tr>
</tbody></table>

<!-- 范围选择条件过滤 
<DIV style="width:400px; height:5px; top:90px; left:20px;
  position:absolute;
  z-index : 5;
  visibility:visible;" id="Lpublic">
所属机构：
</DIV>
-->

<!-- 查询显示 -->
<DIV style="top:100px; left:20px;
  position:absolute;
  z-index : 2;
  visibility:visible;" id="Lcxgx">
    <TABLE border="0"  width="550">
      <TR>
       <TH>中心编码</TH>
       <TH>责任中心名称</TH>
       <TH>上级中心编码</TH>
       <TH>中心标志</TH>
      </TR>
	  <%=resulttable%>
  </TABLE>
</DIV>

<!-- 删除显示 -->
<DIV style="top:100px; left:20px;
  position:absolute;
  z-index : 3;
  visibility:hidden;" id="Ldel">
    <TABLE border="0"  width="550">
       <TR>
       <TH>删除</TH>
       <TH>中心编码</TH>
       <TH>责任中心名称</TH>
       <TH>上级中心编码</TH>
       <TH>中心标志</TH>
       </TR>
      <%=delResulttable%>
  </TABLE>
</DIV>

<!-- 增加显示 -->
<DIV style="top:100px; left:20px;
  position:absolute;
  z-index : 4;
  visibility:hidden;" id="Lxz">
<TABLE border="0"  width="550">
      <TR>
       <TH>中心编码</TH>
       <TH>责任中心名称</TH>
       <TH>上级中心编码</TH>
       <TH>中心标志</TH>
      </TR>

      <TR>
	  <TD align='center'><INPUT size='8' type='text' maxlength='4' name='NZRZXBM'></TD>
	  <TD align='center'><INPUT size='30' type='text' maxlength='50' name='NZRZXMC'></TD>
      <TD align='center'><INPUT size='8' type='text' maxlength='4' name='NSJZRZXBM'></TD>
	  <TD align='center' onclick='DispHelp()' onmouseout='CancelHelp()'><INPUT size='10' type='text' maxlength='8' name='NZRZXBZ'></TD>
      </TR>
</TABLE>
</DIV>
</FORM>
</BODY>
</HTML>
<%
	System.gc();
      } catch( Throwable e)
          {  
      		 DbBean.clear();
      		 if(((e.getMessage())).equals("ResultSet is closed"))
      		 {
      		 	out.println("<SCRIPT language='JavaScript'>");
	 		out.println("self.location='/blank.html';");
	 		out.println("</SCRIPT>");
      		 }
      		 else if(e.getMessage()==null)
      		 {
	 		out.println("服务已经重启，您闲置的时间太长或系统调用错误，请重新登入试一下！<br>如果再出现这种情况请与系统维护员联系！"); 
      		 }
      		 else out.println(e.getMessage());
      		 System.gc();
       		 return;
          }
%>
⌨️ 快捷键说明

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