Method and system for batch copying data in non-continuous areas

Abstract

The present invention discloses a method and system for batch copying data in a non-continuous area. The method comprises the following steps: S1: generating a list form according to a project form template according to a generation instruction; S2: querying an archive form of a reference project according to a query instruction; S3: batch copying the data content of the non-continuous area according to multiple copy instructions of the non-continuous area on the archive form; S4: automatically pasting the data content to a matching position of the list form according to a non-continuous area paste instruction on the list form. By implementing the present invention, batch copying and pasting of non-continuous areas can be realized, and the copying efficiency and data processing efficiency of non-continuous areas can be improved.

Description

Technical Field

[0001] The present invention relates to the technical field of nuclear power plant project pricing, and in particular to a method and system for batch copying non-continuous area data. Background Art

[0002] When you need to refer to the cost data of historical projects, you have to copy them one by one, which is inefficient and prone to errors and does not meet business requirements. Summary of the invention

[0003] The technical problem to be solved by the present invention is to provide a method and system for batch copying data in a non-contiguous area in view of at least one defect in the prior art.

[0004] The technical solution adopted by the present invention to solve the technical problem is: constructing a method for batch copying data in a non-continuous area, comprising the following steps:

[0005] S1: Generate a list form according to the project form template based on the generation instruction;

[0006] S2: Query the archived table of the reference project according to the query instruction;

[0007] S3: according to the multiple copy instructions of the non-continuous areas on the archiving table, batch copy the data content of the non-continuous areas;

[0008] S4: According to the non-continuous area paste instruction on the list form, the data content is automatically pasted to the matching position of the list form.

[0009] Preferably, in the method for batch copying data in a non-contiguous area according to the present invention, step S1 comprises:

[0010] S11: presetting a table template, wherein the table header of the table template includes fixed project items and items to be calculated for all projects;

[0011] S12: according to the project to which the list table to be generated belongs in the generation instruction, the items to be calculated in the table template are reduced to obtain a project table template;

[0012] S13: Generate a list table according to the project table template.

[0013] Preferably, in the method for batch copying data in a non-contiguous area according to the present invention, step S3 comprises:

[0014] S31: According to the multiple copy instructions of the non-contiguous areas on the archive table, the data contents of the non-contiguous areas and the corresponding column names are copied in batches and stored in a copy content set.

[0015] Preferably, in the method for batch copying data in a non-contiguous area according to the present invention, step S3 further comprises:

[0016] S32: Display each piece of data content in the duplicate content set, and delete the data content according to the received deletion instruction.

[0017] Preferably, in the method for batch copying data in non-contiguous areas of the present invention, step S4 comprises:

[0018] S41: according to the non-continuous area paste instruction on the list table, obtaining the column name corresponding to each piece of data content in the copied content set, and matching it with the column name in the list table;

[0019] S42: If the match is consistent, pasting the data content into the cell corresponding to the column name in the list table;

[0020] S43: If the matches are inconsistent, then paste each unmatched data content into a cell selected by the user according to the user's operation instruction, or discard the unmatched data content.

[0021] The present invention also constructs a discontinuous area data batch replication system, comprising:

[0022] A generation module, used for generating a list form according to a project form template based on a generation instruction;

[0023] A query module, used to query the archived table of reference items according to the query instruction;

[0024] A copy module, used for batch copying the data content of the non-continuous area according to the multiple copy instructions of the non-continuous area on the archive table;

[0025] The pasting module is used to automatically paste the data content to the matching position of the list form according to the non-continuous area paste instruction on the list form.

[0026] Preferably, in the non-contiguous area data batch replication system of the present invention, the generation module includes:

[0027] A preset table template, wherein the table header of the table template includes fixed project items and items to be calculated for all projects;

[0028] A template cutting module is used to cut the items to be calculated in the table template according to the items to be generated in the list table in the generation instruction, so as to obtain a project table template;

[0029] The table generation module is used to generate a list table according to the project table template.

[0030] Preferably, in the non-contiguous area data batch replication system of the present invention, the replication module includes:

[0031] The content copying module copies the data content and the corresponding column names of the non-continuous areas in batches according to the multiple copying instructions of the non-continuous areas on the archive table, and stores them in the copying content set.

[0032] Preferably, in the non-contiguous area data batch replication system of the present invention, the replication module further comprises:

[0033] A display module, used to display each piece of data content in the copied content set;

[0034] The deletion module is used to delete the data content according to the received deletion instruction.

[0035] Preferably, in the system for batch copying data in a non-contiguous area according to the present invention, the pasting module comprises:

[0036] A matching module, configured to obtain, according to the non-continuous area paste instruction on the list table, a column name corresponding to each piece of data content in the copied content set, and match it with the column name in the list table;

[0037] An automatic pasting module, for pasting the data content into the cell corresponding to the column name in the list table if the match is consistent;

[0038] The manual pasting module is used to paste each unmatched data content into a cell selected by the user according to the user's operation instruction if the match is inconsistent, or to discard the unmatched data content.

[0039] By implementing the present invention, the following beneficial effects are achieved:

[0040] The present invention generates a list table according to a project table template according to a generation instruction, and then queries the archive table of the reference project according to the query instruction, and then batch copies the data content of the non-continuous area according to multiple copy instructions of the non-continuous area on the archive table, and finally automatically pastes the data content to the matching position of the list table according to the non-continuous area paste instruction on the list table, thereby realizing batch copying and pasting of non-continuous areas and improving the copying efficiency and data processing efficiency of non-continuous areas. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] The present invention will be further described below with reference to the accompanying drawings and embodiments, in which:

[0042] Figure 1 It is a flow chart of the method for batch copying data in non-continuous areas of the present invention;

[0043] Figure 2 It is a user operation interface diagram for generating generation instructions of the present invention;

[0044] Figure 3 It is a flow chart of a method for pasting data content to a matching position of a list table according to the present invention;

[0045] Figure 4 It is a module block diagram of the discontinuous area data batch replication system of the present invention. DETAILED DESCRIPTION

[0046] In order to have a clearer understanding of the technical features, purposes and effects of the present invention, specific embodiments of the present invention are now described in detail with reference to the accompanying drawings.

[0047] It should be noted that the flowcharts shown in the accompanying drawings are only exemplary and do not necessarily include all the contents and operations / steps, nor do they have to be executed in the order described. For example, some operations / steps can be decomposed, while some operations / steps can be combined or partially combined, so the actual execution order may change according to actual conditions.

[0048] The block diagrams shown in the accompanying drawings are merely functional entities and do not necessarily correspond to physically independent entities. That is, these functional entities may be implemented in software form, or in one or more hardware modules or integrated circuits, or in different networks and / or processor devices and / or microcontroller devices.

[0049] like Figure 1 As shown, the present invention discloses a method for batch copying data in a non-contiguous area, comprising the following steps:

[0050] Step S1: Generate a list form according to a project form template based on a generation instruction;

[0051] Step S2: querying the archive table of the reference project according to the query instruction;

[0052] Step S3: according to the multiple copy instructions of the non-continuous areas on the archive table, batch copy the data content of the non-continuous areas;

[0053] Step S4: According to the paste instruction in the non-continuous area on the list table, the data content is automatically pasted to the matching position of the list table.

[0054] In this embodiment, step S1 includes:

[0055] Step S11: presetting a table template, the table header of which includes fixed project items and items to be calculated for all projects;

[0056] Step S12: according to the project to which the list table to be generated belongs in the generation instruction, the items to be calculated in the table template are reduced to obtain a project table template;

[0057] Specifically, taking cost estimation as an example, Figure 2 As shown, the user interface displays the project names under cost estimation, including engineering costs and management fees, etc., and the engineering costs include construction and installation engineering costs, equipment purchase costs, commissioning costs, etc., and various engineering costs have related cost items. For example, the construction and installation engineering costs include preliminary engineering, nuclear island and BOP construction engineering cost items. Based on the user's selection of cost items, a generation instruction is generated, and the items to be calculated in the table template are trimmed according to the items to which the list table to be generated in the generation instruction belongs, so as to obtain a project table template.

[0058] Step S13: Generate a bill of quantities form according to the project form template, such as the cost estimation bill of quantities form shown in Table 1 below.

[0059] Table 1

[0060] Serial number Drawing code Project Code Project Name Component Name Part code Calculation process unit Project Quantity Remark

