package com.yuanchung.sales.dao.busiOpport.impl;

import java.util.List;

import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.yuanchung.sales.dao.busiOpport.BoStageHistoryDAO;
import com.yuanchung.sales.exception.SystemException;
import com.yuanchung.sales.model.businessOpportunity.BusinessOpportunityStageHistory;

public class BoStageHistoryDAOImpl extends HibernateDaoSupport implements
		BoStageHistoryDAO {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

	}

	/**
	 * 添加階段歷史 by 張明強 time：2009-02-09
	 */

	public void addBoStageHistory(BusinessOpportunityStageHistory boStageHistory)
			throws DataAccessException {
		this.getHibernateTemplate().save(boStageHistory);
	}

	/**
	 * 通過業務機會主鍵(busiOpportID)查找業務機會階段歷史集
	 */
	public List<BusinessOpportunityStageHistory> getByBusiOpportID(
			int busiOpportID) throws DataAccessException {
		return this
				.getHibernateTemplate()
				.find(
						"from BusinessOpportunityStageHistory as bosh where bosh.businessOpportunityId=?",
						busiOpportID);
	}
	
	
	public void deleteByObject(BusinessOpportunityStageHistory bosh) throws DataAccessException {
		try{
			this.getHibernateTemplate().delete(bosh);
			logger.debug("刪除成功～～～");
		}catch(Exception e){
			e.printStackTrace();
			logger.error(e.getMessage());
			throw new SystemException(e.getMessage());
		}
	}

}