package com.oyc.mapxtreme.dao;

import java.util.List;

import com.oyc.mapxtreme.beans.TravelAgencyBean;
import com.oyc.wakeup.Session;

/**
 * 旅行社dao,操作表tb_travelAgency
 * @author 三峽大學理學院 歐陽超
 *
 */
public class TravelAgencyDAO {
	
	/** 數據庫會話對象 **/
	private Session sess=null;
	
	/**
	 * 構造器:根據數據庫會話來創建一個通訊錄管理器
	 * @param sess 數據庫會話對象
	 */
	public TravelAgencyDAO(Session sess){
		this.sess=sess;
	}
	
	/**
	 * 根據旅行社ID取得旅行社Bean
	 * @param taID 旅行社ID
	 * @return
	 */
	public TravelAgencyBean getTravelById(int taID){
		List list = null;
		try {
			String sql = "select * from tb_travelAgency where taID=" + taID;
			list = sess.query(sql, TravelAgencyBean.class);
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(list != null && list.size() > 0){
			return (TravelAgencyBean) list.get(0);
		}else{
			return null;
		}
	}
	
	/**
	 * 搜索與關鍵字配置的旅行社Bean
	 * @param taName 旅行社名稱
	 * @return
	 */
	public List searchTravelByName(String taName){
		List list = null;
		try {
			String sql = "select * from tb_travelAgency where taName like '%"+ taName +"%'";
			list = sess.query(sql, TravelAgencyBean.class);
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(list != null && list.size() > 0){
			return list;
		}else{
			return null;
		}
	}
	
	public List searchTravelByIDAry(int[] taIDAry){
		List list = null;
		//組裝sql語句
		String sql = "select * from tb_travelAgency where ";
		for(int i=0; i<taIDAry.length; i++){
			sql += "taID=" + taIDAry[i] + " or ";
		}
		sql = sql.substring(0, sql.length()-4);
		
		try {
			list = sess.query(sql, TravelAgencyBean.class);
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(list != null && list.size() > 0){
			return list;
		}else{
			return null;
		}
	}

}