archivescountresult1.jsp

这是一个法律事务所系统源码

<%--
模块名称：律所公告
模块功能：公告显示
版    本：V1.0
著 作 人：沈文炎 谢永刚
著作日期：2001-09-29
该模块所需的文件：BulletionAmend.jsp 
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：= = = = = = = = = = = = = = = = = = = = = = = = = =
	修改日期：
	修 改 人：
	修改理由：
	修改出处：
	= = = = = = = = = = = = = = = = = = = = = = = = = =

--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="system.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />

<%
	String doSelect = "",
		fromDate = "",
		toDate = "",
		lawyer = "";
	
	String caseAttribute = "",caseType = "";
	ResultSet rs1=null,rs2=null,rs3=null,rs4=null;
	int countFLGW = 0,
		countXSSS = 0,
		countMSSS = 0,
		countJJSS = 0,
		countXZSS = 0,
		countFSSAJ = 0,
		countREFERFOREIGN = 0;
	doSelect = request.getParameter("txtDoSelect");
	if(doSelect.equals("0"))
	{
		fromDate = request.getParameter("txtFromDate1");
		toDate = request.getParameter("txtToDate1");
	}
	else if(doSelect.equals("1"))
	{
		fromDate = request.getParameter("txtFromDate2");
		toDate = request.getParameter("txtToDate2");
	}
	lawyer = request.getParameter("txtLawyer");
	
	String sql = "";
	if(doSelect.equals("0"))	//律所统计
	{
		sql = "select case_attribute,count(case_id) as record_count from t_caseinfo ";
		sql = sql + " where begin_date>='" + fromDate;
		sql = sql + "' and begin_date<='" + toDate + "'";
		sql = sql + "  group by case_attribute";
		rs1 = db.executeQuery(sql);
			
		sql = "select case_type,count(case_id) as record_count from t_caseinfo";
		sql = sql + " where begin_date>='" + fromDate;
		sql = sql + "' and begin_date<='" + toDate + "'";
		sql = sql + " group by case_type";
		rs2 = db.executeQuery(sql);
		
		sql = "select count(case_id) as record_count from t_caseinfo";
		sql = sql + " where begin_date>='" + fromDate;
		sql = sql + "' and begin_date<='" + toDate + "'";
		sql = sql + " and refer_foreign<>'0'";
		rs3 = db.executeQuery(sql);
	}
	else if(doSelect.equals("1"))	//律师统计
	{
		sql = "select case_attribute,count(case_id) as record_count from t_caseinfo ";
		sql = sql + " where begin_date>='" + fromDate;
		sql = sql + "' and begin_date<='" + toDate + "'";
		sql = sql + " and employee_id='" + lawyer + "'";
		sql = sql + "  group by case_attribute";
		rs1 = db.executeQuery(sql);
			
		sql = "select case_type,count(case_id) as record_count from t_caseinfo";
		sql = sql + " where begin_date>='" + fromDate;
		sql = sql + "' and begin_date<='" + toDate + "'";
		sql = sql + " and employee_id='" + lawyer + "'";
		sql = sql + " group by case_type";
		rs2 = db.executeQuery(sql);
		
		sql = "select count(case_id) as record_count from t_caseinfo";
		sql = sql + " where begin_date>='" + fromDate;
		sql = sql + "' and begin_date<='" + toDate + "'";
		sql = sql + " and employee_id='" + lawyer + "'";
		sql = sql + " and refer_foreign<>'0'";
		rs3 = db.executeQuery(sql);
		
		sql = "select employee_name from t_employee where employee_id='";
		sql = sql + lawyer + "'";
		rs4 = db.executeQuery(sql);
	}
	
	if(rs1==null)
		out.println("rs1 is null");
	else
	{
		for(int i=0;rs1.next();i++)
		{
			caseAttribute = rs1.getString("case_attribute");
			if(caseAttribute != null)
			{
				caseAttribute = caseAttribute.trim();
				if(caseAttribute.equals("flgw"))	//法律顾问
					countFLGW = rs1.getInt("record_count");
				else if(caseAttribute.equals("xsss"))
					countXSSS = rs1.getInt("record_count");
				else if(caseAttribute.equals("msss"))
					countMSSS = rs1.getInt("record_count");
				else if(caseAttribute.equals("jjss"))
					countJJSS = rs1.getInt("record_count");
				else if(caseAttribute.equals("xzss"))
					countXZSS = rs1.getInt("record_count");
			}	//if()
		}	//for()
	}	//else()

	if(rs2==null)	//获取非诉讼案件总数
		out.println("rs2 is null");
	else
	{
		for(int i=0;rs2.next();i++)
		{
			caseType = rs2.getString("case_type");
			if(caseType!=null)
				caseType = caseType.trim();
			if(caseType.equals("fssaj"))
			 	countFSSAJ = rs2.getInt("record_count");			 		
		}
	}
	
	if(rs3==null)
		out.println("rs3 is null");
	else
	{
		if(rs3.next())
			countREFERFOREIGN = rs3.getInt("record_count");
	}
	
	if(rs4!=null)
		if(rs4.next())	lawyer = rs4.getString("employee_name");			
	
