DO

213         public string TinhDiemTB(string MaSV, string MaHK)
214         {
215             SqlConnection con = da.GetConnect();
216             con.Open();
217             //view tc
218             string sql1 = " select 'sotinchi'=sum(SoTC) " +
219                                " from KetQua kq,HocPhan hp,NhomHocPhan nhp,KeHoachGiangDay khgd " +
220                                " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khgd.MaKHGD=nhp.MaKHGD and MaSV='"+MaSV+"' and MaHK='"+MaHK+"' " +
221                                " group by MaSV ";
222             SqlCommand cmd1 = new SqlCommand(sql1, con);
223             string tc = cmd1.ExecuteScalar().ToString();
224             // view diem10
225             string sql2 = " select 'cuoiky'=sum(DiemTk10*SoTC) " +
226                                " from KetQua kq,NhomHocPhan nhp,HocPhan hp,KeHoachGiangDay khdt " +
227                                " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khdt.MaKHGD=nhp.MaKHGD and MaSV='"+MaSV+"' and MaHK='"+MaHK+"' " +
228                                " group by MaSV ";
229             SqlCommand cmd2 = new SqlCommand(sql2, con);
230             string diem10 = cmd2.ExecuteScalar().ToString();
231             //view diem4
232             string sql3 = " select 'cuoiky'=sum(DiemTk4*SoTC) " +
233                                " from KetQua kq,NhomHocPhan nhp,HocPhan hp,KeHoachGiangDay khdt " +
234                                " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khdt.MaKHGD=nhp.MaKHGD and MaSV='"+MaSV+"' and MaHK='"+MaHK+"' " +
235                                " group by MaSV ";
236             SqlCommand cmd3 = new SqlCommand(sql3, con);
237             string diem4 = cmd3.ExecuteScalar().ToString();
238
239
240             string ketqua="";
241             ketqua = Convert.ToDouble(diem10) / Convert.ToDouble(tc) + "," + Convert.ToDouble(diem4) / Convert.ToDouble(tc) ;
242             return ketqua;
243         }

244         public string TinhDiemTB(string MaSV)
245         {
246             SqlConnection con = da.GetConnect();
247             con.Open();
248             //view tc
249             string sql1 = " select 'sotinchi'=sum(SoTC) " +
250                                " from KetQua kq,HocPhan hp,NhomHocPhan nhp,KeHoachGiangDay khgd " +
251                                " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khgd.MaKHGD=nhp.MaKHGD and MaSV='" + MaSV + "'" +
252                                " group by MaSV ";
253             SqlCommand cmd1 = new SqlCommand(sql1, con);
254             string tc = cmd1.ExecuteScalar().ToString();
255             // view diem10
256             string sql2 = " select 'cuoiky'=sum(DiemTk10*SoTC) " +
257                                " from KetQua kq,NhomHocPhan nhp,HocPhan hp,KeHoachGiangDay khdt " +
258                                " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khdt.MaKHGD=nhp.MaKHGD and MaSV='" + MaSV + "'" +
259                                " group by MaSV ";
260             SqlCommand cmd2 = new SqlCommand(sql2, con);
261             string diem10 = cmd2.ExecuteScalar().ToString();
262             //view diem4
263             string sql3 = " select 'cuoiky'=sum(DiemTk4*SoTC) " +
264                                " from KetQua kq,NhomHocPhan nhp,HocPhan hp,KeHoachGiangDay khdt " +
265                                " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khdt.MaKHGD=nhp.MaKHGD and MaSV='" + MaSV + "'" +
266                                " group by MaSV ";
267             SqlCommand cmd3 = new SqlCommand(sql3, con);
268             string diem4 = cmd3.ExecuteScalar().ToString();
269
270
271             string ketqua = "";
272             ketqua = Convert.ToDouble(diem10) / Convert.ToDouble(tc) + "," + Convert.ToDouble(diem4) / Convert.ToDouble(tc);
273             return ketqua;
274         }

