public void HienThiDataGridViewComboBoxColumn(DataGridViewComboBoxColumn cmbColumn)
{
cmbColumn.DataSource = m_HocKyData.LayDsHocKy();
cmbColumn.DisplayMember = "TenHocKy";
cmbColumn.ValueMember = "MaHocKy";
cmbColumn.DataPropertyName = "MaHocKy";
cmbColumn.HeaderText = "Học kỳ";
}
public void HienThiComboBox(ComboBoxEx comboBox)
{
HocKyData m_HKData = new HocKyData();
comboBox.DataSource = m_HKData.LayDsHocKy();
comboBox.DisplayMember = "TenHocKy";
comboBox.ValueMember = "MaHocKy";
}
public float DiemTrungBinhMonCaNam(String maHocSinh, String maMonHoc, String maNamHoc, String maLop)
{
DataTable m_DT = new DataTable();
m_DT = m_HocKyData.LayDsHocKy();
float tongDiem = 0;
int tongHeSo = 0;
foreach (DataRow row in m_DT.Rows)
{
tongDiem += DiemTrungBinhMonHocKy(maHocSinh, maMonHoc, row["MaHocKy"].ToString(), maNamHoc, maLop) * Convert.ToInt32(row["HeSo"].ToString());
tongHeSo += Convert.ToInt32(row["HeSo"].ToString());
}
if (tongHeSo > 0)
{
return(tongDiem / tongHeSo);
}
else
{
return(0);
}
}