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