frmissue.frm

该压缩包包含有很多关于数据库原理与应用的课件以及课程设计

VERSION 5.00
Begin VB.Form frmIssue 
   Caption         =   "借书信息"
   ClientHeight    =   4935
   ClientLeft      =   120
   ClientTop       =   420
   ClientWidth     =   9780
   LinkTopic       =   "Form2"
   MDIChild        =   -1  'True
   ScaleHeight     =   4935
   ScaleWidth      =   9780
   WindowState     =   2  'Maximized
   Begin VB.CommandButton cmdMemberOpen 
      Caption         =   "..."
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   4200
      TabIndex        =   15
      Top             =   2400
      Width           =   735
   End
   Begin VB.CommandButton cmdBookOpen 
      Caption         =   "..."
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   4200
      TabIndex        =   14
      Top             =   1680
      Width           =   735
   End
   Begin VB.CommandButton cmdLast 
      BackColor       =   &H00FFFFFF&
      Caption         =   "最后一条"
      Height          =   615
      Left            =   8040
      TabIndex        =   13
      Top             =   3480
      Width           =   975
   End
   Begin VB.CommandButton cmdNext 
      BackColor       =   &H00FFFFFF&
      Caption         =   "下一条"
      Height          =   615
      Left            =   6924
      TabIndex        =   12
      Top             =   3480
      Width           =   975
   End
   Begin VB.CommandButton cmdPrevious 
      BackColor       =   &H00FFFFFF&
      Caption         =   "上一条"
      Height          =   615
      Left            =   5810
      TabIndex        =   11
      Top             =   3480
      Width           =   975
   End
   Begin VB.CommandButton cmdFirst 
      BackColor       =   &H00FFFFFF&
      Caption         =   "第一条"
      Height          =   615
      Left            =   4696
      TabIndex        =   10
      Top             =   3480
      Width           =   975
   End
   Begin VB.CommandButton cmdCancel 
      Caption         =   "取消"
      Height          =   615
      Left            =   3582
      TabIndex        =   9
      Top             =   3480
      Width           =   975
   End
   Begin VB.CommandButton cmdSave 
      Caption         =   "保存"
      Height          =   615
      Left            =   2468
      TabIndex        =   8
      Top             =   3480
      Width           =   975
   End
   Begin VB.CommandButton cmdDel 
      Caption         =   "删除"
      Height          =   615
      Left            =   1354
      TabIndex        =   7
      Top             =   3480
      Width           =   975
   End
   Begin VB.CommandButton cmdAddNew 
      BackColor       =   &H00FFFFFF&
      Caption         =   "添加"
      Height          =   615
      Left            =   240
      TabIndex        =   6
      Top             =   3480
      Width           =   975
   End
   Begin VB.ComboBox cmbLibraryId 
      Height          =   300
      Left            =   2400
      TabIndex        =   2
      Text            =   "Combo1"
      Top             =   2400
      Width           =   1695
   End
   Begin VB.ComboBox cmbBookId 
      Height          =   300
      Left            =   2400
      TabIndex        =   1
      Text            =   "Combo1"
      Top             =   1560
      Width           =   1695
   End
   Begin VB.TextBox txtIssueDate 
      Height          =   300
      Left            =   2400
      TabIndex        =   0
      Text            =   "Text1"
      Top             =   720
      Width           =   1695
   End
   Begin VB.Label Label3 
      Caption         =   "读者编号"
      BeginProperty Font 
         Name            =   "微软雅黑"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   480
      TabIndex        =   5
      Top             =   2280
      Width           =   1335
   End
   Begin VB.Label Label2 
      Caption         =   "图书编号"
      BeginProperty Font 
         Name            =   "微软雅黑"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   480
      TabIndex        =   4
      Top             =   1440
      Width           =   1695
   End
   Begin VB.Label Label1 
      Caption         =   "借书日期"
      BeginProperty Font 
         Name            =   "微软雅黑"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   480
      TabIndex        =   3
      Top             =   720
      Width           =   1575
   End
End
Attribute VB_Name = "frmIssue"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdAddNew_Click()
On Error Resume Next
Call clear
Dim i As Integer
addnewflag = True
cmdAddNew.Enabled = False
cmdSave.Caption = "Issue"
'向cmbLibraryId下拉列表中添加图书馆编号
For i = 0 To rsLibraryId.RecordCount
    cmbLibraryId.AddItem rsLibraryId(0)
    rsLibraryId.MoveNext
    If rsLibraryId.EOF = True Then
        rsLibraryId.MoveLast
        cmbLibraryId.ListIndex = 0
        Exit For
    End If
Next i
'向cmbBookId下拉列表中添加图书编号
For i = 0 To rsBookId.RecordCount
    cmbBookId.AddItem rsBookId(0)
    rsBookId.MoveNext
    If rsBookId.EOF = True Then
        rsBookId.MoveLast
        cmbBookId.ListIndex = 0
        Exit For
    End If
Next i

cmdCancel.Enabled = True
cmdDel.Enabled = False
cmdFirst.Enabled = False
cmdLast.Enabled = False
cmdPrevious.Enabled = False
cmdNext.Enabled = False

'添加新记录
rsIssueInfo.AddNew
txtIssueDate.Text = Date$
cmbLibraryId.SetFocus
End Sub

Private Sub cmdCancel_Click()
cmdAddNew.Enabled = True
cmdDel.Enabled = True
cmdFirst.Enabled = True
cmdLast.Enabled = True
cmdPrevious.Enabled = True
cmdNext.Enabled = True
cmdCancel.Enabled = False
cmdSave.Caption = "Save"
rsIssueInfo.CancelUpdate
Call display
End Sub

Private Sub cmdDel_Click()
On Error Resume Next
If MsgBox("Are you sure to delete record", vbOKCancel + vbExclamation, "Deleting record") = vbOK Then
    rsIssueInfo.Delete
    rsIssueInfo.MoveNext
    If rsIssueInfo.EOF Then
        rsIssueInfo.MoveLast
        MsgBox "Last record"
    End If
    Call display
End If
End Sub

Private Sub cmdSave_Click()
On Error Resume Next
Call assign
rsIssueInfo.save
MsgBox "Record saved", vbInformation, "Record is saved"

cmdDel.Enabled = True
cmdFirst.Enabled = True
cmdLast.Enabled = True
cmdPrevious.Enabled = True
cmdNext.Enabled = True
cmdAddNew.Enabled = True
cmdCancel.Enabled = False
cmdSave.Caption = "Save"
Exit Sub
End Sub