CN116354018A - Automatic drug storage detection method, device and equipment - Google Patents

Abstract

The invention discloses an automatic medicine warehouse-in detection method, device and equipment, which comprises the following steps: acquiring interaction data among a supervision code database, a stacking database and a warehouse management database based on a cross-system; responding to the stacking request, and detecting the current stacking state in real time based on the interaction data to obtain stacking state data after stacking is completed; the stacking state data are sent to a warehouse management system from a stacking system, the warehouse management system is updated to generate a corresponding target order state, and the target order state is detected in real time to obtain updated target order data; when the detection mode is started, the balance among the current stacking state, the target order state and the interactive data is detected in real time, whether the task is abnormal in the running process is judged, and an abnormal prompt is output. Based on the cross-system connection of the databases, the data balance among the databases is ensured, the manual detection can be replaced, the abnormality can be positioned and warned in time, and the automation of medicine warehouse-in detection is realized.

Description

Automatic drug storage detection method, device and equipment

technical field

The invention relates to the technical field of drug management, in particular to an automatic drug storage detection method, device and equipment.

Background technique

With the accelerated pace of life, people's requirements for logistics efficiency are also constantly increasing. In order to improve the storage efficiency of medicines in the workshop, robots are usually used to carry boxes. The warehousing and stacking of medicines produced in the workshop has changed from manual to machine, which requires real-time verification of data accuracy and data balance between systems. The defects of the prior art are: 1. The pharmaceutical production workshop and the warehouse are in different spaces, and the workshop cannot see the stacking situation of the warehouse, and cannot find problems in time. 2. The data interaction between the assembly line hardware equipment and the warehouse management software lacks the monitoring of auxiliary programs, which leads to the inability to locate problems in time and prevent early warning of erroneous instructions in equipment. 3. The data transmission between the various systems is not equal, and abnormalities are prone to occur. To sum up, due to the many warehousing links, when an exception occurs, it is not handled in time, resulting in low warehousing efficiency.

Contents of the invention

The purpose of the present invention is to provide an automatic drug storage detection method, device, equipment and storage medium, based on the establishment of cross-system connections to various databases, the storage and stacking of finished products in the workshop is changed from manual to machine, and real-time verification of each database The data accuracy and data balance between can replace manual inspection, locate and warn abnormalities in time, and realize the automation of storage inspection.

The invention provides an automated drug storage detection method, which is characterized in that it comprises:

Interaction data between the corresponding supervision code database, palletizing database and warehouse management database is obtained based on the cross-system, and the interaction data includes information for establishing a connection with the supervision code database, information for establishing a connection with the palletizing database, and Information on establishing a connection with the warehouse management database;

In response to the palletizing request sent from the warehouse management database to the palletizing system, the current palletizing state is detected in real time based on the interactive data, and the palletizing state data after palletizing is completed;

Send the palletizing status data from the palletizing system to the warehouse management system, establish a connection between the palletizing system and the warehouse management system, and update the warehouse management system to generate a corresponding target order status , and perform real-time detection on the target order status to obtain updated target order data;

When the detection mode is started, the balance between the current palletizing state, the target order state and the interactive data is detected in real time and whether there is any abnormality in the operation process of the task related to the automatic drug storage, if any abnormal situation occurs , an exception prompt will be output on the user interface.

Preferably, it also includes:

In the normal working state, collect target drug information according to the storage request, send the target drug information from the supervision code system to the palletizing system, and establish a relationship between the palletizing system and the supervision code system The target drug information includes at least the production batch number of the target drug, the drug sub-category code and the corresponding drug regulatory code information;

Obtain the target production task ID from the supervision code system, obtain the corresponding drug supervision code information according to the target production ID, and bind the target production task ID with the target palletizing task one by one;

In the running state of the detection mode, it is detected whether the interactive data transmission between the supervision code system and the palletizing system is successful, that is, the target in production is obtained according to the production batch of the target drug production task ID, locate the corresponding drug supervision code information generated by the supervision code system according to the corresponding drug supervision code information received by the palletizing system, and confirm the target production task ID in production is it accurate;

Wherein, one production batch of the target drug includes multiple target production tasks, and only one target production task is performed in the same batch.

Preferably, the method for starting the detection mode includes:

Obtain the finished product plan work order generated by the warehouse management system according to the storage request;

sending a palletizing location request from the warehouse management system to the palletizing system according to the finished product planning work order;

According to the palletizing position request, obtain the binding instruction for the target palletizing position issued by the palletizing system to execute the allocation of the target palletizing position, and control the external equipment to sort the allocated palletizing positions, Obtain the first comparison information after the palletizing is completed, the first comparison information includes at least the total number of palletized pieces of the target drug and the corresponding drug regulatory code information;

Sending the first comparison information after the palletizing is completed to the warehouse management system to obtain the second comparison information after the target order is closed, the second comparison information at least includes that the palletizing system transmits to the warehouse management system The total number of target drugs and the corresponding drug regulatory code information;

Obtain the target drug information generated by the supervision code system, send the target drug information to the palletizing system to obtain the third comparison information after production is completed, the target drug information includes at least the target production batch number and the target drug supervision code Information, the third comparison information includes at least the total number of target drugs transmitted by the regulatory code system to the palletizing system and the corresponding drug regulatory code information;

Judging whether there is an abnormality in the automated warehousing process, comparing the first comparison information, the second comparison information and the third comparison information, and checking in real time whether the interaction data output between the system databases are consistent , output the detection results related to the system stability.

Preferably, the method for starting the detection mode further includes:

Obtain the document information and supervision code information of the target palletizing task in the palletizing system;

The first step is to detect whether the palletizing system has received the supervision code information sent by the supervision code system, and in the case of abnormal transmission, re-obtain the supervision code corresponding to the target drug from the supervision code system information;

Carry out a second step of detection on the workshop production line equipment, the supervision code system, and the interactive network and ports in the palletizing system;

Obtain the palletizing task status corresponding to the target order in the supervision code system, the palletizing system and the warehouse management system and the corresponding drug supervision code information, and obtain the interaction data balance in each system database a third step of detection, enabling compensatory checks for in-progress or unsuccessful tasks; and/or,

If there is a hardware failure, hardware error information is collected, and a failure prompt is issued according to the hardware error information. The hardware error information includes alarm information generated by related equipment during the automated drug storage process and abnormal status information of warehouse shelving tasks.

Preferably, the real-time detection of the target palletizing state based on the interaction data includes:

Acquiring the interaction data in progress of the palletizing task, the interaction data at least includes the document information transmitted from the warehouse management database to the palletizing database, the total number of orders obtained from the warehouse management database, the The number of pieces and the number of pieces on the current pallet obtained from the palletizing database;

Check whether each document information conforms to the preset palletizing rules;

Confirm whether the interaction data generated between the palletizing database and the warehouse management database is balanced by the formula of the total number of target orders = the number of pieces on the pallet + the number of pieces on the shelf;

When one or more of the document information does not meet the preset palletizing rules, mark the current palletizing position;

When all the document information generated during the whole inspection process conforms to the preset palletizing rules, the command operation of the current palletizing state inspection is directly ended to complete the whole inspection operation under the current state.

As preferably, judging whether the palletizing system has received the batch closing instruction sent from the supervision code system further includes:

When a pallet is full on the pallet, send a full pallet command to the palletizing system and generate an xml file, which includes the order number of the finished product planning work order corresponding to the current palletizing task, the drug production batch number, the pallet No. and supervision code information on the current pallet as well as palletizing time;

Receiving the xml file from the warehouse management system and parsing the xml file, obtaining the parsed information and storing it in a database corresponding to the warehouse management system, so as to show that the physical object is in a warehouse-in state.

Preferably, the checking whether each document information conforms to the preset palletizing rules includes:

Judging whether the target palletizing position task obtained from the warehouse management system is legal;

Apply for a stacking position from the warehouse management system to the palletizing system according to the production batch number, and judge whether the application for the current stacking position is successful. The target drug is placed on the hoist, and the regulatory code information corresponding to the target drug is obtained after the grab position operation and photoelectric scanning operation. If it is recognized that the regulatory code information does not match the current palletizing task, it will be removed from the fault port;

If the current palletizing position has completed the allocation instruction operation, a rejection signal for allocating a new palletizing position is issued and fed back to the warehouse management system and a prompt is given to the user;

If the current palletizing position has been assigned to the current production batch number, a rejection signal for assigning a new palletizing position is issued and fed back to the warehouse management system and a prompt is given to the user;

Judging whether the palletizing system has received the batch closing instruction sent from the supervision code system, if the batch closing instruction is received, it will enter the corresponding warehousing task, output the number of full boxes and the total quantity of the current palletizing, and Compared with the actual number of full boxes and the total number of palletized, it is judged whether the number is equal, and if the batch closing instruction is not received, the target palletizing task is continued.

Preferably, said obtaining the finished product planning work order generated by the warehouse management system according to the storage request further includes:

Verifying the planned work order for the finished product;

The content of the verification includes: judging whether the drug subcategory code obtained from the finished product plan work order matches the subcategory code in the finished product subcategory code table generated from the palletizing system, and the finished product subcategory code The table includes the name of the target drug, the subclass code and the box type number packed into the box;

Binding the production batch number corresponding to the target pallet location, and judging whether the bound production batch number exists in the target order obtained from the warehouse management system.

The present invention also provides an automatic drug storage detection device, including:

The data acquisition module is used to obtain the interaction data between the corresponding supervision code database, palletizing database and warehouse management database based on cross-system, the interaction data includes the information of establishing a connection with the supervision code database, and the information related to the palletizing Information on establishing a connection to the database and information on establishing a connection with the warehouse management database;

The first detection module is used to respond to the palletizing request sent from the warehouse management system to the palletizing system, to detect the current palletizing state in real time based on the interactive data, and to obtain the palletizing state data after the palletizing is completed;

The second detection module is used to send the palletizing state data from the palletizing system to the warehouse management system, establish a connection between the palletizing system and the warehouse management system, and update the warehouse management system The system generates the corresponding target order status, and detects the target order status in real time to obtain updated target order data;

The abnormal output module is used to detect in real time the balance between the current palletizing state, the target order state and the interactive data when the detection mode is started, and judge whether there is an Abnormal, if an abnormal situation occurs, an abnormal prompt will be output on the user interface.

The present invention also provides a control device, comprising:

memory, the memory is used to store the processing program;

A processor, when the processor executes the processing program, the automatic drug storage detection method according to the embodiment of the present invention is realized.

For the prior art, the present invention has the following beneficial effects:

The automatic drug storage detection method provided by the present invention is based on the establishment of connections to various databases across systems, the storage and stacking of finished products in the workshop is changed from manual to machine, and the data accuracy and data accuracy between the databases are verified in real time. Balanced, it can replace manual inspection, locate and warn of abnormalities in time, and realize the automation and intelligence of storage inspection.

The present invention is based on AC, WCS, and WMS to realize the functions of data verification and monitoring of the whole process; as an auxiliary instruction operation in the manufacturing industry, it realizes the data collection and early warning functions of assembly line hardware equipment and warehouse management software.

The invention breaks through the barriers between the various systems on the production line, checks the interactive data between AC, WCS and WMS programs in real time, monitors the palletizing state and data balance; realizes the inspection of the equipment state, including the inspection of the network, port and document state; realizes Data check function, check the data balance of the palletizing order.

Description of drawings

Figure 1 is a schematic diagram of the steps of the automated drug storage detection method described in an embodiment of the present invention;

Fig. 2 is the schematic diagram of each database interaction in an embodiment of the present invention;

Fig. 3 is an example diagram of WCS palletizing state detection in an embodiment of the present invention;

Fig. 4 is an example diagram of the status interface of the palletizing position in an embodiment of the present invention;

Fig. 5 is a flowchart of automated drug storage detection in an embodiment of the present invention;

Fig. 6 is an example diagram of the stability check of the automated drug storage detection method described in an embodiment of the present invention;

Fig. 7 is an example diagram of routine inspection of the automated drug storage detection method described in an embodiment of the present invention;

