CN112258107A - LED intelligent material rack management method, system, equipment and storage medium - Google Patents

LED intelligent material rack management method, system, equipment and storage medium Download PDF

Info

Publication number
CN112258107A
CN112258107A CN202011130172.2A CN202011130172A CN112258107A CN 112258107 A CN112258107 A CN 112258107A CN 202011130172 A CN202011130172 A CN 202011130172A CN 112258107 A CN112258107 A CN 112258107A
Authority
CN
China
Prior art keywords
materials
bill
request
work order
component
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.)
Pending
Application number
CN202011130172.2A
Other languages
Chinese (zh)
Inventor
唐春艳
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Wangtaqi Intelligent Technology Suzhou Co ltd
Original Assignee
Wangtaqi Intelligent Technology Suzhou Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Wangtaqi Intelligent Technology Suzhou Co ltd filed Critical Wangtaqi Intelligent Technology Suzhou Co ltd
Priority to CN202011130172.2A priority Critical patent/CN112258107A/en
Publication of CN112258107A publication Critical patent/CN112258107A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875Itemisation or classification of parts, supplies or services, e.g. bill of materials
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06KGRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
    • G06K17/00Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
    • G06K17/0022Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device
    • G06K17/0025Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device the arrangement consisting of a wireless interrogation device in combination with a device for optically marking the record carrier

Abstract

The embodiment of the application discloses a method, a system, equipment and a storage medium for managing an LED intelligent material rack, wherein the method comprises the steps of obtaining a user login request, verifying whether an account password of a user is correct or not, and displaying an operation interface corresponding to a role authority corresponding to a user account to a user who successfully logs in; receiving a material list import request, storing names, packaging marks, models and quantities of materials and elements into a database in a table form, generating two-dimensional codes related to the names of the materials, and generating material shortage information related to the material list; receiving a work order query request, querying whether the materials related to the work order have material shortage information, and sending a prompt to a manager; and receiving a work order management request, and inquiring the component library information included in the bill of materials. The state of the elements on the LED intelligent material frame is obtained, and the LED intelligent material frame is compared with the bill of material to obtain the information of lack of material, so that a manager can obtain the state of the material in the material frame in time, and the operation of replenishment and the like is facilitated.

Description

