📄 consultationinfo.jsp
字号:
<%--
模块名称：法 律 咨 询
模块功能：显示内容
版 本：V1.0
著 作 人：SIMM
著作日期：2001-10-30
该模块所需的文件：BulletionAmend.jsp
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<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>
<%}%>
<%
String caseID = "",
caseReason = "",
beginDate = "",
lawyer = "",
subType = "",
opinion = "",
mainContent="",
referForeign = "",
charged = "",
noPayReason = "",
customer = "",
customerID = "";
caseID = request.getParameter("caseID");
String sql = "select case_reason,begin_date,employee_name" +
",sub_type,main_content,refer_foreign,charged,no_pay_reason" +
",opinion_to_customer " +
",customer_id,customer_name" +
" from v_nonsueinfo where case_id = '";
sql = sql + caseID + "'";
ResultSet rs = db.executeQuery(sql);
if(!rs.next())
{
return;
}
else
{
caseReason = rs.getString("case_reason"); //案由
beginDate = rs.getString("begin_date");
if(beginDate == null) beginDate = "";
else beginDate = beginDate.substring(0,10); //时间格式转换
lawyer = rs.getString("employee_name");
if(lawyer == null) lawyer = "";
subType = rs.getString("sub_type");
if(subType == null) subType = "";
mainContent = rs.getString("main_content");
if(mainContent == null) mainContent = "";
referForeign = rs.getString("refer_foreign");
charged = rs.getString("charged");
noPayReason = rs.getString("no_pay_reason");
if(noPayReason == null) noPayReason = "";
opinion = rs.getString("opinion_to_customer");
if(opinion == null) opinion = "";
customerID = rs.getString("customer_id");
customer = rs.getString("customer_name");
if(customer == null) customer = "";
//转换内容
if(charged.equals("0")) charged = "否";
else if(charged.equals("1")) charged = "是";
if(referForeign.equals("0"))
referForeign = "无";
else if(referForeign.equals("1"))
referForeign = "涉外";
else if(referForeign.equals("2"))
referForeign = "涉台";
else if(referForeign.equals("3"))
referForeign = "涉港澳";
if(subType.equals("0")) subType = "口头咨询";
else if(subType.equals("1")) subType = "书面咨询";
}
//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:120px; z-index:1; 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')" style="cursor:hand" class="tr_bg2" width="70" >案件信息</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','show','Layer3','','hide','Layer4','','hide')" style="cursor:hand" width="70">费用信息</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','show','Layer4','','hide')" style="cursor:hand" width="90">其他费用列表</td>
<td class="table_bg" width="1"></td>
<td onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','hide','Layer4','','show')" style="cursor:hand" width="80">委托人信息</td>
<td class="table_bg" width="1"></td>
</tr>
</table>
<table align="center" border="0" cellspacing="1" cellpadding="5" class="table_bg" width="100%">
<tr>
<td width="18%" align="right" class="title_bg"> 编 码：</td>
<td width="28%" class="tr_bg1"> <%=caseID%> </td>
<td width="19%" align="right" class="title_bg"> 咨询类型：</td>
<td width="35%" class="tr_bg1"> <%=subType%></td>
</tr>
<tr>
<td align="right" width="18%" class="title_bg"> 案由：</td>
<td class="tr_bg1" colspan="3"> <%=caseReason%> </td>
</tr>
<tr>
<td align=right width=18% class="title_bg"> 涉外信息：</td>
<td width=28% class="tr_bg1"> <%=referForeign%></td>
<td align=right width=19% class="title_bg"> 咨询时间：</td>
<td width=35% class="tr_bg1" > <%=beginDate%></td>
</tr>
<tr>
<td align=right width=18% class="title_bg"> 承办律师：</td>
<td class="tr_bg1" width="28%"> <%=lawyer%></td>
<td align="right" class="title_bg" width="19%">是否收费：</td>
<td class="tr_bg1" width="35%"> <%=charged%></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -