package com.shop.Manager.Impl;

import com.shop.Manager.GoodsManager;
import com.shop.Model.Goods;
import com.shop.Util.Pager.PagerManager;
import com.shop.Util.Pager.PagerModel;

public class GoodsManagerImpl extends PagerManager implements GoodsManager {

	public void addGoods(Goods goods) {
		this.getHibernateTemplate().save(goods);

	}

	public void delGoods(int id) {
		this.getHibernateTemplate().delete(this.getGoodsById(id));

	}

	public Goods getGoodsById(int id) {
		
		return (Goods)this.getHibernateTemplate().get(Goods.class, id);
	}

	public PagerModel searchGoods(Goods goods) {
		String where = "";
		if(goods.getCode()!=null && goods.getCode()!=""){
			where = where+" and g.code = '"+goods.getCode()+"'";
		}
		if(goods.getName()!=null && goods.getName()!=""){
			where = where+" and g.name = '"+goods.getName()+"'";
		}
		
		String hql = "select g from Goods g where 1=1 "+where;
		return this.searchPaginated(hql);
	}

	public void updateGoods(Goods goods) {
		this.getHibernateTemplate().update(goods);

	}
	public Goods getGoodsByCode(String code){
		String hql = "select g from Goods g where g.code = '"+code+"'";
		return (Goods)this.getSession().createQuery(hql).uniqueResult();
	}
}