/// <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"); } } }