aisle送水管理系统设计与实现设计

送水管理系统设计与实现

学

院

专

业

班

级

学

号

姓

名

指导教师

负责教师

计算机学院

计算机科学与技术

沈阳航空航天大学

摘

要

本文主要介绍送水管理系统的设计 与实现。该系统采用

C/S

架构，基于

.NET

Framework

技术开发，使用

C#

语言。数据库方面则采用

SQL Server 2008

对数据进行

操作，使用

ODB C

技术对数据库进行操作。主要实现的功能有销售管理、产品库存

管理、基本信息管理、售后管理等。

本文着重从概述、

需求分析及方案论证、

概要设计、

详细设计 以及系统测试五个

部分进行阐述。首先，概述主要介绍项目背景、项目内容及要求；其次 ，需求分析及

方案论证主要对该软件进行分析以及进行可行性研究，

了解该软件在市场上的发展空

间及实现所需要的软件；再次，概要设计、详细设计主 要介绍该软件总体思想、所需

要的技术及内部程序是如何实现；

最后，

经过系统测试，

实现该软件的每个运行模块

正确无误，达到项目的要求和设计目标。

关键词< /p>

：送水；

.

NET Framework

；

C#

；

SQ L Server 2008

，模块

Bottled water management system design and implementation

Abstract

This

paper

mainly

describes

the

design

and

implementation

of

the

bottled

water

management system. The system adopts C/S architecture, based on the .NET Framework

technology development, using the C# language. Databases are used to manipulate data in

SQL Server 2008, operating the database by using ODBC technology. The main function

is to realize the sales management, inventory management, basic information management,

customer service management.

This article focuses on an overview of the needs analysis and demonstration program,

outline design, detailed design, as well as five parts of the system test described. First, an

overview

introduces

the

project

background,

project

content

and

requirements;

Second,

demand

analysis

and

solution

of

the

main

argument

software

analysis

and

carry

out

a

feasibility study, understand the software in the market development space and realize the

software needed; again, the outline design, detailed design mainly introduces the general

idea of software, the required technology and internal procedure is how to achieve; finally,

after testing the system, the implementation of the software for each operation module is

correct, meet the requirements of the project and the design goal.

Keywords:

Water supply

；

.NET Framework

；

C#

；

SQL Server 2008

；

Modular

目

录

1

概

述

.......................... .................................................. .................................................. . 1

1.1

项目背景

.

.................................................. .................................................. ................ 1

1.2

项目内容及要求

.

< br>............................................... .................................................. ....... 1

2

需求分析及方案论证

.................. .................................................. ................................... 3

2.1

需求分析

< br>.

................................... .................................................. ............................... 3

2.1.1

任务概述

...... .................................................. .................................................. .... 3

2.1.2

任务分析

....................... .................................................. ..................................... 3

2.2

方案论证

< br>.

................................... .................................................. ............................... 3

2.2.1

经济可行性

..... .................................................. .................................................. . 4

2.2.2

技术可行性

...................... .................................................. .................................. 4

3

概要设计

.......... .................................................. .................................................. ............. 6

3.1

功能模块分析

.

................................................ .................................................. .......... 6

3.2

数据库设计

.

................................................. .................................................. ............. 7

3.2.1

概念模型（

E-R

图）

< /p>

.

............................ .................................................. ............ 7

3.2.2

表设计

........................ .................................................. ...................................... 10

3.2.3

数据库物理结构

.................... .................................................. .......................... 12

4

详细设计

.......... .................................................. .................................................. ........... 13

4.1

表层设计

.

.................................................. .................................................. .............. 13

4.1.1

用户登录

....................... .................................................. ................................... 13

4.1.2

主界面显示

..... .................................................. ................................................. 14

4.2

系统功能分析

.

................................................ .................................................. ........ 15

4.2.1

销售管理

....................... .................................................. ................................... 15

4.2.2

产品库存管理

.... .................................................. .............................................. 18

4.2.3

基本信息管理

..................... .................................................. ............................. 19

4.2.4

售后管理

...... .................................................. .................................................. .. 21

5

系统测试

....................... .................................................. ................................................ 22

5.1

编码问题

.

.................................................. .................................................. .............. 22

5.2

测试主要功能实现情况

.