public List <DTO_MMT> SVKN_MMT()
{
string sql = "select * from DS_SinhVien"
+ " where MMT>4 and KTMT>4"
+ " and HDH>4";
List <DTO_MMT> dssv = new List <DTO_MMT>();
try
{
kn.Mo();
SqlDataReader rd = kn.ExecuteReader(sql);
while (rd.Read())
{
DTO_MMT sv = new DTO_MMT();
sv.MSSV1 = rd["MSSV"].ToString();
sv.HDH1 = double.Parse(rd["HDH"].ToString());
sv.KTMT1 = double.Parse(rd["KTMT"].ToString());
sv.LT_MMT1 = double.Parse(rd["LT_MMT"].ToString());
dssv.Add(sv);
}
kn.Dong();
return(dssv);
}
catch
{
return(dssv);
}
}
public List <DTO_MMT> hienThiMMT(DTO_SinhVien[] ds)
{
List <DTO_MMT> kq = new List <DTO_MMT>();
for (int i = 0; i < ds.Length; i++)
{
DTO_MMT cn = new DTO_MMT();
cn.MSSV1 = ds[i].MSSV1;
cn.HoTen1 = ds[i].HoTen1;
cn.KTMT1 = ds[i].KTMT1;
cn.LT_MMT1 = ds[i].MMT1;
cn.HDH1 = ds[i].HDH1;
kq.Add(cn);
}
return(kq);
}
