⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 frmticket1.frm

📁 这是一个航空管理系统用vb和sql的做的. 是 VB数据库系统开发实例导航,中的一个实例
💻 FRM
📖 第 1 页 / 共 2 页
字号:
VERSION 5.00
Begin VB.Form frmTicket1 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "机票信息"
   ClientHeight    =   5172
   ClientLeft      =   48
   ClientTop       =   336
   ClientWidth     =   6384
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   5172
   ScaleWidth      =   6384
   ShowInTaskbar   =   0   'False
   StartUpPosition =   1  'CenterOwner
   Begin VB.TextBox ticketFsum 
      Height          =   270
      Left            =   840
      TabIndex        =   27
      TabStop         =   0   'False
      Top             =   4800
      Visible         =   0   'False
      Width           =   735
   End
   Begin VB.TextBox ticketMsum 
      Height          =   270
      Left            =   840
      TabIndex        =   26
      TabStop         =   0   'False
      Top             =   4440
      Visible         =   0   'False
      Width           =   735
   End
   Begin VB.TextBox ticketCsum 
      Height          =   270
      Left            =   0
      TabIndex        =   25
      TabStop         =   0   'False
      Top             =   4800
      Visible         =   0   'False
      Width           =   735
   End
   Begin VB.Frame Frame1 
      Caption         =   "备注信息:"
      Height          =   1212
      Index           =   2
      Left            =   120
      TabIndex        =   19
      Top             =   3120
      Width           =   6132
      Begin VB.TextBox txtItem 
         Height          =   840
         Index           =   1
         Left            =   240
         MaxLength       =   80
         MultiLine       =   -1  'True
         ScrollBars      =   2  'Vertical
         TabIndex        =   24
         Top             =   240
         Width           =   5532
      End
   End
   Begin VB.TextBox txtairline 
      Height          =   270
      Left            =   5520
      TabIndex        =   18
      TabStop         =   0   'False
      Top             =   4680
      Visible         =   0   'False
      Width           =   735
   End
   Begin VB.TextBox txtcustomer 
      Height          =   270
      Left            =   4560
      TabIndex        =   17
      TabStop         =   0   'False
      Top             =   4680
      Visible         =   0   'False
      Width           =   735
   End
   Begin VB.TextBox txtticket 
      Height          =   270
      Left            =   0
      TabIndex        =   16
      TabStop         =   0   'False
      Top             =   4440
      Visible         =   0   'False
      Width           =   735
   End
   Begin VB.Frame Frame1 
      Caption         =   "客户信息:"
      Height          =   1212
      Index           =   1
      Left            =   120
      TabIndex        =   12
      Top             =   1800
      Width           =   6132
      Begin VB.ComboBox Combo1 
         Height          =   288
         Index           =   6
         Left            =   1560
         Style           =   2  'Dropdown List
         TabIndex        =   23
         Top             =   720
         Width           =   1212
      End
      Begin VB.ComboBox Combo1 
         Height          =   288
         Index           =   5
         Left            =   4560
         Style           =   2  'Dropdown List
         TabIndex        =   22
         Top             =   360
         Width           =   1212
      End
      Begin VB.ComboBox Combo1 
         Height          =   288
         Index           =   4
         Left            =   1560
         Style           =   2  'Dropdown List
         TabIndex        =   21
         Top             =   360
         Width           =   1212
      End
      Begin VB.Label Label2 
         Caption         =   "客    户    类    型:"
         Height          =   252
         Index           =   15
         Left            =   3360
         TabIndex        =   15
         Top             =   360
         Width           =   1212
      End
      Begin VB.Label Label2 
         Caption         =   "客   户    姓   名:"
         Height          =   252
         Index           =   14
         Left            =   360
         TabIndex        =   14
         Top             =   360
         Width           =   1212
      End
      Begin VB.Label Label2 
         Caption         =   "折   扣   比   例:"
         Height          =   252
         Index           =   13
         Left            =   360
         TabIndex        =   13
         Top             =   720
         Width           =   1212
      End
   End
   Begin VB.Frame Frame1 
      Caption         =   "航线信息:"
      Height          =   1572
      Index           =   0
      Left            =   120
      TabIndex        =   6
      Top             =   120
      Width           =   6132
      Begin VB.ComboBox Combo1 
         Height          =   288
         Index           =   3
         Left            =   1560
         Style           =   2  'Dropdown List
         TabIndex        =   20
         Top             =   1080
         Width           =   1212
      End
      Begin VB.ComboBox Combo1 
         Height          =   288
         Index           =   2
         Left            =   4560
         Style           =   2  'Dropdown List
         TabIndex        =   3
         Top             =   720
         Width           =   1212
      End
      Begin VB.ComboBox Combo1 
         Height          =   288
         Index           =   1
         Left            =   4560
         Style           =   2  'Dropdown List
         TabIndex        =   1
         Top             =   360
         Width           =   1212
      End
      Begin VB.ComboBox Combo1 
         Height          =   288
         Index           =   0
         Left            =   1560
         Style           =   2  'Dropdown List
         TabIndex        =   0
         Top             =   360
         Width           =   1212
      End
      Begin VB.TextBox txtItem 
         Height          =   270
         Index           =   0
         Left            =   1560
         MaxLength       =   20
         TabIndex        =   2
         Top             =   720
         Width           =   1212
      End
      Begin VB.Label Label2 
         Caption         =   "票                    价:"
         Height          =   252
         Index           =   7
         Left            =   360
         TabIndex        =   11
         Top             =   1080
         Width           =   1212
      End
      Begin VB.Label Label2 
         Caption         =   "舱    位    类    型:"
         Height          =   252
         Index           =   6
         Left            =   3360
         TabIndex        =   10
         Top             =   720
         Width           =   1212
      End
      Begin VB.Label Label2 
         Caption         =   "出    发    时    间:"
         Height          =   252
         Index           =   5
         Left            =   360
         TabIndex        =   9
         Top             =   720
         Width           =   1212
      End
      Begin VB.Label Label2 
         Caption         =   "出    发    城    市:"
         Height          =   252
         Index           =   0
         Left            =   360
         TabIndex        =   8
         Top             =   360
         Width           =   1212
      End
      Begin VB.Label Label2 
         Caption         =   "到    达    城    市:"
         Height          =   252
         Index           =   1
         Left            =   3360
         TabIndex        =   7
         Top             =   360
         Width           =   1212
      End
   End
   Begin VB.CommandButton cmdExit 
      Caption         =   "返回 (&X)"
      Height          =   375
      Left            =   3120
      TabIndex        =   5
      Top             =   4560
      Width           =   1215
   End
   Begin VB.CommandButton cmdSave 
      Caption         =   "保存 (&S)"
      Height          =   375
      Left            =   1680
      TabIndex        =   4
      Top             =   4560
      Width           =   1215
   End
End
Attribute VB_Name = "frmTicket1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
'是否改动过记录,ture为改过
Dim mblChange As Boolean
Dim mrc As ADODB.Recordset
Public txtSQL As String

Private Sub cmdExit_Click()
    If mblChange And cmdSave.Enabled Then
        If MsgBox("保存当前记录的变化吗?", vbOKCancel + vbExclamation, "警告") = vbOK Then
            '保存
            Call cmdSave_Click
        End If
    End If
    Unload Me
End Sub

Private Sub cmdSave_Click()
    Dim intCount As Integer
    Dim sMeg As String
    Dim MsgText As String
    
  
    For intCount = 0 To 6
        If Trim(Combo1(intCount) & " ") = "" Then
            Select Case intCount
                Case 0
                    sMeg = "出发城市"
                Case 1
                    sMeg = "到达城市"
                Case 2

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -