📄 advisorinfo.jsp
字号:
<%--
模块名称：法律顾问信息显示
模块功能：显示选择的记录内容
版 本：V1.0
著 作 人：谢永刚(ui); SIMM(java)
著作日期：2001-10-16
该模块所需的文件：
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：2001-10-16
修 改 人：SIMM
修改理由：jsp
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page language="java" import="java.util.Date,java.util.Locale,java.text.DateFormat"%>
<%@ page import="java.io.*,java.sql.*" contentType= "text/html; charset=gb2312" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%@ page import="system.*" %>
<%
Security auth = new Security();
String scu_employee_id = (String)session.getAttribute("employee_id");
if(scu_employee_id == null || scu_employee_id.equals(""))
{
response.sendRedirect(response.encodeRedirectURL("../Error/nonlogin.htm"));
}
String modelid = "Law021"; // 案件管理/顾问管理内容显示
int authflag = auth.popedom(scu_employee_id, modelid);
if(authflag == 0 || authflag == 2 || authflag == -1)
{%>
<jsp:forward page="../inc/noauth.jsp" >
</jsp:forward>
<%}%>
<%
//---------------------------------------
//BEGIN----法律顾问案件信息处理部分
//-----------------------------------------
String caseID = "", //案件编码
caseReason = "", //案由
beginDate = "", //顾问开始时间
endDate = "", //顾问结束时间
opinion = "", //律师对客户评价
lawyerName = "", //律师
customer = "", //客户名称
content = "", //客户主要业务范围
customerID = "";
caseID = request.getParameter("caseID");
String sql = "select CASE_ID,CASE_REASON,BEGIN_DATE,END_DATE," +
" OPINION_TO_CUSTOMER,EMPLOYEE_NAME,MAIN_CONTENT,CUSTOMER_NAME,CUSTOMER_ID " +
" from V_NONSUEINFO where CASE_ID = '" + caseID + "'"; //查询记录
ResultSet rs = db.executeQuery(sql);
if (!rs.next())
{
return;
}
else
{
caseID = rs.getString("case_id");
caseReason = rs.getString("case_reason");
beginDate = rs.getString("begin_date");
if(beginDate == null) beginDate = ""; //判断空值，不显示为NULL
else beginDate = beginDate.substring(0,10); //时间格式转换
endDate = rs.getString("end_date");
if(endDate == null) endDate = "";
else endDate = endDate.substring(0,10); //时间格式转换
opinion = rs.getString("opinion_to_customer");
if(opinion == null) opinion = "";
lawyerName = rs.getString("employee_name");
if(lawyerName == null) lawyerName = "";
content = rs.getString("main_content");
if(content == null) content = "";
customer = rs.getString("customer_name");
if(customer == null) customer = "";
customerID = rs.getString("customer_id");
if(customerID == null) customerID = "";
}
/**/
//---------------------------------------
//END---法律顾问案件信息处理部分
//-----------------------------------------
//---------------------------------------
//BEGIN---事务信息处理部分
String sql2 = "select item_id,item_name,begin_time,spend_time,item_result " +
" from t_caseafair where case_id='" + caseID + "' order by item_id";
ResultSet rs1 = db.executeQuery(sql2);
//END---法律顾问案件信息处理部分
//-----------------------------------------
//-----------------------------------------
//BEGIN---费用信息部分--------------------
String charge_id = "",
charge_sum = "",
case_id = "",
case_reason = "",
part_proportion = "",
case_object = "",
time_limit = "";
String payment_method = "",
receive_time = "",
charge_standard = "",
discount = "",
discount_person = "",
charge_person = "",
currency_kind = "",
comment = "";
sql = "select a.charge_id, a.charge_sum, a.case_id, 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 + " from t_charge a where";
sql = sql + " a.case_id = '" + caseID + "'";
sql = sql + " and a.charge_type = 'ht'";
rs = db.executeQuery(sql);
if (rs.next()) {
charge_id = rs.getString("charge_id");
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);
}
part_proportion = rs.getString("part_proportion");
if(part_proportion == null) part_proportion = "";
case_object = rs.getString("case_object");
if(case_object == null) 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");
if(charge_standard == null) charge_standard = "";
discount = rs.getString("discount");
if(discount == null) discount = "";
discount_person = rs.getString("discount_person");
if(discount_person == null) discount_person = "";
charge_person = rs.getString("charge_person");
if(charge_person == null) charge_person = "";
currency_kind = rs.getString("currency_kind");
comment = rs.getString("comment");
if(comment == null) comment = "";
if(time_limit != null) time_limit = time_limit.substring(0,10);
else time_limit = "";
if(receive_time != null) receive_time = receive_time.substring(0,10);
else receive_time = "";
}
//END---------------------------------------------
//-------------------------------------------
//BEGIN 其他费用列表显示
sql = "select charge_id, charge_name, charge_sum,";
sql = sql + " payment_method, receive_time,";
sql = sql + " charge_person, currency_kind";
sql = sql + " from t_charge where";
sql = sql + " case_id = '" + caseID + "'";
sql = sql + " and charge_type = 'qt'";
ResultSet rs2 = db.executeQuery(sql);
//END---------------------------------------------
//-------------------------------------------
//BEGIN--客户信息处理---
String link_man = "",
customer_id = "",
customer_name = "",
telephone = "",
mobile_telephone = "",
fax = "",
email = "",
customer_type = "",
address = "",
customer_introduce = "";
sql = "select link_man, customer_name, telephone,";
sql = sql + "mobile_telephone, fax, email, customer_type, address,";
sql = sql + "customer_introduce from t_customer where customer_id='";
sql = sql + customerID + "'";
rs = db.executeQuery(sql);
if (rs.next()) {
link_man = rs.getString("link_man");
if(link_man == null) link_man = "";
customer_id = customerID;
customer_name = rs.getString("customer_name");
if(customer_name == null) customer_name = "";
telephone = rs.getString("telephone");
if(telephone == null) telephone = "";
mobile_telephone = rs.getString("mobile_telephone");
if(mobile_telephone == null) mobile_telephone = "";
fax = rs.getString("fax");
if(fax == null) fax = "";
email = rs.getString("email");
if(email == null) email = "";
customer_type = rs.getString("customer_type");
address = rs.getString("address");
if(address == null) address = "";
customer_introduce = rs.getString("customer_introduce");
if(customer_introduce == null) customer_introduce = "";
if(customer_type == null) customer_type = "";
else if(customer_type.equals("zf")) customer_type = "政府";
else if(customer_type.equals("gq")) customer_type = "国企";
else if(customer_type.equals("sz")) customer_type = "三资";
else if(customer_type.equals("my")) customer_type = "民营";
else if(customer_type.equals("gr")) customer_type = "个人";
else if(customer_type.equals("qt")) customer_type = "其他";
}
//END---------------------------------------------
%>
<html>
<head>
<title>顾问记录信息</title>
<%@ include file="../inc/config.jsp" %>
</head>
<body class="page">
<!--显示工具条-->
<div id="Layer1" style="Position:absolute; top:70px; width:98%; height:161px; visibility: visible">
<table border="0" cellspacing="0" cellpadding="0" height="25" >
<tr class="tr_bg1" align="center">
<td class="table_bg" colspan="11" height="1" ></td>
</tr>
<tr class="tr_bg1" align="center">
<td class="table_bg" width="1" ></td>
<td onClick="MM_showHideLayers('Layer1','','show','Layer2','','hide','Layer3','','hide','Layer4','','hide','Layer5','','hide')" style="cursor:hand" class="tr_bg2" width="80" >顾问事务信息</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','show','Layer3','','hide','Layer4','','hide','Layer5','','hide')" style="cursor:hand" width="80">顾问办理事务</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','show','Layer4','','hide','Layer5','','hide')" style="cursor:hand" width="60">合同费用</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','hide','Layer4','','show','Layer5','','hide')" style="cursor:hand" width="80">其他费用列表</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','hide','Layer4','','hide','Layer5','','show')" style="cursor:hand" width="70">委托人信息</td>
<td class="table_bg" width="1"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="5" class="table_bg" align="center">
<tr>
<td width="21%" class="title_bg" align="right">顾问信息编号：</td>
<td width="79%" class="tr_bg1"> <%=caseID%></td>
</tr>
<tr>
<td width="21%" class="title_bg" align="right"> 顾问事务名称：</td>
<td width="79%" class="tr_bg1"><%=caseReason%> </td>
</tr>
<tr>
<td width="21%" class="title_bg" align="right"> 顾问开始时间：</td>
<td width="79%" class="tr_bg1"><%=beginDate%></td>
</tr>
<tr>
<td width="21%" class="title_bg" valign="top" align="right"> 顾问结束时间：</td>
<td width="79%" class="tr_bg1"><%=endDate%></td>
</tr>
<tr>
<td width="21%" class="title_bg" height="9" align="right"> 承办律师：</td>
<td width="79%" class="tr_bg1" height="9"><%=lawyerName%> </td>
</tr>
<tr>
<td width="21%" class="title_bg" align="right"> 客户名称：</td>
<td width="79%" class="tr_bg1"><%=customer%></td>
</tr>
<tr>
<td width="21%" class="title_bg" align="right"> 主要业务：</td>
<td width="79%" class="tr_bg1"><%=content%></td>
</tr>
<tr>
<td width="21%" class="title_bg" align="right"> 律师对顾问单位评价：</td>
<td width="79%" class="tr_bg1"><%=opinion%></td>
</tr>
</table>
</div>
<div id="Layer2" style="Position:absolute; top:70px; width:98%; height:161px; z-index:2; visibility: hidden">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td>
<table border="0" cellspacing="0" cellpadding="0" height="25" >
<tr class="tr_bg1" align="center">
<td class="table_bg" colspan="11" height="1" ></td>
</tr>
<tr class="tr_bg1" align="center">
<td class="table_bg" width="1" ></td>
<td onClick="MM_showHideLayers('Layer1','','show','Layer2','','hide','Layer3','','hide','Layer4','','hide','Layer5','','hide')" style="cursor:hand" width="80" >顾问事务信息</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','show','Layer3','','hide','Layer4','','hide','Layer5','','hide')" style="cursor:hand" class="tr_bg2" width="80">顾问办理事务</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','show','Layer4','','hide','Layer5','','hide')" style="cursor:hand" width="60">合同费用</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','hide','Layer4','','show','Layer5','','hide')" style="cursor:hand" width="80">其他费用列表</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','hide','Layer4','','hide','Layer5','','show')" style="cursor:hand" width="70">委托人信息</td>
<td class="table_bg" width="1"></td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" cellspacing="1" cellpadding="5" border="0" align="center" class="table_bg">
<tr class="title_bg" align="center" >
<td width="43%" >事务名称</td>
<td width="14%" >开始时间</td>
<td width="11%" >花费工时</td>
<td width="32%" >办理结果</td>
</tr>
<%
String itemID = "",
itemName = "",
beginTime = "",
spendTime = "",
itemResult = "";
int recordCount = 0;
if(rs1 != null)
{
rs1.last();
recordCount = rs1.getRow();
rs1.first();
}
for (int i=1; i <= recordCount;i++)
{
itemID = rs1.getString("item_id");
itemName = rs1.getString("item_name");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -