CN105138499B - A kind of data processing method, device and terminal - Google Patents
A kind of data processing method, device and terminal Download PDFInfo
- Publication number
- CN105138499B CN105138499B CN201510483524.5A CN201510483524A CN105138499B CN 105138499 B CN105138499 B CN 105138499B CN 201510483524 A CN201510483524 A CN 201510483524A CN 105138499 B CN105138499 B CN 105138499B
- Authority
- CN
- China
- Prior art keywords
- data
- trial
- data message
- manufactured material
- material inventory
- 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.)
- Active
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a kind of data processing method, device and terminal, wherein, data processing method includes：Obtain enabled instruction；The data message of operation card, and the data message in trial-manufactured material inventory are read according to the enabled instruction；Data message in the trial-manufactured material inventory is subjected to packing summation；The data message of data message and the operation card in the trial-manufactured material inventory after summing of packing is contrasted, result is verified in generation, and is exported.After this programme is by obtaining enabled instruction, directly read the data message in the data message and trial-manufactured material inventory of operation card, and the data message after the data message in trial-manufactured material inventory is handled with operation card is contrasted, result is verified in output, to complete the data check to operation card, it is convenient and swift, manpower and time are saved, improves and verifies efficiency and accuracy rate.
Description
Technical field
The present invention relates to technical field of data processing, particularly relates to a kind of data processing method, device and terminal.
Background technology
Field is researched and developed in automobile, project data is in R＆D process is designed, it is necessary to be manufactured experimently, tested.Trial-production, experiment institute
The material needed needs to purchase, is put in storage, a series of outbound even management such as calcellation.How to ensure that research and development department can carry to process part
Accurate shopping list and the related letter of buying are provided for accurately trial-production parts inventory and process related information, for purchasing department
Breath, for Pilot Manufacturing Dept. provide effectively to go out to be put in storage inventory information, turn into the focus for manufacturing experimently management study, and trial-manufactured material inventory BOM
As technological operation guiding book establishment, shopping list generation, outbound inventory generation data foundation, with greater need for exactly establishment and
Safeguard.Trial-production BOM need to pass through following operation flow from generation to application：
(1) BOM establishments are manufactured experimently：BOM administrative engineers are according to sample car allocation list, trial-production BOM template establishment preproduction car cars
Type information.If there is engineering BOM EBOM data, BOM administrative engineers can assist the examination of expert engineer's generation first edition
BOM data information processed.
(2) trial-production BOM data collects：BOM management engineerings are an apprentice of each expert engineer and obtain the trial-production data filled in there,
Attribute inspection is carried out to it, and collected for a summary table；Summary table through each expert engineer sign after, from BOM administrative engineers to
Department's issue used in connection with.
(3) BOM data change is manufactured experimently：In processes such as project data research and development, the establishment of technological operation guiding book, trial-production experiments
In, if necessary to change trial-production BOM data, it is necessary to initiate to manufacture experimently modification application, data change is then carried out by BOM administrative engineers
More, and by the trial-production BOM after change and modification information issue using department.
(4) BOM data is manufactured experimently to verify：Expert engineer in actual mechanical process, may respectively to process engineer,
BOM Engineer communication exchange, change technological operation guiding book and trial-production BOM；Sometimes BOM administrative engineers, process engineer exist
Safeguard to exist during data and safeguard error situation.To ensure data consistency, it is necessary to be carried out to trial-production BOM and technological operation guiding book
Verify.
Because trial-production BOM data amount is larger, change is more frequent, cause maintenance workload is big, data maintenance not in time etc.
Problem, finally often occurs the inconsistent situation of data in actual implementation process.It is mainly shown as following problem：
(1) it is slower to manufacture experimently BOM establishments speed：When such case refers to generate first edition trial-production BOM data according to EBOM data,
Need to reject the part (mainly purchasing subordinate's part, the part that entrucking and buying are all not concerned with) not embodied in trial-production BOM, it is also necessary to right
The parts repeatedly occurred under same taxonomic structure are merged by structure.This data processing, workload are larger.
(2) the trial-production BOM data that each specialty provides collects content format disunity, and BOM administrative engineers are needed to submitting
Data checked, it is ensured that data, which are filled in, to meet the requirements.
(3) manufacture experimently BOM data change and safeguard that data may be inconsistent with actual change data：Such as the trial-production change submitted
Data are 10, actual only to have changed 9；Either data maintenance is wrong.
(4) technological operation guiding book data can not be verified with manufacturing experimently the uniformity of BOM data：Technological operation guiding book presses work
Position, total member are worked out, and it is a big table to manufacture experimently BOM；The form of expression is different, fairly cumbersome by contrast.
Based on current trial-production BOM management status, go to consider a problem from the angle of optimum management, certainly long-term plan.
But (uncertainty of trial time, the promptness of parts research and development, data change frequent due to manufacturing experimently some characteristics of itself
Property, trial-production purposes diversity), as project data checking a process, if adding too many constraint in management, gesture
R＆D cycle, increase management cost must be extended；Certainly, consider to provide a shared datamation platform, can greatly reduce
Data check workload, but consider whether the implementation duration is longer, can software systems meet that business demand, section office's budget etc. are asked
Topic, use trial-production BOM management systems and improper.
The content of the invention
The technical problem to be solved in the present invention is to provide a kind of data processing method, device and terminal, solves prior art
The problem of middle operation card data check inconvenience.
In order to solve the above-mentioned technical problem, the embodiment of the present invention provides a kind of data processing method, applied to operation card
Data check, including：
Obtain enabled instruction；
The data message of operation card, and the data message in trial-manufactured material inventory are read according to the enabled instruction；
Data message in the trial-manufactured material inventory is subjected to packing summation；
The data message of data message in the trial-manufactured material inventory after summing of packing and the operation card is carried out
Contrast, result is verified in generation, and is exported.
Alternatively, the data message that operation card is read according to the enabled instruction, and in trial-manufactured material inventory
The step of data message, includes：
The data message of operation card is read according to the enabled instruction；
After the data message of the operation card is read, then read the data message in the trial-manufactured material inventory.
Alternatively, it is described according to the enabled instruction read operation card data message the step of include：
Read the configuration rule of operation card；
The data row lookup parameter preset that operation card is traveled through according to the configuration rule is expert at；
If finding, position residing for reading other relevant parameters of being expert at according to the configuration rule and the parameter preset
Confidence ceases, and according to the data message of other relevant parameters of other relevant parameter present position acquisition of information, will be described pre-
The data message of the data message of setting parameter and other relevant parameters is write in result table according to preset rules；
If not finding, perform it is described reading trial-manufactured material inventory in data message the step of.
Alternatively, the number of the data message and the operation card by the trial-manufactured material inventory after summing of packing
It is believed that breath is specially the step of contrast：
Data message in the trial-manufactured material inventory after summing of packing is entered with the data message in the result table
Row contrast.
Alternatively, the described the step of trial-manufactured material inventory information is carried out into packing summation, includes：
Respectively packing summation is carried out according to packet number, Part No. and the column information of station three.
Alternatively, before the acquisition enabled instruction, the data processing method also includes：
According to the trial-manufactured material inventory after modification information generation change.
Alternatively, after the trial-manufactured material inventory after the generation change according to modification information, the data processing side
Method also includes：
Trial-manufactured material change inventory is generated according to modification information.
Alternatively, before the trial-manufactured material inventory after the generation change according to modification information, the data processing side
Method also includes：
The data message inputted according to user in information processing trial-manufactured material inventory, obtains the modification information.
Alternatively, before the acquisition enabled instruction, the data processing method also includes：
Processing engineering BOM obtains the trial-manufactured material inventory.
Alternatively, the step of processing engineering BOM obtains the trial-manufactured material inventory includes：
Attribute inspection is carried out according to preset rules to the data message of the engineering BOM according to specifying for user,
When attribute fills in mistake, recorded, and remind user to modify；
After attribute checks, the buying subordinate part in the data message of the engineering BOM is rejected；
Traversal rejects the data row of the engineering BOM after purchasing subordinate's part, is entered according to specified row and summation column information
Row packing summation, generates the trial-manufactured material inventory.
Alternatively, before the generation trial-manufactured material inventory, the data processing method also includes：
Judge whether traversal terminates；
If so, the step of then performing the generation trial-manufactured material inventory；
If it is not, then traversal rejects the data row of the engineering BOM after buying subordinate part again, according to specified row and
Summation column information carries out packing summation.
Alternatively, the step of basis specifies row and summation column information to carry out packing summation includes：
Judge whether the specified column information of the specified column information and lastrow of current line is identical；
If so, then the summation column information of the summation column information of current line and lastrow is summed, and charge to lastrow
Summation row in, delete current line；
If it is not, then travel through the specified column information of follow-up all data rows, and by specified column information and the specified row of current line
The specified column information of information identical data row, is summed with the specified column information of current line, charges to the specified row of current line
In, delete the specified column information identical data row for specifying column information and current line.
Alternatively, there is the corresponding pass between the parameter preset and other described relevant parameters in the configuration rule
System.
Alternatively, the parameter preset includes technique numbering and/or dash number.
Present invention also offers a kind of data processing equipment, applied to the data check of operation card, including：
Acquisition module, for obtaining enabled instruction；
Read module, for reading the data message of operation card according to the enabled instruction, and in trial-manufactured material inventory
Data message；
Summation module, for the data message in the trial-manufactured material inventory to be carried out into packing summation；
First processing module, for the data message in the trial-manufactured material inventory after packing is summed and the technique
The data message of card is contrasted, and result is verified in generation, and is exported.
Present invention also offers a kind of terminal, including：Above-mentioned data processing equipment.
The above-mentioned technical proposal of the present invention has the beneficial effect that：
In such scheme, after the data processing method is by obtaining enabled instruction, the data letter of operation card is directly read
Data message in breath and trial-manufactured material inventory, and after the data message in trial-manufactured material inventory is handled with operation card
Data message contrasted, result is verified in output, convenient and swift to complete to the data check of operation card, save manpower with
Time, improve and verify efficiency and accuracy rate.
Brief description of the drawings
Fig. 1 is the data processing method schematic flow sheet of the embodiment of the present invention one；
Fig. 2 is the trial-production BOM data handling process schematic diagram of the embodiment of the present invention two；
Fig. 3 is the EBOM flow chart of data processing schematic diagrames of the embodiment of the present invention two；
Fig. 4 is the operation card Data Extraction Plug-ins interface schematic diagram of the embodiment of the present invention two；
Fig. 5 is that the technological operation guiding book components information of the embodiment of the present invention two extracts result template schematic diagram；
Fig. 6 is the trial-production BOM and operation card data check schematic flow sheet of the embodiment of the present invention two；
Fig. 7 is the trial-production BOM and operation card data comparison result schematic diagram of the embodiment of the present invention two；
Fig. 8 is the data processing equipment structural representation of the embodiment of the present invention three.
Embodiment
To make the technical problem to be solved in the present invention, technical scheme and advantage clearer, below in conjunction with accompanying drawing and tool
Body embodiment is described in detail.
The present invention is directed to the problem of operation card data check inconvenience in existing technology, there is provided a variety of solutions, tool
Body is as follows：
Embodiment one
As shown in figure 1, the data processing method in the embodiment of the present invention one, described applied to the data check of operation card
Data processing method includes：
Step 11：Obtain enabled instruction；
Step 12：The data message of operation card, and the data in trial-manufactured material inventory are read according to the enabled instruction
Information；
Step 13：Data message in the trial-manufactured material inventory is subjected to packing summation；
Step 14：The data of data message in the trial-manufactured material inventory after summing of packing and the operation card are believed
Breath is contrasted, and result is verified in generation, and is exported.
After the data processing method that the embodiment of the present invention one provides is by obtaining enabled instruction, operation card is directly read
Data message and trial-manufactured material inventory in data message, and after the data message in trial-manufactured material inventory is handled
Contrasted with the data message of operation card, result is verified in output, convenient and swift to complete the data check to operation card, section
Human-saving and time, improve and verify efficiency and accuracy rate.
Wherein, the data message that operation card is read according to the enabled instruction, and the number in trial-manufactured material inventory
It is believed that the step of breath, includes：The data message of operation card is read according to the enabled instruction；The data message of the operation card is read
After taking, then read the data message in the trial-manufactured material inventory.
Specifically, it is described according to the enabled instruction read operation card data message the step of include：Read operation card
Configuration rule；The data row lookup parameter preset that operation card is traveled through according to the configuration rule is expert at；If finding, root
According to the configuration rule and the parameter preset be expert at read other relevant parameter present position information, and according to it is described other
The data message of other relevant parameters of relevant parameter present position acquisition of information, by the data message of the parameter preset and described
The data message of other relevant parameters is write in result table according to preset rules；If not finding, perform described read and manufacture experimently
The step of data message in BOM.
More specifically, the data message by the trial-manufactured material inventory after summing of packing and the operation card
The step of data message is contrasted be specially：By pack sum after the trial-manufactured material inventory in data message with it is described
As a result the data message in table is contrasted.
In the present embodiment, the described the step of trial-manufactured material inventory information is carried out into packing summation, includes：Respectively according to
Packet number, Part No. and the column information of station three carry out packing summation.
In order to ensure the accuracy of trial-manufactured material listings data, before the acquisition enabled instruction, the data processing
Method also includes：According to the trial-manufactured material inventory after modification information generation change.
Associative operation is carried out for the ease of administrative staff, the trial-manufactured material after the generation change according to modification information is clear
After list, the data processing method also includes：Trial-manufactured material change inventory is generated according to modification information.
Further, before the trial-manufactured material inventory after the generation change according to modification information, the data processing
Method also includes：The data message inputted according to user in information processing trial-manufactured material inventory, obtains the modification information.
Wherein, before the acquisition enabled instruction, the data processing method also includes：Processing engineering BOM obtains
To the trial-manufactured material inventory.
Specifically, the processing engineering BOM includes the step of obtaining the trial-manufactured material inventory：According to user's
Specify and attribute inspection is carried out according to preset rules to the data message of the engineering BOM, when attribute fills in mistake, enter
Row record, and remind user to modify；After attribute checks, in the data message for rejecting the engineering BOM
Purchase subordinate's part；Traversal rejects the data row of the engineering BOM after purchasing subordinate's part, according to specified row and summation row letter
Breath carries out packing summation, generates the trial-manufactured material inventory.
Further, before the generation trial-manufactured material inventory, the data processing method also includes：Judgement time
Go through and whether terminate；If so, the step of then performing the generation trial-manufactured material inventory；If it is not, then traversal rejects buying again
The data row of engineering BOM after subordinate's part, packing summation is carried out according to specified row and summation column information.
Specifically, the basis includes the step of specifying row and summation column information to carry out packing summation：Judge current line
Specified column information and lastrow specified column information it is whether identical；If so, then by the summation column information and lastrow of current line
Summation column information summed, and charge to lastrow summation row in, delete current line；If it is not, then travel through follow-up all numbers
According to capable specified column information, and by specified column information and the specified column information of the specified column information identical data row of current line,
Summed, charged in the specified row of current line with the specified column information of current line, delete the finger for specifying column information and current line
Determine column information identical data row.
Have for the ease of obtaining the data message of operation card, in the configuration rule parameter preset with it is described other
Corresponding relation between relevant parameter.Alternatively, the parameter preset includes technique numbering and/or dash number.
Embodiment two
The embodiment of the present invention two develop EBOM data processings plug-in unit (comprising trial-production BOM parts inventory abstraction functions and
Part packing processing function), effectively to remove buying subordinate part, and EBOM data can be merged；It will be based on
Data comparison plug-in unit template grand EXCEL is applied to the contrast between trial-production BOM versions：By the trial-production of former and later two different editions
BOM data is put into data comparison plug-in unit template, to produce the data variation information of former and later two versions, change information according to
Changing content, shown by different colours, visually illustrate some period data situation；Develop technological operation
Guiding book components information extracts plug-in unit, according to the requirement of technological operation guiding book template, to extract required data and press
Specified template is preserved, and data basis is established so as to be verified for trial-production BOM data；It also developed trial-production BOM and operation card number
According to plug-in unit is verified, to verify operation card data.
The scheme provided below the embodiment of the present invention two-trial-production BOM management auxiliary mechanisms based on EXCEL carry out brief
Explanation.
As shown in Fig. 2 during trial-production BOM management, EBOM data processings plug-in unit, trial-production BOM data pair can be used
Than template, technological operation guiding book components information extraction plug-in unit and trial-production BOM and operation card data check plug-in unit, by Business Stream
The operation that some in journey solidify switchs to system processing by processing by hand, greatly improves the operating efficiency of BOM administrative engineers：
Step 21：The initial trial-production BOM of establishment, using EBOM data processing plug-in units；
Step 22：Manufacture experimently BOM attribute inspections；
Step 23：Trial-production BOM collects and issued；
Step 24：Safeguard trial-production BOM change data；
Step 25：Generation trial-production BOM change inventories, using trial-production BOM data contrast mould；
Step 26：Check whether the renewal of operation card data is complete, the extraction of technique for applying operation guide components information is inserted
Part and trial-production BOM and operation card data check plug-in unit.
Wherein, (1) EBOM data processing plug-in units
EBOM data processing plug-in units are the plug-in units based on EXCEL write with VBA, can delete buying subordinate part, and right
Data row merges；EBOM data are switched to manufacture experimently BOM data, mainly remain Purchased Item, entrucking part, buying cooperation part
And its subordinate's part；And packing processing is carried out to the parts of reservation, main rule is as follows：
EBOM attribute inspections：The EBOM data for ensuring to obtain do not have the mistake that attribute fills in aspect, otherwise will cause mistake
Take to by mistake in trial-production BOM；
Manufacture experimently the extraction of BOM parts inventory：Reject buying subordinate part (subordinate's part is the reservation of entrucking part)；Final reservation is adopted
Purchase parts, entrucking parts, self-control parts etc..
Component number is according to packing：The trial-production BOM parts inventories of acquisition are packed, i.e.,：Design of part and Part No.
Identical parts, if Part No. is neighbouring, quantity is superimposed together, retains data line.
The rule more than, EBOM data processing plug-in units are combined with the inspection of EBOM attributes, (entrucking part removes buying subordinate part
(inspection of EBOM attributes, buying subordinate part is rejected and data are packaged as three independent work(for the function of rejecting and data packing outside)
Can, they are combined by EBOM data processing plug-in units) reduce manual operation workload, improve at EBOM data
The operating efficiency of reason.
EBOM flow chart of data processing is as shown in Figure 3：
Step 31：According to EBOM attribute informations corresponding to specified tables of data and reference columns acquisition of information；
Step 32：Judge whether EBOM attribute informations are correct, if so, into step 34, if it is not, into step 33；
Step 33：The data row information of EBOM attribute errors is recorded, and is shown, reminds BOM administrative engineers to carry out
Data correction, after amendment, return to step 32；
Step 34：Reject buying subordinate's part (except entrucking part)；
Step 35：Ergodic data row, read the reference column information in tables of data；
Step 36：Adjacent packing (current line is identical with the reference column information of lastrow) is determined whether, if so, entering step
Rapid 37, if it is not, into step 38；
Step 37：Reference columns are summed, charged in lastrow reference columns, while delete current line, subsequently into step
Rapid 39；
Step 38：According to the reference column information of current line, the follow-up all data row informations of traversal current line, if in the presence of with
The reference column information identical data row of current line, then reference columns are summed, and delete the data row found；
Step 39：Judge whether traversal terminates, if so, into step 310, if it is not, return to step 35；
Step 310：Generate data packing result.
(2) BOM attribute inspections are manufactured experimently
Whether trial-production BOM attributes inspection mainly fills in (such as including required item：First vehicle, Part No., part Chinese
Deng), whether automobile type configuration information complete, moment of torsion fill in whether meet the requirements, the information such as whether buying state correct.These information
It can be achieved, will not be repeated here by functions such as the existing screenings of EXCEL.
(3) application data contrast plug-in unit template carries out manufacturing experimently BOM data contrast
It is similar to EBOM data comparisons to manufacture experimently BOM data contrast, does not have unique mark row in EBOM data, is carried by plug-in unit
Take generation unique mark row；And manufacture experimently BOM and unique line identifier has been determined that in maintenance process is worked out, therefore, it is not required to make data
Processing, you can be compared.The details of data comparison plug-in unit refers to document ---《It is a kind of effectively based on EXCEL's
EBOM data check methods》, will not be repeated here.
(4) BOM and operation card data check plug-in unit are manufactured experimently
At present, technological operation guiding book is by the scheme of installation of the parts on each station, installation instructions, using zero
Component information makes at least one card, that is to say, that the technological operation guiding book of process part establishment is by multiple process charts
Composition.
If wanting the components information of extraction process operation guide, the position of fill message on process chart is necessarily required
Put and have something to base on.By checking, analyzing, summarizing, the process such as testing, the present invention, which proposes, meets the zero of current process card format
Component information extraction algorithm.The algorithm requires that each process chart includes technique numbering and the row information of dash number two, and other
Attribute field is distributed in this two row --- being not considered elsewhere is distributed in, attribute field is numbered with technique or part is compiled
Number relative position it is constant.Operation card Data Extraction Plug-ins interface " can browse " selection institute as shown in figure 4, including file path
The technological operation guiding book needed；Technique number label arranges, operation card numbering, operation card name column, dash number row, packet number
Row, parts title row, unit dose row, assembly name label row, assembly name column and station name column.
User can click on navigation button, select the technological operation guiding book to be extracted (only to support EXCEL version techniques at present
Card)；After filling in corresponding informance, confirming button is clicked on, you can the components information of extraction process operation guide；Cancellation is clicked on to press
Button, the data extraction of operation card can be cancelled.Extraction result is preserved according to template content as shown in Figure 5.
According to the technological operation guiding book components information extracted, the present invention proposes trial-production BOM and referred to technological operation
Book components information contrast mechanism (trial-production BOM and operation card data check algorithm) is led, is mainly included the following steps that：
1) station, IA packets (operation card packet), Part No. are pressed, summation is carried out to data and collected.On the other hand, it can be used above
In the data packing function introduced the operation card data of trial-production BOM, extraction are handled.
2) station, IA packets, Part No. information are merged into a row, use data comparison plug-in unit template carries out data pair
Than the whether consistent of data checked.
Trial-production BOM is illustrated with operation card data check algorithm flow below, as shown in Figure 6.
Step 61：Read technological operation guiding book configuration rule；
Step 62：Travel through technological operation guiding book data row；
Step 63：" Part No. " is searched to be expert at；
Step 64：Judge whether to find " Part No. " property location, if so, into step 65, if it is not, into step
67；
Step 65：It is expert at according to " Part No. " and configuration rule, searches other attribute position information；
Step 66：Reading attributes corresponding data information simultaneously writes result table, return to step 62 according to template；
Step 67：Read the data letter in the result table of trial-production BOM data message and the technological operation guiding book of extraction
Breath；
Step 68：Respectively packing summation is carried out according to IA packet numbers, Part No., the column information of station three；
Step 69：Data after packing are subjected to data comparison；
Step 610：Generate data comparison result.
By manufacturing experimently BOM and operation card data comparison, verification result as shown in Figure 7 is ultimately formed.Verify asking for result
Inscribing type is mainly at present：Trial-production BOM in lack lack in part, operation card part, trial-production BOM and operation card quantity it is inconsistent
Three types.
It should be noted that after " Part No. " property location is found, scheme provided by the invention can also set work
Parts attribute (position) configuration rule in skill card.
From the foregoing, it will be observed that the embodiment of the present invention two mainly provides the EBOM data processings plug-in unit based on EXCEL and its wrapped
The buying subordinate part contained is rejected and parts packing plug-in unit, and the plug-in unit is in addition to rejecting Data duplication row and buying subordinate part, also
For the data summarization work of thousands of parts, it can subtract significantly to specifying qualified quantity summation in row to collect
Lack labor workload, improve data accuracy；
Develop trial-production BOM and operation card data check plug-in unit and its comprising operation card data extraction algorithm, by this
Plug-in unit, the components information disperseed in technological operation guiding book is collected together, and press data comparison template by the zero of extraction
Component information is contrasted with trial-production BOM, has ultimately generated trial-production BOM and operation card correction data；
Application data contrast mould, the trial-production BOM of front and rear different editions is contrasted, offer is updated the data for downstream
Effective and convenient data renewal foundation.
In summary, the embodiment of the present invention two is mainly manufactured experimently from raising works out efficiency, finds data problem in time, ensures to become
More data maintenance is with submitting the uniformity of change data, finding technological operation guiding book components information and trial-production BOM zero in time
Wait from the aspect of four in the inconsistent place of component information, there is provided a kind of data processing method, to reach following purpose：
(1) effectively extraction EBOM in buying subordinate's part and effectively merge it is generic under components information；
(2) check that trial-production BOM attributes check rule；
(3) generation trial-production BOM change results；
(4) components information in scattered technological operation guiding book is merged, and protected by the form that can be contrasted
Deposit；
(5) technological operation guiding book data and trial-production BOM data are verified as requested, and result is carried out in the form of setting
Displaying；
(6) operating efficiency of trial-production BOM management and the correctness of change data maintenance are improved.
Embodiment three
As shown in figure 8, the data processing equipment in the embodiment of the present invention three, described applied to the data check of operation card
Data processing equipment includes：
Acquisition module 81, for obtaining enabled instruction；
Read module 82, for reading the data message of operation card, and trial-manufactured material inventory according to the enabled instruction
In data message；
Summation module 83, for the data message in the trial-manufactured material inventory to be carried out into packing summation；
First processing module 84, for the data message in the trial-manufactured material inventory after packing is summed and the work
The data message of skill card is contrasted, and result is verified in generation, and is exported.
After the data processing equipment that the embodiment of the present invention three provides is by obtaining enabled instruction, operation card is directly read
Data message and trial-manufactured material inventory in data message, and after the data message in trial-manufactured material inventory is handled
Contrasted with the data message of operation card, result is verified in output, convenient and swift to complete the data check to operation card, section
Human-saving and time, improve and verify efficiency and accuracy rate.
Wherein, the read module includes：First reading submodule, for reading operation card according to the enabled instruction
Data message；Second reading submodule, after the data message for the operation card is read, then read the trial-manufactured material
Data message in inventory.
Specifically, the read module includes：3rd reading submodule, for reading the configuration rule of operation card；Search
Submodule, the data row for traveling through operation card according to the configuration rule are searched parameter preset and are expert at；First processing submodule
Block, if for finding, position residing for reading other relevant parameters of being expert at according to the configuration rule and the parameter preset
Confidence ceases, and according to the data message of other relevant parameters of other relevant parameter present position acquisition of information, will be described pre-
The data message of the data message of setting parameter and other relevant parameters is write in result table according to preset rules；First performs
Submodule, if for not finding, perform the operation of the data message in the reading trial-manufactured material inventory.
More specifically, the first processing module is specifically used for：Will pack summation after the trial-manufactured material inventory in
Data message is contrasted with the data message in the result table.
In the present embodiment, the summation module includes：Summation submodule, for respectively according to packet number, Part No. and work
Three column informations of position carry out packing summation.
In order to ensure the accuracy of trial-manufactured material listings data, the data processing equipment also includes：First generation module,
Before performing associative operation for the acquisition module, according to the trial-manufactured material inventory after modification information generation change.
Associative operation is carried out for the ease of administrative staff, the data processing equipment also includes：Second generation module, is used for
After first generation module performs associative operation, trial-manufactured material change inventory is generated according to modification information.
Further, the data processing equipment also includes：Second processing module, performed for first generation module
Before associative operation, according to the data message in user's input information processing trial-manufactured material inventory, the modification information is obtained.
Wherein, the data processing equipment also includes：3rd processing module, associative operation is performed for the acquisition module
Before, processing engineering BOM obtains the trial-manufactured material inventory.
Specifically, the 3rd processing module includes：Second processing submodule, for being set according to specifying for user to described
The data message for counting BOM carries out attribute inspection according to preset rules, when attribute fills in mistake, is recorded, and remind
User modifies；Submodule is rejected, after being checked in attribute, in the data message for rejecting the engineering BOM
Buying subordinate part；3rd processing submodule, for traveling through the data row of the engineering BOM after rejecting buying subordinate part, root
Packing summation is carried out according to specified row and summation column information, generates the trial-manufactured material inventory.
Further, the data processing equipment also includes：First judging submodule, for the described 3rd processing submodule
Before performing associative operation, judge whether traversal terminates；Second implementation sub-module, for if so, then performing described in the generation
The operation of trial-manufactured material inventory；Fourth process submodule, for if it is not, then traversal rejects the design thing after buying subordinate part again
Expect the data row of inventory, packing summation is carried out according to specified row and summation column information.
Specifically, the 3rd processing submodule includes：Second judging submodule, for judging that the specified row of current line are believed
Whether breath is identical with the specified column information of lastrow；5th processing submodule, for if so, then by the summation column information of current line
Summed, and charged in the summation row of lastrow with the summation column information of lastrow, delete current line；6th processing submodule
Block, for if it is not, the then specified column information of the follow-up all data rows of traversal, and the specified row of specified column information and current line are believed
The specified column information of identical data row is ceased, is summed, is charged in the specified row of current line with the specified column information of current line,
Delete the specified column information identical data row for specifying column information and current line.
Have for the ease of obtaining the data message of operation card, in the configuration rule parameter preset with it is described other
Corresponding relation between relevant parameter.Alternatively, the parameter preset includes technique numbering and/or dash number.
Wherein, the embodiment realized embodiment and be applied to the data processing equipment of above-mentioned data processing method
In, it can also reach identical technique effect.
In order to solve the above-mentioned technical problem, the embodiment of the present invention additionally provides a kind of terminal, including：Above-mentioned data processing
Device.
It should be noted that the embodiment realized embodiment and be applied to the terminal of above-mentioned data processing equipment
In, it can also reach identical technique effect.
Above-described is the preferred embodiment of the present invention, it should be pointed out that is come for the ordinary person of the art
Say, under the premise of principle of the present invention is not departed from, some improvements and modifications can also be made, these improvements and modifications should also regard
For protection scope of the present invention.
Claims (15)
1. a kind of data processing method, the data check applied to operation card, it is characterised in that including：
Obtain enabled instruction；
The data message of operation card, and the data message in trial-manufactured material inventory are read according to the enabled instruction；
Data message in the trial-manufactured material inventory is subjected to packing summation；
The data message of data message and the operation card in the trial-manufactured material inventory after summing of packing is contrasted,
Result is verified in generation, and is exported；
Wherein, it is described according to the enabled instruction read operation card data message the step of include：
Read the configuration rule of operation card；
The data row lookup parameter preset that operation card is traveled through according to the configuration rule is expert at；
If finding, it is expert at according to the configuration rule and the parameter preset and reads other relevant parameter present positions letter
Breath, and according to the data message of other relevant parameters of other relevant parameter present position acquisition of information, by the default ginseng
Several data messages and the data message of other relevant parameters are write in result table according to preset rules；
If not finding, perform it is described reading trial-manufactured material inventory in data message the step of.
2. data processing method as claimed in claim 1, it is characterised in that described that operation card is read according to the enabled instruction
Data message, and the step of data message in trial-manufactured material inventory includes：
The data message of operation card is read according to the enabled instruction；
After the data message of the operation card is read, then read the data message in the trial-manufactured material inventory.
3. data processing method as claimed in claim 1, it is characterised in that the trial-manufactured material after summing that will pack
The step of data message of data message and the operation card in inventory is contrasted be specially：
Data message in data message and the result table in the trial-manufactured material inventory after summing of packing is carried out pair
Than.
4. data processing method as claimed in claim 1, it is characterised in that described to carry out the trial-manufactured material inventory information
The step of packing summation, includes：
Respectively packing summation is carried out according to packet number, Part No. and the column information of station three.
5. data processing method as claimed in claim 1, it is characterised in that before the acquisition enabled instruction, the number
Also include according to processing method：
According to the trial-manufactured material inventory after modification information generation change.
6. data processing method as claimed in claim 5, it is characterised in that after the generation change according to modification information
After trial-manufactured material inventory, the data processing method also includes：
Trial-manufactured material change inventory is generated according to modification information.
7. data processing method as claimed in claim 5, it is characterised in that after the generation change according to modification information
Before trial-manufactured material inventory, the data processing method also includes：
The data message inputted according to user in information processing trial-manufactured material inventory, obtains the modification information.
8. data processing method as claimed in claim 1, it is characterised in that before the acquisition enabled instruction, the number
Also include according to processing method：
Processing engineering BOM obtains the trial-manufactured material inventory.
9. data processing method as claimed in claim 8, it is characterised in that the processing engineering BOM obtains the examination
The step of BOM processed, includes：
Attribute inspection is carried out according to preset rules to the data message of the engineering BOM according to specifying for user, in attribute
When filling in mistake, recorded, and remind user to modify；
After attribute checks, the buying subordinate part in the data message of the engineering BOM is rejected；
Traversal rejects the data row of the engineering BOM after purchasing subordinate's part, is beaten according to specified row and summation column information
Bag summation, generates the trial-manufactured material inventory.
10. data processing method as claimed in claim 9, it is characterised in that the generation trial-manufactured material inventory it
Before, the data processing method also includes：
Judge whether traversal terminates；
If so, the step of then performing the generation trial-manufactured material inventory；
If it is not, then traversal rejects the data row of the engineering BOM after purchasing subordinate's part again, according to specified row and summation
Column information carries out packing summation.
11. data processing method as claimed in claim 9, it is characterised in that the basis specifies row and summation column information
The step of carrying out packing summation includes：
Judge whether the specified column information of the specified column information and lastrow of current line is identical；
If so, then the summation column information of the summation column information of current line and lastrow is summed, and charge to asking for lastrow
In row, current line is deleted；
If it is not, then travel through the specified column information of follow-up all data rows, and by specified column information and the specified column information of current line
The specified column information of identical data row, summed with the specified column information of current line, charge in the specified row of current line, delete
Except specified column information and the specified column information identical data row of current line.
12. data processing method as claimed in claim 1, it is characterised in that have the default ginseng in the configuration rule
Several corresponding relations between other described relevant parameters.
13. data processing method as claimed in claim 1, it is characterised in that the parameter preset include technique number and/or
Dash number.
14. a kind of data processing equipment, the data check applied to operation card, it is characterised in that including：
Acquisition module, for obtaining enabled instruction；
Read module, for reading the data message of operation card, and the number in trial-manufactured material inventory according to the enabled instruction
It is believed that breath；
Summation module, for the data message in the trial-manufactured material inventory to be carried out into packing summation；
First processing module, for the data message in the trial-manufactured material inventory after packing is summed and the operation card
Data message is contrasted, and result is verified in generation, and is exported；
Wherein, the read module includes：3rd reading submodule, for reading the configuration rule of operation card；Search submodule,
Data row for traveling through operation card according to the configuration rule is searched parameter preset and is expert at；First processing submodule, is used for
If finding, it is expert at according to the configuration rule and the parameter preset and reads other relevant parameter present position information,
And according to the data message of other relevant parameters of other relevant parameter present position acquisition of information, by the parameter preset
The data message of data message and other relevant parameters is write in result table according to preset rules；First implementation sub-module,
If for not finding, the operation of the data message in the reading trial-manufactured material inventory is performed.
A kind of 15. terminal, it is characterised in that including：Data processing equipment as claimed in claim 14.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510483524.5A CN105138499B (en) | 2015-08-07 | 2015-08-07 | A kind of data processing method, device and terminal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510483524.5A CN105138499B (en) | 2015-08-07 | 2015-08-07 | A kind of data processing method, device and terminal |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105138499A CN105138499A (en) | 2015-12-09 |
| CN105138499B true CN105138499B (en) | 2018-03-09 |
Family
ID=54723850
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510483524.5A Active CN105138499B (en) | 2015-08-07 | 2015-08-07 | A kind of data processing method, device and terminal |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105138499B (en) |
Families Citing this family (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106469141B (en) * | 2016-08-31 | 2018-10-23 | 北京汽车研究总院有限公司 | A kind of ECN inspection methods based on Excel and TeamCenter |
| CN106435069B (en) * | 2016-10-17 | 2018-07-06 | 中冶赛迪工程技术股份有限公司 | A kind of change material detection method and system towards blast furnace process production process |
| WO2018088470A1 (en) * | 2016-11-11 | 2018-05-17 | 日本電気株式会社 | Process design assistance apparatus, process design assistance method, and program |
| CN107330648A (en) * | 2017-06-12 | 2017-11-07 | 北京汽车研究总院有限公司 | The preparation method and scheduling apparatus of the vehicle trial-manufactured material inventory configured based on multi-vehicle-type |
| CN112508470A (en) * | 2019-09-16 | 2021-03-16 | 比亚迪股份有限公司 | Method and device for changing bill of material, storage medium and electronic equipment |
| CN112463850A (en) * | 2020-11-20 | 2021-03-09 | 中国建设银行股份有限公司 | Data processing method, device and storage medium |
| CN112508520A (en) * | 2020-12-08 | 2021-03-16 | 安徽巨一科技股份有限公司 | Method, system, device and storage medium for rapidly checking bill of material |
| CN112712415B (en) * | 2021-01-19 | 2023-01-10 | 青岛檬豆网络科技有限公司 | Form preprocessing method based on purchase BOM (bill of material) price checking of electronic components |
| CN114331129A (en) * | 2021-12-28 | 2022-04-12 | 广东泰云泽科技有限公司 | Data analysis method and system based on cloud computing |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1851575A (en) * | 2006-05-24 | 2006-10-25 | 北京理工大学 | Production site-faced semi-immersion assembling process planning method |
| CN101515308A (en) * | 2009-03-31 | 2009-08-26 | 上海同济同捷科技股份有限公司 | Data management system for vehicle products and collaborative design method thereof |
-
2015
- 2015-08-07 CN CN201510483524.5A patent/CN105138499B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1851575A (en) * | 2006-05-24 | 2006-10-25 | 北京理工大学 | Production site-faced semi-immersion assembling process planning method |
| CN101515308A (en) * | 2009-03-31 | 2009-08-26 | 上海同济同捷科技股份有限公司 | Data management system for vehicle products and collaborative design method thereof |
Non-Patent Citations (6)
| Title |
|---|
| BOM一致性维护;袁平鹏 等;《计算机辅助设计与图形学学报》;20020131;第14卷(第1期);第83-86页 * |
| BOM多视图和视图之间映射模型的研究;黄学文 等;《机械工程学报》;20050430;第41卷(第4期);第97-102页 * |
| 以制造BOM为核心的制造工艺数据管理研究;贾晓亮 等;《制造业自动化》;20060531;第28卷(第5期);第20-23页 * |
| 基于VPG/FFC的商用车BOM的管理方法;王帅锋;《机械设计与制造工程》;20140630;第43卷(第6期);第1节、第2.1节、第2.2节第1段、第2.3节、第3.2.2 * |
| 基于单一产品数据源的BOM管理;蒋辉 等;《北京航空航天大学学报》;20030531;第29卷(第5期);第447-450页 * |
| 多车型结构中零部件关系及配置管理研究;郭庆军 等;《新型工业化》;20150509;第5卷(第5期);第62-66页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105138499A (en) | 2015-12-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105138499B (en) | A kind of data processing method, device and terminal | |
| CN103605857B (en) | Towards the dimensional structured process design system and method for designing of spacecraft | |
| CN108228183A (en) | Front-end interface code generating method, device, electronic equipment and storage medium | |
| CN106142091A (en) | Information processing method and information processor | |
| CN105718728B (en) | A kind of method calculated automatically for road roller number of rolling | |
| CN103870623A (en) | Preprocessing template for vehicle model | |
| CN107066519A (en) | A kind of task detection method and device | |
| CN107451368A (en) | Weld fatigue lifetime estimation method based on ANSYS platforms | |
| CN105608140A (en) | Graphical automatic compilation method for LKJ basic data | |
| CN110555271A (en) | Auxiliary assembly method and device | |
| CN106815725A (en) | A kind of transaction verification method and device | |
| CN109522453A (en) | A kind of standard criterion digitalized processing method towards equipment technology index | |
| CN107239923B (en) | Method and device for generating material application form | |
| CN105205545A (en) | Method for optimizing logistics system by applying simulation experiment | |
| CN106156170A (en) | The analysis of public opinion method and device | |
| CN110375728A (en) | A kind of GYK railcar air navigation aid and system based on chart database | |
| CN114281821A (en) | Data chart sharing system and method | |
| CN108399545A (en) | E-commerce platform quality determining method and device | |
| Singh et al. | Does analysis matter in Six Sigma?: a case study | |
| CN111368353A (en) | CAD drawing rollover method, system, device and storage medium | |
| Dettmann et al. | Startup methodology for production flow simulation projects assessing environmental sustainability | |
| CN107704707A (en) | A kind of method for checking word on pad | |
| Yousnadj et al. | Integration of environmental assessment in a PLM context: a case study in luxury industry | |
| CN102955870A (en) | Method and system for extracting dimension information | |
| CN107330648A (en) | The preparation method and scheduling apparatus of the vehicle trial-manufactured material inventory configured based on multi-vehicle-type |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20200805 Address after: 100130 Zhaofeng Town, Shunyi District, Beijing Zhaofeng industrial base Tongxin Road No. 1 Patentee after: BAIC GROUP ORV Co.,Ltd. Address before: 101300, 99, Shuanghe Avenue, Renhe Town, Beijing, Shunyi District Patentee before: BEIJING AUTOMOBILE RESEARCH GENERAL INSTITUTE Co.,Ltd. |