📄 ryzd.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;
 }
java.lang.String sql="";
java.sql.ResultSet rs=null;
java.sql.ResultSet rsRylb=null;
java.lang.String optionRylb="";
java.lang.String optionRylbbm="";
java.lang.String optionRylbmc="";

java.lang.String selectedJgbm="";
java.lang.String baseJgbm="";
java.lang.String isTop="";

int checknum=0;
int i=0;//计数器
try
{
	java.lang.String czydm=(( java.lang.String)session.getValue("czydm")).trim();
	java.lang.String isFirst=((java.lang.String)request.getParameter("isFirst")).trim();
	java.lang.String strRybm="";
	java.lang.String strRyxm="";				//人员姓名;
	java.lang.String strJgbm="";
	java.lang.String strJgmc="";
	java.lang.String strRyxb="";				//人员性别编码；
	java.lang.String strNbbm="";				//柜员的内部编码；
	java.lang.String strRybz="";				//人员标志；
	java.lang.String resulttable="";
	java.lang.String delResulttable="";

	//把人员性别从代码转换为汉字；
	java.lang.String ryxbbm[]={"1", "2"};
	java.lang.String ryxbmc[]={"男", "女"};	

	//查询出操作员所属的机构
	sql="SELECT  DBO.CZYZD.JGBM AS JGBM FROM  DBO.CZYZD WHERE DBO.CZYZD.CZYBM='"+czydm+"'";
	rs=DbBean.sqlQuery(sql);
	if(rs.next())
	{
		i=1;
		baseJgbm=(rs.getString("JGBM")).trim();
	}
	else
	{
		java.sql.SQLException exception = new java.sql.SQLException("请与系统维护员联系，您现在不属于任何机构或所属于机构不唯一！");
		
		throw exception;
	}
	rs.close();//释放资源
	rs=null;

	//确定选择的机构；
	if(isFirst.equals("1"))				//从菜单直接调用;
	{
		selectedJgbm=baseJgbm;
	}
	else if(isFirst.equals("0"))		//选择下属机构;
	{
		//经过修改后，刷新页面时，要用到的机构参数;
		selectedJgbm=((java.lang.String)request.getParameter("jgbmlist")).trim();
	}
	else								//isFirst=='2'：回到上级机构;
	{
		selectedJgbm=(( java.lang.String)request.getParameter("jgbmlist")).trim();
		sql="SELECT  DBO.JGZD.SJJGBM AS SJJGBM FROM  DBO.JGZD WHERE DBO.JGZD.JGBM='"+selectedJgbm+"'";        
		rs=DbBean.sqlQuery(sql);
		if(rs.next())
		{
			selectedJgbm=(rs.getString("SJJGBM")).trim();
		} 
		else     	 	
		{
			java.sql.SQLException exception = new java.sql.SQLException("当前机构已经没有上级机构了！");
			
			throw exception;
		} 
		rs.close();//释放资源
		rs=null;	 
	}
	//判断是否到了顶级;
	if(baseJgbm.equals(selectedJgbm)) 
		isTop="1";		//已经到了顶级;
	else
		isTop="0";
		
	sql="SELECT DBO.RYLBZD.RYLBBM AS RYLBBM, DBO.RYLBZD.RYLBMC AS RYLBMC FROM DBO.RYLBZD ORDER BY DBO.RYLBZD.RYLBBM";        
	rsRylb=DbBean.sqlQuery(sql);
	if(!rsRylb.next())
	{
		java.sql.SQLException exception = new java.sql.SQLException("当前人员类别字典没有内容，请与系统维护员联系！");
		throw exception;
	} 

	i=0;//计数器复位，以备后用
	sql="SELECT DBO.RYZD.RYBM, DBO.RYZD.JGBM, DBO.RYZD.RYXM, DBO.RYZD.XB AS RYXB, DBO.RYZD.NBBM, DBO.RYZD.RYBZ FROM DBO.RYZD WHERE DBO.RYZD.JGBM ='" + selectedJgbm + "' ORDER BY DBO.RYZD.RYBM";
	rs=DbBean.sqlQuery(sql);
	while(rs.next())
	{
		checknum++;
		resulttable+="<TR>";
		delResulttable+="<TR>";
		strRybm=((java.lang.String)(rs.getString("RYBM"))).trim();
		strJgbm=((java.lang.String)(rs.getString("JGBM"))).trim();
		strRyxm=((java.lang.String)(rs.getString("RYXM"))).trim();
		strRyxb=((java.lang.String)(rs.getString("RYXB"))).trim();
		strNbbm=((java.lang.String)(rs.getString("NBBM"))).trim();
		strRybz=((java.lang.String)(rs.getString("RYBZ"))).trim();
		
		//获取人员类别下拉框
  		optionRylb="";
  		do
  		{
  			optionRylbbm  = rsRylb.getString("RYLBBM").trim(); 
  			optionRylbmc  = rsRylb.getString("RYLBMC").trim();
  			if(strRybz.substring(0,1).equals(optionRylbbm)) optionRylb = optionRylb+"<option value='"+optionRylbbm+"' selected>"+optionRylbmc+"</option>";
  			else  optionRylb = optionRylb+"<option value='"+optionRylbbm+"'>"+optionRylbmc+"</option>"; 
  		}
  		while(rsRylb.next());
  		rsRylb.first();		

		//显示列表////////////////////////
		resulttable+="<TD><INPUT size='20' type='text' maxlength='20' name='ORYBM' value='"+strRybm+"' readonly></TD>";
		resulttable+="<TD><INPUT size='10' type='text' maxlength='10' name='ORYXM' value='"+strRyxm+"'></TD>";
		resulttable+="<TD><SELECT name='ORYXB'>" + DbBean.selOptionS(ryxbbm, ryxbmc, strRyxb) +"</SELECT></TD>";	
		resulttable+="<TD><SELECT name='ORYBZFIRST'>" + optionRylb +"</SELECT></TD>";
		resulttable+="<TD><INPUT size='8' type='text' maxlength='6' name='ONBBM' value='"+strNbbm+"'></TD>";
		resulttable+="<TD><INPUT size='9' type='text' maxlength='9' name='OJGBM' value='"+strJgbm+"'></TD>";
	
		//删除情况下的显示列表//////////////////
		delResulttable+="<TD align='right'><INPUT type='checkbox' name='DRYBMCHECK'  value='" + strRybm + "'></TD>";
		delResulttable+="<TD><INPUT size='20' type='text' maxlength='20' name='DRYBM' value='"+strRybm+"' readonly></TD>";
		delResulttable+="<TD><INPUT size='10' type='text' maxlength='10' name='DRYXM' value='"+strRyxm+"'></TD>";
		delResulttable+="<TD><SELECT name='DRYXB'>" + DbBean.selOptionS(ryxbbm, ryxbmc, strRyxb) +"</SELECT></TD>";			
		delResulttable+="<TD><SELECT name='DRYBZFIRST'>" + optionRylb +"</SELECT></TD>";
		delResulttable+="<TD><INPUT size='8' type='text' maxlength='6' name='DNBBM' value='"+strNbbm+"'></TD>";	

		resulttable+="</TR>";
		delResulttable+="</TR>";
	}
	if(checknum==0)
	{
		resulttable+="<TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>";
		delResulttable+="<TR><TD></TD><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>
<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";
	}
}

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="ryzd_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.NRYXM.focus();
			actionurl="ryzd_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="ryzd_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='ryzd.jsp?isFirst=0';
	czform.submit();
}

