public IList <AdvertisementInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms)
{
string cmdText = @"select Id,Title,SiteFunId,LayoutPositionId,Timeout,LastUpdatedDate
from Advertisement";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += " where 1=1 " + sqlWhere;
}
IList <AdvertisementInfo> list = new List <AdvertisementInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
AdvertisementInfo model = new AdvertisementInfo();
model.Id = reader.GetGuid(0);
model.Title = reader.GetString(1);
model.SiteFunId = reader.GetGuid(2);
model.LayoutPositionId = reader.GetGuid(3);
model.Timeout = reader.GetInt32(4);
model.LastUpdatedDate = reader.GetDateTime(5);
list.Add(model);
}
}
}
return(list);
}
public int Insert(AdvertisementInfo model)
{
string cmdText = @"insert into Advertisement (Id,Title,SiteFunId,LayoutPositionId,Timeout,LastUpdatedDate)
values
(@Id,@Title,@SiteFunId,@LayoutPositionId,@Timeout,@LastUpdatedDate)
" ;
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@SiteFunId", SqlDbType.UniqueIdentifier),
new SqlParameter("@LayoutPositionId", SqlDbType.UniqueIdentifier),
new SqlParameter("@Timeout", SqlDbType.Int),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = Guid.Parse(model.Id.ToString());
parms[1].Value = model.Title;
parms[2].Value = model.SiteFunId;
parms[3].Value = model.LayoutPositionId;
parms[4].Value = model.Timeout;
parms[5].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
public IList <AdvertisementInfo> GetListByJoin(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms)
{
string cmdText = @"select count(1)
from Advertisement ad
left join ContentType at on at.Id = ad.SiteFunId
left join ContentType at1 on at1.Id = ad.LayoutPositionId
";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += " where 1=1 " + sqlWhere;
}
totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms);
if (totalRecords == 0)
{
return(new List <AdvertisementInfo>());
}
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
cmdText = @"select * from(select row_number() over(order by ad.LastUpdatedDate desc) as RowNumber,
ad.Id,ad.Title,ad.SiteFunId,ad.LayoutPositionId,ad.Timeout,ad.LastUpdatedDate,
at.TypeCode as SiteFunName,at1.TypeCode as LayoutPositionName
from Advertisement ad
left join ContentType at on at.Id = ad.SiteFunId
left join ContentType at1 on at1.Id = ad.LayoutPositionId
";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " ";
IList <AdvertisementInfo> list = new List <AdvertisementInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
AdvertisementInfo model = new AdvertisementInfo();
model.Id = reader.GetGuid(1);
model.Title = reader.GetString(2);
model.SiteFunId = reader.GetGuid(3);
model.LayoutPositionId = reader.GetGuid(4);
model.Timeout = reader.GetInt32(5);
model.LastUpdatedDate = reader.GetDateTime(6);
model.SiteFunName = reader.IsDBNull(7) ? "" : reader.GetString(7);
model.LayoutPositionName = reader.IsDBNull(8) ? "" : reader.GetString(8);
list.Add(model);
}
}
}
return(list);
}
public bool Validate_InsertScreenDownAdvertisement(out string errorMessage)
{
var adInfo = new AdvertisementInfo(AdvertisementName.Text, PublishmentSystemId, EAdvertisementTypeUtils.GetEnumType(AdvertisementType.SelectedValue), IsDateLimited.Checked, TranslateUtils.ToDateTime(StartDate.Text), TranslateUtils.ToDateTime(EndDate.Text), DateTime.Now, ControlUtils.GetSelectedListControlValueCollection(NodeIDCollectionToChannel), ControlUtils.GetSelectedListControlValueCollection(NodeIDCollectionToContent), ControlUtils.GetSelectedListControlValueCollection(FileTemplateIDCollection), string.Empty);
var adScreenDownInfo = new AdvertisementScreenDownInfo(ScreenDownNavigationUrl.Text, ScreenDownImageUrl.Text, TranslateUtils.ToInt(ScreenDownDelay.Text), TranslateUtils.ToInt(ScreenDownHeight.Text), TranslateUtils.ToInt(ScreenDownWidth.Text));
adInfo.Settings = adScreenDownInfo.ToString();
try
{
if (isEdit)
{
DataProvider.AdvertisementDao.Update(adInfo);
}
else
{
DataProvider.AdvertisementDao.Insert(adInfo);
}
errorMessage = string.Empty;
return(true);
}
catch
{
errorMessage = "操作失败！";
return(false);
}
}
public AdvertisementInfo GetModel(object Id)
{
AdvertisementInfo model = null;
string cmdText = @"select top 1 Id,Title,SiteFunId,LayoutPositionId,Timeout,LastUpdatedDate
from Advertisement
where Id = @Id " ;
SqlParameter parm = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
parm.Value = Guid.Parse(Id.ToString());
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parm))
{
if (reader != null)
{
while (reader.Read())
{
model = new AdvertisementInfo();
model.Id = reader.GetGuid(0);
model.Title = reader.GetString(1);
model.SiteFunId = reader.GetGuid(2);
model.LayoutPositionId = reader.GetGuid(3);
model.Timeout = reader.GetInt32(4);
model.LastUpdatedDate = reader.GetDateTime(5);
}
}
}
return(model);
}
private string GetDisplay(int siteId, AdvertisementInfo adInfo)
{
var builder = new StringBuilder();
if (!string.IsNullOrEmpty(adInfo.ChannelIdCollectionToChannel))
{
builder.Append("栏目：");
var channelIdArrayList = Utils.StringCollectionToIntList(adInfo.ChannelIdCollectionToChannel);
foreach (var channelId in channelIdArrayList)
{
builder.Append(Context.ChannelApi.GetChannelName(siteId, channelId));
builder.Append(",");
}
builder.Length--;
}
if (!string.IsNullOrEmpty(adInfo.ChannelIdCollectionToContent))
{
if (builder.Length > 0)
{
builder.Append(" | ");
}
builder.Append("内容：");
var channelIdList = Utils.StringCollectionToIntList(adInfo.ChannelIdCollectionToContent);
foreach (var channelId in channelIdList)
{
builder.Append(Context.ChannelApi.GetChannelName(siteId, channelId));
builder.Append(",");
}
builder.Length--;
}
return(builder.ToString());
}
public bool Validate_InsertFloatImageAdvertisement(out string errorMessage)
{
var adInfo = new AdvertisementInfo(AdvertisementName.Text, PublishmentSystemId, EAdvertisementTypeUtils.GetEnumType(AdvertisementType.SelectedValue), IsDateLimited.Checked, TranslateUtils.ToDateTime(StartDate.Text), TranslateUtils.ToDateTime(EndDate.Text), DateTime.Now, ControlUtils.GetSelectedListControlValueCollection(NodeIDCollectionToChannel), ControlUtils.GetSelectedListControlValueCollection(NodeIDCollectionToContent), ControlUtils.GetSelectedListControlValueCollection(FileTemplateIDCollection), string.Empty);
var adFloatImageInfo = new AdvertisementFloatImageInfo(IsCloseable.Checked, EPositionTypeUtils.GetEnumType(PositionType.SelectedValue), TranslateUtils.ToInt(PositionX.Text), TranslateUtils.ToInt(PositionY.Text), ERollingTypeUtils.GetEnumType(RollingType.SelectedValue), NavigationUrl.Text, ImageUrl.Text, TranslateUtils.ToInt(Height.Text), TranslateUtils.ToInt(Width.Text));
adInfo.Settings = adFloatImageInfo.ToString();
try
{
if (isEdit)
{
DataProvider.AdvertisementDao.Update(adInfo);
Body.AddSiteLog(PublishmentSystemId, "修改漂浮广告", $"广告名称：{adInfo.AdvertisementName}");
}
else
{
DataProvider.AdvertisementDao.Insert(adInfo);
Body.AddSiteLog(PublishmentSystemId, "新增漂浮广告", $"广告名称：{adInfo.AdvertisementName}");
}
errorMessage = string.Empty;
return(true);
}
catch
{
errorMessage = "操作失败！";
return(false);
}
}
private static Parameters GetParameters(AdvertisementInfo advertisementInfo)
{
Parameters parameters = new Parameters();
parameters.AddInParameter("@ADID", DbType.Int32, advertisementInfo.ADId);
parameters.AddInParameter("@strZoneID", DbType.String, advertisementInfo.ZoneId);
parameters.AddInParameter("@UserID", DbType.Int32, advertisementInfo.UserId);
parameters.AddInParameter("@ADType", DbType.Int32, advertisementInfo.ADType);
parameters.AddInParameter("@ADName", DbType.String, advertisementInfo.ADName);
parameters.AddInParameter("@ImgUrl", DbType.String, advertisementInfo.ImgUrl);
parameters.AddInParameter("@ImgWidth", DbType.Int32, advertisementInfo.ImgWidth);
parameters.AddInParameter("@ImgHeight", DbType.Int32, advertisementInfo.ImgHeight);
parameters.AddInParameter("@FlashWmode", DbType.Int32, advertisementInfo.FlashWmode);
parameters.AddInParameter("@ADIntro", DbType.String, advertisementInfo.ADIntro);
parameters.AddInParameter("@LinkUrl", DbType.String, advertisementInfo.LinkUrl);
parameters.AddInParameter("@LinkTarget", DbType.Int32, advertisementInfo.LinkTarget);
parameters.AddInParameter("@LinkAlt", DbType.String, advertisementInfo.LinkAlt);
parameters.AddInParameter("@Priority", DbType.Int32, advertisementInfo.Priority);
parameters.AddInParameter("@Setting", DbType.String, advertisementInfo.Setting);
parameters.AddInParameter("@CountView", DbType.Boolean, advertisementInfo.CountView);
parameters.AddInParameter("@Views", DbType.Int32, advertisementInfo.Views);
parameters.AddInParameter("@CountClick", DbType.Boolean, advertisementInfo.CountClick);
parameters.AddInParameter("@Clicks", DbType.Int32, advertisementInfo.Clicks);
parameters.AddInParameter("@Passed", DbType.Boolean, advertisementInfo.Passed);
parameters.AddInParameter("@OverdueDate", DbType.DateTime, advertisementInfo.OverdueDate);
return(parameters);
}
protected override void Render(HtmlTextWriter writer)
{
string strB = BasePage.RequestString("Action");
AdvertisementInfo advertisementById = Advertisement.GetAdvertisementById(BasePage.RequestInt32("AdId"));
if (!advertisementById.IsNull)
{
if (advertisementById.CountView)
{
advertisementById.Views++;
}
if (string.Compare("Click", strB, StringComparison.OrdinalIgnoreCase) == 0)
{
if (advertisementById.CountClick)
{
advertisementById.Clicks++;
}
if (!string.IsNullOrEmpty(advertisementById.LinkUrl))
{
this.srcript = "<script language='javascript' type='text/javascript'>window.location='" + advertisementById.LinkUrl + "';</script>";
}
}
Advertisement.Update(advertisementById);
writer.Write(this.srcript);
}
}
public AdvertisementInfo GetAdvertisement(string id)
{
logger.Debug(Settings.MethodName());
logger.Trace("Parameters: id: " + id);
AdvertisementInfo advertisementInfo = new AdvertisementInfo();
if (isCorrectUser(id))
{
try
{
S_Advert advert = AdvertManager.GetRandomAdvert();
if (advert != null)
{
advertisementInfo.advertisement = advert.advertisement;
advertisementInfo.advertisement_url = Conversion.UriToEscapedUri(advert.advertisement_url);
advertisementInfo.advertisement_www = Conversion.UriToEscapedUri(advert.advertisement_www);
}
}
catch
{
}
}
logger.Trace("Return: advertisement: " + advertisementInfo.advertisement);
logger.Trace("Return: advertisement_url: " + advertisementInfo.advertisement_url);
logger.Trace("Return: advertisement_www: " + advertisementInfo.advertisement_www);
return(advertisementInfo);
}
private static AdvertisementInfo AdvertisementFromrdr(NullableDataReader rdr)
{
AdvertisementInfo info = new AdvertisementInfo();
info.ADId = rdr.GetInt32("ADID");
info.UserId = rdr.GetInt32("UserID");
info.ADType = rdr.GetInt32("ADType");
info.ADName = rdr.GetString("ADName");
info.ImgUrl = rdr.GetString("ImgUrl");
info.ImgWidth = rdr.GetInt32("ImgWidth");
info.ImgHeight = rdr.GetInt32("ImgHeight");
info.FlashWmode = rdr.GetInt32("FlashWmode");
info.ADIntro = rdr.GetString("ADIntro");
info.LinkUrl = rdr.GetString("LinkUrl");
info.LinkTarget = rdr.GetInt32("LinkTarget");
info.LinkAlt = rdr.GetString("LinkAlt");
info.Priority = rdr.GetInt32("Priority");
info.Setting = rdr.GetString("Setting");
info.CountView = rdr.GetBoolean("CountView");
info.Views = rdr.GetInt32("Views");
info.CountClick = rdr.GetBoolean("CountClick");
info.Clicks = rdr.GetInt32("Clicks");
info.Passed = rdr.GetBoolean("Passed");
info.OverdueDate = rdr.GetDateTime("OverdueDate");
return(info);
}
public IList <AdvertisementInfo> GetList()
{
string cmdText = @"select Id,Title,SiteFunId,LayoutPositionId,Timeout,LastUpdatedDate
from Advertisement
order by LastUpdatedDate desc " ;
IList <AdvertisementInfo> list = new List <AdvertisementInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
AdvertisementInfo model = new AdvertisementInfo();
model.Id = reader.GetGuid(0);
model.Title = reader.GetString(1);
model.SiteFunId = reader.GetGuid(2);
model.LayoutPositionId = reader.GetGuid(3);
model.Timeout = reader.GetInt32(4);
model.LastUpdatedDate = reader.GetDateTime(5);
list.Add(model);
}
}
}
return(list);
}
public Guid InsertByOutput(AdvertisementInfo model)
{
string cmdText = @"insert into Advertisement (Title,SiteFunId,LayoutPositionId,Timeout,LastUpdatedDate)
output inserted.Id values
(@Title,@SiteFunId,@LayoutPositionId,@Timeout,@LastUpdatedDate)
" ;
SqlParameter[] parms =
{
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@SiteFunId", SqlDbType.UniqueIdentifier),
new SqlParameter("@LayoutPositionId", SqlDbType.UniqueIdentifier),
new SqlParameter("@Timeout", SqlDbType.Int),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.Title;
parms[1].Value = model.SiteFunId;
parms[2].Value = model.LayoutPositionId;
parms[3].Value = model.Timeout;
parms[4].Value = model.LastUpdatedDate;
object obj = SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms);
if (obj != null)
{
return(Guid.Parse(obj.ToString()));
}
return(Guid.Empty);
}
protected void GdvAD_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
AdvertisementInfo dataItem = (AdvertisementInfo)e.Row.DataItem;
Label label = (Label)e.Row.FindControl("LabViews");
Label label2 = (Label)e.Row.FindControl("LabClicks");
Label label3 = (Label)e.Row.FindControl("LabDays");
HyperLink link = (HyperLink)e.Row.FindControl("HypPreview");
link.NavigateUrl = "PreviewAD.aspx?Type=Ad&AdId=" + dataItem.ADId;
Label label4 = (Label)e.Row.FindControl("LabRate");
if (dataItem.Clicks == 0)
{
label4.Text = "0%";
}
else if (dataItem.Views == 0)
{
label4.Text = "100%";
}
else
{
label4.Text = (((((float)dataItem.Clicks) / ((float)dataItem.Views)) * 100f)).ToString() + "%";
}
if (dataItem.ADType == 4)
{
link.Attributes.Add("onmouseover", "ShowADPreview(' 代码广告请点击预览 ')");
}
else
{
link.Attributes.Add("onmouseover", "ShowADPreview('" + Advertisement.GetAdContent(dataItem) + "')");
}
link.Attributes.Add("onmouseout", "hideTooltip('dHTMLADPreview')");
if (dataItem.CountClick)
{
label2.Text = dataItem.Clicks.ToString();
}
else
{
label2.Text = "<font color='#999999'>不统计</font>";
}
if (dataItem.CountView)
{
label.Text = dataItem.Views.ToString();
}
else
{
label.Text = "<font color='#999999'>不统计</font>";
}
if (dataItem.Days >= 0)
{
label3.Text = dataItem.Days.ToString() + "天";
}
else
{
label3.Text = "<font color=\"red\">已经过期</font>";
}
}
}
public IList <AdvertisementInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms)
{
StringBuilder sb = new StringBuilder(250);
sb.Append(@"select count(*) from Advertisement ");
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms);
if (totalRecords == 0)
{
return(new List <AdvertisementInfo>());
}
sb.Clear();
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber,
Id,Title,SiteFunId,LayoutPositionId,Timeout,Sort,StartTime,EndTime,VirtualViewCount,ViewCount,IsDisable,LastUpdatedDate
from Advertisement " );
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex);
IList <AdvertisementInfo> list = new List <AdvertisementInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
AdvertisementInfo model = new AdvertisementInfo();
model.Id = reader.GetGuid(1);
model.Title = reader.GetString(2);
model.SiteFunId = reader.GetGuid(3);
model.LayoutPositionId = reader.GetGuid(4);
model.Timeout = reader.GetInt32(5);
model.Sort = reader.GetInt32(6);
model.StartTime = reader.GetDateTime(7);
model.EndTime = reader.GetDateTime(8);
model.VirtualViewCount = reader.GetInt32(9);
model.ViewCount = reader.GetInt32(10);
model.IsDisable = reader.GetBoolean(11);
model.LastUpdatedDate = reader.GetDateTime(12);
list.Add(model);
}
}
}
return(list);
}
public static DataActionState Update(AdvertisementInfo advertisementInfo)
{
DataActionState unknown = DataActionState.Unknown;
if (dal.Update(advertisementInfo))
{
unknown = DataActionState.Successed;
}
return(unknown);
}
public FloatingScript(PublishmentSystemInfo publishmentSystemInfo, int uniqueID, AdvertisementInfo adInfo)
{
this.publishmentSystemInfo = publishmentSystemInfo;
this.adInfo = adInfo;
adFloatImageInfo = new AdvertisementFloatImageInfo(this.adInfo.Settings);
this.uniqueID = uniqueID;
floatDivIsCloseableHtml = (adFloatImageInfo.IsCloseable) ?
$@"<div style=""text-align:right; line-height:22px;""><a href=""javascript:;"" onclick=""document.getElementById('ad_{this
.uniqueID}').style.display='none'"" style=""text-decoration:underline"">关闭<a></div>"
: string.Empty;
}
protected void Page_Load(object sender, EventArgs e)
{
AdvertisementInfo advertisementById = Advertisement.GetAdvertisementById(BasePage.RequestInt32("AdId"));
if (!advertisementById.IsNull)
{
this.LabAdShow.Text = Advertisement.GetAdContent(advertisementById);
if (advertisementById.CountClick)
{
advertisementById.Clicks++;
}
if (advertisementById.CountView)
{
advertisementById.Views++;
}
Advertisement.Update(advertisementById);
}
}
public AdvertisementInfo GetAdvertisementById(int id)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@ADId", DbType.Int32, id);
string zondIdList = GetZondIdList(id);
using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT * FROM PE_Advertisement WHERE AdId = @ADId", cmdParams))
{
if (reader.Read())
{
AdvertisementInfo info = AdvertisementFromrdr(reader);
info.ZoneId = zondIdList;
return(info);
}
return(new AdvertisementInfo(true));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
if (BasePage.RequestString("Action") == "Modify")
{
int id = BasePage.RequestInt32("AdId");
AdvertisementInfo advertisementInfo = new AdvertisementInfo();
advertisementInfo = Advertisement.GetAdvertisementById(id);
this.TxtADName.Text = advertisementInfo.ADName;
this.TxtPriority.Text = advertisementInfo.Priority.ToString();
this.DpkOverdueDate.Text = advertisementInfo.OverdueDate.ToString("yyyy-MM-dd");
this.InitRadlAdType(advertisementInfo.ADType);
this.InitShowPanel(advertisementInfo);
this.HdnAction.Value = "Modify";
this.HdnAdId.Value = advertisementInfo.ADId.ToString();
this.InitLstZoneName();
this.SetLstZoneNameSelected(advertisementInfo.ZoneId);
this.ChkCountClick.Checked = advertisementInfo.CountClick;
this.ChkCountView.Checked = advertisementInfo.CountView;
this.TxtClicks.Text = advertisementInfo.Clicks.ToString();
this.TxtViews.Text = advertisementInfo.Views.ToString();
this.InitJSScript();
if (advertisementInfo.ADType > 1)
{
this.ChkCountClick.Enabled = false;
this.TxtClicks.Enabled = false;
}
this.ChkPassed.Checked = advertisementInfo.Passed;
}
else
{
this.InitLstZoneName();
this.DpkOverdueDate.Text = DateTime.Now.AddMonths(1).ToString("yyyy-MM-dd");
if (!string.IsNullOrEmpty(BasePage.RequestString("ZoneId")))
{
string ids = BasePage.RequestString("ZoneId") + ",";
this.SetLstZoneNameSelected(ids);
}
this.InitJSScript();
this.InitRadlAdType(1);
}
}
}
public AdvertisementInfo GetModelByJoin(object Id)
{
AdvertisementInfo model = null;
string cmdText = @"select top 1 ad.Id,ad.Title,ad.SiteFunId,ad.LayoutPositionId,ad.Timeout,ad.Sort,ad.StartTime,ad.EndTime,ad.VirtualViewCount,ad.ViewCount,ad.IsDisable,ad.LastUpdatedDate,
at.TypeCode as SiteFunName,at1.TypeCode as LayoutPositionName,adi.Descr,adi.ContentText
from Advertisement ad
left join ContentType at on at.Id = ad.SiteFunId
left join ContentType at1 on at1.Id = ad.LayoutPositionId
left join AdvertisementItem adi on adi.AdvertisementId = ad.Id
where ad.Id = @Id " ;
SqlParameter parm = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
parm.Value = Guid.Parse(Id.ToString());
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parm))
{
if (reader != null)
{
while (reader.Read())
{
model = new AdvertisementInfo();
model.Id = reader.GetGuid(0);
model.Title = reader.GetString(1);
model.SiteFunId = reader.GetGuid(2);
model.LayoutPositionId = reader.GetGuid(3);
model.Timeout = reader.GetInt32(4);
model.Sort = reader.GetInt32(5);
model.StartTime = reader.GetDateTime(6);
model.EndTime = reader.GetDateTime(7);
model.VirtualViewCount = reader.GetInt32(8);
model.ViewCount = reader.GetInt32(9);
model.IsDisable = reader.GetBoolean(10);
model.LastUpdatedDate = reader.GetDateTime(11);
model.SiteFunName = reader.IsDBNull(12) ? "" : reader.GetString(12);
model.LayoutPositionName = reader.IsDBNull(13) ? "" : reader.GetString(13);
model.Descr = reader.IsDBNull(14) ? "" : reader.GetString(14);
model.ContentText = reader.IsDBNull(15) ? "" : reader.GetString(15);
}
}
}
return(model);
}
public void CreateJS(ADZoneInfo adZoneInfo, IList <AdvertisementInfo> advertisementInfoList)
{
this.zoneInfo = adZoneInfo;
StringBuilder builder = new StringBuilder(this.GetZoneJSTemplate());
builder.Append("var ZoneAD_" + adZoneInfo.ZoneId + "=new ");
builder.Append(string.Concat(new object[] { this.zoneConfig[adZoneInfo.ZoneType], "ZoneAD(\"ZoneAD_", adZoneInfo.ZoneId, "\");" }));
for (int i = 0; i < advertisementInfoList.Count; i++)
{
this.advertisementInfo = advertisementInfoList[i];
this.advertisementInfo.ZoneId = adZoneInfo.ZoneId.ToString(CultureInfo.CurrentCulture);
if (this.advertisementInfo.Passed && (this.advertisementInfo.Days >= 0))
{
builder.Append(this.CreatAdvertisementJS());
}
}
builder.Append(this.CreateADZoneJS());
FileSystemObject.WriteFile(VirtualPathUtility.AppendTrailingSlash(HttpContext.Current.Server.MapPath("~/" + SiteConfig.SiteOption.AdvertisementDir)) + adZoneInfo.ZoneJSName, builder.ToString());
}
public int Insert(AdvertisementInfo model)
{
if (IsExist(model.Title, null))
{
return(110);
}
StringBuilder sb = new StringBuilder(250);
sb.Append(@"insert into Advertisement (Id,Title,SiteFunId,LayoutPositionId,Timeout,Sort,StartTime,EndTime,VirtualViewCount,IsDisable,LastUpdatedDate)
values
(@Id,@Title,@SiteFunId,@LayoutPositionId,@Timeout,@Sort,@StartTime,@EndTime,@VirtualViewCount,@IsDisable,@LastUpdatedDate)
" );
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@SiteFunId", SqlDbType.UniqueIdentifier),
new SqlParameter("@LayoutPositionId", SqlDbType.UniqueIdentifier),
new SqlParameter("@Timeout", SqlDbType.Int),
new SqlParameter("@Sort", SqlDbType.Int),
new SqlParameter("@StartTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@VirtualViewCount", SqlDbType.Int),
new SqlParameter("@IsDisable", SqlDbType.Bit),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = Guid.Parse(model.Id.ToString());
parms[1].Value = model.Title;
parms[2].Value = model.SiteFunId;
parms[3].Value = model.LayoutPositionId;
parms[4].Value = model.Timeout;
parms[5].Value = model.Sort;
parms[6].Value = model.StartTime;
parms[7].Value = model.EndTime;
parms[8].Value = model.VirtualViewCount;
parms[9].Value = model.IsDisable;
parms[10].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), parms));
}
public void Update(AdvertisementInfo adInfo)
{
var adParms = new IDataParameter[]
{
GetParameter(ParmAdType, EDataType.VarChar, 50, EAdvertisementTypeUtils.GetValue(adInfo.AdvertisementType)),
GetParameter(ParmIsDateLimited, EDataType.VarChar, 18, adInfo.IsDateLimited.ToString()),
GetParameter(ParmStartDate, EDataType.DateTime, adInfo.StartDate),
GetParameter(ParmEndDate, EDataType.DateTime, adInfo.EndDate),
GetParameter(ParmNodeIdCollectionToChannel, EDataType.NVarChar, 255, adInfo.NodeIDCollectionToChannel),
GetParameter(ParmNodeIdCollectionToContent, EDataType.NVarChar, 255, adInfo.NodeIDCollectionToContent),
GetParameter(ParmFileTemplateIdCollection, EDataType.NVarChar, 255, adInfo.FileTemplateIDCollection),
GetParameter(ParmSettings, EDataType.NText, adInfo.Settings),
GetParameter(ParmAdName, EDataType.VarChar, 50, adInfo.AdvertisementName),
GetParameter(ParmPublishmentsystemid, EDataType.Integer, adInfo.PublishmentSystemID)
};
ExecuteNonQuery(SqlUpdateAd, adParms);
AdvertisementManager.RemoveCache(adInfo.PublishmentSystemID);
}
private void InitShowPanel(AdvertisementInfo advertisementInfo)
{
switch (advertisementInfo.ADType)
{
case 1:
this.ADContent_1.Attributes.Add("style", "display: ");
this.FileUploadControl1.FilePath = advertisementInfo.ImgUrl;
this.TxtImgWidth.Text = advertisementInfo.ImgWidth.ToString();
this.TxtImgHeight.Text = advertisementInfo.ImgHeight.ToString();
this.TxtLinkUrl.Text = advertisementInfo.LinkUrl;
this.TxtLinkAlt.Text = advertisementInfo.LinkAlt;
BasePage.SetSelectedIndexByValue(this.RadlLinkTarget, advertisementInfo.LinkTarget.ToString());
this.TxtADIntro.Text = advertisementInfo.ADIntro;
return;
case 2:
this.ADContent_2.Attributes.Add("style", "display: ");
this.ExtenFileUpload.FilePath = advertisementInfo.ImgUrl;
this.TxtFlashWidth.Text = advertisementInfo.ImgWidth.ToString();
this.TxtFlashHeight.Text = advertisementInfo.ImgHeight.ToString();
BasePage.SetSelectedIndexByValue(this.RadlFlashMode, advertisementInfo.FlashWmode.ToString());
return;
case 3:
this.ADContent_3.Attributes.Add("style", "display: ");
this.TxtADText.Text = advertisementInfo.ADIntro;
return;
case 4:
this.ADContent_4.Attributes.Add("style", "display: ");
this.TxtADCode.Text = advertisementInfo.ADIntro;
return;
case 5:
this.ADContent_5.Attributes.Add("style", "display: ");
this.TxtWebFileUrl.Text = advertisementInfo.ADIntro;
return;
}
this.ADContent_1.Attributes.Add("style", "display: ");
}
public IList <AdvertisementInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms)
{
StringBuilder sb = new StringBuilder(250);
sb.Append(@"select Id,Title,SiteFunId,LayoutPositionId,Timeout,Sort,StartTime,EndTime,VirtualViewCount,ViewCount,IsDisable,LastUpdatedDate
from Advertisement ");
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
IList <AdvertisementInfo> list = new List <AdvertisementInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
AdvertisementInfo model = new AdvertisementInfo();
model.Id = reader.GetGuid(0);
model.Title = reader.GetString(1);
model.SiteFunId = reader.GetGuid(2);
model.LayoutPositionId = reader.GetGuid(3);
model.Timeout = reader.GetInt32(4);
model.Sort = reader.GetInt32(5);
model.StartTime = reader.GetDateTime(6);
model.EndTime = reader.GetDateTime(7);
model.VirtualViewCount = reader.GetInt32(8);
model.ViewCount = reader.GetInt32(9);
model.IsDisable = reader.GetBoolean(10);
model.LastUpdatedDate = reader.GetDateTime(11);
list.Add(model);
}
}
}
return(list);
}
public AdvertisementInfo GetAdvertisementInfo(string advertisementName, int publishmentSystemId)
{
AdvertisementInfo adInfo = null;
var parms = new IDataParameter[]
{
GetParameter(ParmAdName, EDataType.VarChar, 50, advertisementName),
GetParameter(ParmPublishmentsystemid, EDataType.Integer, publishmentSystemId)
};
using (var rdr = ExecuteReader(SqlSelectAd, parms))
{
if (rdr.Read())
{
var i = 0;
adInfo = new AdvertisementInfo(GetString(rdr, i++), GetInt(rdr, i++), EAdvertisementTypeUtils.GetEnumType(GetString(rdr, i++)), GetBool(rdr, i++), GetDateTime(rdr, i++), GetDateTime(rdr, i++), GetDateTime(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetString(rdr, i));
}
rdr.Close();
}
return(adInfo);
}
public IList <AdvertisementInfo> GetList(int pageIndex, int pageSize, string sqlWhere, params SqlParameter[] cmdParms)
{
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
string cmdText = @"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber,
Id,Title,SiteFunId,LayoutPositionId,Timeout,LastUpdatedDate
from Advertisement" ;
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += " where 1=1 " + sqlWhere;
}
cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " ";
IList <AdvertisementInfo> list = new List <AdvertisementInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
AdvertisementInfo model = new AdvertisementInfo();
model.Id = reader.GetGuid(1);
model.Title = reader.GetString(2);
model.SiteFunId = reader.GetGuid(3);
model.LayoutPositionId = reader.GetGuid(4);
model.Timeout = reader.GetInt32(5);
model.LastUpdatedDate = reader.GetDateTime(6);
list.Add(model);
}
}
}
return(list);
}
public AdvertisementInfo GetModel(object Id)
{
AdvertisementInfo model = null;
StringBuilder sb = new StringBuilder(300);
sb.Append(@"select top 1 Id,Title,SiteFunId,LayoutPositionId,Timeout,Sort,StartTime,EndTime,VirtualViewCount,ViewCount,IsDisable,LastUpdatedDate
from Advertisement
where Id = @Id " );
SqlParameter parm = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
parm.Value = Guid.Parse(Id.ToString());
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, sb.ToString(), parm))
{
if (reader != null)
{
while (reader.Read())
{
model = new AdvertisementInfo();
model.Id = reader.GetGuid(0);
model.Title = reader.GetString(1);
model.SiteFunId = reader.GetGuid(2);
model.LayoutPositionId = reader.GetGuid(3);
model.Timeout = reader.GetInt32(4);
model.Sort = reader.GetInt32(5);
model.StartTime = reader.GetDateTime(6);
model.EndTime = reader.GetDateTime(7);
model.VirtualViewCount = reader.GetInt32(8);
model.ViewCount = reader.GetInt32(9);
model.IsDisable = reader.GetBoolean(10);
model.LastUpdatedDate = reader.GetDateTime(11);
}
}
}
return(model);
}
public int Update(AdvertisementInfo model)
{
string cmdText = @"update Advertisement set Title = @Title,SiteFunId = @SiteFunId,LayoutPositionId = @LayoutPositionId,Timeout = @Timeout,LastUpdatedDate = @LastUpdatedDate
where Id = @Id" ;
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@SiteFunId", SqlDbType.UniqueIdentifier),
new SqlParameter("@LayoutPositionId", SqlDbType.UniqueIdentifier),
new SqlParameter("@Timeout", SqlDbType.Int),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.Id;
parms[1].Value = model.Title;
parms[2].Value = model.SiteFunId;
parms[3].Value = model.LayoutPositionId;
parms[4].Value = model.Timeout;
parms[5].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
