CN116627980A - Material standard generation method and device, computer equipment and storage medium - Google Patents

Abstract

The application relates to a method and a device for generating a material standard, computer equipment and a storage medium, and belongs to the technical field of industrial informatization IT. A material standard generation method comprises the following steps: defining naming rules of materials; creating material main data; the material main data comprises a fixed field and an extension field; the fixed field and the extension field are stored in the same database record; the extension field is used for storing extension attributes; acquiring target content from the material main data according to the naming rule; and generating a material standard according to the naming rule and the target content. The material standard generation method utilizes the characteristic that the extension attribute has multiple data types, and flexible naming rule configuration is carried out through extension metadata, so that the requirement of naming complex and various materials is met, and the complete automation, standardization and standardization of material naming are realized.

Description

Material standard generation method and device, computer equipment and storage medium

Technical Field

The application relates to a method and a device for generating a material standard, computer equipment and a storage medium, and belongs to the technical field of industrial informatization IT.

Background

The informatization basis of the manufacturing industry is to construct a Bill of materials (BOM), and the basis of the Bill of materials is Material information. In increasingly huge material libraries in enterprises, how to construct scientific and reasonable material naming standards meets the internal management and external market development requirements of the enterprises, not only can the management level of the enterprises be embodied, but also the method is an effective method for reducing the cost and enhancing the efficiency.

The traditional ERP management system is mainly used for naming material information, and mainly shows aspects of material coding, material names, material specifications and the like, a direct manual input mode is provided, or a preset rule is provided, content is acquired from relevant fields of the material, and relevant information is automatically generated. Manual input has high dependence on personnel, and naming contents are not standard due to different personnel habits, different input errors and other reasons; the latter plays a certain effect to naming standardability of the material, but in practical application, a certain attribute material code and a material name are always involved, but the material code needs to be in a numbered format, the material name needs to be in Chinese content, such as color number attribute, 0060 represents red, the material code needs to represent 0060, the material name needs to represent "red", the prior method needs to define two sections of input when creating material information, and the color number and the color number name are respectively input. Other attributes such as suppliers, customers, accounting subjects and the like are data existing in other modules of the system, if the material numbers need to represent the supplier numbers and the material names need to represent the supplier names, currently, the existing basic data are difficult to directly reference, and if the information is repeatedly maintained in the main material data, not only is the material information inconsistent with the basic data easily caused, but also additional maintenance workload is increased.

In addition, when a specific value of a certain type appears in the attribute participating in naming, the value needs to be converted correspondingly, for example: if the lens has myopia degree attribute, the character of 'myopia' needs to appear automatically in the name of the lens. The naming rule with certain value condition operation logic is also not supported by the current ERP system, and although the purpose can be achieved through manual input, the naming rule has very high dependence on personnel, and if the input is wrong and missed, the material information of the system is inaccurate and not standard.

Disclosure of Invention

In order to solve the technical problems, the application provides a material standard generation method, a device, computer equipment and a storage medium, which utilize the characteristic that the extension attribute has multiple data types, and flexibly allocate naming rules by extending metadata, thereby meeting the naming requirements of complex and various materials and realizing the complete automation, standardization and standardization of material naming.

In one aspect, the application provides a method for generating a material standard, which comprises the following steps:

defining naming rules of materials;

creating material main data; the material main data comprises a fixed field and an extension field; the fixed field and the extension field are stored in the same database record; the extension field is used for storing extension attributes; the extension attribute is generated through extension metadata; the extension metadata comprises metadata names, metadata types and metadata settings; the extended attribute carries out assignment according to the metadata type and metadata setting;

acquiring target content from the material main data according to the naming rule;

and generating a material standard according to the naming rule and the target content.

Specifically, the naming rule comprises rule items and ordering rules among the rule items;

the obtaining the target content from the material main data according to the naming rule comprises the following steps:

acquiring target content from the material main data according to the rule item;

the generating material standard according to the naming rule and the target content comprises the following steps:

taking the target content as the content of the corresponding rule item;