LED intelligent material rack management method, system, equipment and storage medium
Technical Field
The invention relates to the technical field of warehousing management, in particular to a method, a system, equipment and a storage medium for managing an LED intelligent material rack.
Background
In the current technology, accurate and timely delivery of materials is a precondition for normal production activities of enterprises. The current rack management mainly depends on manual work, so that the efficiency is low, the error is easy to occur, the synchronous processing of large-scale materials cannot be realized, and the great defects exist in enterprise production and operation.
The information disclosed in this background section is only for enhancement of understanding of the general background of the invention and should not be taken as an acknowledgement or any form of suggestion that this information forms the prior art already known to a person skilled in the art.
Disclosure of Invention
The embodiment of the application provides a method, a system, equipment and a storage medium for managing an LED intelligent material rack, and can solve the problem that the material processing efficiency of the current material rack is low.
In a first aspect, an embodiment of the application provides a method for managing an LED intelligent rack, which includes the following steps:
acquiring a user login request, verifying whether an account password of a user is correct, and displaying an operation interface corresponding to the role authority corresponding to the user account to the user who successfully logs in;
receiving a material list import request, storing the name, the packaging mark, the model and the quantity of the material into a database in a table form, and generating a two-dimensional code related to the name of the material;
receiving a component library input request, storing the name, the packaging mark, the model, the two-dimensional code and the number of the component into a database in a form of a table, and generating material shortage information related to a bill of materials;
creating a work order associated with the bill of materials, receiving a work order query request, querying whether the materials associated with the work order have material shortage information, and sending a prompt to a manager;
and receiving a work order management request, inquiring the component in-stock information included in the bill of materials, and outputting the component in a exporting or printing mode.
In one possible embodiment, the method further comprises creating a location number for the LED smart rack, associating the components of the component library with the location number.
In one possible embodiment, the step of creating a position number for the LED smart rack further comprises providing the LED smart rack with an LED lamp for displaying the warehousing status of the component.
In one possible embodiment, the method further comprises setting a color marker for the bill of materials to distinguish between new and old models of components.
In one possible embodiment, the step of querying the component-in-library information included in the bill of materials further includes obtaining information of a new model and an old model of a component.
In one possible embodiment, the method further comprises converting the barcode of the component library to a unique material code of the factory component library.
In one possible implementation, the method further includes receiving a role management request, and creating users with different permissions according to the role management request.
In a second aspect, an embodiment of the present invention provides an LED intelligent rack management system, including the following units:
the login verification unit is used for acquiring a user login request, verifying whether the account password of the user is correct or not and displaying an operation interface corresponding to the role authority corresponding to the user account to the user who successfully logs in;
the bill importing unit is used for receiving a bill of material importing request, storing the name, the packaging mark, the model and the quantity of the material into a database in a form of a table, and generating a two-dimensional code related to the name of the material;
the component import unit is used for receiving a component library entry request, storing the name, the packaging mark, the model, the two-dimensional code and the quantity of the component into a database in a form of a table and generating the material shortage information related to the bill of materials;
the work order query unit is used for creating a work order associated with the bill of materials, receiving a work order query request, querying whether the materials associated with the work order have material shortage information or not and sending a prompt to a manager;
and the work order management unit is used for receiving the work order management request, inquiring the component in-stock information included in the bill of materials and outputting the component in a exporting or printing mode.
In a third aspect, an embodiment of the present invention provides a computer device, where the computer device includes a memory and a processor connected to the memory; the memory is used for storing a computer program; the processor is configured to run a computer program stored in the memory to perform the steps of the LED smart rack management method according to any one of the above.
In a fourth aspect, an embodiment of the present invention further provides a storage medium, where the storage medium stores a computer program, and the computer program, when executed by a processor, causes the processor to perform the steps of the LED smart rack management method according to any one of the above-mentioned embodiments.
The embodiment of the application provides a method and a system for managing an LED intelligent material rack, computer equipment and a storage medium. This application embodiment is through acquireing the component state on the LED intelligence work or material rest, and compare with the bill of material and acquire when scarce material information, make managers can in time acquire material state in the work or material rest, so as to carry out operations such as replenishment, can satisfy customer business development needs, further strengthen the whole competitiveness of enterprise, support the enterprise to upgrade the transformation to current material delivery mode, the informationization has been realized, it is visual, can reach the optimizing personnel, the space, efficiency, realize the management of lean in the factory logistics, and great economic benefits has.
The invention is further described below with reference to the accompanying drawings and specific embodiments.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
Fig. 1 is a schematic view of an application scenario of an LED intelligent rack management method according to an embodiment of the present application;
fig. 2 is a schematic flow chart of a method for managing an LED intelligent rack according to an embodiment of the present application;
fig. 3 is a schematic block diagram of an LED intelligent rack management system provided in an embodiment of the present application;
fig. 4 is a schematic block diagram of a computer device provided in an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It will be understood that the terms "comprises" and/or "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 invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in the specification of the present invention 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 this specification and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.
Referring to fig. 1, fig. 1 is a schematic view of an application scenario of an LED intelligent rack management method according to an embodiment of the present application. The application scene comprises the following steps:
(1) and the user controls the LED material rack through the terminal.
(2) The terminal is an LED intelligent material frame and is provided with a control program, a user uses the control program through input equipment such as a touch screen or a keyboard on the terminal, and the terminal is connected with the server through a wired network or a wireless network.
(3) The server is used for storing program files required by the LED intelligent material rack management method, and is connected with the terminal in a wired or wireless mode.
The working process of each main body in the figure 1 is shown in the figure 2:
step S101, obtaining a user login request, verifying whether an account password of a user is correct, and displaying an operation interface corresponding to a role authority corresponding to a user account to a user who successfully logs in;
step S102, receiving a material list import request, storing the name, the packaging mark, the model and the quantity of the material into a database in a table form, and generating a two-dimensional code related to the name of the material;
specifically, since the positional information data of each material needs to be visualized, the method also needs to create a position number for the LED smart rack, associating the elements included in the bill of materials with the position number.
In this embodiment, the imported data has five columns in the system, which are respectively the package mark, the old model, the new model, the quantity and the barcode. The packaging mark is the packaging mark after the system processing is finished, the old model is the model before the system processing, the old model is reserved for being edited and screened later, and the new model is the model processed by the system, namely the original quantity. And setting a color mark for the bill of materials to distinguish elements of new models and old models, specifically, when the packaging column and the new model column have no matching item in the element library, the background color of the row is light red, otherwise, the background color is light green, so that managers can quickly know the storage state without comparison one by one.
In other embodiments, the method further needs to set an edit entry for the form of the bill of materials, so as to facilitate the modification and check of the bill of materials, and facilitate the use of the user.
In one possible embodiment, Excel can be imported into the system by using Excel import, and data of the bill of materials are converted into text or digital format, so that data import is facilitated.
Step S103, receiving a component library entry request, storing the name, the packaging mark, the model, the two-dimensional code and the quantity of the component into a database in a form of a table, and generating the material shortage information related to the bill of materials;
specifically, in this step, the bar code of the component library needs to be converted into the unique material code of the factory component library, so as to facilitate the processing of the component by the method.
In one embodiment, an LED lamp is arranged on the LED intelligent material rack, the LED lamp is used for displaying the storage state of the element, and the display state of the LED lamp can be sent to the server side in a wired or wireless mode, so that a manager can timely know the storage state of the element.
In a possible embodiment, a two-dimensional code associated with a bill of materials can be arranged below the LED lamp, so that maintenance personnel can conveniently maintain the components.
Step S104, creating a work order associated with the bill of materials, receiving a work order query request, querying whether the materials associated with the work order have material shortage information or not, and sending a prompt to a manager;
specifically, the work order may be used to prompt a manager to perform replenishment or to perform material component delivery, and when the work order is changed, the bill of material and the related information of the component also need to be changed correspondingly.
And S105, receiving a work order management request, inquiring the component in-stock information included in the bill of materials, and outputting the component in a exporting or printing mode.
Wherein, the report with insufficient elements in the library or the report with insufficient elements displayed in the library can be printed or exported.
In an embodiment, the work order management request may further include acquiring warehousing history of warehousing elements, such as warehousing in-and-out time span, and directly batching materials according to the LED lighting prompt, instead of manually holding paper documents/PDAs to find the position of the material tray at present.
Through the steps of S101-105, the efficiency of incoming material loading, ingredient unloading and line edge loading can be improved, and specifically, the following effects can be realized:
feeding and putting on shelf: the intelligent light-on guide is directly put on the shelf to replace the prior manual paper document holding/PDA to look for the storage position and return to a computer for recording.
Discharging the ingredients out of the warehouse: the paper documents are directly picked according to the intelligent lighting prompt, and the current manual paper document holding/PDA searching for the storage position and returning to a computer for accounting are replaced.
Line edge feeding: the materials are directly dispensed according to the intelligent lighting prompt, and the current manual paper document holding/PDA searching for the position of the material tray is replaced.
The incoming material loading frame, the ingredient discharge and the line edge loading mistake proofing are reduced.
Feeding and putting on shelf: according to the lamp on the shelf, the current manual storage position is prevented from being misplaced.
Discharging the ingredients out of the warehouse: direct picking is prompted according to intelligent lighting, and manual paper document holding and material mistake taking are prevented.
Line edge feeding: direct batching is prompted according to intelligent lighting, and the situation that paper documents are held manually and mistaken materials are taken is prevented.
First-in first-out: and managing and refining by a software system, and lighting according to an FIFO principle.
Fig. 3 is a schematic block diagram of an LED intelligent rack management system according to an embodiment of the present invention. As shown in fig. 3, the invention further provides an LED intelligent rack management system corresponding to the above LED intelligent rack management method. The LED intelligent material rack management system comprises a unit for executing the LED intelligent material rack management method, and can be configured in terminals such as desktop computers, tablet computers and portable computers. Specifically, referring to fig. 3, the LED intelligent rack management system 200 includes a login verification unit 201, a list import unit 202, a component import unit 203, a work order query unit 204, and a work order management unit 205.
The login verification unit 201 is configured to obtain a user login request, verify whether an account password of a user is correct, and display an operation interface corresponding to a role authority corresponding to a user account to a user who successfully logs in;
the bill importing unit 202 is configured to receive a bill of material importing request, store the name, the packaging mark, the model number, and the quantity of the material in a form of a table in a database, and generate a two-dimensional code related to the name of the material;
the component import unit 203 is used for receiving a component library entry request, storing the name, the packaging mark, the model number, the two-dimensional code and the quantity of the component into a database in a form of a table, and generating the material shortage information related to the bill of materials;
the work order query unit 204 is used for creating a work order associated with the bill of materials, receiving a work order query request, querying whether the materials associated with the work order have material shortage information or not, and sending a prompt to a manager;
and the work order management unit 205 is used for receiving the work order management request, inquiring the component in-stock information included in the bill of materials, and outputting the component in an export or printing mode.
It should be noted that, as can be clearly understood by those skilled in the art, the specific implementation processes of the LED intelligent rack management system 200 and each unit may refer to the corresponding descriptions in the foregoing method embodiments, and for convenience and conciseness of description, no further description is provided herein.
The LED smart rack management system described above may be implemented in the form of a computer program that may be run on a computer device as shown in fig. 4.
Referring to fig. 4, fig. 4 is a schematic block diagram of a computer device according to an embodiment of the present application. The computer device 300 may be a server, wherein the server may be an independent server or a server cluster composed of a plurality of servers.
Referring to fig. 4, the computer device 300 includes a processor 302, memory, and a network interface 305 connected by a system bus 301, where the memory may include a non-volatile storage medium 303 and an internal memory 304.
The nonvolatile storage medium 303 may store an operating system 3031 and a computer program 3032. The computer program 3032 includes program instructions that, when executed, cause the processor 302 to perform a LED smart rack management method.
The processor 302 is used to provide computing and control capabilities to support the operation of the overall computer device 300.
The internal memory 304 provides an environment for the execution of computer programs 3032 in the non-volatile storage medium 303, which computer programs 3032, when executed by the processor 302, cause the processor 302 to perform a LED smart rack management method.
The network interface 305 is used for network communication with other devices. Those skilled in the art will appreciate that the configuration shown in fig. 4 is a block diagram of only a portion of the configuration associated with the present application and does not constitute a limitation of the computer apparatus 300 to which the present application is applied, and that a particular computer apparatus 300 may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
Wherein the processor 302 is configured to run a computer program 3032 stored in the memory to implement the following steps:
in an embodiment, the processor 302 implements the obtaining of the user login request, verifies whether the account password of the user is correct, and displays an operation interface corresponding to the role authority corresponding to the user account to the user who successfully logs in; receiving a material list import request, storing the name, the packaging mark, the model and the quantity of the material into a database in a table form, and generating a two-dimensional code related to the name of the material; receiving a component library input request, storing the name, the packaging mark, the model, the two-dimensional code and the number of the component into a database in a form of a table, and generating material shortage information related to a bill of materials; creating a work order associated with the bill of materials, receiving a work order query request, querying whether the materials associated with the work order have material shortage information, and sending a prompt to a manager; and receiving a work order management request, inquiring the information of the component in the stock included in the bill of materials, and outputting the information in a exporting or printing mode.
It should be understood that, in the embodiment of the present Application, the Processor 302 may be a Central Processing Unit (CPU), and the Processor 302 may also be other general-purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components, and the like. Wherein a general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
It will be understood by those skilled in the art that all or part of the flow of the method implementing the above embodiments may be implemented by a computer program instructing associated hardware. The computer program includes program instructions, and the computer program may be stored in a storage medium, which is a computer-readable storage medium. The program instructions are executed by at least one processor in the computer system to implement the flow steps of the embodiments of the method described above. Accordingly, the present invention also provides a storage medium. The storage medium may be a computer-readable storage medium. The storage medium stores a computer program, wherein the computer program comprises program instructions. The program instructions, when executed by the processor, cause the processor to perform the steps of:
in an embodiment, the processor executes the program instruction to realize the acquisition of the user login request, verifies whether the account and the password of the user are correct, and displays an operation interface corresponding to the role authority corresponding to the user account to the user who successfully logs in; receiving a material list import request, storing the name, the packaging mark, the model and the quantity of the material into a database in a table form, and generating a two-dimensional code related to the name of the material; receiving a component library input request, storing the name, the packaging mark, the model, the two-dimensional code and the number of the component into a database in a form of a table, and generating material shortage information related to a bill of materials; creating a work order associated with the bill of materials, receiving a work order query request, querying whether the materials associated with the work order have material shortage information, and sending a prompt to a manager; receiving a work order management request, inquiring the information of the component in the stock included in the bill of materials, and outputting the information in a exporting or printing mode:
the storage medium may be a usb disk, a removable hard disk, a Read-Only Memory (ROM), a magnetic disk, or an optical disk, which can store various computer readable storage media.
Those of ordinary skill in the art will appreciate that the elements and algorithm steps of the examples described in connection with the embodiments disclosed herein may be embodied in electronic hardware, computer software, or combinations of both, and that the components and steps of the examples have been described in a functional general in the foregoing description for the purpose of illustrating clearly the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative. For example, the division of each unit is only one logic function division, and there may be another division manner in actual implementation. For example, various elements or components may be combined or may be integrated into another system, or some features may be omitted, or not implemented.
The steps in the method of the embodiment of the invention can be sequentially adjusted, combined and deleted according to actual needs. The units in the device of the embodiment of the invention can be merged, divided and deleted according to actual needs. In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a storage medium. Based on such understanding, the technical solution of the present invention essentially or partially contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a terminal, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention.
While the invention has been described with reference to specific embodiments, the invention is not limited thereto, and various equivalent modifications and substitutions can be easily made by those skilled in the art within the technical scope of the invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Various other modifications and changes may be made by those skilled in the art based on the above-described technical solutions and concepts, and all such modifications and changes should fall within the scope of the claims of the present invention.

