企业物资采购管理系统VB+SQL.docVIP

　　企业物资采购管理系统VB+SQL 毕业 目 录 摘要1 前言3 1绪论4 1.1企业物资采购管理系统概述4 1.1.1企业物资采购管理的概念4 1.1.2传统企业物资采购的弊端4 1.1.3企业物资采购中常遇的问题4 1.1.4 选择本选题的意义5 1.1.5物资采购管理工作成果简述5 2 开发工具简介7 2.1 Visual Basic 6.0集成开发环境7 2.1.1 Visual Basic术语7 2.1.2 VisualBasic的基本语句7 2.1.3 Visual Basic数据库编程9 2.2 数据库理论基础12 2.3 SQL简介14 2.3.1 SQL语言介绍14 2.3.2 SQL Server特点15 2.3.3 SQL Server 2000常见版本16 2.3.4 SQL Server 2000工具和实用程序16 3 采购管理系统总体设计18 3.1项目概述18 3.2业务可行性分析18 3.3系统开发环境19 3.3.1硬件环境19 3.3.2软件环境20 3.3.3开发语言的选择20 3.4系统设计概述20 3.5企业物资采购管理系统流程图22 4 数据库设计23 4.1管理ODBC数据源23 4.1.1 ODBC概述23 4.1.2 配置ODBC数据源23 4.2 数据库概念结构设计24 4.3 数据库逻辑结构设计27 4.3.1 Product数据表结构27 4.3.2 Supplier数据表结构28 4.3.3 Department数据表结构29 4.3.4 Users数据表结构30 4.3.5 Purchase数据表结构31 4.3.6 Disburse数据表结构32 4.4各数据表的关系33 5 子系统设计及其实现34 5.1系统结构34 5.1.1日常业务模块34 5.1.2库存管理模块35 5.1.3统计查询模块35 5.1.4基础信息模块35 5.1.5系统设置模块36 5.2系统菜单的设计36 5.3登录窗口模块设计37 （作文网 zent System Of modity Of Enterprise Abstract：Along ation technology development and the ERP system daily popularization, the puter is more and more not alloanagement function. This topic is aims at the enterprise the purchase management development system, I use present popular Visual Basic to make the development kit, the backstage use SQL the Server database. System involves the daily service, the stock management, the statistical inquiry, the foundation information, the system establishment and so on several big modules. The paper first prehensively and studied systematically has constructed an enterprise modity purchase management system management system necessary each kind of knoethod, carried on the system feasibility analysis, introduced the system development environment, the design system database, the plan enterprise modity purchase floet do system design, the subsystem development and the realization, finally ent and the issue explanation. （fakes every effort the theory and the practice unifies, odity purchase theory, the coordination analogous system