www.pudn.com > jiudianguanli.rar > 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