表单 申请权限 卡控

 

表单自定义Store Procedure

usp_FORMKIND(去点)_ApplyFormPermission

 

 

CREATE PROCEDURE [dbo].[usp_FORMKIND_ApplyFormPermission]@p_strEmpID  nvarchar(30),@p_strFormKind  nvarchar(30)AS BEGINSET NOCOUNT ON;IF NOT EXISTS(SELECT * FROM AM_EMPLOYEEWHERE EMP_ID=@p_strEmpIDAND EMP_ID IN(SELECT EMPLOYEEID FROM ***.dbo.PSNACCOUNT WHERE PERSONID IN(SELECT DISTINCT DIRECTOR FROM eHR_DB.dbo.ORGSTDSTRUCT WHERE DIRECTOR !='')))BEGINRETURN  1ENDELSEBEGINRETURN  0ENDEND