DELETE FROM [dbo].[T_Record_Info] WHERE (([ID] = @Original_ID)) INSERT INTO [dbo].[T_Record_Info] ([Beian_No], [Beian_type], [Unit_Name], [Contact_Person], [Contact_Tel], [Project_name], [province], [city], [country], [Project_Addr], [ShiGongXuke_No], [UseProperty], [ShiGongXuKe_Time], [Design_no], [Finish_time], [monitorOrg], [Project_Desc], [ConstractUnit_Suggestions], [DesignUnit_Suggestions], [ContractorUnit_Suggestion], [EstablishmentUnit_Suggestion], [PrjectMonitorUnit_Suggestion], [EstablishmentCheckUnit_Suggestion], [Check_Flag], [Beian_DateTime], [Check_date], [validate_code], [group_ID], [group_code], [delete_flag], [prep_field1], [prep_field2], [prep_field3], [prep_field4], [prep_field5]) VALUES (@Beian_No, @Beian_type, @Unit_Name, @Contact_Person, @Contact_Tel, @Project_name, @province, @city, @country, @Project_Addr, @ShiGongXuke_No, @UseProperty, @ShiGongXuKe_Time, @Design_no, @Finish_time, @monitorOrg, @Project_Desc, @ConstractUnit_Suggestions, @DesignUnit_Suggestions, @ContractorUnit_Suggestion, @EstablishmentUnit_Suggestion, @PrjectMonitorUnit_Suggestion, @EstablishmentCheckUnit_Suggestion, @Check_Flag, @Beian_DateTime, @Check_date, @validate_code, @group_ID, @group_code, @delete_flag, @prep_field1, @prep_field2, @prep_field3, @prep_field4, @prep_field5) SELECT ID, Beian_No, Beian_type, Unit_Name, Contact_Person, Contact_Tel, Project_name, province, city, country, Project_Addr, ShiGongXuke_No, UseProperty, ShiGongXuKe_Time, Design_no, Finish_time, monitorOrg, Project_Desc, ConstractUnit_Suggestions, DesignUnit_Suggestions, ContractorUnit_Suggestion, EstablishmentUnit_Suggestion, PrjectMonitorUnit_Suggestion, EstablishmentCheckUnit_Suggestion, Check_Flag, Beian_DateTime, Check_date, validate_code, group_ID, group_code, delete_flag, prep_field1, prep_field2, prep_field3, prep_field4, prep_field5 FROM dbo.T_Record_Info UPDATE [dbo].[T_Record_Info] SET [Beian_No] = @Beian_No, [Beian_type] = @Beian_type, [Unit_Name] = @Unit_Name, [Contact_Person] = @Contact_Person, [Contact_Tel] = @Contact_Tel, [Project_name] = @Project_name, [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, [monitorOrg] = @monitorOrg, [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, [group_ID] = @group_ID, [group_code] = @group_code, [delete_flag] = @delete_flag, [prep_field1] = @prep_field1, [prep_field2] = @prep_field2, [prep_field3] = @prep_field3, [prep_field4] = @prep_field4, [prep_field5] = @prep_field5 WHERE (([ID] = @Original_ID)) DELETE FROM [dbo].[T_About_Units] WHERE (([ID] = @Original_ID)) INSERT INTO [dbo].[T_About_Units] ([beiAn_No], [unit_type], [unit_name], [unit_level], [unit_principal], [unit_linkMan], [unit_Tel], [unit_prep_Field1], [unit_prep_Field2], [unit_prep_Field3], [unit_prep_Field4], [unit_prep_Field5]) VALUES (@beiAn_No, @unit_type, @unit_name, @unit_level, @unit_principal, @unit_linkMan, @unit_Tel, @unit_prep_Field1, @unit_prep_Field2, @unit_prep_Field3, @unit_prep_Field4, @unit_prep_Field5) SELECT ID, beiAn_No, unit_type, unit_name, unit_level, unit_principal, unit_linkMan, unit_Tel, unit_prep_Field1, unit_prep_Field2, unit_prep_Field3, unit_prep_Field4, unit_prep_Field5 FROM dbo.T_About_Units UPDATE [dbo].[T_About_Units] SET [beiAn_No] = @beiAn_No, [unit_type] = @unit_type, [unit_name] = @unit_name, [unit_level] = @unit_level, [unit_principal] = @unit_principal, [unit_linkMan] = @unit_linkMan, [unit_Tel] = @unit_Tel, [unit_prep_Field1] = @unit_prep_Field1, [unit_prep_Field2] = @unit_prep_Field2, [unit_prep_Field3] = @unit_prep_Field3, [unit_prep_Field4] = @unit_prep_Field4, [unit_prep_Field5] = @unit_prep_Field5 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], [AreaOrReserves], [prep_field1], [prep_field2], [prep_field3], [prep_field4], [prep_field5]) VALUES (@Beian_No, @Beian_Type, @Builder_Name, @Frame_Name, @Naihuo_Level, @Height, @Layer_Num, @Contruct_Area, @Danger_Type, @AreaOrReserves, @prep_field1, @prep_field2, @prep_field3, @prep_field4, @prep_field5) SELECT ID, Beian_No, Beian_Type, Builder_Name, Frame_Name, Naihuo_Level, Height, Layer_Num, Contruct_Area, Danger_Type, AreaOrReserves, prep_field1, prep_field2, prep_field3, prep_field4, prep_field5 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, [AreaOrReserves] = @AreaOrReserves, [prep_field1] = @prep_field1, [prep_field2] = @prep_field2, [prep_field3] = @prep_field3, [prep_field4] = @prep_field4, [prep_field5] = @prep_field5 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], [summary_type_name], [summary_type_value], [item_type_name], [item_type_value], [item_position], [item_material], [item_fireLevel], [item_array_order], [item_array_mode], [prep_field5], [prep_field1], [prep_field2], [prep_field3], [prep_field4]) VALUES (@beiAn_No, @summary_type_name, @summary_type_value, @item_type_name, @item_type_value, @item_position, @item_material, @item_fireLevel, @item_array_order, @item_array_mode, @prep_field5, @prep_field1, @prep_field2, @prep_field3, @prep_field4) SELECT ID, beiAn_No, summary_type_name, summary_type_value, item_type_name, item_type_value, item_position, item_material, item_fireLevel, item_array_order, item_array_mode, prep_field5, prep_field1, prep_field2, prep_field3, prep_field4 FROM dbo.T_Project_Main_Content_Info UPDATE [dbo].[T_Project_Main_Content_Info] SET [beiAn_No] = @beiAn_No, [summary_type_name] = @summary_type_name, [summary_type_value] = @summary_type_value, [item_type_name] = @item_type_name, [item_type_value] = @item_type_value, [item_position] = @item_position, [item_material] = @item_material, [item_fireLevel] = @item_fireLevel, [item_array_order] = @item_array_order, [item_array_mode] = @item_array_mode, [prep_field5] = @prep_field5, [prep_field1] = @prep_field1, [prep_field2] = @prep_field2, [prep_field3] = @prep_field3, [prep_field4] = @prep_field4 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], [Danger_Type], [Material_Steel], [Material_Quan], [Material_Silicon], [Material_Other], [Temperature_low], [Temperature_common], [Form_Overground], [Form_MidUnderground], [Form_Underground], [Press_High], [Press_Middle], [Press_Low], [prep_field1], [prep_field2], [prep_field3], [prep_field4], [prep_field5]) 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, @Danger_Type, @Material_Steel, @Material_Quan, @Material_Silicon, @Material_Other, @Temperature_low, @Temperature_common, @Form_Overground, @Form_MidUnderground, @Form_Underground, @Press_High, @Press_Middle, @Press_Low, @prep_field1, @prep_field2, @prep_field3, @prep_field4, @prep_field5) 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, Danger_Type, Material_Steel, Material_Quan, Material_Silicon, Material_Other, Temperature_low, Temperature_common, Form_Overground, Form_MidUnderground, Form_Underground, Press_High, Press_Middle, Press_Low, prep_field1, prep_field2, prep_field3, prep_field4, prep_field5 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, [Danger_Type] = @Danger_Type, [Material_Steel] = @Material_Steel, [Material_Quan] = @Material_Quan, [Material_Silicon] = @Material_Silicon, [Material_Other] = @Material_Other, [Temperature_low] = @Temperature_low, [Temperature_common] = @Temperature_common, [Form_Overground] = @Form_Overground, [Form_MidUnderground] = @Form_MidUnderground, [Form_Underground] = @Form_Underground, [Press_High] = @Press_High, [Press_Middle] = @Press_Middle, [Press_Low] = @Press_Low, [prep_field1] = @prep_field1, [prep_field2] = @prep_field2, [prep_field3] = @prep_field3, [prep_field4] = @prep_field4, [prep_field5] = @prep_field5 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], [prep_field1], [prep_field2], [prep_field3], [prep_field4], [prep_field5]) VALUES (@Beian_no, @Field_Material_Name, @Field_Material_Quantity, @prep_field1, @prep_field2, @prep_field3, @prep_field4, @prep_field5) SELECT ID, Beian_no, Field_Material_Name, Field_Material_Quantity, prep_field1, prep_field2, prep_field3, prep_field4, prep_field5 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, [prep_field1] = @prep_field1, [prep_field2] = @prep_field2, [prep_field3] = @prep_field3, [prep_field4] = @prep_field4, [prep_field5] = @prep_field5 WHERE (([ID] = @Original_ID))