CN117952333A

CN117952333A - Formula confidentiality method and system based on batch separation

Info

Publication number: CN117952333A
Application number: CN202311538128.9A
Authority: CN
Inventors: 董雁适; 千应庆; 樊玉书
Original assignee: Zhikong Huzhou Intelligent System Co ltd; Zhikong Technology Huzhou Innovation Research Institute Co ltd
Current assignee: Zhikong Huzhou Intelligent System Co ltd; Zhikong Technology Huzhou Innovation Research Institute Co ltd
Priority date: 2023-11-17
Filing date: 2023-11-17
Publication date: 2024-04-30

Abstract

The invention relates to the technical field of industrial production, in particular to a formula confidentiality method and system based on batch separation, comprising the following steps of S1, establishing a basic relationship data model; step S2, batching is carried out according to batching BOM, virtual batching father single-piece numbers are created in a material single-piece table, two-dimensional codes of solid materials are sequentially scanned to generate corresponding single-piece numbers, and binding relation is established between the two-dimensional codes and the batching father single-piece numbers until batching is completed; and S3, feeding according to the feeding BOM, scanning a two-dimensional code of a solid material, judging according to whether the solid material is bound with the single part number of the batching parent, and when a binding relation exists, displaying only the single part number required to be fed and the material type information corresponding to the single part number of the batching parent by an operation interface for confirmation of the user. The invention defines the ingredients of the BOM bill as 'fixed proportion materials' and ensures that the ingredients cannot be split or combined at will to strengthen the confidentiality of the formula, and simultaneously ensures the production accuracy and traceability.

Description

Formula confidentiality method and system based on batch separation

Technical Field

The invention relates to the technical field of industrial production, in particular to a formula confidentiality method and system based on batch separation.

Background

In fine chemical industry, food industry and other manufacturing enterprises, BOM (product formulation) has become a key part of many enterprise core competence. Especially in the field of professional production, in order to achieve confidentiality of the formulation and to prevent the occurrence of theft of the formulation in enterprises, enterprises often split a BOM of a finished product into at least 2 BOMs, called A and B sheets, respectively. Wherein, the finished product of the B list is taken as a raw material of the A list, the finished product of the A list is the final finished product, and the yield of the finished product of the B list is just the dosage of the finished product of the A list. Then, A, B sheets are respectively delivered to different workshops for production, so that the mutual confidentiality effect is realized. Such operations, while ensuring confidentiality of the formulation, make the operations during production more complex and special. In view of the foregoing, a new set of systems and methods are needed. The method not only can ensure effective information exchange and reduce risks of missed casting and miscasting, but also can ensure confidentiality of a core formula. In addition, the system should also be able to support sophisticated rights control, ensuring that only authorized personnel have access to the relevant recipe information.

Disclosure of Invention

The invention aims at solving the technical problems, and provides a formula confidentiality method and a formula confidentiality system based on batch separation based on the above-mentioned concepts of batch and batch separation, so that production personnel can carry out missed batch reminding and display permission control when batch is fed, and the aim of the invention can be realized through the following technical scheme:

the invention provides a formula confidentiality method based on batch separation, which comprises the following steps of,

Step S1, a basic relation data model is established to carry out the authority check sum operation of batching or feeding, each material in a material type table in the data relation model has a globally unique material number, a unique two-dimensional code is distributed when a single piece of a solid material is created, and a user carries out the batching or feeding operation after the operation authority in the system is verified and authorized through a user authority table;

step S2, a user performs batching according to a batching BOM defined in a BOM table, creates a virtual batching father single-piece number in a material single-piece table, sequentially scans two-dimensional codes of solid materials to generate corresponding single-piece numbers, and establishes a binding relationship with the batching father single-piece number until batching is completed;

Step S3, a user performs feeding according to feeding BOM in the BOM table, scans a two-dimensional code of a solid material, and judges according to whether the solid material is bound with a single-piece number of a batching father; when no binding relation exists, the materials are ordinary materials, the operation interface displays material type information to confirm, and when the binding relation exists, the operation interface also needs the single piece number of the fed materials and the material type information corresponding to the single piece number of the parent material for the user to confirm until the feeding is finished.

Further, the step S1 includes,

Step S101, a basic relation data model is built, wherein the basic relation data model comprises a material type list, a material single-piece list, a BOM list, a raw material item sub-list and a user authority list, the material type number in the material type list, the single-piece number of the material single-piece list, the BOM number in the BOM list and the raw material item number in the raw material item sub-list are set as main keys, and the material type number in the material type list and the raw material item sub-list are related through the BOM list;

