public string GetWeakConceptAnalysis(string id)
{
string result;
StudentAnalysisByConcept analysis = new StudentAnalysisByConcept();
result = analysis.AnalysisWeakConcept(id);
return(result);
}
public void GetWeakConcept(int snum, StudentAnalysisByConcept analysis)
{
analysis.StrongConcepts.Clear();
string sql = "select TOP 3 단위지식이름, count(*) Count from cp, Concept, StuData where cp.단위개념번호 = Concept.단위지식번호 and 문제번호 in(select 틀린문제번호 from ps where 학생번호 = " + snum + ") group by 단위개념번호,단위지식이름 HAVING count(*) > 1 ORDER BY count(*) DESC";
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())
{
analysis.WeakConcepts.Add(new StudentAnalysisByConcept.ConceptFrequency(reader["단위지식이름"].ToString(), (int)reader["Count"]));
}
scom.Connection.Close();
}
}
}
