VB 人事工資管理系統(tǒng)

1、warm Franco-Prussian peace and harmony and the new year greeting cards, and the publicity photo gallery and the 2015 law and usage, law-abiding Holler, promotional materials such as calendars, market day, Festival Community law, legal in rural activities. Meanwhile, the County 9 townships (towns) Le

2、gal Office 85 villages, 4 community two committees cadre carried out against the peoples mediation law and standardized legal documents, the rural land contracting law and the rule of law training tour of the Marriage Act and other laws and regulations. Meanwhile, the party members of the party scho

3、ol teaching resources and annually to the village (community) the favorable opportunity for the County Clerk training 23,000 rural pave the way for the law and the 1972 legal advocacy Center legal publicity and education, increase their use of legal means to manage rural services, the ability to pre

4、vent and deal with conflicts and disputes. (Assessment points 3 points, since assessment 3 points) 13. increased on farmers workers Franco-Prussian education efforts, regularly in-depth to farmers workers concentrated live to, and work places and the main activities places carried out regular of rul

5、e of law education; insisted who competent who Franco-Prussian, and who labor who Franco-Prussian of work principles, State-owned enterprises, labor units established has farmers workers continues to Franco-Prussian education system, regularly or not regularly organization carried out education trai

6、ning. Franco-Prussian Union-related functions in the County Fairgrounds, station distribution center for migrants, legal service through the establishment of enquiry points and propaganda materials, sent out vans, station electronic display rolling, installation of car popularization anime and other

7、 forms of floating on the rule of law publicity and education activities. Positive return during the legal education of migrant workers, improve migrant workers law concept and awareness of labor rights according to law. For five years, and floating population of migrant workers, the rule of law pub

8、licity and education activities reached more than 600 times, issue the labor contract law, the census law, literature, more than 10,000 copies. (Assessment points 3 points, since assessment 3 points) three, and to innovation seeking development, further deepening rule of law publicity education of w

9、ay method, solid advance 65 Franco-Prussian target task of completed (assessment points 30 points, since assessment 30 points) 1. to legal six into activities for carrier, to I County 193 support rule of law publicity literary team for relies on, take masses joy Le see of national dance, and sketch,

10、 publicity way, active advance area within rule of law publicity education activities, County minority masses, and Religious clergy and religious peoples legal awareness is increased further. (Check with 3 points, scoring 3 points) 2. promote legal six kinds of entering activities, and vigorously ex

11、pand law six kinds of entering connotation and extension activities, establish a legal six kinds of entering model typical, typical leading and exemplary role in promoting the rule of law publicity and education work in our County, the County set up legal six kinds of entering model typical of 11. (

12、Check with 3 points, self-evaluation-3) 3. carrying out who is in charge of who Franco-Prussian, who law enforcement who legal principle, enactment of the XX County implement who is in charge of who摘 要由于計(jì)算機(jī)技術(shù)的飛速發(fā)展,數(shù)據(jù)庫技術(shù)作為數(shù)據(jù)管理的一個(gè)有效的手段,在各行各業(yè)中得到越來越廣泛的應(yīng)用。因此,本文圍繞一個(gè)”人事管理系統(tǒng)”程序的設(shè)計(jì)和應(yīng)用系統(tǒng)的開發(fā)課題為背景,詳細(xì)介紹了以VB和SQL

13、SERVER為語言編寫管理信息系統(tǒng)的過程。該程序通過VB的ADO數(shù)據(jù)對象來實(shí)現(xiàn)VB前臺(tái)與后臺(tái)SQL SERVER數(shù)據(jù)庫的連接,并具有典型的數(shù)據(jù)庫應(yīng)用系統(tǒng)的特征,完成了系統(tǒng)結(jié)構(gòu)與現(xiàn)實(shí)生活的緊密結(jié)合。管理系統(tǒng)的開發(fā)不僅是一個(gè)應(yīng)用程序編寫的過程,更重要的是在系統(tǒng)分析和設(shè)計(jì)階段所做的工作。該程序在設(shè)計(jì)過程中嚴(yán)格遵循軟件工程學(xué)的方法,用分階段的生命周期計(jì)劃嚴(yán)格管理,并主要講述了程序的總體設(shè)計(jì)、詳細(xì)設(shè)計(jì)階段,對程序進(jìn)行需求迭代,不斷修正和改進(jìn),利用SQL SERVER的強(qiáng)大數(shù)據(jù)庫功能,直到形成一個(gè)完善的可行性系統(tǒng).優(yōu)美、秀麗的界面,方便實(shí)用的查詢與維護(hù)功能共同構(gòu)成了“人事工資管理系統(tǒng)”。關(guān)鍵詞：VB，SQ

