书店图书库存管理系统设计与开发

思源书店图书库存管理系统设计与开发

摘 要

图书库存管理是书店销售保障的一项重要内容，其管理能力的高低直接关系着

书店的利益和竞争水平。本设计以此为切入点，采用结构化开发的方法，C#为前台

开发工具，SQL Server 2005为后台数据库，为思源书店研发了一个图书库存管理系统

主要完成图书信息管理、入库管理、出库管理和库存控制的功能，同时提供了多种检

索图书信息和库存信息的方式以及统计报表，更加便于对图书库存信息的统计和分析

此系统易操作，可靠性高，扩展性好，从而使书店实现了图书库存管理的信息化和网

湖南商学院学年设计

T h e bo o k i n v e n t o r y m a n a g e m e n t i s o n e o f t h e i m p o r t a n t c o n t e n t s o f t h e s a l e s o f

bookstore, the ability of the management is directly related to the bookstore’s interests and

co mpetitive l e v e l . So a b o o k i nv entory man a g e m e n t informa t i o n system was developed

f o r S I Y U A N b o o k s t o r e , u si n g s t r u c t u r e d a n d d e s i g n m e t h o d , w i t h C # u s e d i n t h e

foreground and SQL Server 2005 in the background. The MIS is made up of four parts as

books information management subsystem, inventory management subsystem, outbound

m a n a g e m e n t s u b s y s t e m a n d i n v e n t o r y c o n t r o l s u b s y s t e m, at t h e s a m e t i m e, i t p r o v i d e s

varies ways for the information in books and inventory, which is more user-friendly for

people to get the statistics and analysis about the book inventory information. This system

will reach the goal of informantionizing and internizing book inventory management, and

思源书店图书库存管理系统设计与开发

1．引言..................................................................................................1

1.1 项目来源..............................................................................................................1

1.2 任务目标..............................................................................................................1

2. 项目规划.............................................................................................1

2.1 项目资源..............................................................................................................1

2.2 项目规划..............................................................................................................2

3. 系统需求分析.......................................................................................3

3.1 业务需求..............................................................................................................3

根据本系统的项目规划、需求分析、系统结构设计等，可以得出系统的各个模块：用

户登录模块、图书管理模块、入库管理模块、出库管理模块、库存管理模块、系统管

理模块、用户管理模块和报表统计模块。....................................................13

系统名称：图书库存管理信息系统.............................................................13

模块名称：用户登录模块.........................................................................13

模块编号：1..........................................................................................13

上层调用模块：无...................................................................................13

可调用的下层模块：2,3,4,5,6,7,8............................................................13

输入数据：用户名、密码.........................................................................13

湖南商学院学年设计

输出数据：弹出登录成功提示框................................................................13

模块名称：图书管理模块.........................................................................13

模块编号：2..........................................................................................13

输入数据：图书信息................................................................................13

在，提示错误，存在则输出相应记录。.......................................................13

系统名称：图书库存管理信息系统.............................................................13

模块名称：入库管理模块.........................................................................13

模块编号：3..........................................................................................13

上层调用模块：1,2.................................................................................13

可调用的下层模块：5,8...........................................................................13

输入数据：入库信息................................................................................13

输出数据：入库信息表.............................................................................14

处理步骤：............................................................................................14

系统名称：图书库存管理信息系统.............................................................14

模块编号：4..........................................................................................14

输入数据：出库信息................................................................................14

输出数据：出库信息表.............................................................................14

处理步骤：............................................................................................14

系统名称：图书库存管理信息系统.............................................................14

模块名称：库存管理模块.........................................................................14

模块编号：5..........................................................................................14

上层调用模块：1,2,5,4...........................................................................14

可调用的下层模块：8..............................................................................14

输入数据：图书编号................................................................................14

思源书店图书库存管理系统设计与开发

输出数据：库存信息................................................................................14

系统名称：图书库存管理信息系统.............................................................15

模块名称：用户管理模块.........................................................................15

可调用的下层模块：1..............................................................................15

1.修改密码............................................................................................15

系统名称：图书库存管理信息系统.............................................................15

模块名称：系统管理模块.........................................................................15

模块编号：7..........................................................................................15

上层调用模块：......................................................................................15

可调用的下层模块：................................................................................15

输入数据：用户信息，角色信息................................................................15

输出数据：用户信息表，角色信息表..........................................................15

处理步骤：............................................................................................15

1.用户信息添加...................................................................................... 15

系统名称：图书库存管理信息系统.............................................................16

上层调用模块：......................................................................................16

可调用的下层模块：................................................................................16

输入数据：入库信息、出库信息、库存信息.................................................16

输出数据：入库统计报表、出库统计报表、库存盘点报表和库存报警..............16

处理步骤：............................................................................................16

5. 系统详细设计.....................................................................................17