//从一个用户组中删除一个权限菜单 public List <string> DelPermissionMenuFromGroup(int menuId, int groupId) { using (VanchBgDataContext vdc = new VanchBgDataContext()) { user_group_menu data = vdc.user_group_menus.FirstOrDefault <user_group_menu>(c => c.fk_menu_id == menuId && c.fk_user_group_id == groupId && c.delete_date == null); data.delete_date = DateTime.Now; vdc.SubmitChanges(); //假如删除的是在线客服权限菜单,返回该用户组中的用户编号 List <string> userWorkNumList = null; if (menuId == 4) { userWorkNumList = (from c in vdc.internal_users where c.fk_user_group_id == groupId select c.work_num).ToList(); } return(userWorkNumList); } }
//添加一个权限菜单到一个用户组中 public List <string> AddPermissionMenuToGroup(int menuId, int groupId) { using (VanchBgDataContext vdc = new VanchBgDataContext()) { user_group_menu data = new user_group_menu(); data.fk_menu_id = menuId; data.fk_user_group_id = groupId; vdc.user_group_menus.InsertOnSubmit(data); vdc.SubmitChanges(); //假如添加的是在线客服权限菜单,返回该用户组中的用户编号 List <string> userWorkNumList = null; if (menuId == 4) { userWorkNumList = (from c in vdc.internal_users where c.fk_user_group_id == groupId select c.work_num).ToList(); } return(userWorkNumList); } }