www.pudn.com > jiudianguanli.rar > frmfangjianzhuangtai.frm

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