negotiationinfo.jsp

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

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

--%>
<%@ 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 = "",
    	mainContent="",
    	referForeign = "",
    	charged = "",
    	noPayReason = "",
    	customer = "",
    	customerID = "";
    	

    caseID = request.getParameter("caseID");    	
    String sql = "select case_reason,begin_date,employee_name" + 
    	",main_content,refer_foreign,charged,no_pay_reason" +
    	",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 = "";		
		
		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 = "";
    	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 = "涉港澳";
  	 }               
//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 charge_id, charge_sum, case_id, part_proportion,";
  sql = sql + "case_object, time_limit, payment_method, receive_time,";
  sql = sql + "charge_standard, discount,discount_person,";
  sql = sql + " charge_person,currency_kind,comment";
  sql = sql + " from t_charge where";
  sql = sql + " case_id = '" + caseID + "'";  
  sql = sql + " and 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">&nbsp;</td>
      <td width="35%" class="tr_bg1">&nbsp;</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 colspan="3" class="tr_bg1"> <%=mainContent%></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>
    </tr>
    <tr> 
      <td align=right width=18% class="title_bg">免费原由：</td>
      <td colspan="3" class="tr_bg1"><%=noPayReason%></td>
    </tr>