// Kiểm tra điều kiện lên lớp public static bool KiemTraDieuKienLenLop(string maHS, string maNamHoc) { var lst = MONHOC_BUS.LayTatCaMonHoc(); int heSoHK1 = HOCKY_BUS.layHeSo("HK01"); int heSoHK2 = HOCKY_BUS.layHeSo("HK02"); //foreach (var mh in lst) //{ // double diemHK1 = HOCTAP_DAL.LayDiemTongKetMonHoc(maHS, mh.MAMONHOC.ToString(), "HK01", maNamHoc); // double diemHK2 = HOCTAP_DAL.LayDiemTongKetMonHoc(maHS, mh.MAMONHOC.ToString(), "HK02", maNamHoc); // double diemCaNam = (diemHK1 * heSoHK1 + diemHK2 * heSoHK2) / (heSoHK1 + heSoHK2); // if (diemCaNam < 3.5) // return false; //} double diemTongKetHK1 = HOCTAP_DAL.LayDiemTongKetHocKy(maHS, "HK01", maNamHoc); double diemTongKetHK2 = HOCTAP_DAL.LayDiemTongKetHocKy(maHS, "HK02", maNamHoc); double diemTongKetCaNam = (diemTongKetHK1 * heSoHK1 + diemTongKetHK2 * heSoHK2) / (heSoHK1 + heSoHK2); if (diemTongKetCaNam < 5) { return(false); } return(true); }
// Sửa điểm public static void SuaDiem(string maHS, string maMon, string mahocky, string maNamHoc, float diemMieng, float diem15P, float diem1Tiet, float diemThi) { HOCTAP_DAL.SuaDiem(maHS, maMon, mahocky, maNamHoc, diemMieng, diem15P, diem1Tiet, diemThi); }
// Lấy điểm chi tiết học sinh public static DataTable LayDiemChiTietHocSinh(string maHS, string maHocKy, string maNamHoc) { return(HOCTAP_DAL.LayDiemChiTietHocSinh(maHS, maHocKy, maNamHoc)); }
// Lấy điểm môn học theo lớp public static DataTable LayDiemMonHocTheoLop(string maLop, string maMonHoc, string maHocKy, string maNamHoc) { return(HOCTAP_DAL.LayDiemMonHocTheoLop(maLop, maMonHoc, maHocKy, maNamHoc)); }
// Lấy điểm học sinh theo lớp public static DataTable LayDiemHocSinhTheoLop(string maLop) { return(HOCTAP_DAL.LayDiemHocSinhTheoLop(maLop)); }