stuffinfodao.java

有关医院方向的开发

package com.woyi.dao;
// default package


import java.text.SimpleDateFormat;
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.Group;
import com.woyi.dto.Organization;
import com.woyi.dto.Stuffinfo;
import com.woyi.page.PageInfo;
import com.woyi.page.Pagination;

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

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

	// property constants
	public static final String STUFFID = "stuffid";

	public static final String STUFFNAME = "stuffname";

	public static final String SEX = "sex";

	public static final String ORGCODE = "orgcode";

	public static final String GROUPID = "groupid";

	public static final String CARD_ID = "cardId";

	public static final String BIMCHG = "bimchg";

	public static final String SVCNUM = "svcnum";

	public static final String PHONE = "phone";

	public static final String EMAIL = "email";

	public static final String ADDRESS = "address";

	public static final String VALIDFLAG = "validflag";

	public static final String OPTRID = "optrid";

	public static final String STUFFDESC = "stuffdesc";

	public static final String REMARK = "remark";

	public Pagination pagination;	
	public Organization organization;
	public Group group;
	
	protected void initDao() {
		// do nothing
	}

	public void save(Stuffinfo transientInstance) {
		log.debug("saving Stuffinfo instance");
		try {
			getHibernateTemplate().save(transientInstance);
			log.debug("save successful");
		} catch (RuntimeException re) {
			log.error("save failed", re);
			throw re;
		}
	}

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

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

	public List findByExample(Stuffinfo instance) {
		log.debug("finding Stuffinfo 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 Stuffinfo instance with property: " + propertyName
				+ ", value: " + value);
		try {
			String queryString = "from Stuffinfo 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 findByStuffid(Object stuffid) {
		return findByProperty(STUFFID, stuffid);
	}

	public List findByStuffname(Object stuffname) {
		return findByProperty(STUFFNAME, stuffname);
	}

	public List findBySex(Object sex) {
		return findByProperty(SEX, sex);
	}

	public List findByOrgcode(Object orgcode) {
		return findByProperty(ORGCODE, orgcode);
	}

	public List findByGroupid(Object groupid) {
		return findByProperty(GROUPID, groupid);
	}

	public List findByCardId(Object cardId) {
		return findByProperty(CARD_ID, cardId);
	}

	public List findByBimchg(Object bimchg) {
		return findByProperty(BIMCHG, bimchg);
	}

	public List findBySvcnum(Object svcnum) {
		return findByProperty(SVCNUM, svcnum);
	}

	public List findByPhone(Object phone) {
		return findByProperty(PHONE, phone);
	}

	public List findByEmail(Object email) {
		return findByProperty(EMAIL, email);
	}

	public List findByAddress(Object address) {
		return findByProperty(ADDRESS, address);
	}

	public List findByValidflag(Object validflag) {
		return findByProperty(VALIDFLAG, validflag);
	}

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

	public List findByStuffdesc(Object stuffdesc) {
		return findByProperty(STUFFDESC, stuffdesc);
	}

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

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

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

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

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

	public static StuffinfoDAO getFromApplicationContext(ApplicationContext ctx) {
		return (StuffinfoDAO) ctx.getBean("StuffinfoDAO");
	}
	
	public PageInfo	fechstuff(String orgcode,String groupid,String stuffid,String stuffname,String validflag,int pageNo){
        log.debug("finding Optrinfo instance with property: " + groupid
        );
      try {
         String queryString = "from Stuffinfo as b where  b.stuffname like '%" +stuffname+"%' and b.stuffid like '%"+stuffid+"%' and b.validflag='"+validflag+"'";
         if(!orgcode.equals("")){
        	 queryString=queryString+" and b.orgcode='"+orgcode+"'";
         }
         if(!groupid.equals("")){
        	 queryString=queryString+" and b.groupid ='"+groupid+"'";
         }
         queryString=queryString+"  order by b.stuffid";

         String count = "select count(*) from  Stuffinfo as b where  b.stuffname like '%" +stuffname+"%' and b.stuffid like '%"+stuffid+"%' and b.validflag='"+validflag+"'";
         if(!orgcode.equals("")){
        	 count=count+" and b.orgcode='"+orgcode+"'";
         }
         if(!groupid.equals("")){
        	 count=count+" and b.groupid ='"+groupid+"'";
         }
         
         PageInfo pageInfo = pagination.page(pageNo, 10, queryString, count);
		 return pageInfo;
      } catch (RuntimeException re) {
         log.error("find by property name failed", re);
         throw re;
      }
	}
	

	/**
     * 查询通讯录信息
     * @param propertyName
     * @param value
     * @return
     */
    
    public PageInfo findStuffInfo(Integer partname,String stuffname,int pageno) {

        try {
        	StringBuffer sql = new StringBuffer();
        	sql.append("select obj from Stuffinfo obj,Organization b where obj.orgcode=b.orgcode");
        	if(null != partname &&!"".equals(partname))
        		sql.append(" and b.orgcode="+partname);
        	if(null != stuffname &&!"".equals(stuffname))
        		sql.append(" and obj.stuffname like '%"+stuffname+"%'");
           StringBuffer sql1 = new StringBuffer();
           sql1.append("select count(obj) from Stuffinfo obj,Organization b where obj.orgcode=b.orgcode");
           if(null != partname &&!"".equals(partname))
       		sql1.append(" and b.orgcode="+partname);
         	if(null != stuffname &&!"".equals(stuffname))
       		sql1.append(" and obj.stuffname like '%"+stuffname+"%'");
			PageInfo pageInfo1 = pagination.page(pageno,10,sql.toString(),sql1.toString());
  		    return pageInfo1;
        } catch (RuntimeException re) {
           log.error("find by property name failed", re);
           throw re;
        }
  	}
    
    
    /**
     * 查询发短信员工
     * @param propertyName
     * @param value
     * @return
     */
    
    public PageInfo querySendMessge(Stuffinfo info,int pageno) {

        try {
        	StringBuffer sql = new StringBuffer();
        	sql.append("select obj from Stuffinfo obj,Organization b,Group c where obj.orgcode=b.orgcode and (obj.groupid=c.groupid or c.groupid =null)");
        	if(null != info.getOrgcode() && info.getOrgcode()!=0 )
        		sql.append(" and obj.orgcode="+info.getOrgcode());
        	if(null != info.getGroupid() && info.getGroupid() !=0)
        		sql.append(" and obj.groupid like '%"+info.getGroupid()+"%'");
        	if(null != info.getSvcnum() &&!"".equals(info.getSvcnum()))
        		sql.append(" and obj.svcnum like '%"+info.getSvcnum()+"%'");
        	
           StringBuffer sql1 = new StringBuffer();
           sql1.append("select count(obj) from Stuffinfo obj,Organization b,Group c where obj.orgcode=b.orgcode and (obj.groupid=c.groupid or c.groupid =null)");
       		if(null != info.getOrgcode() && info.getOrgcode()!=0 )
       		sql1.append(" and obj.orgcode="+info.getOrgcode());
       		if(null != info.getGroupid() && info.getGroupid() !=0 )
       		sql1.append(" and obj.groupid like '%"+info.getGroupid()+"%'");
       		if(null != info.getSvcnum() &&!"".equals(info.getSvcnum()))
       		sql1.append(" and obj.svcnum like '%"+info.getSvcnum()+"%'");
			PageInfo pageInfo1 = pagination.page(pageno,10,sql.toString(),sql1.toString());
  		    return pageInfo1;
        } catch (RuntimeException re) {
           log.error("find by property name failed", re);
           throw re;
        }
  	}
    /**
     * 查询员工列表
     * @param validflag
     * @return
     */
    
    
	public List findStuffList(String validflag) {

		try {
			String queryString = "from Stuffinfo  where validflag = '"+validflag+
			"' and sqlertid not in (select stuffid from WageInfo where balmonth='"
			 + new SimpleDateFormat("yyyyMMdd").format(new Date()).substring(0,6)+"')";
			return getHibernateTemplate().find(queryString);
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}
    
	
    /**
     * 查询员工资本工资
     * @param validflag
     * @return
     */
    
    
	public List queryBaseWage(String flag) {

		try {
			String queryString = "from Stuffinfo  where validflag = '"+1+
			"' and sqlertid="+Integer.parseInt(flag);
			return getHibernateTemplate().find(queryString);
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}

	public Pagination getPagination() {
		return pagination;
	}

	public void setPagination(Pagination pagination) {
		this.pagination = pagination;
	}

	public Group getGroup() {
		return group;
	}

	public void setGroup(Group group) {
		this.group = group;
	}

	public Organization getOrganization() {
		return organization;
	}

	public void setOrganization(Organization organization) {
		this.organization = organization;
	}
}