readerinfo.frm

是有关于音像制品的管理系统

VERSION 5.00
Begin VB.Form readerInfo 
   BackColor       =   &H00FFFFC0&
   BorderStyle     =   1  'Fixed Single
   Caption         =   "会员注册"
   ClientHeight    =   3045
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   4620
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   Picture         =   "readerInfo.frx":0000
   ScaleHeight     =   3045
   ScaleWidth      =   4620
   StartUpPosition =   1  '所有者中心
   Begin VB.TextBox readerPassword 
      Height          =   375
      Left            =   1560
      TabIndex        =   9
      Top             =   1200
      Width           =   2295
   End
   Begin VB.CommandButton exit 
      Caption         =   "返 回"
      Height          =   375
      Left            =   2520
      TabIndex        =   8
      Top             =   2280
      Width           =   1215
   End
   Begin VB.CommandButton readerInfoAdd 
      Caption         =   "注 册"
      Height          =   375
      Left            =   600
      TabIndex        =   7
      Top             =   2280
      Width           =   1215
   End
   Begin VB.TextBox readerPhone 
      Height          =   375
      Left            =   1560
      TabIndex        =   6
      Top             =   1680
      Width           =   2295
   End
   Begin VB.TextBox readerName 
      Height          =   375
      Left            =   1560
      TabIndex        =   5
      Top             =   720
      Width           =   2295
   End
   Begin VB.TextBox readerNO 
      Height          =   375
      Left            =   1560
      TabIndex        =   4
      Top             =   240
      Width           =   2295
   End
   Begin VB.Label Label7 
      BackColor       =   &H00FFFFC0&
      BackStyle       =   0  'Transparent
      Caption         =   "联系电话："
      Height          =   255
      Left            =   600
      TabIndex        =   3
      Top             =   1800
      Width           =   975
   End
   Begin VB.Label Label5 
      BackColor       =   &H00FFFFC0&
      BackStyle       =   0  'Transparent
      Caption         =   "会员密码："
      Height          =   255
      Left            =   600
      TabIndex        =   2
      Top             =   1320
      Width           =   1095
   End
   Begin VB.Label Label2 
      BackColor       =   &H00FFFFC0&
      BackStyle       =   0  'Transparent
      Caption         =   "会员姓名："
      Height          =   255
      Left            =   600
      TabIndex        =   1
      Top             =   840
      Width           =   975
   End
   Begin VB.Label Label1 
      BackColor       =   &H00FFFFC0&
      BackStyle       =   0  'Transparent
      Caption         =   "会员编号："
      Height          =   255
      Left            =   600
      TabIndex        =   0
      Top             =   360
      Width           =   975
   End
End
Attribute VB_Name = "readerInfo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub exit_Click()
    Unload Me
End Sub

Private Sub Form_Load()
    '操作选择
    If ModifyRdFlag2 = True Then
      Dim rs As New ADODB.Recordset
      Dim sql As String
      sql = "select * from readers where readerNO ='" & ModifyRdFlag1 & "'"
      Set rs = TransactSQL(sql)
      readerNO.Text = rs.Fields(0)
      readerNO.Locked = True   ' 使不可改动
      readerName.Text = rs.Fields(1)
      readerPassword.Text = rs.Fields(2)
      readerPhone.Text = rs.Fields(3)
      ModifyRdFlag2 = ModifyRdFlag2 Xor True
      readerInfoAdd.Enabled = False
   End If
End Sub

Private Sub readerInfoAdd_Click()
    Dim rs As New ADODB.Recordset
    Dim sql As String
    sql = "select * from readers"
    Dim sql2 As String
    sql2 = "select * from readers where readerNO ='" & readerNO.Text & "'"
    If Trim(readerNO.Text) = "" Or Trim(readerName.Text) = "" Or _
         Trim(readerPassword.Text) = "" Or _
        Trim(readerPhone.Text) = "" Then
        MsgBox "信息录入不能为空！", vbOKOnly
    Else
       Set rs = TransactSQL(sql2)
       If rs.EOF = False Then
          MsgBox "该编号会员已经存在！", vbOKOnly
          rs.Close
       Else
         Set rs = TransactSQL(sql)
          rs.AddNew                '添加新纪录
            rs.Fields(0) = Trim(readerNO.Text)
            rs.Fields(1) = Trim(readerName.Text)
            rs.Fields(2) = Trim(readerPassword.Text)
            rs.Fields(3) = Trim(readerPhone.Text)
            rs.Update
            MsgBox "会员注册成功！", vbOKOnly
            rs.Close
        End If
    End If
End Sub