package com.chinatech.cpmanage.service.impl;

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

import com.chinatech.cpmanage.service.ColumnStatService;
import com.chinatech.cpmanage.dao.ColumnStatDAO;
import com.chinatech.cpmanage.dao.OperDAO;
import com.chinatech.cpmanage.common.BusinessException;
import com.chinatech.cpmanage.common.DAOException;
import com.chinatech.cpmanage.hibernate.NyxxwTitletree;


public class ColumnStatServiceImpl implements ColumnStatService{
	
	private ColumnStatDAO columnStatDAO;
	private OperDAO operDAO;
	
	public List getSpByAreaId(String areaid) throws BusinessException {
		// TODO 自動(dòng)生成方法存根
		List list=new ArrayList();
		try{	
			list=operDAO.getOperesByAreaid(areaid,"1");
		}catch(Exception e){
			throw new BusinessException("執(zhí)行g(shù)etSpByAreaId方法時(shí)出錯(cuò)");
		}
		return list;
	}
	
	public List getMultiColumns(String spid) throws BusinessException {
		// TODO 自動(dòng)生成方法存根
		List list=new ArrayList();
		try{
			list=columnStatDAO.getMultiColumns(spid);
		}catch(Exception e){
			throw new BusinessException("執(zhí)行g(shù)etMultiColumns方法時(shí)出錯(cuò)");
		}
		return list;
	}
	
	public List getMultiColumnsPage(int startRow, int pageSize,String id) throws BusinessException {
		// TODO 自動(dòng)生成方法存根
		List list=new ArrayList();
		try{
			list=columnStatDAO.getMultiColumnsPage(startRow, pageSize, id);
		}catch(Exception e){
			throw new BusinessException("執(zhí)行g(shù)etMultiColumnsPage方法時(shí)出錯(cuò)");
		}
		return list;
	}
	
	public int getSingleColumnsStat(String query) throws BusinessException {
		// TODO 自動(dòng)生成方法存根
		try{
			return columnStatDAO.getSingleColumnsStat(query);
		}catch(DAOException e){
			throw new BusinessException("getSingleColumnsStat方法出錯(cuò)！" + e.getMessage());
		}
	}
	
	public NyxxwTitletree getSpById(String spid) throws BusinessException {
		NyxxwTitletree obj = null;
		try{
			obj = columnStatDAO.getSpById(spid);
		}catch(DAOException e){
			throw new BusinessException("執(zhí)行g(shù)etSpById方法出錯(cuò)！");
		}
		return obj;
}
	
	

	public ColumnStatDAO getColumnStatDAO() {
		return columnStatDAO;
	}

	public void setColumnStatDAO(ColumnStatDAO columnStatDAO) {
		this.columnStatDAO = columnStatDAO;
	}

	public void setOperDAO(OperDAO operDAO) {
		this.operDAO = operDAO;
	}
}