// 新建问题 public bool create(Problem obj) { DataClassesDataContext da = new DataClassesDataContext(); da.Problem.InsertOnSubmit(obj); da.SubmitChanges(); return true; }
//添加课程 public bool AddCourse(Course course) { DataClassesDataContext da = new DataClassesDataContext(); da.Course.InsertOnSubmit(course); da.SubmitChanges(); return true; }
//根据账号名获取学生全部信息 public Student GetStudent(String name) { DataClassesDataContext da = new DataClassesDataContext(); var stu = from s in da.Student where s.username == name select s; return stu.FirstOrDefault(); }
//根据Problem的Id获得分值 public float GetProblemScore(int pro_id) { DataClassesDataContext da = new DataClassesDataContext(); var problem = from p in da.Problem where p.id == pro_id select p; return (float)problem.First().score; }
public Problem GetProblemById(int id) { DataClassesDataContext da = new DataClassesDataContext(); var p = from s in da.Problem where s.id == id select s; return p.FirstOrDefault(); }
//根据teacher账号名获取teacher信息 public Teacher GetTeacher(String name) { DataClassesDataContext da = new DataClassesDataContext(); var t = from s in da.Teacher where s.username == name select s; return t.FirstOrDefault(); }
public bool Create(Accessory accessory) { if (accessory.adress.Length == 0) return false; DataClassesDataContext da = new DataClassesDataContext(); da.Accessory.InsertOnSubmit(accessory); da.SubmitChanges(); return true; }
public Accessory GetAccessory(String stu, int assignment) { DataClassesDataContext da = new DataClassesDataContext(); var a = from s in da.Accessory where s.student == stu && s.assignment == assignment select s; return a.FirstOrDefault(); }
// 添加学生 public bool AddStudent(Student stu) { DataClassesDataContext da = new DataClassesDataContext(); Student student = new Student(); student = stu; da.Student.InsertOnSubmit(student); da.SubmitChanges(); return true; }
//插入teacher public bool AddTeacher(Teacher teacher) { DataClassesDataContext da = new DataClassesDataContext(); Teacher t = new Teacher(); t = teacher; da.Teacher.InsertOnSubmit(t); da.SubmitChanges(); return true; }
public bool Update(Admin newadmin) { DataClassesDataContext da = new DataClassesDataContext(); var a = from s in da.Admin where s.username == newadmin.username select s; a.First().passwd = newadmin.passwd; da.SubmitChanges(); return true; }
//学生选课 public bool ChooseCourse(String stuname, String course_num) { DataClassesDataContext da = new DataClassesDataContext(); Student_Course sc = new Student_Course(); sc.course = course_num; sc.student = stuname; da.Student_Course.InsertOnSubmit(sc); da.SubmitChanges(); return true; }
//得到所有问题 public List<Problem> getAllProblem() { DataClassesDataContext da = new DataClassesDataContext(); var p = from s in da.Problem select s; pro = new List<Problem>(); foreach (var n in p) pro.Add(n); return pro; }
//根据assignment的ID获取该作业的problem的List public List<Problem> GetProblem(int assignment_id) { DataClassesDataContext da = new DataClassesDataContext(); var p = from s in da.Problem where s.assignment == assignment_id select s; pro = new List<Problem>(); foreach (var n in p) pro.Add(n); return pro; }
public Admin GetAdmin(String name) { DataClassesDataContext da = new DataClassesDataContext(); var admin = from s in da.Admin where s.username == name select s; if (admin.Count() > 0) return admin.First(); else return null; }
//获得所有老师 public List<Teacher> GetAllTeacher() { DataClassesDataContext da = new DataClassesDataContext(); var t = from s in da.Teacher select s; TeacherList = new List<Teacher>(); foreach (var n in t) { TeacherList.Add(n); } return TeacherList; }
// 通过“专业”获取学生,返回该专业的全部学生信息的List public List<Student> GetStudentByMajor(String major) { DataClassesDataContext da = new DataClassesDataContext(); var stu = from s in da.Student where s.major == major select s; StuListForMajor = new List<Student>(); foreach (var n in stu) { StuListForMajor.Add(n); } return StuListForMajor; }
//根据Problem的Id来删除作业 public bool DeleteProblem(int pro_id) { DataClassesDataContext da = new DataClassesDataContext(); var answer = from s in da.Answer where s.problem == pro_id select s; da.Answer.DeleteAllOnSubmit(answer); var p = from s in da.Problem where s.id == pro_id select s; da.Problem.DeleteAllOnSubmit(p); da.SubmitChanges(); return true; }
//删除课程 public bool DeleteCourse(Course course) { DataClassesDataContext da = new DataClassesDataContext(); var c=from s in da.Course where s.teacher==course.teacher && s.name==course.name select s; var cin = from s in da.Student_Course where s.course == c.First().num select s; var ca = from s in da.Assignment where s.course == c.First().num select s; if (ca.Count() > 0) { foreach (var n in ca) { var p = from s in da.Problem where s.assignment == n.id select s; if (p.Count() > 0) { var answer = from s in da.Answer where s.problem == p.First().id select s; if (answer.Count() > 0) { da.Answer.DeleteAllOnSubmit(answer); //删除answer } } var accessory = from s in da.Accessory where s.assignment == n.id select s; if (accessory.Count() > 0) da.Accessory.DeleteAllOnSubmit(accessory); da.Problem.DeleteAllOnSubmit(p); //删除Problem } da.Assignment.DeleteAllOnSubmit(ca); //删除assignment } if (cin.Count() > 0) { da.Student_Course.DeleteAllOnSubmit(cin); //删除student_course } da.Course.DeleteAllOnSubmit(c); //删除Course da.SubmitChanges(); return true; }
//根据课程获取Student的列表 public List<Student> GetStudentByCourse(String course) { DataClassesDataContext da = new DataClassesDataContext(); var student = from s in da.Student_Course where s.course == course select s.student; StuListForCourse = new List<Student>(); foreach (var n in student) { var stu = from s in da.Student where s.username == n select s; StuListForCourse.Add(stu.FirstOrDefault()); } return StuListForCourse; }
//通过老师账号名和课程名获得指定课程 public Course GetOneCourse(String teachername, String coursename) { DataClassesDataContext da = new DataClassesDataContext(); var c = from s in da.Course where s.teacher == teachername && s.name == coursename select s; return c.FirstOrDefault(); }
//评分,pro_id代表问题ID,score代表分数 public bool Score(int pro_id,float score) { DataClassesDataContext da = new DataClassesDataContext(); var p = from s in da.Problem where s.id == pro_id select s; p.First().score = score; da.SubmitChanges(); return true; }
//更新问题 public bool UpdateProblem(Problem pro) { DataClassesDataContext da = new DataClassesDataContext(); var p = from s in da.Problem where s.id == pro.id select s; foreach (Problem problem in p) { problem.id = pro.id; problem.assignment = pro.assignment; problem.title = pro.title; problem.descrip = pro.descrip; problem.score = pro.score; } da.SubmitChanges(); return true; }
public Course GetCourseByNum(string number) { DataClassesDataContext da = new DataClassesDataContext(); var cou = from s in da.Course where s.num == number select s; if (cou.Count() > 0) return cou.First(); else return null; }
//通过学生账号名,获取该学生课程的List public List<Course> GetCourseForStudent(String stuname) { DataClassesDataContext da = new DataClassesDataContext(); var course_num = from s in da.Student_Course where s.student == stuname select s.course; StudentCourse = new List<Course>(); foreach (var c in course_num) { var result = from s in da.Course where s.num == c select s; StudentCourse.AddRange(result); } return StudentCourse; }
//获取全部Course public List<Course> GetCourse() { DataClassesDataContext da = new DataClassesDataContext(); var c = from s in da.Course select s; Course = new List<Course>(); foreach (var n in c) { Course.Add(n); } return Course; }
//通过老师账号名,获取课程List public List<Course> GetCourseForTeacher(String teachername) { DataClassesDataContext da = new DataClassesDataContext(); var c = from s in da.Course where s.teacher == teachername select s; TeacherCourse = new List<Course>(); foreach (var n in c) { TeacherCourse.Add(n); } return TeacherCourse; }