unionhouseinfodao.java

有关医院方向的开发

package com.woyi.dao;
// default package

import java.util.Date;
import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.woyi.dto.UnionHouseInfo;
import com.woyi.page.PageInfo;
import com.woyi.page.Pagination;

/**
 * Data access object (DAO) for domain model class UnionHouseInfo.
 * 
 * @see .UnionHouseInfo
 * @author MyEclipse Persistence Tools
 */

public class UnionHouseInfoDAO extends HibernateDaoSupport {
	private static final Log log = LogFactory.getLog(UnionHouseInfoDAO.class);

	// property constants
	public static final String UNIONHOUSINFO_NAME = "unionhousinfoName";

	public static final String LEVID = "levid";

	public static final String HOUSENAME = "housename";
	
	public static final String ALLNAME = "allname";

	public static final String PARENTNAME = "parentname";

	public static final String HOUSETTYPE = "housettype";

	public static final String HOUSEFACE = "houseface";

	public static final String HOUSESTRUCT = "housestruct";

	public static final String PICTURL = "picturl";

	public static final String CRTAREA = "crtarea";

	public static final String PRICE = "price";

	public static final String TOTALPRICE = "totalprice";

	public static final String SALESTATE = "salestate";

	public static final String HOUSESTATE = "housestate";

	public static final String SALERID = "salerid";

	public static final String RESPNAMEID = "respnameid";

	public static final String UNIONADDR = "unionaddr";

	public static final String OPTRID = "optrid";

	public static final String REMARK = "remark";
	
	private Pagination pageInfo;
	protected void initDao() {
		// do nothing
	}

	public boolean save(UnionHouseInfo transientInstance) {
		log.debug("saving UnionHouseInfo instance");
		try {
			getHibernateTemplate().save(transientInstance);
			log.debug("save successful");
			return true;
		} catch (RuntimeException re) {
			log.error("save failed", re);
			return false;
		}
	}

	public boolean delete(UnionHouseInfo persistentInstance) {
		log.debug("deleting UnionHouseInfo instance");
		try {
			getHibernateTemplate().delete(persistentInstance);
			log.debug("delete successful");
			return true;
		} catch (RuntimeException re) {
			log.error("delete failed", re);
			return false;
		}
	}

