CN112307036A - Method for inputting medicine information record into medicine database - Google Patents
Method for inputting medicine information record into medicine database Download PDFInfo
- Publication number
- CN112307036A CN112307036A CN202011524617.5A CN202011524617A CN112307036A CN 112307036 A CN112307036 A CN 112307036A CN 202011524617 A CN202011524617 A CN 202011524617A CN 112307036 A CN112307036 A CN 112307036A
- Authority
- CN
- China
- Prior art keywords
- drug
- data
- information
- field
- record
- 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
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The embodiment of the invention relates to a method for inputting a medicine information record into a medicine database, which comprises the following steps: acquiring a first medicine information record; acquiring a plurality of key field name data from a key field name data set; according to the name data of each key field, inquiring and processing the content data of the corresponding field of the first medicine information record to generate the content data of the corresponding key field; according to all the key field name data and the corresponding key field content data, drug information record matching query processing is carried out on a drug database, and first record index data are generated; when the first record index data is empty, newly adding records in the medicine database; and when the first record index data is not empty, updating the inventory of the medicine database. The embodiment of the invention can adapt to different drug batch management principles of different customers by simply configuring the key field name data set, thereby reducing the maintenance cost of the database and improving the flexibility of system application.
Description
Technical Field
The invention relates to the technical field of data information processing, in particular to a method for inputting medicine information records into a medicine database.
Background
When a new medicine information record is input into the medicine database, the old medicine information record in the database is firstly inquired in batches according to the medicine batch management principle, and when no record in the same batch with the new medicine information record exists in the database, the new medicine information record is used for carrying out record adding operation on the medicine database; and when the same batch of records exist in the library, the quantity in the new medicine information records is used for carrying out incremental updating on the quantity in the medicine information records in the library. Here, the principle of managing the drug batch is a key field comparison principle for defining whether the new and old drug information records are in the same batch. Some hospitals are simple in management, the key field comparison principle is simple, and only five pieces of basic information, namely a drug warehouse code, a drug basic specification, drug packaging specification information and a drug manufacturer, are compared; some hospitals have careful management and complex key field comparison principles, not only need to compare five basic information of drug warehouse codes, drug codes, basic specifications of drugs, drug packaging specification information and drug manufacturers, but also can compare information of drug purchase prices, drug wholesale prices, drug retail prices, drug lot numbers, drug validity periods, drug supply units and the like, and even key fields used for comparison at different periods can be different. Such a practical problem may cause that even though each hospital uses the same medical system and the same database, batch management principle processing procedures of different versions are correspondingly generated, and corresponding system maintenance costs are also increased.
Disclosure of Invention
The object of the present invention is to provide a method, a computer program product and a computer readable storage medium for inputting drug information records in a drug database, which use a key field name data set to configure data for key field names; performing field matching comparison according to the keyword field name data; when the matching record is not found, the system generates a new medicine batch number, and then adds the new medicine information record with the new medicine batch number into the medicine database; when the matching record is found, the batch number of the medicines recorded in the library is not modified, and the quantity in the record in the library is only subjected to incremental processing by using the quantity of the medicines in the new medicine information record. Therefore, management requirements of different customers can be met only by simply configuring the key field name data set, maintenance cost of the database can be reduced, and flexibility of system application can be improved.
In order to achieve the above object, a first aspect of embodiments of the present invention provides a method for entering a drug information record in a drug database, where the method includes:
acquiring a first medicine information record; the first drug information record comprises a plurality of first field data sets; the first field data group comprises first field name data and first field content data; the first field name data at least comprises medicine batch information and medicine quantity information;
acquiring a plurality of key field name data from a preset key field name data set;
according to each key field name data, performing corresponding field content data query processing on the first medicine information record to generate corresponding key field content data;
according to all the key field name data and the corresponding key field content data, drug information record matching query processing is carried out on a preset drug database, and first record index data are generated; the drug database comprises a plurality of second drug information records; the second drug information record comprises a plurality of second field data sets; the second field data group comprises second field name data and second field content data; the second field name data at least comprises the medicine batch information and the medicine quantity information;
when the first record index data is empty, performing batch generation processing of newly added medicines to generate first medicine batch data; taking the first field name data in the first medicine information record as the first field data group of the medicine batch information as a first current field data group; updating the first field content data of the first current field data set by using the first medicine batch data; performing record processing on newly added second medicine information on the medicine database to generate a newly added second medicine information record; using the updated first medicine information record, and carrying out field content input processing on the newly added second medicine information record according to the field name corresponding relation between the first medicine information record field data group and the second medicine information record field data group;
when the first record index data is not empty, recording the second medicine information corresponding to the first record index data in the medicine database as a current record; taking the second field name data in the current record as the second field data group of the medicine quantity information as a second current field data group; extracting the second field content data of the second current field data group to generate first medicine quantity data; taking the first field name data in the first medicine information record as the first field data group of the medicine quantity information as a third current field data group; extracting the first field content data of the third current field data group to generate second medicine quantity data; generating third medicine quantity data according to the sum of the first medicine quantity data and the second medicine quantity data; and performing field content updating processing on the second field content data of the second current field data group currently recorded in the drug database by using the third drug quantity data.
Preferably, the querying and processing the content data of the corresponding field of the first medicine information record according to the name data of each key field to generate the content data of the corresponding key field specifically includes:
extracting the first field data group corresponding to the first field name data which is the same as each key field name data from the first medicine information record to generate a first key field data group; and then extracting the first field content data of the first key field data group as the key field content data corresponding to each key field name data.
Preferably, the performing, according to all the key field name data and the corresponding key field content data, a matching query process on a preset drug database for drug information records to generate first record index data specifically includes:
polling all the second medicine information records in the medicine database, and taking the currently polled second medicine information records as current medicine information records;
in the current medicine information record, performing key field matching processing according to each key field name data and the corresponding key field content data to generate first matching state data corresponding to each key field name data;
and when all the first matching state data are successfully matched, recording index position information of the current medicine information in the medicine database as the first recording index data.
Further, in the current drug information record, according to each key field name data and the corresponding key field content data, performing key field matching processing to generate first matching state data corresponding to each key field name data, specifically including:
extracting the second field data group corresponding to the second field name data which is the same as each key field name data from the current medicine information record to generate a corresponding second key field data group; extracting the second field content data of the second key field data group to generate corresponding matching key field content data; and when the key field content data corresponding to each key field name data is the same as the corresponding matching key field content data, setting the first matching state data corresponding to each key field name data as successful matching.
Preferably, the field content entry processing is performed on the newly added second medicine information record according to the field name correspondence between the first medicine information record field data group and the second medicine information record field data group by using the updated first medicine information record, and specifically includes:
sequentially extracting the first field data group from the updated first medicine information record to generate a source field data group; in the newly added second medicine information record, using the second field data group with the second field name data being the same as the first field name data of the source field data group as a target field data group; and recording the first field content data of the source field data set into the target field data set as the second field content data of the target field data set.
Preferably, the first field name data and the second field name data each include drug library code information, drug basic specification information, drug packaging specification information, drug manufacturer information, drug batch information, drug purchase price information, drug wholesale price information, drug retail price information, drug batch number information, drug expiration date information, drug quantity information, and drug supply unit information;
the key field name data comprises the drug warehouse code information, the drug basic specification information, the drug packaging specification information, the drug manufacturer information, the drug purchase price information, the drug wholesale price information, the drug retail price information, the drug wholesale number information, the drug expiration date information and the drug delivery unit information.
Preferably, in the first medicine information record, the first field name data is that the first field content data of the first field data group of the medicine batch information is null.
Preferably, the plurality of key field name data at least include the drug library code information, the drug code information, the basic specification information of the drug, the package specification information of the drug, and the drug manufacturer information.
A second aspect of embodiments of the present invention provides a computer program product, which includes computer program code, when executed by a computer, causes the computer to perform the method of the first aspect.
A third aspect of embodiments of the present invention provides a computer-readable storage medium storing computer instructions that, when executed by a computer, cause the computer to perform the method of the first aspect.
The embodiment of the invention provides a method for inputting medicine information records into a medicine database, a computer program product and a computer readable storage medium, wherein a keyword field name data set is used for configuring keyword field name data; performing field matching comparison according to the keyword field name data; when the matching record is not found, the system generates a new medicine batch number, and then adds the new medicine information record with the new medicine batch number into the medicine database; when the matching record is found, the batch number of the medicines recorded in the library is not modified, and the quantity in the record in the library is only subjected to incremental processing by using the quantity of the medicines in the new medicine information record. Therefore, management requirements of different customers can be met only by simply configuring the key field name data set, maintenance cost of the database can be reduced, and flexibility of system application can be improved.
Drawings
Fig. 1 is a schematic diagram of a method for entering a drug information record in a drug database according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the present invention will be described in further detail with reference to the accompanying drawings, and it is apparent that the described embodiments are only a part of the embodiments of the present invention, not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
According to the method for inputting the medicine information record into the medicine database, provided by the embodiment of the invention, the data set for the key field name is used for configuring the data for the key field name; when a new medicine information record is input into a medicine database, firstly, field matching comparison is carried out according to key field name data; when the matching record is not found, automatically generating a new medicine batch number, and adding a new medicine information record with the new medicine batch number into the medicine database; when the matching record is found, the batch number of the medicines recorded in the library is not modified, and the quantity in the record in the library is subjected to incremental processing only by using the quantity of the medicines in the new medicine information record; fig. 1 is a schematic view of a method for entering a drug information record in a drug database according to an embodiment of the present invention, as shown in fig. 1, the method mainly includes the following steps:
step 1, acquiring a first medicine information record;
wherein the first medicine information record comprises a plurality of first field data sets; the first field data group includes first field name data and first field content data; the first field name data comprises drug warehouse code information, drug basic specification information, drug packaging specification information, drug manufacturer information, drug batch information, drug purchase price information, drug wholesale price information, drug retail price information, drug batch number information, drug expiration date information, drug quantity information and drug supply unit information;
in the first medicine information record, the first field name data is empty of the first field content data of the first field data group of the medicine batch information.
Here, the first drug information record is a new drug information record entered into the drug database; the new drug information record contains a plurality of drug information fields, i.e. a plurality of first field data sets, each drug information field contains 2 field parameters: the field name is the first field name data, and the field content is the first field content data; in this embodiment, according to the management specification of the pharmaceutical institution for the drug information record, the drug information field of the new drug information record at least includes: a drug warehouse code field, a drug basic specification field, a drug packaging specification field, a drug manufacturer field, a drug batch field, a drug purchase price field, a drug wholesale price field, a drug retail price field, a drug batch number field, a drug validity period field, a drug quantity field and a drug delivery unit field; therefore, the corresponding field name, i.e., the first field name data, should also include: drug depot code information, drug code information, basic drug specification information, drug packaging specification information, drug manufacturer information, drug lot information, drug purchase price information, drug wholesale price information, drug retail price information, drug lot number information, drug expiration date information, drug quantity information, and drug supply unit information.
Here, in the subsequent steps, the same batch of medicine identification is carried out on the new medicine information record and the old medicine information record in the medicine database; if the medicines are in the same batch, only the field content data of the medicine quantity field in the old medicine information record is modified; if the first batch of medicines is not the same, a new medicine batch serial number is automatically generated, and the content data of the first field of the first medicine batch field in the new medicine information record is updated, so that the content data of the first field of the first medicine batch field in the first medicine information record is set to be null by default.
For example, the obtained first drug information record includes 13 drug information fields, that is, 13 first field data sets, as shown in table one, where the first field content data of the first drug batch field of the first drug information record is empty.
Watch 1
the key field name data comprises drug warehouse code information, drug basic specification information, drug packaging specification information, drug manufacturer information, drug purchase price information, drug wholesale price information, drug retail price information, drug batch number information, drug validity period information and drug supply unit information;
the plurality of key field name data at least comprise drug library code information, drug basic specification information, drug packaging specification information and drug manufacturer information.
Here, the keyword field name data set is a data set of keyword field name data configured in advance; each keyword field name data corresponds to a specific first field name data; in addition, in this embodiment, the medicine batch and the medicine quantity are not used as the keywords, so the keyword field name data does not include the medicine batch information and the medicine quantity information; in addition, as described above, the key field comparison principle, whether simple or complex, will use the five basic information of the pharmacy code, the medicine code, the basic specification of the medicine, the packing specification information of the medicine, and the pharmaceutical manufacturer as the key words, so the key field name data set in this embodiment must include the pharmacy code information, the medicine code information, the basic specification information of the medicine, the packing specification information of the medicine, and the pharmaceutical manufacturer information.
For example, the obtained keyword field name data set includes 8 keyword field name data as shown in table two, and the 8 keyword field name data respectively correspond to: drug depot code information, drug code information, basic specification information of drugs, drug packaging specification information, drug manufacturer information, drug purchase price information, drug wholesale price information and drug retail price information; the specific setting of these 8 pieces of information in the reference table is such that the contents of the keyword field name data set are ("library code", "drug code", "basic specification", "packaging specification", "manufacturer", "purchase price", "wholesale price" and "retail price").
| Key field name data index | Specific value of key field name data |
| 1 st key field name data | Storehouse code " |
| 2 nd key field name data | "medicine code" |
| 3 rd key field name data | Basic specification " |
| 4 th key field name data | Packing specification " |
| 5 th key field name data | "manufacturer" |
| 6 th key field name data | Purchase price " |
| 7 th key field name data | Wholesale price " |
| 8 th key field name data | Retail price " |
Watch two
Step 3, according to each key field name data, performing corresponding field content data query processing on the first medicine information record to generate corresponding key field content data;
the method specifically comprises the following steps: extracting a first field data group corresponding to first field name data which is the same as each key field name data from the first medicine information record to generate a first key field data group; and extracting first field content data of the first key field data group as key field content data corresponding to each key field name data.
For example, the obtained first drug information record is shown in table one, and the obtained keyword field name data set is shown in table two, then in the first drug information record, the first field data group corresponding to the 1 st keyword field name data specifically being "library code" should be the drug library code field, and the 1 st keyword field content data generated by extracting the first field content data of the drug library code field should be "01";
in the first medicine information record, a first field data group corresponding to 2 nd key field name data of 'medicine code' should be a medicine code field, and 2 nd key field content data generated by extracting the first field content data of the medicine code field should be '86900676000024';
in the first medicine information record, a first field data group corresponding to 3 rd key field name data of basic specification is a medicine basic specification field, and 3 rd key field content data generated by extracting first field content data of the medicine basic specification field is 0.25 g;
in the first medicine information record, a first field data group corresponding to the 4 th key field name data of the 'packaging specification' is a medicine packaging specification field, and the 4 th key field content data generated by extracting the first field content data of the medicine packaging specification field is '0.25 g × 12 grains';
in the first medicine information record, a first field data group corresponding to 5 th key field name data of a manufacturer is a medicine manufacturer field, and 5 th key field content data generated by extracting the first field content data of the medicine manufacturer field is 'Feiyun pharmaceutical industry';
in the first medicine information record, a first field data group corresponding to 6 th key field name data of a purchase price field is a medicine purchase price field, and 6 th key field content data generated by extracting first field content data of the medicine purchase price field is 20 yuan;
in the first medicine information record, a first field data group corresponding to 7 th key field name data of 'wholesale price' is a medicine wholesale price field, and 7 th key field content data generated by extracting the first field content data of the medicine wholesale price field is '20 yuan';
in the first medicine information record, a first field data group corresponding to 8 th key field name data of 'retail price' is required to be a medicine retail price field, and 8 th key field content data generated by extracting first field content data of the medicine retail price field is required to be '20 yuan';
finally, 8 key field content data corresponding to the 8 key field name data are obtained, as shown in table three;
| keyword field name data and value thereof | Key field content data and values thereof |
| The 1 st key field name data is "warehouse code" | The content data of the 1 st key field is "01" |
| The 2 nd key field name data is "medicine code" | The 2 nd key field content data is "86900676000024" |
| The 3 rd key field name data is "basic Specification" | The content data of the 3 rd key field is "0.25 g" |
| The 4 th key field name data is "packaging Specification" | The content data of the 4 th key field is '0.25 g by 12 grains' |
| The 5 th key field name data is "manufacturer" | The 5 th key field content data is 'Feiyun pharmaceutical industry' |
| The 6 th key field name data is "purchase price" | The content data of the 6 th key field is "20 yuan" |
| The 7 th key field name data is "wholesale price" | The 7 th key field content data is "20 yuan" |
| The 8 th key field name data is "retail price" | The 8 th key field content data is "20 yuan" |
Watch III
wherein the drug database comprises a plurality of second drug information records; the second medicine information record comprises a plurality of second field data groups; the second field data group includes second field name data and second field content data; the second field name data comprises drug warehouse code information, drug basic specification information, drug packaging specification information, drug manufacturer information, drug batch information, drug purchase price information, drug wholesale price information, drug retail price information, drug batch number information, drug expiration date information, drug quantity information and drug supply unit information;
here, the drug database is a preset database or data file for storing drug information records; the drug database comprises a plurality of drug information records, namely second drug information records; in the medicine database of the embodiment of the invention, the medicine batches are unique, and only one medicine information record is provided corresponding to one medicine batch; the field format of the drug information record stored in the drug database is consistent with that of the first drug information record;
the method specifically comprises the following steps: step 41, performing polling processing on all second medicine information records in the medicine database, and taking the currently polled second medicine information record as a current medicine information record;
for example, there are 2 second drug information records in the preset drug database, the content of which is shown in table four, and when polling is performed, and the current polled second drug information record is the 1 st second drug information record, the current drug information record should be the 1 st second drug information record; when the current polled second medicine information record is the 2 nd second medicine information record, the current medicine information record is the 2 nd second medicine information record;
| 1 st second drug | Second | 2 nd drug information record | |
| Storehouse code | 01 | 01 | |
| Medicine code | 86900676000024 | 86900676000024 | |
| Basic specification | 0.25 g | 0.25 g | |
| Packaging specification | 0.25 g of 12 granules | 0.25 g of 12 granules | |
| Manufacturer of the product | Flying cloud pharmaceutical industry | Flying cloud pharmaceutical industry | |
| Batch number | 190729000523 | 190729000588 | |
| Purchase price | 20 Yuan | 25 Yuan | |
| Wholesale price | 20 Yuan | 25 Yuan | |
| Retail price | 20 Yuan | 25 Yuan | |
| Batch number | H20080355 | H20080355 | |
| Period of validity | 20220101 | 20220101 | |
| Number of | 30 boxes | 50 box | |
| Supply unit | Gaoshan pharmaceutical Co Ltd | Gaoshan pharmaceutical Co Ltd |
Watch four
Step 42, in the current medicine information record, performing key field matching processing according to each key field name data and corresponding key field content data to generate first matching state data corresponding to each key field name data;
the method specifically comprises the following steps: extracting a second field data group corresponding to second field name data which is the same as each key field name data from the current medicine information record to generate a corresponding second key field data group; extracting second field content data of a second key field data group to generate corresponding matching key field content data; when the key field content data corresponding to each key field name data is the same as the corresponding matching key field content data, setting the first matching state data corresponding to each key field name data as matching success;
for example, the obtained first medicine information record is shown in table one, the obtained key field name data set is shown in table two, the key field content data corresponding to the key field name data set is shown in table three, and the preset medicine database is shown in table four;
when the current drug information record is the 1 st second drug information record, the 1 st matching key field content data extracted from the current drug information record and corresponding to the 1 st key field name data of the specific library code is 01; the extracted 2 nd matching key field content data corresponding to the 2 nd key field name data specifically being the "medicine code" is "86900676000024"; the extracted 3 rd matching key field content data corresponding to the 3 rd key field name data specifically in the basic specification is 0.25 g; the content data of the 4 th matching key field corresponding to the 4 th key field name data specifically being the packaging specification extracted is 0.25 g 12 grains; the extracted 5 th matching key field content data corresponding to the 5 th key field name data of the manufacturer is 'flying cloud pharmaceutical industry'; the extracted 6 th matching key field content data corresponding to the 6 th key field name data specifically being the "purchase price" is "20 yuan"; the extracted 7 th matching key field content data corresponding to the 7 th key field name data specifically being the 'wholesale price' is '20 yuan'; the extracted 8 th matching key field content data corresponding to the 8 th key field name data specifically being the 'retail price' is '20 yuan'; comparing with a reference table III, wherein the content data of the 1 st matching key field is the same as the content data of the 1 st key field, and setting the 1 st first matching state data as successful matching; the content data of the 2 nd matching key field is the same as the content data of the 2 nd key field, and the 2 nd first matching state data is set as successful matching; the 3 rd matching key field content data is the same as the 3 rd key field content data, and the 3 rd first matching state data is set as matching success; the content data of the 4 th matching key field is the same as the content data of the 4 th key field, and the 4 th first matching state data is set as matching success; the content data of the 5 th matching key field is the same as the content data of the 5 th key field, and the 5 th first matching state data is set as matching success; the content data of the 6 th matching key field is the same as the content data of the 6 th key field, and the 6 th first matching state data is set as matching success; the 7 th matching key field content data is the same as the 7 th key field content data, and the 7 th first matching state data is set as matching success; the 8 th matching key field content data is the same as the 8 th key field content data, and the 8 th first matching state data is set as matching success; finally, 8 pieces of first matching state data which are successfully matched are obtained;
when the current drug information record is the 2 nd second drug information record, the 1 st matching key field content data extracted from the current drug information record and corresponding to the 1 st key field name data of the specific library code is 01; the extracted 2 nd matching key field content data corresponding to the 2 nd key field name data specifically being the "medicine code" is "86900676000024"; the extracted 3 rd matching key field content data corresponding to the 3 rd key field name data specifically in the basic specification is 0.25 g; the content data of the 4 th matching key field corresponding to the 4 th key field name data specifically being the packaging specification extracted is 0.25 g 12 grains; the extracted 5 th matching key field content data corresponding to the 5 th key field name data of the manufacturer is 'flying cloud pharmaceutical industry'; the extracted 6 th matching key field content data corresponding to the 6 th key field name data specifically being the "purchase price" is "25 yuan"; the extracted 7 th matching key field content data corresponding to the 7 th key field name data specifically being the "wholesale price" is "25 yuan"; the extracted 8 th matching key field content data corresponding to the 8 th key field name data specifically being the 'retail price' is '25 yuan'; comparing with a reference table III, wherein the content data of the 1 st matching key field is the same as the content data of the 1 st key field, and setting the 1 st first matching state data as successful matching; the content data of the 2 nd matching key field is the same as the content data of the 2 nd key field, and the 2 nd first matching state data is set as successful matching; the 3 rd matching key field content data is the same as the 3 rd key field content data, and the 3 rd first matching state data is set as matching success; the content data of the 4 th matching key field is the same as the content data of the 4 th key field, and the 4 th first matching state data is set as matching success; the content data of the 5 th matching key field is the same as the content data of the 5 th key field, and the 5 th first matching state data is set as matching success; the content data of the 6 th matching key field is different from the content data of the 6 th key field, and the 6 th first matching state data is set as matching failure; the 7 th matching key field content data is different from the 7 th key field content data, and the 7 th first matching state data is set as matching failure; the 8 th matching key field content data is different from the 8 th key field content data, and the 8 th first matching state data is set as matching failure; finally, 5 pieces of first matching state data which are successfully matched are obtained;
and 43, when all the first matching state data are successfully matched, recording the current medicine information in the record index position information of the medicine database as first record index data.
For example, the obtained first medicine information record is shown in table one, the obtained key field name data set is shown in table two, the key field content data corresponding to the key field name data set is shown in table three, and the preset medicine database is shown in table four;
when the current medicine information record is the 1 st second medicine information record, 8 pieces of first matching state data which are successfully matched are obtained, which indicates that the first medicine information record and the current medicine information record are medicines in the same batch, and the extracted first record index data is 1;
when the current drug information record is the 2 nd second drug information record, 5 of the 8 obtained first matching state data are matching success, and 3 are matching failure, which indicates that the first drug information record and the current drug information record are not the same batch of drugs, and no record index position information extraction processing should be performed, so the first record index data should be null.
here, if the drug database is queried according to the key field name data set in step 4, and a second drug information record in the same batch as the first drug information record is not queried, the first record index data should be null, a new drug batch number should be automatically generated in subsequent steps, and then the new drug information record with the new drug batch number is added to the drug database; if the drug database is inquired according to the key field name data set in the step 4 and a second drug information record in the same batch with the first drug information record is inquired, the index data of the first record is not null, and the quantity in the record in the library is subjected to incremental processing by using the quantity of the drugs in the new drug information record in the subsequent step;
the method specifically comprises the following steps: step 51, when the first record index data is empty, performing batch generation processing of newly added medicines to generate first medicine batch data; taking the first field name data in the first medicine information record as a first field data group of the medicine batch information as a first current field data group; updating the first field content data of the first current field data set by using the first medicine batch data; performing new second medicine information record processing on the medicine database to generate a new second medicine information record; using the updated first medicine information record, and carrying out field content entry processing on the newly added second medicine information record according to the corresponding relation of the field names of the first medicine information record field data group and the second medicine information record field data group;
here, when the first record index data is empty, it indicates that there is no second drug information record in the same batch as the first drug information record in the drug database, and the first drug information record needs to be added to the drug database as a new record; before adding a record, a new batch serial number needs to be generated, and first field content data of a medicine batch field in a first medicine information record is set; the first medicine batch data is the new batch serial number, the new medicine batch generation processing can generate the batch number in a time stamp mode or a random number mode, and the batch number generated in any mode needs to be ensured not to appear in the medicine database; when adding the record, the embodiment of the invention adopts a mode that an empty second medicine information record is newly added in the medicine database, and then the content of the first medicine information record of the first medicine batch data is filled;
the method specifically includes the following steps that by using the updated first medicine information record, according to the field name corresponding relation between the first medicine information record field data group and the second medicine information record field data group, the field content is input and processed for the newly added second medicine information record, and the method specifically includes the following steps: sequentially extracting a first field data set from the updated first medicine information record to generate a source field data set; in the newly added second medicine information record, a second field data group with the second field name data identical to the first field name data of the source field data group is used as a target field data group; inputting the first field content data of the source field data set into the target field data set as the second field content data of the target field data set;
for example, the obtained first medicine information record is shown in table five, the obtained key field name data set is shown in table two, the key field content data corresponding to the key field name data set is shown in table six, and the preset medicine database is shown in table four; because the 'warehouse codes' are not matched, the first medicine information record is regarded as a new batch of medicines, and records are added to the medicine database; performing batch generation processing of newly added medicines before adding, wherein the generated first medicine batch data is '201101000523', and the medicine database after completing recording and adding is shown in table seven;
watch five
| Keyword field name data and value thereof | Key field content data and values thereof |
| The 1 st key field name data is "warehouse code" | The content data of the 1 st key field is "02" |
| The 2 nd key field name data is "medicine code" | The 2 nd key field content data is "86900676000024" |
| The 3 rd key field name data is "basic Specification" | The content data of the 3 rd key field is "0.25 g" |
| The 4 th key field name data is "packaging Specification" | The content data of the 4 th key field is '0.25 g by 12 grains' |
| The 5 th key field name data is "manufacturer" | The 4 th key field content data is 'Feiyun pharmaceutical industry' |
| The 6 th key field name data is "purchase price" | The 5 th key field content data is "20 yuan" |
| The 7 th key field name data is' wholesale price” | The content data of the 6 th key field is "20 yuan" |
| The 8 th key field name data is "retail price" | The 7 th key field content data is "20 yuan" |
Watch six
| 1 st second drug | Second | 2 nd drug information record | 3 rd second drug information record | |
| Storehouse code | 01 | 01 | 02 | |
| Medicine code | 86900676000024 | 86900676000024 | 86900676000024 | |
| Basic specification | 0.25 g | 0.25 g | 0.25 g | |
| Packaging specification | 0.25 g of 12 granules | 0.25 g of 12 granules | 0.25 g of 12 granules | |
| Manufacturer of the product | Flying cloud pharmaceutical industry | Flying cloud pharmaceutical industry | Flying cloud pharmaceutical industry | |
| Batch number | 190729000523 | 190729000588 | 201101000523 | |
| Purchase price | 20 Yuan | 25 Yuan | 20 Yuan | |
| Wholesale price | 20 Yuan | 25 Yuan | 20 Yuan | |
| Retail price | 20 Yuan | 25 Yuan | 20 Yuan | |
| Batch number | H20080355 | H20080355 | H20080355 | |
| Period of validity | 20220101 | 20220101 | 20220101 | |
| Number of | 30 boxes | 50 box | 10 boxes | |
| Supply unit | Gaoshan pharmaceutical Co Ltd | Gaoshan pharmaceutical Co Ltd | Gaoshan pharmaceutical Co Ltd |
Watch seven
Step 52, when the first record index data is not empty, recording second medicine information corresponding to the first record index data in a medicine database as a current record; taking a second field data group in which second field name data in the current record is medicine quantity information as a second current field data group; extracting second field content data of a second current field data group to generate first medicine quantity data; taking the first field name data in the first medicine information record as a first field data group of the medicine quantity information as a third current field data group; extracting first field content data of a third current field data group to generate second medicine quantity data; generating third medicine quantity data according to the sum of the first medicine quantity data and the second medicine quantity data; and using the third medicine quantity data to update the second field content data of the second current field data group currently recorded in the medicine database.
Here, when the first record index data is not empty, it indicates that there is a second drug information record in the same batch as the first drug information record in the drug database, and the number in the record in the library needs to be incrementally processed by using the number of drugs in the first drug information record; the first drug quantity data is a drug inventory in the drug database and is extracted from a drug quantity field of a second drug information record of the same batch as the first drug information record; the second medicine quantity data is the medicine stock in the first medicine information record and is extracted from the medicine quantity field of the first medicine information record; the third medicine quantity data = the first medicine quantity data + the second medicine quantity data, that is, the new stock of the medicines of the same batch after being input; after the third medicine quantity data is calculated, any record adding operation is not needed to be carried out on the medicine database, and the second field content data of the medicine quantity field in the second medicine information record in the same batch as the first medicine information record is updated, so that the third medicine quantity data is updated from the old first medicine quantity data to the new third medicine quantity data.
For example, if the obtained first medicine information record is shown in table one, the obtained key field name data set is shown in table two, the key field content data corresponding to the key field name data set is shown in table three, the preset medicine database is shown in table four, the first record index data is 1, and it indicates that the medicine database is the 1 st second medicine information record in the same batch as the first medicine information record, then the first medicine quantity data =30 extracted from the 1 st second medicine information record, the second medicine quantity data =10 extracted from the first medicine information record, and the calculated third medicine quantity data = the first medicine quantity data + the second medicine quantity data =40, then the second field content data of the medicine quantity field of the 1 st second medicine information record is modified from 30 boxes to 40 boxes; the modified drug database should be as shown in table eight.
| 1 st second drug | Second | 2 nd drug information record | |
| Storehouse code | 01 | 01 | |
| Medicine code | 86900676000024 | 86900676000024 | |
| Basic specification | 0.25 g | 0.25 g | |
| Packaging specification | 0.25 g of 12 granules | 0.25 g of 12 granules | |
| Manufacturer of the product | Flying cloud pharmaceutical industry | Flying cloud pharmaceutical industry | |
| Batch number | 190729000523 | 190729000588 | |
| Purchase price | 20 Yuan | 25 Yuan | |
| Wholesale price | 20 Yuan | 25 Yuan | |
| Retail price | 20 Yuan | 25 Yuan | |
| Batch number | H20080355 | H20080355 | |
| Period of validity | 20220101 | 20220101 | |
| Number of | 40 boxes | 50 box | |
| Supply unit | Gaoshan pharmaceutical Co Ltd | Gaoshan pharmaceutical Co Ltd |
Table eight
It should be noted that the embodiment of the present invention also provides a computer-readable storage medium, where instructions are stored, and when the instructions are executed on a computer, the computer is caused to execute the steps and processes of the method provided by the embodiment of the present invention.
Embodiments of the present invention further provide a computer program product, where the computer program product includes a computer program, the computer program is stored in a storage medium, and at least one processor may read the computer program from the storage medium, and execute the steps and processes of the method provided by the embodiments of the present invention.
The embodiment of the invention provides a method for inputting medicine information records into a medicine database, a computer program product and a computer readable storage medium, wherein a keyword field name data set is used for configuring keyword field name data; performing field matching comparison according to the keyword field name data; when the matching record is not found, the system generates a new medicine batch number, and then adds the new medicine information record with the new medicine batch number into the medicine database; when the matching record is found, the batch number of the medicines recorded in the library is not modified, and the quantity in the record in the library is only subjected to incremental processing by using the quantity of the medicines in the new medicine information record. Therefore, management requirements of different customers can be met only by simply configuring the key field name data set, maintenance cost of the database can be reduced, and flexibility of system application can be improved.
Those of skill would further appreciate that the various illustrative components and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative components and steps have been described above generally in terms of their functionality in order to clearly illustrate this interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied in hardware, a software module executed by a processor, or a combination of the two. A software module may reside in Random Access Memory (RAM), memory, Read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are merely exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (10)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011524617.5A CN112307036B (en) | 2020-12-22 | 2020-12-22 | A method for entering drug information records in a drug database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011524617.5A CN112307036B (en) | 2020-12-22 | 2020-12-22 | A method for entering drug information records in a drug database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112307036A true CN112307036A (en) | 2021-02-02 |
| CN112307036B CN112307036B (en) | 2021-03-23 |
Family
ID=74487533
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011524617.5A Active CN112307036B (en) | 2020-12-22 | 2020-12-22 | A method for entering drug information records in a drug database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112307036B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113362008A (en) * | 2021-06-24 | 2021-09-07 | 北京天健源达科技股份有限公司 | Method for processing medicine specification coefficient |
| CN113362007A (en) * | 2021-06-24 | 2021-09-07 | 北京天健源达科技股份有限公司 | Method for processing zero stock record |
| CN113536062A (en) * | 2021-06-24 | 2021-10-22 | 北京天健源达科技股份有限公司 | Processing method of medicine price adjustment record |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6529892B1 (en) * | 1999-08-04 | 2003-03-04 | Illinois, University Of | Apparatus, method and product for multi-attribute drug comparison |
| US20030055683A1 (en) * | 2001-09-19 | 2003-03-20 | Gibson Jerry Tyrone | System and method for disseminating drug information |
| CN105447123A (en) * | 2009-12-01 | 2016-03-30 | 富志杰 | Data classification, storage and query methods |
| CN107833637A (en) * | 2017-06-19 | 2018-03-23 | 平安医疗健康管理股份有限公司 | Medicine regular record update method, device, computer equipment and medium |
| CN110867235A (en) * | 2019-11-11 | 2020-03-06 | 上海林康医疗信息技术有限公司 | Medicine code generation method and system and medicine quantity monitoring method and system |
| CN111198887A (en) * | 2019-12-31 | 2020-05-26 | 北京左医健康技术有限公司 | Medicine indexing method, medicine retrieval method and system |
-
2020
- 2020-12-22 CN CN202011524617.5A patent/CN112307036B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6529892B1 (en) * | 1999-08-04 | 2003-03-04 | Illinois, University Of | Apparatus, method and product for multi-attribute drug comparison |
| US20030055683A1 (en) * | 2001-09-19 | 2003-03-20 | Gibson Jerry Tyrone | System and method for disseminating drug information |
| CN105447123A (en) * | 2009-12-01 | 2016-03-30 | 富志杰 | Data classification, storage and query methods |
| CN107833637A (en) * | 2017-06-19 | 2018-03-23 | 平安医疗健康管理股份有限公司 | Medicine regular record update method, device, computer equipment and medium |
| CN110867235A (en) * | 2019-11-11 | 2020-03-06 | 上海林康医疗信息技术有限公司 | Medicine code generation method and system and medicine quantity monitoring method and system |
| CN111198887A (en) * | 2019-12-31 | 2020-05-26 | 北京左医健康技术有限公司 | Medicine indexing method, medicine retrieval method and system |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113362008A (en) * | 2021-06-24 | 2021-09-07 | 北京天健源达科技股份有限公司 | Method for processing medicine specification coefficient |
| CN113362007A (en) * | 2021-06-24 | 2021-09-07 | 北京天健源达科技股份有限公司 | Method for processing zero stock record |
| CN113536062A (en) * | 2021-06-24 | 2021-10-22 | 北京天健源达科技股份有限公司 | Processing method of medicine price adjustment record |
| CN113362008B (en) * | 2021-06-24 | 2024-02-02 | 北京天健源达科技股份有限公司 | How to handle drug specification coefficients |
| CN113362007B (en) * | 2021-06-24 | 2024-05-28 | 北京天健源达科技股份有限公司 | How to handle zero inventory records |
| CN113536062B (en) * | 2021-06-24 | 2024-06-11 | 北京天健源达科技股份有限公司 | How to process drug price adjustment records |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112307036B (en) | 2021-03-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112307036B (en) | A method for entering drug information records in a drug database | |
| US20230402146A1 (en) | Selective distribution of pharmacy item data from pharmacy item tracking system | |
| KR102370647B1 (en) | Sales managing method for medicine, Computer program for the same, and Recording medium storing computer program for the same | |
| US20150371179A1 (en) | System for combined orders during batch printing | |
| KR102017813B1 (en) | Sales managing method for medicine, Computer program for the same, and Recording medium storing computer program for the same, Information sheet for medicine | |
| JP6829052B2 (en) | Shipping information management device, shipping information management method and shipping information management program | |
| US12197978B2 (en) | Unique device identification for devices | |
| JP2020166445A (en) | Information inquiry device, information inquiry method and information inquiry program | |
| CN112420213A (en) | Method for inquiring drug balance according to time | |
| CN102945257B (en) | The method and apparatus in initialization data storehouse | |
| CN118886030A (en) | A data desensitization method and system based on data assets | |
| US20230237427A1 (en) | Scan based packaging controller | |
| CN111932284B (en) | Medicine information code matching method and system | |
| CN112990836A (en) | Material cancellation warehouse-in processing method | |
| KR20230015118A (en) | Medicine stock management method | |
| US20220301697A1 (en) | System and techniques for inventory data reconciliation | |
| EP4033427A1 (en) | Information management device, information management method, and computer program | |
| CN113555102A (en) | Drug data management method, device, system and computer storage medium | |
| JP6997513B2 (en) | Numbering control device, numbering control method and numbering control program | |
| CN113536062B (en) | How to process drug price adjustment records | |
| JP7018708B2 (en) | Component management device, component management method and component management program | |
| WO2015077710A1 (en) | Method and apparatus to synchronize drug information | |
| JP7712974B2 (en) | Unit price management device, unit price management method, and unit price management program | |
| JP7641700B2 (en) | Apparatus, method and program for managing inventory of goods in medical institutions | |
| JP2012068912A (en) | Information management device, conversion master management method, and program |
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 | ||
| PP01 | Preservation of patent right | ||
| PP01 | Preservation of patent right |
Effective date of registration: 20251202 Granted publication date: 20210323 |