[0061] Among them, the first row is the table header, "Serial number", "Drawing code", "Project code", and "Project name" are fixed project items, and the others are the items obtained by trimming the items to be calculated in the table template.

[0062] In this embodiment, step S2: query the archived table of the reference project according to the query instruction. Specifically, taking the creation of the cost estimation bill of quantities as an example, there is a button for querying the archived table in the display interface of the created cost estimation bill of quantities table. After the user clicks the button and enters a keyword for query, similar tables in the archive library can be obtained, such as: standard list, contract price list, ** project cost estimation list, etc.

[0063] In this embodiment, step S3 includes:

[0064] Step S31: according to the multiple copy instructions of the non-continuous area on the archive table, the data content of the non-continuous area and the corresponding column names are copied in batches and stored in the copy content set.

[0065] When copying the contents of an archive table, the user may only need to copy part of the contents, and the content of this part may not be in a continuous area. In this case, the user can perform the copy operation multiple times, and the content of each copy will not overwrite the previous content, that is, each copied content and its corresponding column name will be stored to form a copy content set.

[0066] In this embodiment, step S3 further includes:

[0067] Step S32: Display each piece of data content in the copy content set, and delete the data content according to the received deletion instruction.

[0068] In some embodiments, a collection of copied content and a delete button corresponding to each piece of data may be displayed. If an operation of the delete button is received, the content may be deleted from the collection. This may help the user delete the content with the copy error after discovering the copy error.

[0069] In this embodiment, if Figure 3 As shown, step S4 includes:

[0070] Step S41: According to the paste instruction in the non-continuous area on the list table, obtain the column name corresponding to each data content in the copied content set, and match it with the column name in the list table. The column name is the fixed item name in the table header and the name of the item to be calculated;

[0071] Step S42: If the match is consistent, paste the data content in the cell corresponding to the column name in the list table;

[0072] Step S43: If the match is inconsistent, then paste each unmatched data content into the cell selected by the user according to the user's operation instruction, or discard the unmatched data content.

[0073] Specifically, taking the cost estimation bill of quantities form as an example, after the user completes copying, he can switch back to the cost list form. The display interface of the form can display a non-continuous area paste button. If the button is operated, it indicates that it is different from the conventional pasting method, that is, the data content is not pasted at the position of the mouse, but is pasted on a non-continuous area. At this time, the terminal can obtain the column name corresponding to each data content in the copied content set, and match it with the column name in the cost estimation bill of quantities form. If the match is consistent, the data content is pasted in the cell corresponding to the column name. Each data content can be done in this way, thereby realizing a one-time paste operation, so that the data content of multiple non-continuous areas in the copied content set can be pasted to the matching position of the cost estimation bill of quantities form.

[0074] If the cost estimation bill of quantities table does not have a matching column name, a prompt message can be displayed, and the position selection button and the abandon paste button corresponding to each unmatched data content can be displayed. After the user clicks the position selection control, the cell in the cost estimation bill of quantities table can be selected, and the terminal pastes the unmatched data content in the cell selected by the user, thereby realizing the selection of the paste position of the unmatched data content. After the user clicks the abandon paste control, the unmatched data content is discarded and no longer pasted.

[0075] When all the data in the copy content set are pasted or the pasting is abandoned, the copy content set will be cleared so that the user can copy again to form a new copy content set.

[0076] Furthermore, if a project has multiple versions of the same data, the data of the current version can be compared with the previous version, and the modification records can be marked. For example, if a project has multiple versions of cost estimation, the data of the current version can be compared with the previous version, and the data with modification records can be marked.

[0077] The present invention also constructs a discontinuous area data batch replication system, comprising:

[0078] A generation module, used for generating a list form according to a project form template based on a generation instruction;

[0079] A query module, used to query the archived table of reference items according to the query instruction;

[0080] A copy module, used for batch copying the data content of the non-continuous area according to the multiple copy instructions of the non-continuous area on the archive table;

[0081] The pasting module is used to automatically paste the data content to the matching position of the list table according to the paste instruction of the non-continuous area on the list table.

[0082] In this embodiment, the generation module includes:

[0083] A preset table template, the table header of which includes fixed project items and all items to be calculated;

[0084] The template cutting module is used to cut the items to be calculated in the table template according to the items to be generated in the list table in the generation instruction, so as to obtain the project table template;