and generating a material standard according to the ordering rule and the content of each rule item.

Specifically, the rule item includes rule item settings;

the obtaining the target content from the material main data according to the rule item comprises the following steps:

and acquiring target content from the material main data according to the rule item setting.

Specifically, the rule item settings include an extension metadata name and a reference type;

the obtaining the target content from the material main data according to the rule item setting comprises the following steps:

acquiring target extension attributes from the material main data according to the extension metadata names;

judging whether the target extension attribute exists or not;

if not, taking the null value as the target content;

if yes, acquiring target content from the target extension attribute according to the reference type.

Further, in other embodiments, the rule item setting further includes a value condition and a corresponding value result;

after the target content is obtained from the target extension attribute according to the reference type, the method further comprises the following steps:

acquiring a corresponding value result according to the target content and the value condition;

judging whether the value result exists or not;

if yes, taking the value result as the final target content;

if not, the previous target content is taken as the final target content.

Specifically, the metadata type comprises an option table and an association table;

the obtaining the target content from the material main data according to the naming rule comprises the following steps:

acquiring target extension attributes from the material main data according to the naming rules;

judging whether the metadata type of the target extension attribute is an option table or an association table;

if yes, acquiring corresponding extended attribute assignment, namely acquiring the target content.

Specifically, the generating a material standard according to the ordering rule and the content of each rule item includes:

optimizing the content of each rule item;

and generating a material standard according to the sorting rule and the optimized content of each rule item.

On the other hand, the application also provides a material standard generating device, which comprises:

the definition unit is used for defining naming rules of the materials;

the creation unit is used for creating material main data; the material main data comprises a fixed field and an extension field; the fixed field and the extension field are stored in the same database record; the extension field is used for storing extension attributes; the extension attribute is generated through extension metadata; the extension metadata comprises metadata names, metadata types and metadata settings; the extended attribute carries out assignment according to the metadata type and metadata setting;

the acquisition unit is used for acquiring target content from the material main data according to the naming rule;

and the generating unit is used for generating a material standard according to the naming rule and the target content.

In another aspect, the present application further provides a computer device, including a memory, a processor, and a computer program stored in the memory and capable of running on the processor, where the processor implements the material specification generation method as described above when executing the computer program.

In another aspect, the present application also provides a computer readable storage medium storing one or more computer programs executable by one or more processors to implement the material specification generation method as described above.

The method, the device, the computer equipment and the storage medium for generating the material standard have the following beneficial effects:

1. the material main data information is characterized by a fixed field and an extension field; compared with the existing dynamic extension information technology, the template of the extension attribute is not required to be defined in advance, and only loose extension metadata definition is required to be defined. When the material standard is generated, the set of the expansion attribute of each piece of material main data can be flexibly adjusted according to specific application scenes, so that the contained information elements are more accurate and more suitable for business scenes.

2. The extended attributes stored in the extended fields are generated through the extended metadata, assignment is set according to the metadata types and metadata of the extended metadata, the characteristic attributes of the main data of the materials can be changed only by changing the extended attributes without changing the fixed fields through frequently modifying codes, and further the main data information of the materials is rapidly and flexibly maintained to respond to service changes, so that the service requirements can be met when the material specification is generated.

3. Setting rule items as extension metadata names and reference types, and assigning the reference numbers or values through one-time extension metadata assignment, so that the numbers and the values are paired in naming information, and data consistency and normalization are ensured.

4. The target content obtained through the steps is subjected to conditional operation through the value condition in the rule item setting, and the value result is converted, so that various special naming requirements can be flexibly met, naming rules are widely applied, and full automation and standardization of material naming are realized.

5. The metadata type is set as the association table type, so that various basic data and business data existing in the system can be conveniently referenced, the system data intercommunication and interconnection are achieved, and repeated maintenance is not needed.

6. And optimizing the content of each rule item so that the finally generated material standard meets the service requirement.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present application, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.

FIG. 1 is a schematic flow chart of a material standard generation method provided by an embodiment of the application;