Step S102, material information is configured, the material type number in a material type list is the number of each ingredient, in a BOM list, raw materials are listed for preparing the ingredient for the ingredient BOM, and the ingredient is taken as a single raw material item for the feeding BOM, so that the specific formula is kept secret;

step S103, authority check sum operation, wherein when a user accesses a BOM or a material, the system checks whether the user authority list has access and operation authority check, and then the system performs batching operation or feeding operation.

Further, in step S2, including,

Step S201, when the batching operation is started according to a batching BOM, a virtual single-piece number is created for the batching object and marked as X, and the X does not correspond to the physical material and does not have a corresponding two-dimensional code;

Step S202, a user scans two-dimensional codes of each entity material in the batching BOM in turn to generate corresponding single-piece numbers Y, the system displays material type information of each single-piece number Y on an operation interface for the user to check and determine, and establishes a binding relationship by setting a batching father single-piece number field corresponding to the single-piece number Y as X;

step S203, the solid materials are continuously scanned until all the solid materials are configured, and the batching operation is finished.

Further, the step S3 includes,

Step S301, a user scans a two-dimensional code of a solid material when performing feeding operation;

Step S302, when a single-piece number corresponding to the scanned two-dimensional code is not provided with a batching father single-piece number, the corresponding material of the single-piece number is a common raw material, an operation interface displays material type information of the common raw material, and a user confirms the material type information; when the material single piece is provided with the set material parent single piece number, the operation interface displays the material type information corresponding to the material parent single piece number as the single piece number, the user continues to scan the two-dimensional codes of other materials, and confirms the quantity of the single piece to be fed and the material type information of the material parent single piece until all the entity materials are confirmed to be fed, and the feeding operation is completed.

Based on the same inventive concept, the present invention also provides a formulation security system based on dosing separation, for performing the formulation security method as described above, comprising,

The data management module is used for configuring a basic data relation model of the formula security system and comprises a data table definition unit, a relation mapping unit and a data integrity verification unit;

the authority management module comprises a user authentication unit and an access control unit, and is used for verifying the identity of a user and controlling the type of materials and BOM numbers which can only be operated by the user;

The batching operation module comprises a batching operation unit and a batching operation unit, wherein the batching operation unit operates the configuration process of a batching BOM in a BOM table, ensures configuration according to listed materials in the batching BOM, and records each material in the configuration process; the feeding operation unit is used for operating the feeding process of the feeding BOM in the BOM table, so that the confidentiality of a formula is ensured, and only the quantity of single parts required to be fed and the species information of the ingredients are displayed;

And the interface display module is used for providing an operation interface for a user, including a guiding interface for batching and feeding operations, and interactively completing the operations.

Further, in the data management module,

The data table definition unit designs the structure of a data table in the data relation model, and comprises a material type table, a material single piece table, a BOM table, a raw material item sub-table, a user permission table, an accessible material type number sub-table and an accessible BOM number sub-table;

a relationship mapping unit for establishing and managing the association relationship between the data tables;

The data integrity check unit comprises a uniqueness check, a relevance check, a field value check and a data consistency check.

Further, in the rights management module,

A user authentication unit for determining that the user successfully logs in;

The access control unit is used for controlling the access of the identity of the user to the BOM table and ensuring that the user can only access the material information corresponding to the BOM table with authority processing.

Further, in the batch operation module, a batch operation unit is used for carrying out batch according to batch BOM in a BOM table, virtual batch parent single part numbers are created in a material single part table, two-dimension codes of all solid materials in the batch BOM are sequentially scanned to generate corresponding single part numbers, a binding relation is created with the batch parent single part numbers until batch is completed, and materials prepared according to the batch BOM are sent to a production workshop of batch operation for batch feeding;

further, in the batch operation module, the batch operation unit performs batch operation according to batch BOM, scans a two-dimensional code of a physical material, judges whether the physical material is bound with a batch father single part number, and displays material type information confirmation of the physical material when the physical material is a common material and has no binding relation; when the binding relation exists, the operation interface only displays the quantity of single pieces which need to be fed and the material type information of the parent single piece of the ingredients.

Further, the interface display module comprises a batching operation interface and a feeding operation interface, wherein,

The batching operation interface provides operation instructions for a user during batching, including scanning two-dimensional codes, verifying information of materials and confirming proportioning of material batching;

and the feeding operation interface displays the material type information of the batching father single piece of the material corresponding to the scanned two-dimensional code to the user when the feeding is produced and the single piece quantity of the material is required to be fed.

Compared with the prior art, the invention has at least one of the following technical effects:

The invention provides a formula confidentiality method and a formula confidentiality system based on batch separation, which define batch of a BOM (bill of material) as 'fixed proportioning materials' and ensure that the batch of the BOM cannot be split or combined at will, so that the confidentiality of a formula is enhanced by keeping the fixed proportioning in the production of the A bill, meanwhile, the accuracy and traceability of the production are ensured, and meanwhile, the control force and the confidentiality of the formula in the production process are obviously improved by combining two-dimensional code tracking and system control, the dual requirements of the production on the confidentiality and the production precision of the formula are met, and the problems of formula disclosure and material management confusion in the traditional production are solved.

(1) Enhanced security: the confidentiality of the components and the proportion of the formula is ensured through the concept of 'fixed proportion materials' and the premixing of ingredients, the leakage of the formula is avoided, and the consistency of the product quality is maintained;

(2) Accurate material control and improved production efficiency: the two-dimension code technology is utilized to ensure the accurate delivery of each material single piece, so that the accurate management of the materials is realized, the risk of wrong delivery is reduced, and the errors and the retreatment time of the materials are reduced although the code scanning link is added, thereby improving the production efficiency and the product quality in a long term;

(4) Information display of authority control: by setting different authorities of production personnel, the production personnel can only see necessary information, the hierarchical protection of the information is enhanced, and the leakage of important formulas is avoided.

Drawings

In order to more clearly illustrate the technical solution of the embodiments of the present invention, the following description will briefly explain the drawings that are required to be used in the description of the embodiments:

FIG. 1 is a flow chart of the steps of a recipe confidentiality method based on batch separation according to the present invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be further described in detail below with reference to the accompanying drawings and detailed description. It should be understood that the detailed description is presented by way of example only and is not intended to limit the invention.

Example 1

In order to solve the production complexity caused by separation of the A sheet and the B sheet, the current practice is to sign a two-dimensional code for each single piece produced by the B sheet. When the production personnel of the A bill are fed, only the two-dimensional codes are required to be scanned, so that necessary information about the B bill can be obtained. But this approach also brings new problems: although the existing two-dimensional code technology provides necessary information for production personnel of the A form, the method cannot ensure that the problem of missed casting or miscasting is completely avoided, and the existing BOM system design is only limited to recording the types and the quantity of raw materials used by each finished product, but is not designed to support interaction and authority control between ingredients and casting materials, and cannot effectively solve the problems of missed casting or miscasting and failure in effectively realizing authority control on formula information, so that the risk of leakage of a core formula is increased.

In a typical production scenario, the production operation of the B sheet is mainly batching: each raw material in the BOM is placed into a barrel, a bag and a cup according to the quantity requirement in the BOM. Each material is placed separately, and the finished product B is composed of barrels, bags and cups which are placed separately, and is a group of materials which are not mixed together and can be called ingredients. Each of the barrels, bags and cups is referred to as a single piece.

The production operation of the A sheet is mainly to throw and discharge: each raw material in the BOM is put into a production container for mixing according to the quantity requirement in the BOM, and after production and inspection are finished, the raw material is changed into a single-product finished product A, and the single-product A is discharged and put into storage.

The product of the A sheet has the own material type and name, such as X. The product of the B sheet, though a group of unmixed raw materials, also has its own material type and name, such as X-B.2 workshops are kept secret, the workshops of the B form do not know the details of the A form, the workshops of the A form do not know the details of the B form, and the workshops of the A form only know that the finished product of the B form is the raw material of the A form. After the production personnel of the A single workshop takes some single pieces sent by the production personnel of the B single workshop, the specific material types and the specific material amounts of the single pieces are not known, and the raw materials are only taken as a material and put into a production container in a certain process step. Because the production personnel of the A bill does not know the form and the like of the specific raw materials used by the B bill, the production accident of missed casting is easy to occur: after the feeding link is finished, the fact that a certain single piece is forgotten to be fed is found.

In order to solve the problem, a two-dimensional code can be attached to each single piece produced by the B single piece, and the two-dimensional code is required to be recorded into an information system after the code scanning. The production personnel of the A list need to sweep the code and sweep one single piece and throw one single piece on the feeding. The information system will record which B-sheets have been thrown and which have not, and alert the user. This can reduce the occurrence of missed shots to a great extent. However, it should be noted that when the B bill producer scans a two-dimensional code of a single piece, the name and the number of the real material types of the single piece are displayed, and when the a bill producer scans the same single piece, only the name of the B bill finished product can be displayed. The current BOM design format only records the type and quantity of raw materials used for each product. If the material is a batch, how to support the missed call reminding and the display authority control in the information system becomes a considerable problem.