[0085] Specifically, taking cost estimation as an example, Figure 2 As shown, the user interface displays the project names under cost estimation, including engineering costs and management fees, etc., and the engineering costs include construction and installation engineering costs, equipment purchase costs, commissioning costs, etc., and various engineering costs have related cost items. For example, the construction and installation engineering costs include preliminary engineering, nuclear island and BOP construction engineering cost items. Based on the user's selection of cost items, a generation instruction is generated, and the items to be calculated in the table template are trimmed according to the items to which the list table to be generated in the generation instruction belongs, so as to obtain a project table template.

[0086] The table generation module is used to generate a list table based on the project table template, such as the cost estimation bill of quantities table shown in Table 1 below.

[0087] Table 1

[0088] Serial number Drawing code Project Code Project Name Component Name Part code Calculation process unit Project Quantity Remark

[0089] Among them, the first row is the table header, "Serial number", "Drawing code", "Project code", and "Project name" are fixed project items, and the others are the items obtained by cutting the items to be calculated in the table template.

[0090] In this embodiment, the query module is used to query the archived table of the reference project according to the query instruction. Specifically, taking the creation of the cost estimation bill of quantities as an example, there is a button for querying the archived table in the display interface of the created cost estimation bill of quantities table. After the user clicks the button and enters a keyword for query, similar tables in the archive library can be obtained, such as: standard list, contract price list, ** project cost estimation list, etc.

[0091] In this embodiment, the copy module includes:

[0092] The copy content module, according to the multiple copy instructions of the non-continuous area on the archive table, batch copies the data content and the corresponding column names of the non-continuous area, and stores them in the copy content set.

[0093] When copying the contents of an archive table, the user may only need to copy part of the contents, and the content of this part may not be in a continuous area. In this case, the user can perform the copy operation multiple times, and the content of each copy will not overwrite the previous content, that is, each copied content and its corresponding column name will be stored to form a copy content set.

[0094] In this embodiment, the copy module also includes:

[0095] A display module is used to display each piece of data content in the copied content set;

[0096] The deletion module is used to delete the data content according to the received deletion instruction.

[0097] In some embodiments, a collection of copied content and a delete button corresponding to each piece of data may be displayed. If an operation of the delete button is received, the content may be deleted from the collection. This may help the user delete the content with the copy error after discovering the copy error.

[0098] In this embodiment, the pasting module includes:

[0099] The matching module is used to obtain the column name corresponding to each data content in the copied content set according to the paste instruction of the non-continuous area on the list table, and match it with the column name in the list table. The column name is the fixed project item name in the table header and the name of the item to be calculated;

[0100] The automatic paste module is used to paste the data content in the cell corresponding to the column name in the list table if the match is consistent;

[0101] The manual pasting module is used to paste each unmatched data content into a cell selected by the user according to the user's operation instruction if the match is inconsistent, or to discard the unmatched data content.

[0102] Specifically, taking the cost estimation bill of quantities form as an example, after the user completes copying, he can switch back to the cost list form. The display interface of the form can display a non-continuous area paste button. If the button is operated, it indicates that it is different from the conventional pasting method, that is, the data content is not pasted at the position of the mouse, but is pasted on a non-continuous area. At this time, the terminal can obtain the column name corresponding to each data content in the copied content set, and match it with the column name in the cost estimation bill of quantities form. If the match is consistent, the data content is pasted in the cell corresponding to the column name. Each data content can be done in this way, thereby realizing a one-time paste operation, so that the data content of multiple non-continuous areas in the copied content set can be pasted to the matching position of the cost estimation bill of quantities form.

[0103] If the cost estimation bill of quantities table does not have a matching column name, a prompt message can be displayed, and the position selection button and the abandon paste button corresponding to each unmatched data content can be displayed. After the user clicks the position selection control, the cell in the cost estimation bill of quantities table can be selected, and the terminal pastes the unmatched data content in the cell selected by the user, thereby realizing the selection of the paste position of the unmatched data content. After the user clicks the abandon paste control, the unmatched data content is discarded and no longer pasted.

[0104] When all the data in the copy content set are pasted or the pasting is abandoned, the copy content set will be cleared so that the user can copy again to form a new copy content set.

