private decimal get_id_from_ma(string ip_str_ma)
 {
     US_CM_DM_LOAI_TD v_us_cm_loai_tu_dien = new US_CM_DM_LOAI_TD(ip_str_ma);
     return v_us_cm_loai_tu_dien.dcID;
 }
 private void load_cbo_loai_tu_dien()
 {
     US_CM_DM_LOAI_TD v_us_loai_tu_dien = new US_CM_DM_LOAI_TD();
     DS_CM_DM_LOAI_TD v_ds_loai_tu_dien = new DS_CM_DM_LOAI_TD();
     v_us_loai_tu_dien.FillDataset(v_ds_loai_tu_dien," order by "+CM_DM_LOAI_TD.TEN_LOAI);
     m_cbo_loai_tu_dien.DataSource = v_ds_loai_tu_dien.CM_DM_LOAI_TD;
     m_cbo_loai_tu_dien.DataTextField = CM_DM_LOAI_TD.TEN_LOAI;
     m_cbo_loai_tu_dien.DataValueField = CM_DM_LOAI_TD.ID;
     m_cbo_loai_tu_dien.DataBind();
 }
 private void load_cbo_loai_tu_dien_grv()
 {
     US_CM_DM_LOAI_TD v_us_loai_tu_dien = new US_CM_DM_LOAI_TD();
         DS_CM_DM_LOAI_TD v_ds_loai_tu_dien = new DS_CM_DM_LOAI_TD();
         v_us_loai_tu_dien.FillDataset(v_ds_loai_tu_dien);
         m_cbo_loai_tu_dien_grv.DataSource = v_ds_loai_tu_dien.CM_DM_LOAI_TD;
         m_cbo_loai_tu_dien_grv.DataTextField = CM_DM_LOAI_TD.TEN_LOAI;
         m_cbo_loai_tu_dien_grv.DataValueField = CM_DM_LOAI_TD.MA_LOAI;
         m_cbo_loai_tu_dien_grv.DataBind();
 }
        private void loadData_fromDB_toDatasets()
        {
            US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN();
            try
            {
                v_us_tu_dien.BeginTransaction();
                this.m_ds_tu_dien = new DS_CM_DM_TU_DIEN();
                v_us_tu_dien.FillDataset(m_ds_tu_dien);

                US_CM_DM_LOAI_TD v_us_loai_tu_dien = new US_CM_DM_LOAI_TD();
                v_us_loai_tu_dien.UseTransOfUSObject(v_us_tu_dien);
                this.m_ds_loai_tu_dien = new DS_CM_DM_LOAI_TD();
                v_us_loai_tu_dien.FillDataset(m_ds_loai_tu_dien);

                v_us_tu_dien.CommitTransaction();
            }
            catch (Exception v_e)
            {
                v_us_tu_dien.Rollback();
                CDBExceptionHandler v_handler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret());
                v_handler.showErrorMessage();
            }
        }