The invention provides a formula confidentiality method based on batch separation, which defines batch of a formula B as a fixed proportioning material and ensures that the batch of the formula B cannot be split or combined at will, so that the confidentiality of a formula is enhanced by keeping the fixed proportioning in the production of the formula A, and meanwhile, the production accuracy and traceability are ensured. The technical difficulty is how to effectively realize the concept of 'fixed proportioning materials' in an informatization system and ensure that the materials are not split or combined at will in actual production.

The specific operation steps are as follows:

1. Defining a data structure by using a relational data model, establishing a database, and designing a database table in the database;

1. the material category table records the category of all materials and comprises the following fields:

Material type number: a primary key, a unique number identifying the material,

Other attributes: such as material names, material description information;

2. the material list records the information of each material list, is associated with the material type list, and comprises the following fields:

single part number: the primary key is the same as the two-dimensional code on the material single piece, ensures the uniqueness,

Material type number: an external key pointing to the material category list,

Batch parent singleton number: an external key, pointing to a single part number in the table, is used to identify the combined material.

In addition to the fields in the BOM table, the weight, volume, batch, etc. of the singleton can be defined;

3. A BOM table defining a list of raw materials required to produce a product, comprising the following fields:

BOM number: a primary key, a unique identification BOM,

Product number: an external key pointing to the material category list, a mark finished product,

Type of dosing: identifying whether the raw materials are fed or proportioned;

A raw material item table;

4. a stock item sub-table listing all stock items in the BOM, including the following fields:

raw material item number: a primary key, a unique number,

BOM number: an external key, pointing to the BOM table,

Raw material number: an external bond pointing to a material type list, wherein the material number is a material type number;

5. the user authority table contains fields for managing user access authority, and the fields include the following:

user number: a primary key uniquely identifying the user;

The system is associated with an accessible material type number sub-table and an accessible BOM number sub-table and is used for controlling the user to access the material type and the BOM; this design ensures that each user has access to only the materials and BOM information they are authorized to view, thereby protecting the confidentiality of the recipe. Every time the material is put into production, through scanning the two-dimensional code that is correlated with the material list, can realize accurate tracking and record.

6. The accessible material category number sub-table contains the fields: the material category number may be accessed.

7. The accessible BOM number sub-table contains the fields: the BOM number may be accessed.

Furthermore, to reduce descriptive complexity, we assume only one finished product per BOM. The finished product can be a common product or a mixture. At the same time, we have also discarded the fields common in BOM but not relevant to describing our method, such as production planning yield, raw planning usage, etc.

2. On the basis of the relational data model, the following algorithm is designed:

1. Information configuration method of ingredients

The batch is formed by precisely preparing a group of raw materials according to a batch list in a single step B, and then sending the batch to a single step A for feeding. The steps of the information configuration method for each ingredient are as follows:

① Material number configuration, namely assigning a unique material type number for the ingredients in a material type table;

② BOM (batch bill) configuration of the batch, creating a BOM for the batch in a BOM table, wherein the product number of the BOM is set as the material type number of the batch; and the type of dosing material is set as "dosing"; then defining all necessary raw material items;

③ BOM (bill of feed) configuration of feed, another BOM is created for the step of feeding, and the type of feed is set to "feed"

2. BOM access rights control

Based on the information in the user permission table, a user may access and operate a BOM if he has access to all production and raw material types in the BOM and has access to the BOM. This prevents a user from having access to only an incomplete BOM without self knowledge, but from having to do a production incident with an incomplete BOM. Maintaining the confidentiality and integrity of the BOM.

3. Dosing and throwing operation algorithm

During the batching operation:

① The system generates a single material piece X without a two-dimensional code as a reference of a batching batch;

② For each raw material single piece, attaching a unique two-dimensional code to generate a material single piece Y, and numbering a parent single piece of a material mixture of the material single piece Y to be X;

③ Scanning a two-dimensional code input system of each material single Y, and displaying information such as the material types, the quantity and the like of the material single Y on an operation interface for user operation determination;

④ . The batching is continued until the B sheet operation is completed.

In this way, the single piece of material X can be sent to the production plant of A sheets.

The feeding operation is as follows:

① Scanning a two-dimensional code of a raw material single piece X;

② Determining whether the material single piece X is provided with a parent single piece number of the ingredient, if not, displaying information such as the material type, the quantity and the like of the X on an operation interface for a user to confirm; if yes, X is a child piece of the ingredient, the parent piece of the ingredient is Y, and the material type information of Y is displayed on an interface for the user to determine. Note that information on the kind, number, and the like of the material of X, which are contents requiring confidentiality, cannot be displayed.

