area.cs

ajax地区选择列表

using System;

namespace DataSaver.SDE2HClass.SDE2HManagerClass
{
	/// <summary>
	/// Area 的摘要说明。
	/// </summary>
	public class Area
	{
		public string AreaCode;
		public string AreaName;
		public string TelCode;
		public Area ParentArea
		{
			get
			{
				if(this.AreaCode.Substring(this.AreaCode.Length-4,4)=="0000")
					return null;

				if(this.AreaCode.Substring(this.AreaCode.Length-2,2)=="00")
					return new Area(this.AreaCode.Substring(0,2)+"0000");

				try
				{
					Area area= new Area(this.AreaCode.Substring(0,4)+"00");
					string areaName=area.AreaName;
					if(areaName=="市辖区"||areaName=="县"||areaName=="省直辖行政单位")
						return new Area(this.AreaCode.Substring(0,2)+"0000");
					return area;
				}
				catch
				{
					return new Area(this.AreaCode.Substring(0,2)+"0000");
				}
			}
		}

		protected System.Data.DataSet dataSet;
		protected System.Data.SqlClient.SqlDataAdapter Adapter;
		public string EntireAreaName
		{
			get
			{
				string entireAreaName=this.AreaName;
				for(Area parentArea=this.ParentArea;parentArea!=null;parentArea=parentArea.ParentArea)
					entireAreaName=parentArea.AreaName.Replace(" ","")+entireAreaName;
				return entireAreaName;
			}
		}
		public Area(string areaCode)
		{
			string SelectCommand=string.Format("select * from T_Area where sz_code='{0}'",areaCode);
			this.Adapter=new System.Data.SqlClient.SqlDataAdapter(SelectCommand,DataSaver.SDE2HConnection.SDE2HConnection.ManagerConnString);
			this.Adapter.TableMappings.Add("Table","Area");
			new System.Data.SqlClient.SqlCommandBuilder(this.Adapter);
			this.dataSet=new System.Data.DataSet();
			this.Adapter.Fill(this.dataSet);

			if(this.dataSet.Tables[0].Rows.Count==0)
			{
				//throw new Exception(string.Format("地区“{0}”不存在！",areaCode));
				SelectCommand=string.Format("select * from T_Area where sz_code='{0}'","990000");
				Adapter=new System.Data.SqlClient.SqlDataAdapter(SelectCommand,DataSaver.SDE2HConnection.SDE2HConnection.ManagerConnString);
				Adapter.TableMappings.Add("Table","Area");
				dataSet=new System.Data.DataSet();
				Adapter.Fill(this.dataSet);
			}
			System.Data.DataRow EditRow=dataSet.Tables[0].Rows[0];

			this.AreaCode=EditRow["sz_code"].ToString();
			this.AreaName=EditRow["name"].ToString();
			this.TelCode=EditRow["sz_AreaCode"].ToString();
		}

		public static Area FromAreaName(string areaName)
		{
			string SelectCommand=string.Format("select sz_code from T_Area where name='{0}'",areaName);
			System.Data.SqlClient.SqlConnection myConn = new System.Data.SqlClient.SqlConnection(DataSaver.SDE2HConnection.SDE2HConnection.ManagerConnString);
			System.Data.SqlClient.SqlCommand command=new System.Data.SqlClient.SqlCommand(SelectCommand, myConn);
			command.Connection.Open();
			System.Data.SqlClient.SqlDataReader Reader=command.ExecuteReader();
			string areaCode="";
			if(Reader.Read())
			{
				areaCode=Reader["sz_code"].ToString();
				Reader.Close();
				command.Connection.Close();
			}
			Reader.Close();
			command.Connection.Close();

			if(areaCode=="")
				return null;
			else return new Area(areaCode);
		}

		public bool Update()
		{
			System.Data.DataRow EditRow=dataSet.Tables[0].Rows[0];

			EditRow["sz_code"]=this.AreaCode;
			EditRow["name"]=this.AreaName;
			EditRow["sz_AreaCode"]=this.TelCode;
			Adapter.Update(dataSet);

			return true;
		}

