SubscriberItemManager.java

package com.norteksoft.acs.service.sale;

import java.util.List;

import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.norteksoft.acs.base.orm.hibernate.SimpleHibernateTemplate;
import com.norteksoft.acs.entity.sale.SubscriberItem;

@Service
@Transactional
public class SubscriberItemManager {
	
	private SimpleHibernateTemplate<SubscriberItem, Long> itemDao;
	
	@Autowired
	public void setSessionFactory(SessionFactory sessionFactory) {
		itemDao = new SimpleHibernateTemplate<SubscriberItem, Long>(sessionFactory, SubscriberItem.class);
	}
	
	public void saveItem(SubscriberItem item){
		itemDao.save(item);
	}
	
	@SuppressWarnings("unchecked")
	public List<SubscriberItem> queryItems(Long companyId, String sysCode){
		StringBuilder hql = new StringBuilder();
		hql.append("select si from SubscriberItem si, BusinessSystem bs ");
		hql.append("where si.subsciber.tenantId=? and si.product.systemId=bs.id and bs.code=? ");
		hql.append("order by si.invalidDate desc ");
		return itemDao.find(hql.toString(), companyId, sysCode);
	}
}