costenteramendrun.jsp

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

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

--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
  String charge_id, charge_sum, case_id, case_reason, part_proportion, case_object;
  String time_limit, charge_type, receive_time, charge_standard, discount;
  String discount_person, charge_person, currency_kind, comment;      
  String charge_name = "", lawyer_id = "";
  charge_id = request.getParameter("charge_id");
  charge_sum = request.getParameter("charge_sum");
  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");
  charge_type = request.getParameter("charge_type");
  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_name = request.getParameter("charge_name");
  charge_name = new String(charge_name.getBytes("ISO8859_1"));
  lawyer_id = request.getParameter("lawyer_id");    
  
  String sql = "update t_charge set charge_sum="+charge_sum;
  if (case_id!=null)
    sql = sql + ",case_id='" + case_id + "'";
  else
    sql = sql + ",case_id=null";
  if (part_proportion!=null)
    sql = sql + ",part_proportion='" + part_proportion + "'";
  else
    sql = sql + ",part_proportion=null";
  if (case_object!=null)
    sql = sql + ",case_object='" + case_object + "'";
  else
    sql = sql + ",case_object=null";
  if ((time_limit!=null) && (!time_limit.equals("")))
    sql = sql + ",time_limit='" + time_limit + "'";
  else
    sql = sql + ",time_limit=null";
  if (charge_type!=null)
    sql = sql + ",charge_type='" + charge_type + "'";
  else
    sql = sql + ",charge_type=null";
  if ((receive_time!=null) && (!receive_time.equals("")))
    sql = sql + ",receive_time='" + receive_time + "'";
  else
    sql = sql + ",receive_time=null";
  if (charge_standard!=null)
    sql = sql + ",charge_standard='" + charge_standard + "'";
  else
    sql = sql + ",charge_standard=null";
  if ((discount!=null) && (!discount.equals("")))
    sql = sql + ",discount='" + discount + "'";
  else
    sql = sql + ",discount=null";
  if (discount_person!=null)
    sql = sql + ",discount_person='" + discount_person + "'";
  else
    sql = sql + ",discount_person=null";
  if (charge_person!=null)
    sql = sql + ",charge_person='" + charge_person + "'";
  else
    sql = sql + ",charge_person=null";
  if (currency_kind!=null)
    sql = sql + ",currency_kind='" + currency_kind + "'";
  else
    sql = sql + ",currency_kind=null";
  if (comment!=null)
    sql = sql + ",comment='" + comment.trim() + "'";
  else
    sql = sql + ",comment=null";             
  if (charge_name!=null)
    sql = sql + ",charge_name='" + charge_name.trim() + "'";
  else
    sql = sql + ",charge_name = null";     
  if (lawyer_id!=null)
    sql = sql + ",employee_id='" + lawyer_id.trim() + "'";
  else 
    sql = sql + ",employee_id = null";
  sql = sql + " where charge_id='" + charge_id + "'";
  int num = db.executeUpdate(sql);
  if (num <= 0) {%>  
<script language="javascript">
  	alert("修改失败！");
</script>
  <%}
%>
<html>
<head>
<title>修改成功</title>
</head>
<body>
<script language="javascript">
  location = "CostEnter.jsp";
</script>
</body>
</html>