/// <summary> /// 修改攻略信息 /// </summary> /// <param name="stat"></param> /// <returns></returns> public int Updatestrategy(JiaJiModels.strategy stat) { try { return(new JiaJiDAL.strategydal().Updatestrategy(stat)); } catch (Exception ex) { var s = ex; return(0); } }
/// <summary> /// 修改攻略信息 /// </summary> /// <param name="stat"></param> /// <returns></returns> public int Updatestrategy(JiaJiModels.strategy stat) { try { string sql = "update strategy set strategyTitle = '" + stat.StrategyTitle + "',strategyContent = '" + stat.StrategyContent + "',strategyDate = '" + stat.StrategyDate + "',CountryID =" + stat.CountryID + ",Img = '" + stat.Img + "',StrategyProfile='" + stat.StrategyProfile + "',StrategyKeyWord='" + stat.StrategyKeyWord + "',StrategyAuthor='" + stat.StrategyAuthor + "' where StrategyID =" + stat.StrategyID + " "; int h = MySqlDB.nonquery(sql, CommandType.Text, null); return(h); } catch (Exception ex) { return(0); } }
/// <summary> /// 添加攻略信息 /// </summary> /// <param name="stat"></param> /// <returns></returns> public int addstat(JiaJiModels.strategy stat) { try { string sql = "INSERT into strategy(strategyTitle,strategyContent,strategyDate,CountryID,Img,StrategyProfile,StrategyKeyWord,StrategyReadCount,StrategyAuthor)VALUES('" + stat.StrategyTitle + "','" + stat.StrategyContent + "','" + stat.StrategyDate + "'," + stat.CountryID + ",'" + stat.Img + "','" + stat.StrategyProfile + "','" + stat.StrategyKeyWord + "',0,'" + stat.StrategyAuthor + "')"; int h = MySqlDB.nonquery(sql, CommandType.Text, null); return(h); } catch (Exception ex) { var s = ex; return(0); } }
/// <summary> /// 攻略添加 /// </summary> /// <param name="stat"></param> /// <returns></returns> public int addstat(JiaJiModels.strategy stat) { return(new JiaJiDAL.strategydal().addstat(stat)); }