private void get_id_gd_diem(US_DUNG_CHUNG v_us_dc, decimal v_id_ns, decimal v_id_gdlm, DataRow v_dt_r, ref int v_int_khong_nhap_duoc, DataRow v_data_row, ref decimal v_count) { DataSet v_ds = new DataSet(); v_ds.Tables.Add(new DataTable()); v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM GD_DIEM WHERE ID_NHAN_VIEN=" + v_id_ns.ToString() + " AND ID_LOP_MON=" + v_id_gdlm.ToString()); if (v_ds.Tables[0].Rows.Count == 0) { MessageBox.Show("Nhân viên này chưa có tên trong lớp môn này"); } v_dt_r = v_ds.Tables[0].Rows[0]; decimal v_id_gdd = CIPConvert.ToDecimal(v_dt_r["ID"].ToString()); US_GD_DIEM v_us_gdd = new US_GD_DIEM(v_id_gdd); if (v_us_gdd.dcDIEM_CHUYEN_CAN.ToString() == "") { v_us_gdd.IsDIEM_CHUYEN_CANNull(); } else { v_us_gdd.dcDIEM_CHUYEN_CAN = CIPConvert.ToDecimal(v_data_row["DIEM_CHUYEN_CAN"].ToString()); } if (v_us_gdd.dcDIEM_THI.ToString() == "") { v_us_gdd.IsDIEM_THINull(); } else { v_us_gdd.dcDIEM_THI = CIPConvert.ToDecimal(v_data_row["DIEM_KIEM_TRA"].ToString()); } if (v_us_gdd.dcDIEM_KIEM_TRA.ToString()=="") { v_us_gdd.IsDIEM_KIEM_TRANull(); } else { v_us_gdd.dcDIEM_KIEM_TRA = CIPConvert.ToDecimal(v_data_row["DIEM_THI"].ToString()); } v_us_gdd.strQUA_MON = v_data_row["KET_QUA"].ToString(); v_us_gdd.datNGAY_SUA = DateTime.Now.Date; v_us_gdd.strHOC_XONG_YN = "Y"; v_us_gdd.Update(); try { v_us_gdd.Update(); v_data_row.Delete(); v_count++; } catch (Exception) { MessageBox.Show("Lỗi!"); v_int_khong_nhap_duoc++; } }