c33mgrorgdao.java

使用spring ,hibernate 框架的稽查管理系统

package com.je.ims.dao;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.je.ims.hibernate.MgrKind;
import com.je.ims.hibernate.MgrKindId;
import com.je.ims.hibernate.MgrOrg;

public class c33MgrOrgDao extends HibernateDaoSupport {
	
	private c33BtreeDao btreedao;
	public void setBtreedao(c33BtreeDao c){
		btreedao=c;
	}
	
	 public List getMgrOrg(Long year,Long month)
	    {
			Long yea=new Long(year.intValue()+1911);
	    	List L1=getHibernateTemplate().find("from MgrOrg c where c.year="+yea+"and c.month="+month);
	    	
	        return L1;
	    	  
	    }
	 public List getMgrOrg(Long year,Long month,String kindid)
	    {
			Long yea=new Long(year.intValue()+1911);
	    	List L1=getHibernateTemplate().find("from MgrOrg c where c.year="+yea+"and c.month="+month+"and c.kindId='"+kindid+"'");
	    	
	        return L1;
	    	  
	    }
	 
	 public List getMgrOrg(Long year,Long month,Long areapk,String orgid)
	    {
			Long yea=new Long(year.intValue()+1911);
	    	List L1=getHibernateTemplate().find("from MgrOrg c where c.year="+yea+"and c.month="+month+"and c.areaPk="+areapk+"and c.orgId='"+orgid+"'");
	    	
	        return L1;
	    	  
	    }
	 public Long getMgrOrg(Long year,Long month,Long areapk,String orgid,String kindId)
	    {
		    Long yea=new Long(year.intValue()+1911);
	    	List L1=getHibernateTemplate().find("from MgrOrg c where c.year="+yea+"and c.month="+month+"and c.areaPk="+areapk+"and c.orgId='"+orgid+"'"+"and c.kindId='"+kindId+"'");
	    	if(L1.size()>0)
	    	{ MgrOrg mgrorg=null;
	    		mgrorg=(MgrOrg)L1.get(0);
	    	   return mgrorg.getMgrOrgPk();
	    	}
	    	else
	    	return null;
	    	  
	    }
	 
	 public MgrOrg getMgrOrg1(Long year,Long month,Long areapk,String orgid,String kindId)
	    {
		    Long yea=new Long(year.intValue()+1911);
	    	List L1=getHibernateTemplate().find("from MgrOrg c where c.year="+yea+"and c.month="+month+"and c.areaPk="+areapk+"and c.orgId='"+orgid+"'"+"and c.kindId='"+kindId+"'");
	    	
	    	if(L1.size()>0)
	    		
	    	
	    	return(	(MgrOrg)L1.get(0));
	    	  
	    
	    	else
	    	return null;
	    	  
	    }
	 
	 public void saveMgrOrg(Long year,Long month,Long areapk,String area,String orgid,String orgname,String kindid)
	    {
	    	MgrOrg c1=new MgrOrg();
	    	Long yea=new Long(year.intValue()+1911);
	    	c1.setYear(yea);
	    	c1.setMonth(month);
	    	c1.setKindId(kindid);
	    	c1.setArea(area);
	    	c1.setAreaPk(areapk);
	    	c1.setAb("B");
	    	c1.setOrgId(orgid);
	    	c1.setOrgName(orgname);
	    	
	    	
	    	
	    	
	    	String nodename=btreedao.getBtree(year,kindid).getNodeName();
	    	c1.setNodeName(nodename);
	        getHibernateTemplate().saveOrUpdate(c1);
	    }
	 public void delMgrOrg(Long year,Long month,Long areapk,String orgid,String kindId){
		 MgrOrg mgrorg=null;
		 mgrorg=getMgrOrg1( year, month, areapk, orgid,kindId);
		 getHibernateTemplate().delete(mgrorg);
	 }

}