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(); } } }