public String XepLoaiHocLucMonHoc(float[] arrayDiemTBTungMon, float tongDiem) { String xepLoai = ""; float diemTBMonNhoNhat = TimMin(arrayDiemTBTungMon); HocLucData m_HLData = new HocLucData(); DataTable m_DT_DS_HocLuc = m_HLData.LayDsHocLuc(); String[] maHocLuc = new String[m_DT_DS_HocLuc.Rows.Count]; float[] diemCanDuoi = new float[m_DT_DS_HocLuc.Rows.Count]; float[] diemKhongChe = new float[m_DT_DS_HocLuc.Rows.Count]; int count = 0; foreach (DataRow row in m_DT_DS_HocLuc.Rows) { maHocLuc[count] = row["MaHocLuc"].ToString(); diemCanDuoi[count] = float.Parse(row["DiemCanDuoi"].ToString()); diemKhongChe[count] = float.Parse(row["diemKhongChe"].ToString()); count++; } for (int i = 0; i < count - 1; i++) { if (tongDiem >= diemCanDuoi[i]) { xepLoai = maHocLuc[i]; if (diemTBMonNhoNhat <= diemKhongChe[i]) xepLoai = maHocLuc[i + 1]; break; } } if (xepLoai == "") xepLoai = maHocLuc[count - 1].ToString(); return xepLoai; }
public String XepLoaiHLHocKy(String maHocSinh, String maLop, String maHocKy, String maNamHoc) { Console.WriteLine(@"Ma hoc sinh: " + maHocSinh + " co ma hoc luc: ...Enter"); //Lấy ra mã ban theo mã lớp - BEGIN string strBan = "CHUA_PHAN_BAN"; DataTable m_DT_BAN = m_LopData.TimTheoMa(maLop); foreach (DataRow row in m_DT_BAN.Rows) { strBan = row["MaBan"].ToString().Trim(); break; } //Lấy ra mã ban theo mã lớp - END float diemTBChungCacMonHK = (float)Math.Round(m_DiemCtrl.tinhDiemTrungBinhChungCacMonHocKy(maHocSinh, maLop, maHocKy, maNamHoc), 2); DataTable m_DiemTBHKMonHoc = m_KQHKMonHocData.LayDsKQHocKyMonHocTheoBan(maHocSinh, maLop, maHocKy, maNamHoc); HocLucData m_HLData = new HocLucData(); DataTable m_DT_DS_HocLuc = m_HLData.LayDsHocLuc(); String maHocLucHienTai = ""; foreach (DataRow row in m_DT_DS_HocLuc.Rows) { String maHocLuc = row["MaHocLuc"].ToString(); // maHocLucHienTai = maHocLuc; float diemCanTren = float.Parse(row["DiemCanTren"].ToString()); float diemCanDuoi = float.Parse(row["DiemCanDuoi"].ToString()); float diemKhongChe = float.Parse(row["diemKhongChe"].ToString()); if (diemTBChungCacMonHK >= diemCanDuoi && diemTBChungCacMonHK <= diemCanTren) //điểm nằm trong khoảng giới hạn { if (!isThoaManDKKhac(strBan, diemCanDuoi, diemKhongChe, m_DiemTBHKMonHoc)) { //in ra để dò lỗi Console.WriteLine(@"Ma hoc sinh: " + maHocSinh + " ko co ma hoc luc: " + maHocLuc); continue; } else { maHocLucHienTai = maHocLuc; } } } //in ra để dò lỗi Console.WriteLine(@"Ma hoc sinh: " + maHocSinh + " co ma hoc luc: " + maHocLucHienTai+" Exit"); return maHocLucHienTai; }