public List <DTO_CNPM> SVKN_CNPM()
{
string sql = "select * from DS_SinhVien"
+ " where NMLT>4 "
+ " and LTHDT>4 and CTDLGT>4";
List <DTO_CNPM> dssv = new List <DTO_CNPM>();
try
{
kn.Mo();
SqlDataReader rd = kn.ExecuteReader(sql);
while (rd.Read())
{
DTO_CNPM sv = new DTO_CNPM();
sv.MSSV1 = rd["MSSV"].ToString();
sv.LT_CTDLGT1 = double.Parse(rd["LT_CTDLGT"].ToString());
sv.LT_LTHDT1 = double.Parse(rd["LT_LTHDT"].ToString());
sv.LT_NMLT1 = double.Parse(rd["LT_NMLT"].ToString());
dssv.Add(sv);
}
kn.Dong();
return(dssv);
}
catch
{
return(dssv);
}
}
public List <DTO_CNPM> hienThiCNPM(DTO_SinhVien[] ds)
{
List <DTO_CNPM> kq = new List <DTO_CNPM>();
for (int i = 0; i < ds.Length; i++)
{
DTO_CNPM cn = new DTO_CNPM();
cn.MSSV1 = ds[i].MSSV1;
cn.HoTen1 = ds[i].HoTen1;
cn.LT_NMLT1 = ds[i].NMLT1;
cn.LT_CTDLGT1 = ds[i].CTDLGT1;
cn.LT_LTHDT1 = ds[i].LTHDT1;
kq.Add(cn);
}
return(kq);
}
//public void ranDom_BD(List<DTO_CNPM> cnpm,List<DTO_HTTT> httt,List<DTO_MMT> mmt) {
// Random r = new Random();
// int n= r.Next(0,busSV.SVKN_CNPM().Count());
// cnpm.Add(busSV.SVKN_CNPM()[n]);
// n = r.Next(0, busSV.SVKN_HTTT().Count());
// while (cnpm[0].MSSV1 == busSV.SVKN_HTTT()[n].MSSV1) {
// n = r.Next(0, busSV.SVKN_HTTT().Count());
// }
// httt.Add(busSV.SVKN_HTTT()[n]);
// n = r.Next(0, busSV.SVKN_MMT().Count());
// while (cnpm[0].MSSV1 == busSV.SVKN_MMT()[n].MSSV1 || httt[0].MSSV1 == busSV.SVKN_MMT()[n].MSSV1) {
// n = r.Next(0, busSV.SVKN_MMT().Count());
// }
// mmt.Add(busSV.SVKN_MMT()[n]);
//}
public double khoangCach_CNPM(DTO_CNPM sv1, DTO_CNPM sv2)
{
return(Math.Sqrt(Math.Pow(sv1.LT_CTDLGT1 - sv2.LT_CTDLGT1, 2) + Math.Pow(sv1.LT_LTHDT1 - sv2.LT_LTHDT1, 2) + Math.Pow(sv1.LT_NMLT1 - sv2.LT_NMLT1, 2)));
}
