cabins.cs

来自「此项目是用asp.net开发的航班查询系统」· CS 代码 · 共 86 行

using System;
using System.Data;
using System.Collections;
using 数据访问.实体类;

namespace 数据访问.控制类
{
	using OceanSoft.Data;
	/// <summary>
	/// Cabins 的摘要说明。
	/// </summary>
	public class Cabins
	{   
		//声明连接对象
		ICommonAccess action;
        
		/// <summary>
		/// 空的构造函数，用默认值初始化连接对象
		/// </summary>
		public Cabins()
		{
			this.action=DataFactory.GetInstance();
		}
        
		/// <summary>
		/// 带参数的构造函数，用指定值初始化连接对象
		/// </summary>
		/// <param name="action"></param>
		public Cabins(ICommonAccess action)
		{
			this.action=action;
		}
         
		/// <summary>
		/// 此方法用于关闭连接对象
		/// </summary>
		public void Close()
		{
			this.action.Close();
		}
        
		/// <summary>
		/// 获得CabinCollection
		/// </summary>
		/// <param name="flightId">航班编号</param>
		/// <returns></returns>
		public 实体类.CabinCollection GetCabin(int flightId)
		{
			action.CommandString="SelectCabin";
			action.IsStoredProcedure=true;
			Hashtable ht=new Hashtable();
			ht.Add("@flightId",flightId);
			
			action.CommandParams=ht;

			DataSet ds=null;
			try
			{
				ds=this.action.GetDataSet("Cabin");
			}
			catch(Exception err)
			{
				throw err;
			}
			CabinCollection cabinCol =new CabinCollection();

			foreach(DataRow row in ds.Tables[0].Rows)
			{
				Cabin cabin=new Cabin();
				cabin.CabinId=int.Parse(row["CabinId"].ToString());
				cabin.CabinName=row["CabinName"].ToString();
				cabin.FlightId=int.Parse(row["FlightId"].ToString());
				cabin.RemainTickets=int.Parse(row["RemainTickets"].ToString());
				cabin.Type=row["Type"].ToString();
				cabin.Price=decimal.Parse(row["Price"].ToString());
				cabin.Discount=float.Parse(row["Discount"].ToString());
				cabinCol.Add(cabin);
			}
			return cabinCol;


		}
	}
}