/// <summary>
/// 修改活动
/// </summary>
/// <returns></returns>
public int ActiveUpd(JiaJiModels.Active model)
{
try
{
return(new JiaJiDAL.activedal().ActiveUpd(model));
}
catch (Exception ex)
{
return(0);
}
}
/// <summary>
/// 修改活动
/// </summary>
/// <returns></returns>
public int ActiveUpd(JiaJiModels.Active model)
{
try
{
string sql = "update active set ActiveTitle = '" + model.ActiveTitle + "', ActiveDate = '" + model.ActiveDate + "', Site =" + model.Site + ", Datails = '" + model.Datails + "', ActivePhone = '" + model.ActivePhone + "', CountryID=" + model.CountryID + ",ActiveKeyWord='" + model.ActiveKeyWord + "',ActiveProfile='" + model.ActiveProfile + "' where ActiveID =" + model.ActiveID + " ";
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 Activeadd(JiaJiModels.Active model)
{
try
{
string sql = "insert into active(ActiveTitle,ActiveDate,Site,Datails,ActivePhone,HeatID,CountryID,ActiveKeyWord,ActiveProfile) Values('" + model.ActiveTitle + "','" + model.ActiveDate + "'," + model.Site + ",'" + model.Datails + "','" + model.ActivePhone + "',0," + model.CountryID + ",'" + model.ActiveKeyWord + "','" + model.ActiveProfile + "')";
int h = MySqlDB.nonquery(sql, CommandType.Text, null);
return(h);
}
catch (Exception ex)
{
return(0);
}
}
