c32planorgdao.java

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

package com.je.ims.dao;


import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.je.ims.hibernate.*;


public class C32PlanOrgDao extends HibernateDaoSupport {
	
	 	public C32PlanOrgDao() {
	    }
	    
	
	 
	    public List getPlanOrg(Long planAreaId)
	    {
	   
	    	   List L1=getHibernateTemplate().find("from PlanOrg c where c.id.planAreaId=? ",planAreaId);
	    	   return L1;
	    	  
	    }
	    public void deleteMgrAreaOrg(Long planAreaId)
	    {
	    	List c1=getPlanOrg(planAreaId);
	    	getHibernateTemplate().deleteAll(c1);
	    }
	    
	    public void savePlanOrg(Long planAreaId,String orgId,String orgName,Long showId)
	    {
	    	PlanOrgId c2=new PlanOrgId();
	    	c2.setPlanAreaId(planAreaId);
	    	c2.setOrgId(orgId);
	    	
	    	PlanOrg c1=new PlanOrg();
	    	c1.setOrgName(orgName);
	    	c1.setShowId(showId);
	    	c1.setId(c2);
	        getHibernateTemplate().saveOrUpdate(c1);
	    }
	    public void savePlanOrg(PlanOrg p)
	    {
	    	
	        getHibernateTemplate().saveOrUpdate(p);
	    }
	   //昨天進行到此  還需要上下移動和 提示用戶是否確定刪除
	    public List getAll(Long year)
	    {
	    	
	    	List list=getHibernateTemplate().find("select new PlanOrg(c.id,c.orgName,c.showId) from PlanOrg c,PlanArea p  where c.id.planAreaId= p.planAreaId and p.year="+year+" order by c.showId");
	    	
	    	PlanOrg temp;
	    	for(int i=0;i<list.size();i++){
				temp = (PlanOrg)list.get(i);
				temp.setShowId(new Long(i));
				getHibernateTemplate().update(temp);
			}
	    	list=getHibernateTemplate().find("select new PlanOrg(c.id,c.orgName,c.showId) from PlanOrg c,PlanArea p  where c.id.planAreaId= p.planAreaId and p.year="+year+" order by c.showId");

	    	return list;
	    }
	    public PlanOrg getPlanOrg(Long planAreaId,String orgId)
	    {
	   
	    	List L1=getHibernateTemplate().find("from PlanOrg c where c.id.planAreaId=? and c.id.orgId=?",new Object[]{planAreaId,orgId});
	    	
	        if (L1.size()>0) return ((PlanOrg)L1.get(0));
	            else return null;
	    	  
	    }
	    
	    public void deletePlanOrg(Long planAreaId,String orgId)
	    {
	    	PlanOrg c1=getPlanOrg(planAreaId,orgId);
	    	getHibernateTemplate().delete(c1);
	    }
	    public void update(PlanOrg p)
	    {
	    	getHibernateTemplate().update(p);
	    }
	    public PlanOrg getPlanOrgByShowId(Long showId,Long planAreaId)
	    {
	    	List l=getHibernateTemplate().find("from PlanOrg c where c.showId=? and c.id.planAreaId=?",new Object[]{showId,planAreaId});
	    	if(l.size()>0)
	    		return (PlanOrg)l.get(0);
	    	else
	    		return null;
	    }
	    public void up(Long showId,Long planAreaId)
	    {
	    	if(showId.intValue()>0)
	    	{
	    		PlanOrg p1,p2;
	    		p1=this.getPlanOrgByShowId(showId,planAreaId);
	    		p2=this.getPlanOrgByShowId(new Long(showId.intValue()-1),planAreaId);
	    		if((p1!=null)&&(p2!=null))
	    		{
	    			p1.setShowId(new Long(showId.intValue()-1));
	    			p2.setShowId(showId);
	    			getHibernateTemplate().update(p1);
	    			getHibernateTemplate().update(p2);
	    		}
	    	}
	    }
	    
	    public void down(Long showId,Long planAreaId)
	    {
	    	
	    		PlanOrg p1,p2;
	    		p1=this.getPlanOrgByShowId(showId,planAreaId);
	    		p2=this.getPlanOrgByShowId(new Long(showId.intValue()+1),planAreaId);
	    		if((p1!=null)&&(p2!=null))
	    		{
	    			p1.setShowId(new Long(showId.intValue()+1));
	    			p2.setShowId(showId);
	    			getHibernateTemplate().update(p1);
	    			getHibernateTemplate().update(p2);
	    		}
	    	
	    }
	    
	    
	    
	    
	    
	   
	  

}