		public static System.Data.DataSet GetArea()
		{
			string SelectCommand="select * from T_Area where name<>'市辖区' and name<>'县' and name<>'省直辖行政单位'";
			System.Data.SqlClient.SqlDataAdapter adapter=new System.Data.SqlClient.SqlDataAdapter(SelectCommand,DataSaver.SDE2HConnection.SDE2HConnection.ManagerConnString);
			System.Data.DataSet ds=new System.Data.DataSet();
			adapter.Fill(ds,"Area");
			return ds;
		}

		public static System.Data.DataSet GetProvice(System.Data.DataSet AreaDataSet)
		{
			System.Data.DataSet ProviceDS=AreaDataSet.Clone();
			foreach(System.Data.DataRow r in AreaDataSet.Tables[0].Rows)
			{
				string Code=r["sz_code"].ToString();
				if(Code.Substring(Code.Length-4)=="0000")
				{
					System.Data.DataRow NewRow=ProviceDS.Tables[0].NewRow();
					for(int i=0;i<ProviceDS.Tables[0].Columns.Count;i++)
						NewRow[i]=r[i];
					ProviceDS.Tables[0].Rows.Add(NewRow);
				}
			}
			return ProviceDS;
			//return Common.NewDataSetFromDataRows(AreaDataSet,AreaDataSet.Tables[0].Select("right(sz_code,4)='0000'"));
		}

		public static System.Data.DataSet GetProvice()
		{
			string SelectCommand="select * from T_Area where name<>'市辖区' and name<>'县' and right(sz_code, 4)='0000'";
			System.Data.SqlClient.SqlDataAdapter adapter=new System.Data.SqlClient.SqlDataAdapter(SelectCommand,DataSaver.SDE2HConnection.SDE2HConnection.ManagerConnString);
			System.Data.DataSet ds=new System.Data.DataSet();
			adapter.TableMappings.Add("Table","Area");
			adapter.Fill(ds);
			return ds;
		}

		public static System.Data.DataSet GetCities()
		{
			string SelectCommand="select * from T_Area where name<>'市辖区' and name<>'县' and name<>'省直辖行政单位' and right(sz_code, 4)<>'0000' and right(sz_code,2)='00'";
			System.Data.SqlClient.SqlDataAdapter adapter=new System.Data.SqlClient.SqlDataAdapter(SelectCommand,DataSaver.SDE2HConnection.SDE2HConnection.ManagerConnString);
			System.Data.DataSet ds=new System.Data.DataSet();
			adapter.Fill(ds,"Area");
			return ds;
		}

		public static System.Data.DataSet GetCities(Area ProviceArea)
		{
			string SelectCommand=string.Format("select * from T_Area where name<>'市辖区' and name<>'省直辖行政单位' and name<>'县' and right(sz_code,4)<>'0000' and left(sz_code,2)='{0}' and right(sz_code,2)='00'",ProviceArea.AreaCode.Substring(0,2));
			System.Data.SqlClient.SqlDataAdapter adapter=new System.Data.SqlClient.SqlDataAdapter(SelectCommand,DataSaver.SDE2HConnection.SDE2HConnection.ManagerConnString);
			System.Data.DataSet ds=new System.Data.DataSet();
			adapter.Fill(ds,"Area");
			return ds;
		}

		public static System.Data.DataSet GetSection()
		{
			string SelectCommand="select * from T_Area where name<>'市辖区' and name<>'省直辖行政单位' and name<>'县' and right(sz_code,2)<>'00'";
			System.Data.SqlClient.SqlDataAdapter adapter=new System.Data.SqlClient.SqlDataAdapter(SelectCommand,DataSaver.SDE2HConnection.SDE2HConnection.ManagerConnString);
			System.Data.DataSet ds=new System.Data.DataSet();
			adapter.Fill(ds,"Area");
			return ds;
		}

		public static System.Data.DataSet GetSection(Area CityArea)
		{
			string SelectCommand=string.Format("select * from T_Area where name<>'市辖区' and name<>'省直辖行政单位' and name<>'县' and right(sz_code,2)<>'00' and left(sz_code,4)='{0}'",CityArea.AreaCode.Substring(0,4));
			System.Data.SqlClient.SqlDataAdapter adapter=new System.Data.SqlClient.SqlDataAdapter(SelectCommand,DataSaver.SDE2HConnection.SDE2HConnection.ManagerConnString);
			System.Data.DataSet ds=new System.Data.DataSet();
			adapter.Fill(ds,"Area");
			return ds;
		}
	}
}