testimonyadd.jsp

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

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

--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="system.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
  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 = "Law022";         //	案件管理/顾问管理新增
  int authflag = auth.popedom(scu_employee_id, modelid);
  if(authflag == 0 || authflag == 2 || authflag == -1)
  {%>
  <jsp:forward page="../inc/noauth.jsp" >
  </jsp:forward>
<%}%>

<%
  GetID gid = new GetID();
  ExtendString es = new ExtendString();
  String fid = "JZ" + es.digitToString(gid.getIDNumber("case_id")+1);    
  String costID = "FY" + es.digitToString(gid.getIDNumber("charge_id")+1);
  String customerID = "KH" + es.digitToString(gid.getIDNumber("customer_id")+1);
  
  String toDate = es.getNowDate(0);        
  ResultSet rs = null; 
  int num1 = 0;
  
  String str = request.getParameter("btnSave");
  if (str!=null) {
    String caseID = "",
    	caseReason = "",
    	beginDate = "",
    	lawyer = "",  
    	customer = "",
    	caseObject = "",		//标的
    	mainContent="",
    	referForeign = "",
    	charged = "",
    	noPayReason = "";
    //涉外信息：referForeign
    //	0 -- 无
    //  1 -- 涉外
    //	2 -- 涉台
    // 	3 -- 涉港澳
          
    caseID = request.getParameter("txtCaseID");
    caseReason = request.getParameter("txtCaseReason");
    //中文处理
    caseReason = new String(caseReason.getBytes("ISO8859_1"));
    beginDate = request.getParameter("txtBeginDate");
    lawyer = request.getParameter("txtLawyer");
    caseObject = request.getParameter("txtCaseObject");
    //中文处理
    caseObject = new String(caseObject.getBytes("ISO8859_1"));
    
    mainContent = request.getParameter("txtMainContent");
    mainContent = new String(mainContent.getBytes("ISO8859_1"));
    referForeign = request.getParameter("txtReferForeign");
    charged = request.getParameter("txtCharged");
    noPayReason = request.getParameter("txtNoPayReason");
    //中文处理
    noPayReason = new String(noPayReason.getBytes("ISO8859_1"));   
    customer = request.getParameter("txtCustomer");  
    if((customer == null) || (customer.equals("")))
      	customer = request.getParameter("customer_id");
    
//处理t_caseinfo数据表的插入记录    
    String sql = "insert into t_caseinfo(case_id,case_reason,case_type,case_attribute";
    sql = sql + ",case_state,begin_date";
    sql = sql + ",refer_foreign,charged";  
    if(noPayReason != null)
    	sql = sql + ",no_pay_reason";
    sql = sql + ",employee_id";     
    sql = sql + ",customer_id";	
    sql = sql + ") values('"+caseID+"','"+caseReason;
    sql = sql + "','fssaj','lsjz";	//fssaj----非诉讼案件；lsjz----律师见证
    sql = sql + "','sazt";					//sazt----收案状态
    sql = sql + "','" + beginDate;
    sql = sql + "','" + referForeign;
    sql = sql + "','" + charged;
    if(noPayReason != null)
    	sql = sql + "','" + noPayReason;
    sql = sql + "','" + lawyer;        
    sql = sql + "','" + customer; 
    sql = sql + "')";
    int num = db.executeUpdate(sql);
    if (num > 0)
    {
      gid.setIDNumber("case_id", gid.getIDNumber("case_id")+1);
      fid = "ZX" + es.digitToString(gid.getIDNumber("case_id")+1);
    }
    
    if(num > 0)
    {
    //处理T_NONCOURT 内容--main_content--
    	sql = " insert into t_noncourt (case_id";
    	sql = sql + ",main_content";
    	sql = sql + ",case_object";
    	sql = sql + ") values('" + caseID;
    	sql = sql + "','" + mainContent;   
    	sql = sql + "','" + caseObject +"')";
    	int k = db.executeUpdate(sql);
	}

//--------------------------------------
//BEGIN---处理合同费用新增---LAYER2-----

  String charge_id = request.getParameter("charge_id"),
  		charge_sum = request.getParameter("charge_sum");  
  if((num>0) && (charge_id != null) && (!charge_id.equals(""))
  	&& (charge_sum != null) && (!charge_sum.equals("")))
  {   //费用记录存在时处理

    String part_proportion, case_object;
    String time_limit, payment_method, receive_time, charge_standard, discount;
    String discount_person, charge_person, currency_kind, comment;  
    
    charge_id = request.getParameter("charge_id");
    charge_sum = request.getParameter("charge_sum"); 
    charge_sum = new String(charge_sum.getBytes("ISO8859_1"));
    part_proportion = request.getParameter("part_proportion");  
    part_proportion = new String(part_proportion.getBytes("ISO8859_1"));
    case_object = request.getParameter("case_object");   
    case_object = new String(case_object.getBytes("ISO8859_1"));
    time_limit = request.getParameter("time_limit");
    payment_method = request.getParameter("payment_method");
    receive_time = request.getParameter("receive_time");
    charge_standard = request.getParameter("charge_standard");  
    charge_standard = new String(charge_standard.getBytes("ISO8859_1"));
    discount = request.getParameter("discount");            
    discount = new String(discount.getBytes("ISO8859_1"));
    discount_person = request.getParameter("discount_person");
    charge_person = request.getParameter("charge_person");
    currency_kind = request.getParameter("currency_kind");
    comment = request.getParameter("comment");   
    comment = new String(comment.getBytes("ISO8859_1"));  
    
    sql = "insert into t_charge(charge_id, charge_sum, charge_type";     
    if ((caseID!=null) && (!caseID.equals("")))
      sql = sql + ", case_id";
    if ((part_proportion!=null) && (!part_proportion.equals("")))
      sql = sql + ", part_proportion";
    if ((case_object!=null) && (!case_object.equals("")))
      sql = sql + ", case_object";
    if ((time_limit!=null) && (!time_limit.equals("")))
      sql = sql + ", time_limit";
    if (payment_method!=null)
      sql = sql + ", payment_method";
    if ((receive_time!=null) && (!receive_time.equals("")))
      sql = sql + ", receive_time";
    if ((charge_standard!=null) && (!charge_standard.equals("")))
      sql = sql + ", charge_standard";
    if ((discount!=null) && (!discount.equals("")))
      sql = sql + ", discount";
    if ((discount_person!=null) && (!discount_person.equals("")))
      sql = sql + ", discount_person";
    if ((charge_person!=null) && (!charge_person.equals("")))
      sql = sql + ", charge_person";
    if (currency_kind!=null)
      sql = sql + ", currency_kind";
    if ((comment!=null) && (!comment.equals("")))
      sql = sql + ", comment";
    sql = sql + ") values('" + charge_id + "'," + charge_sum + ",'ht'";     
                                                            
    if ((caseID!=null) && (!caseID.equals("")))
      sql = sql + ",'" + caseID + "'";
    if ((part_proportion!=null) && (!part_proportion.equals("")))
      sql = sql + ",'" + part_proportion + "'";
    if ((case_object!=null) && (!case_object.equals("")))
      sql = sql + ",'" + case_object + "'";
    if ((time_limit!=null) && (!time_limit.equals("")))
      sql = sql + ",'" + time_limit + "'";
    if (payment_method!=null)
      sql = sql + ",'" + payment_method + "'";
    if ((receive_time!=null) && (!receive_time.equals("")))
      sql = sql + ",'" + receive_time + "'";
    if ((charge_standard!=null) && (!charge_standard.equals("")))
      sql = sql + ",'" + charge_standard + "'";
    if ((discount!=null) && (!discount.equals("")))
      sql = sql + ",'" + discount + "'";
    if ((discount_person!=null) && (!discount_person.equals("")))
      sql = sql + ",'" + discount_person + "'";
    if ((charge_person!=null) && (!charge_person.equals("")))
      sql = sql + ",'" + charge_person + "'";
    if (currency_kind!=null)
      sql = sql + ",'" + currency_kind + "'";
    if ((comment!=null) && (!comment.equals("")))
      sql = sql + ",'" + comment + "'";
    sql = sql + ")";
    num1 = db.executeUpdate(sql);
    if (num1 > 0) gid.setIDNumber("charge_id", gid.getIDNumber("charge_id")+1);

  } //if(num>0)

//END LAYER2----------------------------

//BEGIN LAYER4 ------处理客户新增信息


  String customer_id = request.getParameter("customer_id"),
  		customer_name = request.getParameter("customer_name"),
  		tempCustomer = request.getParameter("txtCustomer");
  if((num>0) && (customer_id != null) && (!customer_id.equals(""))
  	&& (customer_name != null) && (!customer_name.equals(""))
  	&& ((tempCustomer == null) || (tempCustomer.equals(""))))
  {   //客户记录存在时处理
    String link_man, telephone, mobile_telephone;
    String email, address, customer_type, customer_introduce, fax, enter_date, lawyer_id;
    customer_id = request.getParameter("customer_id");
    customer_name = es.getStr(request.getParameter("customer_name"));
    link_man = es.getStr(request.getParameter("link_man"));
    telephone = es.getStr(request.getParameter("telephone"));
    mobile_telephone = es.getStr(request.getParameter("mobile_telephone"));
    email = es.getStr(request.getParameter("email"));
    address = es.getStr(request.getParameter("address"));
    customer_type = request.getParameter("customer_type");
    customer_introduce = es.getStr(request.getParameter("customer_introduce"));
    fax = es.getStr(request.getParameter("fax"));
    enter_date = toDate; //request.getParameter("enter_date");  //
    lawyer_id = request.getParameter("txtLawyer");    //
    sql = "insert into t_customer(customer_id,customer_name";
    if (link_man!=null)
      sql = sql + ",link_man";
    if (telephone!=null)
      sql = sql + ",telephone";
    if (mobile_telephone!=null)
      sql = sql + ",mobile_telephone";
    if (email!=null)
      sql = sql + ",email";
    if (address!=null)
      sql = sql + ",address";
    if (customer_type!=null)
      sql = sql + ",customer_type";
    if (customer_introduce!=null)
      sql = sql + ",customer_introduce";
    if (fax!=null)
      sql = sql + ",fax";
    if ((enter_date!=null) && (!enter_date.equals("")))
      sql = sql + ",enter_date";
    if ((lawyer_id!=null) && (!lawyer_id.equals("")))
      sql = sql + ",lawyer_id";
    sql = sql + ") values('"+customer_id+"','"+customer_name+"'";
    if (link_man!=null)
      sql = sql + ",'" + link_man + "'";
    if (telephone!=null)
      sql = sql + ",'" + telephone + "'";
    if (mobile_telephone!=null)
      sql = sql + ",'" + mobile_telephone + "'";
    if (email!=null)
      sql = sql + ",'" + email + "'";
    if (address!=null)
      sql = sql + ",'" + address + "'";
    if (customer_type!=null)
      sql = sql + ",'" + customer_type + "'";
    if (customer_introduce!=null)