CN116894625A - Warehouse-in and warehouse-out management method and device, electronic equipment and storage medium - Google Patents
Warehouse-in and warehouse-out management method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN116894625A CN116894625A CN202310970852.2A CN202310970852A CN116894625A CN 116894625 A CN116894625 A CN 116894625A CN 202310970852 A CN202310970852 A CN 202310970852A CN 116894625 A CN116894625 A CN 116894625A
- Authority
- CN
- China
- Prior art keywords
- warehouse
- information corresponding
- key field
- dimensional code
- warehousing
- 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
Links
- 238000007726 management method Methods 0.000 title claims abstract description 33
- 239000000463 material Substances 0.000 claims abstract description 312
- 238000000034 method Methods 0.000 claims abstract description 51
- 238000001514 detection method Methods 0.000 claims description 44
- 238000007689 inspection Methods 0.000 claims description 21
- 238000004590 computer program Methods 0.000 claims description 17
- 238000007639 printing Methods 0.000 claims description 10
- 238000007599 discharging Methods 0.000 abstract 2
- 238000004891 communication Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 7
- 230000008676 import Effects 0.000 description 6
- 238000012545 processing Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 3
- 230000002159 abnormal effect Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012549 training Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000010801 machine learning Methods 0.000 description 1
- -1 numbers Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 230000001953 sensory effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000004381 surface treatment Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
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/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K7/00—Methods or arrangements for sensing record carriers, e.g. for reading patterns
- G06K7/10—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation
- G06K7/10544—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation by scanning of the records by radiation in the optical part of the electromagnetic spectrum
- G06K7/10821—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation by scanning of the records by radiation in the optical part of the electromagnetic spectrum further details of bar or optical code scanning devices
-
- 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/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Electromagnetism (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Computational Linguistics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Human Resources & Organizations (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- Finance (AREA)
- Mathematical Physics (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Toxicology (AREA)
- Artificial Intelligence (AREA)
- Computer Vision & Pattern Recognition (AREA)
Abstract
The invention discloses a warehouse-in and warehouse-out management method, a warehouse-in and warehouse-out management device, electronic equipment and a storage medium. The method comprises the following steps: decoding the scanned material two-dimensional code to obtain key field information corresponding to the material two-dimensional code; performing warehousing query based on key field information corresponding to the material two-dimensional code to obtain a warehousing query result, and executing material warehousing operation under the condition that the warehousing query result is the material warehousing information; and carrying out ex-warehouse inquiry on the key field information corresponding to the material two-dimensional code in a database, and judging whether to carry out ex-warehouse operation or not according to the ex-warehouse inquiry result. According to the technical scheme, the automatic control of the materials is realized from the material scanning and warehousing to the material discharging, so that the material discharging and warehousing efficiency is improved.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method and apparatus for managing access to a warehouse, an electronic device, and a storage medium.
Background
With the rapid development of electronic commerce, a warehouse management link in the logistics industry is widely focused by people.
At present, in storage management, whether to store or deliver materials in a warehouse is generally required to be manually judged, and the problem of low warehouse delivery efficiency exists.
Disclosure of Invention
The invention provides a warehouse-in and warehouse-out management method, a warehouse-in and warehouse-out management device, electronic equipment and a storage medium, which are used for automatically judging whether to carry out warehouse-in and warehouse-out of materials and solving the problem of low warehouse-in and warehouse-out efficiency.
According to an aspect of the present invention, there is provided a method for managing access to a warehouse, including:
decoding the scanned material two-dimensional code to obtain key field information corresponding to the material two-dimensional code;
performing warehousing query based on key field information corresponding to the material two-dimensional code to obtain a warehousing query result, and executing material warehousing operation under the condition that the warehousing query result is the material warehousing information;
and carrying out ex-warehouse inquiry on the key field information corresponding to the material two-dimensional code in a database, and judging whether to carry out ex-warehouse operation or not according to the ex-warehouse inquiry result.
According to another aspect of the present invention, there is provided an in-out warehouse management device including:
the key field acquisition module is used for decoding the scanned material two-dimensional code to obtain key field information corresponding to the material two-dimensional code;
the material warehouse-in query module is used for carrying out warehouse-in query based on the key field information corresponding to the material two-dimensional code to obtain a warehouse-in query result, and executing material warehouse-in operation under the condition that the warehouse-in query result is the material warehouse-in information;
and the material ex-warehouse inquiry module is used for carrying out ex-warehouse inquiry on the key field information corresponding to the material two-dimensional code in the database, and judging whether to carry out ex-warehouse operation according to the ex-warehouse inquiry result.
According to another aspect of the present invention, there is provided an electronic apparatus including:
at least one processor;
and a memory communicatively coupled to the at least one processor;
the memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor, so that the at least one processor can execute the method for managing access to a library according to any embodiment of the present invention.
According to another aspect of the present invention, there is provided a computer readable storage medium storing computer instructions for causing a processor to implement the method for managing access to a library according to any one of the embodiments of the present invention when executed.
According to the technical scheme, the automatic judgment of whether the material is in the warehouse is realized by carrying out the warehouse-in query according to the key field information corresponding to the two-dimensional code of the material; in addition, the key field information corresponding to the two-dimension codes of the materials is subjected to warehouse-out inquiry in the database, so that automatic judgment of whether the materials are in warehouse-out or not is realized.
It should be understood that the description in this section is not intended to identify key or critical features of the embodiments of the invention or to delineate the scope of the invention. Other features of the present invention will become apparent from the description that follows.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of a warehouse entry system according to an embodiment of the present invention;
FIG. 2 is a flowchart of a method for managing access to a warehouse according to a first embodiment of the present invention;
FIG. 3 is a flowchart of an Excel file import database provided according to an embodiment of the present invention;
FIG. 4 is a flowchart of a method for managing access to a warehouse according to a second embodiment of the present invention;
FIG. 5 is a flow chart of a method for material warehouse entry management according to an embodiment of the present invention;
FIG. 6 is a flowchart of a method for managing access to a warehouse according to a third embodiment of the present invention;
FIG. 7 is a flow chart of a method for managing material delivery according to an embodiment of the present invention;
fig. 8 is a schematic structural diagram of a warehouse entry management device according to a fourth embodiment of the present invention;
fig. 9 is a schematic structural diagram of an electronic device implementing a method for managing access to a warehouse according to an embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present invention and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Before describing the specific embodiments, application scenarios of the warehouse entry management method are described herein for facilitating understanding of the technical solution of the present invention. Fig. 1 is a schematic structural diagram of a warehouse entry system according to the present invention. Specifically, the method for managing the in-out warehouse provided by each embodiment can be executed by an in-out warehouse system, and the in-out warehouse system can comprise a two-dimensional code scanning device, an Excel import module, a database, a warehouse-in module, an ex-warehouse module, a label printing module and the like. The two-dimensional code scanning device is used for scanning the two-dimensional code on the material to be put in or taken out of the warehouse, and can be a mobile phone, a tablet computer or a scanning gun and other equipment; the Excel import module is used for automatically importing Excel files containing the in-out library information into the database; the database may be a lightweight database, for example, the database may be a SQLite database, etc.; the warehouse-in module is used for realizing the warehouse-in inquiry of materials and executing the warehouse-in operation of the materials; the ex-warehouse module is used for realizing the ex-warehouse inquiry of the materials and executing the ex-warehouse operation of the materials; the green button is used for triggering quality inspection qualified operation of the material, the red button is used for triggering quality unqualified operation of the material, and the green button or the red button can be a physical key or a virtual key, and is not particularly limited; the label printing module is used for printing a material quality inspection qualified label or a quality unqualified label so as to mark the material quality.
Example 1
Fig. 2 is a flowchart of a method for managing access to a warehouse, which is applicable to the case of automatic management of access to a warehouse of materials based on database query, according to the first embodiment of the present invention, the method may be performed by an access management device, the access management device may be implemented in a hardware and/or software form, and the access management device may be configured in a terminal and/or a server. As shown in fig. 2, the method includes:
s110, decoding the scanned material two-dimensional code to obtain key field information corresponding to the material two-dimensional code.
In this embodiment, the two-dimensional code of the material refers to a two-dimensional code or a two-dimensional bar code of the material to be put in or put out of the warehouse, and may be used to store key field information related to the material. Illustratively, the material two-dimensional code may be QR (Quick Response) code. The key field information refers to identification information for characterizing materials, and can include, but is not limited to, information such as a material item number, a material order number, a material drawing number, a material quantity and the like.
By means of the two-dimensional code scanning device, two-dimensional codes on materials to be put in and taken out of the warehouse can be scanned, the two-dimensional codes of the materials are obtained, the two-dimensional codes of the materials are further decoded, and key field information such as material item numbers, material order numbers, material drawing numbers and material quantity can be obtained.
And S120, carrying out warehouse-in query based on the key field information corresponding to the material two-dimensional code to obtain a warehouse-in query result, and executing material warehouse-in operation under the condition that the warehouse-in query result is the material warehouse-in information.
Specifically, according to the grammar rule of the SQL statement, key field information corresponding to the two-dimensional code of the material can be used for generating an SQL warehouse-in query statement, whether the database contains the material warehouse-in information of the current material or not is further queried through the SQL warehouse-in query statement, and if the material warehouse-in information corresponding to the key field information of the current material is queried in the database, the material warehouse-in operation is executed, so that the automatic query and judgment of the material warehouse-in are realized.
It can be appreciated that if the material warehouse-in information is queried, which indicates that the current material meets the warehouse-in standard, the material warehouse-in operation can be executed.
And S130, carrying out ex-warehouse inquiry on the key field information corresponding to the material two-dimensional code in a database, and judging whether to carry out ex-warehouse operation or not according to the ex-warehouse inquiry result.
Specifically, according to the grammar rule of the SQL statement, key field information corresponding to the two-dimensional code of the material can be used for generating an SQL ex-warehouse query statement, whether the database contains the material ex-warehouse information of the current material or not is further queried through the SQL ex-warehouse query statement, and if the material ex-warehouse information corresponding to the key field information of the current material is queried in the database, the material warehouse-in operation is executed, so that the automatic query judgment of the material ex-warehouse is realized.
It can be appreciated that if the material delivery information is queried, which indicates that the current material meets the delivery standard, the material delivery operation can be performed.
In some optional embodiments, before decoding the scanned two-dimensional code of the material to obtain key field information corresponding to the two-dimensional code of the material, the method further includes: acquiring a target file path, and importing a target file based on the target file path; and reading the content of the target file, judging whether the target file meets the import condition or not based on the read content, and if so, executing the import operation on the target file.
The target file path refers to a file storage path for storing the target file. The read content refers to target field information stored in the target file, and can be used for judging whether the target file meets the import condition.
For example, the target file may be one or more Excel files containing in-and-out information, and the target file path is an Excel file path. Specifically, fig. 3 is a flowchart of an Excel file importing database provided in an embodiment of the present invention, where after an electronic device obtains an Excel file path, it may determine whether an Excel file exists in the Excel file path according to a file type; after the Excel file under the Excel file path is identified, the target field information in the Excel file can be read, whether the Excel file is imported into the database is judged according to whether the target field information contains the specified information, if so, the Excel file is not imported into the database, the importing operation is executed on the Excel file, if not, the Excel file is imported into the database, and if so, the importing operation step is skipped; after the Excel file is imported, an importing result can be returned, wherein the importing result can be that all contents in the Excel file are imported into the database successfully or part of data are imported into the database successfully.
The proposal of the file importing database realizes the automatic importing of the material warehouse-in and warehouse-out information and improves the management efficiency of the material warehouse-in and warehouse-out.
According to the technical scheme, the automatic judgment of whether the material is in the warehouse is realized by carrying out the warehouse-in query according to the key field information corresponding to the two-dimensional code of the material; in addition, the key field information corresponding to the two-dimension codes of the materials is subjected to warehouse-out inquiry in the database, so that automatic judgment of whether the materials are in warehouse-out or not is realized.
Example two
Fig. 4 is a flowchart of a method for managing access to a warehouse, which is provided in the second embodiment of the present invention, and the method in this embodiment may be combined with each of the alternatives in the method for managing access to a warehouse provided in the foregoing embodiment. The warehouse-in and warehouse-out management method provided by the embodiment is further optimized. Optionally, the key field information corresponding to the material two-dimensional code comprises one or more of a material item number, a material order number and a material drawing number; correspondingly, the step of carrying out warehouse-in query based on the key field information corresponding to the material two-dimensional code to obtain a warehouse-in query result comprises the following steps: if the database contains the warehouse-in information matched with one or more of the material item number, the material order number and the material drawing number, the warehouse-in query result is determined to be the queried material warehouse-in information.
As shown in fig. 4, the method includes:
s210, decoding the scanned material two-dimensional code to obtain key field information corresponding to the material two-dimensional code, wherein the key field information corresponding to the material two-dimensional code comprises one or more of a material item number, a material order number and a material drawing number.
S220, if the database contains the warehouse-in information matched with one or more of the material item number, the material order number and the material drawing number, determining that the warehouse-in query result is the queried material warehouse-in information, and executing the material warehouse-in operation under the condition that the warehouse-in query result is the queried material warehouse-in information.
For example, an SQL warehouse-in query statement may be generated FROM the material item number, the material order number, and the material drawing number according to an SQL statement grammar rule, and the SQL warehouse-in query statement may be "SELECT NAME FROM sys. And then searching the database for the material warehouse-in information related to the material item number, the material order number and the material figure number through the SQL warehouse-in inquiry statement, if the material warehouse-in information related to the material item number, the material order number and the material figure number is successfully inquired in the database, executing the material warehouse-in operation, and compared with the prior art, the automatic inquiry judgment of the material warehouse-in is realized without manually judging whether to warehouse in the material, and the material warehouse-in efficiency is improved.
In some alternative embodiments, after performing the material warehousing operation, the method further comprises: and updating the material warehouse-in information based on the material quantity and the historical material warehouse-in quantity in the key field information corresponding to the material two-dimensional code.
By way of example, the quantity of the materials in the key field information and the historical material warehouse-in quantity obtained by inquiry can be added to obtain updated material warehouse-in information, so that automatic update of the material warehouse-in information is realized.
And S230, carrying out ex-warehouse inquiry on the key field information corresponding to the material two-dimensional code in a database, and judging whether to carry out ex-warehouse operation or not according to the ex-warehouse inquiry result.
In some alternative embodiments, determining whether to perform the outbound operation according to the outbound query result includes: if the material delivery information is inquired as the delivery inquiry result, delivering the material to the delivery; if the material delivery information is not queried as the delivery query result, the material delivery is not performed.
Fig. 5 is a flowchart of a material warehouse entry management method according to an embodiment of the present invention. Specifically, after the Excel file is imported into the database, the QR code can be scanned through a two-dimensional code scanning device, the scanned QR code is further decoded to obtain key field information corresponding to the QR code, further, whether the QR code is abnormal or not is judged according to the key field information corresponding to the QR code, if the key field information is missing or the content is empty, the current QR code format is determined to be abnormal, and the QR is scanned again. If the current QR code format is normal, generating an SQL database entry query statement according to an SQL statement grammar rule, searching for material database entry information related to the material item number, the material order number and the material figure number through the SQL database entry query statement, and if the material database entry information related to the material item number, the material order number and the material figure number is successfully queried in the database, executing material database entry operation and updating the material database entry information, and switching to next database entry after the database entry is completed, and scanning the next QR code; if the material warehousing information related to the material item number, the material order number and the material drawing number is not successfully queried in the database, the next warehousing is directly carried out, and the next QR code is scanned.
According to the technical scheme, the automatic judgment of whether the materials are put in storage is realized by inquiring the storage information matched with one or more of the material item number, the material order number and the material drawing number in the database, and compared with manual judgment, the efficiency of putting the materials in storage is improved.
Example III
Fig. 6 is a flowchart of a method for managing access to a warehouse, which is provided in the third embodiment of the present invention, and the method in this embodiment may be combined with each of the alternatives in the method for managing access to a warehouse provided in the foregoing embodiment. The warehouse-in and warehouse-out management method provided by the embodiment is further optimized. Optionally, after performing the material warehousing operation and updating the material warehousing information, the method further includes: detecting the quality of the warehouse-in material to obtain a quality detection result of the warehouse-in material; correspondingly, the judging whether to perform the ex-warehouse operation according to the ex-warehouse query result includes: judging whether to carry out ex-warehouse operation or not according to the ex-warehouse inquiry result and the quality detection result of the warehouse-in materials.
As shown in fig. 6, the method includes:
s310, decoding the scanned material two-dimensional code to obtain key field information corresponding to the material two-dimensional code.
S320, carrying out warehouse-in query based on the key field information corresponding to the material two-dimensional code to obtain a warehouse-in query result, and executing material warehouse-in operation under the condition that the warehouse-in query result is the material warehouse-in information.
S330, quality detection is carried out on the warehouse-in materials, and quality detection results of the warehouse-in materials are obtained.
The quality detection result may include detection results of whether scratches exist on the appearance of the material, whether the material surface treatment process is equal, whether the aperture size exceeds the tolerance, and the like.
Specifically, the quality detection of the warehouse-in material can be performed through a pre-trained quality detection model. Specifically, the method comprises the steps of shooting the warehouse-in materials to obtain warehouse-in material images, inputting the warehouse-in material images into a pre-trained quality detection model, and outputting quality detection results of the warehouse-in materials by the quality detection model.
The training step of the quality detection model comprises the following steps: acquiring a plurality of warehouse-in material images and quality detection result labels of the warehouse-in material images, inputting the warehouse-in material images into a quality detection model to be trained, outputting a quality detection prediction result by the quality detection model, determining model loss based on the quality detection prediction result and the quality detection labels of the warehouse-in material images, and adjusting model parameters of the quality detection model based on the model loss until a model training stop condition is met, so as to obtain a trained quality detection model.
In some embodiments, the quality detection result may also be information entered by the user via a keyboard, mouse, or touch screen.
S340, carrying out ex-warehouse inquiry on the key field information corresponding to the material two-dimensional code in a database, and judging whether to carry out ex-warehouse operation or not according to the ex-warehouse inquiry result and the quality detection result of the warehouse-in material.
Optionally, judging whether to perform the ex-warehouse operation according to the ex-warehouse query result and the quality detection result of the warehouse-in material, including: under the condition that the quality detection result of the warehouse-in materials is qualified in quality inspection, responding to the selection operation of a quality inspection qualified button, and if the material warehouse-out information corresponding to the key field information corresponding to the two-dimension codes of the materials is matched in the database, executing the material warehouse-out operation and printing a quality inspection qualified label; and under the condition that the quality detection result of the warehouse-in material is that the quality detection is unqualified, responding to the selection operation of a quality detection unqualified button, and if the material warehouse-out information corresponding to the key field information corresponding to the material two-dimension code is not matched in the database, printing a quality detection unqualified label.
Illustratively, the quality inspection pass button may be a green button and the quality inspection fail button may be a red button. Specifically, fig. 7 is a flowchart of a method for managing delivery of materials according to an embodiment of the present invention, after the materials are delivered, a user may press a print button corresponding to a quality detection result. Specifically, when the quality detection result of the warehouse-in material is qualified, the user can press the green button, the electronic equipment responds to the selection operation of the green button, generates an SQL warehouse-out query statement according to key field information corresponding to the two-dimensional code of the material according to the grammar rule of the SQL statement, further queries whether the database contains the material warehouse-out information of the current material or not through the SQL warehouse-out query statement, and if the material warehouse-out information corresponding to the key field information corresponding to the two-dimensional code of the material is matched in the database, executes the material warehouse-out operation and prints a quality inspection qualified label. And after the printing of the quality inspection qualified label is finished, updating the ex-warehouse state at the same time, and switching to the next ex-warehouse. And under the condition that the quality detection result of the warehouse-in material is that the quality inspection is unqualified, the user can press a red button, the electronic equipment responds to the selection operation of the quality inspection unqualified button, generates an SQL warehouse-out query sentence according to key field information corresponding to the two-dimensional code of the material according to the grammar rule of the SQL sentence, further queries whether the database contains the material warehouse-out information of the current material or not through the SQL warehouse-out query sentence, and prints a quality inspection unqualified label if the material warehouse-out information corresponding to the key field information corresponding to the two-dimensional code of the material is not matched in the database. After the quality inspection disqualified label is printed, the next delivery is carried out.
According to the technical scheme, the quality detection result of the warehouse-in materials is obtained by carrying out quality detection on the warehouse-in materials, so that automatic detection of the quality of the materials is realized, whether the warehouse-out operation is carried out or not is judged according to the warehouse-out query result and the quality detection result of the warehouse-in materials, automatic judgment of the warehouse-out operation is realized, and the warehouse-out efficiency of the materials is improved.
Example IV
Fig. 8 is a schematic structural diagram of a warehouse entry management device according to a fourth embodiment of the present invention. As shown in fig. 8, the apparatus includes:
the key field acquisition module 410 is configured to decode the scanned two-dimensional code of the material to obtain key field information corresponding to the two-dimensional code of the material;
the material warehouse-in query module 420 is configured to perform warehouse-in query based on key field information corresponding to the material two-dimensional code, obtain a warehouse-in query result, and execute a material warehouse-in operation when the warehouse-in query result is that the material warehouse-in information is queried;
and the material ex-warehouse query module 430 is configured to perform an ex-warehouse query on the key field information corresponding to the material two-dimensional code in the database, and determine whether to perform an ex-warehouse operation according to the ex-warehouse query result.
According to the technical scheme, the automatic judgment of whether the material is in the warehouse is realized by carrying out the warehouse-in query according to the key field information corresponding to the two-dimensional code of the material; in addition, the key field information corresponding to the two-dimension codes of the materials is subjected to warehouse-out inquiry in the database, so that automatic judgment of whether the materials are in warehouse-out or not is realized.
In some optional embodiments, the key field information corresponding to the two-dimensional code of the material includes one or more of a material item number, a material order number, and a material drawing number;
correspondingly, the material warehouse entry query module 420 may be further configured to:
if the database contains the warehouse-in information matched with one or more of the material item number, the material order number and the material drawing number, the warehouse-in query result is determined to be the queried material warehouse-in information.
In some alternative embodiments, the in-out garage management apparatus further comprises:
and the material warehouse-in information updating module is used for updating the material warehouse-in information based on the material quantity and the historical material warehouse-in quantity in the key field information corresponding to the material two-dimensional code.
In some alternative embodiments, the material shipment query module 430 may also be configured to:
if the material delivery inquiry result is that the material delivery information is inquired, carrying out material delivery;
and if the material delivery information is not queried according to the delivery query result, not delivering the material.
In some alternative embodiments, the in-out garage management apparatus further comprises:
the quality detection module is used for detecting the quality of the warehouse-in materials and obtaining quality detection results of the warehouse-in materials;
accordingly, the material delivery query module 430 includes:
and the ex-warehouse operation judging unit is used for judging whether to perform ex-warehouse operation according to the ex-warehouse inquiry result and the quality detection result of the warehouse-in materials.
In some optional embodiments, the ex-warehouse operation determining unit is specifically configured to:
and under the condition that the quality detection result of the warehouse-in material is qualified in quality inspection, responding to the selection operation of a quality inspection qualified button, and if the material warehouse-out information corresponding to the key field information corresponding to the material two-dimension code is matched in the database, executing the material warehouse-out operation and printing a quality inspection qualified label.
In some optional embodiments, the ex-warehouse operation determining unit is specifically configured to:
and if the material output information corresponding to the key field information corresponding to the material two-dimension code is not matched in the database, printing a quality inspection disqualification label.
The warehouse entry management device provided by the embodiment of the invention can execute the warehouse entry management method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method.
Example five
Fig. 9 shows a schematic diagram of an electronic device 10 that may be used to implement an embodiment of the invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. Electronic equipment may also represent various forms of mobile devices, such as personal digital assistants, cellular telephones, smartphones, wearable devices (e.g., helmets, eyeglasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.
As shown in fig. 9, the electronic device 10 includes at least one processor 11, and a memory, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, etc., communicatively connected to the at least one processor 11, in which the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various appropriate actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from the storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 may also be stored. The processor 11, the ROM 12 and the RAM 13 are connected to each other via a bus 14. An I/O interface 15 is also connected to bus 14.
Various components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, etc.; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.
The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, digital Signal Processors (DSPs), and any suitable processor, controller, microcontroller, etc. The processor 11 performs the various methods and processes described above, such as the in-out warehouse management method, which includes:
decoding the scanned material two-dimensional code to obtain key field information corresponding to the material two-dimensional code;
performing warehousing query based on key field information corresponding to the material two-dimensional code to obtain a warehousing query result, and executing material warehousing operation under the condition that the warehousing query result is the material warehousing information;
and carrying out ex-warehouse inquiry on the key field information corresponding to the material two-dimensional code in a database, and judging whether to carry out ex-warehouse operation or not according to the ex-warehouse inquiry result.
In some embodiments, the in-and-out management method may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the above-described in-and-out management method may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the in-and-out management method in any other suitable manner (e.g., by means of firmware).
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuit systems, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems On Chip (SOCs), complex Programmable Logic Devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs, the one or more computer programs may be executed and/or interpreted on a programmable system including at least one programmable processor, which may be a special purpose or general-purpose programmable processor, that may receive data and instructions from, and transmit data and instructions to, a storage system, at least one input device, and at least one output device.
A computer program for carrying out methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be implemented. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on 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), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) through which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.
The computing system may include clients and servers. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical hosts and VPS service are overcome.
It should be appreciated that various forms of the flows shown above may be used to reorder, add, or delete steps. For example, the steps described in the present invention may be performed in parallel, sequentially, or in a different order, so long as the desired results of the technical solution of the present invention are achieved, and the present invention is not limited herein.
The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.
Claims (10)
1. A method of managing access to a warehouse, comprising:
decoding the scanned material two-dimensional code to obtain key field information corresponding to the material two-dimensional code;
performing warehousing query based on key field information corresponding to the material two-dimensional code to obtain a warehousing query result, and executing material warehousing operation under the condition that the warehousing query result is the material warehousing information;
and carrying out ex-warehouse inquiry on the key field information corresponding to the material two-dimensional code in a database, and judging whether to carry out ex-warehouse operation or not according to the ex-warehouse inquiry result.
2. The method of claim 1, wherein the key field information corresponding to the two-dimensional code of the material includes one or more of a material item number, a material order number, and a material drawing number;
correspondingly, the step of carrying out warehouse-in query based on the key field information corresponding to the material two-dimensional code to obtain a warehouse-in query result comprises the following steps:
if the database contains the warehouse-in information matched with one or more of the material item number, the material order number and the material drawing number, the warehouse-in query result is determined to be the queried material warehouse-in information.
3. The method of claim 1, wherein after the performing the material warehousing operation, the method further comprises:
and updating the material warehouse-in information based on the material quantity and the historical material warehouse-in quantity in the key field information corresponding to the material two-dimensional code.
4. The method according to claim 1, wherein the determining whether to perform the ex-warehouse operation according to the ex-warehouse query result comprises:
if the material delivery inquiry result is that the material delivery information is inquired, carrying out material delivery;
and if the material delivery information is not queried according to the delivery query result, not delivering the material.
5. The method of any one of claims 1-4, wherein after performing the material warehousing operation and updating the material warehousing information, the method further comprises:
detecting the quality of the warehouse-in material to obtain a quality detection result of the warehouse-in material;
correspondingly, the judging whether to perform the ex-warehouse operation according to the ex-warehouse query result includes:
judging whether to carry out ex-warehouse operation or not according to the ex-warehouse inquiry result and the quality detection result of the warehouse-in materials.
6. The method of claim 5, wherein the determining whether to perform the ex-warehouse operation based on the ex-warehouse query result and the quality detection result of the in-warehouse material comprises:
and under the condition that the quality detection result of the warehouse-in material is qualified in quality inspection, responding to the selection operation of a quality inspection qualified button, and if the material warehouse-out information corresponding to the key field information corresponding to the material two-dimension code is matched in the database, executing the material warehouse-out operation and printing a quality inspection qualified label.
7. The method of claim 5, wherein the determining whether to perform the ex-warehouse operation based on the ex-warehouse query result and the quality detection result of the in-warehouse material comprises:
and if the material output information corresponding to the key field information corresponding to the material two-dimension code is not matched in the database, printing a quality inspection disqualification label.
8. An in-out management device, comprising:
the key field acquisition module is used for decoding the scanned material two-dimensional code to obtain key field information corresponding to the material two-dimensional code;
the material warehouse-in query module is used for carrying out warehouse-in query based on the key field information corresponding to the material two-dimensional code to obtain a warehouse-in query result, and executing material warehouse-in operation under the condition that the warehouse-in query result is the material warehouse-in information;
and the material delivery inquiry module is used for judging whether to deliver the materials to the warehouse or not based on the key field information corresponding to the two-dimensional codes of the materials, and if the materials are delivered to the warehouse, the material delivery operation is executed.
9. An electronic device, the electronic device comprising:
at least one processor;
and a memory communicatively coupled to the at least one processor;
wherein the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the in-and-out garage management method of any one of claims 1-7.
10. A computer readable storage medium storing computer instructions for causing a processor to implement the method of warehousing management of any one of claims 1-7 when executed.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202310970852.2A CN116894625A (en) | 2023-08-03 | 2023-08-03 | Warehouse-in and warehouse-out management method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202310970852.2A CN116894625A (en) | 2023-08-03 | 2023-08-03 | Warehouse-in and warehouse-out management method and device, electronic equipment and storage medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN116894625A true CN116894625A (en) | 2023-10-17 |
Family
ID=88310748
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202310970852.2A Pending CN116894625A (en) | 2023-08-03 | 2023-08-03 | Warehouse-in and warehouse-out management method and device, electronic equipment and storage medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN116894625A (en) |
-
2023
- 2023-08-03 CN CN202310970852.2A patent/CN116894625A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107798571B (en) | Malice address/malice order identifying system, method and device | |
CN113407851A (en) | Method, device, equipment and medium for determining recommendation information based on double-tower model | |
CN114596188A (en) | Watermark detection method, model training method, device and electronic equipment | |
CN115995022A (en) | Seal identification method, device, equipment and storage medium | |
CN116894625A (en) | Warehouse-in and warehouse-out management method and device, electronic equipment and storage medium | |
CN115599945A (en) | User grade determination method, device, equipment and storage medium | |
CN114706610A (en) | Business flow chart generation method, device, equipment and storage medium | |
CN115759942A (en) | Storage management method, system, device, server, terminal and storage medium | |
CN113691442B (en) | Friend recommendation method, device, equipment, storage medium and program product | |
CN116340346A (en) | Material code allocation method, device, equipment and storage medium | |
CN116308001A (en) | Product information pushing method and device, electronic equipment and storage medium | |
CN118312663A (en) | Method and device for determining article information, electronic equipment and storage medium | |
CN115019334A (en) | Task processing method, device, equipment and medium | |
CN118036635A (en) | Two-dimensional code generation and reading methods, two-dimensional code generation and reading devices, electronic equipment and storage medium | |
CN117635272A (en) | Object recommendation method and device, electronic equipment and storage medium | |
CN116993416A (en) | Merchant recommendation method, device, equipment and medium | |
CN115131137A (en) | Operation risk checking method, device, equipment and storage medium | |
CN115964081A (en) | Code scale determination method, device, equipment and storage medium | |
CN113344550A (en) | Flow processing method, device, equipment and storage medium | |
CN116975653A (en) | Sample information determining method and device, electronic equipment and storage medium | |
CN117520092A (en) | Log data determining method and device, electronic equipment and medium | |
CN115455437A (en) | Code unauthorized detection method and device, electronic equipment and storage medium | |
CN116245982A (en) | Animation file generation method and device, electronic equipment and storage medium | |
CN115599998A (en) | Information generation method and device, storage medium, electronic equipment and product | |
CN117151040A (en) | Encoding method, device, 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 |