Claims (10)

1. The LED intelligent material rack management method is characterized by comprising the following steps:
acquiring a user login request, verifying whether an account password of a user is correct, and displaying an operation interface corresponding to the role authority corresponding to the user account to the user who successfully logs in;
receiving a material list import request, storing the name, the packaging mark, the model and the quantity of the material into a database in a table form, and generating a two-dimensional code related to the name of the material;
receiving a component library input request, storing the name, the packaging mark, the model, the two-dimensional code and the number of the component into a database in a form of a table, and generating material shortage information related to a bill of materials;
creating a work order associated with the bill of materials, receiving a work order query request, querying whether the materials associated with the work order have material shortage information, and sending a prompt to a manager;
and receiving a work order management request, inquiring the component in-stock information included in the bill of materials, and outputting the component in a exporting or printing mode.
2. The LED smart rack management method of claim 1, further comprising creating a location number for an LED smart rack, associating a component of the component library with the location number.
3. The LED smart rack management method of claim 2, wherein said step of creating a location number for an LED smart rack further comprises providing an LED light for the LED smart rack, said LED light for displaying the bin status of the component.
4. The LED smart rack management method of claim 1, further comprising setting color markings for the bill of materials to distinguish between new and old models of components.
5. The LED intelligent rack management method according to claim 4, wherein the step of querying the component inventory information included in the bill of materials further includes obtaining information on new models and old models of components.
6. The LED smart rack management method of claim 5, further comprising converting the component library bar codes to factory component library unique material codes.
7. The LED smart rack management method of claim 1, further comprising receiving a role management request, and creating users with different permissions according to the role management request.
8. The utility model provides a LED intelligence work or material rest management system which characterized in that includes following unit:
the login verification unit is used for acquiring a user login request, verifying whether the account password of the user is correct or not and displaying an operation interface corresponding to the role authority corresponding to the user account to the user who successfully logs in;
the bill importing unit is used for receiving a bill of material importing request, storing the name, the packaging mark, the model and the quantity of the material into a database in a form of a table, and generating a two-dimensional code related to the name of the material;
the component import unit is used for receiving a component library entry request, storing the name, the packaging mark, the model, the two-dimensional code and the quantity of the component into a database in a form of a table and generating the material shortage information related to the bill of materials;
the work order query unit is used for creating a work order associated with the bill of materials, receiving a work order query request, querying whether the materials associated with the work order have material shortage information or not and sending a prompt to a manager;
and the work order management unit is used for receiving the work order management request, inquiring the component in-stock information included in the bill of materials and outputting the component in a exporting or printing mode.
9. A computer device, comprising a memory and a processor coupled to the memory; the memory is used for storing a computer program; the processor is configured to run a computer program stored in the memory to perform the steps of the LED smart rack management method of any of claims 1-7.
10. A storage medium, characterized in that the storage medium stores a computer program which, when executed by a processor, causes the processor to perform the steps of the LED smart rack management method according to any one of claims 1-7.
CN202011130172.2A 2020-10-21 2020-10-21 LED intelligent material rack management method, system, equipment and storage medium Pending CN112258107A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011130172.2A CN112258107A (en) 2020-10-21 2020-10-21 LED intelligent material rack management method, system, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011130172.2A CN112258107A (en) 2020-10-21 2020-10-21 LED intelligent material rack management method, system, equipment and storage medium

