📄 kmjc_xs.jsp

📁 管理会计系统主要功能在主页面左侧的菜单面中
💻 JSP
字号:
<!--科目检查，显示检查结果的列表-->
<!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 km1bm = "";
	String km1mc = "";
	String jgbm  = "";
	String jgmc  = "";
	String zc    = "";
	String bz    = "";
	String sqlstr = "";
	String dqgzr = "";
	String result = "";
	int    num_record = 0;
	ResultSet rs = null;
	Pub_parameter pp = new Pub_parameter();

	try
	{
		dqgzr = pp.getCSZ("DQGZR");
		sqlstr = "select count(*) from ZFJCB as a,KMZD as b ,JGZD as c where a.JGBM = c.JGBM and a.KMBM  = b.KMBM and a.RQ = '"+dqgzr+"' ";
		rs = DbBean.sqlQuery(sqlstr);
		rs.next();
		num_record = rs.getInt(1);
		if (num_record == 0 )
		{
			out.println("<HTML><HEAD><META http-equiv='Content-Style-Type' content='text/css'><TITLE>科目检查</TITLE><LINK rel='stylesheet' href='/resources/Master.css' type='text/css'></HEAD><BODY>");
			out.println("<script language= 'javascript'>");
			out.println("window.alert('无不平科目');");
			out.println("self.location = 'kmjc_jc.jsp';");
			out.println("</script></BODY></HTML>");
			return;

		}
		sqlstr = "select a.JGBM,c.JGMC,a.KMBM,b.KMMC,ZC,BZ from ZFJCB as a,KMZD as b ,JGZD as c where a.JGBM = c.JGBM and a.KMBM  = b.KMBM and a.RQ = '"+dqgzr+"' ";
		rs = DbBean.sqlQuery(sqlstr);
		for(;rs.next();)
		{
			jgbm = rs.getString(1);
			jgmc = rs.getString(2);
			km1bm = rs.getString(3);
			km1mc = rs.getString(4);
			zc    = rs.getString(5);
			bz    = rs.getString(6);
			result = result + "<TR onclick=' call_xg("+jgbm+","+km1bm+","+bz+")'><TD>"+jgbm+"</TD><TD>"+jgmc+"</TD><TD>"+km1bm+"</TD><TD>"+km1mc+"</TD><TD>"+zc+"</TD></TR>";

		}

	}
	catch ( Throwable e )
	{
		System.out.println("kmjc_xs:"+e.getMessage());
		out.println("<HTML><HEAD><META http-equiv='Content-Style-Type' content='text/css'><TITLE>科目检查</TITLE><LINK rel='stylesheet' href='/resources/Master.css' type='text/css'></HEAD><BODY>");
		out.println("<script language= 'javascript'>");
		out.println("window.alert('出现异常');");
		out.println("self.location = 'kmjc_jc.jsp';");
		out.println("</script></BODY></HTML>");

	}
%>

<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 call_xg(jgbm,km1bm,bz)
{
	if(bz == 1)
	{
		self.location='kmjc_xg.jsp?JGBM='+jgbm+'&KM1BM='+km1bm;
	}
	else
	{
		self.location='kmjc_xgbj.jsp?JGBM='+jgbm+'&KM1BM='+km1bm;
	}
}

</SCRIPT>
</HEAD>

<BODY>

  <H2>科目检查</H2>
  <INPUT type="button" name="bangzhu"  value="帮助"  onClick="window.open('/help/2.5/2.5.5.1.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>
<TABLE border="0"  width="550">
		<TR>
			<TH >机构编码</TH>
			<TH>机构名称</TH>
			<TH >一级科目编码</TH>
			<TH>一级科目名称</TH>
			<TH >轧差</TH>
		</TR>
<%=result%>

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

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