DELETE FROM [dbo].[T_Record_Info] WHERE (([ID] = @Original_ID)) INSERT INTO [dbo].[T_Record_Info] ([Beian_No], [Beian_type], [Unit_Name], [Project_name], [Contact_Person], [Contact_Tel], [province], [city], [country], [Project_Addr], [ShiGongXuke_No], [UseProperty], [ShiGongXuKe_Time], [Design_no], [Finish_time], [DesignUnit_Contact_Tel], [DesignUnit_ContactPerson], [DesignUnit_principal], [DesignUnit_Level], [DesignUnit_Name], [ConstructUnit_Contact_Tel], [ConstructUnit_ContactPerson], [ConstructUnit_principal], [ConstructUnit_Level], [ConstructUnit_Name], [MonitorUnit_Contact_Tel], [MonitorUnit_ContactPerson], [MonitorUnit_principal], [MonitorUnit_Level], [MonitorUnit_Name], [CheckUnit_Contact_Tel], [CheckUnit_ContactPerson], [CheckUnit_principal], [CheckUnit_Level], [CheckUnit_Name], [Project_Desc], [ConstractUnit_Suggestions], [DesignUnit_Suggestions], [ContractorUnit_Suggestion], [EstablishmentUnit_Suggestion], [PrjectMonitorUnit_Suggestion], [EstablishmentCheckUnit_Suggestion], [Check_Flag], [Beian_DateTime], [Check_date], [validate_code], [monitorOrg], [group_ID], [group_code]) VALUES (@Beian_No, @Beian_type, @Unit_Name, @Project_name, @Contact_Person, @Contact_Tel, @province, @city, @country, @Project_Addr, @ShiGongXuke_No, @UseProperty, @ShiGongXuKe_Time, @Design_no, @Finish_time, @DesignUnit_Contact_Tel, @DesignUnit_ContactPerson, @DesignUnit_principal, @DesignUnit_Level, @DesignUnit_Name, @ConstructUnit_Contact_Tel, @ConstructUnit_ContactPerson, @ConstructUnit_principal, @ConstructUnit_Level, @ConstructUnit_Name, @MonitorUnit_Contact_Tel, @MonitorUnit_ContactPerson, @MonitorUnit_principal, @MonitorUnit_Level, @MonitorUnit_Name, @CheckUnit_Contact_Tel, @CheckUnit_ContactPerson, @CheckUnit_principal, @CheckUnit_Level, @CheckUnit_Name, @Project_Desc, @ConstractUnit_Suggestions, @DesignUnit_Suggestions, @ContractorUnit_Suggestion, @EstablishmentUnit_Suggestion, @PrjectMonitorUnit_Suggestion, @EstablishmentCheckUnit_Suggestion, @Check_Flag, @Beian_DateTime, @Check_date, @validate_code, @monitorOrg, @group_ID, @group_code) SELECT ID, Beian_No, Beian_type, Unit_Name, Project_name, Contact_Person, Contact_Tel, province, city, country, Project_Addr, ShiGongXuke_No, UseProperty, ShiGongXuKe_Time, Design_no, Finish_time, DesignUnit_Contact_Tel, DesignUnit_ContactPerson, DesignUnit_principal, DesignUnit_Level, DesignUnit_Name, ConstructUnit_Contact_Tel, ConstructUnit_ContactPerson, ConstructUnit_principal, ConstructUnit_Level, ConstructUnit_Name, MonitorUnit_Contact_Tel, MonitorUnit_ContactPerson, MonitorUnit_principal, MonitorUnit_Level, MonitorUnit_Name, CheckUnit_Contact_Tel, CheckUnit_ContactPerson, CheckUnit_principal, CheckUnit_Level, CheckUnit_Name, Project_Desc, ConstractUnit_Suggestions, DesignUnit_Suggestions, ContractorUnit_Suggestion, EstablishmentUnit_Suggestion, PrjectMonitorUnit_Suggestion, EstablishmentCheckUnit_Suggestion, Check_Flag, Beian_DateTime, Check_date, validate_code, monitorOrg, group_ID, group_code FROM dbo.T_Record_Info UPDATE [dbo].[T_Record_Info] SET [Beian_No] = @Beian_No, [Beian_type] = @Beian_type, [Unit_Name] = @Unit_Name, [Project_name] = @Project_name, [Contact_Person] = @Contact_Person, [Contact_Tel] = @Contact_Tel, [province] = @province, [city] = @city, [country] = @country, [Project_Addr] = @Project_Addr, [ShiGongXuke_No] = @ShiGongXuke_No, [UseProperty] = @UseProperty, [ShiGongXuKe_Time] = @ShiGongXuKe_Time, [Design_no] = @Design_no, [Finish_time] = @Finish_time, [DesignUnit_Contact_Tel] = @DesignUnit_Contact_Tel, [DesignUnit_ContactPerson] = @DesignUnit_ContactPerson, [DesignUnit_principal] = @DesignUnit_principal, [DesignUnit_Level] = @DesignUnit_Level, [DesignUnit_Name] = @DesignUnit_Name, [ConstructUnit_Contact_Tel] = @ConstructUnit_Contact_Tel, [ConstructUnit_ContactPerson] = @ConstructUnit_ContactPerson, [ConstructUnit_principal] = @ConstructUnit_principal, [ConstructUnit_Level] = @ConstructUnit_Level, [ConstructUnit_Name] = @ConstructUnit_Name, [MonitorUnit_Contact_Tel] = @MonitorUnit_Contact_Tel, [MonitorUnit_ContactPerson] = @MonitorUnit_ContactPerson, [MonitorUnit_principal] = @MonitorUnit_principal, [MonitorUnit_Level] = @MonitorUnit_Level, [MonitorUnit_Name] = @MonitorUnit_Name, [CheckUnit_Contact_Tel] = @CheckUnit_Contact_Tel, [CheckUnit_ContactPerson] = @CheckUnit_ContactPerson, [CheckUnit_principal] = @CheckUnit_principal, [CheckUnit_Level] = @CheckUnit_Level, [CheckUnit_Name] = @CheckUnit_Name, [Project_Desc] = @Project_Desc, [ConstractUnit_Suggestions] = @ConstractUnit_Suggestions, [DesignUnit_Suggestions] = @DesignUnit_Suggestions, [ContractorUnit_Suggestion] = @ContractorUnit_Suggestion, [EstablishmentUnit_Suggestion] = @EstablishmentUnit_Suggestion, [PrjectMonitorUnit_Suggestion] = @PrjectMonitorUnit_Suggestion, [EstablishmentCheckUnit_Suggestion] = @EstablishmentCheckUnit_Suggestion, [Check_Flag] = @Check_Flag, [Beian_DateTime] = @Beian_DateTime, [Check_date] = @Check_date, [validate_code] = @validate_code, [monitorOrg] = @monitorOrg, [group_ID] = @group_ID, [group_code] = @group_code WHERE (([ID] = @Original_ID)) DELETE FROM [dbo].[T_Project_Info] WHERE (([ID] = @Original_ID)) INSERT INTO [dbo].[T_Project_Info] ([Beian_No], [Beian_Type], [Builder_Name], [Frame_Name], [Naihuo_Level], [Height], [Layer_Num], [Contruct_Area], [Danger_Type]) VALUES (@Beian_No, @Beian_Type, @Builder_Name, @Frame_Name, @Naihuo_Level, @Height, @Layer_Num, @Contruct_Area, @Danger_Type) SELECT ID, Beian_No, Beian_Type, Builder_Name, Frame_Name, Naihuo_Level, Height, Layer_Num, Contruct_Area, Danger_Type FROM dbo.T_Project_Info UPDATE [dbo].[T_Project_Info] SET [Beian_No] = @Beian_No, [Beian_Type] = @Beian_Type, [Builder_Name] = @Builder_Name, [Frame_Name] = @Frame_Name, [Naihuo_Level] = @Naihuo_Level, [Height] = @Height, [Layer_Num] = @Layer_Num, [Contruct_Area] = @Contruct_Area, [Danger_Type] = @Danger_Type WHERE (([ID] = @Original_ID)) DELETE FROM [dbo].[T_Pot_Info] WHERE (([ID] = @Original_ID)) INSERT INTO [dbo].[T_Pot_Info] ([Beian_No], [Position], [Material_Name], [Type_InnerTop], [Type_Water], [Type_Top], [Type_Ball], [Type_Vaulted], [Type_Horizontal], [Type_Others], [Sort_KeRan_Liquid], [Sort_YiRan_Liquid], [Sort_KeRan_Gas], [Sort_ZhuRan_Gas], [Sort_BuRan_Gas], [Sort_Other], [Material_Steel], [Material_Quan], [Material_Silicon], [Material_Other], [Press_High], [Press_Middle], [Press_Low], [Temperature_low], [Temperature_common], [Form_Overground], [Form_MidUnderground], [Form_Underground]) VALUES (@Beian_No, @Position, @Material_Name, @Type_InnerTop, @Type_Water, @Type_Top, @Type_Ball, @Type_Vaulted, @Type_Horizontal, @Type_Others, @Sort_KeRan_Liquid, @Sort_YiRan_Liquid, @Sort_KeRan_Gas, @Sort_ZhuRan_Gas, @Sort_BuRan_Gas, @Sort_Other, @Material_Steel, @Material_Quan, @Material_Silicon, @Material_Other, @Press_High, @Press_Middle, @Press_Low, @Temperature_low, @Temperature_common, @Form_Overground, @Form_MidUnderground, @Form_Underground) SELECT ID, Beian_No, Position, Material_Name, Type_InnerTop, Type_Water, Type_Top, Type_Ball, Type_Vaulted, Type_Horizontal, Type_Others, Sort_KeRan_Liquid, Sort_YiRan_Liquid, Sort_KeRan_Gas, Sort_ZhuRan_Gas, Sort_BuRan_Gas, Sort_Other, Material_Steel, Material_Quan, Material_Silicon, Material_Other, Press_High, Press_Middle, Press_Low, Temperature_low, Temperature_common, Form_Overground, Form_MidUnderground, Form_Underground FROM dbo.T_Pot_Info UPDATE [dbo].[T_Pot_Info] SET [Beian_No] = @Beian_No, [Position] = @Position, [Material_Name] = @Material_Name, [Type_InnerTop] = @Type_InnerTop, [Type_Water] = @Type_Water, [Type_Top] = @Type_Top, [Type_Ball] = @Type_Ball, [Type_Vaulted] = @Type_Vaulted, [Type_Horizontal] = @Type_Horizontal, [Type_Others] = @Type_Others, [Sort_KeRan_Liquid] = @Sort_KeRan_Liquid, [Sort_YiRan_Liquid] = @Sort_YiRan_Liquid, [Sort_KeRan_Gas] = @Sort_KeRan_Gas, [Sort_ZhuRan_Gas] = @Sort_ZhuRan_Gas, [Sort_BuRan_Gas] = @Sort_BuRan_Gas, [Sort_Other] = @Sort_Other, [Material_Steel] = @Material_Steel, [Material_Quan] = @Material_Quan, [Material_Silicon] = @Material_Silicon, [Material_Other] = @Material_Other, [Press_High] = @Press_High, [Press_Middle] = @Press_Middle, [Press_Low] = @Press_Low, [Temperature_low] = @Temperature_low, [Temperature_common] = @Temperature_common, [Form_Overground] = @Form_Overground, [Form_MidUnderground] = @Form_MidUnderground, [Form_Underground] = @Form_Underground WHERE (([ID] = @Original_ID)) DELETE FROM [dbo].[T_Field_Info] WHERE (([ID] = @Original_ID)) INSERT INTO [dbo].[T_Field_Info] ([Beian_no], [Field_Material_Name], [Field_Material_Quantity]) VALUES (@Beian_no, @Field_Material_Name, @Field_Material_Quantity) SELECT ID, Beian_no, Field_Material_Name, Field_Material_Quantity FROM dbo.T_Field_Info UPDATE [dbo].[T_Field_Info] SET [Beian_no] = @Beian_no, [Field_Material_Name] = @Field_Material_Name, [Field_Material_Quantity] = @Field_Material_Quantity WHERE (([ID] = @Original_ID)) DELETE FROM [dbo].[T_Project_Main_Content_Info] WHERE (([ID] = @Original_ID)) INSERT INTO [dbo].[T_Project_Main_Content_Info] ([Beian_No], [Beian_Type], [Build_Project], [Build_Fireproofing_Space], [Build_Fireproofing_Area], [Build_Smokeproofing_Area], [Build_Fire_Elevator], [Build_Smokeproofing_stair], [Build_Close_stair], [Build_Pumper_way], [Build_Control_Room], [Upholstery_Project], [Upholstery_Top], [Upholstery_Wall], [Upholstery_Floor], [Upholstery_Seperate], [Upholstery_Furniture], [Upholstery_Fabric], [Upholstery_Other_Fabric], [FireHydrant_type], [FireHydrant_Pipe_Net], [FireHydrant_Fire_Pool], [FireHydrant_Crude_Water], [WaterWork_System], [WaterWork_Dry], [WaterWork_Wet], [WaterWork_Beforehand], [WaterWork_Drench], [WaterWork_WaterScreen], [WaterWork_WaterFog], [AutoAlarm_System], [AutoAlarm_Area], [AutoAlarm_Collect], [AutoAlarm_ControlCenter], [Gas_System], [Gas_SysForm_Pip_Net], [Gas_SysForm_No_Pip_Net], [Gas_Extinguisher_Clean_Gas], [Gas_Extinguisher_HaLong], [Gas_Extinguisher_Others], [Bubble_System], [Bubble_SysForm_Fixup], [Bubble_SysForm_Half_Fixup], [Bubble_SysForm_Motion], [Bubble_Type_High], [Bubble_Type_Middle], [Bubble_Type_Low], [Bubble_Liquid_KangRongXing], [Bubble_Liquid_FuDanBai], [Bubble_Liquid_Water], [Bubble_Liquid_Others], [Smoke_System], [Smoke_JiXiePaiYan], [Smoke_ZhengYaSongFeng], [Smoke_ZiRanPaiYan], [Extinguisher_System], [Extinguisher_Powder], [Extinguisher_Gas], [Extinguisher_Water], [Extinguisher_Bubble], [Extinguisher_Others], [Powder_System], [Other], [slxhs_location], [zdpsmhxt_location], [hzzdbjxt_location], [qtmhxt_location], [pmmhxt_location], [fypyxt_location], [mhq_location], [gfmhxt_location], [qt_location], [gfmhxt_desc], [qt_desc]) VALUES (@Beian_No, @Beian_Type, @Build_Project, @Build_Fireproofing_Space, @Build_Fireproofing_Area, @Build_Smokeproofing_Area, @Build_Fire_Elevator, @Build_Smokeproofing_stair, @Build_Close_stair, @Build_Pumper_way, @Build_Control_Room, @Upholstery_Project, @Upholstery_Top, @Upholstery_Wall, @Upholstery_Floor, @Upholstery_Seperate, @Upholstery_Furniture, @Upholstery_Fabric, @Upholstery_Other_Fabric, @FireHydrant_type, @FireHydrant_Pipe_Net, @FireHydrant_Fire_Pool, @FireHydrant_Crude_Water, @WaterWork_System, @WaterWork_Dry, @WaterWork_Wet, @WaterWork_Beforehand, @WaterWork_Drench, @WaterWork_WaterScreen, @WaterWork_WaterFog, @AutoAlarm_System, @AutoAlarm_Area, @AutoAlarm_Collect, @AutoAlarm_ControlCenter, @Gas_System, @Gas_SysForm_Pip_Net, @Gas_SysForm_No_Pip_Net, @Gas_Extinguisher_Clean_Gas, @Gas_Extinguisher_HaLong, @Gas_Extinguisher_Others, @Bubble_System, @Bubble_SysForm_Fixup, @Bubble_SysForm_Half_Fixup, @Bubble_SysForm_Motion, @Bubble_Type_High, @Bubble_Type_Middle, @Bubble_Type_Low, @Bubble_Liquid_KangRongXing, @Bubble_Liquid_FuDanBai, @Bubble_Liquid_Water, @Bubble_Liquid_Others, @Smoke_System, @Smoke_JiXiePaiYan, @Smoke_ZhengYaSongFeng, @Smoke_ZiRanPaiYan, @Extinguisher_System, @Extinguisher_Powder, @Extinguisher_Gas, @Extinguisher_Water, @Extinguisher_Bubble, @Extinguisher_Others, @Powder_System, @Other, @slxhs_location, @zdpsmhxt_location, @hzzdbjxt_location, @qtmhxt_location, @pmmhxt_location, @fypyxt_location, @mhq_location, @gfmhxt_location, @qt_location, @gfmhxt_desc, @qt_desc) SELECT ID, Beian_No, Beian_Type, Build_Project, Build_Fireproofing_Space, Build_Fireproofing_Area, Build_Smokeproofing_Area, Build_Fire_Elevator, Build_Smokeproofing_stair, Build_Close_stair, Build_Pumper_way, Build_Control_Room, Upholstery_Project, Upholstery_Top, Upholstery_Wall, Upholstery_Floor, Upholstery_Seperate, Upholstery_Furniture, Upholstery_Fabric, Upholstery_Other_Fabric, FireHydrant_type, FireHydrant_Pipe_Net, FireHydrant_Fire_Pool, FireHydrant_Crude_Water, WaterWork_System, WaterWork_Dry, WaterWork_Wet, WaterWork_Beforehand, WaterWork_Drench, WaterWork_WaterScreen, WaterWork_WaterFog, AutoAlarm_System, AutoAlarm_Area, AutoAlarm_Collect, AutoAlarm_ControlCenter, Gas_System, Gas_SysForm_Pip_Net, Gas_SysForm_No_Pip_Net, Gas_Extinguisher_Clean_Gas, Gas_Extinguisher_HaLong, Gas_Extinguisher_Others, Bubble_System, Bubble_SysForm_Fixup, Bubble_SysForm_Half_Fixup, Bubble_SysForm_Motion, Bubble_Type_High, Bubble_Type_Middle, Bubble_Type_Low, Bubble_Liquid_KangRongXing, Bubble_Liquid_FuDanBai, Bubble_Liquid_Water, Bubble_Liquid_Others, Smoke_System, Smoke_JiXiePaiYan, Smoke_ZhengYaSongFeng, Smoke_ZiRanPaiYan, Extinguisher_System, Extinguisher_Powder, Extinguisher_Gas, Extinguisher_Water, Extinguisher_Bubble, Extinguisher_Others, Powder_System, Other, slxhs_location, zdpsmhxt_location, hzzdbjxt_location, qtmhxt_location, pmmhxt_location, fypyxt_location, mhq_location, gfmhxt_location, qt_location, gfmhxt_desc, qt_desc FROM dbo.T_Project_Main_Content_Info UPDATE [dbo].[T_Project_Main_Content_Info] SET [Beian_No] = @Beian_No, [Beian_Type] = @Beian_Type, [Build_Project] = @Build_Project, [Build_Fireproofing_Space] = @Build_Fireproofing_Space, [Build_Fireproofing_Area] = @Build_Fireproofing_Area, [Build_Smokeproofing_Area] = @Build_Smokeproofing_Area, [Build_Fire_Elevator] = @Build_Fire_Elevator, [Build_Smokeproofing_stair] = @Build_Smokeproofing_stair, [Build_Close_stair] = @Build_Close_stair, [Build_Pumper_way] = @Build_Pumper_way, [Build_Control_Room] = @Build_Control_Room, [Upholstery_Project] = @Upholstery_Project, [Upholstery_Top] = @Upholstery_Top, [Upholstery_Wall] = @Upholstery_Wall, [Upholstery_Floor] = @Upholstery_Floor, [Upholstery_Seperate] = @Upholstery_Seperate, [Upholstery_Furniture] = @Upholstery_Furniture, [Upholstery_Fabric] = @Upholstery_Fabric, [Upholstery_Other_Fabric] = @Upholstery_Other_Fabric, [FireHydrant_type] = @FireHydrant_type, [FireHydrant_Pipe_Net] = @FireHydrant_Pipe_Net, [FireHydrant_Fire_Pool] = @FireHydrant_Fire_Pool, [FireHydrant_Crude_Water] = @FireHydrant_Crude_Water, [WaterWork_System] = @WaterWork_System, [WaterWork_Dry] = @WaterWork_Dry, [WaterWork_Wet] = @WaterWork_Wet, [WaterWork_Beforehand] = @WaterWork_Beforehand, [WaterWork_Drench] = @WaterWork_Drench, [WaterWork_WaterScreen] = @WaterWork_WaterScreen, [WaterWork_WaterFog] = @WaterWork_WaterFog, [AutoAlarm_System] = @AutoAlarm_System, [AutoAlarm_Area] = @AutoAlarm_Area, [AutoAlarm_Collect] = @AutoAlarm_Collect, [AutoAlarm_ControlCenter] = @AutoAlarm_ControlCenter, [Gas_System] = @Gas_System, [Gas_SysForm_Pip_Net] = @Gas_SysForm_Pip_Net, [Gas_SysForm_No_Pip_Net] = @Gas_SysForm_No_Pip_Net, [Gas_Extinguisher_Clean_Gas] = @Gas_Extinguisher_Clean_Gas, [Gas_Extinguisher_HaLong] = @Gas_Extinguisher_HaLong, [Gas_Extinguisher_Others] = @Gas_Extinguisher_Others, [Bubble_System] = @Bubble_System, [Bubble_SysForm_Fixup] = @Bubble_SysForm_Fixup, [Bubble_SysForm_Half_Fixup] = @Bubble_SysForm_Half_Fixup, [Bubble_SysForm_Motion] = @Bubble_SysForm_Motion, [Bubble_Type_High] = @Bubble_Type_High, [Bubble_Type_Middle] = @Bubble_Type_Middle, [Bubble_Type_Low] = @Bubble_Type_Low, [Bubble_Liquid_KangRongXing] = @Bubble_Liquid_KangRongXing, [Bubble_Liquid_FuDanBai] = @Bubble_Liquid_FuDanBai, [Bubble_Liquid_Water] = @Bubble_Liquid_Water, [Bubble_Liquid_Others] = @Bubble_Liquid_Others, [Smoke_System] = @Smoke_System, [Smoke_JiXiePaiYan] = @Smoke_JiXiePaiYan, [Smoke_ZhengYaSongFeng] = @Smoke_ZhengYaSongFeng, [Smoke_ZiRanPaiYan] = @Smoke_ZiRanPaiYan, [Extinguisher_System] = @Extinguisher_System, [Extinguisher_Powder] = @Extinguisher_Powder, [Extinguisher_Gas] = @Extinguisher_Gas, [Extinguisher_Water] = @Extinguisher_Water, [Extinguisher_Bubble] = @Extinguisher_Bubble, [Extinguisher_Others] = @Extinguisher_Others, [Powder_System] = @Powder_System, [Other] = @Other, [slxhs_location] = @slxhs_location, [zdpsmhxt_location] = @zdpsmhxt_location, [hzzdbjxt_location] = @hzzdbjxt_location, [qtmhxt_location] = @qtmhxt_location, [pmmhxt_location] = @pmmhxt_location, [fypyxt_location] = @fypyxt_location, [mhq_location] = @mhq_location, [gfmhxt_location] = @gfmhxt_location, [qt_location] = @qt_location, [gfmhxt_desc] = @gfmhxt_desc, [qt_desc] = @qt_desc WHERE (([ID] = @Original_ID))