public void LoadDSDiem() { cls_connectDB cls_con = new cls_connectDB(); try { cls_con.connect_DB(); string st_sql = "Select tbl_diem.Masv, Tensv, Tenmh, DiemC, DiemB, Diemthilan1, Diemthilan2, DiemTB, Xeploai, tbl_diem.Hocki, Namhoc From (tbl_diem inner join tbl_monhoc on (Monhoc=Mamh) inner join tbl_sinhvien on (tbl_diem.Masv = tbl_sinhvien.Masv )) order by Masv;"; SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con); SqlDataReader sqlre = sqlcm.ExecuteReader(); int sott = 0; string kq = ""; while (sqlre.Read()) { sott++; kq = kq + "<tr><td>" + sott + "</td><td>" + sqlre["Masv"].ToString() + "</td><td>" + sqlre["Tensv"].ToString() + "</td><td>" + sqlre["Tenmh"].ToString() + "</td><td>" + sqlre["DiemC"].ToString() + "</td><td>" + sqlre["DiemB"].ToString() + "</td><td>" + sqlre["Diemthilan1"].ToString() + "</td><td>" + sqlre["Diemthilan2"].ToString() + "</td><td>" + sqlre["DiemTB"].ToString() + "</td><td>" + sqlre["Xeploai"].ToString() + "</td><td>" + sqlre["Hocki"].ToString() + "</td><td>" + sqlre["Namhoc"].ToString() + "</td><td><a title='Sửa điểm' href='QuanlyDiem.aspx?type=edit&id=" + sqlre["Masv"].ToString() + "&code=" + sqlre["Tenmh"].ToString() + "'><i class='fa fa-edit' style='color:#6495ED'></i></a>" + "</td><td>" + "<a title='Xóa điểm' href='QuanlyDiem.aspx?type=delete&id=" + sqlre["Masv"].ToString() + "&code=" + sqlre["Tenmh"].ToString() + "'><i class='fa fa-remove' style='color:#6495ED'></i></a></td></tr>"; } sqlre.Close(); ltr_dsdiem.Text = kq; lbl_timkiem.Text = "Có " + sott + " kết quả"; } catch (Exception ex) { Response.Write("Lỗi: " + ex); } finally { cls_con.close_DB(); } }
public void LoadScoreTable() { cls_connectDB cls_con = new cls_connectDB(); try { string sql = @"SELECT Mamh, Tenmh, DiemC, DiemB, Diemthilan1, Diemthilan2, DiemTB, Xeploai, tbl_diem.Hocki, Namhoc FROM (dbo.tbl_diem inner join dbo.tbl_monhoc ON Monhoc = Mamh) WHERE Masv = @masv;"; cls_con.connect_DB(); SqlCommand sqlcm = new SqlCommand(sql, cls_con.sql_con); sqlcm.Parameters.Add(new SqlParameter("Masv", Convert.ToInt32(Request.QueryString["search"]))); SqlDataReader sqlre = sqlcm.ExecuteReader(); string kq = ""; int sott = 0; while (sqlre.Read()) { sott++; kq = kq + "<tr><td>" + sott + "</td><td>" + sqlre["Mamh"].ToString() + "</td><td>" + sqlre["Tenmh"].ToString() + "</td><td>" + sqlre["DiemC"].ToString() + "</td><td>" + sqlre["DiemB"].ToString() + "</td><td>" + sqlre["Diemthilan1"].ToString() + "</td><td>" + sqlre["Diemthilan2"].ToString() + "</td><td>" + sqlre["DiemTB"].ToString() + "</td><td>" + sqlre["Xeploai"].ToString() + "</td><td>" + sqlre["Hocki"].ToString() + "</td><td>" + sqlre["Namhoc"].ToString() + "</td></tr>"; } sqlre.Close(); ltr_ct_diemsv.Text = kq; } catch (Exception ex) { Response.Write("Lỗi :" + ex); } finally { cls_con.close_DB(); } }
private void LoadTencnDropDownList() { cls_connectDB cls_con = new cls_connectDB(); cls_con.connect_DB(); SqlCommand sqlcm = new SqlCommand("Select Macn, Tencn from tbl_chuyennganh order by Tencn", cls_con.sql_con); SqlDataReader drd = sqlcm.ExecuteReader(); DropDownList2.DataSource = drd; DropDownList2.DataBind(); }
private void LoadKhoahocDropDownList() { cls_connectDB cls_con = new cls_connectDB(); cls_con.connect_DB(); SqlCommand sqlcm = new SqlCommand("Select Makh, Tenkh from tbl_khoahoc order by Makh", cls_con.sql_con); SqlDataReader drd = sqlcm.ExecuteReader(); DropDownList1.DataSource = drd; DropDownList1.DataBind(); }
private void LoadMonHocDropdown() { cls_connectDB cls_con = new cls_connectDB(); cls_con.connect_DB(); SqlCommand sqlcm = new SqlCommand("Select Tenmh from tbl_monhoc order by Tenmh", cls_con.sql_con); SqlDataReader drd = sqlcm.ExecuteReader(); DropDownList2.DataSource = drd; DropDownList2.DataBind(); }
private void LoadSinhVienDropdown() { cls_connectDB cls_con = new cls_connectDB(); cls_con.connect_DB(); SqlCommand sqlcm = new SqlCommand("Select Masv, Tensv from tbl_sinhvien order by Tensv", cls_con.sql_con); SqlDataReader drd = sqlcm.ExecuteReader(); DropDownList1.DataSource = drd; DropDownList1.DataBind(); }
protected void timkiem_Click(object sender, EventArgs e) { cls_connectDB cls_con = new cls_connectDB(); try { cls_con.connect_DB(); string st_key = txt_timkiem.Text.Trim().ToLower(); string st_sql = "Select Masv, Tensv, Ngaysinh, Gioitinh, Email, Diachi, Khoahoc, Tencn from (tbl_sinhvien inner join tbl_chuyennganh on (Chuyennganh = Macn)) Where Masv like '%' + @id + '%' OR lower(Tensv) like N'%' + @id + '%' order by Tensv;"; SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con); SqlParameter sqlpa = new SqlParameter(); sqlpa.ParameterName = "@id"; sqlpa.Value = st_key; sqlcm.Parameters.Add(sqlpa); SqlDataReader sqlre = sqlcm.ExecuteReader(); int sott = 0; string kq = ""; string gioitinh = ""; while (sqlre.Read()) { if (sqlre["gioitinh"].ToString() == "True") { gioitinh = "Nữ"; } else { gioitinh = "Nam"; } sott++; kq = kq + "<tr><td>" + sott + "</td><td>" + sqlre["Masv"].ToString() + "</td><td>" + sqlre["Tensv"].ToString() + "</td><td>" + Convert.ToDateTime(sqlre["Ngaysinh"]).ToString("dd/MM/yyyy") + "</td><td>" + gioitinh + "</td><td>" + sqlre["Email"].ToString() + "</td><td>" + sqlre["Diachi"].ToString() + "</td><td>" + sqlre["Khoahoc"].ToString() + "</td><td>" + sqlre["Tencn"].ToString() + "</td><td><a title='Xem chi tiết' href='ChiTietXemDiem.aspx?search=" + sqlre["Masv"].ToString() + "'><i class='fa fa-id-card-o'style='color:#6495ED'></i></a></td></tr>"; } sqlre.Close(); ltr_quanlysv.Text = kq; lbl_timkiem.Text = "Có " + sott + " kết quả"; } catch (Exception ex) { Response.Write("Lỗi: " + ex); } finally { cls_con.close_DB(); } }
public void LoadInfoForm() { cls_connectDB cls_con = new cls_connectDB(); try { cls_con.connect_DB(); string st_sql = "Select Masv, Tensv, Ngaysinh, Gioitinh, Email, Diachi, tencn, Khoahoc from tbl_sinhvien inner join tbl_chuyennganh on (Chuyennganh = macn) where Masv = @ma;"; SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con); sqlcm.Parameters.Add(new SqlParameter("Ma", Convert.ToInt32(Request.QueryString["search"]))); SqlDataReader sqlre = sqlcm.ExecuteReader(); sqlre.Read(); lbl_masv.Text = sqlre["Masv"].ToString(); lbl_tensv.Text = sqlre["Tensv"].ToString(); if (sqlre["Ngaysinh"] != DBNull.Value) { lbl_ngaysinh.Text = Convert.ToDateTime(sqlre["Ngaysinh"]).ToString("dd/MM/yyyy"); } if (sqlre["Gioitinh"].ToString() == "True") { lbl_sex.Text = "Nữ"; } else if (sqlre["Gioitinh"].ToString() == "False") { lbl_sex.Text = "Nam"; } lbl_email.Text = sqlre["Email"].ToString(); lbl_diachi.Text = sqlre["Diachi"].ToString(); lbl_chuyennganh.Text = sqlre["tencn"].ToString(); lbl_khoahoc.Text = sqlre["Khoahoc"].ToString(); sqlre.Close(); } catch (Exception ex) { Response.Write("Lỗi :" + ex); } finally { cls_con.close_DB(); } }
public void LoadDSSinhVien() { cls_connectDB cls_con = new cls_connectDB(); try { cls_con.connect_DB(); string st_sql = "SELECT Masv, Tensv, Ngaysinh, Gioitinh, Email, Diachi, Khoahoc, Tencn from tbl_sinhvien inner join tbl_chuyennganh on (Chuyennganh = Macn);"; SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con); SqlDataReader sqlre = sqlcm.ExecuteReader(); int sott = 0; string st_kq = ""; string gioitinh = ""; while (sqlre.Read()) { sott++; if (sqlre["Gioitinh"].ToString() == "True") { gioitinh = "Nữ"; } else { gioitinh = "Nam"; } st_kq = st_kq + "<tr><td>" + sott + "</td><td>" + sqlre["Masv"].ToString() + "</td><td>" + sqlre["Tensv"].ToString() + "</td><td>" + Convert.ToDateTime(sqlre["Ngaysinh"]).ToString("dd/MM/yyyy") + "</td><td>" + gioitinh + "</td><td>" + sqlre["Email"].ToString() + "</td><td>" + sqlre["Diachi"].ToString() + "</td><td>" + sqlre["Khoahoc"].ToString() + "</td><td>" + sqlre["Tencn"].ToString() + "</td><td>" + "<a title='Sửa điểm' href='QuanLySinhVien.aspx?type=edit&id=" + sqlre["Masv"].ToString() + "'><i class='fa fa-edit' style='color:#6495ED'></i></a>" + "</td><td>" + "<a title='Xóa điểm' href='QuanlySinhVien.aspx?type=delete&id=" + sqlre["Masv"].ToString() + "'><i class='fa fa-remove' style='color:#6495ED'></i></a></td></tr>"; } sqlre.Close(); ltr_quanlysv.Text = st_kq; lbl_timkiem.Text = "Có " + sott + " kết quả"; } catch (Exception ex) { Response.Write("Lỗi: " + ex); } finally { cls_con.close_DB(); } }
protected void timkiem_Click(object sender, EventArgs e) { cls_connectDB cls_con = new cls_connectDB(); try { cls_con.connect_DB(); string st_key = txt_timkiem.Text.Trim().ToLower(); string st_sql = "SELECT * FROM tbl_monhoc Where Mamh like '%' + @id + '%' OR lower(Tenmh) like N'%' + @id + '%' order by Mamh;"; SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con); SqlParameter sqlpa = new SqlParameter(); sqlpa.ParameterName = "@id"; sqlpa.Value = st_key; sqlcm.Parameters.Add(sqlpa); SqlDataReader re = sqlcm.ExecuteReader(); int sott = 0; string st_kq = ""; while (re.Read()) { sott++; st_kq = st_kq + "<tr><td>" + sott + "</td><td>" + re[0].ToString() + "</td><td>" + re[1].ToString() + "</td><td>" + re[2].ToString() + "</td><td>" + re[3].ToString() + "</td><td>" + re[4].ToString() + "</td>"; st_kq = st_kq + "<td><a href='QuanLyMonHoc.aspx?type=update&id=" + re[0].ToString() + "'><i class='fa fa-edit' style='color:#6495ED'></i></a></td>"; st_kq = st_kq + "<td><a href='QuanLyMonHoc.aspx?type=delete&id=" + re[0].ToString() + "'><i class='fa fa-remove' style='color:#6495ED'></i></a></td></tr>"; } re.Close(); ltr_monhoc.Text = st_kq; lbl_timkiem.Text = "Có " + sott + " kết quả"; } catch (Exception ex) { Response.Write("Lỗi: " + ex); } finally { cls_con.close_DB(); } }
protected void timkiem_Click(object sender, EventArgs e) { cls_connectDB cls_con = new cls_connectDB(); try { cls_con.connect_DB(); string st_key = txt_timkiem.Text.Trim().ToLower(); string st_sql = "SELECT Macn, Tencn, tbl_khoa.Tenkhoa from tbl_chuyennganh JOIN tbl_khoa on tbl_chuyennganh.Khoa = tbl_khoa.Makhoa Where Macn like '%' + @id + '%' OR lower(Tencn) like N'%' + @id + '%' order by Macn;"; SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con); SqlParameter sqlpa = new SqlParameter(); sqlpa.ParameterName = "@id"; sqlpa.Value = st_key; sqlcm.Parameters.Add(sqlpa); SqlDataReader re = sqlcm.ExecuteReader(); int sott = 0; string st_kq = ""; while (re.Read()) { sott++; st_kq = st_kq + "<tr><td>" + sott + "</td><td>" + re[0].ToString() + "</td><td>" + re[1].ToString() + "</td><td>" + re[2].ToString() + "</td>"; st_kq = st_kq + "<td><a href='QuanLyChuyenNganh.aspx?type=update&id=" + re[0].ToString() + "'>Sửa</a></td>"; st_kq = st_kq + "<td><a href='QuanLyChuyenNganh.aspx?type=delete&id=" + re[0].ToString() + "'>Xóa</a></td></tr>"; } re.Close(); ltr_chuyennganh.Text = st_kq; lbl_timkiem.Text = "Có " + sott + " kết quả"; } catch (Exception ex) { Response.Write("Lỗi: " + ex); } finally { cls_con.close_DB(); } }
protected void timkiem_Click(object sender, EventArgs e) { cls_connectDB cls_con = new cls_connectDB(); try { cls_con.connect_DB(); string st_key = txt_timkiem.Text.Trim().ToLower(); string st_sql = "SELECT ac.id,ac.Tendn, ac.Matkhau,ac.Hoten,Case ac.Gioitinh when 0 then N'Nam' else N'Nữ' end,ac.Email,q.Tenquyen FROM tbl_acount ac JOIN tbl_qyen q ON ac.Quyen = q.id WHERE tbl_acount.id=@ma Where id like '%' + @id + '%' OR lower(Hoten) like N'%' + @id + '%' order by id;"; SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con); SqlParameter sqlpa = new SqlParameter(); sqlpa.ParameterName = "@id"; sqlpa.Value = st_key; sqlcm.Parameters.Add(sqlpa); SqlDataReader re = sqlcm.ExecuteReader(); int sott = 0; string st_kq = ""; while (re.Read()) { sott++; st_kq = st_kq + "<tr><td>" + sott + "</td><td>" + re[0].ToString() + "</td><td>" + re[1].ToString() + "</td><td>" + re[2].ToString() + "</td><td>" + re[3].ToString() + "</td><td>" + re[4].ToString() + "</td><td>" + re[5].ToString() + "</td><td>" + re[6].ToString() + "</td>"; st_kq = st_kq + "<td><a href='QuanLyNguoiDung.aspx?type=update&id=" + re[0].ToString() + "'><i class='fa fa-edit' style='color:#6495ED'></i></a></td>"; st_kq = st_kq + "<td><a href='QuanLyNguoiDung.aspx?type=delete&id=" + re[0].ToString() + "'><i class='fa fa-remove' style='color:#6495ED'></i></a></td></tr>"; } re.Close(); ltr_acc.Text = st_kq; lbl_timkiem.Text = "Có " + sott + " kết quả"; } catch (Exception ex) { Response.Write("Lỗi: " + ex); } finally { cls_con.close_DB(); } }
protected void lbt_search_Click(object sender, EventArgs e) { cls_connectDB cls_con = new cls_connectDB(); try { cls_con.connect_DB(); string st_key = tbx_key.Text.Trim().ToLower(); string st_sql = "Select Masv, Tenmh, DiemC, DiemB, Diemthilan1, Diemthilan2, DiemTB, Xeploai, tbl_diem.Hocki, Namhoc From (tbl_diem inner join tbl_monhoc on (Monhoc=Mamh)) Where Masv like '%' + @id + '%' OR lower(Tenmh) like N'%' + @id + '%' order by Masv;"; SqlCommand sqlcm = new SqlCommand(st_sql, cls_con.sql_con); SqlParameter sqlpa = new SqlParameter(); sqlpa.ParameterName = "@id"; sqlpa.Value = st_key; sqlcm.Parameters.Add(sqlpa); SqlDataReader sqlre = sqlcm.ExecuteReader(); int sott = 0; string kq = ""; while (sqlre.Read()) { sott++; kq = kq + "<tr><td>" + sott + "</td><td>" + sqlre["Masv"].ToString() + "</td><td>" + sqlre["Tenmh"].ToString() + "</td><td>" + sqlre["DiemC"].ToString() + "</td><td>" + sqlre["DiemB"].ToString() + "</td><td>" + sqlre["Diemthilan1"].ToString() + "</td><td>" + sqlre["Diemthilan2"].ToString() + "</td><td>" + sqlre["DiemTB"].ToString() + "</td><td>" + sqlre["Xeploai"].ToString() + "</td><td>" + sqlre["Hocki"].ToString() + "</td><td>" + sqlre["Namhoc"].ToString() + "</td><td><a title='Sửa điểm' href='QuanlyDiem.aspx?type=edit&id=" + sqlre["Masv"].ToString() + "&code=" + sqlre["Tenmh"].ToString() + "'><i class='fa fa-edit' style='color:#6495ED'></i></a>" + "</td><td>" + " <a title='Xóa điểm' href='QuanlyDiem.aspx?type=delete&id=" + sqlre["Masv"].ToString() + "&code=" + sqlre["Tenmh"].ToString() + "'><i class='fa fa-remove' style='color:#6495ED'></i></a></td></tr>"; } sqlre.Close(); ltr_dsdiem.Text = kq; lbl_timkiem.Text = "Có " + sott + " kết quả"; } catch (Exception ex) { Response.Write("Lỗi: " + ex); } finally { cls_con.close_DB(); } }