querymanagerimpl.java

struts hibernate spring

package com.syfxapp.service.impl;

import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

import com.syfxapp.dao.ExecHqlDao;
import com.syfxapp.dao.SyfxDmXsgmjcDAO;
import com.syfxapp.dao.SyfxDmYngmjcDAO;
import com.syfxapp.dao.SyfxFirstShowDAO;
import com.syfxapp.service.QueryManager;
import com.syfxapp.util.PageToolsBar;

public class QueryManagerImpl implements QueryManager {
	private PageToolsBar pagetoolsBar;
	private int maxRes;
	private String currentPageNo;
	private int pageNo;
	private String toolsBarHtml;
	private String toolsBarHtmlSave;
	private SyfxFirstShowDAO firstDao;
	private SyfxDmXsgmjcDAO dmxsgmjcDao;
	private SyfxDmYngmjcDAO dmyngmjcDao;
	public void setFirstDao(SyfxFirstShowDAO firstDao) {
		this.firstDao = firstDao;
	}
	public PageToolsBar getPagetoolsBar() {
		return pagetoolsBar;
	}
	public void setPagetoolsBar(PageToolsBar pagetoolsBar) {
		this.pagetoolsBar = pagetoolsBar;
	}
	public int getMaxRes() {
		return maxRes;
	}
	public void setMaxRes(int maxRes) {
		if(maxRes==0)
			this.maxRes=20;
		else
			this.maxRes = maxRes;
	}
	public String getCurrentPageNo() {
		return currentPageNo;
	}
	public void setCurrentPageNo(String currentPageNo) {
		//this.currentPageNo = currentPageNo;
		if(currentPageNo==null)
			pageNo=1;
		else
			pageNo=Integer.parseInt(currentPageNo);
	}
	public String getToolsBarHtml() {
		return toolsBarHtml;
	}
	public void setToolsBarHtml(String toolsBarHtml) {
		this.toolsBarHtml = toolsBarHtml;
	}

