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