/// <summary>
/// 修改课程
/// </summary>
/// <returns></returns>
public int UpdateCourse(JiaJiModels.languagerelation model)
{
try
{
return(new JiaJiDAL.LanguageDAL().UpdateCourse(model));
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 修改课程
/// </summary>
/// <returns></returns>
public int UpdateCourse(JiaJiModels.languagerelation model)
{
try
{
//首先查出选中关系表中的主键
string sql = "select * from languagerelation where LRelationID=" + model.LRelationID + "";
int courseid = Convert.ToInt32(MySqlDB.GetDataTable(sql, CommandType.Text, null).Rows[0][2]);
sql = "UPDATE course set CourseName='" + model.CourseName + "',CourseContent='" + model.CourseContent + "',CourseDetail='" + model.CourseDetail + "',CourseDate='" + model.CourseDate + "',CourseKeyWord='" + model.CourseKeyWord + "' where course.CourseID=" + courseid + ";";
sql += "update languagerelation set LanguageID=" + model.LanguageID + ",CourseID=" + courseid + " where LRelationID=" + model.LRelationID + " ";
int he = MySqlDB.nonquery(sql, CommandType.Text, null);
return(he);
}
catch (Exception ex)
{
return(0);
}
}
