private void StudentScore_Form_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = term_Class.GetDataYears();
comboBox_years.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
this.comboBox_years.Items.Add(dt.Rows[i]["years"].ToString().Trim());
}
if (DateTime.Now.Month < 8)
{
comboBox_years.Text = Convert.ToString(DateTime.Now.Year - 1);
}
else
{
comboBox_years.Text = Convert.ToString(DateTime.Now.Year);
}
if (comboBox_years.Items.Count == 1)
{
comboBox_years.SelectedIndex = 0;
}
dt = ClassStudent_Class.GetDataYeargrade();
comboBox_yeargrade.Items.Clear();
comboBox_yeargrade.Items.Add("");
for (int i = 0; i < dt.Rows.Count; i++)
{
this.comboBox_yeargrade.Items.Add(dt.Rows[i]["yeargrade"].ToString().Trim());
}
}
private void comboBox_yeargrade_SelectedIndexChanged(object sender, EventArgs e)
{
comboBox_classname.Items.Clear();
comboBox_classname.Items.Add("");
ClassStudentlist.Clear();
if (comboBox_yeargrade.Text.Trim() != "")
{
DataTable dt = new DataTable();
dt = ClassStudent_Class.GetDataByYeargrade(this.comboBox_yeargrade.Text);
//comboBox_classname.Items.Clear();
//comboBox_classname.Items.Add("");
//ClassStudentlist.Clear.Replace(this.comboBox_yeargrade.Text.Trim() , "")
for (int i = 0; i < dt.Rows.Count; i++)
{
string temp = dt.Rows[i]["classtudentName"].ToString().Trim().Replace(this.comboBox_yeargrade.Text.Trim(), "");
ClassStudentlist.Add(temp, dt.Rows[i]["classtudentNo"].ToString().Trim());
this.comboBox_classname.Items.Add(temp);
}
if (comboBox_classname.Items.Count == 1)
{
comboBox_classname.SelectedIndex = 0;
}
}
}
private void ScoreReport_Form_Load(object sender, EventArgs e)
{
//CurRecordClass = new ScoreRecord_Class(1);
if (CurRecordClass.ID == 0)
{
return;
}
Student_Class d_student = new Student_Class(CurRecordClass.studentNo);
ClassStudent_Class d_class = new ClassStudent_Class(d_student.classtudentNo);
studentinfo_label.Text = " ";
studentinfo_label.Text += "编号：" + CurRecordClass.ID.ToString() + " ";
studentinfo_label.Text += "班级：" + d_class.classtudentName.ToString() + " ";
studentinfo_label.Text += "姓名：" + d_student.studentName.ToString() + " ";
studentinfo_label.Text += "学号：" + d_student.studentNo.ToString() + " ";
#region 班级荣誉
Curhonorslist = new List <TextBoxList>();
Curhonorslist.Add(new TextBoxList(this.honors_Awardname_1, this.honors_Awarddate_1, this.honors_Awarddep_1, "honors", "", CurRecordClass.termNo, CurRecordClass.studentNo));
Curhonorslist.Add(new TextBoxList(this.honors_Awardname_2, this.honors_Awarddate_2, this.honors_Awarddep_2, "honors", "", CurRecordClass.termNo, CurRecordClass.studentNo));
Curhonorslist.Add(new TextBoxList(this.honors_Awardname_3, this.honors_Awarddate_3, this.honors_Awarddep_3, "honors", "", CurRecordClass.termNo, CurRecordClass.studentNo));
Curhonorslist.Add(new TextBoxList(this.honors_Awardname_4, this.honors_Awarddate_4, this.honors_Awarddep_4, "honors", "", CurRecordClass.termNo, CurRecordClass.studentNo));
Curhonorslist.Add(new TextBoxList(this.honors_Awardname_5, this.honors_Awarddate_5, this.honors_Awarddep_5, "honors", "", CurRecordClass.termNo, CurRecordClass.studentNo));
Curhonorslist.Add(new TextBoxList(this.honors_Awardname_6, this.honors_Awarddate_6, this.honors_Awarddep_6, "honors", "", CurRecordClass.termNo, CurRecordClass.studentNo));
Curhonorslist.Add(new TextBoxList(this.honors_Awardname_7, this.honors_Awarddate_7, this.honors_Awarddep_7, "honors", "", CurRecordClass.termNo, CurRecordClass.studentNo));
Curhonorslist.Add(new TextBoxList(this.honors_Awardname_8, this.honors_Awarddate_8, this.honors_Awarddep_8, "honors", "", CurRecordClass.termNo, CurRecordClass.studentNo));
#endregion
#region 课程
DataTable dt = new DataTable();
dt = Course_Class.GetALL();
Dictionary <string, string> d_Course = new Dictionary <string, string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
d_Course.Add(dt.Rows[i]["Coursename"].ToString().Trim(), dt.Rows[i]["Courseno"].ToString().Trim());
}
CurScorelist = new List <TextBoxScorelist>();
string d_coursename = "社会";
TextBoxScore[] pScore = new TextBoxScore[3];
pScore[0] = new TextBoxScore(this.ScoreGrade_scoregrade_sh_0, this.ScoreGrade_attitudegrade_sh_0, 0, d_Course[d_coursename]);
pScore[1] = new TextBoxScore(this.ScoreGrade_scoregrade_sh_1, this.ScoreGrade_attitudegrade_sh_1, 1, d_Course[d_coursename]);
pScore[2] = new TextBoxScore(this.ScoreGrade_scoregrade_sh_2, this.ScoreGrade_attitudegrade_sh_2, 2, d_Course[d_coursename]);
CurScorelist.Add(new TextBoxScorelist(pScore, d_coursename, d_Course[d_coursename], CurRecordClass.studentNo, CurRecordClass.termNo));
pScore = new TextBoxScore[3];
d_coursename = "语文";
pScore[0] = new TextBoxScore(0, d_Course[d_coursename], this.ScoreGrade_scoregrade_yw_0, this.ScoreGrade_attitudegrade_yw_0, this.ScoreGrade_Writegrade_yw_0, this.ScoreGrade_compositiongrade_yw_0, this.ScoreGrade_practicegrade_yw_0, this.ScoreGrade_readinggrade_yw_0);
pScore[1] = new TextBoxScore(1, d_Course[d_coursename], this.ScoreGrade_scoregrade_yw_1, this.ScoreGrade_attitudegrade_yw_1, this.ScoreGrade_Writegrade_yw_1, this.ScoreGrade_compositiongrade_yw_1, this.ScoreGrade_practicegrade_yw_1, this.ScoreGrade_readinggrade_yw_1);
pScore[2] = new TextBoxScore(2, d_Course[d_coursename], this.ScoreGrade_scoregrade_yw_2, this.ScoreGrade_attitudegrade_yw_2, this.ScoreGrade_Writegrade_yw_2, this.ScoreGrade_compositiongrade_yw_2, this.ScoreGrade_practicegrade_yw_2, this.ScoreGrade_readinggrade_yw_2);
CurScorelist.Add(new TextBoxScorelist(pScore, d_coursename, d_Course[d_coursename], CurRecordClass.studentNo, CurRecordClass.termNo));
pScore = new TextBoxScore[3];
d_coursename = "数学";
pScore[0] = new TextBoxScore(0, d_Course[d_coursename], this.ScoreGrade_scoregrade_sx_0, this.ScoreGrade_attitudegrade_sx_0, null, null, this.ScoreGrade_practicegrade_sx_0, null);
pScore[1] = new TextBoxScore(1, d_Course[d_coursename], this.ScoreGrade_scoregrade_sx_1, this.ScoreGrade_attitudegrade_sx_1, null, null, this.ScoreGrade_practicegrade_sx_1, null);
pScore[2] = new TextBoxScore(2, d_Course[d_coursename], this.ScoreGrade_scoregrade_sx_2, this.ScoreGrade_attitudegrade_sx_2, null, null, this.ScoreGrade_practicegrade_sx_2, null);
CurScorelist.Add(new TextBoxScorelist(pScore, d_coursename, d_Course[d_coursename], CurRecordClass.studentNo, CurRecordClass.termNo));
pScore = new TextBoxScore[3];
d_coursename = "英语";
pScore[0] = new TextBoxScore(0, d_Course[d_coursename], this.ScoreGrade_scoregrade_yy_0, this.ScoreGrade_attitudegrade_yy_0, this.ScoreGrade_Writegrade_yy_0, this.ScoreGrade_compositiongrade_yy_0, this.ScoreGrade_practicegrade_yy_0, null);
pScore[1] = new TextBoxScore(1, d_Course[d_coursename], this.ScoreGrade_scoregrade_yy_1, this.ScoreGrade_attitudegrade_yy_1, this.ScoreGrade_Writegrade_yy_1, this.ScoreGrade_compositiongrade_yy_1, this.ScoreGrade_practicegrade_yy_1, null);
pScore[2] = new TextBoxScore(2, d_Course[d_coursename], this.ScoreGrade_scoregrade_yy_2, this.ScoreGrade_attitudegrade_yy_2, this.ScoreGrade_Writegrade_yy_2, this.ScoreGrade_compositiongrade_yy_2, this.ScoreGrade_practicegrade_yy_2, null);
CurScorelist.Add(new TextBoxScorelist(pScore, d_coursename, d_Course[d_coursename], CurRecordClass.studentNo, CurRecordClass.termNo));
pScore = new TextBoxScore[3];
d_coursename = "科学";
pScore[0] = new TextBoxScore(0, d_Course[d_coursename], this.ScoreGrade_scoregrade_kx_0, this.ScoreGrade_attitudegrade_kx_0, this.ScoreGrade_Writegrade_kx_0, null, this.ScoreGrade_practicegrade_kx_0, null);
pScore[1] = new TextBoxScore(1, d_Course[d_coursename], this.ScoreGrade_scoregrade_kx_1, this.ScoreGrade_attitudegrade_kx_1, this.ScoreGrade_Writegrade_kx_1, null, this.ScoreGrade_practicegrade_kx_1, null);
pScore[2] = new TextBoxScore(2, d_Course[d_coursename], this.ScoreGrade_scoregrade_kx_2, this.ScoreGrade_attitudegrade_kx_2, this.ScoreGrade_Writegrade_kx_2, null, this.ScoreGrade_practicegrade_kx_2, null);
CurScorelist.Add(new TextBoxScorelist(pScore, d_coursename, d_Course[d_coursename], CurRecordClass.studentNo, CurRecordClass.termNo));
TextBoxScore pScoreTotal;
d_coursename = "音乐";
pScoreTotal = new TextBoxScore(this.ScoreGrade_scoregrade_music_0, this.ScoreGrade_attitudegrade_music_0, 0, d_Course[d_coursename]);
CurScorelist.Add(new TextBoxScorelist(pScoreTotal, d_coursename, d_Course[d_coursename], CurRecordClass.studentNo, CurRecordClass.termNo));
d_coursename = "体育";
pScoreTotal = new TextBoxScore(this.ScoreGrade_scoregrade_ty_0, this.ScoreGrade_attitudegrade_ty_0, 0, d_Course[d_coursename]);
CurScorelist.Add(new TextBoxScorelist(pScoreTotal, d_coursename, d_Course[d_coursename], CurRecordClass.studentNo, CurRecordClass.termNo));
//pScoreTotal = new TextBoxScore();
d_coursename = "美术";
pScoreTotal = new TextBoxScore(this.ScoreGrade_scoregrade_ms_0, this.ScoreGrade_attitudegrade_ms_0, 0, d_Course[d_coursename]);
CurScorelist.Add(new TextBoxScorelist(pScoreTotal, d_coursename, d_Course[d_coursename], CurRecordClass.studentNo, CurRecordClass.termNo));
//pScoreTotal = new TextBoxScore[1];
d_coursename = "信息技术";
pScoreTotal = new TextBoxScore(this.ScoreGrade_scoregrade_it_0, null, 0, d_Course[d_coursename]);
CurScorelist.Add(new TextBoxScorelist(pScoreTotal, d_coursename, d_Course[d_coursename], CurRecordClass.studentNo, CurRecordClass.termNo));
//pScoreTotal = new TextBoxScore[1];
d_coursename = "社区服务与社会实践";
pScoreTotal = new TextBoxScore(this.ScoreGrade_scoregrade_sq_0, null, 0, d_Course[d_coursename]);
CurScorelist.Add(new TextBoxScorelist(pScoreTotal, d_coursename, d_Course[d_coursename], CurRecordClass.studentNo, CurRecordClass.termNo));
//pScoreTotal = new TextBoxScore[1];
d_coursename = "研究性学习";
pScoreTotal = new TextBoxScore(this.ScoreGrade_scoregrade_yj_0, null, 0, d_Course[d_coursename]);
CurScorelist.Add(new TextBoxScorelist(pScoreTotal, d_coursename, d_Course[d_coursename], CurRecordClass.studentNo, CurRecordClass.termNo));
//pScoreTotal = new TextBoxScore[1];
d_coursename = "劳动与技术";
pScoreTotal = new TextBoxScore(this.ScoreGrade_scoregrade_ld_0, null, 0, d_Course[d_coursename]);
CurScorelist.Add(new TextBoxScorelist(pScoreTotal, d_coursename, d_Course[d_coursename], CurRecordClass.studentNo, CurRecordClass.termNo));
#endregion
#region 教育教学活动记录
CurEvaluationlist = new List <TextBoxList>();
CurEvaluationlist.Add(new TextBoxList("社会调查", this.Evaluation_Quantity_shehui, this.Evaluation_results_shehui, "Evaluation", "课外活动", CurRecordClass.termNo, CurRecordClass.studentNo));
CurEvaluationlist.Add(new TextBoxList("阅读书籍", this.Evaluation_Quantity_yuedu, this.Evaluation_results_yuedu, "Evaluation", "课外活动", CurRecordClass.termNo, CurRecordClass.studentNo));
CurEvaluationlist.Add(new TextBoxList("社团活动", this.Evaluation_Quantity_shetuan, this.Evaluation_results_shetuan, "Evaluation", "课外活动", CurRecordClass.termNo, CurRecordClass.studentNo));
CurEvaluationlist.Add(new TextBoxList("社区活动", this.Evaluation_Quantity_shequ, this.Evaluation_results_shequ, "Evaluation", "课外活动", CurRecordClass.termNo, CurRecordClass.studentNo));
CurEvaluationlist.Add(new TextBoxList(this.Evaluation_item_1, this.Evaluation_Quantity_1, this.Evaluation_results_1, "Evaluation", "课外活动", CurRecordClass.termNo, CurRecordClass.studentNo));
CurEvaluationlist.Add(new TextBoxList(this.Evaluation_item_2, this.Evaluation_Quantity_2, this.Evaluation_results_2, "Evaluation", "课外活动", CurRecordClass.termNo, CurRecordClass.studentNo));
CurEvaluationlist.Add(new TextBoxList(this.Evaluation_item_3, this.Evaluation_Quantity_3, this.Evaluation_results_3, "Evaluation", "课外活动", CurRecordClass.termNo, CurRecordClass.studentNo));
CurEvaluationlist.Add(new TextBoxList(this.Evaluation_item_4, this.Evaluation_Quantity_4, this.Evaluation_results_4, "Evaluation", "课外活动", CurRecordClass.termNo, CurRecordClass.studentNo));
CurEvaluationlist.Add(new TextBoxList(this.Evaluation_item_5, this.Evaluation_Quantity_5, this.Evaluation_results_5, "Evaluation", "课外活动", CurRecordClass.termNo, CurRecordClass.studentNo));
CurEvaluationlist.Add(new TextBoxList(this.Evaluation_item_6, this.Evaluation_createdate_6, this.Evaluation_results_6, "Evaluation", "研究课题", CurRecordClass.termNo, CurRecordClass.studentNo));
CurEvaluationlist.Add(new TextBoxList(this.Evaluation_item_7, this.Evaluation_createdate_7, this.Evaluation_results_7, "Evaluation", "研究课题", CurRecordClass.termNo, CurRecordClass.studentNo));
CurEvaluationlist.Add(new TextBoxList(this.Evaluation_item_8, this.Evaluation_createdate_8, this.Evaluation_results_8, "Evaluation", "研究课题", CurRecordClass.termNo, CurRecordClass.studentNo));
CurEvaluationlist.Add(new TextBoxList(this.Evaluation_item_9, this.Evaluation_createdate_9, this.Evaluation_results_9, "Evaluation", "研究课题", CurRecordClass.termNo, CurRecordClass.studentNo));
#endregion
FillInputByClass();
}