frmstopclient.frm

Billing Internet Cafe

VERSION 5.00
Begin VB.Form FrmStopClient 
   BackColor       =   &H00FFFFFF&
   BorderStyle     =   1  'Fixed Single
   Caption         =   " Stop Client"
   ClientHeight    =   2505
   ClientLeft      =   45
   ClientTop       =   390
   ClientWidth     =   3945
   Icon            =   "FrmStopClient.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2505
   ScaleWidth      =   3945
   StartUpPosition =   2  'CenterScreen
   Begin VB.CommandButton CmdStop 
      Caption         =   "Stop"
      Height          =   375
      Left            =   1200
      TabIndex        =   1
      Top             =   1800
      Width           =   1095
   End
   Begin VB.CommandButton CmdBatal 
      Caption         =   "Batal"
      Height          =   375
      Left            =   2520
      TabIndex        =   2
      Top             =   1800
      Width           =   1095
   End
   Begin VB.TextBox TxtNo_Client 
      Height          =   375
      Left            =   2520
      TabIndex        =   0
      Top             =   1080
      Width           =   1095
   End
   Begin VB.Line Line1 
      X1              =   960
      X2              =   3600
      Y1              =   1680
      Y2              =   1680
   End
   Begin VB.Label Label1 
      BackStyle       =   0  'Transparent
      Caption         =   "Nomor Client"
      BeginProperty Font 
         Name            =   "Arial"
         Size            =   8.25
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00B54524&
      Height          =   255
      Left            =   1200
      TabIndex        =   4
      Top             =   1080
      Width           =   1335
   End
   Begin VB.Label Label25 
      Alignment       =   2  'Center
      BackStyle       =   0  'Transparent
      Caption         =   "Stop Client"
      BeginProperty Font 
         Name            =   "Arial"
         Size            =   8.25
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H0000FFFF&
      Height          =   255
      Left            =   1200
      TabIndex        =   3
      Top             =   240
      Width           =   2655
   End
   Begin VB.Image Image1 
      Height          =   690
      Left            =   120
      Picture         =   "FrmStopClient.frx":B532
      Top             =   0
      Width           =   3750
   End
   Begin VB.Shape Shape1 
      BackColor       =   &H00FFFFC0&
      BorderColor     =   &H00E0E0E0&
      BorderWidth     =   2
      FillColor       =   &H00FFFFC0&
      FillStyle       =   0  'Solid
      Height          =   1695
      Left            =   120
      Top             =   720
      Width           =   3735
   End
End
Attribute VB_Name = "FrmStopClient"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub CmdBatal_Click()
    Unload Me
End Sub

Private Sub CmdStop_Click()
On Error Resume Next
    If FrmMain.GridBilling.TextMatrix(Val(TxtNo_Client.Text), 3) = setAktif Then
        cn.Open
        cmd.ActiveConnection = cn
        cmd.CommandType = adCmdText
        cmd.CommandText = "SELECT ip.*,socket.socket FROM ip,socket WHERE ip.ip = socket.ip AND ip.no_client = " & Val(TxtNo_Client.Text)
        cmd.Execute
        rs.ActiveConnection = cn
        rs.Open "SELECT ip.*,socket.socket FROM ip,socket WHERE ip.ip = socket.ip AND ip.no_client = " & Val(TxtNo_Client.Text), cn, adOpenStatic, adLockOptimistic
        If Not rs.RecordCount = 0 Then
            If FrmMain.Winsock(rs(2)).State = sckConnected Then
                FrmMain.Winsock(rs(2)).SendData "stop|_|_|_|_|_|_|"
            Else
            FrmMain.GridBilling.Col = 1
                FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
                FrmMain.GridBilling.CellBackColor = &HFF80FF
            FrmMain.GridBilling.Col = 2
                FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
                FrmMain.GridBilling.CellBackColor = &HFF80FF
                FrmMain.GridBilling.Col = 3
                FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
                FrmMain.GridBilling.CellBackColor = &HFF80FF
                FrmMain.GridBilling.Col = 4
                FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
                FrmMain.GridBilling.CellBackColor = &HFF80FF
                FrmMain.GridBilling.Col = 5
                FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
                FrmMain.GridBilling.CellBackColor = &HFF80FF
                FrmMain.GridBilling.Col = 6
                FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
                FrmMain.GridBilling.CellBackColor = &HFF80FF
                FrmMain.GridBilling.Col = 7
                FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
                FrmMain.GridBilling.CellBackColor = &HFF80FF
                FrmMain.GridBilling.Col = 8
                FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
                FrmMain.GridBilling.CellBackColor = &HFF80FF
                FrmMain.GridBilling.Col = 9
                FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
                FrmMain.GridBilling.CellBackColor = &HFF80FF
                FrmMain.GridBilling.TextMatrix(Val(TxtNo_Client.Text), 3) = "stop"
            End If
        Else
        FrmMain.GridBilling.Col = 1
            FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
            FrmMain.GridBilling.CellBackColor = &HFF80FF
            FrmMain.GridBilling.Col = 2
            FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
            FrmMain.GridBilling.CellBackColor = &HFF80FF
            FrmMain.GridBilling.Col = 3
            FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
            FrmMain.GridBilling.CellBackColor = &HFF80FF
            FrmMain.GridBilling.Col = 4
            FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
            FrmMain.GridBilling.CellBackColor = &HFF80FF
            FrmMain.GridBilling.Col = 5
            FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
            FrmMain.GridBilling.CellBackColor = &HFF80FF
            FrmMain.GridBilling.Col = 6
            FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
            FrmMain.GridBilling.CellBackColor = &HFF80FF
            FrmMain.GridBilling.Col = 7
            FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
            FrmMain.GridBilling.CellBackColor = &HFF80FF
            FrmMain.GridBilling.Col = 8
            FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
            FrmMain.GridBilling.CellBackColor = &HFF80FF
            FrmMain.GridBilling.Col = 9
            FrmMain.GridBilling.Row = Val(TxtNo_Client.Text)
            FrmMain.GridBilling.CellBackColor = &HFF80FF
            FrmMain.GridBilling.TextMatrix(Val(TxtNo_Client.Text), 3) = "stop"
        End If
        cn.Close
    End If
    Unload Me
End Sub

Private Sub TxtNo_Client_KeyPress(KeyAscii As Integer)
On Error Resume Next
    If Not ((KeyAscii >= Asc("0") And KeyAscii <= Asc("9")) Or KeyAscii = 13 Or KeyAscii = 8) Then
        KeyAscii = 0
    End If
    If KeyAscii = 13 Then
        CmdStop.SetFocus
    End If
End Sub