③ And after the information is determined, feeding is continued until the A single operation is completed.

In summary, the solution idea of the invention is to split one formula into 2 formulas A, B to simplify the operation flow and enhance the control, and in the single-ingredient stage B, the raw materials are not mixed, and the finished product is the small bags of various materials and keeps independent package;

after the preparation of the sheet B is finished, the formed mixture is uniform for operators of the sheet A, and the operators of the sheet B can see the real material types.

A generally requires the gradual feeding of the raw materials into the reactor in different process steps, which is a material mixing operation, so is called feeding. For the personnel in the A list, the materials in the B list are all the same material types.

For the distinction of the method from other informationized systems: ① Other systems consider the B single ingredient as a real product and record the same. But does not record which materials, quantity and other information are in the finished product. To review this information, the B-sheet record must be reviewed. In our method design, the batch is a virtual material, consisting of multiple sub-pieces. ② The ingredients are different from the common finished products: 1 burden article can not split at will, and a plurality of burden articles can not mix at will, otherwise the ratio relation is easy chaotic. Must be fed together and cannot leak. This can be achieved using our ingredient concept. ③ Since the ingredients directly carry the formula information, multiple ingredients can be split and mixed. The materials in the system are all kinds and the quantity of the materials, and still have records in the informatization system.

Example 2

The invention provides a formula confidentiality method based on dosing material separation, referring to fig. 1, comprising,

Step S2, a user performs batching according to a batching BOM defined in a BOM table, creates a virtual batching father single-piece number in a material single-piece table, sequentially scans two-dimensional codes of solid materials to generate corresponding single-piece numbers, and establishes a binding relationship with the batching father single-piece number until batching is completed; because the ingredients are new materials formed by combining a plurality of raw materials through the ingredients operation, even virtual non-physical ingredients (combined materials) are required to be provided with single-piece numbers in a single-piece table in order to trace the ingredients process and maintain the consistency of data, and the parent single-piece numbers of the ingredients exist as virtual or logical single-pieces and represent the whole of the ingredients rather than specific physical entities;

Step S3, a user performs feeding according to feeding BOM in the BOM table, scans a two-dimensional code of a physical material, and judges whether the physical material is bound with a parent single part number of the ingredients; when no binding relation exists, the materials are ordinary materials, the operation interface displays material type information to confirm, and when the binding relation exists, the operation interface only displays the quantity of single pieces which need to be fed and the material type information corresponding to the serial numbers of the single pieces of the burdening father for the user to confirm until the feeding is finished. The key purpose of the process is to ensure that the correct materials are used in the correct proportion and combination during feeding, and simultaneously only the necessary material type information is displayed on an operation interface so as to achieve confidentiality of ingredients. For example, if a batch is made up of several different materials mixed according to a secret recipe, the operator interface will not display the specific information of the material, but only the information of the batch, to achieve the confidentiality of the recipe, and will not leak out during production.

Further, the step S1 includes,

Further, in step S2, including,

Step S201, when the batching operation is started according to a batching BOM, a virtual single-piece number is created for the batching object and marked as X, and the X does not correspond to the physical material and does not have a corresponding two-dimensional code; the virtual single-piece number represents the ingredient to be produced by the dispensing operation,

Step S202, a user scans two-dimensional codes of each entity material in the batching BOM in turn to generate corresponding single-piece numbers Y, the system displays material type information of each single-piece number Y on an operation interface for the user to check and determine, and establishes a binding relationship by setting a batching father single-piece number field corresponding to the single-piece number Y as X; when the materials are mixed together by the batching operation, each solid material is scanned, its individual part number is obtained, and the individual parts of the solid material are associated with the batching parent individual part number in the system;

Wherein a single ingredient is also assigned a parent single ingredient number in order to maintain consistency in the operation of the system, even though this operation may appear to be somewhat redundant for the case of only one ingredient, such a design may allow the system to handle ingredients in a uniform manner in different situations, whether it be composed of one or more ingredients. In general, the purpose of creating a recipe parent singleton number is to create a mechanism in the system that represents the result of a recipe operation so that the recipe can be tracked and managed in the same manner regardless of how much material the recipe is composed of.

Further, the step S3 includes,

Step S302, when a single-piece number corresponding to the scanned two-dimensional code is not provided with a batching father single-piece number, the corresponding material of the single-piece number is a common raw material, an operation interface displays material type information of the common raw material, and a user confirms the material type information; when the material single piece is provided with the set material parent single piece number, the operation interface displays the material parent single piece number as material type information corresponding to the single piece number, the user continues to scan two-dimensional codes of other materials, and confirms the number of single pieces required to be fed and the material type information of the material parent single piece until all the entity materials are confirmed to be fed, and the feeding operation is completed. If the material is the only material in fact, the operator interface will still present the material type information of the product based on the parent material number rather than the original material information, such design maintains the consistency of the system process flow, or the single material is subject to a certain degree of specific treatment or quality control, and can be considered a product.

