CN108984760B - Application system for realizing centralized management and control of outer packaging labels, automatic printing as required and automatic detection of production parameters - Google Patents

Abstract

The invention discloses an application system that realizes centralized management and control of outer packaging labels, automatic printing on demand and automatic detection of production parameters. It uses a B/S architecture and includes a central service program and a system subunit, and the system subunit includes a system web page application. , Packing station client, label management client, the system web application includes a web service request module for accepting label download and upload from each client, a report query function module, and a cross query function module for box numbers and product serial numbers. The present invention can realize unified management, control and distribution of label templates.

Description

A kind of centralized control of outer packaging labels and automatic printing on demand and production parameters Automatically detected application system

technical field

The invention relates to the technical field of application systems, in particular to an application system that realizes centralized management and control of outer packaging labels, automatic printing on demand and automatic detection of production parameters.

Background technique

The auto parts industry adopts the pull-type production mode. The usual practice is that when the product is shipped, the warehouse will arrange for personnel to print the outer box label. The second is that the warehouse will print a variety of outer packaging labels corresponding to different products in advance.

In the former mode, additional shift labor costs are added due to shipping requirements; in the second mode, unnecessary label printing waste is caused due to the change of production lines. Moreover, in the two modes, due to manual label printing, there will be human error, and the wrong label template will be used, which will lead to customer complaints; another important point, the product serial number cannot be accurately matched with the packaging box number. When product quality problems occur Product and batch information cannot be pinpointed, adding additional cost of picking and recalling problematic products.

SUMMARY OF THE INVENTION

In order to solve the problems existing in the above background technology, the purpose of the present invention is to provide an application system that realizes centralized management and control of outer packaging labels, automatic printing on demand and automatic detection of production parameters, so as to achieve the purpose of unified management, control and distribution of label templates. .

For achieving the above object, technical scheme of the present invention is as follows:

An application system that realizes centralized management and control of outer packaging labels, automatic printing on demand and automatic detection of production parameters, using B/S architecture, including a central service program and a system sub-unit, the system sub-unit includes a system web application, a packaging station A client and a label management client, the system webpage application includes a webpage service request module for accepting label download and upload from each client, a report query function module, and a cross query function module for box numbers and product serial numbers;

The packaging station client includes the following steps: 1) Automatically download the label template and corresponding product error-proofing requirements from the central server according to the product model and customer information; 2) After the production line workers use the scanner to read the product serial number, carry out the process. The uniqueness of the label serial number is confirmed and the error-proof verification is carried out according to the error-proofing requirements, and the number is automatically counted and reported by voice; 3) The label is automatically printed after the packing box is full, and the corresponding relationship between the generated box serial number and the product label is stored; 4) With ERP The system transmits data and updates ERP material information;

The label management client includes the following steps: 1) Packaging engineers define product information in the system; 2) Design label templates according to different product packaging box label drawing requirements of different customers; 3) Process engineers define different anti-virus products for different products. wrong demand.

Preferably, the webpage service request module that accepts the label download and upload of each client is to use WebSerivce, and the interface is provided as follows: the token defined by the GetDataBaseConnection interface is used as client verification, and the database connection string is returned to the client for use; DownloadLabel accepts the item number ( Model), customer information (CustomerCode), line code (LineCode), and return the bytes stream of the corresponding codesoft label template.

Preferably, the report query function module selects a corresponding line and a corresponding time period for the front end of the web page, communicates with the server through an asynchronous http request, the server returns JSON data format, and the front end uses jquerytable and highcharts to render data tables and trend charts.

Preferably, the cross query function module of the box number and the product serial number is that the front-end user of the web page can select the box number or the product serial number, and after inputting the information, send a query request to the server through ajax, and the server retrieves from the packaging relationship table according to the content, Return the corresponding data result to the front end.

Preferably, the specific steps of the packaging station client step 1) are:

A. The system database defines the item number (Model), customer information (CustomerCode) and line code (LineCode);

B. The client selects the material number, customer number and line code according to the specific situation when performing packaging operations;

C. At this time, the program matches the label template name from the system database according to the combination of the above three factors, and then downloads the corresponding template from the web page service provided by the web page system A and stores it in the local folder;

D. At the same time, according to the above three factors, the corresponding part number information is retrieved from the database, and the error-proof content is pre-loaded in the system memory.

Preferably, the specific steps of step 2) of the packaging station client are:

