using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Drawing;

using System.Data;

using System.Linq;

using System.Text;

using System.Windows.Forms;

namespace winform_test.UserControls

{

    public partial class conYMPC : UserControl

    {

        private string sb_ym;

        public string Sb_ym

        {

            get { return sb_ym; }

        }

        private string sb_pc;

        public string Sb_pc

        {

            get { return sb_pc; }

        }

        //委托

        public delegate void MyChangeEventHandler();

        //事件

        public event MyChangeEventHandler MyChange;

        //方法

        public void OnMyChange()

        {

            if (MyChange != null)

                MyChange();

        }

        public conYMPC()

        {

            InitializeComponent();

        }

        /// <summary>

        ///窗体初始化

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void conYM_Load(object sender, EventArgs e)

        {

            BindYear();

        }

        /// <summary>

        /// 得到年份

        /// </summary>

        private void BindYear()

        {

            string sql = "select distinct left(sb_ym,4)+'年' as sb_year from sb_ympc order by sb_year desc";

            DataSet ds = SqlHelp.GetDataSet(sql);

            foreach (DataRow dr in ds.Tables[0].Rows)

            {

                cboY.Properties.Items.Add(dr["sb_year"].ToString());

            }

            cboY.SelectedIndex = 0;

        }

        /// <summary>

        /// 得到月份

        /// </summary>

        private void BindMonth()

        {

            cboM.Properties.Items.Clear();

            string sql = "select distinct right(sb_ym,2)+'月' as sb_month from sb_ympc where sb_ym like '" + cboY.Text.Substring(0, 4) + "%' order by sb_month desc";

            DataSet ds = SqlHelp.GetDataSet(sql);

            foreach (DataRow dr in ds.Tables[0].Rows)

            {

                cboM.Properties.Items.Add(dr["sb_month"].ToString());

            }

            cboM.SelectedIndex = 0;

        }

        /// <summary>

        /// 得到批次

        /// </summary>

        private void BindPC()

        {

            cboPC.Properties.Items.Clear();

            string sql = "select sb_pc from sb_ympc where sb_ym='" + cboY.Text.Substring(0, 4) + cboM.Text.Substring(0, 2) + "' order by sb_pc";

            DataSet ds = SqlHelp.GetDataSet(sql);

            foreach (DataRow dr in ds.Tables[0].Rows)

            {

                cboPC.Properties.Items.Add(dr["sb_pc"].ToString());

            }

            cboPC.SelectedIndex = 0;

        }

        /// <summary>

        /// 年份下拉列表框改变事件

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void cboY_SelectedIndexChanged(object sender, EventArgs e)

        {

            BindMonth();

            CheckChange();

        }

        /// <summary>

        /// 月份下拉列表框改变事件

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void cboM_SelectedIndexChanged(object sender, EventArgs e)

        {

            BindPC();

            CheckChange();

        }

        /// <summary>

        /// 批次下拉列表框改变事件

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void cboPC_SelectedIndexChanged(object sender, EventArgs e)

        {

            CheckChange();

        }

        /// <summary>

        /// 检查下拉列表框的值是否改变，改变的话更新

        /// </summary>

        private void CheckChange()

        {

            string _sb_ym = cboY.Text.Substring(0, 4) + cboM.Text.Substring(0, 2);

            string _sb_pc = cboPC.Text;

            if (_sb_ym != sb_ym || _sb_pc != sb_pc)

            {

                sb_ym = _sb_ym;

                sb_pc = _sb_pc;

                OnMyChange();//触发这个方法

            }

        }

    }

}

  private void frmStart_Load(object sender, EventArgs e)

        {

            //给控件绑定事件

            conYMPC1.MyChange += new UserControls.conYMPC.MyChangeEventHandler(aa);

        }

        void aa()

        {

            MessageBox.Show("申报年月：" + conYMPC1.Sb_ym + "  申报批次：" + conYMPC1.Sb_pc);

        }