private void insert_2_nhom_sd()
        {
            US_HT_NGUOI_SU_DUNG_NHOM_CHI_NHANH m_us_nguoi_sd_nhom_cn = new US_HT_NGUOI_SU_DUNG_NHOM_CHI_NHANH();

            m_us_nguoi_sd_nhom_cn.dcID_NGUOI_SU_DUNG = m_us.dcID;
            m_us_nguoi_sd_nhom_cn.dcID_NHOM          = CIPConvert.ToDecimal(m_cbo_cap_xu_ly.SelectedValue.ToString());
            m_us_nguoi_sd_nhom_cn.dcID_CHI_NHANH     = us_user.dcCHI_NHANH;
            m_us_nguoi_sd_nhom_cn.Insert();
        }
        private void update_nhom_sd()
        {
            string        m_query = "select top 1 id from ht_nguoi_su_dung_nhom_chi_nhanh where ID_NGUOI_SU_DUNG = " + m_us.dcID;
            US_DUNG_CHUNG us      = new US_DUNG_CHUNG();
            DataSet       ds      = new DataSet();

            ds.Tables.Add(new DataTable());
            us.FillDatasetWithQuery(ds, m_query);
            US_HT_NGUOI_SU_DUNG_NHOM_CHI_NHANH m_us_nguoi_sd_nhom_cn = new US_HT_NGUOI_SU_DUNG_NHOM_CHI_NHANH(CIPConvert.ToDecimal(ds.Tables[0].Rows[0][0].ToString()));

            m_us_nguoi_sd_nhom_cn.dcID_NHOM = CIPConvert.ToDecimal(m_cbo_cap_xu_ly.SelectedValue.ToString());
            m_us.Update();
        }