This paper puts forward a labor and personnel management system based on WWW environment, which realizes the functions of multi-condition query, deletion, update, printing and password setting of labor and personnel by using dynamic server pages.
Keywords: labor and personnel management system dynamic server page multi-condition query password settings
introduce
Labor and personnel management is a very important management matter of the company. However, at present, most of the labor and personnel management in the company is basically manual operation or dos-based application, which brings a lot of inconvenience to information managers. Although some of them are developed by foxpro and visual foxpro, due to the limitation of the development tools themselves, the support for network functions is not very strong, which brings trouble for upgrading the software to the Internet in the future. Therefore, it is necessary to develop a network-based labor and personnel management system to realize the functions of data entry, insertion, deletion, query, statistics, update and printing under the network environment. At the same time, in order to ensure the confidentiality and security of information, the system should also provide a certain security mechanism.
Powerbuilder6.5 is an application development tool widely used under the client/server architecture, which is introduced by the famous American Powersoft company. It has a complete Web application development function. It supports multiple relational database management systems at the same time, and can read the data in the database at high speed through Microsoft ODBC interface and special large database interface. This system is developed by Powerbuilder6.5. The server operating system is Windows NT 4.0 and the client operating system is Windows 98.
Analysis and planning of system functions
(1) system function analysis
The internal labor and personnel management of the company mainly focuses on the personal situation, salary details, transfer-in and transfer-out, car use, etc. So the system is mainly to realize data entry, insertion,
Delete, online query, statistics, update, print and other functions. Secondly,
In order to ensure the confidentiality and security of information, the system should also provide some security mechanisms.
(2) System function planning
According to the analysis of the above system functions, the system decided to adopt MDI style, which is mainly divided into the following modules, among which the functional structure diagram of the parent window of the labor and personnel management system is shown in figure 1.
File module: this module realizes the functions of data opening, saving, print preview, printing and user management in this system, and can exit the system accordingly.
Information management module: this module realizes the information management of the system, including the functions of inserting, deleting, modifying and saving the information data of employee information list, employee transfer-in information table and employee payroll table.
Query module: this module realizes the query function of this system, and can retrieve personal basic information, transfer-in and transfer-out situation, salary situation and so on. , and can realize multi-condition query and fuzzy query.
Statistical module: this module is used to make statistics on the information data in the database according to certain rules.
System service module: this module is used for system administrators to set passwords and introduce system functions and development information.
For each table in the system, its basic information management function structure diagram is as shown in figure 1:
Figure 1. Functional diagram of employee basic information management
Design data tables according to user requirements.
The establishment of data table is a very important link in the process of application development. You need to know what data each module needs to operate and the relationship between the data, and then build a data table. The labor and personnel management system needs to manage the employee's personal situation, transfer-in and transfer-out, salary, etc. Under the employee's personal information table, there are also things such as maintaining the job table and maintaining the academic record table. At the same time, we should also establish a security mechanism for the system. In order to meet the above requirements, we will take personnel, salary and password tables as examples to introduce the structure of each table:
Employee list
Including employee number, name, gender, political views and other information. Its structure is as follows:
Code char(4) is not empty.//Employee code
Name char(8) null，// name
Sex char(2) null,//gender
Political char(8)null,//political views
Birthday data is empty.//Date of birth
Work_time data is empty.//Working time.
Post_zhw char( 10) null，// job
Address char(30) null,//home address
The primary key of this table is the employee number (code).
Employee payroll
Its structure mainly includes all kinds of wages and benefits earned by employees.
Code char(4) is not empty.//Employee No.
Name char(8) null，// name
G_pay integer null,//post salary
J_pay integer null,//skill salary
W_pay integer null,//price supplement
S_pay integer null,//book and newspaper fee
Ws_pay integer null,//health expense.
Xh_pay integer null,//child allowance
A_pay integer null,//seniority salary
Ht _ paynumeric (6,2 2) null,//contract subsidy
Jj_pay numeric(8，2) null，// bonus
Total _ paynumeric (8,2 2) null,//payroll
The primary key of this table is the employee number code.
System cipher table
User _ namechar (10) is not empty.//User name.
User _ wordchar (10) is not empty.//User password.
User_qx char(2) not null,//user permissions
Network implementation of the system
Because Powerbuilder has a complete Web application development function, the software compiled by PowerBuilder can easily work with the server-side database to form a client/server working mode. It uses familiar web standards (HTML and Java) and can control the whole life cycle of Web applications through end-to-end design, debugging and submission. The client application and server application of the system are developed by Powerbuilder. Among them, the server-side program is the key part of the implementation, and its content is mainly to generate SQL statements to operate the database and process the obtained data. Mainly divided into monitoring customer connections, handling customer requests, avoiding deadlocks, and pushing messages to customers. The block diagram of the implementation platform of the system is shown in Figure 2:
Figure 2. Implementation platform diagram
Solutions to key problems
(1) security mechanism problem
Confirm your identity before entering the system. Only users with the same username and password can enter the system. In order to prevent illegal users from viewing and modifying data, this system divides users into three levels: super, modifiable and read-only, namely primary and secondary users. Super (first-level) users not only have the right to query and modify data, but also can control users' right to use, set user names, passwords and their permissions, and add, delete and modify records. Modifiable (second) Users can query and print data, and also add, delete and modify records. Read-only (level 3) users only have the right to browse, query and print records. When the user wants to enter the system, he must first enter the user name and password. After pressing the "Confirm" button, the system will identify the identity of the user, and give the legal user the corresponding use function according to the user's authority level.
The problem of sorting any data column.
Users who are familiar with Windows must be familiar with Explorer. When there are many directories or files, you will naturally think of sorting to locate the target as soon as possible. You only need to click any one of the names, sizes, types or modifications at the top of the Explorer with the mouse, and it will sort the items in ascending or descending order. Similarly, in PowerBuilder, if there is a lot of data, we can also use this method to sort and find records as soon as possible.
This system takes w_rsh window as an example. To achieve this sorting function, first define two instance variables, String pre_col= ""and Int click_time=0, to record the parity of the last clicked column and clicking the same column respectively. Then add the following script to the Clicked event of dw_ 1:
String clicked_pos, col, format
Long il_pos
Click the dwo.name//Get of the object.
Il_pos = Pos(clicked_pos,' _t') // For column headings,
//The object obtained is column name +"_ t "
If il _ pos>, then 0
col = Left(clicked_pos，il_pos - 1)
If col=pre_col then
If click time =0, then
click_time = 1
format = col+" A "
other
click_time=0
format = col+" D "
If ... it will be over.
other
click_time = 0
format = col+" A "
If ... it will be over.
Pre-column = column
dw_ 1。 Set Sorting (Format)
dw_ 1。 Sort ()
If ... it will be over.
The above method can realize the flexible sorting function like the resource manager in Windows, thus making the data to be browsed clearer.
Use of editing style of data window controls
In this system, the data such as date type and gradient variable are input by the editmask control EditMask, which greatly facilitates the user's operation. For those with only two values, such as gender, radiobutton is adopted, and users only need to click the button when inputting. When setting conditions, the droplistbox is used for the name of the value segment and the data in a fixed position for the user to select, and the user only needs to select the value to be input.
6 concluding remarks
With the development and popularization of computers and the expansion of Internet technology, the daily labor and personnel management will be paperless, and it will be added to the company's internal intranet or Internet to realize the * * * sharing of data, which is conducive to the inquiry of labor and personnel information within the unit, improve the utilization rate of data resources, and be updated in time, without wasting a lot of manpower and material resources to copy as in the past, and improve work efficiency.
reference data
[1] Shen yun, automatic question answering system based on WWW, computer engineering, 25(9), 1999.
Zhang Shichao, Jiang Yuncheng, Research on Approximate Equivalence in Fuzzy Database, Computer Science, 25(6), 1998.