CN107301044B - Multi-page control for form of electronic medical record of metabolic disease - Google Patents
Multi-page control for form of electronic medical record of metabolic disease Download PDFInfo
- Publication number
- CN107301044B CN107301044B CN201710436536.1A CN201710436536A CN107301044B CN 107301044 B CN107301044 B CN 107301044B CN 201710436536 A CN201710436536 A CN 201710436536A CN 107301044 B CN107301044 B CN 107301044B
- Authority
- CN
- China
- Prior art keywords
- control
- page
- data
- page number
- design
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/20—Software design
- G06F8/24—Object-oriented
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Medical Treatment And Welfare Office Work (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a multi-page control for a form of an electronic medical record of metabolic diseases, which comprises a control form design unit, a data entry and storage unit and a data retrieval unit, wherein the control form design unit comprises basic attribute design, Interface design, view design and Wrapper adaptation; the control form design unit is used for designing a control form, each page is provided with the same template, and the content can be modified according to different page numbers; the data storage unit comprises primary storage and page number expansion, and the storage mode is that a corresponding table is independently established in a relational database; the data retrieval unit is used for retrieving the data source by using the view as a pointer in the data source according to the selected page number, so that the three functions of inputting, storing and retrieving are integrated into the same control, the storage space is saved, and the related records are conveniently filed and read.
Description
Technical Field
The invention relates to the technical field of medical treatment, in particular to a multi-page control for a form of an electronic medical record of metabolic diseases.
Background
In endocrine department wards or other departments (such as nephrology department) closely related to metabolic diseases, as the course of a patient is long, certain indexes need to be monitored regularly, if a series of records are added on a course record form every day, the course record can extend for a certain length, occupies a large number of pages in an electronic medical record, and is not beneficial to filing and reading the medical record.
Therefore, a control is needed to be developed, which can summarize and integrate the metabolic disease-related course records occupying a large space, and integrate the related course records into a whole, so that the related records can be conveniently filed and read.
Disclosure of Invention
Aiming at the problems in the background art, the invention aims to provide a multi-page control for an electronic medical record form of metabolic diseases, which integrates the functions of recording, storing and reading into a whole, saves the storage space and is convenient for filing and reading related records.
The technical scheme of the invention is realized as follows: the utility model provides a many pages of controls for metabolic disease electronic medical record form, includes control form design unit, data entry and memory cell and data retrieval unit, wherein, control form design unit: the method comprises basic attribute design, Interface design, view design and Wrapper adaptation; a control form design unit: the method is used for designing a control form, and the generated multi-page control has the same template on each page and can modify the content according to the difference of page numbers; a data storage unit: the method comprises primary storage and page number expansion, wherein the primary storage refers to that when a certain electronic medical record form is written into the multi-page control for the first time and stored, a table is independently established in a medical record file of a patient in a corresponding electronic medical record form relational database, data is stored in the table after being serialized, and a main key is a page number; the page number expansion means that the page number is increased along with the increase of the disease course record, and the page number is increased on the basis of the original table when a new disease course record is added each time; a data retrieval unit: setting the DefaultView of the control form in a control form design unit as a page number, and binding a pointer as the page number; when a user needs to retrieve the data in the control, the reader screens and retrieves the data source by using the View according to the input page number.
In the above technical solution, the basic attribute design includes a prescribed design of a FrontColor and a BackColor basic attribute.
In the technical scheme, the Interface design comprises three Interface specification designs of an iEmrControl Interface, an iParent Interface and an iChildren Interface.
In the above technical solution, the structure of the table is that the rows correspond to page numbers, and the columns correspond to child controls carried by the multi-page controls.
In the above technical solution, when the page number is expanded, a layer of data is added on the basis of the original table, the number of horizontal lines is increased, and the increased content is serialized and recorded in a specific horizontal line.
In the technical scheme, when the data is called, the data pointer points to the horizontal line corresponding to the input page number, the data of the line is called, and the line is covered on the multi-page control; when the horizontal line of the input page number is changed, the pointer moves to point to the newly input page number, so that the data of the line corresponding to the page number is called out and is given to the multi-page control.
The invention relates to a multi-page control for a form of an electronic medical record of metabolic diseases, which comprises a control form design unit, a data entry and storage unit and a data retrieval unit, wherein the control form design unit comprises basic attribute design, Interface design, view design and Wrapper adaptation; the control form design unit is used for designing a control form, each page is provided with the same template, and the content can be modified according to different page numbers; the data storage unit comprises primary storage and page number expansion, and the storage mode is that a corresponding table is independently established in a relational database; the data retrieval unit is used for retrieving the data source by using the view as a pointer in the data source according to the selected page number, so that the three functions of inputting, storing and retrieving are integrated into the same control, the storage space is saved, and the related records are conveniently filed and read.
Drawings
FIG. 1 is a general framework diagram of the present invention;
FIG. 2 is a flow chart of the design of a control attribute design unit according to the present invention;
FIG. 3 is a flow chart of the data storage unit of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and 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.
The multi-page control for the form of the electronic medical record of metabolic diseases has three interface specifications of an iEmrControl interface, an iParent interface and an iChildren interface, the storage mode is that a corresponding table is independently set in a relational database, and the retrieval mode is that a data source is screened by using view according to a selected page number as a pointer in the data source, so that the three functions of entry-storage-retrieval are integrated in the same control.
The system specifically comprises a control attribute design unit, a control form design unit, a data entry and storage unit and a data retrieval unit, wherein the overall framework is shown in fig. 1, and the following is a detailed description of the units:
(1) a control attribute design unit:
and the control attribute design unit is used for developing and adapting the control, stipulating various attributes of the control and adapting to the electronic medical record form designer. The control attribute design mainly comprises the following items: basic attribute design, Interface design, view design and Wrapper adaptation. The flow is shown in fig. 2.
a. Designing basic attributes: the multi-page control has the basic properties of FrontColor, BackColor and the like similar to other controls, and the control properties need to be specified in the design stage.
Interface design: the iEmrControl interface can be applied to the electronic medical record form designer, the iEmrControl interface can be used as a parent control to bear other controls to serve as the basis of the control form design, and the iChildren can be used as a child control to be borne by other parent controls.
c. And (3) view design: the data of the multi-page control is stored in a relational database, and the view is adopted for reading when the data is read, so that the DefaultView needs to be set when the multi-page control is designed, and the DefaultView is set as a page number.
Wrapper adaptation: after the properties and the interface of the controls are specified, the controls need to pass through a Wrapper control adapter and are registered in a dynamic link library file in the electronic medical record form designer, and the properties can be used for the electronic medical record form designer after being adapted.
(2) A control form design unit:
after the design of the control attribute design unit, the multi-page control can be applied to an electronic medical record form designer. When a metabolic disease course recording form of a specific department is developed, the control is called in a design module of an electronic medical record form designer and is based on the control. Other controls are called according to the specific record of metabolic diseases and are used as child controls of the multi-page control, so that the generated multi-page control has the same template on each page, and the content can be modified according to different page numbers.
(3) A data storage unit:
the data storage of the control is divided into two modes, namely primary storage and extended storage.
a. Primary storage: the primary storage refers to that when a certain electronic medical record form is written into the multi-page control for the first time and stored, the multi-page control independently establishes a table in a medical record file of the patient in a corresponding electronic medical record form database during storage, data is stored in a relational database, a main key is a page number, the table is constructed into a structure that a horizontal row corresponds to the page number, a vertical row corresponds to a sub-control carried by the multi-page control, and data is stored in the table after being serialized. The structure of the table is shown in the following table
b. Page number expansion: as the record of the disease course increases, the page number also increases. When a new course record is added each time, a new table is not created, but a layer of data is added on the basis of the original table, namely, the row number is increased, and the added content is recorded in a specific row after being serialized.
It should be noted that the columns of the stored data tables corresponding to different multi-page controls are different, depending on the child controls placed in the control form design. When the initial storage is carried out, the sub-controls in the multi-page control are established into columns one by one so as to store different data stored by the control in different pages. The flow is shown in fig. 3.
(4) A data retrieval unit:
the realization of the multi-page control data retrieval function is based on a core idea: when the control reads data, the spatial attribute of the control is not changed, but the data carried by the control is changed. The controls themselves act merely as containers, and can be given data from different data sources.
The data retrieval of the multi-page control is realized by View View, and the DefaultView of the control is set as a page number in the control form design unit, so that the pointer is bound as the page number. When a user needs to call and read data in the control, the reader screens a data source by using the View according to the input page number, the data pointer points to a transverse line corresponding to the input page number, the data of the line is called out, and the data is covered on the multi-page control.
When the horizontal line of the input page number is changed, the pointer moves to point to the newly input page number, so that the data of the line corresponding to the page number is called out, and the multi-page control is endowed.
The following is a further description taken in conjunction with a specific example:
after the control form design, the multi-page control is used for recording the diabetes course, and the multi-page control comprises blood sugar value, urine sugar detection, the diabetes course recording and the like. In the course of disease record of a certain patient, the blood sugar value recorded on the first page is 11.4mmol/L, the urine sugar is positive, and the course of disease record is slight.
When storing, firstly establishing a corresponding storage table in the database, taking each control as a column and taking a page number as a row, and recording the data structure stored for the first time as shown in the following table:
| Page | Textbox1_Blood | RadioButton1 | RadioButton2 | Richbox |
| 1 | 11.4 | True | False | |
the data recorded the next day is 8.9mmol/L, urine glucose is negative, the disease course is recorded slightly, page number expansion is carried out, one is added in the number of data layers, and the data are stored in the data layers as shown in the following table:
| Page | Textbox1_Blood | RadioButton1 | RadioButton2 | Richbox |
| 1 | 11.4 | True | False | |
| 2 | 8.9 | False | True | |
when the data is called, the data pointer points to the target page code value, the data of the layer is read, and the data is covered on the multi-page control.
To sum up: the multi-page control for the form of the electronic medical record of metabolic diseases has the following beneficial effects:
1. because the record of the course of a metabolic disease is longer, the index that needs to monitor is more, if pile up the record of the course of a metabolic disease in the course of a disease record form, will occupy considerable space, also do not benefit to the reading of user to other disease course records besides the metabolic disease simultaneously. The invention can integrate the metabolic disease course record and index monitoring into one control, and establishes tables in the database for structured storage aiming at different sub-controls, so that the attribute and data of the control are recorded without the need of appearing a new control, and the storage space is saved to a certain extent.
2. In departments of nephrology and the like, metabolic diseases are only one aspect of disease diagnosis and treatment, and main diseases need to be treated besides the metabolic diseases. If the course records of metabolic diseases are accumulated in the course records, the reading of the main course records of diseases is not facilitated. After the method and the device are adopted, the metabolic disease course records can be concentrated in one control, so that the sorting and filing of the metabolic disease course records are greatly facilitated, and the comparison between the metabolic disease course records in different periods and index monitoring is facilitated.
(3) In the control design link, the multi-page control can be used as a father control and a child control and can bear other controls, the course record of metabolic diseases usually needs to regularly monitor specific indexes, such as blood sugar, whether to take medicine and the like, and the content of the record needed by different metabolic diseases is different. The invention can add controls meeting the requirements of the course record in the multi-page controls according to the actual requirements of the specific metabolic disease course record, thereby developing targeted metabolic disease course record controls and having great flexibility.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (3)
1. A multi-page control for forms of an electronic medical record of metabolic disease, comprising: including control form design unit, data entry and memory cell and data retrieval unit, wherein: a control form design unit: the method comprises basic attribute design, Interface design, view design and Wrapper adaptation;
a control form design unit: the method is used for designing a control form, and the generated multi-page control has the same template on each page and can modify the content according to the difference of page numbers;
a data storage unit: the method comprises primary storage and page number expansion, wherein the primary storage refers to that when a certain electronic medical record form is written into the multi-page control for the first time and stored, a table is independently established in a corresponding electronic medical record form relational database, data are stored in the table after being serialized, and a main key is a page number; the page number expansion means that the page number is increased along with the increase of the disease course record, and the page number is increased on the basis of the original table when a new disease course record is added each time;
a data retrieval unit: setting the DefaultView of the control form in a control form design unit as a page number, and binding a pointer as the page number; when a user needs to retrieve the data in the control, the reader screens and retrieves the data source by using the View according to the input page number;
the structure of the table is that the horizontal rows correspond to page numbers, and the columns correspond to the sub-controls borne by the multi-page controls;
when the page number is expanded, adding a layer of data on the basis of the original table, increasing the row number, serializing the added content and recording the serialized content in a specific row;
when the data is read, the data pointer points to the horizontal line corresponding to the input page number, the data of the line is fetched out and covered on the multi-page control; when the horizontal line of the input page number is changed, the pointer moves to point to the newly input page number, so that the data of the line corresponding to the page number is called out and is given to the multi-page control.
2. The multi-page control for forms of electronic medical records of metabolic disorders of claim 1, wherein: the basic attribute design comprises a specified design of the basic attribute of FrontColor and BackColor.
3. The multi-page control for forms of electronic medical records of metabolic disorders of claim 1, wherein: the Interface design comprises three Interface specification designs of an iEmrControl Interface, an iParent Interface and an iChildren Interface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710436536.1A CN107301044B (en) | 2017-06-09 | 2017-06-09 | Multi-page control for form of electronic medical record of metabolic disease |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710436536.1A CN107301044B (en) | 2017-06-09 | 2017-06-09 | Multi-page control for form of electronic medical record of metabolic disease |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107301044A CN107301044A (en) | 2017-10-27 |
| CN107301044B true CN107301044B (en) | 2021-02-19 |
Family
ID=60136281
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710436536.1A Active CN107301044B (en) | 2017-06-09 | 2017-06-09 | Multi-page control for form of electronic medical record of metabolic disease |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107301044B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101727319A (en) * | 2009-12-09 | 2010-06-09 | 上海宝信软件股份有限公司 | Page-turning service-oriented data table control and implementation method thereof |
| CN103092612A (en) * | 2012-12-31 | 2013-05-08 | 深圳天珑无线科技有限公司 | Method and electronic device for achieving three dimensional (3D) desktop mapping of Android operating system |
| CN104992053A (en) * | 2015-06-17 | 2015-10-21 | 广州慧扬信息系统科技有限公司 | Method for automatic charging of additional items related in medical advice execution |
| CN105354281A (en) * | 2014-02-03 | 2016-02-24 | 株式会社隆创 | Image inspection apparatus and image inspection procedure |
| CN105740478A (en) * | 2016-03-25 | 2016-07-06 | 浪潮通用软件有限公司 | Non-refreshing table paging sorting achieving method and device |
| CN106202027A (en) * | 2016-08-12 | 2016-12-07 | 南京都昌信息科技有限公司 | A kind of Tibetan language electronic medical record system text editor |
Family Cites Families (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102291491B (en) * | 2011-08-18 | 2015-07-15 | 融创天下（上海）科技发展有限公司 | Form control and terminal equipment comprising same |
| CN103034917A (en) * | 2011-09-30 | 2013-04-10 | 西门子（中国）有限公司 | Device and method for designing material tracking system |
| CN102360296A (en) * | 2011-10-20 | 2012-02-22 | 北京金和软件股份有限公司 | WEB-based online form development tool |
| CN102541551B (en) * | 2011-12-26 | 2016-01-06 | 深圳联友科技有限公司 | A kind of easy-to-use page report design method and system |
| CN103077185B (en) * | 2012-12-18 | 2017-09-29 | 厦门雅迅网络股份有限公司 | A kind of method of object-based self-defined extension information |
| CN103246733A (en) * | 2013-05-13 | 2013-08-14 | 浪潮集团山东通用软件有限公司 | Dynamic form system based on metadata and generation method thereof |
| CN103295176A (en) * | 2013-05-14 | 2013-09-11 | 中标软件有限公司 | Electronic medical record editing method and system |
| CN103400008A (en) * | 2013-08-02 | 2013-11-20 | 浙江和仁科技有限公司 | Realization technology of temperature chart control software in electronic medical record system |
| CN104598437B (en) * | 2013-10-31 | 2018-05-11 | 蓝网科技股份有限公司 | The dynamic realizing method of header information in electronic health record |
| JP6397259B2 (en) * | 2014-08-08 | 2018-09-26 | キヤノン株式会社 | COMMUNICATION DEVICE, ITS CONTROL METHOD, AND PROGRAM |
| CN104267962A (en) * | 2014-10-09 | 2015-01-07 | 浪潮通用软件有限公司 | Interface UI (user interface) control configuration method based on description |
| CN104331854A (en) * | 2014-11-21 | 2015-02-04 | 浙江和仁科技股份有限公司 | Implementation technique for form editor of nursing record documents |
| CN106683018A (en) * | 2016-06-20 | 2017-05-17 | 杨玉海 | Hospital medical record large text intelligent variable software technique method |
| CN106371825B (en) * | 2016-08-23 | 2019-08-13 | 武大吉奥信息技术有限公司 | A kind of mobile terminal application interface list dynamic creation method and device |
| CN106502973A (en) * | 2016-09-19 | 2017-03-15 | 济南浪潮高新科技投资发展有限公司 | A kind of universal description method of Form Designer control |
| CN106293777B (en) * | 2016-10-31 | 2020-04-03 | 山东鲁能软件技术有限公司 | Method for realizing development front-end interface control based on component type |
| CN106599039B (en) * | 2016-11-07 | 2021-01-15 | 深圳市睿捷软件技术有限公司 | Statistical representation method supporting free combination nesting of relational database data |
| CN106777925A (en) * | 2016-11-30 | 2017-05-31 | 上海电机学院 | Nursing station management system in hospital |
| CN106777998A (en) * | 2016-12-19 | 2017-05-31 | 邹春秋 | A kind of medical system big data processing unit and method |
-
2017
- 2017-06-09 CN CN201710436536.1A patent/CN107301044B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101727319A (en) * | 2009-12-09 | 2010-06-09 | 上海宝信软件股份有限公司 | Page-turning service-oriented data table control and implementation method thereof |
| CN103092612A (en) * | 2012-12-31 | 2013-05-08 | 深圳天珑无线科技有限公司 | Method and electronic device for achieving three dimensional (3D) desktop mapping of Android operating system |
| CN105354281A (en) * | 2014-02-03 | 2016-02-24 | 株式会社隆创 | Image inspection apparatus and image inspection procedure |
| CN104992053A (en) * | 2015-06-17 | 2015-10-21 | 广州慧扬信息系统科技有限公司 | Method for automatic charging of additional items related in medical advice execution |
| CN105740478A (en) * | 2016-03-25 | 2016-07-06 | 浪潮通用软件有限公司 | Non-refreshing table paging sorting achieving method and device |
| CN106202027A (en) * | 2016-08-12 | 2016-12-07 | 南京都昌信息科技有限公司 | A kind of Tibetan language electronic medical record system text editor |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107301044A (en) | 2017-10-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10496621B2 (en) | Columnar storage of a database index | |
| EP1089195B1 (en) | Method for storing and managing data | |
| Lin et al. | Temporal event tracing on big healthcare data analytics | |
| Chauhan | A review on various aspects of MongoDB databases | |
| US20080319965A1 (en) | Filtering query results using model entity limitations | |
| CN1592908B (en) | Database system having heterogeneous object types | |
| CN109785918B (en) | Data acquisition system and method applied to clinical scientific research | |
| CN109102897A (en) | A kind of Database and information retrieval method for disease big data | |
| US8037088B2 (en) | Change management | |
| CN112417836A (en) | Automatic table generation method, terminal equipment and storage medium | |
| CN101833511B (en) | Data management method, device and system | |
| CN104598437B (en) | The dynamic realizing method of header information in electronic health record | |
| CN102067140A (en) | A system method and computer program product for pedigree analysis | |
| US7761461B2 (en) | Method and system for relationship building from XML | |
| CN107301044B (en) | Multi-page control for form of electronic medical record of metabolic disease | |
| CN104794567B (en) | A kind of Infectious Diseases Data management method based on HBase | |
| CN105975616A (en) | Data quality control system based on public health refinement management | |
| CN106202008B (en) | A kind of MySQL database structured document generation method and device | |
| CN111190895B (en) | Organization method, device and storage medium of column-type storage data | |
| US8554722B2 (en) | Method for transferring data into database systems | |
| Ren et al. | Design of hospital beds center management information system based on HIS | |
| Frank et al. | Evaluation of different database designs for integration of heterogeneous distributed electronic health records | |
| CN108984720B (en) | Data query method and device based on column storage, server and storage medium | |
| CN107679050B (en) | Electronic nursing recording system capable of being customized | |
| US20090187591A1 (en) | Retrieving database records for aggregation without redundant database read operations |
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 |