Quản lý điểm khoa công nghệ thông tin C#
- FormXemDiem.cs
- QuanLyDiem /
- QuanLyDiem /
- project /
1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Linq;
7 using BLL;
8 using System.Text;
9 using Excel = Microsoft.Office.Interop.Excel;
10 using System.Windows.Forms;
11
12 namespace QuanLyDiem
13 {
14 public partial class FormXemDiem : Form
15 {
16 public FormXemDiem()
17 {
18 InitializeComponent();
19 }
20 ClassBLL business = new ClassBLL();
21 private void FormXemDiem_Load(object sender, EventArgs e)
22 {
23 // TODO: This line of code loads data into the 'cNPM_1DataSet4.HocKy' table. You can move, or remove it, as needed.
24 this.hocKyTableAdapter.Fill(this.cNPM_1DataSet_HocKy.HocKy);
25
26 }
27 private void btnThoat_Click(object sender, EventArgs e)
28 {
29 this.Close();
30 }
31
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 }
84
85 private void btnXuatRaExcel_Click(object sender, EventArgs e)
86 {
87 try
88 {
89
90 Excel.Application objExcelApp = new Excel.Application();
91 Excel.Workbook objExcelWorkbook = objExcelApp.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
92 Excel.Worksheet objSheet = (Excel.Worksheet)objExcelWorkbook.Worksheets[1];
93 //objSheet.Cells.Interior.Color.ToString() = 'blue';
94 objSheet = (Excel.Worksheet)objExcelWorkbook.Sheets[1];
95 objSheet.Cells.HorizontalAlignment = Excel.Constants.xlCenter;
96 objSheet.Cells[2, 5] = "BẢNG ĐIỂM CỦA SINH VIÊN";
97 objSheet.Cells[5, 3] = "Mã Học Phần";
98 objSheet.Cells[5, 4] = "Mã Nhóm Học Phần";
99 objSheet.Cells[5, 5] = "Tên Học Phần";
100 objSheet.Cells[5, 6] = "Điểm Thi";
101 objSheet.Cells[5, 7] = "Điểm Quá Trình";
102 objSheet.Cells[5, 8] = "Điểm Xếp Loại";
103 objSheet.Cells[3, 3] = "Mã Học Kỳ : "+cmbMaHK.SelectedValue.ToString()+"";
104 objSheet.Cells[4, 3] = "Mã SV : " + txtMaSV.Text + "";
105 objSheet.Cells[9,10] = "ĐIỂM TỔNG KẾT";
106 objSheet.Cells[10,10] = "Hệ 10 : "+txtHe10.Text+"";
107 objSheet.Cells[11,10] = "Hệ 4 : "+txtHe4.Text+"";
108 for (int i = 0; i < dgvKetQua.Rows.Count ; i++)
109 {
110 for (int j = 0; j < dgvKetQua.Columns.GetColumnCount(DataGridViewElementStates.Displayed); j++)
111 {
112 objSheet.Cells[i + 6, j + 3] = dgvKetQua.Rows[i].Cells[j].Value.ToString();
113 objSheet.Columns.AutoFit();
114 }
115 }
116 objExcelApp.Visible = true;
117 }
118 catch (Exception ex)
119 {
120 MessageBox.Show(ex.Message);
121 }
122 }
123
124 private void txtMaSV_KeyPress(object sender, KeyPressEventArgs e)
125 {
126 if (e.KeyChar == ' ')
127 e.Handled = true;
128 }
129 int j = -1;
130 private void chbXemTatCaHocKy_CheckedChanged(object sender, EventArgs e)
131 {
132 int i = -1;
133 i = i * j;
134 if (i == 1)
135 {
136 cmbMaHK.Enabled = false;
137 }
138 else
139 {
140 cmbMaHK.Enabled = true;
141 }
142 j = -j;
143 }
144 }
145 }
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Linq;
7 using BLL;
8 using System.Text;
9 using Excel = Microsoft.Office.Interop.Excel;
10 using System.Windows.Forms;
11
12 namespace QuanLyDiem
13 {
14 public partial class FormXemDiem : Form
15 {
16 public FormXemDiem()
17 {
18 InitializeComponent();
19 }
20 ClassBLL business = new ClassBLL();
21 private void FormXemDiem_Load(object sender, EventArgs e)
22 {
23 // TODO: This line of code loads data into the 'cNPM_1DataSet4.HocKy' table. You can move, or remove it, as needed.
24 this.hocKyTableAdapter.Fill(this.cNPM_1DataSet_HocKy.HocKy);
25
26 }
27 private void btnThoat_Click(object sender, EventArgs e)
28 {
29 this.Close();
30 }
31
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 }
84
85 private void btnXuatRaExcel_Click(object sender, EventArgs e)
86 {
87 try
88 {
89
90 Excel.Application objExcelApp = new Excel.Application();
91 Excel.Workbook objExcelWorkbook = objExcelApp.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
92 Excel.Worksheet objSheet = (Excel.Worksheet)objExcelWorkbook.Worksheets[1];
93 //objSheet.Cells.Interior.Color.ToString() = 'blue';
94 objSheet = (Excel.Worksheet)objExcelWorkbook.Sheets[1];
95 objSheet.Cells.HorizontalAlignment = Excel.Constants.xlCenter;
96 objSheet.Cells[2, 5] = "BẢNG ĐIỂM CỦA SINH VIÊN";
97 objSheet.Cells[5, 3] = "Mã Học Phần";
98 objSheet.Cells[5, 4] = "Mã Nhóm Học Phần";
99 objSheet.Cells[5, 5] = "Tên Học Phần";
100 objSheet.Cells[5, 6] = "Điểm Thi";
101 objSheet.Cells[5, 7] = "Điểm Quá Trình";
102 objSheet.Cells[5, 8] = "Điểm Xếp Loại";
103 objSheet.Cells[3, 3] = "Mã Học Kỳ : "+cmbMaHK.SelectedValue.ToString()+"";
104 objSheet.Cells[4, 3] = "Mã SV : " + txtMaSV.Text + "";
105 objSheet.Cells[9,10] = "ĐIỂM TỔNG KẾT";
106 objSheet.Cells[10,10] = "Hệ 10 : "+txtHe10.Text+"";
107 objSheet.Cells[11,10] = "Hệ 4 : "+txtHe4.Text+"";
108 for (int i = 0; i < dgvKetQua.Rows.Count ; i++)
109 {
110 for (int j = 0; j < dgvKetQua.Columns.GetColumnCount(DataGridViewElementStates.Displayed); j++)
111 {
112 objSheet.Cells[i + 6, j + 3] = dgvKetQua.Rows[i].Cells[j].Value.ToString();
113 objSheet.Columns.AutoFit();
114 }
115 }
116 objExcelApp.Visible = true;
117 }
118 catch (Exception ex)
119 {
120 MessageBox.Show(ex.Message);
121 }
122 }
123
124 private void txtMaSV_KeyPress(object sender, KeyPressEventArgs e)
125 {
126 if (e.KeyChar == ' ')
127 e.Handled = true;
128 }
129 int j = -1;
130 private void chbXemTatCaHocKy_CheckedChanged(object sender, EventArgs e)
131 {
132 int i = -1;
133 i = i * j;
134 if (i == 1)
135 {
136 cmbMaHK.Enabled = false;
137 }
138 else
139 {
140 cmbMaHK.Enabled = true;
141 }
142 j = -j;
143 }
144 }
145 }