%>



<html>
<head>
<title>办理各类法律事务数量合计（件）</title>
<%@ include file="../inc/config.jsp" %>
</head>

<body class=page>
<!--显示工具条-->
<table width="98%" align="center" cellspacing="1">
  <tr> 
    <td>&nbsp;</td>
    <td align="right"><img src="../images/back.gif" width="50" height="22" onClick="window.history.back()" style="cursor:hand" alt="返回"></td>
  </tr>
</table>
<table width="98%" background="../images/line.gif" border="0" cellspacing="0" cellpadding="0" height="12" align="center">
  <tr> 
    <td>&nbsp;</td>
  </tr>
</table>
<!--显示工具条结束-->
<table width="60%" align="center">
  <tr>
  	<td> 时间从<span class="font1"> <%=fromDate%></span>  到 <span class="font1"> <%=toDate%></span> 期间</td>
  </tr>
  <tr>
  <%
  if(doSelect.equals("0"))
  	%>
  	<td><span class="font1"> 律所 </span>办理各类法律事务数量合计（件）</td>
  <%	
  else if(doSelect.equals("1"))
  {%>
  	<td> 律师<span class="font1">  <%=lawyer%> </span> 办理各类法律事务数量合计（件）</td>
  <%
  }%>
  </tr>
  
</table>
<table border="0" cellspacing="1" cellpadding="5" class="table_bg" align="center" width="60%">
  <tr> 
    <td width="40%" class="title_bg" align="right"> 担任法律顾问：</td>
    <td align="right" class="tr_bg1" width="60%"><%=countFLGW%></td>
  </tr>
  <tr> 
    <td width="40%" class="title_bg" height="9" align="right"> 刑事诉讼案件：</td>
    <td align="right" class="tr_bg1" height="9" width="60%"><%=countXSSS%></td>
  </tr>
  <tr> 
    <td width="40%" class="title_bg" align="right"> 民事诉讼案件：</td>
    <td align="right" class="tr_bg1" width="60%"><%=countMSSS%></td>
  </tr>
  <tr> 
    <td width="40%" class="title_bg" align="right">经济诉讼案件：</td>
    <td align="right" class="tr_bg1" width="60%"><%=countJJSS%></td>
  </tr>
  <tr> 
    <td width="40%" class="title_bg" align="right">行政诉讼案件：</td>
    <td align="right" class="tr_bg1" width="60%"><%=countXZSS%></td>
  </tr>
  <tr> 
    <td width="40%" class="title_bg" align="right">非诉讼案件：</td>
    <td align="right" class="tr_bg1" width="60%"><%=countFSSAJ%></td>
  </tr>
  <tr> 
    <td width="40%" class="title_bg" align="right">涉外及港澳台案件：</td>
    <td align="right" class="tr_bg1" width="60%"><%=countREFERFOREIGN%></td>
  </tr>
</table>
<div align="center"> <br>
</div>
</body>
</html>