queryyearcheckuplist.java

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

package com.gs.control.handlers.pageBuilder.query;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
import java.util.*;
import javax.servlet.http.*;
import com.gs.control.handlers.DefaultHandlerSupport;
import com.gs.control.exceptions.WebException;
import com.gs.control.event.HandlerEvent;
import com.gs.pageBuilder.dao.*;
import com.gs.pageBuilder.model.*;
import com.gs.util.*;
import com.gs.pageBuilder.util.AutoBuild;
import com.gs.control.util.PageBuilderScreen;
import com.gs.pageBuilder.util.*;
import com.gs.component.sysadmin.model.*;

public class QueryYearCheckupList extends DefaultHandlerSupport{
        public HandlerEvent processEvent(HttpServletRequest request) throws
            WebException{
            Debug.println("[QueryYearCheckupList]ProcessEvent------->start!");

            HandlerEvent handlerEvent = new HandlerEvent();
            String nextPage = null;
            try{
                //接收页面参数
                QueryDAO queryDAO = QueryDAOFactory.getDAO();
                ArrayList queryResultList=new ArrayList();
                HashMap pageParMap = new HashMap();

                String sqlResult="";
                int queryShowNum=0;//列表个数
                String superQueryCount="";
                String nowPageNum;
                String page_code;

                int superQueryCountInt=0;
                int querySelectPrintItemNum=0;


                HttpSession session = request.getSession(false);
                QuerySessionResultModel querySessionResultModel = null;
                UserModel user = (UserModel) session.getAttribute("userModel");

                request.setAttribute("queryDJJG",user.getAreaCoding());
                request.setAttribute("queryGXDW",user.getAreaCoding());
                request.setAttribute("queryGXDW",user.getAreaCoding());

                try{
                    //打印选择项目
                    ArrayList querySelectPrintItem=null;

                    querySessionResultModel = (QuerySessionResultModel) session.getAttribute("querySessionResultModel");

                    //提取页面编号,
                    nowPageNum = request.getParameter("nowPageNum");
                    if(request.getParameter("queryShowNum")==null||"".equals(request.getParameter("queryShowNum"))){
                        queryShowNum=50;
                    }else{
                        queryShowNum=Integer.parseInt(request.getParameter("queryShowNum"));
                    }
                    page_code = request.getParameter("page_code");

                    //第一次查询时初始化
                    if(nowPageNum==null||"".equals(nowPageNum)){

                        //异常处理 第一次查询
                        if(page_code == null || "".equals(page_code)){
                            Debug.println("[QueryYearCheckupList]ProcessEvent------->page_code is null!");
                            return handlerEvent;
                        }

                        nowPageNum = "1";

                        Debug.println("第一次查询时初始化 star!");
                        //获得参数
                        pageParMap = getPageElement(request);
                        //获得sql分析结果
                        sqlResult = querySqlTransition.getQuerySql(pageParMap);

                        //获得查询结果

                        //年检综合情况
                        if("query005".equals(page_code)){
                            //获得查询结果
                            String yearCheckupYear = request.getParameter("yearCheckupYear");
                            queryResultList = queryDAO.getSuperQueryCheckUp(sqlResult,Integer.parseInt(nowPageNum),queryShowNum,yearCheckupYear);
                            superQueryCount = queryDAO.getSuperQueryCountCheckUp(sqlResult,yearCheckupYear);
                            request.setAttribute("yearcheckupSelect","01");
                        } else

                        //已经年检的企业条件
                        if("query003".equals(page_code)){
                            //获得查询结果
                            String yearCheckupYear = request.getParameter("query0105field007"); //年检年度
                            request.setAttribute("yearCheckupYear",yearCheckupYear);
                            queryResultList = queryDAO.getYearCheckupQuery(sqlResult,Integer.parseInt(nowPageNum),queryShowNum);
                            superQueryCount = queryDAO.getYearCheckupCount(sqlResult);
                            request.setAttribute("yearcheckupSelect","02");
                        } else

                        //未年检的企业条件(未申报)
                        if("query008".equals(page_code)){
                            //获得查询结果
                            String yearCheckupYear = request.getParameter("yearCheckupYear"); //年检年度
                            request.setAttribute("yearCheckupYear",yearCheckupYear);

                            String ztfl=request.getParameter("ztfl");
                            //未申报sql
                            sqlResult=" )a,(SELECT field003,field007 FROM "
                                + TableNameUtil.OUT_YEARVALI
                                + " WHERE field007='"
                                + yearCheckupYear
                                + "' AND field002 LIKE '07%' AND field104='"
                                + user.getAreaCoding()
                                + "' ) b WHERE a.field003=b.field003(+) and b.field007 is null "
                                + sqlResult
                                +")";

                            queryResultList = queryDAO.getUnPassYearCheckup(sqlResult,Integer.parseInt(nowPageNum),queryShowNum);
                            superQueryCount = queryDAO.getUnPassYearCheckupCount(sqlResult);
                            request.setAttribute("yearcheckupSelect","03");
                        }else

                        //未年检的企业条件(正在受理中)
                        if("query015".equals(page_code)){
                            //获得查询结果
                            String yearCheckupYear = request.getParameter("yearCheckupYear"); //年检年度
                            request.setAttribute("yearCheckupYear",yearCheckupYear);
                            String ztfl=request.getParameter("ztfl");

                            sqlResult=" )a,(SELECT field003,field007 FROM "
                                + TableNameUtil.OUT_YEARVALI
                                + " WHERE field046 ='0101' AND field007='"
                                + yearCheckupYear
                                + "' AND field002 LIKE '07%' AND field104='"
                                + user.getAreaCoding()
                                + "' ) b WHERE a.field003=b.field003(+) and b.field007 is not null"
                                + sqlResult
                                +")";

                            queryResultList = queryDAO.getUnPassYearCheckup(sqlResult,Integer.parseInt(nowPageNum),queryShowNum);
                            superQueryCount = queryDAO.getUnPassYearCheckupCount(sqlResult);
                            request.setAttribute("yearcheckupSelect","04");
                        }else
                        //未年检企业 add by yuxiaogang 20040520
                        if("query022".equals(page_code)){
                            String yearCheckupYear = request.getParameter("yearCheckupYear");
                            request.setAttribute("yearCheckupYear",yearCheckupYear);
                            String ztfl=request.getParameter("ztfl");

                            sqlResult=" )a,(SELECT field003,field007 FROM "
                               + TableNameUtil.IN_YEARVALI
                               + " WHERE field155 ='9002' AND field007='"
                               + yearCheckupYear
                               + "' AND field002 LIKE '07%' AND field104='"
                               + user.getAreaCoding()
                               + "' ) b WHERE a.field003=b.field003(+) and b.field003 is null"
                               + sqlResult
                               +")";

                           queryResultList = queryDAO.getUnPassYearCheckup(sqlResult,Integer.parseInt(nowPageNum),queryShowNum);
                           superQueryCount = queryDAO.getUnPassYearCheckupCount(sqlResult);
                           request.setAttribute("yearcheckupSelect","07");


                        }else

                        //企业吊销情况
                        if("query013".equals(page_code)){
                            String yearCheckupYear = request.getParameter("yearCheckupYear"); //年度
                            request.setAttribute("yearCheckupYear",yearCheckupYear);
                            //获得查询结果
                            queryResultList = queryDAO.getSuperQuery(sqlResult,Integer.parseInt(nowPageNum),queryShowNum);
                            superQueryCount = queryDAO.getSuperQueryCount(sqlResult);
                            request.setAttribute("yearcheckupSelect","05");
                        } else

                        //企业注销情况
                        if("query014".equals(page_code)){
                            String yearCheckupYear = request.getParameter("yearCheckupYear"); //年度
                            request.setAttribute("yearCheckupYear",yearCheckupYear);
                            //获得查询结果