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.

Figure 1:visual Studio.NET

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:

table name	main field	primary key and foreign key
employee	employid,departid, Leaderid,reallname, Username,userpass, emal, telephone ...	primary key: Employid Foreign key : Departid
departid,leaderid,dname,ddescription the ...	primary key: Departid
smallrules	smallid,bigid,departid s Implediscription,fulldescription,score,	primary key: Smallid Foreign key: Bigid, departID< /td>
bigid,content,totalscore	primary key: Bigid
score	testpersonid, Testedpersonid,smallid, Score, month	primary key: No foreign key: Smallid

In most software companies, departments are divided into research and development, testing, customer service and so on, employees are divided into a number of departments, each department has the same and different standards of evaluation. For example, in the author of the development of supermarket software companies, in compliance with the system, each department needs the same standard of evaluation, such as: No late leave early, something to the company, no reason for absenteeism, etc. at the same time, various departments have different evaluation criteria, such as in professional skills, research and development department staff need to master skilled. NET development of Windows page technology, and customer service departments need to master skilled database technology, at any time for each store to find merchandise sales, merchandise invoicing situation, etc. in the work results, the testing department will have "test leakage rate" evaluation criteria, and research and development and customer service departments do not need. Therefore, in the Smallrules (evaluation Rules) table, not only the corresponding Bigrules (classification of rules) in the Bigid, so that "skilled use of the development of more than two tools" corresponds to the "professional skills" category, but also to store the rules belong to the Department ID.

In addition, in the score table, in accordance with each month, each evaluation person, each test person, each evaluation rules to store the corresponding details of the score, so whether it is taken from the test results or the supervisor of their evaluation results are very convenient. All ID, score, score, month and other numeric data is int type, descriptive information is varchar type.