[SQL] syntaxhighlighter_viewsource syntaxhighlighter_copycode
BEGIN
DECLARE @tempid int,@tempEstId int;
SET @tempEstId=1;
insert INTO o_PreEstUser (Name,ProjectId,CreateTime,IsDelete,Type,XMMC,YDXZ,SSQY,JZMJ,RL,WXCD,HXNBJJE,
Memo_WXTJ,Memo_WXSB,Memo_WXCL,Memo_KBSSB,Memo_KBSCL,Memo_GYSB,Memo_GYCL,Memo_ZYSB,Memo_ZYCL,
Memo_ZTAZ,Memo_ZTTJSGF,Memo_ZTSYTSF,YZYQ_CF,Memo_YZYQCF,YZYQ_YHYB,Memo_YZYQYHYB,YZYQ_LLLJ,Memo_YZYQLLLJ,
YZYQ_CDZ,Memo_YZYQCDZ,DJHTJE,Memo_DJHTJE,SJF,Memo_SJF,JLF,Memo_JLF,DJGLF,Memo_DJGLF,SJ,Memo_SJ,ZJCB,Memo_ZJCB,
GSGLF,Memo_GSGLF,Memo_YWF,LRL,Memo_LRL)
SELECT '测试复制',ProjectId,CreateTime,IsDelete,Type,XMMC,YDXZ,SSQY,JZMJ,RL,WXCD,HXNBJJE,
Memo_WXTJ,Memo_WXSB,Memo_WXCL,Memo_KBSSB,Memo_KBSCL,Memo_GYSB,Memo_GYCL,Memo_ZYSB,Memo_ZYCL,
Memo_ZTAZ,Memo_ZTTJSGF,Memo_ZTSYTSF,YZYQ_CF,Memo_YZYQCF,YZYQ_YHYB,Memo_YZYQYHYB,YZYQ_LLLJ,Memo_YZYQLLLJ,
YZYQ_CDZ,Memo_YZYQCDZ,DJHTJE,Memo_DJHTJE,SJF,Memo_SJF,JLF,Memo_JLF,DJGLF,Memo_DJGLF,SJ,Memo_SJ,ZJCB,Memo_ZJCB,
GSGLF,Memo_GSGLF,Memo_YWF,LRL,Memo_LRL FROM o_PreEstUser where PreEstId=@tempEstId;
SET @tempid=(SELECT top 1 PreEstId from o_PreEstUser ORDER BY PreEstId DESC);
insert INTO o_PECoordFee (CooContent,CooDepart,money,Memo,IsDelete,PreEstId,PreEstType,Quantity,QuoteMoney)
SELECT CooContent,CooDepart,money,Memo,IsDelete,@tempid,PreEstType,Quantity,QuoteMoney
FROM o_PECoordFee where PreEstId=@tempEstId AND PreEstType='用户工程' and IsDelete<>1;
INSERT INTO o_PETestFee (TestName,money,IsDelete,Memo,PreEstId,Quantity,QuoteMoney,PreEstType)
SELECT TestName,money,IsDelete,Memo,@tempid,Quantity,QuoteMoney,PreEstType
FROM o_PETestFee where PreEstId=@tempEstId AND PreEstType='用户工程' and IsDelete<>1;
INSERT INTO o_PEMaterialFeeUser (EquipName,Specification,Unit,Type,LogTime,IsDelete,Price,Code,PreEstId,
EquipPriceId,TabType,PreEstType,Quantity,QuoteMoney,SumTax)
SELECT EquipName,Specification,Unit,Type,LogTime,IsDelete,Price,Code,@tempid,EquipPriceId,
TabType,PreEstType,Quantity,QuoteMoney,SumTax
FROM o_PEMaterialFeeUser where PreEstId=@tempEstId AND PreEstType='用户工程' and IsDelete<>1;
INSERT INTO o_PEInstallFee (Name,Specification,Content,Unit,Money,Memo,IsDelete,PreEstId,Quantity,QuoteMoney,PreEstType,TabType)
SELECT Name,Specification,Content,Unit,Money,Memo,IsDelete,@tempid,Quantity,QuoteMoney,PreEstType,TabType
FROM o_PEInstallFee where PreEstId=@tempEstId AND PreEstType='用户工程' and IsDelete<>1;
INSERT INTO o_PEEquipFee (EquipName,Specification,Unit,Type,LogTime,IsDelete,Price,Code,PreEstId,EquipPriceId,TabType,
PreEstType,Quantity,QuoteMoney,SumTax)
SELECT EquipName,Specification,Unit,Type,LogTime,IsDelete,Price,Code,@tempid,EquipPriceId,TabType,PreEstType,Quantity,
QuoteMoney,SumTax
FROM o_PEEquipFee where PreEstId=@tempEstId AND PreEstType='用户工程' and IsDelete<>1;
DECLARE @tempCivilId int,@tempCivilAddId int;
DECLARE mycursor CURSOR FOR SELECT PECivilPriceId FROM o_PECivilPrice WHERE PreEstId=@tempEstId AND PreEstType='用户工程' and IsDelete<>1;
OPEN mycursor
FETCH NEXT FROM mycursor INTO @tempCivilId
WHILE (@@fetch_status = 0)
BEGIN
INSERT INTO o_PECivilPrice (Name,TaxRate,Unit,UnitPrice,Memo,IsDelete,LogTime,PreEstId,PreEstType,TabType,OrgCivilPriceId,Quantity)
SELECT Name,TaxRate,Unit,UnitPrice,Memo,IsDelete,LogTime,@tempid,PreEstType,TabType,OrgCivilPriceId,Quantity
FROM o_PECivilPrice where PECivilPriceId=@tempCivilId;
SET @tempCivilAddId=(SELECT top 1 PECivilPriceId FROM o_PECivilPrice ORDER BY PECivilPriceId DESC);
INSERT INTO o_PECivilPriceSingle (XMMC,GCLJSS,DW,GCL,RGDJ,CLDJ,PECivilPriceId,Memo)
SELECT XMMC,GCLJSS,DW,GCL,RGDJ,CLDJ,@tempCivilAddId,Memo FROM o_PECivilPriceSingle
WHERE PECivilPriceId=@tempCivilId;
FETCH NEXT FROM mycursor INTO @tempCivilId;
END
CLOSE mycursor
DEALLOCATE mycursor
END