/// <summary>
/// 修改版位
/// </summary>
/// <param name="adZone"></param>
/// <returns></returns>
bool ID_Adzone.ADZone_Update(Model.M_Adzone adZone)
{
SqlParameter[] parameter = null;
this.GetAdzoneParameter(adZone, ref parameter);
return(SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "dt_ADZone_Upadte", parameter) > 0);
}
/// <summary>
/// 删除某个广告所在的版位
/// </summary>
/// <param name="ADID"></param>
/// <returns></returns>
bool ID_Adzone.Delete_ADZone_Ad(string ADID)
{
string str = "delete from ZL_Zone_Advertisement where ADID=" + ADID;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, str, null) > 0);
}
/// <summary>
/// 批量激活
/// </summary>
/// <param name="ZoneIds"></param>
/// <returns></returns>
bool ID_Adzone.BatchActive(string ZoneIds)
{
string strSql = "Update ZL_AdZone Set Active=1 Where ZoneID in (" + ZoneIds + ")";
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSql, null) > 0);
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="ZoneIds"></param>
/// <returns></returns>
bool ID_Adzone.BatchRemove(string ZoneIds)
{
string strSql = "Delete from ZL_AdZone Where ZoneID in (" + ZoneIds + ")";
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSql, null) > 0);
}
