archivesinfo.jsp

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

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

--%>
<%@ 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 = "Ach021";         //	归档案卷内容显示
  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 = "",
    	caseAttribute = "",
    	caseReason = "",
    	lawyer = "",
    	customer = "",
    	beginDate = "",
    	endDate = "",
    	court = "",
    	judgeLevel = "",
    	judgeResult = "",
    	
    	archiveID = "",
    	archiveDate = "",
    	archivePerson = "",
    	keepYears = "",
    	caseRemark = "";
    	

    caseID = request.getParameter("caseID");    	
    String sql = "select case_attribute,case_reason" +
    	",employee_name" +
    	",customer_name" +
    	",begin_date,end_date" +
    	",court,judge_level,judge_result" +
    	",archive_id,archive_date,archive_person" +
    	",keep_years,case_remark" +
    	" from v_archivesinfo where case_id = '";
    sql = sql + caseID + "'";
    ResultSet rs = db.executeQuery(sql);
		
	if(!rs.next())
	{
		return;
	}
	else
	{						 
    	caseAttribute = rs.getString("case_attribute");	 		
		caseReason = rs.getString("case_reason");			//案由 
		lawyer = rs.getString("employee_name");
		if(lawyer == null) lawyer = "";		
    	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);					//时间格式转换
		    	
    	court = rs.getString("court");
		if(court == null) court = "";	
		
   // 	judgeLevel = rs.getString("judge_level");
    	
    	judgeResult = rs.getString("judge_result");
    	if(judgeResult == null) judgeResult = "";    	
   		archiveID = rs.getString("archive_id");
    	if(archiveID == null) archiveID = "";
    	archiveDate = rs.getString("archive_date");
    	if(archiveDate == null) archiveDate = "";
    	archivePerson = rs.getString("archive_person");
    	if(archivePerson == null) archivePerson = "";
    	keepYears = rs.getString("keep_years");
    	if(keepYears == null) keepYears = "";
    	caseRemark = rs.getString("case_remark");
    	if(caseRemark == null) caseRemark = "";
    /* 	*/    	
  	 	//转换内容
  	 	//out.println(caseAttribute);
  	 	caseAttribute = caseAttribute.substring(0,4);
		if(caseAttribute.equals("flgw"))  caseAttribute = "法律顾问";
		else if(caseAttribute.equals("znht"))  caseAttribute = "撰拟合同";
		else if(caseAttribute.equals("flyj"))  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 = "";
		
		if(judgeLevel.equals("1"))  judgeLevel = "一审";
		else if(judgeLevel.equals("2")) judgeLevel = "二审";
		else judgeLevel = "";
  	 }
  		 
  	%>

<html>

<head>
<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> 
      <td align=right width=18% class="title_bg"> 立卷人：</td>
      <td width=28% class="tr_bg1"> <%=archivePerson%></td>