frmallbooks.frm

实现某班级的图书信息管理

VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Begin VB.Form FrmAllBooks 
   Caption         =   "FrmAllbooks"
   ClientHeight    =   2160
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   7455
   LinkTopic       =   "Form1"
   MDIChild        =   -1  'True
   ScaleHeight     =   2160
   ScaleWidth      =   7455
   Begin VB.Data datAllbooks 
      Caption         =   "Data1"
      Connect         =   "Access 2000;"
      DatabaseName    =   ""
      DefaultCursorType=   0  'DefaultCursor
      DefaultType     =   2  'UseODBC
      Exclusive       =   0   'False
      Height          =   300
      Left            =   1320
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   ""
      Top             =   4440
      Visible         =   0   'False
      Width           =   1815
   End
   Begin MSDBGrid.DBGrid DBGridbooks 
      Bindings        =   "FrmAllBooks.frx":0000
      Height          =   2175
      Left            =   0
      OleObjectBlob   =   "FrmAllBooks.frx":001A
      TabIndex        =   0
      Top             =   0
      Width           =   7455
   End
End
Attribute VB_Name = "FrmAllBooks"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub DBGridbooks_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
    
    FrmRegister.TxtBookindex = DBGridbooks.Columns(0)
    FrmRegister.TxtBookName = DBGridbooks.Columns(1)
    
End Sub

 '************************************************************************
     '本窗本用于浏览图书信息
 '*************************************************************************
Private Sub Form_Activate()
    
    Me.Top = 0
    Me.Left = 2800
    
    InitializeDataPath
    
    datAllbooks.DatabaseName = DataPath '取得BookMessage的数据路径
    datAllbooks.RecordSource = "SELECT bookmessage.bookindex ,bookname,status,count(borrowtime)as bcount,author,publish,jointime,type" _
    & "  from bookmessage left join borrowmessage on bookmessage.bookindex = borrowmessage.bookindex" _
    & "  group by bookmessage.bookindex ,bookname,author,publish,jointime,type,status"
    datAllbooks.Refresh '只有刷新了后才能改变数据源
   
End Sub

Private Sub Form_Load()
    
    FrmAllBooks.Height = 2550
    FrmAllBooks.Width = 7545
    
End Sub

Private Sub Form_Resize()
    
    DBGridbooks.Height = FrmAllBooks.ScaleHeight
    
    DBGridbooks.Width = FrmAllBooks.ScaleWidth
    
End Sub