private void loadDuLieu()
{
dgvDanhSach.Rows.Clear();
DataTable dt = DiemControl.layDanhSachDiemHS(id);
for (int i = 0; i < dt.Rows.Count; ++i)
{
double diemmieng = 0;
double diemgiua = 0;
double diemcuoi = 0;
if (dt.Rows[i][2].ToString().Length > 0)
{
diemmieng = double.Parse(dt.Rows[i][2].ToString());
}
if (dt.Rows[i][3].ToString().Length > 0)
{
diemgiua = double.Parse(dt.Rows[i][3].ToString());
}
if (dt.Rows[i][4].ToString().Length > 0)
{
diemcuoi = double.Parse(dt.Rows[i][4].ToString());
}
double tongket = 0;
if (diemmieng != 0 && diemgiua != 0 && diemcuoi != 0)
{
tongket = (1 * diemmieng + 2 * diemgiua + 3 * diemcuoi) / 6;
dgvDanhSach.Rows.Add(new object[] { i, dt.Rows[i][0], dt.Rows[i][1], dt.Rows[i][2], dt.Rows[i][3], dt.Rows[i][4], tongket });
continue;
}
dgvDanhSach.Rows.Add(new object[] { i, dt.Rows[i][0], dt.Rows[i][1], dt.Rows[i][2], dt.Rows[i][3], dt.Rows[i][4] });
}
}
public frmDiemHS(int id)
{
InitializeComponent();
this.id = id;
lbTenHS.Text = DiemControl.layThongTin(id).Rows[0][1].ToString();
loadDuLieu();
}
private void dgvDanhSach_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1 || e.RowIndex + 1 == dgvDanhSach.RowCount)
{
return;
}
int idMH = Convert.ToInt32(dgvDanhSach.Rows[e.RowIndex].Cells["colMa"].Value.ToString());
if (e.ColumnIndex == dgvDanhSach.Columns["colDiemMieng"].Index)
{
DiemControl.suaDiem(id, idMH, double.Parse(dgvDanhSach.CurrentCell.Value.ToString()), 0, 0);
}
else if (e.ColumnIndex == dgvDanhSach.Columns["colDiemGiuaKi"].Index)
{
DiemControl.suaDiem(id, idMH, 0, double.Parse(dgvDanhSach.CurrentCell.Value.ToString()), 0);
}
else if (e.ColumnIndex == dgvDanhSach.Columns["colCuoiKi"].Index)
{
DiemControl.suaDiem(id, idMH, 0, 0, double.Parse(dgvDanhSach.CurrentCell.Value.ToString()));
}
loadTongKet(e.RowIndex);
}