Publications (1)

Publication Number Publication Date
CN112258107A true CN112258107A (en) 2021-01-22

Family

ID=74264074

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011130172.2A Pending CN112258107A (en) 2020-10-21 2020-10-21 LED intelligent material rack management method, system, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN112258107A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114936300A (en) * 2022-07-21 2022-08-23 济南鼎点数控设备有限公司 List generation method and system for laser pipe cutter electrical design auxiliary system

Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040186761A1 (en) * 2003-03-20 2004-09-23 Yun-Chi Lee Method and system for logistical management of import and export goods
CN102298739A (en) * 2011-08-19 2011-12-28 迈普通信技术股份有限公司 Method for changing bill of materials (BOM) and apparatus thereof
WO2012109194A1 (en) * 2011-02-07 2012-08-16 Intermetro Industries Corporation Inventory management system
CN106803161A (en) * 2017-02-10 2017-06-06 常州工学院 Intelligent dispensing work station
CN107657361A (en) * 2017-08-28 2018-02-02 梁彪 Materials intelligent management and Intelligent Production System
CN109636278A (en) * 2018-12-03 2019-04-16 Oppo(重庆)智能科技有限公司 Material replenishing method, material goods compensator and terminal device
CN109919400A (en) * 2017-12-12 2019-06-21 小圈信息科技(上海)有限公司 A kind of production discharge management system and method based on B/S framework
CN109978369A (en) * 2019-03-22 2019-07-05 Oppo(重庆)智能科技有限公司 Work order generation method, device, electronic equipment and storage medium
CN209657129U (en) * 2019-06-06 2019-11-19 天津工业职业学院 A kind of intelligent material managing device
CN110738085A (en) * 2018-07-20 2020-01-31 浙江汉朔电子科技有限公司 shelf out-of-stock checking method, device and equipment and storage medium
CN111861316A (en) * 2020-07-13 2020-10-30 深圳创维-Rgb电子有限公司 Intelligent material rack control method and device and computer readable storage medium

