Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE [dbo].[falcon_dragDrop]
- @parameters ExtendedDictionaryParameter readonly,
- @username nvarchar(256)
- AS
- BEGIN
- DECLARE @elementItemID INT, @elementCode nvarchar(128), @containerItemID INT, @containerCode nvarchar(128)
- SELECT @elementItemID = try_cast(Value2 AS INT) FROM @parameters WHERE LOWER([KEY])='elementitemid'
- SELECT @elementCode= Value2 FROM @parameters WHERE LOWER([KEY])='elementcode'
- SELECT @containerItemID = try_cast(Value2 AS INT) FROM @parameters WHERE LOWER([KEY])='containeritemid'
- SELECT @containerCode = Value2 FROM @parameters WHERE LOWER([KEY])='containercode'
- DECLARE @actionType nvarchar(128) = CASE
- WHEN @elementCode= 'copyType' THEN 'copy'
- WHEN @elementCode= 'moveType' THEN 'move'
- WHEN @elementCode= 'deleteType' THEN 'delete'
- WHEN @elementCode= 'backType' THEN 'back'
- END
- EXEC as_print @str=@elementCode
- -- SELECT 1
- SELECT 1 RESULT, iif(@elementCode='moveAlert' , 'OK!', '') Msg, 'fa-cogs' icon, 'body' RefreshContainer, @actionType [action] -- move, back, delete, copy
- -- SELECT 2 Outer commands
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement