/// <summary>
/// 删除广告
/// </summary>
/// <param name="advId">广告编号</param>
/// <returns></returns>
public virtual bool DeleteAdv(int advId)
{
EyouSoft.Model.AdvStructure.AdvInfo adv = GetAdvInfo(advId);
if (adv != null)
{
DbCommand cmd = base.SystemStore.GetSqlStringCommand("A");
EyouSoft.Model.AdvStructure.AdvDisplayType DisplayType = GetPositionInfo(adv.Position).DisplayType;
if (DisplayType != EyouSoft.Model.AdvStructure.AdvDisplayType.单位图片广告 &&
DisplayType != EyouSoft.Model.AdvStructure.AdvDisplayType.单位图文广告 &&
DisplayType != EyouSoft.Model.AdvStructure.AdvDisplayType.单位文字广告)
{
cmd = base.SystemStore.GetSqlStringCommand(SQL_DELETEDFILE_DELETEMOVE + SQL_DELETE_DeleteAdv);
}
else
{
cmd = base.SystemStore.GetSqlStringCommand(SQL_DELETE_DeleteAdv);
}
base.SystemStore.AddInParameter(cmd, "AdvId", DbType.Int32, advId);
return(DbHelper.ExecuteSql(cmd, base.SystemStore) > 0 ? true : false);
}
else
{
return(false);
}
}
/// <summary>
/// 获取广告信息
/// </summary>
/// <param name="advId">广告编号</param>
/// <returns></returns>
public virtual EyouSoft.Model.AdvStructure.AdvInfo GetAdvInfo(int advId)
{
EyouSoft.Model.AdvStructure.AdvInfo info = null;
DbCommand cmd = base.SystemStore.GetSqlStringCommand(SQL_SELECT_GetAdvInfo);
base.SystemStore.AddInParameter(cmd, "AdvId", DbType.Int32, advId);
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, base.SystemStore))
{
if (rdr.Read())
{
info = new EyouSoft.Model.AdvStructure.AdvInfo();
info.AdvId = advId;
EyouSoft.Model.AdvStructure.AdvDisplayType displayType = (EyouSoft.Model.AdvStructure.AdvDisplayType)rdr.GetByte(rdr.GetOrdinal("DisplayType"));
info.AdvType = displayType == EyouSoft.Model.AdvStructure.AdvDisplayType.MQ广告 ? EyouSoft.Model.AdvStructure.AdvType.MQ : EyouSoft.Model.AdvStructure.AdvType.城市;
info.Category = (EyouSoft.Model.AdvStructure.AdvCategory)rdr.GetByte(rdr.GetOrdinal("ClassId"));
info.CompanyId = rdr.GetString(rdr.GetOrdinal("CompanyId"));
info.CompanyName = rdr["CompanyName"].ToString();
info.ContactInfo = rdr["ContactInfo"].ToString();
info.EndDate = rdr.GetDateTime(rdr.GetOrdinal("EndDate"));
info.ImgPath = rdr["AdvImg"].ToString();
info.AdvThumb = rdr["AdvThumbnail"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId"));
info.OperatorName = rdr["OperatorName"].ToString();
info.Position = (EyouSoft.Model.AdvStructure.AdvPosition)rdr.GetInt32(rdr.GetOrdinal("AreaId"));
info.Range = (EyouSoft.Model.AdvStructure.AdvRange)rdr.GetByte(rdr.GetOrdinal("AdvArea"));
info.RedirectURL = rdr["AdvLink"].ToString();
//info.Relation=
info.Remark = rdr["AdvRemark"].ToString();
info.SortId = 0;
info.StartDate = rdr.GetDateTime(rdr.GetOrdinal("StartDate"));
info.Title = rdr["AdvDescript"].ToString();
}
}
/*if (info != null)
* {
* info.Relation = this.GetAdvRelation(info.AdvId);
* }*/
return(info);
}
/// <summary>
/// 更新广告
/// </summary>
/// <param name="info">广告信息业务实体</param>
/// <returns>1:成功 0:失败</returns>
public virtual int UpdateAdv(EyouSoft.Model.AdvStructure.AdvInfo info)
{
DbCommand cmd = base.SystemStore.GetSqlStringCommand(SQL_DELETEDFILE_UPDATEMOVE);
EyouSoft.Model.AdvStructure.AdvDisplayType DisplayType = GetPositionInfo(info.Position).DisplayType;
if (DisplayType != EyouSoft.Model.AdvStructure.AdvDisplayType.单位图片广告 &&
DisplayType != EyouSoft.Model.AdvStructure.AdvDisplayType.单位图文广告 &&
DisplayType != EyouSoft.Model.AdvStructure.AdvDisplayType.单位文字广告)
{
base.SystemStore.AddInParameter(cmd, "AdvId", DbType.Int32, info.AdvId);
base.SystemStore.AddInParameter(cmd, "AdvImg", DbType.String, info.ImgPath);
DbHelper.ExecuteSql(cmd, base.SystemStore);
}
cmd = base.SystemStore.GetStoredProcCommand("proc_SysAdv_UpdateAdv");
base.SystemStore.AddInParameter(cmd, "AdvId", DbType.Int32, info.AdvId);
base.SystemStore.AddInParameter(cmd, "PositionId", DbType.Int32, info.Position);
base.SystemStore.AddInParameter(cmd, "CategoryId", DbType.Int32, info.Category);
base.SystemStore.AddInParameter(cmd, "Title", DbType.String, info.Title);
base.SystemStore.AddInParameter(cmd, "Remark", DbType.String, info.Remark);
base.SystemStore.AddInParameter(cmd, "RedirectURL", DbType.String, info.RedirectURL);
base.SystemStore.AddInParameter(cmd, "ImgPath", DbType.String, info.ImgPath);
base.SystemStore.AddInParameter(cmd, "AdvThumbnail", DbType.String, info.AdvThumb);
base.SystemStore.AddInParameter(cmd, "CompanyId", DbType.String, info.CompanyId);
base.SystemStore.AddInParameter(cmd, "CompanyName", DbType.String, info.CompanyName);
base.SystemStore.AddInParameter(cmd, "ContactInfo", DbType.String, info.ContactInfo);
base.SystemStore.AddInParameter(cmd, "StartDate", DbType.DateTime, info.StartDate);
base.SystemStore.AddInParameter(cmd, "EndDate", DbType.DateTime, info.EndDate);
base.SystemStore.AddInParameter(cmd, "OperatorId", DbType.Int32, info.OperatorId);
base.SystemStore.AddInParameter(cmd, "OperatorName", DbType.String, info.OperatorName);
base.SystemStore.AddInParameter(cmd, "IssueTime", DbType.DateTime, info.IssueTime);
base.SystemStore.AddInParameter(cmd, "Range", DbType.Int32, info.Range);
base.SystemStore.AddInParameter(cmd, "Relation", DbType.String, this.CreateRelationXML(info.Relation));
base.SystemStore.AddOutParameter(cmd, "Result", DbType.Int32, 4);
DbHelper.ExecuteSql(cmd, base.SystemStore);
return(Convert.ToInt32(base.SystemStore.GetParameterValue(cmd, "Result")));
}
