public string GetStudentAchievementByUnit(string id)
{
string result;
StudentAnalysisByUnits analysis = new StudentAnalysisByUnits();
result = analysis.AnalysisScore(id);
return(result);
}
internal void GetAllUnitScores(string sql, StudentAnalysisByUnits analysis)
{
string Unit = "";
int UnitScore = -1;
int index = -1;
using (SqlCommand scom = new SqlCommand(sql, scon))
{
scom.Connection.Open();
using (SqlDataReader reader = scom.ExecuteReader())
{
if (reader == null)
{
scom.Connection.Close();
return;
}
while (reader.Read())
{
Unit = reader["교과목이름"].ToString();
UnitScore = (int)reader["학생점수"];
for (int i = 0; i < analysis.StudentScores.Count; i++)
{
if (analysis.StudentScores[i].UnitName == Unit)
{
index = i;
}
}
if (index == -1)
{
analysis.StudentScores.Add(new StudentAnalysisByUnits.StudentScore(Unit, UnitScore));
}
else
{
analysis.StudentScores[index].StuScore = UnitScore;
}
}
scom.Connection.Close();
}
}
}
