public M_Advertisement GetModelFromReader(DataRow rdr) { M_Advertisement model = new M_Advertisement(); model.ADID = Convert.ToInt32(rdr["ADID"]); model.UserID = Convert.ToInt32(rdr["UserID"]); model.ADType = ConvertToInt(rdr["ADType"]); model.ADName = ConverToStr(rdr["ADName"]); model.ImgUrl = ConverToStr(rdr["ImgUrl"]); model.ImgWidth = ConverToStr(rdr["ImgWidth"]); model.ImgHeight = ConverToStr(rdr["ImgHeight"]); model.FlashWmode = ConvertToInt(rdr["FlashWmode"]); model.ADIntro = ConverToStr(rdr["ADIntro"]); model.LinkUrl = ConverToStr(rdr["LinkUrl"]); model.LinkTarget = ConvertToInt(rdr["LinkTarget"]); model.LinkAlt = ConverToStr(rdr["LinkAlt"]); model.Priority = ConvertToInt(rdr["Priority"]); model.Setting = ConverToStr(rdr["Setting"]); model.CountView = Convert.ToBoolean(rdr["CountView"]); model.Views = ConvertToInt(rdr["Views"]); model.CountClick = ConverToBool(rdr["CountClick"]); model.Clicks = ConvertToInt(rdr["Clicks"]); model.Passed = ConverToBool(rdr["Passed"]); model.OverdueDate = ConvertToDate(rdr["OverdueDate"]); model.ImgUrl1 = ConverToStr(rdr["ImgUrl1"]); model.ImgHeight1 = ConverToStr(rdr["ImgHeight1"]); model.ImgWidth1 = ConverToStr(rdr["ImgWidth1"]); model.LinkUrl1 = ConverToStr(rdr["LinkUrl1"]); model.LinkTarget1 = ConvertToInt(rdr["LinkTarget1"]); model.LinkAlt1 = ConverToStr(rdr["LinkAlt1"]); model.ADIntro1 = ConverToStr(rdr["ADIntro1"]); model.FlashWmode1 = ConvertToInt(rdr["FlashWmode1"]); return(model); }
public override SqlParameter[] GetParameters() { M_Advertisement model = this; SqlParameter[] sp = GetSP(); sp[0].Value = model.ADID; sp[1].Value = model.UserID; sp[2].Value = model.ADType; sp[3].Value = model.ADName; sp[4].Value = model.ImgUrl; sp[5].Value = model.ImgWidth; sp[6].Value = model.ImgHeight; sp[7].Value = model.FlashWmode; sp[8].Value = model.ADIntro; sp[9].Value = model.LinkUrl; sp[10].Value = model.LinkTarget; sp[11].Value = model.LinkAlt; sp[12].Value = model.Priority; sp[13].Value = model.Setting; sp[14].Value = model.CountView; sp[15].Value = model.Views; sp[16].Value = model.CountClick; sp[17].Value = model.Clicks; sp[18].Value = model.Passed; sp[19].Value = model.OverdueDate; sp[20].Value = model.ImgUrl1; sp[21].Value = model.ImgHeight1; sp[22].Value = model.ImgWidth1; sp[23].Value = model.LinkUrl1; sp[24].Value = model.LinkTarget1; sp[25].Value = model.LinkAlt1; sp[26].Value = model.ADIntro1; sp[27].Value = model.FlashWmode1; return(sp); }
/// <summary> /// 创建广告版位JS /// </summary> /// <param name="adZoneInfo"></param> /// <param name="advertisementInfoList"></param> public void CreateJS(M_Adzone adZoneInfo, IList<M_Advertisement> 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, "\");" })); //将广告对象定义加入到JS代码中 for (int i = 0; i < advertisementInfoList.Count; i++) { this.advertisementInfo = advertisementInfoList[i]; this.advertisementInfo.ZoneID = adZoneInfo.ZoneID; 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()); }
/// <summary> /// 添加广告 /// </summary> /// <param name="Advertisement"></param> /// <param name="StrZoneID"></param> /// <returns></returns> public bool Advertisement_Add(M_Advertisement Advertisement) { SqlParameter[] parameter = this.GetParameter(Advertisement); return (SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "dt_Advertisement_Add", parameter)>0); }
private M_Advertisement GetInfoFromReader(SqlDataReader rdr) { M_Advertisement info = new M_Advertisement(); info.AdId = DataConverter.CLng(rdr["ADID"]); info.UserId = DataConverter.CLng(rdr["UserID"]); info.AdType = DataConverter.CLng(rdr["ADType"]); info.AdName = rdr["ADName"].ToString(); info.ImgUrl = rdr["ImgUrl"].ToString(); info.ImgWidth = DataConverter.CLng(rdr["ImgWidth"]); info.ImgHeight = DataConverter.CLng(rdr["ImgHeight"]); info.FlashWmode = DataConverter.CLng(rdr["FlashWmode"]); info.ADIntro = rdr["ADIntro"].ToString(); info.LinkUrl = rdr["LinkUrl"].ToString(); info.LinkTarget = DataConverter.CLng(rdr["LinkTarget"]); info.LinkAlt = rdr["LinkAlt"].ToString(); info.Priority = DataConverter.CLng(rdr["Priority"]); info.Setting = rdr["Setting"].ToString(); info.CountView = DataConverter.CBool(rdr["CountView"].ToString()); info.Views = DataConverter.CLng(rdr["Views"]); info.CountClick = DataConverter.CBool(rdr["CountClick"].ToString()); info.Clicks = DataConverter.CLng(rdr["Clicks"]); info.Passed = DataConverter.CBool(rdr["Passed"].ToString()); info.OverdueDate = DataConverter.CDate(rdr["OverdueDate"]); return info; }
private SqlParameter[] GetParameter(M_Advertisement adv) { SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@ADID", SqlDbType.Int), new SqlParameter("@UserID",SqlDbType.Int), new SqlParameter("@ADType",SqlDbType.Int), new SqlParameter("@ADName",SqlDbType.NVarChar,100), new SqlParameter("@ImgUrl",SqlDbType.NVarChar,255), new SqlParameter("@ImgWidth",SqlDbType.Int), new SqlParameter("@ImgHeight",SqlDbType.Int), new SqlParameter("@FlashWmode",SqlDbType.Int), new SqlParameter("@ADIntro",SqlDbType.NText), new SqlParameter("@LinkUrl",SqlDbType.NVarChar,255), new SqlParameter("@LinkTarget",SqlDbType.Int), new SqlParameter("@LinkAlt",SqlDbType.NVarChar,255), new SqlParameter("@Priority",SqlDbType.Int), new SqlParameter("@Setting",SqlDbType.NText), new SqlParameter("@CountView",SqlDbType.Bit), new SqlParameter("@Views",SqlDbType.Int), new SqlParameter("@CountClick",SqlDbType.Bit), new SqlParameter("@Clicks",SqlDbType.Int), new SqlParameter("@Passed",SqlDbType.Int), new SqlParameter("@OverdueDate",SqlDbType.DateTime) }; sp[0].Value = adv.AdId; sp[1].Value = adv.UserId; sp[2].Value = adv.AdType; sp[3].Value = adv.AdName; sp[4].Value = adv.ImgUrl; sp[5].Value = adv.ImgWidth; sp[6].Value = adv.ImgHeight; sp[7].Value = adv.FlashWmode; sp[8].Value = adv.ADIntro; sp[9].Value = adv.LinkUrl; sp[10].Value = adv.LinkTarget; sp[11].Value = adv.LinkAlt; sp[12].Value = adv.Priority; sp[13].Value = adv.Setting; sp[14].Value = adv.CountView; sp[15].Value = adv.Views; sp[16].Value = adv.CountClick; sp[17].Value = adv.Clicks; sp[18].Value = adv.Passed; sp[19].Value = adv.OverdueDate; return sp; }
protected void EBtnSubmit_Click(object sender, EventArgs e) { string adZoneIdList = this.GetAdZoneIdList(); if (this.Page.IsValid) { M_Advertisement adv = new M_Advertisement(); adv.UserId = 0; adv.AdName = DataSecurity.HtmlEncode(this.TxtADName.Text.Trim()); adv.AdType = DataConverter.CLng(this.RadlADType.SelectedValue); adv.Priority = DataConverter.CLng(this.TxtPriority.Text.Trim()); adv.Passed = this.ChkPassed.Checked; adv.CountView = this.ChkCountView.Checked; adv.Views = DataConverter.CLng(this.TxtViews.Text.Trim()); adv.CountClick = this.ChkCountClick.Checked; adv.Clicks = DataConverter.CLng(this.TxtClicks.Text.Trim()); //adv.ZoneID = adZoneIdList; adv.AdId = DataConverter.CLng(this.HdnID.Value.Trim()); adv.OverdueDate = DataConverter.CDate(this.txtOverdueDate.Text); adv.Setting = ""; switch (adv.AdType) { case 1: { adv.ImgUrl = this.txtpic.Text.Trim(); if (string.IsNullOrEmpty(adv.ImgUrl)) { function.WriteErrMsg("图片广告的图片地址不能为空!"); } adv.ImgHeight = DataConverter.CLng(this.TxtImgHeight.Text.Trim()); adv.ImgWidth = DataConverter.CLng(this.TxtImgWidth.Text.Trim()); string str2 = this.TxtLinkUrl.Text.Trim(); adv.LinkUrl = str2; adv.LinkTarget = DataConverter.CLng(this.RadlLinkTarget.SelectedValue); adv.LinkAlt = this.TxtLinkAlt.Text.Trim(); adv.ADIntro = this.TxtADIntro.Text.Trim(); break; } case 2: adv.ImgUrl = this.txtFlashPath.Text.Trim(); if (string.IsNullOrEmpty(adv.ImgUrl)) { function.WriteErrMsg("动画广告的Flash地址不能为空"); } adv.ImgHeight = DataConverter.CLng(this.TxtFlashHeight.Text.Trim()); adv.ImgWidth = DataConverter.CLng(this.TxtFlashWidth.Text.Trim()); adv.FlashWmode = DataConverter.CLng(this.RadlFlashMode.SelectedValue); break; case 3: adv.ADIntro = this.TxtADText.Text.Trim(); break; case 4: adv.ADIntro = this.TxtADCode.Text.Trim(); break; case 5: adv.ADIntro = this.TxtWebFileUrl.Text.Trim(); break; } bool flag = false; if (adv.AdId>0) { flag=B_Advertisement.Advertisement_Update(adv); } else { adv.AdId = B_Advertisement.MaxID(); flag = B_Advertisement.Advertisement_Add(adv); } if (flag) { int zid = 0; if (!string.IsNullOrEmpty(adZoneIdList)) { string[] arr = adZoneIdList.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); for (int s = 0; s < arr.Length; s++) { zid = DataConverter.CLng(arr[s]); if (!B_Advertisement.IsExistZoneAdv(zid, adv.AdId)) B_Advertisement.Add_Zone_Advertisement(zid, adv.AdId); } B_ADZone.CreateJS(adZoneIdList); } Response.Write("<script>alert('广告信息保存成功!');window.document.location.href='ADManage.aspx'</script>"); } else { Response.Write("<script>alert('广告信息保存失败!');</script>"); } } }
private void InitShowPanel(M_Advertisement adv) { switch (adv.AdType) { case 1: this.ADContent1.Attributes.Add("style", "display: "); this.txtpic.Text = adv.ImgUrl; this.TxtImgWidth.Text = adv.ImgWidth.ToString(); this.TxtImgHeight.Text = adv.ImgHeight.ToString(); this.TxtLinkUrl.Text = adv.LinkUrl; this.TxtLinkAlt.Text = adv.LinkAlt; this.RadlLinkTarget.SelectedValue= adv.LinkTarget.ToString(); this.TxtADIntro.Text = adv.ADIntro; return; case 2: this.ADContent2.Attributes.Add("style", "display: "); this.txtFlashPath.Text = adv.ImgUrl; this.TxtFlashWidth.Text = adv.ImgWidth.ToString(); this.TxtFlashHeight.Text = adv.ImgHeight.ToString(); this.RadlFlashMode.SelectedValue= adv.FlashWmode.ToString(); return; case 3: this.ADContent3.Attributes.Add("style", "display: "); this.TxtADText.Text = adv.ADIntro; return; case 4: this.ADContent4.Attributes.Add("style", "display: "); this.TxtADCode.Text = adv.ADIntro; return; case 5: this.ADContent5.Attributes.Add("style", "display: "); this.TxtWebFileUrl.Text = adv.ADIntro; return; } this.ADContent1.Attributes.Add("style", "display: "); }
/// <summary> /// 添加广告 /// </summary> /// <param name="Advertisement"></param> /// <returns></returns> public static bool Advertisement_Add(M_Advertisement Advertisement) { return advertisement.Advertisement_Add(Advertisement); }
public static string GetAdContent(M_Advertisement advertisementInfo) { StringBuilder builder2; StringBuilder builder = new StringBuilder(); switch (advertisementInfo.AdType) { case 1: { builder2 = new StringBuilder(); builder2.Append("<img src=\""); string imgUrl = advertisementInfo.ImgUrl; if (((!imgUrl.StartsWith("/") && !imgUrl.StartsWith("~/")) && !imgUrl.StartsWith("http", StringComparison.CurrentCultureIgnoreCase)) && !imgUrl.StartsWith("https", StringComparison.CurrentCultureIgnoreCase)) { builder2.Append(VirtualPathUtility.AppendTrailingSlash(HttpContext.Current.Request.ApplicationPath)); //builder2.Append(VirtualPathUtility.AppendTrailingSlash(SiteConfig.SiteOption.UploadDir)); builder2.Append(imgUrl); break; } builder2.Append(imgUrl); break; } case 2: builder.Append("<object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0\""); if (advertisementInfo.ImgWidth > 0) { builder.Append(" width=\""); builder.Append(advertisementInfo.ImgWidth); builder.Append("\""); } if (advertisementInfo.ImgHeight > 0) { builder.Append(" height=\""); builder.Append(advertisementInfo.ImgHeight); builder.Append("\""); } builder.Append("><param name=\"movie\" value=\""); builder.Append(VirtualPathUtility.AppendTrailingSlash(HttpContext.Current.Request.ApplicationPath)); builder.Append(advertisementInfo.ImgUrl); builder.Append("\">"); if (advertisementInfo.FlashWmode == 1) { builder.Append("<param name=\"wmode\" value=\"transparent\">"); } builder.Append("<param name=\"quality\" value=\"autohigh\">"); builder.Append("<embed src=\""); builder.Append(VirtualPathUtility.AppendTrailingSlash(HttpContext.Current.Request.ApplicationPath)); //builder.Append(VirtualPathUtility.AppendTrailingSlash(SiteConfig.SiteOption.UploadDir)); builder.Append(advertisementInfo.ImgUrl); builder.Append("\" quality=\"autohigh\" pluginspage=\"http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash\" type=\"application/x-shockwave-flash\""); if (advertisementInfo.FlashWmode == 1) { builder.Append(" wmode=\"transparent\" "); } if (advertisementInfo.ImgWidth > 0) { builder.Append(" width=\""); builder.Append(advertisementInfo.ImgWidth); builder.Append("\""); } if (advertisementInfo.ImgHeight > 0) { builder.Append(" height=\""); builder.Append(advertisementInfo.ImgHeight); builder.Append("\""); } builder.Append("></embed></object>"); goto Label_04B5; case 3: builder.Append(advertisementInfo.ADIntro); goto Label_04B5; case 4: builder.Append(advertisementInfo.ADIntro); goto Label_04B5; case 5: builder.Append("<iframe id=\"AD_"); builder.Append(advertisementInfo.AdId); builder.Append("\" marginwidth=0 marginheight=0 hspace=0 vspace=0 frameborder=0 scrolling=no width=100% height=100% src=\""); builder.Append(advertisementInfo.ADIntro); builder.Append("\">AD</iframe>"); goto Label_04B5; default: goto Label_04B5; } builder2.Append("\""); if (advertisementInfo.ImgWidth > 0) { builder2.Append(" width=\""); builder2.Append(advertisementInfo.ImgWidth); builder2.Append("\""); } if (advertisementInfo.ImgHeight > 0) { builder2.Append(" height=\""); builder2.Append(advertisementInfo.ImgHeight); builder2.Append("\""); } builder2.Append(" border=\"0\"></img>"); if (!string.IsNullOrEmpty(advertisementInfo.LinkUrl)) { builder.Append("<a href=\""); builder.Append(advertisementInfo.LinkUrl); builder.Append("\""); if (advertisementInfo.LinkTarget == 0) { builder.Append(" target=\"_self\""); } else { builder.Append(" target=\"_blank\""); } builder.Append(" title=\""); builder.Append(advertisementInfo.LinkAlt); builder.Append("\""); builder.Append(">"); builder.Append(builder2.ToString()); builder.Append("</a>"); } else { builder = builder2; } Label_04B5: return builder.ToString(); }
/// <summary> /// 修改广告 /// </summary> /// <param name="Advertisement"></param> /// <returns></returns> public static bool Advertisement_Update(M_Advertisement Advertisement) { return advertisement.Advertisement_Update(Advertisement); }