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

📄 kmzd.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;

	java.lang.String baseKmlb="";
	java.lang.String selectedKmbm="";		

	int checknum=0;
	int i=0;//计数器
	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 strKmbm="";				//科目编码；
	java.lang.String strKmmc="";				//科目名称;
	java.lang.String strKmjb="";				//科目级别；
	//java.lang.String strSjkm="";				//上级科目(暂时不用) 2002-04-08;
	java.lang.String strCpbm="";				//产品编码；
	java.lang.String strKmlb="";				//科目类别；
	java.lang.String strKmbz="";				//科目标志(目前使用前2位);

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

	//科目类别列表框
	//A:一般存款 B：同业存款 C：正常贷款 D：逾期贷款 E：呆滞贷款 F：呆帐贷款 G：应收利息 H：催收利息 I：贴现户 J：金融企业往来收入 K：金融企业往来支出 L：利息支出 P:利息收入 M: 其它
	java.lang.String kmlbbm[]={"A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "P", "M", "N", "O", "Q", "R", "Z"};
	java.lang.String kmlbmc[]={"一般存款", "同业存款", "正常贷款", "逾期贷款", "呆滞贷款", "呆帐贷款", "应收利息", "催收利息", "贴现收入", "金融企业往来收入", "金融企业往来支出", "利息支出","利息收入","系统内往来","其他收入","其他支出","中间业务收入","中间业务支出","其它"};


	//科目级别：1:一级 2:二级 3:三级 
	java.lang.String kmjbbm[]={"1", "2", "3"};						
	java.lang.String kmjbmc[]={"一级", "二级", "三级"};

	//把科目标志中的属性从代码转换为汉字；
	//第一位：内部转移属性：0：不需要计算 1：内部转移收入 2：内部转移支出
	java.lang.String bzbmfirst[]={"0", "1", "2"};						
	java.lang.String bzmcfirst[]={"不需计算", "转移收入", "转移支出"};

	//第二位：科目性质:0：借方，1：贷方
	java.lang.String bzbmsecond[]={"0", "1"};						
	java.lang.String bzmcsecond[]={"借方", "贷方"};

	if(isFirst.equals("2"))						//从科目编码列表选择
	{
		baseKmlb=((java.lang.String)request.getParameter("kmlblist")).trim();
		selectedKmbm=((java.lang.String)(request.getParameter("kmbmlist"))).trim();
	}
	else
	{
		if(isFirst.equals("1"))					//从菜单调用;
		{
			baseKmlb="A";						//默认第一个科目类别'一般存款';	
		}
		else									//从页面中调用,等于'0'；
		{
			baseKmlb=((java.lang.String)request.getParameter("kmlblist")).trim();
		}
		sql="SELECT TOP 1 DBO.KMZD.KMBM FROM DBO.KMZD WHERE DBO.KMZD.KMJB = '1' AND KMLB LIKE '" + baseKmlb + "' ORDER BY KMBM";
		rs=DbBean.sqlQuery(sql);
		if(rs.next())
		{
			selectedKmbm=((java.lang.String)(rs.getString("KMBM"))).trim();
		}
		else
		{
			out.println("<script language='JavaScript'>");
			out.println("alert('没有属于该类别的科目');");
			out.println("window.location='kmzd.jsp?isFirst=1'");	//相当于从菜单调用
			out.println("</script>");
			return;
		}
		rs.close();		//释放资源;
		rs=null;
	}

	//下面查询出所选科目的所有下属科目信息
	sql="SELECT  DBO.KMZD.KMBM, DBO.KMZD.KMMC, DBO.KMZD.CPBM, DBO.KMZD.KMBZ, DBO.KMZD.KMLB, DBO.KMZD.KMJB FROM  DBO.KMZD WHERE DBO.KMZD.KMBM LIKE '" + selectedKmbm +"%' ORDER BY KMBM";
	rs=DbBean.sqlQuery(sql);
	while(rs.next())
	{
		checknum++;
		resulttable+="<TR>";
		delResulttable+="<TR>";
		strKmbm=((java.lang.String)(rs.getString("KMBM"))).trim();
		strKmmc=((java.lang.String)(rs.getString("KMMC"))).trim();
		strCpbm=((java.lang.String)(rs.getString("CPBM"))).trim();
		strKmbz=((java.lang.String)(rs.getString("KMBZ"))).trim();
		strKmlb=((java.lang.String)(rs.getString("KMLB"))).trim();
		strKmjb=((java.lang.String)(rs.getString("KMJB"))).trim();

		//显示列表////////////////////////////////////////////////////////////////
		resulttable+="<TD><INPUT size='8' type='text' maxlength='10' name='OKMBM' value='"+strKmbm+"' readonly></TD>";
		resulttable+="<TD><INPUT size='20' type='text' maxlength='60' name='OKMMC' value='"+strKmmc+"'></TD>";		
		resulttable+="<TD><INPUT size='8' type='text' maxlength='6' name='OCPBM' value='"+strCpbm+"'></TD>";		
		//科目标志第一位:内部价格属性；
		resulttable+="<TD><SELECT name='OKMBZFIRST'>" + DbBean.selOptionS(bzbmfirst, bzmcfirst, strKmbz.substring(0,1)) +"</SELECT></TD>";
		resulttable+="<TD><SELECT name='OKMBZSECOND'>" + DbBean.selOptionS(bzbmsecond, bzmcsecond, strKmbz.substring(1,2)) +"</SELECT></TD>";
		//科目类别
		resulttable+="<TD><SELECT name='OKMLB'>" + DbBean.selOptionS(kmlbbm, kmlbmc, strKmlb) + "</SELECT></TD>";
		//转换为科目级别名称，下拉框显示
		resulttable+="<TD><SELECT name='OKMJB'>" + DbBean.selOptionS(kmjbbm, kmjbmc, strKmjb) +"</SELECT></TD>";

		//删除情况下的显示列表////////////////////////////////////////////////////////
		delResulttable+="<TD align='right'><INPUT type='checkbox' name='DKMBMCHECK'  value='" + strKmbm + "'></TD>";
		delResulttable+="<TD><INPUT size='10' type='text' maxlength='10' name='DKMBM' value='"+strKmbm+"' readonly></TD>";
		delResulttable+="<TD><INPUT size='20' type='text' maxlength='60' name='DKMMC' value='"+strKmmc+"'></TD>";
		
		//下拉框显示产品
		//delResulttable+="<TD><SELECT name='DCPBM'>" + DbBean.selOptionE2("DBO.CPZD","CPBM","CPMC",strCpbm," ORDER BY CPBM") +"</SELECT></TD>";
		delResulttable+="<TD><INPUT size='8' type='text' maxlength='6' name='DCPBM' value='"+strCpbm+"'></TD>";
		//科目标志第一位:内部价格属性；
		delResulttable+="<TD><SELECT name='DKMBZFIRST'>" + DbBean.selOptionS(bzbmfirst, bzmcfirst, strKmbz.substring(0,1)) +"</SELECT></TD>";
		delResulttable+="<TD><SELECT name='DKMBZSECOND'>" + DbBean.selOptionS(bzbmsecond, bzmcsecond, strKmbz.substring(1,2)) +"</SELECT></TD>";
		//科目类别
		delResulttable+="<TD><SELECT name='DKMLB'>" + DbBean.selOptionS(kmlbbm, kmlbmc, strKmlb) + "</SELECT></TD>";
		//转换为科目级别名称，下拉框显示
		delResulttable+="<TD><SELECT name='DKMJB'>" + DbBean.selOptionS(kmjbbm, kmjbmc, strKmjb) +"</SELECT></TD>";

		resulttable+="</TR>";
		delResulttable+="</TR>";
	}
	if(checknum==0)
	{
		resulttable+="<TR><TD></TD><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><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="kmzd_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.NKMBM.focus();
			actionurl="kmzd_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="kmzd_save.jsp";
			czform.action=actionurl;
			break;
	}
}



