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

ALTER PROCEDURE dbo.CM_BRANCH_Ins

@p_FATHER_ID	varchar(15)  = NULL,

@p_IS_POTENTIAL varchar(1)  = NULL,

@p_BRANCH_CODE	varchar(10)  = NULL,

@p_BRANCH_NAME	nvarchar(200)  = NULL,

@p_REGION_ID	varchar(15)  = NULL,

@p_BRANCH_TYPE	varchar(5)  = NULL,

@p_ADDR	nvarchar(200)  = NULL,

@p_TEL	varchar(20)  = NULL,

@p_NOTES	nvarchar(1000)  = NULL,

@p_RECORD_STATUS	varchar(1)  = NULL,

@p_MAKER_ID	varchar(15)  = NULL,

@p_CREATE_DT	VARCHAR(20) = NULL,

@p_AUTH_STATUS	varchar(50)  = NULL,

@p_CHECKER_ID	varchar(15)  = NULL,

@p_TAX_NO	varchar(50)  = NULL,

@p_APPROVE_DT	VARCHAR(20) = NULL

AS

--Validation is here

DECLARE @ERRORSYS NVARCHAR(15) = '' 

  IF ( EXISTS ( SELECT * FROM CM_BRANCH WHERE BRANCH_CODE = @p_BRANCH_CODE))

	SET @ERRORSYS = 'CMCD-00001'

  ELSE IF( EXISTS (SELECT * FROM CM_BRANCH WHERE @p_TAX_NO IS NOT NULL AND @p_TAX_NO != '' AND  TAX_NO = @p_TAX_NO))

	SET @ERRORSYS = 'BRN-001'

IF @ERRORSYS <> '' 

BEGIN

	SELECT ErrorCode Result, ErrorDesc ErrorDesc FROM SYS_ERROR WHERE ErrorCode = @ERRORSYS

	RETURN '0'

END 

BEGIN TRANSACTION

DECLARE @l_BRANCH_ID VARCHAR(15)

		EXEC SYS_CodeMasters_Gen 'CM_BRANCH', @l_BRANCH_ID out

		IF @l_BRANCH_ID='' OR @l_BRANCH_ID IS NULL GOTO ABORT

		INSERT INTO CM_BRANCH([BRANCH_ID],[FATHER_ID],[IS_POTENTIAL],[BRANCH_CODE],[TAX_NO],[BRANCH_NAME],[REGION_ID],[BRANCH_TYPE],[ADDR],[TEL],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT])

		VALUES(@l_BRANCH_ID ,@p_FATHER_ID, @p_IS_POTENTIAL ,@p_BRANCH_CODE, @p_TAX_NO ,@p_BRANCH_NAME ,@p_REGION_ID ,@p_BRANCH_TYPE ,@p_ADDR ,@p_TEL ,@p_NOTES ,@p_RECORD_STATUS ,@p_MAKER_ID ,CONVERT(DATETIME, @p_CREATE_DT, 103) ,@p_AUTH_STATUS ,@p_CHECKER_ID ,CONVERT(DATETIME, @p_APPROVE_DT, 103) )

		IF @@Error <> 0 GOTO ABORT

        DECLARE @DMMS_ID VARCHAR(20)

        -- KIỂM  TRA XEM ĐÃ KHAI BÁO ĐƠN VỊ / CHI NHÁNH NÀY TRONG CM_DMMS HAY CHƯA

		IF(NOT EXISTS (SELECT * FROM CM_DMMS WHERE BRANCH_ID =@l_BRANCH_ID))

		BEGIN

			 EXEC SYS_CodeMasters_Gen 'CM_DMMS', @DMMS_ID out

			 INSERT INTO CM_DMMS (DMMS_ID,BRANCH_ID, DEP_ID,DVDM_ID) VALUES (@DMMS_ID,@l_BRANCH_ID,(SELECT TOP 1 DEP_ID FROM CM_DEPARTMENT WHERE BRANCH_ID =@l_BRANCH_ID),'')

		END

COMMIT TRANSACTION

SELECT '0' as Result, @l_BRANCH_ID  Id, '' ErrorDesc

RETURN '0'

ABORT:

BEGIN

		ROLLBACK TRANSACTION

		SELECT '-1' as Result, '' Id, '' ErrorDesc

		RETURN '-1'

End