frm客户留言.frm

可以完成宾馆的日常管理功能,例如订房,登记,入住,结帐,和打印报表等

VERSION 5.00
Begin VB.Form frm客户留言 
   Caption         =   "客户留言"
   ClientHeight    =   4305
   ClientLeft      =   60
   ClientTop       =   465
   ClientWidth     =   7935
   Icon            =   "frm客户留言.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   ScaleHeight     =   4305
   ScaleWidth      =   7935
   StartUpPosition =   2  '屏幕中心
   Begin VB.Timer Timer1 
      Interval        =   100
      Left            =   7440
      Top             =   120
   End
   Begin VB.PictureBox Picture1 
      BackColor       =   &H80000013&
      Height          =   5655
      Left            =   0
      ScaleHeight     =   5595
      ScaleWidth      =   7875
      TabIndex        =   0
      Top             =   0
      Width           =   7935
      Begin VB.PictureBox Picture3 
         BackColor       =   &H80000013&
         Height          =   855
         Left            =   120
         ScaleHeight     =   795
         ScaleWidth      =   7635
         TabIndex        =   7
         Top             =   3360
         Width           =   7695
         Begin VB.CommandButton Command2 
            Height          =   495
            Left            =   6600
            Picture         =   "frm客户留言.frx":0E42
            Style           =   1  'Graphical
            TabIndex        =   11
            ToolTipText     =   "关闭窗口"
            Top             =   120
            Width           =   495
         End
         Begin VB.CommandButton Command1 
            BackColor       =   &H0000FFFF&
            Height          =   615
            Left            =   5160
            Picture         =   "frm客户留言.frx":1A84
            Style           =   1  'Graphical
            TabIndex        =   10
            Top             =   120
            Width           =   615
         End
         Begin VB.TextBox Text3 
            Height          =   375
            Left            =   1560
            TabIndex        =   9
            Top             =   240
            Width           =   1815
         End
         Begin VB.Label Label3 
            BackColor       =   &H80000013&
            Caption         =   "署名："
            BeginProperty Font 
               Name            =   "宋体"
               Size            =   10.5
               Charset         =   134
               Weight          =   400
               Underline       =   0   'False
               Italic          =   0   'False
               Strikethrough   =   0   'False
            EndProperty
            Height          =   375
            Left            =   840
            TabIndex        =   8
            Top             =   360
            Width           =   735
         End
      End
      Begin VB.PictureBox Picture2 
         BackColor       =   &H80000013&
         Height          =   2655
         Left            =   120
         ScaleHeight     =   2595
         ScaleWidth      =   7635
         TabIndex        =   4
         Top             =   600
         Width           =   7695
         Begin VB.Frame Frame1 
            BackColor       =   &H80000013&
            Caption         =   "留言"
            BeginProperty Font 
               Name            =   "宋体"
               Size            =   12
               Charset         =   134
               Weight          =   700
               Underline       =   0   'False
               Italic          =   0   'False
               Strikethrough   =   0   'False
            EndProperty
            Height          =   2535
            Left            =   120
            TabIndex        =   5
            Top             =   0
            Width           =   7455
            Begin VB.TextBox Text1 
               Height          =   1935
               Left            =   120
               MultiLine       =   -1  'True
               TabIndex        =   6
               Top             =   360
               Width           =   7215
            End
         End
      End
      Begin VB.TextBox Text2 
         BackColor       =   &H80000013&
         BorderStyle     =   0  'None
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   14.25
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   390
         Left            =   4320
         TabIndex        =   3
         Top             =   240
         Width           =   3375
      End
      Begin VB.Label Label2 
         BackColor       =   &H80000013&
         Caption         =   "现在时刻："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   255
         Left            =   3240
         TabIndex        =   2
         Top             =   240
         Width           =   1215
      End
      Begin VB.Label Label1 
         BackColor       =   &H80000013&
         Caption         =   "请留言："
         BeginProperty Font 
            Name            =   "隶书"
            Size            =   15.75
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H000000FF&
         Height          =   375
         Left            =   240
         TabIndex        =   1
         Top             =   240
         Width           =   1815
      End
   End
End
Attribute VB_Name = "frm客户留言"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.Open frm登录.Adodc1.ConnectionString
rs.Open "select * from 顾客留言表 ", cn, 1, 3
If Text1 = "" Then
   MsgBox "请留下您的建议！！！"
   Text1.SetFocus
ElseIf Text3 = "" Then
   MsgBox "请留下您的名字，谢谢！！！"
   Text3.SetFocus
Else
   rs.AddNew
   rs.Fields(1) = Text3
   rs.Fields(2) = Text2
   rs.Fields(3) = Text1
   rs.Update
   MsgBox "谢谢您的宝贵建议，我们一定改正。"
 
 Text1 = ""
 Text3 = ""
 End If
End Sub

Private Sub Command2_Click()
Me.Hide
End Sub

Private Sub Timer1_Timer()
Text2 = Format(Now, "yyyy-m-dd hh:mm:ss AM/PM")
Text2.Enabled = False
End Sub