USP_DATAFORMTEMPLATE_EDIT_SYSTEMROLEQUERYVIEWPERM

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@QUERYVIEWLIST	xml	IN

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SYSTEMROLEQUERYVIEWPERM (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier =null,
    @QUERYVIEWLIST xml

) AS

set nocount on;

if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

declare @CURRENTDATE datetime;
set @CURRENTDATE=getdate();

BEGIN TRY


    update dbo.SYSTEMROLE set
        CHANGEDBYID = @CHANGEAGENTID  ,DATECHANGED=@CURRENTDATE
    where ID = @ID;


    if @QUERYVIEWLIST is not null
        exec dbo.USP_SYSTEMROLE_GETQUERYVIEWLIST_UPDATEFROMXML @id, @QUERYVIEWLIST, @CHANGEAGENTID

    return 0;

END TRY
BEGIN CATCH
    exec dbo.USP_RAISE_ERROR;
    return 1;
END CATCH