querydeptpayaction.java

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

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

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.mange.deptPay.DaptPay;
import com.gensou.logic.manage.deptPay.DeptPayService;

import com.gensou.struts.mamage.deptPay.form.QueryDeptPayForm;
import com.gensou.util.PagesMax;

/** 
 * MyEclipse Struts
 * Creation date: 01-29-2007
 * 
 * XDoclet definition:
 * @struts.action path="/queryDeptPay" name="queryDeptPayForm" scope="request" validate="true"
 * @struts.action-forward name="queryDeptPay" path="/gjsp/manage/deptPay/queryDeptPay.jsp"
 */
public class QueryDeptPayAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws Exception 
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws Exception {
		QueryDeptPayForm queryDeptPayForm = (QueryDeptPayForm) form;// TODO Auto-generated method stub
		String name = "";
		
		String nianfen = queryDeptPayForm.getNianfen();
		String yuefen = queryDeptPayForm.getYuefen();
		DeptPayService dept = new DeptPayService();
		
		String pages=request.getParameter("pageS");
		int pagei=Integer.parseInt(pages);
		String hql;
		int maxpage=1;
		List list=new ArrayList();
		DaptPay dp = new DaptPay();
		try{
			
			name = queryDeptPayForm.getName();
			if(name==null||name.equals("")){
				name=(String)request.getParameter("name");
				if(name==null||name.equals("")){
					 dept.setName(name);
					 dept.setYuefen(nianfen+"-"+yuefen);
					 hql="select count(id) from Bumengongzi";
						
					 maxpage=PagesMax.max(hql);
					 
					 list = dp.queryDeptPay(dept, pagei, maxpage);
				}
			}else{
				name=(String)request.getParameter("name");
				dept.setName(name);
				dept.setYuefen(nianfen+"-"+yuefen);
				hql="select count(id) from Bumengongzi where bumenming like '%"+name+"%'";
				maxpage=PagesMax.max(hql);
				list = dp.queryDeptPay(dept, pagei, maxpage);
			}
		}catch(NullPointerException e){}
		
		if(list != null && !list.isEmpty()){
	    	request.setAttribute("name",name);
			request.setAttribute("pageS",pagei+"");
			request.setAttribute("maxpages",maxpage+"");
	    	request.setAttribute("queryDept",list);
	    	return mapping.findForward("queryDeptPay");
	    }else{
	    	String queryDN = "没有符合查询条件的数据";
	    	request.setAttribute("queryDN",queryDN);
	    	return mapping.findForward("queryDeptPay");
	    }
	}
}