financialreport.jsp

JSP网络办公自动化系统开发完整的很好好的

<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.text.*"%>
<%@ page import="cn.edu.buaa.nlsde.db.*"%>

<%request.setCharacterEncoding("GB2312");
String TheMessage = "";
//下拉菜单选项
String temp = "";
//排序选项
String TheOrder = "";
String StartDate = "";
String EndDate = "";
//提交成功后的最上面
String TheTimeLimit = "";
String SqlString = "";
ResultSet RSAllFinancialRecord = null;
//判断用户是否登录
if (session.getAttribute("ID") == null) {
	response.sendRedirect("../login.jsp");
}
//连接系统数据库
//Connection conn = (new DBConnect()).getODBCConn("EIMS");
Connection conn = (new DBConnect()).getConnPoolConn("eims");
Statement stmt = conn.createStatement();
boolean ReportLabel = false;
boolean Warning = false;
//判断当前页面状态是否是报表状态
if (request.getParameter("GoBack") != null) {
	ReportLabel = false;
}
//生成报表
if (request.getParameter("Send") != null) {
	//报表的排序方式的获取判断
	if (request.getParameter("ReportOrder").equals("Name")) {
		TheOrder = "姓名";
	}
	else if (
		request.getParameter("ReportOrder").equals("ProjectName")) {
		TheOrder = "财务项目名称";
	}
	else if (
		request.getParameter("ReportOrder").equals("AccountName")) {
		TheOrder = "会计经手人";
	}
	else {
		TheOrder = "记录添加日期";
	}
	//报表是否有时间期限
	if (request.getParameter("DateLimit").equals("Yes")) {
		StartDate =
			request.getParameter("StartYear")
				+ "-"
				+ request.getParameter("StartMonth")
				+ "-"
				+ request.getParameter("StartDay");
		EndDate =
			request.getParameter("EndYear")
				+ "-"
				+ request.getParameter("EndMonth")
				+ "-"
				+ request.getParameter("EndDay");
		TheTimeLimit = "时间期限:从" + StartDate + "到" + EndDate;
		//System.out.println(TheTimeLimit);
	}
	else {
		StartDate = "1900-1-1";
		EndDate = "2100-1-1";
		TheTimeLimit = "时间期限:无";
	}
	//生成总流水帐报表
	if (request
		.getParameter("FinancialReportType")
		.equals("AllFinancialRecord")) {
		if (session.getAttribute("Position").equals("经理")
			|| (session.getAttribute("Department").equals("财务部")
				&& session.getAttribute("Position").equals("主管"))) {
			SqlString =
				"select * from FinancialRecord  where AddDate >='"
					+ StartDate
					+ "' and AddDate<='"
					+ EndDate
					+ "' order by "
					+ request.getParameter("ReportOrder");
					
	
				
			//System.out.println(SqlString);
			RSAllFinancialRecord = stmt.executeQuery(SqlString);
			TheMessage =
				TheTimeLimit + "-总流水帐报表按-" + TheOrder + "-排序如下";
			ReportLabel = true;
		}
		else {
			TheMessage = "您不是[经理/财务部主管]，无权生成总流水帐报表";
			Warning = true;
		}
	}
	//生成部门财务报表
	else if (
		request.getParameter("FinancialReportType").equals(
			"DepartmentFinancialRecord")) {
			//判断是否是经理异或部门是否正确与上 是否部门主管才行 
		if (session.getAttribute("Position").equals("经理")
			|| (session
				.getAttribute("Department")
				.equals(request.getParameter("DepartmentName"))
				&& session.getAttribute("Position").equals("主管"))) {
			SqlString =
				"select * from FinancialRecord where Department = '"
					+ request.getParameter("DepartmentName")
					+ "' and AddDate >='"
					+ StartDate
					+ "' and AddDate<='"
					+ EndDate
					+ "' order by "
					+ request.getParameter("ReportOrder");
			//System.out.println(SqlString);
			RSAllFinancialRecord = stmt.executeQuery(SqlString);
			ReportLabel = true;
			TheMessage =
				TheTimeLimit
					+ "-部门-"
					+ request.getParameter("DepartmentName")
					+ "-财务报表按-"
					+ TheOrder
					+ "-排序如下";
		}
		else {
			TheMessage = "您不是[经理/此部门主管]，无权生成部门财务报表";
			Warning = true;
		}
	}
	//生成项目财务报表
	else if (
		request.getParameter("FinancialReportType").equals(
			"FinancialProjectReport")) {
		ResultSet RSFinancailManager =
			stmt.executeQuery(
				"select FinancialManager from FinancialProject where FinancialProjectName='"
					+ request.getParameter("ProjectName")
					+ "'");
		//temp下拉选项
		while (RSFinancailManager.next()) {
			temp = RSFinancailManager.getString("FinancialManager");
		}
		//判断是否是这个主管签署
		if (session.getAttribute("Name").equals(temp)
			|| session.getAttribute("Position").equals("经理")) {
			SqlString =
				"select * from FinancialRecord where ProjectName = '"
					+ request.getParameter("ProjectName")
					+ "' and AddDate >='"
					+ StartDate
					+ "' and AddDate<='"
					+ EndDate
					+ "' order by "
					+ request.getParameter("ReportOrder");
			//System.out.println(SqlString);
			RSAllFinancialRecord = stmt.executeQuery(SqlString);
			//可否进行打印显示出来属性
			ReportLabel = true;
			TheMessage =
				TheTimeLimit
					+ "-项目-"
					+ request.getParameter("ProjectName")
					+ "-财务报表按-"
					+ TheOrder
					+ "-排序如下";
		}
		else {
			TheMessage = "您不是[经理 /此财务项目主管]，无权生成总流水帐报表";
			Warning = true;
		}
	}
	//生成个人财务报表
	else {
		if (session.getAttribute("Position").equals("经理")
			|| session.getAttribute("Name").equals(
				request.getParameter("Person"))) {
			SqlString =
				"select * from FinancialRecord where Name = '"
					+ request.getParameter("Person")
					+ "' and AddDate >='"
					+ StartDate
					+ "' and AddDate<='"
					+ EndDate
					+ "' order by "
					+ request.getParameter("ReportOrder");
			System.out.println(SqlString);
			RSAllFinancialRecord = stmt.executeQuery(SqlString);
			ReportLabel = true;
			TheMessage =
				TheTimeLimit
					+ "-用户-"
					+ request.getParameter("Person")
					+ "-个人财务报表按-"
					+ TheOrder
					+ "-排序如下";
		}
		else {
			TheMessage = "您不是[经理/此个用户]，无权生成此用户个人财务报表";
			Warning = true;
		}
	}
}
else {
	TheMessage = "请选择您要生成的报表类型";
}
%>



