📄 archivescountresult2.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 = "",customerType = "";
ResultSet rs1=null,rs2=null;
int countGQ = 0, //国企
countMY = 0, //民营
countSZ = 0, //三资
countZF = 0, //政府
countGR = 0, //个人
countQT = 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 customer_type,count(customer_id) as record_count from t_customer where customer_id ";
sql = sql + " in (select customer_id from t_caseinfo where case_attribute='flgw') ";
sql = sql + " group by customer_type";
rs1 = db.executeQuery(sql);
}
else if(doSelect.equals("1")) //律师个人统计
{
sql = "select customer_type,count(customer_id)) as record_count from t_customer where customer_id ";
sql = sql + " in (select customer_id from t_caseinfo where case_attribute='flgw' ";
sql = sql + " and employee_id='" + lawyer + "') ";
sql = sql + " group by customer_type";
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++)
{
customerType = rs1.getString("customer_type");
if(customerType != null)
{
customerType = customerType.trim();
if(customerType.equals("gq")) //国企
countGQ = rs1.getInt("record_count");
else if(customerType.equals("zf")) //政府
countZF = rs1.getInt("record_count");
else if(customerType.equals("sz")) //三资
countSZ = rs1.getInt("record_count");
else if(customerType.equals("my")) //民营
countMY = rs1.getInt("record_count");
else if(customerType.equals("gr")) //个人
countGR = rs1.getInt("record_count");
else if(customerType.equals("qt")) // 其他
countQT = 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%"><%=countZF%></td>
</tr>
<tr>
<td width="40%" class="title_bg" height="9" align="right"> 国营企业：</td>
<td align="right" class="tr_bg1" height="9" width="60%"><%=countGQ%></td>
</tr>
<tr>
<td width="40%" class="title_bg" align="right"> 三资企业：</td>
<td align="right" class="tr_bg1" width="60%"><%=countSZ%></td>
</tr>
<tr>
<td width="40%" class="title_bg" align="right">民营企业：</td>
<td align="right" class="tr_bg1" width="60%"><%=countMY%></td>
</tr>
<tr>
<td width="40%" class="title_bg" align="right">个人：</td>
<td align="right" class="tr_bg1" width="60%"><%=countGR%></td>
</tr>
<tr>
<td width="40%" class="title_bg" align="right">其他：</td>
<td align="right" class="tr_bg1" width="60%"><%=countQT%></td>
</tr>
</table>
<div align="center"> <br>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -