costenteradd.jsp

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

<%--
模块名称：费用管理
模块功能：费用登记增加
版    本：V1.0
著 作 人：蔡静
著作日期：2001-10-19
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：
        = = = = = = = = = = = = = = = = = = = = = = = = = =
	修改日期：
	修 改 人：
	修改理由：
	修改出处：
	= = = = = = = = = = = = = = = = = = = = = = = = = =

--%>
<%@ 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 employee_id = (String)session.getAttribute("employee_id");
  if(employee_id == null || employee_id.equals(""))
  {
    response.sendRedirect(response.encodeRedirectURL("../Error/nonlogin.htm"));
  }
  String modelid = "Chg012";
  int authflag = auth.popedom(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 = "FY" + es.digitToString(gid.getIDNumber("charge_id")+1);
  String str = request.getParameter("save");
  String sql = "";
  ResultSet rs = null;
  if (str!=null) {
    String charge_id, charge_sum, case_id, case_reason, part_proportion, case_object;
    String time_limit, payment_method, receive_time, charge_standard, discount;
    String discount_person, charge_person, currency_kind, comment, charge_type;  
    String charge_name = "", lawyer_id = "";
    charge_id = request.getParameter("charge_id");
    charge_sum = request.getParameter("charge_sum"); 
    charge_sum = new String(charge_sum.getBytes("ISO8859_1"));
    case_id = request.getParameter("case_id");
    case_reason = request.getParameter("case_reason");
    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"));  
    charge_type = request.getParameter("charge_type");
    charge_type = new String(charge_type.getBytes("ISO8859_1"));
    
    charge_name = request.getParameter("charge_name");
    charge_name = new String(charge_name.getBytes("ISO8859_1"));
    lawyer_id = request.getParameter("employee_id");
  //add by SIMM 2001-12-30  
    sql = "select count(*) from t_charge where case_id='";
    sql = sql + case_id + "' and charge_type='ht'";
    String isHTCharge = "";
    rs = db.executeQuery(sql);
    if(rs.next()) isHTCharge = rs.getString(1);
  //判断案件的合同费用是否已经存在
	if(!isHTCharge.equals("0")){%>
		<script language="javascript">
			alert("案件的合同费用信息已经存在！");
		</script>
	<%} else {		//@@
	
    sql = "insert into t_charge(charge_id, charge_sum";
    if (case_id!=null)
      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";      
    if ((charge_name!=null) && (!charge_name.equals("")))
      sql = sql + ", charge_name";          
    if ((lawyer_id!=null) && (!lawyer_id.equals("")))
      sql = sql + ", employee_id";      
    if ((charge_type!=null) && (!charge_type.equals("")))
    	sql = sql + ",charge_type";
    	
    sql = sql + ") values('" + charge_id + "'," + charge_sum;
    if (case_id!=null)
      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 + "'";    
    if ((charge_name!=null) && (!charge_name.equals("")))
      sql = sql + ",'" + charge_name + "'";          
    if ((lawyer_id!=null) && (!lawyer_id.equals("")))
      sql = sql + ",'" + employee_id + "'";
    if ((charge_type!=null) && (!charge_type.equals("")))
    	sql = sql + ",'" + charge_type + "'";
    sql = sql + ")";
    int num = db.executeUpdate(sql);
    if (num <= 0) {%>  
		<script language="javascript">
  		alert("新增失败！");
		</script>
  	<%}else {
      gid.setIDNumber("charge_id", gid.getIDNumber("charge_id")+1);
      fid = "FY" + es.digitToString(gid.getIDNumber("charge_id")+1);
    }
  } //@@
  }
%>
<html>

<head>
<title>费用登记增加</title>
<%@ include file="../inc/config.jsp" %>
</head>

<body class="page">
<script language="javascript">
  function checkNumber(num) {
    var legalchar=new Array("1","2","3","4","5","6","7","8","9","0",".");
    var t="";
    var dot = 0;
    for(i=0;i<num.length;i++) {
      n=num.substr(i,1);
      for(j=0;j<legalchar.length;j++) {
        if(n==legalchar[j]) {
          if (n==".")
            dot = dot + 1;
          break;
        }
      }
      if (j == legalchar.length)
        t = t + n;
    }
    if(t != "") {
      alert("费用金额中有非法字符" + t + "！");
      return false;
    }
    else {
      if (dot >= 2) {
        alert("费用金额中有两个.号！");
        return false;
      }
      return true;
    }
  }

  function checkForm() {
    if (document.form1.charge_id.value=="") {
      alert("请输入费用编码！");
      document.form1.charge_id.focus();
      return false;
    }