BKI_DichVuMatDat.F152_DANH_SACH_NHAN_VIEN_EXCEL.find_id_cm_dm_tu_dien_by_trinh_do_van_hoa C# (CSharp) Method

        private string find_id_cm_dm_tu_dien_by_trinh_do_van_hoa(string ip_str_trinh_do_van_hoa)
        {
            US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN();
            DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN();

            v_us.FillDataset(v_ds);
            ip_str_trinh_do_van_hoa = ip_str_trinh_do_van_hoa.Trim().ToUpper();
            string v_str_filter = "MA_TU_DIEN = '" + ip_str_trinh_do_van_hoa + "'";
            DataRow[] v_dr = v_ds.CM_DM_TU_DIEN.Select(v_str_filter);

            if (v_dr.Count() == 0)
            {
                return null;
            }
            else
            {
                return v_dr.First()["ID"].ToString();
            }
        }