A. After the serial number is scanned into the program, the program (controller) judges the current state. If there is no packaging in progress, the packaging variable is initialized in the system, and the target quantity is initialized according to the product customer definition;

B. Serial number uniqueness verification, the system will store the part serial number for each scan in the data table of the system, and then confirm the uniqueness of the part number scanned each time. This is;

C. Use regular expressions to match part coding rules. If the regular expression rules have not been defined for the part number, it will be automatically skipped;

D. Use the defined production process parameters to prevent errors. Error prevention defines the database connection, the executed database stored procedure, and again the expected value returned by the stored procedure. When the product serial number is passed as a parameter to the stored procedure and executed in the defined database , get the return value and compare it with the set expected value;

E. After the above verifications are passed, the batch information and product serial number of the box are stored in the database, and the target number of packaging boxes is set according to the product and customer requirements. If the actual number in the box has reached the set number, the drive The printer prints the label.

Preferably, the specific steps of step 4) of the packaging station client are: the quantity of each box and the corresponding material number information will be sent to the designated ftp directory of the QAD system in csv file format, and the QAD server will be regularly scripted to read the file and upload the account .

Preferably, the specific steps of step 2) of the label management client are: upload the codesoft template to the server using webservice, the CodeSoft template supports variables, and the C# program can call CodeSoft's DLL to assign variables, so as to realize on-demand printing , such as time variables, can be automatically assigned to the current one when printing labels.

Preferably, the specific steps of step 3) of the label management client are:

A. Packaging or product engineers can define coding rules for part serial numbers. The program can match and verify the serial number of each part, and use regular expressions to configure. The configuration interface includes the specified model, customer number, line type, and regular expressions;

B. The process engineer specifies the value to be verified, executes the database storage process and target value, and the production data is stored in a specific database. When configuring error proofing, specify the target value, such as [Data006] data in the database of a certain part The value is "K810400162", so that the SQL statement to be executed can be defined in the database in the following way, and then the obtained value is compared with the defined value;

C. Configure the error-proof interface, including specifying the item number, customer number, line type, database connection used, executed statements, preparing stored procedures in the database, and target values.

Through the above technical solutions, the present invention provides an application system that realizes centralized management and control of outer packaging labels, automatic printing on demand and automatic detection of production parameters. By establishing a central service program, unified management, control and distribution of label templates can be realized. Process, confirm the parameter status of a specific station in the production system, and the interception function that can achieve the blacklist of product serial numbers.

Detailed ways

The technical solutions in the embodiments of the present invention will be clearly and completely described below.

The invention provides an application system that realizes centralized management and control of outer packaging labels, automatic printing on demand and automatic detection of production parameters. It uses a B/S architecture and includes a central service program and a system subunit, and the system subunit includes a system web page application. , a packaging station client, a label management client, the system web application includes a web service request module that accepts label downloads and uploads from each client, a report query function module, and a cross query function module for box numbers and product serial numbers. The web service request module that accepts the label download and upload of each client is to use WebSerivce, and the interface is provided as follows: The token defined by the GetDataBaseConnection interface is used as the client authentication, and returns the database connection string for the client to use; DownloadLabel accepts the material number (Model), customer information (CustomerCode), line code (LineCode), returns the bytes stream of the corresponding codesoft label template, the report query function module selects the corresponding line type and corresponding time period for the front end of the web page, communicates with the server through an asynchronous http request, and the server returns JSON data format, the front-end uses jquerytable and highcharts to render data tables and trend charts, the cross query function module of box number and product serial number is the front-end web page user can select the box number or product serial number, after inputting the information, send the query to the server through ajax Request, the server retrieves from the packaging relationship table according to the content, and returns the corresponding data results to the front end;

The packaging station client includes the following steps:

1) Automatically download label templates and corresponding product error-proofing requirements from the central server according to the product model and customer information. The specific steps are:

A. The system database defines the item number (Model), customer information (CustomerCode) and line code (LineCode);

B. The client selects the material number, customer number and line code according to the specific situation when performing packaging operations;

C. At this time, the program matches the label template name from the system database according to the combination of the above three factors, and then downloads the corresponding template from the web page service provided by the web page system A and stores it in the local folder;

D. At the same time, according to the above three factors, the corresponding part number information is retrieved from the database, and the error-proof content is preloaded in the system memory;

2) After the production line workers use the scanner to read the product serial number, the uniqueness of the label serial number is confirmed and the error-proof verification is carried out according to the error-proofing requirements. At the same time, the number is automatically counted and reported by voice. The specific steps are:

A. After the serial number is scanned into the program, the program (controller) judges the current state. If there is no packaging in progress, the packaging variable is initialized in the system, and the target quantity is initialized according to the product customer definition;

B. Serial number uniqueness verification, the system will store the part serial number for each scan in the data table of the system, and then confirm the uniqueness of the part number scanned each time. This is;

C. Use regular expressions to match part coding rules. If the regular expression rules have not been defined for the part number, it will be automatically skipped;

D. Use the defined production process parameters to prevent errors. Error prevention defines the database connection, the executed database stored procedure, and again the expected value returned by the stored procedure. When the product serial number is passed as a parameter to the stored procedure and executed in the defined database , get the return value and compare it with the set expected value;

E. After the above verifications are passed, the batch information and product serial number of the box are stored in the database, and the target number of packaging boxes is set according to the product and customer requirements. If the actual number in the box has reached the set number, the drive The printer outputs the label;

3) Automatically print the label when the box is full, and store the corresponding relationship between the serial number of the box and the product label;

4) Data transmission with the ERP system to update the ERP material information. The specific steps are: the quantity of each box and the corresponding material number information will be sent to the designated ftp directory of the QAD system in csv file format, and the file will be read by a regular script on the QAD server upload account;

The label management client includes the following steps:

1) Packaging engineers define product information in the system;

2) Design the label template according to the different product packaging box label drawing requirements of different customers. The specific steps are: upload the codesoft template to the server using webservice, the CodeSoft template supports variables, and the C# program can call CodeSoft's DLL method to assign variables , so as to realize on-demand printing, such as time variables, when printing labels, you can automatically assign the current value;

3) Process engineers define different error-proofing requirements for different products. The specific steps are:

A. Packaging or product engineers can define coding rules for part serial numbers. The program can match and verify the serial number of each part, and use regular expressions to configure. The configuration interface includes the specified model, customer number, line type, and regular expressions;

B. The process engineer specifies the value to be verified, executes the database storage process and target value, and the production data is stored in a specific database. When configuring error proofing, specify the target value, such as [Data006] data in the database of a certain part The value is "K810400162", so that the SQL statement to be executed can be defined in the database in the following way, and then the obtained value is compared with the defined value;

C. Configure the error-proof interface, including specifying the item number, customer number, line type, database connection used, executed statements, preparing stored procedures in the database, and target values.

Each packaging station in this system automatically obtains the latest label template from the server for printing according to the product model produced by the production line, and binds the product serial number in the box to the batch serial number of the outer box when printing the packaging label, which is convenient Inquiry and traceability; centralized control and distribution of outer box labels, reducing the complexity and workload of packaging engineers for label maintenance; client-side label printing, saving the labor of printing labels when shipping from the warehouse, and saving redundant The customer can realize the error proofing based on the product process definition, and realize the final error proofing from the product to the customer.

This system realizes the binding of the batch sequence of the outer box and the product serial number, which can quickly locate the product serial number when there is a problem with the product, and solve the problem quickly. Status updates and report presentations.

The invention discloses an application system that realizes centralized management and control of outer packaging labels, automatic printing on demand and automatic detection of production parameters. By establishing a central service program, unified management, control and distribution of label templates can be realized, and the production system can also be confirmed according to the technological process. The parameter status of a specific station, and the interception function that can achieve a blacklist of product serial numbers.

The above description of the disclosed embodiments enables any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (8)

1. An application system that realizes centralized management and control of outer packaging labels and automatic printing on demand and automatic detection of production parameters, using B/S architecture, is characterized in that, including a central service program and a system subunit, and the system subunit includes a system A web application, a packaging station client and a label management client, the system web application includes a web service request module for accepting label download and upload from each client, a report query function module, and a cross query function module for box numbers and product serial numbers; The packaging station client includes the following steps: 1) automatically download the label template and the corresponding product error-proofing requirements from the central server according to the product model and customer information; 2) after the production line worker reads the product serial number using a scanner gun, carry out the process. The uniqueness of the label serial number is confirmed and the error-proof verification is carried out according to the error-proofing requirements, and the number is automatically counted and reported by voice; 3) The label is automatically printed after the packing box is full, and the corresponding relationship between the generated box serial number and the product label is stored; 4) With ERP The system transmits data and updates ERP material information; The label management client includes the following steps: 1) The packaging engineer defines product information in the system; 2) The label template is designed according to the different product packaging box label drawing requirements of different customers; 3) The process engineer defines different anti-protection methods for different products. wrong demand; Described packing station client step 1) The concrete steps are: A. The system database defines the item number, customer information and line classification; B. The client selects the material number, customer number and line code according to the specific situation when performing packaging operations; C. At this time, the program matches the label template name from the system database according to the combination of the above three factors, and then downloads the corresponding template from the web page service provided by the web page system A and stores it in the local folder; D. At the same time, according to the above three factors, the corresponding part number information and error prevention content are retrieved from the database and preloaded in the system memory. 2. An application system for realizing centralized management and control of outer packaging labels, automatic printing on demand and automatic detection of production parameters according to claim 1, characterized in that the web service request module for accepting label download and uploading of each client In order to use WebSerivce, the interface is provided as follows: The token defined by the GetDataBaseConnection interface is used as client authentication, and returns the database connection string for the client to use; DownloadLabel accepts the item number, customer information, and line code, and returns the bytes stream of the corresponding codesoft label template. 3. An application system for realizing centralized management and control of outer packaging labels, automatic printing on demand and automatic detection of production parameters according to claim 2, characterized in that the report query function module selects the corresponding line and line type for the front end of the webpage. In the corresponding time period, the server communicates with the server through an asynchronous http request, the server returns the JSON data format, and the front end uses jquerytable and highcharts to render the data table and trend chart. 4. An application system for realizing centralized management and control of outer packaging labels, automatic printing on demand and automatic detection of production parameters according to claim 3, wherein the cross query function module of the box number and the product serial number is a web front end The user can select the box number or the product serial number. After entering the information, a query request is sent to the server through ajax. The server retrieves the package relationship table according to the content and returns the corresponding data results to the front end. 5. A kind of application system for realizing centralized management and control of outer packaging labels and automatic printing on demand and automatic detection of production parameters according to claim 1, it is characterized in that, described packing station client step 2) concrete steps are: A. After the serial number is scanned into the program, the program judges the current state. If there is no packaging in progress, the packaging variable is initialized in the system, and the target quantity is initialized according to the product customer definition; B. Serial number uniqueness verification, the system will store the part serial number for each scan in the data table of the system, and then confirm the uniqueness of the part number scanned each time. This is; C. Use regular expressions to match part coding rules. If the regular expression rules have not been defined for the part number, it will be automatically skipped; D. Use the defined production process parameters to prevent errors. Error prevention defines the database connection, the executed database stored procedure, and again the expected value returned by the stored procedure. When the product serial number is passed as a parameter to the stored procedure and executed in the defined database , get the return value and compare it with the set expected value; E. After the above verifications are passed, the batch information and product serial number of the box are stored in the database, and the target number of packaging boxes is set according to the product and customer requirements. If the actual number in the box has reached the set number, the drive The printer prints the label. 6. A kind of application system that realizes centralized management and control of outer packaging labels and automatic printing on demand and automatic detection of production parameters according to claim 5, it is characterized in that, described packaging station client step 4) The specific steps are: each The number of boxes and the corresponding part number information will be sent to the designated ftp directory of the QAD system in csv file format, and the file upload account will be read regularly by the script on the QAD server. 7. a kind of application system that realizes the centralized management and control of outer packaging labels and automatic printing on demand and automatic detection of production parameters according to claim 1, it is characterized in that, described label management client step 2) concrete steps are: codesoft The template is uploaded to the server using webservice. The CodeSoft template supports variables. The C# program can call CodeSoft's DLL to assign variables to realize on-demand printing. 8. A kind of application system for realizing centralized management and control of outer packaging labels and automatic printing on demand and automatic detection of production parameters according to claim 3, it is characterized in that, described label management client step 3) concrete steps are: A. Packaging or product engineers can define coding rules for part serial numbers. The program can match and verify the serial number of each part, and use regular expressions to configure. The configuration interface includes the specified model, customer number, line type, and regular expressions; B. The process engineer specifies the value to be verified, executes the database storage process and the target value, and stores the production data in a specific database. When configuring error prevention, specify the target value, and then compare the obtained value with the defined value; C. Configure the error-proof interface, including specifying the item number, customer number, line type, database connection used, executed statements, preparing stored procedures in the database, and target values.