public bool Update(ADZoneInfo adZoneInfo) { Parameters cmdParams = GetParameters(adZoneInfo); cmdParams.AddInParameter("@ZoneId", DbType.Int32, adZoneInfo.ZoneId); return(DBHelper.ExecuteProc("PR_AD_ADZone_UPDATE", cmdParams)); }
public bool Add(ADZoneInfo adZoneInfo) { Parameters cmdParams = GetParameters(adZoneInfo); cmdParams.AddInParameter("@ZoneId", DbType.Int32, GetMaxADZoneId()); return(DBHelper.ExecuteProc("PR_Ad_ADZone_ADD", cmdParams)); }
protected void Page_Load(object sender, EventArgs e) { if (!this.Page.IsPostBack) { this.TxtZoneJSName.Text = this.GetJSFileName(); this.DropFixedPosition.Attributes.Add("onchange", "ChangePositonShow(this)"); this.DropFloatPosition.Attributes.Add("onchange", "ChangePositonShow(this)"); this.DropMovePosition.Attributes.Add("onchange", "ChangePositonShow(this)"); this.DropPopPosition.Attributes.Add("onchange", "ChangePositonShow(this)"); if (BasePage.RequestString("Action") == "Modify") { int id = BasePage.RequestInt32("ZoneId"); ADZoneInfo adZoneById = ADZone.GetAdZoneById(id); this.TxtZoneName.Text = adZoneById.ZoneName; this.TxtZoneJSName.Text = adZoneById.ZoneJSName; this.TxtZoneIntro.Text = adZoneById.ZoneIntro; this.InitRblADZoneType((int)adZoneById.ZoneType); if (adZoneById.DefaultSetting) { this.InitRblADZoneDefaultSetting(0); } else { this.InitRblADZoneDefaultSetting(1); } BasePage.SetSelectedIndexByValue(this.RadlShowType, adZoneById.ShowType.ToString()); string flag = adZoneById.ZoneWidth.ToString() + "x" + adZoneById.ZoneHeight.ToString(); this.InitDropADZoneSize(flag); this.TxtZoneWidth.Text = adZoneById.ZoneWidth.ToString(); this.TxtZoneHeight.Text = adZoneById.ZoneHeight.ToString(); this.InitSetting(adZoneById.Setting, adZoneById.ZoneType); if (this.RadlDefaultSetting.SelectedValue == "1") { this.InitShowPanel(adZoneById.ZoneType); } this.ChkActive.Checked = adZoneById.Active; this.EBtnAdZone.Text = "修 改"; this.HdnAction.Value = "Modify"; this.HdnZoneId.Value = id.ToString(); if ((adZoneById.ZoneType > ADZoneType.Banner) && (adZoneById.ZoneType == ADZoneType.Code)) { this.DropAdZoneSize.Enabled = false; this.TxtZoneHeight.Enabled = false; this.TxtZoneWidth.Enabled = false; } } else { this.InitRblADZoneType(1); this.InitRblADZoneDefaultSetting(0); this.InitDropADZoneSize(null); this.EBtnAdZone.Text = "添 加"; this.HdnAction.Value = "Add"; } } }
protected void GdvADZone_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { ADZoneInfo dataItem = (ADZoneInfo)e.Row.DataItem; Label label = (Label)e.Row.FindControl("LabZoneType"); Label label2 = (Label)e.Row.FindControl("LabShowType"); label.Text = BasePage.EnumToHtml <ADZoneType>(dataItem.ZoneType); label2.Text = GetADZoneShowType()[dataItem.ShowType]; } }
public bool ImportData(string zoneId, string importDatabase) { bool flag; Database db = DatabaseFactory.CreateDatabase(); StringBuilder builder = new StringBuilder(""); builder.Append(" SELECT ZoneID, ZoneName, ZoneJSName, ZoneIntro, ZoneType, DefaultSetting, ZoneSetting, ZoneWidth, ZoneHeight, ShowType, Active, UpdateTime FROM PE_AdZone "); OleDbConnection connection = new OleDbConnection("Provider = Microsoft.Jet.OleDb.4.0;Data Source = " + importDatabase); try { connection.Open(); builder.Append("Where ZoneID IN (" + zoneId + ") ORDER BY ZoneID"); OleDbCommand command = new OleDbCommand(builder.ToString(), connection); NullableDataReader reader = new NullableDataReader(command.ExecuteReader(CommandBehavior.CloseConnection)); while (reader.Read()) { ADZoneInfo adZoneInfo = new ADZoneInfo(); adZoneInfo.ZoneId = GetMaxADZoneId(); adZoneInfo.ZoneName = reader.GetString("ZoneName"); adZoneInfo.ZoneJSName = reader.GetString("ZoneJSName"); adZoneInfo.ZoneIntro = reader.GetString("ZoneIntro"); adZoneInfo.ZoneType = (ADZoneType)reader.GetInt32("ZoneType"); adZoneInfo.DefaultSetting = reader.GetBoolean("DefaultSetting"); adZoneInfo.Setting = reader.GetString("ZoneSetting"); adZoneInfo.ZoneWidth = reader.GetInt32("ZoneWidth"); adZoneInfo.ZoneHeight = reader.GetInt32("ZoneHeight"); adZoneInfo.ShowType = reader.GetInt32("ShowType"); adZoneInfo.Active = reader.GetBoolean("Active"); adZoneInfo.UpdateTime = reader.GetDateTime("UpdateTime"); DbCommand command2 = GetProcdbComm(db, "PR_Ad_ADZone_ADD", adZoneInfo); try { db.ExecuteNonQuery(command2); continue; } catch { reader.Close(); return(false); } } flag = true; } catch { flag = false; } finally { connection.Close(); } return(flag); }
protected void Page_Load(object sender, EventArgs e) { ADZoneInfo adZoneById = ADZone.GetAdZoneById(BasePage.RequestInt32("ZoneId")); if ((adZoneById == null) || string.IsNullOrEmpty(adZoneById.ZoneJSName)) { this.TxtZoneCode.Text = "找不到指定的版位!"; } else { this.TxtZoneCode.Text = "<script type=\"text/javascript\" src='{PE.SiteConfig.adpath/}/" + adZoneById.ZoneJSName + "'></script>"; } }
public static DataActionState Add(ADZoneInfo adZoneInfo) { DataActionState unknown = DataActionState.Unknown; if (!dal.Add(adZoneInfo)) { return(unknown); } if (adZoneInfo.Active) { CreateJS(adZoneInfo.ZoneId.ToString(CultureInfo.CurrentCulture)); } return(DataActionState.Successed); }
private static Parameters GetParameters(ADZoneInfo adZoneInfo) { Parameters parameters = new Parameters(); parameters.AddInParameter("@ZoneName", DbType.String, adZoneInfo.ZoneName); parameters.AddInParameter("@ZoneJSName", DbType.String, adZoneInfo.ZoneJSName); parameters.AddInParameter("@ZoneIntro", DbType.String, adZoneInfo.ZoneIntro); parameters.AddInParameter("@ZoneType", DbType.Int32, adZoneInfo.ZoneType); parameters.AddInParameter("@DefaultSetting", DbType.Boolean, adZoneInfo.DefaultSetting); parameters.AddInParameter("@ZoneSetting", DbType.String, adZoneInfo.Setting); parameters.AddInParameter("@ZoneWidth", DbType.Int32, adZoneInfo.ZoneWidth); parameters.AddInParameter("@ZoneHeight", DbType.Int32, adZoneInfo.ZoneHeight); parameters.AddInParameter("@Active", DbType.Boolean, adZoneInfo.Active); parameters.AddInParameter("@ShowType", DbType.Int32, adZoneInfo.ShowType); parameters.AddInParameter("@UpdateTime", DbType.DateTime, adZoneInfo.UpdateTime); return(parameters); }
public static void DeleteJS(string id) { if (!string.IsNullOrEmpty(id)) { string[] strArray = id.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); string advertisementDir = SiteConfig.SiteOption.AdvertisementDir; HttpContext current = HttpContext.Current; if (current != null) { advertisementDir = current.Server.MapPath("~/" + advertisementDir); } for (int i = 0; i < strArray.Length; i++) { ADZoneInfo adZoneById = GetAdZoneById(DataConverter.CLng(strArray[i])); FileSystemObject.Delete(VirtualPathUtility.AppendTrailingSlash(advertisementDir) + adZoneById.ZoneJSName, FsoMethod.File); } } }
private static DbCommand GetProcdbComm(Database db, string proName, ADZoneInfo adZoneInfo) { DbCommand storedProcCommand = db.GetStoredProcCommand(proName); db.AddInParameter(storedProcCommand, "@ZoneId", DbType.Int32, adZoneInfo.ZoneId); db.AddInParameter(storedProcCommand, "@ZoneName", DbType.String, adZoneInfo.ZoneName); db.AddInParameter(storedProcCommand, "@ZoneJSName", DbType.String, adZoneInfo.ZoneJSName); db.AddInParameter(storedProcCommand, "@ZoneIntro", DbType.String, adZoneInfo.ZoneIntro); db.AddInParameter(storedProcCommand, "@ZoneType", DbType.Int32, adZoneInfo.ZoneType); db.AddInParameter(storedProcCommand, "@DefaultSetting", DbType.Boolean, adZoneInfo.DefaultSetting); db.AddInParameter(storedProcCommand, "@ZoneSetting", DbType.String, adZoneInfo.Setting); db.AddInParameter(storedProcCommand, "@ZoneWidth", DbType.Int32, adZoneInfo.ZoneWidth); db.AddInParameter(storedProcCommand, "@ZoneHeight", DbType.Int32, adZoneInfo.ZoneHeight); db.AddInParameter(storedProcCommand, "@Active", DbType.Boolean, adZoneInfo.Active); db.AddInParameter(storedProcCommand, "@ShowType", DbType.Int32, adZoneInfo.ShowType); db.AddInParameter(storedProcCommand, "@UpdateTime", DbType.DateTime, adZoneInfo.UpdateTime); return(storedProcCommand); }
private static ADZoneInfo GetAdZoneInfoFromrdr(NullableDataReader rdr) { ADZoneInfo info = new ADZoneInfo(); info.ZoneId = rdr.GetInt32("ZoneId"); info.ZoneName = rdr.GetString("ZoneName"); info.ZoneJSName = rdr.GetString("ZoneJSName"); info.ZoneIntro = rdr.GetString("ZoneIntro"); info.ZoneType = (ADZoneType)rdr.GetInt32("ZoneType"); info.DefaultSetting = rdr.GetBoolean("DefaultSetting"); info.Setting = rdr.GetString("ZoneSetting"); info.ZoneWidth = rdr.GetInt32("ZoneWidth"); info.ZoneHeight = rdr.GetInt32("ZoneHeight"); info.Active = rdr.GetBoolean("Active"); info.ShowType = rdr.GetInt32("ShowType"); info.UpdateTime = rdr.GetDateTime("UpdateTime"); return(info); }
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 static void CreateJS(string id) { if (!string.IsNullOrEmpty(id)) { string[] strArray = id.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); ADZoneJS ejs = new ADZoneJS(); for (int i = 0; i < strArray.Length; i++) { ADZoneInfo adZoneById = GetAdZoneById(DataConverter.CLng(strArray[i])); if (adZoneById.Active) { IList <AdvertisementInfo> aDList = Advertisement.GetADList(adZoneById.ZoneId, adZoneById.ShowType); if (aDList.Count > 0) { ejs.CreateJS(adZoneById, aDList); } } } } }
protected void EBtnAdZone_Click(object sender, EventArgs e) { if (this.Page.IsValid) { ADZoneInfo adZoneInfo = new ADZoneInfo(); adZoneInfo.ZoneName = this.TxtZoneName.Text.Trim(); adZoneInfo.ZoneJSName = this.TxtZoneJSName.Text.Trim(); adZoneInfo.ZoneIntro = this.TxtZoneIntro.Text.Trim(); adZoneInfo.ZoneType = (ADZoneType)DataConverter.CLng(this.RadlZoneType.SelectedValue); adZoneInfo.DefaultSetting = this.GetDefaultSetting(this.RadlDefaultSetting.SelectedValue); adZoneInfo.Setting = this.GetZoneSetting(adZoneInfo.DefaultSetting); adZoneInfo.ZoneWidth = DataConverter.CLng(this.TxtZoneWidth.Text.Trim()); adZoneInfo.ZoneHeight = DataConverter.CLng(this.TxtZoneHeight.Text.Trim()); adZoneInfo.ShowType = DataConverter.CLng(this.RadlShowType.SelectedValue); adZoneInfo.Active = this.ChkActive.Checked; adZoneInfo.UpdateTime = DateTime.Now; if (this.HdnAction.Value.Trim() == "Modify") { adZoneInfo.ZoneId = DataConverter.CLng(this.HdnZoneId.Value.Trim()); if (ADZone.Update(adZoneInfo)) { BasePage.ResponseRedirect("ADZoneManage.aspx"); } else { AdminPage.WriteErrMsg("更新出错!", "ADZone.aspx?ZoneId=" + adZoneInfo.ZoneId); } } else if (ADZone.Add(adZoneInfo) == DataActionState.Successed) { BasePage.ResponseRedirect("ADZoneManage.aspx"); } else { AdminPage.WriteErrMsg("添加出错!", "ADZone.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { int zoneId = BasePage.RequestInt32("ZoneId"); if (string.Compare(BasePage.RequestString("Type"), "Zone", StringComparison.OrdinalIgnoreCase) == 0) { if (Advertisement.GetADList(zoneId).Count == 0) { this.ShowJS.InnerHtml = "版位中暂时还未添加广告,请添加后再进行预览!"; } else { ADZoneInfo adZoneById = ADZone.GetAdZoneById(zoneId); if (adZoneById != null) { this.ShowJS.InnerHtml = "<script type=\"text/javascript\" src='" + base.ResolveUrl("~/" + VirtualPathUtility.AppendTrailingSlash(SiteConfig.SiteOption.AdvertisementDir) + adZoneById.ZoneJSName) + "?temp=" + DataSecurity.RandomNum() + "'></script>"; } } } else { this.ShowAd(); } }
public static bool Update(ADZoneInfo adZoneInfo) { return(dal.Update(adZoneInfo)); }