Fig. 8 is an example diagram of fault checking of the automatic drug storage detection method according to an embodiment of the present invention.

Detailed ways

In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

As used herein, the term "comprise" and its variations are open-ended, ie "including but not limited to". The term "based on" is "based at least in part on". The term "an embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". Relevant definitions of other terms will be given in the description below.

It should be noted that the concepts such as "once" and "second" mentioned in the disclosure of this application are only used to distinguish different devices, modules or units, and are not used to limit the sequence of functions performed by these devices, modules or units or interdependence.

It should be noted that the modifications of "one" and "plurality" mentioned in the disclosure of the present application are illustrative and not restrictive, and those skilled in the art should understand that unless the context clearly indicates otherwise, it should be understood as "a or more".

Embodiment one

As shown in Fig. 1, the present invention provides a kind of automatic drug storage detection method, it is characterized in that, comprises:

S1: Obtaining the interaction data between the corresponding supervision code database, palletizing database and warehouse management database based on cross-system, the interaction data includes information establishing connection with the supervision code database, information establishing connection with the stacking database Information and the information that establishes connection with described warehouse management database; With reference to shown in Figure 2, the user-friendly cross-system that present embodiment adopts is the interactive platform that realizes by XZRobot program, obtains required information from each system database, namely from supervision The code system AC obtains the supervision code database data, the palletizing system WCS obtains the palletizing database data, and the warehouse management system WMS obtains the warehouse management database data, and monitors the interface in real time. As long as an abnormality is detected, an alarm can be issued for timely processing.

S2: In response to the palletizing request sent from the warehouse management system to the palletizing system, based on the interactive data, the current palletizing state is detected in real time, and the palletizing state data after palletizing is completed;

In order to break through the barriers between the various systems on the production line, check the interactive data between AC, WCS and WMS programs in real time, monitor the palletizing status and data balance, and perform real-time detection of the target palletizing status based on the interactive data in the step S2 include:

S210: Obtain the interaction data in progress of the current palletizing task, the interaction data at least includes the document information transmitted from the warehouse management database to the palletizing database, and the total number of target orders obtained from the warehouse management database , the number of pieces currently on the shelf and the current number of pieces on the pallet obtained from the palletizing database; when palletizing, it is necessary to first code to the pallet and then switch to other positions. The document information described in this embodiment includes: According to the finished product plan of WMS The WCS palletizing position, WMS order number, drug name, order quantity, drug subcategory code, and drug production batch number of the work order application.

S211: Check whether each document information conforms to the preset palletizing rules; the preset palletizing rules in this embodiment include: 1. WCS has a drug information table, including drug name, sub-category code, box model number. Boxes of different sizes have different stacking methods, and there are 4 numbers in total. Whether the subclass code is in the WCS drug information table. 2. It is not allowed to have two palletizing tasks for one production batch of drugs at the same time.

S212: Confirm whether the interaction data between the palletizing database and the warehouse management database is balanced through the formula of total number of orders = number of pieces on pallet + number of put-on-shelf pieces; the number of put-on-shelf pieces described in this embodiment is Refers to the number of pieces that WMS has received. When a pallet is full of pallets, WCS will generate an xml file, which contains the order number of the WMS finished product plan work order corresponding to the current palletizing task, the drug production batch number, the pallet number, the supervision code information on the pallet, and the palletizing time. WMS will parse the xml file and record the above information into the database, which means that the physical object has been stored. According to the WMS order number, the number of supervised codes that have been put into storage is queried, that is, the number of received items.

S213: When one or more of the document information does not conform to the preset palletizing rules, mark the current palletizing location; the document information described in this embodiment can be updated information generated by executing WCS tasks or executed by WMS For the update information generated by the task, if the above information does not meet the preset rules, the XZRobot program in the automated drug storage inspection system will turn red, and an alarm sound will be played to warn.

S214: When all the document information generated during the whole inspection process conforms to the preset palletizing rules, directly end the instruction operation of the current palletizing state inspection to complete the whole inspection operation in the current state. This embodiment is a full-process inspection of automated drug storage, and one inspection is completed after running for about 30 seconds. If all the data that needs to be checked conform to the rules, the green color is normally displayed, and it turns red once an abnormality is detected on the way.

With reference to shown in Fig. 3, in the present embodiment, the inspection to the stacking state focuses on the task in progress, obtains the expected arrival notice document and the production task of AC that WMS passes to WCS from AC, WCS, WMS database, checks Check whether each document complies with the palletizing rules, and confirm in real time whether the WCS and WMS data are balanced through the formula "total number of pieces on the order = number of pieces on the pallet + number of pieces on the shelf". If an error is found, the document will turn red on the interface to remind the business Errors are detected by personnel in a timely manner. The erroneous documents described in this embodiment are mainly to prevent some errors when artificially creating work orders, such as subcategory coding errors, warehouse errors, quantity errors, and simultaneous application for palletizing positions for multiple tasks in the same batch.

In one embodiment, the step of checking whether each document information conforms to the preset palletizing rules in the step S211 includes:

S2110: judging whether the target palletizing position task obtained from the warehouse management system is legal;

S2111: Apply for a palletizing position from the warehouse management system to the palletizing system according to the production batch number, and judge whether the application for the current palletizing position is successful. If the application for the palletizing position is unsuccessful, if the workshop will The target drug is placed on the hoist, and the regulatory code information corresponding to the target drug is obtained after the grabbing position operation and photoelectric scanning operation. If it is recognized that the regulatory code information does not match the current palletizing task, start remove;

S2112: If the current palletizing location has completed the allocation command operation, send a rejection signal for assigning a new palletizing location, feed it back to the warehouse management system, and issue a prompt to the user;

S2113: If the current palletizing position has been assigned to the current production batch number, send a rejection signal for allocating the new palletizing position, feed it back to the warehouse management system, and issue a prompt to the user;

S2114: Judging whether the palletizing system has received the batch closing instruction from the supervision code system, if the batch closing instruction is received, enter the corresponding warehousing task, and output the current number of full boxes and the total number of palletized , and compare it with the actual palletized FCL and total quantity to determine whether the quantity is equal, and continue to run the target palletizing task if the batch closing instruction is not received.

