frmchkbbus.frm

一个功能比较完善的远程抄表软件

VERSION 5.00
Begin VB.Form frmChkBBus 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "楼内总线检查"
   ClientHeight    =   1470
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   3090
   ControlBox      =   0   'False
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   1470
   ScaleWidth      =   3090
   Begin VB.CommandButton cmdOK 
      Caption         =   "检查"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   240
      TabIndex        =   3
      Top             =   960
      Width           =   1215
   End
   Begin VB.CommandButton cmdCancle 
      Caption         =   "返回"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   1680
      TabIndex        =   2
      Top             =   960
      Width           =   1215
   End
   Begin VB.ComboBox cmbFrame 
      Height          =   300
      Left            =   1200
      Style           =   2  'Dropdown List
      TabIndex        =   1
      Top             =   120
      Width           =   1695
   End
   Begin VB.ComboBox cmbBuild 
      Height          =   300
      Left            =   1200
      Style           =   2  'Dropdown List
      TabIndex        =   0
      Top             =   480
      Width           =   1695
   End
   Begin VB.Label Label1 
      BackColor       =   &H80000004&
      BackStyle       =   0  'Transparent
      Caption         =   "楼号:"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   240
      TabIndex        =   5
      Top             =   480
      Width           =   615
   End
   Begin VB.Label Label2 
      Caption         =   "网段号:"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   9.75
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   240
      TabIndex        =   4
      Top             =   120
      Width           =   975
   End
End
Attribute VB_Name = "frmChkBBus"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'****************************************************************************
'人人为我，我为人人
'枕善居收藏整理
'发布日期：2007/07/09
'描    述：CBB三表户外计量系统 Ver 5.2
'网    站：http://www.Mndsoft.com/  (VB6源码博客)
'网    站：http://www.VbDnet.com/   (VB.NET源码博客,主要基于.NET2005)
'e-mail  ：[e-mail]
'e-mail  ：[e-mail]
'OICQ    ：88382850
'          如果您有新的好的代码别忘记给枕善居哦!
'****************************************************************************
Private Sub cmbFrame_Click()
Dim rcBuild As Recordset
Dim curFrame As Integer
    
    cmbBuild.Clear
    
    If Trim(cmbFrame.List(cmbFrame.ListIndex)) = "" Then
        Exit Sub
    End If
    
    curFrame = Val(Trim(cmbFrame.List(cmbFrame.ListIndex)))
    SQL = "select distinct BuildID from BuildMap "
    SQL = SQL + "where FrameID=" + Format(curFrame) + " "
    SQL = SQL + "order by BuildID ASC "
    Set rcBuild = dbCbb.OpenRecordset(SQL)
    Do While Not rcBuild.EOF
        cmbBuild.AddItem Trim(rcBuild!BuildID)
        rcBuild.MoveNext
    Loop
    
End Sub


Private Sub cmdCancle_Click()
    Unload frmChkBBus
End Sub

Private Sub cmdCancle_KeyPress(KeyAscii As Integer)
    If KeyAscii = 27 Then
        cmdCancle_Click
    End If

End Sub

Private Sub cmdOK_Click()
Dim chkBuild As String
    cmdOK.Enabled = False
    
    chkBuild = Trim(cmbBuild.List(cmbBuild.ListIndex))
    If chkBuild = "" Then
        Exit Sub
    End If
    CheckBuild (chkBuild)
'status
    AppendStatusInfo "检查" & chkBuild & "楼内总线", icoBLUE
    SaveLog "检查" & chkBuild & "楼内总线", 0
    cmdOK.Enabled = True
End Sub

Private Sub cmdOK_KeyPress(KeyAscii As Integer)
    If KeyAscii = 27 Then
        cmdCancle_Click
    End If

End Sub

Private Sub Form_Load()
    If UBound(curForm) > 0 Then
        curForm(UBound(curForm)).Enabled = False
    End If
    ReDim Preserve curForm(UBound(curForm) + 1)
    Set curForm(UBound(curForm)) = Me

    
Dim rcFrame As Recordset

    SQL = "select distinct FrameID from GateMap order by FrameID ASC "
    Set rcFrame = dbCbb.OpenRecordset(SQL)
    Do While Not rcFrame.EOF
        cmbFrame.AddItem Format(rcFrame!FrameID)
        rcFrame.MoveNext
    Loop

    DoEvents
End Sub

Private Sub Form_Unload(Cancel As Integer)
    ReDim Preserve curForm(UBound(curForm) - 1)
    If UBound(curForm) > 0 Then
        curForm(UBound(curForm)).Enabled = True
    End If
'    frmMain.Enabled = True
 '   frmMain.Show
End Sub

Private Sub txtBBusID_KeyPress(KeyAscii As Integer)
    If KeyAscii = &HD Then
        cmdOK_Click
    End If
    If KeyAscii = 27 Then
        cmdCancle_Click
    End If

End Sub