Пример #1
0
        private void capNhat()
        {
            if (flag == true)
            {
                LopDAO adapterDAO = new LopDAO();
                Lop[] Danh_Sach_Lop = adapterDAO.getAllClass();

                int chi_soHK = combHocKi.SelectedIndex;
                int chi_soMH = combMonHoc.SelectedIndex;

                if (chi_soHK >= 0 && chi_soMH >= 0)
                {
                    HocKi[] HK = (HocKi[])combHocKi.Tag;
                    HocKi KQHK = HK[chi_soHK];
                    MonHoc[] MonHoc = (MonHoc[])combMonHoc.Tag;
                    MonHoc KQMH = MonHoc[chi_soMH];
                    monHoc = KQMH.TenMonHoc;
                    hocKi = KQHK.TenHocKi;

                    DataTable dt = new DataTable();
                    dt.Columns.Add("Stt");
                    dt.Columns.Add("tenLop");
                    dt.Columns.Add("siSo");
                    dt.Columns.Add("soLuongDat");
                    dt.Columns.Add("tiLe");
                    int stt = 0;
                    int i = 0;
                    noiDungBaoCao = new BaoCaoTongKetMon[Danh_Sach_Lop.Length];
                    foreach (Lop lop in Danh_Sach_Lop)
                    {
                        BaoCaoTongKetMon temp = new BaoCaoTongKetMon();
                        DataRow dr = dt.NewRow();
                        dt.Rows.Add(dr);
                        temp.Stt = stt;
                        dr["Stt"] = stt++;
                        dr["tenLop"] = lop.TenLop;
                        dr["siSo"] = lop.SiSo;
                        int soLuongDat = adapterDAO.soLuongDat(KQMH.MaMonHoc, KQHK.MaHocKi, lop.MaLop);
                        dr["soLuongDat"] = soLuongDat;
                        dr["tiLe"] = (float)soLuongDat / lop.SiSo * 100 + "%";

                        temp.TenLop = lop.TenLop;
                        temp.SiSo = lop.SiSo;
                        temp.SoLuongDat = soLuongDat;
                        temp.TiLe = (float)soLuongDat / lop.SiSo * 100 + "%";

                        noiDungBaoCao[i] = temp;
                        i++;
                    }
                    dgvBaoCao.DataSource = dt;
                }
            }
        }
Пример #2
0
        private void frmThayDoiBangDiem_Load(object sender, EventArgs e)
        {
            LopDAO adaterLop = new LopDAO();
            HocKiDAO adapterHK = new HocKiDAO();
            MonHocDAO adapterMH = new MonHocDAO();

            if (flag == false)
            {
                combMonHoc.DataSource = adapterMH.getAllMH();
                combMonHoc.DisplayMember = "tenMonHoc";
                combMonHoc.Tag = adapterMH.getAllMH();

                combHK.DataSource = adapterHK.getAllHK();
                combHK.DisplayMember = "tenHocKi";
                combHK.Tag = adapterHK.getAllHK();

                combLop.DataSource = adaterLop.getAllClass();
                combLop.DisplayMember = "tenLop";
                combLop.Tag = adaterLop.getAllClass();
                flag = true;
            }
            XL_Chon();
        }