/**
 * 
 */
package com.ascent.dao.hibernate;

import java.util.ArrayList;
import java.util.List;

import org.apache.log4j.LogManager;
import org.apache.log4j.Logger;
import org.springframework.orm.hibernate.support.HibernateDaoSupport;

import com.ascent.bean.Orderitem;
import com.ascent.dao.IOrderItemDAO;

public class OrderItemHibernateDAO extends HibernateDaoSupport implements
		IOrderItemDAO {

	private static final Logger LOGGER = LogManager
			.getLogger(OrderItemHibernateDAO.class);

	private static final String LOAD_ALL = "from Orderitem oi order by oi.orderItemId desc";

	private static final String LOAD_BY_BOOK = "from Orderitem oi where oi.bookId = ? order by oi.orderItemId desc";

	private static final String LOAD_BY_ORDERID = "from Orderitem oi where oi.orderId = ? order by oi.orderItemId desc";

	/**
	 * 
	 */
	public OrderItemHibernateDAO() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * 
	 * @param Orderitem
	 * @return Orderitem
	 */
	public Orderitem saveOrderitem(Orderitem orderitem) {
		try {
			LOGGER.debug("保存訂單明顯項到數(shù)據(jù)庫！");
			this.getHibernateTemplate().save(orderitem);
			return orderitem;
		} catch (Exception ex) {
			LOGGER.error("保存訂單明細(xì)項到數(shù)據(jù)庫失敗！");
			ex.printStackTrace();
			return null;
		}
	}

	/**
	 * 
	 * @param id
	 *            Integer
	 * 
	 * @return Orderitem
	 */
	public Orderitem getOrderitem(Integer id) {
		LOGGER.debug("根據(jù)訂單明細(xì)項ID獲取該訂單項信息！");
		return (Orderitem) this.getHibernateTemplate().get(Orderitem.class, id);
	}

	/**
	 * 
	 * @return List
	 */
	public List findOrderitemAll() {
		try {
			LOGGER.debug("獲取所有訂單明顯項列表！");
			return this.getHibernateTemplate().find(LOAD_ALL);
		} catch (Exception ex) {
			LOGGER.error("獲取所有訂單明明細(xì)項列表失??！");
			ex.printStackTrace();
			return new ArrayList();
		}
	}

	/**
	 * 
	 * @param type
	 *            String
	 * 
	 * @return List
	 */
	public List findOrderitemByBook(Integer bookId) {
		try {
			LOGGER.debug("根據(jù)書籍ID獲取對應(yīng)該書的所有訂單明細(xì)項列表！");
			return this.getHibernateTemplate().find(LOAD_BY_BOOK, bookId);
		} catch (Exception ex) {
			LOGGER.error("根據(jù)書籍ID獲取對應(yīng)該書的所有訂單明細(xì)項列表失敗！");
			ex.printStackTrace();
			return new ArrayList();
		}
	}

	public List findOrderitemByOrderId(Integer orderId) {
		try {
			LOGGER.debug("根據(jù)訂單ID獲取對應(yīng)該書的所有訂單明細(xì)項列表！");
			return this.getHibernateTemplate().find(LOAD_BY_ORDERID, orderId);
		} catch (Exception ex) {
			LOGGER.error("根據(jù)訂單ID獲取對應(yīng)該書的所有訂單明細(xì)項列表失??！");
			ex.printStackTrace();
			return new ArrayList();
		}
	}

	/**
	 * 
	 * @param Orderitem
	 * 
	 */
	public void removeOrderItem(Orderitem orderitem) {
		LOGGER.debug("刪除指定的訂單明細(xì)項");
		this.getHibernateTemplate().delete(orderitem);
	}

}