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

ALTER PROCEDURE [dbo].[LS_CUSTOMER_App]

@p_CUSTOMER_ID varchar(15),

@P_AUTH_STATUS VARCHAR(1),

@P_CHECKER_ID VARCHAR(12),

@P_APPROVE_DT VARCHAR(20)

AS

/*

DECLARE	@aStatus VARCHAR(1)

DECLARE @sErrorCode VARCHAR(20)

SET @sErrorCode = ''

	SELECT @aStatus = [AUTH_STATUS] FROM LS_CUSTOMER WHERE CUSTOMER_ID=@p_CUSTOMER_ID

	IF @aStatus = 'A'

		SET @sErrorCode = ''

	IF @ERRORSYS <> ''

	BEGIN

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

		RETURN '0'

	END*/

BEGIN TRANSACTION

		UPDATE LS_CUSTOMER SET AUTH_STATUS = 'A', CHECKER_ID = @P_CHECKER_ID, APPROVE_DT = CONVERT(DATETIME,@P_APPROVE_DT,103)

WHERE CUSTOMER_ID=@p_CUSTOMER_ID

		IF @@Error <> 0 GOTO ABORT

COMMIT TRANSACTION

SELECT '0' as Result, @p_CUSTOMER_ID  CUSTOMER_ID, '' ErrorDesc

RETURN '0'

ABORT:

BEGIN

		ROLLBACK TRANSACTION

		SELECT '-1' as Result, '' CUSTOMER_ID, '' ErrorDesc

		RETURN '-1'

End