/// <summary>
/// 从System.Data.DataTable导入数据到数据库
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public int InsetData(System.Data.DataTable dt)
{
int i = 0;
ExamSignSystemEntity.Grade grade = new ExamSignSystemEntity.Grade();
foreach (DataRow dr in dt.Rows)
{
grade.gradeID = int.Parse(dr[0].ToString().Trim());
grade.gradeSno = dr[1].ToString().Trim();
grade.gradeSubject = dr[2].ToString().Trim();
grade.gradeTime = DateTime.Parse(dr[3].ToString().Trim());
grade.gradeScore = int.Parse(dr[4].ToString().Trim());
GradeMgr mgr = new GradeMgr();
bool bl = mgr.AddGrade(grade);
if (bl)
{
i++;
}
else
{
i = 0;
}
}
return(i);
}
protected void Query_Click(object sender, EventArgs e)
{
string stuSno = this.txtGradeSno.Value.Trim();
string Pwd = this.txtGradePwd.Value.Trim();
if (stuSno == "" || Pwd == "")
{
this.hintGrade.InnerHtml = "学号或者密码不能为空！";
}
else
{
MD5Encrypt MD5 = new MD5Encrypt();
string stuPwd = MD5.GetMD5(Pwd);
StudentMgr mgr = new StudentMgr();
ExamSignSystemEntity.Student student = mgr.Login(stuSno, stuPwd);
if (student != null)
{
GradeMgr grade = new GradeMgr();
List <Grade> list = grade.ShowGradeList(stuSno);
if (list != null)
{
this.showGrade.Attributes.Add("style", "display:block");
this.Repeater1.DataSource = list;
this.Repeater1.DataBind();
this.hintGrade.InnerHtml = "";
}
else
{
this.hintGrade.InnerHtml = "可能没有考试！";
this.showGrade.Attributes.Add("style", "display:none");
}
}
else
{
this.hintGrade.InnerHtml = "账号或者密码输入错误！";
this.showGrade.Attributes.Add("style", "display:none");
}
}
}
