otheramend.jsp

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

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

--%>

<%@ page language="java" import="java.util.Date,java.util.Locale,java.text.DateFormat,system.ExtendString"%>
<%@ 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 = "Law023";         //	案件管理/顾问管理修改
  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 = "",				//案件编码
  	 		caseReason = "",			//事 由
    		beginDate = "",				//时间
    		mainContent = "",			//内容
    		referForeign = "",			//涉外信息
    		charged = "",				//是否收费
    		noPayReason = "",			//免费事由
    		lawyer = "",				//承办律师
    		customer = "",
    		customerID = "",
    		accessory = "";
    		
  caseID = request.getParameter("caseID");
  String sql = "select CASE_REASON,BEGIN_DATE" +
  				", main_content, refer_foreign" +
  				", charged, no_pay_reason, EMPLOYEE_name " +
  				", customer_name, customer_id,accessory" +
  				" from v_nonsueinfo where CASE_ID = '" + 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 = "";			//判断空值，不显示为NULL
		else beginDate = beginDate.substring(0,10);		//时间格式转换		    	
    	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 = "";
    	lawyer = rs.getString("employee_name");			//承办律师	
		if(lawyer == null) lawyer = "";         
		customer = rs.getString("customer_name");
		if(customer == null) customer = "";
		customerID = rs.getString("customer_id"); 
		accessory = rs.getString("accessory");
		if(accessory == null) accessory = "";
									
	}


//---------------------------------------
//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--客户信息处理---c

  String cLinkMan = "",
  		cCustomerID = "",
  		cCustomerName = "", 
  		cTelephone = "", 
  		cMobile = "",
  		cFax = "", 
  		cEmail = "", 
  		cCustomerType = "",
  		engCustomerType = "",	//拼音代号 
  		cAddress = "", 
  		cCustomerIntroduce = "";
  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()) {
    cLinkMan = rs.getString("link_man");
    if(cLinkMan == null) cLinkMan = "";             
    
    cCustomerID = customerID;
    cCustomerName = rs.getString("customer_name"); 
    if(cCustomerName == null) cCustomerName = "";        
    
    cTelephone = rs.getString("telephone");       
    if(cTelephone == null) cTelephone = "";         
    
    cMobile = rs.getString("mobile_telephone");          
    if(cMobile == null) cMobile = "";    
    
    cFax = rs.getString("fax");                 
    if(cFax == null) cFax = "";            
    
    cEmail = rs.getString("email");                 
    if(cEmail == null) cEmail = "";       
    
    cCustomerType = rs.getString("customer_type");    
    
    cAddress = rs.getString("address");                
    if(cAddress == null) cAddress = "";             
    
    cCustomerIntroduce = rs.getString("customer_introduce");        
    if(cCustomerIntroduce == null) cCustomerIntroduce = "";     
    
    if(cCustomerType != null) engCustomerType = cCustomerType;
    
    if(cCustomerType == null) cCustomerType = "";   
    else if(cCustomerType.equals("zf")) cCustomerType = "政府";
    else if(cCustomerType.equals("gq")) cCustomerType = "国企";
    else if(cCustomerType.equals("sz")) cCustomerType = "三资";
    else if(cCustomerType.equals("my")) cCustomerType = "民营";
    else if(cCustomerType.equals("gr")) cCustomerType = "个人";
    else if(cCustomerType.equals("qt")) cCustomerType = "其他";
        
  }

//END---------------------------------------------
%>

<html>

<script language="JavaScript">
<!--
function addfile()
{
  attach.insertAdjacentHTML("BeforeEnd","<INPUT id=file1 name=Accessory type=file size=30 class=input><br>")
}