hotelinfodao.java

有关医院方向的开发

  		 return getHibernateTemplate().find(queryString);
        } catch (RuntimeException re) {
           log.error("find by property name failed", re);
           throw re;
        }
  	}
    
    
    /**
     * 查询客房信息
     * @param propertyName
     * @param value
     * @return
     */
    
    public PageInfo findHotelInfo(Float hotelsize,Integer hotelfloor,String hotellevel,Float hotelprice,int pageno) {

        try {
           String queryString = "from HotelInfo as model where model.hotelsId" 
           						 + "> 0";
          if (hotelsize !=null && hotelsize >0){
        	  queryString =  queryString +" and model.hotelsize ="+hotelsize;
          }else  if ( hotelfloor !=null && hotelfloor >0){
        	  queryString =  queryString +" and model.hotelfloor ="+hotelfloor;
          }else  if (hotellevel != null && hotellevel.trim().length()>0){
        	  queryString =  queryString +" and model.hotellevel like '%"+hotellevel+"%'";
          }else  if (hotelprice !=null && hotelprice >0){
        	  queryString =  queryString +" and model.hotelprice ="+hotelprice;
          }  
          
           String queryString1 = " select count(*) from HotelInfo as model where model.hotelsId" 
				 + "> 0";
           if (hotelsize !=null && hotelsize >0){
         	  queryString1 =  queryString1 +" and model.hotelsize ="+hotelsize;
           }else  if ( hotelfloor !=null && hotelfloor >0){
         	  queryString1 =  queryString1 +" and model.hotelfloor ="+hotelfloor;
           }else  if (hotellevel != null && hotellevel.trim().length()>0){
         	  queryString1 =  queryString1 +" and model.hotellevel like '%"+hotellevel+"%'";
           }else  if (hotelprice !=null && hotelprice >0){
         	  queryString1 =  queryString1 +" and model.hotelprice ="+hotelprice;
           }   
			PageInfo pageInfo1 = pageInfo.page(pageno,10,queryString,queryString1);
  		    return pageInfo1;
        } catch (RuntimeException re) {
           log.error("find by property name failed", re);
           throw re;
        }
  	}
    
    
    
    /**
     * 查询客房未预定信息
     * @param propertyName
     * @param value
     * @return
     */
    
    public PageInfo queryHotelDetail(HotelInfo hotelinfo,int pageno) {

        try {
         	PageInfo pageInfo1 = null;
	          String queryString = "  select a from HotelDetailInfo as b right outer  join b.hotelInfo as a  where a.hotelsId" 
	           						 + "> 0  and (b.hotelstatus ='0' or b.hotelstatus = null)";
	          if (hotelinfo.getHotelsize() !=null && hotelinfo.getHotelsize() >0){
	        	  queryString =  queryString +" and a.hotelsize ="+hotelinfo.getHotelsize();
	          }else  if (hotelinfo.getHotellevel() != null && hotelinfo.getHotellevel().trim().length()>0){
	        	  queryString =  queryString +" and a.hotellevel like '%"+hotelinfo.getHotellevel()+"%'";
	          }else  if (hotelinfo.getHotelprice() !=null && hotelinfo.getHotelprice() >0){
	        	  queryString =  queryString +" and a.hotelprice ="+hotelinfo.getHotelprice();
	          }  
	          
	          String queryString1 = "select count(a) from HotelDetailInfo as b right outer  join b.hotelInfo as a where a.hotelsId" 
					 + "> 0 and (b.hotelstatus ='0' or b.hotelstatus = null)" ;
	           if (hotelinfo.getHotelsize() !=null && hotelinfo.getHotelsize() >0){
		        	  queryString1 =  queryString1 +" and a.hotelsize ="+hotelinfo.getHotelsize();
		          }else  if (hotelinfo.getHotellevel() != null && hotelinfo.getHotellevel().trim().length()>0){
		        	  queryString1 =  queryString1 +" and a.hotellevel like '%"+hotelinfo.getHotellevel()+"%'";
		          }else  if (hotelinfo.getHotelprice() !=null && hotelinfo.getHotelprice() >0){
		        	  queryString1 =  queryString1 +" and a.hotelprice ="+hotelinfo.getHotelprice();
		          }
	

	          pageInfo1 = pageInfo.page(pageno,10,queryString,queryString1);
		
  		    return pageInfo1;
        } catch (RuntimeException re) {
           log.error("find by property name failed", re);
           throw re;
        }
  	}
    
    
    /**
     * 查询客房已预定信息
     * @param propertyName
     * @param value
     * @return
     */
    
    public PageInfo queryHotelDetail1(HotelInfo hotelinfo,int pageno,String custname,String certname) {

        try {
         	PageInfo pageInfo1 = null;
	          String queryString = " select b from HotelDetailInfo as b right   join b.clubInfo as c right  join b.hotelInfo as a   where b.clubId" 
	           						 + ">= 0 and a.hotelsId =b.hotelsId and b.hotelstatus ='1' ";
	          if (hotelinfo.getHotelsize() !=null && hotelinfo.getHotelsize() >0){
	        	  queryString =  queryString +" and a.hotelsize ="+hotelinfo.getHotelsize();
	          }else  if (hotelinfo.getHotellevel() != null && hotelinfo.getHotellevel().trim().length()>0){
	        	  queryString =  queryString +" and a.hotellevel like '%"+hotelinfo.getHotellevel()+"%'";
	          }else  if (hotelinfo.getHotelprice() !=null && hotelinfo.getHotelprice() >0){
	        	  queryString =  queryString +" and model.hotelprice ="+hotelinfo.getHotelprice();
	          }else  if (custname != null && custname.trim().length()>0){
	        	  queryString =  queryString + " and b.custname like '%"+custname+"%'";
	          }else  if (certname != null && certname.trim().length()>0){
	        	  queryString =  queryString + " and b.custcertid like '%"+certname+"%'";
	          }  
	          
	          String queryString1 = " select count(b) from HotelDetailInfo as b right  join b.clubInfo as c right  join b.hotelInfo as a  where b.clubId" 
					 + ">=0 and a.hotelsId =b.hotelsId and b.hotelstatus ='1' ";
	           if (hotelinfo.getHotelsize() !=null && hotelinfo.getHotelsize() >0){
		        	  queryString1 =  queryString1 +" and a.hotelsize ="+hotelinfo.getHotelsize();
		          }else  if (hotelinfo.getHotellevel() != null && hotelinfo.getHotellevel().trim().length()>0){
		        	  queryString1 =  queryString1 +" and a.hotellevel like '%"+hotelinfo.getHotellevel()+"%'";
		          }else  if (hotelinfo.getHotelprice() !=null && hotelinfo.getHotelprice() >0){
		        	  queryString1 =  queryString1 +" and model.hotelprice ="+hotelinfo.getHotelprice();
		          }else  if (custname != null && custname.trim().length()>0){
		        	  queryString =  queryString + " and b.custname like '%"+custname+"%'";
		          }else  if (certname != null && certname.trim().length()>0){
		        	  queryString =  queryString + " and b.custcertid like '%"+certname+"%'";
		          } 
	          pageInfo1 = pageInfo.page(pageno,10,queryString,queryString1);
		
  		    return pageInfo1;
        } catch (RuntimeException re) {
           log.error("find by property name failed", re);
           throw re;
        }
  	}
    
    /**
     * 查询客房已定信息
     * @param propertyName
     * @param value
     * @return
     */
    
    public PageInfo queryHotelDetail2(HotelInfo hotelinfo,int pageno,String custname,String certname) {

        try {
         	PageInfo pageInfo1 = null;
	          String queryString = " select b from HotelDetailInfo as b,HotelInfo as a right outer  join b.clubInfo as c where a.hotelsId" 
	           						 + "> 0 and a.hotelsId =b.hotelsId and b.hotelstatus ='2' ";
	          if (hotelinfo.getHotelsize() !=null && hotelinfo.getHotelsize() >0){
	        	  queryString =  queryString +" and a.hotelsize ="+hotelinfo.getHotelsize();
	          }else  if (hotelinfo.getHotellevel() != null && hotelinfo.getHotellevel().trim().length()>0){
	        	  queryString =  queryString +" and a.hotellevel like '%"+hotelinfo.getHotellevel()+"%'";
	          }else  if (hotelinfo.getHotelprice() !=null && hotelinfo.getHotelprice() >0){
	        	  queryString =  queryString +" and model.hotelprice ="+hotelinfo.getHotelprice();
	          }else  if (custname != null && custname.trim().length()>0){
	        	  queryString =  queryString + " and b.custname like '%"+custname+"%'";
	          }else  if (certname != null && certname.trim().length()>0){
	        	  queryString =  queryString + " and b.custcertid like '%"+certname+"%'";
	          }  
	          
	          String queryString1 = " select count(*) from HotelDetailInfo as b,HotelInfo as a right outer  join b.clubInfo as c  where a.hotelsId" 
					 + "> 0 and a.hotelsId =b.hotelsId  and b.hotelstatus ='2' ";
	           if (hotelinfo.getHotelsize() !=null && hotelinfo.getHotelsize() >0){
		        	  queryString1 =  queryString1 +" and a.hotelsize ="+hotelinfo.getHotelsize();
		          }else  if (hotelinfo.getHotellevel() != null && hotelinfo.getHotellevel().trim().length()>0){
		        	  queryString1 =  queryString1 +" and a.hotellevel like '%"+hotelinfo.getHotellevel()+"%'";
		          }else  if (hotelinfo.getHotelprice() !=null && hotelinfo.getHotelprice() >0){
		        	  queryString1 =  queryString1 +" and model.hotelprice ="+hotelinfo.getHotelprice();
		          }else  if (custname != null && custname.trim().length()>0){
		        	  queryString =  queryString + " and b.custname like '%"+custname+"%'";
		          }else  if (certname != null && certname.trim().length()>0){
		        	  queryString =  queryString + " and b.custcertid like '%"+certname+"%'";
		          } 
	          pageInfo1 = pageInfo.page(pageno,10,queryString,queryString1);
		
  		    return pageInfo1;
        } catch (RuntimeException re) {
           log.error("find by property name failed", re);
           throw re;
        }
  	}


	public static HotelInfoDAO getFromApplicationContext(ApplicationContext ctx) {
    	return (HotelInfoDAO) ctx.getBean("HotelInfoDAO");
	}

	public Pagination getPageInfo() {
		return pageInfo;
	}

	public void setPageInfo(Pagination pageInfo) {
		this.pageInfo = pageInfo;
	}
}