frmtianjiafangjian.frm

适合毕业设计用

VERSION 5.00
Begin VB.Form frmtianjiafangjian 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "添加房间"
   ClientHeight    =   3975
   ClientLeft      =   4140
   ClientTop       =   3270
   ClientWidth     =   3735
   Icon            =   "frmtianjiafangjian.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3975
   ScaleWidth      =   3735
   Begin VB.CommandButton Command3 
      Caption         =   "退出"
      Height          =   495
      Left            =   2640
      TabIndex        =   10
      Top             =   3240
      Width           =   855
   End
   Begin VB.CommandButton Command2 
      Caption         =   "重置"
      Height          =   495
      Left            =   1440
      TabIndex        =   9
      Top             =   3240
      Width           =   855
   End
   Begin VB.CommandButton Command1 
      Caption         =   "保存"
      Height          =   495
      Left            =   240
      TabIndex        =   8
      Top             =   3240
      Width           =   855
   End
   Begin VB.TextBox Text4 
      Height          =   375
      Left            =   1920
      TabIndex        =   7
      Top             =   2400
      Width           =   1335
   End
   Begin VB.TextBox Text3 
      Height          =   375
      Left            =   1920
      TabIndex        =   6
      Top             =   1680
      Width           =   1335
   End
   Begin VB.TextBox Text2 
      Height          =   375
      Left            =   1920
      TabIndex        =   5
      Top             =   960
      Width           =   1335
   End
   Begin VB.TextBox Text1 
      Height          =   375
      Left            =   1920
      TabIndex        =   4
      Top             =   240
      Width           =   1335
   End
   Begin VB.Label lbl4 
      Caption         =   "房间价格"
      Height          =   255
      Left            =   360
      TabIndex        =   3
      Top             =   2400
      Width           =   975
   End
   Begin VB.Label lbl3 
      Caption         =   "房间种类"
      Height          =   255
      Left            =   360
      TabIndex        =   2
      Top             =   1680
      Width           =   975
   End
   Begin VB.Label lbl2 
      Caption         =   "房间状态"
      Height          =   255
      Left            =   360
      TabIndex        =   1
      Top             =   960
      Width           =   975
   End
   Begin VB.Label lbl1 
      Caption         =   "房间编号"
      Height          =   255
      Left            =   360
      TabIndex        =   0
      Top             =   240
      Width           =   975
   End
End
Attribute VB_Name = "frmtianjiafangjian"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Dim str As String
    If Text1.Text = Empty Then
        MsgBox "你的输入无效"
    Else
        str = "select * from fangjianbiao"
        If querydata(str) = True Then
            rct.AddNew
            rct.Fields("fangjianbianhao").Value = Val(Text1.Text)
            rct.Fields("fangjianzhuangtai").Value = Val(Text2.Text)
            rct.Fields("fangjianzhonglei").Value = Val(Text3.Text)
            rct.Fields("fangjianjiage").Value = Val(Text4.Text)
            rct.Update
        Else
            MsgBox "提出数据失败!"
        End If
    End If
    Text1.Text = ""
    Text2.Text = ""
    Text3.Text = ""
    Text4.Text = ""
End Sub

Private Sub Command2_Click()
    Text1.Text = ""
    Text2.Text = ""
    Text3.Text = ""
    Text4.Text = ""
End Sub

Private Sub Command3_Click()
    Unload Me
End Sub