14、L SERVER，數(shù)據(jù)庫，軟件工程，管理信息系統(tǒng)AbstractBecause of the rapid development of computer technology, database technology as an effective means of data management, in all walks of life are increasingly wide application. Therefore, this article on a personnel management system design and procedures for applicatio

15、ns development topics background, details and SQL Server to add language to the process of preparing management information systems. The procedure adopted to achieve the target data add the ado with VB prospects background SQL Server databases and database applications with typical characteristics,

16、and completed the structure and system combining real life. Management system applications development is not only a preparation process, but more importantly in the analysis and design phase work. The procedure strictly followed in the design process software engineering methods, and use a phased p

17、lan to manage the life cycle and on the main procedures designed, detailed design stage, the demand for computation procedures, and constantly revised and improved, the use of SQL Server powerful database functions, Until the feasibility of forming a perfect system. beautiful and attractive interfac

18、e for practical information and the maintenance of the common functions constitute a Personnel wage management system.Keyword: VB，SQL SERVER，Database, Software Engineering, Management Information SystemsFranco-Prussian, who law enforcement who legal literacy of the application of the principles at w

19、ork (law Pu (2013), 6th) issued the single . Is the backbone area the rule of law publicity and education. (Assessment-2-, self-evaluation-2) 7. 65 Franco-Prussian work yilai, I County active using 3.8 womens day, and March fully rule publicity months and 3.15 consumers interests protection day, and

20、 five or four youth day, and 6.24 international drug day, and 6.25 land day for opportunity, combined 12.4 national Constitution Day cum national rule of law publicity day, major activities, and important node, using fair day carried out forms of rule of law publicity topic activities, on women inte

21、rests guarantees method, and marriage method, and land method, and water And the law on notary, the peoples mediation law and other professional law legal advocacy work. In five years, distribute all kinds of rule of law information materials (126,700), accepts all kinds of legal advice 18,000 visit

22、ors, posting signs more than 4,000 articles, achieve legal literacy does not remain dead, keep. (Check with 3 points, self-evaluation-3) 8. solid advance rule of law culture construction activities, 65 Franco-Prussian work yilai, in County carried out has Chinese soul? flying dream rule of law readi

23、ng activities; September 2014, rule of law culture construction model base in mill black town middle school tone established, Franco-Prussian do, and Judicial Council gift youth legal reading more than 1000 more than this; 2015 television opened rule of law XX column, total making broadcast 4 period

24、, 16 article rule of law news program. And give full play to 193 of the county supported the rule of law role of literary propaganda through popular and accessible essays, Allegro, dancing a variety of theatrical interpretation of laws and regulations promote the rule of law, they performed as the c

25、ouple mahjong and the conciliation officers patrol in mind, collection and other programmes are well received by the masses. (Check with 3 points, self-evaluation-3) 9. increase grass-roots mass culture of rule of law activities of the guidance, support, and training grass-roots cultural awareness c

26、ultural backbone of rule of law, the County year-round theatrical performance teams a total of 31 total support rule of law, mass culture of rule of law activities and healthy development. (Evaluation of 3 minutes, scoring 3 points) 10. active use of the Web site, television, mobile phones and other

27、 new media law publicity and education activities carried out. In June 2013, XX law popularization network officially opened, its built and opened, XX is the rule of law propaganda education implementation of networked communication, actively develop Franco-Prussian governance according to law, inno

