【正文】 作態(tài)度,各種獎(jiǎng)勵(lì)及處罰,技術(shù)水平,備注。:包括評(píng)價(jià)的輸入,查詢和修改。數(shù)據(jù)流成圖中已經(jīng)劃分出系統(tǒng)必須完成的許多基本功能，系統(tǒng)分析員將仔細(xì)研究這些功能并進(jìn)一步將它們具體化。使用ADO的目的是進(jìn)入數(shù)據(jù)源,使得修改,更新數(shù)據(jù)成為可能[10]?；蛘唛_(kāi)始一個(gè)事務(wù)。目前,數(shù)據(jù)庫(kù)己經(jīng)成為現(xiàn)代信息系統(tǒng)的不可分離的重要組成部分。20世紀(jì)80年代中后期,在全國(guó)性的計(jì)算機(jī)應(yīng)用熱潮中,許多企業(yè)紛紛從財(cái)務(wù)管理、人事管理等單項(xiàng)應(yīng)用入手,嘗試建立MIS[10]。有了ActiveX技術(shù)，就可使用其他應(yīng)用程序提供的功能，例如，Microsoft Word字處理器，Microsoft Excel電子數(shù)據(jù)表及其他Windows應(yīng)用程序。第2章 相關(guān)工具的基本理論 關(guān)于VB的說(shuō)明Visual Basic 是Microsoft公司推出的一種Windows應(yīng)用程序的開(kāi)發(fā)工具。人事管理是任何企事業(yè)單位都需要進(jìn)行的一項(xiàng)工作,因此,開(kāi)發(fā)制作人事管理系統(tǒng)具有較大的社會(huì)現(xiàn)實(shí)意義,同時(shí)人事管理系統(tǒng)是一切應(yīng)用系統(tǒng)的典范,它具有一切應(yīng)用系統(tǒng)的特征,系統(tǒng)結(jié)構(gòu)與現(xiàn)實(shí)生活緊密結(jié)合,具體直觀,具有典范的數(shù)據(jù)庫(kù)系統(tǒng)的特性。因此,本文圍繞一個(gè)”人事管理系統(tǒng)”程序的設(shè)計(jì)和應(yīng)用系統(tǒng)的開(kāi)發(fā)課題為背景,詳細(xì)介紹了以VB和SQL SERVER為語(yǔ)言編寫(xiě)管理信息系統(tǒng)的過(guò)程。本系統(tǒng)根據(jù)企業(yè)管理的一些實(shí)際情況而編制的一套自動(dòng)化的人事管理系統(tǒng)。如果已使用過(guò)諸如Paint之類的繪圖程序，實(shí)際上就已經(jīng)掌握了創(chuàng)建用戶界面的必要技巧。管理信息系統(tǒng)起初應(yīng)用于最基礎(chǔ)的工作,如打印報(bào)表、計(jì)算工資、人事管理等,進(jìn)而發(fā)展到企業(yè)財(cái)務(wù)管理、庫(kù)存管理等單項(xiàng)業(yè)務(wù)管理,這屬于電子數(shù)據(jù)處理系統(tǒng)。在一般不引起混淆的情況下常常把數(shù)據(jù)庫(kù)系統(tǒng)簡(jiǎn)稱為數(shù)據(jù)庫(kù)。 ADO與SQL SERVER 2000 AxtiveX數(shù)據(jù)對(duì)象ADOADO,即Active 數(shù)據(jù)對(duì)象:實(shí)際是一種提供訪問(wèn)各種數(shù)據(jù)類型的連接機(jī)制。,則將它們保存在緩存中,產(chǎn)生相應(yīng)的數(shù)據(jù)集對(duì)象。SQL SERVER 2000可以使操作系統(tǒng)具有應(yīng)用程序數(shù)據(jù)庫(kù),并被優(yōu)化支持未連接用戶或移動(dòng)用戶。 系統(tǒng)設(shè)計(jì) 系統(tǒng)功能分析系統(tǒng)開(kāi)發(fā)的總體任務(wù)是要實(shí)現(xiàn)企業(yè)人事信息關(guān)系的系統(tǒng)化,規(guī)范化和自動(dòng)化。部門(mén)管理:編號(hào),名稱,部門(mén)經(jīng)理。具體數(shù)據(jù)表的設(shè)計(jì)如下面的表格所示。在編寫(xiě)程序的具體代碼之前首先要?jiǎng)?chuàng)建公用模塊,VB中可以用公用模塊來(lái)存放整個(gè)工程項(xiàng)目公用的函數(shù),過(guò)程和全局變量等。 員工基本信息模塊該模塊主要完成員工基本信息的輸入、查詢與修改,它定義了三個(gè)主要窗口:信息添加窗口、復(fù)合查詢窗口、員工信息列表窗口。輸入的出生日期按照YYYYMMDD的統(tǒng)一格式來(lái)錄入。查詢功能使用復(fù)合查詢的模式。用戶在列表中選擇了要操作的員工記錄后點(diǎn)擊該按扭,屏幕將出現(xiàn)員工信息添加窗體,窗體中體現(xiàn)出上一步用戶所選擇的員工記錄,在具體的文本框中寫(xiě)入修改的記錄,單擊保存按鈕出現(xiàn)”記錄保存成功”消息對(duì)話框,點(diǎn)擊確定按扭返回員工列表窗體,至此己完成了對(duì)員工信息的修改。考勤管理模塊同樣使用VB的ADO數(shù)據(jù)對(duì)象連接SQL SERVER數(shù)據(jù)庫(kù),使得前臺(tái)與后臺(tái)成功連接。這種使用方式的好處是讓用戶可以根據(jù)員工檔案的具體情況進(jìn)行編輯,對(duì)每個(gè)員工進(jìn)行考勤錄入,從而避免了不了解企業(yè)內(nèi)部員工檔案的實(shí)際情況而造成錯(cuò)誤的可能,同時(shí)也大大縮短了考勤操作的時(shí)間。在按考勤時(shí)間查詢中,用戶可以從ComboBox下拉列表中選擇出考勤的時(shí)間范圍。刪除員工信息的功能和修改功能類似,在列表中選擇要?jiǎng)h除的記錄后點(diǎn)擊鼠標(biāo)右鍵,在彈出的子窗體中選擇刪除信息彈出”是否刪除此記錄”對(duì)話框,點(diǎn)擊確定后完成了信息的刪除操作。滿足查詢要求的記錄都將出現(xiàn)在員工評(píng)價(jià)記錄列表框中。在月份文本框中使用的是Format(Now, yyyymmdd)函數(shù),直接添加計(jì)算機(jī)的系統(tǒng)日期。 圖413 員工工資報(bào)表窗體工資報(bào)表窗體做為子窗體來(lái)顯示。數(shù)據(jù)報(bào)表為我們提供了一個(gè)更加方便快捷地實(shí)現(xiàn)報(bào)表打印的方法。密碼更改的流程圖如圖417所示。在系統(tǒng)的編譯和發(fā)行以前,需要設(shè)置工程項(xiàng)目的屬性。在本系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)的過(guò)程中主要講述了企業(yè)人事管理信息系統(tǒng)的系統(tǒng)設(shè)計(jì)部分，包括功能模塊設(shè)計(jì)、數(shù)據(jù)庫(kù)結(jié)構(gòu)設(shè)計(jì)等。充分鍛煉了自己的動(dòng)手和應(yīng)用能力，真正做到了理論聯(lián)系實(shí)際。172～222 人民郵電出版社[10] Ullmanl,Principles of Database and knowledgeBase Systems,VolumeⅡ,Computer Science Press,New York,1989[11] : Database Management System, GRANADA London Toronto Sydney New York, 1985[12] Stonebraker M, et al: The Design of XPRS. Processing of VLDB, 1998[13] :Query Processing in Parallel Relational Database Computer Society Press, 1994附錄1 外文翻譯Management Information SystemIt is the MIS(Management Information System ) that we constantly say that the management information system , and is living to emphasize the administration , and emphasizes that it changes into more and more significantly and more and more is universalized in the contemporary munity of message . MIS is a fresh branch of learning, and it leaped over several territories, and for instance administers scientific knowledge, system science, operational research, statistic along with calculating machine scientific knowledge. Is living on these the branches of learning base, and takes shape that the message is gathered and the process means, thereby take shape the system that the crossbar mingles. 1. The Management Information System Summary20 centuries, in the wake of the flourishing development of whole world economy, numerous economists propose the fresh administration theory one by one. Xi Men propose the administration and was dependent on idea to message and decision of strategic importance in the 50’s 20 centuries. The dimension of simultaneous stage is admitted issuing cybernetics, and he thinks that the administration is a control procedure. In 1958, Ger. write the lid: “ the administration shall obtain without delay with the lower cost and exact message, pletes the better control “. This particular period, the calculating machine starts being used accountancy work. The data handling term has risen.In 1970, Walter give administration that has raised the only a short while ago information system term to get off a definition: “ either the cover of the book shape with the discount, is living appropriately time to director, staff member along with the outside world personnel staff supplies the past and now and message that internal forecasting the approaching relevant business reaches such environment, in order to assist they make a strategic decision”. Is living in this definition to emphasize, yet does not emphasize using the pattern, and mention the calculating machine application in the way of the message support decision of strategic importance. In 1985, admonishing information system originator, title Buddhist nun Su Da university administration professor Gordon give the management information system relatively integrated definition, in immediate future “ administer the information system is one use calculating machine software and hardware resources along with data bank man the engine system. It be able to supply message support business either organization operation, administration or the decision making function. Comprehensive directions of this definition management information system target and meritorious service capacity and ponent, but also make known the management information system to be living the level that attains at that time. The Developing History of MIS The management information system is living the most primarily phase is counting the system, the substance which researched is the regular pattern on face between the incremental data, it what may separate into the data being mutually related and more not being mutually related series, afterwards act as the data conversion to message. The second stage is the data are replaced the system, and it is that the SABRE that the American airline pany put up to in the 50’s 20 centuries subscribes to book the bank note system that such type stands for. It possess 1008 bank note booking spots, and may access 600000 traveler keep the minutes and 27000 flight segments record. Its operation is paratively more plex, and is living whatever one “spot ”wholly to check whether to be the free place up some one flight numbers. Yet through approximately attending school up to say, it is only a data and repla