using System;
using System.Data;
using System.Data.SqlClient;
using Data_Common;
using Model;

namespace Data_Access
{
	/// <summary>
	/// DBAllCity 的摘要說明。
	/// </summary>
	public class DBAllCity:IDBAllCity
	{
		public DBAllCity(){}
		//定義查詢的字符串
		private const string Sql_select_AllCityInfo="SELECT * FROM DistrictMap WHERE ProName=@ProName";
		//定義參數
		private const string Parm_ProName="@ProName";
		//獲取所有參數的
		private static SqlParameter[] GetAllCity()
		{
			SqlParameter[] parms=Sqlhelp.GetCachedParameters(Sql_select_AllCityInfo);
			if(parms==null)
			{
				parms=new SqlParameter[]{
											new SqlParameter(Parm_ProName,SqlDbType.VarChar,20)
										};
				Sqlhelp.CacheParameters(Sql_select_AllCityInfo,parms);
			}
			return parms;
		}
		/// <summary>
		/// 根據點擊區域獲取所有城市信息
		/// </summary>
		/// <param name="scheduleCode">列車時刻代碼</param>
		/// <returns>所有城市信息</returns>
		public AllCity[] GetAllCity(string Pro)
		{
			SqlParameter[] parms=GetAllCity();
			parms[0].Value=Pro;
			
			DataTable dt=Sqlhelp.ExecuteDataTable(ConnectionInfo.ConnectionString(),Sql_select_AllCityInfo,CommandType.Text,parms);

			AllCity[] ProName = new AllCity[dt.Rows.Count];
			AllCity x;

	
			for(int i=0;i<dt.Rows.Count;i++)
			{
				x=new AllCity();
				x._ProName=dt.Rows[i][1].ToString();
				x._CityName=dt.Rows[i][2].ToString();								
				ProName[i]=x;
			}

			return ProName;
		} 


	}
}