arbitrationinfo.jsp

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

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

--%>

<%@ 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 = "",
    	caseNo = "",
    	caseReason = "",
    	beginDate = "",
    	endDate = "",
    	agentSide = "",      
    	customerID = "",
    	customer = "",
    	lawyer = "",
    	applicant = "",  	//申请人简介
    	appellee = "",  	//被申请人简介
    	arbitrationCourt = "",	//受理仲裁委员会   
    	      
    	proof = "",				//相关证据
    	discussRecord = "",		//案情讨论记录
    	notice = "",            //仲裁委通知书   
    	arbitration_judgment = "",     //仲裁委裁决书
    	agent_word = "",        //律师代理词
    	defensive_word = "",    //律师辩护词
    	court_report = "",      //开庭报告
    	accessorys = "",			//附件       	
    	caseObject = "",		//标的
    	referForeign = "",
    	charged = "",
    	noPayReason = "";
    ResultSet rs = null;
    caseID = request.getParameter("caseID");    	
    String sql = "select case_no, case_reason, begin_date, end_date" +
    	", refer_foreign, charged, no_pay_reason" +
    	", employee_name" + 
    	", agent_side, applicant_introduce " +
    	", appellee_introduce,arbitration_court" +    
    	", proof, discuss_record, notice, arbitration_judgment" +
    	", agent_word, defensive_word, court_report, accessory" +
    	", case_object " +                               
    	", customer_id, customer_name" +
    	" from V_arbitratecase where case_id = '";
    sql = sql + caseID + "'";
   
    rs = db.executeQuery(sql);		
	if(!rs.next()) return;
	else
	{						
		caseNo = rs.getString("case_no");
		if(caseNo == null) caseNo = "";
		caseReason = rs.getString("case_reason");			//案由  	 		
		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);		
		referForeign = rs.getString("refer_foreign");		
    	charged = rs.getString("charged");
    	noPayReason = rs.getString("no_pay_reason");
    	if(noPayReason == null) noPayReason = "";
		lawyer = rs.getString("employee_name");
		if(lawyer == null) lawyer = "";		
		agentSide = rs.getString("agent_side");       
		if(agentSide == null) agentSide = "";
		applicant = rs.getString("applicant_introduce");
		if(applicant == null) applicant = "";
		appellee = rs.getString("appellee_introduce");
		if(appellee == null) appellee = "";
		arbitrationCourt = rs.getString("arbitration_court");
		if(arbitrationCourt == null) arbitrationCourt = "";   
		                                               
    	proof = rs.getString("proof");
    	discussRecord = rs.getString("discuss_record");
    	notice = rs.getString("notice"); 
    	arbitration_judgment = rs.getString("arbitration_judgment");
    	agent_word = rs.getString("agent_word");
    	defensive_word = rs.getString("defensive_word");
    	court_report = rs.getString("court_report");
    	accessorys = rs.getString("accessory");
    	
    	caseObject = rs.getString("case_object"); 
		if(caseObject == null) caseObject = "";
		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(agentSide.equals("1"))		//委托方
			agentSide = "申请人";
		else if(agentSide.equals("2"))
			agentSide = "被申请人";
 	 } 
//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 = "";