28、vation is a new initiative of the Franco-German forms of governance according to law; departments of industry and commerce, taxation, society set up the rule of law promotion portal sites; more than 6,900 employees from all walks of life the cadres and masses throughout the County opened a Franco-Ge

29、rman mobile news-XX news. (Check with 3 points, self-assessment 3 points) 11. focus on combining rule by law education and rule of law. In August 2011, my County is named after the town of XX district village, Meng first border village, fengyang community 45 villages (communities) in April 2014, nam

30、ed Secretary for Commerce and industry, West side community as rule of law to create demonstration unit. (Check with 3 points, self-evaluation-3) four,II 目 錄摘 要IAbstractII第1章 緒論1第2章 相關(guān)工具的基本理論32.1 關(guān)于VB的說明32.2 關(guān)于管理信息系統(tǒng)32.3 數(shù)據(jù)庫系統(tǒng)概述42.4 ADO與SQL SERVER 200052.4.1 AxtiveX數(shù)據(jù)對象-ADO52.4.2 關(guān)于SQL SERVER 20005第

31、3章 系統(tǒng)需求分析與總體設(shè)計(jì)63.1 需求分析63.2 系統(tǒng)設(shè)計(jì)63.2.1 系統(tǒng)功能分析63.2.2 數(shù)據(jù)流程圖83.3 數(shù)據(jù)庫設(shè)計(jì)93.3.1 數(shù)據(jù)庫需求分析93.3.2 實(shí)體之間的ER模型93.3.3 數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計(jì)103.4 本章小結(jié)13第4章 系統(tǒng)詳細(xì)設(shè)計(jì)144.1 系統(tǒng)模塊的具體實(shí)現(xiàn)144.1.1 系統(tǒng)的主界面144.1.2 員工基本信息模塊164.1.3 員工考勤模塊204.1.4 員工評價(jià)模塊244.1.5 員工工資管理模塊244.1.7 部門管理模塊274.1.8 系統(tǒng)其它功能簡介284.2 本章小結(jié)29第5章 系統(tǒng)運(yùn)行與測試30結(jié) 論31致 謝32參考文獻(xiàn)33附錄1 外

32、文翻譯34附錄2 譯文41附錄3 系統(tǒng)的實(shí)現(xiàn)代碼45第1章 緒論隨著計(jì)算機(jī)的日益普及和網(wǎng)絡(luò)的發(fā)展,數(shù)據(jù)庫的應(yīng)用范圍越來越廣,數(shù)據(jù)庫應(yīng)用的功能也越來越強(qiáng),因此編寫管理信息系統(tǒng)應(yīng)用程序也顯得尤為重要,在強(qiáng)調(diào)管理,強(qiáng)調(diào)信息的現(xiàn)代社會(huì)中它變得越來越普及。人事管理是任何企事業(yè)單位都需要進(jìn)行的一項(xiàng)工作,因此,開發(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ù)庫系統(tǒng)的特性。人事管理系統(tǒng)主要用于企業(yè)內(nèi)部員工的檔案、工資、考勤、評價(jià)的管理,便于公司領(lǐng)導(dǎo)掌握人員的動(dòng)向,及時(shí)調(diào)整人才的分配,同時(shí)也減少了手工

33、操作帶來的一些繁瑣與不便,使員工情況的記錄和統(tǒng)計(jì)變得十分簡單.這些優(yōu)點(diǎn)可以極大的提高企業(yè)對人事管理的效率.因此,人事管理系統(tǒng)是企事業(yè)信息化、智能化、科學(xué)化和正規(guī)化不可缺少的管理軟件。本系統(tǒng)開發(fā)的目的一方面從提高人事管理工作的效率出發(fā)，擺脫過去由人用紙和筆進(jìn)行的費(fèi)時(shí)費(fèi)力的繁重工作，即利用成熟的計(jì)算機(jī)系統(tǒng)來實(shí)現(xiàn)商品管理工作的自動(dòng)化。本系統(tǒng)根據(jù)企業(yè)管理的一些實(shí)際情況而編制的一套自動(dòng)化的人事管理系統(tǒng)。人事管理系統(tǒng)針對企業(yè)員工信息的處理工作采用計(jì)算機(jī)進(jìn)行全面的現(xiàn)代化管理,主要包括:.員工基本信息的管理.員工評價(jià)的管理.員工考勤信息的管理.員工工資的管理.企業(yè)內(nèi)部人事變動(dòng)的管理.企業(yè)部門管理用戶通過輸入員