function doChangeKmlb()		//科目类别变化;
{
	czform.action='kmzd.jsp?isFirst=0';
	czform.submit();
}

function doChangeKmbm()		//科目变化
{
	czform.action='kmzd.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.4.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>

 <DIV style="width:600px; height:5px; top:90px; left:20px;
  position:absolute;
  z-index:1;
  visibility:visible;"id="Lpublic">
科目类别：<SELECT name="kmlblist" onchange="doChangeKmlb()"><%=DbBean.selOptionS(kmlbbm, kmlbmc, baseKmlb)%></SELECT> 科目：<SELECT name="kmbmlist" onchange="doChangeKmbm()"><%=DbBean.selOptionE2("DBO.KMZD", "KMBM", "KMMC",selectedKmbm, " WHERE KMLB LIKE '" + baseKmlb + "' AND KMJB = '1' ORDER BY KMBM")%></SELECT></DIV>

<!-- 查询显示 -->
<DIV style="top:130px; left:20px;
  position:absolute;
  z-index:1;
  visibility:visible;" id="Lcxgx">
    <TABLE border="0"  width="550">
      <TR>
       <TH>科目编码</TH>
       <TH>科目名称</TH>
       <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:1;
  visibility:hidden;" id="Ldel">
    <TABLE border="0"  width="550">
       <TR>
       <TH>删除</TH>
       <TH>科目编码</TH>
       <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:1;
  visibility:hidden;" id="Lxz">
<TABLE border="0"  width="550">
      <TR>
       <TH>科目编码</TH>
       <TH>科目名称</TH>
       <TH>产品编码</TH>
       <TH>内部转移</TH>
       <TH>科目性质</TH>
       <TH>科目类别</TH>
       <TH>科目级别</TH>
      </TR>
      <TR>
	  <TD><INPUT size='10' type='text' maxlength='10' name='NKMBM'></TD>
      <TD><INPUT size='20' type='text' maxlength='60' name='NKMMC'></TD>
	  <TD><SELECT name='NCPBM'><%=DbBean.selOptionE2("DBO.CPZD","CPBM","CPMC","","ORDER BY CPBM")%></SELECT></TD>
	  <TD><SELECT name='NKMBZFIRST'><%=DbBean.selOptionS(bzbmfirst, bzmcfirst, "")%></SELECT></TD>
      <TD><SELECT name='NKMBZSECOND'><%=DbBean.selOptionS(bzbmsecond, bzmcsecond, "")%></SELECT></TD>
	  <TD><SELECT name='NKMLB'><%=DbBean.selOptionS(kmlbbm, kmlbmc, "")%></SELECT></TD>
      <TD><SELECT name='NKMJB'><%=DbBean.selOptionS(kmjbbm, kmjbmc, "1")%></SELECT></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 + -