CN111415172A - Intelligent tracing method for monitoring core board quality - Google Patents

Intelligent tracing method for monitoring core board quality Download PDF

Info

Publication number
CN111415172A
CN111415172A CN202010159170.XA CN202010159170A CN111415172A CN 111415172 A CN111415172 A CN 111415172A CN 202010159170 A CN202010159170 A CN 202010159170A CN 111415172 A CN111415172 A CN 111415172A
Authority
CN
China
Prior art keywords
core board
information
traceability
database
product
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202010159170.XA
Other languages
Chinese (zh)
Inventor
黄健
戴俊秀
叶荣盛
张顺境
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangzhou Embedsky Computer Tech Co ltd
Original Assignee
Guangzhou Embedsky Computer Tech Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Guangzhou Embedsky Computer Tech Co ltd filed Critical Guangzhou Embedsky Computer Tech Co ltd
Priority to CN202010159170.XA priority Critical patent/CN111415172A/en
Publication of CN111415172A publication Critical patent/CN111415172A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q30/00Commerce
    • G06Q30/018Certifying business or products
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06KGRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
    • G06K17/00Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
    • G06K17/0022Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device
    • G06K17/0025Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device the arrangement consisting of a wireless interrogation device in combination with a device for optically marking the record carrier

Abstract

The invention discloses an intelligent tracing method for monitoring the quality of a core board, which comprises the following steps: making a production plan according to the sales order, automatically decomposing the production plan into a bom table, and generating a purchase contract according to the bom table; in the purchasing link, raw materials are purchased according to a bom table, the raw materials are put in a bin to generate batch serial numbers, and the raw material information and the corresponding batch serial numbers are uploaded to a cloud platform and then recorded to a first database; in the production link, raw materials are called out from a warehouse according to a production plan, raw material information in a first database is updated in real time, and processing information of core plate products, raw material information adopted by the core plate products and batch serial numbers are uploaded to a cloud platform and then recorded to a second database; and in the quality inspection link, testing the core board product by adopting the testing system, adding the testing information to a second database, and then building a traceability platform according to the second database. The core board is visually displayed to the merchant through the traceability platform, so that the whole manufacturing period of the core board is transparent and public.

Description

Intelligent tracing method for monitoring core board quality
Technical Field
The invention belongs to the technical field of information tracing, and particularly relates to an intelligent tracing method for monitoring the quality of a core board.
Background
The core board packages the core functions of the processor on an electronic mainboard, and most of the core boards integrate a CPU, a memory, universal functional pins and the like, and are matched with the bottom board in a patch, golden finger or direct insertion mode to meet the performance requirements of various products. Therefore, the core board is more widely applied to various products.
The core plate is used for the production of all kinds of products in big purchase of trade company, generally, is equipped with two-dimensional code or bar code on the core plate packing, records this core plate's producer, model, place of production and production time etc. and content is comparatively brief, is difficult to relate to the raw materials information and the detection information of core plate for the trade company is difficult to trace back this core plate's quality condition. When a quality problem occurs with a large number of core boards, the business loses confidence in using the core boards. Therefore, a traceability system for monitoring the whole manufacturing cycle of the core board is urgently needed, and a merchant can acquire specific information of the core board in each manufacturing link at any time so as to ensure that the core board is good in quality.
Disclosure of Invention
The invention aims to solve the technical problem that the existing core board quality monitoring system is incomplete, and provides an intelligent traceability method for monitoring the quality of a core board.
In order to solve the problems, the invention is realized according to the following technical scheme:
the invention provides an intelligent tracing method for monitoring the quality of a core board, which comprises the following steps:
s1, making a production plan according to the sales order, automatically decomposing the production plan into a bom table, and generating a purchase contract according to the bom table;
s2, purchasing raw materials according to the bom table in a purchasing link, warehousing the raw materials to generate batch serial numbers, uploading the raw material information and the corresponding batch serial numbers to a cloud platform, and recording the raw material information and the corresponding batch serial numbers to a first database;
s3, calling raw materials from a warehouse according to a production plan in a production link, processing the raw materials to obtain a core board product, updating the raw material information in the first database in real time, uploading the processing information of the core board product, the raw material information adopted by the core board product and the batch number to a cloud platform, and recording the processing information, the raw material information and the batch number of the core board product to a second database;
and S4, testing the core board product by adopting the testing system in the quality inspection link, adding the testing information to a second database, and then building a traceability platform according to the second database.
Further, in step S4, the source tracing platform includes:
selecting a traceability system server, selecting a server with corresponding configuration according to the requirements of data storage and analysis, and deploying the intelligent traceability system into the server;
installing a bar code printer, installing the two-dimensional code printer in a packaging link after the quality inspection of the core board, directly connecting the two-dimensional code printer to a traceability system server through the Internet, acquiring main traceability information, automatically generating a two-dimensional code and automatically tracing and printing the two-dimensional code on the package of a product;
setting and connecting an information system, namely setting an Alpro system, periodically exporting required data, uploading the data to a traceability system server, creating a remote account for the traceability system to access a database of the ERP system, directly connecting the traceability system with the database of the ERP system, and acquiring related traceability information from a related table;
in the query of the traceability system, a consumer scans the two-dimensional code of the product package by using a terminal device, the terminal device uploads the two-dimensional code identification of the product to a network, and then traceability information of the product is acquired from a database of the traceability system according to the identification and downloaded, so that raw material information, processing information and test information of the product are displayed.
Further, in step S4, the testing system automatically tests the same batch of core products, and if the core board products pass through the testing system, the core board products are placed in a qualified warehouse; and if the core board product does not pass through the test system for three times, the core board product is placed in the unqualified bin.
Further, the test information includes an interface test, a SATA function test, an aging test, and a stability test of the core board product.
Further, in step S2, the raw material information includes a raw material manufacturer, a purchase date, and physical and chemical properties of the raw material.
Further, in step S3, MRP calculation is performed based on the bom table of each product, the calculation result is compared with the first database, whether or not all the raw materials used for the product are sufficient is determined, and if the raw materials are sufficient, the core board is processed and molded, and if the raw materials are insufficient, a purchase contract is created based on the bom table and purchased.
Further, the processing information comprises product attributes, a manufacturing process, manufacturing time, bom table conversion rate and processing performance.
Compared with the prior art, the invention has the beneficial effects that:
1. transparent to the public: the intelligent traceability system discloses the whole manufacturing links of the core board from purchasing, processing and quality inspection to the government and consumers through the internet, and the consumers can quickly and conveniently inquire all the information of the core board adopted by the consumers.
2. Intelligentization: in the whole tracing process, a full-automatic method is almost adopted to collect data, so that the number of participated personnel is small, the efficiency is high, and the cost is effectively saved.
3. The information is complete: the intelligent traceability system has numerous tracing links and large amount of included information, and almost all information of the whole production week of the core board is collected into the traceability system.
4. The practicability is as follows: the intelligent traceability system can realize the visualization of the quality flow monitoring of various core boards, has great use value for various electronic commodities, is convenient for finding problems in time, effectively reduces loss, greatly promotes the rapid development of the embedded core board industry, and enables the management of purchasing, processing and quality inspection to be standardized and standardized. The intelligent traceability is open to the outside through the Internet, and omnibearing and multi-angle services are provided for enterprises, governments and the public.
Drawings
Embodiments of the invention are described in further detail below with reference to the attached drawing figures, wherein:
FIG. 1 is a flow chart of the intelligent traceability method of the present invention.
Detailed Description
The preferred embodiments of the present invention will be described in conjunction with the accompanying drawings, and it will be understood that they are described herein for the purpose of illustration and explanation and not limitation.
Fig. 1 is a preferred flowchart of an intelligent traceability method for monitoring the core board quality according to the present invention.
The manufacturing process of the core board comprises a selling link, a raw material purchasing link, a processing and manufacturing link and a quality detection link, wherein in the selling link, a sales department worker designs the structure and wiring of the core board in an individualized way according to the sales plan and the customer requirements, and a production plan is made according to the core board; the raw material purchasing link is used for purchasing periodically according to the materials of the core board, and the raw materials include but are not limited to a single chip microcomputer, a resistor, a capacitor, an optical coupler, a relay, a controller, a mutual inductor, an operational amplifier and other chips, and the information of the purchased raw materials is recorded and uploaded; the processing and manufacturing link comprises a conventional processing technology, and various raw materials are manufactured into core plate products according to design drawings; in the quality detection link, the test system designed and researched by the application automatically tests the core boards in large batch, and records and uploads detection information.
Furthermore, the quality detection link comprises interface detection of the core board, operation detection of each element, stability detection of the core board and aging detection, wherein the stability detection of the core board refers to the Chinese invention patent with the publication number of CN110673023A, a plurality of current detection circuits are arranged in the testing device, the current detection circuits are used for simultaneously collecting the currents output by the plurality of core boards during starting, the currents are converted into digital signals and then fed back to a control unit of the testing device, whether the current values of the core boards are within the respective standard value ranges is intelligently detected, the trouble that instruments such as an ammeter or a universal meter are adopted to detect the plurality of core boards one by one is avoided, and the synchronous detection of the plurality of core boards is realized. The chinese utility model patent that nuclear core plate ageing testing reference publication is CN209992620U, through the power control circuit who is equipped with control circuit switch-on or disconnection between nuclear core plate and working power supply, adopt the instantaneous current value of current detection circuit intelligent measurement nuclear core plate simultaneously, when the current value that detects nuclear core plate surpasses normal value or maximum rated current, power control circuit breaks off working power supply at once and is connected with this nuclear core plate, prevent that the heavy current from continuing to flow through and puncturing the chip behind the nuclear core plate, effectively protect nuclear core plate chip not punctured by transient heavy current in ageing testing. The quality of the automatic test core board can effectively reduce the labor cost, and meanwhile, the core board avoids serious quality problems and improves the use confidence of customers.
Specifically, the intelligent tracing method specifically includes the following steps:
and S100, making a production plan according to the sales order, automatically decomposing the production plan into a bom table, and generating a purchase contract according to the bom table.
After the sales department signs an order, the technical department designs and develops a relevant core board according to the customer requirements, and formulates a production plan according to the delivery deadline of a sales order and other requirements of the product, wherein the production plan comprises production date, production duration, technical responsible persons, project content, raw materials and expenditure budget, the production plan is automatically decomposed into a bom table according to the production plan, the attribute of the core board product such as material details, suppliers and purchasing information is recorded on the bom table in detail, a purchasing contract is automatically drawn and generated according to the bom table, and the raw materials are purchased in a mailing or mail mode.
S200, raw materials are purchased according to a bom table in a purchasing link, the raw materials are put in a bin to generate batch serial numbers, and the raw material information and the corresponding batch serial numbers are uploaded to a cloud platform and then recorded to a first database.
The raw material information comprises but is not limited to raw material manufacturers, purchase dates, physical attributes and chemical attributes of the raw materials, the raw materials are respectively stored in corresponding warehouse bins and then are marked by using bar codes or RFID, and the raw material information and batch serial numbers of the raw materials are uploaded to a cloud platform and then are stored in a first database.
S300, in the production link, the raw materials are called out from the warehouse according to the production plan and are used for processing and manufacturing the core plate product, the raw material information in the first database is updated in real time, and the processing information of the core plate product, the adopted raw material information and the batch number are uploaded to the cloud platform and then recorded in the second database.
Specifically, MRP calculation is carried out according to a bom table of each product, the calculation result is compared with a first database, whether all raw materials adopted by the product are sufficient or not is judged, if the raw materials are sufficient, the core board is machined and molded, and if the raw materials are insufficient, a purchase contract is generated according to the bom table for purchase.
Meanwhile, the production condition of the core board is monitored in real time according to the consultation of the client, if delay occurs or the core board is influenced by the lack of raw materials, the production schedule is fed back to the system for automatically adjusting in time, and the economic loss caused by delivery delay is avoided.
S400, testing the core board product by adopting the testing system in the quality inspection link, adding the testing information to a second database, and then building a traceability platform according to the second database.
Furthermore, the test information comprises interface test, SATA function test, aging test and stability test of the core board product, each core board obtains the test information through a special test system, and the test information is uploaded to a second database, so that the second database stores the complete quality cycle from purchasing to processing and manufacturing to quality inspection of the core board, and a traceability platform is established according to the second database.
The tracing platform comprises the following specific steps:
s401, selecting a traceability system server, selecting a correspondingly configured server according to the requirements of data storage and analysis, and deploying the intelligent traceability system into the server;
s402, installing a bar code printer, wherein the two-dimensional code printer is installed in a packaging link after the quality inspection of a core board, is directly connected to a traceability system server through the Internet, acquires main traceability information, automatically generates a two-dimensional code and automatically traces the two-dimensional code and automatically prints the two-dimensional code on the package of a product;
s403, setting and connecting an information system, setting an Alpro system, periodically exporting required data, uploading the data to a traceability system server, creating a remote account for the traceability system to access a database of the ERP system, directly connecting the traceability system with the database of the ERP system, and acquiring related traceability information from a related table;
s404, inquiring the traceability system, wherein a consumer scans the two-dimensional code of the product package by using a terminal device, the terminal device uploads the two-dimensional code identification of the product to a network, and then traceability information of the product is acquired from a database of the traceability system according to the identification and downloaded, and raw material information, processing information and test information of the product are displayed.
Other structures of the intelligent tracing method for monitoring the quality of the core board described in this embodiment are referred to in the prior art.
The above description is only a preferred embodiment of the present invention, and is not intended to limit the present invention in any way, so that any modification, equivalent change and modification made to the above embodiment according to the technical spirit of the present invention are within the scope of the technical solution of the present invention.

Claims (7)

1. An intelligent tracing method for monitoring the quality of a core board is characterized by comprising the following steps:
s1, making a production plan according to the sales order, automatically decomposing the production plan into a bom table, and generating a purchase contract according to the bom table;
s2, purchasing raw materials according to the bom table in a purchasing link, warehousing the raw materials to generate batch serial numbers, uploading the raw material information and the corresponding batch serial numbers to a cloud platform, and recording the raw material information and the corresponding batch serial numbers to a first database;
s3, calling raw materials from a warehouse according to a production plan in a production link, processing the raw materials to obtain a core board product, updating the raw material information in the first database in real time, uploading the processing information of the core board product, the raw material information adopted by the core board product and the batch number to a cloud platform, and recording the processing information, the raw material information and the batch number of the core board product to a second database;
and S4, testing the core board product by adopting the testing system in the quality inspection link, adding the testing information to a second database, and then building a traceability platform according to the second database.
2. The intelligent traceability method for monitoring the quality of a core board of claim 1, wherein: in step S4, the source tracing platform includes:
selecting a traceability system server, selecting a server with corresponding configuration according to the requirements of data storage and analysis, and deploying the intelligent traceability system into the server;
installing a bar code printer, installing the two-dimensional code printer in a packaging link after the quality inspection of the core board, directly connecting the two-dimensional code printer to a traceability system server through the Internet, acquiring main traceability information, automatically generating a two-dimensional code and automatically tracing and printing the two-dimensional code on the package of a product;
setting and connecting an information system, namely setting an Alpro system, periodically exporting required data, uploading the data to a traceability system server, creating a remote account for the traceability system to access a database of the ERP system, directly connecting the traceability system with the database of the ERP system, and acquiring related traceability information from a related table;
in the query of the traceability system, a consumer scans the two-dimensional code of the product package by using a terminal device, the terminal device uploads the two-dimensional code identification of the product to a network, and then traceability information of the product is acquired from a database of the traceability system according to the identification and downloaded, so that raw material information, processing information and test information of the product are displayed.
3. The intelligent traceability method for monitoring the quality of a core board of claim 1, wherein: in step S4, the test system automatically tests the same batch of core products, and if the core board products pass through the test system, the core board products are placed in a qualified warehouse; and if the core board product does not pass through the test system for three times, the core board product is placed in the unqualified bin.
4. The intelligent traceability method for monitoring the quality of the core board as claimed in claim 3, wherein: the test information comprises an interface test, an SATA function test, an aging test and a stability test of the core board product.
5. The intelligent traceability method for monitoring the quality of a core board of claim 1, wherein: in step S2, the raw material information includes a raw material manufacturer, a purchase date, and physical and chemical properties of the raw material.
6. The intelligent traceability method for monitoring the quality of a core board of claim 1, wherein: in step S3, MRP calculation is performed according to the bom table of each product, the calculation result is compared with the first database, whether all the raw materials used for the product are sufficient is determined, if the raw materials are sufficient, the core board is processed and molded, and if the raw materials are insufficient, a purchase contract is generated according to the bom table for purchase.
7. The intelligent traceability method for monitoring the quality of the core board as claimed in claim 6, wherein: the processing information comprises product attributes, a manufacturing process, manufacturing time, bom table conversion rate and processing performance.
CN202010159170.XA 2020-03-09 2020-03-09 Intelligent tracing method for monitoring core board quality Pending CN111415172A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010159170.XA CN111415172A (en) 2020-03-09 2020-03-09 Intelligent tracing method for monitoring core board quality

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010159170.XA CN111415172A (en) 2020-03-09 2020-03-09 Intelligent tracing method for monitoring core board quality

Publications (1)

Publication Number Publication Date
CN111415172A true CN111415172A (en) 2020-07-14

Family

ID=71494298

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010159170.XA Pending CN111415172A (en) 2020-03-09 2020-03-09 Intelligent tracing method for monitoring core board quality

Country Status (1)

Country Link
CN (1) CN111415172A (en)

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106447005A (en) * 2016-11-28 2017-02-22 江苏中利电子信息科技有限公司 Bar code printing tracing system
CN106529871A (en) * 2016-10-28 2017-03-22 上海福赛特机器人有限公司 Intelligent manufacturing method and system

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106529871A (en) * 2016-10-28 2017-03-22 上海福赛特机器人有限公司 Intelligent manufacturing method and system
CN106447005A (en) * 2016-11-28 2017-02-22 江苏中利电子信息科技有限公司 Bar code printing tracing system

Similar Documents

Publication Publication Date Title
CN109906467B (en) Information management system
CN201143502Y (en) Device for testing, analyzing and counting bar-code
CN107516137B (en) Intelligent ammeter manufacturing data acquisition system
JPH1091236A (en) System and method for set history management using bar code system
US20060116778A1 (en) On-line statistical process control information system and method
KR102140731B1 (en) System implementing smart factory
KR20090001710A (en) A system for managing the process of manufacture
CN101907696A (en) Electric energy meter production detecting system and method
CN112116364A (en) Production and manufacturing tracing system and platform
CN112258053A (en) Method for producing formula food for special medical application by using manufacturing execution system
CN109344981A (en) A kind of detection device management system based on Internet of Things
Liu et al. Applications of RFID technology for improving production efficiency in an integrated-circuit packaging house
CN106127492A (en) Agricultural product traceability system
CN114596055A (en) Digital MES management method and system
CN107862485B (en) Comprehensive management platform of crushing equipment
WO2002057988A2 (en) Method, apparatus and system for quality performance evaluation of a supplier base
CN111415172A (en) Intelligent tracing method for monitoring core board quality
CN112381555A (en) Production and quality inspection method based on two-dimensional code
KR101166101B1 (en) statistical quality test and management system
CN111523805A (en) Method and device for inspecting incoming goods
CN110322195A (en) A kind of food materials management system
KR100920909B1 (en) System for auto sorter/shipment in agricultural products
CN114611890A (en) Jig data management method, device, equipment and storage medium
KR102102591B1 (en) System implementing smart factory
KR101091103B1 (en) Manufactures history pursuiting system

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