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