Epicor图层配置的菜单查询

查询语句：
select * from ice.Menu where Program like 'Erp.UI.PartEntry.dll'
关键字段：WebResourceURL
 
快速查看层级：
;WITH Ancestors  AS
(
    -- 基础节点（起始节点）
    SELECT MenuID, ParentMenuID,MenuDesc,0 as deep
    FROM ice.Menu
    WHERE MenuID = 'FSMN1000'
 
    UNION ALL
 
    -- 递归查找子节点
    SELECT c.MenuID, c.ParentMenuID,c.MenuDesc,p.deep+1 as deep
    FROM ice.Menu c
    INNER JOIN Ancestors  p ON c.MenuID = p.ParentMenuID
)
 
 
SELECT * FROM Ancestors OPTION (MAXRECURSION 0)