chaxun.frm

基于非接触IC的卡的一个综合功能的实现

VERSION 5.00
Begin VB.Form chaxun 
   Caption         =   "查询"
   ClientHeight    =   2430
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   3615
   LinkTopic       =   "Form1"
   ScaleHeight     =   2430
   ScaleWidth      =   3615
   StartUpPosition =   3  '窗口缺省
   Begin VB.TextBox chaxunValue 
      Height          =   270
      Left            =   1200
      TabIndex        =   6
      Text            =   "Text1"
      Top             =   1080
      Width           =   2055
   End
   Begin VB.ComboBox searchBy 
      Height          =   300
      Left            =   1200
      TabIndex        =   2
      Text            =   "searchBy"
      Top             =   360
      Width           =   1575
   End
   Begin VB.CommandButton cancel 
      Caption         =   "取　消"
      Height          =   375
      Left            =   1920
      TabIndex        =   1
      Top             =   1680
      Width           =   975
   End
   Begin VB.CommandButton confirm 
      Caption         =   "确　定"
      Height          =   375
      Left            =   480
      TabIndex        =   0
      Top             =   1680
      Width           =   975
   End
   Begin VB.Label Label3 
      Alignment       =   2  'Center
      Caption         =   "查询值："
      Height          =   255
      Left            =   360
      TabIndex        =   5
      Top             =   1080
      Width           =   735
   End
   Begin VB.Label Label2 
      Alignment       =   2  'Center
      Caption         =   "查询"
      Height          =   255
      Left            =   2880
      TabIndex        =   4
      Top             =   360
      Width           =   495
   End
   Begin VB.Label Label1 
      Alignment       =   2  'Center
      Caption         =   "按"
      Height          =   255
      Left            =   600
      TabIndex        =   3
      Top             =   360
      Width           =   375
   End
End
Attribute VB_Name = "chaxun"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Private Sub cancel_Click()
    Unload Me
End Sub

Private Sub confirm_Click()
    On Error Resume Next
    Dim searchText As String
    Select Case searchBy.Text
        Case "姓名"
            searchText = "studentsname"
        Case "学号"
            searchText = "studentsnumber"
        Case "卡号"
            searchText = "cardnumber"
    End Select
            
    If ((chaxun.chaxunValue.Text <> "") And (chaxun.searchBy.Text <> "请选择")) Then
        '查找数据库里相应的内容
        rsGrade.MoveFirst
        Do While Not rsGrade.EOF
            '找到相应记录
            If rsGrade.Fields(searchText) = chaxun.chaxunValue.Text Then
                '读取卡上的数据
                '
                cdblock = 61
                status = RFMifare_Read(cdblock, ReadBuff(0))
                If status = 0 Then
                    Dim atemp As String
                    Dim atemp1 As String
                    For i = 0 To 15
                        atemp1 = Mid("00" + Hex(ReadBuff(i)), Len("00" + Hex(ReadBuff(i))) - 1)
                        atemp = atemp1 + atemp
                    Next i
                    
                Else
                    MsgBox "读数据失败！"
                End If

                MsgBox "卡号：" & rsGrade.Fields("cardnumber") & Chr(13) _
                       & "学号：" & rsGrade.Fields("studentsnumber") & Chr(13) _
                       & "姓名：" & rsGrade.Fields("studentsname") & Chr(13) _
                       & "余额：" & Val(atemp)
                rsGrade.MoveFirst
                Exit Sub
            End If
            
            rsGrade.MoveNext
        Loop
        MsgBox "没有找到相应记录！"
    End If

End Sub

Private Sub Form_Load()
    '初始化
    searchBy.Text = "请选择"
    searchBy.AddItem "姓名"
    searchBy.AddItem "学号"
    searchBy.AddItem "卡号"
    chaxunValue.Text = ""
End Sub