ALTER PROCEDURE [dbo].[MW_LIQ_MASTER_Del]
@p_LIQ_ID	varchar(15)
AS

	DECLARE @sErrorCode VARCHAR(20) = ''
	DECLARE @l_AUTH_STATUS VARCHAR(1)
	--KIEM TRA TRANG THAI AUTH_STATUS
	IF( (SELECT KT_CHECKER_ID FROM MW_LIQ_MASTER WHERE LIQ_ID = @p_LIQ_ID) IS NOT NULL AND  (SELECT KT_CHECKER_ID FROM MW_LIQ_MASTER WHERE LIQ_ID = @p_LIQ_ID) <>'' )
	BEGIN
		SELECT '-1' as Result, N'Thông tin thanh lý vật liệu đã được kế toán duyệt' ErrorDesc
		RETURN '-1'
	END		
BEGIN TRANSACTION
	IF((SELECT CHECKER_ID FROM MW_LIQ_MASTER WHERE LIQ_ID = @p_LIQ_ID) IS NOT NULL AND  (SELECT CHECKER_ID FROM MW_LIQ_MASTER WHERE LIQ_ID = @p_LIQ_ID) <>'')
	BEGIN
		   UPDATE MW_LIQ_MASTER SET RECORD_STATUS = '0' 
		   WHERE LIQ_ID = @p_LIQ_ID
		 IF @@Error <> 0 GOTO ABORT
	END
	ELSE
	BEGIN
	DELETE FROM MW_LIQ_MASTER WHERE LIQ_ID = @p_LIQ_ID
	DELETE FROM MW_LIQ_MASTER WHERE LIQ_ID= @p_LIQ_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