DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

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