AMS - VB

ALTER PROCEDURE dbo.MW_CANCEL_OUT_Del

@p_CANCEL_OUT_ID	varchar(15) = NULL

AS

	DECLARE @ERRORSYS NVARCHAR(15) = '', @AUTH_STATUS VARCHAR(1);

	IF ( NOT EXISTS ( SELECT * FROM MW_CANCEL_OUT cr WHERE cr.CANCEL_OUT_ID = @p_CANCEL_OUT_ID))

		SET @ERRORSYS = ''

	IF( EXISTS (SELECT * FROM MW_CANCEL_OUT cd WHERE cd.RECORD_STATUS <> '1' AND cd.AUTH_STATUS = 'A' AND cd.CANCEL_OUT_ID = @p_CANCEL_OUT_ID))

		SET @ERRORSYS = '241'

  SET @AUTH_STATUS = (SELECT mco.AUTH_STATUS FROM MW_CANCEL_OUT mco WHERE mco.CANCEL_OUT_ID = @p_CANCEL_OUT_ID)

  IF(@AUTH_STATUS <> 'E' AND @AUTH_STATUS <> 'R')

  BEGIN

    SELECT '-1' as Result, N'Phiếu ' + @p_CANCEL_OUT_ID + N' Không được phép xóa' ErrorDesc

		RETURN '-1'

  END

	IF @ERRORSYS <> ''

	BEGIN

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

		RETURN '0'

	END

BEGIN TRANSACTION

	IF((SELECT cd.CHECKER_ID FROM MW_CANCEL_OUT cd WHERE  cd.CANCEL_OUT_ID = @p_CANCEL_OUT_ID) IS NOT NULL )

	BEGIN

		UPDATE MW_CANCEL_OUT 

    SET RECORD_STATUS = '0' 

		WHERE MW_CANCEL_OUT.CANCEL_OUT_ID = @p_CANCEL_OUT_ID

		IF @@Error <> 0 GOTO ABORT

	END

	ELSE

	BEGIN

		DELETE 

    FROM MW_CANCEL_OUT 

    WHERE MW_CANCEL_OUT.CANCEL_OUT_ID = @p_CANCEL_OUT_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