Those skilled in the art can understand that this embodiment checks the preset palletizing rules: whether the palletizing task of WCS is legal: 1) judge whether the WMS applies for a palletizing position, if no palletizing position is applied for, if the workshop will pack the Put the whole box of medicines on the hoist, reach the grabbing position of the manipulator, and after photoelectric scanning, if it is found that the batch of supervision codes has no palletizing task, it will be rejected and exit from the fault port; 2) Judging whether the same batch number has repeatedly applied for palletizing positions , there cannot be palletizing positions that have been applied for repeatedly.

Further, in the step S2114, judging whether the palletizing system has received the batch closing instruction sent from the supervision code system further includes:

When a pallet is full on the pallet, send a full pallet command to the palletizing system and generate an xml file, which includes the order number of the finished product planning work order corresponding to the current palletizing task, the drug production batch number, the pallet No. and supervision code information on the current pallet as well as palletizing time;

Receiving the xml file from the warehouse management system and parsing the xml file, obtaining the parsed information and storing it in a database corresponding to the warehouse management system, so as to show that the physical object is in a warehouse-in state.

S3: Send the palletizing state data from the palletizing system to the warehouse management system, establish a connection between the palletizing system and the warehouse management system, and update the warehouse management system to generate a corresponding target Order status, and real-time detection of the target order status to obtain updated target order data;

S4: When the detection mode is started, the balance between the current palletizing state, the target order state and the interactive data is detected in real time and whether there is any abnormality in the operation process of tasks related to the automatic drug storage, if there is In case of an exception, an exception prompt is output on the user interface. During operation, if the status of the palletizing task is normal, the interface will be green; if an error occurs, the interface will turn red, an alarm will sound, and the workshop will suspend palletizing until the error is recovered before continuing to palletize. The data checking function can be realized by checking the data balance of the palletizing order.

As shown in Figure 4, the status and information of the palletizing position are obtained, and the real-time display content includes: the palletizing position channel number and the current task status, if the batch has not been completed, continuous production; WMS work order number, product name specification, production batch number, Obtain the time of palletizing location; the total number of palletized pieces in WCS and AC production task ID, whether to confirm the AC production task ID, the number of AC produced pieces, the number of WMS received goods, the number of pieces on the pallet at the current palletizing location, the status of WMS work order, etc.

The data interaction between the assembly line hardware equipment and the warehouse management software lacks the monitoring of auxiliary programs, which makes it impossible to locate problems in time and to warn of wrong instructions in equipment in advance. As an auxiliary method for the manufacturing industry, this embodiment realizes the data collection and early warning functions of the assembly line hardware equipment and warehouse management software. The cross-system used in this embodiment is based on the AC, WCS and WMS systems, to establish a supervision code database, a palletizing database and a warehouse management database, hereinafter referred to as AC database, WCS database and WMS database. Figure 5 illustrates the automatic warehousing process of finished products from the workshop to the warehouse, and the relationship between the three systems. XZRobot is a monitoring auxiliary program developed on this basis, which is deployed on-site to verify data throughout the process.

Specifically, the specific detection steps of the supervision code system used in this embodiment in the whole process verification include:

S5: Under normal working conditions, collect target drug information according to the storage request, send the target drug information from the supervision code system to the palletizing system, and establish the palletizing system and the supervision code system The connection between the target drug information includes at least the production batch number of the target drug, the drug subcategory code and the corresponding drug regulatory code information;

S6: Obtain the target production task ID from the supervision code system, obtain the corresponding drug supervision code information according to the target production ID, and bind the target production task ID to the target palletizing task one by one;

S7: In the running state of the detection mode, detect whether the interactive data transmission between the supervision code system and the palletizing system is successful, that is, obtain all the production batches of the target drug according to the production batch of the target drug. The target production task ID, according to the corresponding drug supervision code information received by the palletizing system, the corresponding supervision code information generated by the supervision code system is located, and the target production in production is confirmed Whether the task ID is accurate;

Wherein, one production batch of the target drug includes multiple target production tasks, and only one target production task is performed in the same batch. In this embodiment, the following checks are performed on the AC, such as checking whether the AC has successfully passed the supervision code to the WCS; whether the correct task ID has been obtained. Use the supervision code information received by WCS to locate the supervision code in the AC system, and confirm whether the obtained task ID is correct. There are multiple tasks in one batch of AC, and other systems do not need to use the AC task ID, so there is no function of passing the AC task ID to other systems. There is only one AC task in progress in the same batch, but in rare cases, the workshop may suspend task A and perform task B during operation. In this case, the ID of task B is obtained in real time, so the task needs to be confirmed Is the ID correct and records the correct ID.

In order to check the stability of the automated drug storage inspection system, as shown in Figure 6, all abnormalities detected in the automatic storage process and combined with the operation log are convenient for traceability and location. The method for starting the detection mode in the step S4 includes:

S410: Obtain a finished product planning work order generated by the warehouse management database according to the storage request;

S411: Send a palletizing location request from the warehouse management database to the palletizing location database according to the finished product planning work order; the information used by the finished product planning work order in the automated storage process: target order number, warehouse information , the name of the target drug, the material code of the target drug, the production batch number of the target drug, the target order quantity, the quantity received, the unit, the pallet number, the pallet location number, the number of boxes, and the sub-category code.

S412: According to the palletizing position request, obtain the binding instruction for the target palletizing position issued by the palletizing system to execute the allocation of the target palletizing position, and control the external device to distribute the allocated palletizing position Picking, to obtain the first comparison information after the palletizing is completed, the first comparison information includes at least the total number of palletized pieces of the target drug and the corresponding drug supervision code information; the control external equipment used in this embodiment can be automatic sorting machine or other automatic sorting equipment.

S413: Send the first comparison information after the palletizing is completed to the warehouse management system to obtain the second comparison information after the target order is closed, the second comparison information at least includes the palletizing system transmitted to the warehouse The total number of target drugs in the management system and the corresponding drug regulatory code information;

S414: Obtain the target drug information generated by the supervision code system, send the target drug information to the palletizing system to obtain the third comparison information after production is completed, the drug information includes at least the target production batch number and target drug supervision Code information, the third comparison information includes at least the total number of target drugs transmitted by the regulatory code system to the palletizing system and the corresponding drug regulatory code information;

S415: Determine whether there is an abnormality in the automated warehousing process, compare the first comparison information, the second comparison information, and the third comparison information, and verify the interaction data output between the system databases in real time Whether it is consistent, output the test results related to system stability, the first comparison information, the second comparison information and the third comparison information can also include other required information, updated receipt information, palletizing information, warehouse Management information, order information, etc.

Those skilled in the art can understand that after the WCS palletizing task is completed, the documents and data of the palletizing task in the AC, WCS and WMS databases are obtained, and by comparing the total number of pieces and supervision code information sent by AC to WCS, and the total number of palletizing pieces in WCS Compare with the supervision code information, the total number of pieces and supervision code information sent by WCS to WMS, and the total number of goods received by WMS and the supervision code information. If the corresponding WMS order has not been closed for a long time, an alarm will be prompted. by human intervention. The inspection method of WCS also includes: 1) Check the current number of pallets in WCS = total number of palletized pieces in WCS - number of received goods in WMS; 2) Whether the palletizing task of WCS is legal: i) Whether WMS applies for palletizing position; no application for palletizing If the workshop puts the packaged full box of medicines on the elevator, and reaches the grabbing position of the manipulator, after photoelectric scanning, it is found that there is no palletizing task for the batch of supervision codes, it will be rejected and exit from the fault exit. ii) Whether the same batch number has repeatedly applied for palletizing positions; 3) Whether the palletizing task has been approved, that is, whether the AC system has issued an order end instruction; 4) Obtain real-time hardware alarm information, the specific content will be described in detail below.

In the step S410, obtaining the finished product planning work order generated by the warehouse management database according to the warehousing request further includes:

Verify the planned work order of the finished product; judge the data balance of the current palletizing position: the current number of pallets in WCS = the total number of palletizing in WCS - the number of received goods in WMS; when the pallet is full of pallets, WCS will generate an xml file Contains the order number of the WMS finished product planning work order corresponding to the current palletizing task, the drug production batch number, the pallet number, the supervision code information on the pallet, and the palletizing time. WMS will parse the xml file and record the above information into the WMS database, which means that the physical object has been stored. According to the WMS order number, the number of supervised codes that have been put into the warehouse can be queried, that is, the number of goods received.

The content of the verification includes: 1. Whether the drug subcategory code obtained from the finished product planning work order in the warehouse management database can be found in the product subcategory code table of WCS; that is, whether the drug subcategory code of WMS exists in In the definition of WCS. 2. Whether the shelf rules of WMS are legal or not, for example, if the drug is not put into the designated warehouse according to the classification: the LCL is put into the full container warehouse; 3. Bind the production batch number corresponding to the target pallet position, and judge Whether the bound production batch number exists in the target order obtained from the warehouse management database, where the order is the WMS expected arrival notice and is consistent with the finished product planning work order information.

When performing routine inspection in this embodiment, referring to FIG. 7, the method for starting the detection mode in step S4 also includes:

S420: Obtain the document information and corresponding drug regulatory code information of the target palletizing task in the palletizing system;

S421: Check whether the palletizing system has received the drug supervision code information sent by the supervision code system. Supervision code information; when received, the interface is green and everything is normal, and the workshop is stacking normally; when not received, an alarm will be prompted, and the workshop will suspend palletizing, requiring human intervention to check the cause of network abnormalities. Under the premise that the palletizing task is normally bound, the packaged whole box of medicines is rejected, and the fault exits, it may be that the WCS has not received the supervision code information delivered by the AC. If it is rejected when the delivery is successful, it may be that the label is affixed crookedly, or the label is printed abnormally, and no information is scanned. If it fails, the AC needs to resend the supervision code information.

S422: At the same time, perform a second step of detection on the workshop production line equipment, the supervision code system, and the interactive network and ports in the palletizing system; it is beneficial to realize the detection of equipment status, including network, port and document status checks .

S423: Obtain the interaction of the palletizing task status corresponding to the target order in the regulatory code system, the palletizing system, and the warehouse management system and the corresponding drug regulatory code information obtained in each system database The data balance is checked in the third step to realize the compensation check of the ongoing or unsuccessful tasks.

Those skilled in the art can understand, obtain the documents and information of the palletizing task in the WCS database, check whether the supervision code information issued by the AC is received; Ping/telnet the industrial computer of the production line in the workshop and the AC and WCS database to check whether the network and ports are unblocked ; Obtain AC, WCS, WMS databases to obtain order palletizing status and supervision code information, and check compensation for ongoing or unsuccessful tasks. Specifically, in this embodiment, by comparing the supervision code on the WCS pallet with the information of the current AC task supervision code, it is judged whether the correct task ID has been obtained; Manual update is required; for tasks that have been closed but with unequal AC, WCS, and WMS data, record the cause of failure and find the supervision code that caused the data imbalance; update the status of records that have not obtained the correct task status.

In order to further check the fault problem, as shown in Figure 8, the method for starting the detection mode in the step S4 also includes:

S430: If the hardware fails, collect hardware error information, and issue a fault prompt according to the hardware error information. The hardware error information includes alarm information generated by related equipment during the automated drug storage process, such as palletizing robots and overhead racks. The alarm information of the warehouse, the information of the non-existence of the warehouse put-up task and the unfinished state information of the warehouse put-up task, after obtaining the alarm information of the palletizing robot and the high-bay warehouse, check whether the WMS put-up task exists according to the pallet number, check the storage status: whether the put-up task is After completion, the pallet will arrive at the storage port, indicating that there is no put-on-shelf task, and the following problems will occur: the pallet enters the designated storage location, or it gets stuck somewhere due to a hardware failure during automatic storage, etc. The alarm information of the palletizing robot, such as the abnormal bar code of the pallet, cannot be recognized; some boxes are rejected; the whole pallet comes out from the fault port; the lack of pallets needs to be replenished; hardware fault alarms, such as the failure of the first elevator; Inconsistent with the WCS program count, etc. In this embodiment, the WCS fault reading module collects hardware errors of the WCS in the interface between the WMS and the WCS, and promptly reminds business personnel during operation. In this embodiment, palletized pallets finally enter the elevated warehouse, that is, the elevated three-dimensional warehouse.

