設(shè)備管理系統(tǒng)

摘  要
計(jì)算機(jī)技術(shù)飛速發(fā)展，信息化管理必不可少，企業(yè)要在激烈的市場(chǎng)競(jìng)爭(zhēng)中求得生存與發(fā)展，必須具有良好的設(shè)備管理水平。
此設(shè)備管理系統(tǒng)所用的開(kāi)發(fā)工具是Microsoft公司的面向?qū)ο蟮目梢暬幊坦ぞ遃B.NET和SQL Sever 2000。該管理系統(tǒng)在操作上集設(shè)備添加、維修、查詢(xún)、統(tǒng)計(jì)和報(bào)廢等處理為一體，從而使管理人員可以快速、準(zhǔn)確地掌握設(shè)備的庫(kù)存信息、維修記錄和使用現(xiàn)狀，逐步使設(shè)備管理工作標(biāo)準(zhǔn)化、規(guī)范化，提高設(shè)備的管理水平，減少了企業(yè)內(nèi)部的機(jī)構(gòu)設(shè)置 ，精簡(jiǎn)了人員。
通過(guò)使用該設(shè)備管理系統(tǒng)可以及時(shí)更新設(shè)備庫(kù)，為企業(yè)生產(chǎn)提供優(yōu)良而又經(jīng)濟(jì)的技術(shù)裝備，保證生產(chǎn)的順利進(jìn)行，從而提高生產(chǎn)效率，降低生產(chǎn)成本，使企業(yè)獲得最高經(jīng)濟(jì)效益。

關(guān)鍵詞：設(shè)備管理，面向?qū)ο?，VB.NET，SQL Sever 2000

ABSTRACT
The Computer technology fast develop, and it is indispensable of the management of imformationalization. The enterprises which want to exist and develop in vigorous market competition, must reach very good equipments management level.
    The development tools what the equipments management system uses are the product of Microsoft company, one is VB.NET which is Object_orient and visible programming and the other is SQL Sever 2000.As this management system integrate all kinds of handles as a whole, such as, the equipments adding, maintaining, searching, counting and discarding etc. it can make administrators master the stock information, maintaining records and present using condition of the equipments fast and accurately, equipments management work standardized and regularization, and the level of equipments management improvement, besides, internal organization establishes and the personnel simplify.
    Through the use of the equipments management system they can update equipments warehouse in time, can supply good and economic technique equipment for the enterprise production and can offer the guarantee to the production smooth, after that the efficiency of production can improve, the production cost can go down, and economic benefits of the enterprise can get the supreme.

Keywords：Equipments management，Object_orient，VB.NET，SQL Sever 2000

目  錄
 
緒論 1
1  開(kāi)發(fā)工具 2
1.1  Visual Basic.NET語(yǔ)言概述 2
1.1.1  Visual Basic.NET基礎(chǔ)知識(shí) 2
1.1.2  ADO數(shù)據(jù)訪(fǎng)問(wèn)組件 3
1.2  DateTimePicker 控件 4
2  需求分析 5
2.1  需求分析的任務(wù) 5
2.1.1  對(duì)系統(tǒng)的綜合要求 5
2.1.2  分析系統(tǒng)的數(shù)據(jù)要求 5
2.1.3  系統(tǒng)的數(shù)據(jù)流圖 6
2.2  數(shù)據(jù)流圖 8
2.3  ER模型 8
2.3.1  概念介紹 8
2.3.2  E-R圖 9
2.4  功能概述 11
2.4.1  適應(yīng)性 11
2.4.2  主要功能簡(jiǎn)介 11
2.5  軟件的設(shè)計(jì)要求 12
3  總體設(shè)計(jì) 13
3.1  總體設(shè)計(jì)的過(guò)程 13
3.2  面向?qū)ο蟾攀?nbsp;13
3.3  系統(tǒng)總體設(shè)計(jì) 13
3.3.1  功能分解 13
3.3.2  模塊設(shè)計(jì) 14
3.4  數(shù)據(jù)庫(kù)的設(shè)計(jì)工具（SQL Server） 14
3.4.1  關(guān)系數(shù)據(jù)庫(kù)標(biāo)準(zhǔn)語(yǔ)言SQL 14
3.4.2  SQL命令 15
3.4.3  SQL子句 15
3.4.4  SQL運(yùn)算符及其含義 16
3.4.5  集函數(shù) 16
3.5  數(shù)據(jù)庫(kù)的建立 16
4  詳細(xì)設(shè)計(jì) 19
4.1  詳細(xì)設(shè)計(jì)概要 19
4.2  整體結(jié)構(gòu)詳細(xì)設(shè)計(jì) 19
5  編碼 26
5.1  編碼的目的 26
5.2  程序設(shè)計(jì)語(yǔ)言 26
5.3  系統(tǒng)實(shí)現(xiàn) 26
6  測(cè)試 28
6.1  軟件測(cè)試概念 28
6.2  測(cè)試的目的 28
6.3  測(cè)試的目標(biāo) 28
6.4  軟件測(cè)試的對(duì)象 28
6.5  測(cè)試步驟 29
6.5.1  模塊測(cè)試 29
6.5.2  子系統(tǒng)測(cè)試 29
6.5.3  系統(tǒng)測(cè)試 30
總 結(jié) 31
致 謝 33
參考文獻(xiàn) 34
附錄一 部分源程序代碼 35
附錄二 英文資料（1） 40
附錄三 英文資料（2） 55
附錄四 英文譯文（1） 70