FIG. 2 is a sub-schematic flow chart of a method for generating a material standard according to an embodiment of the present application;

FIG. 3 is a schematic flow chart of a method for generating a material standard according to another embodiment of the present application;

FIG. 4 is a schematic flow chart of a method for generating a material standard according to another embodiment of the present application

FIG. 5 is a schematic block diagram of a material gauge generating device according to an embodiment of the present application;

fig. 6 is a schematic structural diagram of a computer device according to an embodiment of the present application.

Detailed Description

The following description of the embodiments of the present application will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.

It should be understood that the terms "comprises" and "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.

It is also to be understood that the terminology used in the description of the application herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. As used in this specification and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.

It should be further understood that the term "and/or" as used in the present specification and the appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes such combinations.

Examples

The embodiment of the application provides a material standard generation method, which is used for managing information such as codes, names, specifications, album numbers and the like of materials in manufacturing industry, wherein a database for providing data storage can be a mainstream OLTP relational database such as Oracle, sql Server, mysql, postgresSQL and the like; in addition, the execution subject of the method may be a computer, a server, or the like, and the embodiment is not limited in any way.

Referring to fig. 1, fig. 1 is a schematic flow chart of a method for generating a material standard according to an embodiment of the present application. As shown in FIG. 1, the material standard generation method comprises the following steps S1-S4:

s1, defining naming rules of materials.

Specifically, the naming rule comprises rule items and ordering rules among the rule items; the rule items include rule item types and rule item settings.

The rule term settings for different rule term types are somewhat different, as specified in table 1 below ("NA" indicates that there is no such rule term setting):

TABLE 1

1) When the rule item type is text, the text content is necessary to be filled, and the prefix and the suffix are selected and filled. The type is mainly used for splicing certain fixed texts in names and specifications or scenes such as separators, and the like, such as: the factory name is fixedly noted in front of the material name, the contents of the two sections of rule items are separated by "/", and the like, and the method can be realized by text types.

2) When the rule item type is "running water", the number of running water bits must be filled out, and no other rule item is set. The type is mainly used for the scene that the material coding is finally needed to use the serial number, and a complete naming rule can only have a segment of rule items of the serial type at most and must be arranged at the end of the rule. When the rule items of the flow type appear in the naming rule, after all rule items in front of the flow rule items are generated into contents, the KEY serving as the flow counter is used for obtaining the current count value of the KEY, adding 1 to the count value, combining the flow digit, and converting the count value into an available flow number conforming to the format.

3) When the rule item type is 'material main data', the prefix, the suffix, the value condition and the corresponding value result are optional padding, and the extension metadata name and the reference type are necessary padding. The material master data contained in the present-level category may be selected and a reference type may be specified, and the reference number or value may be used to generate the rule item content.

4) The value condition and the corresponding value result are set as follows in table 2 (NA' indicates that the setting item is not present) only when the rule item type is "material main data":

TABLE 2

In the value condition, the condition operation and the condition value are all necessary to be filled.

4.1 If the value result type in the value result is 'extension metadata', no text content option exists, and the extension metadata name and the second reference type are all necessarily filled.

4.2 If the type of the value result in the value result is text, a text content option exists, which can be a null string, and the extension metadata name and the second reference type are not referenced.

In the embodiment of the application, the rule item type is 'material main data', and the rule item setting comprises an extension metadata name, a reference type, a prefix, a suffix, a value condition and a corresponding value result; the extension metadata name and the reference type are necessary padding, and the prefix, the suffix, the value condition and the corresponding value result are optional padding.

The embodiment of the application is illustrated by material coding rules and material name rules; of course, the naming rule is not limited to the material encoding rule and the material name rule, and in other embodiments, the naming rule may be a material specification rule or other naming rules, and only an appropriate naming rule needs to be defined according to an actual application scenario.

According to the naming convention model described above, material encoding rules are defined for materials (the embodiments of the present application are illustrated by "swimming goggles"), as detailed in Table 3 below:

TABLE 3 Table 3

Sequence number of order	Rule item type	Extending metadata names	Reference type
				1	Material main data	Category(s)	Numbering device
2	Material main data	Process for producing a solid-state image sensor	Numbering device
				3	Material main data	Client and method for providing a customer with a service	Numbering device

The swimming goggles material coding rule consists of three rule items:

1) The first section of the code takes the serial number of the attribute of category in the main data of the material;

