advisoramendrun.jsp

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

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

--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
  
//---------------------------------------
//BEGIN---信息保存处理部分
//-----------------------------------------	


  String caseID, caseReason,mainContent,lawyer,beginDate,endDate,opinion,customer;
  
  caseID = request.getParameter("txtCaseID");
  caseReason = request.getParameter("txtCaseReason");
  //中文处理
  caseReason = new String(caseReason.getBytes("ISO8859_1"));
  lawyer = request.getParameter("txtLawyer");  
  beginDate = request.getParameter("txtBeginDate");
  endDate = request.getParameter("txtEndDate");
  opinion = request.getParameter("txtOpinion");
  opinion = new String(opinion.getBytes("ISO8859_1"));
  mainContent = request.getParameter("txtMainContent");
  mainContent = new String(mainContent.getBytes("ISO8859_1"));    
  customer = request.getParameter("txtCustomer");
  
  String sql = "update t_caseinfo set case_reason='"+caseReason+"'";
  
  sql = sql + ",employee_id='" + lawyer + "'";      
  sql = sql + ",customer_id='" + customer + "'";
  
  if (beginDate!=null)
    sql = sql + ",begin_date='" + beginDate + "'";
  else
    sql = sql + ",begin_date=null";
    
  if (endDate!=null)
    sql = sql + ",end_date='" + endDate + "'";
  else
    sql = sql + ",end_date=null";

  sql = sql + " where case_id='" + caseID + "'";
	
	
  int num = 0;             
  int num1 = 0;
  num = db.executeUpdate(sql);
	
	//-------------------------------
	//update T_NONCOURT TABLE CONTENT
  /**/
  if (num > 0)
  {
  	sql = "delete from t_noncourt where case_id = '";
  	sql = sql + caseID + "'";
  	num1 = db.executeUpdate(sql);
  	if(num1 > 0)		//删除成功
  	{
  		sql = " insert into t_noncourt(case_id";
    	sql = sql + ",main_content";
    	sql = sql + ",opinion_to_customer";
    	sql = sql + ") values('" + caseID;
  		sql = sql + "','" + mainContent;    		
    	sql = sql + "','" + opinion;
    	sql = sql + "')";  
  		num1 = db.executeUpdate(sql);
        
    }  	
  }
  
  
//---------------------------------------
//END---信息保存处理部分
//-----------------------------------------	 

//-------------------------------
//BEGIN---律师"事务"处理部分	
//
  //事务处理的内容
  if(num > 0)
  {
	String itemID = "",		//事务编号
		itemName = "",		//事务名称
		beginTime = "",		//开始时间
		spendTime = "",	//花费工时
		itemResult = "";		//处理结果
	int iFileCount = 0;
	//先删除原来的记录,然后重新写入内容
	sql = "delete from t_caseafair where case_id='" + caseID + "'";	
	num1 = db.executeUpdate(sql);
	//写入新内容
	iFileCount = Integer.parseInt(request.getParameter("txtFileCount"));
	
	for(int i = 1; i <= iFileCount; i++)
	{
		itemID = String.valueOf(i);
 		itemName = request.getParameter("txtItemName" + i);
		if((itemName == null) || (itemName.equals(""))) continue;
		itemName = new String(itemName.getBytes("ISO8859_1"));
		beginTime = request.getParameter("txtBeginTime" + i);		
		spendTime = request.getParameter("txtSpendTime" + i); 
		spendTime = new String(spendTime.getBytes("ISO8859_1"));
		itemResult = request.getParameter("txtItemResult" + i);
		if(itemResult != null) itemResult = new String(itemResult.getBytes("ISO8859_1"));
		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.equals("") || (beginTime == null))
		sql = "insert into t_caseafair(case_id,item_id,item_name,spend_time,item_result)" +
			  " values('" + caseID +
			  "','" + itemID +
			  "','" + itemName +
			  "','" + spendTime +
			  "','" + itemResult + "')";
   		num1 = db.executeUpdate(sql);
  	}	//for()
  } 	//if()
//END -------------     

//BEGIN---合同费用修改处理     
//暂时确定不支持该功能 2001-11-21 by SIMM

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

  String  charge_sum, part_proportion, case_object;
  String time_limit, 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");
  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 = "update t_charge set charge_sum="+charge_sum;
  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 ((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";             
  sql = sql + " where charge_id='" + charge_id + "'";
  num1 = db.executeUpdate(sql);
} 
*/

//END -------------     

  		if (num <= 0)           
  		{
%>  		
  		<script language=JavaScript> 	
  			alert("修改失败！");
  			self.location="Advisor.jsp"
  		</script>
<%		}else 
		{             
%>  		
  		<script language=JavaScript> 	
  			alert("修改成功！");
  			self.location="Advisor.jsp"
  		</script>
<%      }%>
<html>
<head>
<title>修改成功</title>
</head>
<body>
</body>
</html>