34、工的基本信息、考勤信息等,由系統(tǒng)自動(dòng)生成相應(yīng)的統(tǒng)計(jì)數(shù)據(jù)及工資統(tǒng)計(jì)報(bào)表以供用戶查詢、打印,另外用戶還可以對這些基本信息進(jìn)行定期的更新與刪除工作,人事管理系統(tǒng)力求以方便快捷的途徑去管理手工操作的每繁瑣數(shù)據(jù)。人事管理系統(tǒng)的數(shù)據(jù)要求具有一定的保密性禁止非法用戶使用。在用戶使用過程中對用戶的權(quán)限具有一定的限制,防止個(gè)別用戶對員工信息做出修改、刪除等操作。本文首先介紹了人事管理系統(tǒng)所涉及工具和一些相關(guān)的理論知識(shí)，并注重介紹了企業(yè)管理系統(tǒng)和數(shù)據(jù)庫,其中包括對Visual Basic 6.0 和SQL SERVER 2000的使用和特點(diǎn)進(jìn)行了介紹，然后對所做系統(tǒng)進(jìn)行總體設(shè)計(jì)，數(shù)據(jù)庫的設(shè)計(jì)和詳細(xì)設(shè)計(jì)，從這三個(gè)方

35、面詳細(xì)闡明系統(tǒng)的設(shè)計(jì)過程，最后，在編程實(shí)現(xiàn)的過程中，介紹本人使用Visual Basic 6.0對數(shù)據(jù)庫基應(yīng)用程序進(jìn)行設(shè)計(jì)、開發(fā)與實(shí)現(xiàn)的思路、算法、并得出結(jié)論。第2章 相關(guān)工具的基本理論2.1 關(guān)于VB的說明Visual Basic 是Microsoft公司推出的一種Windows應(yīng)用程序的開發(fā)工具。由于它具有使用方便，簡單易學(xué)、功能豐富等特點(diǎn)，迅速成為最流行的Windows應(yīng)用程序的開發(fā)工具之一。何謂Visual Basic ?“Visual”指的是開發(fā)圖形用戶界面（GUI）的方法，不需編寫大量代碼去描述界面元素的外觀和位置，而只要把預(yù)先建立的對象加到屏幕上即可。如果已使用過諸如Paint之

36、類的繪圖程序，實(shí)際上就已經(jīng)掌握了創(chuàng)建用戶界面的必要技巧。“Basic”指的是BASIC（Beginners All-Purpose Symbolit Instruction Code）語言，這是一種在計(jì)算技術(shù)發(fā)展史上應(yīng)用得最為廣泛的語言。Visual Basic 在原有BASIC語言的基礎(chǔ)上進(jìn)一步發(fā)展，目前包含了數(shù)百條語句、函數(shù)及關(guān)鍵詞。其中，很多和Windows GUI有直接關(guān)系。數(shù)據(jù)訪問特性允許對包括Microsoft SQL Server和其他企業(yè)數(shù)據(jù)庫在內(nèi)的大部分?jǐn)?shù)據(jù)庫格式建立數(shù)據(jù)庫和前端應(yīng)用程序，以及可調(diào)整的服務(wù)器端部件。有了ActiveX技術(shù)，就可使用其他應(yīng)用程序提供的功能，例如，

