cityaccess.cs

实施医院管理系统

using System;
using comman;
using System.Data;

namespace DataAccess
{
	/// <summary>
	/// CityAccess 的摘要说明。
	/// </summary>
	public class CityAccess
	{
		DBconnection cn = new DBconnection();
		public CityAccess()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		public City[] GetNameByProID(int ProvinceID)
		{
			string commandText = string.Format("SELECT * FROM City WHERE ProvinceID = '{0}'",ProvinceID);
			DataTable table = DBAccess.ExcuteDataTable(cn.Connection,commandText);

			int count = table.Rows.Count;
			City[] city = new City[count];
			for(int i=0;i<city.Length;i++)
			{
				city[i].CityID = Convert.ToInt32(table.Rows[i]["CityID"]);
				city[i].ProvinceID = Convert.ToInt32(table.Rows[i]["ProvinceID"]);
				city[i].CityName = table.Rows[i]["CityName"].ToString();
			}
			return city;
		 }
	}
}