sueamendrun.jsp

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

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

--%>
<%@ page language="java" import="com.jspsmart.upload.*,
java.util.Date,
java.util.Locale,
java.text.DateFormat,
java.io.*,
java.sql.*"%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page import="system.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<jsp:useBean id="mySmartUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />

<% mySmartUpload.initialize(pageContext);

  mySmartUpload.upload();
%>
<%

//BEGIN-处理附件传送------------------------------ 	
//copy from WEBOA-AFFICHE.JSP,ADD_SUCCESS.JSP
 
	Date timenow=new Date();
	String accessory[] = new String[9];		//附件字符串
	long timenownum=timenow.getTime();
	DateFormat df = DateFormat.getDateTimeInstance();
	int ii = 0;
	for (ii=0; ii<mySmartUpload.getFiles().getCount();ii++)
	{
  		com.jspsmart.upload.File myFile = mySmartUpload.getFiles().getFile(ii);
  		if (!myFile.isMissing()) 
  		{
  			myFile.saveAs("/upload/" +String.valueOf(timenownum+ii)+"."+myFile.getFileExt() , mySmartUpload.SAVE_VIRTUAL);
		  	accessory[ii]=myFile.getFileName()+";"+String.valueOf(timenownum+ii)+"."+myFile.getFileExt()+";";
		}
	}
//END----------------------------       
//---------------------------------------
//BEGIN---信息保存处理部分
//-----------------------------------------	
       
	String 	caseID = "",				//案件编码
  			caseNo = "",					//案件编号（法院）
  	 		caseReason = "",			//案由
  	 		approveMan = "",			//审批人
  	 		lawyer = "",					//律师
  	 		caseType = "",				//案件类别
  	 		caseAttribute = "",					//案件属性
  	 		agentSide = "",							//委托角色
  	 		customer = "",							//委托人
  	 		referForeign = "",					//涉外信息
  	 		court = "",									//受理法院
  	 		defendantInfo = "",					//被告简介
  	 		plaintiffInfo = "",					//原告简介  	 							
    		beginDate = "",							//收案时间
    		endDate = "",								//结案时间
    		judgeLevel = "",						//审级
    		judgeToCustomerDate = "", 	//判决书递交客户时间
    		charged = "", 							//是否收费
    		noPayReason = "", 					//免费事由
    		proof = "", 								//相关证据
    		courtReport = "", 					//开庭报告
    		discussRecord = "", 				//案情讨论记录
    		courtBook = "", 						//法院文书    		
    		agentWord = "", 						//律师代理词
    		indictment = "", 						//律师起诉状
    		courtNote = "", 						//律师庭审笔录
    		readNote = "", 							//律师阅卷笔录
    		caseBrief = "", 						//办案小结
    		judgeResult = "", 					//判决结果
    		caseRemark = ""; 							//备注
    		    
    caseID = mySmartUpload.getRequest().getParameter("txtCaseID");
    caseNo = mySmartUpload.getRequest().getParameter("txtCaseNo");		//案件编号（法院） 
    caseReason = mySmartUpload.getRequest().getParameter("txtCaseReason");		//案由     
    approveMan = mySmartUpload.getRequest().getParameter("txtApproveMan");			//审批人
  	lawyer = mySmartUpload.getRequest().getParameter("txtLawyer");					//律师
  	caseType = mySmartUpload.getRequest().getParameter("txtCaseType");				//案件类别
  	caseAttribute = mySmartUpload.getRequest().getParameter("txtCaseAttribute");					//案件属性
  	agentSide = mySmartUpload.getRequest().getParameter("txtAgentSide");							//委托角色
  	customer = mySmartUpload.getRequest().getParameter("txtCustomer");							//委托人
  	referForeign = mySmartUpload.getRequest().getParameter("txtReferForeign");					//涉外信息
  	court = mySmartUpload.getRequest().getParameter("txtCourt");									//受理法院 
    defendantInfo = mySmartUpload.getRequest().getParameter("txtDefendantInfo");					//被告简介  
    plaintiffInfo = mySmartUpload.getRequest().getParameter("txtPlaintiffInfo");					//原告简介 
     		 							
    beginDate = mySmartUpload.getRequest().getParameter("txtBeginDate");    	
    endDate = mySmartUpload.getRequest().getParameter("txtEndDate");
    judgeLevel = mySmartUpload.getRequest().getParameter("txtJudgeLevel");						//审级
		judgeToCustomerDate = mySmartUpload.getRequest().getParameter("txtJudgeToCustomerDate"); 	//判决书递交客户时间
   	charged = mySmartUpload.getRequest().getParameter("txtCharged"); 							//是否收费
    noPayReason = mySmartUpload.getRequest().getParameter("txtNoPayReason"); 					//免费事由  
    proof = accessory[0];
    courtReport = accessory[1];				//开庭报告
    discussRecord = accessory[2]; 				//案情讨论记录
    courtBook = accessory[3]; 						//法院文书    		
    agentWord = accessory[4]; 						//律师代理词
    indictment = accessory[5]; 						//律师起诉状
    courtNote = accessory[6]; 						//律师庭审笔录
    readNote = accessory[7]; 							//律师阅卷笔录
    caseBrief = accessory[8]; 						//办案小结
    judgeResult = mySmartUpload.getRequest().getParameter("txtJudgeResult"); 					//判决结果 
    caseRemark = mySmartUpload.getRequest().getParameter("txtCaseRemark"); 							//备注  
    
