毕业设计设计题目药品进销存管理系统设计学生姓名学号专业班级指导教师2013年6月6日药品进销存管理系统设计摘要药品进销存管理系统是医院信息系统建设的重要组成部分。有效的药品进销存管理可以对药品物流、资金流和信息流进行整体规划,减少不良库存,降低药品流通资金占用率,挖掘潜在利润。本文基于VB和ADO技术编程实现了一个集药品进销存为一体的信息管理系统,该系统以SQLServer2000为后台数据库,实现了商品类型管理、商品管理、进货管理、销售管理、报损管理、供销商管理销售分析等功能。本系统界面简洁、明快、直观,尤其适合中小型药房的药品批发零售管理。关键词:药品进销存管理系统;SQLServer2000;ADO;VBDesignofaStocking-Selling-StoringSystemofMedicineABSTRACTThestocking-selling-storingsystemofmedicineisanimportantcomponentintheconstructionofhospitalinformationsystem,whichcanplandrugs,capitalandinformationmoreeffectively,reduceadverseinventoryandtapthepotentialprofits.Thisdissertationdevelopedastocking-selling-storingsystemofmedicinebasedonVBandADO.WeuseSQLServer2000fordatabasedesign.Thesystemcanachievetheproducttypemanagement,productmanagement,purchasingmanagement,salemanagement,lossreportmanagement,suppliermanagement,saleanalysis,andsoon.Thesysteminterfaceissimple,clean,andintuitive,andespeciallyitisfitforthewholesaleandretailofdrugsinsmallandmediumsizeddrugstores.Keywords:stocking-selling-storingsystemofmedicine;SQLSERVER2000;ADO;VB目录第一章绪论..................................................................................................................71.1研究背景.................................................................................................................71.2国内外研究现状.....................................................................................................71.3课题目的与意义.....................................................................................................81.4论文组织与结构.....................................................................................................9第二章开发工具简介..............................................................................................102.1visualbasic编程开发工具...................................................................................102.1.1VisualBasic语言概述................................................................................102.1.1.1VB简介.............................................................................................102.1.1.2VB语言的基本特点及VB应用程序的基本持点.........................102.1.2VisualBasic编程环境...............................................................................112.1.2.1面对对象的编程...............................................................................112.1.2.2实现菜单选项...................................................................................112.1.2.3实现工具栏.......................................................................................112.1.2.4关于版本............................................................................................112.2使用SQLServer2000实现关系型数据库..........................................................122.2.1数据库的概念.............................................................................................122.2.2SQLServer2000介绍.................................................................................122.3ADO技术........................................