37、Microsoft Word字處理器，Microsoft Excel電子數(shù)據(jù)表及其他Windows應(yīng)用程序。甚至可直接使用VBP或VBE創(chuàng)建的應(yīng)用程序和對象7。2.2 關(guān)于管理信息系統(tǒng)管理信息系統(tǒng)在最初級階段是統(tǒng)計(jì)系統(tǒng),所研究的內(nèi)容是數(shù)量數(shù)據(jù)間的表面的規(guī)律,它可以把數(shù)據(jù)分成較相關(guān)和較不相關(guān)的組,然后把數(shù)據(jù)轉(zhuǎn)換為信息。管理信息系統(tǒng)起初應(yīng)用于最基礎(chǔ)的工作,如打印報(bào)表、計(jì)算工資、人事管理等,進(jìn)而發(fā)展到企業(yè)財(cái)務(wù)管理、庫存管理等單項(xiàng)業(yè)務(wù)管理,這屬于電子數(shù)據(jù)處理系統(tǒng)。當(dāng)建立了企業(yè)數(shù)據(jù)庫,有了計(jì)算機(jī)網(wǎng)絡(luò)從而達(dá)到數(shù)據(jù)共享后,從系統(tǒng)觀點(diǎn)出發(fā),實(shí)施全局規(guī)劃和設(shè)計(jì)信息系統(tǒng)時(shí),就達(dá)到管理信息系統(tǒng)的階段。隨著計(jì)算機(jī)技術(shù)

38、的進(jìn)步和人們對系統(tǒng)的需求進(jìn)一步提高,人們更加強(qiáng)調(diào)管理信息系統(tǒng)能否支持企業(yè)高層領(lǐng)導(dǎo)的決策這一功能,更側(cè)重于企業(yè)外部信息的收集、綜合數(shù)據(jù)庫、模型庫、方法庫和其他人工智能工具能否直接面向決策者,這是決策支持系統(tǒng)的任務(wù)。我國20世紀(jì)70年代末有少數(shù)企業(yè)開始MIS的局部應(yīng)用?！绷濉逼陂g, 選擇一些大企業(yè)進(jìn)行MIS的開發(fā)試點(diǎn), 其中首都鋼鐵公司、北京第一棉紡廠、湖北第二汽車制造廠、寧江機(jī)床廠等取得了經(jīng)驗(yàn)。20世紀(jì)80年代中后期,在全國性的計(jì)算機(jī)應(yīng)用熱潮中,許多企業(yè)紛紛從財(cái)務(wù)管理、人事管理等單項(xiàng)應(yīng)用入手,嘗試建立MIS10。2.3 數(shù)據(jù)庫系統(tǒng)概述數(shù)據(jù)庫系統(tǒng)是指在計(jì)算機(jī)系統(tǒng)中引入數(shù)據(jù)庫后的系統(tǒng),一般由數(shù)據(jù)庫

39、、數(shù)據(jù)庫管理系統(tǒng)、應(yīng)用系統(tǒng)、數(shù)據(jù)庫管理員和用戶構(gòu)成。應(yīng)當(dāng)指出的是,數(shù)據(jù)庫的建立、使用和維護(hù)等工作只靠一個(gè)DBMS遠(yuǎn)遠(yuǎn)不夠,還要有專門的人員來完成,這些人被稱為數(shù)據(jù)庫管理員。在一般不引起混淆的情況下常常把數(shù)據(jù)庫系統(tǒng)簡稱為數(shù)據(jù)庫。數(shù)據(jù)庫技術(shù)是應(yīng)數(shù)據(jù)管理任務(wù)的需要而產(chǎn)生的。隨著計(jì)算機(jī)技術(shù)的發(fā)展,其應(yīng)用遠(yuǎn)遠(yuǎn)地超出了這個(gè)范圍。在應(yīng)用需求的推動(dòng)下,在計(jì)算機(jī)硬件,軟件發(fā)展的基礎(chǔ)上,數(shù)據(jù)管理技術(shù)經(jīng)歷了人工管理、文件系統(tǒng)、數(shù)據(jù)庫系統(tǒng)三個(gè)階段。與人工管理和文件系統(tǒng)相比,數(shù)據(jù)庫系統(tǒng)的特點(diǎn)主要有以下幾個(gè)主面:數(shù)據(jù)的結(jié)構(gòu)化；數(shù)據(jù)的共享性高,冗余度低,易擴(kuò)充；數(shù)據(jù)獨(dú)立性高；數(shù)據(jù)由DBMS統(tǒng)一管理和控制。目前,數(shù)據(jù)庫己經(jīng)成

