【正文】 浙江育英職業(yè)技術(shù)學(xué)院畢業(yè)論文 XD 網(wǎng)絡(luò)辦公系統(tǒng) 第 1 頁 共 38 頁 ASP 技術(shù)構(gòu)建 XD 網(wǎng)絡(luò)辦公系統(tǒng) [摘要 ] 網(wǎng)絡(luò)辦公系統(tǒng)是為適應(yīng)現(xiàn)代無紙化及網(wǎng)絡(luò)化辦公的趨勢，更好地服務(wù)于現(xiàn)代辦公操作，基于 Inter Web 開發(fā)的一套 廣泛應(yīng)用于各行業(yè)企事業(yè)單位的辦公自動化系統(tǒng)。 辦公自動化 (簡稱為 OAOffice Automation)。 本文論述了一個基于公司企業(yè)實(shí)現(xiàn)無紙化辦公的采用 B/S模式下的充分利用數(shù)據(jù)庫服務(wù)的整體軟件平臺的設(shè)計與實(shí)現(xiàn)。分析了該系統(tǒng)所適應(yīng)的計算機(jī)軟硬件的配置環(huán)境與選取的利弊。討論了系統(tǒng)的結(jié)構(gòu)框架和設(shè)計原理。說明了系統(tǒng)數(shù)據(jù)庫設(shè)計的思路與實(shí)現(xiàn)方法。系統(tǒng)構(gòu)建的 重點(diǎn)主要在于系統(tǒng)使用權(quán)限的設(shè)計 、 公司營運(yùn)流程的細(xì)分和模式化 、系統(tǒng)數(shù)據(jù)庫的合理設(shè)計與實(shí)現(xiàn)。本文中就如何在軟件中實(shí)現(xiàn)以上幾點(diǎn)作了詳細(xì)分析與講解，并給出了使用 Sql Server 數(shù)據(jù)庫建立本系統(tǒng)數(shù)據(jù)庫的實(shí)例。 關(guān)鍵字 B/S網(wǎng)絡(luò)辦公系統(tǒng) ASP SQL 技術(shù) [Abstract ] The work office system is for adapting to the modern with no paper at all and worked trend that handle official business, serve and handle official business modernly and operate better, a set of office automated systems applied to the every profession and trade enterprises and institutions extensively developed on the basis of Inter Web. Handle official business and turn (abbreviation into OA automatically Office Automation). This thesis is focused on the design and implementation of handle official business without paper, in the mode of pany management with fully Data Service utilization. By the analysis of system framework and deployment, we explore the specific structure of original Data extraction model, build up a simplized model with Data extraction, Data collection amp。 interpretation and report template filling as its three phases. The system structure mainly emphasizes on the process capability of large quantity of database, system efficiency and global parameter configuration, so as to lessen program redevelopment. In order to realize the above effects, such techniques are widely used in the system, as memory calculation, fast lookup algorithm, formula analysis algorithm, predication analysis, working procedure control, report template filling, among which several key technical calculation are provided. Key words B/S work office system ASP SQL technology 浙江育英職業(yè)技術(shù)學(xué)院畢業(yè)論文 XD 網(wǎng)絡(luò)辦公系統(tǒng) 第 2 頁 共 38 頁 目 錄 述 ................................................................................................................................ 4 ............................................................................................................... 4 ............................................................................................. 4 ........................................................................................................ 6 B/S 結(jié)構(gòu) ............................................................................................................... 6 網(wǎng)絡(luò)辦公系統(tǒng)所采用的技術(shù) ..................................................................... 10 ASP .................................................................................................................... 10 ASP 的特征 ......................................................................................................... 10 系統(tǒng)采用的加密與解密技術(shù) ...........................................................................................11 DES 對 稱加密算法 ................................................................................................11 MD5 不可逆加密方式 ........................................................................................... 17 SQL server 數(shù)據(jù)庫 ...................................................................................................... 18 3． XD 網(wǎng)絡(luò)辦公系統(tǒng)設(shè)計分析 ............................................................................ 20 權(quán)限設(shè)置 ...................................................................................................................... 21 系統(tǒng)結(jié)構(gòu)設(shè)計 ............................................................................................................... 22 系統(tǒng)主要界面介紹 ........................................................................................................ 23 .................................................................................................. 24 系統(tǒng)登陸代碼 ..................................................................................................... 24 添加數(shù)據(jù)代碼 ..................................................................................................... 25 刪除數(shù)據(jù)代碼 ..................................................................................................... 26 ...................................................................................................... 27 查詢數(shù)據(jù)代碼 ..................................................................................................... 28 .................................................................................................... 29 3． 1 數(shù)據(jù)表結(jié)構(gòu) ................................................................................................................. 29 動態(tài)信息表 ........................................................................................................ 29 ......................................................................................................... 29 公共計劃信息表 ................................................................................................. 30 公共通訊錄表 ..................................................................................................... 30 ......................................................................................................... 31 .................................................................................................. 31 .................................................................................................. 32 ......................................................................................................... 32 ......................................................................................................... 33 ....................................................................................................... 33 ..