基于SQL server医院诊疗自动化排队叫号系统

Queuing and calling system of hospital diagnosis and treatment automation based on SQL server

为提高医院对病人就诊秩序的管理效率,设计一种基于SQL server医院诊疗自动化排队叫号系统,改变传统叫号系统响应时间慢的问题。通过分析医院诊疗自动化排队叫号系统现状,根据排队叫号系统需求,此次设计主要分为系统的硬件设计和软件设计2部分。在硬件设计部分,设计无线传输器,选用C20作为无线接收芯片,并选择SPI接口与C20共同完成排队叫号信息数据的采集与发送,为系统提供通信功能。系统的软件部分,设计叫号权限功能,控制叫号顺序,在此基础上,利用SQL server建立用户界面,建立HIS数据库,将叫号信息、医生信息和患者信息等都存入到该数据库中,并引入形式化算法,提供自动化排队叫号功能,以此完成基于SQL server医院诊疗自动化排队叫号系统的设计。实验对比结果表明,此次设计的排队叫号系统比传统系统响应时间快,在并发用户增多的情况下,也能保证较快的响应速度。

in order to improve the efficiency of hospital management of patient order,an automatic queuing and calling system for hospital diagnosis and treatment based on SQL server is designed to change the slow response time of traditional calling system.Based on the analysis of the status quo of hospital diagnosis and treatment automation queuing system,according to the demand of queuing system,the design is mainly divided into two parts:hardware design and software design.In the part of hardware design,the wireless transmitter is designed,C20 is chosen as the wireless receiving chip,and SPI interface and C20 are selected to complete the collection and transmission of queuing call information data,providing communication function for the system.In the software part of the system,the calling authority function is designed and the calling order is controlled.On this basis,the user interface is established by SQL server,and the HIS database is established.Calling information,doctor information and patient information are stored in the database,and formal algorithm is introduced to provide automatic queuing calling function.The queuing and calling system is designed based on SQL server for hospital diagnosis and treatment automation.The experimental results show that the designed queuing call system in this paper has faster response time than the traditional system,and can also guarantee faster response speed when the number of concurrent users increases.