291 lines
14 KiB
Plaintext
291 lines
14 KiB
Plaintext
--管道分部分项
|
||
insert into dbo.Wbs_UnitProjectInit(UnitProjectCode,UnitProjectName,SuperUnitProject,CnProfessionId,IsIn,SortIndex)
|
||
values('PP','工艺管道',null,13,1,1)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PF01','管道现场制作',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PF0101','焊接（DIN）；',13,'PF01','PP',1,70)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PF0102','检验',13,'PF01','PP',1,30)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PF02','管件现场制作',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PF0201','焊接（DIN）；',13,'PF02','PP',1,70)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PF0202','检验',13,'PF02','PP',1,30)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP01','土（石）方',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0101','土石方开挖（m³）',13,'PP01','PP',1,40)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0102','管道基础施工',13,'PP01','PP',1,20)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0103','土方回填',13,'PP01','PP',1,40)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP02','碳钢管道壁厚≤10mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0201','预制和安装（DN）',13,'PP02','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0202','试压',13,'PP02','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP03','碳钢管道10mm<壁厚≤20mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0301','预制和安装（DN）',13,'PP03','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0302','试压',13,'PP03','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP04','碳钢管道20mm<壁厚≤34mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0401','预制和安装（DN）',13,'PP04','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0402','试压',13,'PP04','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP05','碳钢管道34mm<壁厚≤51mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0501','预制和安装（DN）',13,'PP05','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0502','试压',13,'PP05','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP06','碳钢管道壁厚>51mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0601','预制和安装（DN）',13,'PP06','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0602','试压',13,'PP06','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP07','不锈钢管道壁厚≤10mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0701','预制和安装（DN）',13,'PP07','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0702','试压',13,'PP07','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP08','不锈钢管道10mm<壁厚≤20mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0801','预制和安装（DN）',13,'PP08','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0802','试压',13,'PP08','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP09','不锈钢管道20mm<壁厚≤34mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0901','预制和安装（DN）',13,'PP09','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP0902','试压',13,'PP09','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP10','不锈钢管道34mm<壁厚≤51mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1001','预制和安装（DN）',13,'PP10','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1002','试压',13,'PP10','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP11','不锈钢管道壁厚>51mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1101','预制和安装（DN）',13,'PP11','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1102','试压',13,'PP11','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP12','低合金钢管道壁厚≤10mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1201','预制和安装（DN）',13,'PP12','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1202','试压',13,'PP12','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP13','低合金钢管道10mm<壁厚≤20mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1301','预制和安装（DN）',13,'PP13','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1302','试压',13,'PP13','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP14','低合金钢管道壁厚20mm<壁厚≤34mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1401','预制和安装（DN）',13,'PP14','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1402','试压',13,'PP14','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP15','低合金钢管道34mm<壁厚≤51mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1501','预制和安装（DN）',13,'PP15','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1502','试压',13,'PP15','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP16','低合金钢管道壁厚>51mm',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1601','预制和安装（DN）',13,'PP16','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1602','试压',13,'PP16','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP17','特种材料管道',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1701','预制和安装（DN）',13,'PP17','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1702','试压',13,'PP17','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP18','衬里管道',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1801','预制和预安装（米）',13,'PP18','PP',1,30)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1802','衬里',13,'PP18','PP',1,25)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1803','安装',13,'PP18','PP',1,25)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1804','试压',13,'PP18','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP19','有色金属(其他材质）管道',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1901','预制和安装（DN）',13,'PP19','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP1902','试压',13,'PP19','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP20','非金属管道',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP2001','预制和安装（米）',13,'PP20','PP',1,80)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP2002','试压',13,'PP20','PP',1,20)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP21','管道支架安装',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP2101','现场制作管架（t/个）',13,'PP21','PP',1,null)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP2102','成品管架（t/个）',13,'PP21','PP',1,null)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP2103','弹簧管架（t/个）',13,'PP21','PP',1,null)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP2104','保冷管托（t/个）',13,'PP21','PP',1,null)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP22','伴热',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP2201','伴热安装（米）',13,'PP22','PP',1,100)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP23','无损检测',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP2301','无损检测（DN）',13,'PP23','PP',1,100)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP24','热处理',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP2401','热处理（DN）',13,'PP24','PP',1,100)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP25','化学清洗',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP2501','按系统',13,'PP25','PP',1,100)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP26','脱脂',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP2601','按系统',13,'PP26','PP',1,100)
|
||
GO
|
||
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn)
|
||
values('PP27','吹洗',13,null,'PP',1)
|
||
GO
|
||
Insert into dbo.WBS_WbsSetInit(WbsSetCode,WbsSetName,CnProfessionId,SuperWbsSetCode,UnitProjectCode,IsIn,Weights)
|
||
values('PP2701','按系统',13,'PP27','PP',1,100)
|
||
GO |