c454controller.java

使用spring ,hibernate 框架的稽查管理系统

 package com.je.ims.controller.c454;

import java.util.Date;
import java.util.HashMap;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;
import java.util.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.Controller;

import com.chttl.im.organization.Person;
import com.je.ims.dao.*;
import com.je.ims.dao.C851RoleDao;
import com.je.ims.hibernate.*;
import com.je.ims.hibernate.RoleId;
import com.je.ims.util.DateTimeFormat;
import com.je.ims.util.DbLogDAO;
import com.je.ims.util.MenuUtils;
import com.je.ims.util.Page;

public class C454Controller implements Controller {

	private C454DAO dao;
	private DbLogDAO dbLogDao;
	Person personMe = new Person();
	
	private String errorMsg=null;
	private String link="/auditsystem/c454.do";
	private Map errModel=new HashMap();
	DateTimeFormat format=new DateTimeFormat();
	
	private C851RoleDao roleTypeDao;
	public void setRoleTypeDao(C851RoleDao u){
        roleTypeDao=u;
    }
    public C851RoleDao getRoleTypeDAO(){
        return roleTypeDao;
    }
	public void setDao(C454DAO dao) {
		this.dao = dao;
	}
	public C454DAO getDao(C454DAO dao){
		return dao;
	}
	public DbLogDAO getDbLogDao() {
		return dbLogDao;
	}
	public void setDbLogDao(DbLogDAO dbLogDao) {
		this.dbLogDao = dbLogDao;
	}
	public Person getPersonMe() {
		return personMe;
	}
	public void setPersonMe(Person personMe) {
		this.personMe= personMe;
	}	
	public ModelAndView handleRequest(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		Page p = new Page();
		int pageSize = p.getPageSize(); // 每页显示的记录数
		int count = p.getCount(); // 每次增加的页数
		int size;	
		String actionType = request.getParameter("actionType");
		String pageNo = request.getParameter("pageNo");
		String indexStr = request.getParameter("index");
		
		HttpSession session = request.getSession(); 
		personMe = (Person) session.getAttribute("person");
	    if( (personMe==null) || (personMe.getUserID()== null) )
	    {
	        response.sendRedirect("../../auditsystem/login.jsp");
	        return null;
	    }
	   LinkedList list=(LinkedList)session.getAttribute("menu");
	   int right=MenuUtils.getMenuRight(list,"c454.do");
	   session.setAttribute("/view/c_4.5.4SelletY.jsp",new Integer(right));
	   session.setAttribute("/view/c_4.5.4SelletY2.jsp",new Integer(right));
	     //RoleId id=MenuUtils.getRole(list,"c454.do");
	   List roleList=MenuUtils.getRole(list,"c454.do");
	   RoleId id=(RoleId)roleList.get(0);

	     String roleid=id.getRoleId();
	     Long roletypeid=id.getRoleTypeId();
		// TODO Auto-generated method stub
	     
	     if(actionType!=null){
	    	 if(actionType.equals("add")){
	    	//this.addData(request);
	    		 dao.saveAdviceDetails();
	    	 }else if(actionType.equals("query")){
	    		 return this.showQueryResult(1,1,request);
	    	 }else if(actionType.equals("pre_add")){
	    		 return new ModelAndView("c_4.5.4add.jsp");
	    	 }else if(actionType.equals("showDetail")){
	    		 return this.showDetail(request);
	    	 }
	     }
		return new ModelAndView("c_4.5.4SelletY2.jsp");
	}
	
	
	public ModelAndView addData(HttpServletRequest request){
		Long year=new Long(2006);
		Long month=new Long(1);
		Date fillDate=new Date();
		String editorName=new String("Eric");
		String editorId=new String("123");
		String editorDn=new String("軟件學院");
		String viseDirectorName=new String("劉");
		String viseDirectorId=new String("345");
		String viseDirectorDn=new String("縂公司");
		dao.savePraetorAdvice(year,month,fillDate,editorName,editorId,editorDn,viseDirectorName,viseDirectorId,viseDirectorDn);
		
		return null;
	}
	
	public ModelAndView  showQueryResult(int pageNo, int index,HttpServletRequest request){
		int[] array;
		PraetorAdvice[] praetorAdvice;
		PraetorAdviceDateReflection[] padf;
		Map model = new HashMap();
		Integer indexInteger = new Integer(index);
		List list = null;
		String year = null, month = null;//, date1 = null, date2 = null;
		try {

			year = new String(request.getParameter("year").getBytes(
					"ISO-8859-1"), "MS950").trim();
			month = new String(request.getParameter("month").getBytes(
					"ISO-8859-1"), "MS950").trim();
		} catch (Exception e) {

		}
			if (year == null)
				year = "";
			if (month == null)
				month = "";
			//if (date1 == null)
			//	date1 ="";     
			list = dao.queryPraetorAdvice(year,month);//, date1, date2);
		
       try{
		Page page = new Page(pageNo, index, list.size());

		int indexCount = page.getIndexCount();
		Integer indexCountInt = new Integer(indexCount);
		praetorAdvice = new PraetorAdvice[page.getAvaCount()];
		padf=new PraetorAdviceDateReflection[page.getAvaCount()];
		for(int i=0;i<page.getAvaCount();i++){
			padf[i]=new PraetorAdviceDateReflection();
		}
		praetorAdvice = (PraetorAdvice[]) page.getObj(dao,list);
		for(int i=0;i<page.getAvaCount();i++){
			padf[i].setPraetorAdviceId(praetorAdvice[i].getPraetorAdviceId());
			padf[i].setFileId(praetorAdvice[i].getFileId());
			padf[i].setTitle(praetorAdvice[i].getTitle());
			padf[i].setEditState(praetorAdvice[i].getEditState());
			padf[i].setFillDate(format.format(praetorAdvice[i].getFillDate()));
			padf[i].setEditorName(praetorAdvice[i].getEditorName());
			
		}
		
		array = new int[page.getArray().length];
		array = page.getArray();
		Integer length=new Integer(padf.length);
		//Integer length = new Integer(5);
		//if(bul.length>0)
		// {
		model.put("padf", padf);
		model.put("array", array);
		model.put("index", indexInteger);
		model.put("indexCount", indexCountInt);
		model.put("length", length);
		model.put("year", year);
		model.put("month", month);
		//model.put("date1", date1);
		//model.put("date2", date2);
		model.put("pageNo",new Integer(pageNo));
		// }
		model.put("size", new Integer(list.size()));
		return new ModelAndView("c_4.5.4superiorreport.jsp", model);
       }catch(Exception e){
    	    errorMsg="沒有查找到相關記錄！";
        	errModel.put("errorMessage",errorMsg);
        	errModel.put("link",link);
        	return new ModelAndView("error.jsp",errModel);
       }
	}
	
	public ModelAndView showDetail(HttpServletRequest request){
		String sid=null;

		try{
			sid = new String(request.getParameter("id").getBytes(
			"ISO-8859-1"), "MS950").trim();
		}catch(Exception e){}
		
		PraetorAdvice praetorAdvice=dao.getPraetorAdvice(sid);
		Long yearL=praetorAdvice.getYear();
		long myear=yearL.longValue()-1911; 
		
		String fillDate=null;
		try{
			fillDate=format.format(praetorAdvice.getFillDate());
		}catch(Exception e){}
		
		Map model=new HashMap();
		model.put("pa",praetorAdvice);
		model.put("year",new Long(myear));
		model.put("fillDate",fillDate);
		
		//獲取長官意見信息
		List adviceDetailsList=new ArrayList();
		List praetorNameList=dao.getPraetorName(new Long(sid));
		//List adviceTitleList=dao.getAdviceTitle(new Long(sid));
		String praetorName=null;
		String adviceTitle=null;
		for(int i=0;i<praetorNameList.size();i++){
			praetorName=(String)praetorNameList.get(i);
			List adviceTitleList=dao.getAdviceTitle(new Long(sid),praetorName);
			for(int j=0;j<adviceTitleList.size();j++){
				adviceTitle=(String)adviceTitleList.get(j);
				List dealConditionList=dao.getDealConditions(new Long(sid),praetorName,adviceTitle);
				List dealConditionL=new ArrayList();
				//獲取辦理情形
				for(int k=0;k<dealConditionList.size();k++){
					TempDealConditions tdc=new TempDealConditions();
					tdc.setTDealCondition((String)dealConditionList.get(k));	
					dealConditionL.add(tdc);
				}
				PraetorAdviceScan pas=new PraetorAdviceScan();
				pas.setDealConditionL(dealConditionL);
				//獲取擬辦内容
				List arrangementList=dao.getArrangements(new Long(sid),praetorName,adviceTitle);
				List arrangementL=new ArrayList();
		        for(int m=0;m<arrangementList.size();m++){
		        	TempArrangements ta=new TempArrangements();
		        	ta.setTArrangement((String)arrangementList.get(m));
		        	arrangementL.add(ta);
		        }
		        pas.setArrangementL(arrangementL);
		        //獲取其它内容
		        AdviceDetails ad=dao.getAdviceDetails(new Long(sid),praetorName,adviceTitle);
		        pas.setReplyDate(format.format(ad.getReplyDate()));
		        pas.setPraetorName(praetorName);
		        pas.setStyle(ad.getStyle().toString());
		        pas.setAdviceTitle(adviceTitle);
		        pas.setAdviceContents(ad.getAdviceContents());   	
		        adviceDetailsList.add(pas);
			}
            			
		}
		
		model.put("adl",adviceDetailsList);
		return new ModelAndView("c_4.5.4scan.jsp",model);

	}
	public List queryData(HttpServletRequest request) {
		List l = null;
		String year=null,month=null;//,date1=null,date2=null;
		try {

			year = new String(request.getParameter("year").getBytes(
					"ISO-8859-1"), "MS950").trim();
			month = new String(request.getParameter("month").getBytes(
					"ISO-8859-1"), "MS950").trim();
			//層級
			//date1 = new String(request.getParameter("d1").getBytes(
				//	"ISO-8859-1"), "MS950").trim();
			if (year == null)
				year = "";
			if (month == null)
				month = "";
			//if (date1 == null)
			//	date1 = "";
		
		
		l = dao.queryPraetorAdvice(year,month);// date1,date2);
		} catch (Exception e) {

		}	
		return l;	
	}

}