?? costqueryresult1.jsp
字號(hào):
<%--
模塊名稱：費(fèi)用管理
模塊功能：律所收費(fèi)統(tǒng)計(jì)結(jié)果
版 本：V1.0
著 作 人：蔡靜
著作日期：2001-11-05
使用說(shuō)明：
主要技術(shù)說(shuō)明：
參考文獻(xiàn)：法律事務(wù)設(shè)計(jì)書
修改歷史：
= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出處：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ 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 begindate = request.getParameter("begindate1");
String enddate = request.getParameter("enddate1");
if ((begindate == null) || (begindate.equals("")))
begindate = "1900/01/01";
if ((enddate == null) || (enddate.equals("")))
enddate = "2050/01/01";
String sql = "select a.receive_time, a.charge_sum, ";
sql = sql + "currency_kind=case(a.currency_kind) when 'rmb' then '人民幣' when 'mj' then '美金' end,";
sql = sql + "c.employee_name as lawyer, d.employee_name as charge_person from ";
sql = sql + "t_charge a left outer join t_employee d on a.charge_person=d.employee_id,";
sql = sql + "t_caseinfo b, t_employee c where a.case_id = b.case_id and ";
sql = sql + "b.employee_id = c.employee_id and receive_time between '";
sql = sql + begindate + "' and '" + enddate + "'";
ResultSet rs = db.executeQuery(sql);
sql = "select sum(charge_sum) charge_sum from t_charge where receive_time between '";
sql = sql + begindate + "' and '" + enddate + "'";
ResultSet rs1 = db.executeQuery(sql);
String sum = "";
if (rs1.next())
sum = rs1.getString("charge_sum");
%>
<html>
<head>
<title>律所收費(fèi)統(tǒng)計(jì)結(jié)果</title>
<%@ include file="../inc/config.jsp" %>
</head>
<body class=page>
<!--顯示工具條-->
<table width="98%" align="center" cellspacing="1">
<tr>
<td width="90%"> </td>
<td width="10%" align="right"><img src="../images/back.gif" width="50" height="22" onClick="window.history.back()" style="cursor:hand"></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>
<!--顯示工具條結(jié)束-->
<table width="98%" align="center">
<tr>
<td><span class="font1"><%=begindate%></span>至 <span class="font1"><%=enddate%></span>
律所律師費(fèi)收入統(tǒng)計(jì)</td>
</tr>
</table>
<!--顯示內(nèi)容-->
<table cellspacing="1" cellpadding="0" height="25" align="center" border="0" class="table_bg" width="98%">
<tr class="title_bg">
<td height="25" align="center"> 收費(fèi)日期</td>
<td align="center"> 金額</td>
<td align="center">幣種</td>
<td align="center">承辦律師</td>
<td align="center"> 收費(fèi)人</td>
</tr>
<%
String receive_time, charge_sum, currency_kind, lawyer, charge_person;
while (rs.next()) {
receive_time=rs.getString("receive_time");
charge_sum=rs.getString("charge_sum");
currency_kind=rs.getString("currency_kind");
lawyer=rs.getString("lawyer");
charge_person=rs.getString("charge_person");
if (rs.getRow()!=(rs.getRow()/2*2)) {
%>
<tr class="tr_bg1">
<% }
else {
%>
<tr class="tr_bg2">
<% }
%>
<td height="25" align="center"><%=receive_time.substring(0,10)%></td>
<td align="right">
<%if ((charge_sum != null) && (!charge_sum.equals(""))) {
if ((charge_sum.indexOf(".")) >= 0) {
charge_sum=charge_sum + "00";
charge_sum=charge_sum.substring(0,charge_sum.indexOf(".")+3);
}
out.print("￥"+charge_sum);
}
%>
</td>
<td align="right"><%=currency_kind%></td>
<td align="right">
<%
if (lawyer != null)
out.print(lawyer);
%>
</td>
<td align="right">
<%
if (charge_person != null)
out.print(charge_person);
%>
</td>
</tr>
<%}%>
</table>
總計(jì)：
<%
if ((sum != null) && (!sum.equals(""))) {
if ((sum.indexOf(".")) >= 0) {
sum = sum + "00";
sum = sum.substring(0,sum.indexOf(".")+3);
}
out.print("￥" + sum);
}
else {
out.print("0");
}
%>
</body>
</html>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -