BKI_DichVuMatDat.NghiepVu.NhanSu.f003_import_he_so_lns.find_id_hs_lns_by_ma_muc C# (CSharp) Метод

        private decimal find_id_hs_lns_by_ma_muc(string ma_lns, string muc_lns)
        {
            try
            {
                decimal id_ma_lns = (from DataRow dr in m_dt_ma_lns.Rows
                                     where (string)dr[CM_DM_TU_DIEN.MA_TU_DIEN] == ma_lns
                                     select (decimal)dr[CM_DM_TU_DIEN.ID]).FirstOrDefault();
                decimal id_muc_lns = (from DataRow dr in m_dt_muc_lns.Rows
                                      where (string)dr[CM_DM_TU_DIEN.MA_TU_DIEN] == muc_lns
                                      select (decimal)dr[CM_DM_TU_DIEN.ID]).FirstOrDefault();
                US_DM_HE_SO_LUONG_NS v_us = new US_DM_HE_SO_LUONG_NS();
                DS_DM_HE_SO_LUONG_NS v_ds = new DS_DM_HE_SO_LUONG_NS();
                v_us.FillDataset(v_ds);
                decimal id_lns = (from DataRow dr in v_ds.Tables[0].Rows
                                  where (decimal)dr["ID_MA_LNS"] == id_ma_lns & (decimal)dr["ID_MUC_LNS"] == id_muc_lns
                                  select (decimal)dr["ID"]).FirstOrDefault();

                return id_lns;
            }
            catch(Exception v_e)
            {
                throw v_e;
            }
        }