package com.chinatech.cpmanage.service.impl;

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

import com.chinatech.cpmanage.common.BusinessException;
import com.chinatech.cpmanage.common.DAOException;
import com.chinatech.cpmanage.dao.ColumnDAO;
import com.chinatech.cpmanage.dao.OperLogDAO;
import com.chinatech.cpmanage.dto.ColumnDTO;
import com.chinatech.cpmanage.hibernate.CpmanageOperatorLog;
import com.chinatech.cpmanage.hibernate.CpmanageTitletree;
import com.chinatech.cpmanage.service.ColumnService;

public class ColumnServiceImpl implements ColumnService {
	private OperLogDAO operLogDAO;
	public void setOperLogDAO(OperLogDAO operLogDAO) {
		this.operLogDAO = operLogDAO;
	}
	public CpmanageTitletree getColumnById(String id) throws BusinessException {
		// TODO Auto-generated method stub
		try{
			return columnDAO.getColumnById(id);
		}
		catch(Exception e){
			throw new BusinessException("修改欄目出錯");
		}
	}
	public void modifyColumn(CpmanageTitletree title) throws BusinessException {
		// TODO Auto-generated method stub
		try{
			columnDAO.updateColumn(title);
		}
		catch(Exception e){
			throw new BusinessException("修改欄目出錯");
		}
	}
	public void removeColumnById(String id) throws BusinessException {
		// TODO Auto-generated method stub
		try{
			columnDAO.deleteById(id);
		}
		catch(Exception e){
			throw new BusinessException("刪除欄目出錯");
		}
	}
	private ColumnDAO columnDAO;
	public List getColumn(ColumnDTO dto) throws BusinessException{
		try{
			List columnList=columnDAO.getColumn(dto);
			List list=new ArrayList();
			Iterator it=columnList.iterator();
			while(it.hasNext()){
				ColumnDTO columndto=new ColumnDTO();
				CpmanageTitletree colog=(CpmanageTitletree)it.next();  //查詢到的結果
				columndto.setGrade(colog.getGrade());
				columndto.setTitleName(colog.getTitlename());                    //地區號
				columndto.setContestDes(colog.getContestdes()); 			 //日志內容
				columndto.setCpcp_bybszm(colog.getCpcpBybszm());    //操作員類型
				columndto.setCpcp_byfee(colog.getCpcpByfee());		 //操作員ID
				columndto.setCpcp_byqxbszm(colog.getCpcpByqxbszm());	 //操作類型
				columndto.setCpcp_dbbszm(colog.getCpcpDbbszm());	
				columndto.setServiceCode(colog.getServicecode());//操作時間
				columndto.setCpcp_dbfee(colog.getCpcpDbfee());
				columndto.setTitleId(colog.getTitleid());  //欄目ID
				
				System.out.println();
				list.add(columndto);
			}
			return list;
		}catch(DAOException e){
			throw new BusinessException("getColumn方法出錯!");
		}
	}
	public List getColumnByPage(ColumnDTO dto, int startRows, int pageSize) throws BusinessException {
		try{
			List columnList=columnDAO.getColumnByPage(dto, startRows, pageSize);
			List list=new ArrayList();
			for(int i=0;i<columnList.size();i++){
				ColumnDTO columndto=new ColumnDTO();
				CpmanageTitletree colog=(CpmanageTitletree)columnList.get(i);  //查詢到的結果
				columndto.setGrade(colog.getGrade());
				columndto.setTitleName(colog.getTitlename());                    //地區號
				columndto.setContestDes(colog.getContestdes()); 			 //日志內容
				columndto.setCpcp_bybszm(colog.getCpcpBybszm());    //操作員類型
				columndto.setCpcp_byfee(colog.getCpcpByfee());		 //操作員ID
				columndto.setCpcp_byqxbszm(colog.getCpcpByqxbszm());	 //操作類型
				columndto.setCpcp_dbbszm(colog.getCpcpDbbszm());	
				columndto.setServiceCode(colog.getServicecode());//操作時間
				columndto.setCpcp_dbfee(colog.getCpcpDbfee());
				columndto.setTitleId(colog.getTitleid());  //ID
			//	System.out.println("aaaaaaaaaaaaaa titleid "+colog.getTitleid());
				list.add(columndto);
			}
			return list;
		}catch(DAOException e){
			throw new BusinessException("getColumnByPage()方法出錯!");
		}
	}
	public int getColumnCount(ColumnDTO dto) throws BusinessException {
		try{
			return columnDAO.getColumnCount(dto);
		}catch(DAOException e){
			throw new BusinessException("getColumnCount()方法出錯!");
		}
	}
	
	public ColumnDAO getColumnDAO() {
		return columnDAO;
	}
	public void setColumnDAO(ColumnDAO columnDAO) {
		this.columnDAO = columnDAO;
	}
	public void addColumn(CpmanageTitletree title)throws BusinessException{
		try{
		columnDAO.insertColumn(title);
		}catch(DAOException e){
			throw new BusinessException("insertColumn方法出錯！");
		}
	}
	public boolean hasSpSelectTitle(String id) throws BusinessException {
		try{
			return columnDAO.hasSpSelectTitle(id);
		}catch(DAOException e){
			throw new BusinessException("hasSpSelectTitle方法出錯!");
		}
	}
	public void addOperLog(CpmanageOperatorLog col) throws BusinessException {
		// TODO 自動生成方法存根
		try{
			operLogDAO.insertOperLog(col);
		}catch(DAOException e){
			throw new BusinessException("addOperLog方法出錯！" + e.getMessage());
		}
	}

}