/// <summary> /// 修改留学规划 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdStudentprogram(JiaJiModels.StudentProgram model) { try { return(new JiaJiDAL.SprelationDal().UpdStudentprogram(model)); } catch (Exception ex) { return(0); } }
/// <summary> /// 修改留学规划 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdStudentprogram(JiaJiModels.StudentProgram model) { try { string sql = " update studentprogram set studentprogram.StudentProgramTitle='" + model.StudentProgramTitle + "',studentprogram.StudentProgramContent='" + model.StudentProgramContent + "',studentprogram.`Source`='" + model.Source + "',studentprogram.Author='" + model.Author + "',studentprogram.ImageUrl='" + model.ImageUrl + "',studentprogram.CountryID=" + model.CountryID + ",studentprogram.EducationID=" + model.EducationID + ",studentprogram.TypeID=" + model.TypeID + ",StudentKeyWord='" + model.StudentKeyWord + "',StudentProfile='" + model.StudentProfile + "' where studentprogram.StudentProgramID =" + model.StudentProgramID + ""; int h = MySqlDB.nonquery(sql, CommandType.Text, null); return(h); } catch (Exception ex) { return(0); } }
/// <summary> /// 添加留学规划 /// </summary> /// <param name="model"></param> /// <returns></returns> public int StudentprogramAdd(JiaJiModels.StudentProgram model) { try { string sql = " INSERT into studentprogram(studentprogram.StudentProgramTitle,studentprogram.StudentProgramContent,studentprogram.`Source`,studentprogram.Author,studentprogram.ImageUrl,studentprogram.CountryID,studentprogram.EducationID,studentprogram.TypeID,ReadCount,StudentKeyWord,StudentProfile) values('" + model.StudentProgramTitle + "', '" + model.StudentProgramContent + "', '" + model.Source + "', '" + model.Author + "', '" + model.ImageUrl + "'," + model.CountryID + "," + model.EducationID + "," + model.TypeID + ",0,'" + model.StudentKeyWord + "','" + model.StudentProfile + "') "; int h = MySqlDB.nonquery(sql, CommandType.Text, null); return(h); } catch (Exception ex) { return(0); } }
public JsonResult addSprelation(JiaJiModels.StudentProgram model) { try { model.ImageUrl = "/image/" + model.ImageUrl; var i = new JiaJiBLL.SprelationBll().StudentprogramAdd(model); if (i > 0) { return(Json(new { Success = true, Message = "添加成功" })); } else { return(Json(new { Success = false, Message = "添加失败" })); } } catch { return(Json(new { Success = false, Message = "添加失败" })); } }
public JsonResult editSprelation(JiaJiModels.StudentProgram model) { try { int id = model.StudentProgramID; var i = new JiaJiBLL.SprelationBll().UpdStudentprogram(model); if (i > 0) { return(Json(new { Success = true, Message = "修改成功" })); } else { return(Json(new { Success = false, Message = "修改失败" })); } } catch { return(Json(new { Success = false, Message = "修改失败" })); } }