The detection method used in this implementation is applied to storage equipment, such as robots and assembly line mechanisms, and is verified and monitored based on AC, WCS, and WMS cross-system full-process data. The standard inbound process works as follows:

In the first step, the workshop selects the finished product planning work order corresponding to the material code and production batch number in WMS.

In the second step, WMS initiates an application to WCS for a palletizing position, and WMS uses the production batch number to apply.

In the third step, WCS judges whether the palletizing position can be allocated. If the preset palletizing position has been allocated, it refuses to allocate a new palletizing position and feeds back to WMS, which will remind the user. The preset stacking positions can be 4 or other quantities.

If the palletizing position is already assigned to the current batch number, then refuse to allocate a new palletizing position, and the user will be reminded by WMS. In this case, the user may select the wrong finished product planning work order. If it is rejected, the packaging will be stopped, and the touch screen or signal light can prompt "abnormal rejection of palletizing position".

If there are none of the above conditions, pack the goods.

Partial receipt and partial putaway of the current task appear alternately in the MS, and the number of putaway pieces described in this embodiment is the same as the number of pieces received by the WMS.

In the fourth step, the packaged goods pass through the sampling equipment used in this embodiment, such as probes, and send information such as product name, drug subcategory code, batch number, and three-level electronic supervision code to WCS according to the electronic supervision code.

In the fifth step, WCS obtains information according to the automated storage inspection system provided in this embodiment to verify whether the current batch number is one of the four palletizing positions. The information obtained by the automated storage inspection system; otherwise, it is suspended.

The sixth step, before the goods arrive at the palletizing robot, WCS obtains the production batch number according to the electronic supervision code on the outer box, and then judges which stacking position the goods are placed according to the production batch number. The above operations are all completed in WCS.

In the seventh step, the palletizing robot palletizes.

In the eighth step, the palletizing robot completes the pallets according to the preset number of boxes per pallet.

In the ninth step, WCS sends the third-level code information of the electronic supervision code of pallets and goods to WMS. The XML file uploaded for sales platform is generated by WMS.

In the tenth step, the WMS completes the listing.

In the eleventh step, if the batch ending signal sent by the AC is not detected, loop to the seventh step.

The twelfth step, in the case that the last pallet is less than the whole pallet, Aichuang sends a batch closing instruction, including the total quantity and status of the full container, to WCS, indicating that the batch is over. WCS compares whether the number of full boxes actually stacked is equal to the total number, and if they are not equal, the process stops and an alarm is issued.

In the thirteenth step, the WMS order is closed, and when the AC, WCS, and WMS data are consistent, the finished product planning work order is closed. The automatic storage process is completed.

The fourteenth step, release the occupancy of the batch number at the palletizing position, and WCS deletes all the electronic supervision code information obtained from the supervision code system for each box of the current finished product planning work order.

Embodiment two

Based on the same concept, the present invention also provides an automatic drug storage detection device, including:

The data acquisition module is used to obtain the interaction data between the corresponding supervision code database, palletizing database and warehouse management database based on cross-system, the interaction data includes the information of establishing a connection with the supervision code database, and the information related to the palletizing Information on establishing a connection to the database and information on establishing a connection with the warehouse management database;

The first detection module is configured to, in response to the palletizing request sent from the warehouse management system to the palletizing system, detect the current palletizing state in real time based on the interactive data, and obtain the palletizing state after palletizing is completed Data; the first detection module described in this embodiment is the palletizing state inspection module.

The second detection module is used to send the palletizing state data from the palletizing system to the warehouse management system, establish a connection between the palletizing system and the warehouse management system, and update the warehouse management system The system generates the corresponding target order status, and detects the target order status in real time to obtain updated target order data;

The abnormal output module is used to detect in real time the balance between the current palletizing state, the target order state and the interactive data when the detection mode is started, and judge whether there is an Abnormal, if an abnormal situation occurs, an abnormal prompt will be output on the user interface.

The third detection module is used to collect target drug information according to the warehousing request under normal working conditions, send the target drug information from the supervision code system to the palletizing system, and establish the palletizing system and The connection between the supervision code systems, the target drug information at least includes the production batch number of the target drug, the drug subcategory code and the corresponding drug supervision code information;

Obtain the target production task ID from the supervision code system, obtain the corresponding drug supervision code information according to the target production ID, and bind the target production task ID with the target palletizing task one by one;

In the running state of the detection mode, it is detected whether the interactive data transmission between the supervision code system and the palletizing system is successful, that is, the target in production is obtained according to the production batch of the target drug Production task ID, locate the corresponding supervision code information generated by the supervision code system according to the corresponding drug supervision code information received by the palletizing system, and confirm the target production task ID in production Is it accurate.

Specifically, the system stability check module includes:

Obtain the finished product plan work order generated by the warehouse management system according to the storage request;

sending a palletizing location request from the warehouse management system to the palletizing system according to the finished product planning work order;

According to the palletizing position request, obtain the binding instruction for the target palletizing position issued by the palletizing position system to execute the allocation of the target palletizing position, and control the external equipment to sort the allocated palletizing positions , obtaining the first comparison information after the palletizing is completed, the first comparison information includes at least the total number of palletized pieces of the target drug and the corresponding drug regulatory code information;

Sending the first comparison information after the palletizing is completed to the warehouse management system to obtain the second comparison information after the order is closed, the second comparison information includes at least the information transmitted by the palletizing system to the warehouse management system The total number of target drugs and the corresponding drug regulatory code information;

Obtain the target drug information generated by the supervision code system, send the target drug information to the palletizing system to obtain the third comparison information after production is completed, and the drug information includes at least the target production batch number and target drug supervision code information , the third comparison information includes at least the total number of target drugs transmitted by the regulatory code system to the palletizing system and the corresponding drug regulatory code information;

