edlev1.frm

系统实现了图书的添加

VERSION 5.00
Begin VB.Form edlev1 
   Caption         =   "记录编辑"
   ClientHeight    =   5250
   ClientLeft      =   60
   ClientTop       =   420
   ClientWidth     =   5130
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   5250
   ScaleWidth      =   5130
   StartUpPosition =   2  '屏幕中心
   Begin VB.TextBox Text1 
      Height          =   375
      Index           =   3
      Left            =   2040
      TabIndex        =   10
      Top             =   2760
      Width           =   1815
   End
   Begin VB.TextBox Text1 
      Height          =   375
      Index           =   2
      Left            =   2040
      TabIndex        =   9
      Top             =   2280
      Width           =   1815
   End
   Begin VB.TextBox Text1 
      Height          =   375
      Index           =   1
      Left            =   2040
      TabIndex        =   8
      Top             =   1800
      Width           =   1815
   End
   Begin VB.CommandButton Comm2 
      Caption         =   "取    消"
      Height          =   375
      Left            =   3000
      TabIndex        =   6
      Top             =   4440
      Width           =   855
   End
   Begin VB.CommandButton Comm1 
      Caption         =   "确    定"
      Height          =   375
      Left            =   1560
      TabIndex        =   5
      Top             =   4440
      Width           =   855
   End
   Begin VB.Frame Frame1 
      Caption         =   "记录编辑"
      Height          =   3495
      Left            =   840
      TabIndex        =   0
      Top             =   480
      Width           =   3735
      Begin VB.TextBox Text1 
         Height          =   375
         Index           =   0
         Left            =   1200
         TabIndex        =   7
         Top             =   840
         Width           =   1815
      End
      Begin VB.Label Label4 
         Caption         =   "借书天数"
         Height          =   255
         Left            =   240
         TabIndex        =   4
         Top             =   2400
         Width           =   975
      End
      Begin VB.Label Label3 
         Caption         =   "借书总数"
         Height          =   255
         Left            =   240
         TabIndex        =   3
         Top             =   1920
         Width           =   975
      End
      Begin VB.Label Label2 
         Caption         =   "过期罚款"
         Height          =   255
         Left            =   240
         TabIndex        =   2
         Top             =   1440
         Width           =   975
      End
      Begin VB.Label Label1 
         Caption         =   "级    别"
         Height          =   255
         Left            =   240
         TabIndex        =   1
         Top             =   960
         Width           =   975
      End
   End
End
Attribute VB_Name = "edlev1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim cond As String

Private Sub Comm1_Click()
   If Trim(Text1(0).Text) = "" Or Trim(Text1(1).Text) = "" _
      Or Trim(Text1(2).Text) = "" Or Trim(Text1(3).Text) = "" Then
      MsgBox "所有项目都不能为空，请重新输入", vbOKOnly, "信息提示"
      Text1(0).SetFocus
      Exit Sub
    End If
    If flag = 1 Then
       If edlev.Adodc1.Recordset.RecordCount > 0 Then
          cond = "级别='" + Trim(Text1(0).Text) + "'"
          edlev.Adodc1.Recordset.MoveFirst
          edlev.Adodc1.Recordset.Find (cond)
          If Not edlev.Adodc1.Recordset.EOF() Then
             MsgBox "存在完全相同的记录", vbOKOnly, "信息提示"
             Text1(0).SetFocus
             Exit Sub
          End If
        End If
        edlev.Adodc1.Recordset.AddNew
        edlev.Adodc1.Recordset.Fields("级别") = Trim(Text1(0).Text)
        edlev.Adodc1.Recordset.Fields("过期罚款") = Val(Trim(Text1(1).Text))
        edlev.Adodc1.Recordset.Fields("借书总数") = Val(Trim(Text1(2).Text))
        edlev.Adodc1.Recordset.Fields("借书天数") = Val(Trim(Text1(3).Text))
        edlev.Adodc1.Recordset.Update
        recs = recs + 1
    Else
        n = edlev.Adodc1.Recordset.AbsolutePosition
        cond = "级别='" + Trim(Text1(0).Text) + "'"
        edlev.Adodc1.Recordset.MoveFirst
        edlev.Adodc1.Recordset.Find (cond)
        If Not edlev.Adodc1.Recordset.EOF() And _
              edlev.Adodc1.Recordset.AbsolutePosition <> n Then
            MsgBox "存在完全相同的记录", vbOKOnly, "信息提示"
            edlev.Adodc1.Recordset.MoveFirst
            edlev.Adodc1.Recordset.Move (n - 1)
            Text1(0).SetFocus
            Exit Sub
        End If
        edlev.Adodc1.Recordset.MoveFirst
        edlev.Adodc1.Recordset.Move (n - 1)
        edlev.Adodc1.Recordset.Fields("级别") = Trim(Text1(0).Text)
        edlev.Adodc1.Recordset.Fields("过期罚款") = Val(Trim(Text1(1).Text))
        edlev.Adodc1.Recordset.Fields("过期罚款") = Val(Trim(Text1(2).Text))
        edlev.Adodc1.Recordset.Fields("过期罚款") = Val(Trim(Text1(3).Text))
        edlev.Adodc1.Recordset.Update
    End If
    Unload Me
End Sub

Private Sub Comm2_Click()
   Unload Me
End Sub


Private Sub Form_Load()
   If flag = 2 Then
      Text1(0).Text = edlev.Adodc1.Recordset.Fields("级别")
      Text1(1).Text = edlev.Adodc1.Recordset.Fields("过期罚款")
      Text1(2).Text = edlev.Adodc1.Recordset.Fields("借书总数")
      Text1(3).Text = edlev.Adodc1.Recordset.Fields("借书天数")
    End If
End Sub