stayarchivesinfo.jsp

这是一个法律事务所系统源码

<%--
模块名称：待归档案件管理
模块功能：显示信息内容
版    本：V1.0
著 作 人：谢永刚 SIMM(java)
著作日期：2001-10-26
该模块所需的文件：
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：= = = = = = = = = = = = = = = = = = = = = = = = = =
	修改日期：
	修 改 人：
	修改理由：
	修改出处：
	= = = = = = = = = = = = = = = = = = = = = = = = = =

--%>

<%@ 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 = "Ach011";         //	待归档案件内容显示
  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 = "",			//案由
  	 	caseAttribute = "",
  	 	customer = "",
    		beginDate = "",				//顾问开始时间
    		endDate = "",
    		judgeLevel = "",
    		judgeResult = "",
    		archivePerson = "",
    		archiveID = "",
    		keepYears = "",
    		archiveDate = "",
    		caseRemark = "",      
    		court = "",
    		lawyer = "",			//律师
    		
    		contract = "",							//授权、辩护委托书合同
    		credence = "",							//收费凭证    		
    		answerBook = "", 			//答辩状
    		appealBook = "",			//上诉书
    		judgementFor1 = "", 	//一审判决书
    		requisition = "",			//申请书
    		faceNote = "",								//会见被告人或当事人笔录
    		doResult = "",   						//裁判，调解文书或处理结果
    		rollChart = "",  						//卷内备考表
    		accessorys = "",						//附件
    		proof = "", 								//相关证据
    		courtReport = "", 					//开庭报告
    		discussRecord = "", 				//案情讨论记录
    		courtBook = "", 						//法院文书    		
    		agentWord = "", 						//律师代理词
    		indictment = "", 						//律师起诉状
    		courtNote = "", 						//律师庭审笔录
    		readNote = "", 							//律师阅卷笔录
    		caseBrief = ""; 						//办案小结
    		
  caseID = request.getParameter("caseID");
  String sql = "select case_reason, case_attribute, customer_name ";
  sql = sql + ", begin_date, end_date ";
  sql = sql + ", judge_level, judge_result";
  sql = sql + ", employee_name, archive_person";
  sql = sql + ", archive_id, keep_years, case_remark ";   
  sql = sql + ", court ";
  sql = sql + " from V_CASEINFO where case_id = '";
  sql = sql + caseID + "'";
  
  ResultSet rs = db.executeQuery(sql);
  if(rs.next())
  {
  	caseReason = rs.getString("case_reason");
  	caseAttribute = rs.getString("case_attribute");
  	if(caseAttribute == null)  caseAttribute = "";
  	customer = rs.getString("customer_name");
  	if(customer == null)  customer = "";
  	beginDate = rs.getString("begin_date");
  	if(beginDate == null) beginDate = "";
  	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 = "";
  	judgeResult = rs.getString("judge_result");
  	if(judgeResult == null) judgeResult = "";
  	lawyer = rs.getString("employee_name");
  	if(lawyer == null) lawyer = "";
  	archivePerson = rs.getString("archive_person");
  	if(archivePerson == null) archivePerson = "";
  	archiveID = rs.getString("archive_id");
  	if(archiveID == null)  archiveID = "";
  	keepYears = rs.getString("keep_years");
  	if(keepYears == null) keepYears = "";
  	caseRemark = rs.getString("case_remark");
  	if(caseRemark == null) caseRemark = "";   
  	court = rs.getString("court");
  	if(court == null) court = "";
    
  	 	caseAttribute = caseAttribute.trim();
		if(caseAttribute.equals("flgw"))  caseAttribute = "法律顾问";
		else if(caseAttribute.equals("znht"))  caseAttribute = "撰拟合同";
		else if(caseAttribute.equals("flyjs"))  caseAttribute = "法律意见书";
		else if(caseAttribute.equals("flzx"))  caseAttribute = "法律咨询";
		else if(caseAttribute.equals("lsjz"))  caseAttribute = "律师见证";
		else if(caseAttribute.equals("cytp"))  caseAttribute = "参与谈判";
		else if(caseAttribute.equals("zctj"))  caseAttribute = "仲裁调解";
		else if(caseAttribute.equals("qtsw"))  caseAttribute = "其他事务";
		else 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 = "其他诉讼";
		else caseAttribute = "";
  }
  sql = "select proof ,court_report,discuss_record,court_book";
  sql = sql + ",agent_word,indictment,court_note,read_note,case_brief";
  sql = sql + ",contract,credence,answer_book,appeal_book,judgement_for1,requisition";
  sql = sql + ",face_note,do_result,roll_chart,accessory ";
  sql = sql + " from t_suecase where case_id='" + caseID + "'";
  rs = db.executeQuery(sql);
  if(rs.next()) {    		
    		proof = rs.getString(1); 								//相关证据
    		courtReport = rs.getString(2); 					//开庭报告
    		discussRecord = rs.getString(3); 				//案情讨论记录
    		courtBook = rs.getString(4); 						//法院文书    		
    		agentWord = rs.getString(5); 						//律师代理词
    		indictment = rs.getString(6);						//律师起诉状
    		courtNote = rs.getString(7); 						//律师庭审笔录
    		readNote = rs.getString(8);							//律师阅卷笔录
    		caseBrief = rs.getString(9); 						//办案小结
  
    		contract = rs.getString(10);							//授权、辩护委托书合同
    		credence = rs.getString(11);							//收费凭证    		
    		answerBook = rs.getString(12); 			//答辩状
    		appealBook = rs.getString(13);			//上诉书
    		judgementFor1 = rs.getString(14); 	//一审判决书
    		requisition = rs.getString(15);			//申请书
    		faceNote = rs.getString(16);								//会见被告人或当事人笔录
    		doResult = rs.getString(17);   						//裁判，调解文书或处理结果
    		rollChart = rs.getString(18);  						//卷内备考表
    		accessorys = rs.getString(19);						//附件
  }
%>


<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>待归档案件信息查看</title>
<%@ include file="../inc/config.jsp" %>
</head>

<body class="page">
<!--显示工具条-->
<div id="Layer1" style="Position:absolute; left:5px; top:70px; width:98%; height:186px; 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="8" 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')" 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')"  style="cursor:hand" width="60">案件信息</td>
      <td  class="table_bg" width="1"></td>
      <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','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"> <%=archiveID%></td>
      <td width="19%"  align="right" class="title_bg"> 归档日期： </td>
      <td width="35%" class="tr_bg1"><%=archiveDate%></td>
    </tr>
    <tr> 
    <%
    sql = "select employee_name from t_employee where employee_id='";
    sql = sql + archivePerson + "'";
    rs = db.executeQuery(sql);
    if(rs.next()) archivePerson = rs.getString(1);
    
    %>
      <td align=right width=18% class="title_bg"> 立卷人：</td>
      <td width=28% class="tr_bg1"> <%=archivePerson%></td>
      <td align=right width=19% class="title_bg"> 保存年限： </td>
      <td width=35% class="tr_bg1" > <%=keepYears%></td>
    </tr>
    <tr> 
      <td align="right" width="18%" class="title_bg"> 备注：</td>
      <td colspan="3" class="tr_bg1"><%=caseRemark%></td>
    </tr>
  </table>
</div>
<div id="Layer2" style="Position:absolute; left:5px; top:70px; width:98%; height:121px; z-index:3; visibility: hidden"> 
  <table border="0" cellspacing="0" cellpadding="0" height="25" >
    <tr class="tr_bg1" align="center"> 
      <td  class="table_bg"  colspan="8" 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')" style="cursor:hand"  width="80" >归档案卷信息</td>
      <td class="table_bg" width="1"></td>
      <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','show','Layer3','','hide')"  style="cursor:hand" class="tr_bg2"  width="60">案件信息</td>
      <td  class="table_bg" width="1"></td>
      <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','show')"  style="cursor:hand" width="80">卷宗文档列表</td>
      <td  class="table_bg" width="1"></td>
    </tr>
  </table>
  <table width="100%" 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"><%=caseID%></td>
      <td width="150"  align="right" class="title_bg"> 类    别： </td>
      <td width="245" class="tr_bg1"> <%=caseAttribute%></td>
    </tr>
    <tr> 
      <td align="right" width="152" class="title_bg"> 案由：</td>
      <td colspan="3" class="tr_bg1"> <%=caseReason%></td>
    </tr>
    <tr> 
      <td align=right width=152 class="title_bg"> 承办律师： </td>
      <td width=197 class="tr_bg1"> <%=lawyer%></td>
      <td align="right" width="150" class="title_bg"> 委托人： </td>
      <td width=245 class="tr_bg1"><%=customer%> </td>
    </tr>
    <tr> 
      <td align=right width=152 class="title_bg"> 收案日期： </td>
      <td width=197 class="tr_bg1"> <%=beginDate%></td>
      <td align=right width=150 class="title_bg"> 结案日期： </td>
      <td width=245 class="tr_bg1" > <%=endDate%></td>
    </tr>
    <tr> 
      <td align=right width=152 class="title_bg"> 审理法院： </td>
      <td width=197 class="tr_bg1"> <%=court%></td>
      <td align=right width=150 class="title_bg"> 审级： </td>
      <td width=245 class="tr_bg1" ><%=judgeLevel%></td>
    </tr>
    <tr> 
      <td align=right width=152 class="title_bg"> 审理结果： </td>
      <td width=197 class="tr_bg1"><%=judgeResult%></td>
      <td align=right width=150 class="title_bg">&nbsp;</td>
      <td width=245 class="tr_bg1" >&nbsp;</td>
    </tr>
  </table>
</div>
<div id="Layer3" style="Position:absolute; left:5px; top:70px; width:98%; height:70px; z-index:4; visibility: hidden"> 
  <table border="0" cellspacing="0" cellpadding="0" height="25" >
    <tr class="tr_bg1" align="center"> 
      <td  class="table_bg"  colspan="8" 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')" style="cursor:hand"  width="80" >归档案卷信息</td>
      <td class="table_bg" width="1"></td>
      <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','show','Layer3','','hide')"  style="cursor:hand" width="60">案件信息</td>
      <td  class="table_bg" width="1"></td>
      <td  onClick="MM_showHideLayers('Layer1','','hide','Layer2','','hide','Layer3','','show')"  style="cursor:hand" class="tr_bg2"  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="30%"  align="right" class="title_bg"> 授权、辩护委托书合同：</td>
      <td width="27%" class="tr_bg1">
	<%
	ExtendString es1 = new ExtendString();
	if(contract!=null)
	{
		if(contract.equals("")) out.print("无");
		String[] pk=new String[10];
        pk= es1.Split(";" ,contract);
		for(int i=0;i<es1.length-1;i++){
			if((i%2)==0){
				out.print("<a href=/upload/"+pk[i+1]+" target=\"_blank\">"+pk[i]+"</a>");
				if((i!=(es1.length-3))&&((es1.length-2)!=1)){out.print("、");};