roomdetaildao.java

有关医院方向的开发

            throw re;
        }
    }

    /**
     * 查询未预定信息
     * @param propertyName
     * @param value
     * @return
     */
    
    public PageInfo queryRoomDetail(RoomInfo roomInfo,int pageno) {

        try {
         	PageInfo pageInfo1 = null;
	          String queryString = "  select a from RoomDetail as b right outer  join b.roomInfo as a  where a.roomsId" 
	           						 + "> 0  and (b.roomStatus ='0' or b.roomStatus = null)";
	          if (roomInfo.getRoomsSize() !=null && roomInfo.getRoomsSize() >0){
	        	  queryString =  queryString +" and a.roomsSize ="+roomInfo.getRoomsSize();
	          }else  if (roomInfo.getRoomsName() != null && roomInfo.getRoomsName().trim().length()>0){
	        	  queryString =  queryString +" and a.roomsName like '%"+roomInfo.getRoomsName()+"%'";
	          }else  if (roomInfo.getRoomstableid() !=null &&  roomInfo.getRoomstableid().trim().length()>0){
	        	  queryString =  queryString +" and a.roomstableid like '%"+roomInfo.getRoomstableid()+"%'";
	          }  
	          
	          String queryString1 = "  select count(a) from RoomDetail as b right outer  join b.roomInfo as a  where a.roomsId" 
					 + "> 0  and (b.roomStatus ='0' or b.roomStatus = null)";
	          if (roomInfo.getRoomsSize() !=null && roomInfo.getRoomsSize() >0){
	        	  queryString1 =  queryString1 +" and a.roomsSize ="+roomInfo.getRoomsSize();
	          }else  if (roomInfo.getRoomsName() != null && roomInfo.getRoomsName().trim().length()>0){
	        	  queryString1 =  queryString1 +" and a.roomsName like '%"+roomInfo.getRoomsName()+"%'";
	          }else  if (roomInfo.getRoomstableid() !=null &&  roomInfo.getRoomstableid().trim().length()>0){
	        	  queryString1 =  queryString1 +" and a.roomstableid like '%"+roomInfo.getRoomstableid()+"%'";
	          }  
	

	          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 queryRoomDetail1(RoomInfo roomInfo,int pageno,String custname,String certname) {

        try {
         	PageInfo pageInfo1 = null;
	          String queryString = " select b from RoomDetail as b right   join b.clubInfo as c right  join b.roomInfo as a   where b.clubId" 
	           						 + ">= 0 and a.roomsId =b.roomsId and b.roomStatus ='1'";
	          if (roomInfo.getRoomsSize() !=null && roomInfo.getRoomsSize() >0){
	        	  queryString =  queryString +" and a.roomsSize ="+roomInfo.getRoomsSize();
	          }else  if (roomInfo.getRoomsName() != null && roomInfo.getRoomsName().trim().length()>0){
	        	  queryString =  queryString +" and a.roomsName like '%"+roomInfo.getRoomsName()+"%'";
	          }else  if (roomInfo.getRoomstableid() !=null &&  roomInfo.getRoomstableid().trim().length()>0){
	        	  queryString =  queryString +" and a.roomstableid like '%"+roomInfo.getRoomstableid()+"%'";
	          }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 RoomDetail as b right   join b.clubInfo as c right  join b.roomInfo as a   where b.clubId" 
					 + ">= 0 and a.roomsId =b.roomsId and b.roomStatus ='1'";
				if (roomInfo.getRoomsSize() !=null && roomInfo.getRoomsSize() >0){
				queryString1 =  queryString1 +" and a.roomsSize ="+roomInfo.getRoomsSize();
				}else  if (roomInfo.getRoomsName() != null && roomInfo.getRoomsName().trim().length()>0){
				queryString1 =  queryString1 +" and a.roomsName like '%"+roomInfo.getRoomsName()+"%'";
				}else  if (roomInfo.getRoomstableid() !=null &&  roomInfo.getRoomstableid().trim().length()>0){
				queryString1 =  queryString1 +" and a.roomstableid like '%"+roomInfo.getRoomstableid()+"%'";
				}else  if (custname != null && custname.trim().length()>0){
				queryString1 =  queryString1 + " and b.custname like '%"+custname+"%'";
				}else  if (certname != null && certname.trim().length()>0){
				queryString1 =  queryString1 + " 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 queryRoomDetail2(RoomInfo roomInfo,int pageno,String custname,String certname) {

        try {
        	PageInfo pageInfo1 = null;
	          String queryString = " select b from RoomDetail as b right   join b.clubInfo as c right  join b.roomInfo as a   where b.clubId" 
	           						 + ">= 0 and a.roomsId =b.roomsId and b.roomStatus ='2'";
	          if (roomInfo.getRoomsSize() !=null && roomInfo.getRoomsSize() >0){
	        	  queryString =  queryString +" and a.roomsSize ="+roomInfo.getRoomsSize();
	          }else  if (roomInfo.getRoomsName() != null && roomInfo.getRoomsName().trim().length()>0){
	        	  queryString =  queryString +" and a.roomsName like '%"+roomInfo.getRoomsName()+"%'";
	          }else  if (roomInfo.getRoomstableid() !=null &&  roomInfo.getRoomstableid().trim().length()>0){
	        	  queryString =  queryString +" and a.roomstableid like '%"+roomInfo.getRoomstableid()+"%'";
	          }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 RoomDetail as b right   join b.clubInfo as c right  join b.roomInfo as a   where b.clubId" 
					 + ">= 0 and a.roomsId =b.roomsId and b.roomStatus ='2'";
				if (roomInfo.getRoomsSize() !=null && roomInfo.getRoomsSize() >0){
				queryString1 =  queryString1 +" and a.roomsSize ="+roomInfo.getRoomsSize();
				}else  if (roomInfo.getRoomsName() != null && roomInfo.getRoomsName().trim().length()>0){
				queryString1 =  queryString1 +" and a.roomsName like '%"+roomInfo.getRoomsName()+"%'";
				}else  if (roomInfo.getRoomstableid() !=null &&  roomInfo.getRoomstableid().trim().length()>0){
				queryString1 =  queryString1 +" and a.roomstableid like '%"+roomInfo.getRoomstableid()+"%'";
				}else  if (custname != null && custname.trim().length()>0){
				queryString1 =  queryString1 + " and b.custname like '%"+custname+"%'";
				}else  if (certname != null && certname.trim().length()>0){
				queryString1 =  queryString1 + " 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 List findRoomDetailInfo(Integer hotelsId) {

        try {
           String queryString = "from RoomDetail as model where model.roomsId=" 
           						+ hotelsId+" and model.roomStatus != 0";
  		 return getHibernateTemplate().find(queryString);
        } catch (RuntimeException re) {
           log.error("find by property name failed", re);
           throw re;
        }
  	}
    
    
    
    /**
     * 查询预订信息
     * @param propertyName
     * @param value
     * @return
     */
    
    public List querySinleRoomOrdDetail(Integer hotelsId) {

        try {
           String queryString = "from RoomDetail as model where model.roomsDetailId=" 
           						+ hotelsId;
  		 return getHibernateTemplate().find(queryString);
        } catch (RuntimeException re) {
           log.error("find by property name failed", re);
           throw re;
        }
  	}
    
    

    
    /**
     * 查询包间提醒
     * @param propertyName
     * @param value
     * @return
     */
    
    public PageInfo queryROrderalert(int pageno) {

    	PageInfo pageInfo1 = null;
        try {
           String queryString = "from RoomDetail as model where model.begintime <=" 
        	   +"'"+ new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date())+"'";
           
           String queryString1 = "select count(model) from RoomDetail as model where model.begintime <=" 
        	   +"'"+ new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date())+"'";
           pageInfo1 = pageInfo.page(pageno,10,queryString,queryString1);
 		   return pageInfo1;
        } catch (RuntimeException re) {
           log.error("find by property name failed", re);
           throw re;
        }
  	}
    


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