public static DataTable LoadMonHoc() { if (DataProvider.ConnectDatabase()) { return(DataProvider.ExecSQLQueryDataTable("SELECT * FROM MONHOC")); } return(null); }
public static DataTable LoadGiangVien() { if (DataProvider.ConnectDatabase()) { string str = "select MAGV, HO, TEN, MAKH from GIANGVIEN"; return(DataProvider.ExecSQLQueryDataTable(str)); } return(null); }
//============================= Lấy danh sách mã lớp tạo report học phí================================ public static DataTable LoadMaLop() { if (DataProvider.ConnectDatabase()) { string str = "select distinct MALOP from SINHVIEN"; return(DataProvider.ExecSQLQueryDataTable(str)); } return(null); }
public static DataTable LoadLop() { if (DataProvider.ConnectDatabase()) { string str = "select MALOP,TENLOP,MAKH from LOP"; return(DataProvider.ExecSQLQueryDataTable(str)); } return(null); }
public static DataTable TimKiemLop(string malop) { if (DataProvider.ConnectDatabase()) { string str = "select MALOP,TENLOP,MAKH from LOP where MALOP = '" + malop + "'"; return(DataProvider.ExecSQLQueryDataTable(str)); } return(null); }
public static DataTable LoadKhoa() { if (DataProvider.ConnectDatabase()) { string str = "select MAKH, TENKH from KHOA"; return(DataProvider.ExecSQLQueryDataTable(str)); } return(null); }
public static DataTable KiemTraDiemSinhVien(string masv) { if (DataProvider.ConnectDatabase()) { string str = "select MASV from DIEM where MASV = '" + masv + "'"; return(DataProvider.ExecSQLQueryDataTable(str)); } return(null); }
public static DataTable KiemTraHocPhiSinhVien(string masv) { if (DataProvider.ConnectDatabase()) { string str = "select MASV from LINK2.CSDLPT_QLDSV.DBO.HOCPHI where MASV = '" + masv + "'"; return(DataProvider.ExecSQLQueryDataTable(str)); } return(null); }
public static DataTable LoadSinhVien(string MaLop) { if (DataProvider.ConnectDatabase()) { string str = "select MASV,HO,TEN,MALOP,PHAI,NGAYSINH,NOISINH,DIACHI,GHICHU,NGHIHOC from SINHVIEN where MALOP = '" + MaLop + "'"; return(DataProvider.ExecSQLQueryDataTable(str)); } return(null); }
public static DataTable LoadPhanManh() { Data.m_objConnection.Close(); string chuoiketnoi = "Data Source=" + Constant.SERVER_NAME + ";Initial Catalog=" + Constant.DATABASE_NAME + ";Integrated Security=True"; Data.m_objConnection.ConnectionString = chuoiketnoi; Data.m_objConnection.Open(); return(DataProvider.ExecSQLQueryDataTable("SELECT * FROM V_DS_PHANMANH")); }