readerrewrite.frm

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

VERSION 5.00
Begin VB.Form readerRewrite 
   BackColor       =   &H00FFC0C0&
   Caption         =   "修改会员信息"
   ClientHeight    =   2985
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   4320
   LinkTopic       =   "Form1"
   Picture         =   "readerRewrite.frx":0000
   ScaleHeight     =   2985
   ScaleWidth      =   4320
   StartUpPosition =   3  '窗口缺省
   Begin VB.TextBox readerNO 
      Height          =   375
      Left            =   1440
      TabIndex        =   5
      Top             =   240
      Width           =   2295
   End
   Begin VB.TextBox readerName 
      Height          =   375
      Left            =   1440
      TabIndex        =   4
      Top             =   720
      Width           =   2295
   End
   Begin VB.TextBox readerPhone 
      Height          =   375
      Left            =   1440
      TabIndex        =   3
      Top             =   1680
      Width           =   2295
   End
   Begin VB.CommandButton readerOk 
      Caption         =   "确 定"
      Height          =   375
      Left            =   480
      TabIndex        =   2
      Top             =   2280
      Width           =   1215
   End
   Begin VB.CommandButton exit 
      Caption         =   "返 回"
      Height          =   375
      Left            =   2400
      TabIndex        =   1
      Top             =   2280
      Width           =   1215
   End
   Begin VB.TextBox readerPassword 
      Height          =   375
      Left            =   1440
      TabIndex        =   0
      Top             =   1200
      Width           =   2295
   End
   Begin VB.Label Label1 
      BackColor       =   &H00FFC0C0&
      BackStyle       =   0  'Transparent
      Caption         =   "会员编号："
      Height          =   255
      Left            =   480
      TabIndex        =   9
      Top             =   360
      Width           =   975
   End
   Begin VB.Label Label2 
      BackColor       =   &H00FFC0C0&
      BackStyle       =   0  'Transparent
      Caption         =   "会员姓名："
      Height          =   255
      Left            =   480
      TabIndex        =   8
      Top             =   840
      Width           =   975
   End
   Begin VB.Label Label5 
      BackColor       =   &H00FFC0C0&
      BackStyle       =   0  'Transparent
      Caption         =   "会员密码："
      Height          =   255
      Left            =   480
      TabIndex        =   7
      Top             =   1320
      Width           =   1095
   End
   Begin VB.Label Label7 
      BackColor       =   &H00FFC0C0&
      BackStyle       =   0  'Transparent
      Caption         =   "联系电话："
      Height          =   255
      Left            =   480
      TabIndex        =   6
      Top             =   1800
      Width           =   975
   End
End
Attribute VB_Name = "readerRewrite"
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
   End If
End Sub


Private Sub readerOk_Click()
    Dim rs As New ADODB.Recordset
    Dim sql As String
    sql = "update readers set readerNo= '" & readerNO.Text & "',readername='" & readerName.Text & "'"
    sql = sql & ",readerPassword='" & readerPassword.Text & "' "
    sql = sql & ",readerphone='" & readerPhone.Text & "'where readerno='" & readerNO.Text & "'"
    
    If Trim(readerNO.Text) = "" Or Trim(readerName.Text) = "" Or _
       Trim(readerPassword.Text) = "" Or _
       Trim(readerPhone.Text) = "" Then
        MsgBox "会员信息录入不能为空！", vbOKOnly
    Else
       TransactSQL (sql)
       MsgBox "会员信息修改成功！", vbOKOnly
       Unload Me
    End If
End Sub