public List <Diemm> SearchSinhvienByMaLop(string malop)
{
List <Diemm> list = new List <Diemm>();
string qr = string.Format("SELECT * FROM dbo.Sinhvien WHERE malop = {0}", malop);
DataTable data = DataProvider.Instance.ExecuteQuery(qr);
foreach (DataRow item in data.Rows)
{
Diemm account = new Diemm(item);
list.Add(account);
}
return(list);
}
public List <Diemm> SearchSinhvienByDiem(string operation, float diem)
{
List <Diemm> list = new List <Diemm>();
string qr = string.Format("SELECT * FROM dbo.Diem WHERE diem {0} {1}", operation, diem);
DataTable data = DataProvider.Instance.ExecuteQuery(qr);
foreach (DataRow item in data.Rows)
{
Diemm account = new Diemm(item);
list.Add(account);
}
return(list);
}
public List <Diemm> GetDiemList()
{
List <Diemm> list = new List <Diemm>();
string qr = "SELECT masv, ho, ten, malop, phai, ngaysinh, noisinh, diachi, ghichu, nghihoc FROM dbo.Sinhvien";
DataTable data = DataProvider.Instance.ExecuteQuery(qr);
foreach (DataRow item in data.Rows)
{
Diemm monhoc = new Diemm(item);
list.Add(monhoc);
}
return(list);
}
public List <Diemm> GetDiemList()
{
List <Diemm> list = new List <Diemm>();
string qr = @"SELECT d.masv, sv.ho, sv.ten, sv.phai, sv.malop, l.makh, d.mamh, mh.tenmh, lan, diem
FROM dbo.Diem AS d
INNER JOIN dbo.Sinhvien AS sv ON d.masv = sv.masv
INNER JOIN dbo.Lop AS l ON l.malop = sv.malop
INNER JOIN dbo.Khoa AS kh ON kh.makh = l.makh
INNER JOIN dbo.Monhoc AS mh ON mh.mamh = d.mamh";
DataTable data = DataProvider.Instance.ExecuteQuery(qr);
foreach (DataRow item in data.Rows)
{
Diemm monhoc = new Diemm(item);
list.Add(monhoc);
}
return(list);
}
