public void Page_Load(object sender, EventArgs e) { if (IsForbidden) { return; } PageUtils.CheckRequestParameter("PublishmentSystemId"); _menuId = Body.GetQueryInt("menuID"); _parentId = Body.GetQueryInt("parentID"); if (!IsPostBack) { EMenuTypeUtils.AddListItems(DdlMenuType); var menuInfo = DataProviderWx.MenuDao.GetMenuInfo(_menuId); if (menuInfo == null) { _menuId = 0; } if (_menuId == 0) { LtlPageTitle.Text = $"添加{(_parentId == 0 ? "主" : "子")}菜单"; } else { LtlPageTitle.Text = $"修改{(_parentId == 0 ? "主" : "子")}菜单({menuInfo.MenuName})"; TbMenuName.Text = menuInfo.MenuName; ControlUtils.SelectListItems(DdlMenuType, EMenuTypeUtils.GetValue(menuInfo.MenuType)); TbKeyword.Text = menuInfo.Keyword; TbUrl.Text = menuInfo.Url; LtlScript.Text = $"<script>{MPUtils.GetChannelOrContentSelectScript(PublishmentSystemInfo, menuInfo.ChannelId, menuInfo.ContentId)}</script>"; } DdlMenuType_OnSelectedIndexChanged(null, EventArgs.Empty); BtnKeywordSelect.Attributes.Add("onclick", "parent." + ModalKeywordSelect.GetOpenWindowString(PublishmentSystemId, "selectKeyword")); BtnContentSelect.Attributes.Add("onclick", "parent." + ModalContentSelect.GetOpenWindowString(PublishmentSystemId, false, "contentSelect")); BtnChannelSelect.Attributes.Add("onclick", "parent." + ModalChannelSelect.GetOpenWindowString(PublishmentSystemId)); } }
public void Page_Load(object sender, EventArgs e) { if (IsForbidden) { return; } PageUtils.CheckRequestParameter("PublishmentSystemID"); menuID = TranslateUtils.ToInt(GetQueryString("menuID")); parentID = TranslateUtils.ToInt(GetQueryString("parentID")); if (!IsPostBack) { EMenuTypeUtils.AddListItems(ddlMenuType); var menuInfo = DataProviderWX.MenuDAO.GetMenuInfo(menuID); if (menuInfo == null) { menuID = 0; } if (menuID == 0) { ltlPageTitle.Text = $"添加{(parentID == 0 ? "主" : "子")}菜单"; } else { ltlPageTitle.Text = $"修改{(parentID == 0 ? "主" : "子")}菜单({menuInfo.MenuName})"; tbMenuName.Text = menuInfo.MenuName; ControlUtils.SelectListItems(ddlMenuType, EMenuTypeUtils.GetValue(menuInfo.MenuType)); tbKeyword.Text = menuInfo.Keyword; tbUrl.Text = menuInfo.Url; ltlScript.Text = $"<script>{MPUtils.GetChannelOrContentSelectScript(PublishmentSystemInfo, menuInfo.ChannelID, menuInfo.ContentID)}</script>"; } ddlMenuType_OnSelectedIndexChanged(null, EventArgs.Empty); btnKeywordSelect.Attributes.Add("onclick", "parent." + Modal.KeywordSelect.GetOpenWindowString(PublishmentSystemID, "selectKeyword")); btnContentSelect.Attributes.Add("onclick", "parent." + Modal.ContentSelect.GetOpenWindowString(PublishmentSystemID, false, "contentSelect")); btnChannelSelect.Attributes.Add("onclick", "parent." + CMS.BackgroundPages.Modal.ChannelSelect.GetOpenWindowString(PublishmentSystemID)); } }
public void Update(MenuInfo menuInfo) { var parms = new IDataParameter[] { GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, menuInfo.PublishmentSystemID), GetParameter(PARM_MENU_NAME, EDataType.NVarChar, 50, menuInfo.MenuName), GetParameter(PARM_MENU_TYPE, EDataType.VarChar, 50, EMenuTypeUtils.GetValue(menuInfo.MenuType)), GetParameter(PARM_KEYWORD, EDataType.NVarChar, 50, menuInfo.Keyword), GetParameter(PARM_URL, EDataType.VarChar, 200, menuInfo.Url), GetParameter(PARM_CHANNEL_ID, EDataType.Integer, menuInfo.ChannelID), GetParameter(PARM_CONTENT_ID, EDataType.Integer, menuInfo.ContentID), GetParameter(PARM_PARENT_ID, EDataType.Integer, menuInfo.ParentID), GetParameter(PARM_TAXIS, EDataType.Integer, menuInfo.Taxis), GetParameter(PARM_MENU_ID, EDataType.Integer, menuInfo.MenuID) }; ExecuteNonQuery(SQL_UPDATE, parms); }
public void Update(MenuInfo menuInfo) { var parms = new IDataParameter[] { GetParameter(ParmPublishmentSystemId, EDataType.Integer, menuInfo.PublishmentSystemId), GetParameter(ParmMenuName, EDataType.NVarChar, 50, menuInfo.MenuName), GetParameter(ParmMenuType, EDataType.VarChar, 50, EMenuTypeUtils.GetValue(menuInfo.MenuType)), GetParameter(ParmKeyword, EDataType.NVarChar, 50, menuInfo.Keyword), GetParameter(ParmUrl, EDataType.VarChar, 200, menuInfo.Url), GetParameter(ParmChannelId, EDataType.Integer, menuInfo.ChannelId), GetParameter(ParmContentId, EDataType.Integer, menuInfo.ContentId), GetParameter(ParmParentId, EDataType.Integer, menuInfo.ParentId), GetParameter(ParmTaxis, EDataType.Integer, menuInfo.Taxis), GetParameter(ParmMenuId, EDataType.Integer, menuInfo.MenuId) }; ExecuteNonQuery(SqlUpdate, parms); }
public object GetValue(string attributeName) { foreach (var name in AllAttributes) { if (StringUtils.EqualsIgnoreCase(name, attributeName)) { var nameVlaue = GetType().GetProperty(name).GetValue(this, null); if (attributeName == "MenuType") { return(EMenuTypeUtils.GetEnumType(nameVlaue.ToString())); } return(nameVlaue); } } return(null); }
public int Insert(MenuInfo menuInfo) { var menuID = 0; var sqlString = "INSERT INTO wx_Menu (PublishmentSystemID, MenuName, MenuType, Keyword, Url, ChannelID, ContentID, ParentID, Taxis) VALUES (@PublishmentSystemID, @MenuName, @MenuType, @Keyword, @Url, @ChannelID, @ContentID, @ParentID, @Taxis)"; var taxis = GetMaxTaxis(menuInfo.ParentID) + 1; var parms = new IDataParameter[] { GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, menuInfo.PublishmentSystemID), GetParameter(PARM_MENU_NAME, EDataType.NVarChar, 50, menuInfo.MenuName), GetParameter(PARM_MENU_TYPE, EDataType.VarChar, 50, EMenuTypeUtils.GetValue(menuInfo.MenuType)), GetParameter(PARM_KEYWORD, EDataType.NVarChar, 50, menuInfo.Keyword), GetParameter(PARM_URL, EDataType.VarChar, 200, menuInfo.Url), GetParameter(PARM_CHANNEL_ID, EDataType.Integer, menuInfo.ChannelID), GetParameter(PARM_CONTENT_ID, EDataType.Integer, menuInfo.ContentID), GetParameter(PARM_PARENT_ID, EDataType.Integer, menuInfo.ParentID), GetParameter(PARM_TAXIS, EDataType.Integer, taxis) }; using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { ExecuteNonQuery(trans, sqlString, parms); menuID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, "wx_Menu"); trans.Commit(); } catch { trans.Rollback(); throw; } } } return(menuID); }
public int Insert(MenuInfo menuInfo) { var menuId = 0; var sqlString = "INSERT INTO wx_Menu (PublishmentSystemID, MenuName, MenuType, Keyword, Url, ChannelID, ContentID, ParentID, Taxis) VALUES (@PublishmentSystemID, @MenuName, @MenuType, @Keyword, @Url, @ChannelID, @ContentID, @ParentID, @Taxis)"; var taxis = GetMaxTaxis(menuInfo.ParentId) + 1; var parms = new IDataParameter[] { GetParameter(ParmPublishmentSystemId, EDataType.Integer, menuInfo.PublishmentSystemId), GetParameter(ParmMenuName, EDataType.NVarChar, 50, menuInfo.MenuName), GetParameter(ParmMenuType, EDataType.VarChar, 50, EMenuTypeUtils.GetValue(menuInfo.MenuType)), GetParameter(ParmKeyword, EDataType.NVarChar, 50, menuInfo.Keyword), GetParameter(ParmUrl, EDataType.VarChar, 200, menuInfo.Url), GetParameter(ParmChannelId, EDataType.Integer, menuInfo.ChannelId), GetParameter(ParmContentId, EDataType.Integer, menuInfo.ContentId), GetParameter(ParmParentId, EDataType.Integer, menuInfo.ParentId), GetParameter(ParmTaxis, EDataType.Integer, taxis) }; using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { menuId = ExecuteNonQueryAndReturnId(trans, sqlString, parms); trans.Commit(); } catch { trans.Rollback(); throw; } } } return(menuId); }
public void DdlMenuType_OnSelectedIndexChanged(object sender, EventArgs e) { var isHideAll = false; if (_parentId == 0 && _menuId > 0) { var childrenCount = DataProviderWx.MenuDao.GetCount(_menuId); if (childrenCount > 0) { isHideAll = true; } } if (isHideAll) { PhMenuType.Visible = PhUrl.Visible = PhKeyword.Visible = PhSite.Visible = false; } else { var menuType = EMenuTypeUtils.GetEnumType(DdlMenuType.SelectedValue); PhUrl.Visible = PhKeyword.Visible = PhSite.Visible = false; if (menuType == EMenuType.Url) { PhUrl.Visible = true; } else if (menuType == EMenuType.Keyword) { PhKeyword.Visible = true; } else if (menuType == EMenuType.Site) { PhSite.Visible = true; } } }
public void ddlMenuType_OnSelectedIndexChanged(object sender, EventArgs e) { var isHideAll = false; if (parentID == 0 && menuID > 0) { var childrenCount = DataProviderWX.MenuDAO.GetCount(menuID); if (childrenCount > 0) { isHideAll = true; } } if (isHideAll) { phMenuType.Visible = phUrl.Visible = phKeyword.Visible = phSite.Visible = false; } else { var menuType = EMenuTypeUtils.GetEnumType(ddlMenuType.SelectedValue); phUrl.Visible = phKeyword.Visible = phSite.Visible = false; if (menuType == EMenuType.Url) { phUrl.Visible = true; } else if (menuType == EMenuType.Keyword) { phKeyword.Visible = true; } else if (menuType == EMenuType.Site) { phSite.Visible = true; } } }
public List <MenuInfo> GetMenuInfoList(int publishmentSystemID) { var list = new List <MenuInfo>(); var parms = new IDataParameter[] { GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, publishmentSystemID), GetParameter(PARM_PARENT_ID, EDataType.Integer, 0) }; using (var rdr = ExecuteReader(SQL_SELECT_ALLBY, parms)) { while (rdr.Read()) { var menuInfo = new MenuInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), EMenuTypeUtils.GetEnumType(rdr.GetValue(3).ToString()), rdr.GetValue(4).ToString(), rdr.GetValue(5).ToString(), rdr.GetInt32(6), rdr.GetInt32(7), rdr.GetInt32(8), rdr.GetInt32(9)); list.Add(menuInfo); } rdr.Close(); } return(list); }
public MenuInfo GetMenuInfo(int menuID) { MenuInfo menuInfo = null; var parms = new IDataParameter[] { GetParameter(PARM_MENU_ID, EDataType.Integer, menuID) }; using (var rdr = ExecuteReader(SQL_SELECT, parms)) { if (rdr.Read()) { menuInfo = new MenuInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), EMenuTypeUtils.GetEnumType(rdr.GetValue(3).ToString()), rdr.GetValue(4).ToString(), rdr.GetValue(5).ToString(), rdr.GetInt32(6), rdr.GetInt32(7), rdr.GetInt32(8), rdr.GetInt32(9)); } rdr.Close(); } return(menuInfo); }
public override void Submit_OnClick(object sender, EventArgs e) { if (Page.IsPostBack && Page.IsValid) { try { var menuInfo = new MenuInfo(); if (_menuId > 0) { menuInfo = DataProviderWx.MenuDao.GetMenuInfo(_menuId); } menuInfo.MenuName = TbMenuName.Text; menuInfo.ParentId = _parentId; menuInfo.PublishmentSystemId = PublishmentSystemId; menuInfo.MenuType = EMenuTypeUtils.GetEnumType(DdlMenuType.SelectedValue); if (PhMenuType.Visible) { if (menuInfo.MenuType == EMenuType.Keyword) { if (!DataProviderWx.KeywordMatchDao.IsExists(PublishmentSystemId, TbKeyword.Text)) { FailMessage("菜单保存失败,所填关键词不存在,请先在关键词回复中添加"); return; } } else if (menuInfo.MenuType == EMenuType.Site) { var idsCollection = Request.Form["idsCollection"]; if (!string.IsNullOrEmpty(idsCollection)) { menuInfo.ChannelId = TranslateUtils.ToInt(idsCollection.Split('_')[0]); menuInfo.ContentId = TranslateUtils.ToInt(idsCollection.Split('_')[1]); } if (menuInfo.ChannelId == 0 && menuInfo.ContentId == 0) { FailMessage("菜单保存失败,必须选择微网站页面,请点击下方按钮进行选择"); return; } } } if (_parentId > 0) { if (StringUtils.GetByteCount(TbMenuName.Text) > 26) { FailMessage("菜单保存失败,子菜单菜名称不能超过26个字节(13个汉字)"); return; } } else { if (StringUtils.GetByteCount(TbMenuName.Text) > 16) { FailMessage("菜单保存失败,子菜单菜名称不能超过16个字节(8个汉字)"); return; } } if (menuInfo.MenuType == EMenuType.Url) { if (StringUtils.GetByteCount(TbUrl.Text) > 256) { FailMessage("菜单保存失败,菜单网址不能超过256个字节"); return; } } if (menuInfo.MenuType == EMenuType.Url) { menuInfo.Url = TbUrl.Text; } else if (menuInfo.MenuType == EMenuType.Keyword) { menuInfo.Keyword = TbKeyword.Text; } else if (menuInfo.MenuType == EMenuType.Site) { var idsCollection = Request.Form["idsCollection"]; if (!string.IsNullOrEmpty(idsCollection)) { menuInfo.ChannelId = TranslateUtils.ToInt(idsCollection.Split('_')[0]); menuInfo.ContentId = TranslateUtils.ToInt(idsCollection.Split('_')[1]); } } if (_menuId > 0) { DataProviderWx.MenuDao.Update(menuInfo); Body.AddSiteLog(PublishmentSystemId, "修改自定义菜单"); SuccessMessage("自定义菜单修改成功!"); } else { _menuId = DataProviderWx.MenuDao.Insert(menuInfo); Body.AddSiteLog(PublishmentSystemId, "新增自定义菜单"); SuccessMessage("自定义菜单新增成功!"); } var redirectUrl = PageMenu.GetRedirectUrl(PublishmentSystemId, _parentId, _menuId); LtlPageTitle.Text += $@"<script>parent.redirect('{redirectUrl}');</script>"; } catch (Exception ex) { FailMessage(ex, "自定义菜单配置失败!"); } } }
public List <MenuInfo> GetMenuInfoList(int publishmentSystemId) { var list = new List <MenuInfo>(); var parms = new IDataParameter[] { GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId), GetParameter(ParmParentId, EDataType.Integer, 0) }; using (var rdr = ExecuteReader(SqlSelectAllby, parms)) { while (rdr.Read()) { var menuInfo = new MenuInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), EMenuTypeUtils.GetEnumType(rdr.GetValue(3).ToString()), rdr.GetValue(4).ToString(), rdr.GetValue(5).ToString(), rdr.GetInt32(6), rdr.GetInt32(7), rdr.GetInt32(8), rdr.GetInt32(9)); list.Add(menuInfo); } rdr.Close(); } return(list); }