CN111639100A - Method and device for comparing capital construction and capital supply material design inventory and declaration information - Google Patents
Method and device for comparing capital construction and capital supply material design inventory and declaration informationDownload PDFInfo
- Publication number
- CN111639100A CN111639100ACN202010256510.0ACN202010256510ACN111639100ACN 111639100 ACN111639100 ACN 111639100ACN 202010256510 ACN202010256510 ACN 202010256510ACN 111639100 ACN111639100 ACN 111639100A
- Authority
- CN
- China
- Prior art keywords
- information
- groups
- matching
- group
- target
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06313—Resource planning in a project environment
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- Tourism & Hospitality (AREA)
- Data Mining & Analysis (AREA)
- General Business, Economics & Management (AREA)
- Operations Research (AREA)
- General Engineering & Computer Science (AREA)
- Quality & Reliability (AREA)
- Databases & Information Systems (AREA)
- Computational Linguistics (AREA)
- Health & Medical Sciences (AREA)
- Water Supply & Treatment (AREA)
- Public Health (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Life Sciences & Earth Sciences (AREA)
- Biodiversity & Conservation Biology (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Game Theory and Decision Science (AREA)
- General Factory Administration (AREA)
Abstract
Translated fromChinese
Description
Translated fromChinese技术领域technical field
本发明实施例涉及电网技术领域，具体涉及基建甲供物资设计清册与申报信息的比对方法和装置。The embodiments of the present invention relate to the technical field of power grids, and in particular to a method and device for comparing the design inventory of infrastructure supply materials and declaration information.
背景技术Background technique
基建甲供物资申报前，由设计部门设计制作甲供物资设计清册，提交至申报人员后，由申报人员按设计清册进行物资数据申报。由于设计清册常发生变更，基建甲供物资在企业资源计划(Enterprise Resource Planning，ERP)系统中申报完成后，需要将设计清册与ERP系统中的数据进行比对。Before the declaration of materials supplied by infrastructure A, the design department shall design and produce a design list of materials supplied by A, and submit it to the declarer, and the declarer shall declare the material data according to the design list. Since the design list is often changed, after the capital construction supply materials are declared in the Enterprise Resource Planning (ERP) system, the design list needs to be compared with the data in the ERP system.
当前，采用线下人工比对方式比对设计清册，检查申报的准确性。但由于工作人员责任心、业务水平参差不齐，常出现申报漏项、错项。At present, offline manual comparison is used to compare the design list to check the accuracy of the declaration. However, due to the varying sense of responsibility and professional level of the staff, there are often omissions and mistakes in the declaration.
发明内容SUMMARY OF THE INVENTION
本发明实施例的目的在于提供基建甲供物资设计清册与申报信息的比对方法和装置，用以解决现有线下人工比对方式效率低，出错率高的问题。The purpose of the embodiments of the present invention is to provide a method and device for comparing the design inventory of infrastructure supply materials and the declared information, so as to solve the problems of low efficiency and high error rate of the existing offline manual comparison method.
为实现上述目的，本发明实施例主要提供如下技术方案：To achieve the above purpose, the embodiments of the present invention mainly provide the following technical solutions:
第一方面，本发明实施例提供了一种基建甲供物资设计清册与申报信息的比对方法，包括：从目标设计清册中获取第一目标比对信息，所述第一目标比对信息包括M组信息，所述M组信息中每组信息均包括S个目标属性信息；从目标申报信息中获取第二目标比对信息，所述第二目标比对信息包括N组信息，所述N组信息中每组信息均包括S个目标属性信息；将所述M组信息与所述N组信息按组内目标属性信息的一致性数量生成多段匹配数据并进行显示，每组匹配数据具有相应的标记信息；其中，M、N和S均为大于0的正整数。In a first aspect, an embodiment of the present invention provides a method for comparing a design inventory of infrastructure supply materials and declaration information, including: obtaining first target comparison information from the target design inventory, where the first target comparison information includes M groups of information, each group of information in the M groups of information includes S pieces of target attribute information; second target comparison information is obtained from target declaration information, the second target comparison information includes N groups of information, the N Each group of information in the group information includes S pieces of target attribute information; the M groups of information and the N groups of information are generated according to the consistent quantity of the target attribute information in the group to generate and display multiple pieces of matching data, and each group of matching data has a corresponding tag information; where M, N and S are all positive integers greater than 0.
根据本发明的一个实施例，所述S个目标属性信息包括物料号属性信息、数量属性信息、技术规范标识属性信息、物料描述属性信息和单位属性信息。According to an embodiment of the present invention, the S pieces of target attribute information include material number attribute information, quantity attribute information, technical specification identification attribute information, material description attribute information and unit attribute information.
根据本发明的一个实施例，所述将所述M组信息与所述N组信息按组内目标属性信息的一致性数量生成多组匹配数据，包括：将所述M组信息和所述N组信息中选取组内五个属新信息全一致的信息生成第一段匹配信息，并对所述第一段匹配信息生成第一标记信息后进行显示；在所述M组信息和所述N组信息中去除具有所述第一标记信息的数据，将组内四个属新信息一致的信息生成第二段匹配信息，并对所述第二段匹配信息生成第二标记信息后进行显示；在所述M组信息和所述N组信息中去除具有所述第二标记信息的数据，将组内三个属新信息一致的信息生成第三段匹配信息，并对所述第三段匹配信息生成第三标记信息后进行显示；在所述M组信息和所述N组信息中去除具有所述第三标记信息的数据，将组内两个属新信息一致的信息生成第四段匹配信息，并对所述第四段匹配信息生成第四标记信息后进行显示；在所述M组信息和所述N组信息中去除具有所述第四标记信息的数据，将组内一个属新信息一致的信息生成第五段匹配信息，并对所述第五段匹配信息生成第五标记信息后进行显示；在所述M组信息和所述N组信息中去除具有所述第五标记信息的数据得到剩余数据并进行显示。According to an embodiment of the present invention, generating multiple sets of matching data from the M groups of information and the N groups of information according to the consistent quantity of target attribute information in the group includes: combining the M groups of information with the N groups of information. In the group information, select the information that is completely consistent with five new information in the group to generate the first segment of matching information, and generate the first mark information for the first segment of matching information and display it; in the M group information and the N Removing the data with the first marking information from the group information, generating a second piece of matching information from four pieces of information that are consistent with new information in the group, and generating the second marking information for the second piece of matching information and displaying it; Remove the data with the second label information from the M groups of information and the N groups of information, generate a third piece of matching information from the information that is consistent with the three new pieces of information in the group, and match the third piece of information The information is displayed after generating the third mark information; the data with the third mark information is removed from the M groups of information and the N groups of information, and the information that is consistent with the two new information in the group is generated to match the fourth paragraph information, and generate the fourth mark information for the fourth piece of matching information and display it; remove the data with the fourth mark information from the M groups of information and the N groups of information, and assign a new one in the group to a new one. The information with the same information generates the fifth piece of matching information, and generates the fifth mark information for the fifth piece of matching information and displays it; removes the fifth mark information from the M groups of information and the N groups of information The remaining data is obtained and displayed.
根据本发明的一个实施例，使用数据库提供的选取方式在述M组信息和所述N组信息中选取相应的数据。According to an embodiment of the present invention, corresponding data is selected from the M groups of information and the N groups of information using a selection method provided by a database.
第二方面，本发明实施例还提供一种基建甲供物资设计清册与申报信息的比对装置，包括：获取模块，用于从目标设计清册中获取第一目标比对信息，并从目标申报信息中获取第二目标比对信息，所述第一目标比对信息包括M组信息，所述M组信息中每组信息均包括S个目标属性信息，所述第二目标比对信息包括N组信息，所述N组信息中每组信息均包括S个目标属性信息，M、N和S均为大于0的正整数；显示模块；控制处理模块，用于将所述M组信息与所述N组信息按组内目标属性信息的一致性数量生成多段匹配数据并通过所述显示模块进行显示，其中，每组匹配数据具有相应的标记信息。In a second aspect, an embodiment of the present invention also provides a device for comparing the design inventory of infrastructure A supply materials and declaration information, including: an acquisition module for acquiring the first target comparison information from the target design inventory, and obtaining the first target comparison information from the target declaration Obtain second target comparison information from the information, the first target comparison information includes M groups of information, each group of information in the M groups of information includes S pieces of target attribute information, and the second target comparison information includes N group information, each group of information in the N groups of information includes S pieces of target attribute information, and M, N and S are all positive integers greater than 0; a display module; a control processing module, used for combining the M groups of information with all The N groups of information generate multiple pieces of matching data according to the consistent quantity of target attribute information in the group and display them through the display module, wherein each group of matching data has corresponding tag information.
根据本发明的一个实施例，所述S个目标属性信息包括物料号属性信息、数量属性信息、技术规范标识属性信息、物料描述属性信息和单位属性信息。According to an embodiment of the present invention, the S pieces of target attribute information include material number attribute information, quantity attribute information, technical specification identification attribute information, material description attribute information and unit attribute information.
根据本发明的一个实施例，所述控制处理模块用于将所述M组信息和所述N组信息中选取组内五个属新信息全一致的信息生成第一段匹配信息，并对所述第一段匹配信息生成第一标记信息后通过所述显示模块进行显示；所述控制处理模块还用于在所述M组信息和所述N组信息中去除具有所述第一标记信息的数据，将组内四个属新信息一致的信息生成第二段匹配信息，并对所述第二段匹配信息生成第二标记信息后通过所述显示模块进行显示；所述控制处理模块用于在所述M组信息和所述N组信息中去除具有所述第二标记信息的数据，将组内三个属新信息一致的信息生成第三段匹配信息，并对所述第三段匹配信息生成第三标记信息后通过所述显示模块进行显示；所述控制处理模块用于在所述M组信息和所述N组信息中去除具有所述第三标记信息的数据，将组内两个属新信息一致的信息生成第四段匹配信息，并对所述第四段匹配信息生成第四标记信息后通过所述显示模块进行显示；所述控制处理模块用于在所述M组信息和所述N组信息中去除具有所述第四标记信息的数据，将组内一个属新信息一致的信息生成第五段匹配信息，并对所述第五段匹配信息生成第五标记信息后通过所述显示模块进行显示；所述控制处理模块用于在所述M组信息和所述N组信息中去除具有所述第五标记信息的数据得到剩余数据并通过所述显示模块进行显示。According to an embodiment of the present invention, the control processing module is configured to generate the first piece of matching information by selecting the information in the M groups of information and the N groups of information that are consistent with five new information in the group, and to generate the first piece of matching information. After the first piece of matching information generates first mark information, it is displayed by the display module; the control processing module is further configured to remove the first mark information from the M groups of information and the N groups of information. data, generate the second piece of matching information from the information that is consistent with the four new information in the group, and generate the second mark information for the second piece of matching information and display it through the display module; the control processing module is used for Remove the data with the second label information from the M groups of information and the N groups of information, generate a third piece of matching information from the information that is consistent with the three new pieces of information in the group, and match the third piece of information After the information generates third mark information, it is displayed by the display module; the control processing module is used to remove the data with the third mark information in the M group information and the N group information, and display the two data in the group. A fourth piece of matching information is generated for each piece of information that is consistent with the new information, and a fourth piece of marking information is generated for the fourth piece of matching information, and then displayed by the display module; the control processing module is used to display the information in the M groups of information Removing the data with the fourth marking information from the N groups of information, generating a fifth segment of matching information from information that is consistent with one of the new information in the group, and generating the fifth marking information for the fifth segment of matching information. Display is performed by the display module; and the control processing module is configured to remove the data with the fifth marker information from the M groups of information and the N groups of information to obtain remaining data and display the remaining data by the display module.
根据本发明的一个实施例，所述控制处理模块用于使用数据库提供的选取方式在述M组信息和所述N组信息中选取相应的数据。According to an embodiment of the present invention, the control processing module is configured to select corresponding data from the M groups of information and the N groups of information by using a selection method provided by a database.
第三方面，本发明实施例还提供一种电子设备，包括：至少一个处理器和至少一个存储器；所述存储器用于存储一个或多个程序指令；所述处理器，用于运行一个或多个程序指令，用以执行如第一方面所述的基建甲供物资设计清册与申报信息的比对方法。In a third aspect, an embodiment of the present invention further provides an electronic device, including: at least one processor and at least one memory; the memory is used to store one or more program instructions; the processor is used to run one or more program instructions A program instruction is used to implement the method for comparing the design inventory of infrastructure A supply materials with the declared information as described in the first aspect.
第四方面，本发明实施例还提供一种计算机可读存储介质，包含一个或多个程序指令，所述一个或多个程序指令用于被执行如第一方面所述的基建甲供物资设计清册与申报信息的比对方法。In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, comprising one or more program instructions, and the one or more program instructions are used to execute the design of infrastructure supply materials according to the first aspect The method of comparing the inventory and declaration information.
本发明实施例提供的技术方案至少具有如下优点：The technical solutions provided by the embodiments of the present invention have at least the following advantages:
本发明实施例提供的基建甲供物资设计清册与申报信息的比对方法和装置，通过建立甲供物资设计清册与ERP申报数据的快速比对算法，优化循环步骤，提高比对效率，同时解决人工比对方式慢易出错等问题。The method and device for comparing the design list of infrastructure supply materials and the declaration information provided by the embodiment of the present invention, by establishing a rapid comparison algorithm between the design list of A supply materials and the ERP declaration data, optimize the cycle steps, improve the comparison efficiency, and solve the problem at the same time. Manual comparison is slow and error-prone.
附图说明Description of drawings
图1为本发明实施例的基建甲供物资设计清册与申报信息的比对方法的流程图。FIG. 1 is a flow chart of a method for comparing a design inventory of infrastructure first supply materials and declaration information according to an embodiment of the present invention.
图2为本发明实施例的基建甲供物资设计清册与申报信息的比对装置的结构框图。FIG. 2 is a structural block diagram of a device for comparing the design inventory and declaration information of infrastructure A supply materials according to an embodiment of the present invention.
具体实施方式Detailed ways
以下由特定的具体实施例说明本发明的实施方式，熟悉此技术的人士可由本说明书所揭露的内容轻易地了解本发明的其他优点及功效。The embodiments of the present invention are described below by specific embodiments, and those skilled in the art can easily understand other advantages and effects of the present invention from the contents disclosed in this specification.
以下描述中，为了说明而不是为了限定，提出了诸如特定系统结构、接口、技术之类的具体细节，以便透彻理解本发明。然而，本领域的技术人员应当清楚，在没有这些具体细节的其它实施例中也可以实现本发明。在其它情况中，省略对众所周知的系统、电路以及方法的详细说明，以免不必要的细节妨碍本发明的描述。In the following description, for purposes of explanation and not limitation, specific details are set forth, such as specific system structures, interfaces, techniques, etc., in order to provide a thorough understanding of the present invention. However, it will be apparent to those skilled in the art that the present invention may be practiced in other embodiments without these specific details. In other instances, detailed descriptions of well-known systems, circuits, and methods are omitted so as not to obscure the description of the present invention with unnecessary detail.
在本发明的描述中，需要理解的是，术语“第一”和“第二”仅用于描述目的，而不能理解为指示或暗示相对重要性。In the description of the present invention, it should be understood that the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance.
图1为本发明实施例的基建甲供物资设计清册与申报信息的比对方法的流程图。如图1所示，本发明实施例的基建甲供物资设计清册与申报信息的比对方法，包括：FIG. 1 is a flow chart of a method for comparing a design inventory of infrastructure first supply materials and declaration information according to an embodiment of the present invention. As shown in Figure 1, the comparison method of the design inventory of the infrastructure A supply material and the declaration information according to the embodiment of the present invention includes:
S1：从目标设计清册中获取第一目标比对信息。其中，第一目标比对信息包括M组信息，M组信息中每组信息均包括S个目标属性信息。其中，M和S均为大于0的正整数。S1: Obtain the first target comparison information from the target design inventory. The first target comparison information includes M groups of information, and each group of information in the M groups of information includes S pieces of target attribute information. Wherein, M and S are both positive integers greater than 0.
具体地，从基建甲供物资的设计清册中获取第一目标比对信息。在本发明的一个示例中，第一目标比对信息包括设计清册中的M组信息。在这M组信息中的每组信息均包括物料号属性信息、数量属性信息、技术规范标识属性信息、物料描述属性信息和单位属性信息。Specifically, the first target comparison information is obtained from the design inventory of infrastructure A supply materials. In an example of the present invention, the first target comparison information includes M groups of information in the design inventory. Each group of information in the M groups of information includes material number attribute information, quantity attribute information, technical specification identification attribute information, material description attribute information and unit attribute information.
S2：从目标申报信息中获取第二目标比对信息。其中，第二目标比对信息包括N组信息，N组信息中每组信息均包括S个目标属性信息。其中，N和为大于0的正整数。S2: Obtain the second target comparison information from the target declaration information. The second target comparison information includes N groups of information, and each group of information in the N groups of information includes S pieces of target attribute information. where N and N are positive integers greater than 0.
具体地，从ERP系统获取申报信息中的第二目标比对信息。在本发明的一个示例中，第二目标比对信息包括设计清册中的M组信息。在这M组信息中的每组信息均包括物料号属性信息、数量属性信息、技术规范标识属性信息、物料描述属性信息和单位属性信息。Specifically, the second target comparison information in the declaration information is obtained from the ERP system. In an example of the present invention, the second target comparison information includes M groups of information in the design inventory. Each group of information in the M groups of information includes material number attribute information, quantity attribute information, technical specification identification attribute information, material description attribute information and unit attribute information.
S3：将M组信息与N组信息按组内目标属性信息的一致性数量生成多段匹配数据并进行显示，每组匹配数据具有相应的标记信息。S3: Generate and display multiple pieces of matching data according to the consistent quantity of the target attribute information in the M groups of information and N groups of information, and each group of matching data has corresponding tag information.
在本发明的一个实施例中，步骤S3具体包括：In an embodiment of the present invention, step S3 specifically includes:
S3-1：将M组信息和N组信息中选取组内五个属新信息全一致的信息生成第一段匹配信息，并对第一段匹配信息生成第一标记信息后进行显示。S3-1: Select the information in the M group information and the N group information that are completely consistent with the five new information in the group to generate the first piece of matching information, and generate the first mark information for the first piece of matching information and then display it.
具体地，使用SQL左连接方式(left join)选取五个属性全一致的数据条目，并进行一致性数据标记后进行显示，记录标记为5后进行显示，此时显示的数据五个属性全一致。Specifically, use the SQL left join method to select data items with all the same attributes, and mark the consistent data for display. The records are marked with 5 and then display. At this time, the five attributes of the displayed data are all consistent. .
S3-2：在M组信息和N组信息中去除具有第一标记信息的数据，将组内四个属新信息一致的信息生成第二段匹配信息，并对第二段匹配信息生成第二标记信息后进行显示。S3-2: Remove the data with the first marker information from the M group information and the N group information, generate the second piece of matching information from the information that is consistent with the four new pieces of information in the group, and generate a second piece of matching information for the second piece of matching information. Displayed after marking the information.
具体地，去除标记为5的数据，使用SQL左连接方式选取物料号、数量、技术规范ID、单位属性全一致的数据条目，并进行一致性数据标记，记录标记为4后进行显示，此时显示的数据物料描述存在不一致。Specifically, remove the data marked as 5, use SQL left join method to select the data entry with the same material number, quantity, technical specification ID, and unit attribute, and mark the consistent data, and display the record after the mark is 4, at this time There is an inconsistency in the displayed data item description.
S3-3：在M组信息和N组信息中去除具有第二标记信息的数据，将组内三个属新信息一致的信息生成第三段匹配信息，并对第三段匹配信息生成第三标记信息后进行显示。S3-3: remove the data with the second label information from the M group information and the N group information, generate the third piece of matching information from the information that is consistent with the three new pieces of information in the group, and generate a third piece of matching information for the third piece of matching information Displayed after marking the information.
具体地，继续去除标记为4的数据，使用SQL左连接方式选取物料号、数量、技术规范ID属性全一致的数据条目，并进行一致性数据标记，记录标记为3后进行显示，此时显示的数据单位和物料描述存在不一致。Specifically, continue to remove the data marked as 4, use the SQL left join method to select the data entries with the same material number, quantity, and technical specification ID attributes, and mark the consistent data, and display the record after the mark is 3. At this time, the display There is an inconsistency between the data unit and the material description.
S3-4：在M组信息和N组信息中去除具有第三标记信息的数据，将组内两个属新信息一致的信息生成第四段匹配信息，并对第四段匹配信息生成第四标记信息后进行显示。S3-4: remove the data with the third marker information from the M group information and the N group information, generate the fourth piece of matching information from the information that is consistent with the two new pieces of information in the group, and generate the fourth piece of matching information for the fourth piece of matching information. Displayed after marking the information.
具体地，继续去除标记为3的数据，使用SQL左连接方式选取物料号、数量属性全一致的数据条目，并进行一致性数据标记，记录标记为2后进行显示,此时显示的数据单位、物料描述和技术规范ID存在不一致。Specifically, continue to remove the data marked as 3, use the SQL left join method to select the data entry with the same material number and quantity attribute, and mark the consistent data. After the record is marked as 2, it will be displayed. At this time, the displayed data unit, There is an inconsistency between the material description and the technical specification ID.
S3-5：在M组信息和N组信息中去除具有第四标记信息的数据，将组内一个属新信息一致的信息生成第五段匹配信息，并对第五段匹配信息生成第五标记信息后进行显示。S3-5: remove the data with the fourth mark information from the M group information and the N group information, generate a fifth piece of matching information from a piece of information that is consistent with new information in the group, and generate a fifth mark for the fifth piece of matching information After the information is displayed.
具体地，继续去除标记为1的数据，使用SQL左连接方式选取物料号属性全一致的数据条目，并进行一致性数据标记，记录标记为1后进行显示，此时显示的数据单位、物料描述、技术规范ID和数量存在不一致。Specifically, continue to remove the data marked as 1, use the SQL left join method to select the data entry with the same material number attribute, and mark the consistent data. After the record is marked as 1, it will be displayed. At this time, the displayed data unit and material description , technical specification ID and quantity are inconsistent.
S3-6：在M组信息和N组信息中去除具有第五标记信息的数据得到剩余数据并进行显示。此时显示的数据全部数据不一致。S3-6: Remove the data with the fifth marker information from the M groups of information and the N groups of information to obtain remaining data and display them. All data displayed at this time are inconsistent.
本发明实施例提供的基建甲供物资设计清册与申报信息的比对方法，通过建立甲供物资设计清册与ERP申报数据的快速比对算法，优化循环步骤，提高比对效率，同时解决人工比对方式慢易出错等问题。The method for comparing the design list of infrastructure supply materials and the declaration information provided by the embodiment of the present invention, by establishing a rapid comparison algorithm between the design list of A supply materials and the ERP declaration data, optimizes the cycle steps, improves the comparison efficiency, and solves the problem of manual comparison. Problems such as slow and error-prone methods.
图2为本发明实施例的基建甲供物资设计清册与申报信息的比对装置的结构框图。如图2所示，本发明实施例的基建甲供物资设计清册与申报信息的比对装置，包括：获取模块100、显示模块200和控制处理模块300。FIG. 2 is a structural block diagram of a device for comparing the design inventory and declaration information of infrastructure A supply materials according to an embodiment of the present invention. As shown in FIG. 2 , the device for comparing the design inventory of the first supply materials for infrastructure construction and the declaration information according to the embodiment of the present invention includes an acquisition module 100 , a display module 200 and a control processing module 300 .
其中，获取模块100用于从目标设计清册中获取第一目标比对信息，并从目标申报信息中获取第二目标比对信息。第一目标比对信息包括M组信息，M组信息中每组信息均包括S个目标属性信息，N组信息中每组信息均包括S个目标属性信息，M、N和S均为大于0的正整数。控制处理模块300用于将M组信息与N组信息按组内目标属性信息的一致性数量生成多段匹配数据并通过显示模块200进行显示，其中，每组匹配数据具有相应的标记信息。The obtaining module 100 is configured to obtain the first target comparison information from the target design list, and obtain the second target comparison information from the target declaration information. The first target comparison information includes M groups of information, each of the M groups of information includes S pieces of target attribute information, and each of the N groups of information includes S pieces of target attribute information, and M, N, and S are all greater than 0. positive integer of . The control processing module 300 is configured to generate multiple pieces of matching data according to the consistency of the target attribute information in the M groups of information and N groups of information, and display them through the display module 200 , wherein each group of matching data has corresponding tag information.
在本发明的一个实施例中，S个目标属性信息包括物料号属性信息、数量属性信息、技术规范标识属性信息、物料描述属性信息和单位属性信息。In an embodiment of the present invention, the S pieces of target attribute information include material number attribute information, quantity attribute information, technical specification identification attribute information, material description attribute information, and unit attribute information.
在本发明的一个实施例中，控制处理模块300用于将M组信息和N组信息中选取组内五个属新信息全一致的信息生成第一段匹配信息，并对第一段匹配信息生成第一标记信息后通过显示模块200进行显示；控制处理模块300还用于在M组信息和N组信息中去除具有第一标记信息的数据，将组内四个属新信息一致的信息生成第二段匹配信息，并对第二段匹配信息生成第二标记信息后通过显示模块200进行显示。控制处理模块300用于在M组信息和N组信息中去除具有第二标记信息的数据，将组内三个属新信息一致的信息生成第三段匹配信息，并对第三段匹配信息生成第三标记信息后通过显示模块200进行显示。控制处理模块300用于在M组信息和N组信息中去除具有第三标记信息的数据，将组内两个属新信息一致的信息生成第四段匹配信息，并对第四段匹配信息生成第四标记信息后通过显示模块200进行显示。控制处理模块300用于在M组信息和N组信息中去除具有第四标记信息的数据，将组内一个属新信息一致的信息生成第五段匹配信息，并对第五段匹配信息生成第五标记信息后通过显示模块200进行显示。控制处理模块300用于在M组信息和N组信息中去除具有第五标记信息的数据得到剩余数据并通过显示模块200进行显示。In an embodiment of the present invention, the control processing module 300 is configured to generate the first piece of matching information by selecting the information in the M groups of information and the N groups of information that are identical to five new pieces of information in the group, and for the first piece of matching information After the first marking information is generated, it is displayed by the display module 200; the control processing module 300 is also used to remove the data with the first marking information in the M group information and the N group information, and generate the consistent information of the four new information in the group The second piece of matching information, and the second mark information is generated for the second piece of matching information and displayed by the display module 200 . The control processing module 300 is used to remove the data with the second label information in the M group information and the N group information, generate the third segment of matching information from the information that is consistent with the three new information in the group, and generate the third segment of the matching information. The third mark information is then displayed by the display module 200 . The control processing module 300 is used to remove the data with the third mark information in the M group information and the N group information, generate the fourth piece of matching information from the information that is consistent with the two new information in the group, and generate the fourth piece of matching information. The fourth mark information is then displayed by the display module 200 . The control processing module 300 is used to remove the data with the fourth mark information in the M group information and the N group information, generate the fifth piece of matching information from a piece of information that is consistent with the new information in the group, and generate the fifth piece of matching information for the fifth piece of matching information. After the five marked information, the display module 200 displays it. The control processing module 300 is configured to remove the data with the fifth tag information from the M group information and the N group information to obtain the remaining data and display the remaining data through the display module 200 .
在本发明的一个实施例中，控制处理模块300用于使用数据库提供的选取方式在述M组信息和N组信息中选取相应的数据。In an embodiment of the present invention, the control processing module 300 is configured to select corresponding data from the M groups of information and the N groups of information by using the selection method provided by the database.
需要说明的是，本发明实施例的基建甲供物资设计清册与申报信息的比对装置的具体实施方式与本发明实施例的基建甲供物资设计清册与申报信息的比对方法的具体实施方式类似，具体参见基建甲供物资设计清册与申报信息的比对方法部分的描述，为了减少冗余，不做赘述。It should be noted that the specific implementation of the device for comparing the design inventory of infrastructure A supply materials and the declaration information according to the embodiment of the present invention is the specific implementation of the method for comparing the design inventory of infrastructure A supply materials and declaration information according to the embodiment of the present invention. Similarly, please refer to the description in the section on the comparison method between the design inventory of infrastructure supply materials and the declaration information for details. In order to reduce redundancy, it will not be repeated.
另外，本发明实施例的基建甲供物资设计清册与申报信息的比对装置的其它构成以及作用对于本领域的技术人员而言都是已知的，为了减少冗余，不做赘述。In addition, other components and functions of the device for comparing the design inventory of infrastructure A supply materials and the declaration information according to the embodiment of the present invention are known to those skilled in the art, and are not described in detail in order to reduce redundancy.
本发明实施例还提供一种电子设备，包括：至少一个处理器和至少一个存储器；所述存储器用于存储一个或多个程序指令；所述处理器，用于运行一个或多个程序指令，用以执行如第一方面所述的基建甲供物资设计清册与申报信息的比对方法。An embodiment of the present invention further provides an electronic device, comprising: at least one processor and at least one memory; the memory is used to store one or more program instructions; the processor is used to execute one or more program instructions, It is used to perform the comparison method between the design inventory of infrastructure A supply materials and the declared information as described in the first aspect.
本发明所公开的实施例提供一种计算机可读存储介质，所述计算机可读存储介质中存储有计算机程序指令，当所述计算机程序指令在计算机上运行时，使得计算机执行上述的基建甲供物资设计清册与申报信息的比对方法。The embodiments disclosed in the present invention provide a computer-readable storage medium, in which computer program instructions are stored, and when the computer program instructions are executed on a computer, the computer is made to execute the above-mentioned infrastructure supply The comparison method between the material design inventory and the declaration information.
在本发明实施例中，处理器可以是一种集成电路芯片，具有信号的处理能力。处理器可以是通用处理器、数字信号处理器(Digital Signal Processor，简称DSP)、专用集成电路(Application Specific Integrated Circuit，简称ASIC)、现场可编程门阵列(FieldProgrammable Gate Array，简称FPGA)或者其他可编程逻辑器件、分立门或者晶体管逻辑器件、分立硬件组件。In this embodiment of the present invention, the processor may be an integrated circuit chip, which has signal processing capability. The processor may be a general-purpose processor, a digital signal processor (DSP for short), an application specific integrated circuit (ASIC for short), a field programmable gate array (FPGA for short), or other possible Programming logic devices, discrete gate or transistor logic devices, discrete hardware components.
可以实现或者执行本发明实施例中的公开的各方法、步骤及逻辑框图。通用处理器可以是微处理器或者该处理器也可以是任何常规的处理器等。结合本发明实施例所公开的方法的步骤可以直接体现为硬件译码处理器执行完成，或者用译码处理器中的硬件及软件模块组合执行完成。软件模块可以位于随机存储器，闪存、只读存储器，可编程只读存储器或者电可擦写可编程存储器、寄存器等本领域成熟的存储介质中。处理器读取存储介质中的信息，结合其硬件完成上述方法的步骤。Various methods, steps, and logical block diagrams disclosed in the embodiments of the present invention can be implemented or executed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of the method disclosed in conjunction with the embodiments of the present invention may be directly embodied as executed by a hardware decoding processor, or executed by a combination of hardware and software modules in the decoding processor. The software modules may be located in random access memory, flash memory, read-only memory, programmable read-only memory or electrically erasable programmable memory, registers and other storage media mature in the art. The processor reads the information in the storage medium, and completes the steps of the above method in combination with its hardware.
存储介质可以是存储器，例如可以是易失性存储器或非易失性存储器，或可包括易失性和非易失性存储器两者。The storage medium may be memory, eg, may be volatile memory or nonvolatile memory, or may include both volatile and nonvolatile memory.
其中，非易失性存储器可以是只读存储器(Read-Only Memory，简称ROM)、可编程只读存储器(Programmable ROM，简称PROM)、可擦除可编程只读存储器(Erasable PROM，简称EPROM)、电可擦除可编程只读存储器(Electrically EPROM，简称EEPROM)或闪存。Among them, the non-volatile memory may be a read-only memory (Read-Only Memory, referred to as ROM), a programmable read-only memory (Programmable ROM, referred to as PROM), an erasable programmable read-only memory (Erasable PROM, referred to as EPROM) , Electrically Erasable Programmable Read-Only Memory (Electrically EPROM, EEPROM for short) or flash memory.
易失性存储器可以是随机存取存储器(Random Access Memory，简称RAM)，其用作外部高速缓存。通过示例性但不是限制性说明，许多形式的RAM可用，例如静态随机存取存储器(Static RAM，简称SRAM)、动态随机存取存储器(Dynamic RAM，简称DRAM)、同步动态随机存取存储器(Synchronous DRAM，简称SDRAM)、双倍数据速率同步动态随机存取存储器(Double Data Rate SDRAM，简称DDRSDRAM)、增强型同步动态随机存取存储器(EnhancedSDRAM，简称ESDRAM)、同步连接动态随机存取存储器(Synch Link DRAM，简称SLDRAM)和直接内存总线随机存取存储器(Direct Rambus RAM，简称DRRAM)。The volatile memory may be a random access memory (Random Access Memory, RAM for short), which is used as an external cache. By way of example and not limitation, many forms of RAM are available, such as Static Random Access Memory (SRAM), Dynamic RAM (DRAM), Synchronous DRAM, referred to as SDRAM), double data rate synchronous dynamic random access memory (Double Data Rate SDRAM, referred to as DDRSDRAM), enhanced synchronous dynamic random access memory (Enhanced SDRAM, referred to as ESDRAM), synchronous connection dynamic random access memory (Synch Link DRAM, referred to as SLDRAM) and direct memory bus random access memory (Direct Rambus RAM, referred to as DRRAM).
本发明实施例描述的存储介质旨在包括但不限于这些和任意其它适合类型的存储器。The storage medium described in the embodiments of the present invention is intended to include, but not limited to, these and any other suitable types of memory.
本领域技术人员应该可以意识到，在上述一个或多个示例中，本发明所描述的功能可以用硬件与软件组合来实现。当应用软件时，可以将相应功能存储在计算机可读介质中或者作为计算机可读介质上的一个或多个指令或代码进行传输。计算机可读介质包括计算机存储介质和通信介质，其中通信介质包括便于从一个地方向另一个地方传送计算机程序的任何介质。存储介质可以是通用或专用计算机能够存取的任何可用介质。Those skilled in the art should appreciate that, in one or more of the above examples, the functions described in the present invention may be implemented by a combination of hardware and software. When the software is applied, the corresponding functions may be stored in or transmitted over as one or more instructions or code on a computer-readable medium. Computer-readable media includes both computer storage media and communication media including any medium that facilitates transfer of a computer program from one place to another. A storage medium can be any available medium that can be accessed by a general purpose or special purpose computer.
以上所述的具体实施方式，对本发明的目的、技术方案和有益效果进行了进一步详细说明，所应理解的是，以上所述仅为本发明的具体实施方式而已，并不用于限定本发明的保护范围，凡在本发明的技术方案的基础之上，所做的任何修改、等同替换、改进等，均应包括在本发明的保护范围之内。The specific embodiments described above further describe the objectives, technical solutions and beneficial effects of the present invention in detail. It should be understood that the above descriptions are only specific embodiments of the present invention, and are not intended to limit the scope of the present invention. Any modification, equivalent replacement, improvement, etc. made on the basis of the technical solution of the present invention shall be included within the protection scope of the present invention.
Claims (10)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010256510.0ACN111639100A (en) | 2020-04-02 | 2020-04-02 | Method and device for comparing capital construction and capital supply material design inventory and declaration information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010256510.0ACN111639100A (en) | 2020-04-02 | 2020-04-02 | Method and device for comparing capital construction and capital supply material design inventory and declaration information |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111639100Atrue CN111639100A (en) | 2020-09-08 |
Family
ID=72329496
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010256510.0APendingCN111639100A (en) | 2020-04-02 | 2020-04-02 | Method and device for comparing capital construction and capital supply material design inventory and declaration information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111639100A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114881545A (en)* | 2022-07-07 | 2022-08-09 | 国网浙江省电力有限公司 | Automatic material matching method and device based on cooperative interconnection |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105339881A (en)* | 2013-03-14 | 2016-02-17 | 维克斯网有限公司 | Apparatus, system and method for building a website by using a data list |
| US20170168794A1 (en)* | 2015-12-15 | 2017-06-15 | International Business Machines Corporation | Enhanceable Cross-Domain Rules Engine For Unmatched Registry Entries Filtering |
| CN107657527A (en)* | 2017-09-29 | 2018-02-02 | 平安科技（深圳）有限公司 | Loan product matching process, device and computer-readable recording medium |
| CN109947797A (en)* | 2017-07-31 | 2019-06-28 | 华为技术有限公司 | A data checking device and method |
| CN110264269A (en)* | 2019-06-20 | 2019-09-20 | 卓尔智联(武汉)研究院有限公司 | Advertisement position recommended method, device, electronic equipment and storage medium |
| CN110276665A (en)* | 2019-06-25 | 2019-09-24 | 南方电网能源发展研究院有限责任公司 | Electricity power engineering purchase of goods and materials demand declaration method based on big data |
- 2020
- 2020-04-02CNCN202010256510.0Apatent/CN111639100A/enactivePending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105339881A (en)* | 2013-03-14 | 2016-02-17 | 维克斯网有限公司 | Apparatus, system and method for building a website by using a data list |
| US20170168794A1 (en)* | 2015-12-15 | 2017-06-15 | International Business Machines Corporation | Enhanceable Cross-Domain Rules Engine For Unmatched Registry Entries Filtering |
| CN109947797A (en)* | 2017-07-31 | 2019-06-28 | 华为技术有限公司 | A data checking device and method |
| CN107657527A (en)* | 2017-09-29 | 2018-02-02 | 平安科技（深圳）有限公司 | Loan product matching process, device and computer-readable recording medium |
| CN110264269A (en)* | 2019-06-20 | 2019-09-20 | 卓尔智联(武汉)研究院有限公司 | Advertisement position recommended method, device, electronic equipment and storage medium |
| CN110276665A (en)* | 2019-06-25 | 2019-09-24 | 南方电网能源发展研究院有限责任公司 | Electricity power engineering purchase of goods and materials demand declaration method based on big data |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114881545A (en)* | 2022-07-07 | 2022-08-09 | 国网浙江省电力有限公司 | Automatic material matching method and device based on cooperative interconnection |
| CN114881545B (en)* | 2022-07-07 | 2022-09-23 | 国网浙江省电力有限公司 | Material automatic matching method and device based on collaborative interconnection |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111813963A (en) | Knowledge graph construction method and device, electronic equipment and storage medium | |
| WO2020098296A1 (en) | Image retrieval method and device | |
| CN108829746B (en) | Main data management system and device based on memory database | |
| CN116266183A (en) | Data analysis method, device, equipment and computer storage medium | |
| CN110765750B (en) | Report data input method and terminal equipment | |
| CN109800445A (en) | The processing method and system of the visualization auxiliary assessment of bids are realized based on BIM technology | |
| CN111061475A (en) | Software code generation method and device, computer equipment and storage medium | |
| CN113254455A (en) | Dynamic configuration method and device of database, computer equipment and storage medium | |
| CN107992492A (en) | A kind of storage method of data block, read method, its device and block chain | |
| CN110795475A (en) | Report generation method, device, computer equipment and storage medium | |
| CN116431660B (en) | Data processing method, device, system, electronic device and storage medium | |
| CN111639100A (en) | Method and device for comparing capital construction and capital supply material design inventory and declaration information | |
| CN111444368A (en) | Method and device for constructing user portrait, computer equipment and storage medium | |
| CN114757767B (en) | Method and device for identifying associated enterprises, electronic equipment and storage medium | |
| DE102018214011A1 (en) | Techniques for dynamic access to databases in multiple storage formats | |
| CN117743299A (en) | Database migration methods, apparatus, equipment, media and products | |
| CN111008198A (en) | Business data acquisition method, device, storage medium, and electronic device | |
| CN116795933A (en) | Method and device for generating product design man-hour, storage medium and program product | |
| CN114612077A (en) | Contract review method, apparatus and computer equipment | |
| CN108121733A (en) | The querying method and device of a kind of data | |
| CN114490646A (en) | Metadata-based data lineage analysis method and system | |
| CN114385630A (en) | Blood relationship sorting method, device, equipment, storage medium and program product | |
| CN109034982B (en) | Method and device for accelerating processing of order information in ten-million-level order form | |
| CN113360505A (en) | Data processing method and device based on time sequence data, electronic equipment and readable storage medium | |
| CN111309821A (en) | Graph database-based task scheduling method and device and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | Application publication date:20200908 | |
| RJ01 | Rejection of invention patent application after publication |