flights.cs

VsualStudio2003

using System;
using System.Data;
using System.Data.SqlClient;
using AirQuery.entity;
//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

namespace AirQuery.Class
{

	/// <summary>
	/// Flights 的摘要说明。
	/// </summary>
	public class Flights
	{
		public Flights()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		public struct Condition
		{
			public int _DepartureCityId;
			public int _ArrivalCityId;
			public DateTime _BeginDate;
			public DateTime _EndDate;
		}

		public FlightData GetFlights(Condition condition)
		{
			FlightData flight = new FlightData();
			SqlConnection sqlConnection = new SqlConnection();
			sqlConnection.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
			SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
			SqlCommand sqlCommand = new SqlCommand();
			sqlDataAdapter.SelectCommand = sqlCommand;
			sqlCommand.CommandType = CommandType.StoredProcedure;
			sqlCommand.Connection = sqlConnection;
		
			sqlCommand.Parameters.Add(new SqlParameter("@DepartureCityId",condition._DepartureCityId));
			sqlCommand.Parameters.Add(new SqlParameter("@ArrivalCityId", condition._ArrivalCityId));
			sqlCommand.Parameters.Add(new SqlParameter("@DepartureDateMin", condition._BeginDate));
			sqlCommand.Parameters.Add(new SqlParameter("@DepartureDateMax",condition._EndDate));

			try
			{
				sqlConnection.Open();
				sqlCommand.CommandText = "SelectFlight";
				sqlDataAdapter.Fill(flight.Flight);
				sqlCommand.CommandText = "SelectCabin";
				sqlDataAdapter.Fill(flight.Cabin);
			}
			catch(Exception e)
			{
				throw new ApplicationException("数据库错误。", e);
			}
			finally
			{
				sqlConnection.Close();
			}

			return flight;
		}
	}
}