SP

25         public void ExcuteNonQuery(string sql)
26         {
27             SqlConnection con = GetConnect();
28             con.Open();
29             SqlCommand cmd = new SqlCommand(sql, con);
30             cmd.ExecuteNonQuery();
31             cmd.Dispose();
32             con.Close();
33         }

130         public virtual System.TimeSpan CacheTimeOut {
131             get {
132                 return CachedReportConstants.DEFAULT_TIMEOUT;
133             }
134             set {
135                 //
136             }
137         }

27         public void loadCmb()
28         {
29             SqlConnection con = dal.GetConnect();
30             con.Open();
31             SqlCommand cm = new SqlCommand("Select *from Lop", con);
32             SqlDataAdapter da = new SqlDataAdapter(cm);
33             DataTable dt = new DataTable();
34             da.Fill(dt);
35             this.cmbMaLop.DisplayMember = "MaLop";
36             this.cmbMaLop.ValueMember = "MaLop";
37             this.cmbMaLop.DataSource = dt;
38         }

29         public void loadCmbMaNhomHP(string MaHK)
30         {
31             SqlConnection con = dal.GetConnect();
32             con.Open();
33             SqlCommand cm = new SqlCommand("Select MaNhomHP from NhomHocPhan,KeHoachGiangDay where NhomHocPhan.MaKHGD=KeHoachGiangDay.MaKHGD and KeHoachGiangDay.MaHK='"+MaHK+"'", con);
34             SqlDataAdapter da = new SqlDataAdapter(cm);
35             DataTable dt = new DataTable();
36             da.Fill(dt);
37             this.cmbMaNhomHP.DisplayMember = "MaNhomHP";
38             this.cmbMaNhomHP.ValueMember = "MaNhomHP";
39             this.cmbMaNhomHP.DataSource = dt;
40         }

27         public void loadCmbLop()
28         {
29             SqlConnection con = dal.GetConnect();
30             con.Open();
31             SqlCommand cm = new SqlCommand("Select *from Lop", con);
32             SqlDataAdapter da = new SqlDataAdapter(cm);
33             DataTable dt = new DataTable();
34             da.Fill(dt);
35             this.cmbMa.DisplayMember = "MaLop";
36             this.cmbMa.ValueMember = "MaLop";
37             this.cmbMa.DataSource = dt;
38         }

39         public void loadCmbKhoiLop()
40         {
41             SqlConnection con = dal.GetConnect();
42             con.Open();
43             SqlCommand cm = new SqlCommand("Select *from KhoiLop", con);
44             SqlDataAdapter da = new SqlDataAdapter(cm);
45             DataTable dt = new DataTable();
46             da.Fill(dt);
47             this.cmbMa.DisplayMember = "MaKhoiLop";
48             this.cmbMa.ValueMember = "MaKhoiLop";
49             this.cmbMa.DataSource = dt;
50         }

90         public void loadCmbMaHK()
91         {
92             SqlConnection con = dal.GetConnect();
93             con.Open();
94             SqlCommand cm = new SqlCommand("Select *from HocKy", con);
95             SqlDataAdapter da = new SqlDataAdapter(cm);
96             DataTable dt = new DataTable();
97             da.Fill(dt);
98             this.cmbMaHK.DisplayMember = "MaHK";
99             this.cmbMaHK.ValueMember = "MaHK";
100             this.cmbMaHK.DataSource = dt;
101         }

40         public void loadCmbMaHP()
41         {
42             SqlConnection con = dal.GetConnect();
43             con.Open();
44             SqlCommand cm = new SqlCommand("Select *from HocPhan", con);
45             SqlDataAdapter da = new SqlDataAdapter(cm);
46             DataTable dt = new DataTable();
47             da.Fill(dt);
48             this.cmbMaHP.DisplayMember = "TenHP";
49             this.cmbMaHP.ValueMember = "MaHP";
50             this.cmbMaHP.DataSource = dt;
51         }

44         public void loadCmbMaHP()
45         {
46             SqlConnection con = dal.GetConnect();
47             con.Open();
48             SqlCommand cm = new SqlCommand("Select *from HocPhan", con);
49             SqlDataAdapter da = new SqlDataAdapter(cm);
50             DataTable dt = new DataTable();
51             da.Fill(dt);
52             this.cmbMaHP.DisplayMember = "TenHP";
53             this.cmbMaHP.ValueMember = "MaHP";
54             this.cmbMaHP.DataSource = dt;
55         }

32         private void btnXem_Click(object sender, EventArgs e)
33         {
34             string sql1 = "select TenSV from SinhVien where MaSV='" + txtMaSV.Text + "'";
35             if (business.ShowData_where(sql1).Rows.Count!=0)
36             {
37                 lblTenSV.Text= business.ShowData_where(sql1).Rows[0][0].ToString();
38                 lblTenSV.Visible = true;
39             }
40             if (chbXemTatCaHocKy.Checked == true)
41             {
42                 string sql = "select HocPhan.MaHP,NhomHocPhan.MaNhomHP,HocPhan.TenHP,KetQua.DiemQT,KetQua.DiemThi,KetQua.DiemXepLoai " +
43                                " From KetQua,HocPhan,NhomHocPhan,KeHoachGiangDay " +
44                                 " Where KetQua.MaSV='" + txtMaSV.Text + "' " +
45                                    " and KetQua.MaNhomHP=NhomHocPhan.MaNhomHP " +
46                                    " and NhomHocPhan.MaHP=HocPhan.MaHP " +
47                                    " and NhomHocPhan.MaKHGD=KeHoachGiangDay.MaKHGD ";
48                 dgvKetQua.DataSource = business.ShowData_where(sql);
49                 if (dgvKetQua.RowCount > 0)
50                 {
51                     string test = business.TinhDiemTB(txtMaSV.Text);
52                     txtHe10.Text = test.Split(',')[0];
53                     txtHe4.Text = test.Split(',')[1];
54                 }
55                 else
56                 {
57                     txtHe10.Text = "";
58                     txtHe4.Text = "";
59                 }
60             }
61             else
62             {
63                 string sql = "select HocPhan.MaHP,NhomHocPhan.MaNhomHP,HocPhan.TenHP,KetQua.DiemQT,KetQua.DiemThi,KetQua.DiemXepLoai " +
64                                " From KetQua,HocPhan,NhomHocPhan,KeHoachGiangDay " +
65                                 " Where KetQua.MaSV='" + txtMaSV.Text + "' " +
66                                    " and KetQua.MaNhomHP=NhomHocPhan.MaNhomHP " +
67                                    " and NhomHocPhan.MaHP=HocPhan.MaHP " +
68                                    " and NhomHocPhan.MaKHGD=KeHoachGiangDay.MaKHGD " +
69                                    " and KeHoachGiangDay.MaHK='" + cmbMaHK.SelectedValue.ToString() + "'";
70                 dgvKetQua.DataSource = business.ShowData_where(sql);
71                 if (dgvKetQua.RowCount > 0)
72                 {
73                     string test = business.TinhDiemTB(txtMaSV.Text, cmbMaHK.SelectedValue.ToString());
74                     txtHe10.Text = test.Split(',')[0];
75                     txtHe4.Text = test.Split(',')[1];
76                 }
77                 else
78                 {
79                     txtHe10.Text = "";
80                     txtHe4.Text = "";
81                 }
82             }
83         }