Design and Implementation of Intelligent Management System for ID Card Room

0 Preface

In order to improve work efficiency and management level, realize the automatic management of the computer room, and make the computer room management work from manual to unattended. According to the actual situation of our hospital, we have independently developed a comprehensive, intelligent and high security performance. Pure software room intelligent management system. The system uses a contactless ID card as a medium, combined with a three-layer switch with routing function, and utilizes the TCMP protocol transmission mode to implement cross-network segment management functions, which can intuitively, conveniently and efficiently manage all computers in the entire campus LAN. .

1 Hardware composition of the intelligent management system of the equipment room

The system uses a contactless ID card as an identification tool. Each server is equipped with an ID card reader. Each student machine is equipped with client software. Through the combination of the computer management software and the client software, the system is completely integrated. It realizes functions such as identification, automatic billing, remote monitoring, ID card management, and data statistics analysis. The system hardware components are shown in Figure 1.

Figure 1 Block diagram of the hardware management system of the computer room

2 software composition of the intelligent management system of the computer room

The equipment room intelligent management system is developed based on the C/S structure and the B/S structure mode. The users of the B/S structure are mainly students and system administrators, and mainly perform functions such as loss of card loss, password protection, password inquiry, personal machine detailed inquiry, feedback on the machine, feedback processing, report generation, and system log. The users of the C/S structure are mainly students, computer room administrators, and system administrators. The student client mainly completes the credit card login and the network disconnected independent tube as the client software that does not affect the student's computer as the computer room management system. The computer automatically uses the login tray mode. The management client software mainly implements functions such as user card swiping, remote control of student lock screen, screen unlocking, shutdown, logout, booting, monitoring, password modification, automatic billing, fee inquiry, and management terminal checkout. The system management side implements functions such as user management, machine management, schedule management, expense management, system basic information setting, and remote control. The software functional structure is shown in Figure 2.

Figure 2 software functional structure diagram

The functions of each subsystem of the system management terminal are as follows:

Cost management recharge management (collective recharge, personal recharge), query statistics.
User management user registration (bulk registration, single registration), user logout (bulk logout, single logout), loss reporting, user card replacement, user information management.
Class schedule management room table setting, machine room class table inquiry.
The system sets the room settings, administrator settings, rate settings, and idle settings.
On-board management card management, monitoring management.

3 system design and implementation

The system is built on the school LAN, using a mixed mode of B / S and C / S, with windows 2000 server as the server, SQL server 2000 as the background database, PowerBuilder, VisualBasic and ASP. NET is a development tool that uses the standard TCP/IP protocol. The cross-network segment cross-route is realized, which breaks the limitation of the network segment, solves the problem that each network segment needs to be equipped with one server, and saves resources.

3.1 client technology implementation

As the client software of the computer room management system automatically moves visual effects with the startup of the computer, the system adopts the login tray mode. The main implementation of the management client software is to quickly lock the screen, mouse and function keys. After swiping the card at the entrance of the computer room, the student enters the account and password into the computer inside the computer room. After passing the verification, the computer can be used. After the end of the machine, the client automatically shuts down the account. The main technologies are as follows:

(1) Processing of automatic running of client software

Modify the key value of the run in the registry "HKEY-LOCAI, MACINE\SOFTWARE\Mi-crosomwindows\cunrrentversion\run" to achieve the purpose of automatic operation; at the same time, it is equipped with a hard disk protection card, a recovery card and the like, and the user Unable to delete the client application. By modifying the value of DisableTaskMgr in the registry "HKEY_CURRENLMACHINER\SoRware\Microsoft\Windows\CurrentVerSion\Poliies\system\DisableTaskMgr", the task manager is disabled and the user cannot abort the client program. The client program automatically stops once it is aborted or forced to abort. Shut down to prevent some people from closing the client program through certain channels, so that the workstation can not be supervised by the server. In addition, the system adopts a secondary process to enhance the security of the client management program. The process detects client management at regular intervals. Whether the program is running normally and the IP address is modified. If it is not working properly or the IP address is incorrect, the client management program has been destroyed. The program automatically locks or automatically shuts down the workstation, so that illegal users cannot use the machine. .

(2) Processing of computer control functions

PowerBuilder is suitable for database development, but it is particularly weak as a machine control software development. Therefore, in the development we use VisualBasic to develop controls, combined with PB to achieve computer control, to achieve a seamless integration of PB and vB controls. In this system, two control functions with control functions are developed by calling system API functions, as shown in Table 1.

3.2 technical implementation of the management side

The management terminal mainly implements the function of swiping cards, and automatically sets the charging status, charging standard, remote control, etc., as well as completing the functions of registration, cancellation, recharge and charging statistical analysis of the upper machine card.

