editsaveaction.java

一套完整的档案管理系统

package com.stsc.archive.second;

import javax.servlet.http.*;
import org.apache.struts.action.*;
import java.util.Properties;

import org.apache.struts.util.MessageResources;
import com.stsc.util.STPoolDataSet;
import com.stsc.util.STResultSet;
import java.util.Date;
import java.text.SimpleDateFormat;

import com.stsc.archive.manage.*;
//import com.stsc.archive.manage.Constants;
import com.stsc.archive.file.Archive;

public final class editsaveAction extends Action
{
	/*
	public String Iso2Gb(String str)
     {
           String ret=(str==null) ? "" : str;
         try
        {
         byte[] byteStr=str.getBytes("ISO-8859-1");
         return new String(byteStr,"gb2312");
        }
         catch(Exception e)
       {
         return ret;
       }
      }*/
      public ActionForward perform(ActionMapping mapping,ActionForm form,
             HttpServletRequest req,HttpServletResponse res)
      {
      	 translate m=new translate();
      	 String archivetype=req.getParameter("archivetype");
      	
     String volumnno=req.getParameter("volumnno");
	 String volumntitle=req.getParameter("volumntitle");
	 String code=req.getParameter("code");
	 
	 String category=req.getParameter("category");
	 String retentionperiod=req.getParameter("retentionperiod");
	 String startdate=req.getParameter("startdate");
	 String enddate=req.getParameter("enddate");
	 //String totalnum=req.getParameter("totalnum");
	 String totalnum=((fileinfoForm)form).gettotalnum();
	 //String totalpage=req.getParameter("totalpage");
	 String totalpage=((fileinfoForm)form).gettotalpage();
	 String duty=req.getParameter("duty");
	 String security=req.getParameter("security");
	 String archiveunit=req.getParameter("archiveunit");
	 String remark=req.getParameter("remark");
	
	 String status=req.getParameter("status");
	 String volumnid2=req.getParameter("volumnid");

	 //2003-05-29 add by liqf
	 String volumnno_old=req.getParameter("volumnno_old");
	  System.out.println("volumnno_old==================="+volumnno_old);
	   
	  if(code.length()<4)
	 {
	 	for(int i=0;i<4;i++)
	 	{
	 		if(code.length()<4)
	 		{
	 			code="0"+code;
	 			System.out.println(code);
	 		}
	 	}
	 }
	 int volumnid=Integer.parseInt(volumnid2);
	 
	 
	 Properties dbBase= new Properties();
	 dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
	 
	 STPoolDataSet data= new STPoolDataSet();
	 String sql=null;
	
	   	  sql="UPDATE fVolumn SET ArchiveType='" ;
		  sql+= m.Iso2Gb(archivetype)+"',VolumnNo='"+m.Iso2Gb(volumnno)+"',";
		  sql+="VolumnTitle='"+m.Iso2Gb(volumntitle)+"',Code='"+m.Iso2Gb(code)+"',";
		  sql+="Category='"+m.Iso2Gb(category)+"',RetentionPeriod='"+m.Iso2Gb(retentionperiod)+"'";
		  sql+=",TotalNum="+Integer.parseInt(totalnum)+",TotalPage="+Integer.parseInt(totalpage)+",";
		  sql+="Duty='"+m.Iso2Gb(duty)+"',Security='"+m.Iso2Gb(security)+"'";
		  sql+=",ArchiveUnit='"+m.Iso2Gb(archiveunit)+"',Remark='"+m.Iso2Gb(remark)+"',";
		  
	if(startdate!=null && !startdate.equals("") && !startdate.equals("null"))
	 {
		 sql+= "StartDate=cdate('"+m.Iso2Gb(startdate)+"'),";
	}  
	if(startdate!=null && !startdate.equals("") && !startdate.equals("null")){
		sql+= "EndDate=cdate('"+m.Iso2Gb(enddate)+"'),";
	}
	sql+="Status='"+m.Iso2Gb(status)+"'";
	sql+="WHERE VolumnID="+volumnid;
	 data.executeSQL(sql,dbBase);

	HttpSession session=req.getSession();
	 String index1=(String)session.getAttribute("index");//--------增加----------------
	 int index=Integer.parseInt(index1);//-----------增加-------------------
	 System.out.println(index);
	 String[] volumnid1=(String[])session.getAttribute("save");//-----------增加------------------
	 System.out.println(volumnid1);
	 int[] volumnid3=new int[index];//--------------增加----------------------------
	 String series="";//---------------增加-----------------------------
	 String enddate2="";
	 String startdate2="";
	 System.out.println("startdate2");
	 //------------------增加-----------------------------
	 for(int i=0;i<index;i++)
	 {
	 	volumnid3[i]=Integer.parseInt(volumnid1[i]);
	 }
	 for(int i=0;i<index;i++)
	 {
	    if(i==index-1)
	    {
	    	
	    	series+=volumnid3[i];
	    }
	    else{
	    series+=volumnid3[i] + ",";
	    }
	 }

	 //2003-06-06 add
	 User userInfo=(User)session.getAttribute(Constants.CURRENT_USER_KEY);
	boolean info2=userInfo.hasPopedom(6);
	String sql1="";
	if(info2){
		 sql1="SELECT * FROM fVolumn where Deleted in('1','0')";   
	}else{
	
		sql1="SELECT * FROM fVolumn WHERE VolumnID IN (" + series + ") AND Deleted<>'1'";
	 }
	 
	
	 System.out.println(sql1);
	// STResultSet rs1=data.getSTResult(sql1,dbBase);
	 STResultSet rs1=data.getSTResult(sql1,dbBase);//--------------改过---------------------
	 SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM");
	 //-----------rs都改成rs1---------------------------

	 //2003-05-29 add by liqf,
	//更新文件表中与案卷有关的信息
		String sql2="UPDATE  fArchive SET volumnno ='"+ m.Iso2Gb(volumnno)+"',code='"+ m.Iso2Gb(code)+"',";
		sql2+=" archivetype='"+ m.Iso2Gb(archivetype)+"',retentionperiod='"+ m.Iso2Gb(retentionperiod)+"',category='"+ m.Iso2Gb(category)+"',";
		sql2+=" securityclass='"+ m.Iso2Gb(security)+"' where volumnno='"+m.Iso2Gb(volumnno_old)+"'";
		data.executeSQL(sql2,dbBase);
		//2003-05-26 add by liqf
		//进行文件日志操作
		//User userInfo = (User)(session.getAttribute(Constants.CURRENT_USER_KEY));
		String entername=userInfo.getEnterName();
		SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
		String handletime = sdf1.format(new java.util.Date());
		String username=userInfo.getUserName();
		String handlecontent="编辑原案卷号为"+m.Iso2Gb(volumnno_old)+"的文件数据,案卷数据信息.";
		if(!volumnno_old.equals(volumnno)){
			handlecontent=handlecontent+"并将案卷号改为"+volumnno;
			 System.out.println(handlecontent);
		}
		Archive archive=new Archive();
		//2003-05-28 add by liqf
		//加入操作日志
		archive.setEntername(entername);
        archive.setHandletime(handletime);
        archive.setUsername(username);
        archive.setHandlecontent(handlecontent);
		
		archive.writeLog(volumnno_old,dbBase);


	 FileKindList shore=new FileKindList();
	 while(rs1!=null && rs1.next())
		{ 
			
			FileKind filename=new FileKind();
			filename.setarchivetype(rs1.getString("ArchiveType"));
			filename.setvolumnno(rs1.getString("VolumnNo"));
		        System.out.println(rs1.getString("VolumnNo"));
			filename.setvolumntitle(rs1.getString("VolumnTitle"));
			
			filename.setcode(rs1.getString("Code"));
			
			filename.setcategory(rs1.getString("Category"));
			
			filename.setretentionperiod(rs1.getString("RetentionPeriod"));
			
		       // System.out.println(rs1.getDate("StartDate"));
		        //System.out.println(rs1.getDate("EndDate"));
		        
		      if(rs1.getDate("StartDate")==null && rs1.getDate("EndDate")==null)
		       {
		       	       // startdate2="0";
		       	        //enddate2="0";
		       	         System.out.println("进入if语句");
		       	}
		       
		         else if(rs1.getDate("StartDate")==null && rs1.getDate("EndDate")!=null)
		         {
		         	//startdate2="0";
		         	 enddate2=sdf.format(rs1.getDate("EndDate"));
		         	 //System.out.println("进入else if语句");
		         }
		        
		         else if(rs1.getDate("EndDate")==null && rs1.getDate("StartDate")!=null)
		         {
		         	//enddate2="0";
		         	startdate2=sdf.format(rs1.getDate("StartDate"));
		         	//System.out.println("进入else if语句");
		         }
		         
		        else
		        {
			 startdate2=sdf.format(rs1.getDate("StartDate"));
			 enddate2=sdf.format(rs1.getDate("EndDate"));
			 //System.out.println(rs1.getDate("StartDate"));
			}
		       //System.out.println("进入if后一步语句");
		
			filename.setstartdate(startdate2);
			
			filename.setenddate(enddate2);
			 
			filename.settotalnum(Integer.toString(rs1.getInt("TotalNum")));
			//System.out.println("filename.getdeleted()");
			filename.settotalpage(Integer.toString(rs1.getInt("TotalPage")));
			
			filename.setduty(rs1.getString("Duty"));
			
			filename.setsecurity(rs1.getString("Security"));
			
			filename.setarchiveunit(rs1.getString("ArchiveUnit"));
			
			filename.setremark(rs1.getString("Remark"));
			
			filename.setstatus(rs1.getString("Status"));
			
			filename.setvolumnid(rs1.getInt("VolumnID"));
			
			filename.setdeleted(rs1.getString("Deleted"));
			
		       
			shore.addFileName(filename);
			
			
		}
		//System.out.println("出了while语句");
		
		session.setAttribute("myhashtable",shore);
	 //----------
				
      	System.out.println("出了editsaveAction.java 123");
	 return mapping.findForward("success");//------------------success改过了-------------------
      }
}