Mh
How do I use Mh
Below are practical examples compiled from projects for learning and reference purposes
Featured Snippets
File name: ClassBLL.cs
Copy
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 }
File name: ClassBLL.cs
Copy
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 }
File name: ClassBLL.cs
Copy
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 }
File name: ClassBLL.cs
Copy
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 }
File name: Form9.cs
Copy
24 public void PhanQuyenMenu()
25 {
26 switch (quyen)
27 {
28 case 1 :
29 btnTDDT.Enabled = true;
30 btnHeDT.Enabled = true;
31 btnHocKy.Enabled = true;
32 btnKHGD.Enabled = true;
33 btnKhoiLop.Enabled = true;
34 btnDangNhap.Enabled = false;
35 btnDangXuat.Enabled = true;
36 btnPhanQuyen.Enabled = true;
37 btnGiangVien.Enabled = true;
38 btnHocPhan.Enabled = true;
39 btnLop.Enabled = true;
40 btnNhomHocPhan.Enabled = true;
41 btnSinhVien.Enabled = true;
42 btnQuanLyDiem.Enabled = true;
43 btnXemDiemLop.Enabled = false;
44 btnXemDiemNhomHP.Enabled = true ;
45 btnBaoCao.Enabled = true;
46 btnThongKe.Enabled = true;
47 btnXemDiem.Enabled = true;
48 btnXemDiemLop.Enabled = true;
49 break;
50 case 2 :
51 btnDangNhap.Enabled = false;
52 btnDangXuat.Enabled = true;
53 btnBaoCao.Enabled = false;
54 btnThongKe.Enabled = false;
55 btnXemDiem.Enabled = true;
56 btnXemDiemNhomHP.Enabled = false;
57 break;
58 default:
59 btnTDDT.Enabled = false;
60 btnHeDT.Enabled = false;
61 btnHocKy.Enabled = false;
62 btnKHGD.Enabled = false;
63 btnKhoiLop.Enabled = false;
64 btnDangNhap.Enabled = true;
65 btnDangXuat.Enabled = false;
66 btnPhanQuyen.Enabled = false;
67 btnGiangVien.Enabled = false;
68 btnHocPhan.Enabled = false;
69 btnLop.Enabled = false;
70 btnNhomHocPhan.Enabled = false;
71 btnSinhVien.Enabled = false;
72 btnQuanLyDiem.Enabled = false;
73 btnThongKe.Enabled = false;
74 btnXemDiemLop.Enabled = false;
75 btnBaoCao.Enabled = false;
76 btnXemDiemNhomHP.Enabled = false;
77 btnXemDiem.Enabled = false;
78 break;
79 }
80 }
File name: Form9.cs
Copy
114 private void btnHuongDan_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
115 {
116 CloseForm("Form9");
117 FormHDSD f = new FormHDSD();
118 f.MdiParent = this;
119 f.Show();
120 }
File name: Form9.cs
Copy
140 private void btnHeDT_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
141 {
142 CloseForm("Form9");
143 FormHeDaoTao f = new FormHeDaoTao();
144 f.MdiParent = this;
145 f.Show();
146 }
File name: Form9.cs
Copy
148 private void btnHocKy_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
149 {
150 CloseForm("Form9");
151 FormHocKy f = new FormHocKy();
152 f.MdiParent = this;
153 f.Show();
154 }
File name: Form9.cs
Copy
164 private void btnHocPhan_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
165 {
166 CloseForm("Form9");
167 FormHocPhan f = new FormHocPhan();
168 f.MdiParent = this;
169 f.Show();
170 }
File name: Form9.cs
Copy
204 private void btnNhomHocPhan_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
205 {
206 CloseForm("Form9");
207 FormNhomHocPhan f = new FormNhomHocPhan();
208 f.MdiParent = this;
209 f.Show();
210 }
Download file with original file name:Mh
Mh 153 lượt xem
Gõ tìm kiếm nhanh...
Dự án liên quan!
Cách sửa bàn phím laptop bị liệt hiệu quả 170k
506 lượt xem
Java enum Constructor
482 lượt xem
Toán tử Spread JavaScript
750 lượt xem
LinQ.QLTV.designer.cs.dll
887 lượt xem
QLTV.designer.cs.dll
900 lượt xem