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

namespace Data_Access
{
	/// <summary>
	/// DBDetailInfo 的摘要說明---顏政.。
	/// </summary>
	public class DBDetailInfo:IDBDetailInfo
	{
		//定義查詢的字符串
		private const string Sql_select_TrainDetailInfo="SELECT * FROM RouteInfo WHERE TrainNO=@TrainNO ORDER BY TrainNO,CityNo";
		//定義參數
		private const string Parm_TrainNo="@TrainNO";

		public DBDetailInfo(){}

		//獲取所有參數的
		private static SqlParameter[] GetTrainDetailInfo()
		{
			SqlParameter[] parms=Sqlhelp.GetCachedParameters(Sql_select_TrainDetailInfo);
			if(parms==null)
			{
				parms=new SqlParameter[]{
											new SqlParameter(Parm_TrainNo,SqlDbType.VarChar,20)
										};
				Sqlhelp.CacheParameters(Sql_select_TrainDetailInfo,parms);
			}
			return parms;
		}

		
		/// <summary>
		/// 根據列車時刻代碼獲取所有列車信息
		/// </summary>
		/// <param name="scheduleCode">列車時刻代碼</param>
		/// <returns>所有列車信息</returns>
		public Train_DetailInfo[] GetTrainDetailInfo(string scheduleCode)
		{
			SqlParameter[] parms=GetTrainDetailInfo();
			parms[0].Value=scheduleCode;
			
			DataTable dt=Sqlhelp.ExecuteDataTable(ConnectionInfo.ConnectionString(),Sql_select_TrainDetailInfo,CommandType.Text,parms);

			Train_DetailInfo[] schedule=new Train_DetailInfo[dt.Rows.Count];
			Train_DetailInfo x;
	
			for(int i=0;i<dt.Rows.Count;i++)
			{
				x=new Train_DetailInfo();				
				x.schedulecode=dt.Rows[i][1].ToString();
				x.cityname=dt.Rows[i][2].ToString();
				x.arrivaltime=DateTime.Parse(dt.Rows[i][3].ToString());
				x.leavetime=DateTime.Parse(dt.Rows[i][4].ToString());;
				x.days=int.Parse(dt.Rows[i][5].ToString());
				x.distance=int.Parse(dt.Rows[i][6].ToString());
				x.cid=int.Parse(dt.Rows[i][7].ToString());
				
				
				schedule[i]=x;
			}

			return schedule;		
		}
	}
}