📄 kmjc_xg.jsp

📁 管理会计系统主要功能在主页面左侧的菜单面中
💻 JSP
字号:
<!--用户修改页面，修改ZZXXJK-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 //EN">
<%
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
%>
<%@page contentType="text/html;charset=gb2312"%>
<%@page language = "java"%>
<%@page import = "java.sql.*"%>
<%@page import = "publib.*"%>
<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;
	}

	String jgbm = "";	
	String km1bm = "";	
	String km1mc = "";
	String km2bm = "";
	String km2mc = "";
	String sqlstr = "";
	String sqlstr1 = "";
	String dqgzr = "";
	String result = "";
	String jgmc = "";
	String km1ye = "";
	String km2ye = "";
	String km2zj = "";
	String zc    = "";
	int    num_km2 = 0;	//二级科目个数
try
{
	jgbm = (String)request.getParameter("JGBM");
	km1bm = (String)request.getParameter("KM1BM");
	ResultSet rs = null;
	Pub_parameter pp = new Pub_parameter();
	dqgzr = pp.getCSZ("DQGZR");
	//得到机构名称
	sqlstr = "select JGMC from JGZD where jgbm = '"+jgbm+"' ";
	rs = DbBean.sqlQuery(sqlstr);
	rs.next();
	jgmc = rs.getString(1).trim();
	//????若无一级科目
	//查询bjzzxxjk,得到一级科目的余额,科目名称
	sqlstr = "select YE,KMMC  from KMZD as a , ZZXXJK as b where a.KMBM = b.KMBM and b.RQ = '"+dqgzr+"' and b.JGBM = '"+jgbm+"' and b.KMBM = '"+km1bm+"' and a.KMJB = '1'";
	rs = DbBean.sqlQuery(sqlstr);
	rs.next();
	km1ye = rs.getString(1);
	km1mc = rs.getString(2);
	
	//根据ZFJCB.BZ，判断查询ZZXXJK or BJZZXXJK,得到机构对应的km1bm,km2bm,及其对应余额
	sqlstr = "select sum(YE)  from ZZXXJK as a ,KMZD as b  where a.KMBM  like '"+km1bm+"%' and a.RQ = '"+dqgzr+"' and a.JGBM = '"+jgbm+"' and a.KMBM = b.KMBM and b.KMJB = '2' ";
	
	//？？？？若无二级科目
	rs = DbBean.sqlQuery(sqlstr);
	rs.next();
	km2zj = rs.getString(1);
	sqlstr = "select a.KMBM,a.YE, b.KMMC  from ZZXXJK as a ,KMZD as b  where a.KMBM  like '"+km1bm+"%' and a.RQ = '"+dqgzr+"' and a.JGBM = '"+jgbm+"' and a.KMBM = b.KMBM and b.KMJB = '2' ";

	rs = DbBean.sqlQuery(sqlstr);
	for ( ; rs.next() ; )
	{
		km2bm = rs.getString(1);
		km2ye = rs.getString(2);
		km2mc = rs.getString(3);
		result = result + "<TR><INPUT type='hidden' name='km2bm' value='"+km2bm+"'><TD align='left'>"+km2bm+"</TD><TD align='left'>"+km2mc+"</TD><TD align='left'><input type='text' size='20' maxlength='20'  name='km2ye' value='"+km2ye+"' onkeypress = 'checkdecinput3(this)'></TD></TR>";
	}
	zc = Double.toString(Double.parseDouble(km1ye) - Double.parseDouble(km2zj));


}
catch ( Throwable e)
{
	System.out.println(e.getMessage());
}
%>
<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">

function checkzc()
{
	var zj = 0.00;//km2总计
	var zc = 0.00; //轧差
	for ( i = 0 ; i <= flform.km2ye.length -1 ; i++ )
	{
		zj = zj + parseFloat(flform.km2ye[i].value) ;
	}
	flform.showkm2zj.value = zj;
	flform.showkm1ye.value = flform.km1ye.value;
	zc = parseFloat(flform.km1ye.value) - zj;
	flform.showzc.value = zc;
	if ( zc != 0 )
	{
		window.alert("一级科目与二级科目轧差不平");
		return false;
	}
	else
	{
		return true;
	}

}
function checkdecinput3(varthis)
{  
  	if(event.keyCode==46)
  	{
  		if(varthis.value.indexOf('.')==-1) event.returnValue = true;
  		else event.returnValue = false;
  	}
	else if(event.keyCode==45)
  	{
  		if(varthis.value.indexOf('-')==-1) event.returnValue = true;
  		else event.returnValue = false;
  	}
  	else
  	 {
  	 	if (event.keyCode >= 48 && event.keyCode <= 57 ) 
  	 	  {
  	 	      event.returnValue = true;  	 	  
  	 	  }
  	 	else
  	 	      event.returnValue = false;
  	}
}
function submit_xg()
{
	if ( checkzc() )
	{
		document.flform.submit();
	}
}

</SCRIPT>
</HEAD>

<BODY>

<FORM action="kmjc_tj.jsp?dqgzr=<%=dqgzr%>" method="post" name="flform" >
  <H2>科目检查</H2>
<INPUT type="button" name="newbtn" value="检查" onclick="checkzc()"> 
  <INPUT type="reset" name="delbtn" value="复位" > 
  <INPUT type="button" name="subbtn" value="提交" onclick='submit_xg()'>
  <Input type='button' name='backbt' value='返回' onclick="history.back()">
  <INPUT type="button" name="bangzhu"  value="帮助"  onClick="window.open('/help/2.5/2.5.5.2.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');"> 
<BR>
<BR>
机构：<INPUT type='text' size='9' maxlength='9' name='jgbm' value='<%=jgbm%>' readonly >&nbsp;&nbsp;<%=jgmc%>
<TABLE border="0"  width="550">
		<TR>
			<TH >一级科目当前余额</TH>
			<TH>-</TH>
			<TH >二级科目当前余额总计</TH>
			<TH>=</TH>
			<TH >轧差</TH>
		</TR>
		<TR>
			<TD width='150'><INPUT type='text' size='20' maxlength='20' name='showkm1ye' value='<%=km1ye%>' readonly ></TD>
			<TD align='center'>-</TD>
			<TD width='150'><INPUT type='text' size='20' maxlength='20' name='showkm2zj' value='<%=km2zj%>' readonly ></TD>
			<TD align='center'>=</TD>
			<TD width='150'><INPUT type='text' size='20' maxlength='20' name='showzc' value='<%=zc%>' readonly ></TD>
		</TR>
</TABLE>
<BR>
<BR>
<TABLE border="0"  width="550">
      <TR>
	    <TH>一级科目编码</TH>
        <TH>一级科目名称</TH>
        <TH>当前余额</TH>
      </TR>
	  <TR>
		<INPUT type='hidden' name='km1bm' value='<%=km1bm%>'>
		<TD align='left'><%=km1bm%></TD>
		<TD align='left'><%=km1mc%></TD>
		<TD align='left' width='150'><input type='text' size='20' maxlength='20'  name='km1ye' value='<%=km1ye%>' onkeypress = 'checkdecinput3(this)'></TD>

	  </TR>
	  <TR>
  	    <TH>二级科目编码</TH>
        <TH>二级科目名称</TH>
        <TH>当前余额</TH>
	  </TR>

<%=result%>

  </TABLE>

</FORM>
</BODY>
</HTML>
<%
System.gc();
%>
⌨️ 快捷键说明

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