[ASS_INVENTORY_UNSTOCKED_Del].txt
| 1 |
CREATE PROCEDURE [dbo].[ASS_INVENTORY_UNSTOCKED_Del] |
|---|---|
| 2 |
@p_UNSTOCKED_ID varchar(15) |
| 3 |
|
| 4 |
AS |
| 5 |
BEGIN |
| 6 |
BEGIN TRANSACTION |
| 7 |
DECLARE @Error NVARCHAR(MAX) = '' |
| 8 |
|
| 9 |
IF EXISTS (SELECT * FROM ASS_INVENTORY_UNSTOCKED WHERE UNSTOCKED_ID = @p_UNSTOCKED_ID) |
| 10 |
BEGIN |
| 11 |
DELETE ASS_INVENTORY_UNSTOCKED WHERE UNSTOCKED_ID = @p_UNSTOCKED_ID |
| 12 |
END |
| 13 |
ELSE |
| 14 |
BEGIN |
| 15 |
SET @Error = N'Không tìm thấy mã' |
| 16 |
GOTO ABORT |
| 17 |
END |
| 18 |
|
| 19 |
IF @@Error <> 0 GOTO ABORT |
| 20 |
COMMIT TRANSACTION |
| 21 |
SELECT '0' as Result, @p_UNSTOCKED_ID id, '' ErrorDesc |
| 22 |
RETURN '0' |
| 23 |
ABORT: |
| 24 |
BEGIN |
| 25 |
ROLLBACK TRANSACTION |
| 26 |
SELECT '-1' as Result, '' id, @Error ErrorDesc |
| 27 |
RETURN '-1' |
| 28 |
End |
| 29 |
|
| 30 |
END |