40、為現(xiàn)代信息系統(tǒng)的不可分離的重要組成部分。具有數(shù)百萬甚至數(shù)十億字節(jié)信息的數(shù)據(jù)庫己經(jīng)普遍存在于科學(xué)技術(shù)、工業(yè)、農(nóng)業(yè)、商業(yè)、服務(wù)業(yè)和政府部門的信息系統(tǒng)。20世紀(jì)80年代后不公在大型機(jī)上,在多數(shù)微機(jī)上也配置了DBMS,使數(shù)據(jù)庫技術(shù)得到了更加廣泛的應(yīng)用和普及,是計(jì)算機(jī)領(lǐng)域中發(fā)展最快的技術(shù)之一1。2.4 ADO與SQL SERVER 20002.4.1 AxtiveX數(shù)據(jù)對象-ADOADO,即Active 數(shù)據(jù)對象:實(shí)際是一種提供訪問各種數(shù)據(jù)類型的連接機(jī)制。ADO設(shè)計(jì)為一種極簡單的格式,通過ODBC的方法同數(shù)據(jù)庫接口相連。用戶可以使用任何一種ODBC數(shù)據(jù)源。ADO集中了RDO和DAO的優(yōu)點(diǎn),可以通過簡單的

41、編程實(shí)現(xiàn)和各種數(shù)據(jù)結(jié)構(gòu)進(jìn)行連接。ADO通過下面幾步來完成對數(shù)據(jù)庫的操作:1.創(chuàng)建一個(gè)到數(shù)據(jù)源的連接,邊接到數(shù)據(jù)庫;或者開始一個(gè)事務(wù)。2.創(chuàng)建一個(gè)代表SQL命令行的對象。3.執(zhí)行命令行。4.如果返回以表格形式組織的數(shù)據(jù),則將它們保存在緩存中,產(chǎn)生相應(yīng)的數(shù)據(jù)集對象。這樣便于查找,操作數(shù)據(jù)。5.通過數(shù)據(jù)集對象對數(shù)據(jù)進(jìn)行各種操作。6.更新數(shù)據(jù)庫,如果使用事務(wù),確認(rèn)是否接受事務(wù)期間發(fā)生的數(shù)據(jù)變化。7.結(jié)束連接和事務(wù)。使用ADO的目的是進(jìn)入數(shù)據(jù)源,使得修改,更新數(shù)據(jù)成為可能10。2.4.2 關(guān)于SQL SERVER 2000SQL SERVER 2000不僅吸收了許多新的功能以增加系統(tǒng)的運(yùn)行性能,而且還使

42、數(shù)據(jù)庫的管理工作更加輕松。在過去,數(shù)據(jù)庫都是安裝在服務(wù)器或是工作站上的,所用的操作系統(tǒng)都是UNIX或?qū)Ｓ孟到y(tǒng),價(jià)格比較高,SQL SERVER 2000可以安裝在個(gè)人計(jì)算機(jī)上,價(jià)格要低的多。SQL SERVER 2000可以使操作系統(tǒng)具有應(yīng)用程序數(shù)據(jù)庫,并被優(yōu)化支持未連接用戶或移動(dòng)用戶。4它也用于在單用戶機(jī)器上進(jìn)行小型應(yīng)用程序的開發(fā),能夠很好的滿足我們的需要。第3章 系統(tǒng)需求分析與總體設(shè)計(jì)3.1 需求分析需求分析是軟件定義的最后一個(gè)階段，它的基本任務(wù)是回答“系統(tǒng)必須做什么“這個(gè)問題。需求分析的任務(wù)不是確定系統(tǒng)怎樣完成他的工作，而僅僅是確定系統(tǒng)完成哪些工作，也就是對目標(biāo)系統(tǒng)提出完整、準(zhǔn)確、清晰、

