企业进销存管理系统（C#含源代码） - 图文

河南科技大学本科毕业设计

摘 要

进销存管理系统旨在解决商业企业商品的采购、仓储、运输、配送、流通加工等一系列操作流程中的数据信息的处理问题，提供一系列的数据分析，帮助经营者合理的调整各个经营运作环节的运作节奏，并对商品流转过程进行了全程跟踪管理、相应款项流通的全程记录管理和票据信息统计的管理。因此进销存管理系统的全面应用，规范业务流程、提高了企业的管理水平，提高资金流动的透明度，加快商品资金周转速度，进而全面提高了企业的经营水平、进而全面提升了企业的经济效益。

进销存管理系统采用.NET技术和大型数据库SQL Server 2005开发，主要是处理商业企业商品的采购、库存和销售各个环节的活动，具有良好的人机界面；考虑到系统的使用对象可能较多，权限管理良好；数据查询方便，支持多条件查询；系统支持良好的数据备份和还原操作，有效保护数据，减少意外损失；在相应的权限下，可方便地删除数据；数据计算自动完成，尽量减少人工干预；报表分析商品进货、商品销售情况；强大的报表打印功能；报表基本信息查询时，可根据查询条件动态显示查询结果。

关键词： 进销存管理系统； .NET开发环境； C#语言； SQL Server 2005； 报表

I

河南科技大学本科毕业设计

Abstract

Purchase Sales Inventory Management System solves the business enterprises for procurement of goods, warehousing, transportation, distribution, circulation and processing of a series of operational procedures to deal with the issue of data, providing a wide range of data analysis to help operators of all reasonable measures to adjust the operation aspects of the operation of the rhythm and flow of goods throughout the tracking process management, and the corresponding flow of the entire record of the money management and paper management information statistics. Purchase Sales Inventory Management System is therefore a comprehensive application, standardized business processes and improve enterprise management level, improve the transparency of capital flows to accelerate the pace of commodity cash flow, and improve the operation of the enterprise level, thereby enhance the economic efficiency of enterprises.

Purchase Sales Inventory Management system applies .NET technologies and SQL Server 2005 database on large-scale development of commercial enterprises to deal primarily with the procurement of goods, inventory, and marketing activities, has a good human-machine interface;

II

河南科技大学本科毕业设计

taking into account the target system may be more , it has good rights management; query data to facilitate and support the multi-criteria query; the system supports good data backup and restore operations, the effective protection of data, loss of reduction of accidents; in the appropriate authority, can easily delete data; data auto-complete, as far as possible reduce human intervention; Statement Analysis purchase of goods, merchandise sales; powerful printing statements; statements of basic information may be based on dynamic query search results.

Key words： Purchase Sales Inventory Management System; .NET development environment; C# programming language; SQL

Server 2005; Crystal Reports

目 录

1 前言 .............................................................6

1.1 系统的现状以及研究意义 .....................................6 1.2 国内外文献综述 .............................................2 1.3 系统的基本内容综述 .........................................4 2 系统分析 .........................................................4

2.1 需求分析 ...................................................5 2.2 可行性分析 .................................................5 2.3 开发工具选择 ...............................................5

2.3.1 Visual Studio.NET平台简介 ............................5 2.3.2 C#语言简介 ............................................7 2.3.3 SQL Server 2005简介 ..................................8 2.4 管理信息系统逻辑模型设计 ...................................9

III

河南科技大学本科毕业设计

2.4.1 数据流程图 ............................................9 2.4.2 数据字典 .............................................11

3 系统设计 ........................................................12

3.1 项目规划 ..................................................12 3.2 系统功能结构 ..............................................13 3.3 设计目标 ..................................................13 3.4 开发及运行环境 ............................................14 3.5 数据库设计 ................................................14

3.5.1 数据表概要说明 .......................................14 3.5.2 数据库E-R图分析 .....................................15 3.5.3主要数据表的结构 ......................................17 3.6 新系统的主要功能模块设计 ..................................20

3.6.1 系统登录设计 .........................................20 3.6.2 系统主窗体设计 .......................................21 3.6.3 基本档案管理窗体设计 .................................23 3.6.4 进货管理窗体设计 .....................................26 3.6.5 销售管理窗体设计 .....................................28 3.6.6库存管理窗体设计 ......................................30 3.6.7报表窗体设计 ..........................................31 3.7系统的（硬件）系统结构与处理方式设计 ........................38

3.7.1系统处理方式 ..........................................38 3.7.2系统硬件配置 ..........................................38 3.7.3软件配置 ..............................................38 3.8系统的处理流程设计 ..........................................39

3.8.1系统业务流程分析 ......................................39 3.8.2新系统结构搭建 ........................................40

4 结束语 ..........................................................40 参考文献 ...........................................................41

IV