schedulesystem.cs

列车时刻查询Visual Studio 2005 + sql2005

using System;
using System.Data;

namespace train
{
	/// <summary>
	/// ScheduleSystem：业务
	/// </summary>
	public class ScheduleSystem
	{
		public Schedule schedule;
		private frmMain frmtrain;
		private DataTable dt;
		public ScheduleSystem(frmMain frmtrain)
		{
			this.frmtrain=frmtrain;
			schedule=new Schedule();
			dt=new DataTable();
			
		}


		/// <summary>
		/// 根据起点站、终点站得到列车信息
		/// </summary>
		/// <param name="fromcity">起点站</param>
		/// <param name="tocity">终点站</param>
		public void GetScheduleList(string fromcity,string tocity)
		{	
			//			frmtrain.dgtraindetails.DataSource=null;
			frmtrain.dgtrainresult.DataSource=schedule.SearchScheduleList(fromcity,tocity);
			dt=(DataTable)frmtrain.dgtrainresult.DataSource;
			//如果没有直达车则选择中间站
			if(dt.Rows.Count==0)
			{
				frmtrain.btnexportxml.Visible=false;
				frmtrain.btnexport.Visible=false;
				frmtrain.btnprint.Visible=false;
				GetMidList(tocity);
			}
			else
			{
				frmtrain.btnexportxml.Visible=true;
				frmtrain.btnexport.Visible=true;
				frmtrain.btnprint.Visible=true;
			}
			
			frmtrain.tabdisplay.SelectedIndex=1;
			
		}


		/// <summary>
		/// 显示用用户单击某列车的详细信息
		/// </summary>
		/// <param name="code">列车的车次</param>
		public void GetMidScheduleList(string code)
		{
			frmtrain.dgtraindetails.DataSource=schedule.SearchMidScheduleList(code);
			frmtrain.tabdisplay.SelectedIndex=2;
			frmtrain.btnprint.Visible=true;
			frmtrain.btnexport.Visible=true;
			frmtrain.btnexportxml.Visible=true;
		}


		/// <summary>
		/// 得到中间站的信息
		/// </summary>
		/// <param name="tocity">终点站的名字</param>
		private void GetMidList(string tocity)
		{
			frmtrain.cboMdiStation.DataSource=schedule.SearchMidList(tocity);
			frmtrain.cboMdiStation.DisplayMember="cityname";
			frmtrain.cboMdiStation.DroppedDown=true;
			frmtrain.dgtraindetails.DataSource=null;

		}


		/// <summary>
		/// 根据列车的车次获得列车详细信息
		/// </summary>
		/// <param name="code">列车车次</param>
		public void GetScheduleByCode(string code)
		{
			frmtrain.dgtrainresult.DataSource=schedule.SearchScheduleByCode(code);
			dt=(DataTable)frmtrain.dgtrainresult.DataSource;
			if(dt.Rows.Count==0)
			{
				frmtrain.btnexportxml.Visible=false;
				frmtrain.btnexport.Visible=false;
				frmtrain.btnprint.Visible=false;
			}
			else
			{
				frmtrain.btnexportxml.Visible=true;
				frmtrain.btnexport.Visible=true;
				frmtrain.btnprint.Visible=true;
			}
			frmtrain.tabdisplay.SelectedIndex=1;
		}
		
		/// <summary>
		/// 根据选择的中间站得到起点站、中间站、终点站的详细信息
		/// </summary>
		/// <param name="fromcity">起点站</param>
		/// <param name="midcity">中间站</param>
		/// <param name="finalcity">终点站</param>
		public void GetMidStation(string fromcity,string midcity,string finalcity)
		{
			frmtrain.dgtrainresult.DataSource=schedule.SearchMidStation(fromcity,midcity,finalcity);
			dt=(DataTable)frmtrain.dgtrainresult.DataSource;
			if(dt.Rows.Count==0)
			{
				frmtrain.btnexportxml.Visible=false;
				frmtrain.btnexport.Visible=false;
				frmtrain.btnprint.Visible=false;
			}
			else
			{
				frmtrain.btnexportxml.Visible=true;
				frmtrain.btnexport.Visible=true;
				frmtrain.btnprint.Visible=true;
			}
			frmtrain.tabdisplay.SelectedIndex=1;
		}

		/// <summary>
		/// 打印按扭的显示与隐藏
		/// </summary>
		public void showprintbutton()
		{
				switch(frmtrain.tabdisplay.SelectedIndex)
				{
					case 1:
						if(frmtrain.dgtrainresult.DataSource!=null)
						{
							dt=(DataTable)frmtrain.dgtrainresult.DataSource;
							if(dt.Rows.Count!=0)
							{
								frmtrain.btnexportxml.Visible=true;
								frmtrain.btnexport.Visible=true;
								frmtrain.btnprint.Visible=true;
							}
							else
							{
								frmtrain.btnexportxml.Visible=false;
								frmtrain.btnexport.Visible=false;
								frmtrain.btnprint.Visible=false;
							}
						}
						else
						{
							frmtrain.btnexportxml.Visible=false;
							frmtrain.btnexport.Visible=false;
							frmtrain.btnprint.Visible=false;
						}
						break;
					case 2:
						if(frmtrain.dgtraindetails.DataSource!=null)
						{
							dt=(DataTable)frmtrain.dgtraindetails.DataSource;
							if(dt.Rows.Count!=0)
							{
								frmtrain.btnexportxml.Visible=true;
								frmtrain.btnexport.Visible=true;
								frmtrain.btnprint.Visible=true;
							}
							else
							{
								frmtrain.btnexportxml.Visible=false;
								frmtrain.btnexport.Visible=false;
								frmtrain.btnprint.Visible=false;
							}
						}
						else
						{
							frmtrain.btnexportxml.Visible=false;
							frmtrain.btnexport.Visible=false;
							frmtrain.btnprint.Visible=false;
						}
						break;
					case 0:
						frmtrain.btnexportxml.Visible=false;
						frmtrain.btnexport.Visible=false;
						frmtrain.btnprint.Visible=false;
						break;
				}
			
		
		}

		/// <summary>
		/// 导入数据
		/// </summary>
		/// <returns>返回一个bool值以表示是否导入成功</returns>
		public bool ImportData()
		{
			ImportData importdata=new ImportData();
			dt=importdata.ImportDataFromXml();
			if(dt!=null)
			{
				frmtrain.dgtrainresult.DataSource=dt;
				frmtrain.tabdisplay.SelectedIndex=1;
				return true;
			}
			else
			{
				return false;
			}
		}
	}
}