📄 frmpindahclient.frm

📁 Billing Internet Cafe
💻 FRM
字号:
VERSION 5.00
Begin VB.Form FrmPindahClient 
   BackColor       =   &H00FFFFFF&
   BorderStyle     =   1  'Fixed Single
   Caption         =   "Pindah Client"
   ClientHeight    =   2535
   ClientLeft      =   45
   ClientTop       =   390
   ClientWidth     =   3945
   Icon            =   "FrmPindahClient.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2535
   ScaleWidth      =   3945
   StartUpPosition =   2  'CenterScreen
   Begin VB.CommandButton CmdBatal 
      Caption         =   "Batal"
      Height          =   495
      Left            =   2640
      TabIndex        =   3
      Top             =   1680
      Width           =   1095
   End
   Begin VB.CommandButton CmdPindah 
      Caption         =   "Pindahkan"
      Height          =   495
      Left            =   1320
      TabIndex        =   2
      Top             =   1680
      Width           =   1095
   End
   Begin VB.TextBox TxtNoDari 
      BackColor       =   &H00FFFFFF&
      BeginProperty Font 
         Name            =   "Arial"
         Size            =   8.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00B54524&
      Height          =   375
      Left            =   1320
      TabIndex        =   0
      Top             =   960
      Width           =   735
   End
   Begin VB.TextBox TxtNoKe 
      BackColor       =   &H00FFFFFF&
      BeginProperty Font 
         Name            =   "Arial"
         Size            =   8.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00B54524&
      Height          =   375
      Left            =   3000
      TabIndex        =   1
      Top             =   960
      Width           =   735
   End
   Begin VB.Label Label1 
      BackStyle       =   0  'Transparent
      Caption         =   "Dari Client"
      BeginProperty Font 
         Name            =   "Arial"
         Size            =   8.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00B54524&
      Height          =   255
      Left            =   360
      TabIndex        =   6
      Top             =   960
      Width           =   1335
   End
   Begin VB.Label Label2 
      BackStyle       =   0  'Transparent
      Caption         =   "Ke Client"
      BeginProperty Font 
         Name            =   "Arial"
         Size            =   8.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00B54524&
      Height          =   255
      Left            =   2160
      TabIndex        =   5
      Top             =   960
      Width           =   1095
   End
   Begin VB.Line Line1 
      X1              =   240
      X2              =   3720
      Y1              =   1560
      Y2              =   1560
   End
   Begin VB.Label Label25 
      Alignment       =   2  'Center
      BackStyle       =   0  'Transparent
      Caption         =   "Pindah 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        =   4
      Top             =   240
      Width           =   2655
   End
   Begin VB.Image Image1 
      Height          =   690
      Left            =   120
      Picture         =   "FrmPindahClient.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 = "FrmPindahClient"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public sockdari As Long
Public sockke As Long
Public mulai_dari As Date
Public jenis_dari As String
Public user_dari As String
Private Sub CmdBatal_Click()
    Unload Me
End Sub