Judging whether there is an abnormality in the automated warehousing process, comparing the first comparison information, the second comparison information and the third comparison information, and checking in real time whether the interaction data output between the system databases are consistent , output the detection results related to the system stability.

The routine inspection module includes: obtaining the document information and corresponding drug supervision code information of the target palletizing task in the palletizing system; whether the palletizing system has received the supervision code sent by the supervision code system The first step of detection of information; at the same time, the second step of detection is performed on the workshop production line equipment, the supervision code system, and the interactive network and ports in the palletizing system; The third step is to detect the balance of the interaction data obtained in each database of the palletizing task status corresponding to the target order in the warehouse management system and the corresponding drug supervision code information, so as to realize the in-progress or Compensation check for unsuccessful tasks.

The fault reading module, if there is a fault in the hardware, collects hardware error information and sends a fault prompt according to the hardware error information. The hardware error information includes alarm information generated by related equipment during the automated drug storage process and warehouse shelving tasks exception information.

It should be noted that the division of each module in this device/system embodiment is only a division of logical functions, and may be fully or partially integrated into a physical entity or physically separated during actual implementation. And these modules can all be implemented in the form of calling software through processing elements; they can also be implemented in the form of hardware; some units can also be implemented in the form of calling software through processing elements, and some units can be implemented in the form of hardware.

The implementation principles and methods of the data acquisition module, the first detection module, the second detection module and the abnormality output module have been described in the foregoing embodiments, so they will not be repeated here.

Embodiment Three

Based on the same idea, in some embodiments of the present application, a control device is also provided. The control device includes a memory and a processor, wherein the memory is used to store the processing program, and the processor executes the processing program according to instructions. When the processor executes the processing program, the automatic drug storage inspection method in the foregoing embodiments is realized. The control device used in this embodiment may be a robot.

In some embodiments of the present application, a readable storage medium is also provided, and the readable storage medium may be a non-volatile readable storage medium or a volatile readable storage medium. Instructions are stored in the readable storage medium, and when the instructions are run on the computer, the electronic equipment including the readable storage medium executes the aforementioned automatic drug storage inspection method.

It can be understood that, if the above-mentioned automated drug storage detection methods are implemented in the form of software function modules and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on such an understanding, the essence of the technical solution of the present invention or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium , including several instructions to make a computer device (which may be a personal computer, a server, or a network device, etc.) execute all or part of the steps of the methods in various embodiments of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (Read-only memory, ROM), random access memory (Random access memory, RAM), magnetic disk or optical disk and other various media that can store program codes. .

A computer readable storage medium may include a data signal carrying readable program code in baseband or as part of a carrier wave traveling as part of a data signal. Such propagated data signals may take many forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the foregoing. A readable storage medium may also be any readable medium other than a readable storage medium that can send, propagate or transport a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the readable storage medium may be transmitted by any suitable medium, including but not limited to wireless, cable, optical cable, RF, etc., or any suitable combination of the above.

The program codes involved in implementing the technical solutions disclosed in this application can be written in any combination of one or more programming languages, and the programming languages include object-oriented programming languages—such as Java, C++, etc., and also include A conventional procedural programming language—such as C or a similar programming language. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server to execute. In cases involving a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computing device (for example, using an Internet service provider). business to connect via the Internet).

Finally, it should be noted that: the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: it can still be Modifications are made to the technical solutions described in the foregoing embodiments, or equivalent replacements are made to some of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the various embodiments of the present invention.

Claims (10)

