📄 sueinfo.jsp
字号:
<%--
模块名称：诉讼案件信息显示
模块功能：显示选择的记录内容
版 本：V1.0
著 作 人：谢永刚(ui) SIMM(java)
著作日期：2001-10-20
该模块所需的文件：
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ 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 = "", //案件编码
caseNo = "", //案件编号（法院）
caseReason = "", //案由
approveMan = "", //审批人
lawyer = "", //律师
caseType = "", //案件类别
caseAttribute = "", //案件属性
agentSide = "", //委托角色
agentMan = "", //委托人
referForeign = "", //涉外信息
court = "", //受理法院
defendantInfo = "", //被告简介
plaintiffInfo = "", //原告简介
beginDate = "", //收案时间
endDate = "", //结案时间
judgeLevel = "", //审级
judgeToCustomerDate = "", //判决书递交客户时间
charged = "", //是否收费
noPayReason = "", //免费事由
proof = "", //相关证据
courtReport = "", //开庭报告
discussRecord = "", //案情讨论记录
courtBook = "", //法院文书
agentWord = "", //律师代理词
indictment = "", //律师起诉状
courtNote = "", //律师庭审笔录
readNote = "", //律师阅卷笔录
caseBrief = "", //办案小结
judgeResult = "", //判决结果
remarks = "", //备注
customer = "",
customerID = "";
caseID = request.getParameter("caseID");
String sql = "select case_no,case_reason " +
", approve_man, employee_name, case_type, case_attribute" +
", agent_side, agent_man, refer_foreign, court, defendant_info " +
", plaintiff_info, begin_date, end_date,judge_level" +
", judge_to_customer_date, charged, no_pay_reason, proof" +
", court_report, discuss_record, court_book,agent_word, indictment" +
", court_note, read_note, case_brief, judge_result, case_remark" +
", customer_id, customer_name" +
" from V_SUEINFO " +
" where CASE_ID = '" + caseID + "'"; //查询记录
ResultSet rs = db.executeQuery(sql);
if(!rs.next())
{
return;
}
else
{
caseNo = rs.getString("case_no"); //案件编号（法院）
if(caseNo == null) caseNo = "";
caseReason = rs.getString("case_reason"); //案由
approveMan = rs.getString("approve_man"); //审批人
if(approveMan == null) approveMan = "";
lawyer = rs.getString("employee_name"); //律师
if(lawyer == null) lawyer = "";
caseType = rs.getString("case_type"); //案件类别
if(caseType == null) caseType = "";
caseAttribute = rs.getString("case_attribute"); //案件属性
if(caseAttribute == null) caseAttribute = "";
agentSide = rs.getString("agent_side"); //委托角色
if(agentSide == null) agentSide = "";
agentMan = rs.getString("agent_man"); //委托人
if(agentMan == null) agentMan = "";
referForeign = rs.getString("refer_foreign"); //涉外信息
if(referForeign == null) referForeign = "";
court = rs.getString("court"); //受理法院
if(court == null) court = "";
defendantInfo = rs.getString("defendant_info"); //被告简介
if(defendantInfo == null) defendantInfo= "";
plaintiffInfo = rs.getString("plaintiff_info"); //原告简介
if(plaintiffInfo == null) plaintiffInfo= "";
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); //时间格式转换
judgeLevel = rs.getString("judge_level"); //审级
if(judgeLevel == null) judgeLevel= "";
judgeToCustomerDate = rs.getString("judge_to_customer_date"); //判决书递交客户时间
if(judgeToCustomerDate == null) judgeToCustomerDate= "";
charged = rs.getString("charged"); //是否收费
if(charged == null) charged= "";
noPayReason = rs.getString("no_pay_reason"); //免费事由
if(noPayReason == null) noPayReason= "";
proof = rs.getString("proof"); //相关证据
if(proof == null) proof= "";
courtReport = rs.getString("court_report"); //开庭报告
if(courtReport == null) courtReport= "";
discussRecord = rs.getString("discuss_record"); //案情讨论记录
if(discussRecord == null) discussRecord= "";
courtBook = rs.getString("court_book"); //法院文书
if(courtBook == null) courtBook= "";
agentWord = rs.getString("agent_word"); //律师代理词
if(agentWord == null) agentWord= "";
indictment = rs.getString("indictment"); //律师起诉状
if(indictment == null) indictment= "";
courtNote = rs.getString("court_note"); //律师庭审笔录
if(courtNote == null) courtNote= "";
readNote = rs.getString("read_note"); //律师阅卷笔录
if(readNote == null) readNote= "";
caseBrief = rs.getString("case_brief"); //办案小结
if(caseBrief == null) caseBrief = "";
judgeResult = rs.getString("judge_result"); //判决结果
if(judgeResult == null) judgeResult = "";
remarks = rs.getString("case_remark"); //备注
if(remarks == null) remarks = "";
customerID = rs.getString("customer_id");
customer = rs.getString("customer_name");
if(customer == null) customer = "";
caseType = caseType.trim();
if(caseType.equals("ssaj")) caseType = "诉讼案件";
else if(caseType.equals("fssaj")) caseType = "非诉讼案件";
caseAttribute = caseAttribute.trim();
if(caseAttribute.equals("xsss")) caseAttribute = "刑事诉讼";
else if(caseAttribute.equals("msss")) caseAttribute = "民事诉讼";
else if(caseAttribute.equals("jjss")) caseAttribute = "经济诉讼";
else if(caseAttribute.equals("xzss")) caseAttribute = "行政诉讼";
else if(caseAttribute.equals("qtss")) caseAttribute = "其他诉讼";
if(judgeLevel.equals("1")) judgeLevel = "一审";
else if(judgeLevel.equals("2")) judgeLevel = "二审";
if(charged.equals("1")) charged = "收费";
else if(charged.equals("0")) charged = "免费";
if(referForeign.equals("0")) referForeign = "无";
else if(referForeign.equals("1")) referForeign = "涉外";
else if(referForeign.equals("2")) referForeign = "涉台";
else if(referForeign.equals("3")) referForeign = "涉港澳";
else referForeign = "";
if(agentSide.equals("1")) agentSide = "原告";
else if(agentSide.equals("2")) agentSide = "被告";
else if(agentSide.equals("3")) agentSide = "第三人";
else agentSide = "";
} /**/
//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);
/*if(rs1 != null)
{
out.println(rs1.getRow());
if(rs1.next())
{caseID = rs1.getString(1);
out.println("caseid:" + caseID);
}
}
else out.println("it is null");
*/
//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 = "";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -