arbitrationamendrun.jsp

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

<%--
模块名称：仲裁调解
模块功能：修改执行
版    本：V1.0
著 作 人：SIMM
著作日期：2001-11-01
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：
        = = = = = = = = = = = = = = = = = = = = = = = = = =
	修改日期：
	修 改 人：
	修改理由：
	修改出处：
	= = = = = = = = = = = = = = = = = = = = = = = = = =

--%>
<%@ 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---信息保存处理部分
//-----------------------------------------	
                              
//BEGIN-处理附件传送------------------------------ 	
//copy from WEBOA-AFFICHE.JSP,ADD_SUCCESS.JSP
 
	Date timenow=new Date();
	String accessory[] = new String[8];		//附件字符串
	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----------------------------   

//-----------------------------------------
//仲裁信息处理
//-----------------------------------------
 String caseID = "",
    	caseNo = "",
    	caseReason = "",
    	beginDate = "",
    	endDate = "",
    	agentSide = "",          
    	customer = "",
    	lawyer = "",
    	applicant = "",  	//申请人简介
    	appellee = "",  	//被申请人简介
    	arbitrationCourt = "",	//受理仲裁委员会    
    	
    	proof = "",				//相关证据
    	discussRecord = "",		//案情讨论记录
    	notice = "",            //仲裁委通知书   
    	arbitration_judgment = "",     //仲裁委裁决书
    	agent_word = "",        //律师代理词
    	defensive_word = "",    //律师辩护词
    	court_report = "",      //开庭报告
    	accessorys = "",			//附件  
    	caseObject = "",		//标的
    	referForeign = "",
    	charged = "",
    	noPayReason = "";

    caseID = mySmartUpload.getRequest().getParameter("txtCaseID");
    caseNo = mySmartUpload.getRequest().getParameter("txtCaseNo");
    caseReason = mySmartUpload.getRequest().getParameter("txtCaseReason");
    beginDate = mySmartUpload.getRequest().getParameter("txtBeginDate");
    endDate = mySmartUpload.getRequest().getParameter("txtEndDate");
    agentSide = mySmartUpload.getRequest().getParameter("txtAgentSide");  
    customer = mySmartUpload.getRequest().getParameter("txtCustomer");
    lawyer = mySmartUpload.getRequest().getParameter("txtLawyer");
    applicant = mySmartUpload.getRequest().getParameter("txtApplicant");
    appellee = mySmartUpload.getRequest().getParameter("txtAppellee");
    arbitrationCourt = mySmartUpload.getRequest().getParameter("txtArbitrationCourt");
    caseObject = mySmartUpload.getRequest().getParameter("txtCaseObject");
    
    referForeign = mySmartUpload.getRequest().getParameter("txtReferForeign");
    charged = mySmartUpload.getRequest().getParameter("txtCharged");
    noPayReason = mySmartUpload.getRequest().getParameter("txtNoPayReason");
   
    proof = accessory[0];				//相关证据
    discussRecord = accessory[1];		//案情讨论记录
    notice = accessory[2];            	//仲裁委通知书   
    arbitration_judgment = accessory[3];     //仲裁委裁决书
    agent_word = accessory[4];        	//律师代理词
    defensive_word = accessory[5];    	//律师辩护词
    court_report = accessory[6];      	//开庭报告
    accessorys = accessory[7];			//附件   
    
  String sql = "update t_caseinfo set case_no = '" + caseNo;
  sql = sql + "',case_reason='"+caseReason;
  sql = sql + "',begin_date='" + beginDate;    
  if((endDate != null) && (!endDate.equals("")))
  	sql = sql + "',end_date='" + endDate;
  sql = sql + "',customer_id='" + customer;
  sql = sql + "',employee_id='" + lawyer;
  
  sql = sql + "',refer_foreign = '" + referForeign;
  sql = sql + "',charged = '" + charged;
  sql = sql + "',no_pay_reason = '" + noPayReason;
  sql = sql + "' where case_id='" + caseID + "'";	
  
  int num = db.executeUpdate(sql);
  if (num <= 0){%> 
  	<script language=JavaScript> 	
  		alert("修改失败！");    
  	</script>
  <%}
  //-------------------------------
  //update t_arbitratecase TABLE CONTENT
  if (num > 0)
  {
  	sql = " update t_arbitratecase set ";  	  	
    sql = sql + " agent_side='" + agentSide;
    sql = sql + "',applicant_introduce='" + applicant;
    sql = sql + "',appellee_introduce='" + appellee;
    sql = sql + "',arbitration_court='" + arbitrationCourt;
    sql = sql + "',case_object='" + caseObject;
   	if((proof != null) && (!proof.equals("")))
   		sql = sql + "',proof='" + proof;
   	if((discussRecord != null) && (!discussRecord.equals("")))
   		sql = sql + "',discuss_record='" + discussRecord;
   	if((notice != null) && (!notice.equals("")))
   		sql = sql + "',notice='" + notice;
   	if((arbitration_judgment != null) && (!arbitration_judgment.equals("")))
   		sql = sql + "',arbitration_judgment='" + arbitration_judgment;
   	if((agent_word != null) && (!agent_word.equals("")))
   		sql = sql + "',agent_word='" + agent_word;
   	if((defensive_word != null) && (!defensive_word.equals("")))
   		sql = sql + "',defensive_word='" + defensive_word;
   	if((court_report != null) && (!court_report.equals("")))
   		sql = sql + "',court_report='" + court_report;
   	if((accessorys != null) && (!accessorys.equals("")))
   		sql = sql + "',accessory='" + accessorys;
   	sql = sql + "' where case_id = '" + caseID + "'";    
	num = db.executeUpdate(sql);
  }
/**/
  

//---------------------------------------
//END---信息保存处理部分
//-----------------------------------------	 
%>
<html>
<head>
<title>修改d成功</title>
</head>
<body>
  	<script language=JavaScript> 	
  			self.location="Arbitration.jsp"
  	</script>
</body>
</html>