CN113707288A - SPD mode-based medical consumable multi-level storehouse management system and method - Google Patents
SPD mode-based medical consumable multi-level storehouse management system and method Download PDFInfo
- Publication number
- CN113707288A CN113707288A CN202111260375.8A CN202111260375A CN113707288A CN 113707288 A CN113707288 A CN 113707288A CN 202111260375 A CN202111260375 A CN 202111260375A CN 113707288 A CN113707288 A CN 113707288A
- Authority
- CN
- China
- Prior art keywords
- consumable
- information
- warehouse
- database
- list
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H40/00—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices
- G16H40/20—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices for the management or administration of healthcare resources or facilities, e.g. managing hospital staff or surgery rooms
-
- 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
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- General Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Tourism & Hospitality (AREA)
- Finance (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Accounting & Taxation (AREA)
- Biomedical Technology (AREA)
- Epidemiology (AREA)
- General Health & Medical Sciences (AREA)
- Medical Informatics (AREA)
- Primary Health Care (AREA)
- Public Health (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application provides a SPD mode-based medical consumable multilevel storehouse management system and a method, and the system comprises: the server side is provided with a plurality of first users; the server is provided with a primary standby database and a primary in-hospital database corresponding to each first user; the server is also provided with an SPD center library; the first-level standby database is used for storing consumable information in the first-level standby warehouse of the first user; the primary hospital database is used for storing consumable information in the primary hospital warehouse of the first user; the SPD central library is used for storing consumable information in the central consumable warehouse; the system comprises a plurality of first terminals, a plurality of second terminals and a plurality of SPD modules, wherein the SPD systems are installed on the first terminals; the first terminal is used for sending out a purchase order through the SPD system, and the purchase order comprises current purchase consumable information and standby purchase consumable information; and the server is used for receiving the database moving application and the purchasing and warehousing application and updating each database. This application makes the hospital can have reserve consumptive material in advance outside the institute, has reduced the storage area of consumptive material in the institute space.
Description
Technical Field
The disclosure generally relates to the technical field of medical consumable supply, in particular to a SPD mode-based medical consumable multi-level storehouse management system and method.
Background
The hospital drug logistics are put on a professional logistics platform to operate, through the standardized flow specification of an information system and the application of a bar code identification technology, the logistics operation specification is simplified, the quality requirement of managers is reduced, meanwhile, the operation efficiency is improved, and errors are reduced, and the hospital logistics information system is called as an SPD system; the SPD system generates a purchase order for the supplier, who delivers the medication directly to the hospital.
The SPD system simplifies the consumable purchasing process and procedure of the hospital; however, the disadvantages of complicated in-hospital inventory management, complicated in medicinal material purchasing procedure and the like still exist in hospitals.
Disclosure of Invention
In view of the above-mentioned drawbacks and deficiencies of the prior art, it is desirable to provide a SPD mode-based medical consumable multi-level repository management system and method, wherein the system comprises:
the server side is provided with a plurality of first users; the server is provided with a primary standby database and a primary in-hospital database corresponding to each first user; the server is also provided with an SPD center library; the primary standby database is used for storing consumable information in the primary standby warehouse of the first user; the primary hospital database is used for storing consumable information in the primary hospital warehouse of the first user; the SPD central library is used for storing consumable information in the central consumable warehouse;
the system comprises a plurality of first terminals and a plurality of second terminals, wherein the first terminals are held by a first user, and the SPD system is installed on the first terminals; the first terminal is used for sending out a purchase order through the SPD system, and the purchase order comprises current purchase consumable information and standby purchase consumable information;
the server is used for extracting the information of the current purchasing consumables contained in the primary standby database and generating a moving consumable list; extracting the information of the current purchasing consumables contained in the SPD central library and the information of the standby purchasing consumables not contained in the primary standby database to generate a list of consumables to be purchased;
the first terminal sends a warehouse moving application and a purchasing warehouse entering application to the server through the SPD system; the warehouse moving application comprises source warehouse information and target warehouse information with different warehouse information, and also comprises a warehouse moving consumable list; the source warehouse information and the target warehouse information comprise first-level standby warehouse information and first-level in-hospital warehouse information; the purchase warehousing application comprises the list of consumable parts to be purchased;
the server is used for receiving the warehouse moving application, deleting the consumable material information in the warehouse moving consumable material list from the database corresponding to the source warehouse information, and adding the consumable material information in the warehouse moving consumable material list from the database corresponding to the target warehouse information;
and the server is used for receiving the purchase warehousing application, deleting the consumable information in the consumable list to be purchased from the database corresponding to the central consumable warehouse, and correspondingly storing the consumable information in the consumable list to be purchased into a primary yard database or a primary standby database.
According to the technical scheme provided by the embodiment of the application, the method further comprises the following steps:
the plurality of second terminals are held by a second user, and the SPD system is installed on the second terminals; the server is provided with a secondary hospital database corresponding to each second user and used for storing consumable material information in the secondary hospital database of the second user;
the second terminal is used for sending out a purchase requisition; the procurement order comprises procurement consumable information;
the first terminal is configured to receive the procurement order;
the first terminal is also configured to send out a delivery order generation request, and the delivery order generation request comprises the purchase requisition consumable information;
the server is configured to receive a warehouse-out bill generation request, generate a warehouse-out bill and a corresponding warehouse-in bill and warehouse-in confirmation request when the warehouse-out bill generation request is judged to contain the procurement consumable material information in the primary hospital database, wherein the warehouse-in bill and the warehouse-out bill both contain the procurement consumable material information;
the first terminal is used for receiving the delivery order;
the second terminal is used for receiving the warehousing order and the warehousing confirmation request and feeding back warehousing confirmation information;
and after receiving the warehousing confirmation information, the server deletes the consumable information corresponding to the warehouse-out bill from the primary in-hospital database, and adds the consumable information corresponding to the warehouse-in bill from the secondary in-hospital database.
According to the technical scheme provided by the embodiment of the application, the server is further provided with a consumable usage database corresponding to each second user; the consumable material use database stores use consumable material data; the usage consumable data includes usage consumable information, usage time information, and usage user information;
the second terminal is configured to send a consumable use request to the server;
the server is configured to receive the consumable use request, delete the data corresponding to the consumable use information from the secondary hospital database, and add the consumable use data corresponding to the consumable use information from the consumable use database.
According to the technical solution provided by the embodiment of the present application, the server is further configured to:
when the consumable information in the consumable list to be purchased is judged to be the current consumable information to be purchased, storing the consumable information in the consumable list to be purchased in the primary hospital database;
and when the consumable information in the consumable list to be purchased is judged to be standby consumable information to be purchased, storing the consumable information in the consumable list to be purchased in the primary standby database.
In a second aspect, the present application provides a SPD mode-based medical consumable multilevel warehouse management method, which is applied to the SPD mode-based medical consumable multilevel warehouse management system, and includes the following steps:
receiving a purchase order sent by a first terminal through an SPD system, wherein the purchase order comprises current purchase consumable information and standby purchase consumable information;
extracting the information of the current purchasing consumables contained in the primary standby database to generate a moving stock consumable list;
extracting the information of the current purchasing consumables contained in the SPD central library and the information of the standby purchasing consumables not contained in the primary standby database to generate a list of consumables to be purchased;
receiving a database transfer application sent by the first terminal through the SPD system, wherein the database transfer application comprises source warehouse information and target warehouse information with different warehouse information, and also comprises a mobile consumable list; the source warehouse information and the target warehouse information comprise first-level standby warehouse information and first-level in-hospital warehouse information;
deleting corresponding consumable information in the mobile consumable list from a database corresponding to the source warehouse information;
adding corresponding consumable information in the mobile consumable list from a database corresponding to the target warehouse information;
receiving a purchase warehousing application sent by the first terminal through the SPD system;
deleting the consumable information in the consumable list to be purchased from a database corresponding to the central consumable warehouse;
and correspondingly storing the consumable information in the consumable list to be purchased into a primary hospital database or a primary standby database.
According to the technical scheme provided by the embodiment of the application, the method comprises the following steps:
receiving a delivery order generation request, wherein the delivery order generation request is sent by a first terminal after receiving a procurement order sent by a second terminal, and the procurement order comprises procurement consumable material information;
when the first-level in-hospital database contains the procurement consumable information, generating an ex-warehouse bill and a corresponding in-warehouse bill and an in-warehouse confirmation request, wherein the in-warehouse bill and the ex-warehouse bill both contain the procurement consumable information;
sending the delivery list to the first terminal;
sending the warehousing bill and the warehousing confirmation request to the second terminal;
and receiving warehousing confirmation information fed back by the second terminal, deleting the consumable material information corresponding to the warehouse-out bill from the primary in-hospital database, and adding the consumable material information corresponding to the warehouse-in bill from the secondary in-hospital database.
According to the technical scheme provided by the embodiment of the application, the method further comprises the following steps:
receiving a consumable use request sent by a second terminal;
deleting data corresponding to the consumable information from the secondary hospital database;
adding the use consumable data corresponding to the use consumable information from the consumable use database; the consumable usage database is set corresponding to each second user; the usage consumable data includes usage consumable information, usage time information, and usage user information.
According to the technical solution provided by the embodiment of the present application,
correspondingly storing the consumable information in the consumable list to be purchased into a primary hospital database or a primary standby database, comprising:
when the consumable information in the consumable list to be purchased is judged to be the current consumable information to be purchased, storing the consumable information in the consumable list to be purchased in the primary hospital database;
and when the consumable information in the consumable list to be purchased is judged to be standby consumable information to be purchased, storing the consumable information in the consumable list to be purchased in the primary standby database.
According to the technical scheme provided by the embodiment of the application, stock information, inventory lower limit information and inventory upper limit information are stored in the primary hospital database corresponding to consumable information in the primary hospital warehouse; the method further comprises the steps of:
when judging that the inventory information is smaller than the inventory lower limit information, sending stock preparation reminding information to the first terminal;
and sending stock excess reminding information to the first terminal when judging that the stock information is larger than the stock upper limit information.
According to the technical scheme provided by the embodiment of the application, the first-level hospital database also stores valid period information corresponding to consumable information in the first-level hospital database; the method further comprises the following steps:
and sending out the temporary reminding information when the interval time between the validity period and the current date is judged to be less than the set value.
In the technical scheme of the application, a first user corresponds to a warehouse end of each hospital, a primary standby database and a primary in-hospital database are arranged corresponding to each hospital, and an SPD central database is further arranged; when a first user issues a purchase order, the first user comprises current purchase consumable material information and standby purchase consumable material information, so that the standby consumable materials are stored in a primary standby database, and the current purchase consumable materials can be directly called from a primary standby warehouse or from an SPD (Surge protective device) central library when the current purchase consumable materials are stored in the primary standby database; correspond database in the one-level institute in the institute and correspond the reserve database of one-level outside the institute respectively for the hospital can be with reserve consumptive material pre-existing outside the institute, has reduced the storage area of consumptive material in the institute and has taken up an area of the space. Meanwhile, the SPD central library can be arranged corresponding to a plurality of hospitals, so that unified storage and purchase of different hospitals are realized, purchase processes corresponding to a plurality of suppliers are avoided, and the purchase processes are simplified.
Drawings
Other features, objects and advantages of the present application will become more apparent upon reading of the following detailed description of non-limiting embodiments thereof, made with reference to the accompanying drawings in which:
fig. 1 is a schematic block diagram of embodiment 1 of the present application.
Detailed Description
The present application will be described in further detail with reference to the following drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the relevant invention and not restrictive of the invention. It should be noted that, for convenience of description, only the portions related to the present invention are shown in the drawings.
It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict. The present application will be described in detail below with reference to the embodiments with reference to the attached drawings.
Example 1
As shown in fig. 1, the present embodiment provides a SPD mode-based medical consumable multi-level repository management system, including:
a server 10 having a plurality of first users; the server 10 is provided with a primary standby database and a primary in-hospital database corresponding to each first user; the server 10 is also provided with an SPD central library; the primary standby database is used for storing consumable information in the primary standby warehouse of the first user; the primary hospital database is used for storing consumable information in the primary hospital warehouse of the first user; the SPD central library is used for storing consumable information in the central consumable warehouse;
a plurality of first terminals 20 held by a first user, the first terminals having an SPD system installed thereon; the first terminal 20 is configured to issue a purchase order through the SPD system, where the purchase order includes active purchase consumable information and standby purchase consumable information;
the server 10 is used for extracting the information of the current purchasing consumables contained in the primary standby database and generating a stock moving consumable list; extracting the information of the current purchasing consumables contained in the SPD central library and the information of the standby purchasing consumables not contained in the primary standby database to generate a list of consumables to be purchased;
the first terminal 20 sends a warehouse moving application and a purchasing warehouse entering application to the server through the SPD system; the warehouse moving application comprises source warehouse information and target warehouse information with different warehouse information, and also comprises a warehouse moving consumable list; the source warehouse information and the target warehouse information comprise first-level standby warehouse information and first-level in-hospital warehouse information; the purchase warehousing application comprises the list of consumable parts to be purchased;
the server 10 is configured to receive the library transfer application, delete the consumable information in the library transfer consumable list from the database corresponding to the source warehouse information, and add the consumable information in the library transfer consumable list from the database corresponding to the target warehouse information;
and the server 10 is used for receiving the purchase warehousing application, deleting the consumable information in the consumable list to be purchased from the database corresponding to the central consumable warehouse, and correspondingly storing the consumable information in the consumable list to be purchased into a primary yard database or a primary standby database.
Correspondingly storing the consumable information in the consumable list to be purchased into a primary hospital database or a primary standby database, comprising:
when the consumable information in the consumable list to be purchased is judged to be the current consumable information to be purchased, storing the consumable information in the consumable list to be purchased in the primary hospital database;
and when the consumable information in the consumable list to be purchased is judged to be standby consumable information to be purchased, storing the consumable information in the consumable list to be purchased in the primary standby database.
The first user corresponds to a storehouse of each hospital, each hospital is provided with a total storehouse, the total storehouse of each hospital is provided with a management user, and the management user has the authority to send out a consumable purchase order of the hospital; for example, the warehouse management system in this embodiment corresponds to a plurality of hospitals such as hospital a, hospital b, and hospital c, where a primary standby database of hospital a is shown in table 1 below, a primary in-hospital database is shown in table 2 below, and an SPD central database of the service end is shown in table 3 below:
for example, a purchase order issued by a warehouse administrator of hospital a is shown in table 4 below, in which the consumable information of serial numbers 1 and 3 in table 4 is standby purchase consumable information, and the consumable information of serial numbers 2 and 4 in table 4 is active purchase consumable information:
since serial number 2 is included in the primary standby database in the current procurement consumable part information in table 4, the list of stock-moving consumable parts is generated as shown in table 5 below:
since the consumable spare library of serial number 1 in table 4 already has 50, which exceeds the purchase amount by 10 boxes, the consumable spare library does not need to be purchased; the consumable spare library of serial number 3 has 10 boxes, and the purchase amount is not enough for 50, so that the differential amount is purchased for 40 boxes at this time; the consumable items of serial number 4 exceed the purchase amount 110 because the spare library has 500, so the consumable items do not need to be purchased at this time; the consumable item of serial number 5 needs to be purchased this time because the spare library does not exist. The list of purchasable consumables generated according to table 4 is therefore as shown in table 6 below:
when the consumables in the tables 5 and 6 reach the designated warehouse, the consumables in the tables 5 are delivered to the first-level hospital warehouse; the consumables with serial number 1 in the table 6 are delivered to the first-level standby warehouse, and the consumables with serial number 2 in the table 6 are delivered to the first-level hospital warehouse; namely, the current purchasing consumables are delivered to the primary warehouse, and the standby purchasing consumables are delivered to the primary standby warehouse; after the first-level warehouse and the first-level standby warehouse receive the goods, the first user sends out a warehouse moving application and a purchasing and warehousing application.
The library transfer application is shown in table 7 below, and includes a list of library transfer consumables in table 5:
after receiving the database transfer application and the purchase and storage application, the server side updates the primary standby database as shown in the following table 8, updates the primary in-hospital database as shown in the following table 9, and updates the SPD center database as shown in the following table 10:
therefore, in the embodiment, according to the emergency use degree of the consumable parts, the first user divides the purchasing consumable parts into the current purchasing consumable part information and the standby purchasing consumable part information, so that the three-level layer-by-layer translation storage management of the medical consumable parts from the SPD central library, the primary standby database and the primary hospital database is realized, and the storage occupation of the consumable parts in the hospital is reduced.
Wherein, in this embodiment, still include:
a plurality of second terminals 30 held by a second user, the second terminals 30 having an SPD system installed thereon; the server 10 is provided with a secondary hospital database corresponding to each second user, and is used for storing consumable information in the secondary hospital database of the second user;
the second user corresponds to a department warehouse manager in each hospital, each hospital is correspondingly provided with a plurality of second users, and each second user corresponds to each department; taking department one of hospital a as an example, the corresponding secondary in-hospital database is shown in table 11 below:
the second terminal 30 is used for issuing a purchase requisition; the procurement order comprises procurement consumable information; the order for a subscription is shown in Table 12 below, for example:
the first terminal 20 is configured to receive the procurement order;
the first terminal 20 is further configured to send a delivery order generation request, where the delivery order generation request includes the purchase-applying consumable information; that is, consumable part information in serial numbers 1 and 2 in table 12 described above.
The server 10 is configured to receive a request for generating an outbound order, and when determining that the first-level in-hospital database contains the procurement consumable information, that is, table 9 contains the consumable information in the serial numbers 1 and 2 in table 12, generate an outbound order, and a corresponding warehousing order and a warehousing confirmation request, where the warehousing order and the outbound order both contain the procurement consumable information; the warehousing entry is shown in the following table 13, and the ex-warehouse entry is shown in the following table 14:
the first terminal 20 is used for receiving the delivery order;
the second terminal 30 is configured to receive the warehousing entry and the warehousing confirmation request, and feed back warehousing confirmation information;
after receiving the warehousing confirmation information, the server 10 deletes the consumable information corresponding to the delivery order from the primary in-hospital database, and adds the consumable information corresponding to the warehousing order from the secondary in-hospital database.
Therefore, in this embodiment, the primary hospital database is updated on the basis of table 9 as shown in table 15 below, and the secondary hospital database is updated on the basis of table 11 as shown in table 16 below:
in this embodiment, the server is further provided with a consumable usage database corresponding to each second user; the consumable material use database stores use consumable material data; the usage consumable data includes usage consumable information, usage time information, and usage user information;
the consumable usage database established for department one of hospital a is shown in table 17 below:
the second terminal is configured to send a consumable use request to the server; for example, a department one warehouse manager of hospital A initiates a consumable use request after being received by department personnel. The consumable use request comprises the use consumable information obtained by scanning the code; the usage amount information is obtained through accumulated calculation according to the recorded usage time information and the usage user information; the consumable use request is shown, for example, in table 18 below:
the server is configured to receive the consumable use request, delete the data corresponding to the consumable use information from the secondary hospital database, and add the consumable use data corresponding to the consumable use information from the consumable use database.
Therefore, the secondary hospital database updated technically in table 16 is shown in table 19 below, and the consumable use database updated on the basis of table 17 is shown in table 20 below.
Example 2
Corresponding to embodiment 1, this embodiment provides a management method for a SPD mode-based medical consumable multi-level repository management system according to embodiment 1, including the following steps: the default subject of the following steps is the server 10:
s01, receiving a purchase order sent by a first terminal through an SPD system, wherein the purchase order comprises current purchase consumable material information and standby purchase consumable material information;
s02, extracting the information of the current purchase consumables contained in the primary standby database to generate a stock moving consumable list;
s03, extracting the information of the current purchasing consumables contained in the SPD central library and the information of the standby purchasing consumables not contained in the primary standby database to generate a consumable list to be purchased;
s04, receiving a database transfer application sent by the first terminal through the SPD system, wherein the database transfer application comprises source warehouse information and target warehouse information with different warehouse information, and further comprises a mobile consumable list; the source warehouse information and the target warehouse information comprise first-level standby warehouse information and first-level in-hospital warehouse information;
s05, deleting corresponding consumable information in the mobile consumable list from a database corresponding to the source warehouse information;
s06, adding corresponding consumable information in the mobile consumable list from a database corresponding to the target warehouse information;
s07, receiving a purchase warehousing application sent by the first terminal through the SPD system;
s08, deleting the consumable information in the consumable list to be purchased from the database corresponding to the central consumable warehouse;
s09, correspondingly storing the consumable information in the consumable list to be purchased into a primary yard database or a primary standby database, including:
s09-1, when the consumable information in the consumable list to be purchased is judged to be the current consumable information to be purchased, storing the consumable information in the consumable list to be purchased into the primary hospital database;
and S09-2, when the consumable information in the consumable list to be purchased is judged to be standby consumable information, storing the consumable information in the consumable list to be purchased into the primary standby database.
Corresponding to embodiment 1, this embodiment further includes the following steps:
s10, receiving a delivery order generation request, wherein the delivery order generation request is sent out after a first terminal receives a procurement order sent by a second terminal, and the procurement order comprises procurement consumable material information;
s11, when the first-level in-hospital database contains the procurement consumable information, generating an ex-warehouse bill, a corresponding warehousing bill and a warehousing confirmation request, wherein the warehousing bill and the ex-warehouse bill both contain the procurement consumable information;
s12, sending the delivery list to the first terminal;
s13, sending the warehousing entry and the warehousing confirmation request to the second terminal;
and S14, receiving warehousing confirmation information fed back by the second terminal, deleting the consumable information corresponding to the warehouse-out bill from the primary in-hospital database, and adding the consumable information corresponding to the warehouse-in bill from the secondary in-hospital database.
Further comprising the steps of:
s15, receiving a consumable use request sent by the second terminal;
s16, deleting data corresponding to consumable information from a secondary hospital database;
s17, adding the use consumable data corresponding to the use consumable information from the consumable use database; the consumable usage database is set corresponding to each second user; the usage consumable data includes usage consumable information, usage time information, and usage user information.
Preferably, the method further comprises the following steps:
s18, when the consumable information in the consumable list to be purchased is judged to be the current consumable information to be purchased, storing the consumable information in the consumable list to be purchased into the primary hospital database;
and S19, when the consumable information in the consumable list to be purchased is judged to be standby consumable information to be purchased, storing the consumable information in the consumable list to be purchased into the primary standby database.
Preferably, as shown in table 21 below, the first-level hospital database further stores stock quantity information, stock lower limit information, and stock upper limit information corresponding to the consumable material information in the first-level hospital warehouse;
the method further comprises the steps of:
s18, sending stock reminding information to the first terminal when judging that the stock information is smaller than the stock lower limit information; for example, the server determines that the storage amount of the consumable item with serial number 2 in the table 21, that is, "inventory amount" is less than the lower inventory limit 2000, so that the stock preparation reminding information is sent out and displayed on the first terminal in a pop-up window;
and S19, sending stock excess reminding information to the first terminal when judging that the stock quantity information is larger than the stock upper limit information. For example, the server determines that the storage amount of the consumable item of serial number 3 in the table 21, i.e., "inventory amount", is greater than the upper inventory limit 40, so that a spare excess reminding message is sent and displayed on the first terminal in a pop-up window.
Preferably, as shown in table 22 below, the first-level hospital database further stores expiration date information corresponding to the consumable information in the first-level hospital database; the method further comprises the following steps:
and sending out the temporary reminding information when the interval time between the validity period and the current date is judged to be less than the set value. For example, if the current date is 2021, 12 and 05 days, and the setting value is 7 days, the consumable item with serial number 2 in the table 22 will be due, and the server sends out a due reminder and displays it on the first terminal in a pop-up manner.
The above description is only a preferred embodiment of the application and is illustrative of the principles of the technology employed. It will be appreciated by a person skilled in the art that the scope of the invention as referred to in the present application is not limited to the embodiments with a specific combination of the above-mentioned features, but also covers other embodiments with any combination of the above-mentioned features or their equivalents without departing from the inventive concept. For example, the above features may be replaced with (but not limited to) features having similar functions disclosed in the present application.
Claims (10)
1. A SPD mode-based medical consumable multi-level storehouse management system is characterized by comprising:
the server side is provided with a plurality of first users; the server is provided with a primary standby database and a primary in-hospital database corresponding to each first user; the server is also provided with an SPD center library; the primary standby database is used for storing consumable information in the primary standby warehouse of the first user; the primary hospital database is used for storing consumable information in the primary hospital warehouse of the first user; the SPD central library is used for storing consumable information in the central consumable warehouse;
the system comprises a plurality of first terminals and a plurality of second terminals, wherein the first terminals are held by a first user, and the SPD system is installed on the first terminals; the first terminal is used for sending out a purchase order through the SPD system, and the purchase order comprises current purchase consumable information and standby purchase consumable information;
the server is used for extracting the information of the current purchasing consumables contained in the primary standby database and generating a moving consumable list; extracting the information of the current purchasing consumables contained in the SPD central library and the information of the standby purchasing consumables not contained in the primary standby database to generate a list of consumables to be purchased;
the first terminal sends a warehouse moving application and a purchasing warehouse entering application to the server through the SPD system; the warehouse moving application comprises source warehouse information and target warehouse information with different warehouse information, and also comprises a warehouse moving consumable list; the source warehouse information and the target warehouse information comprise first-level standby warehouse information and first-level in-hospital warehouse information; the purchase warehousing application comprises the list of consumable parts to be purchased;
the server is used for receiving the warehouse moving application, deleting the consumable material information in the warehouse moving consumable material list from the database corresponding to the source warehouse information, and adding the consumable material information in the warehouse moving consumable material list from the database corresponding to the target warehouse information;
and the server is used for receiving the purchase warehousing application, deleting the consumable information in the consumable list to be purchased from the database corresponding to the central consumable warehouse, and correspondingly storing the consumable information in the consumable list to be purchased into a primary yard database or a primary standby database.
2. The SPD mode-based medical consumable multilevel repository management system of claim 1, further comprising:
the plurality of second terminals are held by a second user, and the SPD system is installed on the second terminals; the server is provided with a secondary hospital database corresponding to each second user and used for storing consumable material information in the secondary hospital database of the second user;
the second terminal is used for sending out a purchase requisition; the procurement order comprises procurement consumable information;
the first terminal is configured to receive the procurement order;
the first terminal is also configured to send out a delivery order generation request, and the delivery order generation request comprises the purchase requisition consumable information;
the server is configured to receive a warehouse-out bill generation request, generate a warehouse-out bill and a corresponding warehouse-in bill and warehouse-in confirmation request when the warehouse-out bill generation request is judged to contain the procurement consumable material information in the primary hospital database, wherein the warehouse-in bill and the warehouse-out bill both contain the procurement consumable material information;
the first terminal is used for receiving the delivery order;
the second terminal is used for receiving the warehousing order and the warehousing confirmation request and feeding back warehousing confirmation information;
and after receiving the warehousing confirmation information, the server deletes the consumable information corresponding to the warehouse-out bill from the primary in-hospital database, and adds the consumable information corresponding to the warehouse-in bill from the secondary in-hospital database.
3. The SPD mode-based medical consumable multi-level warehouse management system of claim 2,
the server is also provided with a consumable material use database corresponding to each second user; the consumable material use database stores use consumable material data; the usage consumable data includes usage consumable information, usage time information, and usage user information;
the second terminal is configured to send a consumable use request to the server;
the server is configured to receive the consumable use request, delete the data corresponding to the consumable use information from the secondary hospital database, and add the consumable use data corresponding to the consumable use information from the consumable use database.
4. The SPD mode-based medical consumable multi-level warehouse management system of claim 2, wherein the server is further configured to:
when the consumable information in the consumable list to be purchased is judged to be the current consumable information to be purchased, storing the consumable information in the consumable list to be purchased in the primary hospital database;
and when the consumable information in the consumable list to be purchased is judged to be standby consumable information to be purchased, storing the consumable information in the consumable list to be purchased in the primary standby database.
5. A SPD mode-based medical consumable multilevel storehouse management method is applied to the SPD mode-based medical consumable multilevel storehouse management system of any one of claims 1 to 4, and comprises the following steps:
receiving a purchase order sent by a first terminal through an SPD system, wherein the purchase order comprises current purchase consumable information and standby purchase consumable information;
extracting the information of the current purchasing consumables contained in the primary standby database to generate a moving stock consumable list;
extracting the information of the current purchasing consumables contained in the SPD central library and the information of the standby purchasing consumables not contained in the primary standby database to generate a list of consumables to be purchased;
receiving a database transfer application sent by the first terminal through the SPD system, wherein the database transfer application comprises source warehouse information and target warehouse information with different warehouse information, and also comprises a mobile consumable list; the source warehouse information and the target warehouse information comprise first-level standby warehouse information and first-level in-hospital warehouse information;
deleting corresponding consumable information in the mobile consumable list from a database corresponding to the source warehouse information;
adding corresponding consumable information in the mobile consumable list from a database corresponding to the target warehouse information;
receiving a purchase warehousing application sent by the first terminal through the SPD system;
deleting the consumable information in the consumable list to be purchased from a database corresponding to the central consumable warehouse;
and correspondingly storing the consumable information in the consumable list to be purchased into a primary hospital database or a primary standby database.
6. The SPD mode-based medical consumable multilevel warehouse management method according to claim 5, characterized by comprising the following steps:
receiving a delivery order generation request, wherein the delivery order generation request is sent by a first terminal after receiving a procurement order sent by a second terminal, and the procurement order comprises procurement consumable material information;
when the first-level in-hospital database contains the procurement consumable information, generating an ex-warehouse bill and a corresponding in-warehouse bill and an in-warehouse confirmation request, wherein the in-warehouse bill and the ex-warehouse bill both contain the procurement consumable information;
sending the delivery list to the first terminal;
sending the warehousing bill and the warehousing confirmation request to the second terminal;
and receiving warehousing confirmation information fed back by the second terminal, deleting the consumable material information corresponding to the warehouse-out bill from the primary in-hospital database, and adding the consumable material information corresponding to the warehouse-in bill from the secondary in-hospital database.
7. The SPD mode-based medical consumable multilevel warehouse management method according to claim 6, further comprising the steps of:
receiving a consumable use request sent by a second terminal;
deleting data corresponding to the consumable information from the secondary hospital database;
adding the use consumable data corresponding to the use consumable information from the consumable use database; the consumable usage database is set corresponding to each second user; the usage consumable data includes usage consumable information, usage time information, and usage user information.
8. The SPD mode-based medical consumable multilevel warehouse management method according to claim 7, wherein the correspondingly storing consumable information in the consumable list to be purchased into a primary hospital database or a primary standby database comprises:
when the consumable information in the consumable list to be purchased is judged to be the current consumable information to be purchased, storing the consumable information in the consumable list to be purchased in the primary hospital database;
and when the consumable information in the consumable list to be purchased is judged to be standby consumable information to be purchased, storing the consumable information in the consumable list to be purchased in the primary standby database.
9. The SPD mode-based medical consumable multilevel warehouse management method according to claim 6, wherein the first-level hospital database further stores stock information, stock lower limit information and stock upper limit information corresponding to consumable information in the first-level hospital warehouse; the method further comprises the steps of:
when judging that the inventory information is smaller than the inventory lower limit information, sending stock preparation reminding information to the first terminal;
and sending stock excess reminding information to the first terminal when judging that the stock information is larger than the stock upper limit information.
10. The SPD mode-based medical consumable multi-level storehouse management method according to claim 6, wherein validity period information is stored in the first-level hospital database corresponding to consumable information in the first-level hospital warehouse; the method further comprises the following steps:
and sending out the temporary reminding information when the interval time between the validity period and the current date is judged to be less than the set value.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111260375.8A CN113707288B (en) | 2021-10-28 | 2021-10-28 | SPD mode-based medical consumable multi-level storehouse management system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111260375.8A CN113707288B (en) | 2021-10-28 | 2021-10-28 | SPD mode-based medical consumable multi-level storehouse management system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113707288A true CN113707288A (en) | 2021-11-26 |
| CN113707288B CN113707288B (en) | 2022-02-22 |
Family
ID=78647285
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111260375.8A Active CN113707288B (en) | 2021-10-28 | 2021-10-28 | SPD mode-based medical consumable multi-level storehouse management system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113707288B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116187912A (en) * | 2023-04-27 | 2023-05-30 | 天津医药集团众健康达医疗器械有限公司 | Medical consumable material warehouse-in and warehouse-out method, system, terminal equipment and medium |
Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050075954A1 (en) * | 2003-10-03 | 2005-04-07 | Kazuhiko Matsumoto | Inventory management and ordering system, and ordering management system using the previous system |
| CN102521721A (en) * | 2011-11-28 | 2012-06-27 | 安徽省电力公司滁州供电公司 | Management system for spare parts of transformer substation |
| CN103559594A (en) * | 2013-11-26 | 2014-02-05 | 武钢集团昆明钢铁股份有限公司 | Management system and method for having control over procurement plan according to inventory level of spare parts |
| CN104573968A (en) * | 2015-01-20 | 2015-04-29 | 石丹杰 | Consumable item management system |
| CN106327114A (en) * | 2015-06-25 | 2017-01-11 | 阿里巴巴集团控股有限公司 | Warehouse resource information processing method and device, and method and device for providing inventory information |
| CN106407692A (en) * | 2016-09-28 | 2017-02-15 | 合肥工业大学 | Method for determining actual purchase quantity and optimum storage amount of medical consumable based on big data |
| CN106447257A (en) * | 2016-09-12 | 2017-02-22 | 北海和思科技有限公司 | Multifunctional warehouse management system |
| US20170068788A1 (en) * | 2015-09-04 | 2017-03-09 | Materials Management Microsystems, Inc. | Systems and Methods for Tracking Surgical Inventory and Sterilization |
| CN108921469A (en) * | 2018-06-22 | 2018-11-30 | 深圳倍佳医疗科技服务有限公司 | Medical treatment consumptive materials supplies management method, mobile terminal and computer readable storage medium |
| CN109255569A (en) * | 2018-08-24 | 2019-01-22 | 北京极智嘉科技有限公司 | Tally method, apparatus, server and storage medium in library |
| CN109784800A (en) * | 2018-06-01 | 2019-05-21 | 太仓市第一人民医院 | Low-cost medical consumables three-level treasury management system and its working method under SPD mode |
| CN110718287A (en) * | 2019-08-27 | 2020-01-21 | 福建亿能达信息技术股份有限公司 | High-value consumable tracing management method and system based on SPD mode |
| CN110729036A (en) * | 2019-09-18 | 2020-01-24 | 医修技术服务(北京)有限公司 | Medical consumable management method and device, computer equipment and storage medium |
| CN110957023A (en) * | 2019-09-26 | 2020-04-03 | 福建亿能达信息技术股份有限公司 | Hospital logistics supply ecological chain management system based on zero-inventory concept |
| CN111415733A (en) * | 2020-03-26 | 2020-07-14 | 武汉博科国泰信息技术有限公司 | Medical treatment consumptive material wisdom logistics system |
| CN113409929A (en) * | 2021-06-30 | 2021-09-17 | 重庆博尔德医疗科技股份有限公司 | Medical consumable data management platform |
-
2021
- 2021-10-28 CN CN202111260375.8A patent/CN113707288B/en active Active
Patent Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050075954A1 (en) * | 2003-10-03 | 2005-04-07 | Kazuhiko Matsumoto | Inventory management and ordering system, and ordering management system using the previous system |
| CN102521721A (en) * | 2011-11-28 | 2012-06-27 | 安徽省电力公司滁州供电公司 | Management system for spare parts of transformer substation |
| CN103559594A (en) * | 2013-11-26 | 2014-02-05 | 武钢集团昆明钢铁股份有限公司 | Management system and method for having control over procurement plan according to inventory level of spare parts |
| CN104573968A (en) * | 2015-01-20 | 2015-04-29 | 石丹杰 | Consumable item management system |
| CN106327114A (en) * | 2015-06-25 | 2017-01-11 | 阿里巴巴集团控股有限公司 | Warehouse resource information processing method and device, and method and device for providing inventory information |
| US20170068788A1 (en) * | 2015-09-04 | 2017-03-09 | Materials Management Microsystems, Inc. | Systems and Methods for Tracking Surgical Inventory and Sterilization |
| CN106447257A (en) * | 2016-09-12 | 2017-02-22 | 北海和思科技有限公司 | Multifunctional warehouse management system |
| CN106407692A (en) * | 2016-09-28 | 2017-02-15 | 合肥工业大学 | Method for determining actual purchase quantity and optimum storage amount of medical consumable based on big data |
| CN109784800A (en) * | 2018-06-01 | 2019-05-21 | 太仓市第一人民医院 | Low-cost medical consumables three-level treasury management system and its working method under SPD mode |
| CN108921469A (en) * | 2018-06-22 | 2018-11-30 | 深圳倍佳医疗科技服务有限公司 | Medical treatment consumptive materials supplies management method, mobile terminal and computer readable storage medium |
| CN109255569A (en) * | 2018-08-24 | 2019-01-22 | 北京极智嘉科技有限公司 | Tally method, apparatus, server and storage medium in library |
| CN110718287A (en) * | 2019-08-27 | 2020-01-21 | 福建亿能达信息技术股份有限公司 | High-value consumable tracing management method and system based on SPD mode |
| CN110729036A (en) * | 2019-09-18 | 2020-01-24 | 医修技术服务(北京)有限公司 | Medical consumable management method and device, computer equipment and storage medium |
| CN110957023A (en) * | 2019-09-26 | 2020-04-03 | 福建亿能达信息技术股份有限公司 | Hospital logistics supply ecological chain management system based on zero-inventory concept |
| CN111415733A (en) * | 2020-03-26 | 2020-07-14 | 武汉博科国泰信息技术有限公司 | Medical treatment consumptive material wisdom logistics system |
| CN113409929A (en) * | 2021-06-30 | 2021-09-17 | 重庆博尔德医疗科技股份有限公司 | Medical consumable data management platform |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116187912A (en) * | 2023-04-27 | 2023-05-30 | 天津医药集团众健康达医疗器械有限公司 | Medical consumable material warehouse-in and warehouse-out method, system, terminal equipment and medium |
| CN116187912B (en) * | 2023-04-27 | 2023-08-22 | 天津医药集团众健康达医疗器械有限公司 | Medical consumable material warehouse-in and warehouse-out method, system, terminal equipment and medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113707288B (en) | 2022-02-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6651063B1 (en) | Data organization and management system and method | |
| US20030088442A1 (en) | Inventory management system and method | |
| US20120259655A1 (en) | Drug Inventory System | |
| CN112001681B (en) | Warehouse management method, device, platform and computer readable storage medium | |
| US20140236609A1 (en) | Pharmacy tracking system with automatically-entered customer transaction information | |
| US20110246219A1 (en) | System and Method of Integrated Logistics Management for Inventory | |
| US11880898B2 (en) | Order receiving management device, order receiving management system, order receiving management method, and program | |
| US20080065418A1 (en) | Systems and Methods to Manage Drug Accountability Processes in Clinical Trials | |
| MXPA02008814A (en) | Inventory control system and methods. | |
| CN113707288B (en) | SPD mode-based medical consumable multi-level storehouse management system and method | |
| US7761325B2 (en) | Intelligent inventory applications and services | |
| CN111415733A (en) | Medical treatment consumptive material wisdom logistics system | |
| CN114420240A (en) | Prescription management system based on artificial intelligence, big data and block chain | |
| US10726099B2 (en) | System and method for providing real time control of pharmaceuticals | |
| EP1403803A2 (en) | Method and system for the management of end user subscriptions | |
| CN113689940B (en) | Medical consumable integrated purchasing system and method based on SPD system | |
| JP2005234911A (en) | Locker delivery system | |
| JP6994196B2 (en) | Drug traceability system | |
| US20180158549A1 (en) | Surgical tray coordination system and method | |
| WO2020236563A1 (en) | Autonomous rfid storage system | |
| US20190325383A1 (en) | System and Method of Providing a Secure Parcel Service | |
| JP4394886B2 (en) | Information distribution system and information distribution method | |
| US20170147785A1 (en) | Systems and methods for tracking inventory and distribution of medications in a healthcare facility | |
| Ken et al. | Pharmacy Warehouse Management System | |
| Mao et al. | Device Management |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |