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++;
}
}
