CN116933761A - Automatic material number data comparison method, system, storage medium and electronic equipment - Google Patents
Automatic material number data comparison method, system, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN116933761A CN116933761A CN202310930546.6A CN202310930546A CN116933761A CN 116933761 A CN116933761 A CN 116933761A CN 202310930546 A CN202310930546 A CN 202310930546A CN 116933761 A CN116933761 A CN 116933761A
- Authority
- CN
- China
- Prior art keywords
- material number
- number data
- data
- comparison result
- comparison
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/194—Calculation of difference between files
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/197—Version control
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/253—Grammatical analysis; Style critique
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application provides a method, a system, a storage medium and electronic equipment for automatically comparing material number data; the automatic material number data comparison method comprises the following steps: after the material number data of all the materials are obtained, the corresponding first comparison result, second comparison result and third comparison result can be obtained respectively by comparing the preamble material number data and the current version material number data of the current material, comparing the material number data of different materials and comparing the material number data of different versions of the same material, and then all the compared first comparison result, second comparison result and third comparison result are output and displayed. The automatic comparison method of the material number data can obtain accurate change details and specific differences through automatic comparison of the program, reduces the complicated work of manual comparison, and saves time and labor cost; if the material number data is abnormal, the production flow is affected, and the method can reduce the influence probability to zero.
Description
Technical Field
The present application relates to the field of data management technologies, and in particular, to a method and system for automatically comparing material number data, a storage medium, and an electronic device.
Background
With the development of the PCB industry, there is an increasing demand for automation, and the operation mode is developed towards automation. When an engineering MI auditor audits MI data, conventionally, a problem point is marked by manual first audit, the problem point is returned to an MI producer for modification, and MI audit is carried out for the second time, and in this way, the project MI auditor can be subjected to final manuscript finishing after multiple times of modification.
In the process, because of continuous modification, each MI auditing needs to be re-checked by manual visual inspection to manufacture work orders and flow pages, the process is tedious, and the pain is always the pain of engineering MI auditors. And the manual visual inspection is easy to make mistakes, and production abnormality can be caused as long as MI is manufactured or audited and any lack of omission occurs in the modification process.
Disclosure of Invention
The application provides a method, a system, a storage medium and electronic equipment for automatically comparing material number data.
The application provides an automatic comparison method of material number data, which comprises the following steps:
s100: and acquiring material number data of all materials.
S200: comparing the preamble version material number data of the current material with the current version material number data to obtain a first comparison result, wherein the first comparison result comprises newly added, deleted and/or modified material number data of the current version material number data compared with the preamble version material number data.
S300: and comparing the material number data of different materials to obtain a second comparison result, wherein the second comparison result comprises material number data similar to the current version of material number data.
S400: and comparing the material number data of different versions of the same material to obtain a third comparison result, wherein the third comparison result comprises material number data which is different from the material number data of the current version.
S500: and (5) circularly executing the steps S200-S400, outputting all the first comparison result, the second comparison result and the third comparison result, and displaying.
According to the automatic material number data comparison method, manual visual inspection is not needed, accurate change details and specific differences can be obtained through automatic comparison of the program, the tedious work of manual comparison is reduced, and time and labor cost are saved; if the material number data is abnormal, the production flow is affected, and the method can reduce the influence probability to zero.
The step S100 includes:
initial data for all materials is derived in response to the data derivation instructions.
Initial data of all materials are exported at one time, workload of manually exporting the materials one by one is reduced, and data export efficiency is improved.
And converting the initial data into material number data in a preset node format through xsl grammar and storing the material number data.
The initial data is converted into the material number data in the preset node format through xsl grammar, so that the requirement of a specific data structure or database table can be met, and the subsequent storage and use are convenient; and the converted material number data is stored, so that the integrity and disposability of the data can be ensured, and the subsequent data access and management are convenient.
And importing the material number data into a database so as to acquire the material number data of all materials from the database.
By storing the material number data of all materials in the database, the problem of inconsistent data caused by multiple data storage can be avoided, and the possibility of human input errors is reduced; and the material number data can be obtained from the database, so that the material number data of all materials can be obtained quickly, and the data access efficiency is improved.
Each material number data is provided with a key value and a value, and the key value at least comprises a material number name, a material number data table name, a sub-key value and a material number field name.
By setting the key value with the structure, the management and the processing of the material number data become more convenient and efficient, the flexibility of data acquisition and the advantage of quick retrieval are improved, and the data management efficiency and the accuracy are improved.
The step S200 includes:
and comparing the key value and the value corresponding to the preamble version material number data of the current material and the current version material number data piece by piece.
And acquiring the modification state of the current version material number data according to the comparison result.
The comparison result comprises the key values and the value values which are the same, the key values are different, the key values are the same and the value values are different.
By comparing the key value with the value, the change condition of each material number data can be ensured to be accurately judged; the subsequent processing and analysis can be flexibly carried out by comparing the key value with the value in the result; by accurately judging the modification state of the material number data, the error rate of data processing can be reduced, and the accuracy of the data is improved; and by comparing the data piece by piece, the data change can be quickly captured, and the workload and time cost of subsequent processing are reduced.
The obtaining the modification state of the current version material number data according to the comparison result comprises the following steps:
and when the key value and the value are the same, judging that the current version of material number data is not modified.
When the key values are different, judging whether the key values of the preamble version material number data are stored in the current version material number data, and when the key values are not stored, judging that the current version material number data corresponding to the current key values are deleting data, and marking the deleting data for the first time.
And judging whether the key value of the current version material number data exists in the preamble version material number data, judging that the current version material number data corresponding to the current key value is newly added data when the key value does not exist, and marking the newly added data for the second time.
When the key values are the same and the value values are different, the current version material number data corresponding to the current key value is judged to be modification data, and third marking is carried out on the modification data.
By comparing and judging the key value and the value, the method can provide fine modification state marks and change detail tracking, is beneficial to subsequent data analysis, processing and screening, and improves the operability and management efficiency of data.
The step S300 includes:
and constructing a query condition based on the key value, and acquiring the key value with the same material number name, material number data table name and material number field name by adopting the query condition.
And comparing the sub key values of the current version material number data and the historical version material number data.
And when the sub key values are the same, judging that the current version material number data is the same data as the historical version material number data, and marking the fourth data for the fourth.
And when the sub key values are different, judging that the historical version material number data is similar data of the current version material number data, and fifth marking the similar data.
By constructing the design of the query condition and the comparison sub key value based on the key value, the same data and similar data can be identified more accurately, and the reliability and accuracy of data comparison and management are improved.
The step S400 includes:
and comparing the current version material number data and the historical version material number data of the current material, identifying difference data, and performing sixth marking on the difference data.
By identifying the difference data and marking the difference data in the sixth way, the existence and the importance of the difference data can be clearly determined, and the accuracy and the efficiency of data management are improved.
The application also provides an automatic material number data comparison system, which comprises:
the acquisition module is used for: and the method is used for acquiring the material number data of all materials.
Through the acquisition module, the material number data of all materials are acquired, and the coverage of the whole data is ensured. Can ensure that the material number data of any material can not be missed in the comparison process.
A first comparison module: and the first comparison result is obtained by comparing the preamble version material number data of the current material with the current version material number data.
And a second comparison module: and the material number data are used for comparing different materials to obtain a second comparison result.
And a third comparison module: and the method is used for comparing the material number data of different versions of the same material so as to obtain a third comparison result.
The first comparison module, the second comparison module and the third comparison module realize the comparison of different layers and dimensions; different comparison results can be obtained through different comparison modules, and various requirements are met.
And an output module: and the display unit is used for outputting all the first comparison result, the second comparison result and the third comparison result and displaying the results.
Through the display function of the output module, all the first comparison results, the second comparison results and the third comparison results are output, so that a user can comprehensively know the comparison condition of the material number data, and convenience is brought to the user to carry out further analysis and decision.
The automatic material number data comparison system is characterized in that the whole system has high-efficiency, comprehensive and accurate material number data comparison and display capability through the comparison modules which are focused on different comparison tasks.
The application also provides a storage medium which is one of computer readable storage media, wherein the computer readable storage medium stores computer instructions, and the computer instructions are used for enabling a computer to execute the automatic material number data comparison method.
The application also provides electronic equipment, which comprises a processor and a memory, wherein at least one instruction, at least one section of program, a code set or an instruction set is stored in the memory, and the at least one instruction, the at least one section of program, the code set or the instruction set is loaded and executed by the processor so as to realize the automatic material number data comparison method.
Compared with the prior art, the application has the beneficial effects that:
after the material number data of all the materials are acquired, the corresponding first comparison result, second comparison result and third comparison result can be respectively acquired by comparing the preamble material number data and the current version material number data of the current material, comparing the material number data of different materials and comparing the material number data of different versions of the same material, and further, all the compared first comparison result, second comparison result and third comparison result are output and displayed. According to the automatic material number data comparison method, manual visual inspection is not needed, accurate change details and specific differences can be obtained through automatic comparison of the program, the tedious work of manual comparison is reduced, and time and labor cost are saved; if the material number data is abnormal, the production flow is affected, and the method can reduce the influence probability to zero. The technical problems that the manual visual inspection process is tedious and easy to make mistakes in the prior art are solved.
Drawings
FIG. 1 is a flow chart of the automatic comparison method of material number data according to the present application.
FIG. 2 is a system frame diagram of the automatic material number data comparison method shown in FIG. 1.
Detailed Description
The application provides an automatic material number data comparison method, an automatic material number data comparison system, a storage medium and electronic equipment, and aims to solve the technical problems that in the prior art, the manual visual inspection process is complex and errors are easy to occur.
The application relates to a method, a system, a storage medium and an electronic device for automatically comparing material number data, which are described in further detail below with reference to specific embodiments and drawings.
Embodiment one:
referring to fig. 1, the present application provides a method for automatically comparing material number data, comprising the following steps:
s100: and acquiring material number data of all materials.
The step S100 includes:
initial data for all materials is derived in response to the data derivation instructions.
The initial data may differ in different embodiments, such as picture data and/or text data of drilling information, layering information or impedance information.
In one possible embodiment, xml format data is automatically derived from MI engineering software, inplan, which is currently commonly used in the industry for PCB engineering MI, each material number data can be stored in an xml format for export, and the picture data and the text data can be output at the same time by using an API instruction ExportForCrystal of the Inplan.
After the initial data is exported, the initial data is converted into material number data in a preset node format through xsl grammar and stored.
In a possible implementation manner, an xsl extraction language is written, and the xsl grammar is utilized to refine the initial data in the xml format into the material data in the preset node format and store the material data.
Generated by xsl syntax is, for example, the bin number data in the form of the node:
< RECORD tc_aaf00= "HN519A1-del" tc_aaf01= "primary drilling" tc_aaf02= "tc_aaf03=" T03 "tc_aaf04=" 0.25 "tc_aaf05=" Y "tc_aaf06=" 1601 "tc_aaf07=" +0.05/-0.24 "tc_aaf36=" 0.24 "tc_aaf37=" 0.05 "tc_aaf38=" 0.24 "tc_aaf08=" Via "; tc_aaf 09=" 0.24 "tc_aaf 12=" 10050 "tc_aaf 20=" 1"tc_aaf 56=" drl $part $1 "tc_aaf_inplatrtype=" inplantpype "tc_aaf_inplanrpc=" inplanrpc "tc_aaf_inplanruser=" inplanruser "tc_aaf_inplanrusate=" tcjaaf_inplanrtime= "inplanrtime"/>
After the material number data are stored, the material number data are imported into a database, so that the material number data of all materials are obtained from the database.
In a possible implementation manner, the database is an ERP database, and the material number data is stored in an xml format in the ERP database; and capturing material number data in an xml format through an API program and inserting the material number data into the ERP database.
Each material number data is provided with a key value and a value, and the key value at least comprises a material number name, a material number data table name, a sub-key value and a material number field name.
After the material number data is obtained, step S200 may be executed.
S200: comparing the preamble version material number data of the current material with the current version material number data to obtain a first comparison result, wherein the first comparison result comprises newly added, deleted and/or modified material number data of the current version material number data compared with the preamble version material number data.
The step S200 includes:
and comparing the key value and the value corresponding to the preamble version material number data of the current material and the current version material number data piece by piece.
Acquiring the modification state of the current version material number data according to the comparison result; the comparison result comprises the key values and the value values which are the same, the key values are different, the key values are the same and the value values are different.
And when the key value and the value are the same, judging that the current version of material number data is not modified.
When the key values are different, judging whether the key values of the preamble version material number data are stored in the current version material number data, and when the key values are not stored, judging that the current version material number data corresponding to the current key values are deleting data, and marking the deleting data for the first time.
And judging whether the key value of the current version material number data exists in the preamble version material number data, judging that the current version material number data corresponding to the current key value is newly added data when the key value does not exist, and marking the newly added data for the second time.
When the key values are the same and the value values are different, the current version material number data corresponding to the current key value is judged to be modification data, and third marking is carried out on the modification data.
In one possible embodiment, the following current version and preamble version material data are assumed:
current version bin number data-bin number 1: key1-Value1, key2-Value2, key3-Value3.
Preamble version material number data-material number 1: key1-Value1, key2-OldValue2, key4-Value4.
And according to the requirements, comparing the key value and the value corresponding to the preamble version material number data of the current material and the current version material number data one by one.
For material number 1, its key value and value are compared one by one.
key1 and Value1 are both present and identical in the current version material number data and the preamble version material number data, and thus can be determined as not modified.
There is no key4 in the current version of the material number data, but there is key4 in the preamble version of the material number data, so we determine key4 as deleted data and make the first mark.
The current version of the material number data has key3, but the preamble version of the material number data has no key3, so we judge the key3 as the newly added data and perform the second marking.
The Value of key2 exists in both the current version material number data and the preamble version material number data, but the Value is different, so that key2 can be determined as modified data, and a third marking can be performed.
According to the comparison, the processed current version material number data are as follows:
current version bin number data-bin number 1: key1-Value1, key2-Value2 (third label), key3-Value3 (second label).
Preamble version material number data-material number 1: key1-Value1, key2-OldValue2 (third label), key4-Value4 (first label).
In this embodiment, the current version material number data and the preamble version material number data are compared and marked according to the logic to identify deleted data, newly added data, and modified data. It should be noted that those skilled in the art may modify and adapt to specific needs and data structures in practical operation.
The first mark, the second mark and the third mark mean different colors, for example, red marks are performed on deleted data, yellow marks are performed on newly added data, and green marks are performed on modified data; the setting of the mark color here may be set according to the actual application, and is not limited thereto.
After the first comparison result is obtained, step S300 may be performed.
S300: and comparing the material number data of different materials to obtain a second comparison result, wherein the second comparison result comprises material number data similar to the current version of material number data.
The step S300 includes:
and constructing a query condition based on the key value, and acquiring the key value with the same material number name, material number data table name and material number field name by adopting the query condition.
And comparing the sub key values of the current version material number data and the historical version material number data.
And when the sub key values are the same, judging that the current version material number data is the same data as the historical version material number data, and marking the fourth data for the fourth.
And when the sub key values are different, judging that the historical version material number data is similar data of the current version material number data, and fifth marking the similar data.
The fourth mark and the fifth mark have the same meaning as in the above step S200, and only different colors need to be selected for marking.
It should be noted that, whatever material is refined into a preset node format by xsl grammar, its data format is the same, and the data table in the ERP database is also the same.
In one possible implementation, it is assumed that the following current version number data and historical version number data exist:
current version bin number data-bin number 1: stock number name ABC123, stock number data table name table 1, child key value 123, stock number field name field a.
Current version bin number data-bin number 2: material number name XYZ789, material number data table name table 2, child key value 456, material number field name field B.
Historical version bin number data-bin number 1: stock number name ABC123, stock number data table name table 1, child key value 123, stock number field name field a.
Historical version bin number data-bin number 2: stock number name DEF456, stock number data table 3, child key value 789, stock number field name field C.
According to the requirements, firstly, constructing inquiry conditions, namely material numbers with the same material number names, material number data table names and material number field names; in this embodiment, the material number 1 satisfies this condition.
Next, we compare the sub-key values of the current version bin number data and the historical version bin number data.
For bin number 1, its child key value is 123. In the historical version bin number data, there is also bin number 1 with a child key value of 123. Therefore, we determine that bin number 1 of the current version of bin number data is the same data as the historical version of bin number data and mark it fourth.
For bin number 2, its child key value is 456. In the historical version material number data, no material number with a sub key value of 456 exists. Therefore, we determine bin number 2 of the historical version of bin number data as similar data to the current version of bin number data and fifth tag it.
According to the above description, the processed data are as follows:
current version bin number data-bin number 1: the material number name ABC123, the material number data table name table 1, the child key value 123, the material number field name field a, and the label is the fourth label.
Current version bin number data-bin number 2: material number name XYZ789, material number data table name table 2, child key value 456, material number field name field B.
Historical version bin number data-bin number 1: stock number name ABC123, stock number data table name table 1, child key value 123, stock number field name field a.
Historical version bin number data-bin number 2: stock number name DEF456, stock number data table 3, child key value 789, stock number field name field C, labeled fifth label.
In this embodiment, the current version number data and the historical version number data are compared and marked according to the logic to identify the same data and similar data. It should be noted that those skilled in the art may modify and adapt to specific needs and data structures in practical operation.
After the second comparison result is obtained, step S400 may be performed.
S400: and comparing the material number data of different versions of the same material to obtain a third comparison result, wherein the third comparison result comprises material number data which is different from the material number data of the current version.
The step S400 includes:
and comparing the current version material number data and the historical version material number data of the current material, identifying difference data, and performing sixth marking on the difference data.
Wherein, the difference data refers to new data, deleted data and modified data.
The sixth mark has a meaning different from the first mark, the second mark, the third mark, and the fifth mark, and represents three colors different from the above description; for example, the new data is marked blue, the deleted data is marked gray, and the modified data is marked purple.
The specific implementation of step S400 is the same as step S200.
After the comparison of the material number data of the current material is performed, step S500 may be performed.
S500: and (5) circularly executing the steps S200-S400, outputting all the first comparison result, the second comparison result and the third comparison result, and displaying.
After the material number data of all the materials are compared, outputting corresponding first comparison results, second comparison results and third comparison results; wherein, each comparison result is displayed through an excel document.
In this embodiment, the material number data of a material is displayed in an excel document, where the excel document includes all material number data, and the material number data with modification and difference are marked with corresponding colors; and the detection personnel can delete and modify the corresponding data according to the marking condition so as to screen and obtain the key material number data.
Embodiment two:
referring to fig. 2, the present application further provides an automatic comparison system for material data, the system includes:
the acquisition module is used for: and the method is used for acquiring the material number data of all materials.
The initial data may differ in different embodiments, such as picture data and/or text data of drilling information, layering information or impedance information.
The material number data is stored in an xml format, and the picture data and the text data can be output at the same time by using an API instruction ExportForCrystal of the Inplan.
A first comparison module: and the first comparison result is obtained by comparing the preamble version material number data of the current material with the current version material number data.
The first comparison module can acquire the new data, the deleted data, the modified data and the marks corresponding to the data.
And a second comparison module: and the material number data are used for comparing different materials to obtain a second comparison result.
Similar data, identical data and corresponding marks of the data can be obtained through the second comparison module.
And a third comparison module: and the method is used for comparing the material number data of different versions of the same material so as to obtain a third comparison result.
The third comparison module can acquire difference data, wherein the difference data also comprises new data, deleted data and modified data, and when the marking mode of all the difference data is different from that of the first comparison module.
And an output module: and the display unit is used for outputting all the first comparison result, the second comparison result and the third comparison result and displaying the results.
The output module outputs all the marked material number data and displays the marked material number data through an excel document, so that a person skilled in the art can update the marked material number data correspondingly on the basis of the excel document.
Embodiment III:
the application also provides a storage medium which is one of computer readable storage media, wherein the computer readable storage medium stores computer instructions, and the computer instructions are used for enabling a computer to execute the automatic material number data comparison method.
Embodiment four:
the application also provides electronic equipment, which comprises a processor and a memory, wherein at least one instruction, at least one section of program, a code set or an instruction set is stored in the memory, and the at least one instruction, the at least one section of program, the code set or the instruction set is loaded and executed by the processor so as to realize the automatic material number data comparison method.
In this embodiment, the memory and the processor are connected to each other through a bus; the processor may be one or more CPUs, and in the case that the processor is one CPU, the CPU may be a single-core CPU or a multi-core CPU, and the processor is configured to control each functional module of the electronic device and process signals.
The Memory includes, but is not limited to, RAM (Random Access Memory ), ROM (Read-Only Memory), EPROM (Erasable Programmable Read-Only Memory ), CD-ROM (Compact Disc Read-Only Memory, read-Only optical disk), and the Memory is used to store an instruction, at least one program, a code set, or an instruction set, such as a program for implementing the material number data auto-compare method.
In summary, the application provides a method, a system, a storage medium and electronic equipment for automatically comparing material number data; by comparing the preamble version material number data and the current version material number data of the current material, comparing the material number data of different materials and comparing the material number data of different versions of the same material, a corresponding first comparison result, a second comparison result and a third comparison result can be respectively obtained, and then all the compared first comparison result, second comparison result and third comparison result are output and displayed. According to the automatic material number data comparison method, manual visual inspection is not needed, accurate change details and specific differences can be obtained through automatic comparison of the program, the tedious work of manual comparison is reduced, and time and labor cost are saved; if the material number data is abnormal, the production flow is affected, and the method can reduce the influence probability to zero.
Although the illustrative embodiments have been described herein with reference to the accompanying drawings, it is to be understood that the above illustrative embodiments are merely exemplary and are not intended to limit the scope of the present application thereto. Various changes and modifications may be made therein by one of ordinary skill in the art without departing from the scope and spirit of the application. All such changes and modifications are intended to be included within the scope of the present application as set forth in the appended claims.
Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
In the several embodiments provided by the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described device embodiments are merely illustrative, e.g., the division of the elements is merely a logical functional division, and there may be additional divisions when actually implemented, e.g., multiple elements or components may be combined or integrated into another device, or some features may be omitted or not performed.
Various component embodiments of the application may be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. Those skilled in the art will appreciate that some or all of the functions of some of the modules according to embodiments of the present application may be implemented in practice using a microprocessor or Digital Signal Processor (DSP). The present application can also be implemented as an apparatus program (e.g., a computer program and a computer program product) for performing a portion or all of the methods described herein. Such a program embodying the present application may be stored on a computer readable medium, or may have the form of one or more signals. Such signals may be downloaded from an internet website, provided on a carrier signal, or provided in any other form.
It is noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
While the application has been described in conjunction with the specific embodiments above, it is evident that many alternatives, modifications and variations will be apparent to those skilled in the art in light of the foregoing description. Accordingly, all such alternatives, modifications, and variations are included within the spirit and scope of the following claims.
Claims (10)
1. The automatic comparison method for the material number data is characterized by comprising the following steps of:
s100: acquiring material number data of all materials;
s200: comparing the preamble version material number data of the current material with the current version material number data to obtain a first comparison result, wherein the first comparison result comprises newly added, deleted and/or modified material number data of the current version material number data compared with the preamble version material number data;
s300: comparing the material number data of different materials to obtain a second comparison result, wherein the second comparison result comprises material number data similar to the current version of material number data;
s400: comparing the material number data of different versions of the same material to obtain a third comparison result, wherein the third comparison result comprises material number data which is different from the material number data of the current version;
s500: and (5) circularly executing the steps S200-S400, outputting all the first comparison result, the second comparison result and the third comparison result, and displaying.
2. The automatic material number comparison method according to claim 1, wherein the step S100 includes:
responding to the data export instruction, and exporting initial data of all materials;
converting the initial data into material number data in a preset node format through xsl grammar and storing the material number data;
and importing the material number data into a database so as to acquire the material number data of all materials from the database.
3. The automatic comparison method of material number data according to claim 2, wherein each material number data is provided with a key value and a value, and the key value at least comprises a material number name, a material number data table name, a sub key value and a material number field name.
4. A method of automatic comparison of material number data according to claim 3, wherein step S200 comprises:
comparing the key value and the value corresponding to the preamble version material number data of the current material and the current version material number data one by one;
acquiring the modification state of the current version material number data according to the comparison result;
the comparison result comprises the key values and the value values which are the same, the key values are different, the key values are the same and the value values are different.
5. The automatic comparison method of material number data according to claim 4, wherein the obtaining the modification state of the current version of material number data according to the comparison result comprises:
when the key value and the value are the same, judging that the current version of material number data is not modified;
when the key values are different, judging whether the key value of the preamble version material number data exists in the current version material number data, and when the key value is not exists, judging that the current version material number data corresponding to the current key value is deleting data and marking the deleting data for the first time;
judging whether a key value of the current version material number data exists in the preamble version material number data, judging that the current version material number data corresponding to the current key value is newly added data when the key value does not exist, and marking the newly added data for the second time;
when the key values are the same and the value values are different, the current version material number data corresponding to the current key value is judged to be modification data, and third marking is carried out on the modification data.
6. A method of automatic comparison of material number data according to claim 3, wherein the step S300 comprises:
constructing a query condition based on the key value, and acquiring the key value with the same material number name, material number data table name and material number field name by adopting the query condition;
comparing the sub key value of the current version material number data with the sub key value of the historical version material number data;
when the sub key values are the same, judging that the current version material number data is the same data as the historical version material number data, and marking the fourth data for the fourth time;
and when the sub key values are different, judging that the historical version material number data is similar data of the current version material number data, and fifth marking the similar data.
7. A method of automatic comparison of material number data according to claim 3, wherein step S400 comprises:
and comparing the current version material number data and the historical version material number data of the current material, identifying difference data, and performing sixth marking on the difference data.
8. A system employing the automatic material number data comparison method according to any one of claims 1 to 7, characterized in that the system comprises:
the acquisition module is used for: the method comprises the steps of acquiring material number data of all materials;
a first comparison module: the method comprises the steps of comparing preamble version material number data of a current material with current version material number data to obtain a first comparison result;
and a second comparison module: the material number data are used for comparing different materials to obtain a second comparison result;
and a third comparison module: the method comprises the steps of comparing material number data of different versions of the same material to obtain a third comparison result;
and an output module: and the display unit is used for outputting all the first comparison result, the second comparison result and the third comparison result and displaying the results.
9. A storage medium, one of computer-readable storage media, wherein the computer-readable storage medium stores computer instructions for causing a computer to perform the automatic material number data comparison method of any one of claims 1-7.
10. An electronic device comprising a processor and a memory, wherein the memory stores at least one instruction, at least one program, a set of codes, or a set of instructions, the at least one instruction, the at least one program, the set of codes, or the set of instructions being loaded and executed by the processor to implement the method of automatic alignment of material data according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310930546.6A CN116933761A (en) | 2023-07-27 | 2023-07-27 | Automatic material number data comparison method, system, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310930546.6A CN116933761A (en) | 2023-07-27 | 2023-07-27 | Automatic material number data comparison method, system, storage medium and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116933761A true CN116933761A (en) | 2023-10-24 |
Family
ID=88377017
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310930546.6A Pending CN116933761A (en) | 2023-07-27 | 2023-07-27 | Automatic material number data comparison method, system, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116933761A (en) |
-
2023
- 2023-07-27 CN CN202310930546.6A patent/CN116933761A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8010844B2 (en) | File mutation method and system using file section information and mutation rules | |
| US8612372B2 (en) | Detection rule-generating facility | |
| US20110270858A1 (en) | File type recognition analysis method and system | |
| KR20010022215A (en) | System and method for generating year 2000 test cases | |
| US20080091742A1 (en) | System and method for detecting and updating geographical information dataset versions | |
| US5862382A (en) | Program analysis system and program analysis method | |
| US7093207B1 (en) | Data analysis flow engine | |
| CN111061733A (en) | Data processing method, apparatus, electronic device and computer-readable storage medium | |
| CN114116765B (en) | Mybatis framework SQL statement anomaly detection method, server and system | |
| CN117909392B (en) | Intelligent data asset inventory method and system | |
| CN110990055B (en) | Pull Request function classification method based on program analysis | |
| US20070100858A1 (en) | System, method and computer-program product for structured data capture | |
| CN113538626A (en) | Workflow generation method and device | |
| CN111651196A (en) | Document publishing method, device and server | |
| WO2020062186A1 (en) | Industrial device matching method and apparatus | |
| KR20090124059A (en) | Integrated Block Quality Management System and Method | |
| US20030135496A1 (en) | Management program, method and apparatus for business process definition | |
| CN118378270B (en) | Method, device, equipment and medium for generating component vulnerability automatic repair scheme | |
| CN118035117A (en) | A fine-grained test case system for component-based satellite service software | |
| CN116933761A (en) | Automatic material number data comparison method, system, storage medium and electronic equipment | |
| CN117236896A (en) | Automatic type selection analysis method, device and equipment for thermal control instrument | |
| CN117609057A (en) | Code review method, system, equipment and medium based on merging request increment | |
| CN116881512A (en) | Cross-system metadata blood-edge automatic analysis method | |
| CN113590686B (en) | Processing method, device and equipment for ecological environment data index | |
| CN112597040B (en) | Interface automatic testing 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 |