摘要
本研究采用客户机/服务器(Client/Server,C/S)架构,利用Power Builder(9.0.3)软件,通过SQL2005数据库,创建触发器接口,与医院物资系统集成,开发了适合我院的医用试剂条码管理系统,实施并应用。其功能包括:入库查询,条码生成,试剂出库,出库查询,出库取消,退货处理,库存查询,效期管理,采购计划等。该系统的使用,提高了工作效率,避免领用无序、消耗和库存账目不清、试剂过期等试剂管理不规范行为,加强了对医用试剂的科学管理。
The study uses Client/Server structure and Power Builder(9.0.3)software to create trigger interface with SQL2005 database, then integrates with hospital supplies system and develops a barcode management system of hospital reagent for implementation and application. Functions include storage and query, barcode generation, reagent ex-warehouse, ex-warehouse query, ex-warehouse cancel, returns processing, inventory query, effect phase management, procurement plan, etc. Application of this system improves work efficiency, avoids disorderly conducts like disorder use, unclear consumption and inventory accounts, out-of-date reagent, etc, thus strengthens scientific management of medical reagent.
出处
《中国医疗设备》
2017年第1期139-141,共3页
China Medical Devices
关键词
条码
医用试剂
触发器
系统集成
医院管理
barcode
medical reagent
trigger
system integration
hospital management