filesearchaction.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.util.PageCt;
//import java.text.ParseException;
import com.stsc.archive.manage.*;//----------增加-------------------
//import com.stsc.archive.file.Constants;

public final class filesearchAction 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)
	{
		
      	        
		//----选择文件的SQL语句-----------------------------------------------------------------
		String archivetype=req.getParameter("archivetype");
	        //System.out.println(Iso2Gb(archivetype));		
	        String volumnno=req.getParameter("volumnno");
		 //System.out.println(Iso2Gb(volumnno));      
	        String volumntitle=req.getParameter("volumntitle");
			
	        String code=req.getParameter("code");
	       
			
                String category=req.getParameter("category");
			
	        String retentionperiod=req.getParameter("retentionperiod");
	        System.out.println("retentionperiod的数值是。。。");	
		System.out.println(Iso2Gb(retentionperiod));	
	        String startdate=req.getParameter("startdate");
			
	        String enddate=req.getParameter("enddate");
			
	        String totalnum=req.getParameter("totalnum");
			
	        String totalpage=req.getParameter("totalpage");
			
	        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 sql="";
			
		HttpSession session=req.getSession();
		User userInfo=(User)session.getAttribute(Constants.CURRENT_USER_KEY);//----------增加------------
	        boolean info=userInfo.hasPopedom(4);//--------增加-------------------
	        boolean info1=userInfo.hasPopedom(5);//-----------增加------------------------
			 boolean info2=userInfo.hasPopedom(6);//
			
	      // if(archivetype.equals("")  && volumnno.equals("")  && volumntitle.equals("")  && code.equals("") == true && category.equals("") == true && retentionperiod.equals("") == true && startdate.equals("") == true && enddate.equals("") == true && totalnum.equals("") == true && totalpage.equals("") == true && duty.equals("") == true && security.equals("") == true && archiveunit.equals("") == true && remark.equals("") == true && status.equals("") == true)
	        // {  

		sql="SELECT * FROM fVolumn where Deleted<>'1'";
		if(info2){
			sql="SELECT * FROM fVolumn where Deleted in('1','0')";   
		}
	           //}
	       //else{
			//     sql="SELECT * FROM fVolumn where Deleted<>'1'";
	       //       if(info2){
			//		 sql="SELECT * FROM fVolumn where Deleted in('1','0')";   
			//	}
	        //   }
	        //System.out.println(sql);
	        //-------改过-------------
	        
	         if(security!=null && !security.equals(""))
	        { 
	        	sql+="AND Security='" + Iso2Gb(security)+"'";
	        }
	        else{
	                if(info==false && info1==false)
	                {
	                	sql+="And Security='普通'";
	                }
	                else if(info==true && info1==false)
	                {
	                	sql+="And Security<>'机密'";
	                }
	        }//----------------改完---------------------
	        
	        if(archivetype!=null && archivetype.equals("") == false)
	        {
	        	sql+="And ArchiveType='" + Iso2Gb(archivetype) +"'";
	        }
	        	        
	         if(volumnno!=null && volumnno.equals("") == false)
	        { 
	        	sql+="And VolumnNo='" + Iso2Gb(volumnno)+"'";
	        }
	       
	        if( volumntitle!=null && volumntitle.equals("") == false)
	        { 
	        	sql+="And VolumnTitle='" + Iso2Gb(volumntitle)+"'";
	        }
	        
	        if(code!=null && code.equals("") == false)
	        { 
	        	sql+="And Code='" + Iso2Gb(code)+"'";
	        }
	        
	        if(category!=null && category.equals("") == false)
	        { 
	        	sql+="And Category='" + Iso2Gb(category)+"'";
	        }
	        
	        if(retentionperiod!=null && retentionperiod.equals("") == false)
	        { 
	        	sql+="And RetentionPeriod='" + Iso2Gb(retentionperiod)+"'";
	        }
	        
	        if(startdate!=null && startdate.equals("") == false)
	        { 
	        	sql+="And StartDate=cdate('" + Iso2Gb(startdate)+"')";
	        }
	        
	        if(enddate!=null && enddate.equals("") == false)
	        { 
	        	sql+="And EndDate=cdate('" + Iso2Gb(enddate)+"')";
	        }
	        
	        if(totalnum!=null && totalnum.equals("") == false)
	        { 
	        	
	        	sql+="And TotalNum=" + Integer.parseInt(totalnum);
	        }
	        
	        if(totalpage!=null && totalpage.equals("") == false)
	        { 
	        	
	        	sql+="And TotalPage=" + Integer.parseInt(totalpage);
	        }
	       
	        if(duty!=null && duty.equals("") == false)
	        { 
	        	sql+="And Duty='" + Iso2Gb(duty)+"'";
	        }
	        
	       
	        
	        if(archiveunit!=null && archiveunit.equals("") == false)
	        { 
	        	sql+="And ArchiveUnit='" + Iso2Gb(archiveunit)+"'";
	        }
	       
	        if(remark!=null && remark.equals("") == false)
	        { 
	        	sql+="And Remark='" + Iso2Gb(remark)+"'";
	        }
	        
	        if(status!=null && status.equals("") == false)
	        { 
	        	sql+="And Status='" + Iso2Gb(status)+"'";
	        }
	       
		//------------------------------------------------------------------------
		System.out.println(sql);
		Properties dbBase= new Properties();
		dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
		STPoolDataSet data=new STPoolDataSet();
		
		//2003-05-28 add by liqf
		//将查询所用sql置入session
		//第一次进入，未翻页之前
		String currentpage=(String)req.getParameter("currentpage");
		if(currentpage==null || currentpage.equals("") || currentpage.equals("null")){
			session.setAttribute("searchsql_volnumn",sql);
		}
		if(currentpage!=null && !currentpage.equals("") && !currentpage.equals("null")){
			sql=(String)session.getAttribute("searchsql_volnumn");
		}

		STResultSet rs=data.getSTResult(sql,dbBase);
		//------------数据类型的转化还没进行
		SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM");
		String startdate2=null;
		String enddate2=null;
		//-------------------------------------增加---------
		String[] volumnid1=new String[rs.getRecCount()];
		System.out.println(rs.getRecCount());
		int i=0;                              
		String[] m=new String[rs.getRecCount()];

		STResultSet ns=data.getSTResult(sql,dbBase);
		while(ns!=null && ns.next()){
			volumnid1[i]=Integer.toString(ns.getInt("VolumnID"));
			i++;
		}
		//FileKindList shore=new FileKindList();
		//System.out.println("怎么回事");

		//STResultSet rs=data.getSTResult(sql,dbBase);
      	//SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM");
      	//String startdate2=null;
      	//String enddate2=null;
		FileKindList shore=new FileKindList();

		//2003-06-07 add by liqf
		 //增加分页处理
		// STResultSet rs=data.getSTResult(sql1,dbBase);
			long data_num=rs.getRecCount();
			//System.out.println("data_num====="+data_num);
			long Current_Page = 0;
			PageCt PageCt=new PageCt();
			
			if (currentpage != null && !currentpage.equals("") && !currentpage.equals(""))
			{
			  Current_Page = Integer.parseInt(req.getParameter("currentpage"));

			}
			String Query_Page=(String)req.getParameter("Query_Page");
			if (Query_Page!=null && !Query_Page.equals(""))
			{
			  Current_Page = Integer.parseInt(req.getParameter("Query_Page"))-1;
			}
			PageCt.Init(Current_Page,data_num,session);
			long l_start = PageCt.getStart();
			//System.out.println("l_start==================="+l_start);
			long l_end = PageCt.getEnd();
			//System.out.println("l_end==================="+l_end);
			long i1=0;
			//System.out.println("PageCt==================="+PageCt.getTotalnum());
			while((i1<l_start) && rs.next())
			{
				  i1++;
			}  
			//输出查询结果
			long j=0;
		while(rs!=null && rs.next() && (i1<l_end))
		{ 
			  j=i1+1;
			
			FileKind filename=new FileKind();
			
			filename.setarchivetype(rs.getString("ArchiveType"));
			
		        filename.setvolumnno(rs.getString("VolumnNo"));
		        //System.out.println(rs.getString("VolumnNo"));
			filename.setvolumntitle(rs.getString("VolumnTitle"));
			
			filename.setcode(rs.getString("Code"));
			
			filename.setcategory(rs.getString("Category"));
			
			filename.setretentionperiod(rs.getString("RetentionPeriod"));
			
		       // System.out.println(rs.getDate("StartDate"));
		        //System.out.println(rs.getDate("EndDate"));
		        
		       //if((rs.getDate("StartDate").equals("")==true||rs.getDate("StartDate")==null) &&(rs.getDate("EndDate").equals("")==true||rs.getDate("EndDate")==null))
		      if(rs.getDate("StartDate")==null && rs.getDate("EndDate")==null)
		       {
		       	        //startdate2="0";
		       	        //enddate2="0";
		       	        // System.out.println("进入if语句");
		       	}
		       
		         //else if((rs.getDate("StartDate"))==null||(rs.getDate("StartDate")).equals("")==true)
		         else if(rs.getDate("StartDate")==null && rs.getDate("EndDate")!=null)
		         {
		         	//startdate2="0";
		         	 enddate2=sdf.format(rs.getDate("EndDate"));
		         	 //System.out.println("进入else if语句");
		         }
		        
		         //else if((rs.getDate("EndDate"))==null||(rs.getDate("EndDate")).equals("")==true)
		         else if(rs.getDate("EndDate")==null && rs.getDate("StartDate")!=null)
		         {
		         	//enddate2="0";
		         	startdate2=sdf.format(rs.getDate("StartDate"));
		         	//System.out.println("进入else if语句");
		         }
		         
		        else
		        {
			 startdate2=sdf.format(rs.getDate("StartDate"));
			 enddate2=sdf.format(rs.getDate("EndDate"));
			// System.out.println(rs.getDate("StartDate"));
			}
		       //System.out.println("进入if后一步语句");
		
			filename.setstartdate(startdate2);
			
			filename.setenddate(enddate2);
			 
			filename.settotalnum(Integer.toString(rs.getInt("TotalNum")));
			//System.out.println("filename.getdeleted()");
			filename.settotalpage(Integer.toString(rs.getInt("TotalPage")));
			
			filename.setduty(rs.getString("Duty"));
			
			filename.setsecurity(rs.getString("Security"));
			
			filename.setarchiveunit(rs.getString("ArchiveUnit"));
			
			filename.setremark(rs.getString("Remark"));
			
			filename.setstatus(rs.getString("Status"));
			
			filename.setvolumnid(rs.getInt("VolumnID"));
			
			filename.setdeleted(rs.getString("Deleted"));
		       
			shore.addFileName(filename);
			i1++;
		}
		//System.out.println("出了while语句");
		//HttpSession session=req.getSession();
		//2003-06-07 add by liqf
		//增加分页处理
		session.setAttribute("PageCt_volumn", PageCt);
		session.setAttribute("myhashtable",shore);
		session.setAttribute("my",sql);
		session.setAttribute("save",volumnid1);//---------------增加---------------------
		session.setAttribute("index",Integer.toString(i));//-------------增加-----------------
		
		
		System.out.println("出了filesearchAction.java 123");
		return mapping.findForward("success");
	}
}