数据统计.frm

其中包含比较详细的软件工程的概要设计说明书、详细设计说明书、系统需求规格说明书、项目开发计划书、软件工程课程设计报告、项目可行性研究报告

VERSION 5.00
Begin VB.Form 数据统计 
   Caption         =   "图书管理系统"
   ClientHeight    =   1965
   ClientLeft      =   6420
   ClientTop       =   5055
   ClientWidth     =   4545
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   ScaleHeight     =   1965
   ScaleWidth      =   4545
   Begin VB.TextBox TxtlibBookCount 
      BackColor       =   &H80000004&
      Enabled         =   0   'False
      Height          =   285
      Left            =   1200
      TabIndex        =   2
      Top             =   1200
      Width           =   3015
   End
   Begin VB.TextBox TxtReaderCount 
      BackColor       =   &H80000004&
      Enabled         =   0   'False
      Height          =   285
      Left            =   1200
      TabIndex        =   1
      Top             =   720
      Width           =   3015
   End
   Begin VB.TextBox TxtbookCount 
      BackColor       =   &H80000004&
      Enabled         =   0   'False
      Height          =   285
      Left            =   1200
      TabIndex        =   0
      Top             =   240
      Width           =   3015
   End
   Begin VB.Label Label15 
      AutoSize        =   -1  'True
      Caption         =   "在库图书"
      Enabled         =   0   'False
      Height          =   180
      Left            =   240
      TabIndex        =   5
      Top             =   1200
      Width           =   720
   End
   Begin VB.Label Label16 
      AutoSize        =   -1  'True
      Caption         =   "读者总量"
      Enabled         =   0   'False
      Height          =   180
      Left            =   240
      TabIndex        =   4
      Top             =   720
      Width           =   720
   End
   Begin VB.Label Label17 
      AutoSize        =   -1  'True
      Caption         =   "图书总量"
      Enabled         =   0   'False
      Height          =   180
      Left            =   240
      TabIndex        =   3
      Top             =   240
      Width           =   720
   End
End
Attribute VB_Name = "数据统计"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Private Sub Form_Load()
    On Error GoTo ERR
    Dim rsBook As ADODB.Recordset
    Dim rsReader As ADODB.Recordset
    
    If (de.rsBook.State = 0) Then de.Book
    If (de.rsReader.State = 0) Then de.reader
    Set rsBook = de.rsBook
    Set rsReader = de.rsReader
    
    Txtbookcount = rsBook.RecordCount
    TxtReaderCount = rsReader.RecordCount
    rsBook.Filter = "bookstatus <> '已借'"
    TxtlibBookCount = rsBook.RecordCount
    rsBook.Filter = 0
ERR:
    If ERR.Number = 3001 Then Exit Sub
End Sub

Private Sub Form_Unload(Cancel As Integer)
    系统操作.Show
End Sub