BKI_DichVuMatDat.NghiepVu.f322_lap_hop_dong_excel.find_id_lcd C# (CSharp) Method

        private decimal find_id_lcd(decimal ip_dc_chuc_danh, decimal ip_dc_muc)
        {
            US_DM_LUONG_CHE_DO v_us = new US_DM_LUONG_CHE_DO();
            DS_DM_LUONG_CHE_DO v_ds = new DS_DM_LUONG_CHE_DO();

            v_us.FillDataset(v_ds);

            string v_str_filter = "ID_MA_LCD = " + ip_dc_chuc_danh + " AND ID_MUC_LCD = " + ip_dc_muc;
            DataRow[] v_dr = v_ds.DM_LUONG_CHE_DO.Select(v_str_filter);
            if (v_dr.Count() == 0)
            {
                return -1;
            }
            else
            {
                return CIPConvert.ToDecimal(v_dr.First()["ID"].ToString());
            }
        }