毕业设计（体育设施）

体育用品租借管理系统

摘 要

一个良好实用的体育用品租借管理系统应该能够对体育用品进行全方位的租借管理，其主要功能应包括体育用品入库管理，场地管理，租借管理，丢失故障管理，用户信息管理，系统信息管理等功能，以满足对体育用品的各种处理。在开发此系统时首先对所要设计的内容作了详细的准备，分析系统功能，确定基本框架。再建立相应数据库表结构，最后再开始编码。系统功能的实现,大大提高了体育用品租借管理的合理性以及效率性。

本系统用户界面友好，实用性强，容易被用户掌握.它的主要目的是为客户提供方便的租借服务，并且能够提高体育用品管理人员的工作效率。管理人员只需在用户界面上输入用品信息，场地信息就可以实现对用品和场地进行入库、租借等信息的管理。当用品和场地被租借时，系统就会自动进行计时计费，可以实时的查询到相关的数据。本系统还提供了对用品和场地进行丢失和故障的管理。本系统的开发是在MICROSOFT WINDOWS XP操作系统下，使用Microsoft Visual Studio 2008 作为开发工具，SQL SERVER 2005 作为后台数据库来实现的。

关键词：体育用品租借管理系统, c#,asp.net,Sql server

1

Abstract

A practical and good sporting goods rental management system should be able to sporting goods for a full range of rental management, its main function should include sporting goods storage management, venue management, lease management, loss, fault management, the user information management, information management, etc.functions to meet the processing of a variety of sporting goods. First in the development of this system to design the contents of detailed preparation, analysis of system functions to determine the basic framework. The corresponding database table structure, and finally start coding. Realization of system functions, greatly improving the rationality and efficiency of the management of sporting goods rental.

Of the system user-friendly, practical, easy for users to grasp. Its main purpose is to provide customers with convenient rental services, and to improve the work efficiency of the management of sporting goods. Management only in the user interface, input supplies, and venue information can be achieved on the management of information storage, rental of supplies and venues. Supplies and site lease, the system will automatically time billing, real-time query to the data. The system also provides supplies and site management of loss and failure. The development of this system is THE MICROSOFT WINDOWS XP operating system using Microsoft Visual Studio 2008 as a development tool, SQL SERVER 2005 as back-end database.

Keywords: sporting goods rental management system, c #, ASP.NET, Sql the server

2

目录

摘 要.............................................................................................................................. 1 ABSTRACT ................................................................................................................... 2 介绍................................................................................................................................ 6 第一章课程背景............................................................................................................ 7 1.1现状...................................................................................................................... 7 1.2研究的意义.......................................................................................................... 8 1.3概要...................................................................................................................... 8 第二章可行性分析........................................................................................................ 8 2.1组织和管理可行性.............................................................................................. 8 2.2 经济可行性 ......................................................................................................... 8 2.3 技术可行性 ......................................................................................................... 9 第三章需求分析.......................................................................................................... 11 3.1 用户分析 ........................................................................................................... 12 3.2 功能分析 ........................................................................................................... 12 3.2.1 用户管理功能............................................................................................ 12 3.2.2 体育器材的管理........................................................................................ 12 3.2.3 租借归还管理.......................................................................................... 12 3.2.4 丢失和故障管理........................................................................................ 13 3.2.5 数据库的备份还原管理............................................................................ 13 3.3 开发工具 ........................................................................................................... 13 3.3.1 Microsoft Visual Studio 2008 ..................................................................... 13 3.3.2 c# ................................................................................................................. 14 3.3.3 SQL Server 2005 ......................................................................................... 14 第四章系统设计.......................................................................................................... 15 4.1 系统界面设计 ................................................................................................... 15 4.1.1 登陆界面.................................................................................................... 15 4.1.2 系统主页面................................................................................................ 15 4.2 数据库设计 ....................................................................................................... 16 4.2.1 导论............................................................................................................ 16

3

4.2.2 数据库的选择............................................................................................ 16 4.2.3 数据库的概念设计.................................................................................... 17 4.2.3.1 表DB_Admin（操作员表） ............................................................. 17 4.2.3.2 表DB_Lease(租借表) ........................................................................ 17 4.2.3.3 表DB_ReportedLoss（丢失报损表） .............................................. 18 4.2.3.4 表DB_Stock（库存表） ................................................................... 18 4.2.3.5 表DB_Type(分类表) ......................................................................... 19 4.2.3.6 表DB_User(用户表) ........................................................................ 19 4.2.4 数据库逻辑设计........................................................................................ 20 4.2.4.1 操作员表............................................................................................. 20 4.2.4.2 表DB_Lease设施租借表 .................................................................. 20 4.2.4.3 表DB_ReportedLoss丢失故障表 ..................................................... 21 4.2.4.4 库存表................................................................................................. 22 4.2.4.5 类别表................................................................................................. 23 4.2.4.6 用户表................................................................................................. 23 第五章系统的实现...................................................................................................... 24 5.1 导论 ................................................................................................................... 24 5.2 系统功能的实现 ............................................................................................... 24 5.2.1 登陆模块.................................................................................................... 24 5.2.1.1 功能描述............................................................................................. 24 5.2.1.2 活动图................................................................................................. 25 5.2.1.3 GUI实现 .......................................................................................... 25 5.2.1.4 代码陈述............................................................................................. 27 5.2.2 添加用户.................................................................................................... 30 5.2.2.1 功能描述............................................................................................. 30 5.2.2.2 活动图................................................................................................. 30 5.2.2.3 GUI实现 ............................................................................................. 31 5.2.2.4 代码陈述............................................................................................. 33 5.2.3 体育器材入库............................................................................................ 34 5.2.3.1 功能描述............................................................................................. 34 5.2.3.2活动图.................................................................................................. 35 5.2.3.3 GUI实现 ............................................................................................. 35 5.2.3.4 代码陈述............................................................................................. 38

4

第六章总结.................................................................................................................. 40 引用.............................................................................................................................. 42 参考文献...................................................................................................................... 42 致谢.............................................................................................................................. 43

5

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库毕业设计（体育设施）在线全文阅读。