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 information Download PDF

Info

Publication number
CN111639100A
CN111639100A CN202010256510.0A CN202010256510A CN111639100A CN 111639100 A CN111639100 A CN 111639100A CN 202010256510 A CN202010256510 A CN 202010256510A CN 111639100 A CN111639100 A CN 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
Application number
CN202010256510.0A
Other languages
Chinese (zh)
Inventor
林海强
陈许议
尹琛
陈宙平
廖文江
江能明
吴慧莹
刘烁
李剑谓
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shanghai Zhougu Electrical Technology Co ltd
Great Power Science and Technology Co of State Grid Information and Telecommunication Co Ltd
Original Assignee
Shanghai Zhougu Electrical Technology Co ltd
Great Power Science and Technology Co of State Grid Information and Telecommunication Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Shanghai Zhougu Electrical Technology Co ltd, Great Power Science and Technology Co of State Grid Information and Telecommunication Co Ltd filed Critical Shanghai Zhougu Electrical Technology Co ltd
Priority to CN202010256510.0A priority Critical patent/CN111639100A/en
Publication of CN111639100A publication Critical patent/CN111639100A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR 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; CALCULATING OR 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; CALCULATING OR 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; CALCULATING OR 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; CALCULATING OR 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—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/06—Electricity, gas or water supply

Abstract

The embodiment of the invention discloses a method and a device for comparing capital construction supply material design inventory and declaration information, wherein the method comprises the following steps: acquiring first target comparison information from a target design inventory, wherein the first target comparison information comprises M groups of information, and each group of information in the M groups of information comprises S pieces of target attribute information; acquiring second target comparison information from target declaration information, wherein the second target comparison information comprises N groups of information, and each group of information in the N groups of information comprises S target attribute information; generating and displaying multiple sections of matching data of the M groups of information and the N groups of information according to the consistency quantity of target attribute information in the groups, wherein each group of matching data has corresponding mark information; wherein M, N and S are both positive integers greater than 0. The invention can solve the problems of low efficiency and high error rate of the existing offline manual comparison mode.

Description

