frmdengji.frm

VB编程：简单酒店管理系统（SQL版）VB编程：简单酒店管理系统（SQL版）

VERSION 5.00
Begin VB.Form frmdengji 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "客户登记"
   ClientHeight    =   5520
   ClientLeft      =   2505
   ClientTop       =   3465
   ClientWidth     =   7785
   Icon            =   "frmdengji.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   5520
   ScaleWidth      =   7785
   Begin VB.TextBox txtbianhao 
      Height          =   390
      Left            =   6000
      TabIndex        =   20
      Top             =   1560
      Width           =   1215
   End
   Begin VB.TextBox txtid 
      Height          =   375
      Left            =   6360
      TabIndex        =   18
      Top             =   120
      Width           =   855
   End
   Begin VB.CommandButton cmdquxiao 
      Caption         =   "取消"
      Height          =   375
      Left            =   6240
      TabIndex        =   16
      Top             =   3000
      Width           =   1095
   End
   Begin VB.CommandButton cmdbaocun 
      Caption         =   "保存"
      Height          =   375
      Left            =   4800
      TabIndex        =   15
      Top             =   3000
      Width           =   1095
   End
   Begin VB.TextBox txtruzhuriqi 
      Height          =   375
      Left            =   1440
      TabIndex        =   14
      Top             =   3000
      Width           =   3015
   End
   Begin VB.TextBox txtzhuzhi 
      Height          =   375
      Left            =   1440
      TabIndex        =   12
      Top             =   2280
      Width           =   5895
   End
   Begin VB.TextBox txtbeizhu 
      Height          =   1455
      Left            =   240
      TabIndex        =   11
      Text            =   "备注说明："
      Top             =   3840
      Width           =   7455
   End
   Begin VB.TextBox txtnianling 
      Height          =   375
      Left            =   5160
      TabIndex        =   10
      Top             =   840
      Width           =   2055
   End
   Begin VB.TextBox txtshenfenzhenghao 
      Height          =   375
      Left            =   1440
      TabIndex        =   9
      Top             =   840
      Width           =   2055
   End
   Begin VB.TextBox txtdanwei 
      Height          =   375
      Left            =   1440
      TabIndex        =   5
      Top             =   1560
      Width           =   3015
   End
   Begin VB.TextBox txtxingbie 
      Height          =   390
      Left            =   4680
      TabIndex        =   4
      Top             =   120
      Width           =   495
   End
   Begin VB.TextBox txtxingming 
      Height          =   375
      Left            =   1440
      TabIndex        =   1
      Top             =   120
      Width           =   1815
   End
   Begin VB.Label lblbianhao 
      Caption         =   "房间编号"
      Height          =   255
      Left            =   4800
      TabIndex        =   19
      Top             =   1680
      Width           =   855
   End
   Begin VB.Label lblid 
      Caption         =   "客户编号"
      Height          =   375
      Left            =   5400
      TabIndex        =   17
      Top             =   240
      Width           =   735
   End
   Begin VB.Label lblruzhuriqi 
      Caption         =   "入住日期"
      Height          =   375
      Left            =   240
      TabIndex        =   13
      Top             =   3120
      Width           =   975
   End
   Begin VB.Label lblnianling 
      Caption         =   "客户年龄"
      Height          =   375
      Left            =   3840
      TabIndex        =   8
      Top             =   960
      Width           =   975
   End
   Begin VB.Label lblshenfenzhenghao 
      Caption         =   "身份证号"
      Height          =   375
      Left            =   240
      TabIndex        =   7
      Top             =   960
      Width           =   975
   End
   Begin VB.Label lblzhuzhi 
      Caption         =   "客户住址"
      Height          =   375
      Left            =   240
      TabIndex        =   6
      Top             =   2400
      Width           =   975
   End
   Begin VB.Label lblxingbie 
      Caption         =   "客户性别"
      Height          =   375
      Left            =   3480
      TabIndex        =   3
      Top             =   240
      Width           =   975
   End
   Begin VB.Label lbldanwei 
      Caption         =   "客户单位"
      Height          =   375
      Left            =   240
      TabIndex        =   2
      Top             =   1680
      Width           =   975
   End
   Begin VB.Label lblxingming 
      Caption         =   "客户姓名"
      Height          =   375
      Left            =   240
      TabIndex        =   0
      Top             =   240
      Width           =   975
   End
End
Attribute VB_Name = "frmdengji"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub cmdbaocun_Click()
    Dim str As String
    If txtxingming.Text = Empty Then
        MsgBox "你的输入无效请重新输入"
    Else
        str = "select * from kehudengji"
        If querydata(str) = True Then
            rct.AddNew
            rct.Fields("kehuID").Value = Val(txtid.Text)
            rct.Fields("kehuname").Value = txtxingming.Text
            rct.Fields("kehudanwei").Value = txtdanwei.Text
            rct.Fields("kehunianling").Value = Val(txtnianling.Text)
            rct.Fields("kehuxingbie").Value = txtxingbie.Text
            rct.Fields("kehuzhuzhi").Value = txtzhuzhi.Text
            rct.Fields("shenfenzhenghao").Value = Val(txtshenfenzhenghao.Text)
            rct.Fields("beizhu").Value = txtbeizhu.Text
            rct.Fields("ruzhuriqi").Value = txtruzhuriqi.Text
            rct.Fields("fangjianbianhao").Value = Val(txtbianhao.Text)
            rct.Update
        Else
            MsgBox "提出数据失败!"
        End If
    
        str = "select * from fangjianbiao where fangjianbianhao=" & txtbianhao.Text
        If querydata(str) = True Then
            rct.MoveFirst
            rct.Fields("fangjianzhuangtai").Value = 1
            rct.Update
        Else
            MsgBox "没有此房间!"
        End If
    End If
    txtxingming.Text = ""
    txtxingbie.Text = ""
    txtid.Text = ""
    txtshenfenzhenghao.Text = ""
    txtnianling.Text = ""
    txtdanwei.Text = ""
    txtbianhao.Text = ""
    txtzhuzhi.Text = ""
    txtruzhuriqi.Text = ""
    txtbeizhu.Text = "备注说明："
End Sub

Private Sub cmdquxiao_Click()
    Unload Me
End Sub