Design And Development Of Hospital Appointment Triage Management System Based On SQL Server

This paper is established on a practical item--the Appointment Triage Management System of Qiqihar Third People's Hospital.First,this paper systematically analysises the application status, developing purpose and feasibility of "multi-terminal hospital appointment triage management software based SQL Server", and focuses on the overall design of "registration triage system". And then it indetailly designs the various functional modules on the basis of the well-built development framework for the registration system. The front system takes the Visual Basic 6.0 language,the performance of which is more stable and reliable , as object-oriented development tools. The background system takes the SQL Server 2000 database. The interface of the system is more friendly, besides ,the keyboard can be used more fast and conveniently and be controlled more strictly .The most important, it can not only help to improve the medical staff's work efficiency ,but also help to reduce the patients'waiting time to queque up to register. In the end of the paper, it proposes the future expansion direction of the system.With the rapid development of the Internet, the Internet is gradually applied to all walks of our life. The way to register has changed from the traditional way which is lining up for making appointments with doctors into the modern way which is called the Internet registering. Now, the number of people who has the habit of using the Internet registering is increasing all the time and more and more people should make use of it more effectively. Currently the traditional way has totally changed, because fully using the Internet technology to realize its functions has lay technological foundation.We can complete one-stop personalized service based on the VB technology and the SQL Server database technology. For example,the companies should use it more effectively in the larger network system area. Fully using the LAN technology can help to achieve its functions.Based on the VB technique, we can use the SQL Server database technology to complete a one-stop personalized service. The appointment triage management system of hospital based on the SQL server and LAN in the Qiqihar Third People's Hospital have good prospects.The appointment triage management system of hospital has been more and more popular in domestic and foreign developed cities and the technology is relatively more mature. This paper mainly adopts the VB and SQL technology to develop such applications. Most of these systems have strong application markets and can be spread much faster in many hospitals of China. The appointment triage management system of hospital which is based on the VB and SQL technology can be used more simply and widely. It has its own independent applications, in addition it can be operated more easily and more resources are saved. In the future, the development of appointment triage management system will develop into the form which is based on the MAN, multi-hospital interconnected and the global Internet,at that time,the doctors can cross different hospitals and cities to make remote consultation and the patients can also make advance cross-regional booking.Then the remote collaboration technology, distributed systems and related security technology will be the main topics in this field.The appointment triage management system of hospital includes the triage staff procedure,the procedure for registration information, the procedure for calling to change the password, the printed procedure for making appointments with the older experts,the procedure for taking the number card of the appointment with the older experts, the procedure for taking the number card of the appointment with the ordinary expert, the doctor procedures, the procedure for audio calling and the procedure for totally controlling.We can realize the data communication between the server and terminal by linking the server and the terminal under the use of the VB technology and the SQL technology .The overall design includes the functional design of the database table design, interface unified design, the temporary table and database table storage management design, the information broadcast of comprehensive used of SQL Server based on the VB code, combined with VB controls we can realize the functions of appointment triage management systems.