// Lấy điểm học sinh theo lớp
public static DataTable LayDiemHocSinhTheoLop(string maLop)
{
DataTable dt = new DataTable();
dt.Columns.Add("STT", typeof(int));
dt.Columns.Add("MAHS", typeof(string));
dt.Columns.Add("HOTEN", typeof(string));
dt.Columns.Add("DIEMTBHK1", typeof(float));
dt.Columns.Add("DIEMTBHK2", typeof(float));
dt.Columns.Add("DIEMCANAM", typeof(float));
using (SQL_QLHSDataContext db = new SQL_QLHSDataContext())
{
var lst = db.sp_LayDiemHocSinhTheoLop(maLop);
foreach (var i in lst)
{
DataRow r = dt.NewRow();
if (i.MAHS != null)
{
r["MAHS"] = i.MAHS;
}
if (i.HOTEN != null)
{
r["HOTEN"] = i.HOTEN;
}
if (i.DIEMTBHK1 != null)
{
r["DIEMTBHK1"] = i.DIEMTBHK1.Value;
}
if (i.DIEMTBHK2 != null)
{
r["DIEMTBHK2"] = i.DIEMTBHK2.Value;
}
if (i.DIEMCANAM != null)
{
r["DIEMCANAM"] = i.DIEMCANAM.Value;
}
dt.Rows.Add(r);
}
}
if (dt.Rows.Count == 0)
{
return(null);
}
return(dt);
}
// Lấy điểm học sinh theo lớp
public static DataTable LayDiemHocSinhTheoLop(string tenLop, string maNamHoc)
{
DataTable dt = new DataTable();
dt.Columns.Add("STT", typeof(int));
dt.Columns.Add("MAHS", typeof(string));
dt.Columns.Add("HOTEN", typeof(string));
dt.Columns.Add("DIEMTBHKI", typeof(float));
dt.Columns.Add("DIEMTBHKII", typeof(float));
SQL_QLHSDataContext db = new SQL_QLHSDataContext();
var lst = db.sp_LayDiemHocSinhTheoLop(tenLop, maNamHoc);
foreach (var i in lst)
{
DataRow r = dt.NewRow();
if (i.MAHS != null)
{
r["MAHS"] = i.MAHS;
}
if (i.HOTEN != null)
{
r["HOTEN"] = i.HOTEN;
}
if (i.DIEMTBHK1 != null)
{
r["DIEMTBHK1"] = i.DIEMTBHK1;
}
if (i.DIEMTBHK2 != null)
{
r["DIEMTBHK2"] = i.DIEMTBHK1;
}
dt.Rows.Add(r);
}
if (dt.Rows.Count == 0)
{
return(null);
}
return(dt);
}