private void HienThiThongTin()
{
LuuTruDanhSach service = new LuuTruDanhSach();
Diem objDiem = service.HienThiDiemCuaHocSinhTheoMaHS(MAHS);
if (objDiem != null)
{
string HoVTen = objDiem.Ho + objDiem.Ten;
txtHoTen.Text = HoVTen;
txtMaHS.Text = objDiem.MaHS;
txtTOAN15.Text = objDiem.TOAN15;
txtTOAN60.Text = objDiem.TOAN60;
txtTOANHK.Text = objDiem.TOANHK;
txtTOANTB.Text = objDiem.TOANTB;
txtVAN15.Text = objDiem.VAN15;
txtVAN60.Text = objDiem.VAN60;
txtVANHK.Text = objDiem.VANHK;
txtVANTB.Text = objDiem.VANTB;
txtTA15.Text = objDiem.ANH15;
txtTA60.Text = objDiem.ANH60;
txtTAHK.Text = objDiem.ANHHK;
txtTATB.Text = objDiem.ANHTB;
txtDIA15.Text = objDiem.DIA15;
txtDIA60.Text = objDiem.DIA60;
txtDIAHK.Text = objDiem.DIAHK;
txtDIATB.Text = objDiem.DIATB;
txtSU15.Text = objDiem.SU15;
txtSU60.Text = objDiem.SU60;
txtSUHK.Text = objDiem.SUHK;
txtSUTB.Text = objDiem.SUTB;
}
}
public Diem HienThiDiemCuaHocSinhTheoMaHS(string MaHS)
{
Diem objDiem = null;
string strSQL = "SELECT * FROM HocSinh ,Diem D WHERE D.MaHS='" + MaHS + "'";
DataTable dt = DataProvider.LayDanhSach(strSQL);
if (dt.Rows.Count > 0)
{
objDiem = new Diem();
objDiem.Ho = "" + dt.Rows[0]["Ho"];
objDiem.Ten = "" + dt.Rows[0]["Ten"];
objDiem.MaHS = "" + dt.Rows[0]["MaHS"];
objDiem.TOAN15 = "" + dt.Rows[0]["Toan15"];
objDiem.TOAN60 = "" + dt.Rows[0]["Toan60"];
objDiem.TOANHK = "" + dt.Rows[0]["ToanHK"];
objDiem.TOANTB = "" + dt.Rows[0]["ToanTB"];
objDiem.ANH15 = "" + dt.Rows[0]["ANH15"];
objDiem.ANH60 = "" + dt.Rows[0]["ANH60"];
objDiem.ANHHK = "" + dt.Rows[0]["ANHHK"];
objDiem.ANHTB = "" + dt.Rows[0]["ANHTB"];
objDiem.VAN15 = "" + dt.Rows[0]["Van15"];
objDiem.VAN60 = "" + dt.Rows[0]["Van60"];
objDiem.VANHK = "" + dt.Rows[0]["VanHK"];
objDiem.VANTB = "" + dt.Rows[0]["VanTB"];
objDiem.DIA15 = "" + dt.Rows[0]["DIA15"];
objDiem.DIA60 = "" + dt.Rows[0]["DIA60"];
objDiem.DIAHK = "" + dt.Rows[0]["DIAHK"];
objDiem.DIATB = "" + dt.Rows[0]["DIATB"];
objDiem.SU15 = "" + dt.Rows[0]["SU15"];
objDiem.SU60 = "" + dt.Rows[0]["SU60"];
objDiem.SUHK = "" + dt.Rows[0]["SUHK"];
objDiem.SUTB = "" + dt.Rows[0]["SUTB"];
// objDiem = new Diem();
//objDiem.Ho = "" + dt.Rows[1]["Ho"];
//objDiem.Ten = "" + dt.Rows[1]["Ten"];
//objDiem.MaHS = "" + dt.Rows[1]["MaHS"];
//objDiem.TOAN15 = "" + dt.Rows[1]["Toan15"];
//objDiem.TOAN60 = "" + dt.Rows[1]["Toan60"];
//objDiem.TOANHK = "" + dt.Rows[1]["ToanHK"];
//objDiem.TOANTB = "" + dt.Rows[1]["ToanTB"];
//objDiem.ANH15 = "" + dt.Rows[1]["TA15"];
//objDiem.ANH60 = "" + dt.Rows[1]["TA60"];
//objDiem.ANHHK = "" + dt.Rows[1]["TAHK"];
//objDiem.ANHTB = "" + dt.Rows[1]["TATB"];
//objDiem.VAN15 = "" + dt.Rows[1]["Van15"];
//objDiem.VAN60 = "" + dt.Rows[1]["Van60"];
//objDiem.VANHK = "" + dt.Rows[1]["VanHK"];
//objDiem.VANTB = "" + dt.Rows[1]["VanTB"];
//objDiem.DIA15 = "" + dt.Rows[1]["DIA15"];
//objDiem.DIA60 = "" + dt.Rows[1]["DIA60"];
//objDiem.DIAHK = "" + dt.Rows[1]["DIAHK"];
//objDiem.DIATB = "" + dt.Rows[1]["DIATB"];
//objDiem.SU15 = "" + dt.Rows[1]["SU15"];
//objDiem.SU60 = "" + dt.Rows[1]["SU60"];
//objDiem.SUHK = "" + dt.Rows[1]["SUHK"];
//objDiem.SUTB = "" + dt.Rows[1]["SUTB"];
}
return(objDiem);
}
