protected void btnSend_Click(object sender, EventArgs e) { Test_BUL.sys_Common common = new Test_BUL.sys_Common(); DataSet ds = common.GetList(" select menuName from tb_sys_sysmenu where menuName='" + this.txtMenuName.Value.Trim() + "' "); if (!Tools.Validator.CheckDataSet(ds, 0)) { Test_Model.sys_sysmenu sysmenuModel = new Test_Model.sys_sysmenu(); sysmenuModel.menuName = this.txtMenuName.Value.Trim(); string imgUrl = this.txtMenuImg.Value.Trim(); sysmenuModel.imgUrl = imgUrl != "" ? imgUrl : "../Images/Ico/null.gif"; sysmenuModel.menuOrder = Tools.StringHelp.GetInt(this.txtIntOrder.Value.Trim()); sysmenuModel.addName = adminGetCount; sysmenuModel.addTime = DateTime.Now; Test_BUL.sys_sysmenu sysmenu = new Test_BUL.sys_sysmenu(); if (sysmenu.Add(sysmenuModel) > 0) { Response.Redirect("Manage_Menu.aspx"); } else { FinalMessage("新增用户失败!", "Add_Menu.aspx", 1); } } }
/// <summary> /// 获取菜单HTML /// </summary> /// <returns></returns> private string GetMenuHTML() { if (string.IsNullOrEmpty(FileItems)) return ""; Test_BUL.sys_Common common = new Test_BUL.sys_Common(); DataSet ds = common.GetList(" select id,menuName,imgUrl from tb_sys_sysmenu order by menuOrder asc "); if (Tools.Validator.CheckDataSet(ds, 0)) { Test_BUL.sys_sysmenu bulMenu = new Test_BUL.sys_sysmenu(); return bulMenu.GetSystemMenu(ds, FileItems); } return ""; }
/// <summary> /// 获取数据 /// </summary> /// <returns></returns> public DataSet GetInfoDS() { Test_BUL.sys_sysmenu bulMenu = new Test_BUL.sys_sysmenu(); DataSet ds = bulMenu.GetAllList(); if (Tools.Validator.CheckDataSet(ds, 0)) { int count = ds.Tables[0].Rows.Count; ds.Tables[0].Columns.Add("NoLi"); for (int i = 0; i < count; i++) ds.Tables[0].Rows[i]["NoLi"] = (i + 1).ToString(); return ds; } else return null; }
/// <summary> /// 获取菜单HTML /// </summary> /// <returns></returns> private string GetMenuHTML() { if (string.IsNullOrEmpty(FileItems)) { return(""); } Test_BUL.sys_Common common = new Test_BUL.sys_Common(); DataSet ds = common.GetList(" select id,menuName,imgUrl from tb_sys_sysmenu order by menuOrder asc "); if (Tools.Validator.CheckDataSet(ds, 0)) { Test_BUL.sys_sysmenu bulMenu = new Test_BUL.sys_sysmenu(); return(bulMenu.GetSystemMenu(ds, FileItems)); } return(""); }
/// <summary> /// 获取菜单HTML /// </summary> private void LoadMenu() { //重新获取用户权限页面id集合,并写入缓存 DataSet SysAdminDS = common.GetList(" select pageId from tb_sys_role where id=" + adminGetRoleId); Tools.CacheUtil.InsertCach(Test_BUL.sysParam.CachePageIdDs, (object)SysAdminDS, Test_BUL.sysParam.CachePageIdDsTimes, 2); string FileItems = SysAdminDS.Tables[0].Rows[0]["pageId"].ToString();//1,2,3,4,5,6,7,8,9... if (string.IsNullOrEmpty(FileItems)) return; //获取所有系统菜单 DataSet ds = common.GetList(" select id,menuName,imgUrl from tb_sys_sysmenu order by menuOrder asc "); if (Tools.Validator.CheckDataSet(ds, 0)) { Test_BUL.sys_sysmenu bulMenu = new Test_BUL.sys_sysmenu(); _response = bulMenu.GetSystemMenu(ds, FileItems); } }
/// <summary> /// 获取数据 /// </summary> /// <returns></returns> public DataSet GetInfoDS() { Test_BUL.sys_sysmenu bulMenu = new Test_BUL.sys_sysmenu(); DataSet ds = bulMenu.GetAllList(); if (Tools.Validator.CheckDataSet(ds, 0)) { int count = ds.Tables[0].Rows.Count; ds.Tables[0].Columns.Add("NoLi"); for (int i = 0; i < count; i++) { ds.Tables[0].Rows[i]["NoLi"] = (i + 1).ToString(); } return(ds); } else { return(null); } }
protected void btnSend_Click(object sender, EventArgs e) { Test_BUL.sys_Common common = new Test_BUL.sys_Common(); DataSet ds = common.GetList(" select menuName from tb_sys_sysmenu where menuName='" + this.txtMenuName.Value.Trim() + "' "); if (!Tools.Validator.CheckDataSet(ds, 0)) { Test_Model.sys_sysmenu sysmenuModel = new Test_Model.sys_sysmenu(); sysmenuModel.menuName = this.txtMenuName.Value.Trim(); string imgUrl = this.txtMenuImg.Value.Trim(); sysmenuModel.imgUrl = imgUrl != "" ? imgUrl : "../Images/Ico/null.gif"; sysmenuModel.menuOrder = Tools.StringHelp.GetInt(this.txtIntOrder.Value.Trim()); sysmenuModel.addName = adminGetCount; sysmenuModel.addTime = DateTime.Now; Test_BUL.sys_sysmenu sysmenu = new Test_BUL.sys_sysmenu(); if (sysmenu.Add(sysmenuModel) > 0) Response.Redirect("Manage_Menu.aspx"); else FinalMessage("新增用户失败!", "Add_Menu.aspx", 1); } }
/// <summary> /// 获取菜单HTML /// </summary> private void LoadMenu() { //重新获取用户权限页面id集合,并写入缓存 DataSet SysAdminDS = common.GetList(" select pageId from tb_sys_role where id=" + adminGetRoleId); Tools.CacheUtil.InsertCach(Test_BUL.sysParam.CachePageIdDs, (object)SysAdminDS, Test_BUL.sysParam.CachePageIdDsTimes, 2); string FileItems = SysAdminDS.Tables[0].Rows[0]["pageId"].ToString();//1,2,3,4,5,6,7,8,9... if (string.IsNullOrEmpty(FileItems)) { return; } //获取所有系统菜单 DataSet ds = common.GetList(" select id,menuName,imgUrl from tb_sys_sysmenu order by menuOrder asc "); if (Tools.Validator.CheckDataSet(ds, 0)) { Test_BUL.sys_sysmenu bulMenu = new Test_BUL.sys_sysmenu(); _response = bulMenu.GetSystemMenu(ds, FileItems); } }