Method and device for comparing capital construction and capital supply material design inventory and declaration information
Technical Field
The embodiment of the invention relates to the technical field of power grids, in particular to a method and a device for comparing capital construction supplies design inventory and declaration information.
Background
Before the capital construction first supply material declaration, a first supply material design inventory is designed and manufactured by a design department, and after the first supply material design inventory is submitted to a declaration personnel, the declaration personnel declares material data according to the design inventory. Since the design inventory is frequently changed, after the capital construction and supply of materials are declared in an Enterprise Resource Planning (ERP) system, the design inventory needs to be compared with data in the ERP system.
At present, the design inventory is compared in an offline manual comparison mode, and the accuracy of declaration is checked. However, due to different responsibility and service level of the workers, the reporting of missed items and wrong items often occurs.
Disclosure of Invention
The embodiment of the invention aims to provide a method and a device for comparing capital construction and capital supply material design inventory and declaration information, which are used for solving the problems of low efficiency and high error rate of the existing offline manual comparison mode.
In order to achieve the above object, the embodiments of the present invention mainly provide the following technical solutions:
in a first aspect, an embodiment of the present invention provides a method for comparing a capital construction supply material design inventory with declaration information, including: acquiring first target comparison information from a target design inventory, wherein the first target comparison information comprises M groups of information, and each group of information in the M groups of information comprises S pieces of target attribute information; acquiring second target comparison information from target declaration information, wherein the second target comparison information comprises N groups of information, and each group of information in the N groups of information comprises S target attribute information; generating and displaying multiple sections of matching data of the M groups of information and the N groups of information according to the consistency quantity of target attribute information in the groups, wherein each group of matching data has corresponding mark information; wherein M, N and S are both positive integers greater than 0.
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 identifier attribute information, material description attribute information, and unit attribute information.
According to an embodiment of the present invention, the generating multiple sets of matching data by the M sets of information and the N sets of information according to the consistency number of the target attribute information in the sets includes: generating a first section of matching information from information in which five new information in the selected group are completely consistent in the M group of information and the N group of information, and displaying the first section of matching information after generating first mark information; removing data with the first mark information from the M groups of information and the N groups of information, generating second section matching information from four information in the group with the same new information, and displaying the second section matching information after generating second mark information; removing data with the second mark information from the M groups of information and the N groups of information, generating a third section of matching information from three information in the group which is consistent with the new information, generating third mark information for the third section of matching information, and displaying the third mark information; removing data with the third mark information from the M groups of information and the N groups of information, generating fourth matching information from two information in the groups with the same new information, and displaying the fourth matching information after generating the fourth mark information; removing data with the fourth marking information from the M groups of information and the N groups of information, generating a fifth section of matching information from one information in the group which belongs to the same new information, and displaying the fifth section of matching information after generating the fifth marking information; and removing the data with the fifth mark information from the M groups of information and the N groups of information to obtain residual data and displaying the residual data.
According to one embodiment of the invention, the corresponding data is selected from the M groups of information and the N groups of information by using a selection mode provided by a database.
In a second aspect, an embodiment of the present invention further provides a device for comparing a capital construction supplies design inventory with declaration information, including: the system comprises an acquisition module, a comparison module and a comparison module, wherein the acquisition module is used for acquiring first target comparison information from a target design inventory and acquiring second target comparison information from target declaration information, the first target comparison information comprises M groups of information, each group of information in the M groups of information comprises S target attribute information, the second target comparison information comprises N groups of information, each group of information in the N groups of information comprises S target attribute information, and M, N and S are positive integers larger than 0; a display module; and the control processing module is used for generating a plurality of sections of matching data from the M groups of information and the N groups of information according to the consistency quantity of target attribute information in the groups and displaying the matching data through the display module, wherein each group of matching data has corresponding mark information.
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 identifier attribute information, material description attribute information, and unit attribute information.
According to an embodiment of the present invention, the control processing module is configured to generate a first piece of matching information from information in which five pieces of new information in the selected group of the M group information and the N group information are completely consistent, generate a first piece of tag information for the first piece of matching information, and display the first piece of matching information through the display module; the control processing module is further configured to remove data with the first tag information from the M groups of information and the N groups of information, generate second section matching information from four information in a group with the same information, generate second tag information for the second section matching information, and display the second tag information through the display module; the control processing module is used for removing data with the second mark information from the M groups of information and the N groups of information, generating a third section of matching information from the information with the same information in the groups, generating third mark information from the third section of matching information, and displaying the third mark information through the display module; the control processing module is used for removing data with the third mark information from the M group of information and the N group of information, generating fourth section of matching information from two information in the group with the same new information, generating fourth mark information from the fourth section of matching information, and displaying the fourth mark information through the display module; the control processing module is used for removing data with the fourth mark information from the M groups of information and the N groups of information, generating a fifth section of matching information from one information in the group with the same new information, generating a fifth mark information for the fifth section of matching information, and displaying the fifth mark information through the display module; the control processing module is used for removing the data with the fifth mark information from the M groups of information and the N groups of information to obtain residual data and displaying the residual data through the display module.
According to an embodiment of the present invention, the control processing module is configured to select corresponding data from the M sets of information and the N sets of information using a selection manner 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 to store one or more program instructions; the processor is configured to run one or more program instructions to execute the method for comparing the capital construction and supplies design inventory with the declaration information according to the first aspect.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, which contains one or more program instructions, where the one or more program instructions are used to execute the method for comparing the capital infrastructure supply material design inventory with the declaration information according to the first aspect.
The technical scheme provided by the embodiment of the invention at least has the following advantages:
according to the method and the device for comparing the capital supply goods and materials design inventory and the declaration information, which are provided by the embodiment of the invention, the circulation steps are optimized by establishing a rapid comparison algorithm of the capital supply goods and materials design inventory and the ERP declaration data, the comparison efficiency is improved, and meanwhile, the problems that a manual comparison mode is slow and easy to make mistakes are solved.
Drawings
Fig. 1 is a flowchart of a method for comparing a capital construction supplies design inventory and declaration information according to an embodiment of the present invention.
Fig. 2 is a block diagram of a device for comparing capital construction supplies design inventory and declaration information according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention is provided for illustrative purposes, and other advantages and effects of the present invention will become apparent to those skilled in the art from the present disclosure.
In the following description, for purposes of explanation and not limitation, specific details are set forth such as particular system structures, interfaces, techniques, etc. in order to provide a thorough understanding of the present invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced in other embodiments that depart from 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 is to be understood that the terms "first" and "second" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.
Fig. 1 is a flowchart of a method for comparing a capital construction supplies design inventory and declaration information according to an embodiment of the present invention. As shown in fig. 1, the method for comparing the capital construction supplies design inventory and the declaration information according to the embodiment of the present invention includes:
s1: and acquiring first target comparison information from the target design inventory. The first target comparison information comprises M groups of information, and each group of information in the M groups of information comprises S pieces of target attribute information. Wherein M and S are both positive integers greater than 0.
Specifically, first target comparison information is obtained from a design inventory of capital construction supplies. In one example of the present invention, the first target comparison information includes M sets of information in the design inventory. Each group of information in the M groups of information comprises material number attribute information, quantity attribute information, technical specification identification attribute information, material description attribute information and unit attribute information.
S2: and acquiring second target comparison information from the target declaration information. The second target comparison information comprises N groups of information, and each group of information in the N groups of information comprises S target attribute information. Wherein the sum of N is a positive integer greater than 0.
Specifically, second target comparison information in the declaration information is obtained from the ERP system. In one example of the present invention, the second target comparison information includes M sets of information in the design inventory. Each group of information in the M groups of information comprises material number attribute information, quantity attribute information, technical specification identification attribute information, material description attribute information and unit attribute information.
S3: and generating and displaying multiple sections of matching data of the M groups of information and the N groups of information according to the consistency quantity of the target attribute information in the groups, wherein each group of matching data has corresponding mark information.
In an embodiment of the present invention, step S3 specifically includes:
s3-1: and generating a first section of matching information from the information with the full consistency of the five new information in the selected group from the M group of information and the N group of information, and displaying the first section of matching information after generating first mark information.
Specifically, an SQL left connection mode (left join) is used for selecting five data items with all consistent attributes, the consistent data is marked and then displayed, the record mark is 5 and then displayed, and at the moment, the five displayed data attributes are all consistent.
S3-2: and removing data with the first mark information from the M groups of information and the N groups of information, generating second section of matching information from the four information with the same new information in the groups, and displaying the second section of matching information after generating second mark information.
Specifically, data marked as 5 is removed, data items with the same object material number, technical specification ID and unit attribute are selected in an SQL left connection mode, consistent data marking is carried out, the data items are displayed after the record mark is marked as 4, and the displayed data material description is inconsistent at the moment.
S3-3: and removing data with second mark information from the M groups of information and the N groups of information, generating a third section of matching information from the three information in the group with the same new information, and displaying the third section of matching information after generating third mark information.
Specifically, the data marked as 4 is continuously removed, data items with the same object material number, number and technical specification ID attribute in an SQL left connection mode are selected, consistent data marking is carried out, the data items are displayed after the record mark is marked as 3, and the displayed data unit is inconsistent with the object material description at this time.
S3-4: and removing data with third mark information from the M groups of information and the N groups of information, generating fourth matching information from the two information with the same new information in the groups, and displaying the fourth mark information generated from the fourth matching information.
Specifically, the data marked as 3 is continuously removed, the data items with the completely consistent object material numbers and quantity attributes are selected in an SQL left connection mode, consistent data marking is carried out, the data items are displayed after the record mark is marked as 2, and at this time, the displayed data units, the object description and the technical specification ID are inconsistent.
S3-5: and removing data with fourth label information from the M groups of information and the N groups of information, generating a fifth section of matching information from one information with the same new information in the group, and displaying the fifth section of matching information after generating fifth label information.
Specifically, data marked as 1 is continuously removed, data items with the completely consistent material number attributes are selected in an SQL left connection mode, consistent data marking is carried out, the data items are displayed after the data items are marked as 1, and at the moment, the displayed data units, material descriptions, technical specification IDs and the quantity are inconsistent.
S3-6: and removing the data with the fifth mark information from the M groups of information and the N groups of information to obtain residual data and displaying the residual data. All data displayed at this time are inconsistent.
According to the comparison method of the capital construction supplies design inventory and the declaration information, provided by the embodiment of the invention, the loop steps are optimized by establishing a rapid comparison algorithm of the capital construction supplies design inventory and the ERP declaration data, the comparison efficiency is improved, and the problems that a manual comparison mode is slow and easy to make mistakes are solved.
Fig. 2 is a block diagram of a device for comparing capital construction supplies design inventory and declaration information according to an embodiment of the present invention. As shown in fig. 2, the device for comparing the capital construction supplies design inventory 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.
The obtaining module 100 is configured to obtain first target comparison information from a target design inventory, and obtain second target comparison information from target declaration information. The first target comparison information comprises M groups of information, each group of information in the M groups of information comprises S target attribute information, each group of information in the N groups of information comprises S target attribute information, and M, N and S are positive integers larger than 0. The control processing module 300 is configured to generate a plurality of pieces of matching data from the M groups of information and the N groups of information according to the consistency number of the target attribute information in the group, and display the matching data through the display module 200, where each group of matching data has corresponding label information.
In an embodiment of the present invention, the S pieces of target attribute information include material number attribute information, quantity attribute information, technical specification identifier attribute information, material description attribute information, and unit attribute information.
In an embodiment of the present invention, the control processing module 300 is configured to generate a first piece of matching information from information in which five pieces of new information in the selected group of the M group information and the N group information are completely consistent, and display the first piece of matching information through the display module 200 after generating first tag information; the control processing module 300 is further configured to remove data with the first tag information from the M groups of information and the N groups of information, generate second-segment matching information from four information in the group that are consistent with the new information, generate second tag information for the second-segment matching information, and display the second tag information through the display module 200. The control processing module 300 is configured to remove data with second tag information from the M groups of information and the N groups of information, generate a third segment of matching information from three pieces of information in the group that are consistent with the new information, generate a third tag information for the third segment of matching information, and display the third tag information through the display module 200. The control processing module 300 is configured to remove data with third tag information from the M groups of information and the N groups of information, generate a fourth segment of matching information from two information in the group that belong to the same new information, generate a fourth tag information for the fourth segment of matching information, and display the fourth tag information through the display module 200. The control processing module 300 is configured to remove data with fourth tag information from the M groups of information and the N groups of information, generate a fifth piece of matching information from one information in the group that is consistent with the new information, generate a fifth tag information for the fifth piece of matching information, and display the fifth tag information through the display module 200. 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 remaining data, and display the remaining data through the display module 200.
In an embodiment of the present invention, the control processing module 300 is configured to select corresponding data from the M sets of information and the N sets of information using a selection manner provided by the database.
It should be noted that, a specific implementation manner of the comparison device for the capital-based supplies and supplies design inventory and the declaration information in the embodiment of the present invention is similar to a specific implementation manner of the comparison method for the capital-based supplies and supplies design inventory and the declaration information in the embodiment of the present invention, and specific reference is made to the description of the comparison method part for the capital-based supplies and supplies design inventory and the declaration information, and no further description is made for reducing redundancy.
In addition, other configurations and functions of the device for comparing the capital construction and supplies design inventory and the declaration information in the embodiment of the invention are known to those skilled in the art, and are not described in detail for reducing redundancy.
An embodiment of the present invention further provides an electronic device, including: at least one processor and at least one memory; the memory is to store one or more program instructions; the processor is configured to run one or more program instructions to execute the method for comparing the capital construction and supplies design inventory with the declaration information according to the first aspect.
The embodiment of the invention discloses a computer readable storage medium, wherein computer program instructions are stored in the computer readable storage medium, and when the computer program instructions are run on a computer, the computer is enabled to execute the method for comparing the capital construction and supplies material design inventory with the declaration information.
In an embodiment of the invention, the processor may be an integrated circuit chip having signal processing capability. The Processor may be a general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other programmable logic device, discrete Gate or transistor logic device, discrete hardware component.
The various methods, steps and logic blocks disclosed in the embodiments of the present invention may be implemented or performed. 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 connection with the embodiments of the present invention may be directly implemented by a hardware decoding processor, or implemented by a combination of hardware and software modules in the decoding processor. The software module may be located in ram, flash memory, rom, prom, or eprom, registers, etc. storage media as is well known in the art. The processor reads the information in the storage medium and completes the steps of the method in combination with the hardware.
The storage medium may be a memory, for example, which may be volatile memory or nonvolatile memory, or which may include both volatile and nonvolatile memory.
The nonvolatile Memory may be a Read-Only Memory (ROM), a Programmable ROM (PROM), an Erasable PROM (EPROM), an Electrically Erasable PROM (EEPROM), or a flash Memory.
The volatile Memory may be a Random Access Memory (RAM) which serves as an external cache. By way of example and not limitation, many forms of RAM are available, such as Static random access memory (Static RAM, SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (ddr Data Rate SDRAM), enhanced SDRAM (enhanced SDRAM, ESDRAM), synclink DRAM (SLDRAM), and Direct Rambus RAM (DRRAM).
The storage media described in connection with the embodiments of the invention are intended to comprise, without being limited to, these and any other suitable types of memory.
Those skilled in the art will appreciate that the functionality described in the present invention may be implemented in a combination of hardware and software in one or more of the examples described above. When software is applied, the corresponding functionality may be stored on 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 media may be any available media that can be accessed by a general purpose or special purpose computer.
The above-mentioned embodiments, objects, technical solutions and advantages of the present invention are further described in detail, it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made on the basis of the technical solutions of the present invention should be included in the scope of the present invention.

Claims (10)

1. A method for comparing a capital construction and capital supply material design inventory with declaration information is characterized by comprising the following steps:
acquiring first target comparison information from a target design inventory, wherein the first target comparison information comprises M groups of information, and each group of information in the M groups of information comprises S pieces of target attribute information;
acquiring second target comparison information from target declaration information, wherein the second target comparison information comprises N groups of information, and each group of information in the N groups of information comprises S target attribute information;
generating and displaying multiple sections of matching data of the M groups of information and the N groups of information according to the consistency quantity of target attribute information in the groups, wherein each group of matching data has corresponding mark information;
wherein M, N and S are both positive integers greater than 0.
2. The method of claim 1, wherein the S target attribute information includes material number attribute information, quantity attribute information, technical specification identification attribute information, material description attribute information, and unit attribute information.
3. The method of claim 2, wherein the step of generating a plurality of sets of matching data from the M sets of information and the N sets of information according to the consistency of the target attribute information in the sets comprises:
generating a first section of matching information from information in which five new information in the selected group are completely consistent in the M group of information and the N group of information, and displaying the first section of matching information after generating first mark information;
removing data with the first mark information from the M groups of information and the N groups of information, generating second section matching information from four information in the group with the same new information, and displaying the second section matching information after generating second mark information;
removing data with the second mark information from the M groups of information and the N groups of information, generating a third section of matching information from three information in the group which is consistent with the new information, generating third mark information for the third section of matching information, and displaying the third mark information;
removing data with the third mark information from the M groups of information and the N groups of information, generating fourth matching information from two information in the groups with the same new information, and displaying the fourth matching information after generating the fourth mark information;
removing data with the fourth marking information from the M groups of information and the N groups of information, generating a fifth section of matching information from one information in the group which belongs to the same new information, and displaying the fifth section of matching information after generating the fifth marking information;
and removing the data with the fifth mark information from the M groups of information and the N groups of information to obtain residual data and displaying the residual data.
4. The method of claim 3, wherein the M sets of information and the N sets of information are selected according to a selection method provided by a database.
5. A device for comparing a capital construction supply material design inventory with declaration information is characterized by comprising:
the system comprises an acquisition module, a comparison module and a comparison module, wherein the acquisition module is used for acquiring first target comparison information from a target design inventory and acquiring second target comparison information from target declaration information, the first target comparison information comprises M groups of information, each group of information in the M groups of information comprises S target attribute information, the second target comparison information comprises N groups of information, each group of information in the N groups of information comprises S target attribute information, and M, N and S are positive integers larger than 0;
a display module;
and the control processing module is used for generating a plurality of sections of matching data from the M groups of information and the N groups of information according to the consistency quantity of target attribute information in the groups and displaying the matching data through the display module, wherein each group of matching data has corresponding mark information.
6. The apparatus of claim 5, wherein the S target attribute information includes material number attribute information, quantity attribute information, technical specification identification attribute information, material description attribute information, and unit attribute information.
7. The device for comparing the capital construction and supplies design inventory with the declaration information according to claim 6, wherein the control processing module is configured to generate a first piece of matching information from information in which five new information in the selected group of the M group of information and the N group of information are completely consistent, generate a first piece of marking information for the first piece of matching information, and display the first piece of matching information through the display module;
the control processing module is further configured to remove data with the first tag information from the M groups of information and the N groups of information, generate second section matching information from four information in a group with the same information, generate second tag information for the second section matching information, and display the second tag information through the display module;
the control processing module is used for removing data with the second mark information from the M groups of information and the N groups of information, generating a third section of matching information from the information with the same information in the groups, generating third mark information from the third section of matching information, and displaying the third mark information through the display module;
the control processing module is used for removing data with the third mark information from the M group of information and the N group of information, generating fourth section of matching information from two information in the group with the same new information, generating fourth mark information from the fourth section of matching information, and displaying the fourth mark information through the display module;
the control processing module is used for removing data with the fourth mark information from the M groups of information and the N groups of information, generating a fifth section of matching information from one information in the group with the same new information, generating a fifth mark information for the fifth section of matching information, and displaying the fifth mark information through the display module;
the control processing module is used for removing the data with the fifth mark information from the M groups of information and the N groups of information to obtain residual data and displaying the residual data through the display module.
8. The apparatus of claim 7, wherein the control processing module is configured to select corresponding data from the M sets of information and the N sets of information using a selection method provided by a database.
9. An electronic device, characterized in that the electronic device comprises: at least one processor and at least one memory;
the memory is to store one or more program instructions;
the processor is configured to execute one or more program instructions to perform the method for comparing the capital infrastructure supplies design inventory with the declaration information according to any one of claims 1 to 4.
10. A computer readable storage medium containing one or more program instructions for performing the method of comparing a design inventory of capital infrastructure supplies with reporting information as claimed in any one of claims 1 to 4.
CN202010256510.0A 2020-04-02 2020-04-02 Method and device for comparing capital construction and capital supply material design inventory and declaration information Pending CN111639100A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010256510.0A CN111639100A (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.0A CN111639100A (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
CN111639100A true CN111639100A (en) 2020-09-08

Family

ID=72329496

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010256510.0A Pending CN111639100A (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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105339881A (en) * 2013-03-14 2016-02-17 维克斯网有限公司 Device, system, and method of website building by utilizing data lists
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 kind of data detecting 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

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105339881A (en) * 2013-03-14 2016-02-17 维克斯网有限公司 Device, system, and method of website building by utilizing data lists
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 kind of data detecting 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)

* Cited by examiner, † Cited by third party
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 国网浙江省电力有限公司 Automatic material matching method and device based on cooperative interconnection

Similar Documents

Publication Publication Date Title
CN111078910A (en) Medical image storage method, device, system, equipment and storage medium
CN103995879A (en) Data query method, device and system based on OLAP system
CN111159167B (en) Labeling quality detection device and method
CN111639100A (en) Method and device for comparing capital construction and capital supply material design inventory and declaration information
CN110765750A (en) Report data entry method and terminal equipment
CN112433753A (en) Interface document generation method, device, equipment and medium based on parameter information
CN109871593B (en) Information inheritance method and device based on BIM platform and storage device
CN111695330A (en) Method and device for generating table, electronic equipment and computer-readable storage medium
CN109542962B (en) Data processing method, data processing device, computer equipment and storage medium
CN113791594B (en) Configuration establishing method, system, equipment and medium of distributed control system
CN113259154B (en) Method and device for informing middle station data verification, computer equipment and storage medium
CN116304251A (en) Label processing method, device, computer equipment and storage medium
CN112579571B (en) Monitoring data configuration, data monitoring method, device, equipment and storage medium
CN114462859A (en) Workflow processing method and device, computer equipment and storage medium
CN111796907A (en) Data checking method and device based on checking script, electronic equipment and medium
CN112613894A (en) Method and device for associating source code and product
CN111078574A (en) Method and device for generating influence analysis report
CN111913993B (en) Table data generation method, apparatus, electronic device and computer readable storage medium
CN110750817B (en) Connecting piece placement method, adjacent relation determination method, device, equipment and medium
CN111309623B (en) Coordinate class data classification test method and device
CN113222084B (en) Block chain-based date labeling and querying method and device
CN111507566B (en) Method, device, computer equipment and storage medium for generating article production list
CN114579179A (en) Version synchronization method and device, computer equipment and storage medium
CN110209666B (en) data storage method and terminal equipment
CN116303669A (en) Method and device for acquiring data

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