Analysis and Management System of Drug Purchasing Database Based on VB.NET and VBA
ZHOU Leilei1, ZHANG Zuoheng2, LIU Chengyou1, JIANG Hongbing1,3, MA Jie3
1.Department of Medical Equipment, Nanjing First Hospital, Nanjing Medical University, Nanjing Jiangsu 210006, China;
2.Jiangsu Key Laboratory for Biomaterials and Devices, School of Biological Sciences & Medical Engineering, Southeast
University, Nanjing Jiangsu 210096, China
3.Centralized Drug Procurement Hosting Center, Nanjing Health Information Center, Nanjing Jiangsu 210003, China
Abstract:Objective In order to strengthen the drug management of medical institutions and reduce the investment of the statistics
of drug procurement accomplished by medical personnel, a drug procurement database analysis and management system which
could not only make the massive and cumbersome statistical work intuitive and convenient but also optimize the management of
medical procurement of medical institutions was developed. Methods A friendly user interface was developed by using VB.NET,
the VBA macro language was utilized to write background data handlers, and classification and statistical analysis was performed on
medical device procurement data in Excel format. By using the VB.NET to call VBA macro code, the system could be both simple to
operate and process the big data smoothly. Results A database analysis and management system for drug purchasing was developed.
It could complete the statistical analysis of online procurement performed by medical institutions of the whole city and generate the
reports directly, which therefore, made the statistical management of drug procurement data much more standardized and efficient.
Conclusion A multi-module, multi-data automatic analysis and process makes the original statistical work that needs mountains
of labor can now be quickly finished in batches, which improves the efficiency and accuracy impressively, and reduces the cost of
duplicate work.
周蕾蕾1,张作恒2,刘成友1,蒋红兵1,3,马洁3. 基于VB.NET与VBA的药物采购数据库分析管理系统[J]. 中国医疗设备, 2018, 33(4): 119-121.
ZHOU Leilei1, ZHANG Zuoheng2, LIU Chengyou1, JIANG Hongbing1,3, MA Jie3. Analysis and Management System of Drug Purchasing Database Based on VB.NET and VBA. China Medical Devices, 2018, 33(4): 119-121.