43、具體的要求?？尚行匝芯侩A段產(chǎn)生的文檔，特別是數(shù)據(jù)流成圖，是需求分析的出發(fā)點(diǎn)。數(shù)據(jù)流成圖中已經(jīng)劃分出系統(tǒng)必須完成的許多基本功能，系統(tǒng)分析員將仔細(xì)研究這些功能并進(jìn)一步將它們具體化。需求分析的結(jié)果是系統(tǒng)開發(fā)的基礎(chǔ)，關(guān)系到工程的成敗和軟件產(chǎn)品的質(zhì)量。因此，必須用行之有效的方法對軟件需求進(jìn)行嚴(yán)格的審查驗(yàn)證2。3.2 系統(tǒng)設(shè)計(jì)3.2.1 系統(tǒng)功能分析系統(tǒng)開發(fā)的總體任務(wù)是要實(shí)現(xiàn)企業(yè)人事信息關(guān)系的系統(tǒng)化,規(guī)范化和自動(dòng)化。系統(tǒng)功能分析是在系統(tǒng)開發(fā)的總體任務(wù)的基礎(chǔ)之上完成的。人事管理系統(tǒng)主要有以下幾項(xiàng)功能:1.員工檔案的管理:包括員工基本信息,所在部門,工作信息和工作簡歷的輸入,員工信息的查詢和修改。2.員工考勤

44、的管理:包括考勤的添加,查詢,修改和刪除。3.員工工資的管理:包括工資的添加,工資報(bào)表的查詢,修改和刪除。4.員工評價(jià)的管理:包括評價(jià)的輸入,查詢和修改。5.人事變動(dòng)的詳細(xì)記錄,包括崗位和部門的調(diào)整,便于掌握人員的動(dòng)向,及時(shí)調(diào)整人才的分配。6.企業(yè)所有部門的查詢與管理。7.管理員以及其它功能模塊。仔細(xì)分析調(diào)查有關(guān)企業(yè)人事信息需求的基礎(chǔ)上,將得到如圖3-1的數(shù)據(jù)流程。用戶登陸核對密碼添加員工檔案錄入員工檔案管理員工表現(xiàn)員工表現(xiàn)考勤管理工資設(shè)置考勤管理工資管理計(jì)算工資本月工資人事變動(dòng)人事變動(dòng)圖3-1 系統(tǒng)數(shù)據(jù)流程圖3.2.2 數(shù)據(jù)流程圖員工檔案員工考勤員工評價(jià)工資管理添加事件查詢修改刪除添加部門修

45、改刪除檔案添加檔案查詢修改刪除考勤添加考勤查詢評價(jià)添加評價(jià)查詢修改刪除添加工資工資查詢修改刪除按姓名查詢按工號(hào)查詢按部門查詢按姓名查詢按工號(hào)查詢按姓名查詢按工號(hào)查詢按姓名查詢按工號(hào)查詢修改刪除企業(yè)人事管理系統(tǒng)員工管理人事變動(dòng)部門管理根據(jù)系統(tǒng)功能的要求,可以將系統(tǒng)分解成幾個(gè)功能模塊來分別設(shè)計(jì),功能模塊如圖3-2所示: 圖3-2 系統(tǒng)功能模塊圖3.3 數(shù)據(jù)庫設(shè)計(jì)3.3.1 數(shù)據(jù)庫需求分析數(shù)據(jù)庫的設(shè)計(jì)是指對于一個(gè)給定的應(yīng)用環(huán)境，構(gòu)造最有效的數(shù)據(jù)庫模式，建立數(shù)據(jù)及應(yīng)用系統(tǒng)，實(shí)質(zhì)能夠有效地存儲(chǔ)數(shù)據(jù)，滿足用戶的需求，數(shù)據(jù)庫設(shè)計(jì)是在數(shù)據(jù)庫管理系統(tǒng)支持下進(jìn)行的。根據(jù)數(shù)據(jù)流程圖,可以列出以下數(shù)據(jù)項(xiàng)和數(shù)據(jù)結(jié)構(gòu):員

