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"));
}
