protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { List <StudentClass> listClass = new List <StudentClass>(); listClass = new StudentClassServer().GetStudentClassList(); dpdClassName.DataSource = listClass; dpdClassName.DataTextField = "ClassName"; dpdClassName.DataValueField = "ClassId"; dpdClassName.DataBind(); //【1】获取学员的ID string studentId = Request.QueryString["StudentId"].ToString(); StudentSimpleExt objStudent = new StudentSimpleExt(); objStudent = new StudentServer().GetStuSentById(studentId); //【2】解析对象 latStudentId.Text = studentId; txtNmae.Text = objStudent.StudentName; txtAddress.Text = objStudent.StudentAddress; txtBirthday.Text = objStudent.Birthday.ToString("yyyy-MM-dd"); txtPhoneNum.Text = objStudent.PhoneNumber; dpdClassName.SelectedIndex = objStudent.ClassID; rdoFelmem.Checked = objStudent.Gender == "女" ? true : false; rdoMen.Checked = objStudent.Gender == "女" ? false : true; txtStuIdCardNum.Text = objStudent.StudentIDNub; imgStudent.ImageUrl = string.Format("~/images/student-img/{0}.png", studentId); } LtaMsg.Text = ""; }
protected void btnSubmit_Click(object sender, EventArgs e) { StudentServer objStudentServer = new StudentServer(); //【1】判断身份证是否重复 if (objStudentServer.IsExistsStudent(latStudentId.Text.Trim(), txtStuIdCardNum.Text.Trim())) { LtaMsg.Text = "<script type='text / javascript'>alert('" + latStudentId.Text.Trim() + "学员身份号信息已存在!请检查学员的身份证号')</script>"; return; } //【2】封装学员对象 Student objStudent = new Student() { StudentID = Convert.ToInt32(latStudentId.Text.Trim()), StudentName = txtNmae.Text.Trim(), StudentAddress = txtAddress.Text.Trim(), Birthday = Convert.ToDateTime(txtBirthday.Text), PhoneNumber = txtPhoneNum.Text.Trim(), ClassID = dpdClassName.SelectedIndex, Gender = rdoFelmem.Checked ? "女":"男", StudentIDNub = txtStuIdCardNum.Text.Trim() }; if (objStudentServer.ModifyStudentInfo(objStudent) != 1) { //LtaMsg.Text = "<script type='text / javascript'>alert('" + latStudentId.Text.Trim() + "学员身份号信息已存在!请检查学员的身份证号')</script>"; Response.Redirect("~/errPage.html"); } else { Response.Redirect("~/StudentWebASP/UpLoadImg.aspx?IsModify=1&Id=" + objStudent.StudentID); } }
public static bool UpdateStudentInfo(Student s) { try { ////查询出来一个student //Student stu = StudentServer.SelectStudentByID(s.StuID); //ExamDBEntities db = new ExamDBEntities(); //db.Entry(stu).State = EntityState.Modified; ////逐个更新 //stu.StuName = s.StuName; //stu.StuLoginName = s.StuLoginName; //stu.StuSex = s.StuSex; //stu.StuGrade = s.StuGrade; //stu.StuEmail = s.StuEmail; //stu.StuLoginPwd = s.StuLoginPwd; //stu.StuPhone = s.StuPhone; //查询出来一个student Student stu = StudentServer.SelectStudentByID(s.StuID); ExamDBEntities db = new ExamDBEntities(); //这也可以实现对象的快速修改,推荐用这个方法 db.Entry(s).State = EntityState.Modified; //直接将传入的对象,设置修改装填 db.SaveChanges(); return(true); } catch { return(false); } }
public static bool CheckStudentUser(string name, string pwd) { Student s = StudentServer.SelectStudentByName(name); //不为空,表示查询到了一条学生信息的记录 if (s != null) { return(s.StuLoginPwd == pwd); } else { return(false); } }
protected void btnSubmit_Click(object sender, EventArgs e) { //【1】检查学员的信息 if (new StudentServer().IsExistsStudent(txtStuIdCardNum.Text.Trim())) { LtaMsg.Text = "<script type='text/javascript'>alert('学员信息重复请检查信息的输入!')</script>"; return; } else { //【2】验证验证码是否正确 if (txtCord.Text == Session["CheckCode"].ToString()) { //【3】封装学员数据 Student objStudent = new Student() { StudentName = txtNmae.Text.Trim(), Gender = rdoMen.Checked ? "男" : "女", Birthday = Convert.ToDateTime(txtBirthday.Text), ClassID = dpdClassName.SelectedIndex, StudentIDNub = txtStuIdCardNum.Text, PhoneNumber = txtPhoneNum.Text, StudentAddress = txtAddress.Text.Trim().Length == 0 ? "地址不详" : txtAddress.Text.Trim() }; //【4】提交学员信息 try { int newStudentId = new StudentServer().AddStudentInfo(objStudent); if (newStudentId > 0) { Response.Redirect("~/StudentWebASP/UpLoadImg.aspx?Id=" + newStudentId); // LtaMsg.Text = "<script type='text/javascript'>alert('添加学员信息时出现错误:')</script>"; } } catch (Exception ex) { //LtaMsg.Text = "<script type='text/javascript'>alert(' 验证码错误,请重新输入验证码!')</script>"; LtaMsg.Text = "<script type='text/javascript'>alert('添加学员信息时出现错误:" + ex.Message.ToString().Replace('\'', '_') + " ')</script>"; //throw ex ; } } else { LtaMsg.Text = "<script type='text/javascript'>alert(' 验证码错误,请重新输入验证码!')</script>"; return; } } }
public static bool DeleteStudentByID(int id) { try { //获取要删除的学生信息 Student s = StudentServer.SelectStudentByID(id); ExamDBEntities db = new ExamDBEntities(); //将要删除的学生对象状态,修改为删除。 db.Entry(s).State = EntityState.Deleted; db.Students.Remove(s);//Remove删除 db.SaveChanges(); return(true); } catch { return(false); } }
public static Student GetStudentById(int id) { return(StudentServer.SelectStudentByID(id)); }
public static List <Student> GetAllStudent() { return(StudentServer.SelectAllStudent()); }