摘要本系统用于实现对装修公司中装修材料的规范管理。系统实现了装修公司对装修材料的保管和使用的全过程的管理功能，并可以为装修材料采购人员提供装修材料采购计划，使材料采购人员能更及时的完成自己的采购任务。42784

本系统具体实现了装修公司的材料的查询、材料信息的修改、材料的出库与入库、材料的月度盘库与年度盘库。此外，系统还实现了对供应商信息的查询、修改与添加的操作和材料使用的申请与材料申请的审批等功能。

系统的开发工具采用SQL Server 2008和Visual Studio 2013来完成本系统的实现。使用SQL Server2008完成数据库的设计与实现，Visual Studio 2013完成了界面的设计与系统功能的实现。

本文除了对系统的系统总体设计、系统详细设计、系统功能实现和数据库设计进行简要介绍之外，还介绍了有关系统开发的相关信息和相关技术信息。

关键词  企业管理，信息化，网络化，B/S结构，装修材料

毕业论文设计说明书外文摘要

Title  The design and implement of material management system  for decoration company                                

Abstract

This system is used to achieve the decoration company decoration materials standardized management. System management functions to achieve the storage and use of decoration company decoration materials the whole process, and can provide decoration materials  procurement plans for procurement staff.Procurement staff can make the material more timely completion of their task of procurement.

The system realizes the query of decoration materials information, modify decoration materials information, the material library and storage, monthly and annual stocktaking of the library material. In addition, the system also allows  query manufacturers' information , modify manufacturers' information and add new

manufacturers' information.The system can realize the function of decoration materials application and approval of decoration materials function.

System development tools using Server SQL 2008 and Studio Visual 2013 to complete the implementation of the system. Using Server2008 SQL to complete the design and implementation of the database, Studio Visual 2013 to complete the design of the interface and the realization of the system function.

In this paper, in addition to the realization of the system, the overall system design, system detailed design, system function and database design are briefly introduced. It also introduces the system development on the relevant information and related information technology.

Keywords  enterprise management, information technology, network, B/S structure, decoration materials

目   次

1绪论 1

1.1研究背景及意义 1

1.2研究现状及问题 1

2系统开发工具与开发平台简介 3

2.1 开发平台和技术介绍 3

2.1.1 ASP.NET开发环境 3

2.1.2 IIS简介 3

2.2 Visual Studio 2013 3

2.3 SQL Server 2008 4

2.4 C#编程语言 4

3系统总体设计 5

3.1系统模块总体设计 5

3.2数据库结构设计 6

3.2.1数据库逻辑结构设计