CN102762032A - Method and system for tracking part quality - Google Patents
Method and system for tracking part quality Download PDFInfo
- Publication number
- CN102762032A CN102762032A CN2011101097975A CN201110109797A CN102762032A CN 102762032 A CN102762032 A CN 102762032A CN 2011101097975 A CN2011101097975 A CN 2011101097975A CN 201110109797 A CN201110109797 A CN 201110109797A CN 102762032 A CN102762032 A CN 102762032A
- Authority
- CN
- China
- Prior art keywords
- data
- assembly
- foundry
- product
- stage
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 35
- 238000004519 manufacturing process Methods 0.000 claims abstract description 25
- 238000009434 installation Methods 0.000 claims description 19
- 238000012552 review Methods 0.000 claims description 9
- 241001269238 Data Species 0.000 claims description 6
- 238000000429 assembly Methods 0.000 claims description 6
- 230000000712 assembly Effects 0.000 claims description 6
- 239000000284 extract Substances 0.000 claims description 5
- RVCKCEDKBVEEHL-UHFFFAOYSA-N 2,3,4,5,6-pentachlorobenzyl alcohol Chemical compound OCC1=C(Cl)C(Cl)=C(Cl)C(Cl)=C1Cl RVCKCEDKBVEEHL-UHFFFAOYSA-N 0.000 description 6
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- General Factory Administration (AREA)
Abstract
The invention discloses a method and a system for tracking part quality. The method and the system for tracking part quality can track production specifications of products according to car frame numbers. The method for tracking part quality includes: at the original equipment manufacturing stage of the parts uploading original equipment manufacturing data of parts to an original equipment manufacturer server in real time, and extracting data including part numbers and corresponding test data from the original equipment manufacturer server by a general database at fixed time; at the component mounting stage, binding a plurality of parts into components, and uploading binding data including the part numbers and the component numbers to the general database; and at the product assembling stage, mounting the components to form products, binding the product numbers and the component numbers, and uploading the binding data including the product numbers and the component numbers to the general database.
Description
Technical field
The present invention relates to the trace-back technique of part quality, relate in particular to when vehicle assembles retroactive method and system for printed circuit board (PCB).
Background technology
Because automotive electronics is to review the product of producing; Come the management and control quality and recall; So, when problem occurs, just can recognize very clearly how many products are this problem related to like this for the scheme of reviewing that just must there be a cover oneself in the producer of doing automotive electronics; When these products are produced, and which these products have unusual in process of production.
Especially for the PCBA in the automotive electronics printed circuit board (PCB) of original paper (band), its use amount in automobile assembling is bigger, and also more from producing the link that experiences in assemble, and reviewing of PCBA seemed particularly important.
But in the prior art not the such system of a cover realize the function of reviewing of associated component in the product.
Summary of the invention
The objective of the invention is to address the above problem, a kind of part quality retroactive method is provided, the production details that can number review product through vehicle frame.
Another object of the present invention is to provide a kind of part quality traceability system.
Technical scheme of the present invention is: the present invention has disclosed a kind of part quality retroactive method, comprising:
In the part foundry stage, part foundry data in real time is uploaded to the foundries server, regularly from the foundries server, extract the data that comprise the dash number and the test data of correspondence by the total data storehouse;
At the assembly erection stage, a plurality of parts are bound into assembly, will comprise dash number and assembly numbering and upload to the total data storehouse at interior binding data;
In the product assembling stage, a plurality of assemblies are mounted to product, production code member and assembly numbering are bound, and will comprise production code member and assembly and number and upload to the total data storehouse at interior binding data.
According to an embodiment of part quality retroactive method of the present invention, part is meant the printed circuit board (PCB) of band original paper, and assembly is meant by a plurality of printed circuit board (PCB)s and is assembled into one that product is meant car load.
According to an embodiment of part quality retroactive method of the present invention, the part foundry stage is positioned at the foundries of printed circuit board (PCB), and the assembly erection stage is positioned at the maquila end, and the product assembling stage is positioned at parking lot site installation end.
According to an embodiment of part quality retroactive method of the present invention, the total data storehouse is to realize with SQL database.
According to an embodiment of part quality retroactive method of the present invention, part foundry data are the test datas on each station of part foundry stage.
According to an embodiment of part quality retroactive method of the present invention, production code member is a vehicle frame number.
The present invention has also disclosed a kind of part instruction traceability system, comprises that part foundry data acquisition unit, assembly installation data are uploaded device, product is assembled data upload device, total data repository, wherein:
Part foundry data acquisition unit uploads to the foundries server with part foundry data in real time, regularly from the foundries server, is extracted the data that comprise the dash number and the test data of correspondence by the total data repository;
The assembly installation data is uploaded device, and a plurality of parts are bound into assembly, will comprise dash number and assembly numbering and upload to the total data repository at interior binding data;
Product assembling data upload device is mounted to product with a plurality of assemblies, production code member and assembly numbering is bound, and will comprise production code member and assembly and number and upload to the total data repository at interior binding data;
The total data repository has been stored by part foundry data acquisition unit, assembly installation data and has been uploaded the data that device, product assembling data upload device is uploaded, and supplies the user to review the related data of part in whole process.
According to an embodiment of part instruction traceability system of the present invention, part is meant the printed circuit board (PCB) of band original paper, and assembly is meant by a plurality of printed circuit board (PCB)s and is assembled into one that product is meant car load.
According to an embodiment of part instruction traceability system of the present invention, part foundry data acquisition unit is positioned at the foundries of printed circuit board (PCB), and the assembly installation data is uploaded device and is positioned at the maquila end, and product assembling data upload device is positioned at parking lot site installation end.
According to an embodiment of part instruction traceability system of the present invention, the total data storehouse is to realize with SQL database.
According to an embodiment of part instruction traceability system of the present invention, part foundry data are the test datas on each station of part foundry stage.
According to an embodiment of part of the present invention instruction traceability system, production code member is a vehicle frame number.
The present invention contrasts prior art has following beneficial effect: the present invention is through the total related data of data-base recording workpiece in each link, number reviews the record of workpiece in each link with the vehicle frame of automobile.Compared to prior art, the present invention can let the related personnel recognize the situation of workpiece in each link at any time, and handling for workpieces in subsequent provides basis for estimation.
Description of drawings
Fig. 1 shows the flow chart of the embodiment of part quality retroactive method of the present invention.
Fig. 2 shows the schematic diagram of the embodiment of part quality traceability system of the present invention.
Fig. 3 A～3C shows part quality of the present invention and reviews the sketch map in each stage.
Embodiment
Below in conjunction with accompanying drawing and embodiment the present invention is done further description.
The embodiment of part quality retroactive method
Fig. 1 shows the flow process of the embodiment of part quality retroactive method of the present invention, sees also Fig. 1, is the detailed description to each step of the part quality retroactive method of present embodiment below.
Step S10: in the part foundry stage, part foundry data in real time is uploaded to the foundries server, regularly from the foundries server, extract the data that comprise the dash number and the test data of correspondence by the total data storehouse.
Present embodiment is assembled into example with the finished vehicle electronic system, and part is meant the printed circuit board (PCB) of band original paper.Part foundry data are the test datas on each station.The part foundry stage is positioned at the foundries of printed circuit board (PCB).
Shown in Fig. 3 A, the test data of nine procedures of Fig. 3 A uploads in the PCBA foundries database in real time, regularly from PCBA foundries database, extracts data by SQL total data storehouse then.
Step S12: at the assembly erection stage, a plurality of parts are bound into assembly, will comprise dash number and assembly numbering and upload to the total data storehouse at interior binding data.
Assembly is to be assembled into one by a plurality of printed circuit board (PCB)s, and the assembly erection stage is positioned at the maquila end.
Shown in Fig. 3 B, four printed circuit board wherein are assembled into one, and the binding data of the numbering of these four printed circuit board (PCB)s and assembly numbering passes through the maquila data-base recording in SQL total data storehouse.
Step S14: in the product assembling stage, a plurality of assemblies are mounted to product, production code member and assembly numbering are bound, and will comprise production code member and assembly and number and upload to the total data storehouse at interior binding data.
Product is meant car load, and the product assembling stage is positioned at parking lot site installation end, and the production code member here is meant vehicle frame number.The total data storehouse can use the SQL database technology to realize.Shown in Fig. 3 C, vehicle frame number and assembly numbering through the maquila data-base recording in SQL total data storehouse.
Through the above-mentioned steps data recorded; The user can number obtain the assembly numbering through vehicle frame; Obtain the data of assembling process and the numbering of corresponding printed circuit board (PCB) through the assembly numbering; Numbering through printed circuit board (PCB) obtains the data in the production process again, thereby reviews the overall process of each link of printed circuit board (PCB).
The embodiment of part quality traceability system
Fig. 2 shows the principle of the embodiment of part quality traceability system of the present invention.See also Fig. 2, the part quality traceability system of present embodiment comprises: part foundry data acquisition unit 10, assembly installation data are uploaded device 12, product assembling data upload device 14, total data repository 16.
Annexation between these devices is: the output that part foundry data acquisition unit 10, assembly installation data are uploaded device 12, product assembling data upload device 14 all is connected to total data repository 16.
The principle of present embodiment is following.
Part foundry data acquisition unit 10 uploads to the foundries server with part foundry data in real time, regularly from the foundries server, is extracted the data that comprise the dash number and the test data of correspondence by total data repository 16.
Present embodiment is assembled into example with the finished vehicle electronic system, and part is meant the printed circuit board (PCB) of band original paper.Part foundry data are the test datas on each station.Part foundry data acquisition unit 10 is positioned at the foundries of printed circuit board (PCB).
Shown in Fig. 3 A, the test data of nine procedures of Fig. 3 A uploads in the PCBA foundries database in real time, regularly from PCBA foundries database, extracts data by SQL total data storehouse then.
The assembly installation data is uploaded device 12 a plurality of parts is bound into assembly, will comprise dash number and assembly numbering and upload to total data repository 16 at interior binding data.
Assembly is to be assembled into one by a plurality of printed circuit board (PCB)s, and the assembly installation data is uploaded device 12 and is positioned at the maquila end.
Shown in Fig. 3 B, four printed circuit board wherein are assembled into one, and the binding data of the numbering of these four printed circuit board (PCB)s and assembly numbering passes through the maquila data-base recording in SQL total data storehouse.
Product assembling data upload device 14 is mounted to product with a plurality of assemblies, production code member and assembly numbering is bound, and will comprise production code member and assembly and number and upload to total data repository 16 at interior binding data.
Product is meant car load, and product assembling data upload device 14 is positioned at parking lot site installation end, and the production code member here is meant vehicle frame number.The total data storehouse can use the SQL database technology to realize.Shown in Fig. 3 C, vehicle frame number and assembly numbering through the maquila data-base recording in SQL total data storehouse.
In the system of present embodiment; The user can number obtain the assembly numbering through vehicle frame; Obtain the data of assembling process and the numbering of corresponding printed circuit board (PCB) through the assembly numbering; Numbering through printed circuit board (PCB) obtains the data in the production process again, thereby reviews the overall process of each link of printed circuit board (PCB).
The foregoing description provides to those of ordinary skills and realizes or use of the present invention; Those of ordinary skills can be under the situation that does not break away from invention thought of the present invention; The foregoing description is made various modifications or variation; Thereby protection scope of the present invention do not limit by the foregoing description, and should be the maximum magnitude that meets the inventive features that claims mention.
Claims (12)
1. part quality retroactive method comprises:
In the part foundry stage, part foundry data in real time is uploaded to the foundries server, regularly from the foundries server, extract the data that comprise the dash number and the test data of correspondence by the total data storehouse;
At the assembly erection stage, a plurality of parts are bound into assembly, will comprise dash number and assembly numbering and upload to the total data storehouse at interior binding data;
In the product assembling stage, a plurality of assemblies are mounted to product, production code member and assembly numbering are bound, and will comprise production code member and assembly and number and upload to the total data storehouse at interior binding data.
2. part quality retroactive method according to claim 1 is characterized in that, part is meant the printed circuit board (PCB) of band original paper, and assembly is meant by a plurality of printed circuit board (PCB)s and is assembled into one that product is meant car load.
3. part quality retroactive method according to claim 2 is characterized in that the part foundry stage is positioned at the foundries of printed circuit board (PCB), and the assembly erection stage is positioned at the maquila end, and the product assembling stage is positioned at parking lot site installation end.
4. part quality retroactive method according to claim 1 is characterized in that the total data storehouse is to realize with SQL database.
5. part quality retroactive method according to claim 1 is characterized in that, part foundry data are the test datas on each station of part foundry stage.
6. part quality retroactive method according to claim 3 is characterized in that, production code member is a vehicle frame number.
7. a part instruction traceability system comprises that part foundry data acquisition unit, assembly installation data are uploaded device, product is assembled data upload device, total data repository, wherein:
Part foundry data acquisition unit uploads to the foundries server with part foundry data in real time, regularly from the foundries server, is extracted the data that comprise the dash number and the test data of correspondence by the total data repository;
The assembly installation data is uploaded device, and a plurality of parts are bound into assembly, will comprise dash number and assembly numbering and upload to the total data repository at interior binding data;
Product assembling data upload device is mounted to product with a plurality of assemblies, production code member and assembly numbering is bound, and will comprise production code member and assembly and number and upload to the total data repository at interior binding data;
The total data repository has been stored by part foundry data acquisition unit, assembly installation data and has been uploaded the data that device, product assembling data upload device is uploaded, and supplies the user to review the related data of part in whole process.
8. part instruction traceability system according to claim 7 is characterized in that part is meant the printed circuit board (PCB) of band original paper, and assembly is meant by a plurality of printed circuit board (PCB)s and is assembled into one that product is meant car load.
9. part quality traceability system according to claim 8; It is characterized in that; Part foundry data acquisition unit is positioned at the foundries of printed circuit board (PCB), and the assembly installation data is uploaded device and is positioned at the maquila end, and product assembling data upload device is positioned at parking lot site installation end.
10. part quality traceability system according to claim 7 is characterized in that the total data storehouse is to realize with SQL database.
11. part quality traceability system according to claim 7 is characterized in that, part foundry data are the test datas on each station of part foundry stage.
12. part quality traceability system according to claim 9 is characterized in that, production code member is a vehicle frame number.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110109797.5A CN102762032B (en) | 2011-04-28 | 2011-04-28 | Part quality retroactive method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110109797.5A CN102762032B (en) | 2011-04-28 | 2011-04-28 | Part quality retroactive method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102762032A true CN102762032A (en) | 2012-10-31 |
| CN102762032B CN102762032B (en) | 2016-01-06 |
Family
ID=47056316
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110109797.5A Active CN102762032B (en) | 2011-04-28 | 2011-04-28 | Part quality retroactive method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102762032B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109144801A (en) * | 2018-08-27 | 2019-01-04 | 郑州云海信息技术有限公司 | It is a kind of to be directed to the test method of MOC card, device and equipment in server |
| CN112150165A (en) * | 2020-08-25 | 2020-12-29 | 宣城托新精密科技有限公司 | Automobile ornament quality tracing multiple detection method and system |
| CN112579681A (en) * | 2020-12-16 | 2021-03-30 | 贵州航天朝阳科技有限责任公司 | Engine matching system based on liquid flow data |
| CN112765173A (en) * | 2021-01-20 | 2021-05-07 | 四川湖山电器股份有限公司 | Data storage method, system and loading method suitable for upper computer |
| CN112801243A (en) * | 2020-12-31 | 2021-05-14 | 鲨湾科技(上海)有限公司 | Method and system for determining associated information of production serial number of electric bicycle part |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060004475A1 (en) * | 2004-07-01 | 2006-01-05 | Abb Inc. | Incrementally accruing product and component quality and tracking data in the manufacturing of devices |
| CN1779706A (en) * | 2004-11-23 | 2006-05-31 | 鸿富锦精密工业（深圳）有限公司 | Parts tracking managing system and method |
| CN101540013A (en) * | 2008-03-17 | 2009-09-23 | 亿维讯软件（北京）有限公司 | System and method for tracing quality data of all life cycle |
-
2011
- 2011-04-28 CN CN201110109797.5A patent/CN102762032B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060004475A1 (en) * | 2004-07-01 | 2006-01-05 | Abb Inc. | Incrementally accruing product and component quality and tracking data in the manufacturing of devices |
| CN1779706A (en) * | 2004-11-23 | 2006-05-31 | 鸿富锦精密工业（深圳）有限公司 | Parts tracking managing system and method |
| CN101540013A (en) * | 2008-03-17 | 2009-09-23 | 亿维讯软件（北京）有限公司 | System and method for tracing quality data of all life cycle |
Non-Patent Citations (1)
| Title |
|---|
| 汪勇: "浅谈基于质量追溯的汽车产品质量管理系统", 《世界标准信息 》, 15 January 2008 (2008-01-15) * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109144801A (en) * | 2018-08-27 | 2019-01-04 | 郑州云海信息技术有限公司 | It is a kind of to be directed to the test method of MOC card, device and equipment in server |
| CN112150165A (en) * | 2020-08-25 | 2020-12-29 | 宣城托新精密科技有限公司 | Automobile ornament quality tracing multiple detection method and system |
| CN112579681A (en) * | 2020-12-16 | 2021-03-30 | 贵州航天朝阳科技有限责任公司 | Engine matching system based on liquid flow data |
| CN112801243A (en) * | 2020-12-31 | 2021-05-14 | 鲨湾科技(上海)有限公司 | Method and system for determining associated information of production serial number of electric bicycle part |
| CN112765173A (en) * | 2021-01-20 | 2021-05-07 | 四川湖山电器股份有限公司 | Data storage method, system and loading method suitable for upper computer |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102762032B (en) | 2016-01-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102762032A (en) | Method and system for tracking part quality | |
| CN103473828A (en) | Distribution network line inspection system based on tablet computer | |
| EP1736843A1 (en) | System and method for RFID supported system configuration | |
| US20190029117A1 (en) | Printed circuit board fabrication processes and architecture including point-of-use design and fabrication capacity employing additive manufacturing | |
| MX2014010645A (en) | Communication simulating system, communication simulating method, and vehicle communication apparatus. | |
| CN102169513A (en) | Wiring design system and method | |
| CN104898461A (en) | Half-in-loop simulation test system and method of carrier rocket control system | |
| US20160343276A1 (en) | Use of a code for marking a nacelle | |
| WO2020025399A1 (en) | Device and method for testing the contents of a switchgear cabinet following installation according to a plan | |
| DE102018114598A1 (en) | METHOD AND SYSTEM FOR ANALYZING EXTRACTED PHRASES FROM A TEXT | |
| US20150178524A1 (en) | System and method for wiring circuit verification of vehicle | |
| WO2007032812A3 (en) | Systems and methods for substituting missing data by mock-up data from a proxy | |
| CN101684999B (en) | Conversion method of data format | |
| EP3864487B1 (en) | Method for preparing the automated production of an electronic component, method for automated production and/or for automated post-processing of an electronic component and system | |
| DE102017109132A1 (en) | Method and IT infrastructure for model-based testing of software for a vehicle application system and for providing corresponding test results | |
| EP3132384A1 (en) | The provision of system-specific data | |
| DE102017123530A1 (en) | Method for the mechanical contacting of a potting frame on a printed circuit board | |
| WO2014043520A3 (en) | Screening and monitoring data to ensure that a subject entity complies with laws and regulations | |
| CN113568933A (en) | Vehicle data storage method, vehicle and readable storage medium | |
| CN102663205A (en) | Software realization method and system for vehicle assembly shop tooling site management | |
| WO2012004260A3 (en) | Method for locating aircraft wiring | |
| EP3557454A1 (en) | Method and system for optimisable configuration of a switching cabinet | |
| JP2007133894A (en) | Production method | |
| DE102012015695A1 (en) | Method for retrieving information over quick response codes by electronic devices, particularly smartphones, involves supplementing quick response codes by code consisting of characters and numbers | |
| CN105607984B (en) | A kind of back method of bus record data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: Method and system of parts quality traceability Effective date of registration: 20201130 Granted publication date: 20160106 Pledgee: Jiading Branch of Shanghai Bank Co.,Ltd. Pledgor: SHANGHAI PATEO ELECTRONIC EQUIPMENT MANUFACTURING Co.,Ltd. Registration number: Y2020310000046 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| CP03 | Change of name, title or address | ||
| CP03 | Change of name, title or address |
Address after: 201821 room 208, building 4, No. 1411, Yecheng Road, Jiading Industrial Zone, Jiading District, Shanghai Patentee after: Botai vehicle networking technology (Shanghai) Co.,Ltd. Address before: 200233 block D1, 2f, Zhaofeng global building, No. 1800, Zhongshan West Road, Xuhui District, Shanghai Patentee before: SHANGHAI PATEO ELECTRONIC EQUIPMENT MANUFACTURING Co.,Ltd. |
|
| PM01 | Change of the registration of the contract for pledge of patent right | ||
| PM01 | Change of the registration of the contract for pledge of patent right |
Change date: 20230921 Registration number: Y2020310000046 Pledgor after: Botai vehicle networking technology (Shanghai) Co.,Ltd. Pledgor before: SHANGHAI PATEO ELECTRONIC EQUIPMENT MANUFACTURING Co.,Ltd. |
|
| CP03 | Change of name, title or address | ||
| CP03 | Change of name, title or address |
Address after: Room 3701, No. 866 East Changzhi Road, Hongkou District, Shanghai, 200080 Patentee after: Botai vehicle networking technology (Shanghai) Co.,Ltd. Country or region after: China Address before: 201821 room 208, building 4, No. 1411, Yecheng Road, Jiading Industrial Zone, Jiading District, Shanghai Patentee before: Botai vehicle networking technology (Shanghai) Co.,Ltd. Country or region before: China |