queryyggongziaction.java

gensou.rar为某渔具厂的一个简单ERP系统。为比较基础的工程

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.gensou.struts.yuangong.gongzi.action;

import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.gensou.dao.bumen.xinxi.BumenxinxiDao;
import com.gensou.dao.yuangong.gongzi.YuangonggongziDao;
import com.gensou.struts.bumen.xinxi.form.QuerybmxinxiForm;
import com.gensou.struts.yuangong.gongzi.form.QueryyggongziForm;
import com.gensou.util.PagesMax;

/** 
 * MyEclipse Struts
 * Creation date: 01-19-2007
 * 
 * XDoclet definition:
 * @struts.action path="/queryyggongzi" name="queryyggongziForm" scope="request" validate="true"
 */
public class QueryyggongziAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		QueryyggongziForm queryyggongziForm = (QueryyggongziForm) form;// TODO Auto-generated method stub
		String way =null;
		String term=null;
		String date=null;
		String pages;
		int pagei = 1;
		String hql;
		int maxpage=1;
		YuangonggongziDao yuangonggongziDao=new YuangonggongziDao();
		List list=new ArrayList();
		try{
			date=queryyggongziForm.getNianfen()+"-"+queryyggongziForm.getYuefen();
			if(date==null||date.equals("")){
				date=(String)request.getAttribute("date");
			}
			pages=queryyggongziForm.getPageS();
			if(pages==null||pages.equals("")){
			 pages=request.getParameter("pageS");
			}
			pagei=Integer.parseInt(pages);
			way=queryyggongziForm.getWay();
			term=queryyggongziForm.getTerm();
			
			if(way==null||way.equals("")||term==null||term.equals("")){
				way=(String)request.getAttribute("query");
				term=(String)request.getAttribute("term");
				
				if(way==null||way.equals("")||term==null||term.equals("")){
					way="";
					term="";
					 hql="select count(id) from Yuangonggongzi where yuefen like '%"+date+"%'";
					 maxpage=PagesMax.max(hql);
					 list=yuangonggongziDao.queryyggongzi(way,term,date,pagei,maxpage);
				}
			}else{
				 String name="%"+term+"%";
				 hql="select count(id) from Yuangonggongzi where "+way+" like '"+name+"' and yuefen like '%"+date+"%'";
				 maxpage=PagesMax.max(hql);
				list=yuangonggongziDao.queryyggongzi(way,term,date,pagei,maxpage);
			}
		}catch(NullPointerException e){}
		if(list.isEmpty()){
			String str="员工不存在";
			request.setAttribute("str", str);
			return mapping.findForward("queryemployyeg");
		}else{
			request.setAttribute("way",way);
			request.setAttribute("pageS",pagei+"");
			request.setAttribute("maxpages",maxpage+"");
			request.setAttribute("date",date);
			request.setAttribute("yggongzi", list);
		    return mapping.findForward("queryemployyeg");
		}
	}

	}