CREATE trigger [dbo].[trg_用户管理设置新增] on [dbo].[SYS_Users] for insert,delete
as
--新增用户数据 触发器执行新增角色管理表和表权限设置表
--select top 1 * into #inserted fr om SYS_Users
--select * fr om SYS_RolePower
--select * fr om SYS_TablePower
--select * fr om SYS_Ribbon
--将新增的用户信息新增至角色管理中
--用户信息表的角色字段保存的是用户ID，用户ID是唯一值
delete fr om SYS_RolePower where UserRole in (select UserRole fr om deleted)
insert into SYS_RolePower(Unit,UserRole,[Group],_Locked,UserType,NavBar)
select Unit,UserRole,[Group],0,UserType,''
fr om inserted where UserRole not in (select UserRole fr om SYS_RolePower)
delete fr om SYS_TablePower where UserRole in (select UserRole fr om deleted)
insert into SYS_TablePower(UserRole,ViewName,Visible,Edit,Options,AddRow,DelRow,LockRow,UnLockRow,Perform,_Locked,Copy,Import,Export,查询)
select a.UserRole,b.ItemName,0,0,'',0,0,0,0,'',0,0,0,0,0 fr om inserted a,SYS_Ribbon b
where b.[Enable] = 1 and b.Parent <> 'NavBar' and b.[Type] = 'MenuItem' and a.UserRole not in (select distinct UserRole fr om SYS_TablePower where UserRole is not null)
order by b._SortKey asc
--新添加代码
se lect SCOPE_IDENTITY() as ID fr om inserted
GO
加好友 
发短信
Post By：2018/3/22 11:38:00 [只看该作者]
