功能菜单 查询 SQL语句原创
18人赞赏了该文章
1,139次浏览
编辑于2022年08月31日 16:20:24
SQL查询语句
select DL.FNAME AS '领域',CL.FNAME AS '子系统',BL.FNAME as '功能分组',AL.FNAME as '功能',A.FNUMBER as '编码',FOBJECTID as '业务对象', K1.FCAPTION as'类型',K2L.FNAME AS '权限项' from T_META_CONSOLEDETAIL A inner join T_META_CONSOLEDETAIL_L AL ON A.FDETAILFUNCID=AL.FDETAILFUNCID AND AL.FLOCALEID=2052 inner join t_meta_consolesubfunc B on a.FSUBFUNCID=b.FSUBFUNCID INNER JOIN T_META_CONSOLESUBFUNC_L BL ON B.FSUBFUNCID=BL.FSUBFUNCID AND BL.FLOCALEID=2052 inner join T_META_SUBSYSTEM C on C.FID=B.FSUBSYSTEMID INNER JOIN T_META_SUBSYSTEM_L CL on cl.FID=c.FID and cl.FLOCALEID=2052 inner join T_META_TOPCLASS D on D.FTOPCLASSID=C.FTOPCLASSID inner join T_META_TOPCLASS_L DL ON DL.FTOPCLASSID=D.FTOPCLASSID AND DL.FLOCALEID=2052 inner join (select t3.FCAPTION,t2.FVALUE FROM T_META_FORMENUM_L t1 inner join T_META_FORMENUMITEM t2 on t1.FNAME='发布类型' and t2.FID=t1.FID inner join T_META_FORMENUMITEM_L t3 ON t3.FENUMID=t2.FENUMID) K1 ON K1.FVALUE=A.FTYPE inner join T_SEC_PERMISSIONITEM K2 ON K2.FITEMID=A.FPERMISSIONITEMID INNER JOIN T_SEC_PERMISSIONITEM_L K2L ON K2.FITEMID=K2L.FITEMID AND K2L.FLOCALEID=2052 where DL.FNAME='供应链' and CL.FNAME='销售管理' order by d.FSEQ,c.FSEQ,b.FSEQ,a.FSEQ
推荐阅读