CN106485042A - Traditional Chinese Medicine Diagnosis System Based on Visual FoxPro - Google Patents

Abstract

The invention discloses a traditional Chinese medicine diagnosis system based on Visual FoxPro. The Visual FoxPro-based traditional Chinese medicine diagnosis system belongs to the field of computer and traditional Chinese medicine diagnosis, and is a system combining computer technology with traditional Chinese medicine diagnosis. This system uses the database of the Visual FoxPro system and its own programming function to complete the construction and realization of the traditional Chinese medicine diagnosis system, which is a good solution to the current many traditional Chinese medicine diagnoses caused by manual methods. The downside of not being able to save this permanently. It enables the inheritance and inheritance of the essence of traditional Chinese medicine, provides diagnostic experience and basis for future generations, and also provides a good platform for the research and development of new prescriptions.

Description

based on Visual FoxPro traditional Chinese medicine diagnosis system

technical field

The invention belongs to the fields of computer and traditional Chinese medicine diagnosis, and specifically relates to a traditional Chinese medicine diagnosis system based on Visual FoxPro.

Background technique

At present, many traditional Chinese medicine diagnoses are mostly carried out manually, and the records of illnesses are not standardized and complete, and the contents of patient records cannot be permanently preserved. In addition, it is not conducive to the revision of patient prescriptions, let alone the research and development of new prescriptions.

Contents of the invention

The present invention provides a traditional Chinese medicine diagnostic system based on Visual FoxPro, which includes a client, a server and processing controls: the client includes input controls, data collection controls, data preprocessing controls, data analysis controls, data integration and sending controls ; The client can be set up on desktop computers, notebook computers and smart phones; the server includes data acceptance and temporary storage, combination analyzer, database module, evaluator, data storage module, data transmission control; a server Several clients can be connected; the processing control includes storage control, display, printing control and network control; the system also includes three tables: patient table, prescription table and prescription table, these three tables are the tables used in the database , the realization of the system is based on these three tables; the realization of the system is to use Visual FoxPro system to complete the form.

Tables in the database include:

Patient information, including patient number, name, age, home address, past medical history, contact number), where the patient's number is used as a key attribute;

Prescription information, including prescription number, prescription name, prescription function, price, where prescription number is the key attribute;

Prescription information, including patient number, prescription number, dose, prescription time, total price), where patient number and prescription number are key attributes.

The system also includes an information entry module, a disease diagnosis module, an information query module, and a data statistics module.

Description of drawings

Fig. 1 is the E-R diagram of the relationship among tables between the patient table, the prescription table and the prescription table among the present invention;

Figure 2 is a picture of the basic situation of the patient;

Fig. 3 is a diagnosis result processing diagram;

Fig. 4 is a prescription query diagram.

detailed description

The present invention provides a traditional Chinese medicine diagnostic system based on Visual FoxPro, which includes a client, a server and processing controls: the client includes input controls, data collection controls, data preprocessing controls, data analysis controls, data integration and sending controls ; The client can be set up on desktop computers, notebook computers and smart phones; the server includes data acceptance and temporary storage, combination analyzer, database module, evaluator, data storage module, data transmission control; a server Several clients can be connected; the processing control includes storage control, display, printing control and network control; the system also includes three tables: patient table, prescription table and prescription table, these three tables are the tables used in the database , the realization of the system is based on these three tables; the realization of the system is to use Visual FoxPro system to complete the form.

Tables in the database include:

Patient information, including patient number, name, age, home address, past medical history, contact number), where the patient's number is used as a key attribute;

Prescription information, including prescription number, prescription name, prescription function, price, where prescription number is the key attribute;

Prescription information, including patient number, prescription number, dose, prescription time, total price), where patient number and prescription number are key attributes.

The system also includes an information entry module, a disease diagnosis module, an information query module, and a data statistics module.

The rapid development and popularization of computer science and technology has provided technical support for traditional Chinese medicine diagnosis, and the establishment of a digital Chinese medicine diagnosis system is also the general trend, and it is also a good way to solve the innovation and inheritance of Chinese medicine. This article is based on this idea to establish a Visual FoxPro traditional Chinese medicine diagnosis system.

visual FoxPro is a database product, which is welcomed by users for its powerful performance, complete and rich tools, high processing speed, friendly user interface and complete compatibility. As a relational database product, Visual FoxPro provides an integrated system development environment, which makes the organization and operation of data easy and convenient. It has made a powerful expansion in the language system, not only supports traditional structured programming, but also supports object-oriented programming, and has a powerful visual programming tool.

1. Database design

The design of the database plays an important role in the diagnosis system of traditional Chinese medicine. There are 3 tables in this system, namely patient, prescription and prescription. The E-R diagrams of the three tables are shown in Figure 1.

There is a many-to-many relationship between the patient entity and the prescription entity. The two entities are connected through the prescription, so there are three relationships:

Patient (patient number, name, age, home address, past medical history, contact number), where the patient's number is used as a key attribute

Prescription (prescription number, prescription name, prescription function, price), where the prescription number is the key attribute

Prescription (Patient ID, Prescription ID, Dosage, Prescription Time, Total Price), with Patient ID and Prescription ID as key attributes

The various data table structures in the database are as follows:

(1) Patient's basic information table

Table 1-Basic information table of patients

(2) prescription list

Table 2 - Prescription Table

(3) prescription form

Table 3 - Prescription Form

2. Functions of traditional Chinese medicine diagnosis system based on Visual FoxPro include:

(1) Information entry

Information entry includes doctor-patient information entry and prescription entry. The patient's information entry mainly includes the patient's name, gender, age, past medical history, home address and contact information. Prescription entry includes the entry of traditional Chinese medicine classic prescriptions and innovative prescriptions - the entry of self-made prescriptions. Establish a complete information system through information entry to facilitate the development of subsequent work.

(2) Disease diagnosis

Disease diagnosis is a doctor's diagnosis through observation, smell, questioning, and palpation. At the same time, he conducts syndrome differentiation and treatment based on blood pressure, electrocardiogram, and CT and other relevant information provided by the hospital, and finally gives a diagnostic conclusion and prescribes a prescription.

(3) Information query

Information query includes patient information query and prescription information query. The patient's information query mainly includes the patient's name, gender, age, past medical history, home address, contact information, diagnosis information of this medical visit, diagnosis result and prescription issuance, etc. Prescription information query is to query the composition of the prescription and the price of the prescription.

(4) Statistics

Data statistics can be counted according to different requirements. If the statistics are made by the name of the disease, the purpose is to make a decision on which disease has a higher incidence in the recent period; it can also be counted by region to see which region has a higher incidence of which disease , find out the corresponding reason and solve it.

The realization of traditional Chinese medicine diagnosis system based on Visual FoxPro is based on Visual Under the FoxPro system environment. The Visual FoxPro system is not only a database system, but also has its own programming environment, which is very suitable for traditional Chinese medicine diagnosis. The specific system implementation is as follows:

1 information entry

Information entry includes patient information entry and prescription entry. The implementation of the patient information input interface is shown in Figure 2.

The basic information of all patients can be displayed through the "Display" button; the information of a single person can be displayed through the "Search" button; the information of a new patient can be added through the "Add" button; part of the information of some patients can be modified through the "Modify" button ; "Delete" can delete a patient's information; "Save" can save the modified or newly added records; "Exit" button completes the entry of the patient's basic information.

Prescription entry includes the composition entry of traditional Chinese medicine prescriptions and the entry of self-made prescriptions. The composition of the prescription is not static. According to the changes of time and environment, the composition of the prescription changes, and new prescriptions will appear. For example, before the Qing Dynasty, there were no prescriptions specifically for the treatment of cancer, but now this disease is more common, and because the location of the cancer is different, the medicines are different, so the number of prescriptions has to increase.

2 Disease diagnosis

Disease diagnosis is that doctors conduct syndrome differentiation and treatment by looking, smelling, asking, and making four diagnoses, together with the patient's current medical history and the results of examinations done in the hospital. The realization of this function is relatively complicated, mainly including the doctor's record of the patient's diagnosis process, diagnosis results and prescription. The implementation interface of diagnosis results and prescription issuance is shown in Figure 3.

3Information query

Information inquiry mainly includes patient information inquiry and prescription information inquiry. The patient's information query mainly includes the patient's name, gender, age, past medical history, home address, contact information, diagnosis information of this medical visit, diagnosis result and prescription issuance, etc. Prescription information query is to query the composition of the prescription and the price of the prescription. The realization interface of prescription information query is shown in Figure 4.

4 Statistics

Data statistics can be counted according to different requirements. If the statistics are carried out by the name of the disease, the purpose is to find out the reason for which disease has a higher incidence rate in the recent period, so that when the same patient comes to see a doctor, it can be quickly diagnosed and the doctor's diagnosis time can be reduced; it can also be classified by region Make statistics to see which area has a higher incidence of which disease, find out the corresponding reasons and solve them. The prescription can also be modified and improved through data statistics. The prescription cannot remain unchanged. With the changes of the environment, the weather, and the cycle of seasons throughout the year, the dosage of the prescription is different. In addition, new prescriptions will be produced. Due to changes in the environment, diseases that did not exist before are now appearing, such as cancer, Parkinson's syndrome, etc.

Claims (3)

1. the Traditional Chinese Medicine diagnostic system based on Visual FoxPro, comprises client, server and processes control：Described client comprises input control, data acquisition control, data pre-processing control, data analysiss control, Data Integration and sends control；Described client can be set up on desktop computer, notebook computer and smart mobile phone；Described server comprises data and accepts and buffer, combinative analysiss device, DBM, evaluator, data memory module, data is activation control；One server can connect some clients；Described process control comprises storage control, display, word depghi and GetIpUpDown；It is characterized in that：

Three tables that system also includes：Patient's table, prescription table and prescription table, this three tables are tables used in data base, based on the realization of system is by this three tables；The realization of system is to be completed using the list of Visual FoxPro system.

2. according to claim 1 based on Visual FoxPro Traditional Chinese Medicine diagnostic system it is characterised in that：Table in data base includes：

Patient information, it includes patient number, name, age, home address, medical history, telephone number）, the numbering of wherein patient is as determinant attribute；

Prescription information, it includes prescription numbering, prescription name, prescription function, price, and its prescription is numbered as determinant attribute；

Prescription information, it includes patient number, and prescription is numbered, and dosage is write a prescription the time, total price）, wherein patient number and prescription numbering are as determinant attribute.

3. according to claim 1 based on Visual FoxPro Traditional Chinese Medicine diagnostic system it is characterised in that：This system also includes Data Enter module, medical diagnosis on disease module, information inquiry module, data statistics module.