private void LoadcmbCapTren()
        {
            var cmb = cmbCapTren;

            cmb.Tag = 0;
            clsDM_ChucVu cls = new clsDM_ChucVu();
            DataTable    dt  = cls.SelectAll();

            dt.DefaultView.RowFilter = "TonTai = 1";
            dt.DefaultView.Sort      = "ID_ChucVu ASC";
            dt = dt.DefaultView.ToTable();
            cmb.Properties.DataSource    = dt;
            cmb.Properties.DisplayMember = "Ten_ChucVu";
            cmb.Properties.ValueMember   = "ID_ChucVu";
            cmb.Tag = 1;
        }
        private void LoadcmbCapDuoi()
        {
            var cmb = cmbCapDuoi;

            cmb.Tag = 0;
            clsDM_ChucVu cls = new clsDM_ChucVu();
            //DataTable dt = cls.SelectAllNVCapDuoi(Convert.ToInt32(cmbCapTren.EditValue));
            DataTable dt = cls.SelectAll();

            dt.DefaultView.RowFilter = "ID_ChucVu <> " + cmbCapTren.EditValue + " AND TonTai = 1";
            dt.DefaultView.Sort      = "ID_ChucVu ASC";
            dt = dt.DefaultView.ToTable();
            cmb.Properties.DataSource    = dt;
            cmb.Properties.DisplayMember = "Ten_ChucVu";
            cmb.Properties.ValueMember   = "ID_ChucVu";
            cmb.Tag = 1;
        }