[0105] Furthermore, if a project has multiple versions of the same data, the data of the current version can be compared with the previous version, and the modification records can be marked. For example, if a project has multiple versions of cost estimation, the data of the current version can be compared with the previous version, and the data with modification records can be marked.

[0106] By implementing the present invention, the following beneficial effects are achieved:

[0107] The present invention generates a list table according to a project table template according to a generation instruction, and then queries the archive table of the reference project according to the query instruction, and then batch copies the data content of the non-continuous area according to multiple copy instructions of the non-continuous area on the archive table, and finally automatically pastes the data content to the matching position of the list table according to the non-continuous area paste instruction on the list table, thereby realizing batch copying and pasting of non-continuous areas and improving the copying efficiency and data processing efficiency of non-continuous areas.

[0108] It can be understood that the above embodiments only express the preferred implementation modes of the present invention, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the patent scope of the present invention. It should be pointed out that, for ordinary technicians in this field, the above technical features can be freely combined without departing from the concept of the present invention, and several deformations and improvements can be made, which all belong to the protection scope of the present invention. Therefore, all equivalent changes and modifications made to the scope of the claims of the present invention should belong to the coverage of the claims of the present invention.

Claims

1. A method for batch copying data in non-contiguous areas. It is characterized in that The following steps are involved: S1: Generate a list form according to the project form template based on the generation instruction; S2: Query the archived table of the reference project according to the query instruction; S3: according to the multiple copy instructions of the non-continuous areas on the archiving table, batch copy the data content of the non-continuous areas; S4: automatically pasting the data content to the matching position of the list form according to the non-continuous area paste instruction on the list form; Wherein, the step S3 comprises: S31: according to the multiple copy instructions of the non-contiguous areas on the archive table, batch copy the data content and the corresponding column names of the non-contiguous areas, and store them in the copy content set; S32: displaying each piece of data content in the copy content set, and deleting the data content according to the received deletion instruction; The step S4 comprises: S41: according to the non-continuous area paste instruction on the list table, obtaining the column name corresponding to each piece of data content in the copied content set, and matching it with the column name in the list table; S42: If the match is consistent, pasting the data content into the cell corresponding to the column name in the list table; S43: If the matches are inconsistent, then paste each unmatched data content into a cell selected by the user according to the user's operation instruction, or discard the unmatched data content.

2. The method for batch copying non-contiguous area data according to claim 1, It is characterized in that The step S1 comprises: S11: presetting a table template, wherein the table header of the table template includes fixed project items and items to be calculated for all projects; S12: according to the project to which the list table to be generated belongs in the generation instruction, the items to be calculated in the table template are reduced to obtain a project table template; S13: Generate a list table according to the project table template.

3. A system for batch replication of non-contiguous area data, It is characterized in that include: A generation module, used for generating a list form according to a project form template based on a generation instruction; A query module, used to query the archived table of reference items according to the query instruction; A copy module, used for batch copying the data content of the non-continuous area according to the multiple copy instructions of the non-continuous area on the archive table; A pasting module, used for automatically pasting the data content to the matching position of the list form according to the non-continuous area paste instruction on the list form; Wherein, the copy module includes: A content copying module, which, according to the multiple copying instructions of the non-continuous areas on the archive table, batch copies the data content and the corresponding column names of the non-continuous areas, and stores them in a copy content set; A display module, used to display each piece of data content in the copied content set; A deletion module, used to delete the data content according to the received deletion instruction; The pasting module comprises: A matching module, configured to obtain, according to the non-continuous area paste instruction on the list table, a column name corresponding to each piece of data content in the copied content set, and match it with the column name in the list table; An automatic pasting module, for pasting the data content into the cell corresponding to the column name in the list table if the match is consistent; The manual pasting module is used to paste each unmatched data content into a cell selected by the user according to the user's operation instruction if the match is inconsistent, or to discard the unmatched data content.

4. The system for batch copying data in a non-contiguous area according to claim 3, It is characterized in that The generation module comprises: A preset table template, wherein the table header of the table template includes fixed project items and items to be calculated for all projects; A template cutting module is used to cut the items to be calculated in the table template according to the items to be generated in the list table in the generation instruction, so as to obtain a project table template; The table generation module is used to generate a list table according to the project table template.

Images