CN113536062A - Processing method of medicine price adjustment record - Google Patents

Processing method of medicine price adjustment record Download PDF

Info

Publication number
CN113536062A
CN113536062A CN202110707574.2A CN202110707574A CN113536062A CN 113536062 A CN113536062 A CN 113536062A CN 202110707574 A CN202110707574 A CN 202110707574A CN 113536062 A CN113536062 A CN 113536062A
Authority
CN
China
Prior art keywords
price
record
field
medicine
adjustment
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
Application number
CN202110707574.2A
Other languages
Chinese (zh)
Other versions
CN113536062B (en
Inventor
高雄
姜跃滨
吕春枝
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Tianjian Source Technology Co ltd
Original Assignee
Beijing Tianjian Source Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Tianjian Source Technology Co ltd filed Critical Beijing Tianjian Source Technology Co ltd
Priority to CN202110707574.2A priority Critical patent/CN113536062B/en
Publication of CN113536062A publication Critical patent/CN113536062A/en
Application granted granted Critical
Publication of CN113536062B publication Critical patent/CN113536062B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/903—Querying
    • 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
    • G06Q30/00—Commerce
    • G06Q30/02—Marketing; Price estimation or determination; Fundraising
    • G06Q30/0201—Market modelling; Market analysis; Collecting market data
    • 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
    • G06Q30/00—Commerce
    • G06Q30/02—Marketing; Price estimation or determination; Fundraising
    • G06Q30/0201—Market modelling; Market analysis; Collecting market data
    • G06Q30/0203—Market surveys; Market polls
    • 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
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30—Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Finance (AREA)
  • Development Economics (AREA)
  • Accounting & Taxation (AREA)
  • General Business, Economics & Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Game Theory and Decision Science (AREA)
  • Databases & Information Systems (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • Health & Medical Sciences (AREA)
  • Public Health (AREA)
  • Epidemiology (AREA)
  • Biomedical Technology (AREA)
  • General Engineering & Computer Science (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Medical Informatics (AREA)
  • Medical Treatment And Welfare Office Work (AREA)
  • Medical Preparation Storing Or Oral Administration Devices (AREA)

Abstract

The embodiment of the invention relates to a method for processing a price adjustment record of a medicine, which comprises the following steps: acquiring a first medicine name and manufacturer data; inquiring the price adjustment attribute of the medicine; if the price-adjustable property is the price-adjustable property, recording the matched record in the first medicine inventory list as a first medicine record; taking a first drug record selected by the user as a first drug record; acquiring price adjusting information set by a user for a first medicine record to generate a first price adjusting data set; generating a first medicine price adjustment record according to the first price adjustment data group and the first medicine record; referring to the first medicine price adjustment record to perform unified price adjustment information setting on the rest first medicine records and generate corresponding first medicine price adjustment records; and storing the first medicine price adjustment record into a first medicine price adjustment list. The method of the invention can solve the problems of low efficiency and easy error of manual price adjustment, and can improve the data guarantee capability of price adjustment.

Description

Processing method of medicine price adjustment record
Technical Field
The invention relates to the technical field of data information processing, in particular to a processing method of a medicine price adjustment record.
Background
In a drug management system, a drug inventory list is often used to store record information related to inventory of drugs, that is, drug inventory records, in which not only information such as names, drug codes, basic specifications, packaging specifications, quantities, etc., of drugs, but also information on purchase price, wholesale price, and retail price related to purchase and sale of drugs are stored. The price of the medicine is not constant, and when the price of the medicine is adjusted, the corresponding price in the medicine inventory record needs to be adjusted. Conventionally, most of the methods of manual setting, modification and single confirmation are adopted to modify the drug inventory records in the drug inventory list one by one. This approach is not only inefficient and error prone, but also has no traceable modification of trace information.
Disclosure of Invention
The invention aims to provide a method for processing a medicine price adjustment record, which is used for generating a corresponding medicine price adjustment record in advance for each price adjustment, carrying out batch automatic price adjustment processing on medicine inventory records according to the medicine price adjustment record when system time reaches preset time, using a price change list to store the price adjustment track information of the previous times when the price adjustment is processed, and increasing more price adjustment modes and more convenient profit and loss statistical modes by configuring a purchase price adjustment mode and a profit and loss record adding/cancelling mode. Therefore, the problems of low manual operation efficiency and easy error in the conventional method can be solved, the data guarantee capability of the price exchange operation can be improved, and in addition, the intuitive profit and loss comparison and statistics functions before and after price exchange can be provided.
In order to achieve the above object, an embodiment of the present invention provides a method for processing a price adjustment record of a medicine, where the method includes:
acquiring first medicine name data and first medicine manufacturer data;
inquiring the price adjustment attribute of the medicine corresponding to the first medicine name data;
if the query result is the unified price-adjusting attribute, in a preset first medicine inventory list, marking a first medicine inventory record with a first name field matched with the first medicine name data and a first manufacturer field matched with the first medicine manufacturer data as a first medicine record, and forming a first list by the obtained first medicine records;
taking one first medicine record which is selected by the user in the first list as a first medicine record;
acquiring price adjusting information set by the user for the first medicine record to generate a first price adjusting data set;
performing first medicine price adjustment record combination processing according to the first price adjustment data group and the first medicine record to generate a first medicine price adjustment record;
referring to the first medicine price adjustment record, performing unified price adjustment information setting on the rest first medicine records in the first list, and generating first medicine price adjustment records corresponding to the rest first medicine records;
and finally, storing all the obtained first medicine price adjustment records into a preset first medicine price adjustment list.
Preferably, the first drug inventory list comprises a plurality of the first drug inventory records; the first drug inventory record comprises a first basic field set, a first quantity field, a first purchase price field, a first wholesale price field and a first retail price field; the first set of base fields includes at least the first name field, a first drug code field, a first base specification field, the first package specification field, the first vendor field, and the first package coefficient field;
the first medicine price adjustment list comprises a plurality of first medicine price adjustment records; the first medicine price adjusting record comprises a second basic field set, a first original wholesale price field, a first original retail price field, a first current wholesale price field, a first current retail price field, a first preset price adjusting time field and a first actual price adjusting time field; the second basic field set at least comprises a second name field, a second medicine code field, a second basic specification field, a second package specification field, a second manufacturer field and a second package coefficient field;
the first price adjusting data group comprises first medicine wholesale price adjusting data, first medicine retail price adjusting data and first medicine price adjusting preset time data.
Preferably, the performing a first drug price adjustment record combination process according to the first price adjustment data group and the first drug record to generate a first drug price adjustment record specifically includes:
setting the second basic field set of the first drug price adjustment record according to the first basic field set of the first drug record;
setting the first original wholesale price field of the first medicine price adjustment record according to the first wholesale price field of the first medicine record;
setting the first original retail price field of the first medicine price adjustment record according to the first retail price field of the first medicine record;
setting the first current wholesale price field of the first medicine price adjustment record according to the first medicine wholesale price adjustment data of the first price adjustment data group;
setting the first current retail price field of the first medicine price adjustment record according to the first medicine retail price adjustment data of the first price adjustment data group;
setting the first preset price adjusting time field of the first medicine price adjusting record according to the first medicine price adjusting preset time data of the first price adjusting data group;
setting the first actual price-adjusting time field of the first medicine price-adjusting record to be null.
Preferably, the referring to the first medicine price adjustment record, performing unified price adjustment information setting on the remaining first medicine records in the first list, and generating first medicine price adjustment records corresponding to the remaining first medicine records specifically includes:
extracting the first current wholesale price field as first wholesale price reference data, the first current retail price field as first retail price reference data, the second packaging system number field as first coefficient reference data and the first preset price adjusting time field as first time reference data from the first medicine price adjusting record;
polling all first drug records in the first list except the first drug record; recording the first drug record which is polled currently as a first current record; initializing the first medicine price adjustment record corresponding to the first current record, and recording as a second current record; setting the second basic field set of the second current record according to the first basic field set of the first current record; setting the first original wholesale price field of the second current record according to the first wholesale price field of the first current record; setting the first original retail price field of the second current record according to the first retail price field of the first current record; extracting the first packaging coefficient field from the first current record as first packaging coefficient data, calculating first price data as first wholesale price reference data as first packaging coefficient data/first coefficient reference data, calculating second price data as first retail price reference data as first packaging coefficient data/first coefficient reference data, setting the first current wholesale price field of the second current record according to the first price data, and setting the first current retail price field of the second current record according to the second price data; setting the first preset price-adjusting time field of the second current record according to the first time reference data; and setting the first actual tune away time field of the second current record to null.
Preferably, when the price adjustment processing is performed based on the price adjustment record of the medicine, the method further includes:
generating first time data according to current time information of the system;
marking the first medicine price adjusting record in which the first preset price adjusting time field in the first medicine price adjusting list does not exceed the first time data and the first actual price adjusting time field is empty as a first price adjusting record;
according to the first time data, carrying out actual price adjusting time modification processing on the first price adjusting record;
then according to the modified first price adjustment record, carrying out price adjustment processing and price adjustment profit and loss recording processing on the drug inventory record;
and setting a preset first price change list according to the modified first price adjustment record.
Further, the performing, according to the first time data, actual price adjustment time modification processing on the first price adjustment record specifically includes:
and setting the first actual price-adjusting time field of the first price-adjusting record according to the first time data.
Further, the adjusting the price of the drug inventory record and the adjusting the price for profit and loss record according to the modified first price adjusting record specifically includes:
adjusting the price of the drug inventory record according to the modified first price adjustment record; firstly, inquiring the first drug inventory list according to the second drug code field, the second basic specification field, the second packaging specification field and the second manufacturer field of the modified first price adjustment record, and marking the matched first drug inventory record as a third current record; then setting the first wholesale price field of the third current record according to the first current wholesale price field of the modified first price adjustment record; then setting the first retail price field of the third current record according to the first current retail price field of the modified first price adjusting record; identifying a preset purchase price adjusting mode, and if the purchase price adjusting mode is an equivalent wholesale price mode of a purchase price, setting the first purchase price field of the third current record according to the first current wholesale price field of the modified first adjusting record;
after the adjustment processing of the drug inventory record price is completed, carrying out price adjustment profit and loss record processing according to the third current record and the modified first price adjustment record; firstly, identifying a preset profit and loss record adding/canceling mode; and if the profit-loss record adding/canceling mode is an adding mode, identifying whether the first quantity field of the third current record is empty, if the first quantity field is not empty, performing price adjustment profit-loss record generation processing according to the third current record and the modified first price adjustment record to obtain a corresponding first price adjustment profit-loss record, and storing the first price adjustment profit-loss record into a preset first price adjustment profit-loss list.
Further preferably, the first price adjustment profit and loss list comprises a plurality of first price adjustment profit and loss records; the first adjusting price profit and loss record at least comprises a third basic field set, a second number field, a second purchase price field, a second original wholesale price field, a second original retail price field, a second current wholesale price field, a second current retail price field, a second actual adjusting time field, a first wholesale price profit and loss field and a first retail price profit and loss field; the third set of base fields includes a third name field, a third drug code field, a third base specification field, a third package specification field, a third vendor field, and a third package coefficient field.
Further preferably, the performing, according to the third current record and the modified first price adjustment record, a price adjustment profit and loss record generating process to obtain a corresponding first price adjustment profit and loss record specifically includes:
setting the third basic field set of the first price adjustment profit-loss record according to the first basic field set of the third current record;
setting the second quantity field of the first price adjustment profit-loss record according to the first quantity field of the third current record;
setting the second purchase price field of the first price adjustment profit and loss record according to the first purchase price field of the third current record;
setting the second original wholesale price field of the first price adjustment profit-loss record according to the first original wholesale price field of the modified first price adjustment record;
setting the second original retail price field of the first price adjustment profit-loss record according to the first original retail price field of the modified first price adjustment record;
setting the second current wholesale price field of the first price adjustment profit-loss record according to the first current wholesale price field of the modified first price adjustment record;
setting the second current retail price field of the first price adjustment profit-loss record according to the first current retail price field of the modified first price adjustment record;
setting the second actual price adjusting time field of the first price adjusting profit-loss record according to the first actual price adjusting time field of the modified first price adjusting record;
calculating a third data (a second current wholesale price field-a second original wholesale price field) and a second quantity field, and a fourth data (a second current retail price field-a second original retail price field) and a second quantity field;
setting the first wholesale price profit and loss field of the first price adjustment profit and loss record according to the third data;
and setting the first retail price profit and loss amount field of the first price adjustment profit and loss record according to the fourth data.
Further, the setting a preset first price change list according to the modified first price adjustment record specifically includes:
inquiring first price change records in the first price change list according to the second medicine code field, the second package specification field and the second manufacturer field of the modified first price adjustment record to obtain a plurality of matched first price change records, and marking the first cut-off time field as a fourth current record, wherein the first cut-off time field is empty; wherein the first price change list comprises a plurality of first price change records; the first price change record at least comprises a fourth basic field set, a second wholesale price field, a second retail price field, a first starting time field and a first cut-off time field; the fourth basic field set comprises a fourth drug code field, a fourth basic specification field, a fourth packaging specification field, a fourth manufacturer field and a fourth packaging coefficient field;
setting a first cut-off time field of the fourth current record according to the first actual price-adjusting time field of the modified first price-adjusting record;
adding a new first price change record in the first price change list;
setting the fourth basic field set of the new first price change record according to the second basic field set of the modified first price change record;
setting the second wholesale price field of the new first price change record according to the first current wholesale price field of the modified first price adjustment record;
setting the second retail price field of the new first price change record according to the first current retail price field of the modified first price adjustment record;
setting the first starting time field of the new first price change record according to the first actual price adjusting time field of the modified first price adjusting record;
setting the first expiration time field of the new first price change record to null.
The method for processing the drug price adjustment records, provided by the embodiment of the invention, is characterized in that corresponding drug price adjustment records are generated in advance for each price adjustment, batch automatic price adjustment processing is carried out on drug inventory records according to the drug price adjustment records when the system time reaches the preset time, a price change list is used for storing the previous price adjustment track information when the price adjustment is processed, and in addition, more price adjustment modes and more convenient profit and loss statistical modes are added by configuring a purchase price adjustment mode and a profit and loss record adding/canceling mode. Therefore, the problems of low manual operation efficiency and easy error in the conventional method are solved, the data guarantee capability of the price-exchange operation is improved, and in addition, the intuitive profit-loss comparison and statistics functions before and after price exchange are provided.
Drawings
Fig. 1 is a schematic view of a processing method for a price adjustment record of a medicine according to an embodiment of the present invention;
fig. 2 is a schematic view of another processing method for a price adjustment record of a medicine according to a second 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.
When a worker plans to perform price adjustment processing on a certain drug in a drug management system, the drug management system does not directly perform manual modification on drug inventory data, but establishes a corresponding drug price adjustment record for the adjusted drug by using a processing method of a drug price adjustment record provided in an embodiment of the present invention, so as to specifically perform automatic unified price adjustment processing by using a subsequent processing method of another drug price adjustment record provided in a second embodiment of the present invention, fig. 1 is a schematic diagram of a processing method of a drug price adjustment record provided in the first embodiment of the present invention, as shown in fig. 1, the method mainly includes the following steps:
step 1, first medicine name data and first medicine manufacturer data are obtained.
Here, the first drug name data is the name of the drug which is scheduled to be adjusted in price and is entered by the staff in the drug management system; the first drug manufacturer data is the name of the manufacturer of the drug which is entered by the staff in the drug management system and is scheduled to be adjusted.
Step 2, inquiring the price adjustment attribute of the medicine corresponding to the first medicine name data;
the drug price adjustment attribute comprises a uniform price adjustment attribute and a non-uniform price adjustment attribute.
Here, the pricing types for the drugs in the drug management system can be divided into a unified price adjustment type and a purchase and sale type; the unified price-adjusting type shows that the price adjustment of different packaging specifications of the current medicine can be realized uniformly based on the unit price adjustment and the packaging specifications, and the unified price adjustment can be carried out according to the different packaging specifications as long as the unit price adjustment is confirmed; the advance-order-sale type indicates that the current medicines may have different unit prices in different packaging specifications, so that unified price adjustment cannot be performed based on the unit price adjustment and the packaging specifications during price adjustment; therefore, for the medicines of the unified price-adjusting type, the price-adjusting attribute of the corresponding medicine is preset to be the unified price-adjusting attribute by the medicine management system, and for the medicines of the advance-order and sale-order type, the price-adjusting attribute of the corresponding medicine is preset to be the non-unified price-adjusting attribute by the medicine management system. The embodiment of the invention mainly aims at the operation of carrying out the price adjustment record of the medicines with unified price adjustment, so that the price adjustment attribute of the medicines is firstly inquired.
Step 3, if the query result is the unified price-adjusting attribute, in a preset first medicine inventory list, marking a first medicine inventory record with a first name field matched with first medicine name data and a first manufacturer field matched with the first medicine manufacturer data as a first medicine record, and forming a first list by the obtained plurality of first medicine records;
wherein the first drug inventory list comprises a plurality of first drug inventory records; the first drug inventory record comprises a first basic field set, a first quantity field, a first purchase price field, a first wholesale price field and a first retail price field; the first set of base fields includes at least a first name field, a first drug code field, a first base specification field, a first package specification field, a first vendor field, and a first package coefficient field.
Here, the first drug inventory list is a data system for storing all inventory drugs, and the first drug inventory list may be implemented by a plurality of combined data lists, or may be implemented by an independent database;
each first drug inventory record in the first drug inventory list is used for storing detailed information of one packaging specification of one drug, and the stored information at least comprises fields such as a first basic field set, a first quantity field, a first purchase price field, a first wholesale price field and a first retail price field;
the first set of basic fields is used for storing some basic drug information, and at least comprises a first name field for storing drug name information, a first drug code field for storing code information, a first basic specification field for storing minimum unit specification magnitude information (such as x mg, y ml, z ml, etc.) of the drug, a first packaging specification field for storing certain specific packaging specification information (such as x mg N sheets, y ml M bottles, z ml L sheets, etc.) of the drug, a first manufacturer field for storing drug manufacturer information, and a first packaging coefficient field for confirming the current packaging specification number (for example, when the first packaging specification field is x mg N sheets, the first packaging coefficient field can be set to N); in addition, the first basic field set further includes a first basic unit field for storing minimum unit specification unit information of medicines (such as "sheet", "bottle", "branch"), a first packing unit field for storing certain specific packing specification unit information of medicines (such as "box", etc.), a first medicine batch field for storing medicine batch information, a first medicine batch number field for storing medicine batch number information, a first medicine expiration date field for storing medicine expiration date, a first warehouse code word field for storing warehouse identification, and the like;
the first quantity field is used for storing inventory remaining quantity information of the current packaging specification of the current medicine; the first purchase price field is used for storing purchase price information of the current packaging specification of the current medicine; the first wholesale price field is used for storing wholesale price information of the current packaging specification of the current medicine; the first retail price field is used for storing retail price information of the current packaging specification of the current medicine;
here, if the query result of the drug price adjustment attribute is the unified price adjustment attribute, which indicates that all packaging specifications of the current drug subordinate support unified price adjustment, the drug management system first searches inventory records of all packaging specifications of the current drug produced by the current manufacturer, that is, all matched first drug inventory records, from a drug inventory database of the system, that is, a first drug inventory list, according to the drug name, that is, the first drug name data, and the manufacturer name, that is, the first drug manufacturer data, and marks all the inventory records as the first drug records, so as to obtain the first list for processing in subsequent steps.
For example, the first drug name data is drug 1, the first drug manufacturer data is manufacturer 1, and there are 3 first drug inventory records in the first drug inventory list, where the first name field is "first drug 1" + the first manufacturer field is "manufacturer 1": the drug management system extracts the 3 first drug inventory records by querying the first drug inventory list and labels them as first drug records, resulting in a first list of 3 first drug records. And the drug management system pushes the first list to the user in a display mode of a text, a list or a graphical interface for the user to select.
And 4, taking a first medicine record which is optionally selected by the user in the first list as a first medicine record.
Here, in the embodiment of the present invention, after the user manually performs the price adjustment setting on one of the first medicine records in the first list, the unit price adjustment information of the current price adjustment setting may be automatically calculated, and then, based on the calculated unit price adjustment information, the automatic unified price adjustment setting may be performed on the other first medicine records in the first list. When the manual price adjustment setting is carried out, the user can select a first medicine record from the first list for setting, wherein the first medicine record is the first medicine record which is selected by the user for manual price adjustment setting.
Step 5, obtaining price adjusting information set by a user for the first medicine record to generate a first price adjusting data set;
the first price adjusting data set comprises first medicine wholesale price adjusting data, first medicine retail price adjusting data and first medicine price adjusting preset time data.
Here, the first price-adjusting data set includes all information of manual price-adjusting setting of the first medicine record by the user; the first medicine wholesale price adjusting data is price adjusting information for wholesale price set by a user; the first medicine retail price adjusting data is price adjusting information for retail price set by a user, if the first medicine wholesale price adjusting data or the first medicine retail price adjusting data is not null, it is indicated that the wholesale price or the retail price needs to be adjusted, otherwise, if the first medicine retail price adjusting data is null, it is indicated that the wholesale price or the retail price does not need to be adjusted, it is indicated that a value 0 is different from null, 0 is not equal to null, and if the first medicine wholesale price adjusting data or the first medicine retail price adjusting data is 0, it is indicated that the price is reduced to 0; the first medicine price-adjusting preset time data is time information for starting unified price adjustment set by a user.
Step 6, performing combined processing on the first medicine price adjustment records according to the first price adjustment data group and the first medicine record to generate a first medicine price adjustment record;
the first medicine price adjusting record comprises a second basic field set, a first original wholesale price field, a first original retail price field, a first current wholesale price field, a first current retail price field, a first preset price adjusting time field and a first actual price adjusting time field; the second basic field set at least comprises a second name field, a second medicine code field, a second basic specification field, a second package specification field, a second manufacturer field and a second package coefficient field;
here, the first drug price adjustment record is a corresponding drug price adjustment record established by the drug management system for the first drug record, and the first drug price adjustment record is used for storing some basic information of the price-adjusted drugs, price information before and after price adjustment, time information for starting price adjustment, and the like;
in the first medicine price adjustment record, the fields of the second basic field set at least comprise a second name field for storing medicine name information, a second medicine code field for storing code information, a second basic specification field for storing medicine minimum unit specification magnitude information, a second packaging specification field for storing certain specific packaging specification information of a medicine, a second manufacturer field for storing medicine manufacturer information and a second packaging coefficient number field for confirming the current packaging specification quantity, and in addition, the fields also can comprise a second basic unit field for storing medicine minimum unit specification unit information and a second packaging unit field for storing certain specific packaging specification unit information; it should be noted that the field content of the second basic field set should be consistent with the corresponding field content in the first basic field set in the first drug record, that is, the second name field should be consistent with the first name field, the second drug code field should be consistent with the first drug code field, the second basic specification field should be consistent with the first basic specification field, the second package specification field should be consistent with the first package specification field, the second manufacturer field should be consistent with the first manufacturer field, the second package coefficient field should be consistent with the first package coefficient field, the second basic unit field should be consistent with the first basic unit field, and the second package unit field should be consistent with the first package unit field;
the first original wholesale price field and the first original retail price field are respectively used for storing price information before the price adjustment of the medicines, namely the first original wholesale price field is consistent with the first wholesale price field of the first medicine record, and the first original retail price field is consistent with the first retail price field of the first medicine record;
the first current wholesale price field and the first current retail price field are respectively used for storing price information after the price adjustment of the medicines, namely the first current wholesale price field is consistent with the first medicine wholesale price adjustment data of the first price adjustment data set, namely the first current retail price field is consistent with the first medicine retail price adjustment data of the first price adjustment data set;
the first preset price-adjusting time field is used for storing unified price-adjusting starting time information set by a user, namely the first preset price-adjusting time field is consistent with first medicine price-adjusting preset time data of the first price-adjusting data set;
the first actual price-adjusting time field is used for storing the substantial execution time information of the current medicine price-adjusting record, namely the field is set after the medicine management system completes the corresponding automatic unified price-adjusting treatment according to the current medicine price-adjusting record, so that the first actual price-adjusting time field is set to be null when the current medicine price-adjusting record is created;
in addition, the first medicine price adjustment record can further comprise a first generation time field for storing generation time information of the current medicine price adjustment record, a first price adjustment reason field for storing reason description information for generating the current medicine price adjustment record, a first personnel field for storing operator information for generating the current medicine price adjustment record and the like;
after all information of manual price adjustment setting of the first medicine record by the user, namely the first price adjustment data set, is obtained, the medicine management system generates a medicine price adjustment record with empty full fields, namely a first medicine price adjustment record, and configures all fields of the first medicine price adjustment record according to the corresponding relation between the medicine price adjustment record and the fields of the medicine record and the price adjustment information set by the user;
the method specifically comprises the following steps: step 61, setting a second basic field set of the first medicine price adjustment record according to the first basic field set of the first medicine record;
here, as can be seen from the above analysis of the content of the first drug pricing record, the second basic field set of the first drug pricing record is copied from the corresponding field of the first basic field set of the first drug record;
step 62, setting a first original wholesale price field of the first medicine price adjustment record according to the first wholesale price field of the first medicine record;
here, as can be seen from the above analysis of the content of the first drug price adjustment record, the first original wholesale price field of the first drug price adjustment record is copied from the first wholesale price field of the first drug record;
step 63, setting a first original retail price field of the first medicine price adjustment record according to the first retail price field of the first medicine record;
here, as can be seen from the above analysis of the content of the first drug pricing record, the first original retail price field of the first drug pricing record is copied from the first retail price field of the first drug record;
step 64, setting a first current wholesale price field of a first medicine price regulation record according to first medicine wholesale price regulation data of the first price regulation data set;
here, as can be seen from the above analysis of the content of the first drug price adjustment record, the first current wholesale price field of the first drug price adjustment record is copied from the first drug wholesale price adjustment data of the first price adjustment data set;
step 65, setting a first current retail price field of a first medicine price adjustment record according to first medicine retail price adjustment data of the first price adjustment data group;
here, as can be seen from the above analysis of the content of the first drug pricing record, the first current retail price field of the first drug pricing record is copied from the first drug retail pricing data of the first pricing data set;
step 66, setting a first preset price adjusting time field of a first medicine price adjusting record according to first medicine price adjusting preset time data of the first price adjusting data group;
here, as can be seen from the above analysis of the content of the first drug pricing record, the first preset pricing time field of the first drug pricing record is copied from the first drug pricing preset time data of the first pricing data set;
step 67, set the first actual price adjustment time field of the first medicine price adjustment record to null.
Here, as can be seen from the above analysis of the contents of the first medicine price adjustment record, the first actual price adjustment time field of the first medicine price adjustment record should be initially empty.
In addition, if the first medicine price adjustment record further comprises contents such as a first generation time field, a first price adjustment reason field, a first person field and the like, the medicine management system sets the first generation time field by acquiring current time information of the system, sets the first price adjustment reason field according to condition reason information input by a user, and acquires identification or name information of a current operator to set the first person field.
Step 7, referring to the first medicine price adjustment record, performing unified price adjustment information setting on the rest first medicine records in the first list, and generating first medicine price adjustment records corresponding to the rest first medicine records;
as described above, in the embodiment of the present invention, after the user manually performs the price adjustment setting on one of the first medicine records in the first list, the unit price adjustment information of the current price adjustment setting may be automatically calculated, and then the other first medicine records in the first list may be automatically and uniformly set based on the calculated unit price adjustment information; the current step is the process of carrying out automatic unified price adjustment setting on other first medicine records;
the method specifically comprises the following steps: step 71, extracting a first current wholesale price field as first wholesale price reference data, a first current retail price field as first retail price reference data, a second packaging system number field as first coefficient reference data and a first preset price adjusting time field as first time reference data from the first medicine price adjusting record;
here, as mentioned above, the price adjustment of different packaging specifications of the current medicine can be uniformly realized based on the unit price adjustment and the current packaging specification, and the unit price adjustment can be uniformly adjusted according to different packaging specifications as long as the unit price adjustment is confirmed;
when calculating the unit price adjustment information, the embodiment of the invention is realized by calculating the ratio of the reference medicine price adjustment record, namely the latest price field (the first current wholesale price field or the first current retail price field) of the first medicine price adjustment record to the packaging coefficient field (the second packaging system digital field), namely the calculated unit price adjustment of the wholesale price is the first current wholesale price field/the second packaging system digital field, and the unit price adjustment of the retail price is the first current retail price field/the second packaging system digital field;
therefore, before performing automatic unified price adjustment setting, it is necessary to extract in advance various parameters, that is, first wholesale price reference data, first retail price reference data and first coefficient reference data, which can calculate unit price adjustment information from the information of performing manual price adjustment setting on the first medicine record by the user in step 6, and it is also necessary to extract in advance a time parameter, that is, first time reference data, of unified price adjustment from the information of performing manual price adjustment setting on the first medicine record by the user;
for example, the first list contains 3 first drug records: the first packing factor of the first drug record a is 1, the first packing factor of the first drug record B is 11, and the first packing factor of the first drug record C is 12;
in the step 6, the user selects the first medicine record A as a first medicine price adjusting record, performs manual price adjusting setting on the first medicine price adjusting record, adjusts the wholesale price to 1.1 yuan, adjusts the retail price to 5 yuan, and sets the unified price adjusting time to 2021 year, 1 month and 1 day, so as to obtain a first medicine price adjusting record;
packaging coefficient information set in the first medicine price adjustment record, namely a second packaging coefficient field of the first medicine price adjustment record is consistent with a first packaging coefficient of the first medicine record A and is also 1, latest wholesale price information set in the first medicine price adjustment record, namely a first current wholesale price field of the first medicine price adjustment record is 1.1 yuan, latest retail price information set in the first medicine price adjustment record, namely a first current retail price field of the first medicine price adjustment record is 5 yuan, and unified price adjustment time information set in the first medicine price adjustment record, namely a first preset price adjustment time field of the first medicine price adjustment record is 2021 month and 1 day in 2021 year;
then the first wholesale price reference data obtained in step 71 is 1.1 yuan, the first retail price reference data is 5 yuan, the first coefficient reference data is 1, and the first time reference data is 1 month and 1 day 2021;
step 72, polling all first drug records except the first drug record in the first list;
the method specifically comprises the following steps: step 721, recording the first currently polled drug record as a first current record;
here, if the first list includes 3 first drug records, 2 first drug records are included in addition to the first drug record, and the remaining 2 records are sequentially operated during polling, and the first drug record currently being processed is recorded as a first current record each time;
step 722, initializing a first medicine price adjustment record corresponding to the first current record, and recording as a second current record;
here, if the first list has 2 first drug records besides the first drug record, a corresponding first drug price adjustment record is automatically generated for the current first drug record at each polling, and is marked as a second current record in the current operation, and finally 2 drug condition records can be obtained after the polling is finished;
723, setting a second basic field set of a second current record according to the first basic field set of the first current record;
here, similar to the processing of step 61, further description is not given;
step 724, setting a first original wholesale price field of a second current record according to the first wholesale price field of the first current record;
here, similar to the processing of step 62, further description is not given;
step 725, setting a first original retail price field of a second current record according to the first retail price field of the first current record;
here, similar to the processing in step 63, further description is not given;
step 726, extracting a first package coefficient segment from the first current record as first package coefficient data, calculating first price data as first wholesale price reference data as first package coefficient data/first coefficient reference data, calculating second price data as first retail price reference data as first package coefficient data/first coefficient reference data, setting a first current wholesale price field of the second current record according to the first price data, and setting the first current retail price field of the second current record according to the second price data;
here, as mentioned above, the price adjustment of different packaging specifications of the current medicines can be uniformly realized based on the unit price adjustment of the wholesale price, i.e. the first current wholesale price field/the second packaging system number field, the unit price adjustment of the retail price, i.e. the first current retail price field/the second packaging system number field, the current packing specification is the first packing coefficient data, then the latest wholesale price field of the current medicine price adjustment record is the unit price adjustment of the wholesale price, the first packing coefficient data is the first wholesale price reference data, the first packing coefficient data/the first coefficient reference data, the latest retail price field of the current medicine price adjustment record is the unit price adjustment of the first current retail price field, namely the retail price, and the first packaging coefficient data is the first retail price reference data; the first price data in the above steps is the latest wholesale price of the calculated current drug price adjustment record, and the second price data is the latest retail price of the calculated current drug price adjustment record;
for example, the first list contains 3 first drug records: the first packing factor of the first drug record a is 1, the first packing factor of the first drug record B is 11, and the first packing factor of the first drug record C is 12;
in step 6, the user selects the first medicine record A as a first medicine price adjusting record, performs manual price adjusting setting on the first medicine price adjusting record, adjusts the wholesale price to 1.1 yuan, and adjusts the retail price to 5 yuan; the first wholesale price reference data obtained in the step 71 is 1.1 yuan, the first retail price reference data is 5 yuan, and the first coefficient reference data is 1;
then, when the first current record is the first drug record B, the drug management system generates a corresponding first price adjustment record B for the first drug record B as a second current record; and the first packing coefficient data is a first packing coefficient field extracted from the first current record, that is, a first packing coefficient field extracted from the first medicine record B, and since the field is 11, the first packing coefficient data should be 11; then the first price data is the first wholesale price reference data, the first packing coefficient data/the first coefficient reference data is 1.1, 11/1 is 12.1, the second price data is the first retail price reference data, the first packing coefficient data/the first coefficient reference data is 5, 11/1 is 55, then the first current wholesale price field of the first tuning record B should be 12.1, and the first current retail price field of the first tuning record B should be 55;
when the first current record is the first medicine record C, the medicine management system generates a corresponding first price adjustment record C for the first medicine record C as a second current record; and the first packing coefficient data is a first packing coefficient field extracted from the first current record, that is, a first packing coefficient field extracted from the first medicine record C, and since the field is 12, the first packing coefficient data should be 12; then the first price data is the first wholesale price reference data, the first packing coefficient data/the first coefficient reference data is 1.1, 12/1, 13.2-element, the second price data is the first retail price reference data, the first packing coefficient data/the first coefficient reference data is 5, 12/1-element, 60-element, then the first current wholesale price field of the first tuning record C should be 13.2, and the first current retail price field of the first tuning record B should be 60-element;
step 726, setting a first preset price adjusting time field of the second current record according to the first time reference data;
here, for example, the first list includes 3 first drug records: a first medication record A, B, C; in step 6, the user selects the first medicine record A as a first medicine price adjustment record, performs manual price adjustment setting on the first medicine price adjustment record, and sets the unified price adjustment time to be 1 month and 1 day in 2021 year; the first time reference data obtained in step 71 is 1 month and 1 day of 2021 year;
then, when the first current record is the first drug record B, the first preset price-adjusting time field of the first price-adjusting record B generated by the drug management system for the first drug record B should be 1 month 1 day 2021 year; when the first current record is the first drug record C, the first preset price adjusting time field of the first price adjusting record C generated by the drug management system for the first drug record C should also be 1 month 1 day 2021 year;
step 727 sets the first actual tune away time field of the second current record to null.
Here, similar to the processing of step 67, further description is not given.
Step 8, finally, storing all the obtained first medicine price adjustment records into a preset first medicine price adjustment list;
the first medicine price adjustment list comprises a plurality of first medicine price adjustment records.
Here, for example, the first list includes 3 first drug records, and finally 3 corresponding first drug price adjustment records can be obtained, and the preset price adjustment times of the 3 first drug price adjustment records are all the same time point, so that the purpose of automatically and uniformly adjusting prices can be achieved by the subsequent processing method of another drug price adjustment record provided by the second embodiment of the present invention.
To sum up, the method for processing the drug price adjustment records provided by the embodiment of the invention can automatically match all drug inventory records conforming to the current manufacturer and the current drug according to the drug name and the manufacturer name input by the user, and does not need to manually search item by staff; after all matched drug inventory records are obtained, the embodiment of the invention can automatically adjust the price of other remaining records by referring to the setting content of the user only by adjusting the price of one record by the user, and does not need to modify price adjusting information one by a worker, thereby reducing the error rate and improving the working efficiency; when price adjustment setting is carried out, the embodiment of the invention does not directly modify the original inventory, but creates a corresponding medicine price adjustment record for each medicine inventory record needing price adjustment, thereby reducing the error rate and improving the safety guarantee of the medicine inventory data; when the price adjustment is carried out, the price adjustment time of the price adjustment records of the medicines with different packaging specifications of the same medicine is unified, and the situations of price omission or asynchronous price adjustment and the like during automatic price adjustment are avoided.
After a worker establishes a corresponding medicine price adjusting record for the price adjusting medicine in a medicine management system through the processing method of the medicine price adjusting record provided by the embodiment of the invention, the automatic price adjusting processing of the medicine price adjusting record set by the embodiment of the invention can be started through setting a unified automatic price adjusting switch; if the unified automatic price adjustment switch is in an on state, the drug management system monitors the current time of the system by using another method for processing a record of price adjustment of a drug provided by the second embodiment of the present invention, and once the time meets the start requirement, the automatic unified price adjustment processing process can be started, fig. 2 is a schematic diagram of another method for processing a record of price adjustment of a drug provided by the second embodiment of the present invention, as shown in fig. 2, the method mainly includes the following steps:
step 101, generating first time data according to current time information of a system.
Here, the drug management system can monitor the system time in real time, and can also monitor the current time of the system in sections according to a preset time acquisition frequency; if the real-time monitoring is carried out, the drug management system continuously acquires the real-time current time of the system as first time data, and if the real-time monitoring is carried out in a segmented mode, the drug management system acquires the system time once every a period of time as the first time data.
Step 102, marking a first medicine price adjustment record as a first price adjustment record, wherein a first preset price adjustment time field in the first medicine price adjustment list does not exceed first time data and a first actual price adjustment time field is empty.
Here, after obtaining the first time data each time, the drug management system searches whether a first drug price adjustment record exists in the first drug price adjustment list mentioned in the first embodiment, where the first drug price adjustment record is to be used for starting price adjustment processing; the specific determination method is to compare the first time data with a first preset price-adjusting time field of the first medicine price-adjusting record, and if the current time, that is, the first time data, has reached or exceeded the first preset price-adjusting time field of the first medicine price-adjusting record, it indicates that the current first medicine price-adjusting record should be started for corresponding price-adjusting processing, and then the medicine management system will complete automatic price-adjusting processing through the subsequent step 103 and 105. As can be seen from the analysis of the first embodiment, the first price adjustment records conforming to the time judgment, that is, the number of the first price adjustment records, may not be unique, and in the case of the non-unique records, the drug management system may complete the automatic price adjustment process for each first price adjustment record by repeating or executing the subsequent steps 103 and 105 in parallel.
103, according to the first time data, carrying out actual price adjusting time modification processing on the first price adjusting record;
the method specifically comprises the following steps: and setting a first actual price-adjusting time field of the first price-adjusting record according to the first time data.
Here, as described in the first embodiment of the present invention, each first pacing record has its first actual pacing time field empty before the pacing process is not performed, and when the automatic pacing process is started for the current first pacing record, it is necessary to set its first actual pacing time field to the starting time of the automatic pacing, that is, the first time data. That is, the only difference between the first tuning record before modification and the first tuning record after modification is that the first actual tuning time field changes from null to an actual time information.
Step 104, adjusting the price of the drug inventory record and recording the price adjustment profit and loss according to the modified first price adjustment record;
here, the current step is a processing procedure of adjusting each price field of the drug inventory record corresponding to the price adjustment record in the first drug inventory list mentioned in the first embodiment of the present invention based on the modified first price adjustment record, and a generation processing procedure of the price adjustment profit and loss record according to a profit and loss record adding/canceling mode preset by the system;
the method specifically comprises the following steps: step 1041, adjusting the price of the drug inventory record according to the modified first price adjustment record;
here, a processing procedure of adjusting each price field of the drug inventory record corresponding to the price adjustment record in the first drug inventory list mentioned in the first embodiment of the present invention;
the method specifically comprises the following steps: step 10411, first, according to the second drug code field, the second basic specification field, the second package specification field and the second manufacturer field of the modified first price adjustment record, querying the first drug inventory list, and marking the matched first drug inventory record as a third current record;
here, the drug management system queries the first drug inventory list through the second drug code field, the second base specification field, the second package specification field and the second manufacturer field of the first price adjustment record, and takes the first drug inventory record in which the first drug code field in the first drug inventory list is matched with the second drug code field, the first base specification field is matched with the second base specification field, the first package specification field is matched with the second package specification field, and the first manufacturer field is matched with the second manufacturer field as the matched first drug inventory record, and marks the first drug inventory record as a third current record for the subsequent steps;
step 10412, setting the first wholesale price field of the third current record according to the modified first current wholesale price field of the first price adjustment record;
here, according to the modified wholesale price adjusting information of the first price adjusting record, namely the first current wholesale price field, price adjustment is carried out on the wholesale price information of the third current record, namely the first wholesale price field;
step 10413, setting the first retail price field of the third current record according to the first current retail price field of the modified first tuning record;
here, according to the modified retail price adjusting information of the first adjusting record, namely the first current retail price field, the price of the third current recorded retail price information, namely the first retail price field, is adjusted;
step 10414, identifying a preset purchase price adjusting mode, and if the purchase price adjusting mode is an equivalent wholesale price mode such as a purchase price, setting a first purchase price field of a third current record according to the modified first current wholesale price field of the first adjusting record;
here, the purchase price adjusting mode is a preset system parameter, and the purchase price adjusting mode comprises two setting modes, namely a wholesale price mode with the same purchase price and a wholesale price mode with the same purchase price;
if the purchase price is not equal to the wholesale price mode, it indicates that the third currently recorded purchase price information does not need to be modified, and in this case, the drug management system directly goes to step 1042 to continue the subsequent steps;
if the purchase price is equal to the wholesale price mode, it indicates that the purchase price information of the third current record needs to be modified and is equal to the latest wholesale price information, under this condition, the drug management system performs price adjustment on the purchase price information of the third current record, namely the first purchase price field, according to the modified wholesale price adjustment information of the first price adjustment record, and then turns to the step 1042 to continue the subsequent steps after the price adjustment is completed;
step 1042, after the adjustment processing of the drug inventory record price is completed, adjusting the price, profit and loss record processing according to the third current record and the modified first price adjusting record;
here, the generation processing procedure of the price-adjusting profit-loss record is carried out according to the profit-loss record adding/canceling mode preset by the system;
the method specifically comprises the following steps: step 10421, identifying a preset profit and loss record adding/canceling mode; if the profit-loss record adding/canceling mode is the adding mode, go to step 10422; if the profit-loss record adding/canceling mode is the canceling mode, go to step 105;
here, the profit-loss record adding/canceling mode is a preset system parameter, and the profit-loss record adding/canceling mode includes two setting modes of an adding mode and a canceling mode;
if the current automatic price adjustment mode is the adding mode, a corresponding first price adjustment profit and loss record needs to be added to the current automatic price adjustment process, and the relationship between the before and after profit and loss generated on the wholesale price and the retail price based on the current price adjustment operation is reflected; in this case, the drug management system proceeds to step 10422 for relevant processing;
if the automatic price adjustment mode is the cancellation mode, the corresponding first price adjustment profit and loss record does not need to be added to the current automatic price adjustment process; in this case, the drug management system will go directly to step 105 to continue the following steps;
step 10422, identifying whether the first number field of the third current record is empty, if not, going to step 10423; if the first quantity field is empty, go to step 105;
here, if the first quantity field of the third current record is 0 or null, it indicates that the record is actually a zero-stock record, and because profit and loss before and after the zero-stock record is adjusted are zero and have no practical use, the drug management system may give up executing the profit and loss record generation processing procedure of the subsequent step 10423, and instead, go to step 105 to continue the subsequent steps;
step 10423, performing price adjustment profit and loss record generation processing according to the third current record and the modified first price adjustment record to obtain a corresponding first price adjustment profit and loss record, and storing the first price adjustment profit and loss record into a preset first price adjustment profit and loss list;
the first price adjustment profit and loss list comprises a plurality of first price adjustment profit and loss records; the first adjusting price profit and loss record at least comprises a third basic field set, a second number field, a second purchasing price field, a second original wholesale price field, a second original retail price field, a second current wholesale price field, a second current retail price field, a second actual adjusting time field, a first wholesale price profit and loss field and a first retail price profit and loss field; the third basic field set comprises a third name field, a third medicine code field, a third basic specification field, a third packaging specification field, a third manufacturer field and a third packaging coefficient field;
the first price adjustment profit and loss list is used for storing first price adjustment profit and loss records capable of embodying the relation between the profit and loss before and after price adjustment; each first price adjustment profit and loss record corresponds to a first medicine price adjustment record, and naturally corresponds to a first medicine inventory record;
in the first price adjustment profit-loss record, the third basic field set is consistent with the first basic field set of the corresponding first drug inventory record, and can comprise contents such as a basic unit field, a packaging unit field, a drug batch number field, a drug validity period field, a warehouse code word segment and the like besides a basic name field, a drug code field, a basic specification field, a packaging specification field, a manufacturer field and a packaging coefficient field; the second quantity field is consistent with the first quantity field of the corresponding first drug inventory record; the second purchase price field is consistent with the first purchase price field of the corresponding first drug inventory record;
the second original wholesale price field, the second original retail price field, the second current wholesale price field, the second current retail price field and the second actual price adjusting time field are respectively consistent with the first original wholesale price field, the first original retail price field, the first current wholesale price field, the first current retail price field and the first actual price adjusting time field of the corresponding first medicine price adjusting record;
in addition, the first price-adjusting profit-loss record can further comprise a second generation time field for storing the current profit-loss record generation time, a first sequence number field for storing the sequence number identification, and the like;
the method specifically comprises the following steps: step S1, setting a third basic field set of the first price-adjusting profit-loss record according to the first basic field set of the third current record;
here, as can be seen from the above analysis of the content of the first price adjustment profit-and-loss record, the third basic field set of the first price adjustment profit-and-loss record is copied from the first basic field set of the third current record;
step S2, setting a second quantity field of the first price adjustment profit and loss record according to the first quantity field of the third current record;
here, as can be seen from the above analysis of the content of the first price adjustment profit-and-loss record, the second quantity field of the first price adjustment profit-and-loss record is copied from the first quantity field of the third current record;
step S3, setting a second purchase price field of the first price adjustment profit and loss record according to the first purchase price field of the third current record;
here, as can be seen from the above analysis of the content of the first price adjustment profit and loss record, the second purchase price field of the first price adjustment profit and loss record is copied from the first purchase price field of the third current record;
step S4, setting a second original wholesale price field of the first price adjustment profit-loss record according to the first original wholesale price field of the modified first price adjustment record;
here, as can be seen from the above analysis of the content of the first price adjustment profit and loss record, the second original wholesale price field of the first price adjustment profit and loss record is copied from the first original wholesale price field of the modified first price adjustment record;
step S5, setting a second original retail price field of the first price adjustment profit and loss record according to the first original retail price field of the modified first price adjustment record;
here, as can be seen from the above analysis of the content of the first adjusted price profit and loss record, the second original retail price field of the first adjusted price profit and loss record is copied from the first original retail price field of the modified first adjusted price record;
step S6, setting a second current wholesale price field of the first price adjustment profit-loss record according to the first current wholesale price field of the modified first price adjustment record;
here, as can be seen from the above analysis of the content of the first price adjustment profit and loss record, the second current wholesale price field of the first price adjustment profit and loss record is copied from the first current wholesale price field of the modified first price adjustment record;
step S7, setting a second current retail price field of the first price adjustment profit and loss record according to the first current retail price field of the modified first price adjustment record;
here, as can be seen from the above analysis of the content of the first price adjustment profit and loss record, the second current retail price field of the first price adjustment profit and loss record is copied from the first current retail price field of the modified first price adjustment record;
step S8, setting a second actual price-adjusting time field of the first price-adjusting profit-loss record according to the first actual price-adjusting time field of the modified first price-adjusting record;
here, as can be seen from the above analysis of the content of the first price adjustment profit and loss record, the second actual price adjustment time field of the first price adjustment profit and loss record is copied from the first actual price adjustment time field of the modified first price adjustment record;
step S9, calculating a third data (second current wholesale price field-second original wholesale price field) and a fourth data (second current retail price field-second original retail price field) and a second quantity field;
the third data is a wholesale total price profit and loss calculation result before and after the price adjustment corresponding to the current price adjustment profit and loss record, and the fourth data is a retail total price profit and loss calculation result before and after the price adjustment corresponding to the current price adjustment profit and loss record;
for example, if a certain drug inventory records that the wholesale price before price adjustment is 10 yuan, the wholesale price after price adjustment is 9 yuan, and the stock before and after price adjustment is not 8, the third data is (9-10) × 8 is-8, which means that the wholesale total price is lost by 8 yuan after the current price adjustment; the retail price before price adjustment of a certain medicine inventory record is 10 yuan, the retail price after price adjustment is 19 yuan, and the inventory amount before and after price adjustment is not 8, then the fourth data is (19-10) × 8 is 72, which means that the total retail price is increased by 72 yuan after the price adjustment;
step S10, setting a first wholesale price profit and loss field of the first price adjustment profit and loss record according to the third data;
the first wholesale price profit and loss field of the first price adjustment profit and loss record is used for storing wholesale total price profit and loss results before and after price adjustment corresponding to the current price adjustment profit and loss record;
and step 11, setting the first selling price profit and loss field of the first adjusting price profit and loss record according to the fourth data.
Here, the first retail price profit and loss field of the first price adjustment profit and loss record is used for storing retail total price profit and loss results before and after price adjustment corresponding to the current price adjustment profit and loss record.
In addition, if the first price adjustment profit-loss record further includes contents such as a second generation time field and a first sequence number field, the drug management system may acquire system time information of the profit-loss record to set the second generation time field, and acquire corresponding sequence number information to set the first sequence number field.
After completing the adjustment process of the drug inventory record price and the adjustment profit-loss record process, the drug management system updates the first price change list preset by the system through the subsequent step 105. The list is used for storing the price change history information of each item of medicine, and when a worker needs to look up the price change track of a certain item of medicine or all medicines, the worker does not need to search the medicine inventory list, so that the access pressure of the medicine inventory list can be reduced, and the efficiency of searching and retrieving can be improved.
Step 105, setting a preset first price change list according to the modified first price adjustment record;
the first price change list comprises a plurality of first price change records; the first price change record at least comprises a fourth basic field set, a second wholesale price field, a second retail price field, a first starting time field and a first ending time field; the fourth basic field set comprises a fourth medicine code field, a fourth basic specification field, a fourth packaging specification field, a fourth manufacturer field and a fourth packaging coefficient field;
here, the first price change list is used to store price change history information of the medicine; each first price change record is used for storing price change information of a certain specification of medicine;
in the first price change record, a fourth basic field set is used for storing basic information related to price change medicines, such as names, medicine codes, packaging specifications, manufacturers and the like; the second wholesale price field and the second retail price field are respectively used for storing the wholesale price and the retail price after the current price is changed; the first starting time field and the first ending time field are respectively used for storing the starting time and the ending time information of the current price holding time period;
because the same-specification medicine can have pricing in multiple stages, namely, the first price change records corresponding to the same-specification medicine in the first price change list can be multiple, but the current pricing of the first price change records can only be one, namely, the first cut-off time field of only one record in the multiple first price change records is empty;
the method specifically comprises the following steps: step 1051, according to the second medicine code field, the second package specification field and the second manufacturer field of the modified first price adjustment record, inquiring the first price change record in the first price change list to obtain a plurality of matched first price change records, and marking the first cut-off time field as a fourth current record;
the drug management system firstly inquires historical price change information matched with the modified first price adjustment record, namely the matched first price change record, in a first price change list, wherein the specific matching process is that the first price change record, which is matched with a fourth drug code field and a second drug code field of the modified first price adjustment record, is matched with a fourth packaging specification field and a second packaging specification field of the modified first price adjustment record, and is matched with a fourth manufacturer field and a second manufacturer field of the modified first price adjustment record, is used as the matched first price change record; the matched first price change records can be a plurality of records, but only one first cut-off time field is empty, so that the record with the first cut-off time field empty is selected from the plurality of matched first price change records as the executing price record, namely the fourth current record;
step 1052, setting a first cut-off time field of a fourth current record according to the first actual price-adjusting time field of the modified first price-adjusting record;
here, the medication management system converts the fourth current record from the executing price record to the historical price record that has ended by setting the contents of the first cutoff time field of the fourth current record from idle to the first actual price adjustment time field of the modified first price adjustment record;
then, the drug management system will create a first price change record through the following steps 1054 and 1058, configure the first price change record according to the information in the modified first price adjustment record, and set the first deadline field to be null, thereby generating a new record for representing the currently executed price information for the currently specified drug;
step 1053, adding a new first price change record in the first price change list;
here, the drug management system adds a new first price change record without content in the first price change list;
step 1054, according to the second basic field set of the modified first price adjustment record, setting a fourth basic field set of the new first price change record;
here, as can be seen from the above analysis of the content of the first price change record, the fourth basic field set of the new first price change record is copied from the second basic field set of the modified first price adjustment record;
step 1055, setting a second wholesale price field of the new first price change record according to the first current wholesale price field of the modified first price adjustment record;
here, as can be seen from the above analysis of the content of the first price change record, the second wholesale price field of the new first price change record is copied from the first current wholesale price field of the modified first price adjustment record;
step 1056, according to the first current retail price field of the modified first price adjustment record, setting a second retail price field of the new first price change record;
here, as can be seen from the above analysis of the content of the first price change record, the second retail price field of the new first price change record is copied from the first current retail price field of the modified first tuning record;
step 1057, according to the first actual price-adjusting time field of the modified first price-adjusting record, setting the first start time field of the new first price change record;
here, as can be seen from the above analysis of the content of the first price change record, the first start time field of the new first price change record is copied from the first actual price adjustment time field of the modified first price adjustment record;
step 1058 sets the first deadline field of the new first price change record to null.
Here, as is clear from the above analysis of the contents of the first price change record, the first expiration time field of the new first price change record needs to be empty because the new first price change record is used to represent the price information currently being executed.
In summary, the processing method for the price adjustment record provided by the second embodiment of the present invention can perform automatic unified price adjustment processing according to the generated price adjustment record of the medicine provided by the second embodiment of the present invention, and does not require any manual intervention by a worker, and particularly when processing large-batch centralized price adjustment of the medicine, the accuracy of price adjustment can be ensured, a large amount of manpower and material resources can be saved, and the efficiency can be improved; after the price adjustment is finished, a price change list is configured to store the information of each price adjustment, so that the traceability of the system to the historical price adjustment information is ensured; in addition, the second embodiment of the invention also provides an operation step of adjusting the purchase price according to the purchase price adjusting mode; in addition, the second embodiment of the present invention further provides a processing method for selecting whether to create a price adjustment profit-loss record according to the profit-loss record adding/canceling mode, and when a price adjustment profit-loss record is specifically created, a distinguishing process may be performed on a zero inventory record or a non-zero inventory record.
The method for processing the drug price adjustment records, provided by the embodiment of the invention, is characterized in that corresponding drug price adjustment records are generated in advance for each price adjustment, batch automatic price adjustment processing is carried out on drug inventory records according to the drug price adjustment records when the system time reaches the preset time, a price change list is used for storing the previous price adjustment track information when the price adjustment is processed, and in addition, more price adjustment modes and more convenient profit and loss statistical modes are added by configuring a purchase price adjustment mode and a profit and loss record adding/canceling mode. Therefore, the problems of low manual operation efficiency and easy error in the conventional method are solved, the data guarantee capability of the price-exchange operation is improved, and in addition, the intuitive profit-loss comparison and statistics functions before and after price exchange are provided.
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)

1. A method for processing a record of the adjustment of the price of a drug, the method comprising:
acquiring first medicine name data and first medicine manufacturer data;
inquiring the price adjustment attribute of the medicine corresponding to the first medicine name data;
if the query result is the unified price-adjusting attribute, in a preset first medicine inventory list, marking a first medicine inventory record with a first name field matched with the first medicine name data and a first manufacturer field matched with the first medicine manufacturer data as a first medicine record, and forming a first list by the obtained first medicine records;
taking one first medicine record which is selected by the user in the first list as a first medicine record;
acquiring price adjusting information set by the user for the first medicine record to generate a first price adjusting data set;
performing first medicine price adjustment record combination processing according to the first price adjustment data group and the first medicine record to generate a first medicine price adjustment record;
referring to the first medicine price adjustment record, performing unified price adjustment information setting on the rest first medicine records in the first list, and generating first medicine price adjustment records corresponding to the rest first medicine records;
and finally, storing all the obtained first medicine price adjustment records into a preset first medicine price adjustment list.
2. The method for processing a record of a price adjustment of a pharmaceutical product according to claim 1,
the first drug inventory list comprises a plurality of the first drug inventory records; the first drug inventory record comprises a first basic field set, a first quantity field, a first purchase price field, a first wholesale price field and a first retail price field; the first set of base fields includes at least the first name field, a first drug code field, a first base specification field, the first package specification field, the first vendor field, and the first package coefficient field;
the first medicine price adjustment list comprises a plurality of first medicine price adjustment records; the first medicine price adjusting record comprises a second basic field set, a first original wholesale price field, a first original retail price field, a first current wholesale price field, a first current retail price field, a first preset price adjusting time field and a first actual price adjusting time field; the second basic field set at least comprises a second name field, a second medicine code field, a second basic specification field, a second package specification field, a second manufacturer field and a second package coefficient field;
the first price adjusting data group comprises first medicine wholesale price adjusting data, first medicine retail price adjusting data and first medicine price adjusting preset time data.
3. The method for processing the drug price adjustment record according to claim 2, wherein the performing a first drug price adjustment record combination process according to the first price adjustment data group and the first drug record to generate a first drug price adjustment record specifically includes:
setting the second basic field set of the first drug price adjustment record according to the first basic field set of the first drug record;
setting the first original wholesale price field of the first medicine price adjustment record according to the first wholesale price field of the first medicine record;
setting the first original retail price field of the first medicine price adjustment record according to the first retail price field of the first medicine record;
setting the first current wholesale price field of the first medicine price adjustment record according to the first medicine wholesale price adjustment data of the first price adjustment data group;
setting the first current retail price field of the first medicine price adjustment record according to the first medicine retail price adjustment data of the first price adjustment data group;
setting the first preset price adjusting time field of the first medicine price adjusting record according to the first medicine price adjusting preset time data of the first price adjusting data group;
setting the first actual price-adjusting time field of the first medicine price-adjusting record to be null.
4. The method for processing a drug price adjustment record according to claim 2, wherein the referring to the first drug price adjustment record, performing uniform price adjustment information setting on the remaining first drug records in the first list, and generating the first drug price adjustment records corresponding to the remaining first drug records specifically includes:
extracting the first current wholesale price field as first wholesale price reference data, the first current retail price field as first retail price reference data, the second packaging system number field as first coefficient reference data and the first preset price adjusting time field as first time reference data from the first medicine price adjusting record;
polling all first drug records in the first list except the first drug record; recording the first drug record which is polled currently as a first current record; initializing the first medicine price adjustment record corresponding to the first current record, and recording as a second current record; setting the second basic field set of the second current record according to the first basic field set of the first current record; setting the first original wholesale price field of the second current record according to the first wholesale price field of the first current record; setting the first original retail price field of the second current record according to the first retail price field of the first current record; extracting the first packaging coefficient field from the first current record as first packaging coefficient data, calculating first price data as first wholesale price reference data as first packaging coefficient data/first coefficient reference data, calculating second price data as first retail price reference data as first packaging coefficient data/first coefficient reference data, setting the first current wholesale price field of the second current record according to the first price data, and setting the first current retail price field of the second current record according to the second price data; setting the first preset price-adjusting time field of the second current record according to the first time reference data; and setting the first actual tune away time field of the second current record to null.
5. The method for processing a record of adjusting the price of a drug according to claim 2, wherein when the record of adjusting the price of a drug is used for adjusting the price, the method further comprises:
generating first time data according to current time information of the system;
marking the first medicine price adjusting record in which the first preset price adjusting time field in the first medicine price adjusting list does not exceed the first time data and the first actual price adjusting time field is empty as a first price adjusting record;
according to the first time data, carrying out actual price adjusting time modification processing on the first price adjusting record;
then according to the modified first price adjustment record, carrying out price adjustment processing and price adjustment profit and loss recording processing on the drug inventory record;
and setting a preset first price change list according to the modified first price adjustment record.
6. The method for processing a record of adjusting a price of a drug according to claim 5, wherein the actual time modification processing of adjusting the price of the first record of adjusting the price according to the first time data specifically comprises:
and setting the first actual price-adjusting time field of the first price-adjusting record according to the first time data.
7. The method for processing the record of the adjusted price of the pharmaceutical product according to claim 5, wherein the adjusting the price of the record of the pharmaceutical product and the record of the adjusted price, profit and loss are performed according to the modified first adjusted price record, specifically comprising:
adjusting the price of the drug inventory record according to the modified first price adjustment record; firstly, inquiring the first drug inventory list according to the second drug code field, the second basic specification field, the second packaging specification field and the second manufacturer field of the modified first price adjustment record, and marking the matched first drug inventory record as a third current record; then setting the first wholesale price field of the third current record according to the first current wholesale price field of the modified first price adjustment record; then setting the first retail price field of the third current record according to the first current retail price field of the modified first price adjusting record; identifying a preset purchase price adjusting mode, and if the purchase price adjusting mode is an equivalent wholesale price mode of a purchase price, setting the first purchase price field of the third current record according to the first current wholesale price field of the modified first adjusting record;
after the adjustment processing of the drug inventory record price is completed, carrying out price adjustment profit and loss record processing according to the third current record and the modified first price adjustment record; firstly, identifying a preset profit and loss record adding/canceling mode; and if the profit-loss record adding/canceling mode is an adding mode, identifying whether the first quantity field of the third current record is empty, if the first quantity field is not empty, performing price adjustment profit-loss record generation processing according to the third current record and the modified first price adjustment record to obtain a corresponding first price adjustment profit-loss record, and storing the first price adjustment profit-loss record into a preset first price adjustment profit-loss list.
8. The method for processing a record of a price adjustment of a pharmaceutical product according to claim 7,
the first price adjustment profit and loss list comprises a plurality of first price adjustment profit and loss records; the first adjusting price profit and loss record at least comprises a third basic field set, a second number field, a second purchase price field, a second original wholesale price field, a second original retail price field, a second current wholesale price field, a second current retail price field, a second actual adjusting time field, a first wholesale price profit and loss field and a first retail price profit and loss field; the third set of base fields includes a third name field, a third drug code field, a third base specification field, a third package specification field, a third vendor field, and a third package coefficient field.
9. The method for processing the record of adjusting the price of the medicine according to claim 8, wherein performing record generation processing of adjusting the price for profit and loss according to the third current record and the modified first record of adjusting the price for profit and loss to obtain a corresponding record of adjusting the price for profit and loss specifically comprises:
setting the third basic field set of the first price adjustment profit-loss record according to the first basic field set of the third current record;
setting the second quantity field of the first price adjustment profit-loss record according to the first quantity field of the third current record;
setting the second purchase price field of the first price adjustment profit and loss record according to the first purchase price field of the third current record;
setting the second original wholesale price field of the first price adjustment profit-loss record according to the first original wholesale price field of the modified first price adjustment record;
setting the second original retail price field of the first price adjustment profit-loss record according to the first original retail price field of the modified first price adjustment record;
setting the second current wholesale price field of the first price adjustment profit-loss record according to the first current wholesale price field of the modified first price adjustment record;
setting the second current retail price field of the first price adjustment profit-loss record according to the first current retail price field of the modified first price adjustment record;
setting the second actual price adjusting time field of the first price adjusting profit-loss record according to the first actual price adjusting time field of the modified first price adjusting record;
calculating a third data (a second current wholesale price field-a second original wholesale price field) and a second quantity field, and a fourth data (a second current retail price field-a second original retail price field) and a second quantity field;
setting the first wholesale price profit and loss field of the first price adjustment profit and loss record according to the third data;
and setting the first retail price profit and loss amount field of the first price adjustment profit and loss record according to the fourth data.
10. The method for processing a record of adjusting prices of drugs according to claim 5, wherein the setting of the preset first price change list according to the modified first record of adjusting prices specifically comprises:
inquiring first price change records in the first price change list according to the second medicine code field, the second package specification field and the second manufacturer field of the modified first price adjustment record to obtain a plurality of matched first price change records, and marking the first cut-off time field as a fourth current record, wherein the first cut-off time field is empty; wherein the first price change list comprises a plurality of first price change records; the first price change record at least comprises a fourth basic field set, a second wholesale price field, a second retail price field, a first starting time field and a first cut-off time field; the fourth basic field set comprises a fourth drug code field, a fourth basic specification field, a fourth packaging specification field, a fourth manufacturer field and a fourth packaging coefficient field;
setting a first cut-off time field of the fourth current record according to the first actual price-adjusting time field of the modified first price-adjusting record;
adding a new first price change record in the first price change list;
setting the fourth basic field set of the new first price change record according to the second basic field set of the modified first price change record;
setting the second wholesale price field of the new first price change record according to the first current wholesale price field of the modified first price adjustment record;
setting the second retail price field of the new first price change record according to the first current retail price field of the modified first price adjustment record;
setting the first starting time field of the new first price change record according to the first actual price adjusting time field of the modified first price adjusting record;
setting the first expiration time field of the new first price change record to null.
CN202110707574.2A 2021-06-24 2021-06-24 Processing method of medicine price adjustment record Active CN113536062B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110707574.2A CN113536062B (en) 2021-06-24 2021-06-24 Processing method of medicine price adjustment record

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110707574.2A CN113536062B (en) 2021-06-24 2021-06-24 Processing method of medicine price adjustment record

Publications (2)

Publication Number Publication Date
CN113536062A true CN113536062A (en) 2021-10-22
CN113536062B CN113536062B (en) 2024-06-11

Family

ID=78096723

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110707574.2A Active CN113536062B (en) 2021-06-24 2021-06-24 Processing method of medicine price adjustment record

Country Status (1)

Country Link
CN (1) CN113536062B (en)

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2003118840A (en) * 2001-10-17 2003-04-23 Zoo Corp Pharmaceutical storing and selling management method and its system
US20030105683A1 (en) * 2001-11-01 2003-06-05 Fratarcangeli Frank M. Method of ordering pharmaceutical and vaccine products
US20120203645A1 (en) * 2011-02-09 2012-08-09 Strategic Pharmaceutical Solutions, Inc. Computer-enabled method and system for automated application, determination and distribution of taxes and fees on the sale of products for animals
US8380532B1 (en) * 2009-09-09 2013-02-19 Returns R Us, Inc. Method and apparatus for accurate price estimation in reverse distribution of pharmaceutical items
KR20190132953A (en) * 2018-05-21 2019-11-29 주식회사 은성 Sales managing method for medicine, Computer program for the same, and Recording medium storing computer program for the same
CN110580145A (en) * 2018-06-07 2019-12-17 珠海横琴盛达兆业科技投资有限公司 Method for realizing batch price adjustment of medicines and having available document to be checked by B/S architecture-based pharmacy system
CN112307036A (en) * 2020-12-22 2021-02-02 北京天健源达科技股份有限公司 Method for inputting medicine information record into medicine database
CN112667645A (en) * 2021-01-22 2021-04-16 北京天健源达科技股份有限公司 Method for processing sent medicine record

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2003118840A (en) * 2001-10-17 2003-04-23 Zoo Corp Pharmaceutical storing and selling management method and its system
US20030105683A1 (en) * 2001-11-01 2003-06-05 Fratarcangeli Frank M. Method of ordering pharmaceutical and vaccine products
US8380532B1 (en) * 2009-09-09 2013-02-19 Returns R Us, Inc. Method and apparatus for accurate price estimation in reverse distribution of pharmaceutical items
US20120203645A1 (en) * 2011-02-09 2012-08-09 Strategic Pharmaceutical Solutions, Inc. Computer-enabled method and system for automated application, determination and distribution of taxes and fees on the sale of products for animals
KR20190132953A (en) * 2018-05-21 2019-11-29 주식회사 은성 Sales managing method for medicine, Computer program for the same, and Recording medium storing computer program for the same
CN110580145A (en) * 2018-06-07 2019-12-17 珠海横琴盛达兆业科技投资有限公司 Method for realizing batch price adjustment of medicines and having available document to be checked by B/S architecture-based pharmacy system
CN112307036A (en) * 2020-12-22 2021-02-02 北京天健源达科技股份有限公司 Method for inputting medicine information record into medicine database
CN112667645A (en) * 2021-01-22 2021-04-16 北京天健源达科技股份有限公司 Method for processing sent medicine record

Non-Patent Citations (9)

* Cited by examiner, † Cited by third party
Title
M. AZHAGIRI 等: "Secured Electronic Health Record Management System", 2018 3RD INTERNATIONAL CONFERENCE ON COMMUNICATION AND ELECTRONICS SYSTEMS (ICCES), 30 March 2019 (2019-03-30), pages 915 - 919 *
QAZWYC: "数据库设计——医药销售管理系统", pages 1, Retrieved from the Internet <URL:https://blog.csdn.net/qazwyc/article/details/59731125> *
SHAIMAA K. AHMED 等: "Design and Implementation of a Computerized Drug Inventory Management Information System Using ASP.NET MVC", DIYALA JOURNAL OF ENGINEERING SCIENCES, no. 4, 9 December 2020 (2020-12-09), pages 80 - 89 *
任智文;: "医院信息系统中的药库管理", 西部医学, no. 06, 20 June 2009 (2009-06-20), pages 1012 - 1013 *
朱敏文 等: "医院药品管理信息系统应用问题之探讨", 中国现代医学杂志, no. 14, 11 February 2005 (2005-02-11), pages 147 - 148 *
王子懿: "医院药房管理系统的设计与实现", 中国优秀硕士学位论文全文数据库信息科技辑, no. 4, 15 April 2018 (2018-04-15), pages 138 - 875 *
穆尼拉・塔西买买提;: "计算机信息网络系统在医院药品管理系统中的应用", 科技传播, no. 04, 23 February 2011 (2011-02-23), pages 246 - 247 *
范树德;: "应用编程的方法提高药品调价效率", 中国社区医师(医学专业), no. 08, 23 April 2013 (2013-04-23), pages 381 *
韩荣慧 等: "浅谈计算机网络管理在医院药剂科的应用", 天津药学, no. 01, 28 February 2010 (2010-02-28), pages 75 - 76 *

Also Published As

Publication number Publication date
CN113536062B (en) 2024-06-11

Similar Documents

Publication Publication Date Title
US8706561B2 (en) Product common object
US7765127B2 (en) System for processing product information in support of commercial transactions
US6549906B1 (en) System and method for electronic data retrieval and processing
US20100280912A1 (en) Online marketplace management system with automated pricing tool
CN112307036B (en) Method for inputting medicine information record into medicine database
US20040088334A1 (en) System and method for generating reports for a versioned database
US20080189195A1 (en) System and method for account reconciliation
CN112513912A (en) Method for updating food item information
US20030074349A1 (en) Method and apparatus for displaying real-time status of product availability, orders, and sales revenue
US7258266B1 (en) Defining, administering, and managing automatic identification information, such as bar codes
CN107451846A (en) The management method and managing device of business rule
CN113536062B (en) Processing method of medicine price adjustment record
US20030046262A1 (en) Method and system for making production plan
JP2004287833A (en) Dispensing work support system, medicine storage system and medicine distribution management system
US20150052028A1 (en) Systems and Methods for Recommending Providers and for Processing Product Inventories of Providers
US7337029B2 (en) Design data management system and trace system
CN116402437A (en) Batch management method, device, equipment and storage medium
CN116775956A (en) Method, device, equipment and storage medium for creating multi-level BOM model
JP2004295257A (en) Order proposing method through computer network, order proposing program and computer readable medium
JP4855326B2 (en) Code management system and code management method
JP6397657B2 (en) Requirements calculation system, requirements calculation method and program
US20150066565A1 (en) Systems and methods for managing an inventory of component parts
US20020169646A1 (en) Planning and administrating a manufacturing plant
CN107832430A (en) A kind of medicine information storage method based on Internet of Things
US20110153468A1 (en) Inventory management system and method

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