frmmain.frm

这是一个航空管理系统用vb和sql的做的. 是 VB数据库系统开发实例导航,中的一个实例

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.MDIForm frmMain 
   BackColor       =   &H8000000C&
   Caption         =   "大唐航空公司信息管理系统"
   ClientHeight    =   2484
   ClientLeft      =   132
   ClientTop       =   1032
   ClientWidth     =   3744
   LinkTopic       =   "MDIForm1"
   StartUpPosition =   3  'Windows Default
   Begin MSComctlLib.StatusBar sbStatusBar 
      Align           =   2  'Align Bottom
      Height          =   264
      Left            =   0
      TabIndex        =   0
      Top             =   8256
      Width           =   12192
      _ExtentX        =   21505
      _ExtentY        =   466
      _Version        =   393216
      BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628} 
         NumPanels       =   3
         BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            AutoSize        =   1
            Object.Width           =   15896
            Text            =   "Status"
            TextSave        =   "Status"
         EndProperty
         BeginProperty Panel2 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            Style           =   6
            AutoSize        =   2
            TextSave        =   "2002-1-22"
         EndProperty
         BeginProperty Panel3 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            Style           =   5
            AutoSize        =   2
            TextSave        =   "8:24"
         EndProperty
      EndProperty
   End
   Begin VB.Menu menuSystem 
      Caption         =   "系统"
      Begin VB.Menu menuModifypwd 
         Caption         =   "修改密码"
      End
      Begin VB.Menu menuAdduser 
         Caption         =   "添加用户"
      End
      Begin VB.Menu menuExit 
         Caption         =   "退出"
      End
   End
   Begin VB.Menu menuMairline 
      Caption         =   "航线信息管理"
      Begin VB.Menu menuCarbin 
         Caption         =   "舱位信息"
      End
      Begin VB.Menu menuPlane 
         Caption         =   "客机信息"
      End
      Begin VB.Menu menuAirline 
         Caption         =   "航线信息"
      End
   End
   Begin VB.Menu menuCustomerinfo 
      Caption         =   "客户信息管理"
      Begin VB.Menu menuCtype 
         Caption         =   "客户类型"
      End
      Begin VB.Menu menuCustomer 
         Caption         =   "客户信息"
      End
   End
   Begin VB.Menu menuMticket 
      Caption         =   "票务信息管理"
      Begin VB.Menu menuBookticket 
         Caption         =   "订票管理"
      End
   End
   Begin VB.Menu menuHelp 
      Caption         =   "帮助"
      Begin VB.Menu menuAbout 
         Caption         =   "About"
      End
   End
End
Attribute VB_Name = "frmMain"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub MDIForm_Load()
    Me.Left = GetSetting(App.Title, "Settings", "MainLeft", 1000)
    Me.Top = GetSetting(App.Title, "Settings", "MainTop", 1000)
    Me.Width = GetSetting(App.Title, "Settings", "MainWidth", 6500)
    Me.Height = GetSetting(App.Title, "Settings", "MainHeight", 6500)
  
End Sub




Private Sub MDIForm_Unload(Cancel As Integer)
    If Me.WindowState <> vbMinimized Then
        SaveSetting App.Title, "Settings", "MainLeft", Me.Left
        SaveSetting App.Title, "Settings", "MainTop", Me.Top
        SaveSetting App.Title, "Settings", "MainWidth", Me.Width
        SaveSetting App.Title, "Settings", "MainHeight", Me.Height
    End If
End Sub


Private Sub menuAirline_Click()
    frmAirline.txtSQL = "select * from airlineInfo"
    frmAirline.Show 0
End Sub

Private Sub menuBookticket_Click()
    frmTicket.txtSQL = "select * from ticketInfo "
    frmTicket.Show 0
End Sub

Private Sub menuCarbin_Click()
    frmService.txtSQL = "select * from serviceInfo"
    frmService.Show 0
End Sub

Private Sub menuCtype_Click()
    frmcType.txtSQL = "select * from customerType"
    frmcType.Show 0
End Sub

Private Sub menuCustomer_Click()
    frmCustomer.txtSQL = "select * from customerInfo"
    frmCustomer.Show 0
End Sub

Private Sub menuPlane_Click()
    frmPlane.txtSQL = "select * from planeInfo"
    frmPlane.Show 0
End Sub