public DataTable laydulieu(string dieukien)
{
return(cn.gettable("select * from tblRenLuyen " + dieukien));
}
public DataTable laydulieu(string dieukien)
{
return(cn.gettable("select * from tblNguoiDung " + dieukien));
}
public DataTable laydulieu(string dieukien)
{
return(cn.gettable("Select * from tblSinhVien " + dieukien));
}
public DataTable laydulieu(string dieukien)
{
return(cn.gettable("select tblMonHoc.*,tblDiem.DiemCC,tblDiem.DiemKT1,tblDiem.DiemKT2,tblDiem.DiemGK,tblDiem.DiemThi,case when (SoTC<=2) then convert(decimal(3,2),(DiemCC+DiemKT1+DiemKT2)/3*0.3+DiemThi*0.7) else convert(decimal(3,2),(DiemCC+DiemKT1+DiemKT2+DiemGK*2)/5*0.3+DiemThi*0.7)end as [DiemTB] from tblDiem inner join tblMonHoc on tblDiem.MaMH=tblMonHoc.MaMH inner join tblNamHoc on tblDiem.MaNamHoc=tblNamHoc.MaNamHoc " + dieukien));
}