1. An automated drug storage detection method, characterized in that, comprising: Interaction data between the corresponding supervision code database, palletizing database and warehouse management database is obtained based on the cross-system, and the interaction data includes information for establishing a connection with the supervision code database, information for establishing a connection with the palletizing database, and Information on establishing a connection with the warehouse management database; In response to the palletizing request sent from the warehouse management system to the palletizing system, the current palletizing state is detected in real time based on the interactive data, and the palletizing state data after palletizing is completed; Send the palletizing status data from the palletizing system to the warehouse management system, establish a connection between the palletizing system and the warehouse management system, and update the warehouse management system to generate a corresponding target order status , and perform real-time detection on the target order status to obtain updated target order data; When the detection mode is started, the balance between the current palletizing state, the target order state and the interactive data is detected in real time and whether there is any abnormality in the operation process of the task related to the automatic drug storage, if any abnormal situation occurs , an exception prompt will be output on the user interface. 2. The automatic drug storage detection method according to claim 1, further comprising: Under normal working conditions, collect target drug information according to the storage request, send the target drug information from the supervision code system to the palletizing system, and establish a connection between the palletizing system and the supervision code system , the target drug information at least includes the production batch number of the target drug, the drug sub-category code and the corresponding drug regulatory code information; Obtain the target production task ID from the supervision code system, obtain the corresponding drug supervision code information according to the target production ID, and bind the target production task ID with the target palletizing task one by one; In the running state of the detection mode, it is detected whether the interactive data transmission between the supervision code system and the palletizing system is successful, that is, the target in production is obtained according to the production batch of the target drug Production task ID, locate the corresponding supervision code information generated by the supervision code system according to the corresponding drug supervision code information received by the palletizing system, and confirm the target production task ID in production is it accurate; Wherein, one production batch of the target drug includes multiple target production tasks, and only one target production task is performed in the same batch. 3. The automatic drug storage detection method according to claim 2, wherein the method for starting the detection mode comprises: Obtain the finished product plan work order generated by the warehouse management system according to the storage request; sending a palletizing location request from the warehouse management system to the palletizing system according to the finished product planning work order; According to the palletizing position request, obtain the binding instruction for the target palletizing position issued by the palletizing system to execute the allocation of the target palletizing position, and control the external equipment to sort the allocated palletizing positions, Obtain the first comparison information after the palletizing is completed, the first comparison information includes at least the total number of palletized pieces of the target drug and the corresponding drug regulatory code information; Sending the first comparison information after the palletizing is completed to the warehouse management system to obtain the second comparison information after the order is closed, the second comparison information includes at least the information transmitted by the palletizing system to the warehouse management system The total number of target drugs and the corresponding drug regulatory code information; Obtain the target drug information generated by the supervision code system, send the target drug information to the palletizing system to obtain the third comparison information after production is completed, the target drug information includes at least the target production batch number and the target drug supervision code Information, the third comparison information includes at least the total number of target drugs transmitted by the supervision code system to the palletizing system and the corresponding supervision code information; Judging whether there is an abnormality in the automated warehousing process, comparing the first comparison information, the second comparison information and the third comparison information, and checking in real time whether the interaction data output between the system databases are consistent , output the detection results related to the system stability. 4. The automatic drug storage detection method according to claim 2, wherein the method for starting the detection mode further comprises: Obtain the document information and corresponding drug supervision code information of the target palletizing task in the palletizing system; The first step is to detect whether the palletizing system has received the supervision code information sent by the supervision code system, and in the case of abnormal transmission, re-obtain the supervision code corresponding to the target drug from the supervision code system information; Carry out a second step of detection on the workshop production line equipment, the supervision code system, and the interactive network and ports in the palletizing system; Obtain the balance of the interaction data acquired in the databases of each system of the palletizing task status corresponding to the target order in the supervision code system, the palletizing system and the warehouse management system and the corresponding supervision code information Conduct a third-step detection that implements compensation checks for in-progress or unsuccessful tasks; and/or, If the hardware fails, the hardware error information is collected, and a fault prompt is issued according to the hardware error information. The hardware error information includes the alarm information generated by the relevant equipment during the automatic drug storage process and the abnormal status information of the warehouse shelving task. 5. The automated drug warehousing detection method according to claim 2, wherein the real-time detection of the target palletizing state based on the interactive data comprises: Acquiring the interaction data in progress of the palletizing task, the interaction data at least includes the document information transmitted from the warehouse management database to the palletizing database, the total number of target orders obtained from the warehouse management database, the current The number of pieces on the shelf and the current number of pieces on the pallet obtained from the palletizing database; Check whether each document information conforms to the preset palletizing rules; Confirm whether the interaction data generated between the palletizing database and the warehouse management database is balanced by the formula of the total number of target orders = the number of pieces on the pallet + the number of pieces on the shelf; When one or more of the document information does not meet the preset palletizing rules, mark the current palletizing position; When all the document information generated during the whole inspection process conforms to the preset palletizing rules, the command operation of the current palletizing state inspection is directly ended to complete the whole inspection operation under the current state. 6. The automated drug warehousing detection method according to claim 5, wherein said checking whether each said document information complies with a preset palletizing rule comprises: Judging whether the target palletizing position task obtained from the warehouse management system is legal; Apply for a stacking position from the warehouse management system to the palletizing system according to the production batch number, and judge whether the application for the current stacking position is successful. The target drug is placed on the hoist, and the regulatory code information corresponding to the target drug is obtained after the grab position operation and photoelectric scanning operation. If it is recognized that the regulatory code information does not match the current palletizing task, it will be removed from the fault port; If the current palletizing position has completed the allocation instruction operation, a rejection signal for allocating a new palletizing position is issued and fed back to the warehouse management system and a prompt is given to the user; If the current palletizing position has been assigned to the current production batch number, a rejection signal for assigning a new palletizing position is issued and fed back to the warehouse management system and a prompt is given to the user; Judging whether the palletizing system has received the batch closing instruction sent from the supervision code system, if the batch closing instruction is received, it will enter the corresponding warehousing task, output the number of full boxes and the total quantity of the current palletizing, and Compared with the actual number of full boxes and the total number of palletized, it is judged whether the number is equal, and if the batch closing instruction is not received, the target palletizing task is continued. 7. The automated drug warehousing detection method according to claim 6, wherein judging whether the palletizing system has received a batch closing instruction sent from the supervision code system further comprises: When a pallet is full on the pallet, send a full pallet command to the palletizing system and generate an xml file, which includes the order number of the finished product planning work order corresponding to the current palletizing task, the drug production batch number, the pallet No. and supervision code information on the current pallet as well as palletizing time; Receiving the xml file from the warehouse management system and parsing the xml file, obtaining the parsed information and storing it in a database corresponding to the warehouse management system, so as to show that the physical object is in a warehouse-in state. 8. The automated drug warehousing detection method according to claim 3, wherein said obtaining the finished product plan work order generated by the warehouse management system according to the warehousing request further comprises: Verifying the planned work order for the finished product; The content of the verification includes: judging whether the drug subcategory code obtained from the finished product plan work order matches the subcategory code in the finished product subcategory code table generated from the palletizing system, and the finished product subcategory code The table includes the name of the target drug, the subclass code and the box type number packed into the box; Binding the production batch number corresponding to the target pallet location, and judging whether the bound production batch number exists in the target order obtained from the warehouse management system. 9. An automated drug storage detection device, characterized in that it comprises: The data acquisition module is used to obtain the interaction data between the corresponding supervision code database, palletizing database and warehouse management database based on cross-system, the interaction data includes the information of establishing a connection with the supervision code database, and the information related to the palletizing Information on establishing a connection to the database and information on establishing a connection with the warehouse management database; The first detection module is used to respond to the palletizing request sent from the warehouse management system to the palletizing system, to detect the current palletizing state in real time based on the interactive data, and to obtain the palletizing state data after the palletizing is completed; The second detection module is used to send the palletizing state data from the palletizing system to the warehouse management system, establish a connection between the palletizing system and the warehouse management system, and update the warehouse management system The system generates the corresponding target order status, and detects the target order status in real time to obtain updated target order data; The abnormal output module is used to detect in real time the balance between the current palletizing state, the target order state and the interactive data when the detection mode is started, and judge whether there is an Abnormal, if an abnormal situation occurs, an abnormal prompt will be output on the user interface. 10. A control device, characterized in that it comprises: memory, the memory is used to store the processing program; A processor, when the processor executes the processing program, the automatic drug storage detection method according to any one of claims 1 to 8 is realized.

Images