CN110716937A - Batch printing method and system for quality inspection reports of assembly mode products - Google Patents
Batch printing method and system for quality inspection reports of assembly mode products Download PDFInfo
- Publication number
- CN110716937A CN110716937A CN201910971407.1A CN201910971407A CN110716937A CN 110716937 A CN110716937 A CN 110716937A CN 201910971407 A CN201910971407 A CN 201910971407A CN 110716937 A CN110716937 A CN 110716937A
- Authority
- CN
- China
- Prior art keywords
- assembly mode
- products
- parts
- quality inspection
- 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
Links
- 238000007689 inspection Methods 0.000 title claims abstract description 65
- 238000000034 method Methods 0.000 title claims abstract description 26
- 230000000295 complement effect Effects 0.000 claims 3
- 239000000047 product Substances 0.000 description 86
- 239000011265 semifinished product Substances 0.000 description 8
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/12—Digital output to print unit, e.g. line printer, chain printer
- G06F3/1201—Dedicated interfaces to print systems
- G06F3/1202—Dedicated interfaces to print systems specifically adapted to achieve a particular effect
- G06F3/1203—Improving or facilitating administration, e.g. print management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Human Computer Interaction (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- General Health & Medical Sciences (AREA)
- Manufacturing & Machinery (AREA)
- Software Systems (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- General Factory Administration (AREA)
- Inking, Control Or Cleaning Of Printing Machines (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a batch printing method and a system for quality inspection reports of assembled mode products, relating to the technical field of batch printing; establishing a matching table in a database, recording the structural relationship between the assembly mode product and the parts, and establishing association between the serial number of the assembly mode product and the information of the parts; inquiring corresponding information of all parts according to the serial numbers of the assembly mode products through a matching table, acquiring quality inspection reports of the assembly mode products and all parts, and realizing the whole set of batch printing of the quality inspection reports; the method can select the quality inspection report of the assembly mode product to be printed according to the incidence relation between the serial number of the assembly mode product and the part information in the matching table, is very flexible and convenient, does not need manual sorting, saves labor and time, and improves the working efficiency.
Description
Technical Field
The invention discloses a batch printing method and a batch printing system for quality inspection reports of assembled mode products, and relates to the technical field of batch printing.
Background
In the existing ERP management software and quality management software, printing of a quality inspection report as a final output file of a quality inspection result plays an important role in enterprise management. The existing quality management software can only print quality inspection reports one by one according to inspection result documents, the quality inspection reports of a model product are assembled according to quality requirements, the quality inspection reports of a finished product and each part need to be printed and output, and when the product has a complex composition relationship and the parts are more, the printing workload of the product quality inspection reports is huge. The invention provides a method and a system for printing quality inspection reports of assembly mode products in batches.A matching table is established in a database, the structural relationship between the assembly mode products and parts is recorded, and the serial numbers of the assembly mode products are associated with the information of the parts; and inquiring corresponding information of all parts according to the serial numbers of the assembly mode products through a matching table, acquiring quality inspection reports of the assembly mode products and all parts, and realizing the whole set of batch printing of the quality inspection reports, thereby solving the problem of printing the quality inspection reports in a set.
Disclosure of Invention
The invention provides a method and a system for printing quality inspection reports of assembled products in batches aiming at the problems in the prior art.
The specific scheme provided by the invention is as follows:
a batch printing method for quality inspection reports of assembly mode products comprises the steps of establishing a matching table in a database, recording the structural relationship between the assembly mode products and parts, and establishing association between the serial numbers of the assembly mode products and the information of the parts;
and inquiring corresponding information of all parts according to the serial numbers of the assembly mode products through a matching table, acquiring quality inspection reports of the assembly mode products and all parts, and realizing the whole set of batch printing of the quality inspection reports.
The method comprises the steps that a matching table comprises a main matching table and a sub matching table, wherein the main matching table stores the serial number of the product in the assembling mode, and the sub matching table stores the association relation between the serial number of the product in the assembling mode and the information of the parts.
According to the method, the serial number of the assembly mode product is transmitted into the printing control through the matching table, the printing control inquires corresponding information of all parts according to the serial number of the assembly mode product, and quality inspection reports of the assembly mode product and all parts are obtained.
In the method, the serial numbers of the assembly mode products are transmitted into a Fastreport printing control in an array form.
An assembly mode product quality inspection report batch printing system comprises a table building module and an acquisition printing module,
the table building module builds a matching table in a database, records the structural relationship between the assembly mode product and the parts, and builds association between the serial number of the assembly mode product and the information of the parts;
the acquisition printing module inquires corresponding information of all parts according to the serial numbers of the assembly mode products through the matching table, acquires quality inspection reports of the assembly mode products and all parts, and realizes the whole set of batch printing of the quality inspection reports.
The matching table in the table building module in the system comprises a main matching table and a sub matching table, wherein the main matching table stores the serial number of the product in the assembling mode, and the sub matching table stores the association relation between the serial number of the product in the assembling mode and the information of the parts.
The system comprises a printing module, a printing control and a quality inspection report, wherein the printing module is used for transmitting a serial number of an assembly mode product into the printing control through a matching table, the printing control inquires corresponding information of all parts according to the serial number of the assembly mode product, and the quality inspection report of the assembly mode product and all parts is obtained.
The serial number of the product in the assembly mode is transmitted to a Fastreport printing control in an array form by the acquisition printing module in the system.
The invention has the advantages that:
the invention provides a method and a system for printing quality inspection reports of assembly mode products in batches.A matching table is established in a database, the structural relationship between the assembly mode products and parts is recorded, and the serial numbers of the assembly mode products are associated with the information of the parts; inquiring corresponding information of all parts according to the serial numbers of the assembly mode products through a matching table, acquiring quality inspection reports of the assembly mode products and all parts, and realizing the whole set of batch printing of the quality inspection reports; the method can select the quality inspection report of the assembly mode product to be printed according to the incidence relation between the serial number of the assembly mode product and the part information in the matching table, is very flexible and convenient, does not need manual sorting, saves labor and time, and improves the working efficiency.
Drawings
FIG. 1 is a schematic flow diagram of the process of the present invention.
Detailed Description
The invention provides a batch printing method for quality inspection reports of assembly mode products, which comprises the steps of establishing a matching table in a database, recording the structural relationship between the assembly mode products and parts, and establishing association between the serial numbers of the assembly mode products and the information of the parts;
and inquiring corresponding information of all parts according to the serial numbers of the assembly mode products through a matching table, acquiring quality inspection reports of the assembly mode products and all parts, and realizing the whole set of batch printing of the quality inspection reports.
Meanwhile, the assembly mode product quality inspection report batch printing system corresponding to the method is provided, which comprises a table building module and an acquisition printing module,
the table building module builds a matching table in a database, records the structural relationship between the assembly mode product and the parts, and builds association between the serial number of the assembly mode product and the information of the parts;
the acquisition printing module inquires corresponding information of all parts according to the serial numbers of the assembly mode products through the matching table, acquires quality inspection reports of the assembly mode products and all parts, and realizes the whole set of batch printing of the quality inspection reports.
The present invention is further described below in conjunction with the following figures and specific examples so that those skilled in the art may better understand the present invention and practice it, but the examples are not intended to limit the present invention.
When the method is used for printing quality inspection reports in batches, a matching table is established in a database, the structural relationship between the assembly mode product and the parts is recorded, and the serial number of the assembly mode product is associated with the information of the parts;
the serial number of the assembly mode product is transmitted to a Fastreport printing control in an array form through a matching table, the printing control inquires corresponding all part information according to the serial number of the assembly mode product, and quality inspection reports of the assembly mode product and all parts are obtained to realize the whole set of batch printing of the quality inspection reports, for example, in the following service requirement scene, two semi-finished products (A, B) are respectively detected in the early stage, and corresponding inspection reports are obtained; the assembly of these two semi-finished products (A, B) with the other semi-finished product (C) is now required; the assembled finished product (D) is inspected, three semi-finished products (A, B, C) and the assembled finished product (D) need to be respectively detected in the inspection, the prior inspection report and the subsequent inspection report are obtained by utilizing the association relationship between the assembled product and the parts in the matching table by utilizing the method, and the batch printing can be realized, so that the working efficiency of inspection personnel is greatly improved.
In the above process, the matching table may be further refined, the matching table includes a main matching table CJSN storing the serial number of the assembly pattern product and a sub matching table cjsntem storing the association relationship between the serial number of the assembly pattern product and the part information, as shown in tables 1 and 2,
TABLE 1
| Name (R) | Column name | Data type | Null value | Default | Rules | Note |
| Product serial number ID | SNID | Varchar2(36) | No | Main key | ||
| Product serial number | SN | Varchar2(100) | ||||
| Product name | MC | Varchar2(100) | ||||
| Model number | XH | Varchar2(100) | ||||
| …… |
TABLE 2
| Name (R) | Column name | Data type | Null value | Default | Rules | Note |
| Product serial number ID | SNID | Varchar2(36) | No | External key | ||
| Component serial number | SN | Varchar2(100) | No | |||
| Name of parts | MC | Varchar2(100) | ||||
| Part model | XH | Varchar2(100) | ||||
| …… |
The serial number of the assembly mode product is transmitted into a Fastreport printing control in an array form through a main table and a sub table of a matching table, the printing control inquires corresponding all part information according to the serial number of the assembly mode product, and the quality inspection report of the assembly mode product and all parts is acquired to realize the whole set of batch printing of the quality inspection report, wherein the main codes are as follows:
when the system is used for printing quality inspection reports in batches, the table building module builds a matching table in a database, records the structural relationship between an assembly mode product and parts, and builds association between the serial number of the assembly mode product and the information of the parts;
the method comprises the steps that a printing module is obtained, serial numbers of assembly mode products are transmitted to a Fastreport printing control in an array mode through a matching table, the printing control inquires corresponding all part information according to the serial numbers of the assembly mode products, quality inspection reports of the assembly mode products and all parts are obtained, the whole set of batch printing of the quality inspection reports is achieved, for example, in the following service requirement scene, two semi-finished products (A, B) are detected respectively in the early stage, and corresponding inspection reports are obtained; the assembly of these two semi-finished products (A, B) with the other semi-finished product (C) is now required; the assembled finished product (D) is inspected, three semi-finished products (A, B, C) and the assembled finished product (D) need to be respectively detected in the inspection, the prior inspection report and the subsequent inspection report are obtained by utilizing the system of the invention through the incidence relation between the assembled product and the parts in the matching table, and the batch printing can be realized, thereby greatly improving the working efficiency of inspectors.
In the above process, the form building module may further perform form table refinement, where the form table includes a form table main table CJSN and a form table sub table cjsntem, the form table main table stores the serial number of the assembly pattern product, the form table sub table stores the association relationship between the serial number of the assembly pattern product and the part information, as in tables 1 and 2,
TABLE 1
| Name (R) | Column name | Data type | Null value | Default | Rules | Note |
| Product serial number ID | SNID | Varchar2(36) | No | Main key | ||
| Product serial number | SN | Varchar2(100) | ||||
| Product name | MC | Varchar2(100) | ||||
| Model number | XH | Varchar2(100) | ||||
| …… |
TABLE 2
| Name (R) | Column name | Data type | Null value | Default | Rules | Note |
| Product serial number ID | SNID | Varchar2(36) | No | External key | ||
| Component serial number | SN | Varchar2(100) | No | |||
| Name of parts | MC | Varchar2(100) | ||||
| Part model | XH | Varchar2(100) | ||||
| …… |
The method comprises the following steps that a printing module is acquired, a serial number of an assembly mode product is transmitted into a Fastreport printing control in an array form through a main table and a sub table of a matching table, the printing control inquires corresponding all part information according to the serial number of the assembly mode product, a quality inspection report of the assembly mode product and all parts is acquired, and a whole set of batch printing of the quality inspection report is realized, wherein main codes are as follows:
the system can also develop a matching table maintenance interface function in ERP software, and can be used for inputting, modifying and maintaining matching table data. If the application unit uses the production management software or MES software, the product assembly matching relation can be extracted from the production management software or MES through the interface without manual input.
The above-mentioned embodiments are merely preferred embodiments for fully illustrating the present invention, and the scope of the present invention is not limited thereto. The equivalent substitution or change made by the technical personnel in the technical field on the basis of the invention is all within the protection scope of the invention. The protection scope of the invention is subject to the claims.
Claims (8)
1. A method for printing quality inspection reports of assembly mode products in batches is characterized in that a matching table is established in a database, the structural relation between the assembly mode products and parts is recorded, and the serial numbers of the assembly mode products are associated with the information of the parts;
and inquiring corresponding information of all parts according to the serial numbers of the assembly mode products through a matching table, acquiring quality inspection reports of the assembly mode products and all parts, and realizing the whole set of batch printing of the quality inspection reports.
2. The method as claimed in claim 1, wherein the complement table includes a complement table main table storing serial numbers of the assembly pattern products and a complement table sub table storing association relations between the serial numbers of the assembly pattern products and the part information.
3. The method as claimed in claim 1 or 2, wherein the serial number of the assembly mode product is transmitted to the printing control through the matching table, and the printing control inquires the corresponding information of all the parts according to the serial number of the assembly mode product, so as to obtain the quality inspection report of the assembly mode product and all the parts.
4. The method as claimed in claim 3, wherein the serial numbers of the assembly mode products are transmitted in array form to the Fastreport print control.
5. An assembly mode product quality inspection report batch printing system is characterized by comprising a table building module and an acquisition printing module,
the table building module builds a matching table in a database, records the structural relationship between the assembly mode product and the parts, and builds association between the serial number of the assembly mode product and the information of the parts;
the acquisition printing module inquires corresponding information of all parts according to the serial numbers of the assembly mode products through the matching table, acquires quality inspection reports of the assembly mode products and all parts, and realizes the whole set of batch printing of the quality inspection reports.
6. The system of claim 5, wherein the configuration table in the build module comprises a main configuration table storing serial numbers of the assembly model products and a sub configuration table storing association relationships between the serial numbers of the assembly model products and the component information.
7. The system as claimed in claim 5 or 6, wherein the acquiring and printing module transmits the serial number of the assembly mode product to the printing control through the matching table, and the printing control queries the corresponding information of all the parts according to the serial number of the assembly mode product to acquire the quality inspection reports of the assembly mode product and all the parts.
8. The system as recited in claim 7, wherein the get print module passes serial numbers of assembly mode products in an array into the FastReport print control.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910971407.1A CN110716937A (en) | 2019-10-14 | 2019-10-14 | Batch printing method and system for quality inspection reports of assembly mode products |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910971407.1A CN110716937A (en) | 2019-10-14 | 2019-10-14 | Batch printing method and system for quality inspection reports of assembly mode products |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110716937A true CN110716937A (en) | 2020-01-21 |
Family
ID=69211515
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910971407.1A Pending CN110716937A (en) | 2019-10-14 | 2019-10-14 | Batch printing method and system for quality inspection reports of assembly mode products |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110716937A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101261571A (en) * | 2008-04-08 | 2008-09-10 | 中兴通讯股份有限公司 | Device and method for bulk printing packing bill |
| CN102737353A (en) * | 2011-04-08 | 2012-10-17 | 四川科伦药业股份有限公司 | System for generating drug inspection report |
| CN106648477A (en) * | 2015-12-30 | 2017-05-10 | 济南大陆机电股份有限公司 | Method for batch printing of commission sheet for measuring instrument |
| CN107943778A (en) * | 2017-12-15 | 2018-04-20 | 内蒙古蒙牛乳业（集团）股份有限公司 | The information-based method and system of examination and test of products report |
-
2019
- 2019-10-14 CN CN201910971407.1A patent/CN110716937A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101261571A (en) * | 2008-04-08 | 2008-09-10 | 中兴通讯股份有限公司 | Device and method for bulk printing packing bill |
| CN102737353A (en) * | 2011-04-08 | 2012-10-17 | 四川科伦药业股份有限公司 | System for generating drug inspection report |
| CN106648477A (en) * | 2015-12-30 | 2017-05-10 | 济南大陆机电股份有限公司 | Method for batch printing of commission sheet for measuring instrument |
| CN107943778A (en) * | 2017-12-15 | 2018-04-20 | 内蒙古蒙牛乳业（集团）股份有限公司 | The information-based method and system of examination and test of products report |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104991975B (en) | The data query method and its system of power business system | |
| CN109189016B (en) | Intelligent manufacturing integrated execution system | |
| CN110704880B (en) | Correlation method of engineering drawings | |
| CN102708213A (en) | Method for realizing BOM (Bill of Material) information transmission between PDM (Product Data Management) system and ERP (Enterprise Resource Planning) system | |
| CN104616104A (en) | Marine diesel engine component fast coding management system and management method | |
| DE102020208147A1 (en) | DATA FORMAT PREPARATION DEVICE, EDGE SERVER AND DATA FORMAT PREPARATION PROCESS | |
| CN106372944A (en) | Data table-based product tracing method and system | |
| CN104216987A (en) | Timestamp-based method for capturing incremental data and supporting delete operation | |
| CN103455516A (en) | Operation platform and maintaining method for database | |
| CN102436476A (en) | Three-dimensional information system based on combining three networks | |
| CN110716937A (en) | Batch printing method and system for quality inspection reports of assembly mode products | |
| CN102692908A (en) | Paperless workshop quality feedback method | |
| CN106570119A (en) | Device for quickly obtaining product information and method for obtaining product information | |
| CN110750559A (en) | Authority information processing method and device, storage medium and electronic device | |
| CN109582286A (en) | Data standard method of calibration and its device based on Freemarker technology | |
| CN106228378A (en) | The traceability system of automobile driving system | |
| CN110995466A (en) | Multi-format log unified processing method and system under security situation awareness system | |
| US20050125444A1 (en) | Report composer | |
| CN114219217B (en) | Parallel disassembly line setting method for non-merged priority relation matrix | |
| CN102968414A (en) | Efficient receipt logging method based on different field types | |
| CN110059215B (en) | Arrangement system suitable for rapid naming and filing of defect photos of power transmission line | |
| CN115309582A (en) | Data auditing method and device, electronic equipment and storage medium | |
| CN108563202A (en) | A kind of data input emergency system and its processing method based on MES | |
| CN110163316A (en) | A kind of with no paper retroactive method of auto parts | |
| CN111428949A (en) | Workshop manufacturing management system and method |
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 |