advisoramend.jsp

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

<%--
模块名称：法律顾问
模块功能：修改当前法律顾问记录的信息
版    本：V1.0
著 作 人：谢永刚(ui) SIMM(java)
著作日期：2001-09-29
所需文件：
使用说明：
技术说明：
参考文献：法律事务设计书
修改记录：= = = = = = = = = = = = = = = = = = = = = = = = = =
	修改日期：2001-10-16
	修 改 人：SIMM
	修改理由：jsp code
	修改出处：
	= = = = = = = = = = = = = = = = = = = = = = = = = =

--%>

<%@ 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 = "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 = "",				//顾问开始时间
    		endDate = "",					//顾问结束时间
    		opinion = "",					//律师对客户评价
    		lawyer = "",			//律师                          
    		customer = "",			//客户名称             
    		customerID = "",
    		mainContent = "";					//客户主要业务范围
    		
	caseID = request.getParameter("caseID");
  String sql = "select CASE_ID,CASE_REASON,BEGIN_DATE,END_DATE," +
  						 "OPINION_TO_CUSTOMER,EMPLOYEE_NAME,MAIN_CONTENT " + 
  						 ",CUSTOMER_NAME,CUSTOMER_ID " +
  						 " from V_NONSUEINFO where CASE_ID = '" + caseID + "'"; 		//查询记录

  ResultSet rs = db.executeQuery(sql);
  if (!rs.next())
  {
  	return;
  }
  else
  {
		caseID = rs.getString("case_id");
		caseReason = rs.getString("case_reason");
	
		beginDate = rs.getString("begin_date");
		if(beginDate == null) beginDate = "";			//判断空值，不显示为NULL
		else beginDate = beginDate.substring(0,10);		//时间格式转换
		
		endDate = rs.getString("end_date");		 		
		if(endDate == null) endDate = "";
		else endDate = endDate.substring(0,10);		//时间格式转换
		
		opinion = rs.getString("opinion_to_customer");
		if(opinion == null)	opinion = "";
																					
		lawyer = rs.getString("employee_name");
		if(lawyer == null) lawyer = "";
	
		mainContent = rs.getString("main_content");
		if(mainContent == null) mainContent = "";        
		customer = rs.getString("customer_name");      
		if(customer == null) customer = "";
		customerID = rs.getString("customer_id");  
	}
/**/	
//---------------------------------------
//END---法律顾问案件信息处理部分
//-----------------------------------------	


//---------------------------------------
//BEGIN---法律顾问事务信息处理部分

	String sql2 = "select item_id,item_name,begin_time,spend_time,item_result " +
				" from t_caseafair where case_id='" + caseID + "' order by item_id"; 
	ResultSet rs1 = db.executeQuery(sql2);

//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>
<head>
<title>顾问信息修改</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../inc/law.css" type="text/css">
<script Language="JavaScript" src="../inc/iOffice_Popup.js"></script>
<script Language="JavaScript" src="../inc/calendar.script"></script>
<script Language="JavaScript" src="../inc/checkValue.js"></script>

<script language="javascript">
	//检查输入的合法性
	
  function checkForm() 
  {  	
    if (document.myForm.txtCaseID.value=="") 
    {
      alert("请输入案件编码！");
      document.myForm.txtCaseID.focus();
      return false;
    }
    if (document.myForm.txtCaseReason.value=="") 
    {
      alert("请输入案由内容！");
      document.myForm.txtCaseReason.focus();
      return false;