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