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

-----------UPDATE TR_REQUEST_DOC-----------------

UPDATE TR_REQUEST_DOC SET DMMS_ID = (SELECT TOP 1 DMMS_ID FROM CM_DMMS WHERE BRANCH_ID = 'BRN000000000833') 

WHERE REQ_ID = 'TRRD00000257401'

-----------UPDATE PL_REQUEST_PROCESS-------------

UPDATE PL_REQUEST_PROCESS SET DVDM_ID = (SELECT TOP 1 DMMS_ID FROM CM_DMMS WHERE BRANCH_ID = 'BRN000000000833')

WHERE REQ_ID = 'TRRD00000257401' AND PROCESS_ID = 'DMMS'

----------XÓA PL_REQUEST_PROCESS_CHILD-----------

DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = 'TRRD00000257401' AND PROCESS_ID = (SELECT TOP 1 ID FROM PL_REQUEST_PROCESS WHERE REQ_ID = 'TRRD00000257401' AND PROCESS_ID = 'DMMS')

--------------INSERT XỬ LÝ-------------------------

INSERT INTO dbo.PL_PROCESS

		(

			REQ_ID,

			PROCESS_ID,

			CHECKER_ID,

			APPROVE_DT,

			PROCESS_DESC,NOTES

		)

		VALUES

		(   'TRRD00000257401',        -- REQ_ID - varchar(15)

			'IT',        -- PROCESS_ID - varchar(10)

			'',        -- CHECKER_ID - varchar(15)

			GETDATE() , -- APPROVE_DT - datetime

			--@p_PROCESS_DES,

			N'Phòng Hành Chính chuyển phiếu về DVKD tự mua',

			 N'Phòng Hành Chính chuyển phiếu về DVKD tự mua'        -- PROCESS_DESC - nvarchar(1000)

		)