public static int sumDau_Rot()
{
int i = 0;
string Query = " select ho_ten, THI_SINH.so_bao_danh,sum(diem_thi) sum_diem_thi , ma_nganh from KET_QUA_CHAM_THI, THI_SINH , PHIEU_DKDT where THI_SINH.so_bao_danh = KET_QUA_CHAM_THI.so_bao_danh and PHIEU_DKDT.ho_va_ten = THI_SINH.ho_ten group by ho_ten,THI_SINH.so_bao_danh , ma_nganh";
string nameTable = "KET_QUA_CHAM_THI, THI_SINH , PHIEU_DKDT";
DataTable dt = sqlDataTable.getDataTable(Query, nameTable);
foreach (DataRow row in dt.Rows)
{
if ((double)row["sum_diem_thi"] >= DiemChuan.getDiemChuan((string)row["ma_nganh"]))
{
i++;
}
}
return(i);
}
public static bool Dau_Rot(string so_bao_danh)
{
string Query = " select ho_ten, THI_SINH.so_bao_danh,sum(diem_thi) sum_diem_thi , ma_nganh from KET_QUA_CHAM_THI, THI_SINH , PHIEU_DKDT where THI_SINH.so_bao_danh = KET_QUA_CHAM_THI.so_bao_danh and PHIEU_DKDT.ho_va_ten = THI_SINH.ho_ten group by ho_ten,THI_SINH.so_bao_danh , ma_nganh";
string nameTable = "DIEM_CHUAN";
DataTable dt = sqlDataTable.getDataTable(Query, nameTable);
foreach (DataRow row in dt.Rows)
{
if ((string)row["so_bao_danh"] == so_bao_danh)
{
if ((double)row["sum_diem_thi"] >= DiemChuan.getDiemChuan((string)row["ma_nganh"]))
{
return(true);
}
else
{
return(false);
}
}
}
return(false);
}