Asp. NET Development Employee Performance Evaluation Center

Abstract: This article introduces the use of ASP.net to develop a software company's internal staff performance evaluation system, including backstage all staff information management, departmental information management, all departmental evaluation rules information management The front desk staff review and evaluate their staff monthly. Focus on database design and the use of important Web server and page controls. The author believes that this article will be helpful to the reader's database design and the use of asp.net development page technology.
First, System architecture
Visual Studio. NET is the most powerful and complete development tool ever launched by Microsoft to build ASP Web applications, XML Web services, desktop applications, and mobile applications. ASP.net is a compiled,. NET-based environment. The following chart shows us how the Visual Studio.NET framework supports ASP.net applications.
Visual C # (pronounced C Sharp) is a new object-oriented programming language that evolves from C and C + + to provide a simple and type-safe language for developing applications. Therefore, in the programming environment and the choice of language, we use the ASP.net architecture to support page development, Visual C # for practical programming. Our evaluation system uses a traditional three-tier architecture, including the data storage layer (SqlServer2000), the Application logic layer (. aspx.cs), and the page display (. aspx).
Second, database design
The database "YGPC" (Employee evaluation) contains five tables, as described below:
1. Employee, the basic information of all employees and supervisors of the company.
2. Department, basic information for all departments.
3. Bigrules, including the classification of the review rules, such as "compliance system", "professional skills", "Planning and Management", "Work results", "work attitude" and so on.
4. Smallrules, including specific evaluation rules corresponding to the classification of each rule, such as "skilled use of design tools (such as rational rose or Visio)" in the Classification of "professional skills", "proficiency in the use of databases or their related applications such as Sql,olap", Familiar with the company's technical system and be skilled in the development of ".
5. Score, the monthly evaluation results score, divided into staff self-test and supervisor of staff evaluation, for each of the evaluation rules of each employee monthly corresponding points.
The main fields of each table and the relationships between the tables are shown in the following illustration: