Default

96         public DataTable ThongKeLop(string MaHK,string MaLop,int loai)
97         {
98             SqlConnection con = da.GetConnect();
99             ChuanBi3Table(MaHK);
100             //Truy van cuoi cung
101             string sql4;
102             switch (loai)
103             {
104                 case 0:
105                     sql4 = "select sv.MaSV,TenSV,TrungBinhCuoiKyHe10 " +
106                            " from DTB left join SinhVien sv on DTB.MaSV=sv.MaSV " +
107                            " where MaLop='" + MaLop + "' and TrungBinhCuoiKyHe10 >= 9";
108                     break;
109                 case 1:
110                     sql4 = "select sv.MaSV,TenSV,TrungBinhCuoiKyHe10 " +
111                            " from DTB left join SinhVien sv on DTB.MaSV=sv.MaSV " +
112                            " where MaLop='" + MaLop + "' and TrungBinhCuoiKyHe10 >=8 and TrungBinhCuoiKyHe10 < 9";
113                     break;
114                 case 2:
115                     sql4 = "select sv.MaSV,TenSV,TrungBinhCuoiKyHe10 " +
116                            " from DTB left join SinhVien sv on DTB.MaSV=sv.MaSV " +
117                            " where MaLop='" + MaLop + "' and TrungBinhCuoiKyHe10 >=6.5 and TrungBinhCuoiKyHe10 < 8";
118                     break;
119                 case 3:
120                     sql4 = "select sv.MaSV,TenSV,TrungBinhCuoiKyHe10 " +
121                            " from DTB left join SinhVien sv on DTB.MaSV=sv.MaSV " +
122                            " where MaLop='" + MaLop + "' and TrungBinhCuoiKyHe10 >=5 and TrungBinhCuoiKyHe10 < 6.5";
123                     break;
124                 case 4:
125                     sql4 = "select sv.MaSV,TenSV,TrungBinhCuoiKyHe10 " +
126                            " from DTB left join SinhVien sv on DTB.MaSV=sv.MaSV " +
127                            " where MaLop='" + MaLop + "' and TrungBinhCuoiKyHe10 >=3.5 and TrungBinhCuoiKyHe10 < 5";
128                     break;
129                 default:
130                     sql4 = "select sv.MaSV,TenSV,TrungBinhCuoiKyHe10 " +
131                            " from DTB left join SinhVien sv on DTB.MaSV=sv.MaSV " +
132                            " where MaLop='" + MaLop + "' and TrungBinhCuoiKyHe10 < 3.5";
133                     break;
134             }
135             DataTable dt4 = da.GetTable(sql4);
136             da.ExcuteNonQuery("delete from Loptc where MaSV in ( select MaSV from Loptc )");
137             da.ExcuteNonQuery("delete from Lopdiem10 where MaSV in ( select MaSV from Lopdiem10 )");
138             da.ExcuteNonQuery("delete from DTB where MaSV in ( select MaSV from DTB )");
139             return dt4;
140         }

