/// <summary>
/// 添加课程
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int addCourse(JiaJiModels.CourseModel model)
{
try
{
return(new JiaJiDAL.LanguageDAL().addCourse(model));
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 添加课程
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int addCourse(JiaJiModels.CourseModel model)
{
try
{
string sql = "insert into course(CourseName,CourseContent,CourseDetail,CourseReadCount,CourseDate,CourseKeyWord) values ('" + model.CourseName + "','" + model.CourseContent + "','" + model.CourseDetail + "',0,'" + model.CourseDate + "','" + model.CourseKeyWord + "');select @@IDENTITY; ";
int courseid = Convert.ToInt32(MySqlDB.GetDataTable(sql, CommandType.Text, null).Rows[0][0]);
sql = "insert into languagerelation(LanguageID, Courseid) values(" + model.LanguageID + "," + courseid + ")";
int he = MySqlDB.nonquery(sql, CommandType.Text, null);
return(he);
}
catch (Exception ex)
{
return(0);
}
}
