/// <summary> /// Update one record /// </summary> public void Update(Johnny.CMS.OM.SystemInfo.Menu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE [cms_menu] SET "); strSql.Append("[MenuName]=@menuname,"); strSql.Append("[MenuCategoryId]=@menucategoryid,"); strSql.Append("[PageLink]=@pagelink,"); strSql.Append("[ToolTip]=@tooltip,"); strSql.Append("[Image]=@image,"); strSql.Append("[PermissionId]=@permissionid,"); strSql.Append("[IsDisplay]=@isdisplay"); strSql.Append(" WHERE [MenuId]=@menuid "); SqlParameter[] parameters = { new SqlParameter("@menuid", SqlDbType.Int, 4), new SqlParameter("@menuname", SqlDbType.NVarChar, 50), new SqlParameter("@menucategoryid", SqlDbType.Int, 4), new SqlParameter("@pagelink", SqlDbType.VarChar, 100), new SqlParameter("@tooltip", SqlDbType.NVarChar, 100), new SqlParameter("@image", SqlDbType.VarChar, 200), new SqlParameter("@permissionid", SqlDbType.Int, 4), new SqlParameter("@isdisplay", SqlDbType.Bit) }; parameters[0].Value = model.MenuId; parameters[1].Value = model.MenuName; parameters[2].Value = model.MenuCategoryId; parameters[3].Value = model.PageLink; parameters[4].Value = model.ToolTip; parameters[5].Value = model.Image; parameters[6].Value = model.PermissionId; parameters[7].Value = model.IsDisplay; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// Method to get records with condition /// </summary> public IList <Johnny.CMS.OM.SystemInfo.Menu> GetListByCategory(int menucategoryid) { IList <Johnny.CMS.OM.SystemInfo.Menu> list = new List <Johnny.CMS.OM.SystemInfo.Menu>(); StringBuilder strSql = new StringBuilder(); strSql.Append(" SELECT [MenuId], [MenuName], [cms_menu].[MenuCategoryId], [cms_menucategory].[MenuCategoryName],[PageLink], [ToolTip], [Image], [PermissionId], [IsDisplay], [cms_menu].[Sequence] "); strSql.Append(" FROM [cms_menu] "); strSql.Append(" LEFT OUTER JOIN [cms_menucategory] "); strSql.Append(" ON [cms_menu].[MenuCategoryId] = [cms_menucategory].[MenuCategoryId] "); strSql.Append(" WHERE [cms_menu].[MenuCategoryId]=@menucategoryid"); strSql.Append(" ORDER BY [cms_menucategory].[Sequence],[cms_menu].[Sequence]"); SqlParameter[] parameters = { new SqlParameter("@menucategoryid", SqlDbType.Int, 4) }; parameters[0].Value = menucategoryid; using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters)) { while (sdr.Read()) { Johnny.CMS.OM.SystemInfo.Menu item = new Johnny.CMS.OM.SystemInfo.Menu(sdr.GetInt32(0), sdr.GetString(1), sdr.GetInt32(2), sdr.GetString(3), sdr.GetString(4), sdr.GetString(5), sdr.GetString(6), sdr.GetInt32(7), sdr.GetBoolean(8), sdr.GetInt32(9)); list.Add(item); } } return(list); }
/// <summary> /// Method to get one record by primary key /// </summary> public Johnny.CMS.OM.SystemInfo.Menu GetModel(int menuid) { //Set up a return value Johnny.CMS.OM.SystemInfo.Menu model = null; StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT [MenuId], [MenuName], [MenuCategoryId], [PageLink], [ToolTip], [Image], [PermissionId], [IsDisplay], [Sequence] "); strSql.Append(" FROM [cms_menu] "); strSql.Append(" WHERE [MenuId]=@menuid"); SqlParameter[] parameters = { new SqlParameter("@menuid", SqlDbType.Int, 4) }; parameters[0].Value = menuid; using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters)) { if (sdr.Read()) { model = new Johnny.CMS.OM.SystemInfo.Menu(sdr.GetInt32(0), sdr.GetString(1), sdr.GetInt32(2), sdr.GetString(3), sdr.GetString(4), sdr.GetString(5), sdr.GetInt32(6), sdr.GetBoolean(7), sdr.GetInt32(8)); } else { model = new Johnny.CMS.OM.SystemInfo.Menu(); } } return(model); }
protected override void Page_Load(object sender, EventArgs e) { base.Page_Load(sender, e); Johnny.CMS.OM.SystemInfo.Menu model = new Johnny.CMS.OM.SystemInfo.Menu(); base.ManageTable = model.TableName; base.ManageKey = model.PrimaryKey; base.IsDesc = model.IsDesc; if (!IsPostBack) { myManageGridView.Columns[2].HeaderText = GetLabelText("Menu_MenuCategoryId"); myManageGridView.Columns[3].HeaderText = GetLabelText("Menu_MenuName"); getData(); } }
/// <summary> /// Add one record /// </summary> public int Add(Johnny.CMS.OM.SystemInfo.Menu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("DECLARE @Sequence int"); strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [cms_menu]"); strSql.Append(" if @Sequence is NULL"); strSql.Append(" Set @Sequence=1"); strSql.Append("INSERT INTO [cms_menu]("); strSql.Append("[MenuName],[MenuCategoryId],[PageLink],[ToolTip],[Image],[PermissionId],[IsDisplay],[Sequence]"); strSql.Append(")"); strSql.Append(" VALUES ("); strSql.Append("@menuname,@menucategoryid,@pagelink,@tooltip,@image,@permissionid,@isdisplay,@Sequence"); strSql.Append(")"); strSql.Append(";SELECT @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@menuname", SqlDbType.NVarChar, 50), new SqlParameter("@menucategoryid", SqlDbType.Int, 4), new SqlParameter("@pagelink", SqlDbType.VarChar, 100), new SqlParameter("@tooltip", SqlDbType.NVarChar, 100), new SqlParameter("@image", SqlDbType.VarChar, 200), new SqlParameter("@permissionid", SqlDbType.Int, 4), new SqlParameter("@isdisplay", SqlDbType.Bit) }; parameters[0].Value = model.MenuName; parameters[1].Value = model.MenuCategoryId; parameters[2].Value = model.PageLink; parameters[3].Value = model.ToolTip; parameters[4].Value = model.Image; parameters[5].Value = model.PermissionId; parameters[6].Value = model.IsDisplay; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// Update one record /// </summary> public void Update(Johnny.CMS.OM.SystemInfo.Menu model) { dal.Update(model); }
/// <summary> /// Add one record /// </summary> public int Add(Johnny.CMS.OM.SystemInfo.Menu model) { return(dal.Add(model)); }
protected override void Page_Load(object sender, EventArgs e) { base.Page_Load(sender, e); if (!this.IsPostBack) { litPageTitle.Text = GetLabelText("Menu_Title"); litMenuCategory.Text = GetLabelText("Menu_MenuCategoryId"); ddlCategory.ToolTip = GetLabelText("Menu_MenuCategoryId"); litMenuName.Text = GetLabelText("Menu_MenuName"); txtMenuName.ToolTip = GetLabelText("Menu_MenuName"); litPageLink.Text = GetLabelText("Menu_PageLink"); txtPageLink.ToolTip = GetLabelText("Menu_PageLink"); litToolTip.Text = GetLabelText("Menu_ToolTip"); txtToolTip.ToolTip = GetLabelText("Menu_ToolTip"); litImage.Text = GetLabelText("Menu_Image"); txtImage.ToolTip = GetLabelText("Menu_Image"); litPermission.Text = GetLabelText("Menu_PermissionId"); ddlPermission.ToolTip = GetLabelText("Menu_PermissionId"); litIsDisplay.Text = GetLabelText("Menu_IsDisplay"); rdbDisplay0.Text = GetLabelText("Common_Yes"); rdbDisplay1.Text = GetLabelText("Common_No"); litRdbDisplayTip.Text = GetLabelText("Menu_IsDisplay"); if (Request.QueryString["action"] == "modify") { //get MenuId int MenuId = Convert.ToInt32(Request.QueryString["id"]); //Permission entity Johnny.CMS.BLL.SystemInfo.Menu bll = new Johnny.CMS.BLL.SystemInfo.Menu(); //bind data Johnny.CMS.OM.SystemInfo.Menu model = new Johnny.CMS.OM.SystemInfo.Menu(); model = bll.GetModel(MenuId); CreateddlCategory(); foreach (ListItem item in ddlCategory.Items) { if (DataConvert.GetInt32(item.Value) == model.MenuCategoryId) { item.Selected = true; break; } } txtMenuName.Text = model.MenuName; txtToolTip.Text = model.ToolTip; txtPageLink.Text = model.PageLink; txtImage.Text = model.Image; CreateddlPermission(); foreach (ListItem item in ddlPermission.Items) { if (DataConvert.GetInt32(item.Value) == model.PermissionId) { item.Selected = true; break; } } if (model.IsDisplay) rdbDisplay0.Checked = true; else rdbDisplay1.Checked = true; btnAdd.ButtonType = Johnny.Controls.Web.Button.Button.EnumButtonType.Save; //btnAdd.Text = CONST_BUTTONTEXT_SAVE; } else { CreateddlCategory(); CreateddlPermission(); rdbDisplay0.Checked = true; } //RFVldtMenuName.Text = GetMessage("E00901", txtMenuName.MaxLength.ToString()); //RFVldtPageLink.Text = GetMessage("E00903", txtPageLink.MaxLength.ToString()); } // <zr:ValidationRadioButton ID="rdbDisplay0" runat="server" GroupName="IsDisplay" Text="ÊÇ" IsRequired="True" /> // <zr:ValidationRadioButton ID="rdbDisplay1" runat="server" GroupName="IsDisplay" Text="·ñ" IsRequired="True" /> //<asp:Panel ID="IsDisplayTip" runat="server" class="msgNormal" tip="ÏÔʾÔÚ×ó²à²Ëµ¥À¸Àï">ÏÔʾÔÚ×ó²à²Ëµ¥À¸Àï</asp:Panel> }
protected void btnAdd_Click(object sender, System.EventArgs e) { //check category name if (!CheckInputEmptyAndLength(txtMenuName, "E00901", "E00902", false)) return; //check page url if (!CheckInputEmptyAndLength(txtPageLink, "E00903", "E00904")) return; //tips if (!CheckInputLength(txtToolTip, "E00903", false)) return; //image if (!CheckInputLength(txtImage, "E00903")) return; Johnny.CMS.BLL.SystemInfo.Menu bll = new Johnny.CMS.BLL.SystemInfo.Menu(); Johnny.CMS.OM.SystemInfo.Menu model = new Johnny.CMS.OM.SystemInfo.Menu(); if (Request.QueryString["action"] == "modify") { //update model.MenuId = Convert.ToInt32(Request.QueryString["id"]); model.MenuCategoryId = DataConvert.GetInt32(ddlCategory.SelectedValue); model.MenuName = txtMenuName.Text; model.ToolTip = txtToolTip.Text; model.PageLink = txtPageLink.Text; model.Image = txtImage.Text; model.PermissionId = DataConvert.GetInt32(ddlPermission.SelectedValue); model.IsDisplay = rdbDisplay0.Checked; bll.Update(model); SetMessage(GetMessage("C00003")); } else { //insert model.MenuCategoryId = DataConvert.GetInt32(ddlCategory.SelectedValue); model.MenuName = txtMenuName.Text; model.ToolTip = txtToolTip.Text; model.PageLink = txtPageLink.Text; model.Image = txtImage.Text; model.PermissionId = DataConvert.GetInt32(ddlPermission.SelectedValue); model.IsDisplay = rdbDisplay0.Checked; if (bll.Add(model) > 0) { SetMessage(GetMessage("C00001")); ddlCategory.SelectedIndex = 0; txtMenuName.Text = ""; } else SetMessage(GetMessage("C00002")); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { /* * string strXmlFile = System.Web.HttpRuntime.AppDomainAppPath + "admin/xmlconfig/pagepart.xml"; * //set properties * XmlDocument doc = new XmlDocument(); * doc.Load(strXmlFile); * XmlNodeList nodes = doc.SelectSingleNode("JohnnyCMS").SelectNodes("Page"); * * string currentPage = GetCurrentPageName(); * for (int ix = 0; ix < nodes.Count; ix++) * { * if (currentPage == nodes[ix].Attributes["AddName"].Value || currentPage == nodes[ix].Attributes["ListName"].Value) * { * lblStatus.Text = " "; * //lblCategory.Text = nodes[ix].ChildNodes[0].InnerText; * lblTitle.Text = nodes[ix].ChildNodes[1].InnerText; * hyperlinkAllList.Text = nodes[ix].ChildNodes[2].InnerText; * hyperlinkAllList.NavigateUrl = nodes[ix].ChildNodes[3].InnerText; * hyperlinkAdd.Text = nodes[ix].ChildNodes[4].InnerText; * hyperlinkAdd.NavigateUrl = nodes[ix].ChildNodes[5].InnerText; * if (nodes[ix].Attributes["Single"].Value == "True") * { * lblSeparator.Visible = false; * hyperlinkAdd.Visible = false; * } * break; * } * }*/ //Get current page string currentPage = GetCurrentPageName(); //Get Page Binding Johnny.CMS.BLL.SystemInfo.PageBinding pagebinding = new Johnny.CMS.BLL.SystemInfo.PageBinding(); IList <Johnny.CMS.OM.SystemInfo.PageBinding> bindinglist = pagebinding.GetList(); Johnny.CMS.BLL.SystemInfo.Menu menu = new Johnny.CMS.BLL.SystemInfo.Menu(); IList <Johnny.CMS.OM.SystemInfo.Menu> menulist = menu.GetList(); foreach (var menuitem in menulist) { if (menuitem.PageLink.Equals(currentPage) || menuitem.PageLink.Contains("/" + currentPage)) { foreach (var bindingitem in bindinglist) { if (menuitem.MenuId == bindingitem.ListMenuId || menuitem.MenuId == bindingitem.AddMenuId) { lblStatus.Text = " "; lblTitle.Text = bindingitem.Title; hyperlinkAllList.Text = GlobalizationUtility.GetLabelText("AdminMaster_List"); //hyperlinkAllList.Text = DataConvert.GetString(GetGlobalResourceObject("globaladmin", "AdminMasterLinkButtonList")); Johnny.CMS.OM.SystemInfo.Menu listmenu = menulist.FirstOrDefault(p => p.MenuId == bindingitem.ListMenuId); hyperlinkAllList.NavigateUrl = listmenu.PageLink; //hyperlinkAdd.Text = "Add"; hyperlinkAdd.Text = GlobalizationUtility.GetLabelText("AdminMaster_Add"); Johnny.CMS.OM.SystemInfo.Menu addmenu = menulist.FirstOrDefault(p => p.MenuId == bindingitem.AddMenuId); hyperlinkAdd.NavigateUrl = addmenu.PageLink; if (bindingitem.ListMenuId == bindingitem.AddMenuId) { hyperlinkAllList.Text = bindingitem.Title; lblSeparator.Visible = false; hyperlinkAdd.Visible = false; } break; } } break; } } } }
protected override void Page_Load(object sender, EventArgs e) { base.Page_Load(sender, e); if (!this.IsPostBack) { litPageTitle.Text = GetLabelText("Menu_Title"); litMenuCategory.Text = GetLabelText("Menu_MenuCategoryId"); ddlCategory.ToolTip = GetLabelText("Menu_MenuCategoryId"); litMenuName.Text = GetLabelText("Menu_MenuName"); txtMenuName.ToolTip = GetLabelText("Menu_MenuName"); litPageLink.Text = GetLabelText("Menu_PageLink"); txtPageLink.ToolTip = GetLabelText("Menu_PageLink"); litToolTip.Text = GetLabelText("Menu_ToolTip"); txtToolTip.ToolTip = GetLabelText("Menu_ToolTip"); litImage.Text = GetLabelText("Menu_Image"); txtImage.ToolTip = GetLabelText("Menu_Image"); litPermission.Text = GetLabelText("Menu_PermissionId"); ddlPermission.ToolTip = GetLabelText("Menu_PermissionId"); litIsDisplay.Text = GetLabelText("Menu_IsDisplay"); rdbDisplay0.Text = GetLabelText("Common_Yes"); rdbDisplay1.Text = GetLabelText("Common_No"); litRdbDisplayTip.Text = GetLabelText("Menu_IsDisplay"); if (Request.QueryString["action"] == "modify") { //get MenuId int MenuId = Convert.ToInt32(Request.QueryString["id"]); //Permission entity Johnny.CMS.BLL.SystemInfo.Menu bll = new Johnny.CMS.BLL.SystemInfo.Menu(); //bind data Johnny.CMS.OM.SystemInfo.Menu model = new Johnny.CMS.OM.SystemInfo.Menu(); model = bll.GetModel(MenuId); CreateddlCategory(); foreach (ListItem item in ddlCategory.Items) { if (DataConvert.GetInt32(item.Value) == model.MenuCategoryId) { item.Selected = true; break; } } txtMenuName.Text = model.MenuName; txtToolTip.Text = model.ToolTip; txtPageLink.Text = model.PageLink; txtImage.Text = model.Image; CreateddlPermission(); foreach (ListItem item in ddlPermission.Items) { if (DataConvert.GetInt32(item.Value) == model.PermissionId) { item.Selected = true; break; } } if (model.IsDisplay) { rdbDisplay0.Checked = true; } else { rdbDisplay1.Checked = true; } btnAdd.ButtonType = Johnny.Controls.Web.Button.Button.EnumButtonType.Save; //btnAdd.Text = CONST_BUTTONTEXT_SAVE; } else { CreateddlCategory(); CreateddlPermission(); rdbDisplay0.Checked = true; } //RFVldtMenuName.Text = GetMessage("E00901", txtMenuName.MaxLength.ToString()); //RFVldtPageLink.Text = GetMessage("E00903", txtPageLink.MaxLength.ToString()); } // <zr:ValidationRadioButton ID="rdbDisplay0" runat="server" GroupName="IsDisplay" Text="ÊÇ" IsRequired="True" /> // <zr:ValidationRadioButton ID="rdbDisplay1" runat="server" GroupName="IsDisplay" Text="·ñ" IsRequired="True" /> //<asp:Panel ID="IsDisplayTip" runat="server" class="msgNormal" tip="ÏÔʾÔÚ×ó²à²Ëµ¥À¸Àï">ÏÔʾÔÚ×ó²à²Ëµ¥À¸Àï</asp:Panel> }
protected void btnAdd_Click(object sender, System.EventArgs e) { //check category name if (!CheckInputEmptyAndLength(txtMenuName, "E00901", "E00902", false)) { return; } //check page url if (!CheckInputEmptyAndLength(txtPageLink, "E00903", "E00904")) { return; } //tips if (!CheckInputLength(txtToolTip, "E00903", false)) { return; } //image if (!CheckInputLength(txtImage, "E00903")) { return; } Johnny.CMS.BLL.SystemInfo.Menu bll = new Johnny.CMS.BLL.SystemInfo.Menu(); Johnny.CMS.OM.SystemInfo.Menu model = new Johnny.CMS.OM.SystemInfo.Menu(); if (Request.QueryString["action"] == "modify") { //update model.MenuId = Convert.ToInt32(Request.QueryString["id"]); model.MenuCategoryId = DataConvert.GetInt32(ddlCategory.SelectedValue); model.MenuName = txtMenuName.Text; model.ToolTip = txtToolTip.Text; model.PageLink = txtPageLink.Text; model.Image = txtImage.Text; model.PermissionId = DataConvert.GetInt32(ddlPermission.SelectedValue); model.IsDisplay = rdbDisplay0.Checked; bll.Update(model); SetMessage(GetMessage("C00003")); } else { //insert model.MenuCategoryId = DataConvert.GetInt32(ddlCategory.SelectedValue); model.MenuName = txtMenuName.Text; model.ToolTip = txtToolTip.Text; model.PageLink = txtPageLink.Text; model.Image = txtImage.Text; model.PermissionId = DataConvert.GetInt32(ddlPermission.SelectedValue); model.IsDisplay = rdbDisplay0.Checked; if (bll.Add(model) > 0) { SetMessage(GetMessage("C00001")); ddlCategory.SelectedIndex = 0; txtMenuName.Text = ""; } else { SetMessage(GetMessage("C00002")); } } }