?using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Data 的摘要說明
/// </summary>
public class Data
{
	public Data()
	{
		//
		// TODO: 在此處添加構(gòu)造函數(shù)邏輯
		//
	}


    public DataTable GetProvince(string ProviceID)
    {
        string SearchProvince = "select * from povince";
        if (!string.IsNullOrEmpty(ProviceID))
        {
            SearchProvince += "Where '" + ProviceID + "'";
        }
        return GetData(SearchProvince);
    }

    public DataTable GetCity(string ProviceID)
    {

        string SearchCity = "select * from city where father='" + ProviceID + "'";
        return GetData(SearchCity);
    }

    private DataTable GetData(string sql)
    {
        using (System.Data.SqlClient.SqlConnection conn = DB.GetConn())
        {

            System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sql, conn);
            DataTable AimDT = new DataTable();
            System.Data.SqlClient.SqlDataAdapter Adapter = new System.Data.SqlClient.SqlDataAdapter();
            Adapter.SelectCommand = cmd;
            conn.Open();
            Adapter.Fill(AimDT);
            return AimDT;
        }
    }
}