随着社会经济的发展和计算机技术以及各种计算机应用技术的发展和成熟，各种信息管理系统进入了人类社会的各个领域并发挥了越来越重要的作用。这些信息系统给人们带来了快速，方便的管理体验。对于许多大型书店而言，一套完整的信息管理系统已成为日常管理的一部分对书店的进销存以及财务进行管理，而对于许多中小型书店来说，手工填制单据依然是主要的管理方式。这种传统的管理模式效率低下，无法及时全面了解各种图书的采购和销售以及库存的状况，不易在较短的时间内解决读者的需求。图书的入库以及出库更新管理比较麻烦，同时，手工填制单据的管理方式很难避免人为因素带来的错误，纰漏。

本次设计从中小型书店的角度出发，以更好地适应当前书店的销售需求，缓解手工管理存在的弊端为目的，开发了书店销售管理系统。首先本文系统讨论了书店管理的基本过程，并指出了人工管理的复杂性和不可靠性。然后设计了基于VB.NET平台和Microsoft SQL Server 数据库的书店销售管理系统。开发并实现了系统管理、图书管理、采购销售模块、实现了用户信息、仓库信息、客户信息、图书信息、图书类目、采购和销售信息的添加、删除、修改和查询等功能。

考虑到中小型书店的规模、特点和实力，本系统具有书店销售管理中基本功能，例如用户角色信息、仓库信息、客户信息、图书信息、图书类目信息、图书采购以及销售管理等功能。具有简洁，易操作的特点。

 

关键词：书店销售管理 VB.NET 数据库

 

 

 

Nowadays, with rapid developing of computers and applying of network technology, in order to make a great difference in efficiency and productivity, daily management should be freed from nagging formalities and other unnecessary items.. At present, a series of information managing system which is complete and well-working enough has been applied to large bookstore, while for some smaller ones most of work has been done by hand, which is incurring lower efficiency and higher energy-cost. Worse still, it is quite impossible for them to access to updated information on stock and reserve, being unable restructure promptly and dynamically since it is very hard to update and purchase new books and periodicals. In addition, readers cannot find out what they need as soon as possible. On the other hand, inevitably, the loss of data and imprecise delivery is rising.

In this graduation design, used the Visual Basic.NET platform and SQL Server of the company of Microsoft in order to develop the tool, combine to open into the request of the type library, complete to manage the need analysis, the function mold piece demarcation, the database mode analysis of the bookstore information system.

According to the running scales and the capacity of economy, this system has basic functions such as user information, warehouse information, books information, the categories information of books, purchasing and sales management, system management, and so on. Moreover, it shows simple interface and processing convenience. As an explore with practical meaning, the aim of this system is to offer a user-friendly and supplementary managing system to satisfy detailed needs of managing practice and business process. 

Key Words：Bookstore sales managing system  Information management system Visual Basic.NET  Database

 

 

摘  要.......................................................... Ι

Abstract........................................................ Ⅱ

目  录.......................................................... Ⅲ

第一章 绪论..................................................... 1

  1.1 课题背景.................................................. 1

  1.2 开发技术简介.............................................. 1

 1.2.1 Visual Basic.NET平台简介............................ 1

 1.2.2 ADO.NET简介......................................... 2

  1.3 数据库平台简介............................................ 3

 1.3.1 数据库简介........................................... 3

 1.3.2 Microsoft SQL Server简介............................ 4

  1.4 课题主要工作.............................................. 4

第二章 需求分析................................................. 5

  2.1 系统需求.................................................. 5

  2.2 功能需求.................................................. 5

 2.2.1 系统模块............................................. 5

 2.2.2 系统管理............................................. 5

 2.2.3 图书管理............................................. 6

 2.2.4 采购销售管理......................................... 6

第三章 总体设计................................................. 7

  3.1基本设计概念以及处理流程....................................... 7

  3.2系统分析.......................................................... 7

 3.2.1 系统划分............................................. 7

 3.2.2 子模块划分........................................... 8

 3.2.3 子模块功能描述....................................... 9

  3.3 数据库设计...................................................... 11

 3.3.1 数据库介绍........................................... 11

 3.3.2 数据库设计........................................... 11

第四章 系统实现与测试........................................... 16

  4.1 编写存储过程.................................................... 16

 4.1.1 添加客户............................................. 16

 4.1.2 删除客户............................................. 16

 4.1.3 更新客户信息......................................... 17

 4.1.4 获取所有用户信息..................................... 17

 4.1.5 添加书籍的流通信息................................... 17

  4.2 系统详细设计.................................................... 18

 4.2.1 主界面设计........................................... 19

 4.2.2 登录模块设计......................................... 20

 4.2.3 用户信息管理模块..................................... 22

 4.2.4 客户信息管理......................................... 26

 4.2.5 图书类目管理模块..................................... 29

 4.2.6 采购销售管理模块..................................... 31

  4.3 功能测试......................................................... 33

 4.3.1 测试方法............................................. 33

 4.3.2 测试结果............................................. 33

结论............................................................ 34

参考文献........................................................ 35

致谢............................................................ 36

 

 

 

 

第一章 绪论