Patent Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040186761A1 (en) * 2003-03-20 2004-09-23 Yun-Chi Lee Method and system for logistical management of import and export goods
WO2012109194A1 (en) * 2011-02-07 2012-08-16 Intermetro Industries Corporation Inventory management system
CN102298739A (en) * 2011-08-19 2011-12-28 迈普通信技术股份有限公司 Method for changing bill of materials (BOM) and apparatus thereof
CN106803161A (en) * 2017-02-10 2017-06-06 常州工学院 Intelligent dispensing work station
CN107657361A (en) * 2017-08-28 2018-02-02 梁彪 Materials intelligent management and Intelligent Production System
CN109919400A (en) * 2017-12-12 2019-06-21 小圈信息科技(上海)有限公司 A kind of production discharge management system and method based on B/S framework
CN110738085A (en) * 2018-07-20 2020-01-31 浙江汉朔电子科技有限公司 shelf out-of-stock checking method, device and equipment and storage medium
CN109636278A (en) * 2018-12-03 2019-04-16 Oppo(重庆)智能科技有限公司 Material replenishing method, material goods compensator and terminal device
CN109978369A (en) * 2019-03-22 2019-07-05 Oppo(重庆)智能科技有限公司 Work order generation method, device, electronic equipment and storage medium
CN209657129U (en) * 2019-06-06 2019-11-19 天津工业职业学院 A kind of intelligent material managing device
CN111861316A (en) * 2020-07-13 2020-10-30 深圳创维-Rgb电子有限公司 Intelligent material rack control method and device and computer readable storage medium

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
宁晓嫚 等: "基于盘状物料管理的智能货架", 新技术新工艺, no. 02, pages 26 - 28 *
张莉萍;: "库存管理系统", 考试周刊, no. 01 *
王宁;何瑛;: "汽车制造业生产物流物料按灯系统设计", 计算机工程与应用, no. 12 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114936300A (en) * 2022-07-21 2022-08-23 济南鼎点数控设备有限公司 List generation method and system for laser pipe cutter electrical design auxiliary system

