public List <ThongTinChungHS_DiemTB> GetDanhSachHocSinh_ThongTinChung_TimKiemTheoDiemTB(float canDuoi, float canTren)
{
OpenConnection();
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "select hs.MaHocSinh,hs.HoVaTen,qth.MaLop,qth.MaHocKy,qth.DiemTBHk "
+ " from HOCSINH hs,QUATRINHHOCTAP qth, LOP l "
+ "where hs.MaHocSinh = qth.MaHocSinh and qth.MaLop = l.MaLop and DiemTBHk>=@canDuoi and DiemTBHk <=@canTren";
com.Parameters.Add("@canDuoi", SqlDbType.Float).Value = canDuoi;
com.Parameters.Add("@canTren", SqlDbType.Float).Value = canTren;
com.Connection = conn;
SqlDataReader reader = com.ExecuteReader();
List <ThongTinChungHS_DiemTB> listdshocsinh = new List <ThongTinChungHS_DiemTB>();
while (reader.Read())
{
string maHocSinh = reader.GetInt32(0).ToString();
String tenHocSinh = reader.GetString(1);
string maLop = reader.GetString(2);
string maHocKy = reader.GetString(3);
string diemTrungBinh = null;
try
{
diemTrungBinh = reader.GetDouble(4).ToString();
}
catch { }
ThongTinChungHS_DiemTB dshocsinh = new ThongTinChungHS_DiemTB(
maHocSinh, tenHocSinh, maLop, maHocKy, diemTrungBinh);
listdshocsinh.Add(dshocsinh);
}
reader.Close();
CloseConnection();
return(listdshocsinh);
}
public List <ThongTinChungHS_DiemTB> GetDanhSachHocSinh_ThongTinChung_TimKiemTheoTen(string tenHS)
{
OpenConnection();
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "select hs.MaHocSinh,hs.HoVaTen,qth.MaLop,qth.MaHocKy,qth.DiemTBHk "
+ "from HOCSINH hs,QUATRINHHOCTAP qth "
+ "where hs.MaHocSinh = qth.MaHocSinh and hs.hovaten like N'%" + tenHS + "%'";
// com.Parameters.Add("@ten", SqlDbType.VarChar).Value = tenHocSinh;
com.Connection = conn;
SqlDataReader reader = com.ExecuteReader();
List <ThongTinChungHS_DiemTB> listdshocsinh = new List <ThongTinChungHS_DiemTB>();
while (reader.Read())
{
string maHocSinh = reader.GetInt32(0) + "";
String tenHocSinh = reader.GetString(1);
string maLop = reader.GetString(2);
string maHocKy = reader.GetString(3);
string diemTrungBinh = null;
try
{
diemTrungBinh = reader.GetDouble(4).ToString();
}
catch { }
ThongTinChungHS_DiemTB dshocsinh = new ThongTinChungHS_DiemTB(
maHocSinh, tenHocSinh, maLop, maHocKy, diemTrungBinh);
listdshocsinh.Add(dshocsinh);
}
reader.Close();
CloseConnection();
return(listdshocsinh);
}
public List <ThongTinChungHS_DiemTB> GetDanhSachHocSinh_ThongTinChung_Diem(string maNamHoc)
{
OpenConnection();
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "select hs.MaHocSinh,hs.HoVaTen,l.TenLop,qth.MaHocKy,qth.DiemTBHk "
+ "from HOCSINH hs,QUATRINHHOCTAP qth ,LOP l "
+ "where hs.MaHocSinh = qth.MaHocSinh and l.MaLop=qth.MaLop and maNamHoc=@maNamHoc and hs.TrangThai='HD'";
com.Parameters.Add("@maNamHoc", SqlDbType.VarChar).Value = maNamHoc;
com.Connection = conn;
SqlDataReader reader = com.ExecuteReader();
List <ThongTinChungHS_DiemTB> listdshocsinh = new List <ThongTinChungHS_DiemTB>();
while (reader.Read())
{
string maHocSinh = reader.GetInt32(0) + "";
String tenHocSinh = reader.GetString(1);
string maLop = reader.GetString(2);
string maHocKy = reader.GetString(3);
string diemTrungBinh = null;
try
{
diemTrungBinh = reader.GetDouble(4).ToString();
}
catch { }
ThongTinChungHS_DiemTB dshocsinh = new ThongTinChungHS_DiemTB(
maHocSinh, tenHocSinh, maLop, maHocKy, diemTrungBinh);
listdshocsinh.Add(dshocsinh);
}
reader.Close();
CloseConnection();
return(listdshocsinh);
}
