CN117497159A - Method for managing hospital beds by using cards based on automatic SQL loading - Google Patents
Method for managing hospital beds by using cards based on automatic SQL loading Download PDFInfo
- Publication number
- CN117497159A CN117497159A CN202410003033.5A CN202410003033A CN117497159A CN 117497159 A CN117497159 A CN 117497159A CN 202410003033 A CN202410003033 A CN 202410003033A CN 117497159 A CN117497159 A CN 117497159A
- Authority
- CN
- China
- Prior art keywords
- bed
- card
- service domain
- condition
- sql
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 31
- 230000000474 nursing effect Effects 0.000 claims abstract description 15
- 238000012552 review Methods 0.000 claims abstract description 6
- 238000004590 computer program Methods 0.000 claims description 11
- 239000003086 colorant Substances 0.000 claims description 10
- 238000012545 processing Methods 0.000 claims description 7
- 230000005540 biological transmission Effects 0.000 claims description 6
- 238000012216 screening Methods 0.000 claims description 4
- 230000000007 visual effect Effects 0.000 claims description 3
- 238000007726 management method Methods 0.000 description 10
- 238000004364 calculation method Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000003044 adaptive effect Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000011218 segmentation Effects 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 208000035473 Communicable disease Diseases 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000004069 differentiation Effects 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 208000015181 infectious disease Diseases 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000001356 surgical procedure Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H40/00—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices
- G16H40/20—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices for the management or administration of healthcare resources or facilities, e.g. managing hospital staff or surgery rooms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Primary Health Care (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Public Health (AREA)
- Biomedical Technology (AREA)
- Medical Informatics (AREA)
- General Health & Medical Sciences (AREA)
- Epidemiology (AREA)
- Software Systems (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The method for managing the hospital bed based on the automatically loaded SQL card identifies the current service domain according to the service domain sequence number queryIndex, automatically discriminates and selects the corresponding service domain condition grammar block, finally completes the automatically loaded SQL configuration to form a complete card fetch statement, automatically calculates the width and height of the bed card, fonts and field intervals according to the current screen size and preset condition style logic information, and performs the responsive layout of the automatic arrangement of the bed card, thereby realizing the card management of the hospital bed. According to the invention, through automatic loading data and multidimensional condition retrieval, information closely focused by doctors and nurses is displayed according to service domains and conditions, more comprehensive and detailed patient information can be provided, medical staff can easily review and manage bed information, bed management efficiency and accuracy can be improved, and better nursing service is provided for patients.
Description
Technical Field
The invention belongs to the field of data processing, and particularly relates to a method for managing hospital beds by using cards based on automatic loading SQL.
Background
In the field of hospital bed management, there are some conventional bed paper card management methods at present. These methods typically use manual filling, paper card replacement for bed management, and then manually update patient information by a nurse or other healthcare worker. This method has the following drawbacks:
1. time consuming and error prone: the manual filling and replacing of paper cards requires a lot of time, and filling errors or omission easily occur, so that information is inaccurate.
2. Not easy to update in real time: the traditional bed paper card management mode can not update patient information in real time, and when the state of a patient changes, extra time and labor cost are required to be consumed for updating.
3. The information is not comprehensive: the information on the paper card is limited, can not provide detailed patient information, and the width and the height of the entity card are fixed, can not be self-adaptively unfolded and stretched according to the content, so that more comprehensive information is displayed, the comprehensive requirements of medical staff on the patient information are difficult to meet, and the paper card can not be divided and arranged according to business domains.
4. Inconvenience: the paper card needs to be carried and replaced manually, so that the medical staff is inconvenient to quickly review and manage the bed position information.
5. Inflexibility: information closely focused by doctors and nurses cannot be displayed according to business fields and conditions through automatic loading data and multi-dimensional condition retrieval.
In view of the foregoing, the conventional bed paper card management method has major drawbacks in terms of efficiency, accuracy and information comprehensiveness, and a more intelligent and efficient bed management system is needed to solve these problems.
Disclosure of Invention
The invention aims to provide a method for managing hospital beds based on automatically loading SQL cards, which can display information closely focused by doctors and nurses according to business fields and conditions by automatically loading data and multi-dimensional condition retrieval, can provide more comprehensive and detailed patient information, is convenient for medical staff to easily review and manage the bed information, can improve the bed management efficiency and accuracy, and provides better nursing service for patients.
The invention discloses a method for managing hospital beds based on automatically loading SQL cards, which comprises the following steps:
step 1, an administrator performs background bed card grammar configuration and bed navigation interface configuration:
on a bed card visual configuration interface, an administrator firstly configures grammar for acquiring bed data of a patient, wherein the grammar comprises a main SQL (structured query language) containing all business domain condition grammar blocks, a condition SQL for inquiring each business domain and the number of beds under the business domain and an infant SQL for inquiring whether a lying-in woman infant occupies a bed or not;
each main SQL comprises a patient bed basic information module, a business domain condition grammar module and a specific condition parameter transmission processing module, wherein the patient bed basic information is a display field on a bed card and comprises basic data and special data, the basic data comprises fields of patient name, bed number, sex and age, the special data comprises fields of critical, nursing grade and rescue type, and the special data refers to information with business attributes; simultaneously, the association conditions of the fields with a patient admission information table, a bed usage table and a bed dictionary table are recorded; each service domain condition grammar block module comprises a service domain condition grammar block corresponding to each service domain sequence number queryIndex; the specific condition parameter transmission processing module is used for further screening the retrieval result obtained based on the service domain condition grammar block;
the bed navigation interface comprises a service domain display area and a specific bed card display area, wherein a plurality of service domain labels are sequentially arranged in the service domain display area, each service domain label displays specific service domain names and statistics quantity, each service domain label corresponds to a service domain serial number queryIndex, the specific bed card display area is used for displaying bed cards meeting the conditions, and basic information of the patient bed is displayed on the bed cards;
then configuring the value information and the font color of all fields of the bed card, and the condition pattern rule of the card ground color;
finally, configuring judging rules of the conditional patterns of all field colors of the bed card and the base colors of the card;
step 2, the background inquires all current service domains and the number of beds corresponding to each service domain according to the condition SQL, and displays the current service domains and the number of beds in a service domain display area; identifying the current service domain according to the service domain sequence number queryIndex transmitted by a foreground, automatically analyzing a main SQL in a segmented mode, automatically selecting a service domain condition grammar block corresponding to the service domain sequence number queryIndex in a screened mode, automatically loading service domain condition grammar blocks matched with the service domain sequence number queryIndex, eliminating the rest service domain condition grammar blocks to form a complete bed card fetch statement, AND inquiring respective set information after the main SQL is spliced in a segmented mode according to the service domain condition grammar blocks by using a WHERE.
Step 3, after the foreground acquires the specific information of the bed, firstly assembling basic data of the name, the number, the sex and the age of a patient into a bed card according to fields, and then assembling special data of critical, nursing grade and rescue type into the bed card;
step 4, the foreground executes the logical judgment of the bed card condition patterns according to the judgment rule and the condition pattern rule of the condition patterns configured in the step 1, calculates the field spacing and the width and the height of the single bed card, and renders the single bed card;
step 5, calculating the width and height, fonts and spacing of each bed card by a foreground, adaptively calculating the number of card containers in rows and columns according to the width and the height of a current screen, wherein each card container represents 1 bed card, setting a corresponding number of card containers in a specific bed card display area according to a service domain, automatically arranging card positions according to the calculated width and height and spacing of each bed card, and carrying out responsive layout arrangement of the bed cards;
and 6, clicking a business domain label of a business domain display area in the bed navigation interface by a user to review and display the card information of the multi-dimensional bed, so as to realize card management of the hospital bed.
An electronic device, comprising:
one or more processors;
a storage means for storing one or more programs;
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method for managing hospital beds based on automatically loading SQL cards described above.
A computer readable medium having stored thereon a computer program which when executed by a processor implements the above method of automatically loading SQL based card management of hospital beds.
After the technical scheme is adopted, the current business domain is identified according to the business domain sequence number queryIndex, the corresponding business domain condition grammar block is automatically selected, the automatic loading SQL configuration is finally completed, a complete card fetch statement is formed, the width and height of the bed card, the fonts and the field spacing are automatically calculated according to the current screen size and the preset condition pattern logic information, the responsive layout of the automatic arrangement of the bed card is carried out, and the hospital bed is managed by the card, so that the method has the following beneficial effects:
1. high-efficiency automation: the automatic recording and updating of bed information can be realized, medical staff is not required to fill in and replace paper cards manually, time is saved, and the risk of human errors is reduced;
2. information comprehensiveness: the medical staff can clearly know the patient information on each bed, including the nursing grade, the type of the rescue staff, the severe state and the like, the user interface can provide detailed patient information in real time, and clearly display the patient information of each bed, so that the medical staff can make more comprehensive and accurate nursing decisions;
3. and (3) self-adaptive display: the system supports the self-adaptive adjustment of the width, the height, the spacing and the arrangement of the bed cards, and can automatically adjust the fonts, the character spacing and the like of the bed cards so as to meet the requirements of different users and realize good user experience;
4. flexible configuration: the system supports the segmentation and cutting of the main SQL of the patient information according to the service domain, and the automatic loading is carried out after the data are fetched.
Drawings
FIG. 1 is a flow chart of the present invention;
FIG. 2 is a timing diagram of the present invention;
FIG. 3 is a schematic diagram of the main SQL component of the present invention;
FIG. 4 is a flow chart of the automatic SQL loading of the present invention;
fig. 5 is a schematic block diagram of an electronic device of the present invention.
Detailed Description
The following description of the embodiments of the present application will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are only some, but not all, of the embodiments of the present application. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the present disclosure, are within the scope of the present application based on the embodiments herein.
It should be noted that the terms "first," "second," and the like in the description and claims of the present application and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that embodiments of the present application described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or server that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed or inherent to such process, method, article, or apparatus, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
In this application embodiment, the terms "exemplary" or "such as" and the like are used to denote examples, illustrations, or descriptions, and any embodiment or solution described as "exemplary" or "such as" in this application embodiment should not be construed as being preferred or advantageous over other embodiments or solutions. Rather, the use of words such as "exemplary" or "such as" is intended to present related concepts in a concrete fashion.
Example 1
In one embodiment of the present invention, a method for managing hospital beds based on automatically loading SQL cards is provided, as shown in FIGS. 1 to 4, comprising the steps of:
step 1, an administrator performs background bed card grammar configuration and bed navigation interface configuration:
on a bed card visual configuration interface, an administrator firstly configures grammar for acquiring patient bed data, wherein the grammar comprises a main SQL (structured query language) containing all business domain condition grammar blocks, a condition SQL for inquiring the number of beds under each business domain and an infant SQL for inquiring whether a puerperal infant occupies a bed or not, and the infant SQL is used for inquiring whether the bed of an obstetrical department is occupied by the infant or not;
as shown in fig. 3, each main SQL includes a patient bed basic information module, a respective business domain condition grammar module and a specific condition parameter transmission processing module, wherein the patient bed basic information is a display field on a bed card, and includes basic data and special data, the basic data includes fields of patient name, bed number, sex, age and the like, and the special data refers to information with business attributes, including fields of crisis, nursing level, rescue type and the like; meanwhile, the association conditions of the fields with the tables such as a patient admission information table, a bed usage table, a bed dictionary table and the like are recorded; each service domain condition grammar block module comprises a service domain condition grammar block corresponding to each service domain sequence number queryIndex, wherein the service domain sequence number queryIndex is a unique number; generally including retrieving headcount condition grammars, retrieving present day surgery patient condition grammars, retrieving present day admission patient condition grammars, retrieving high risk tube slip patient condition grammars, and other business domain condition grammars; the specific condition parameter transmission processing module is used for further screening the search result obtained based on the business domain condition grammar block, for example, searching the present hospitalization patient condition grammar block to obtain the present hospitalization patient number, and further screening the number belonging to the pediatric department if the specific condition parameter is pediatric;
the bed navigation interface comprises a service domain display area and a specific bed card display area, wherein a plurality of service domain labels are sequentially arranged in the service domain display area on the left side, each service domain label displays specific service domain names and statistics quantity, each service domain label corresponds to a service domain sequence number queryIndex, and the service domain labels are matched to corresponding service domain condition grammar blocks through the service domain sequence numbers queryIndex; the right side is a specific bed card display area for displaying bed cards meeting the conditions, and the bed cards are used for displaying bed basic information of patients; the business domain labels comprise different scenes such as number of people in hospital, admission, nursing level, today's discharge, today's operation, operation table, high-risk patients, infectious disease patients and the like;
then configuring the value information and the font color of all fields of the bed card and the condition pattern rule of the bottom color of the card, different special data can be configured into different colors according to the needs, and basic data can be configured into the same color, which can be customized according to the needs and are not described in detail herein;
finally, configuring judging rules of all field colors of the bed card and the condition patterns of the card base color, supporting custom setting of font colors according to the numerical value of the field values, and whether highlighting;
step 2, the background inquires all current service domains and the number of beds corresponding to each service domain according to the condition SQL, and displays the service domains in a service domain display area; identifying the current service domain according to the service domain sequence number queryIndex transmitted by a foreground, automatically analyzing the main SQL in a segmented mode, automatically selecting a service domain condition grammar block corresponding to the service domain sequence number queryIndex, automatically loading a condition grammar block matched with the service domain sequence number queryIndex, removing the rest service domain condition grammar blocks to form a complete bed card fetch statement, AND inquiring respective set information after the main SQL is segmented AND spliced by the AND condition according to the service domain condition grammar block, thereby obtaining bed specific information;
the method comprises the steps that a main SQL comprises all service domain condition grammar blocks, when the main SQL is analyzed, the condition SQL is cut in a segmented mode, the main SQL and the condition SQL are bound one by one in a mode of inquiring service domain sequence numbers queryIndex and inquiring parameters queryParam, segmentation calculation is automatically loaded, WHERE conditions are transmitted into the main SQL in a one-to-one correspondence mode, and therefore data of each service domain and display data of bed cards are inquired;
the background inquires the specific number corresponding to each business domain label through the condition SQL, and displays the specific number in a business domain display area, for example, a business domain label which marks 10 people in the operation today is generated on the business domain display area of a bed navigation interface, and the specific number represents that 10 beds in the beds belong to patients needing to do the operation today; if a nurse clicks the business domain label of the 'today operation', a background automatically loads a conditional grammar block matched with the business domain sequence number queryIndex according to the business domain sequence number queryIndex of the business domain label, eliminates the rest business domain conditional grammar blocks, and then splices and assembles patient bed basic information in a main SQL to obtain a spliced main SQL (patient bed basic information SQL+the today operation condition grammar block SQL), and after the spliced main SQL is executed, all bed specific information under the 'today operation' can be queried;
all the service domain condition grammar blocks in the main SQL are marked with # condition query=query index (queryIndex) #, and when a user clicks a certain service domain label, the background can match the service domain condition grammar blocks according to the service domain sequence number queryIndex;
step 3, after the foreground acquires the specific information of the bed, firstly assembling basic data of the name, the number, the sex and the age of a patient into a bed card according to fields, and then assembling special data of critical, nursing grade and rescue type into the bed card;
step 4, the foreground executes the logical judgment of the bed card condition patterns according to the judgment rule and the condition pattern rule of the condition patterns configured in the step 1, calculates the field spacing and the width and the height of the single bed card, and renders the single bed card;
the bed card condition pattern logic comprises bed card ground color logic, field color logic and service domain color logic, the background type of the card ground color is set by judging the bed card ground color logic, specific value values are obtained for each service domain and each field, different value values are adapted to different triggers in an adapter mode, and finally a color extractor is triggered to render colors; for example, bed card critical judgment refers to that when a patient is a critical patient, the upper right corner of the bed card automatically renders a highlighting display so as to remind a medical staff of paying attention;
for example, for high critical patients, can be in the right upper corner mark of bed card and pay attention to, danger appearance, the nursing level mainly divide into first order nursing, second grade nursing, tertiary nursing, generally can set up different colours to the nurse can distinguish fast, examples: when the patient is inquired to be primary care, after judging according to the judging rule of the conditional style, the system sets 4 primary care words to be green, secondary yellow and tertiary red (the color can be customized) according to the judging rule of the conditional style;
for example, the rescue type is a medical insurance patient, and different colors may be provided for differentiation. Setting the font color to red when the patient is less than 1 year old, setting to green when the patient is greater than or equal to 1 year old, etc., supporting custom setting of the font color according to the size of the numerical value, and whether to highlight;
the step of calculating the field spacing and width and height information of the single bed card refers to calculating the number of bed card row display (columnSize) according to the number of fields (columnCount) required to be displayed by the card, the index width (itemWidth), the adaptive height factor (authHeight) and the adaptive width factor (authWidth).
Card height calculation formula:；
card width calculation formula:；
step 5, calculating the width, the height, the fonts and the spacing of each bed card by a foreground, adaptively calculating the number of card containers in rows and columns according to the width and the height of a current screen, wherein each card container represents 1 bed card, 1 patient occupies 1 bed, corresponding number of card containers are arranged in a specific bed card display area according to a service domain, card positions are automatically arranged according to the width and the height of each calculated bed card, and responsive layout arrangement of the bed cards is performed;
in the embodiment, a foreground acquires a drawing object DrawPage of a card, an empty bed defaults to only draw a card rectangle, and a bed number is displayed, the orientation of the card to be drawn is set by using a SetPosition () method of the DrawPage object, and all bed cards are arranged and rendered according to the calculated width and height of the bed cards and the interval;
and 6, clicking a business domain label of a business domain display area in the bed navigation interface by a user to review and display the card information of the multi-dimensional bed, so as to realize card management of the hospital bed.
The key point of the invention is that the current business domain is identified according to the business domain sequence number queryIndex, the corresponding business domain condition grammar block is automatically selected, the SQL configuration of automatic loading is finally completed, a complete card fetch sentence is formed, the width and height of the bed card, the fonts and the field spacing are automatically calculated according to the current screen size and the preset condition pattern logic information, the responsive layout of the automatic arrangement of the bed card is realized, and the hospital bed is managed by the card.
Example two
Those of skill would further appreciate that the various illustrative elements 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 elements and steps are described above generally in terms of functionality in order to clearly illustrate the 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 solution. 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.
Specifically, each step of the method embodiments in the embodiments of the present application may be implemented by an integrated logic circuit of hardware in a processor and/or an instruction in software form, and the steps of the method disclosed in connection with the embodiments of the present application may be directly implemented as a hardware decoding processor or implemented by a combination of hardware and software modules in the decoding processor. Alternatively, the software modules may be located in a well-established storage medium in the art such as random access memory, flash memory, read-only memory, programmable read-only memory, electrically erasable programmable memory, registers, and the like. The storage medium is located in a memory, and the processor reads information in the memory, and in combination with hardware, performs the steps in the above method embodiments.
A second embodiment of the present invention provides an electronic device, as shown in fig. 5, the electronic device 700 may include: a memory 710 and a processor 720, the memory 710 being configured to store a computer program and to transfer the program code to the processor 720. In other words, the processor 720 may call and run a computer program from the memory 710 to implement the methods in the embodiments of the present application. For example, the processor 720 may be configured to perform the above-described method embodiments according to instructions in the computer program.
In some embodiments of the present application, the processor 720 may include, but is not limited to:
a general purpose processor, digital signal processor (Digital Signal Processor, DSP), application specific integrated circuit (Application Specific Integrated Circuit, ASIC), field programmable gate array (Field Programmable Gate Array, FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware components, or the like.
In some embodiments of the present application, the memory 710 includes, but is not limited to: volatile memory and/or nonvolatile memory. The nonvolatile Memory may be a Read-Only Memory (ROM), a Programmable ROM (PROM), an Erasable PROM (EPROM), an Electrically Erasable EPROM (EEPROM), or a flash Memory. The volatile memory may be random access memory (Random Access Memory, RAM) which acts as an external cache. By way of example, and not limitation, many forms of RAM are available, such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (Double Data Rate SDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), and Direct memory bus RAM (DR RAM).
In some embodiments of the present application, the computer program may be partitioned into one or more modules that are stored in the memory 710 and executed by the processor 720 to perform the methods provided herein. The one or more modules may be a series of computer program instruction segments capable of performing the specified functions, which are used to describe the execution of the computer program by the electronic device 700.
As shown in fig. 5, the electronic device may further include: a transceiver 730, the transceiver 730 being connectable to the processor 720 or the memory 710. The processor 720 may control the transceiver 730 to communicate with other devices, and in particular, may send information or data to other devices or receive information or data sent by other devices. Transceiver 730 may include a transmitter and a receiver. Transceiver 730 may further include antennas, the number of which may be one or more.
It should be appreciated that the various components in the electronic device 700 may be connected by a bus system that includes a power bus, a control bus, and a status signal bus in addition to a data bus.
Example III
The third embodiment of the present invention also provides a computer storage medium having stored thereon a computer program which, when executed by a computer, enables the computer to perform the method of the above-described method embodiment.
When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, produces, in whole or in part, a flow or function consistent with embodiments of the present application. The computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable apparatus. The computer instructions may be stored in a computer-readable storage medium or transmitted from one computer-readable storage medium to another computer-readable storage medium, for example, the computer instructions may be transmitted from one website, computer, server, or data center to another website, computer, server, or data center by a wired (e.g., coaxial cable, fiber optic, digital subscriber line (digital subscriber line, DSL)) or wireless (e.g., infrared, wireless, microwave, etc.). The computer readable storage medium may be any available medium that can be accessed by a computer or a data storage device such as a server, data center, etc. that contains an integration of one or more available media. The usable medium may be a magnetic medium (e.g., a floppy disk, a hard disk, a magnetic tape), an optical medium (e.g., a digital video disc (digital video disc, DVD)), or a semiconductor medium (e.g., a Solid State Disk (SSD)), or the like.
The foregoing description of the embodiments has been provided for the purpose of illustrating the general principles of the invention, and is not meant to limit the scope of the invention, but to limit the invention to the particular embodiments, and any modifications, equivalents, improvements, etc. that fall within the spirit and principles of the invention are intended to be included within the scope of the invention.
Claims (3)
1. The method for managing the hospital bed by the card based on the automatic loading SQL is characterized by comprising the following steps of:
step 1, an administrator performs background bed card grammar configuration and bed navigation interface configuration:
on a bed card visual configuration interface, an administrator firstly configures grammar for acquiring bed data of a patient, wherein the grammar comprises a main SQL (structured query language) containing all business domain condition grammar blocks, a condition SQL for inquiring each business domain and the number of beds under the business domain and an infant SQL for inquiring whether a lying-in woman infant occupies a bed or not;
each main SQL comprises a patient bed basic information module, a business domain condition grammar module and a specific condition parameter transmission processing module, wherein the patient bed basic information is a display field on a bed card and comprises basic data and special data, the basic data comprises fields of patient name, bed number, sex and age, the special data comprises fields of critical, nursing grade and rescue type, and the special data refers to information with business attributes; simultaneously, the association conditions of the fields with a patient admission information table, a bed usage table and a bed dictionary table are recorded; each service domain condition grammar block module comprises a service domain condition grammar block corresponding to each service domain sequence number queryIndex; the specific condition parameter transmission processing module is used for further screening the retrieval result obtained based on the service domain condition grammar block;
the bed navigation interface comprises a service domain display area and a specific bed card display area, wherein a plurality of service domain labels are sequentially arranged in the service domain display area, each service domain label displays specific service domain names and statistics quantity, each service domain label corresponds to a service domain serial number queryIndex, the specific bed card display area is used for displaying bed cards meeting the conditions, and basic information of the patient bed is displayed on the bed cards;
then configuring the value information and the font color of all fields of the bed card, and the condition pattern rule of the card ground color;
finally, configuring judging rules of the conditional patterns of all field colors of the bed card and the base colors of the card;
step 2, the background inquires all current service domains and the number of beds corresponding to each service domain according to the condition SQL, and displays the current service domains and the number of beds in a service domain display area; identifying the current service domain according to the service domain sequence number queryIndex transmitted by a foreground, automatically analyzing a main SQL in a segmented mode, automatically selecting a service domain condition grammar block corresponding to the service domain sequence number queryIndex in a screened mode, automatically loading service domain condition grammar blocks matched with the service domain sequence number queryIndex, eliminating the rest service domain condition grammar blocks to form a complete bed card fetch statement, AND inquiring respective set information after the main SQL is spliced in a segmented mode according to the service domain condition grammar blocks by using a WHERE.
Step 3, after the foreground acquires the specific information of the bed, firstly assembling basic data of the name, the number, the sex and the age of a patient into a bed card according to fields, and then assembling special data of critical, nursing grade and rescue type into the bed card;
step 4, the foreground executes the logical judgment of the bed card condition patterns according to the judgment rule and the condition pattern rule of the condition patterns configured in the step 1, calculates the field spacing and the width and the height of the single bed card, and renders the single bed card;
step 5, calculating the width and height, fonts and spacing of each bed card by a foreground, adaptively calculating the number of card containers in rows and columns according to the width and the height of a current screen, wherein each card container represents 1 bed card, setting a corresponding number of card containers in a specific bed card display area according to a service domain, automatically arranging card positions according to the calculated width and height and spacing of each bed card, and carrying out responsive layout arrangement of the bed cards;
and 6, clicking a business domain label of a business domain display area in the bed navigation interface by a user to review and display the card information of the multi-dimensional bed, so as to realize card management of the hospital bed.
2. An electronic device, comprising:
one or more processors;
a storage means for storing one or more programs;
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of automatically loading SQL-based cards to manage hospital beds of claim 1.
3. A computer readable medium having stored thereon a computer program, wherein the program when executed by a processor implements the method of automatically loading SQL based cards to manage hospital beds of claim 1.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410003033.5A CN117497159B (en) | 2024-01-02 | 2024-01-02 | Method for managing hospital beds by using cards based on automatic SQL loading |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410003033.5A CN117497159B (en) | 2024-01-02 | 2024-01-02 | Method for managing hospital beds by using cards based on automatic SQL loading |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117497159A true CN117497159A (en) | 2024-02-02 |
| CN117497159B CN117497159B (en) | 2024-04-16 |
Family
ID=89683369
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410003033.5A Active CN117497159B (en) | 2024-01-02 | 2024-01-02 | Method for managing hospital beds by using cards based on automatic SQL loading |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117497159B (en) |
Citations (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1608270A (en) * | 2000-11-13 | 2005-04-20 | 美国西门子医疗解决公司 | A system and method for navigating patient medical information |
| CN102819675A (en) * | 2012-07-31 | 2012-12-12 | 陈兰 | Method for constructing nursing management and quality comprehensive information of hospital |
| CN203122871U (en) * | 2013-03-04 | 2013-08-14 | 刘兵 | Electronic bedside card system capable of connecting hospital ward and nurse station |
| US20150213206A1 (en) * | 2012-09-13 | 2015-07-30 | Parkland Center For Clinical Innovation | Holistic hospital patient care and management system and method for automated staff monitoring |
| CN108597561A (en) * | 2018-02-01 | 2018-09-28 | 南京滕健医疗科技有限公司 | Wisdom ward interactive system |
| CN110880367A (en) * | 2019-11-15 | 2020-03-13 | 湖南尚医康医疗科技有限公司 | Self-service terminal system of being in hospital and intelligent triage management system thereof |
| CN112270989A (en) * | 2020-10-27 | 2021-01-26 | 河北省中医院 | Intelligent information indicating method and device and intelligent bed card |
| CN112635082A (en) * | 2020-12-21 | 2021-04-09 | 山东众阳健康科技集团有限公司 | Intelligent ward system considering patient hospitalizing experience and working method thereof |
| CN112951398A (en) * | 2021-03-31 | 2021-06-11 | 联仁健康医疗大数据科技股份有限公司 | Bed management method and device, electronic terminal and storage medium |
| CN213588817U (en) * | 2020-10-09 | 2021-07-02 | 中国人民解放军空军军医大学 | Tail clamp device of sickbed |
| CN113407522A (en) * | 2021-06-18 | 2021-09-17 | 上海市第十人民医院 | Data processing method and device, computer equipment and computer readable storage medium |
| CN214632812U (en) * | 2021-03-08 | 2021-11-09 | 朱秀英 | Nursing management is with bed nurse signboard |
| CN113641487A (en) * | 2021-07-06 | 2021-11-12 | 多点生活(成都)科技有限公司 | Intelligent automatic switching method for SQL task execution engine of big data platform |
| CN113687827A (en) * | 2021-08-24 | 2021-11-23 | 平安国际智慧城市科技股份有限公司 | Data list generation method, device and equipment based on widget and storage medium |
| CN115061721A (en) * | 2022-07-12 | 2022-09-16 | 平安科技（深圳）有限公司 | Report generation method and device, computer equipment and storage medium |
| CN115080594A (en) * | 2022-06-27 | 2022-09-20 | 医利捷(上海)信息科技有限公司 | Method and system for carrying out multi-dimensional analysis on data and electronic equipment |
| CN116246767A (en) * | 2023-03-15 | 2023-06-09 | 厦门狄耐克物联智慧科技有限公司 | Batch control method and system for ward ink screens |
-
2024
- 2024-01-02 CN CN202410003033.5A patent/CN117497159B/en active Active
Patent Citations (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1608270A (en) * | 2000-11-13 | 2005-04-20 | 美国西门子医疗解决公司 | A system and method for navigating patient medical information |
| CN102819675A (en) * | 2012-07-31 | 2012-12-12 | 陈兰 | Method for constructing nursing management and quality comprehensive information of hospital |
| US20150213206A1 (en) * | 2012-09-13 | 2015-07-30 | Parkland Center For Clinical Innovation | Holistic hospital patient care and management system and method for automated staff monitoring |
| CN203122871U (en) * | 2013-03-04 | 2013-08-14 | 刘兵 | Electronic bedside card system capable of connecting hospital ward and nurse station |
| CN108597561A (en) * | 2018-02-01 | 2018-09-28 | 南京滕健医疗科技有限公司 | Wisdom ward interactive system |
| CN110880367A (en) * | 2019-11-15 | 2020-03-13 | 湖南尚医康医疗科技有限公司 | Self-service terminal system of being in hospital and intelligent triage management system thereof |
| CN213588817U (en) * | 2020-10-09 | 2021-07-02 | 中国人民解放军空军军医大学 | Tail clamp device of sickbed |
| CN112270989A (en) * | 2020-10-27 | 2021-01-26 | 河北省中医院 | Intelligent information indicating method and device and intelligent bed card |
| CN112635082A (en) * | 2020-12-21 | 2021-04-09 | 山东众阳健康科技集团有限公司 | Intelligent ward system considering patient hospitalizing experience and working method thereof |
| CN214632812U (en) * | 2021-03-08 | 2021-11-09 | 朱秀英 | Nursing management is with bed nurse signboard |
| CN112951398A (en) * | 2021-03-31 | 2021-06-11 | 联仁健康医疗大数据科技股份有限公司 | Bed management method and device, electronic terminal and storage medium |
| CN113407522A (en) * | 2021-06-18 | 2021-09-17 | 上海市第十人民医院 | Data processing method and device, computer equipment and computer readable storage medium |
| CN113641487A (en) * | 2021-07-06 | 2021-11-12 | 多点生活(成都)科技有限公司 | Intelligent automatic switching method for SQL task execution engine of big data platform |
| CN113687827A (en) * | 2021-08-24 | 2021-11-23 | 平安国际智慧城市科技股份有限公司 | Data list generation method, device and equipment based on widget and storage medium |
| CN115080594A (en) * | 2022-06-27 | 2022-09-20 | 医利捷(上海)信息科技有限公司 | Method and system for carrying out multi-dimensional analysis on data and electronic equipment |
| CN115061721A (en) * | 2022-07-12 | 2022-09-16 | 平安科技（深圳）有限公司 | Report generation method and device, computer equipment and storage medium |
| CN116246767A (en) * | 2023-03-15 | 2023-06-09 | 厦门狄耐克物联智慧科技有限公司 | Batch control method and system for ward ink screens |
Non-Patent Citations (2)
| Title |
|---|
| 何建权;: "床旁智能护理服务系统的设计与应用", 中国数字医学, no. 02, 15 February 2020 (2020-02-15) * |
| 朱琳;: "设计检索模块实现日间病房精准数据统计", 中国医院统计, no. 04, 25 August 2020 (2020-08-25) * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117497159B (en) | 2024-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7107281B2 (en) | Method for storing records at easily accessible addresses | |
| CN108170655A (en) | Production method, device, terminal device and the storage medium of Visual Report Forms | |
| US20060004745A1 (en) | Structured reporting report data manager | |
| CA2477689A1 (en) | A dynamic dictionary and term repository system | |
| US20160070751A1 (en) | Database management system | |
| CN101789020A (en) | Image output method for PACS system | |
| CN113223710A (en) | Big data health examination result display system and control method | |
| CN117497159B (en) | Method for managing hospital beds by using cards based on automatic SQL loading | |
| JP5678229B1 (en) | Recording information management system, recording information management program, and recording information management method | |
| CN107609017A (en) | The method and system of medical industry intelligent search consulting are realized by self-defined hot word | |
| CN104134267A (en) | System and method for triage number-calling management | |
| JP5810230B1 (en) | Recording information management system, recording information management program, and recording information management method | |
| CN101635711B (en) | Programmable character communication method | |
| EP1729235A1 (en) | Structured reporting report data manager | |
| CN116313073A (en) | Multi-dimensional medical health data holographic intelligent display method | |
| TW202313140A (en) | Interface between heart pump controller database and hospital | |
| CN114093454A (en) | Image lower limb artery structured report writing design method and system | |
| JP2003108664A (en) | Opinion preparing system | |
| CN109255081B (en) | Portal service navigation method and system based on cloud platform | |
| CN112466419B (en) | Patient information management method, device and system | |
| JP2000184595A (en) | Display drawing generation management system and storage medium for recording processing program thereof | |
| US20170075875A1 (en) | Medical-document management apparatus, electronic medical record system, medical-document management system, and non-transitory computer readable medium | |
| CN117594178B (en) | Method, system, storage medium and equipment for processing vital sign information | |
| US20100115002A1 (en) | Customizing diagnostic codes and descriptions for an ecg management system | |
| CN109065156A (en) | A kind of synthesis display method of patients with malignant myeloma inspection result |
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 |