(1) Implementation of the card swipe function

At present, IC cards, ID cards, and the like are popular on the market. Due to the high cost of the IC card, a special card reader and a card writer are required, which is not suitable for low-cost needs; compared with the contact type IC card, the contactless ID card does not need to be inserted or removed, thereby avoiding various problems caused by poor mechanical contact. The fault has the outstanding advantages of convenient operation, quickness, reliability and long service life, and is especially suitable for occasions with large human flow. The ID card and the card reader are low in cost and simple to use. After the card is swiped, the modified event of the single-line edit box can be triggered immediately, and the ID card number is automatically input into the single-line edit box. By programming the modified event, all the functions we need can be realized. . Therefore, the system selects an ID card instead of an IC card.

(2) Implementation of remote control

In order to achieve remote control of the client, we choose winsock programming for communication transfer control parameters, and the information transfer connection method adopts UDP connection. The UDP protocol does not need to display the connection. A UDP application can be used as the client or server side of the application. The status of the two computers can be regarded as "equal". This application is also called peer-to-peer communication. Therefore, any machine that installs server-side software can be used as a server to enable remote monitoring of all computers in the campus network. Moreover, since the UDP data packet has strong network penetration capability, network communication can be performed in the case where the above network environment is relatively complicated.

The server and the client communicate with each other via the UDP protocol using the winsock control. Therefore, the network association of the server and the client needs to be set to the UDP protocol through the winsock control property setting dialog box, as shown in FIG.

Figure 3 winsock control communication protocol settings

The specific settings of the server-side remote control window (W_server) and the "click" event of the "remote control" command button of the window are as follows.

/ / Winsock control name is ole_server
Stnng ls_mes / / define the variable ls_mes, which represents the information sent string Is_ip / / define the variable Is_ip, on behalf of the client ip address Is_ip = trim (sIe_2text) / / get the client's IP address
/ / Specify the client host name or lP address oIe_server. Object. RemoteHost=ls_ip
oIe_server. Obiect. RemotePort=2001 //Specify the connection port number //Specify the port number of the client host to be bound oIe_server. Obiecl. Bind (2002)
/ / Get the information to be sent entered in the single-line edit box Is_mes:trim (sIe_senddata.text)
/ / Use the SendData method in the ole_server control to send the input string ole_server. Obiecl. SendData(is_mes)
Ole_server. Object.close // Closes the script of the open event of the client software main window (w_client).
// The name of the WInsock control is ole_server.
oIe_server. Obiect. RemotePort=2002//Specify the connection port number //Specify the port number of the server host to be bound oIe_server. Objecl. Bind (2001)
Dataarrjval of the ole-client control in the client software main window (w-client)
The script for the event.
Int Ii_qr
uo_shutdOwn=Create nvo_shutdown
String is_RecvData//Declare a variable for the received data // Call the GetData method to get the data. Object. GetData(REF is_RecvData)
Choose case Is_RecvData
Case "reboot" //oIe_2 is the shutt developed by vb. Ocx control oIe_2. Objecl. Shut(3)//force restart case "shutdown"
oIe_2. Object. Shut(5)//forced shutdown case "Iogoff"
oIe_2. Object. Shut(0)//Logout case "lock"
Open(w_pm)//lock screen case "unIock"
cIose (w_pm) / / screen
CASE ELSE
Messagebox ("Friendly Tips", lS_RecvData)
End choose

When the IP address of the client is set on the server side and the port number of the client host is bound, the connection is established with the client, and the server and the client can communicate with each other through the sendD呦 method at any time to complete the communication to the client. Real-time control and monitoring. Since the winsock control can only send one string at a time, we determine the actual meaning of the sent string, such as "reboot" for forced restart, "logoff" for logout, "shutdown" for shutdown, and "lock" for Lock screen, "unlook" means unwinding, etc. After the client receives the string, it triggers the DataA and val event. According to the meaning of the agreed string, the corresponding function is executed. For example, if the "lock" message is received, the client automatically locks the screen to realize remote control.

4 Conclusion

Based on the above ideas and technologies, we used PowerBuilder and VisualBasic to design and develop the "ID card room intelligent management system", boldly integrated the development features of the two tools, shortening the development cycle. Through one year of use, the system runs stably, the timing charges are accurate, and it achieves the purpose of computer room management automation and unattended operation, improves work efficiency, saves resources, and greatly reduces the workload of the computer room management personnel.

(Wen/Qingdao Gangwan Vocational and Technical College, Teng Lianshuang, Li Lingchen, Guo Jiaxi)

Dinner Table

dinner table

dinner table

Jiangmen Lihua Import & Export Trading Co., Ltd. Jiangmen Lihua Furniture., Ltd. , https://www.jmlihua.com