/// <summary>
/// 学生选课
/// </summary>
/// <param name="CourseId">被选课程Id</param>
/// <param name="StuId">学生Id</param>
/// <returns>1 成功 </returns>
public int chooseCourse(int CourseId, int StuId)
{
//判断是否以经选择过
int res1 = new CourseService().IsExistCourse(CourseId, StuId);
if (res1 > 0)
{
return(-1);
}
//判断学分
float mypoint = new CourseService().CalPoint(StuId);
float coursepoint = new CourseService().CalCoursePoint(CourseId);
if (mypoint + coursepoint > 30.0)
{
return(-2);
}
Course_Stu course = new Course_Stu();
CourseMes course1 = new CourseService().queryCourseById(CourseId);
CourseMana course2 = new CourseService().selectCourseById(CourseId);
course.StuId = StuId;
course.CourseId = course1.CourseID;
course.TeaId = course1.TeaId;
course.CourseName = course1.CourseName;
course.Season = course2.Season;
course.Time = course2.Time;
return(new CourseService().chooseCourse(course));
}
/// <summary>
/// 学生选择课程
/// </summary>
/// <param name="course"></param>
/// <returns></returns>
public int chooseCourse(Course_Stu course)
{
string sql = "insert into Courses_Stu (StuId,CourseId,CourseName,Season,Time,TeaId) Values (@StuId,@CourseId,@CourseName,@Season,@Time,@TeaId)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@StuId", course.StuId),
new SqlParameter("@CourseId", course.CourseId),
new SqlParameter("@CourseName", course.CourseName),
new SqlParameter("@Season", course.Season),
new SqlParameter("@Time", course.Time),
new SqlParameter("@TeaId", course.TeaId)
};
return(new Helper.SQLHelper().update(sql, param, false));
}
