private void UpdateChart()
{
this.subjects = new SortedSet <string>();
sbjcts = SubjectsDAL.GetGradeSubjects(StudentDAL.GetStudentGradeID(this.StudentID));
foreach (Subject s in sbjcts)
{
this.subjects.Add(s.Title);
}
//gain marks list on each subject
List <string> seriesList = new List <string>();
List <List <MarkInfo> > marksList = new List <List <MarkInfo> >();
DateTime studyYearStart; //= new DateTime(yearStart, 9, 1); //1st Septemper
if (DateTime.Now.Month <= 7) //it's previous study year
{
studyYearStart = new DateTime(DateTime.Now.Year - 1, 9, 1); //1st Septemper
}
else
{
studyYearStart = new DateTime(DateTime.Now.Year, 9, 1);
}
this.Text = string.Format("My overall progress - School Journal" +
" - Results on the {0}/{1} study year", studyYearStart.Year, studyYearStart.Year + 1);
foreach (Subject s in this.sbjcts)
{
if (seriesList.Contains(s.Title))
{
continue;
}
seriesList.Add(s.Title);
//select student marks
marksList.Add(StudentDAL.GetStudentSubjectMarks(this.StudentID, s.SubjectID, studyYearStart));
}
this.chartProgress.Series.Clear();
for (int i = 0; i < seriesList.Count; i++)
{
// Add series.
Series series = this.chartProgress.Series.Add(seriesList[i]);
series.XValueType = ChartValueType.Date;
series.YValueType = ChartValueType.Double;
if (marksList[i].Count > 0)
{
this.chartProgress.BackImage = string.Empty;
}
series.Points.Clear();
foreach (MarkInfo info in marksList[i])
{
series.Points.AddXY(info.Date, (double)info.MarkValue);
}
}
}
private void UpdateSubjectsComboBox()
{
this.subjects = new SortedSet <string>();
sbjcts = SubjectsDAL.GetGradeSubjects(StudentDAL.GetStudentGradeID(this.StudentID));
foreach (Subject s in sbjcts)
{
this.subjects.Add(s.Title);
}
this.comboSubject.Items.Clear();
foreach (string sTitle in this.subjects)
{
this.comboSubject.Items.Add(sTitle);
}
if (comboSubject.Items.Count > 0)
{
comboSubject.SelectedItem = comboSubject.Items[0];
}
else
{
comboSubject.Enabled = false;
}
}
/// <summary>
/// 查询所有科目的业务访问方法
/// </summary>
/// <param name="model">科目的实体对象</param>
/// <returns>DataTable的数据表</returns>
public DataTable GetAllSubjects()
{
SubjectsDAL subject = new SubjectsDAL();
DataTable dt = subject.GetAllSubjects();
return(dt);
}
/// <summary>
/// 删除科目业务
/// </summary>
/// <param name="model">科目的实体对象</param>
public void DeleSubjects(SubjectsModel model)
{
SubjectsDAL subject = new SubjectsDAL();
subject.DeleSubject(model);
}
/// <summary>
/// 添加科目业务
/// </summary>
/// <param name="model">科目的实体对象</param>
public void AddSubjects(SubjectsModel model)
{
SubjectsDAL subject = new SubjectsDAL();
subject.AddSubjects(model);
}
