WebpageDao.java

package com.norteksoft.portal.dao;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.norteksoft.portal.entity.Webpage;
import com.norteksoft.product.orm.hibernate.HibernateDao;
import com.norteksoft.product.util.ContextUtils;

@Repository
public class WebpageDao extends HibernateDao<Webpage, Long>{
  
	/**
	 * 根据用户id取页签
	 * @return
	 */
	public List<Webpage> getWebpageByUserId(){
		String hql = "FROM Webpage w WHERE w.userId=? AND w.companyId=? ORDER BY w.displayOrder";
		return this.find(hql,ContextUtils.getUserId(),ContextUtils.getCompanyId());
	}
	
	public Webpage getWebpageByCode(String code){
		List<Webpage> pages=this.find("from Webpage w where w.code=?", code);
		if(pages.size()>0)return pages.get(0);
		return null;
	}
	
	public Webpage getWebpage(){
		List<Webpage> pages=this.find("from Webpage w where w.userId is null and w.acquiescent=?", true);
		if(pages.size()>0)return pages.get(0);
		return null;
	}
	public Webpage getWebpage(Long companyId){
		List<Webpage> pages=this.find("from Webpage w where w.userId is null and w.acquiescent=? and w.companyId=?", true,companyId);
		if(pages.size()>0)return pages.get(0);
		return null;
	}
	
	public int getMaxPageOrderNumber(){
		return Integer.parseInt(this.findUnique("select max(w.displayOrder) from Webpage w where w.userId=? AND w.companyId=? ", 
				ContextUtils.getUserId(), 
				ContextUtils.getCompanyId()).toString());
	}
	
}