/// <summary> /// 添加版位 /// </summary> /// <param name="adZone"></param> /// <returns></returns> public static bool ADZone_Add(M_Adzone adZone) { if (!adzone.ADZone_Add(adZone)) { return false; } else { CreateJS(adZone.ZoneID.ToString()); } return true; }
public M_Adzone GetModelFromReader(DbDataReader rdr) { M_Adzone model = new M_Adzone(); model.ZoneID = Convert.ToInt32(rdr["ZoneID"]); model.ZoneName = ConverToStr(rdr["ZoneName"]); model.ZoneJSName = ConverToStr(rdr["ZoneJSName"]); model.ZoneIntro = ConverToStr(rdr["ZoneIntro"]); model.ZoneType = ConvertToInt(rdr["ZoneType"]); model.DefaultSetting = ConverToBool(rdr["DefaultSetting"]); model.ZoneSetting = ConverToStr(rdr["ZoneSetting"]); model.ZoneWidth = ConvertToInt(rdr["ZoneWidth"]); model.ZoneHeight = ConvertToInt(rdr["ZoneHeight"]); model.Active = ConverToBool(rdr["Active"]); model.ShowType = ConvertToInt(rdr["ShowType"]); model.UpdateTime = ConvertToDate(rdr["UpdateTime"]); model.Sales = ConvertToInt(rdr["Sales"]); rdr.Close(); rdr.Dispose(); return(model); }
public override SqlParameter[] GetParameters() { M_Adzone model = this; SqlParameter[] sp = GetSP(); sp[0].Value = model.ZoneID; sp[1].Value = model.ZoneName; sp[2].Value = model.ZoneJSName; sp[3].Value = model.ZoneIntro; sp[4].Value = model.ZoneType; sp[5].Value = model.DefaultSetting; sp[6].Value = model.ZoneSetting; sp[7].Value = model.ZoneWidth; sp[8].Value = model.ZoneHeight; sp[9].Value = model.Active; sp[10].Value = model.ShowType; sp[11].Value = model.UpdateTime; sp[12].Value = model.Sales; 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="adZone"></param> /// <returns></returns> bool ID_Adzone.ADZone_Add(M_Adzone adZone) { SqlParameter[] parameter = null; this.GetAdzoneParameter(adZone,ref parameter); return (SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "dt_ADZone_Add", parameter)>0); }
/// <summary> /// 实例化 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private M_Adzone GetInfoFromReader(SqlDataReader rdr) { M_Adzone info = new M_Adzone(); info.ZoneID = DataConverter.CLng(rdr["ZoneID"]); info.ZoneName = rdr["ZoneName"].ToString(); info.ZoneJSName = rdr["ZoneJSName"].ToString(); info.ZoneIntro = rdr["ZoneIntro"].ToString(); info.ZoneType = DataConverter.CLng(rdr["ZoneType"]); info.DefaultSetting = DataConverter.CBool(rdr["DefaultSetting"].ToString()); info.ZoneSetting = rdr["ZoneSetting"].ToString(); info.ZoneHeight = DataConverter.CLng(rdr["ZoneHeight"]); info.ZoneWidth = DataConverter.CLng(rdr["ZoneWidth"]); info.Active = DataConverter.CBool(rdr["Active"].ToString()); info.ShowType = DataConverter.CLng(rdr["ShowType"]); info.UpdateTime = DataConverter.CDate(rdr["UpdateTime"]); return info; }
private void GetAdzoneParameter(M_Adzone adzone, ref SqlParameter[] parameter) { parameter = new SqlParameter[] { new SqlParameter("@ZoneId", SqlDbType.Int), new SqlParameter("@ZoneName", SqlDbType.NVarChar, 100), new SqlParameter("@ZoneJSName", SqlDbType.NVarChar, 100), new SqlParameter("@ZoneIntro", SqlDbType.NVarChar, 255), new SqlParameter("@ZoneType", SqlDbType.Int ,4), new SqlParameter("@DefaultSetting", SqlDbType.Bit), new SqlParameter("@ZoneSetting", SqlDbType.NVarChar, 255), new SqlParameter("@ZoneWidth", SqlDbType.Int), new SqlParameter("@ZoneHeight", SqlDbType.Int), new SqlParameter("@Active", SqlDbType.Bit), new SqlParameter("@ShowType", SqlDbType.Int), new SqlParameter("@UpdateTime", SqlDbType.DateTime) }; parameter[0].Value = adzone.ZoneID; parameter[1].Value = adzone.ZoneName; parameter[2].Value = adzone.ZoneJSName; parameter[3].Value = adzone.ZoneIntro; parameter[4].Value = adzone.ZoneType; parameter[5].Value = adzone.DefaultSetting; parameter[6].Value = adzone.ZoneSetting; parameter[7].Value = adzone.ZoneWidth; parameter[8].Value = adzone.ZoneHeight; parameter[9].Value = adzone.Active; parameter[10].Value = adzone.ShowType; parameter[11].Value = adzone.UpdateTime; }
protected void Page_Load(object sender, EventArgs e) { if (!this.Page.IsPostBack) { B_Admin badmin = new B_Admin(); badmin.CheckMulitLogin(); if (!badmin.ChkPermissions("ADManage")) { function.WriteErrMsg("没有权限进行此项操作"); } 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)"); foreach (ListItem lit in this.radlZonetype.Items) { lit.Attributes.Add("onclick", "ShowZoenTypePanel()"); } foreach (ListItem li2 in this.RBLDefaultSetting.Items) { li2.Attributes.Add("onclick", "ShowZoenTypePanel()"); } this.DropAdZoneSize.Attributes.Add("onchange", "Zone_SelectSize(this)"); string zoneid = base.Request.QueryString["ZoneId"]; if (string.IsNullOrEmpty(zoneid)) { this.TxtZoneJSName.Text = this.GetJSFileName(); zoneid = "0"; this.HdnZoneId.Value = zoneid; this.Label1.Text = "添加广告版位"; } else { this.HdnZoneId.Value = zoneid; this.Label1.Text = "修改广告版位"; adzone = B_ADZone.getAdzoneByZoneId(DataConverter.CLng(zoneid)); this.TxtZoneName.Text = adzone.ZoneName; this.TxtZoneJSName.Text = adzone.ZoneJSName; this.TxtZoneIntro.Text = adzone.ZoneIntro; this.TxtZoneHeight.Text = adzone.ZoneHeight.ToString(); this.TxtZoneWidth.Text = adzone.ZoneWidth.ToString(); this.radlZonetype.SelectedValue = adzone.ZoneType.ToString(); if (!adzone.DefaultSetting) { this.RBLDefaultSetting.SelectedValue = "0"; } else { this.RBLDefaultSetting.SelectedValue = "1"; } InitShowPanel(adzone.ZoneType); InitSetting(adzone.ZoneSetting, adzone.ZoneType); this.RadlShowType.SelectedValue = adzone.ShowType.ToString(); if (adzone.Active) this.ChkActive.Checked = true; else this.ChkActive.Checked = false; } } }