The Design And Implementation Of MFC-Based Staff Information Management System

In recent years, as the growth of enterprise scale and the number of employees, enterprise information management plays a more important role. This is especially true for the enterprises of medium and large scale which rely on the information management to be efficient. For example, it is commonly required to manage the basic staff information, to provide the information query interface and to track the staff attendance. Therefore, the development of a comprehensive information management system is essential.In this thesis, we will introduce a new management information system to solve this problem. The Microsoft Visual C++ is employed as the integrated development environment for our system. The development mainly utilizes the Microsoft Foundation Classes (MFC) to provide user interface and ADO database connectivity. The SQL Server 2000 is used for database management. Our system allows the direct operating in the Microsoft Excel, and can export the database to Excel spreadsheet.Our system provides a flexible information query interface that can easily and quickly perform the most basic operations. For example, user can query the attendance of the staff to assess employee performance, or check the statistics of basic wage, bonus and penalty of the employee to calculate the final wage. The result of the query can be exported into Excel or printed out directly. The system roughly consists of four modules. The login module is responsible for authorizing the access the system. The administration module and the staff management module are responsible for adding, deleting or modifying the administrator and staff profiles respectively. The information query module implements the interfaces for basic staff information query, and statistics query for employees attendance, wages etc.The whole software development life cycle of our system strictly follows the guidance of software engineering process, which includes requirement analysis, architecture design, detailed design, implementation, unit testing and integration testing. In this way, the quality of our MFC-based information management system can be guaranteed.In requirement analysis, we collected various factors and concepts to exploit the real need of the user, and only reserved those that are necessary to our database. In the architecture design, we introduced a framework that clearly cuts the system into independent modules. In coding phase, we utilized the multi-thread and other optimization method to efficiently implement the functionalities of the modules. In testing phase, we designed plenty of test plans to cover the critical execution paths to ensure the stability of the system. The experimental result proved that the system is able to meet the requirements of the user in both functionality and efficiency aspects. Furthermore, we always keep in mind to provide user-friendly interfaces to enhance the user experience.