<HTML>
<HEAD>
<TITLE>公司财务信息管理系统</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</HEAD>

<BODY BGCOLOR="">

<FORM ACTION="financialreport.jsp" METHOD=POST><%if (ReportLabel == false) {%>
<table width=800 border=0 bgcolor=#164DA8 cellspacing=1 cellpadding=2
	align=center>
	<tr bgcolor=white>
		<td valign=middle><img src="../image/jsplogo.jpg" width=796 height=100></td>
	</tr>
</table>
<table width="800" border="0" bordercolor="#164DA8" align="center"
	cellpadding="0" cellspacing="0">
	<tr>
		<td height="13"><img src=".././image/banner2.jpg" width="800"
			height="12"></td>
	</tr>
</table>

<table width=800 border=0 bgcolor=#164DA8 cellspacing=1 cellpadding=2
	align=center>
	<tr>
		<td colspan=3>
		<div align="center"><font color=white>
		公司办公信息管理系统->财务信息管理子系统->生成财务报表[当前用户- <%=session.getAttribute("Name")%>
		] </font></div>
		</td>
	</tr>
	<tr bgcolor=white>
		<td><a href=../html/home.jsp><font color=#104DAD>返回系统主页</font></a></td>
		<td align=center><%if (Warning == false) {%> <font color="#104DAD"><%=TheMessage%></FONT>
		<%}
else {%> <font color=Red><%=TheMessage%></font> <%}%></td>
		<td align=right><a href=finance.jsp><font color=#104DAD>返回上一级网页</font></a></td>
	</tr>
</table>
<table width=800 border=0 bordercolor=#164DA8 align=center cellpadding=0
	cellspacing=0>
	<tr>
		<td height=10 colspan=4 valign=top bgcolor=#FFFFFF><img
			src=../image/banner2.jpg width=800 height=12></td>
	</tr>
</table>

<TABLE CELLPADDING=1 CELLSPACING=2 BORDER=1 bordercolor=#164DA8