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

ALTER PROCEDURE dbo.TR_REQUEST_CAR_Ins

@p_REQ_CODE varchar(150) = NULL,

@p_REQ_DT varchar(150) = NULL,

@p_EMP_ID varchar(15) = NULL,

@p_EMP_PHONE varchar(15) = NULL,

@p_BRANCH_ID varchar(15) = NULL,

@p_BRANCH_CREATE varchar(15) = NULL,

@p_DEP_ID varchar(15) = NULL,

@p_DEP_CREATE varchar(15) = NULL,

@p_ORIGN nvarchar(100) = NULL,

@p_DESTINATION nvarchar(100) = NULL,

@p_IS_SEND_APPR varchar(15) = NULL,

@p_SEND_APPR_DT varchar(20) = NULL,

@p_SIGN_USER varchar(15) = NULL,

@p_SIGN_DT varchar(20) = NULL,

@p_FROM_DATE VARCHAR(20) = NULL,

@p_TO_DATE VARCHAR(20) = NULL,

@p_NOTES nvarchar(MAX) = NULL,

@p_CAR_ID varchar(15) = NULL,

@p_DRIVER_ID varchar(15) = NULL,

@p_QUANTITY_TRIP int = NULL,

@p_NOTES_TRIP nvarchar(MAX) = NULL,

@p_UNIT_TRIP varchar(5) = NULL,

@p_TO_TRIP nvarchar(100) = NULL,

@p_FROM_TRIP nvarchar(100) = NULL,

@p_MILRAGE_TRIP int = NULL,

@p_START_TIME_TRIP VARCHAR(20) = NULL,

@p_QUANTITY_RETURN_TRIP int = NULL,

@p_NOTES_RETURN_TRIP nvarchar(MAX) = NULL,

@p_UNIT_RETURN_TRIP varchar(5) = NULL,

@p_TO_RETURN_TRIP nvarchar(MAX) = NULL,

@p_FROM_RETURN_TRIP nvarchar(MAX) = NULL,

@p_MILRAGE_RETURN_TRIP int = NULL,

@p_START_TIME_RETURN_TRIP VARCHAR(20) = NULL,

@p_AUTH_STATUS varchar(1) = NULL,

@p_APPROVE_DT varchar(20) = NULL,

@p_CREATE_DT varchar(20) = NULL,

@p_MAKER_ID varchar(20) = NULL,

@p_MAKER_PHONE varchar(20) = NULL,

@p_IS_CONFIRM_COST varchar(1) = NULL,

@p_IS_CONTRACT_CAR varchar(1) = NULL,

@p_ListCarDT xml

AS

 BEGIN TRANSACTION

	exec [TR_CODE_GenKey] 'TR_REQUEST_CAR', '','PYC-XE', @p_REQ_CODE OUT

	--IF EXISTS(SELECT * FROM TR_REQUEST_DOC WHERE [REQ_CODE] = @p_REQ_CODE)

	--BEGIN

	--	ROLLBACK TRANSACTION

	--	SELECT '-1' Result, '' REQ_ID, N'Số phiếu yêu cầu đã tồn tại' ErrorDesc

	--	RETURN '-1'

	--END

	--IF(@p_REQ_CODE IS NULL OR @p_REQ_CODE ='')

	--BEGIN

	--	ROLLBACK TRANSACTION

	--	SELECT '-1' Result, '' REQ_ID, N'Mã phiếu yêu cầu bắt buộc nhập' ErrorDesc 

	--	RETURN '-1'

	--END

		--insert master				

		DECLARE @l_REQ_ID VARCHAR(15)

		EXEC SYS_CodeMasters_Gen 'TR_REQUEST_CAR', @l_REQ_ID out

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

		INSERT INTO dbo.TR_REQUEST_CAR

		(

		    REQ_ID,REQ_CODE,CREATE_DT,MAKER_ID,EMP_ID,MAKER_PHONE,BRANCH_ID,BRANCH_CREATE,DEP_ID,DEP_CREATE,ORIGN,DESTINATION,REQ_DT,IS_SEND_APPR,FROM_DATE,TO_DATE,NOTES,IS_CONFIRM_COST,IS_CONTRACT_CAR,PROCESS_ID,UNIT_TRIP,TO_TRIP,FROM_TRIP,START_TIME_TRIP,NOTES_TRIP,QUANTITY_TRIP,UNIT_RETURN_TRIP,QUANTITY_RETURN_TRIP,START_TIME_RETURN_TRIP,FROM_RETURN_TRIP,TO_RETURN_TRIP,AUTH_STATUS

		)

		VALUES

		(   

			@l_REQ_ID,@p_REQ_CODE,CONVERT(DATETIME, @p_CREATE_DT, 103),@p_MAKER_ID,@p_MAKER_ID,@p_MAKER_PHONE,@p_BRANCH_ID,@p_BRANCH_CREATE,@p_DEP_ID,@p_DEP_CREATE,@p_ORIGN,@p_DESTINATION,CONVERT(DATETIME,@p_REQ_DT,103),@p_IS_SEND_APPR,CONVERT(DATETIME,@p_FROM_DATE,103),CONVERT(DATETIME,@p_TO_DATE,103),@p_NOTES,'N',@p_IS_CONTRACT_CAR,'INSERT',@p_UNIT_TRIP,@p_DESTINATION,@p_ORIGN,CONVERT(DATETIME,@p_FROM_DATE,103),@p_NOTES_TRIP,@p_QUANTITY_TRIP,@p_UNIT_RETURN_TRIP,@p_QUANTITY_TRIP,CONVERT(DATETIME,@p_TO_DATE,103),@p_DESTINATION,@p_ORIGN,'E'

		)

		IF @@Error <> 0 GOTO ABORT

		--INSERT INTO dbo.PL_PROCESS

		--			(

		--			    REQ_ID,

		--			    PROCESS_ID,

		--			    CHECKER_ID,

		--			    APPROVE_DT,

		--			    PROCESS_DESC,

		--			    NOTES

		--			)

		--			VALUES

		--			(   @l_REQ_ID,       

		--				'INSERT',

		--			    @p_MAKER_ID,        

		--			    GETDATE(), 

		--			    N'Thêm mới PYC xe thành công' ,      

		--			    N'Thêm mới PYC xe'       

		--			 )

COMMIT TRANSACTION

SELECT '0' as Result, @l_REQ_ID  REQ_ID,@p_REQ_CODE REQ_CODE, N'Thêm mới PYC xe thành công' ErrorDesc

RETURN '0'

ABORT:

BEGIN

		ROLLBACK TRANSACTION

		SELECT '-1' AS RESULT

		RETURN '-1'

End