planqueryaction.java

基于Java的地图数据管理软件。使用MySQL数据库管理系统。

/* 创建日期：Dec 17, 2006
 * 作　　者：朱　闰
 * 公　　司：安徽通途信息技术有限公司
 */

package com.tongtu.Action.planManage;

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

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

import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.tongtu.Action.TopBaseAction;
import com.tongtu.Form.LoginForm;
import com.tongtu.Form.QueryForm;
import com.tongtu.util.CurrentUser;
import com.tongtu.util.EnToChin;
import com.tongtu.util.Page;
import com.tongtu.util.QueryStr;
import com.tongtu.util.UserInfo;

public class PlanQueryAction extends TopBaseAction
{
    public ActionForward execute(ActionMapping actionMapping,
            ActionForm actionForm, HttpServletRequest httpServletRequest,
            HttpServletResponse httpServletResponse) {
    	   ActionErrors errors = new ActionErrors();
    	   QueryForm form = (QueryForm) actionForm;
           HttpSession session = httpServletRequest.getSession();   
           
              QueryStr qs = new QueryStr();  //查询条件
              if (form.getCity() != null)
              {
            	  System.out.println("=========城市ID========" + form.getCity());
            	  qs.setCity(form.getCity());
              }
            
              if (form.getCounty() !=null)
            	  qs.setCounty(form.getCounty());
           
              if (form.getEndTimeFrom()!=null&& form.getEndTimeFrom().length()>0)
              qs.setEndTimeFrom(form.getEndTimeFrom());
              if (form.getEndTimeTo()!=null && form.getEndTimeTo().length()>0)
              qs.setEndTimeTo(form.getEndTimeTo());
              if (form.getMilemeter()!=null && form.getMilemeter().length()>0)
              qs.setMilemeter(form.getMilemeter());
              else qs.setMilemeter(null);
              qs.setMileStr(form.getMileStr());
              qs.setPlanType(form.getPlanType());
              qs.setProStr(form.getProStr());
              if (form.getProvinceSubsidy()!=null && form.getProvinceSubsidy().length()>0)
              qs.setProvinceSubsidy(form.getProvinceSubsidy());
              else 
            	  qs.setProvinceSubsidy(null);
              if (form.getStartTimeFrom()!=null&& form.getStartTimeFrom().length()>0)
              qs.setStartTimeFrom(form.getStartTimeFrom());
              if (form.getStartTimeTo()!=null && form.getStartTimeTo().length()>0)
              qs.setStartTimeTo(form.getStartTimeTo());
              if (form.getTownName()!=null)
              qs.setTownName(EnToChin.native2unicode(form.getTownName()));
              if (form.getVillageName()!=null)
              qs.setVillageName(EnToChin.native2unicode(form.getVillageName()));
           
              //行政村类型
              String villageList[]=httpServletRequest.getParameterValues("checkbox");
              qs.setVillageType(villageList);
      	      //查询结果 
      	      String resultList[]=httpServletRequest.getParameterValues("checkbox2");
      	      if (resultList != null)
      	    	  System.out.println("======cols=====" + resultList.length);
              qs.setResultStr(resultList); 
      	       
              qs.setJhlx(form.getJhlx());
              qs.setJsxz(form.getJsxz());
              qs.setZyjsnr(form.getZyjsnr());
              qs.setProStr(form.getProStr());
              qs.setZtzStr(form.getZtzStr());
              qs.setJhyear(form.getJhyear());
              if (form.getJhztz()!=null && form.getJhztz().length()>0)
              qs.setJhztz(form.getJhztz());
              else 
            	  qs.setJhztz(null);
              qs.setMileType(1);
              qs.setProType(1);
              qs.setLjkdType(1);
              qs.setLmkdType(1);
              qs.setInvestType(1);
              qs.setStartType(1);
              qs.setEndType(1);
              qs.setRoadType(1);
              qs.setJhType(1);
              qs.setCunType(1);
              qs.setTownType(1);
              qs.setCityType(1);
              qs.setTypeId(12);
              
              String startTmp = httpServletRequest.getParameter("start");//获取首页的
    		  int start = 0,count = CurrentUser.rowCount,pagenum=0;
    	 	  if(startTmp!=null){
    		            start = Integer.parseInt(startTmp);
    		        }
    		        
          
    	 	  
    	 	     //  List planList = getPlanHelper().getAllPlanList(qs); //获取所有计划列表
    	 	        session.setAttribute("queryStr",qs);
    	 	        //session.setAttribute("planList", planList);
    	 	        pagenum = getPlanHelper().getQueryPlanCount(qs);  //获取计划总数 
    		        Page page = getPlanHelper().QueryPlan(start, count, qs);//分页获取计划信息
    	            httpServletRequest.setAttribute("page",page);
    		        httpServletRequest.setAttribute("pagenum",pagenum+"");
    		        httpServletRequest.setAttribute("start",start+"");
    		        httpServletRequest.setAttribute("rowCount",count+"");
    		      //  httpServletRequest.setAttribute("planList", planList);
              
    	      return actionMapping.findForward("success"); 
    }

}