Example 3

The invention also provides a formula confidentiality system based on dosing separation, which is used for executing the formula confidentiality method, and comprises the following steps of,

Further, in the data management module,

A data integrity check unit comprising a uniqueness check, a relevance check, a field value check and a data consistency check, the data integrity check unit ensuring that all data comply with predefined constraints and business rules, comprising: ① Uniqueness checking: ensuring that all numbering fields (e.g., material type number, singleton number, BOM number, etc.) are globally unique; ② And (3) correlation verification: verifying that the external key relation between the tables is correct, for example, the type number of the material single piece must exist in the material type table; ③ And (3) checking a field value: ensuring that the field values meet business logic requirements, for example, the type of dosing can only be "dosing" or "batching". ④ Data consistency: maintaining the relevance and integrity between data when deleting or updating data, such as deleting a material category, ensures that no material piece references such a category number.

Further, in the rights management module,

A user authentication unit for determining that the user successfully logs in;

Further, in the batch operation module, the batch operation unit performs batch operation according to the batch BOM, scans a two-dimensional code of a solid material, judges whether the solid material has a binding relation of batch father single-piece numbers, and displays material type information confirmation of the solid material when the solid material is a common material and has no binding relation; when the binding relation exists, the operation interface only displays the quantity of the single pieces which need to be fed and the material type information of the parent single piece of the ingredients.

The feeding operation interface displays the material type information of the parent single piece of the material corresponding to the scanned two-dimensional code to the user during production feeding, and the quantity of single pieces required to be fed.

Example 4

To assist those skilled in the art in understanding the present invention, an example of a formulation security system based on batch separation is designed below, and the processes of batch separation, batch, rights management and information security are embodied in the form of a table, in this example, we assume that we have a large number of raw material types and a complex product, and multiple batch and batch sheets are required to process, and meanwhile, to illustrate rights management, we set users with different rights and access different BOMs according to rights to illustrate:

(1) Establishing a relational data model of a material type table, a material single piece table, a BOM table, a raw material item sub-table and a user authority table to carry out authority check sum operation of batching or feeding: and the operation authority of the user in the system is verified through the user authority list, and then the material is prepared or fed.

The method comprises the steps of respectively setting a material type number in a material type list, a single-piece number of a material single-piece list, a BOM number in a BOM list and a raw material item number in a raw material item list as a main key, and associating the material type number in the material type list with the raw material item list through the BOM list; the BOM table is associated with the material type number in the material type table and the raw material item sub-table; configuring material information, wherein the material type number in the material type list is the number of each ingredient, and the BOM list is configured with the corresponding BOM number for each ingredient, so as to determine the required raw material item;

The method comprises the following steps:

a. Material type table:

Material type number	Description of materials
		A0001	Raw material A
A0002	Raw material B
		A0003	Raw material C
A0004	Raw material D
		A0005	Raw material E
A0006	Ingredient P1
		A0007	Ingredient P2
...	...

B. material single piece table:

Single part numbering	Material type number	Single-piece numbering of batch father
			B01	A0006	null
D01	A0001	B01
			D02	A0002	B01
B02	A0007	null
			D03	A0003	B02
D04	A0004	B02
			D05	A0005	B02
...	...	...

BOM table (product number generally refers to the end product or a compound and not directly to the feedstock, but the definition of BOM may be set according to the needs of the organization if necessary, the feedstock may also be one of the BOMs, e.g., if the feedstock requires further processing or tracking, the feedstock may also possess a BOM number).

BOM numbering	Product number	Type of batch	Raw materials item sub-table numbering
				BOM001	A0006	Proportioning materials	RT01-RT02
BOM002	A0006	Feeding material	RT03
				BOM003	A0007	Proportioning materials	RT04-RT06
...	...	...	...

D. raw material item table:

