public List <DTO_HTTT> SVKN_HTTT()
{
string sql = "select * from DS_SinhVien"
+ " where HQT_CSDL>4 and LT_CSDL>4 and TH_CSDL>4";
List <DTO_HTTT> dssv = new List <DTO_HTTT>();
try
{
kn.Mo();
SqlDataReader rd = kn.ExecuteReader(sql);
while (rd.Read())
{
DTO_HTTT sv = new DTO_HTTT();
sv.MSSV1 = rd["MSSV"].ToString();
sv.HQT_CSDL1 = double.Parse(rd["HQT_CSDL"].ToString());
sv.LT_CSDL1 = double.Parse(rd["LT_CSDL"].ToString());
sv.TH_CSDL1 = double.Parse(rd["TH_CSDL"].ToString());
dssv.Add(sv);
}
kn.Dong();
return(dssv);
}
catch
{
return(dssv);
}
}
public List <DTO_HTTT> hienThiHTTT(DTO_SinhVien[] ds)
{
List <DTO_HTTT> kq = new List <DTO_HTTT>();
for (int i = 0; i < ds.Length; i++)
{
DTO_HTTT cn = new DTO_HTTT();
cn.MSSV1 = ds[i].MSSV1;
cn.HoTen1 = ds[i].HoTen1;
cn.HQT_CSDL1 = ds[i].HQT_CSDL1;
cn.LT_CSDL1 = ds[i].CSDL1;
cn.TH_CSDL1 = ds[i].TH_CSDL1;
kq.Add(cn);
}
return(kq);
}
