using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DBHelper;
using MySql.Data.MySqlClient;

namespace WindowsFormsApplication1
{

    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            //string sql = "select * from  s_province";
            ////DataTableCollection dc = SqlHelper.GetTableText(sql, null);
            //MySqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.connectionString, CommandType.Text, sql, null);
            //while (dr.Read())
            //{
            //    zi a = new zi();
              
            //    comboBox1.DisplayMember = "ProvinceName";
            //    comboBox1.ValueMember = "ProvinceID";
            //    a.provinceID = Convert.ToInt32(dr[0]);
            //    a.provinceName = Convert.ToString(dr[1]);
            //    comboBox1.Items.Add(a);
            //}
            //comboBox1.SelectedIndex = 0;
            this.comboBox1.Items.Clear();
            string sql = "select * from s_province";
            DataSet ds = SqlHelper.ExecuteDataSetText(sql, null);
            comboBox1.DisplayMember = "ProvinceName";
            comboBox1.ValueMember = "ProvinceID";
            comboBox1.DataSource = ds.Tables[0];
        }

        private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
        {
            //this.comboBox3.Items.Clear();
            //qu qx = (qu)comboBox2.SelectedItem;
            //int id = qx.cityID;
            //string sql = "select * from qu where quid=@id";
            //MySqlParameter p = new MySqlParameter("@id", id);
            //MySqlParameter[] pa = new MySqlParameter[] { p };
            //MySqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.connectionString, CommandType.Text, sql, pa);
            //while (dr.Read()) 
            //{
            //    comboBox3.Items.Add(dr[1]);
            //}
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
           // this.comboBox2.Items.Clear();
            //zi ax = (zi)comboBox1.SelectedItem;

            //int id = ax.provinceID;
            
            //string sql = "select * from s_city where ProvinceID=@id";
            //MySqlParameter p = new MySqlParameter("@id", id);
            //MySqlParameter[] pa = new MySqlParameter[] { p };
            //MySqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.connectionString, CommandType.Text, sql, pa);
            //while (dr.Read())
            //{
            //    //qu q = new qu();
            //    //comboBox1.DisplayMember = "CityName";
            //    //comboBox1.ValueMember = "CityID";
            //    //q.cityID = Convert.ToInt32(dr[0]);
            //    //q.cityName = Convert.ToString(dr[1]);
            //    //comboBox2.Items.Add(q);
            //    comboBox2.Items.Add(dr[1]);
            //}
            string id = Convert.ToString(comboBox1.SelectedValue);
            load_city(id);

        
        }
        private void load_city(string provinceid) 
        {
            string sql = "select * from s_city where ProvinceID="+provinceid;
            DataSet ds = SqlHelper.ExecuteDataSetText(sql, null);
            comboBox2.DisplayMember = "CityName";
            comboBox2.ValueMember = "CityID";
            comboBox2.DataSource = ds.Tables[0];
        }

        private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
        {

        }
    }
    class zi
    {
        public string provinceName;
        public string ProvinceName
        {
            get { return provinceName; }
            set { provinceName = value; }
        }
        public int provinceID;
        public int ProvinceID
        {
            get { return provinceID; }
            set { provinceID = value; }
        }
    }

    class qu 
    {
        public string cityName;
        public string CityName
        {
            get { return cityName; }
            set { cityName = value; }
        }
        public int cityID;
        public int CityID
        {
            get { return cityID; }
            set { cityID = value; }
        }
    }
}