public void ReFresh(object sender, EventArgs e) { if (IsDateLimited.Checked) { StartDateRow.Visible = true; EndDateRow.Visible = true; } else { StartDateRow.Visible = false; EndDateRow.Visible = false; } Level.Visible = Weight.Visible = false; IsDateLimited.Enabled = true; var levelType = EAdvLevelTypeUtils.GetEnumType(LevelType.SelectedValue); if (levelType == EAdvLevelType.Standard) { Level.Visible = true; } else { Level.Visible = false; } if (IsWeight.Checked) { Weight.Visible = true; } else { Weight.Visible = false; } var rotateType = EAdvRotateTypeUtils.GetEnumType(RotateType.SelectedValue); if (rotateType == EAdvRotateType.SlideRotate) { RotateIntervalRow.Visible = true; } else { RotateIntervalRow.Visible = false; } }
public ArrayList GetAdvInfoArrayList(ETemplateType templateType, int adAreaId, int publishmentSystemId, int nodeId, int fileTemplateId) { var arraylist = new ArrayList(); var strSql = new StringBuilder(); strSql.AppendFormat(@"SELECT AdvID,PublishmentSystemID,AdAreaID,AdvName,Summary, IsEnabled, IsDateLimited, StartDate, EndDate,LevelType,Level,IsWeight,Weight ,RotateType,RotateInterval,NodeIDCollectionToChannel,NodeIDCollectionToContent,FileTemplateIDCollection FROM (SELECT * FROM siteserver_Adv WHERE AdAreaID ={0} AND PublishmentSystemID ={1}) AS ADV", adAreaId, publishmentSystemId); if (templateType == ETemplateType.IndexPageTemplate || templateType == ETemplateType.ChannelTemplate) { strSql.AppendFormat(" WHERE NodeIDCollectionToChannel='{0}' OR NodeIDCollectionToChannel LIKE '{0},%' OR NodeIDCollectionToChannel LIKE '%,{0}' OR NodeIDCollectionToChannel LIKE '%,{0},%'", nodeId.ToString()); } else if (templateType == ETemplateType.ContentTemplate) { strSql.AppendFormat(" WHERE NodeIDCollectionToContent='{0}' OR NodeIDCollectionToContent LIKE '{0},%' OR NodeIDCollectionToContent LIKE '%,{0}' OR NodeIDCollectionToContent LIKE '%,{0},%'", nodeId.ToString()); } else if (templateType == ETemplateType.FileTemplate) { strSql.AppendFormat(" WHERE FileTemplateIDCollection='{0}' OR FileTemplateIDCollection LIKE '{0},%' OR FileTemplateIDCollection LIKE '%,{0}' OR FileTemplateIDCollection LIKE '%,{0},%'", fileTemplateId); } strSql.AppendFormat(@" ORDER BY StartDate ASC"); using (var rdr = ExecuteReader(strSql.ToString())) { while (rdr.Read()) { var i = 0; var advInfo = new AdvInfo(GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetBool(rdr, i++), GetBool(rdr, i++), GetDateTime(rdr, i++), GetDateTime(rdr, i++), EAdvLevelTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetBool(rdr, i++), GetInt(rdr, i++), EAdvRotateTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetString(rdr, i)); arraylist.Add(advInfo); } rdr.Close(); } return(arraylist); }
public AdvInfo GetAdvInfo(int advId, int publishmentSystemId) { AdvInfo advInfo = null; var parms = new IDataParameter[] { GetParameter(ParmAdvId, EDataType.Integer, advId), GetParameter(ParmPublishmentsystemid, EDataType.Integer, publishmentSystemId) }; using (var rdr = ExecuteReader(SqlSelectAdv, parms)) { if (rdr.Read()) { var i = 0; advInfo = new AdvInfo(GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetBool(rdr, i++), GetBool(rdr, i++), GetDateTime(rdr, i++), GetDateTime(rdr, i++), EAdvLevelTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetBool(rdr, i++), GetInt(rdr, i++), EAdvRotateTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetString(rdr, i)); } rdr.Close(); } return(advInfo); }
public override void Submit_OnClick(object sender, EventArgs e) { if (Page.IsPostBack && Page.IsValid) { try { if (_isEdit) { var advInfo = DataProvider.AdvDao.GetAdvInfo(_advId, PublishmentSystemId); advInfo.AdvName = AdvName.Text; advInfo.IsEnabled = TranslateUtils.ToBool(IsEnabled.SelectedValue); advInfo.IsDateLimited = IsDateLimited.Checked; advInfo.StartDate = TranslateUtils.ToDateTime(StartDate.Text); advInfo.EndDate = TranslateUtils.ToDateTime(EndDate.Text); advInfo.NodeIDCollectionToChannel = ControlUtils.GetSelectedListControlValueCollection(NodeIDCollectionToChannel); advInfo.NodeIDCollectionToContent = ControlUtils.GetSelectedListControlValueCollection(NodeIDCollectionToContent); advInfo.FileTemplateIDCollection = ControlUtils.GetSelectedListControlValueCollection(FileTemplateIDCollection); advInfo.LevelType = EAdvLevelTypeUtils.GetEnumType(LevelType.SelectedValue); advInfo.Level = TranslateUtils.ToInt(Level.SelectedValue); advInfo.IsWeight = IsWeight.Checked; advInfo.Weight = TranslateUtils.ToInt(Weight.SelectedValue); advInfo.RotateType = EAdvRotateTypeUtils.GetEnumType(RotateType.SelectedValue); advInfo.RotateInterval = TranslateUtils.ToInt(RotateInterval.Text); advInfo.Summary = Summary.Text; DataProvider.AdvDao.Update(advInfo); Body.AddSiteLog(PublishmentSystemId, "修改固定广告", $"广告名称:{advInfo.AdvName}"); SuccessMessage("修改广告成功!"); } else { var advInfo = new AdvInfo(); advInfo.AdAreaID = _adAreadId; advInfo.PublishmentSystemID = PublishmentSystemId; advInfo.AdvName = AdvName.Text; advInfo.Summary = Summary.Text; advInfo.IsEnabled = TranslateUtils.ToBool(IsEnabled.SelectedValue); advInfo.IsDateLimited = IsDateLimited.Checked; advInfo.StartDate = TranslateUtils.ToDateTime(StartDate.Text); advInfo.EndDate = TranslateUtils.ToDateTime(EndDate.Text); advInfo.NodeIDCollectionToChannel = ControlUtils.GetSelectedListControlValueCollection(NodeIDCollectionToChannel); advInfo.NodeIDCollectionToContent = ControlUtils.GetSelectedListControlValueCollection(NodeIDCollectionToContent); advInfo.FileTemplateIDCollection = ControlUtils.GetSelectedListControlValueCollection(FileTemplateIDCollection); advInfo.LevelType = EAdvLevelTypeUtils.GetEnumType(LevelType.SelectedValue); advInfo.Level = TranslateUtils.ToInt(Level.SelectedValue); advInfo.IsWeight = IsWeight.Checked; advInfo.Weight = TranslateUtils.ToInt(Weight.SelectedValue); advInfo.RotateType = EAdvRotateTypeUtils.GetEnumType(RotateType.SelectedValue); advInfo.RotateInterval = TranslateUtils.ToInt(RotateInterval.Text); DataProvider.AdvDao.Insert(advInfo); Body.AddSiteLog(PublishmentSystemId, "新增固定广告", $"广告名称:{advInfo.AdvName}"); SuccessMessage("新增广告成功!"); } AddWaitAndRedirectScript(PageAdv.GetRedirectUrl(PublishmentSystemId, _adAreadId)); } catch (Exception ex) { FailMessage(ex, $"操作失败:{ex.Message}"); } } }