sueadddo.jsp

来自「这是一个法律事务所系统源码」· JSP 代码 · 共 423 行 · 第 1/2 页

	{
		iTemp++;
		itemID = String.valueOf(iTemp);
		itemName = mySmartUpload.getRequest().getParameter("txtTranCont" + i);
		if((itemName == null) || (itemName.equals("")))
		{
			iTemp--;
			continue;		//跳出循环
		}
		beginTime = mySmartUpload.getRequest().getParameter("txtBeginTime" + i);
		spendTime = mySmartUpload.getRequest().getParameter("txtSpendTime" + i);
		itemResult = mySmartUpload.getRequest().getParameter("txtResult" + i);
		
		sql = "insert into t_caseafair(case_id,item_id,item_name,begin_time,spend_time,item_result)" +
			  " values('" + caseID +
			  "','" + itemID +
			  "','" + itemName +
			  "','" + beginTime +
			  "','" + spendTime +
			  "','" + itemResult + "')";
		
		if((beginTime == null) || (beginTime.equals("")))
			sql = "insert into t_caseafair(case_id,item_id,item_name,spend_time,item_result)" +
			  " values('" + caseID +
			  "','" + itemID +
			  "','" + itemName +
			  "','" + spendTime +
			  "','" + itemResult + "')";
    	num = db.executeUpdate(sql);
		
  	} //for()
//-END LAYER2---------------------------   

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

  String charge_id = mySmartUpload.getRequest().getParameter("charge_id"),
  		charge_sum = mySmartUpload.getRequest().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 = mySmartUpload.getRequest().getParameter("charge_id");
    charge_sum = mySmartUpload.getRequest().getParameter("charge_sum"); 
    part_proportion = mySmartUpload.getRequest().getParameter("part_proportion");  
    case_object = mySmartUpload.getRequest().getParameter("case_object");  
    time_limit = mySmartUpload.getRequest().getParameter("time_limit");
    payment_method = mySmartUpload.getRequest().getParameter("payment_method");
    receive_time = mySmartUpload.getRequest().getParameter("receive_time");
    charge_standard = mySmartUpload.getRequest().getParameter("charge_standard"); 
    discount = mySmartUpload.getRequest().getParameter("discount");            
    discount_person = mySmartUpload.getRequest().getParameter("discount_person");
    charge_person = mySmartUpload.getRequest().getParameter("charge_person");
    currency_kind = mySmartUpload.getRequest().getParameter("currency_kind");
    comment = mySmartUpload.getRequest().getParameter("comment");   
    
    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 LAYER3----------------------------

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

  String customer_id = mySmartUpload.getRequest().getParameter("customer_id"),
  		customer_name = mySmartUpload.getRequest().getParameter("customer_name"),
  		tempCustomer = mySmartUpload.getRequest().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 = mySmartUpload.getRequest().getParameter("customer_id");
    customer_name = es.getStr(mySmartUpload.getRequest().getParameter("customer_name"));
    link_man = es.getStr(mySmartUpload.getRequest().getParameter("link_man"));
    telephone = es.getStr(mySmartUpload.getRequest().getParameter("telephone"));
    mobile_telephone = es.getStr(mySmartUpload.getRequest().getParameter("mobile_telephone"));
    email = es.getStr(mySmartUpload.getRequest().getParameter("email"));
    address = es.getStr(mySmartUpload.getRequest().getParameter("address"));
    customer_type = mySmartUpload.getRequest().getParameter("customer_type");
    customer_introduce = es.getStr(mySmartUpload.getRequest().getParameter("customer_introduce"));
    fax = es.getStr(mySmartUpload.getRequest().getParameter("fax"));
    enter_date = toDate; //mySmartUpload.getRequest().getParameter("enter_date");  //
    lawyer_id = mySmartUpload.getRequest().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)
      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 + ")";    
    num1 = db.executeUpdate(sql);
    if (num1 <= 0) {%>  
<script language="javascript">
  	alert("客户信息新增失败！");
</script>
  <%}else {
      gid.setIDNumber("customer_id", gid.getIDNumber("customer_id")+1);
      customerFid = "KH" + es.digitToString(gid.getIDNumber("customer_id")+1);
    }       
  }	// if((num>0) && 
//END LAYER5--------------------------
   
%>
<script language="javascript">
  location = "SueAdd.jsp";
</script>

</BODY>
</HTML>