addvip.frm

VB+ACCESS2000编写的VCD出租管理系统

VERSION 5.00
Begin VB.Form AddVip 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "添加会员"
   ClientHeight    =   3090
   ClientLeft      =   45
   ClientTop       =   435
   ClientWidth     =   6255
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   ScaleHeight     =   3090
   ScaleWidth      =   6255
   Begin VB.CommandButton Command2 
      Caption         =   "关闭(&C)"
      Height          =   375
      Left            =   4920
      TabIndex        =   7
      Top             =   2520
      Width           =   1215
   End
   Begin VB.CommandButton Command1 
      Caption         =   "添加(&A)"
      Height          =   375
      Left            =   3480
      TabIndex        =   6
      Top             =   2520
      Width           =   1215
   End
   Begin VB.TextBox TxtInfo 
      Appearance      =   0  'Flat
      BackColor       =   &H0080FFFF&
      Enabled         =   0   'False
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000FF&
      Height          =   375
      Index           =   3
      Left            =   1320
      TabIndex        =   5
      Top             =   1680
      Width           =   1575
   End
   Begin VB.TextBox TxtInfo 
      Appearance      =   0  'Flat
      Height          =   375
      Index           =   2
      Left            =   1320
      TabIndex        =   3
      Top             =   1080
      Width           =   1575
   End
   Begin VB.TextBox TxtInfo 
      Appearance      =   0  'Flat
      Height          =   375
      Index           =   1
      Left            =   4200
      TabIndex        =   2
      Top             =   360
      Width           =   1575
   End
   Begin VB.Frame Frame1 
      Caption         =   "会员信息"
      Height          =   2175
      Left            =   120
      TabIndex        =   0
      Top             =   120
      Width           =   6015
      Begin VB.TextBox Text1 
         Appearance      =   0  'Flat
         BackColor       =   &H0080FFFF&
         Enabled         =   0   'False
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H000000FF&
         Height          =   375
         Left            =   4080
         TabIndex        =   14
         Top             =   1560
         Width           =   1575
      End
      Begin VB.ComboBox Combo1 
         Appearance      =   0  'Flat
         Height          =   300
         Left            =   4080
         TabIndex        =   4
         Top             =   960
         Width           =   1575
      End
      Begin VB.TextBox TxtInfo 
         Appearance      =   0  'Flat
         Height          =   375
         Index           =   0
         Left            =   1200
         TabIndex        =   1
         Top             =   240
         Width           =   1575
      End
      Begin VB.Label Label2 
         Caption         =   "交纳会费："
         Height          =   375
         Left            =   3120
         TabIndex        =   13
         Top             =   1680
         Width           =   975
      End
      Begin VB.Label Label1 
         Caption         =   "办理日期："
         Height          =   255
         Index           =   4
         Left            =   240
         TabIndex        =   12
         Top             =   1680
         Width           =   975
      End
      Begin VB.Label Label1 
         Caption         =   "会员级别："
         Height          =   375
         Index           =   3
         Left            =   3120
         TabIndex        =   11
         Top             =   1080
         Width           =   975
      End
      Begin VB.Label Label1 
         Caption         =   "会员电话："
         Height          =   375
         Index           =   2
         Left            =   240
         TabIndex        =   10
         Top             =   1080
         Width           =   1095
      End
      Begin VB.Label Label1 
         Caption         =   "会员姓名："
         Height          =   375
         Index           =   1
         Left            =   3120
         TabIndex        =   9
         Top             =   360
         Width           =   975
      End
      Begin VB.Label Label1 
         Caption         =   "会 员 ID："
         Height          =   255
         Index           =   0
         Left            =   240
         TabIndex        =   8
         Top             =   360
         Width           =   1095
      End
   End
End
Attribute VB_Name = "AddVip"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Private Sub Combo1_click()
Dim SQL As String
Dim Rmb As String
SQL = "select 会员交费 from viptype where 会员级别= """ & Combo1.Text & """"
OpenDBFile

OpenRS (SQL)
If Not gRst.EOF Then
     Rmb = gRst("会员交费")
End If
CloseRS

Text1.Text = Format(Rmb, "0.00") + "元"
End Sub

Private Sub Command1_Click()
Dim SQL As String
Dim CDSum As Integer
Dim i As Integer
Dim vbInfo As Boolean
For i = 0 To 2
   If TxtInfo(i) = "" Then
      MsgBox "对不起：" & Label1(i).Caption & "不能为空！", vbInformation + vbOKOnly, "信息"
      TxtInfo(i).SetFocus
      Exit Sub
   End If
Next

If Combo1.Text = "" Then
    MsgBox "对不起，请选择会员级别！", vbInformation + vbOKOnly, "信息"
    Combo1.SetFocus
    Exit Sub
End If

SQL = "select 会员ID from vipinfo where 会员ID=""" & TxtInfo(0).Text & """"
OpenDBFile
OpenRS (SQL)
    If Not gRst.EOF Then
         vbInfo = True
    End If
CloseRS
If vbInfo = True Then
    MsgBox "对不起该会员ID已经存在请输入新的ID号！", vbInformation + vbOKOnly, "提示"
    TxtInfo(0).Text = ""
    TxtInfo(0).SetFocus
    Exit Sub
End If
SQL = "select * from viptype where 会员级别=""" & Combo1.Text & """"
OpenDBFile
OpenRS (SQL)
If Not gRst.BOF Then
   gRst.MoveFirst
End If
If gRst.EOF Then
   MsgBox "对不起，你输入的会员级别不存在，请选择或输入正确的会员级别！", vbInformation + vbOKOnly, "警告"
   Combo1.Text = ""
   CloseRS
   Exit Sub
End If
If Not gRst.EOF Then
   CDSum = gRst("可借碟片")
End If
CloseRS

SQL = "insert into vipinfo(会员ID,会员姓名,会员电话,会员级别,办理日期,还剩盘数)values(""" _
                           & TxtInfo(0).Text & """,""" _
                           & TxtInfo(1).Text & """,""" _
                           & TxtInfo(2).Text & """,""" _
                           & Combo1.Text & """,#" _
                           & TxtInfo(3).Text & "#," _
                           & CDSum & ")"
OpenDBFile

gCon.Execute SQL

CloseDBFile

For i = 0 To 2
TxtInfo(i) = ""
Next
Text1.Text = ""
Combo1.Text = ""
TxtInfo(0).SetFocus
MsgBox "会员信息已经成功添加！", vbInformation + vbOKOnly, "提示"

End Sub

Private Sub Command2_Click()
Unload Me
End Sub

Private Sub Form_Load()
Dim SQL As String
SQL = "select 会员级别 from viptype"
OpenDBFile

OpenRS (SQL)

If gRst.RecordCount > 0 Then
gRst.MoveFirst
Do While Not gRst.EOF
    Combo1.AddItem gRst("会员级别")
    gRst.MoveNext
Loop
CloseRS
TxtInfo(3).Text = Date
Else
   MsgBox "请先添加会员分级信息！", vbInformation + vbOKOnly, "提示"
   CloseRS
   VipType.Show
   Unload Me
   Exit Sub
End If
End Sub