?? baddebtsenterinfo.jsp
字號:
<%--
模塊名稱：費用管理
模塊功能：壞賬登記顯示
版 本：V1.0
著 作 人：蔡靜
著作日期：2001-10-23
使用說明：
主要技術說明：
參考文獻：法律事務設計書
修改歷史：
= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出處：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
String bad_debt_id = request.getParameter("bad_debt_id");
String debt_count, customer_name, lawyer, case_id, begin_date;
String case_reason, bad_debt_reason, enter_people, enter_date;
String sql = "select a.debt_count, b.customer_name, c.employee_name lawyer, ";
sql = sql + "a.case_id, a.begin_date, a.case_reason, a.bad_debt_reason, ";
sql = sql + "d.employee_name enter_people, a.enter_date from t_baddebt a,";
sql = sql + "t_customer b, t_employee c, t_employee d where a.customer_id = b.customer_id";
sql = sql + " and a.lawyer = c.employee_id and a.enter_people = d.employee_id";
sql = sql + " and bad_debt_id = '" + bad_debt_id + "'";
ResultSet rs = db.executeQuery(sql);
if (rs.next()) {
debt_count = rs.getString("debt_count");
customer_name = rs.getString("customer_name");
lawyer = rs.getString("lawyer");
case_id = rs.getString("case_id");
begin_date = rs.getString("begin_date");
case_reason = rs.getString("case_reason");
bad_debt_reason = rs.getString("bad_debt_reason");
enter_people = rs.getString("enter_people");
enter_date = rs.getString("enter_date");
%>
<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="BadDebtsEnter.jsp"><img src="../images/all.gif" height="22" border="0" width="88"></a><a href="BadDebtsEnterAdd.jsp"><img src="../images/add.gif" alt="增加內容" width="79" height="22" border="0" ></a><img src="../images/delete.gif" alt="刪除選中的內容" onClick="return Del();" style="cursor:hand" width="79" height="22"><a href="BadDebtsEnterSearch.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 height="24" width="19%" align="right" class="title_bg"> 壞帳編號：</td>
<td height="24" width="32%" class="tr_bg1"><%=bad_debt_id%></td>
<td height="24" width="17%" align="right" class="title_bg"> 壞帳金額：</td>
<td height="24" width="32%" class="tr_bg1">
<%
if (debt_count != null)
out.print("￥" + debt_count);
%>
</td>
</tr>
<tr>
<td align="right" height="28" width="19%" class="title_bg"> 客戶名稱：</td>
<td height="28" width="32%" class="tr_bg1">
<%
if (customer_name != null)
out.print(customer_name);
%>
</td>
<td align="right" height="28" width="17%" class="title_bg"> 承辦律師：</td>
<td height=28 width=32% class="tr_bg1">
<%
if (lawyer != null)
out.print(lawyer);
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 案件編號：</td>
<td height=28 width=32% class="tr_bg1">
<%
if (case_id != null)
out.print(case_id);
%>
</td>
<td align="right" height="28" width="17%" class="title_bg"> 收案時間：</td>
<td height=28 width=32% class="tr_bg1">
<%
if ((begin_date != null) && (!begin_date.equals("")))
out.print(begin_date.substring(0,10));
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 案由：</td>
<td height=28 colspan="3" class="tr_bg1">
<%
if (case_reason != null)
out.print(case_reason);
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg">壞帳原由：</td>
<td height=28 colspan="3" class="tr_bg1">
<%
if (bad_debt_reason != null)
out.print(bad_debt_reason);
%>
</td>
</tr>
<tr>
<td align=right height=28 width=19% class="title_bg"> 登記人：</td>
<td height=28 width=32% class="tr_bg1">
<%
if (enter_people != null)
out.print(enter_people);
%>
</td>
<td align=right height=28 width=17% class="title_bg"> 登記日期：</td>
<td height=28 width=32% class="tr_bg1" >
<%
if ((enter_date != null) && (!enter_date.equals("")))
out.print(enter_date.substring(0,10));
%>
</td>
</tr>
</table>
<br>
</body>
</html>
<%}%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -