USE [testforuser]
GO
/****** 对象: StoredProcedure [dbo].[p_prj_upgrade] 脚本日期: 10/21/2010 09:24:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: yuweibang
-- Create date: 2010-7-17
-- Description: --upgrade the project
-- =============================================
ALTER PROCEDURE [dbo].[p_prj_upgrade]
(
@targetprojectid uniqueidentifier,
@sourceprojectid uniqueidentifier
)
AS
declare @r_toctree cursor --toctree cursor
BEGIN
set xact_abort on
set implicit_transactions off
set nocount on
set transaction isolation level read uncommitted
set @status_delete = 'd'
set @cons_readfeature= 'rf'
set @cons_metadatastruct= 'ms'
set @cons_metadatavalue= 'mv'
set @cons_toc= 'toc'
set @cons_toctree='toctree'
set @cons_topic='topic'
set @cons_topicref='topicref'
set @cons_component='component'
set @cons_componentnode='cmpnode'
set @cons_outline = 'outline'
set @cons_outlinenode = 'outnode'
--clear table tbl_temp_idlink
delete from tbl_temp_idlink;
--copy tbl_prj_reader
insert into tbl_temp_idlink
select id,newid(),@cons_readfeature
from [tbl_prj_reader]
where [projectid] = @sourceprojectid
INSERT INTO [dbo].[tbl_prj_reader]
([id]
,[projectid]
,[meaningfulid]
,[name]
,[job]
,[type]
,[experience]
,[remark])
select (select [newid] from tbl_temp_idlink where id = a.id)
,@targetprojectid
,[meaningfulid]
,[name]
,[job]
,[type]
,[experience]
,[remark]
from [tbl_prj_reader] a where [projectid] = @sourceprojectid;
--copy tbl_prj_feature
insert into tbl_temp_idlink
select id,newid(),@cons_readfeature
from [tbl_prj_feature]
where [projectid] = @sourceprojectid
INSERT INTO [dbo].[tbl_prj_feature]
([id]
,[projectid]
,[meaningfulid]
,[name]
,[owner]
,[type]
,[subtype]
,[remark])
select (select [newid] from tbl_temp_idlink where id = a.id)
,@targetprojectid
,[meaningfulid]
,[name]
,[owner]
,[type]
,[subtype]
,[remark]
from [tbl_prj_feature] a where [projectid] = @sourceprojectid
--copy tbl_prj_metatypestructon
insert into tbl_temp_idlink
select id,newid(),@cons_metadatastruct
from [tbl_prj_metatypestructon]
where [projectid] = @sourceprojectid