private static DataTable PrintDataSource(int p_id)
{
ScoreRecord_Class CurRecordClass = new ScoreRecord_Class(p_id);
List<string> d_courselist = new List<string>();
d_courselist.Add("yw");
d_courselist.Add("sx");
d_courselist.Add("yy");
d_courselist.Add("kx");
d_courselist.Add("sh");
d_courselist.Add("it");
d_courselist.Add("music");
d_courselist.Add("ms");
d_courselist.Add("ty");
d_courselist.Add("ld");
d_courselist.Add("yj");
d_courselist.Add("sq");
DataTable dt = new DataTable();
dt.Columns.Add("termname", typeof(string));
dt.Columns.Add("classname", typeof(string));
dt.Columns.Add("studentname", typeof(string));
dt.Columns.Add("studentno", typeof(string));
for (int i = 0; i < 12; i++)
{
string coursenametemp = d_courselist[i];
dt.Columns.Add("ScoreGrade_scoregrade_" + coursenametemp + "_0", typeof(string));
dt.Columns.Add("ScoreGrade_scoregrade_" + coursenametemp + "_2", typeof(string));
dt.Columns.Add("ScoreGrade_scoregrade_" + coursenametemp + "_1", typeof(string));
dt.Columns.Add("ScoreGrade_readinggrade_" + coursenametemp + "_0", typeof(string));
dt.Columns.Add("ScoreGrade_readinggrade_" + coursenametemp + "_2", typeof(string));
dt.Columns.Add("ScoreGrade_readinggrade_" + coursenametemp + "_1", typeof(string));
dt.Columns.Add("ScoreGrade_compositiongrade_" + coursenametemp + "_0", typeof(string));
dt.Columns.Add("ScoreGrade_compositiongrade_" + coursenametemp + "_2", typeof(string));
dt.Columns.Add("ScoreGrade_compositiongrade_" + coursenametemp + "_1", typeof(string));
dt.Columns.Add("ScoreGrade_practicegrade_" + coursenametemp + "_0", typeof(string));
dt.Columns.Add("ScoreGrade_practicegrade_" + coursenametemp + "_2", typeof(string));
dt.Columns.Add("ScoreGrade_practicegrade_" + coursenametemp + "_1", typeof(string));
dt.Columns.Add("ScoreGrade_Writegrade_" + coursenametemp + "_0", typeof(string));
dt.Columns.Add("ScoreGrade_Writegrade_" + coursenametemp + "_2", typeof(string));
dt.Columns.Add("ScoreGrade_Writegrade_" + coursenametemp + "_1", typeof(string));
dt.Columns.Add("ScoreGrade_attitudegrade_" + coursenametemp + "_0", typeof(string));
dt.Columns.Add("ScoreGrade_attitudegrade_" + coursenametemp + "_2", typeof(string));
dt.Columns.Add("ScoreGrade_attitudegrade_" + coursenametemp + "_1", typeof(string));
}
for (int i = 0; i < 9; i++)
{
dt.Columns.Add("honors_Awarddep_" + Convert.ToString(i + 1), typeof(string));
dt.Columns.Add("honors_Awardname_" + Convert.ToString(i + 1), typeof(string));
dt.Columns.Add("honors_Awarddate_" + Convert.ToString(i + 1), typeof(string));
dt.Columns.Add("Evaluation_results_" + Convert.ToString(i + 1), typeof(string));
dt.Columns.Add("Evaluation_item_" + Convert.ToString(i + 1), typeof(string));
dt.Columns.Add("Evaluation_createdate_" + Convert.ToString(i + 1), typeof(string));
dt.Columns.Add("Evaluation_Quantity_" + Convert.ToString(i + 1), typeof(string));
}
dt.Columns.Add("Evaluation_results_shequ", typeof(string));
dt.Columns.Add("Evaluation_results_shetuan", typeof(string));
dt.Columns.Add("Evaluation_results_shehui", typeof(string));
dt.Columns.Add("Evaluation_results_yuedu", typeof(string));
dt.Columns.Add("Evaluation_Quantity_shehui", typeof(string));
dt.Columns.Add("Evaluation_Quantity_shequ", typeof(string));
dt.Columns.Add("Evaluation_Quantity_shetuan", typeof(string));
dt.Columns.Add("Evaluation_Quantity_yuedu", typeof(string));
dt.Columns.Add("ScoreRecord_schoolcoursename", typeof(string));
dt.Columns.Add("ScoreRecord_schoolcoursenametwo", typeof(string));
dt.Columns.Add("ScoreRecord_attendance", typeof(string));
dt.Columns.Add("ScoreRecord_leave", typeof(string));
dt.Columns.Add("ScoreRecord_absenteeism", typeof(string));
dt.Columns.Add("ScoreRecord_specialtyelectivegrade", typeof(string));
dt.Columns.Add("ScoreRecord_schoolcoursegradetwo", typeof(string));
dt.Columns.Add("ScoreRecord_schoolcoursegrade", typeof(string));
dt.Columns.Add("ScoreRecord_specialtyelective", typeof(string));
dt.Columns.Add("ScoreRecord_classjob", typeof(string));
dt.Columns.Add("ScoreRecord_parenthope", typeof(string));
dt.Columns.Add("ScoreRecord_myevaluate", typeof(string));
dt.Columns.Add("ScoreRecord_productlevel", typeof(string));
DataRow dw = dt.NewRow();
dw["termname"] = "二〇 学年度第 学期";
dw["classname"] = "二〇 学年度第 学期";
dw["studentname"] = "二〇 学年度第 学期";
dw["studentno"] = "二〇 学年度第 学期";
for (int i = 0; i < 12; i++)
{
string coursenametemp = d_courselist[i];
dw["ScoreGrade_scoregrade_" + coursenametemp + "_0"] = "";
dw["ScoreGrade_scoregrade_" + coursenametemp + "_2"] = "";
dw["ScoreGrade_scoregrade_" + coursenametemp + "_1"] = "";
dw["ScoreGrade_readinggrade_" + coursenametemp + "_0"] = "";
dw["ScoreGrade_readinggrade_" + coursenametemp + "_2"] = "";
dw["ScoreGrade_readinggrade_" + coursenametemp + "_1"] = "";
dw["ScoreGrade_compositiongrade_" + coursenametemp + "_0"] = "";
dw["ScoreGrade_compositiongrade_" + coursenametemp + "_2"] = "";
dw["ScoreGrade_compositiongrade_" + coursenametemp + "_1"] = "";
dw["ScoreGrade_practicegrade_" + coursenametemp + "_0"] = "";
dw["ScoreGrade_practicegrade_" + coursenametemp + "_2"] = "";
dw["ScoreGrade_practicegrade_" + coursenametemp + "_1"] = "";
dw["ScoreGrade_Writegrade_" + coursenametemp + "_0"] = "";
dw["ScoreGrade_Writegrade_" + coursenametemp + "_2"] = "";
dw["ScoreGrade_Writegrade_" + coursenametemp + "_1"] = "";
dw["ScoreGrade_attitudegrade_" + coursenametemp + "_0"] = "";
dw["ScoreGrade_attitudegrade_" + coursenametemp + "_2"] = "";
dw["ScoreGrade_attitudegrade_" + coursenametemp + "_1"] = "";
}
for (int i = 0; i < 9; i++)
{
dw["honors_Awarddep_" + Convert.ToString(i + 1)] = "";
dw["honors_Awardname_" + Convert.ToString(i + 1)] = "";
dw["honors_Awarddate_" + Convert.ToString(i + 1)] = "";
dw["Evaluation_results_" + Convert.ToString(i + 1)] = "";
dw["Evaluation_item_" + Convert.ToString(i + 1)] = "";
dw["Evaluation_createdate_" + Convert.ToString(i + 1)] = "";
dw["Evaluation_Quantity_" + Convert.ToString(i + 1)] = "";
}
dw["Evaluation_results_shequ"] = "";
dw["Evaluation_results_shetuan"] = "";
dw["Evaluation_results_shehui"] = "";
dw["Evaluation_results_yuedu"] = "";
dw["Evaluation_Quantity_shehui"] = "";
dw["Evaluation_Quantity_shequ"] = "";
dw["Evaluation_Quantity_shetuan"] = "";
dw["Evaluation_Quantity_yuedu"] = "";
dw["ScoreRecord_specialtyelectivegrade"] = CurRecordClass.SpecialtyElectiveGrade;
dw["ScoreRecord_schoolcoursename"] = CurRecordClass.SchoolCourseName;
dw["ScoreRecord_schoolcoursenametwo"] = CurRecordClass.SchoolCourseNameTwo;
dw["ScoreRecord_schoolcoursegradetwo"] = CurRecordClass.SchoolCourseGradeTwo;
dw["ScoreRecord_schoolcoursegrade"] = CurRecordClass.SchoolCourseGrade;
dw["ScoreRecord_attendance"] = CurRecordClass.Attendance;
dw["ScoreRecord_leave"] = CurRecordClass.leave;
dw["ScoreRecord_absenteeism"] = CurRecordClass.Absenteeism;
dw["ScoreRecord_parenthope"] = CurRecordClass.Parenthope;
dw["ScoreRecord_myevaluate"] = CurRecordClass.MyEvaluate ;
dw["ScoreRecord_specialtyelective"] = CurRecordClass.SpecialtyElective;
dw["ScoreRecord_classjob"] = CurRecordClass.classjob;
dw["ScoreRecord_productlevel"] = CurRecordClass.Productlevel ;
#region 课程
DataTable d_table = new DataTable();
try
{
d_table = ScoreGrade_Class.GetDataByStudentAndTerm(CurRecordClass.studentNo, CurRecordClass.termNo);
for (int i = 0; i < d_table.Rows.Count; i++)
{
try
{
string p_courseNo = d_table.Rows[i]["courseNo"].ToString().Trim().Replace("2600", "");
p_courseNo = d_courselist[Convert.ToInt32(p_courseNo)-1];
string timesterm = d_table.Rows[i]["teamtimes"].ToString().Trim();
dw["ScoreGrade_scoregrade_" + p_courseNo + "_" + timesterm] = d_table.Rows[i]["scoregrade"].ToString().Trim();
dw["ScoreGrade_readinggrade_" + p_courseNo + "_" + timesterm] = d_table.Rows[i]["readinggrade"].ToString().Trim();
dw["ScoreGrade_compositiongrade_" + p_courseNo + "_" + timesterm] = d_table.Rows[i]["compositiongrade"].ToString().Trim();
dw["ScoreGrade_practicegrade_" + p_courseNo + "_" + timesterm] = d_table.Rows[i]["practicegrade"].ToString().Trim();
dw["ScoreGrade_Writegrade_" + p_courseNo + "_" + timesterm] = d_table.Rows[i]["Writegrade"].ToString().Trim();
dw["ScoreGrade_attitudegrade_" + p_courseNo + "_" + timesterm] = d_table.Rows[i]["attitudegrade"].ToString().Trim();
}
catch { }
// CurScorelist[i].FillInputByClass(p_id, p_name, p_date, p_results, "");
}
}
catch (Exception ex)
{ }
#endregion
#region 班级荣誉
d_table = Honors_Class.GetDataByStudentAndTerm(CurRecordClass.studentNo, CurRecordClass.termNo);
for (int i = 0; i < d_table.Rows.Count; i++)
{
try
{
string p_name = d_table.Rows[i]["Awardname"].ToString().Trim();
string p_date = d_table.Rows[i]["Awarddate"].ToString().Trim();
string p_results = d_table.Rows[i]["Awarddep"].ToString().Trim();
try
{
dw["honors_Awarddep_" + Convert.ToString(i + 1)] = p_results;
dw["honors_Awarddate_" + Convert.ToString(i + 1)] = p_date;
dw["honors_Awardname_" + Convert.ToString(i + 1)] = p_name;
}
catch { }
}
catch (Exception ex)
{ }
}
#endregion
#region 教育教学活动记录
d_table = Evaluation_Class.GetDataByStudentAndTerm(CurRecordClass.studentNo, CurRecordClass.termNo, "课外活动");
int d_count = 0;
for (int i = 0; i < d_table.Rows.Count; i++)
{
try
{
string p_name = d_table.Rows[i]["item"].ToString().Trim();
string p_date = d_table.Rows[i]["Quantity"].ToString().Trim();
string p_results = d_table.Rows[i]["results"].ToString().Trim();
switch (p_name)
{
case "社会调查":
dw["Evaluation_results_shehui"] = p_results;
dw["Evaluation_Quantity_shehui"] = p_date;
break;
case "阅读书籍":
dw["Evaluation_results_yuedu"] = p_results;
dw["Evaluation_Quantity_yuedu"] = p_date;
break;
case "社团活动":
dw["Evaluation_results_shetuan"] = p_results;
dw["Evaluation_Quantity_shetuan"] = p_date;
break;
case "社区活动":
dw["Evaluation_results_shequ"] = p_results;
dw["Evaluation_Quantity_shequ"] = p_date;
break;
default:
try
{
dw["Evaluation_results_" + Convert.ToString(i + 1)] = p_results;
dw["Evaluation_Quantity_" + Convert.ToString(i + 1)] = p_date;
dw["Evaluation_item_" + Convert.ToString(i + 1)] = p_name;
}
catch { }
break;
}
}
catch (Exception ex)
{ }
}
d_table = Evaluation_Class.GetDataByStudentAndTerm(CurRecordClass.studentNo, CurRecordClass.termNo, "研究课题");
for (int i = 0; i < d_table.Rows.Count; i++)
{
string p_name = d_table.Rows[i]["item"].ToString().Trim();
string p_date = d_table.Rows[i]["createdate"].ToString().Trim();
string p_results = d_table.Rows[i]["results"].ToString().Trim();
try
{
dw["Evaluation_results_" + Convert.ToString(i + 6)] = p_results;
dw["Evaluation_createdate_" + Convert.ToString(i + 6)] = p_date;
dw["Evaluation_item_" + Convert.ToString(i + 6)] = p_name;
}
catch { }
}
#endregion
dt.Rows.Add(dw);
return dt;
}
private static DataTable PrintDataSource(int p_id)
{
ScoreRecord_Class CurRecordClass = new ScoreRecord_Class(p_id);
List <string> d_courselist = new List <string>();
d_courselist.Add("yw");
d_courselist.Add("sx");
d_courselist.Add("yy");
d_courselist.Add("kx");
d_courselist.Add("sh");
d_courselist.Add("it");
d_courselist.Add("music");
d_courselist.Add("ms");
d_courselist.Add("ty");
d_courselist.Add("ld");
d_courselist.Add("yj");
d_courselist.Add("sq");
DataTable dt = new DataTable();
dt.Columns.Add("termname", typeof(string));
dt.Columns.Add("classname", typeof(string));
dt.Columns.Add("studentname", typeof(string));
dt.Columns.Add("studentno", typeof(string));
for (int i = 0; i < 12; i++)
{
string coursenametemp = d_courselist[i];
dt.Columns.Add("ScoreGrade_scoregrade_" + coursenametemp + "_0", typeof(string));
dt.Columns.Add("ScoreGrade_scoregrade_" + coursenametemp + "_2", typeof(string));
dt.Columns.Add("ScoreGrade_scoregrade_" + coursenametemp + "_1", typeof(string));
dt.Columns.Add("ScoreGrade_readinggrade_" + coursenametemp + "_0", typeof(string));
dt.Columns.Add("ScoreGrade_readinggrade_" + coursenametemp + "_2", typeof(string));
dt.Columns.Add("ScoreGrade_readinggrade_" + coursenametemp + "_1", typeof(string));
dt.Columns.Add("ScoreGrade_compositiongrade_" + coursenametemp + "_0", typeof(string));
dt.Columns.Add("ScoreGrade_compositiongrade_" + coursenametemp + "_2", typeof(string));
dt.Columns.Add("ScoreGrade_compositiongrade_" + coursenametemp + "_1", typeof(string));
dt.Columns.Add("ScoreGrade_practicegrade_" + coursenametemp + "_0", typeof(string));
dt.Columns.Add("ScoreGrade_practicegrade_" + coursenametemp + "_2", typeof(string));
dt.Columns.Add("ScoreGrade_practicegrade_" + coursenametemp + "_1", typeof(string));
dt.Columns.Add("ScoreGrade_Writegrade_" + coursenametemp + "_0", typeof(string));
dt.Columns.Add("ScoreGrade_Writegrade_" + coursenametemp + "_2", typeof(string));
dt.Columns.Add("ScoreGrade_Writegrade_" + coursenametemp + "_1", typeof(string));
dt.Columns.Add("ScoreGrade_attitudegrade_" + coursenametemp + "_0", typeof(string));
dt.Columns.Add("ScoreGrade_attitudegrade_" + coursenametemp + "_2", typeof(string));
dt.Columns.Add("ScoreGrade_attitudegrade_" + coursenametemp + "_1", typeof(string));
}
for (int i = 0; i < 9; i++)
{
dt.Columns.Add("honors_Awarddep_" + Convert.ToString(i + 1), typeof(string));
dt.Columns.Add("honors_Awardname_" + Convert.ToString(i + 1), typeof(string));
dt.Columns.Add("honors_Awarddate_" + Convert.ToString(i + 1), typeof(string));
dt.Columns.Add("Evaluation_results_" + Convert.ToString(i + 1), typeof(string));
dt.Columns.Add("Evaluation_item_" + Convert.ToString(i + 1), typeof(string));
dt.Columns.Add("Evaluation_createdate_" + Convert.ToString(i + 1), typeof(string));
dt.Columns.Add("Evaluation_Quantity_" + Convert.ToString(i + 1), typeof(string));
}
dt.Columns.Add("Evaluation_results_shequ", typeof(string));
dt.Columns.Add("Evaluation_results_shetuan", typeof(string));
dt.Columns.Add("Evaluation_results_shehui", typeof(string));
dt.Columns.Add("Evaluation_results_yuedu", typeof(string));
dt.Columns.Add("Evaluation_Quantity_shehui", typeof(string));
dt.Columns.Add("Evaluation_Quantity_shequ", typeof(string));
dt.Columns.Add("Evaluation_Quantity_shetuan", typeof(string));
dt.Columns.Add("Evaluation_Quantity_yuedu", typeof(string));
dt.Columns.Add("ScoreRecord_schoolcoursename", typeof(string));
dt.Columns.Add("ScoreRecord_schoolcoursenametwo", typeof(string));
dt.Columns.Add("ScoreRecord_attendance", typeof(string));
dt.Columns.Add("ScoreRecord_leave", typeof(string));
dt.Columns.Add("ScoreRecord_absenteeism", typeof(string));
dt.Columns.Add("ScoreRecord_specialtyelectivegrade", typeof(string));
dt.Columns.Add("ScoreRecord_schoolcoursegradetwo", typeof(string));
dt.Columns.Add("ScoreRecord_schoolcoursegrade", typeof(string));
dt.Columns.Add("ScoreRecord_specialtyelective", typeof(string));
dt.Columns.Add("ScoreRecord_classjob", typeof(string));
dt.Columns.Add("ScoreRecord_parenthope", typeof(string));
dt.Columns.Add("ScoreRecord_myevaluate", typeof(string));
dt.Columns.Add("ScoreRecord_productlevel", typeof(string));
DataRow dw = dt.NewRow();
dw["termname"] = "二〇 学年度第 学期";
dw["classname"] = "二〇 学年度第 学期";
dw["studentname"] = "二〇 学年度第 学期";
dw["studentno"] = "二〇 学年度第 学期";
for (int i = 0; i < 12; i++)
{
string coursenametemp = d_courselist[i];
dw["ScoreGrade_scoregrade_" + coursenametemp + "_0"] = "";
dw["ScoreGrade_scoregrade_" + coursenametemp + "_2"] = "";
dw["ScoreGrade_scoregrade_" + coursenametemp + "_1"] = "";
dw["ScoreGrade_readinggrade_" + coursenametemp + "_0"] = "";
dw["ScoreGrade_readinggrade_" + coursenametemp + "_2"] = "";
dw["ScoreGrade_readinggrade_" + coursenametemp + "_1"] = "";
dw["ScoreGrade_compositiongrade_" + coursenametemp + "_0"] = "";
dw["ScoreGrade_compositiongrade_" + coursenametemp + "_2"] = "";
dw["ScoreGrade_compositiongrade_" + coursenametemp + "_1"] = "";
dw["ScoreGrade_practicegrade_" + coursenametemp + "_0"] = "";
dw["ScoreGrade_practicegrade_" + coursenametemp + "_2"] = "";
dw["ScoreGrade_practicegrade_" + coursenametemp + "_1"] = "";
dw["ScoreGrade_Writegrade_" + coursenametemp + "_0"] = "";
dw["ScoreGrade_Writegrade_" + coursenametemp + "_2"] = "";
dw["ScoreGrade_Writegrade_" + coursenametemp + "_1"] = "";
dw["ScoreGrade_attitudegrade_" + coursenametemp + "_0"] = "";
dw["ScoreGrade_attitudegrade_" + coursenametemp + "_2"] = "";
dw["ScoreGrade_attitudegrade_" + coursenametemp + "_1"] = "";
}
for (int i = 0; i < 9; i++)
{
dw["honors_Awarddep_" + Convert.ToString(i + 1)] = "";
dw["honors_Awardname_" + Convert.ToString(i + 1)] = "";
dw["honors_Awarddate_" + Convert.ToString(i + 1)] = "";
dw["Evaluation_results_" + Convert.ToString(i + 1)] = "";
dw["Evaluation_item_" + Convert.ToString(i + 1)] = "";
dw["Evaluation_createdate_" + Convert.ToString(i + 1)] = "";
dw["Evaluation_Quantity_" + Convert.ToString(i + 1)] = "";
}
dw["Evaluation_results_shequ"] = "";
dw["Evaluation_results_shetuan"] = "";
dw["Evaluation_results_shehui"] = "";
dw["Evaluation_results_yuedu"] = "";
dw["Evaluation_Quantity_shehui"] = "";
dw["Evaluation_Quantity_shequ"] = "";
dw["Evaluation_Quantity_shetuan"] = "";
dw["Evaluation_Quantity_yuedu"] = "";
dw["ScoreRecord_specialtyelectivegrade"] = CurRecordClass.SpecialtyElectiveGrade;
dw["ScoreRecord_schoolcoursename"] = CurRecordClass.SchoolCourseName;
dw["ScoreRecord_schoolcoursenametwo"] = CurRecordClass.SchoolCourseNameTwo;
dw["ScoreRecord_schoolcoursegradetwo"] = CurRecordClass.SchoolCourseGradeTwo;
dw["ScoreRecord_schoolcoursegrade"] = CurRecordClass.SchoolCourseGrade;
dw["ScoreRecord_attendance"] = CurRecordClass.Attendance;
dw["ScoreRecord_leave"] = CurRecordClass.leave;
dw["ScoreRecord_absenteeism"] = CurRecordClass.Absenteeism;
dw["ScoreRecord_parenthope"] = CurRecordClass.Parenthope;
dw["ScoreRecord_myevaluate"] = CurRecordClass.MyEvaluate;
dw["ScoreRecord_specialtyelective"] = CurRecordClass.SpecialtyElective;
dw["ScoreRecord_classjob"] = CurRecordClass.classjob;
dw["ScoreRecord_productlevel"] = CurRecordClass.Productlevel;
#region 课程
DataTable d_table = new DataTable();
try
{
d_table = ScoreGrade_Class.GetDataByStudentAndTerm(CurRecordClass.studentNo, CurRecordClass.termNo);
for (int i = 0; i < d_table.Rows.Count; i++)
{
try
{
string p_courseNo = d_table.Rows[i]["courseNo"].ToString().Trim().Replace("2600", "");
p_courseNo = d_courselist[Convert.ToInt32(p_courseNo) - 1];
string timesterm = d_table.Rows[i]["teamtimes"].ToString().Trim();
dw["ScoreGrade_scoregrade_" + p_courseNo + "_" + timesterm] = d_table.Rows[i]["scoregrade"].ToString().Trim();
dw["ScoreGrade_readinggrade_" + p_courseNo + "_" + timesterm] = d_table.Rows[i]["readinggrade"].ToString().Trim();
dw["ScoreGrade_compositiongrade_" + p_courseNo + "_" + timesterm] = d_table.Rows[i]["compositiongrade"].ToString().Trim();
dw["ScoreGrade_practicegrade_" + p_courseNo + "_" + timesterm] = d_table.Rows[i]["practicegrade"].ToString().Trim();
dw["ScoreGrade_Writegrade_" + p_courseNo + "_" + timesterm] = d_table.Rows[i]["Writegrade"].ToString().Trim();
dw["ScoreGrade_attitudegrade_" + p_courseNo + "_" + timesterm] = d_table.Rows[i]["attitudegrade"].ToString().Trim();
}
catch { }
// CurScorelist[i].FillInputByClass(p_id, p_name, p_date, p_results, "");
}
}
catch (Exception ex)
{ }
#endregion
#region 班级荣誉
d_table = Honors_Class.GetDataByStudentAndTerm(CurRecordClass.studentNo, CurRecordClass.termNo);
for (int i = 0; i < d_table.Rows.Count; i++)
{
try
{
string p_name = d_table.Rows[i]["Awardname"].ToString().Trim();
string p_date = d_table.Rows[i]["Awarddate"].ToString().Trim();
string p_results = d_table.Rows[i]["Awarddep"].ToString().Trim();
try
{
dw["honors_Awarddep_" + Convert.ToString(i + 1)] = p_results;
dw["honors_Awarddate_" + Convert.ToString(i + 1)] = p_date;
dw["honors_Awardname_" + Convert.ToString(i + 1)] = p_name;
}
catch { }
}
catch (Exception ex)
{ }
}
#endregion
#region 教育教学活动记录
d_table = Evaluation_Class.GetDataByStudentAndTerm(CurRecordClass.studentNo, CurRecordClass.termNo, "课外活动");
int d_count = 0;
for (int i = 0; i < d_table.Rows.Count; i++)
{
try
{
string p_name = d_table.Rows[i]["item"].ToString().Trim();
string p_date = d_table.Rows[i]["Quantity"].ToString().Trim();
string p_results = d_table.Rows[i]["results"].ToString().Trim();
switch (p_name)
{
case "社会调查":
dw["Evaluation_results_shehui"] = p_results;
dw["Evaluation_Quantity_shehui"] = p_date;
break;
case "阅读书籍":
dw["Evaluation_results_yuedu"] = p_results;
dw["Evaluation_Quantity_yuedu"] = p_date;
break;
case "社团活动":
dw["Evaluation_results_shetuan"] = p_results;
dw["Evaluation_Quantity_shetuan"] = p_date;
break;
case "社区活动":
dw["Evaluation_results_shequ"] = p_results;
dw["Evaluation_Quantity_shequ"] = p_date;
break;
default:
try
{
dw["Evaluation_results_" + Convert.ToString(i + 1)] = p_results;
dw["Evaluation_Quantity_" + Convert.ToString(i + 1)] = p_date;
dw["Evaluation_item_" + Convert.ToString(i + 1)] = p_name;
}
catch { }
break;
}
}
catch (Exception ex)
{ }
}
d_table = Evaluation_Class.GetDataByStudentAndTerm(CurRecordClass.studentNo, CurRecordClass.termNo, "研究课题");
for (int i = 0; i < d_table.Rows.Count; i++)
{
string p_name = d_table.Rows[i]["item"].ToString().Trim();
string p_date = d_table.Rows[i]["createdate"].ToString().Trim();
string p_results = d_table.Rows[i]["results"].ToString().Trim();
try
{
dw["Evaluation_results_" + Convert.ToString(i + 6)] = p_results;
dw["Evaluation_createdate_" + Convert.ToString(i + 6)] = p_date;
dw["Evaluation_item_" + Convert.ToString(i + 6)] = p_name;
}
catch { }
}
#endregion
dt.Rows.Add(dw);
return(dt);
}
public ScoreReport_Form()
{
InitializeComponent();
CurRecordClass = new ScoreRecord_Class(1);
}
public ScoreReport_Form(int p_id)
{
InitializeComponent();
CurRecordClass = new ScoreRecord_Class(p_id);
}
private void gridControl_RecordList_DoubleClick(object sender, EventArgs e)
{
DataTable d_DTable = new DataTable();
d_DTable = (DataTable)gridControl_RecordList.DataSource;
if (d_DTable == null)
{
MessageBox.Show("请先查出要操作的记录", "错误");
return;
}
if (d_DTable.Rows.Count == 0)
{
MessageBox.Show("请先查出要操作的记录", "错误");
return;
}
string temp_id = d_DTable.Rows[gridView_RecordList.GetDataSourceRowIndex(gridView_RecordList.FocusedRowHandle)]["ID"].ToString();
if (temp_id == "")
{
MessageBox.Show("请先查出要操作的记录", "错误");
return;
}
int p_id = Convert.ToInt32(temp_id);
ScoreRecord_Class d_class = new ScoreRecord_Class(p_id);
if (d_class.ID == 0)
{
MessageBox.Show("无效选择，请重新选择", "错误");
return;
}
ScoreReport_Form d_from = new ScoreReport_Form(p_id);
d_from.MdiParent = this.MdiParent;
d_from.Show();
}