function doChange2()
{
	czform.action='ryzd.jsp?isFirst=2';
	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.5.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><BR>
</DIV>
<DIV style="width : 550px; height : 19px; top:90px; left:20px;
  position:absolute;
  z-index : 5;
  visibility:visible;" id="Lpublic">
所属机构：
<!--把baseJgbm替换为selectedJgbm 2002-04-07: -LFY- -->
<SELECT name="jgbmlist" onchange="doChange()"> <%=DbBean.selOptionE2("DBO.JGZD","JGBM","JGMC",selectedJgbm,"WHERE JGBM = '" + selectedJgbm + "' OR SJJGBM ='" + selectedJgbm + "' ORDER BY JGBM")%></SELECT>

<%
	if(isTop.equals("0"))
	{
		out.println("<IMG src='/resources/images/function/goback.gif' width='16' height='18'   border='0' onclick='doChange2()'>");
	}
%>
</DIV>

<!-- 查询显示 -->
<DIV style="top:130px; 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>
       <TH>内部编码</TH>
       <TH>所属机构</TH>
      </TR>
	  <%=resulttable%>

  </TABLE>
</DIV>

<!-- 删除显示 -->
<DIV style="top:130px; 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>
       <TH>内部编码</TH>
       </TR>
      <%=delResulttable%>

  </TABLE>
</DIV>

<!-- 增加显示 -->
<DIV style="top:130px; 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>
       <TH>内部编码</TH>
      </TR>

      <TR>
<%    
      //<TD><INPUT size="20" type="text" maxlength="20" name="NRYBM"></TD>
%>
      <TD><INPUT size="10" type="text" maxlength="10" name="NRYXM"></TD>
      <TD><SELECT name="NRYXB"><%=DbBean.selOptionS(ryxbbm, ryxbmc, "1")%></SELECT></TD>
<%
		//获取人员类别下拉框
		strRybz="00000000";
  		optionRylb="";
  		do
  		{
  			optionRylbbm  = rsRylb.getString("RYLBBM").trim(); 
  			optionRylbmc  = rsRylb.getString("RYLBMC").trim();
  			if(strRybz.substring(0,1).equals(optionRylbbm)) optionRylb = optionRylb+"<option value='"+optionRylbbm+"' selected>"+optionRylbmc+"</option>";
  			else  optionRylb = optionRylb+"<option value='"+optionRylbbm+"'>"+optionRylbmc+"</option>"; 
  		}
  		while(rsRylb.next()); 
  		rsRylb.first();		
%>
	  <TD><SELECT name='NRYBZFIRST'><%--=DbBean.selOption("DBO.RYLBZD","RYLBBM","RYLBMC", "0")--%><%=optionRylb%></SELECT></TD>
      <TD><INPUT size="8" type="text" maxlength="6" name="NNBBM"></TD>
     <!--  <TD><SELECT name="NJGBM"><%=DbBean.selOptionE("DBO.JGZD","JGBM","JGMC",selectedJgbm,"WHERE ((JGBM='" + selectedJgbm + "' OR SJJGBM='" + selectedJgbm + "') AND (JGBZ LIKE '0%')) ORDER BY JGBM")%></SELECT></TD> --> 
      </TR>
</TABLE>
</DIV>
</FORM>
<MAP name="ryzd">
    <AREA shape="default" href="/BaseDataDef/Ryzd/ryzd.jsp?isFirst=0">
</MAP>
</BODY>
</HTML>
<%
	rsRylb.close();//释放资源
	rsRylb=null;
	System.gc();
      } catch( Throwable e)
          {  
		 rsRylb.close();//释放资源
		 rsRylb=null;
      		 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 + -