function IsScoreConflict($paperName, $LScore, $HScore)
{
include_once 'makePaperBll.php';
include_once '../DAL/scoreDal.php';
$paperID = GetPaperID($paperName);
$result = FindScoreByPaperID($paperID);
foreach ($result as $single) {
$oldLscore = $single[2];
$oldHscore = $single[4];
if ($oldHscore <= $LScore || $oldLscore >= $HScore) {
return 1;
}
}
return 0;
}
function GetScoreInfo($paperID, $sumSocre)
{
include_once '../DAL/scoreDal.php';
$scoreResult = FindScoreByPaperID($paperID);
foreach ($scoreResult as $single) {
$lowScore = $single[2];
$highScore = $single[3];
$scoreInfo = $single[4];
if ($lowScore <= $sumSocre && $highScore >= $sumSocre) {
return $scoreInfo;
}
}
return NULL;
}
