工厂系统员工权限查看语句

发布日期：2023/3/25 7:42:21      浏览量：

select bu.Code as [工号],bu.Title as [姓名],bp.Memo as [权限名称],bp.ItemName as [权限组],’Y’ as [查看],(CASE WHEN up.Power2=1 THEN ’Y’ ELSE ’N’ END) as [新建]
,(CASE WHEN up.Power3=1 THEN ’Y’ ELSE ’N’ END) as [编辑],(CASE WHEN up.Power4=1 THEN ’Y’ ELSE ’N’ END) as [删除]
,(CASE WHEN up.Power5=1 THEN ’Y’ ELSE ’N’ END) as [审核]  from [bdUserPower] up left join [biUser] bu on bu.ID=UserID left join [biSystemPower] bp on bp.ID=up.PowerID order by UserID
go