frmstatus.frm

Billing Internet Cafe

VERSION 5.00
Object = "{6B7E6392-850A-101B-AFC0-4210102A8DA7}#1.3#0"; "COMCTL32.OCX"
Begin VB.Form FrmStatus 
   BackColor       =   &H00EFF2EC&
   BorderStyle     =   1  'Fixed Single
   Caption         =   "Status Koneksi Client"
   ClientHeight    =   7965
   ClientLeft      =   45
   ClientTop       =   465
   ClientWidth     =   7245
   Icon            =   "FrmStatus.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   7965
   ScaleWidth      =   7245
   StartUpPosition =   2  'CenterScreen
   Begin VB.CommandButton XPButton1 
      Caption         =   "Tutup"
      Height          =   615
      Left            =   120
      TabIndex        =   1
      Top             =   7080
      Width           =   6975
   End
   Begin ComctlLib.ListView ListStatus 
      Height          =   6615
      Left            =   120
      TabIndex        =   0
      Top             =   240
      Width           =   6975
      _ExtentX        =   12303
      _ExtentY        =   11668
      View            =   3
      LabelWrap       =   -1  'True
      HideSelection   =   -1  'True
      _Version        =   327682
      ForeColor       =   11879716
      BackColor       =   16777215
      BorderStyle     =   1
      Appearance      =   1
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "OCR A Extended"
         Size            =   8.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      NumItems        =   3
      BeginProperty ColumnHeader(1) {0713E8C7-850A-101B-AFC0-4210102A8DA7} 
         Key             =   ""
         Object.Tag             =   ""
         Text            =   "No."
         Object.Width           =   2540
      EndProperty
      BeginProperty ColumnHeader(2) {0713E8C7-850A-101B-AFC0-4210102A8DA7} 
         SubItemIndex    =   1
         Key             =   ""
         Object.Tag             =   ""
         Text            =   "No. Client"
         Object.Width           =   2540
      EndProperty
      BeginProperty ColumnHeader(3) {0713E8C7-850A-101B-AFC0-4210102A8DA7} 
         SubItemIndex    =   2
         Key             =   ""
         Object.Tag             =   ""
         Text            =   "Status"
         Object.Width           =   2540
      EndProperty
   End
End
Attribute VB_Name = "FrmStatus"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim Status(1 To ClientMax) As String
Private Sub InitStatus()
On Error Resume Next
    For i = 1 To ClientMax
        Call CekStatus(i)
        Set lstItem = ListStatus.ListItems.Add(, , i)
        lstItem.SubItems(1) = "WStation" & i
        lstItem.SubItems(2) = Status(i)
    Next i
End Sub

Private Sub CekStatus(ByVal No_Client As Integer)
On Error Resume Next
    sql = "SELECT ip.no_client,socket.ip FROM ip,socket WHERE ip.ip = socket.ip AND ip.no_client = " & No_Client
    cn.Open
    cmd.ActiveConnection = cn
    cmd.CommandType = adCmdText
    cmd.CommandText = sql
    cmd.Execute
    rs.ActiveConnection = cn
    rs.Open sql, cn, adOpenStatic, adLockOptimistic
    If rs.RecordCount > 0 Then
        Status(No_Client) = "Connected"
    Else
        Status(No_Client) = "Disconnected"
    End If
    cn.Close
End Sub

Private Sub Form_Load()
    Call AturList
    Call InitStatus
End Sub

Private Sub AturList()
    ListStatus.ColumnHeaders(1).Width = 500
    ListStatus.ColumnHeaders(2).Width = 1500
    ListStatus.ColumnHeaders(3).Width = 1500
End Sub

Private Sub XPButton1_Click()
Unload Me

End Sub