DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

ALTER PROCEDURE [dbo].[RET_MASTER_Del]

@RET_ID	varchar(15)

AS

	DECLARE @ERRORSYS NVARCHAR(15) = '' 

	IF ( NOT EXISTS ( SELECT * FROM RET_MASTER WHERE  RET_ID= @RET_ID))

		SET @ERRORSYS = 'RETM-00001'

	IF @ERRORSYS <> ''

	BEGIN

		SELECT ErrorCode Result, ErrorDesc ErrorDesc FROM SYS_ERROR WHERE ErrorCode = @ERRORSYS 

		RETURN '0'

	END

BEGIN TRANSACTION

	IF( (SELECT AUTH_STATUS FROM RET_MASTER WHERE  RET_ID= @RET_ID) = 'A')

	BEGIN

		UPDATE RET_MASTER SET RECORD_STATUS = '0' 

		WHERE RET_ID = @RET_ID -- 23/10 thieu where nen khi xoa bi xoa het

		IF @@Error <> 0 GOTO ABORT

	END

	------------BAODNQ 10/3/2022 : KO CHO XÓA BDS KHI ĐÃ GỬI YC PHÊ DUYỆT------

	IF(EXISTS(SELECT * FROM RET_MASTER WHERE RET_ID = @RET_ID AND IS_SEND_APPR = 'Y'))

	BEGIN

		ROLLBACK TRANSACTION

		SELECT '-1' as Result, N'Không thể xóa BDS đã được gửi yêu cầu phê duyệt' ErrorDesc

		RETURN '-1'

	END

	ELSE

	BEGIN

		Delete FROM RET_MASTER WHERE  RET_ID= @RET_ID

		IF @@Error <> 0 GOTO ABORT

	END

COMMIT TRANSACTION

SELECT '0' as Result, '' ErrorDesc

RETURN '0'

ABORT:

BEGIN

		ROLLBACK TRANSACTION

		SELECT '-1' as Result, '' ErrorDesc

		RETURN '-1'

End