public int selectCourse(int sid, int cid) { int startyear = int.Parse(new StudentBusiness().getStuBySid(sid).Startyear.ToString()); int year = DateTime.Now.Year; int month = DateTime.Now.Month; int semester = (month >= 1 && month <= 6) ? 2 * (year - startyear) : 2 * (year - startyear) + 1; ScModel scModel = new ScModel(sid, cid, semester); CourseService courseService = new CourseService(); //判断是否有先修 if (!courseService.ifPrecourceYes(sid,cid,semester)) { return 2; } //判断是否冲突 else if (courseService.isSectionNotAvailable(sid,cid,semester)) { return 3; } else { return courseService.insertSelectedCourse(scModel); } }
public int insertSelectedCourse(ScModel scModel) { MySqlConnection conn = GetConn.getConn(); try { conn.Open(); MySqlCommand cmd1 = new MySqlCommand("select * from `tb_sc` where `sid`=@sid and `cid`=@cid", conn); cmd1.Parameters.AddWithValue("@sid", scModel.Sid); cmd1.Parameters.AddWithValue("@cid", scModel.Cid); //cmd1.Parameters.AddWithValue("@semester", scModel.Semester); MySqlDataReader reader = cmd1.ExecuteReader(); if (reader.Read()) { conn.Close(); return 0; } else { conn.Close(); conn.Open(); MySqlCommand cmd = new MySqlCommand("insert into `tb_sc`(sid,cid,semester) values (@sid, @cid, @semester)", conn); cmd.Parameters.AddWithValue("@sid", scModel.Sid); cmd.Parameters.AddWithValue("@cid", scModel.Cid); cmd.Parameters.AddWithValue("@semester", scModel.Semester); cmd.ExecuteNonQuery(); cmd.Dispose(); return 1; } } catch (Exception) { conn.Close(); return -1; } }