46、工信息:工號(hào),姓名,性別,年齡,出生日期,地址,電話,政治面貌,畢業(yè)院校,身份證號(hào),所在部門,備注?？记诠芾?工號(hào),姓名,月份,本月天數(shù),公休天數(shù),出勤天數(shù),出勤,曠工,年休,請假,遲到,早退,忘訂卡,假日加班,其它加班,補(bǔ)休天數(shù),出差,加班費(fèi),扣考核,其它,備注。 員工評價(jià):工號(hào),姓名,工作態(tài)度,各種獎(jiǎng)勵(lì)及處罰,技術(shù)水平,備注。工資管理:工號(hào),姓名,底薪,獎(jiǎng)金,補(bǔ)貼,加班,養(yǎng)老金,醫(yī)療保險(xiǎn),公積金,實(shí)發(fā)工資,月份。人事變動(dòng):編號(hào),事件,備注。部門管理:編號(hào),名稱,部門經(jīng)理。管理員:編號(hào),用戶名,口令。3.3.2 實(shí)體之間的ER模型得到上面的數(shù)據(jù)項(xiàng)和數(shù)據(jù)結(jié)構(gòu)以后,就可以設(shè)計(jì)出能夠滿足用戶需求的

47、各種實(shí)體,以及它們之間的關(guān)系,為后面的邏輯結(jié)構(gòu)設(shè)計(jì)打下基礎(chǔ)。這些實(shí)體包含各種具體信息,通過相互之間的作用形成數(shù)據(jù)的流動(dòng)。根據(jù)上面的設(shè)計(jì)規(guī)出的實(shí)體有:員工基本信息實(shí)體,員工考勤信息實(shí)體,員工工作評價(jià)信息實(shí)體,員工工資信息實(shí)體,人事變動(dòng)實(shí)體,部門管理實(shí)體。實(shí)體與實(shí)體之間的E-R模型如圖3-3所示。部門屬于員工考勤管理員工評價(jià)員工考勤員工評價(jià)計(jì)算工資員工工資人事變動(dòng)人員變動(dòng) n 1 1 1 1 1 1 1 1 1 m 圖3-3 實(shí)體間的ER模型3.3.3 數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計(jì)根據(jù)實(shí)體間E R模型的需求分析,本系統(tǒng)需要2個(gè)數(shù)據(jù)表分別來存放員工個(gè)人信息和人事變動(dòng)記錄,并需要一個(gè)外部數(shù)據(jù)表(部門管理表)的支

48、持。另外設(shè)計(jì)工資管理,考勤管理,員工評價(jià)3個(gè)表來管理員工數(shù)據(jù)。具體數(shù)據(jù)表的設(shè)計(jì)如下面的表格所示。表3-1 員工檔案信息表字段名數(shù)據(jù)類型長度是否為空說明ygidVarchar10Not null工號(hào)ygnameVarchar20Not null姓名sexChar10Not null性別ageVarchar3Not null年齡birthDatetime8null出生日期addressVarchar50null地址telVarchar15null電話politicVarchar50null政治面貌schoolVarchar50null畢業(yè)院校ygidentityVarchar20null身份證號(hào)d

49、epartmentVarchar50null所在部門textText16null備注表3-2 員工評價(jià)表字段名數(shù)據(jù)類型長度是否為空說明pjidVarchar10Not null工號(hào)pjnamechar8Not null姓名attitudechar20null工作態(tài)度publishchar40null獎(jiǎng)勵(lì)及處罰Level1Varchar40null技術(shù)水平textText16null備注departmentVarchar50Not null部門pdateDatetime8Not null日期表3-3 部門管理表字段名數(shù)據(jù)類型長度是否為空說明dpidVarchar10Not null編號(hào)dpnamevarchar20Not null部門名稱manageVarchar10Not null部門經(jīng)理表3-4 考勤管理表字段名數(shù)據(jù)類型長度是否為空說明kqidVarchar8Not null工號(hào)kqnameVarchar20Not null姓名kqdateDatetime8Not null考勤日期kqdaysBig