//添加课程时调用方法
public static bool AddClass(string courseName, string courseType, string teacherName, string courseTime)
{
bool result = false;
SqlConnection sqlConnection = GetSqlConnection();
sqlConnection.Open();
bool result1 = false;
DataSet dataSet = DAO_Course.selectCourseData(courseName, courseType); //查询是否有此门课程
if (dataSet.Tables[0].Rows.Count == 0) //若查询结果为0，则添加此门课程
{
result1 = DAO_Course.addCourse(courseName, courseType, courseTime); //调用方法，向课程表中添加此课程，若result1的值为true，则添加成功
}
if (result1) //若向课程表添加成功，则想教师授课表添加数据
{
string sql = "insert T_C(courseName,teaId) values(@courseName,@teacherId)";
string teacherId = DAO_Teacher.getTeacherId(teacherName);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("courseName", courseName),
new SqlParameter("teacherId", teacherId)
};
SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);
sqlCommand.Parameters.AddRange(parameters);
int count = sqlCommand.ExecuteNonQuery();
if (count > 0)
{
result = true;
}
}
sqlConnection.Close();
return(result);
}
//修改教师授课表时调用方法
public static bool updateT_C(string courseName, string teaName, string NewCourseName, string NewTeaName)
{
bool result = false;
SqlConnection sqlConnection = GetSqlConnection();
sqlConnection.Open();
string teacherId = DAO_Teacher.getTeacherId(teaName);
string NewTeacherId = DAO_Teacher.getTeacherId(NewTeaName);
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("teaId", teacherId),
new SqlParameter("courseName", courseName),
new SqlParameter("NewTeaId", NewTeacherId),
new SqlParameter("NewCourseName", NewCourseName)
};
string sql = "update T_C set";
if (courseName != "")
{
sql = sql + " courseName = @NewCourseName, ";
} //判断课程名称是否为空
if (teacherId != "")
{
sql = sql + " teaId = @NewTeaId ";
} //判断成绩是否为空
sql = sql + " where ";
if (courseName != "")
{
sql = sql + " courseName = @courseName ";
} //添加修改条件，判断课程名称是否为空
if (teacherId != "")
{
sql = sql + " and teaId = @teaId ";
} //添加修改条件，判断成绩是否为空
SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);
sqlCommand.Parameters.AddRange(parameter);
int count = sqlCommand.ExecuteNonQuery();
if (count > 0)
{
result = true;
} //判断SQL语句执行结果
sqlConnection.Close();
return(result);
}
