Values

15         public void ChuanBi3Table(string MaHK)
16         {
17             //Table 1
18             string sql1 = " select MaSV,'sotinchi'=sum(SoTC) " +
19                        " from KetQua kq,HocPhan hp,NhomHocPhan nhp,KeHoachGiangDay khgd " +
20                        " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khgd.MaKHGD=nhp.MaKHGD and MaHK='" + MaHK + "' " +
21                        " group by MaSV ";
22             DataTable dt1 = da.GetTable(sql1);
23             for (int i = 0; i < dt1.Rows.Count; i++)
24             {
25                 string sql_1 = "Insert into Loptc values('" + dt1.Rows[i][0] + "'," + dt1.Rows[i][1] + ")";
26                 da.ExcuteNonQuery(sql_1);
27             }
28             //Table 2
29             string sql2 = "select MaSV,'cuoiky'=sum(DiemTk10*SoTC) " +
30                            " from KetQua kq,NhomHocPhan nhp,HocPhan hp,KeHoachGiangDay khdt " +
31                            " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khdt.MaKHGD=nhp.MaKHGD and MaHK='" + MaHK + "' " +
32                            " group by MaSV ";
33             DataTable dt2 = da.GetTable(sql2);
34             for (int i = 0; i < dt2.Rows.Count; i++)
35             {
36                 string sql_2 = "Insert into Lopdiem10 values('" + dt2.Rows[i][0] + "'," + dt2.Rows[i][1] + ")";
37                 da.ExcuteNonQuery(sql_2);
38             }
39             //Table 3
40             string sql3 = " select Lopdiem10.MaSV,'TrungBinhCuoiKyHe10'=cuoiky/sotinchi " +
41                            " from Lopdiem10 left join Loptc on Loptc.MaSV=Lopdiem10.MaSV";
42             DataTable dt3 = da.GetTable(sql3);
43             for (int i = 0; i < dt3.Rows.Count; i++)
44             {
45                 string sql_3 = "Insert into DTB values('" + dt3.Rows[i][0] + "'," + dt3.Rows[i][1] + ")";
46                 da.ExcuteNonQuery(sql_3);
47             }
48         }

49         public void ChuanBi3Table()
50         {
51             //Table 1
52             string sql1 = " select MaSV,'sotinchi'=sum(SoTC) " +
53                        " from KetQua kq,HocPhan hp,NhomHocPhan nhp,KeHoachGiangDay khgd " +
54                        " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khgd.MaKHGD=nhp.MaKHGD " +
55                        " group by MaSV ";
56             DataTable dt1 = da.GetTable(sql1);
57             for (int i = 0; i < dt1.Rows.Count; i++)
58             {
59                 string sql_1 = "Insert into Loptc values('" + dt1.Rows[i][0] + "'," + dt1.Rows[i][1] + ")";
60                 da.ExcuteNonQuery(sql_1);
61             }
62             //Table 2
63             string sql2 = "select MaSV,'cuoiky'=sum(DiemTk10*SoTC) " +
64                            " from KetQua kq,NhomHocPhan nhp,HocPhan hp,KeHoachGiangDay khdt " +
65                            " where kq.MaNhomHP=nhp.MaNhomHP and nhp.MaHP=hp.MaHP and khdt.MaKHGD=nhp.MaKHGD " +
66                            " group by MaSV ";
67             DataTable dt2 = da.GetTable(sql2);
68             for (int i = 0; i < dt2.Rows.Count; i++)
69             {
70                 string sql_2 = "Insert into Lopdiem10 values('" + dt2.Rows[i][0] + "'," + dt2.Rows[i][1] + ")";
71                 da.ExcuteNonQuery(sql_2);
72             }
73             //Table 3
74             string sql3 = " select Lopdiem10.MaSV,'TrungBinhCuoiKyHe10'=cuoiky/sotinchi " +
75                            " from Lopdiem10 left join Loptc on Loptc.MaSV=Lopdiem10.MaSV";
76             DataTable dt3 = da.GetTable(sql3);
77             for (int i = 0; i < dt3.Rows.Count; i++)
78             {
79                 string sql_3 = "Insert into DTB values('" + dt3.Rows[i][0] + "'," + dt3.Rows[i][1] + ")";
80                 da.ExcuteNonQuery(sql_3);
81             }
82         }

302         public void Insert(string table,string sql)
303         {
304             sql = "insert into "+table+" values("+sql+")";
305             da.ExcuteNonQuery(sql);
306         }

