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