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(); }