private void btnXemDiem_Click(object sender, EventArgs e)
{
if (cboHocSinh.Text != "" && cboHocKy.Text != "" && cboNamHoc.Text != "")
{
string maHS = cboHocSinh.EditValue.ToString();
string maHocKy = cboHocKy.EditValue.ToString();
string maNamHoc = cboNamHoc.EditValue.ToString();
bindingSourceDiemChiTiet.DataSource = HOCTAP_BUS.LayDiemChiTietHocSinh(maHS, maHocKy, maNamHoc);
}
}
private void load_BangDiem()
{
if (cboHocSinh.Text != "" && cboHocKy.Text != "" && cboNamHoc.Text != "")
{
string maHS = cboHocSinh.EditValue.ToString();
string maHocKy = cboHocKy.EditValue.ToString();
string maNamHoc = cboNamHoc.EditValue.ToString();
bindingSourceDiemChiTiet.DataSource = HOCTAP_BUS.LayDiemChiTietHocSinh(maHS, maHocKy, maNamHoc);
}
}
private void cboLop_EditValueChanged(object sender, EventArgs e)
{
if (cboLop.Text != null)
{
bindingSourceDiemTongKet.DataSource = HOCTAP_BUS.LayDiemHocSinhTheoLop(cboLop.EditValue.ToString());
}
else
{
bindingSourceDiemTongKet.DataSource = null;
}
}
public rpDanhSachHocSinh(string tenNamHoc, string tenLop, string maLop)
{
InitializeComponent();
foreach (DevExpress.XtraReports.Parameters.Parameter p in Parameters)
{
p.Visible = false;
}
pNamHoc.Value = tenNamHoc;
pLop.Value = tenLop;
pNgayLap.Value = DateTime.Today;
bindingSourceDiemTongKet.DataSource = HOCTAP_BUS.LayDiemHocSinhTheoLop(maLop);
}
private void load_BangDiem()
{
if (cboLop.Text != "" && cboMonHoc.Text != "" && cboHocKy.Text != "" && cboNamHoc.Text != "")
{
string maLop = cboLop.SelectedValue.ToString();
string maMonHoc = cboMonHoc.SelectedValue.ToString();
string maHocKy = cboHocKy.SelectedValue.ToString();
string maNamHoc = cboNamHoc.SelectedValue.ToString();
bindingSourceDiem.DataSource = HOCTAP_BUS.LayDiemMonHocTheoLop(maLop, maMonHoc, maHocKy, maNamHoc);
bindingNavigatorXemDiemItem.Enabled = true;
}
}
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
string maHS, maMonHoc, maHocKy, maLop;
float diemMieng, diem15P, diem1Tiet, diemThi;
maMonHoc = cboMonHoc.EditValue.ToString();
maHocKy = cboHocKy.EditValue.ToString();
maLop = cboLop.EditValue.ToString();
bindingNavigatorDiem.BindingSource.MoveFirst();
for (int i = 0; i < dgvDiem.RowCount; i++)
{
//maHS, maMon, mahocky, maNamHoc, diemMieng, diem15P, diem1Tiet, diemThi
maHS = dgvDiem.GetFocusedRowCellDisplayText(col_maHS);
if (dgvDiem.GetFocusedRowCellDisplayText(col_diemMieng) != "")
{
diemMieng = float.Parse(dgvDiem.GetFocusedRowCellDisplayText(col_diemMieng));
}
else
{
diemMieng = -1;
}
if (dgvDiem.GetFocusedRowCellDisplayText(col_diem15Phut) != "")
{
diem15P = float.Parse(dgvDiem.GetFocusedRowCellDisplayText(col_diem15Phut));
}
else
{
diem15P = -1;
}
if (dgvDiem.GetFocusedRowCellDisplayText(col_diem15Phut) != "")
{
diem1Tiet = float.Parse(dgvDiem.GetFocusedRowCellDisplayText(col_diem1Tiet));
}
else
{
diem1Tiet = -1;
}
if (dgvDiem.GetFocusedRowCellDisplayText(col_diemThi) != "")
{
diemThi = float.Parse(dgvDiem.GetFocusedRowCellDisplayText(col_diemThi));
}
else
{
diemThi = -1;
}
HOCTAP_BUS.SuaDiem(maHS, maMonHoc, maHocKy, maLop, diemMieng, diem15P, diem1Tiet, diemThi);
bindingNavigatorDiem.BindingSource.MoveNext();
}
state = false;
//string maLop = cboLop.SelectedValue.ToString();
//bindingSourceDiem.DataSource = HOCTAP_BUS.LayDiemMonHocTheoLop(maLop, maMonHoc, maHocKy, maNamHoc);
}
private void load_BangDiem()
{
if (cboLop.Text != "" && cboMonHoc.Text != "" && cboHocKy.Text != "")
{
string maLop = cboLop.EditValue.ToString();
string maMonHoc = cboMonHoc.EditValue.ToString();
string maHocKy = cboHocKy.EditValue.ToString();
string maNamHoc = NAMHOC_BUS.LayNamHocHienTai().MANAMHOC;
bindingSourceDiem.DataSource = HOCTAP_BUS.LayDiemMonHocTheoLop(maLop, maMonHoc, maHocKy, maNamHoc);
bindingNavigatorXemDiemItem.Enabled = true;
}
else
{
bindingSourceDiem.DataSource = null;
}
}