141         public DataTable ThongKeKhoiLop(string MaHK, string MaKhoiLop, int loai)
142         {
143             SqlConnection con = da.GetConnect();
144             ChuanBi3Table(MaHK);
145             string sql4;
146             switch (loai)
147             {
148                 case 0:
149                     sql4 = "select sv.MaSV,TenSV,sv.MaLop,TrungBinhCuoiKyHe10 " +
150                            " from DTB left join SinhVien sv on DTB.MaSV=sv.MaSV,KhoiLop kl,Lop l " +
151                            " where sv.MaLop=l.MaLop and l.MaKhoiLop=kl.MaKhoiLop " +
152                            " and kl.MaKhoiLop='" + MaKhoiLop + "' and TrungBinhCuoiKyHe10 >=9 ";
153                     break;
154                 case 1:
155                     sql4 = "select sv.MaSV,TenSV,sv.MaLop,TrungBinhCuoiKyHe10 " +
156                            " from DTB left join SinhVien sv on DTB.MaSV=sv.MaSV,KhoiLop kl,Lop l " +
157                            " where sv.MaLop=l.MaLop and l.MaKhoiLop=kl.MaKhoiLop " +
158                            " and kl.MaKhoiLop='" + MaKhoiLop + "' and TrungBinhCuoiKyHe10 >=8 and TrungBinhCuoiKyHe10 < 9";
159                     break;
160                 case 2:
161                     sql4 = "select sv.MaSV,TenSV,sv.MaLop,TrungBinhCuoiKyHe10 " +
162                            " from DTB left join SinhVien sv on DTB.MaSV=sv.MaSV,KhoiLop kl,Lop l " +
163                            " where sv.MaLop=l.MaLop and l.MaKhoiLop=kl.MaKhoiLop " +
164                            " and kl.MaKhoiLop='" + MaKhoiLop + "' and TrungBinhCuoiKyHe10 >=6.5 and TrungBinhCuoiKyHe10 < 8";
165                     break;
166                 case 3:
167                     sql4 = "select sv.MaSV,TenSV,sv.MaLop,TrungBinhCuoiKyHe10 " +
168                            " from DTB left join SinhVien sv on DTB.MaSV=sv.MaSV,KhoiLop kl,Lop l " +
169                            " where sv.MaLop=l.MaLop and l.MaKhoiLop=kl.MaKhoiLop " +
170                            " and kl.MaKhoiLop='" + MaKhoiLop + "' and TrungBinhCuoiKyHe10 >=5 and TrungBinhCuoiKyHe10 < 6.5";
171                     break;
172                 case 4:
173                     sql4 = "select sv.MaSV,TenSV,sv.MaLop,TrungBinhCuoiKyHe10 " +
174                            " from DTB left join SinhVien sv on DTB.MaSV=sv.MaSV,KhoiLop kl,Lop l " +
175                            " where sv.MaLop=l.MaLop and l.MaKhoiLop=kl.MaKhoiLop " +
176                            " and kl.MaKhoiLop='" + MaKhoiLop + "' and TrungBinhCuoiKyHe10 >=3.5 and TrungBinhCuoiKyHe10 < 5";
177                     break;
178                 default:
179                     sql4 = "select sv.MaSV,TenSV,sv.MaLop,TrungBinhCuoiKyHe10 " +
180                            " from DTB left join SinhVien sv on DTB.MaSV=sv.MaSV,KhoiLop kl,Lop l " +
181                            " where sv.MaLop=l.MaLop and l.MaKhoiLop=kl.MaKhoiLop " +
182                            " and kl.MaKhoiLop='" + MaKhoiLop + "' and TrungBinhCuoiKyHe10 < 3.5";
183                     break;
184             }
185             DataTable dt4 = da.GetTable(sql4);
186             da.ExcuteNonQuery("delete from Loptc where MaSV in ( select MaSV from Loptc )");
187             da.ExcuteNonQuery("delete from Lopdiem10 where MaSV in ( select MaSV from Lopdiem10 )");
188             da.ExcuteNonQuery("delete from DTB where MaSV in ( select MaSV from DTB )");
189             return dt4;
190         }

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

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         }

14         static void Main()
15         {
16             Application.EnableVisualStyles();
17             Application.SetCompatibleTextRenderingDefault(false);
18             Application.Run(new Form9());
19         }

27         private void btThoat_Click(object sender, EventArgs e)
28         {
29             if (MessageBox.Show("Bạn có muốn thoát hay không ", "Thông Báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1) == DialogResult.OK)
30             {
31                 this.Close();
32             }
33         }

106         private void getData(int Rows)
107         {
108             List lst = new List();
109             lst = readfile("datadoan.txt");
110             if (Rows >= lst.Count)
111             {
112                 Rows = iRows = lst.Count - sodonghienlen;
113             }
114             else if (Rows <= 0)
115             {
116                 Rows = iRows = 0;
117             }
118             //if + else kiểm tra đã load hết file text chưa nếu hết thì khi nhấn next sẽ k hiện ra gì nữa
119             for (int i = 0; i < sodonghienlen; i++)
120             {
121                 string strTemp = "";
122                 if ((Rows + i) < lst.Count)
123                 {
124                     strTemp = lst[Rows + i].ToString();
125                 }
126                 switch (i)
127                 {
128                     case 0:
129                         lbcauhoi.Text = strTemp;
130                         break;
131                     case 1:
132                         checkBox1.Text= strTemp;
133                         checkBox1.Checked = false;
134                         break;
135                     case 2:
136                         checkBox2.Text = strTemp;
137                         checkBox2.Checked = false;
138                         break;
139                     case 3:
140                         checkBox3.Text = strTemp;
141                         checkBox3.Checked = false;
142                         break;
143                     case 4:
144                         checkBox4.Text = strTemp;
145                         checkBox4.Checked = false;
146                         break;
147                     default:
148                         lbd.Text = strTemp;
149                         break;
150                 }
151             }
152         }

14         static void Main()
15         {
16             Application.EnableVisualStyles();
17             Application.SetCompatibleTextRenderingDefault(false);
18             Application.Run(new frmMain());
19         }

122         public virtual System.TimeSpan CacheTimeOut {
123             get {
124                 return CachedReportConstants.DEFAULT_TIMEOUT;
125             }
126             set {
127                 //
128             }
129         }

70     public void ConnectWithNickname()
71     {
72         RootOf3dButtons.SetActive(false);
73
74         PhotonNetwork.AuthValues = null; // null by default but maybe set in a previous session.
75         PhotonNetwork.ConnectUsingSettings("1.0");
76
77         // PhotonNetwork.playerName gets set in GUIFriendFinding
78         // a UserID is not used in this case (no AuthValues set)
79     }