40         private void btnLoc_Click(object sender, EventArgs e)
41         {
42             SqlConnection con = dal.GetConnect();
43             con.Open();
44             string sql = "select *from SinhVien where MaLop=@MaLop";
45             SqlDataAdapter da = new SqlDataAdapter(sql, con);
46             da.SelectCommand.Parameters.AddWithValue("@MaLop", cmbMaLop.SelectedValue.ToString());
47             DataTable dt = new DataTable();
48             da.Fill(dt);
49             crBaoCao cr = new crBaoCao();
50             ConnectionInfo crConnectionInfo = new ConnectionInfo();
51             crConnectionInfo.ServerName = "Ty-PC";
52             crConnectionInfo.DatabaseName = "CNPM_1";
53             crConnectionInfo.UserID = "sa";
54             crConnectionInfo.Password = "04091990";
55             TableLogOnInfos crTableLogonInfos = new TableLogOnInfos();
56             foreach (CrystalDecisions.CrystalReports.Engine.Table table in cr.Database.Tables)
57             {
58                 TableLogOnInfo crTableLogonInfo = new TableLogOnInfo();
59                 crTableLogonInfo.TableName = table.Name;
60                 crTableLogonInfo.ConnectionInfo = crConnectionInfo;
61                 crTableLogonInfos.Add(crTableLogonInfo);
62                 table.ApplyLogOnInfo(crTableLogonInfo);
63
64             }
65             crvHocKyHocPhan.LogOnInfo = crTableLogonInfos;
66             cr.SetDataSource(dt);
67             ParameterValues a = new ParameterValues();
68             ParameterDiscreteValue b = new ParameterDiscreteValue();
69             b.Value = cmbMaLop.SelectedValue.ToString();
70             a.Add(b);
71             cr.DataDefinition.ParameterFields["txtMaLop"].ApplyCurrentValues(a);
72             crvHocKyHocPhan.ReportSource = cr;
73             crvHocKyHocPhan.Show();
74         }

311         private void button4_Click(object sender, EventArgs e)
312         {
313             if (richTextBox1.Text == "" || textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || (checkBox1.Checked == false && checkBox2.Checked == false && checkBox3.Checked == false && checkBox4.Checked == false))
314             {
315                 MessageBox.Show("Bạn chưa thêm đầy đủ thông tin", "Thông báo");
316             }
317             else
318             {
319                 try
320                 {
321
322                     string sCauA = textBox1.Text;
323                     string sCauB = textBox2.Text;
324                     string sCauC = textBox3.Text;
325                     string sCauD = textBox4.Text;
326                     string sMaCH = textBox5.Text;
327                     string sCauHoi = richTextBox1.Text;
328                     string sCauDung = "";
329                     string sCauDungLuu = "";
330                     string sTrinhDo = comboBox1.Text;
331                     if (checkBox1.Checked == true)
332                     {
333                         sCauDung = "A";
334                         sCauDungLuu += sCauDung;
335                     }
336                     if (checkBox2.Checked == true)
337                     {
338                         sCauDung = "B";
339                         sCauDungLuu += sCauDung;
340                     }
341                     if (checkBox3.Checked == true)
342                     {
343                         sCauDung = "C";
344                         sCauDungLuu += sCauDung;
345                     }
346                     if (checkBox4.Checked == true)
347                     {
348                         sCauDung = "D";
349                         sCauDungLuu += sCauDung;
350                     }
351
352                     sqlcmd = new SqlCommand("insert into dapan values('" + sMaCH + "','" + sCauA + "','" + sCauB + "','" + sCauC + "','" + sCauD + "','" + sCauDungLuu + "') ", sqlcon);
353                     sqlcmd.ExecuteNonQuery();
354                     sqlcmd = new SqlCommand("insert into cauhoi values('" + sMaCH + "','" + sCauHoi + "','" + sTrinhDo + "') ", sqlcon);
355                     sqlcmd.ExecuteNonQuery();
356                     LoadDataToListView();
357                     button4.Enabled = false;
358                 }
359                 //roi hen;de bi coi lai thu de cHOAky thu chay thu hen ok
360                 catch
361                 {
362                     MessageBox.Show("Bạn đã thao tác sai");
363                 }
364             }
365         }

30         private void btbatdauthi_Click(object sender, EventArgs e)
31         {
32             try
33             {
34                 if (tbten.Text == "" || tbmathisinh.Text == "")
35                 {
36                     MessageBox.Show("Bạn phải điền đầy đủ thông tin");
37                 }
38                 else
39                 {
40                     string TenThSinh = tbten.Text;
41                     string MaThiSinh = tbmathisinh.Text;
42                     string strSQL = "insert THISINHTHI values('" + MaThiSinh + "','" + TenThSinh + "')";
43                     SqlCommand ObjCmd = new SqlCommand(strSQL, ObjCon);
44                     ObjCmd.ExecuteNonQuery();
45                     if (MessageBox.Show("Bạn có chắc chắn thi không ?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
46                     {
47
48                         string dienten = this.tbten.Text;//chuyen thong tin sang form thithat
49                         string dienma = this.tbmathisinh.Text;
50                         frmThiThat thithat = new frmThiThat(dienten, dienma);
51                         thithat.ShowDialog();
52                         this.Close();
53
54
55                     }
56
57                 }
58             }
59             catch
60             {
61                 MessageBox.Show("Mã thí sinh trùng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
62             }
63
64     }

18         public frmKetQua(string strten, string strma, string strdiem, string strsocaudung)
19         {
20             string strCon = "server=.\\SQLEXPRESS;database=QL_Thitracnghiem;integrated security=true";
21             ObjCon = new SqlConnection(strCon);
22             ObjCon.Open();
23             InitializeComponent();
24
25
26             getvalueformdienten = strten;//ten
27             getvalueformdienma = strma;//ma thi sinh
28             getvaluediem = strdiem;//diem
29             getvaluesocaudung = strsocaudung;//so cau dung
30             socausai = 50 - int.Parse(strsocaudung);//so cau sai
31             lbsocausai.Text = socausai.ToString();
32         }

69         private void frmKetQua_Load(object sender, EventArgs e)
70         {
71             string strma,strsocaudung,strdiem;
72             strma = lbmathisinh.Text;
73             strsocaudung =lbsocaudung.Text;
74             strdiem= lbdiem.Text;
75             strngay = DateTime.Now.ToShortDateString();
76             lbngay.Text = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString();
77             string strSQL = "insert KETQUA values('" + strma + "','" + strngay + "','" + strsocaudung + "','" + socausai + "','" + strdiem + "')";
78             SqlCommand ObjCmd = new SqlCommand(strSQL, ObjCon);
79             ObjCmd.ExecuteNonQuery();
80         }

67         private void btnthem_Click(object sender, EventArgs e)
68         {
69             try
70             {
71             string mats = textBox1.Text;
72             string hoten = textBox2.Text;
73             string ngaysinh = textBox3.Text;
74             string gioitinh = textBox4.Text;
75             string quequan = textBox5.Text;
76             string sodt = textBox6.Text;
77             string email = textBox7.Text;
78
79             string strSQL = "insert SINHVIEN values('" + mats + "','" + hoten + "','" + ngaysinh + "','" + gioitinh + "','" + quequan + "','" + sodt + "','" + email + "')";
80             sqlcmd = new SqlCommand(strSQL, sqlcon);
81             sqlcmd.ExecuteNonQuery();
82             MessageBox.Show("B?n dã dang ký thành công");
83             load();
84             }
85                 catch
86             {
87                 MessageBox.Show("Trùng mã sinh viên !!!");
88                 }
89
90         }

43         private void button1_Click(object sender, EventArgs e)
44         {
45             if (txt1.Text == "" || txt2.Text == "" || txt6.Text == "")
46             {
47                 MessageBox.Show("Bạn phải nhập giá trị vào các ô có dấu *");
48             }
49             else
50             {
51                 string TenDangNhap = txt1.Text;
52                 string MatKhau = txt2.Text;
53                 string HoVaTen = txt3.Text;
54                 string NgaySinh = txt4.Text;
55                 string NoiSinh = txt5.Text;
56                 string SoDienThoai = txt6.Text;
57
58                 string strSQL = "insert THISINH values('" + TenDangNhap + "','" + MatKhau + "','" + HoVaTen + "','" + NgaySinh + "','" + NoiSinh + "','" + SoDienThoai + "')";
59                 SqlCommand ObjCmd = new SqlCommand(strSQL, ObjCon);
60                 ObjCmd.ExecuteNonQuery();
61                 MessageBox.Show("Bạn đã đăng ký thành công");
62                 this.Close();
63             }
64         }