Radio frequency identification technology uses non-contact two-way data communication to identify the target through wireless radio frequency. Compared with the traditional identification method, RFID technology can complete the input and processing of information without direct contact and without optical visualization without manual intervention. And the operation is convenient and fast, which can solve the problems in the traditional card well.
This article refers to the address: http://
I. Research status at home and abroad
Radio frequency identification technology is developing very rapidly abroad, and there are many types of radio frequency identification products. In North America, Europe, Oceania, Asia Pacific and South Africa. Radio frequency identification technology is widely used in many fields such as industrial automation, commercial automation, transportation control management, such as automobile, train and other traffic monitoring, highway automatic toll collection system, parking lot management system, item management assembly line production automation, safety access inspection, warehousing Management, animal management. Vehicle security, etc. In my country. Radio frequency identification technology started relatively late but is currently being promoted and applied in various industries.
Second, the basic composition and working principle of RFlD system
RFID is radio frequency identification. Often referred to as electronic tags or inductive electronic non-contact lC cards, electronic bar codes, and the like. RFlD radio frequency identification is a non-contact automatic identification technology. It automatically recognizes the target object through RF signals and obtains relevant data identification work without any manual intervention, and can work in a variety of harsh environments.
The most basic RFID system consists of three parts: an electronic tag, a reader, and an antenna. The reader is used to read or write the non-contact IC card information antenna to transmit RF signals between the non-contact IC card and the reader. The RFlD system can also be connected to an external computer via the RS232 or RS485 interface of the reader for data exchange, as shown in Figure 1.
Figure 1 FRID system and computer system connection diagram
The electronic tag consists of a coupling element and a chip with a built-in RF antenna for communication with the reader. The electronic tags used in the RFlD system are divided into three types of passive tags, active tags and semi-active tags. Passive tags, also known as passive tags, do not require power supply. Instead, it is powered by the RF signal sent by the reader, while both active and semi-active tags require their own power supply. The advantages of long life, small size and low cost of passive tags make them widely used in engineering implementation.
The basic workflow of the RFID system is: the reader transmits the RF signal of the reader at a certain frequency through the transmitting antenna. When the electronic tag enters the working area of ​​the transmitting antenna, the inductive current is generated. The electronic tag obtains the energy to be activated, and the electronic tag passes the information such as its own code through the card. The built-in transmitting antenna transmits out; the receiving antenna of the system receives the carrier signal transmitted from the RF card and transmits it to the reader through the antenna adjuster, and the reader demodulates and decodes the received signal and sends it to the background main system for related processing. The system judges the legality of the card according to the logic operation, and performs corresponding processing and control for different settings, and issues a command signal to control the action of the actuator.
Third, functional analysis and design
The system mainly includes: system settings, basic management, query reports, tools and other functions.
1 basic management function
(1) Operator management. 1 The system can set multiple operator accounts and the permissions they can operate. 2 Each consumer transaction of the VIP, that is, the cashier at the front desk, and the data registration record, have the current operator account.
(2) VIP management. 1 VIP information includes: name, gender, card number, ID number, unit, address, region, contact phone type, card opening date, expiration date, consumption amount, points, discount rate, remarks, etc. 2 You can add and query the VIP card information at any time. Adding is the process of opening an account and issuing an ID card. The lD card fee is charged. It can also modify the misuse of name gender, ID number, etc. 3 For the card number that has not been used for a long time or because of the VIP request, you can go through the account cancellation procedure. 4 can handle loss reporting, card replacement, transfer points and other services for VIP cards. All previous history remains unchanged after the card is changed. After the report is lost, the lD card becomes a black card, and it will automatically alarm when it cannot be swiped. 5 has the function of unpacking the lost VIP card.
(3) Consumption management. 1 When the VIP first consumes, he can open the account opening procedure and register the VIP information according to the requirements of VIP management. 2 Consumption data includes name, card number, discount rate, consumption time, product list price, quantity, amount, current consumption points, consumption type, settlement staff, etc. The name, card number, and discount rate can be manually input into the settlement amount = quantity × unit price X discount rate after reading the card. 3 The VIP card can be charged first and then consumed before consumption. When you charge, you will automatically and manually change the points and discount rate. After recharging, the amount can be used for various types of consumption. 4 Recharge, checkout, account opening and other operations have confirmation prompts. Display information such as recharge or checkout name, amount, etc., or cost, name, and success. 5 For VIPs who have forgotten to bring a card or have not been able to swipe their cards at the time, they can check the customer's name according to their name. It is also possible to make up the consumer checkout procedure afterwards.
2 query report class function
The file information can be queried according to the VIP card number or name.
VIP data can be queried in segments of value such as spending amount or points.
You can query and count the consumption of a certain day or period (in days) and a VIP.
You can check the statistics of a certain authority or a certain period of time (in days) for an operation authority to open, sell, and receive deposits.
You can check the amount of recharge received by someone for a certain period of time (in days).
Can query a certain time period, a certain type, someone is on duty (operating authority), customer
Consumption points.
You can query the consumption of a certain month or year for all types or types of consumption.
The above query can be output through the printer report.
3 system setting class function
(1) Discount rate dictionary. That is, the score and discount rate comparison table. Personal points discounts and units can be set to different.
Business technology
(2) Treatment card dictionary. Can set AE multiple card class. Each card corresponds to a discount rate.
(3) The data maintenance function can back up the database at any time or periodically.
System development environment and hardware architecture The system uses c/s architecture, using Windowsxp or Windows2000 operating system, Microsoft SOLServer2000 database. Delphi7 is a development tool. The hardware distribution is shown in Figure 2.
Figure 2 system hardware connection diagram
From the functional requirements, there are a large number of database access operations, so the importance of database design is particularly obvious. In order to establish a good database, we need to consider from such aspects: database redundancy is small: function dependencies are clear: the table name of the database reflects the contents of the table; the names and types of the attributes in the table reflect the meaning of the attribute; Good index; select the appropriate key: set the constraint rules for each field: the table should consider the convenience of actual use when reducing redundancy.
Using the most advanced non-contact ID card technology, it is recognized as a VIP identity tag, which reduces the disadvantages of low recognition rate, slow recognition speed and short life of magnetic cards, contact IC cards and barcodes. The system divides the VIP card into two categories: the treatment card and the loyalty card. The treatment card enjoys preferential treatment, points, and gifts for the gift; while the loyalty card enjoys points, discounts, and gifts. The former is mostly used for units with business contacts. After opening the card, it enjoys preferential prices: the latter is used for ordinary customers, and most of the cards are not recognized, attracting relatives and friends of VIPs to come to consume. Discounts can be made to increase the number of regular guests. The two can also be converted to each other, and the score card can be converted into the corresponding treatment card when the score is accumulated.
Fourth, the specific application of RFID technology in the system
The system involves reading the lD card information, and the RFlD system connects to the external computer serial port through the RS232 connection of the reader 1:3 for data exchange. The Windows API function is used when serial 13 communication is performed, and the Windows system operates on the string 1:3 as a file. The windaws API functions used in Delphi serial communication mainly include: CreatefiIe(), which is used to open string 1:3: CIOSefiIe(). Used to close the serial port; GetCommState(). Used to get the setting parameters of the serial port: SetCommState(). Used to set serial port parameters, including baud rate, data bit, parity bit and stop bit; PurgeComm() is used to clear the buffer on string 13: ReadfiIe(). Used to get the data in string I:3; Writefile(). Used to send data from the serial port: ClearCommError(), clear the serial port error or get the string 13 information. The main code is as follows:
/ / The following are some of the source code of the RFID system
procedureOpenComm:
Var
CC: TCOMMCONFIG:
Temp:string
Buffer:array[0.256]ofchar:
Begin
Temp:=CaM+lntToStr(pDataModuleDataModulelPort). //
Select the COM you want to open
StrPCopy(Buffer.Temp)
DataModule1hComm:=CreateFile(Buffer.GENERIC—READor
GENERIC—WRITE0nilOPEN—EXISTING00\//Open CaM
If(DataModule1.hComm=INVALID_HANDLE_VALUE) thenbegin
/ / If CaM is not open
MessageBox (0. Open communication port error, ", MB-OK);
DataModule1. hC0mm:=0:
Exit:
End
GetCommState(DataModulelhc0mm.CCdcb)://Learn the current
CaM status
CCdcbBaudRate:=CBR-9600: Set the baud rate to 9600
CC. Dcb. ByteSize:=8;//bytes are 8bit
CCdcbParity=NOPARITY1//ParityNoneCCdcb
StopBits:=ONESTOPBIT//1 Stopbit
ifnotSetCommState(DataModulelhComm.CC.dcb)thenbegin/
/Set the status of COM
MessageBox (0, communication port setting error Jfl ".", MB-OK):
CloseHandle(DataModulelhComm):
DataModulelhCOmm:=0.
Exit;
End:
End;
This paper uses software engineering method to use Delphi7 and SQLSERVER2000 as development tools to achieve a better VIP management system based on RFID technology. In the design and implementation of the system, four key problems are solved: one is to design a scientific, reasonable and humanized customer credit system. It provides better personalized member management solutions such as personalized member consumption, points, and rebates. Secondly, through transaction processing programming technology, it solves the problem of data consistency and integrity in related tables during data modification: the third is to adopt ADO database access method solves the problem of system load and access speed when the number of customers increases. The fourth is to solve the problem of serial port data communication between RFlD and computer. From the perspective of the final implementation of the system. The system has the characteristics of simple operation, friendly interface, good flexibility, high security and stable operation.
Power 12W ,output voltage 3-12V, output current Max 1A, 6 dc tips. We can meet your specific requirement of the products, like label design. The material of this product is PC+ABS. All condition of our product is 100% brand new.
Our products built with input/output overvoltage protection, input/output overcurrent protection, over temperature protection, over power protection and short circuit protection. You can send more details of this product, so that we can offer best service to you!
12W Wall Adapter, 12W Wall Power Supply,12W Power Cord In Wall, 12W Wall Power Adapter
Shenzhen Waweis Technology Co., Ltd. , https://www.waweisasdapter.com