public static DataTable Find(String key, bool bysbd)
{
string cmd = "";
if (!key.Equals(""))
{
if (bysbd)
{
cmd = "Select * from ThiSinh where MsThiSinh='" + key + "'";
}
else
{
cmd = "Select* from ThiSinh where Upper(Ho) LIKE Upper('%" + key + "%') OR(Upper(Ten) LIKE Upper('%" + key + "%'))ORDER BY Ten";
}
}
else
{
cmd = "Select * from ThiSinh";
}
return(ConnectDB.execAdapter(cmd));
}
public static DataTable DanhSachChuDe()
{
String cmd = "SELECT * FROM[ThiB2].[dbo].[ChuDeCauHoi]";
return(ConnectDB.execAdapter(cmd));
}
public static DataTable DanhSachCauHoiByChuDe(String key)
{
string cmd = "SELECT * FROM[ThiB2].[dbo].[View_DanhSachCauHoi] Where [MsChuDe]='" + key + "' ";
return(ConnectDB.execAdapter(cmd));
}
public static DataTable ThongTinThiSinh(String sbd)
{
string cmd = "select Ho,Ten,NgaySinh,Case (GioiTinh) When 1 then 'Nam' When 0 then 'Nữ' end as GioiTinh,DiaChi,QuocTich,CMND,HinhAnh from ThiSinh where MsThiSinh='" + sbd + "'";
return(ConnectDB.execAdapter(cmd));
}
public static DataTable table_BaiThi(String MsThiSinh, String MsBaiThi)
{
string cmd = "select * from KiemtraMBT('" + MsThiSinh + "','" + MsBaiThi + "') ";
return(ConnectDB.execAdapter(cmd));
}
public static DataTable table_DotThi(String dotThi)
{
string cmd = "select * from DotThi where MaBT='" + dotThi + "'";
return(ConnectDB.execAdapter(cmd));
}
public static DataTable table_ThiSinh(String thisinh)
{
string cmd = "select * from ThiSinh where MsThiSinh='" + thisinh + "'";
return(ConnectDB.execAdapter(cmd));
}