139         public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
140             crBaoCao rpt = new crBaoCao();
141             rpt.Site = this.Site;
142             return rpt;
143         }

19         private void btnDong_Click(object sender, EventArgs e)
20         {
21             this.Close();
22         }

31         private void dgvGiangVien_RowEnter(object sender, DataGridViewCellEventArgs e)
32         {
33             dong = e.RowIndex;
34             txtMaGV.Text = dgvGiangVien.Rows[dong].Cells[0].Value.ToString();
35             txtTenGV.Text = dgvGiangVien.Rows[dong].Cells[1].Value.ToString();
36             dtpNamSinh.Text = dgvGiangVien.Rows[dong].Cells[2].Value.ToString();
37             txtDiaChi.Text = dgvGiangVien.Rows[dong].Cells[3].Value.ToString();
38         }

30         private void dgvHeDaoTao_RowEnter(object sender, DataGridViewCellEventArgs e)
31         {
32             dong = e.RowIndex;
33             txtMaHeDT.Text = dgvHeDaoTao.Rows[dong].Cells[0].Value.ToString();
34             txtTenHeDT.Text = dgvHeDaoTao.Rows[dong].Cells[1].Value.ToString();
35         }

30         private void dgvHocKy_RowEnter(object sender, DataGridViewCellEventArgs e)
31         {
32             dong = e.RowIndex;
33             txtMaHocKy.Text = dgvHocKy.Rows[dong].Cells[0].Value.ToString();
34             txtTenHocKy.Text = dgvHocKy.Rows[dong].Cells[1].Value.ToString();
35             txtNamHoc.Text = dgvHocKy.Rows[dong].Cells[2].Value.ToString();
36             dtpBatDau.Text = dgvHocKy.Rows[dong].Cells[3].Value.ToString();
37             dtpKetThuc.Text = dgvHocKy.Rows[dong].Cells[4].Value.ToString();
38         }

65         private void dgvHocPhan_RowEnter(object sender, DataGridViewCellEventArgs e)
66         {
67             dong = e.RowIndex;
68             txtMaHP.Text = dgvHocPhan.Rows[dong].Cells[0].Value.ToString();
69             txtTenHP.Text = dgvHocPhan.Rows[dong].Cells[1].Value.ToString();
70             txtSoTC.Text = dgvHocPhan.Rows[dong].Cells[2].Value.ToString();
71             txtSoTietTH.Text=dgvHocPhan.Rows[dong].Cells[3].Value.ToString();
72             txtSoTietLT.Text = dgvHocPhan.Rows[dong].Cells[4].Value.ToString();
73             txtPhanTramDQT.Text = dgvHocPhan.Rows[dong].Cells[5].Value.ToString();
74             txtPhanTramDT.Text = dgvHocPhan.Rows[dong].Cells[6].Value.ToString();
75         }

70         private void dgvKHGD_RowEnter(object sender, DataGridViewCellEventArgs e)
71         {
72             dong = e.RowIndex;
73             txtMaKHGD.Text = dgvKHGD.Rows[dong].Cells[0].Value.ToString();
74             cmbMahocKy.SelectedValue = dgvKHGD.Rows[dong].Cells[1].Value.ToString();
75             cmbMaKhoiLop.SelectedValue = dgvKHGD.Rows[dong].Cells[2].Value.ToString();
76         }

20         private void FormKhoiLop_Load(object sender, EventArgs e)
21         {
22             // TODO: This line of code loads data into the 'cNPM_1DataSet3.TrinhDoDaoTao' table. You can move, or remove it, as needed.
23             this.trinhDoDaoTaoTableAdapter.Fill(this.cNPM_1DataSet_TrinhDoDaoTao.TrinhDoDaoTao);
24             // TODO: This line of code loads data into the 'cNPM_1DataSet2.HeDaoTao' table. You can move, or remove it, as needed.
25             this.heDaoTaoTableAdapter.Fill(this.cNPM_1DataSet_HeDaoTao.HeDaoTao);
26             dgvKhoiLop.DataSource = business.ShowData("KhoiLop");
27         }