cm_account_pay_byid.txt

Luc Tran Van, 03/30/2022 04:27 PM

       ALTER PROC [dbo].[CM_ACCOUNT_PAY_BYID]
       @p_REF_ID VARCHAR(15) = NULL,
       @p_ACC_TYPE VARCHAR(50) = NULL
       AS
       BEGIN
       IF(@p_ACC_TYPE <> 'ET')
       	BEGIN
       		SELECT TOP 1 A.*,'' AS REF_CODE, '' AS REF_NAME, 'ADV_PAY' AS ACC_TYPE
       		FROM CM_ACCOUNT_PAY A
       		WHERE A.REF_ID = @p_REF_ID
       	END
       ELSE
       	BEGIN
       		SELECT TOP 1 A.*,'' AS REF_CODE, '' AS REF_NAME, 'ET' AS ACC_TYPE
       		FROM CM_ACCOUNT A
       		WHERE A.ACC_NO = @p_REF_ID
       	END
       END

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