CN113919820A - Formula management system based on ERP system and control method - Google Patents
Formula management system based on ERP system and control method Download PDFInfo
- Publication number
- CN113919820A CN113919820A CN202111288453.5A CN202111288453A CN113919820A CN 113919820 A CN113919820 A CN 113919820A CN 202111288453 A CN202111288453 A CN 202111288453A CN 113919820 A CN113919820 A CN 113919820A
- Authority
- CN
- China
- Prior art keywords
- formula
- recipe
- final
- module
- management system
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 23
- 238000007726 management method Methods 0.000 claims abstract description 54
- 238000012550 audit Methods 0.000 claims abstract description 8
- 239000003973 paint Substances 0.000 claims description 69
- 238000004458 analytical method Methods 0.000 claims description 25
- 238000003860 storage Methods 0.000 claims description 15
- 238000004590 computer program Methods 0.000 claims description 6
- 238000013480 data collection Methods 0.000 claims description 3
- 238000013523 data management Methods 0.000 abstract description 3
- 230000008569 process Effects 0.000 abstract description 3
- 238000012423 maintenance Methods 0.000 description 16
- 230000000694 effects Effects 0.000 description 5
- 230000006870 function Effects 0.000 description 5
- 230000002159 abnormal effect Effects 0.000 description 4
- 238000012163 sequencing technique Methods 0.000 description 4
- 238000012384 transportation and delivery Methods 0.000 description 4
- 230000000295 complement effect Effects 0.000 description 3
- 238000007728 cost analysis Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 238000005507 spraying Methods 0.000 description 3
- 238000012795 verification Methods 0.000 description 3
- 239000003086 colorant Substances 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000009826 distribution Methods 0.000 description 2
- 238000009472 formulation Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 238000013439 planning Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 230000008439 repair process Effects 0.000 description 2
- 238000012552 review Methods 0.000 description 2
- 239000007921 spray Substances 0.000 description 2
- 230000004913 activation Effects 0.000 description 1
- 230000002411 adverse Effects 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- -1 annual money Substances 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 239000011248 coating agent Substances 0.000 description 1
- 238000000576 coating method Methods 0.000 description 1
- 239000004595 color masterbatch Substances 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 239000003814 drug Substances 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 239000004615 ingredient Substances 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 239000013615 primer Substances 0.000 description 1
- 239000002987 primer (paints) Substances 0.000 description 1
- 230000002035 prolonged effect Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 230000002441 reversible effect Effects 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000000126 substance Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 239000002966 varnish Substances 0.000 description 1
- 210000003462 vein Anatomy 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/53—Querying
- G06F16/535—Filtering based on additional data, e.g. user or group profiles
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/58—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
- G06F16/583—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using metadata automatically derived from the content
- G06F16/5838—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using metadata automatically derived from the content using colour
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/58—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
- G06F16/5866—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using information manually generated, e.g. tags, keywords, comments, manually generated location and time information
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/58—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
- G06F16/587—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using geographical or spatial information, e.g. location
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
- G06F21/31—User authentication
- G06F21/32—User authentication using biometric data, e.g. fingerprints, iris scans or voiceprints
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/602—Providing cryptographic facilities or services
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/20—Administration of product repair or maintenance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/80—Management or planning
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Strategic Management (AREA)
- Library & Information Science (AREA)
- Computer Security & Cryptography (AREA)
- Tourism & Hospitality (AREA)
- Health & Medical Sciences (AREA)
- Entrepreneurship & Innovation (AREA)
- Computer Hardware Design (AREA)
- Software Systems (AREA)
- General Health & Medical Sciences (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Bioethics (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- General Factory Administration (AREA)
Abstract
The invention discloses a formula management system and a control method based on an ERP system, which relate to the technical field of data management and comprise a formula database used for storing the existing formula; the formula query module is used for receiving query conditions, acquiring the existing formula from the formula database and outputting an initial formula; the formula data acquisition module is used for acquiring an initial formula and a final formula; the formula data comparison module is used for comparing and analyzing the initial formula and the final formula and comparing and analyzing the final formula and the existing formula; the formula query module, the formula data acquisition module and the formula data comparison module are all connected with a system service bus. The invention provides a novel solution for the problems of dependence on manual operation, long time consumption, high cost, easy error and the like of the existing formula management, can reliably collect formula data, automatically classifies and processes newly generated formula data, and quickly analyzes, audits and updates the adopted times of the existing formula.
Description
Technical Field
The invention relates to the technical field of data management, in particular to a formula management system and a control method based on an ERP system.
Background
The formula management system has more applications in research and production in the industries of medicine, chemical industry, food, catering, feed, coating and the like, and has an obvious effect on improving the production efficiency. However, the existing formula management system has many defects, formula management depends on manual operation, the time consumption is long, the cost is high, errors are easy to occur, especially, the collection of formula data is inaccurate, the effectiveness of the formula data is difficult to evaluate, an effective means is lacked for utilizing a formula database, the functional relation between the formula management system and an ERP system is less, information is not shared, especially, a large amount of refinish paint formulas in the ERP system in the automobile maintenance industry cannot be effectively utilized, maintenance personnel cannot obtain the refinish paint formulas which are sufficiently adapted quickly, the working efficiency of the automobile maintenance industry is reduced, and the waiting time of an automobile owner is prolonged.
Disclosure of Invention
Aiming at the technical problems that the existing formula management depends on manual operation, is long in time consumption, high in cost and easy to make mistakes, the formula management system and the control method based on the ERP system can reliably collect formula data, automatically classify and process newly generated formula data, quickly analyze and check and update the adopted times of the existing formula.
In order to solve the problems, the technical scheme provided by the invention is as follows:
the control method of the formula management system comprises the following steps: executing a self-checking program, and judging whether the working state of the formula data acquisition module is normal or not; if the working state of the formula data acquisition module is normal, prompting that the state is normal and starting to acquire an initial formula and a final formula; the formula query module queries and outputs an initial formula in a formula database according to query conditions; the formula data comparison module compares and analyzes the initial formula and the final formula and judges whether the final formula is consistent with the initial formula or not; and if the initial formula is consistent with the final formula, judging whether the color difference between the sample plate color made by adopting the final formula and the target color exceeds a preset range, if so, listing the final formula in an inefficient formula library, and if not, updating the adopted record of the initial formula. The final formula determined by the user may be consistent with or repeated by the initial formula, the final formula which does not meet the requirement can be screened out through comparison analysis, and the adopted record of the initial formula is only updated for the final formula which meets the requirement, so that the repeated formula is prevented from being added into the formula database, and the final formula is recorded into a maintenance work order.
Optionally, if the initial formula and the final formula are not consistent, the formula data comparison module compares and analyzes the final formula and an existing formula in the formula database, determines whether the final formula and the existing formula are consistent, if the final formula and the existing formula are consistent, determines whether a color difference between a sample color and a target color manufactured by using the final formula exceeds a preset range, if so, the final formula is listed in an inefficient formula library, and if not, the adopted record of the existing formula is updated. The final formula determined by the user may be consistent with or repeated by the existing formula in the formula database, and the comparison analysis can avoid adding the repeated formula into the formula database, reduce the number of processing objects in subsequent steps and reduce the running expense of the formula management system.
Optionally, if the final formula is inconsistent with the existing formula, determining whether the final formula meets a paint mixing rule, if so, performing formula compliance audit on the final formula, and if not, listing the final formula in a low-allocation formula library.
Optionally, judging whether the final formula passes the formula compliance audit, and if so, listing the final formula in a formula library to be verified; if not, the final formula is listed in a problem formula library, and the integral of a paint mixing operator is adjusted.
Optionally, the formula query module transmits the query condition to the formula matching analysis module after receiving the query condition, the formula matching analysis module judges whether the query condition is matched with formula data stored in the formula database, if so, the formula query result is output, and if not, no related formula is prompted.
To achieve the object of the present invention, the present invention also provides a recipe management system comprising: a recipe database for storing existing recipes; the formula query module is used for receiving query conditions, acquiring the existing formula from the formula database and outputting an initial formula; the formula data acquisition module is used for acquiring an initial formula and a final formula; and a recipe data comparison module for comparing analysis of the initial recipe and the final recipe and comparing analysis of the final recipe and the existing recipe; the formula query module, the formula data acquisition module and the formula data comparison module are all connected with a system service bus; the recipe management system is used for executing the control method of the recipe management system. The existing formula can be obtained through the formula query module and can be used as an initial formula, so that the usability of the existing formula is improved, and a user can obtain the available formula conveniently. When the initial formula comes from the outside of the formula database, the formula data comparison module is also used for comparison and analysis of the initial formula and the existing formula, and a user can edit the formula data in the formula query module and then output the initial formula.
Optionally, the system further comprises a login authentication module connected to the system service bus, and the login authentication module is configured to log in the recipe management system and obtain a recipe management authority. The formula management authority comprises a formula inquiry authority, a formula viewing authority, a formula auditing authority and a formula editing authority. Different functions are provided for different users by configuring different formula management authorities, the formula inquiry authority and the formula viewing authority are configured for system users or paint mixing operators, the system users or the paint mixing operators only have the authority to view the formulas in the formula inquiry results and the formulas submitted autonomously, the formulas submitted autonomously comprise the temporarily stored formulas after being edited and the formulas which are recorded by the system and generated by the system users or the paint mixing operators through paint mixing operation, and the formula auditing authority and the formula editing authority are configured for the system administrators.
Optionally, the recipe query module is connected to the recipe matching analysis module. The formula matching analysis module is connected with the formula database.
Optionally, the recipe database is disposed on a resource server, and the recipe query module, the recipe data acquisition module, and the recipe data comparison module are all connected to the resource server. The resource server is preferably a cloud server.
Optionally, the formula data acquisition module is connected to a terminal device. The terminal equipment comprises an automatic color mixer, a code scanning gun or an online electronic scale.
To achieve the object of the present invention, the present invention also provides a computer-readable storage medium having stored therein a computer program or a set of codes, which when executed by a processor, implement part or all of the steps of the control method of the recipe management system.
Compared with the prior art, the technical scheme provided by the invention has the following beneficial effects:
(1) the required formula data can be acquired through the formula query module, the formula data can meet the use or management requirements of different users by means of the login authentication module, and meanwhile, the information availability in formula data management and the overall confidentiality requirement of the formula data are balanced;
(2) the automatic formula data acquisition is realized, the sources of the formula data are diversified, a user can independently submit a new formula generated in the paint mixing operation, and the newly generated formula data are classified and stored after being checked and audited, so that the formula data can be further managed and processed conveniently;
(3) the acquired formula data are more accurate, manual operation and input errors are eliminated as much as possible, errors caused by human factors are not prone to occurring, the formula data are acquired more efficiently, and information recorded by each formula data is more comprehensive;
(4) operations related to the formula data can be recorded by the system, the generation, editing, adoption and other operations of the formula data have traceability, the formula data have associability, information provided by a formula data query result after association is realized is richer, and a user can select a proper formula conveniently;
(5) by setting the low-efficiency formula library, the low-distribution formula library, the problem formula library and the formula library to be verified, the paint mixing efficiency is obtained while effective formulas are distinguished, evaluation can be given to the historical performance of a paint mixing operator in the forms of integration and the like, and the grading of formula data and the sequencing display of formula query results are facilitated;
(6) the final formula is compared with the initial formula through step-by-step comparison and analysis of formula data, the final formula is compared with the existing formulas except the initial formula in a formula database, repeated formulas and low-efficiency formulas with chromatic aberration can be screened in advance, unnecessary subsequent inspection steps are reduced, and the system operation load is reduced;
(7) by updating the initial formula or the adopted record of the existing formula, the reference dimension can be added to the formula query result, other paint mixing operators can judge and select the formula more easily when querying the formula, and the time of paint mixing and maintenance operation is indirectly shortened.
Drawings
FIG. 1 is a schematic structural diagram of a recipe management system according to an embodiment of the present invention;
FIG. 2 is a flowchart of a control method for a recipe management system according to an embodiment of the present invention.
Detailed Description
Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the accompanying drawings are illustrative only for the purpose of explaining the present invention, and are not to be construed as limiting the present invention.
In the description of the present invention, it should be noted that, unless otherwise explicitly specified or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, e.g., as being fixedly connected, integrally connected, or detachably connected; either mechanically or electrically, or internally communicating two elements; they may be directly connected or indirectly connected through an intermediate, and those skilled in the art will understand the specific meanings of the above terms according to specific situations.
The formula management system shown in fig. 1 includes a formula database, a formula query module, a formula data acquisition module, and a formula data comparison module, wherein the formula database is used for storing the existing formula; the existing formula data in the formula database comprises one or more information of vehicle type, vehicle body color, vehicle delivery time, paint mixing operators, formula generation time, maintenance parts, weather during maintenance, spray gun model, spraying air pressure, vehicle paint delivery batch, vehicle paint brand and the like, and the formula query module is used for receiving query conditions, acquiring an existing formula in the formula database and outputting an initial formula; the formula data acquisition module is used for acquiring an initial formula and a final formula; the formula data comparison module is used for comparison analysis of the initial formula and the final formula and comparison analysis of the final formula and the existing formula; the formula query module, the formula data acquisition module and the formula data comparison module are all connected with a system service bus; the formula database is arranged on the resource server, and the formula query module, the formula data acquisition module and the formula data comparison module are all connected with the resource server. The formula management system also comprises a login authentication module connected with the system service bus, and the login authentication module is used for logging in the formula management system and obtaining the formula management authority. The resource server is preferably a cloud server, so that paint mixing operators can conveniently log in and use the formula management system.
The login authentication module comprises a login receiving module, a password authentication module and an identity authentication module, wherein the login receiving module is used for receiving user information and a user password, the user information comprises a user name and a user group, the user group is classified according to the formula management authority of the user, and the user group comprises a system administrator, a system user or a paint mixing operator; the password verification module comprises an encryption algorithm capable of encrypting a user password and a user name, the identity authentication module is connected with a biological information identification module, and the biological information identification module is used for processing biological information such as fingerprint information, face information, iris information or vein information.
The formula query module is connected with the formula matching analysis module, the formula matching analysis module is connected with the formula database, the formula data acquisition module is connected with the terminal equipment, and the terminal equipment comprises a touch screen, a keyboard, an automatic color mixer, a code scanning gun or an online electronic scale.
The formula query module comprises an input module, a retrieval module and a sequencing module, wherein the input module is used for receiving query conditions, the query conditions comprise vehicle type information, vehicle body color and target color information of a maintenance part, the target color can be collected through a color measuring instrument, the formula query module can be connected with the color measuring instrument so as to collect the target color, the activation condition of the retrieval module can be set as correct input of the query conditions, the input module is connected with a vehicle type database arranged on a Resource server, the vehicle type database comprises information of vehicle types, vehicle body colors, annual money, vehicle paint suppliers, vehicle pictures and the like, the vehicle type database is arranged in an ERP (Enterprise Resource Planning) system in the automobile maintenance industry, if the vehicle type information and the vehicle body color do not accord with each other, for example, a certain annual money of the vehicle type does not have a certain color, the query conditions are prompted to be input wrongly, the formula query module takes the target color information collected by the color measuring instrument as a priority condition, under the premise that an ERP system in the automobile maintenance industry sets a work order and a work order number, a paint mixing operator logs in a formula management system and can acquire target color information through a color meter and input the target color information into a formula query module to activate a retrieval module, the vehicle type information and the vehicle body color information search related formula data in a formula database, a sorting module is connected with a vehicle paint database arranged on a resource server, the sorting module comprises a default sorting unit and a re-sorting unit, the default sorting unit is used for sorting and displaying a formula query result according to preset rules, the preset rules include but are not limited to preferentially displaying a formula with more vehicle paint stock or displaying a formula with less vehicle paint stock behind after the stock information of the vehicle paint database is associated with the formula data, and the preset rules recommend the formula with sufficient vehicle paint to a user, so that the information sharing and cooperation between a formula management system and an ERP system are realized; the re-ordering unit is used for ordering and displaying the formula query result according to an ordering type specified by a user, wherein the ordering type specified by the user comprises time ordering, relevance ordering, paint mixing operator ordering, weather ordering, cost ordering, adoption time ordering and distance ordering. The time sorting is in order of the current month and the adjacent months of formula query, the closer the formula generation time is to the formula query current date, the higher the reference value is, if the formula data of the current month or the adjacent months are not, the formula data generated in the same month and the adjacent months in the past year are preferentially displayed, because the effect of refinish paint operation is influenced by air temperature and air humidity, the formula query and refinish paint operation are generally required to be performed on the same day, and the operation conditions of the formula data of the current month are closer; the distance sorting takes the formulation inquiry location as a starting point to calculate the distance of the formulation data generation location in the inquiry result, and the closer the distance is, the closer the region climate and weather are, the closer the operation condition is, the more the reference value is. And the relevance ranking is performed by matching formula data information according to the matching numbers of the vehicle type, the vehicle body color, the vehicle delivery time, the formula generation time, the maintenance part and the vehicle paint brand, and the formula data with higher matching number is preferentially displayed.
The formula management system further comprises a communication module connected with the system service bus, the communication module is connected with the internet, the formula management system can acquire weather information and a time stamp through the internet, and the weather information and the time stamp can be associated with the work order so as to ensure the accuracy of the information.
In other embodiments, when the initial recipe is from outside the recipe database, the recipe data comparison module is further used for comparison analysis between the initial recipe and the existing recipe, and the user can edit the recipe data in the recipe query module and then output the initial recipe.
In other embodiments, the formula management system further comprises a formula cost analysis module connected with the formula query module, the formula cost analysis module is connected with a vehicle paint database arranged on the resource server, the vehicle paint database comprises brand, price and stock information of color masterbatch, varnish, primer, spraying auxiliary materials and the like, the vehicle paint database is arranged in an ERP (enterprise resource planning) system in the automobile maintenance industry, and the formula cost analysis module is used for calculating the cost, especially the material cost, of the formula data shown in the formula query result, so that the formula query result can be sorted according to the cost, and a paint mixing operator can conveniently evaluate the availability of the formula from the cost perspective.
The control method for the recipe management system as shown in fig. 2 includes the steps of: executing a self-checking program, and judging whether the working state of the formula data acquisition module is normal or not; if the working state of the formula data acquisition module is normal, prompting that the state is normal and starting to acquire an initial formula and a final formula; the formula query module queries in a formula database according to query conditions and outputs an initial formula; the final formula is determined by a user, in the process of paint mixing operation, a paint mixing operator or an automatic color mixer can adjust the formula, a formula management system records the time and the times of the formula adjusting operation in real time, the final formula is collected by a formula data collection module through a touch screen, a keyboard, the automatic color mixer, a code scanning gun or an online electronic scale, after a user clicks a 'finish' button on an operation interface of the formula management system, the formula management system sends a finish instruction to the formula data acquisition module, the formula data acquisition module takes recently acquired formula data as a final formula, the formula data acquisition module associates an initial formula and the final formula to a work order number, the formula data acquisition module associates the formula adjustment times to the work order number or a paint mixing operator, and the formula data comparison module compares and analyzes the initial formula and the final formula to judge whether the final formula and the initial formula are consistent; and if the initial formula is consistent with the final formula, judging whether the color difference between the sample plate color made by adopting the final formula and the target color exceeds a preset range, if so, listing the final formula in a low-efficiency formula library, adjusting the integral of a paint mixing operator, and if not, updating the adopted record of the initial formula. The color of the sample plate is obtained by preparing a repair paint sample according to a final formula and spraying the repair paint sample on the sample plate by using a spray gun; the target color is the color of the maintenance part, the target color information is collected by a color measuring instrument, the color difference between the sample plate color and the target color is detected by a color difference instrument, if the initial formula is from a formula database, the initial formula belongs to the existing formula, and the adopted record of the existing formula corresponding to the initial formula is updated; if the initial formula is from the formula database, the initial formula comprises formula data generated by inputting data by a paint mixing operator and editing the data on the basis of the existing formula, and the initial formula is subjected to comparison analysis of the formula data comparison module to confirm that the initial formula does not have consistent formula data in the formula database, the initial formula is recorded in the formula database. Because the color difference calculation formulas adopted by different color difference meters are possibly different, the preset range of the color difference can be set according to the model or the type of the color difference meter.
The control method can automatically check the working state of the formula data acquisition module, remind a user in time, avoid the adverse effect of faults on paint mixing work, ensure the accuracy and correctness of data acquisition, set a self-checking program to be periodically executed, set a self-checking period according to the needs of the user or automatically set by the user, output an error code if the self-checking program judges that the working state of the formula data acquisition module is abnormal, record the time and the error code of the abnormal state by the formula management system, send an instruction to prompt the abnormal state by the self-checking program, display a prompting frame or alarm information by the formula management system through display equipment to prompt the abnormal state, and output alarm sound through a loudspeaker.
If the initial formula is inconsistent with the final formula, the formula data comparison module compares and analyzes the final formula with the existing formula in the formula database, judges whether the final formula is consistent with the existing formula, if the final formula is consistent with the existing formula, judges whether the color difference between the sample color made by adopting the final formula and the target color exceeds a preset range, if so, lists the final formula into an inefficient formula library, and if not, updates the adopted record of the existing formula. And screening formula data meeting the requirements through color difference judgment, updating the adopted times of the formula, wherein the adopted times of the formula can be used for displaying the sequencing of the formula query result, and the more the adopted times of the formula are, the more the sequencing of the formula is advanced.
And if the final formula is not consistent with the existing formula, judging whether the final formula accords with a paint mixing rule, if so, performing formula compliance audit on the final formula, and if not, listing the final formula in a low-distribution formula library to adjust the paint mixing operator score. The paint mixing rule comprises an intermediate color principle, namely any two non-complementary colors are mixed to obtain an intermediate color; complementary color principle, that is, the color A and the complementary color of the color A are mixed to obtain black; the substitution principle is as follows: that is, the color master A can be replaced by the color master B, the color mixing effects of the color master A and the color master B are similar, the brightness of the color master can be improved by adding white or reduced by adding black, and the paint mixing rule also comprises the paint mixing requirement determined according to the color master characteristics.
Judging whether the final formula passes the formula compliance audit or not, and if so, listing the final formula in a formula library to be verified; if not, the final formula is listed in a problem formula library, and the integral of a paint mixing operator is adjusted. The paint mixing operator comprises a manual work and a machine, the machine paint mixing operator comprises an automatic color mixer or a color mixing system, when the paint mixing operation is performed manually, formula compliance verification is particularly necessary, the formula compliance verification comprises but is not limited to judging whether contradictions or inconsistency exist according to comparison between operation data collected by terminal equipment connected with a formula data collection module and final formula data, or judging whether the situation is obviously unreasonable according to vehicle paint stock information of a vehicle paint database, for example, the stock of a certain ingredient in the final formula is obviously insufficient.
The formula query module transmits the query condition to the formula matching analysis module after receiving the query condition, the formula matching analysis module judges whether the query condition is matched with formula data stored in the formula database, if so, the formula query result is output, and if not, no related formula is prompted. And the formula data in the formula query result is decrypted by the decryption module and then output, and whether decryption is performed or not is determined according to the formula management authority of the user. The recipe data for the recipe matching analysis module to perform the matching analysis does not include the recipe data of the problem recipe library.
In other embodiments, for recipe data that is listed in the low efficiency recipe library, the low dispense recipe library, and the problem recipe library, the recipe data including a final recipe and an initial recipe associated with the final recipe, the recipe management system may analyze the given cause for reference by a user of the recipe management system based on paint mixing rules or recipe compliance audit rules.
In other embodiments, the formula data in the formula library to be verified may be algorithmically verified and transferred to the verified formula library.
In other embodiments, the recipe data may be subject to review and the recipe query results may present review information for the recipe data.
In other embodiments, when the vehicle paint stock in the vehicle paint database is not sufficient, the formula management system may determine whether to remind the user to replenish the vehicle paint according to the vehicle paint consumption or sales data of the region where the user is located in combination with the common vehicle paint category of the user, and the ERP system in the automobile maintenance industry may adjust the supply price of the vehicle paint in the ERP system according to the vehicle paint consumption or sales data.
In other embodiments, for the work order associated with the final formula with the color difference not exceeding the preset range and the work order associated with the final formula listed in the formula library to be verified, the formula management system can analyze the paint mixing efficiency according to the formula adjustment times and the paint mixing effect, so as to adjust the integral of a paint mixing operator, wherein the less the adjustment times, the smaller the color difference given by the color difference meter, the higher the satisfaction degree of an owner, and the additional points are given.
Each piece of formula data generated by paint mixing operation in the formula database comprises information such as work order number, vehicle type, vehicle body color, automobile delivery time, formula generation time, maintenance part, formula generation place or maintenance place, name or code of paint mixing operator, paint mixing operator score, formula cost, verified mark, comment information, adopted times, vehicle paint brand and the like.
Embodiments of the present invention also provide a computer storage medium, in which a computer program or a code set is stored, and when the computer program or the code set is executed by a processor or a computer, the computer program or the code set controls the readable storage medium to perform part or all of the steps of the control method for the recipe management system. The computer comprises a personal computer, a tablet computer, a notebook computer, a palm computer, a mobile phone or a server.
The computer readable storage medium may be a computer readable signal medium or a computer readable storage medium or any combination of the two. The computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, a magnetic card, an IC card, a flash disk, an SD card, or the like. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any combination of the foregoing. A computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any combination thereof. A computer readable signal medium may also be any computer readable storage medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable storage medium may be transmitted using any appropriate medium, including but not limited to: wireless, wired, fiber optic cable, radio frequency signals, and the like.
The flowcharts in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer programs according to embodiments of the present invention. Each block of the flowchart illustrations may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functional requirements. Each block of the block diagrams or flowchart illustrations, or combinations of blocks in the flowchart illustrations, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The present invention and its embodiments have been described above schematically, without limitation, and what is shown in the drawings is only one of the embodiments of the present invention, and the actual structure is not limited thereto. Therefore, if the person skilled in the art receives the teaching, without departing from the spirit of the invention, the person skilled in the art shall not inventively design the similar structural modes and embodiments to the technical solution, but shall fall within the scope of the invention.
Claims (10)
1. The control method of the formula management system is characterized by comprising the following steps:
executing a self-checking program, and judging whether the working state of the formula data acquisition module is normal or not;
if the working state of the formula data acquisition module is normal, prompting that the state is normal and starting to acquire an initial formula and a final formula;
the formula query module queries and outputs an initial formula in a formula database according to query conditions;
the formula data comparison module compares and analyzes the initial formula and the final formula and judges whether the final formula is consistent with the initial formula or not;
and if the initial formula is consistent with the final formula, judging whether the color difference between the sample plate color made by adopting the final formula and the target color exceeds a preset range, if so, listing the final formula in an inefficient formula library, and if not, updating the adopted record of the initial formula.
2. The method for controlling a recipe management system according to claim 1, wherein if the initial recipe and the final recipe are not identical, the recipe data comparison module compares and analyzes the final recipe and an existing recipe in the recipe database, determines whether the final recipe and the existing recipe are identical, and if the final recipe and the existing recipe are identical, determines whether a color difference between a target color and a template color manufactured using the final recipe is out of a preset range, and if so, lists the final recipe in a low-efficiency recipe library, and if not, updates a usage record of the existing recipe.
3. The method according to claim 2, wherein if the final recipe is not consistent with an existing recipe, determining whether the final recipe meets a paint mixing rule, if so, performing a recipe compliance audit on the final recipe, and if not, listing the final recipe in a low-allocation recipe library.
4. The control method of the recipe management system according to claim 3, wherein it is determined whether the final recipe passes the recipe compliance audit, and if so, the final recipe is listed in a recipe library to be verified; if not, the final formula is listed in a problem formula library, and the integral of a paint mixing operator is adjusted.
5. The method for controlling a recipe management system according to any one of claims 1 to 4, wherein the recipe query module transmits the query condition to a recipe matching analysis module after receiving the query condition, the recipe matching analysis module determines whether the query condition matches the recipe data stored in the recipe database, and outputs a recipe query result if the query condition matches the recipe data, or prompts no related recipe if the query condition does not match the recipe data stored in the recipe database.
6. The recipe management system is characterized by comprising: a recipe database for storing existing recipes;
the formula query module is used for receiving query conditions, acquiring the existing formula from the formula database and outputting an initial formula;
the formula data acquisition module is used for acquiring an initial formula and a final formula;
and a recipe data comparison module for comparing analysis of the initial recipe and the final recipe and comparing analysis of the final recipe and the existing recipe;
the formula query module, the formula data acquisition module and the formula data comparison module are all connected with a system service bus;
the recipe management system is configured to execute a control method of the recipe management system according to any one of claims 1 to 5.
7. The recipe management system of claim 6, further comprising a login authentication module coupled to the system service bus, the login authentication module configured to log into the recipe management system and obtain recipe management privileges.
8. The recipe management system of claim 7, the recipe query module coupled to a recipe match analysis module.
9. The recipe management system according to any one of claims 6 to 8, wherein the recipe database is provided on a resource server, and the recipe query module, the recipe data collection module, and the recipe data comparison module are connected to the resource server.
10. A computer-readable storage medium, wherein a computer program or a set of codes is stored in the computer-readable storage medium, which when executed by a processor implements the control method of the recipe management system of any one of claims 1 to 5.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111288453.5A CN113919820B (en) | 2021-11-02 | 2021-11-02 | Formula management system based on ERP system and control method |
| CN202210644297.XA CN114997828A (en) | 2021-11-02 | 2021-11-02 | Formula management system for ERP in automobile maintenance industry and control method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111288453.5A CN113919820B (en) | 2021-11-02 | 2021-11-02 | Formula management system based on ERP system and control method |
Related Child Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210644297.XA Division CN114997828A (en) | 2021-11-02 | 2021-11-02 | Formula management system for ERP in automobile maintenance industry and control method thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113919820A true CN113919820A (en) | 2022-01-11 |
| CN113919820B CN113919820B (en) | 2022-09-06 |
Family
ID=79245108
Family Applications (2)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210644297.XA Pending CN114997828A (en) | 2021-11-02 | 2021-11-02 | Formula management system for ERP in automobile maintenance industry and control method thereof |
| CN202111288453.5A Active CN113919820B (en) | 2021-11-02 | 2021-11-02 | Formula management system based on ERP system and control method |
Family Applications Before (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210644297.XA Pending CN114997828A (en) | 2021-11-02 | 2021-11-02 | Formula management system for ERP in automobile maintenance industry and control method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (2) | CN114997828A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2009000682A (en) * | 1999-12-17 | 2009-01-08 | Ppg Ind Ohio Inc | Computer-implemented method and apparatus for matching paint |
| CN108733735A (en) * | 2017-04-25 | 2018-11-02 | 车急修汽车科技有限公司 | A kind of methods, devices and systems of inquiry paint formula |
| CN108920679A (en) * | 2018-07-10 | 2018-11-30 | 新疆华泰重化工有限责任公司 | Experimental monitoring data information management system and application method |
| CN109446253A (en) * | 2018-09-25 | 2019-03-08 | 平安科技（深圳）有限公司 | Data query control method, device, computer equipment and storage medium |
| CN111177671A (en) * | 2019-12-16 | 2020-05-19 | 北京淇瑀信息科技有限公司 | Data management platform and method and electronic equipment |
| CN111352921A (en) * | 2020-02-19 | 2020-06-30 | 中国平安人寿保险股份有限公司 | ELK-based slow query monitoring method and device, computer equipment and storage medium |
| CN111427284A (en) * | 2020-05-15 | 2020-07-17 | 杭州以诺行汽车科技股份有限公司 | Color matching system and method for automobile paint |
| CN111950893A (en) * | 2020-08-11 | 2020-11-17 | 上海凯宝健康科技有限公司 | Formula management system |
-
2021
- 2021-11-02 CN CN202210644297.XA patent/CN114997828A/en active Pending
- 2021-11-02 CN CN202111288453.5A patent/CN113919820B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2009000682A (en) * | 1999-12-17 | 2009-01-08 | Ppg Ind Ohio Inc | Computer-implemented method and apparatus for matching paint |
| CN108733735A (en) * | 2017-04-25 | 2018-11-02 | 车急修汽车科技有限公司 | A kind of methods, devices and systems of inquiry paint formula |
| CN108920679A (en) * | 2018-07-10 | 2018-11-30 | 新疆华泰重化工有限责任公司 | Experimental monitoring data information management system and application method |
| CN109446253A (en) * | 2018-09-25 | 2019-03-08 | 平安科技（深圳）有限公司 | Data query control method, device, computer equipment and storage medium |
| CN111177671A (en) * | 2019-12-16 | 2020-05-19 | 北京淇瑀信息科技有限公司 | Data management platform and method and electronic equipment |
| CN111352921A (en) * | 2020-02-19 | 2020-06-30 | 中国平安人寿保险股份有限公司 | ELK-based slow query monitoring method and device, computer equipment and storage medium |
| CN111427284A (en) * | 2020-05-15 | 2020-07-17 | 杭州以诺行汽车科技股份有限公司 | Color matching system and method for automobile paint |
| CN111950893A (en) * | 2020-08-11 | 2020-11-17 | 上海凯宝健康科技有限公司 | Formula management system |
Non-Patent Citations (4)
| Title |
|---|
| 谢健等: "化工涂料行业ERP的关键问题研究", 《计算技术与自动化》 * |
| 谢健等: "化工涂料行业ERP的关键问题研究", 《计算技术与自动化》, no. 02, 30 June 2004 (2004-06-30) * |
| 黄国光等: "经济实用的涂料印花色彩ERP管理系统", 《染整技术》 * |
| 黄国光等: "经济实用的涂料印花色彩ERP管理系统", 《染整技术》, no. 12, 20 December 2015 (2015-12-20), pages 43 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114997828A (en) | 2022-09-02 |
| CN113919820B (en) | 2022-09-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR100486987B1 (en) | Computer-implemented method and apparatus for matching paint | |
| CN113886712B (en) | ERP-based artificial intelligent automobile maintenance recommendation method, system and storage medium | |
| CN107153971B (en) | Method and device for identifying equipment cheating in APP popularization | |
| CN108009199A (en) | A kind of search method and system of measurement and calibration calibration certificate | |
| CN101599141A (en) | The system and method that validity control is carried out in report to the Zheng Shu of measurement technology mechanism | |
| CN111461517A (en) | Intelligent information system for planning laboratory workflow | |
| CN105931007A (en) | Damage assessment checking method, server, and terminal | |
| CN113780998B (en) | Integrated information management method for engineering project execution and implementation | |
| CN111104589A (en) | Decoration enterprise evaluation method and device, computer equipment and storage medium | |
| CN115187125A (en) | Laboratory data management method, device, equipment and medium | |
| CN114415613B (en) | Automatic production management system | |
| CN115619091A (en) | Medicine industry material inspection release control method and device and storage medium | |
| CN113919820B (en) | Formula management system based on ERP system and control method | |
| CN111353713A (en) | Product quality certification management system for factory production | |
| US7225106B2 (en) | Data processing system and method for processing test orders | |
| TWI284846B (en) | Semiconductor automation system for a daily check and method thereof | |
| JP2020173519A (en) | Work man-hour prediction system and production planning support system with work man-hour prediction system | |
| CN106777303B (en) | Passenger flight inquiry behavior classification method and system | |
| US20050131861A1 (en) | Referential and relational database software | |
| CN113628703A (en) | Occupational health record management method and system and network testing server | |
| CN112632247A (en) | Method and device for detecting man-hour report, computer equipment and storage medium | |
| CN111951028A (en) | Product tracing and product anti-counterfeiting method | |
| CN110991847A (en) | Electric energy meter batch management method and device and readable storage medium | |
| CN113256249B (en) | Special labor protection article informatization monitoring system and method | |
| CN115187351A (en) | Data processing method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |