The Design And Implementation Of Web Attendance Management System Based On Entity Framework

With the rapid development of railways enterprice, it needs increasingly higher reguest for the management of attendance. Attendance is an important constituent of HRC(Human Resource) mananagement of Railways Ministry, and it is a good job which is filled with comlex workload and huge amount of information. At Present, The work of attendance in Beijing iron S signal depot is great and the most of checking attendance is finished by manual ways, which is particularly prone to error. The attendance is closely related to the salary.Every month, the attendance management calculate the crew’s salary according to these attendance information and calculating the salary is inefficient and wasteful. Therefore, it is necesssary to develop a attendance system conforming to Beijing iron S signal depot to enhance management efficiency and specify the management process.This article briefly introduces the main content in 4 aspects as below: Firstly,requirement analysis is discussed. Based on research into different level departments of Beijing iron S signal depot, the whole system is divided into 5 subsystems, which includes staff management subsystem, attendance management subsystem, data dictionary maintenance subsystem, annual leave management subsystem and authority management subsystem. Secondly, architecture design is discussed. After analyzing demand of Beijing iron S signal depot, the applicable framework is established for the system. The system is formed by presentation layer, business logic layer and data access layer. MVC Framework and Entity Framework are mainly applied in the system. MVC Framework contains model, view and controller. Its function is to layer the system for the purpose of reducing coupling degree and improving system expansibility. Entity Framework is an object relational mapping mechanism(ORM). It takes Entity Data Model(including Concept Model, Mapping Model and Memory Model) as the core and supports forward engineering and reverse engineering in software development. Entity framework realizes mutual transformation between database and data entity, accessing database by developes in object-oriented means, interaction between developers and data concept model, and creating database access application on conceptapplication programming model. So, this framework can reduce development effort in data-oriented application program and lighten system maintenance work. Thirdly, system database design and system detailed design are discussed. System database design discribe and explain concept model design and logical model design in detail. The system detailed design uses cases of adding personal information, checking staff training, crew composition statistics and attendance sheet lead-in in the system for specific illustration to describe the detailed design. Fourthly, system test is talked about, which is conducted for function and performance aspect. The function test is carried out in five modules, namely site staff management module, checking attendance management module, data dictionary maintenance module, annual leave management module and authority management module. Moreover, site staff management module contains eleven functions, attendance management contains seven functions, data dictionary maintenance contains six functions, annual leave management contains four functions and authority management contains two functions, totally thirty big functions which are one hundred and twenty small functions. This article takes ten small functions as examples for further statement. Problems were discovered in the system during testing period. To solve them, developers corrected the code to ensure system function validity. The performance test is also with the five modules. In testing time, it was to record the minimum, the maximum and average time of concurrent execution from 80 users in different period, which is used for analysis. Test result reveals fine system performance by showing the response time in tolerance interval, which means that it can meet the staff’s actual demand of Beijing iron S signal depot.This article carries through specific description and introduction in the aspects of demand analysis, system database design and system detailed designing, utilized technology,and system test into the system. At present, the system is already put into use in Beijing iron S signal depot. The practical application indicates that the system design goals are achieved with reliable performances and satisfactory effects.