citys.cs

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

using System;
using System.Data;
using System.Collections;

namespace 数据访问.控制类
{
	using OceanSoft.Data;
	/// <summary>
	/// Citys 的摘要说明。
	/// </summary>
	public class Citys
	{
		//声明连接对象
		ICommonAccess action;
        
		/// <summary>
		/// 空的构造函数，用默认值初始化连接对象
		/// </summary>
		public Citys()
		{
			this.action=DataFactory.GetInstance();
		}
         
		/// <summary>
		/// 带参数的构造函数，用指定值初始化连接对象
		/// </summary>
		/// <param name="action"></param>
		public Citys(ICommonAccess action)
		{
			this.action=action;
		}
        
		/// <summary>
		/// 此方法关闭连接对象
		/// </summary>
		public void Close()
		{
			this.action.Close();
		}
        
		/// <summary>
		/// 获取CityCollection
		/// </summary>
		/// <param name="cityId">城市编号</param>
		/// <param name="cityName">城市名称</param>
		/// <returns></returns>
		public 实体类.CityCollection GetCity(int cityId,string cityName)
		{
			action.CommandString="SelectCity";
			action.IsStoredProcedure=true;
			Hashtable ht=new Hashtable();
			ht.Add("@cityId",cityId);
			ht.Add("@cityName",cityName);
			action.CommandParams=ht;

			DataSet ds=null;
			try
			{
				ds=this.action.GetDataSet("City");
			}
			catch(Exception err)
			{
				throw err;
			}
			实体类.CityCollection cityCol =new 数据访问.实体类.CityCollection();

			foreach(DataRow row in ds.Tables[0].Rows)
			{
				实体类.City city=new 数据访问.实体类.City();
				city.CityId=int.Parse(row["CityId"].ToString());
				city.CityName=row["CityName"].ToString();
				city.DistrictCode=row["DistrictCode"].ToString();
				cityCol.Add(city);
			}
			return cityCol;


		}
	}
}