Similar Documents

Publication Publication Date Title
CN104778540B (en) A kind of equipment for building materiaIs manufacturing BOM management method and management system
US20040193602A1 (en) Method and system for maintenance of engineering change data
US20070203811A1 (en) Method of auditing inventory
CN101894133B (en) Method and device for modifying form data in batches
CN104361139A (en) Data importing device and method
CN109815464A (en) PDF document generation method, device, electronic equipment and storage medium
CN109359907A (en) A kind of storekeeper bar code management system
CN102142014A (en) System and method for export and import of metadata located in metadata registries
CN112418798A (en) Information auditing method and device, electronic equipment and storage medium
US20160110679A1 (en) System and method for monitoring an in-progress inventory audit
CN110414635A (en) A kind of product false proof and traceability system based on RFID
JPWO2015033376A1 (en) Form data management server and form data management program
CN113052519A (en) Warehouse management system
CN110457666A (en) A kind of report form generation method, system and electronic equipment and storage medium
CN110490523A (en) Generation method, device and the electronic equipment of stock inventory
CN114140045A (en) Material management method, system, storage medium and equipment
CN111523854A (en) BIM and database based automatic pricing system relating to automatic pre-settlement
CN112258107A (en) LED intelligent material rack management method, system, equipment and storage medium
US7251622B2 (en) System and method for searching for information on inventory with virtual warehouses
CN105700794B (en) Data input device, data entry device and computer-readable storage medium
CN111538292A (en) Machine tool part version management, identification and verification method based on MES system
CN101616026B (en) Method and system for obtaining property of single plate
CN112990800A (en) Method, system and storage medium for managing materials
CN116187915A (en) Warehouse management method, device, equipment and storage medium
CN101518174A (en) Inventory manager for PCB manufacturing

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