ASP. NET development staff performance evaluation center

Abstract: This article introduces the use of Asp.net to develop a software company's internal employee performance evaluation system, including all background employee information management, department information management, and all Department evaluation details information management; monthly self-evaluation by front-end employees and evaluation by supervisors. this section focuses on database design and the use of important Web servers and page controls. I believe this article will inspire and help readers to design databases and develop pages using Asp.net.
I. System Architecture
Visual Studio. NET is the most powerful and complete development tool launched by Microsoft so far. It is used to generate Asp Web applications, XML Web services, desktop applications, and mobile applications. Asp.net is a compiled. NET-based environment .. The chart below demonstrates how Visual Studio. Net framework supports ASP. NET applications.
Visual C # (pronounced C sharp) is a new object-oriented programming language that evolved from C and C ++, it provides a simple and secure language for application development. Therefore, in the programming environment and language selection, we use the Asp.net architecture to provide support for page development, and Visual C # For actual programming. Our evaluation system uses the traditional three-tier architecture, including the data storage layer (SqlServer2000), application logic layer (. aspx. cs), and page display (. aspx ).
Ii. Database Design
The Database "ygpc" (employee evaluation) contains five tables, which are described as follows:
1. Employee: stores basic information about all employees and supervisors of the company.
2. Department. Basic information about all departments.
3. bigRules, including classification of detailed evaluation rules, such as "compliance with the system", "professional skills", "Planning and Management", "Work achievements", and "work attitude.
4. smallRules, including the specific evaluation rules for each detailed rule category, such as "skilled use of design tools (such as Rational Rose or Visio)" in "professional skills" of detailed rule categories )", "skilled in using databases or related applications such as SQL and OLAP", "familiar with the company's technical system and skilled in development ".
5. score: The score of the monthly evaluation result. The score is divided into employee self-testing and employee evaluation by the supervisor. The score of each employee is saved for each evaluation rule.
Shows the relationship between the main fields and tables in each table: