Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE [dbo].[fm_newHuman_saveItem]
- @username nvarchar(256),
- @itemID int,
- @parameters ExtendedDictionaryParameter readonly
- AS
- BEGIN
- declare @pfio nvarchar(max)
- select @pfio = Value2 from @parameters where [key]='fio'
- declare @pdepID nvarchar(max)
- select @pdepID = Value2 from @parameters where [key]='depID'
- insert into hr_humans (fio, depID)
- values (@pfio, try_cast(@pdepID as int))
- -- 1 SELECT (Result, Msg)
- select 1 Result, 'Создан' Msg, '' SuccessUrl, 1 HideFormAfterSubmit, '' RefreshContainer
- -- SELECT 2 Вызов внешнего действия
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement