frmfangjianzhuangtai.frm

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

VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form frmfangjianzhuangtai 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "房间状态"
   ClientHeight    =   7290
   ClientLeft      =   2100
   ClientTop       =   3060
   ClientWidth     =   11205
   Icon            =   "frmfangjianzhuangtai.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   7290
   ScaleWidth      =   11205
   Begin VB.TextBox Text1 
      Height          =   375
      Left            =   9840
      TabIndex        =   3
      Top             =   720
      Width           =   1215
   End
   Begin VB.CommandButton Command2 
      Caption         =   "退出"
      Height          =   375
      Left            =   10080
      TabIndex        =   2
      Top             =   6360
      Width           =   735
   End
   Begin VB.CommandButton Command1 
      Caption         =   "清洁房间"
      Height          =   375
      Index           =   0
      Left            =   9840
      TabIndex        =   1
      Top             =   120
      Width           =   1215
   End
   Begin MSFlexGridLib.MSFlexGrid flxzhuangtai 
      Height          =   6735
      Left            =   120
      TabIndex        =   0
      Top             =   120
      Width           =   9615
      _ExtentX        =   16960
      _ExtentY        =   11880
      _Version        =   393216
      RowHeightMin    =   500
      BackColor       =   255
   End
End
Attribute VB_Name = "frmfangjianzhuangtai"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click(Index As Integer)
     On Error Resume Next
        If MsgBox("数据更改后将不能恢复，确认要更改当前数据吗？", vbQuestion + vbYesNo, "更改数据") = vbNo Then Exit Sub
        'rct.MoveFirst
        'rct.Filter = "guanliyuan = '" & txtguanliyuanid.Text & "'"
    Dim sqlstr As String
    sqlstr = "select * from fangjianbiao where fangjianbianhao='" & Text1.Text & "'"
    If querydata(sqlstr) = False Then Exit Sub
        rct.MoveFirst
        rct.Fields("fangjianzhuangtai").Value = 0
        If rct.EOF Then
            rct.MoveFirst
        Else
            rct.MoveNext
        End If
        flxzhuangtai.Rows = 1
    flxzhuangtai.Cols = 2
    flxzhuangtai.Row = 0
    flxzhuangtai.Col = 1
    flxzhuangtai.Text = "房间编号"
    
    Set rct = New ADODB.Recordset
    rct.Open "select * from fangjianbiao", con, adOpenDynamic, adLockOptimistic, -1
    
    While Not rct.EOF
        flxzhuangtai.AddItem (Empty)
        flxzhuangtai.Row = flxzhuangtai.Rows - 1
        flxzhuangtai.Text = rct!fangjianbianhao
        If rct!fangjianzhuangtai = 0 Then
            flxzhuangtai.CellBackColor = &HFF00&
        Else
            flxzhuangtai.CellBackColor = &HFF&
        End If
        rct.MoveNext
    Wend
    Text1.Text = ""
End Sub

Private Sub Command2_Click()
    Unload Me
End Sub

Private Sub Form_Load()
    flxzhuangtai.Rows = 1
    flxzhuangtai.Cols = 2
    flxzhuangtai.Row = 0
    flxzhuangtai.Col = 1
    flxzhuangtai.Text = "房间编号"
    
    Set rct = New ADODB.Recordset
    rct.Open "select * from fangjianbiao", con, adOpenDynamic, adLockOptimistic, -1
    
    While Not rct.EOF
        flxzhuangtai.AddItem (Empty)
        flxzhuangtai.Row = flxzhuangtai.Rows - 1
        flxzhuangtai.Text = rct!fangjianbianhao
        If rct!fangjianzhuangtai = 0 Then
            flxzhuangtai.CellBackColor = &HFF00&
        Else
            flxzhuangtai.CellBackColor = &HFF&
        End If
        rct.MoveNext
    Wend
End Sub