2) The second section of the code takes the serial number of the process attribute in the main data of the material;

3) The third section of the code takes the number of the customer in the main data of the material.

According to the naming convention model described above, material name rules are defined for materials (the embodiments of the present application are illustrated by "swimming goggles"), as detailed in Table 4 below:

TABLE 4 Table 4

Sequence number of order	Rule item type	Extending metadata names	Reference type
				1	Material main data	Client and method for providing a customer with a service	Value of
2	Material main data	Category(s)	Value of

The swimming goggles material name rule consists of two rule items:

1) The first section of the name takes the value of the 'client' attribute in the main data of the material;

2) The second section of the name takes the value of the "category" attribute in the main data of the material.

S2, creating material main data.

The material main data comprises a fixed field and an extension field; the fixed field and the extension field are stored in the same database record; the extension field is used for storing extension attributes; the extension attribute is generated through extension metadata; the extension metadata comprises metadata names, metadata types and metadata settings; and the extended attribute carries out assignment according to the metadata type and metadata setting.

Referring to Table 5, fixed fields (material category, material identification, default stock location, and work center) are first created for the material (the embodiments of the application are illustrated with "swimming goggles"); referring to table 6, 7 extension metadata are also created at the same time. Although the metadata types in table 6 are the option table and the association table, it is not limited thereto, but text, numerals, date, whether or not and attachment, etc. may be set accordingly as long as applicable.

It should be noted that the fixed field is a general field and is adapted according to the actual application scenario; the extension metadata is also defined according to the actual application scene, and when the metadata type and metadata setting are assigned, the corresponding extension attribute is generated and stored in the extension field.

For example, the extended attribute of the first piece of main data in table 5 includes: { "fieldName": "category", "fieldType": "options table", "extra": { "dataKey": "150", "dataValue": "swimming goggles" }, { "fieldName": "swimming goggles model", "fieldType": "options table", "extra": "{" dataKey ":"70"," dataValue ":" G70"}, {" fieldName ": version", "fieldType": options table "," extra ": {" dataKey ":"00"," dataValue ":" standard version "}, {" fieldName ": process", "fieldType": "options table", "extra": { "dataKey": ": 01", "dataValue": anti-fog "}, and {" fieldName ": clients", "fieldType": association table "," extra ":" datak ": 01: total }, and }, value" 1"," datak "clients" are extended, and the attributes are all extended.

The data type of the extended attribute is json type, and the data format of the storage content is json object array. It should be noted that the fixed fields and the extension attributes in table 5 are limited to the exemplary embodiments, and are not limited thereto, and the fixed fields and the extension attributes in table 5 may be added or deleted according to the requirements of the application scenario.

TABLE 5

TABLE 6

And S3, acquiring target content from the material main data according to the naming rule.

Referring to fig. 2, step S3 specifically includes the following steps S31 to S34:

s31, acquiring target extension attributes from the material main data according to the extension metadata names.

S32, judging whether the target extension attribute exists or not;

s33, if not, taking the null value as the target content;

and S34, if yes, acquiring target content from the target extension attribute according to the reference type.

Step S3 is elaborated in conjunction with the material main data in table 5, the material encoding rules in table 3, and the material name rules in table 4.

The "swimming goggles 1" in table 5 generates a material code.

As can be seen from table 3, the material coding rule has a total of 3 rule entries.

The acquisition process of the content of the first segment rule item (i.e., the target content 11) is:

because the rule item type is "material master data", the extension attribute { "fieldName": "category", "fieldType": "option list", "extra": { "dataKey": "150", "dataValue": "swimming goggles" } of the extension metadata name "category" is found from "swimming goggles 1" of table 5; the target content "150" is then found by the reference type "number" set by the rule item.

The process of obtaining the content of the second segment of rule items (i.e., the target content 12) is:

because the rule item type is "material master data", the extension attribute { "fieldName": "process", "fieldType": "option list", "extra": { "dataKey": "01", "dataValue": "anti-fog" } }, which is the extension metadata name "process", is found from "swimming goggles 1" of table 5; the target content "01" is then found by the reference type "number" set by the rule item.

The acquisition process of the content of the third segment rule item (i.e., the target content 13) is:

because the rule item type is "material master data", the extension attribute { "fieldName": "client", "fieldType": "association table", "extra": { "dataKey": "K01", "dataValue": "a client" } }, which is the extension metadata name "client", is found from "swimming goggles 1" of table 5; then the target content "K01" is found by the reference type "number" set by the rule item.

The "swimming goggles 1" in table 5 generates the material names.

As can be seen from table 4, the material name rule has a total of 2 rule entries.

The acquisition process of the content of the first segment rule item (i.e., the target content 21) is:

because the rule item type is "material master data", the extension attribute { "fieldName": "client", "fieldType": "association table", "extra": { "dataKey": "K01", "dataValue": "a client" } }, which is the extension metadata name "client", is found from "swimming goggles 1" of table 5; the target content "aclient" is then found by the reference type "value" set by the rule item.

The process of obtaining the content of the second segment of rule items (i.e., the target content 22) is:

because the rule item type is "material master data", the extension attribute { "fieldName": "category", "fieldType": "option list", "extra": { "dataKey": "150", "dataValue": "swimming goggles" } of the extension metadata name "category" is found from "swimming goggles 1" of table 5; the target content "swimming goggles" is then found by the reference type "value" set by the rule item.

In the embodiment of the application, the metadata type only sets an option table and an association table; because the metadata type is set as the option table, the option table is a key value pair of the number and the value, and the reference number or the value can be designated by expanding the metadata assignment once, so that the number and the value are paired in the naming information, and the data consistency and normalization are ensured. The metadata type is set as the association table type, so that various basic data and business data existing in the system can be conveniently referenced, the system data intercommunication and interconnection are achieved, and repeated maintenance is not needed.

Further, in other embodiments, when the metadata type further includes other metadata types (such as text, number, date, etc.) in addition to the option table and the association table, a metadata type judgment step is further included after step S31.

Referring to fig. 3, the metadata type judgment step includes the following steps S311 and S312:

s311, judging whether the metadata type of the target extension attribute is an option table or an association table;

and S312, if yes, acquiring corresponding extended attribute assignment, namely acquiring the target content.

When the metadata type of the target extension attribute is not an option table or an association table, corresponding content is acquired according to the specific metadata type to serve as target content.

Of course, in other embodiments, if the naming rule does not adopt the material encoding rule and the material name rule shown in the above tables 3 and 4, but adopts other forms of naming rule, the metadata type determining step is performed after the target extension attribute is acquired from the material main data through the corresponding naming rule.

Further, in other embodiments, the rule item setting further includes a value condition and a corresponding value result.

When the naming rule is a material coding rule, a rule item is added between the first rule item and the second rule item under the naming rule of table 3, and the added material coding rule is described in the following table 7.

TABLE 7

When the naming rule is a material name rule, a rule item is added between the first rule item and the second rule item under the naming rule of table 4, and the added material name rule is described in the following table 8.

TABLE 8

/>

At this time, after step S34, a step of optimizing the target content acquired in step S34 is further included.

Referring to fig. 4, the step of optimizing the target content acquired in step S34 specifically includes the following steps S341 to S344:

s341, obtaining a corresponding value result according to the target content and the value condition;

s342, judging whether the value result exists or not;

s343, if yes, taking the value result as the final target content;

if not, S344 is performed, the previous target content is used as the final target content.

The target content obtained in the step S34 is subjected to conditional operation through the value condition and the corresponding value result in the rule item setting, and the value result is converted, so that various special naming requirements can be flexibly met, naming rules are widely applied, and full automation and standardization of material naming are realized.

The above steps are described in detail in conjunction with tables 7 and 8 above.

The "swimming goggles 1" in table 5 generates a material code, and the content of the second rule item shown in table 7 is obtained by the following steps:

because the rule item type is "material master data", an extension attribute { "fieldName": "version", "fieldType": "option list", "extra": { "dataKey": "00", "dataValue": "standard version" } } of extension metadata named "version" is found from "swimming goggles 1" of table 5; then, finding out target content '00' through the reference type 'number' set by the rule item; judging whether the target content ' 00 ' is equal to a ' condition value ' 00 ' according to a value-taking condition, if yes, finding out corresponding expansion attribute { "fieldName": "swimming goggles model", "fieldType": "option list", "extra": { "dataKey": "70", "dataValue": "G70" }, according to the value-taking result type being expansion metadata, and then finding out corresponding expansion attribute { "fieldName": "swimming goggles model" }; and obtaining the target content 70 according to the second reference type number in the value result.

If the "swimming goggles 1" in table 5 generates the material name, the procedure for acquiring the content of the second rule item shown in table 8 is as follows:

because the rule item type is "material master data", an extension attribute { "fieldName": "version", "fieldType": "option list", "extra": { "dataKey": "00", "dataValue": "standard version" } } of extension metadata named "version" is found from "swimming goggles 1" of table 5; then, finding out target content '00' through the reference type 'number' set by the rule item; judging whether the target content ' 00 ' is equal to a ' condition value ' 00 ' according to a value-taking condition, if yes, finding out corresponding expansion attribute { "fieldName": "swimming goggles model", "fieldType": "option list", "extra": { "dataKey": "70", "dataValue": "G70" }, according to the value-taking result type being expansion metadata, and then finding out corresponding expansion attribute { "fieldName": "swimming goggles model" }; and obtaining the target content G70 according to the second reference type value in the value result.

Further, when there are a plurality of extension attributes with the same extension metadata name and assigned with different values in the main material data, a plurality of extension attributes are obtained in step S31, so that a plurality of target contents of the rule item obtained in steps S31-S34 are obtained, and at this time, a plurality of target contents (i.e., contents of the rule item) need to be optimized, and a suitable target content is selected.

S4, generating a material standard according to the naming rule and the target content.

The detailed exemplary procedure of the above step S3 is described.

When the "swimming goggles 1" in table 5 are coded and named by adopting the material coding rule in table 3, the target content 11 (150), the target content 12 (01) and the target content 13 (K01) are sequentially ordered according to the ordering sequence number in table 3, and finally the material code of the "swimming goggles 1" is obtained: 15001K01.

When the "swimming goggles 1" in table 5 is coded and named by adopting the material coding rule in table 7, the target content 11 (150), the content (70) of the second rule item in table 7, the target content 12 (01) and the target content 13 (K01) are sequentially ordered according to the ordering serial numbers in table 7, and finally the material code of the "swimming goggles 1" is obtained: 1507001K01.

When the "swimming goggles 1" in table 5 is named by adopting the material name rule in table 4, the target content 21 (a client) and the target content 22 (swimming goggles) are sequentially ordered according to the ordering sequence number in table 4, and finally the material name of the "swimming goggles 1" is obtained: a customer swim goggles.

When the "swimming goggles 1" in table 5 is named by adopting the material name rule in table 8, the target content 21 (a client), the content (G70) of the second rule item in table 8 and the target content 22 (swimming goggles) are sequentially ordered according to the ordering sequence number in table 8, and finally the material name of the "swimming goggles 1" is obtained: a customer G70 swim goggles.

According to the material standard generation method, as the material main data information is represented by the fixed field and the extension field; compared with the existing dynamic extension information technology, the template of the extension attribute is not required to be defined in advance, and only loose extension metadata definition is required to be defined. When the material standard is generated, the set of the expansion attribute of each piece of material main data can be flexibly adjusted according to specific application scenes, so that the contained information elements are more accurate and more suitable for business scenes.

For example, when the swimming goggles 1 in the table 5 are added with other expansion attributes, the naming rules of the tables 7-8 can be redefined, and the rule items are enriched, so that the generated material standard can be more suitable for the requirements of actual application scenes.

In addition, the extended attributes stored in the extended fields are generated through the extended metadata, and assignment is set according to the metadata types and metadata of the extended metadata, so that the characteristic attributes of the main data of the materials can be changed only by changing the extended attributes without changing the fixed fields through frequently modifying codes, further, the main data information of the materials can be rapidly and flexibly maintained to respond to service changes, and further, the service requirements can be met when the material specification is generated.

For example, when the extended attribute { "fieldName": "client", "fieldType": "association table", "extra": { "dataKey": "K01", "dataValue": "a client" } "of" swimming goggles 1 "in table 5 is modified, it becomes {" fieldName ":" client "," fieldType ":" association table "," extra ": {" dataKey ":" K01"," dataValue ":" C client "}; at this time, the material name of the "swimming goggles 1" generated according to the material name rule of table 4 is automatically changed to: c, swimming goggles for customers; the material names for generating the swimming goggles 1 according to the material name rules of table 8 automatically become: c customer G70 swimming goggles.

In other embodiments, rule items may be added, and the rule item types may be set to text or running water, and the corresponding rule item settings may be referred to table 1 above; and then combining rule items in the embodiment of the application, and constructing the material rule more accurately and more in accordance with the service scene together through the ordering rule.

Referring to fig. 5, in response to the above-mentioned method for generating a material standard, an embodiment of the present application further provides a device for generating a material standard, where the device 100 includes: definition unit 110, creation unit 120, acquisition unit 130, and generation unit 140.

The defining unit 110 is configured to define naming rules of the materials;

a creation unit 120 for creating material main data; the material main data comprises a fixed field and an extension field; the fixed field and the extension field are stored in the same database record; the extension field is used for storing extension attributes; the extension attribute is generated through extension metadata; the extension metadata comprises metadata names, metadata types and metadata settings; the extended attribute carries out assignment according to the metadata type and metadata setting;

an obtaining unit 130, configured to obtain target content from the material main data according to the naming rule;

and the generating unit 140 is used for generating the material standard according to the naming rule and the target content.

The material standard generating device corresponds to the material standard generating method one by one, and the specific principle and process are the same as those of the method in the embodiment, and are not repeated.

Fig. 6 is a schematic structural diagram of a computer device according to the present application. The device may be a terminal or a server, where the terminal may be a smart phone, a tablet computer, a notebook computer, or a desktop computer. The server may be an independent server or a server cluster formed by a plurality of servers.

With reference to FIG. 6, the computer device 300 includes a processor 302, a non-volatile storage medium 303, an internal memory 304, and a network interface 305 connected by a system bus 301. The non-volatile storage medium 303 of the computer apparatus 300 may store an operating system 3031 and a computer program 3032, where the computer program 3032, when executed, may cause the processor 302 to perform a material specification generation method. The processor 302 of the computer device 300 is used to provide computing and control capabilities to support the operation of the entire computer device 300. The internal memory 304 provides an environment for the execution of a computer program 3032 in the non-volatile storage medium 303, which when executed by the processor causes the processor 302 to perform a material specification generation method. The network interface 305 of the computer device 300 is for network communication. It will be appreciated by those skilled in the art that the structure shown in FIG. 6 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.

The processor 302 is configured to execute a computer program stored in the memory 304 to implement the material specification generation method described above.

It should be appreciated that in embodiments of the present application, the processor 302 may be a central processing unit (Central Processing Unit, CPU), which may also be other general purpose processors, digital signal processors (Digital Signal Processor, DSPs), application specific integrated circuits (application lication Specific Integrated Circuit, ASICs), off-the-shelf programmable gate arrays (Field-Programmable Gate Array, FPGAs) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

The application also provides a computer readable storage medium storing one or more computer programs executable by one or more processors to implement the above-described method of generating a material specification.

The aforementioned storage medium of the present application includes: various media capable of storing program codes, such as magnetic disk, optical disk, read-Only Memory (ROM), etc.

The units in all embodiments of the application may be implemented by a general-purpose integrated circuit, such as a CPU (Central processing unit)

Processing Unit, central Processing Unit), or by an ASIC (Application Specific Integrated Circuit ).

While the application has been described with reference to certain preferred embodiments, it will be understood by those skilled in the art that various changes and substitutions of equivalents may be made and equivalents will be apparent to those skilled in the art without departing from the scope of the application. Therefore, the protection scope of the application is subject to the protection scope of the claims.

Claims (10)

1. The method for generating the material standard is characterized by comprising the following steps:

defining naming rules of materials;

creating material main data; the material main data comprises a fixed field and an extension field; the fixed field and the extension field are stored in the same database record; the extension field is used for storing extension attributes; the extension attribute is generated through extension metadata; the extension metadata comprises metadata names, metadata types and metadata settings; the extended attribute carries out assignment according to the metadata type and metadata setting;

acquiring target content from the material main data according to the naming rule;

and generating a material standard according to the naming rule and the target content.

2. The material gauge generation method of claim 1, wherein the naming convention includes a rule term and a ranking convention between rule terms;

the obtaining the target content from the material main data according to the naming rule comprises the following steps:

acquiring target content from the material main data according to the rule item;

the generating material standard according to the naming rule and the target content comprises the following steps:

taking the target content as the content of the corresponding rule item;

and generating a material standard according to the ordering rule and the content of each rule item.

3. The material gauge generation method of claim 2, wherein the rule items comprise rule item settings;

the obtaining the target content from the material main data according to the rule item comprises the following steps:

and acquiring target content from the material main data according to the rule item setting.

4. A material specification generation method according to claim 3, wherein the rule item settings contain an extended metadata name and a reference type;

the obtaining the target content from the material main data according to the rule item setting comprises the following steps:

acquiring target extension attributes from the material main data according to the extension metadata names;

judging whether the target extension attribute exists or not;

if not, taking the null value as the target content;

if yes, acquiring target content from the target extension attribute according to the reference type.

5. The method for generating a material standard according to claim 4, wherein the rule item setting further comprises a value condition and a corresponding value result;

after the target content is obtained from the target extension attribute according to the reference type, the method further comprises the following steps:

acquiring a corresponding value result according to the target content and the value condition;

judging whether the value result exists or not;

if yes, taking the value result as the final target content;

if not, the previous target content is taken as the final target content.

6. The material specification generation method according to claim 1, wherein the metadata type includes an option table and an association table;

the obtaining the target content from the material main data according to the naming rule comprises the following steps:

acquiring target extension attributes from the material main data according to the naming rules;

judging whether the metadata type of the target extension attribute is an option table or an association table;

if yes, acquiring corresponding extended attribute assignment, namely acquiring the target content.

7. The method for generating a material standard according to claim 2, wherein the step of generating a material standard according to the ranking rule and the content of each rule item comprises the steps of:

optimizing the content of each rule item;

and generating a material standard according to the sorting rule and the optimized content of each rule item.

8. A material gauge generating device, comprising:

the definition unit is used for defining naming rules of the materials;

the creation unit is used for creating material main data; the material main data comprises a fixed field and an extension field; the fixed field and the extension field are stored in the same database record; the extension field is used for storing extension attributes; the extension attribute is generated through extension metadata; the extension metadata comprises metadata names, metadata types and metadata settings; the extended attribute carries out assignment according to the metadata type and metadata setting;

the acquisition unit is used for acquiring target content from the material main data according to the naming rule;

and the generating unit is used for generating a material standard according to the naming rule and the target content.

9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the material specification generation method of any one of claims 1-7 when the computer program is executed by the processor.

10. A computer readable storage medium storing one or more computer programs executable by one or more processors to implement the material specification generation method of any one of claims 1-7.