📄 archivescountresult3.jsp
字号:
<%--
模块名称：非诉讼法律事务数量合计
模块功能：统计结果
版 本：V1.0
著 作 人：SIMM
著作日期：2001-11-07
该模块所需的文件：
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ 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;
int countZNHT = 0,
countFLYJS = 0,
countFLZX = 0,
countFLJZ = 0,
countCYTP = 0,
countZCTJ = 0,
countZHSW = 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 + " and case_type='fssaj'";
sql = sql + " group by case_attribute";
rs1 = 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 case_type='fssaj'";
sql = sql + " and employee_id='" + lawyer + "'";
sql = sql + " group by case_attribute";
rs1 = db.executeQuery(sql);
sql = "select employee_name from t_employee where employee_id='";
sql = sql + lawyer + "'";
rs2 = db.executeQuery(sql);
}
if(rs1==null){}
else
{
for(int i=0;rs1.next();i++)
{
caseAttribute = rs1.getString("case_attribute");
if(caseAttribute != null)
{
caseAttribute = caseAttribute.trim();
if(caseAttribute.equals("znht")) //撰拟合同
countZNHT = rs1.getInt("record_count");
else if(caseAttribute.equals("flyjs"))
countFLYJS = rs1.getInt("record_count");
else if(caseAttribute.equals("flzx"))
countFLZX = rs1.getInt("record_count");
else if(caseAttribute.equals("fljz"))
countFLJZ = rs1.getInt("record_count");
else if(caseAttribute.equals("cytp"))
countCYTP = rs1.getInt("record_count");
else if(caseAttribute.equals("zctj"))
countZCTJ = rs1.getInt("record_count");
else if(caseAttribute.equals("zhsw"))
countZHSW = rs1.getInt("record_count");
} //if()
} //for()
} //else()
if(rs2!=null) if(rs2.next()) lawyer = rs2.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%"><%=countZNHT%></td>
</tr>
<tr>
<td width="40%" class="title_bg" height="9" align="right"> 出具法律意见书：</td>
<td align="right" class="tr_bg1" height="9" width="60%"><%=countFLYJS%></td>
</tr>
<tr>
<td width="40%" class="title_bg" align="right"> 法律咨询：</td>
<td align="right" class="tr_bg1" width="60%"><%=countFLZX%></td>
</tr>
<tr>
<td width="40%" class="title_bg" align="right">法律见证：</td>
<td align="right" class="tr_bg1" width="60%"><%=countFLJZ%></td>
</tr>
<tr>
<td width="40%" class="title_bg" align="right">参加谈判：</td>
<td align="right" class="tr_bg1" width="60%"><%=countCYTP%></td>
</tr>
<tr>
<td width="40%" class="title_bg" align="right">仲裁调解：</td>
<td align="right" class="tr_bg1" width="60%"><%=countZCTJ%></td>
</tr>
<tr>
<td width="40%" class="title_bg" align="right">综合事务：</td>
<td align="right" class="tr_bg1" width="60%"><%=countZHSW%></td>
</tr>
</table>
<div align="center"> <br>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -