BKI_DichVuMatDat.NghiepVu.f380_thay_doi_he_so_chat_luong_xls.delete_gd_da_co_trong_thang_cua_nhan_vien C# (CSharp) Метод

        private void delete_gd_da_co_trong_thang_cua_nhan_vien(US_DUNG_CHUNG v_us_dc, DataRow v_data_row, decimal ip_dc_id_nv)
        {
            decimal v_id_gd_hs_chat_luong = 0;
            DataSet v_ds = new DataSet();
            v_ds.Tables.Add(new DataTable());
            v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM GD_HE_SO_CHAT_LUONG WHERE ID_NHAN_VIEN =" + ip_dc_id_nv + " AND THANG = " + CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim()) + " AND NAM = " + CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim()));
            if (v_ds.Tables[0].Rows.Count > 0)
            {
                v_id_gd_hs_chat_luong = CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["ID"].ToString());
                US_GD_HE_SO_CHAT_LUONG v_us_gd_hs_cl = new US_GD_HE_SO_CHAT_LUONG(v_id_gd_hs_chat_luong);
                v_us_gd_hs_cl.BeginTransaction();
                v_us_gd_hs_cl.Delete();
                v_us_gd_hs_cl.CommitTransaction();
            }
            else
            {
                return;
            }
        }