pro_manager_permit.sql

一套宾馆管理系统

CREATE   PROCEDURE  ManagerPermit
@mode int ,
@permitid int,
@roleid  int
as
if @mode=1 --add
   begin 
    if not exists(select * from rolePermit   where roleid=@roleid and permitid=@permitid )
    insert into RolePermit(roleid,Permitid) values(@roleid,@permitid)
   end 
if @mode=2 --remove 
   begin
    if  exists(select * from rolePermit   where roleid=@roleid and permitid=@permitid )
    delete from RolePermit where roleid=@roleid and permitid=@permitid
   end