negotiationadd.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 = "TP" + 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 str = request.getParameter("btnSave");
  int num = 0,num1 = 0;
  String customerSysID = "";
  String toDate = es.getNowDate(0); 
  String sql = "";
  String caseID = "",
    	caseReason = "",
    	beginDate = "",
    	lawyer = "",
    	
    	mainContent="",
    	referForeign = "",
    	charged = "",
    	noPayReason = "",
    	customer = "";
          
  if (str!=null) {
    caseID = request.getParameter("txtCaseID");
    caseReason = request.getParameter("txtCaseReason");
    //中文处理
    caseReason = new String(caseReason.getBytes("ISO8859_1"));
    beginDate = request.getParameter("txtBeginDate");
    lawyer = request.getParameter("txtLawyer");
    
    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数据表的插入记录    
    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','cytp";	//fssaj----非诉讼案件；cytp----参与谈判
    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 + "')";
    num = db.executeUpdate(sql);
    if (num <= 0) %>
    <script language="javascript">
    	alert("新增失败！");
    </script>
    <%
    else 
    {
      gid.setIDNumber("case_id", gid.getIDNumber("case_id")+1);
      fid = "TP" + 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 + ") values('" + caseID;
    	sql = sql + "','" + mainContent +"')";
    	int k = db.executeUpdate(sql);
		if(k <= 0 )  %>
    <script language="javascript">
    	alert("谈判内容新增失败！");
    </script>
    <%
	}
  }
//--------------------------------------
//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"); 
    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_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)   {%>
    	<script language="javascript">
    		alert("合同费用新增失败！");
    	</script>
    <%}
    else  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 = request.getParameter("customer_name");
    customer_name = new String(customer_name.getBytes("ISO8859_1")); 
    link_man = request.getParameter("link_man");
    link_man = new String(link_man.getBytes("ISO8859_1"));
    telephone = request.getParameter("telephone");
    telephone = new String(telephone.getBytes("ISO8859_1"));
    mobile_telephone = request.getParameter("mobile_telephone");
    mobile_telephone = new String(mobile_telephone.getBytes("ISO8859_1"));
    email = request.getParameter("email");
    email = new String(email.getBytes("ISO8859_1"));
    address = request.getParameter("address");
    address = new String(address.getBytes("ISO8859_1"));
    customer_type = request.getParameter("customer_type");
    customer_introduce = request.getParameter("customer_introduce");
    customer_introduce = new String(customer_introduce.getBytes("ISO8859_1"));
    fax = request.getParameter("fax");
    fax = new String(fax.getBytes("ISO8859_1"));
    enter_date = toDate; 
    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 + "'";