?? 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> </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> </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>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -