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

DECLARE @N_PLATE VARCHAR(50),@FUEL decimal(18,2),@INDEX_NUMBER decimal(18,2),@l_CAR_DR_ID VARCHAR(15)

DELETE  FROM CAR_DRIVE WHERE CAR_DR_ID ='CARD00000251700'

SET @N_PLATE ='62A15274'-- Biển số xe

SET @FUEL =4 --NHIEN LIEU TON DAU

SET @INDEX_NUMBER = 68400 --CHI SO KM DAU

IF(NOT EXISTS(SELECT * FROM CAR_DRIVE WHERE CAR_ID =(SELECT cm.CAR_ID FROM CAR_MASTER cm WHERE cm.N_PLATE=@N_PLATE) AND ISLEAF ='Y'))

BEGIN

	INSERT CAR_DRIVE(CAR_DR_ID, CAR_ID, ASSET_ID, ASSET_NAME, OLD_INDEX_NUMBER, NEW_INDEX_NUMBER, INDEX_NUMBER, POWER_RATE, POWER_RATE_INDEX, CURR_POWER_RATE, INPUT_DT, ISLEAF, PARENT_ID, NOTES, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, CAR_AMT, INVOICE_NO, DR_ROUTE, REQ_PAY_ID, DIFF_FUEL_CONSUM, REQ_CAR_ID, OLD_FUEL_NUMBER, NEW_FUEL_NUMBER) VALUES

	(@l_CAR_DR_ID, (SELECT cm.CAR_ID FROM CAR_MASTER cm WHERE cm.N_PLATE=@N_PLATE), NULL, NULL, @INDEX_NUMBER, @INDEX_NUMBER, @INDEX_NUMBER, NULL, NULL, 0.00, GETDATE(), 'Y', NULL, NULL, '1', 'admin', GETDATE(), 'A', NULL, NULL, NULL, NULL, N'Import data', NULL, NULL, '', 0.00, @FUEL)

END

ELSE

BEGIN

	PRINT N'ĐÃ TỒN TẠI'

END ----21062023_SECCRETKEY