Power Builder环境下使用SQL语言实现我院各药房之间处方发药系统的数据转换

Data Transformation of Prescription Dispensing System among Hospital Pharmacies by Using SQL Language under Power Builder Environment

目的:协调各药房之间的药品管理,使患者取药更为方便、快捷。方法:依托"军卫一号"处方发药系统,在Power Builder环境下使用SQL语言,实现我院各药房之间处方发药系统的处方数据转换。结果与结论:该方法弥补了各药房固定发药模式的缺陷,大大减少患者取药的时间,基本上避免了患者持多张处方在不同药房多次排队取药的问题。

OBJECTIVE： To coordinate the drug management among pharmacies so as to offer a convenient and fast dispensing service for patients. METHODS： Based on “Army No.1” prescription dispensing system, the data in prescription dispensing system were transformed among different pharmacies by using SQL language under the Power Builder environment.RESULTS ＆ CONCLUSIONS：The new method avoided the shortcoming of traditional dispensing type and reduced the waiting time to take drug and basically avoided the problem of patients＇ multiple queuing for dispensing of multiple prescriptions.