蜜桃av色欲a片精品一区,麻豆aⅴ精品无码一区二区,亚洲人成网站在线播放影院在线,亚洲 素人 字幕 在线 最新

  工廠系統(tǒng)員工權(quán)限查看語(yǔ)句

發(fā)布日期：2023/3/25 7:42:21      瀏覽量：

select bu.Code as [工號(hào)],bu.Title as [姓名],bp.Memo as [權(quán)限名稱],bp.ItemName as [權(quán)限組],’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