public bool Insert()
{
if (p_tablename == "honors")
{
Honors_Class d_class = new Honors_Class();
d_class.Awarddep = textbox_results.Text.Trim();
d_class.Awardname = textbox_name.Text.Trim();
try
{
d_class.Awarddate = Convert.ToDateTime(textbox_date.Text.Trim());
}
catch { d_class.Awarddate = DateTime.Now; }
d_class.termNo = ptermNo;
d_class.studentNo = pstudentno;
return(d_class.Insert());
}
else if (p_tablename == "Evaluation")
{
Evaluation_Class d_class = new Evaluation_Class();
d_class.termNo = ptermNo;
d_class.studentNo = pstudentno;
d_class.itemtype = ptype;
d_class.results = textbox_results.Text.Trim();
if (p_labelname != "")
{
d_class.item = p_labelname;
if (textbox_date.Text.Trim() == "")
{
return(true);
}
}
else
{
d_class.item = textbox_name.Text.Trim();
if (d_class.item == "")
{
return(true);
}
}
d_class.Quantity = textbox_date.Text.Trim();
try
{
d_class.createdate = Convert.ToDateTime(textbox_date.Text.Trim());
}
catch
{
d_class.createdate = DateTime.Now;
}
return(d_class.Insert());
}
return(true);
}
public bool Insert()
{
if (p_tablename == "honors")
{
Honors_Class d_class = new Honors_Class();
d_class.Awarddep = textbox_results.Text.Trim();
d_class.Awardname = textbox_name.Text.Trim();
try
{
d_class.Awarddate = Convert.ToDateTime(textbox_date.Text.Trim());
}
catch { d_class.Awarddate = DateTime.Now; }
d_class.termNo = ptermNo;
d_class.studentNo = pstudentno;
return d_class.Insert();
}
else if (p_tablename == "Evaluation")
{
Evaluation_Class d_class = new Evaluation_Class();
d_class.termNo = ptermNo;
d_class.studentNo = pstudentno;
d_class.itemtype = ptype;
d_class.results = textbox_results.Text.Trim();
if (p_labelname != "")
{
d_class.item = p_labelname;
if (textbox_date.Text.Trim() == "")
return true;
}
else
{
d_class.item = textbox_name.Text.Trim();
if (d_class.item == "")
return true;
}
d_class.Quantity = textbox_date.Text.Trim();
try
{
d_class.createdate = Convert.ToDateTime(textbox_date.Text.Trim());
}
catch
{
d_class.createdate = DateTime.Now;
}
return d_class.Insert();
}
return true;
}
public bool Update()
{
if (p_tablename == "honors")
{
return(Honors_Class.UpdateAward(pID.ToString(), textbox_results.Text.Trim(), textbox_name.Text.Trim(), textbox_date.Text.Trim()));
}
else if (p_tablename == "Evaluation")
{
string p_tempname = "";
if (p_labelname != "")
{
p_tempname = p_labelname;
}
else
{
p_tempname = textbox_name.Text.Trim();
}
return(Evaluation_Class.UpdateByID(pID.ToString(), textbox_results.Text.Trim(), p_tempname, textbox_date.Text.Trim(), ptype));
}
return(true);
}
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);
}