//处理t_caseinfo数据表的插入记录    
  String sql = "update t_caseinfo set case_reason='"+caseReason;   
  sql = sql + "',case_no='" + caseNo;     
  sql = sql + "',employee_id='" + lawyer;     
  sql = sql + "',customer_id='" + customer;    
  sql = sql + "',approve_man='" + approveMan;  
  sql = sql + "',case_attribute='" + caseAttribute;
  sql = sql + "',refer_foreign='" + referForeign;
  sql = sql + "',begin_date='" + beginDate;
  sql = sql + "',end_date='" + endDate;
  sql = sql + "',charged='" + charged;   
  sql = sql + "',no_pay_reason='" + noPayReason;
  sql = sql + "',case_remark='" + caseRemark;
  sql = sql + "' where case_id='" + caseID + "'";
  int num = 0, num1 = 0;
  num = db.executeUpdate(sql); 
  if(num<=0) { %>  
<script language="javascript">
  	alert("修改失败！");
</script>
  <%}
	
	//-------------------------------
	//update T_SUECASE TABLE CONTENT
  if(num>0)
  {
  	sql = " update t_suecase set ";
  sql = sql + "agent_side='" + agentSide;  
  sql = sql + "',court='" + court;
  sql = sql + "',defendant_info='" + defendantInfo;
  sql = sql + "',plaintiff_info='" + plaintiffInfo;    
  sql = sql + "',judge_level='" + judgeLevel;
  sql = sql + "',judge_to_customer_date='" + judgeToCustomerDate;        
  if((proof != null) && (!proof.equals("")))
  	sql = sql + "',proof='" + proof;      
  if((courtReport != null) && (!courtReport.equals("")))
  	sql = sql + "',court_report='" + courtReport;         
  if((discussRecord != null) && (!discussRecord.equals("")))
  	sql = sql + "',discuss_record='" + discussRecord;
  if((courtBook != null) && (!courtBook.equals("")))
  	sql = sql + "',court_book='" + courtBook;    
  if((agentWord != null) && (!agentWord.equals("")))
  	sql = sql + "',agent_word='" + agentWord;   
  if((indictment != null) && (!indictment.equals("")))
  	sql = sql + "',indictment='" + indictment;   
  if((courtNote != null) && (!courtNote.equals("")))
  	sql = sql + "',court_note='" + courtNote; 
  if((readNote != null) && (!readNote.equals("")))
  	sql = sql + "',read_note='" + readNote;  
  if((caseBrief != null) && (!caseBrief.equals("")))
  	sql = sql + "',case_brief='" + caseBrief;
  sql = sql + "',judge_result='" + judgeResult;
  sql = sql + "' where case_id = '" + caseID + "'";
  	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(mySmartUpload.getRequest().getParameter("txtFileCount"));
	
	for(int i = 1; i <= iFileCount; i++)
	{
		itemID = String.valueOf(i);
 		itemName = mySmartUpload.getRequest().getParameter("txtItemName" + i);
		if((itemName == null) || (itemName.equals(""))) continue;
		beginTime = mySmartUpload.getRequest().getParameter("txtBeginTime" + i);		
		spendTime = mySmartUpload.getRequest().getParameter("txtSpendTime" + i); 
		itemResult = mySmartUpload.getRequest().getParameter("txtItemResult" + 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.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 -------------

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