//显示要修改学生成绩的默认信息 public DataTable ShowDefultSC(Model.SC sc) { string SQL = "select sc.cno,course.cname,sno,grade from sc,course where sc.cno=course.cno and id='" + sc.ID + "'"; DataTable dt = db.SQLGetDataTable(SQL); return(dt); }
//得到学生已选课程的课程名称 public DataTable GetSelectedCourseName(Model.SC sc) { string SQL = "select * from Course where cno='" + sc.Cno + "'"; DataTable dt = db.SQLGetDataTable(SQL); return(dt); }
//得到学生已选的课程信息 public DataTable GetSelect(Model.SC sc) { string SQL = "select * from SC where sno='" + sc.Sno + "'"; DataTable dt = db.SQLGetDataTable(SQL); return(dt); }
//删除所选择的课程 public void DeleteSC(Model.SC sc) { IDataParameter[] parameter = { new SqlParameter("@ID", SqlDbType.Int, 32) }; parameter[0].Value = sc.ID; pr.ExcutePro("DeleteSC", parameter); }
//判断此门课是否被选 public bool IsSelected(Model.SC sc) { bool flag = false; string SQL = "select * from SC where cno='" + sc.Cno + "' and sno='" + sc.Sno + "'"; DataTable dt = new DataTable(); dt = db.SQLGetDataTable(SQL); if (dt.Rows.Count > 0) { flag = true; } return(flag); }
//保存已修改过的学生信息 public bool SaveSC(Model.SC sc) { bool flag = false; IDataParameter[] parameter = { new SqlParameter("@Sno", SqlDbType.VarChar, 50), new SqlParameter("@Cno", SqlDbType.VarChar, 50), new SqlParameter("@grade", SqlDbType.Float) }; parameter[0].Value = sc.Sno; parameter[1].Value = sc.Cno; parameter[2].Value = sc.Grade; flag = pr.ExecuteProcedure("SaveSC", parameter); return(flag); }
//根据不同的查询条件返回不同的结果 public DataTable Search(Model.SC sc, Model.Student stu, string condition) { if (condition == "按学号查询") { string SQL = "select sc.id,sc.cno,course.cname,sc.sno,student.sclass,grade from sc,course,student where sc.cno=course.cno and student.sno=sc.sno and sc.sno='" + sc.Sno + "'"; DataTable dt = db.SQLGetDataTable(SQL); return(dt); } else if (condition == "按班级查询") { string SQL = "select sc.id,sc.cno,course.cname,sc.sno,student.sclass,grade from sc,course,student where sc.cno=course.cno and student.sno=sc.sno and student.sclass= '" + stu.Sclass + "'"; DataTable dt = db.SQLGetDataTable(SQL); return(dt); } else { string SQL = "select sc.id,sc.cno,course.cname,sc.sno,student.sclass,grade from sc,course,student where sc.cno=course.cno and student.sno=sc.sno"; DataTable dt = db.SQLGetDataTable(SQL); return(dt); } }
//退选课程 public void DeleteCourse(Model.SC sc) { string SQL = "delete from SC where cno='" + sc.Cno + "' and sno='" + sc.Sno + "'"; db.SQLExecute(SQL); }
public DataTable GetSelectedCourseName(Model.SC sc) { return(course.GetSelectedCourseName(sc)); }
public DataTable Search(Model.SC sc, Model.Student stu, string condition) { return(course.Search(sc, stu, condition)); }
public bool SaveSC(Model.SC sc) { return(course.SaveSC(sc)); }
public DataTable ShowDefultSC(Model.SC s) { return(course.ShowDefultSC(s)); }
public void DeleteSC(Model.SC sc) { course.DeleteSC(sc); }
public void InsertCourse(Model.SC sc) { course.InsertCourse(sc); }
public bool IsSelected(Model.SC sc) { return(course.IsSelected(sc)); }
public void DeleteCourse(Model.SC sc) { course.DeleteCourse(sc); }
//选中课程 public void InsertCourse(Model.SC sc) { string SQL = "insert into sc(sno,cno)values('" + sc.Sno + "','" + sc.Cno + "')"; db.SQLExecute(SQL); }
public DataTable GetSelect(Model.SC sc) { return(course.GetSelect(sc)); }