Private Sub CmdPindah_Click()
On Error Resume Next
    If FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 3) = setAktif And FrmMain.GridBilling.TextMatrix(Val(TxtNoKe.Text), 3) = setBebas Then
        'cek open sock client dipindah
        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(TxtNoDari.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(TxtNoDari.Text), cn, adOpenStatic, adLockOptimistic
        If Not rs.RecordCount = 0 Then
            sockdari = rs(2)
        Else
            sockdari = 999
        End If
        cn.Close
        'cek open sock client kepindah
        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(TxtNoKe.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(TxtNoKe.Text), cn, adOpenStatic, adLockOptimistic
        If Not rs.RecordCount = 0 Then
            sockke = rs(2)
        Else
            sockke = 999
        End If
        cn.Close
        'ambil mulai dan jenis
        cn.Open
        cmd.ActiveConnection = cn
        cmd.CommandType = adCmdText
        cmd.CommandText = "SELECT proses.* FROM proses WHERE proses.no_client = " & Val(TxtNoDari.Text)
        cmd.Execute
        rs.ActiveConnection = cn
        rs.Open "SELECT proses.* FROM proses WHERE proses.no_client = " & Val(TxtNoDari.Text), cn, adOpenStatic, adLockOptimistic
        'buat terpindah jadi bebas
        If Not rs.RecordCount = 0 Then
            mulai_dari = rs(4)
            jenis_dari = rs(2)
            user_dari = rs(3)
            rs(1) = "bebas"
            rs.Update
        End If
        cn.Close
        'tulis proses dalam db
        cn.Open
        cmd.ActiveConnection = cn
        cmd.CommandType = adCmdText
        cmd.CommandText = "SELECT proses.* FROM proses WHERE proses.no_client = " & Val(TxtNoKe.Text)
        cmd.Execute
        rs.ActiveConnection = cn
        rs.Open "SELECT proses.* FROM proses WHERE proses.no_client = " & Val(TxtNoKe.Text), cn, adOpenStatic, adLockOptimistic
        If Not rs.RecordCount = 0 Then
            rs(0) = Val(TxtNoKe.Text)
            rs(4) = mulai_dari
            rs(2) = jenis_dari
            rs(3) = user_dari
            rs(1) = "aktif"
            rs.Update
        Else
            rs.AddNew
            rs(0) = Val(TxtNoKe.Text)
            rs(4) = mulai_dari
            rs(2) = jenis_dari
            rs(3) = user_dari
            rs(1) = "aktif"
            rs.Update
        End If
        cn.Close
        'ubah grid pindahdari
        FrmMain.GridBilling.TextMatrix(Val(TxtNoKe.Text), 2) = FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 2)
        FrmMain.GridBilling.Col = 1
        FrmMain.GridBilling.Row = Val(TxtNoKe)
        FrmMain.GridBilling.CellBackColor = &HFFFF00
        FrmMain.GridBilling.Col = 2
        FrmMain.GridBilling.Row = Val(TxtNoKe)
        FrmMain.GridBilling.CellBackColor = &HFFFF00
        FrmMain.GridBilling.Col = 3
        FrmMain.GridBilling.Row = Val(TxtNoKe)
        FrmMain.GridBilling.CellBackColor = &HFFFF00
        FrmMain.GridBilling.Col = 4
        FrmMain.GridBilling.Row = Val(TxtNoKe)
        FrmMain.GridBilling.CellBackColor = &HFFFF00
        FrmMain.GridBilling.Col = 5
        FrmMain.GridBilling.Row = Val(TxtNoKe)
        FrmMain.GridBilling.CellBackColor = &HFFFF00
        FrmMain.GridBilling.Col = 6
        FrmMain.GridBilling.Row = Val(TxtNoKe)
        FrmMain.GridBilling.CellBackColor = &HFFFF00
        FrmMain.GridBilling.Col = 7
        FrmMain.GridBilling.Row = Val(TxtNoKe)
        FrmMain.GridBilling.CellBackColor = &HFFFF00
        FrmMain.GridBilling.Col = 8
        FrmMain.GridBilling.Row = Val(TxtNoKe)
        FrmMain.GridBilling.CellBackColor = &HFFFF00
        FrmMain.GridBilling.Col = 9
        FrmMain.GridBilling.Row = Val(TxtNoKe)
        FrmMain.GridBilling.CellBackColor = &HFFFF00
        FrmMain.GridBilling.TextMatrix(Val(TxtNoKe.Text), 3) = "pindah"
        FrmMain.GridBilling.TextMatrix(Val(TxtNoKe.Text), 4) = FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 4)
        FrmMain.GridBilling.TextMatrix(Val(TxtNoKe.Text), 5) = FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 5)
        FrmMain.GridBilling.TextMatrix(Val(TxtNoKe.Text), 6) = FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 6)
        FrmMain.GridBilling.TextMatrix(Val(TxtNoKe.Text), 7) = FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 7)
        FrmMain.GridBilling.TextMatrix(Val(TxtNoKe.Text), 8) = FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 8)
        FrmMain.GridBilling.TextMatrix(Val(TxtNoKe.Text), 9) = FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 9)
        'ubah grid pindahke
        FrmMain.GridBilling.Col = 1
        FrmMain.GridBilling.Row = Val(TxtNoDari)
        FrmMain.GridBilling.CellBackColor = &H8080FF
        FrmMain.GridBilling.Col = 2
        FrmMain.GridBilling.Row = Val(TxtNoDari)
        FrmMain.GridBilling.CellBackColor = &H8080FF
        FrmMain.GridBilling.Col = 3
        FrmMain.GridBilling.Row = Val(TxtNoDari)
        FrmMain.GridBilling.CellBackColor = &H8080FF
        FrmMain.GridBilling.Col = 4
        FrmMain.GridBilling.Row = Val(TxtNoDari)
        FrmMain.GridBilling.CellBackColor = &H8080FF
        FrmMain.GridBilling.Col = 5
        FrmMain.GridBilling.Row = Val(TxtNoDari)
        FrmMain.GridBilling.CellBackColor = &H8080FF
        FrmMain.GridBilling.Col = 6
        FrmMain.GridBilling.Row = Val(TxtNoDari)
        FrmMain.GridBilling.CellBackColor = &H8080FF
        FrmMain.GridBilling.Col = 7
        FrmMain.GridBilling.Row = Val(TxtNoDari)
        FrmMain.GridBilling.CellBackColor = &H8080FF
        FrmMain.GridBilling.Col = 8
        FrmMain.GridBilling.Row = Val(TxtNoDari)
        FrmMain.GridBilling.CellBackColor = &H8080FF
        FrmMain.GridBilling.Col = 9
        FrmMain.GridBilling.Row = Val(TxtNoDari)
        FrmMain.GridBilling.CellBackColor = &H8080FF
        FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 3) = setBebas
        FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 2) = ""
        FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 4) = ""
        FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 5) = ""
        FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 6) = ""
        FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 7) = ""
        FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 8) = ""
        FrmMain.GridBilling.TextMatrix(Val(TxtNoDari.Text), 9) = ""
        If Not sockdari = 999 Then
            Call Menuju
        End If
        If Not sockke = 999 Then
            Call Tertuju
        End If
    End If
    Unload Me
End Sub
Private Sub Menuju()
On Error Resume Next
    If FrmMain.Winsock(sockdari).State = sckConnected Then
        FrmMain.Winsock(sockdari).SendData "pindahke|_|_|_|_|_|_|"
    End If
End Sub
Private Sub Tertuju()
On Error Resume Next
    If FrmMain.Winsock(sockke).State = sckConnected Then
        FrmMain.Winsock(sockke).SendData "pindahdari|" & mulai_dari & "|" & jenis_dari & "|_|_|_|_|"
        FrmMain.Winsock(sockke).Close
    End If
End Sub

Private Sub TxtNoDari_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 kwyascii = 13 Then
        TxtNoKe.SetFocus
    End If
End Sub

Private Sub TxtNoKe_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
End Sub
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -