TR_CHECK_DEP.txt
| 1 |
CREATE PROCEDURE [dbo].[TR_CHECK_DEP] |
|---|---|
| 2 |
@p_BRANCH_ID VARCHAR(20) = NULL, |
| 3 |
@p_BRANCH_CODE VARCHAR(20) = NULL, |
| 4 |
@p_DEP_ID VARCHAR(20) = NULL, |
| 5 |
@p_DEP_CODE VARCHAR(20) = NULL, |
| 6 |
@p_TYPE nvarchar(200) = NULL |
| 7 |
AS |
| 8 |
DECLARE @l_DEP_ID VARCHAR(20) = NULL; |
| 9 |
|
| 10 |
IF(@p_TYPE = 'TR_PAYMENT_KT') |
| 11 |
BEGIN |
| 12 |
IF(@p_BRANCH_CODE = '699' OR @p_BRANCH_CODE = '799' OR @p_BRANCH_CODE = '899') |
| 13 |
BEGIN |
| 14 |
SELECT '0' AS Result, '' ErrorDesc |
| 15 |
RETURN '0' |
| 16 |
END |
| 17 |
ELSE |
| 18 |
BEGIN |
| 19 |
SET @l_DEP_ID = ( SELECT TOP 1 D.DEP_ID |
| 20 |
FROM CM_DEPARTMENT D |
| 21 |
WHERE D.DEP_CODE= @P_DEP_CODE AND D.BRANCH_ID = @p_BRANCH_ID |
| 22 |
) |
| 23 |
--print @l_DEP_ID; |
| 24 |
IF(ISNULL(@l_DEP_ID, '') <> '') |
| 25 |
BEGIN |
| 26 |
SELECT '0' AS Result, '' ErrorDesc |
| 27 |
RETURN '0' |
| 28 |
END |
| 29 |
ELSE |
| 30 |
BEGIN |
| 31 |
SELECT '-1' AS Result, N'Mã phòng ban không hợp lệ' ErrorDesc |
| 32 |
RETURN '-1' |
| 33 |
END |
| 34 |
END |
| 35 |
END |
| 36 |
ELSE |
| 37 |
BEGIN |
| 38 |
SELECT '-1' AS Result, N'Lỗi không xác định' ErrorDesc |
| 39 |
RETURN '-1' |
| 40 |
END |
| 41 |
|
| 42 |
--exec TR_CHECK_DEP @p_BRANCH_ID = 'DV0001', @p_BRANCH_CODE = '', @p_DEP_ID = '', @p_DEP_CODE = '7990000', @p_TYPE = 'TR_PAYMENT_KT' |
| 43 |
|