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