c33mgrkinddao.java

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

package com.je.ims.dao;

import java.util.List;

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

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

public class c33MgrKindDao extends HibernateDaoSupport {
	  
	private c33BtreeDao btreedao;
	public void setBtreedao(c33BtreeDao c){
		btreedao=c;
	}
	
	
	 public List getMgrKind(Long year,Long month)
	    {
		 	Long yea=new Long(year.intValue()+1911);
	    	
	    	List L1=getHibernateTemplate().find("from MgrKind c where c.id.year="+yea+"and c.id.month="+month);
	    	
	        return L1;
	    	  
	    }
	 public MgrKind getMgrKind(Long year,Long month,String kindId)
	    {
		 	Long yea=new Long(year.intValue()+1911);
	    	
	    	List L1=getHibernateTemplate().find("from MgrKind c where c.id.year="+yea+"and c.id.month="+month+"and c.id.kindId='"+kindId+"'");
	    	if(L1.size()>0){return (MgrKind)L1.get(0);}
	    	else return null;
	    	  
	    }
	 public List getMgrKindno(Long year,Long month)
	    {
		 	Long yea=new Long(year.intValue()+1911);
	    	
	    	List L1=getHibernateTemplate().find("from MgrKind c where c.id.year="+yea+"and c.id.month="+month+"and c.isManager=0");
	    	
	        return L1;
	    	  
	    }
	 
	 public List getMgrKindm(Long year,Long month)
	    {
		 	Long yea=new Long(year.intValue()+1911);
	    	
	    	List L1=getHibernateTemplate().find("from MgrKind c where c.id.year="+yea+"and c.id.month="+month+"and c.isManager=1");
	    	
	        return L1;
	    	  
	    }
	 public void saveMgrKindno(Long year,Long month,String kindid)
	    {
	    	MgrKindId c2=new MgrKindId();
	    	Long yea=new Long(year.intValue()+1911);
	    	c2.setYear(yea);
	    	c2.setMonth(month);
	    	c2.setKindId(kindid);
	    	MgrKind c1=new MgrKind();
	    	c1.setId(c2);
	    	c1.setAb("B");
	    	c1.setIsFinish(new Long(1));
	    	c1.setIsManager(new Long(0));
	    	c1.setNo("");
	    	String nodename=btreedao.getBtree(year,kindid).getNodeName();
	    	c1.setNodeName(nodename);
	        getHibernateTemplate().saveOrUpdate(c1);
	    }
	 public void delMgrKindno(Long year,Long month,String kindid)
	    {
	    	
	    	MgrKind c1=new MgrKind();
	    	c1=getMgrKind( year, month, kindid);
	    	c1.setNo("");
	        getHibernateTemplate().delete(c1);
	    }
	 public void saveMgrKind(Long year,Long month,String kindid)
	    {
	    	MgrKindId c2=new MgrKindId();
	    	Long yea=new Long(year.intValue()+1911);
	    	c2.setYear(yea);
	    	c2.setMonth(month);
	    	c2.setKindId(kindid);
	    	MgrKind c1=new MgrKind();
	    	c1.setId(c2);
	    	c1.setAb("B");
	    	c1.setIsFinish(new Long(0));
	    	c1.setIsManager(new Long(1));
	    	c1.setNo("");
	    	String nodename=btreedao.getBtree(year,kindid).getNodeName();
	    	c1.setNodeName(nodename);
	        getHibernateTemplate().saveOrUpdate(c1);
	    }
	 public void updateMgrKind(Long year,Long month,String kindid,Long finish){
		 MgrKind c1=new MgrKind( );
			
		 c1=this.getMgrKind(year,month,kindid);
		 c1.setIsFinish(finish);
		 c1.setNo("");
		 getHibernateTemplate().saveOrUpdate(c1);
		 
	 }
	 public void delMgrKind(Long year,Long month,String kindid){
		MgrKind mgrkind= getMgrKind( year, month, kindid);
		mgrkind.setNo("");
		getHibernateTemplate().delete(mgrkind);
	 }
	 
	 public void setMgrKindno(Long year,Long month,String kindid,String no){
		 MgrKind mgrkind= getMgrKind( year, month, kindid);
		 mgrkind.setNo(no);
		 getHibernateTemplate().saveOrUpdate(mgrkind);
	 }
	 
}