e. User permission table (one user may have permission to access to a plurality of material category numbers and BOM numbers, depending on the user's job needs and roles in the system:

User numbering	Accessible material category numbering sub-table numbering	Accessible BOM number sub-table numbering
			User001	MT01	BMT01
User002	MT02	BMT02
			User003	MT03	BMT03
...	...	...

F. accessible material category number sub-table

Sub-table numbering	Accessible material category numbering sub-table numbering
		MT01	A0001、A0002
MT02	A0006
		MT03	A0003、A0004、A0005
...	...

G. Accessible BOM number sub-table

BOM access right setting: according to the information set in the user authority list, if a user accesses all raw material items or ingredient items in a BOM list, the BOM can be operated so as to prevent that a user can only access incomplete BOM without self knowledge, but production is carried out according to the incomplete BOM, and production accidents can be easily caused;

The preparation operation process comprises the following steps:

(1) When the User number is User001, the BOM number corresponding to the BOM number sub-table BMT01 can be accessed to be BOM001, the type of the batch of the BOM is batch, and the corresponding raw material numbers are A0001 and A0002, then after the BOM batch starts, a virtual batch object piece is created in the material piece table, and the single piece number is marked as B01;

(2) Generating a corresponding two-dimensional code for each material single piece, wherein the material single piece is a real object, a user scans the two-dimensional code of A0001 through a system, creates a corresponding single piece number D01, displays information of the single piece number D01 on an operation interface for confirmation by the user, simultaneously marks a parent single piece number of ingredients as B01 to bind an association relationship, continues to scan A0002 for ingredients, marks the parent single piece number of the ingredients as B01 to bind the association relationship until the ingredients A0006, namely the single piece number B01, are sent to a production workshop for feeding operation to be fed after the ingredients are finished.

The feeding operation process stage comprises the following steps:

If the User number is User002, the BOM number corresponding to the BOM number sub-table BMT02 is BOM002, the type of the batch of BOM is batch, and the corresponding raw material number is a0006, then the two-dimensional code of one of the material single pieces in the batch a0006 is scanned, the batch parent single piece number is displayed as B01, that is, the material single piece is a sub single piece of the batch a0006, the material type information of the batch a0006 is displayed on the operation interface for the User to confirm, the batch is prompted to trace the source according to the material single piece table, the batch is prompted to have one sub single piece to be batch, batch feeding is continued until another batch is delivered, the batch feeding operation is completed, besides the prompt for the number of single pieces is displayed, the weight, the volume and the like can be limited and prompted, the information related to the material type of the sub single piece cannot be displayed in the batch feeding process, and the information is kept secret. If the number of the parent single piece of the ingredients is not set, the single piece of the materials is common raw materials, and information such as the type of the materials, the number of the single pieces and the like of the single piece of the materials is displayed on an operation interface for a user to confirm.

Although the present invention has been described in terms of the preferred embodiments, it is not intended to be limited to the embodiments, and any person skilled in the art can make any possible variations and modifications to the technical solution of the present invention by using the methods and technical matters disclosed above without departing from the spirit and scope of the present invention, so any simple modifications, equivalent variations and modifications to the embodiments described above according to the technical matters of the present invention are within the scope of the technical matters of the present invention.

Claims

1. A formula confidentiality method based on batch separation is characterized by comprising the following steps of,

Step S1, a basic relation data model is established to carry out the authority check sum operation of batching or feeding, each material in a material type table in the data relation model has a globally unique material number, a unique two-dimensional code is allocated to a single material of a solid material when the single material is established, and a user carries out the batching or feeding operation after the operation authority in the system is verified and authorized through a user authority table;

Step S2, the user performs batching according to a batching BOM defined in a BOM table, creates a virtual batching father single-piece number in a material single-piece table, sequentially scans the two-dimensional code of the solid material to generate a corresponding single-piece number, and establishes a binding relationship with the batching father single-piece number until batching is completed;

Step S3, the user performs feeding according to feeding BOM in the BOM table, scans the two-dimensional code of one entity material, and judges according to whether the entity material is bound with the burdening father single piece number; when the binding relation is not available, the materials are ordinary materials, the operation interface displays material type information for confirmation, and when the binding relation is available, the operation interface only displays the quantity of single pieces which need to be fed and the material type information corresponding to the serial numbers of the single pieces of the burdening father for confirmation by the user until the feeding is finished.

2. The method of claim 1, wherein said step S1 further comprises,

Step S101, building the basic relation data model, wherein the basic relation data model comprises the material category list, the material single-piece list, the BOM list, a raw material item sub-list and the user authority list, and the material category number in the material category list, the single-piece number in the material single-piece list, the BOM number in the BOM list and the raw material item number in the raw material item sub-list are set as main keys, and the material category number in the material category list and the raw material item sub-list are associated through the BOM list;

Step S102, configuring material information, wherein the material type number in the material type list is the number of each ingredient, in the BOM list, for the ingredient BOM, raw materials are listed to prepare the ingredient, and for the feeding BOM, the ingredient is taken as a single raw material item, and the specific formula is kept secret;

Step S103, authority check sum operation, wherein when the user accesses one BOM or the material, the system checks whether the user authority list has access and operation authority check, and then the batching operation or the feeding operation is carried out.

3. The method of claim 2, wherein in step S2, further comprising,

Step S201, when the batching operation is started according to the batching BOM, creating a virtual single-piece number for the batching object to be marked as X, wherein the X does not correspond to the physical material and does not correspond to the two-dimensional code;

step S202, the user scans the two-dimensional code of each solid material in the ingredient BOM in turn, generates the corresponding single-piece number Y, displays the material type information of each single-piece number Y on the operation interface for the user to check and determine, and sets the ingredient father single-piece number field corresponding to the single-piece number Y as the X, and establishes a binding relationship;

step S203, continuing to scan the solid materials until all the solid materials are configured, and ending the batching operation.

4. The method of claim 3, wherein said step S3 further comprises,

Step S301, when the user performs the feeding operation, scanning the two-dimensional code of the physical material;

Step S302, when the single piece number corresponding to the scanned two-dimensional code is not provided with the batching father single piece number, the corresponding material of the single piece number is a common raw material, the operation interface displays the material type information of the common raw material, and the user confirms the material type information; when the material singlets are provided with the batch parent singleton numbers, the operation interface displays the batch parent singleton numbers as the material type information corresponding to the singleton numbers, the user continues to scan two-dimension codes of other materials, the quantity of singleton needing to be fed and the material type information of the batch parent singleton are confirmed until all the solid materials are confirmed to be fed, and the feeding operation is completed.

5. A dosing segregation-based formula security system for performing a formula security method according to any one of claims 1 to 4, comprising,

The data management module configures a basic data relation model of the formula security system and comprises a data table definition unit, a relation mapping unit and a data integrity verification unit;

The authority management module comprises a user authentication unit and an access control unit, and is used for verifying the identity of a user and controlling the user to only operate the allowed material types and BOM numbers;

the batching operation module comprises a batching operation unit and a batching operation unit, wherein the batching operation unit operates the configuration process of batching BOMs in the BOM table, ensures configuration according to listed materials in the batching BOMs, and records each material in the configuration process; the feeding operation unit is used for operating the feeding process of the feeding BOM in the BOM table, and only displaying the quantity of single pieces required to be fed and the species information of the ingredients in order to ensure the confidentiality of the formula;

and the interface display module is used for providing an operation interface for the user, and comprises a guiding interface for batching and feeding operations, so that the operations are interactively completed.

6. The dosing segregation-based recipe privacy system of claim 5, wherein, in the data management module,

The data table definition unit is used for designing the structure of a data table in the data relation model and comprises a material type table, a material single piece table, the BOM table, a raw material item sub-table, a user permission table, an accessible material type number sub-table and an accessible BOM number sub-table;

The relation mapping unit establishes and manages the association relation between the data tables;

7. The dosing segregation-based recipe privacy system of claim 6, wherein, in the rights management module,

The user authentication unit determines that the user successfully logs in;

The access control unit is used for controlling the access of the identity of the user to the BOM table and ensuring that the user can only access the material information corresponding to the BOM table which has authority to process.

8. The batch separation-based formula security system according to claim 7, wherein in a batch operation module, the batch operation unit performs batch according to the batch BOM in the BOM table, creates virtual batch parent single part numbers in the single material part table, sequentially scans the single part numbers corresponding to and generated by the two-dimensional codes of all the entity materials in the batch BOM, and establishes a binding relationship with the batch parent single part numbers until batch is completed, and sends the materials prepared according to the batch BOM to a production shop of a batch operation for batch.

9. The formula confidentiality system based on batch separation according to claim 7, wherein in a batch operation module, the batch operation unit performs batch feeding according to the batch BOM, scans the two-dimensional code of one entity material, determines whether the entity material is bound to the batch parent single part number, and when no binding relation exists, the entity material is a common material, and the operation interface displays the material type information confirmation of the entity material; when the binding relation exists, the operation interface only displays the quantity of the single pieces which need to be fed and the material type information of the parent single piece of the ingredients.

10. The dosing and dosing separation-based recipe privacy system of claim 9, wherein the interface display module comprises a dosing operation interface and a dosing operation interface, wherein,

The batching operation interface provides operation instructions for a user during batching, and comprises the steps of scanning the two-dimensional code, verifying the information of the materials and confirming the proportioning of the materials;

and the feeding operation interface displays the scanned material type information of the material parent single piece and the quantity of single pieces required to be fed corresponding to the two-dimensional code to the user when the feeding operation interface is used for producing the feeding.