public Diem[] getMarkIf(int maLop, int maMonHoc, int maHocKi)
{
string nameProc = "sp_LayBangDiem1MonCuaLop";
SqlParameter[] para = new SqlParameter[3];
para[0] = new SqlParameter("@maLop",maLop);
para[1] = new SqlParameter("@maMonHoc", maMonHoc);
para[2] = new SqlParameter("@maHocKi", maHocKi);
DataTable dt = DataProvider.executeStoreProcedureQuery(nameProc, para);
HocSinhDAO adapterHs = new HocSinhDAO();
HocSinh []HS = adapterHs.getStudentIf(maLop, maMonHoc, maHocKi);
int n = dt.Rows.Count;
Diem[] allMark = new Diem[n];
for (int i = 0; i < n; i++)
{
Diem TK = GetDataFromDataRow(dt, i);
allMark[i] = TK;
if (maDiem != -1)
{
BangDiemMonDAO adapter = new BangDiemMonDAO();
adapter.InsertMarkTable(HS[i].MaHocSinh,maDiem,maMonHoc,maHocKi);
}
}
return allMark;
}
private void XL_Chon()
{
if (flag == true)
{
DiemDAO adapterDiem = new DiemDAO();
HocSinhDAO adapterHS = new HocSinhDAO();
if (combHK.Text != "" && combLop.Text != "" && combMonHoc.Text != "" && combHK.SelectedIndex >= 0 && combLop.SelectedIndex >= 0 && combMonHoc.SelectedIndex>=0)
{
int chi_soHK = combHK.SelectedIndex;
int chi_soLop = combLop.SelectedIndex;
int chi_soMH = combMonHoc.SelectedIndex;
HocKi KQHK;
MonHoc KQMH;
Lop KQL;
if (chi_soHK >= 0 && chi_soLop >= 0 && chi_soMH >= 0)
{
HocKi[] HK = (HocKi[])combHK.Tag;
KQHK = HK[chi_soHK];
Lop[] Lop = (Lop[])combLop.Tag;
KQL = Lop[chi_soLop];
MonHoc[] MonHoc = (MonHoc[])combMonHoc.Tag;
KQMH = MonHoc[chi_soMH];
HocSinh[] HS = adapterHS.getStudentIf(KQL.MaLop, KQMH.MaMonHoc, KQHK.MaHocKi);
diem = adapterDiem.getStudentIf(KQL.MaLop, KQMH.MaMonHoc, KQHK.MaHocKi);
DataTable dt = new DataTable();
dt.Columns.Add("hoTen");
dt.Columns.Add("diem15Phut");
dt.Columns.Add("diem1Tiet");
dt.Columns.Add("diemHocKi");
for (int i = 0; i < HS.Length; i++)
{
DataRow Dong = dt.NewRow();
dt.Rows.Add(Dong);
Dong["hoTen"] = HS[i].HoTen;
Dong["diem15Phut"] = diem[i].Diem15Phut;
Dong["diem1Tiet"] = diem[i].Diem1Tiet;
Dong["diemHocKi"] = diem[i].DiemHocKi;
}
dgvBangDiem.DataSource = dt;
}
}
}
}
