Project

General

Profile

Download (1.52 KB)

BV_PAY_ENTRIES_UPREF_LIVE_150321.txt

Luc Tran Van, 03/15/2021 04:34 PM

 
1 
??
2 
ALTER PROCEDURE [dbo].[PAY_ENTRIES_POST_UpdRef]
3 
@p_ET_ID varchar(50) = NULL,
4 
@p_PAIR_ID varchar(50) = NULL,
5 
@p_REF_NO VARCHAR(100) = ''---SO REF NO CUA CORE TRA VE
6 
AS
7 
BEGIN TRY
8 
--DECLARE @REQ_ID VARCHAR(15)
9 
--SET @REQ_ID =(SELECT TOP 1 TRN_ID FROM PAY_ENTRIES_POST WHERE ET_ID =@p_ET_ID)
10
11 
UPDATE PAY_ENTRIES_POST
12 
SET REF_NO = @p_REF_NO
13 
--WHERE ET_ID = @p_ET_ID AND ENTRY_PAIR = @p_PAIR_ID
14 
--WHERE ENTRY_PAIR = @p_PAIR_ID AND TRN_ID =@REQ_ID
15 
WHERE ET_ID IN (SELECT * FROM wsiSplit(@p_ET_ID,','))
16
17 
--SELECT * FROM wsiSplit('PET000000000016,PET000000000017,PET000000000018,PET000000000019',',')
18
19 
SELECT '0' RESULT, '' ERROR
20 
RETURN 0
21 
END TRY
22 
BEGIN CATCH
23 
SELECT '-1' RESULT, ERROR_MESSAGE() ERROR
24 
RETURN -1
25 
END CATCH
26