public ActionResult ViewThongTinChiTietDanhMuc(int IdDanhMuc) { Sys_MenuController ctrlSysMenu = new Sys_MenuController(); SYS_MENU objSysMenu = ctrlSysMenu.GetItemByID("ID_SYS_MENU", IdDanhMuc); return(PartialView("~/Views/TreeMenuManage/_ThongTinChiTietDanhMuc.cshtml", objSysMenu)); }
public ActionResult SaveThongTinChiTietDanhMuc(SYS_MENU objSysMenu) { Sys_MenuController ctrlSysMenu = new Sys_MenuController(); objSysMenu.UPDATEAT = DateTime.Now; ctrlSysMenu.UpdateItem(objSysMenu); return(PartialView("~/Views/TreeMenuManage/_ThongTinChiTietDanhMuc.cshtml", objSysMenu)); }
public List <EasyUITreeNode> GetMyMenuListTree() { List <string> listMuenId = oc.UserMenuPermission //.Where(u=>!Constant.GISTwoMenu.Split(',').Contains(u.MENU_ID)) .Select(u => u.MENU_ID).ToList(); //获得组织 List <SYS_MENU> listMenu = oc.BllSession.ISYS_MENUService.Entities.Where(m => listMuenId.Contains(m.MENU_ID) && m.MENU_LEVEL <= 3).OrderBy(m => m.MENU_ID).OrderBy(m => m.MENU_ORDER).ToList(); return(SYS_MENU.ConvertTreeNodes(listMenu, "0")); }
public ActionResult GetMyMenuListTree() { List <string> listMuenId = oc.UserMenuPermission .Where(u => string.IsNullOrEmpty(u.GIS_ORDER)).Select(u => u.MENU_ID).ToList(); List <SYS_MENU> listMenu = oc.BllSession.ISYS_MENUService.Entities .Where(m => listMuenId.Contains(m.MENU_ID) && m.MENU_LEVEL < 3 ) .OrderBy(m => m.MENU_ID).OrderBy(m => m.MENU_ORDER).ToList(); return(Content(ObjToJson.GetToJson(SYS_MENU.ConvertTreeNodes(listMenu, "0")))); }
public ActionResult SaveTaoMoiDanhMuc(SYS_MENU objSysMenu) { Sys_MenuController ctrlSysMenu = new Sys_MenuController(); objSysMenu.CREATEDATE = DateTime.Now; objSysMenu.Status = true; ctrlSysMenu.CreateItem(objSysMenu); var newSysMenu = new SYS_MENU(); newSysMenu.CAPDO = objSysMenu.CAPDO; newSysMenu.DANHMUCCHA = objSysMenu.DANHMUCCHA; return(PartialView("~/Views/TreeMenuManage/_TaoMoiDanhMuc.cshtml", newSysMenu)); }
/// <summary> /// 填充数据 /// </summary> private void FillData() { var menu = SYS_MENU.SingleOrDefault(Sql.Builder.Where("Id=@0", Id)); if (menu != null) { Name.Text = menu.Name; SortIndex.Text = menu.SortIndex.ToString(); NavigateUrl.Text = menu.NavigateUrl; ParentId.SelectedValue = menu.ParentId.ToString(); ImageUrl.Text = menu.ImageUrl; iconList.SelectedValue = menu.ImageUrl; } }
public ActionResult GetMyOneMenu() { string strJson = "[]"; //获取用户默认子系统menuid string defuMenuID = GetDefuMenu(); if (!string.IsNullOrEmpty(defuMenuID)) { SYS_MENU parMenu = oc.BllSession.ISYS_MENUService.Entities.Where(u => u.MENU_ID.Equals(defuMenuID)).FirstOrDefault(); string defuMenu = string.Empty; try { if (!string.IsNullOrEmpty(parMenu.DEFMENU_ID)) { defuMenu = parMenu.DEFMENU_ID.Substring(0, 4); } } catch { defuMenu = string.Empty; } List <SYS_MENU> listMenu = oc.UserMenuPermission.Where(m => m.PARENT_ID.Equals(defuMenuID) //&& !Constant.PersonLocationMenuID.Split(',').Contains(m.MENU_ID) && string.IsNullOrEmpty(m.GIS_ORDER)).OrderBy(m => m.MENU_ORDER).ToList(); //.OrderByDescending(m => m.GIS_ORDER).ThenBy(m => m.MENU_ORDER).ToList(); if (listMenu.Count > 0) { if (string.IsNullOrEmpty(defuMenu)) { defuMenu = listMenu[0].MENU_ID; } List <EasyUITreeNode> listTreeNodes = SYS_MENU.ConvertTreeNodes(listMenu, defuMenuID); foreach (EasyUITreeNode node in listTreeNodes) { if (node.id.Equals(defuMenu)) { node.isdefuopen = "Y"; } else { node.isdefuopen = "N"; } } strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked"); } } return(Content(strJson)); }
////// <summary> ////// 分页查询 ////// </summary> ////// <param name="pageIndex"></param> ////// <param name="pageSize"></param> ////// <param name="whLamdba"></param> ////// <param name="recordCount"></param> ////// <param name="pageCount"></param> ////// <returns></returns> ///public List<SYS_MENU> PageQuery<TKey>(int pageIndex, int pageSize, Expression<Func<SYS_MENU, bool>> whLamdba,Expression<Func<SYS_MENU, TKey>> orderByLamdba, out int recordCount, out int pageCount) ///{ /// List<SYS_MENU> list = null; /// try /// { /// if (pageIndex == 0) /// { /// pageIndex = 1; /// } /// list = idal.PageQuery(pageIndex, pageSize, out recordCount, out pageCount, whLamdba, orderByLamdba); /// } /// catch (Exception ex) /// { /// recordCount = 0; /// pageCount = 0; /// Logger.Error(string.Format("SYS_MENU_BLL 分页查询异常,异常信息:{0}", ex.ToString())); /// } /// return list; ///} /// <summary> /// 分页查询 /// </summary> /// <param name="modle"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="recordCount"></param> /// <param name="pageCount"></param> /// <returns></returns> public DataTable PageQuery(SYS_MENU modle, int pageIndex, int pageSize, out int recordCount, out int pageCount) { DataTable dt = new DataTable(); using (var dbcontext = DbFactory.Create()) { try { SearchCondition condition = new SearchCondition(); if (modle != null) { #region 组装查询条件 //if (!string.IsNullOrWhiteSpace(modle.PlayerNickname)) //{ // condition.AddCondition("a.PlayerNickname", modle.PlayerNickname, SqlOperator.Like, true); //} #endregion } PagerInfo pager = new PagerInfo(); #region 组装存储过程调用参数 //pager.curPage = pageIndex; //pager.pageSize = pageSize; //pager.isDescending = true; //pager.fields = "a.*,c.GameName"; //pager.sortField = "a.UploadTime"; //pager.indexField = "a.ID"; //pager.where = null; //pager.condition = condition; //pager.tableName = "[ZhpGame].[dbo].[Zhp_GameRecord] a left join [Zhp_OnlineGame] b on a.Gameid=b.Gameid left join [Zhp_GameConfig] c on b.GameCode= c.GameCode "; #endregion dt = dbcontext.PageQuery(pager, out recordCount, out pageCount); } catch (Exception ex) { recordCount = 0; pageCount = 0; Logger.Error(string.Format("SYS_MENU_BLL 分页查询异常,异常信息:{0}", ex.ToString())); } } return(dt); }
/// <summary> /// 获取数据 /// </summary> protected override void LoadData() { var menus = SYS_MENU.Fetch(Sql.Builder.Where("Active = @0", true)); //拼接查询的SQL var search = ttbFullTextSearch.Text; if (!string.IsNullOrEmpty(search)) { menus = menus.Where(m => m.Name == search).ToList(); } if (!string.IsNullOrEmpty(MainPanel.SortField)) { //排序 } MainPanel.RecordCount = menus.Count; MainPanel.DataSource = menus; MainPanel.DataBind(); }
/// <summary> /// 根据主键获取实体 /// </summary> /// <param name="pkId">主键</param> /// <returns></returns> public SYS_MENU GetById(string pkId) { SYS_MENU model = null; using (var dbcontext = DbFactory.Create()) { try { int id = Convert.ToInt32(pkId); Expression <Func <SYS_MENU, bool> > exp = a => a.ID == id; model = dbcontext.Get(exp); } catch (Exception ex) { Logger.Error(string.Format("SYS_MENU_BLL 根据主键获取实体异常,异常信息:{0}", ex.ToString())); } } return(model); }
/// <summary> /// 编辑 /// </summary> /// <param name="model">新实体</param> /// <returns></returns> public bool Edit(SYS_MENU model) { bool success = false; using (var dbcontext = DbFactory.Create()) { try { dbcontext.Update(model); dbcontext.Save(); success = true; } catch (Exception ex) { success = false; Logger.Error(string.Format("SYS_MENU_BLL 编辑记录异常,异常信息:{0}", ex.ToString())); } } return(success); }
/// <summary> /// 根据条件获取列表 /// </summary> /// <param name="querymodel">条件</param> /// <returns></returns> public List <SYS_MENU> GetList(SYS_MENU querymodel) { List <SYS_MENU> list = null; using (var dbcontext = DbFactory.Create()) { try { int id = Convert.ToInt32(querymodel.ID); Expression <Func <SYS_MENU, bool> > exp = a => a.ID == id; Expression <Func <SYS_MENU, bool> > temp = a => 1 == 1; exp = CompileLinqSearch.AndAlso(exp, temp); list = dbcontext.Find(exp); } catch (Exception ex) { Logger.Error(string.Format("SYS_MENU_BLL 根据条件获取列表异常,异常信息:{0}", ex.ToString())); } } return(list); }
public ActionResult GetMyZeroMenu() { string strJson = "[]"; List <SYS_MENU> listMenu = oc.BllSession.ISYS_MENUService.Entities .Where(m => m.PARENT_ID.Equals(Constant.systemParID)).OrderBy(m => m.MENU_ORDER).ToList();// oc.BllSession.ISYS_MENUService.Entities.ToList();//.GetListByCondition<decimal?>(null, ma => ma.MENU_LEVEL).Select(mb => mb.ToPOCO()).ToList(); //2015-11-06 新增不显示菜单 listMenu = listMenu.Where(u => string.IsNullOrEmpty(u.ISSHOW_FLAG) || (!string.IsNullOrEmpty(u.ISSHOW_FLAG) && !u.ISSHOW_FLAG.Equals("0"))).ToList(); //List<string> showlistMenu=listMenu.Select(u=>u.MENU_ID).ToList(); if (listMenu.Count > 0) { List <EasyUITreeNode> listTreeNodes = SYS_MENU.ConvertTreeNodes(listMenu, Constant.systemParID); //获取用户拥有权限的子系统 List <string> hasPermissionSyss = oc.UserMenuPermission.Where(u => u.PARENT_ID.Equals(Constant.systemParID)).OrderBy(u => u.MENU_ORDER) .Select(u => u.MENU_ID).ToList(); //获取用户默认子系统 string defuMenuID = GetDefuMenu(); foreach (EasyUITreeNode node in listTreeNodes) { if (node.id.Equals(defuMenuID)) { node.isdefu = "Y"; } else { node.isdefu = "N"; } if (hasPermissionSyss.Contains(node.id)) { node.haspermission = "Y"; } else { node.haspermission = "N"; } } strJson = ObjToJson.GetToJson(listTreeNodes.OrderByDescending(m => m.haspermission)).Replace("Checked", "checked"); } return(Content(strJson)); }
/// <summary> /// 保存表单数据 /// </summary> protected override void SaveForm() { SYS_MENU menu; switch (Action) { case ACTION.INSERT: menu = new SYS_MENU { Name = Name.Text, ImageUrl = ImageUrl.Text, NavigateUrl = NavigateUrl.Text, ParentId = ParentId.Text.ToInt64(), SortIndex = SortIndex.Text.ToInt32() }; menu.Insert(); MenuHelper.Reload(); break; case ACTION.UPDATE: menu = SYS_MENU.SingleOrDefault(Sql.Builder.Where("Id=@0", Id)); if (menu != null) { menu.Name = Name.Text; menu.ImageUrl = ImageUrl.Text; menu.NavigateUrl = NavigateUrl.Text; menu.ParentId = ParentId.Text.ToInt64(); menu.SortIndex = SortIndex.Text.ToInt32(); menu.Update(); MenuHelper.Reload(); } break; case ACTION.DETAIL: break; default: break; } }
/// <summary> /// 导航栏项目选中事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) { TreeNode CurrentNode = e.Node;//获取当前选中的节点 if (CurrentNode.Tag != null) { string menu_code = CurrentNode.Tag.ToString(); //根据Menu_code查询对应的Menu_Unit打开相应的窗体 SYS_MENU_BLL bll = new SYS_MENU_BLL(); SYS_MENU menu = bll.GetMenuByCode(menu_code); //tring formName = menu.MENU_UNIT; string strnamespace = "MyERP.UI";//根据你自己的命名空间来修改 string strfrm = menu.MENU_UNIT; //注意:要动态打开的窗体要放在MyERP.UI根目录下一行才能找到 (strnamespace + "." + strfrm) Form frm = (Form)Assembly.Load(strnamespace).CreateInstance(strnamespace + "." + strfrm); if (frm != null) { Add_TabPage(menu.MENU_NAME, frm); } } }
/// <summary> /// 根据用户编号得到对应的权限信息 /// </summary> /// <param name="USER_NAME">用户名</param> /// <returns>权限集合</returns> public static List <SYS_MENU> GetUserPermission(string USER_NAME) { //获取不显示的菜单编号(集合) List <SYS_MENU> AllMenu = oc.BllSession.ISYS_MENUService.Entities.ToList(); List <string> noShowIDtemp = AllMenu.Where(u => (!string.IsNullOrEmpty(u.ISSHOW_FLAG) && u.ISSHOW_FLAG.Equals("0"))) .Select(u => u.MENU_ID).ToList(); List <string> noShowIDs = new List <string>(); foreach (string menuid in noShowIDtemp) { List <string> noShowTempIDList = AllMenu.Where(u => u.MENU_ID.StartsWith(menuid)).Select(u => u.MENU_ID).ToList(); noShowIDs.AddRange(noShowTempIDList); } //--根据用户名得到角色编号(集合) List <string> listRoleId = oc.BllSession.ISYS_USER_ROLE_MAPService.Entities.Where(u => u.USER_NAME == USER_NAME) .Select(u => u.ROLE_ID).ToList(); #region 原写法 //根据角色编号得到菜单权限编号(集合) //List<string> listMenuIds = oc.BllSession.ISYS_ROLE_MENU_MAPService.Entities.Where(rp => listRoleId.Contains(rp.ROLE_ID) // && !noShowIDs.Contains(rp.MENU_ID)) // .Select(rp => rp.MENU_ID).ToList(); ////根据权限编号得到权限的具体信息 //List<SYS_MENU> listMenu = oc.BllSession.ISYS_MENUService.Entities.Where(p => listMenuIds.Contains(p.MENU_ID) && !noShowIDs.Contains(p.MENU_ID)) // .ToList().Select(u => u.ToPOCO()).ToList(); ////根据角色编号得到菜单按纽权限编号(集合) //List<string> listMenuOptIds = oc.BllSession.ISYS_ROLE_MENUOPT_MAPService.Entities.Where(rp => listRoleId.Contains(rp.ROLE_ID)) // .Select(rp => rp.MENUOPT_ID).ToList(); ////根据权限编号得到权限的具体信息 //List<SYS_MENU> listBM = oc.BllSession.ISYS_MENUOPTService.Entities.Where(p => listMenuOptIds.Contains(p.MENUOPT_ID) && !noShowIDs.Contains(p.MENU_ID)).ToList() // .Select(u => new SYS_MENU // { // MENU_ID = u.MENUOPT_ID, // AREA = u.AREA, // CONTROLLER = u.CONTROLLER, // ACTION = u.ACTION, // MENU_NAME = u.MENUOPT_NAME, // C_ICO = u.C_ICO, // MENU_LEVEL = 100, // PARENT_ID = "100" // }).ToList(); //listMenu.AddRange(listBM); #endregion #region 新写法 //根据角色编号得到菜单权限编号(集合) List <SYS_ROLE_MENU_MAP> listMenus = oc.BllSession.ISYS_ROLE_MENU_MAPService.Entities.ToList(); List <string> listMenuIds = (from menuMap in listMenus join roleid in listRoleId on menuMap.ROLE_ID equals roleid select menuMap.MENU_ID).Distinct().ToList(); for (int i = 0; i < noShowIDs.Count; i++) { if (listMenuIds.Contains(noShowIDs[i])) { listMenuIds.Remove(noShowIDs[i]); } } //根据权限编号得到权限的具体信息 List <SYS_MENU> listsysMenus = oc.BllSession.ISYS_MENUService.Entities.ToList(); List <SYS_MENU> listMenu_temp = (from sys_menu in listsysMenus join menuid in listMenuIds on sys_menu.MENU_ID equals menuid select sys_menu).ToList(); List <SYS_MENU> listMenu = new List <SYS_MENU>(); SYS_MENU modelMenu = new SYS_MENU(); for (int i = 0; i < listMenu_temp.Count; i++) { modelMenu = listMenu_temp[i]; if (!noShowIDs.Contains(modelMenu.MENU_ID)) { listMenu.Add(modelMenu); } } //根据角色编号得到菜单按纽权限编号(集合) List <SYS_ROLE_MENUOPT_MAP> listmMenuoptMaps = oc.BllSession.ISYS_ROLE_MENUOPT_MAPService.Entities.ToList(); List <string> listMenuOptIds = (from menuopt in listmMenuoptMaps join roleid in listRoleId on menuopt.ROLE_ID equals roleid select menuopt.MENUOPT_ID).Distinct().ToList(); //根据权限编号得到权限的具体信息 List <SYS_MENUOPT> listmenuopt = oc.BllSession.ISYS_MENUOPTService.Entities.ToList(); List <SYS_MENU> listBM_temp = (from u in listmenuopt join menuoptid in listMenuOptIds on u.MENUOPT_ID equals menuoptid select new SYS_MENU { MENU_ID = u.MENUOPT_ID, AREA = u.AREA, CONTROLLER = u.CONTROLLER, ACTION = u.ACTION, MENU_NAME = u.MENUOPT_NAME, C_ICO = u.C_ICO, MENU_LEVEL = 100, PARENT_ID = "100" }).ToList(); List <SYS_MENU> listBM = new List <SYS_MENU>(); for (int i = 0; i < listBM_temp.Count; i++) { modelMenu = listBM_temp[i]; if (!noShowIDs.Contains(modelMenu.MENU_ID)) { listBM.Add(modelMenu); } } listMenu.AddRange(listBM); #endregion return(listMenu.OrderBy(u => u.MENU_ID).ToList()); }
public ActionResult GetMyMenu(string id) { string strJson = "[]"; //if (Constant.GISMenuID.Split(',').Contains(id)) //{ // //如果是获取GIS二级菜单 // List<SYS_MENU> listMenu = oc.BllSession.ISYS_MENUService.Entities // .Where(m => m.MENU_LEVEL != Constant.MyMenuLevel && m.PARENT_ID.StartsWith(id)) // .OrderBy(m => m.MENU_ORDER).ToList();// oc.BllSession.ISYS_MENUService.Entities.ToList();//.GetListByCondition<decimal?>(null, ma => ma.MENU_LEVEL).Select(mb => mb.ToPOCO()).ToList(); // if (listMenu.Count > 0) // { // List<EasyUITreeNode> listTreeNodes = SYS_MENU.ConvertTreeNodes(listMenu, id); // strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked"); // } //} //else //{ //根据选择的一级菜单找对应模块默认打开的三级页面 string parID = id.Substring(0, 2); SYS_MENU parMenu = oc.BllSession.ISYS_MENUService.Entities.Where(u => u.MENU_ID.Equals(parID)).FirstOrDefault(); string twoMenuID = string.Empty; string threeMenuID = string.Empty; try { if (!string.IsNullOrEmpty(parMenu.DEFMENU_ID)) { twoMenuID = parMenu.DEFMENU_ID.Substring(0, 6); threeMenuID = parMenu.DEFMENU_ID.Substring(0, 8); } } catch { twoMenuID = string.Empty; threeMenuID = string.Empty; } List <SYS_MENU> listMenu = oc.UserMenuPermission.Where(m => m.MENU_LEVEL != Constant.MyMenuLevel && m.PARENT_ID.StartsWith(id)).OrderBy(m => m.MENU_LEVEL) .ThenBy(m => m.MENU_ORDER).ToList();// oc.BllSession.ISYS_MENUService.Entities.ToList();//.GetListByCondition<decimal?>(null, ma => ma.MENU_LEVEL).Select(mb => mb.ToPOCO()).ToList(); if (listMenu.Count > 0) { if (string.IsNullOrEmpty(twoMenuID)) { SYS_MENU firstThreeMenu = listMenu.Where(u => u.MENU_LEVEL == 3).FirstOrDefault(); if (firstThreeMenu != null) { twoMenuID = firstThreeMenu.MENU_ID.Substring(0, 6); threeMenuID = firstThreeMenu.MENU_ID; } } List <EasyUITreeNode> listTreeNodes = SYS_MENU.ConvertTreeNodes(listMenu, id); foreach (EasyUITreeNode node in listTreeNodes) { if (node.id.Equals(twoMenuID)) { node.isdefuopen = "Y"; } else { node.isdefuopen = "N"; } foreach (EasyUITreeNode Childnode in node.children) { if (Childnode.id.Equals(threeMenuID)) { Childnode.isdefuopen = "Y"; } else { Childnode.isdefuopen = "N"; } } } strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked"); } //} return(Content(strJson)); }
/// <summary> /// 隐藏超级用户权限 /// </summary> /// <returns></returns> public static List <SYS_MENU> GetSuperAdminPermission() { //获取所有菜单 List <SYS_MENU> listMenu = oc.BllSession.ISYS_MENUService.Entities.ToList(); List <SYS_MENU> listthreemenu = listMenu.Where(m => m.MENU_LEVEL == Constant.threeMenuLevel).Select(m => m.ToPOCO()).ToList(); foreach (SYS_MENU menu in listthreemenu) { //手动添加三级菜单权限 if (menu.MENU_LEVEL == Constant.threeMenuLevel) { SYS_MENU menuopt_add = new SYS_MENU { MENU_ID = menu + "001", AREA = menu.AREA, CONTROLLER = menu.CONTROLLER, ACTION = "Add", MENU_NAME = menu.MENU_NAME + Message.AddOpt, C_ICO = menu.C_ICO, MENU_LEVEL = 100, PARENT_ID = "100" }; listMenu.Add(menuopt_add); SYS_MENU menuopt_list = new SYS_MENU { MENU_ID = menu + "002", AREA = menu.AREA, CONTROLLER = menu.CONTROLLER, ACTION = "List", MENU_NAME = menu.MENU_NAME + Message.ReadOpt, C_ICO = menu.C_ICO, MENU_LEVEL = 100, PARENT_ID = "100" }; listMenu.Add(menuopt_list); SYS_MENU menuopt_edit = new SYS_MENU { MENU_ID = menu + "003", AREA = menu.AREA, CONTROLLER = menu.CONTROLLER, ACTION = "Edit", MENU_NAME = menu.MENU_NAME + Message.EditOpt, C_ICO = menu.C_ICO, MENU_LEVEL = 100, PARENT_ID = "100" }; listMenu.Add(menuopt_edit); SYS_MENU menuopt_del = new SYS_MENU { MENU_ID = menu + "004", AREA = menu.AREA, CONTROLLER = menu.CONTROLLER, ACTION = "Del", MENU_NAME = menu.MENU_NAME + Message.DelOpt, C_ICO = menu.C_ICO, MENU_LEVEL = 100, PARENT_ID = "100" }; listMenu.Add(menuopt_del); } } return(listMenu.OrderBy(u => u.MENU_ID).ToList()); }