using System;
using System.Data;
using System.Data.SqlClient;
namespace AjaxTest
{
	/// <summary>
	/// Summary description for AjaxMethod.
	/// </summary>
	public class AjaxMethod
	{
		#region GetPovinceList
		public static DataSet GetPovinceList()
		{
			string sql="select * from povince";
			return GetDataSet(sql);
		}
		#endregion

		#region GetCityList
		[Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)]
		public  DataSet GetCityList(int povinceid)
		{
			string sql="select * from city where father="+povinceid;
			return GetDataSet(sql);			
		}
		#endregion

		#region GetAreaList
		[Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)]
		public  DataSet GetAreaList(int cityid)
		{
			string sql="select * from area where father="+cityid;
			return GetDataSet(sql);			
		}
		#endregion
	
		#region GetDataSet
		public static DataSet GetDataSet(string sql)
		{
			string ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
			SqlDataAdapter	sda =new SqlDataAdapter(sql,ConnectionString);
			DataSet ds=new DataSet();
			sda.Fill(ds);
			return ds;
		}
		#endregion
	}
}