InternationOptionDao.java

package com.norteksoft.bs.options.dao;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.norteksoft.bs.options.entity.InternationOption;
import com.norteksoft.product.orm.Page;
import com.norteksoft.product.orm.hibernate.HibernateDao;
@Repository
public class InternationOptionDao extends HibernateDao<InternationOption,Long>{
	public void getInternationOptions(Page<InternationOption> page,Long interId){
		String hql="from InternationOption t where t.internation.id=? order by t.id desc";
		this.searchPageByHql(page, hql,interId);
	}
	
	public List<InternationOption> getInternationOptions(Long interId){
		String hql="from InternationOption t where t.internation.id=? order by t.id desc";
		return this.find(hql, interId);
	}
	
	public InternationOption getInternationOptionByInfo(Long category,String categoryName,String value,String internationCode){
		String hql="from InternationOption t where t.category=? and t.categoryName=? and t.value=? and t.internation.code=?  order by t.id desc";
		List<InternationOption> opts=this.find(hql, category,categoryName,value,internationCode);
		if(opts.size()>0)return opts.get(0);
		return null;
	}
}