/// <summary> /// 修改观点 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdOptions(JiaJiModels.OptionModel model) { try { return(new JiaJiDAL.OptionDAL().UpdOptions(model)); } catch (Exception ex) { return(0); } }
/// <summary> /// 修改观点 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdOptions(JiaJiModels.OptionModel model) { try { string sql = "update optioninfo set OptionTitle='" + model.OptionTitle + "',OptionKeyWord='" + model.OptionKeyWord + "',OptionContent='" + model.OptionContent + "',Author='" + model.Author + "',Source='" + model.Source + "',`Date`='" + model.Date + "',OptionUrl='" + model.OptionUrl + "' where OptionID=" + model.OptionID + ""; int he = MySqlDB.nonquery(sql, CommandType.Text, null); return(he); } catch (Exception ex) { return(0); } }
/// <summary> /// 添加嘉际观点 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddOption(JiaJiModels.OptionModel model) { string sql = string.Format("insert into optioninfo(OptionTitle,OptionContent,Author,Source,Date,OptionHot,OptionKeyWord,OptionUrl) VALUES('{0}','{1}','{2}','{3}', '{4}',{5},'{6}','{7}')", model.OptionTitle, model.OptionContent, model.Author, model.Source, model.Date, 0, model.OptionKeyWord, model.OptionUrl); return(MySqlDB.nonquery(sql, System.Data.CommandType.Text, null)); }
/// <summary> /// 添加嘉际观点 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddOption(JiaJiModels.OptionModel model) { return(new JiaJiDAL.OptionDAL().AddOption(model)); }