?? costenterinfo.jsp
字號:
<%--
模塊名稱：費用管理
模塊功能：費用登記顯示
版 本：V1.0
著 作 人：蔡靜
著作日期：2001-10-18
使用說明：
主要技術說明：
參考文獻：法律事務設計書
修改歷史：
= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出處：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
String charge_id = request.getParameter("charge_id");
String charge_sum, case_id, case_reason, part_proportion, case_object, time_limit;
String payment_method, receive_time, charge_standard, discount, discount_person;
String charge_person, currency_kind, comment,charge_type = "";
String charge_name = "", lawyer_id = ""; //承辦律師
String sql = "select a.charge_sum, a.case_id, b.case_reason, a.part_proportion,";
sql = sql + "a.case_object, a.time_limit, a.payment_method, a.receive_time,";
sql = sql + "a.charge_standard, a.discount, a.discount_person,";
sql = sql + " a.charge_person, a.currency_kind, a.comment";
sql = sql + " ,a.charge_type,a.charge_name,a.employee_id ";
sql = sql + " from t_charge a, t_caseinfo b where";
sql = sql + " a.case_id = b.case_id and charge_id = '" + charge_id + "'";
ResultSet rs = db.executeQuery(sql);
if (rs.next()) {
charge_sum = rs.getString("charge_sum");
if ((charge_sum.indexOf(".")) >= 0) {
charge_sum=charge_sum + "00";
charge_sum=charge_sum.substring(0,charge_sum.indexOf(".")+3);
}
case_id = rs.getString("case_id");
case_reason = rs.getString("case_reason");
part_proportion = rs.getString("part_proportion");
case_object = rs.getString("case_object");
time_limit = rs.getString("time_limit");
payment_method = rs.getString("payment_method");
receive_time = rs.getString("receive_time");
charge_standard = rs.getString("charge_standard");
discount = rs.getString("discount");
discount_person = rs.getString("discount_person");
charge_person = rs.getString("charge_person");
currency_kind = rs.getString("currency_kind");
comment = rs.getString("comment");
charge_type = rs.getString("charge_type");
charge_name = rs.getString("charge_name");
lawyer_id = rs.getString("employee_id");
if(charge_type.equals("ht")) charge_type = "合同費用";
else if(charge_type.equals("qt")) charge_type = "其他費用";
else charge_type = "";
%>
<html>
<head>
<title>費用登記顯示</title>
<%@ include file="../inc/config.jsp" %>
</head>
<body class="page">
<!--顯示工具條-->
<table width="98%" align="center" cellspacing="1">
<tr>
<td width="90%"><a href="CostEnter.jsp"><img src="../images/all.gif" height="22" border="0" width="88"></a>
<a href="CostEnterAdd.jsp"><img src="../images/add.gif" alt="增加內容" width="79" height="22" border="0" ></a>
<img src="../images/delete.gif" alt="刪除選中的內容" style="cursor:hand" width="79" height="22">
<a href="CostEnterSearch.jsp"><img src="../images/query.gif" alt="查詢內容" width="79" height="22" border="0"></a></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>
<!--顯示工具條結束-->
<table width="98%" align="center" border="0" cellspacing="1" cellpadding="5" class="table_bg">
<tr>
<td width="152" align="right" class="title_bg"> 費用編號： </td>
<td width="197" class="tr_bg1"><%=charge_id%></td>
<td width="150" align="right" class="title_bg"> 費用金額[元]： </td>
<td width="245" class="tr_bg1">
<%
if (charge_sum != null)
out.print(charge_sum);
%>
</td>
</tr>
<tr>
<td align="right" width="152" class="title_bg">費用名稱：</td>
<td width="197" class="tr_bg1">
<%
if (charge_name != null)
out.print(charge_name);
%></td>
<td align="right" width="150" class="title_bg">費用類型：</td>
<td width=245 class="tr_bg1">
<%
if (charge_type != null)
out.print(charge_type);
%></td>
</tr>
<tr>
<td align="right" width="152" class="title_bg">案件編號：</td>
<td width="197" class="tr_bg1"><%=case_id%></td>
<td align="right" width="150" class="title_bg">承辦律師：</td>
<%
if (lawyer_id != null) {
sql = "select employee_name from t_employee where";
sql = sql + " employee_id='" + lawyer_id + "'";
rs = db.executeQuery(sql);
if (rs.next())
lawyer_id = rs.getString("employee_name");
else
lawyer_id = "";
}
else lawyer_id = "";
%>
<td width=245 class="tr_bg1"><%=lawyer_id%></td>
</tr>
<tr>
<td align="right" width="150" class="title_bg">案由：</td>
<td class="tr_bg1" colspan="3"> <%=case_reason%></td>
</tr>
<tr>
<td align=right width=152 class="title_bg"> 收費人： </td>
<td width=197 class="tr_bg1">
<%
if (charge_person != null) {
String sql1 = "select employee_name from t_employee where";
sql1 = sql1 + " employee_id='" + charge_person + "'";
ResultSet rs1 = db.executeQuery(sql1);
if (rs1.next())
out.print(rs1.getString("employee_name"));
else
out.print("");
}
%>
</td>
<td align="right" width="150" class="title_bg"> 標的額[元]：</td>
<td width=245 class="tr_bg1">
<%
if (case_object != null)
out.print(case_object);
%>
</td>
</tr>
<tr>
<td align=right width=152 class="title_bg"> 支付期限： </td>
<td width=197 class="tr_bg1">
<%
if (time_limit != null)
out.print(time_limit.substring(0,10));
%>
</td>
<td align="right" width="150" class="title_bg"> 支付方式： </td>
<td width=245 class="tr_bg1">
<%
if (payment_method != null)
if (payment_method.equals("xj"))
out.print("現(xiàn)金");
else
out.print("轉賬");
%>
</td>
</tr>
<tr>
<td align=right width=152 class="title_bg"> 收費日期： </td>
<td width=197 class="tr_bg1">
<%
if (receive_time != null)
out.print(receive_time.substring(0,10));
%>
</td>
<td align=right width=150 class="title_bg"> 收費標準： </td>
<td width=245 class="tr_bg1" >
<%
if (charge_standard != null)
out.print(charge_standard);
%>
</td>
</tr>
<tr>
<td align=right width=152 class="title_bg"> 折扣比例： </td>
<td width=197 class="tr_bg1">
<%
if (discount != null)
out.print(discount + "%");
%>
</td>
<td align=right width=150 class="title_bg"> 折扣審批人： </td>
<td width=245 class="tr_bg1" >
<%
if (discount_person != null) {
String sql1 = "select employee_name from t_employee where";
sql1 = sql1 + " employee_id='" + discount_person + "'";
ResultSet rs1 = db.executeQuery(sql1);
if (rs1.next())
out.print(rs1.getString("employee_name"));
else
out.print("");
}
%>
</td>
</tr>
<tr>
<td align="right" width="152" class="title_bg"> 律師分配比例：</td>
<td width="197" class="tr_bg1">
<%
if (part_proportion != null)
out.print(part_proportion);
%>
</td>
<td align=right width=150 class="title_bg"> 幣種： </td>
<td width=245 class="tr_bg1" >
<%
if (currency_kind != null)
if (currency_kind.equals("rmb"))
out.print("人民幣");
else if(currency_kind.equals("dollar"))
out.print("美金");
else if(currency_kind.equals("hk"))
out.print("港幣");
%>
</td>
</tr>
<tr>
<td align=right width=152 class="title_bg"> 備注：</td>
<td class="tr_bg1" width="592" colspan="3">
<%
if (comment != null)
out.print(comment);
%>
</td>
</tr>
</table>
<br>
<div align="center"> </div>
</body>
</html>
<%}%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -