A sequence code generation method and system

Abstract

The application belongs to the field of Internet of Things, and discloses a sequence code generation method, which comprises the following steps: step 1, configuring related basic information for generating a sequence code; step 2, generating a sequence code template according to a SN type list, a SN composition content detail list and a SN rule association list; and step 3, obtaining production parameters of a production site, and filling the production parameters into the sequence code template to obtain a sequence code, so that the sequence number can be diversified, customized and automatically generated. Meanwhile, the application also discloses a sequence code generation system.

Description

TECHNICAL FIELD

[0001] The application belongs to the technical field of Internet of Things, and more specifically relates to a sequence code generation method and system. BACKGROUND

[0002] CN201810480466.4 discloses a method and device for automatically generating customer customized serial numbers under Linux system, belonging to the field of computer technology, and aims to solve the technical problem of how to disassemble customer customized SN generation rules and maintain them to the production server Linux system to automatically generate customer customized SN, and adopts the technical scheme of:

[0003] A method for automatically generating customer customized serial numbers under Linux system, which comprises the following steps: (1) deploying a Linux system on a production server, and deploying a database inside the Linux system; inputting an order number and a starting serial number under the prompt of the Linux system; (2) grabbing the corresponding instruction number, actual configuration CPU model information and order quantity in the database according to the order; (3) splitting the first 12 bits of the customized serial number; (4) generating the 13th check code according to the customer's customized algorithm rules.

[0004] The splitting rules for the first 12 bits of the customized serial number are as follows:

[0005] ① According to the instruction number and the actual configuration CPU model information, the values of the 1st, 2nd, 4th, 6th and 7th bits of the customized serial number are defined;

[0006] ② The 3rd and 5th bits of the customized serial number are defined according to the actual production year and month information;

[0007] ③ The values of the 8th, 9th, 10th, 11th and 12th bits of the customized serial number are defined according to the starting serial number in step (1) and the order quantity in step (2).

[0008] It can be seen that this scheme splits the serial number and generates the check code according to the predetermined rules, and it cannot generate diversified serial numbers.

[0009] If the sequence code and barcode management of existing manufacturing products are not controlled by the system, they are generally allocated manually through EXCEL according to relevant rules, and then the relevant contents are manually edited and printed on the corresponding label template and pasted on the equipment for production.

[0010] The system can generate various product serial codes and bar codes according to different product sequence generation rules, and automatically generate and call corresponding label templates according to different products, and record relevant information on the system and paste on the product and equipment. When the company business continuously expands and new customers propose more types of serial codes and bar codes, the system needs to develop and adapt a large number of customized serial numbers and bar code rules, which undoubtedly greatly increases the development and maintenance workload of the system.

[0011] Therefore, the technical problem to be solved by the present application is how to diversify, customize and automatically generate serial numbers. SUMMARY

[0012] The main purpose of the present application is to provide a serial code generation method which can diversify, customize and automatically generate serial numbers.

[0013] Meanwhile, the present application also provides a serial code generation system.

[0014] The method of the present application is as follows:

[0015] A serial code generation method, comprising the following steps:

[0016] Step 1: configuring relevant basic information for generating serial codes.

[0017] The relevant basic information includes an SN type list, an SN composition content detail list and an SN rule association list;

[0018] The SN type list is used for recording the ID and type of the serial code template;

[0019] The SN composition content detail list is used for recording the information of the composition content of the serial code and the information of the script for generating the serial code;

[0020] The SN rule association list is used for recording the association information of the ID of the serial code template and the product;

[0021] The composition content and the script of the serial code are pre-stored in a database;

[0022] Step 2: generating a serial code template according to the SN type list, the SN composition content detail list and the SN rule association list;

[0023] Step 3: obtaining production parameters of a production site, and filling the production parameters into the serial code template to obtain a serial code.

[0024] In the above serial code generation method, the production parameters are date and / or serial number.

[0025] In the sequence code generation method, the SN type list is further used for recording the name, length, creator information and template style of the sequence code.

[0026] The information for recording the composition content of the sequence code is the sequence code template ID, sequence code composition content, sequence code composition content sorting, creation information and script for generating the sequence code.

[0027] In the sequence code generation method, the step 2 is specifically:

[0028] Step 21: obtaining the association between the ID of the sequence code template and the product according to the SN rule association list;

[0029] Step 22: obtaining the SN type list according to the ID of the sequence code template, obtaining the SN composition content detail list according to the SN type list, obtaining the information of the composition content of the sequence code and the script for generating the sequence code;

[0030] Step 23: obtaining the corresponding composition content and script of the sequence code from the database according to the information of the composition content of the sequence code and the script for generating the sequence code;

[0031] Step 23: executing the script to convert the composition content of the sequence code into the sequence code template, and generating the product sequence code record table.

[0032] In the sequence code generation method, the step 3 is specifically:

[0033] Step 31: obtaining the sequence code template according to the product sequence code record table by the printing end;

[0034] Step 32: obtaining the production parameters of the production site, filling the production parameters into the sequence code template to obtain the sequence code, sending the sequence code to the printer list, and printing according to the printer list by the printer.

[0035] Meanwhile, the application further discloses a sequence code generation system, comprising:

[0036] A database is used for storing the composition content of a plurality of sequence codes and a plurality of corresponding scripts for generating the sequence codes;

[0037] A configuration module is used for configuring the related basic information for generating the sequence codes.

[0038] The related basic information comprises an SN type list, an SN composition content detail list and an SN rule association list.

[0039] The SN type list is used for recording the ID and type of the sequence code template.

[0040] The SN composition content detail list is used for recording information of composition content of the serial number and information of a script used for generating the serial number;

[0041] The SN rule association list is used for recording association information of the serial number template and the product;

[0042] The serial number template generating module is used for generating the serial number template according to related basic information;

[0043] The serial number generating module is used for obtaining production parameters of a production site, filling the production parameters into the serial number template to obtain the serial number.

[0044] In the serial number generating system, the production parameters are date and / or serial number.

[0045] In the serial number generating system, the SN type list is also used for recording name, length, creator information and template style of the serial number.

[0046] The information of the composition content of the serial number is serial number template ID, serial number composition content, sorting of the serial number composition content, creation information and information of a script used for generating the serial number.

[0047] One of the technical solutions in the above technical solution of the application has at least one of the following advantages or beneficial effects:

[0048] The type, specific information and assembly method of the serial number and the association with the product are independent, and in the production process, the user can flexibly configure according to the selection of the user, the user first selects the serial number template for the product, and then defines the specific information and the assembly method, so that it is very convenient from the information source, the generation strategy, or the effective management of the serial number of the product.

[0049] The barcode instruction of the serial number is generated by using the CODE128 coding rule, the system configuration management, the strategy management and the formation of the system informationization and the barcode system automatic printing, which greatly improves the management and processing efficiency of the production serial number.

[0050] The system maintenance difficulty is reduced, the newly added barcode generating composition content can be developed and maintained in the page with the smallest granularity, and the modification and maintenance of the background business code and the re-deployment are no longer involved, which greatly reduces the workload of system development adaptation, and meets the important features of high cohesion and low coupling of system development.

[0051] For the existing SN composition content strategy, when the customer changes the different sorting requirements of the serial number, the template can be quickly configured on the page.

[0052] Flexible and strong versatility, sequence code, bar code system management, strong after-sales traceability, and not prone to error, reducing product quality problems.

[0053] The bar code printing instruction generation strategy of the scheme fully meets the requirements of various different rule serial numbers to bar codes of the company, and solves the existing and future bar code generation scheme, one-time development, convenient and practical. BRIEF DESCRIPTION OF DRAWINGS

[0054] The application will be further described below in conjunction with the drawings and examples;

[0055] Figure 1 is a flowchart of embodiment 1 of the application;

[0056] Figure 2 is a structural schematic diagram of embodiment 2 of the application. DETAILED DESCRIPTION

[0057] The embodiments of the application will be described in detail below, and examples of the embodiments are shown in the drawings, wherein the same or similar reference numerals represent the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the drawings are exemplary and are only used to explain the application, and cannot be understood as a limitation of the application.

[0058] Embodiment 1

[0059] Referring to Figure 1 , a sequence code generation method includes the following steps:

[0060] Step 1: configuring related basic information for generating a sequence code.

[0061] The related basic information includes an SN type list, an SN composition content detail list, and an SN rule association list;

[0062] The SN type list is used to record the ID and type of the sequence code template; of course, it can also record the creator information and some other user more direct attention information of the sequence code template such as the length of the sequence code.

[0063] The SN composition content detail list is used to record the information of the composition content of the sequence code and the information of the script for generating the sequence code;

[0064] The information of the composition content of the sequence code refers to the ID of the composition information of the sequence code stored in the database, and the composition information of the sequence code can be a set of codes of each subdivided field of the sequence code. As preferred in the application, the preferred composition information of the sequence code is to divide the sequence code into each small field and the order between the fields, which is used to flexibly configure the content of the field and the order of the field in the SN composition content detail list.

[0065] The SN rule association list is used to record the ID of the serial number template and the association information of the product;

[0066] The composition content and the script of the serial number are pre-stored in the database;

[0067] It should be additionally noted that the fields and the order in the composition content have related codes, which can be referred to Table 1 below:

[0068] Table 1 SN composition content detail list (records what generation content each SN contains)

[0069] Field name Field type ID char(32) SN template ID char(32) SN component content varchar(200) Serial number int Creator ID char(32) Creation time bigint Creator varchar(30) Length int JS script code text

[0070] The SN composition content (200) in Table 1 indicates the ID of the composition information of the serial number, and the ID of the script code is also 200. The corresponding composition information and script code in the database can be found through the ID.

[0071] The SN type list can be referred to Table 2:

[0072] Table 2 SN type list (SN type basic data)

[0073] Field name Field type ID char(32) SN type varchar(1) SN name varchar(100) SN total length int Usage status varchar(1) Creator ID varchar(32) Creation time bigint Creator arcahr(30) Template style varchar(100)

[0074] Table 2 is used to explain the ID of the serial number template and some basic and simple information about the template that users are more concerned about.

[0075] The SN rule association list is as shown in Table 3:

[0076] Table 3 SN rule association list

[0077] Field name Field type ID char(32) SN template ID char(32) Product code varchar(100) Creation time bigint Usage status varchar(1) Creator ID varchar(32) Creator varchar(100) Current latest serial number int

[0078] Step 2: generating a serial number template according to the SN type list, the SN composition content detail list and the SN rule association list;

[0079] The step 2 is specifically:

[0080] Step 21: obtaining the association between the ID of the serial number template and the product according to the SN rule association list;

[0081] Step 22: obtaining the SN type list according to the ID of the serial number template, obtaining the SN composition content detail list according to the SN type list, obtaining the information of the composition content of the serial number and the information of the script for generating the serial number;

[0082] Step 23: obtaining the corresponding composition content and script of the serial number from the database according to the information of the composition content of the serial number and the information of the script for generating the serial number;

[0083] Step 23: The script converts the composition of the serial code into a serial code template to generate a product serial code record table.

[0084] Since the composition of the serial code contains small fields and field order, the script can directly generate a serial code template.

[0085] Taking the serial number 101RBT213300001 as an example, 101RBT is the customer identification code, 21 is the two-year, 33 is the week number of the year, and 00001 is the serial number. We can define the template as {custCode} {YY} {WEEK} {ORDER}. This serial code template contains the composition of four fields, which will be recorded in the detail list of the related template and marked with its position (order), and there is also the code of the corresponding JS script and other related information.

[0086] Step 3: Obtain the production parameters of the production site and fill the production parameters into the serial code template to obtain the serial code, wherein the production parameters are date such as year, month, day, week, etc. and serial number.

[0087] The step 3 is specifically:

[0088] Step 31: The printing end obtains the serial code template according to the product serial code record table;

[0089] Step 32: Obtain the production parameters of the production site and fill the production parameters into the serial code template to obtain the serial code, and send the serial code to the printer list. The printer prints according to the printer list.

[0090] The application separates the type, specific information and assembly method of the serial code, and the association with the product. In the production process, the user can flexibly configure according to the user's selection. The user first selects the serial code template for the product, and then defines the specific information and assembly method. This is very convenient in terms of information source, generation strategy, and effective management of the serial code of the product.

[0091] The barcode instruction of the serial number of the application is generated by using the CODE128 coding rule. The system configuration management, strategy management, and formation of the system informationization and the barcode system automatic printing greatly improve the management and processing efficiency of the production serial code.

[0092] The system maintenance difficulty is reduced. For the newly added barcode generation composition content, the strategy development and maintenance can be carried out in the smallest granularity on the page, without involving the modification and maintenance of the background business code and re-deployment, greatly reducing the workload of system development adaptation, and meeting the important features of high cohesion and low coupling of system development.

[0093] For existing SN content composition strategies, when customers require changes to different sequence sorting requirements, this can be quickly completed in the page configuration template.

[0094] It is flexible and versatile, with strong serial code and barcode system management and after-sales traceability. It is also less prone to errors and reduces production quality issues.

[0095] The barcode printing instruction generation strategy of this solution fully meets the company's requirements for converting various regular serial numbers into barcodes, solves existing and future barcode generation solutions, and is developed in one go, which is convenient and practical.

[0096] Example 2

[0097] A sequence code generation system, comprising:

[0098] Database 1: used to store the components of multiple sequence codes and multiple corresponding scripts for generating the sequence codes;

[0099] Configuration module 2: used to configure the basic information related to generating the serial code.

[0100] The relevant basic information includes a list of SN types, a list of SN component details, and a list of SN rule associations;

[0101] The SN type list is used to record the ID and type of the sequence code template;

[0102] The SN component content list is used to record the information of the components of the serial code and the information of the script used to generate the serial code;

[0103] The SN rule association list is used to record the association information between the serial code template ID and the product;

[0104] The SN type list is also used to record the name, length, creator information, and template style of the sequence code;

[0105] The information used to record the components of the sequence code includes the sequence code template ID, the components of the sequence code, the order of the components of the sequence code, creation information, and information of the script used to generate the sequence code;

[0106] Sequence code template generation module 3: used to generate a sequence code template based on relevant basic information;

[0107] Serial code generation module 4: used to obtain production parameters of the production site, fill the production parameters into the serial code template to obtain the serial code, and the production parameters are date and / or serial number.

[0108] During the user's use, it is actually divided into the management end and the printing end. The management end performs related operations. Specifically:

[0109] The management end imports the composition content of multiple serial numbers and multiple corresponding scripts for generating serial numbers into the database. The composition content of serial numbers and scripts can also be temporarily edited and imported into the database by the administrator. In this process, the corresponding ID number should be assigned.

[0110] When there is a serial number editing requirement, the configuration module provides the administrator to configure the SN type list, the SN composition content detail list, and the SN rule association list. The administrator selects the serial number template, the specific composition content field of the serial number, the order, and the corresponding script for the product. The serial number template generation module generates the serial number template. The serial number generation module generates the serial number according to the actual production and sends it to the printing end.

[0111] Although the embodiments of the present application have been shown and described, those of ordinary skill in the art can understand that various changes, modifications, replacements, and variations can be made to these embodiments without departing from the principles and purposes of the present application, and the scope of the present application is defined by the claims and their equivalents.

Claims

1. A method for generating a sequence code, characterized in that: The following steps are involved: Step 1: Configure the basic information related to generating the serial code; The relevant basic information includes a list of SN types, a list of SN component details, and a list of SN rule associations; The SN type list is used to record the ID and type of the sequence code template; The SN component content list is used to record the information of the components of the sequence code and the script used to generate the sequence code; the information of the components of the sequence code includes the sequence code template ID, the components of the sequence code, the order of the components of the sequence code, and the creation information; The SN rule association list is used to record the association information between the serial code template ID and the product; The components and scripts of the sequence code are pre-stored in a database; Step 2: Generate a sequence code template based on the SN type list, SN component content list, and SN rule association list; including the following specific steps: Step 21: Obtain the association between the serial code template ID and the product according to the SN rule association list; Step 22: Obtain the SN type list based on the ID of the serial code template, obtain the SN component content detailed list based on the SN type list, and obtain the information of the serial code component content and the information of the script used to generate the serial code; Step 23: Obtain the corresponding sequence code components and script from the database based on the information of the sequence code components and the information of the script used to generate the sequence code; Step 23: Execute the script to convert the serial code components into a serial code template and generate a product serial code record table; Step 3: Obtain the production parameters of the production site and fill the production parameters into the serial code template to obtain the serial code; Step 31: The printing end obtains the serial code template according to the product serial code record table; Step 32: Obtain production parameters of the production site, enter the production parameters into the serial code template to obtain a serial code, send the serial code to the printer list, and the printer prints according to the printer list.

2. The method for generating a sequence code according to claim 1, wherein: The production parameters are date and / or serial number.

3. The method for generating a sequence code according to claim 1, wherein: The SN type list is also used to record the name, length, creator information, and template style of the sequence code.

4. A sequence code generation system, executing the sequence code generation method according to any one of claims 1 to 3, characterized in that: include: Database: used to store the components of multiple sequence codes and multiple corresponding scripts for generating sequence codes; Configuration module: used to configure the basic information related to generating serial codes; The relevant basic information includes a list of SN types, a list of SN component details, and a list of SN rule associations; The SN type list is used to record the ID and type of the sequence code template; The SN component content list is used to record the information of the components of the serial code and the script used to generate the serial code; The SN rule association list is used to record the association information between the serial code template ID and the product; Sequence code template generation module: used to generate sequence code templates based on relevant basic information; Serial code generation module: used to obtain production parameters at the production site and fill the production parameters into the serial code template to obtain the serial code.

5. The sequence code generation system according to claim 4, characterized in that: The production parameters are date and / or serial number.

6. The sequence code generation system according to claim 4, characterized in that: The SN type list is also used to record the name, length, creator information, and template style of the sequence code; The information used to record the components of the sequence code includes the sequence code template ID, the components of the sequence code, the order of the components of the sequence code, creation information, and information of a script used to generate the sequence code.

Images