📄 kmjc_xgbj.jsp

📁 管理会计系统主要功能在主页面左侧的菜单面中
💻 JSP
字号:
<!--用户修改页面：修改总帐本级的科目BJZZXXJK-->
<!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 dqgzr = "";	//当前工作日期
	String result = "";
	String jgmc = "";
	String km1jye = "";		//一级科目借余额
	String km1dye = "";		//一级科目贷余额
	String km2jye = "";		//二级科目借余额
	String km2dye = "";		//二级科目贷余额
	String km2jzj = "";		//二级科目借余额总计
	String km2dzj = "";		//二级科目贷余额总计
	String jzc    = "";		//借方轧差
	String dzc    = "";		//贷方轧差
	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 QMJ,QMD,KMMC  from KMZD as a , BJZZXXJK 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();
	km1jye = rs.getString(1);
	km1dye = rs.getString(2);
	km1mc = rs.getString(3);

	
	//得到二级科目的借，贷余额总计
	sqlstr = "select sum(QMJ),sum(QMD)  from BJZZXXJK 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();
	km2jzj = rs.getString(1);
	km2dzj = rs.getString(2);
	//查询BJZZXXJK,得到一级科目编码对应的二级科目编码，名称，借贷余额
	sqlstr = "select a.KMBM,a.QMJ,a.QMD, b.KMMC  from BJZZXXJK 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);
		km2jye = rs.getString(2);
		km2dye = rs.getString(3);
		km2mc = rs.getString(4);
		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='km2jye' value='"+km2jye+"' onkeypress = 'checkdecinput3(this)'></TD><TD align='left'><input type='text' size='20' maxlength='20'  name='km2dye' value='"+km2dye+"' onkeypress = 'checkdecinput3(this)'></TD></TR>";
	}
	jzc = Double.toString(Double.parseDouble(km1jye) - Double.parseDouble(km2jzj));
	dzc = Double.toString(Double.parseDouble(km1dye) - Double.parseDouble(km2dzj));
}
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 jzj = 0.00;//km2借总计
	var dzj = 0.00;//km2贷总计
	var jzc = 0.00; //轧差
	var dzc = 0.00;//轧差
	for ( i = 0 ; i <= flform.km2jye.length -1 ; i++ )
	{
		jzj = jzj + parseFloat(flform.km2jye[i].value) ;
	}
	for ( i = 0 ; i <= flform.km2dye.length -1 ; i++ )
	{
		dzj = dzj + parseFloat(flform.km2dye[i].value) ;
	}

	flform.showkm2jzj.value = jzj;
	flform.showkm2dzj.value = dzj;
	flform.showkm1jye.value = flform.km1jye.value;
	flform.showkm1dye.value = flform.km1dye.value;
	jzc = parseFloat(flform.km1jye.value) - jzj;
	dzc = parseFloat(flform.km1dye.value) - dzj;
	flform.showjzc.value = jzc;
	flform.showdzc.value = dzc;
	if ( jzc != 0 || dzc != 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_tjbj.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='showkm1jye' value='<%=km1jye%>' readonly ></TD>
			<TD align='center'>-</TD>
			<TD width='150'><INPUT type='text' size='20' maxlength='20' name='showkm2jzj' value='<%=km2jzj%>' readonly ></TD>
			<TD align='center'>=</TD>
			<TD width='150'><INPUT type='text' size='20' maxlength='20' name='showjzc' value='<%=jzc%>' readonly ></TD>
		</TR>
		<TR>
			<TH >一级科目贷方余额</TH>
			<TH>-</TH>
			<TH >二级科目贷方余额总计</TH>
			<TH>=</TH>
			<TH >轧差</TH>
		</TR>
		<TR>
			<TD width='150'><INPUT type='text' size='20' maxlength='20' name='showkm1dye' value='<%=km1dye%>' readonly ></TD>
			<TD align='center'>-</TD>
			<TD width='150'><INPUT type='text' size='20' maxlength='20' name='showkm2dzj' value='<%=km2dzj%>' readonly ></TD>
			<TD align='center'>=</TD>
			<TD width='150'><INPUT type='text' size='20' maxlength='20' name='showdzc' value='<%=dzc%>' readonly ></TD>
		</TR>

</TABLE>
<BR>
<BR>
<TABLE border="0"  width="550">
      <TR>
	    <TH>一级科目编码</TH>
        <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='km1jye' value='<%=km1jye%>' onkeypress = 'checkdecinput3(this)'></TD>
		<TD align='left' width='150'><input type='text' size='20' maxlength='20'  name='km1dye' value='<%=km1dye%>' onkeypress = 'checkdecinput3(this)'></TD>

	  </TR>
	  <TR>
  	    <TH>二级科目编码</TH>
        <TH>二级科目名称</TH>
        <TH>借方余额</TH>
		<TH>贷方余额</TH>
	  </TR>

<%=result%>

  </TABLE>

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

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