public DataTable getDTBChung(DTO_DTB dtb)
{
dt.Clear();
try
{
string sqlSelect = string.Format("SELECT DIEMTBMON.MAHS,HOCSINH.HOTEN,TBHK1=ROUND(AVG(DIEMTBMON.TBHK1),1),TBHK2=ROUND(AVG(DIEMTBMON.TBHK2),1),CANAM=ROUND(((AVG(DIEMTBMON.TBHK1)+AVG(DIEMTBMON.TBHK2))/2),1) FROM DIEMTBMON, HOCSINH WHERE DIEMTBMON.MAHS = HOCSINH.MAHS AND DIEMTBMON.MANH = {0} AND DIEMTBMON.MALOP = {1} GROUP BY DIEMTBMON.MAHS, HOCSINH.HOTEN", dtb.MaNH, dtb.MaLop, _conn);
da = new SqlDataAdapter(sqlSelect, _conn);
da.Fill(dt);
if (dt.Rows.Count == 0)
{
MessageBox.Show("Lớp chưa có điểm!!");
}
}
catch (Exception ex)
{
MessageBox.Show("Không thể lấy cơ sở dữ liệu mã lớp");
}
return(dt);
}
public DataTable getDTBChung(DTO_DTB dtb)
{
return(da.getDTBChung(dtb));
}
