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

ALTER PROCEDURE dbo.CM_GOODS_Ins

	@p_GD_CODE	varchar(150)  = NULL,

	@p_GD_NAME	nvarchar(200)  = NULL,

	@p_GD_TYPE_ID	varchar(15)  = NULL,

	@p_DESCRIPTION	nvarchar(2000)  = NULL,

	@p_SUP_ID	varchar(15)  = NULL,

	@p_PRICE	decimal(18)  = NULL,

	@p_UNIT_ID	varchar(15)  = NULL,

	@p_NOTES	nvarchar(1000)  = NULL,

	@p_RECORD_STATUS	varchar(1)  = NULL,

	@p_MAKER_ID	varchar(12)  = NULL,

	@p_CREATE_DT	VARCHAR(20) = NULL,

	@p_AUTH_STATUS	varchar(50)  = NULL,

	@p_CHECKER_ID	varchar(12)  = NULL,

	@p_APPROVE_DT	VARCHAR(20) = NULL,

	@p_MONTHLY_ALLOCATED VARCHAR(20) = NULL,

	@p_DVDM_ID VARCHAR(20) = NULL

AS

	DECLARE @l_GD_ID VARCHAR(15)

	DECLARE @ERRORSYS NVARCHAR(15) = '' 

	IF ( EXISTS ( SELECT * FROM CM_GOODS WHERE GD_CODE = @p_GD_CODE AND RECORD_STATUS = '1'))

		SET @ERRORSYS = 'CMCD-00001'	

	IF @ERRORSYS <> '' 

	BEGIN

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

		RETURN '0'

	END 

BEGIN TRANSACTION

		EXEC SYS_CodeMasters_Gen 'CM_GOODS', @l_GD_ID out

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

		INSERT INTO CM_GOODS([GD_ID],[GD_CODE],[GD_NAME],[GD_TYPE_ID],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[MONTHLY_ALLOCATED],[DVDM_ID])

		VALUES(@l_GD_ID ,@p_GD_CODE ,@p_GD_NAME ,@p_GD_TYPE_ID ,@p_DESCRIPTION ,@p_SUP_ID ,@p_PRICE ,@p_UNIT_ID ,@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),@p_MONTHLY_ALLOCATED,@p_DVDM_ID)

    INSERT INTO CM_GOOD_DVDM (GD_ID, DVDM_ID)

    VALUES(@l_GD_ID,@p_DVDM_ID)

		IF @@Error <> 0 GOTO ABORT

COMMIT TRANSACTION

SELECT 0 as Result, @l_GD_ID  ID, '' ErrorDesc

RETURN 0

ABORT:

BEGIN

		ROLLBACK TRANSACTION

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

		RETURN -1

End