	public UnionHouseInfo findById(java.lang.Integer id) {
		log.debug("getting UnionHouseInfo instance with id: " + id);
		try {
			UnionHouseInfo instance = (UnionHouseInfo) getHibernateTemplate()
					.get("UnionHouseInfo", id);
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}

	public List findByExample(UnionHouseInfo instance) {
		log.debug("finding UnionHouseInfo instance by example");
		try {
			List results = getHibernateTemplate().findByExample(instance);
			log.debug("find by example successful, result size: "
					+ results.size());
			return results;
		} catch (RuntimeException re) {
			log.error("find by example failed", re);
			throw re;
		}
	}

	public List findByProperty(String propertyName, Object value) {
		log.debug("finding UnionHouseInfo instance with property: "
				+ propertyName + ", value: " + value);
		try {
			String queryString = "from UnionHouseInfo as model where model."
					+ propertyName + "= ?";
			return getHibernateTemplate().find(queryString, value);
		} catch (RuntimeException re) {
			log.error("find by property name failed", re);
			throw re;
		}
	}

	public List findByUnionhousinfoName(Object unionhousinfoName) {
		return findByProperty(UNIONHOUSINFO_NAME, unionhousinfoName);
	}

	public List findByLevid(Object levid) {
		return findByProperty(LEVID, levid);
	}

	public List findByHousename(Object housename) {
		return findByProperty(HOUSENAME, housename);
	}

	public List findByParentname(Object parentname) {
		return findByProperty(PARENTNAME, parentname);
	}

	public List findByHousettype(Object housettype) {
		return findByProperty(HOUSETTYPE, housettype);
	}

	public List findByHouseface(Object houseface) {
		return findByProperty(HOUSEFACE, houseface);
	}

	public List findByHousestruct(Object housestruct) {
		return findByProperty(HOUSESTRUCT, housestruct);
	}

	public List findByPicturl(Object picturl) {
		return findByProperty(PICTURL, picturl);
	}

	public List findByCrtarea(Object crtarea) {
		return findByProperty(CRTAREA, crtarea);
	}

	public List findByPrice(Object price) {
		return findByProperty(PRICE, price);
	}

	public List findByTotalprice(Object totalprice) {
		return findByProperty(TOTALPRICE, totalprice);
	}

	public List findBySalestate(Object salestate) {
		return findByProperty(SALESTATE, salestate);
	}

	public List findByHousestate(Object housestate) {
		return findByProperty(HOUSESTATE, housestate);
	}

	public List findBySalerid(Object salerid) {
		return findByProperty(SALERID, salerid);
	}

	public List findByRespnameid(Object respnameid) {
		return findByProperty(RESPNAMEID, respnameid);
	}

	public List findByUnionaddr(Object unionaddr) {
		return findByProperty(UNIONADDR, unionaddr);
	}

	public List findByOptrid(Object optrid) {
		return findByProperty(OPTRID, optrid);
	}

	public List findByRemark(Object remark) {
		return findByProperty(REMARK, remark);
	}

	public List findAll() {
		log.debug("finding all UnionHouseInfo instances");
		try {
			String queryString = "from UnionHouseInfo";
			return getHibernateTemplate().find(queryString);
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}

	public UnionHouseInfo merge(UnionHouseInfo detachedInstance) {
		log.debug("merging UnionHouseInfo instance");
		try {
			UnionHouseInfo result = (UnionHouseInfo) getHibernateTemplate()
					.merge(detachedInstance);
			log.debug("merge successful");
			return result;
		} catch (RuntimeException re) {
			log.error("merge failed", re);
			throw re;
		}
	}

	public boolean attachDirty(UnionHouseInfo instance) {
		log.debug("attaching dirty UnionHouseInfo instance");
		try {
			getHibernateTemplate().saveOrUpdate(instance);
			log.debug("attach successful");
			return true;
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			return false;
		}
	}

	public void attachClean(UnionHouseInfo instance) {
		log.debug("attaching clean UnionHouseInfo instance");
		try {
			getHibernateTemplate().lock(instance, LockMode.NONE);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public static UnionHouseInfoDAO getFromApplicationContext(
			ApplicationContext ctx) {
		return (UnionHouseInfoDAO) ctx.getBean("UnionHouseInfoDAO");
	}
	/*
	 * 获取房源详细信息
	 */
	public List getUnionHouseInfoByLevlid(String levlid)
	{
		 try {
	            String queryString = "from UnionHouseInfo as a where a.levid ='"+levlid+"'";
	   		 return getHibernateTemplate().find(queryString);
	         } catch (RuntimeException re) {
	            log.error("find by property name failed", re);
	            throw re;
	         }
	}
	/*
	 * 根据ID获取房源信息
	 */
	public List getInfoByid(String id)
	{
		 try {
	            String queryString = "from UnionHouseInfo as a where a.unionhousinfoId ="+id+"";
	   		 return getHibernateTemplate().find(queryString);
	         } catch (RuntimeException re) {
	            log.error("find by property name failed", re);
	            throw re;
	         }
	}
	/*
	 * 根据客户ID获取房源信息
	 */
	public List getInfoBycustid(String id)
	{
		 try {
	            String queryString = "from UnionHouseInfo as a where a.custinfo_id ="+id+"";
	   		 return getHibernateTemplate().find(queryString);
	         } catch (RuntimeException re) {
	            log.error("find by property name failed", re);
	            throw re;
	         }
	}
	/*根据条件获取房源信息*/
	public PageInfo findUnionInfo(String HouseName,String Houseface,String area1,String area2,String price1,String price2,String housetype,String salestate, int pageno)
	{
		try{
			String queryString = "from UnionHouseInfo as model where model.unionhousinfoId" 
					 + "> 0";

			if (HouseName !=null && HouseName.trim().length() >0){
			queryString =  queryString +" and model.allname like '%"+HouseName+"%'";
			}  
			if (Houseface !=null && Houseface.trim().length() >0){
				queryString =  queryString +" and model.houseface like '%"+Houseface+"%'";
			}  
			if (area1 !=null && area1.trim().length() >0&&!area1.equals("0")){
				queryString =  queryString +" and model.crtarea >="+area1;
			} 
			if (area2 !=null && area2.trim().length() >0&&!area2.equals("0")){
				queryString =  queryString +" and model.crtarea <= "+area2;
			} 
			if (price1 !=null && price1.trim().length() >0 && !price1.equals("0")){
				queryString =  queryString +" and model.price >="+price1;
			} 
			if (price2 !=null && price2.trim().length() >0&&!price2.equals("0")){
				queryString =  queryString +" and model.price <="+price2;
			} 
			if (housetype !=null && housetype.trim().length() >0){
				queryString =  queryString +" and model.housettype like '%"+housetype+"%'";
			} 
			if (salestate !=null && salestate.trim().length() >0){
				queryString =  queryString +" and model.salestate = "+salestate;
			} 
	
			String queryString1 = "select count(*) from UnionHouseInfo as model where model.unionhousinfoId" 
				 + "> 0";
			if (HouseName !=null && HouseName.trim().length() >0){
				queryString1 =  queryString1 +" and model.allname like '%"+HouseName+"%'";
				}  
				if (Houseface !=null && Houseface.trim().length() >0){
					queryString1 =  queryString1 +" and model.houseface like '%"+Houseface+"%'";
				}  
				if (area1 !=null && area1.trim().length() >0&&!area1.equals("0")){
					queryString1 =  queryString1 +" and model.crtarea >="+area1;
				} 
				if (area2 !=null && area2.trim().length() >0&&!area2.equals("0")){
					queryString1 =  queryString1 +" and model.crtarea <= "+area2;
				} 
				if (price1 !=null && price1.trim().length() >0&&!price1.equals("0")){
					queryString1 =  queryString1 +" and model.price >="+price1;
				} 
				if (price2 !=null && price2.trim().length() >0&&!price2.equals("0")){
					queryString1 =  queryString1 +" and model.price <="+price2;
				} 
				if (housetype !=null && housetype.trim().length() >0){
					queryString1 =  queryString1 +" and model.housettype like '%"+housetype+"%'";
				} 
				if (salestate !=null && salestate.trim().length() >0){
					queryString1 =  queryString1 +" and model.salestate = "+salestate;
				} 
				
		//	getHibernateTemplate().find(queryString1);
			
			PageInfo pageInfo1 = pageInfo.page(pageno,20,queryString,queryString1);
		//	PageInfo pageInfo1 = new PageInfo();
  		    return pageInfo1;
			
		}
		catch (RuntimeException re) {
	           log.error("find by property name failed", re);
	           throw re;
	        }
	}
	public PageInfo HouseSaleInfo(String begintime,String endtime,int pageno)
	{
		try{
			String queryString = "from UnionHouseInfo as model where model.unionhousinfoId" 
					 + "> 0";
			queryString =  queryString +" and model.optrdate >= '"+begintime+"'";
			queryString =  queryString +" and model.optrdate <= '"+endtime+"'";
			queryString =  queryString +" and model.salestate in ('5','4')";
			
			String queryString1 = "select count(*) from UnionHouseInfo as model where model.unionhousinfoId" 
				 + "> 0";
			queryString1 =  queryString1 +" and model.optrdate >= '"+begintime+"'";
			queryString1 =  queryString1 +" and model.optrdate <= '"+endtime+"'";
			queryString1 =  queryString1 +" and model.salestate in ('5','4')";
			
				
		//	getHibernateTemplate().find(queryString1);
			
			PageInfo pageInfo1 = pageInfo.page(pageno,20,queryString,queryString1);
		//	PageInfo pageInfo1 = new PageInfo();
  		    return pageInfo1;
			
		}
		catch (RuntimeException re) {
	           log.error("find by property name failed", re);
	           throw re;
	        }
	}

	public Pagination getPageInfo() {
		return pageInfo;
	}

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