otheramendrun.jsp

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

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

--%>
<%@ 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---信息保存处理部分
//-----------------------------------------	


  String caseID = "",
  	caseReason = "",
  	beginDate = "",
  	lawyer = "",
  	mainContent = "",
  	referForeign = "",
  	charged = "",
  	noPayReason = "",
  	customer = "";
  int num = 0;       
  
    caseID = mySmartUpload.getRequest().getParameter("txtCaseID");
    caseReason = mySmartUpload.getRequest().getParameter("txtCaseReason");
    beginDate = mySmartUpload.getRequest().getParameter("txtBeginDate");
    lawyer = mySmartUpload.getRequest().getParameter("txtLawyer");
    mainContent = mySmartUpload.getRequest().getParameter("txtMainContent");
    referForeign = mySmartUpload.getRequest().getParameter("txtReferForeign");
    charged = mySmartUpload.getRequest().getParameter("txtCharged");
    noPayReason = mySmartUpload.getRequest().getParameter("txtNoPayReason");
    customer = mySmartUpload.getRequest().getParameter("txtCustomer");

//BEGIN-处理附件传送------------------------------ 	
//copy from WEBOA-AFFICHE.JSP,ADD_SUCCESS.JSP

	Date timenow=new Date();
	String accessory = "";		//附件字符串
	long timenownum=timenow.getTime();
		
	DateFormat df = DateFormat.getDateTimeInstance();
	
	for (int i=0; i<mySmartUpload.getFiles().getCount();i++)
	{
  		com.jspsmart.upload.File myFile = mySmartUpload.getFiles().getFile(i);
  		if (!myFile.isMissing()) 
  		{
  			myFile.saveAs("/upload/" +String.valueOf(timenownum+i)+"."+myFile.getFileExt() , mySmartUpload.SAVE_VIRTUAL);
		  	accessory=accessory+myFile.getFileName()+";"+String.valueOf(timenownum+i)+"."+myFile.getFileExt()+";";
  		}
	}	
	
	//删除附件选择
	String[] delfiles=mySmartUpload.getRequest().getParameterValues("delfiles");
	String Accessory=mySmartUpload.getRequest().getParameter("Accessory");    //从TEXT框获取内容
	
	String newallfilename="";
	String oddstring="";
	int isin=0;
	int temp=0;
	if(delfiles!=null)
	{                      
		ExtendString es1 = new ExtendString();
		String[] pk=new String[10];
        pk= es1.Split(";" ,Accessory);
        
		for(int i=0;i<(es1.length-1);i++)
		{
			if((i%2)==0)
			{
				isin=0;
				temp=(i/2);
				for(int j=0;j<delfiles.length;j++)
				{
					if((Integer.valueOf(delfiles[j])).intValue()==temp){isin=1;};
				}
				if(isin==0)
				{
                	oddstring=oddstring+pk[i]+";"+pk[i+1]+";";
                }
                else
                {
                	java.io.File filetodel=new java.io.File("./affiche/upload",pk[i+1]);
                    filetodel.delete();
                }
			}
		}
	}
	else	oddstring = Accessory;     

	newallfilename=oddstring+accessory;
          
//END----------------------------  
  String sql = "update t_caseinfo set case_reason='"+caseReason;
  sql = sql + "',begin_date='" + beginDate;
  sql = sql + "',employee_id='" + lawyer;
  sql = sql + "',refer_foreign = '" + referForeign;
  sql = sql + "',charged = '" + charged;
  sql = sql + "',no_pay_reason = '" + noPayReason;
  sql = sql + "',customer_id='" + customer;
  sql = sql + "' where case_id='" + caseID + "'";	
  num = db.executeUpdate(sql);        
//-------------------------------
//update T_NONCOURT TABLE CONTENT
  if (num > 0)
  {
  	sql = " update t_noncourt set ";  	
    sql = sql + " main_content='" + mainContent;
    sql = sql + "',accessory='" + newallfilename;
   	sql = sql + "' where case_id = '" + caseID + "'"; 
	num = db.executeUpdate(sql);
  }

//---------------------------------------
//END---信息保存处理部分
//-----------------------------------------	 
  if(num <= 0){%>
<script language="JavaScript">    
	alert("修改失败！");
</script>
 <%}%>
<script language="JavaScript">   
    location="Other.jsp";
</script>
<html>
<head>
<title>修改d成功</title>
</head>
</html>