21 lines
795 B
Transact-SQL
21 lines
795 B
Transact-SQL
-- Hareket satırı kaydı sonrası: satırın araç çubuğu işlemi (GenerateLots = Lot/Seri Oluştur, AssignLots = Otomatik Ata) ve belge özeti.
|
||
CREATE OR ALTER PROCEDURE [dbo].[Stk_P_TransferLineAfterSave]
|
||
@Id uniqueidentifier,
|
||
@UserId uniqueidentifier = NULL
|
||
AS
|
||
BEGIN
|
||
SET NOCOUNT ON;
|
||
DECLARE @Act nvarchar(16), @Doc uniqueidentifier;
|
||
SELECT @Act = PendingAction, @Doc = TransferId FROM Stk_T_TransferLine WHERE Id = @Id;
|
||
|
||
IF @Act IS NOT NULL
|
||
BEGIN
|
||
UPDATE Stk_T_TransferLine SET PendingAction = NULL WHERE Id = @Id;
|
||
IF @Act = 'GenerateLots'
|
||
EXEC Stk_P_TransferLineLotGenerate @Id, @UserId;
|
||
ELSE IF @Act = 'AssignLots'
|
||
EXEC Stk_P_TransferLineLotAssign @Id, @UserId;
|
||
END
|
||
|
||
EXEC Stk_P_TransferRecalc @Doc;
|
||
END
|