frmmain.frm

VB和Oracle结合的程序

VERSION 5.00
Begin VB.Form FrmMain 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "图书借阅管理系统"
   ClientHeight    =   8220
   ClientLeft      =   60
   ClientTop       =   375
   ClientWidth     =   11805
   Icon            =   "FrmMain.frx":0000
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   Picture         =   "FrmMain.frx":0CCA
   ScaleHeight     =   8220
   ScaleWidth      =   11805
   StartUpPosition =   2  '屏幕中心
   Begin VB.Label lblexit 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "退出系统"
      BeginProperty Font 
         Name            =   "幼圆"
         Size            =   18
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000C0&
      Height          =   360
      Left            =   8880
      MouseIcon       =   "FrmMain.frx":2FB3A
      MousePointer    =   99  'Custom
      TabIndex        =   6
      Top             =   5400
      Width           =   1500
   End
   Begin VB.Shape Shape1 
      BorderColor     =   &H000000C0&
      FillColor       =   &H80000012&
      Height          =   855
      Left            =   8400
      Shape           =   4  'Rounded Rectangle
      Top             =   5160
      Width           =   2415
   End
   Begin VB.Label lbluser 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "系统用户管理"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   20.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000C0&
      Height          =   405
      Left            =   8520
      MouseIcon       =   "FrmMain.frx":2FE44
      MousePointer    =   99  'Custom
      TabIndex        =   5
      Top             =   3825
      Width           =   2520
   End
   Begin VB.Image Image6 
      Height          =   255
      Left            =   8040
      Picture         =   "FrmMain.frx":3014E
      Stretch         =   -1  'True
      Top             =   3900
      Width           =   255
   End
   Begin VB.Label lblborrow 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "图书借阅管理"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   20.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000C0&
      Height          =   405
      Left            =   5040
      MouseIcon       =   "FrmMain.frx":307E8
      MousePointer    =   99  'Custom
      TabIndex        =   4
      Top             =   3825
      Width           =   2520
   End
   Begin VB.Image Image5 
      Height          =   255
      Left            =   4560
      Picture         =   "FrmMain.frx":30AF2
      Stretch         =   -1  'True
      Top             =   3900
      Width           =   255
   End
   Begin VB.Label lblcards 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "借阅证件管理"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   20.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000C0&
      Height          =   405
      Left            =   1560
      MouseIcon       =   "FrmMain.frx":3118C
      MousePointer    =   99  'Custom
      TabIndex        =   3
      Top             =   3825
      Width           =   2520
   End
   Begin VB.Image Image4 
      Height          =   255
      Left            =   1080
      Picture         =   "FrmMain.frx":31496
      Stretch         =   -1  'True
      Top             =   3900
      Width           =   255
   End
   Begin VB.Label lblstore 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "图书库存管理"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   20.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000C0&
      Height          =   405
      Left            =   8520
      MouseIcon       =   "FrmMain.frx":31B30
      MousePointer    =   99  'Custom
      TabIndex        =   2
      Top             =   2685
      Width           =   2520
   End
   Begin VB.Image Image3 
      Height          =   255
      Left            =   8040
      Picture         =   "FrmMain.frx":31E3A
      Stretch         =   -1  'True
      Top             =   2760
      Width           =   255
   End
   Begin VB.Label lblinfo 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "基本信息管理"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   20.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000C0&
      Height          =   405
      Left            =   5040
      MouseIcon       =   "FrmMain.frx":324D4
      MousePointer    =   99  'Custom
      TabIndex        =   1
      Top             =   2685
      Width           =   2520
   End
   Begin VB.Image Image2 
      Height          =   255
      Left            =   4560
      Picture         =   "FrmMain.frx":327DE
      Stretch         =   -1  'True
      Top             =   2760
      Width           =   255
   End
   Begin VB.Label lbltype 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "图书分类管理"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   20.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000C0&
      Height          =   405
      Left            =   1560
      MouseIcon       =   "FrmMain.frx":32E78
      MousePointer    =   99  'Custom
      TabIndex        =   0
      Top             =   2685
      Width           =   2520
   End
   Begin VB.Image Image1 
      Height          =   255
      Left            =   1080
      Picture         =   "FrmMain.frx":33182
      Stretch         =   -1  'True
      Top             =   2760
      Width           =   255
   End
End
Attribute VB_Name = "FrmMain"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Load()
  FrmLogin.Show 1
End Sub

Private Sub lblborrow_Click()
  FrmBorrow.Show 1
End Sub

Private Sub lblcards_Click()
  FrmCards.Show 1
End Sub

Private Sub lblexit_Click()
  DBapi_Disconnect
  End
End Sub

Private Sub lblinfo_Click()
  FrmBookInfo.Show 1
End Sub

Private Sub lblstore_Click()
  FrmStoreIn.Show 1
End Sub

Private Sub lbltype_Click()
  FrmBookType.Show 1
End Sub

Private Sub lbluser_Click()
    '如果当前用户为Admin，则打开用户管理窗体
  If Trim(CurUser.UserName) = "Admin" Then
    FrmUserMan.Show 1
  Else
  '如果当前用户是普通用户，则打开用户编辑窗体，编辑自己的用户信息
    With FrmUserEdit
    .OriUser = CurUser.UserName
    .txtUserName = CurUser.UserName
    .txtPass = CurUser.UserPwd
    .txtPass2 = CurUser.UserPwd
    .Modify = True
    .Show 1
    End With
  End If
End Sub