Project

General

Profile

Download (473 Bytes)

VALIDATE TAM UNG THANH TOAN.txt

Luc Tran Van, 07/24/2020 03:36 PM

 
1 
IF(EXISTS(SELECT * FROM TR_REQ_ADVANCE_DT WHERE REF_ID =@REF_ID AND TYPE ='P' AND REF_ID IN (SELECT PO_ID FROM TR_PO_MASTER WHERE IS_CLOSED ='Y')))
2 
					BEGIN
3 
						ROLLBACK TRANSACTION
4 
						SELECT '-1' as Result, '' REQ_PAY_ID,''  AS REQ_PAY_CODE, N'Dòng '+ CONVERT(VARCHAR(5),@INDEX_PO)+ N': PO số '+
5 
						(SELECT PO_CODE FROM TR_PO_MASTER WHERE PO_ID = @REF_ID)+N' đã được thanh toán. Vui lòng hủy bản nháp!' ErrorDesc
6 
						RETURN '-1'
7 
					END