	public void setDmxsgmjcDao(SyfxDmXsgmjcDAO dmxsgmjcDao) {
		this.dmxsgmjcDao = dmxsgmjcDao;
	}
	public void setDmyngmjcDao(SyfxDmYngmjcDAO dmyngmjcDao) {
		this.dmyngmjcDao = dmyngmjcDao;
	}
	public List getFirstShow(){
		return firstDao.findAll();
	}
	public List getB1List(String ny){
		String hql="from SyfxB1ZzsSytj where ny='"+ny+"'";
		pagetoolsBar.initPage(hql, this.pageNo, this.maxRes);
		this.toolsBarHtml=pagetoolsBar.getToolsBar("listB1.action?ny="+ny+"&");
		this.toolsBarHtmlSave="listB1Save.action?maxRes=999999999&ny="+ny;
		List l=pagetoolsBar.getResultList();
		return l;
	}
	public List getB2List(String nsrsbh,String nsrmc,Date kprq_q,Date kprq_z,String s_kprq_q,String s_kprq_z,
			String zsxmdm,String jkpzdm,String skgkdm,String swjgdm,String yssphm){
		String hql = "from SyfxB2Kprk as model where ";
		String s="";
		try{
			SimpleDateFormat d=new   SimpleDateFormat("yyyyMMdd");
			if(kprq_q!=null)
				s_kprq_q=d.format(kprq_q);
			else
				s_kprq_q="20080901";
			if(kprq_z!=null)			
				s_kprq_z=d.format(kprq_z);
			else
				s_kprq_z="20991231";
			if(nsrsbh!=null){
			if(!nsrsbh.equals("")){
				hql=hql+"nsrsbh like '"+nsrsbh+"%' and ";
				s="nsrsbh="+nsrsbh+"&";
				
			}
		}
		
		if(nsrmc!=null){
			if(!nsrmc.equals("")){
				hql=hql+"nsrmc like '"+nsrmc+"%' and ";
				s=s+"nsrmc="+nsrmc+"&";
				
			}
		}
		
		if(yssphm!=null){
			if(!yssphm.equals("")){
				hql=hql+"yssphm like '"+yssphm+"%' and ";
				s=s+"yssphm="+yssphm+"&";
				
			}
		}
		if(!zsxmdm.equals("all"))
			hql=hql+"zsxmDm = '"+zsxmdm+"' and ";
		if(!jkpzdm.equals("all"))
			hql=hql+"jkpzzlDm = '"+jkpzdm+"' and ";
		if(!skgkdm.equals("all"))
			hql=hql+"skgkDm = '"+skgkdm+"' and ";
		if(swjgdm.equals("14202000000")){
			String t=swjgdm.substring(0,5);
			hql=hql+"swjgDm like '"+t+"%' and ";
		}
		else 
			hql=hql+"swjgDm = '"+swjgdm+"' and ";
		
		hql=hql+"to_char(kprq,'yyyymmdd') >='"+s_kprq_q+"' and to_char(kprq,'yyyymmdd')<= '"+s_kprq_z+"'";
		pagetoolsBar.initPage(hql, this.pageNo, this.maxRes);
		s=s+"zsxmdm="+zsxmdm
		+"&jkpzdm="+jkpzdm+"&skgkdm="+skgkdm+"&swjgdm="+swjgdm+"&s_kprq_q="+s_kprq_q+"&s_kprq_z="+s_kprq_z+"&";
		this.toolsBarHtml=pagetoolsBar.getToolsBar("listB2.action?"+s);
		this.toolsBarHtmlSave="listB2Save.action?maxRes=999999999&"+s;
		List l=pagetoolsBar.getResultList();
		return l;
		}catch(Exception err){
			err.printStackTrace();
			return null;
		}
		}
	public List getB3List(String nsrsbh,String nsrmc,String hydm,
		String ny,String xsgmjcdm,String yngmjcdm,String jkjbdm,String swjgdm){
		String hql="from SyfxB3ZzsYbnsr as a where ";
		String s="";
		if(nsrsbh!=null){
			if(!nsrsbh.equals("")){
				hql=hql+"nsrsbh like '"+nsrsbh+"%' and ";
				s=s+"nsrsbh="+nsrsbh+"&";
			}
		}
		if(nsrmc!=null){
			if(!nsrmc.equals("")){
				hql=hql+"nsrmc like '"+nsrmc+"%' and ";
				s=s+"nsrmc="+nsrmc+"&";
			}
		}
		hql=hql+"a.id.ny = '"+ny+"' and ";
	
		//yngm
		if(!yngmjcdm.equals("all")){
			hql=hql+"((a.bnYnse > "+dmyngmjcDao.findById(yngmjcdm).getYngmXx()+" and ";
			hql=hql+"a.bnYnse < "+dmyngmjcDao.findById(yngmjcdm).getYngmSx()+") or ";
		}
		//xsgm
		if(!xsgmjcdm.equals("all")){
			hql=hql+"(a.bnYsxssr > "+dmxsgmjcDao.findById(xsgmjcdm).getXsgmXx()+" and ";
			hql=hql+"a.bnYsxssr < "+dmxsgmjcDao.findById(xsgmjcdm).getXsgmSx()+")) and ";
		}
		//hydm
	//	hql=hql+"a.hyDm='"+hydm+"' and ";
		//jkjbdm
		if(!jkjbdm.equals("all"))
			hql=hql+"a.jkjbDm='"+jkjbdm+"' and ";
		//swjgdm
		if(swjgdm.equals("14202000000")){
			String t=swjgdm.substring(0,5);
			hql=hql+"swjgDm like '"+t+"%'";
		}
		else 
	//		swjgdm=swjgdm.substring(0,7);
			hql=hql+"swjgDm = '"+swjgdm+"'";
	//
		s=s+"hydm="+hydm+"&";
		s=s+"ny="+ny+"&";
		s=s+"xsgmjcdm="+xsgmjcdm+"&";
		s=s+"yngmjcdm="+yngmjcdm+"&";
		s=s+"jkjbdm="+jkjbdm+"&";
		s=s+"swjgdm="+swjgdm+"&";
		pagetoolsBar.initPage(hql, this.pageNo, this.maxRes);
		this.toolsBarHtml=pagetoolsBar.getToolsBar("listB3.action?"+s);
		this.toolsBarHtmlSave="listB3Save.action?maxRes=999999999&"+s;
		List l=pagetoolsBar.getResultList();
		return l;
		}
	public List getB4List(String nsrsbh,String nsrmc,String hydm,
			String ny,String xsgmjcdm,String yngmjcdm,String jkjbdm,String swjgdm){
		String hql="from SyfxB4Sds as a where ";
		String s="";
		if(nsrsbh!=null){
			if(!nsrsbh.equals("")){
				hql=hql+"id.nsrsbh like '"+nsrsbh+"%' and ";
				s=s+"nsrsbh="+nsrsbh+"&";
			}
		}
		if(nsrmc!=null){
		if(!nsrmc.equals("")){
				hql=hql+"id.nsrmc like '"+nsrmc+"%' and ";
				s=s+"nsrmc="+nsrmc+"&";
			}
		}
		hql=hql+"id.ny = '"+ny+"' and ";
		if(!hydm.equals("all"))
			hql=hql+"hyDm='"+hydm+"'";
		//yngm
		if(!yngmjcdm.equals("all")){
			hql=hql+"((id.bqLjYbtse > "+dmyngmjcDao.findById(yngmjcdm).getYngmXx()+" and ";
			hql=hql+"id.bqLjYbtse < "+dmyngmjcDao.findById(yngmjcdm).getYngmSx()+") or ";
		}
		//xsgm
		if(!xsgmjcdm.equals("all")){
			hql=hql+"(id.bqLjYysr > "+dmxsgmjcDao.findById(xsgmjcdm).getXsgmXx()+" and ";
			hql=hql+"id.bqLjYysr < "+dmxsgmjcDao.findById(xsgmjcdm).getXsgmSx()+")) and ";
		}
		if(!jkjbdm.equals("all"))
			hql=hql+"id.jkjbDm='"+jkjbdm+"' and ";
		if(swjgdm.equals("14202000000")){
			String t=swjgdm.substring(0,5);
			hql=hql+"id.swjgDm like '"+t+"%'";
		}
		else 
			hql=hql+"id.swjgDm = '"+swjgdm+"'";
		s=s+"hydm="+hydm+"&";
		s=s+"ny="+ny+"&";
		s=s+"xsgmjcdm="+xsgmjcdm+"&";
		s=s+"yngmjcdm="+yngmjcdm+"&";
		s=s+"jkjbdm="+jkjbdm+"&";
		s=s+"swjgdm="+swjgdm+"&";
		pagetoolsBar.initPage(hql, this.pageNo, this.maxRes);
		this.toolsBarHtml=pagetoolsBar.getToolsBar("listB4.action?"+s);
		this.toolsBarHtmlSave="listB4Save.action?maxRes=999999999&"+s;
		List l=pagetoolsBar.getResultList();
		return l;
		}
	public List getB5List(String ny){
		String hql="from SyfxB5Sf where ny='"+ny+"'";
		pagetoolsBar.initPage(hql, this.pageNo, this.maxRes);
		this.toolsBarHtml=pagetoolsBar.getToolsBar("listB5.action?ny="+ny+"&");
		this.toolsBarHtmlSave="listB5Save.action?maxRes=999999999&ny="+ny+"&";
		List l=pagetoolsBar.getResultList();
		return l;
		}
	public List getB6List(String ny){
		String hql="from SyfxB6Sjq where ny='"+ny+"'";
		pagetoolsBar.initPage(hql, this.pageNo, this.maxRes);
		this.toolsBarHtml=pagetoolsBar.getToolsBar("listB6.action?ny="+ny+"&");
		this.toolsBarHtmlSave="listB6Save.action?maxRes=999999999&ny="+ny+"&";
		List l=pagetoolsBar.getResultList();
		return l;
		}
	public List getB7List(String ny,String jkjbdm){
		String hql="from SyfxB7Zdsy where  ";
		if(!jkjbdm.equals("all"))	
			hql=hql+"id.jkjbDm='"+jkjbdm+"' and ";
		hql=hql+"id.ny='"+ny+"'";
		pagetoolsBar.initPage(hql, this.pageNo, this.maxRes);
		this.toolsBarHtml=pagetoolsBar.getToolsBar("listB7.action?ny="+ny+"&jkjbdm="+jkjbdm+"&");
		this.toolsBarHtmlSave="listB7Save.action?maxRes=999999999&ny="+ny+"&jkjbdm="+jkjbdm+"&";
		List l=pagetoolsBar.getResultList();
		return l;
	}
	public List getB7FhList(String ny,String jkjbdm,String swjgdm){
		String hql="from SyfxB7ZdsyFhxx where id.ny='"+ny+"' and jkjbDm='"+jkjbdm+"' and ";
		if(swjgdm.equals("14202000000")){
			String t=swjgdm.substring(0,5);
			hql=hql+"swjgDm like '"+t+"%'";
		}
		else 
			hql=hql+"swjgDm = '"+swjgdm+"'";
	
		pagetoolsBar.initPage(hql, this.pageNo, this.maxRes);
		this.toolsBarHtml=pagetoolsBar.getToolsBar("listB7Fh.action?ny="+ny+"&jkjbdm="+jkjbdm+"&swjgdm="+swjgdm+"&");
		this.toolsBarHtmlSave="listB7FhSave.action?maxRes=999999999&ny="+ny+"&jkjbdm="+jkjbdm+"&swjgdm="+swjgdm+"&";
		List l=pagetoolsBar.getResultList();
		return l;
	}
	public List getB8List(String ny){
		String hql="from SyfxB8Sf where ny='"+ny+"'";
		pagetoolsBar.initPage(hql, this.pageNo, this.maxRes);
		this.toolsBarHtml=pagetoolsBar.getToolsBar("listB8.action?ny="+ny+"&");
		this.toolsBarHtmlSave="listB8Save.action?maxRes=999999999&ny="+ny+"&";
		List l=pagetoolsBar.getResultList();
		return l;
		}
	public List getB8FhyList(String swjgdm,String ny){
		String hql="from SyfxB8SfFhy where id.ny='"+ny+"' and id.swjgDm='"+swjgdm+"'";
		pagetoolsBar.initPage(hql, this.pageNo, this.maxRes);
		this.toolsBarHtml=pagetoolsBar.getToolsBar("listB8Fhy.action?ny="+ny+"&swjgdm="+swjgdm+"&");
		this.toolsBarHtmlSave="listB8FhySave.action?maxRes=999999999&ny="+ny+"&swjgdm="+swjgdm+"&";
		List l=pagetoolsBar.getResultList();
		return l;
		}
	public List getB9List(String swjgdm,String ny){
		String hql="from SyfxB9SfFh where id.ny='"+ny+"' and ";
		if(swjgdm.equals("14202000000")){
			String t=swjgdm.substring(0,5);
			hql=hql+"swjgDm like '"+t+"%'";
		}
		else 
			hql=hql+"swjgDm = '"+swjgdm+"'";
		pagetoolsBar.initPage(hql, this.pageNo, this.maxRes);
		this.toolsBarHtml=pagetoolsBar.getToolsBar("listB9.action?ny="+ny+"&swjgdm="+swjgdm+"&");
		this.toolsBarHtmlSave="listB9Save.action?maxRes=999999999&ny="+ny+"&swjgdm="+swjgdm+"&";
		List l=pagetoolsBar.getResultList();
		return l;
		}
	public String getToolsBarHtmlSave() {
		return toolsBarHtmlSave;
	}
	public void setToolsBarHtmlSave(String toolsBarHtmlSave) {
		this.toolsBarHtmlSave = toolsBarHtmlSave;
	}
}