areaaddedit.frm
来自「This application i made for handle simpl」· FRM 代码 · 共 318 行
FRM
318 行
VERSION 5.00
Object = "{D18BBD1F-82BB-4385-BED3-E9D31A3E361E}#1.0#0"; "KewlButtonz.ocx"
Begin VB.Form frmAreaAddEdit
BackColor = &H00FBF7F4&
BorderStyle = 1 'Fixed Single
Caption = "Area"
ClientHeight = 2850
ClientLeft = 45
ClientTop = 330
ClientWidth = 5025
BeginProperty Font
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Icon = "AreaAddEdit.frx":0000
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 190
ScaleMode = 3 'Pixel
ScaleWidth = 335
ShowInTaskbar = 0 'False
StartUpPosition = 2 'CenterScreen
Begin KewlButtonz.KewlButtons btnCancel
Height = 390
Left = 3525
TabIndex = 5
Top = 2100
Width = 1290
_ExtentX = 2275
_ExtentY = 688
BTYPE = 3
TX = "&Cancel"
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 15002603
BCOLO = 15002603
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "AreaAddEdit.frx":0EBA
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin KewlButtonz.KewlButtons btnSave
Height = 390
Left = 2175
TabIndex = 4
Top = 2100
Width = 1290
_ExtentX = 2275
_ExtentY = 688
BTYPE = 3
TX = "&Save"
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 15002603
BCOLO = 15002603
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "AreaAddEdit.frx":0ED6
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin VB.TextBox txtNama
Appearance = 0 'Flat
Height = 315
Left = 1425
MaxLength = 30
TabIndex = 3
Top = 1425
Width = 3390
End
Begin VB.TextBox txtKode
Appearance = 0 'Flat
Height = 315
Left = 1425
MaxLength = 3
TabIndex = 1
Top = 1050
Width = 915
End
Begin Irfan.IrfanHeader ihdForm
Align = 1 'Align Top
Height = 825
Left = 0
Top = 0
Width = 5025
_ExtentX = 8864
_ExtentY = 1455
Text = "Area"
End
Begin VB.Label lblForm
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "&Nama Area:"
Height = 195
Index = 1
Left = 225
TabIndex = 2
Top = 1470
Width = 1035
End
Begin VB.Label lblForm
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "&Kode:"
Height = 195
Index = 0
Left = 225
TabIndex = 0
Top = 1095
Width = 510
End
End
Attribute VB_Name = "frmAreaAddEdit"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private lx As MSComctlLib.ListItem
Private Sub btnCancel_Click()
Call Unload(Me)
End Sub
Private Sub btnSave_Click()
btnSave.Enabled = False
If (Not (ValidSave())) Then
btnSave.Enabled = True
Exit Sub
End If
If (frmArea.sMenu = SelectedSubMenu.Add) Then
If (ExistCode(Trim(txtKode.Text))) Then
Call Message(Replace(LoadResString(3), "@n", "Kode Area"))
btnSave.Enabled = True
Exit Sub
End If
Call SaveArea(False, Trim(txtKode.Text), Trim(txtNama.Text))
Else
Call SaveArea(True, Trim(txtKode.Text), Trim(txtNama.Text))
End If
btnSave.Enabled = True
Call Unload(Me)
End Sub
Private Sub Form_Load()
If (frmArea.sMenu = SelectedSubMenu.Add) Then
ihdForm.Text = "Add Area"
Else
ihdForm.Text = "Edit Area"
txtKode.Enabled = False
With frmArea.lvArea.SelectedItem
txtKode.Text = .Text
txtNama.Text = .ListSubItems(1).Text
End With
End If
End Sub
Private Sub txtKode_GotFocus()
Call TextFocus(txtKode, True, False)
End Sub
Private Sub txtNama_GotFocus()
Call TextFocus(txtNama, True, False)
End Sub
Private Function ValidSave() As Boolean
exString = ""
If (EmptyString(txtKode.Text)) Then
Call ErrorStringAdd("- Kode Area harus diisi.")
Else
If (Len(Trim(txtKode.Text)) < 3) Then
Call ErrorStringAdd("- Kode Area harus 3 karakter.")
End If
End If
If (EmptyString(txtNama.Text)) Then
Call ErrorStringAdd("- Nama Area harus diisi.")
End If
ValidSave = (ValidationString(exString))
End Function
Private Sub SaveArea(ByVal editQuery As Boolean, ByVal nKode As String, ByVal nNama As String)
On Error GoTo NoSave
comm.CommandText = "AreaQuery"
comm.CommandType = CommandTypeEnum.adCmdStoredProc
Call comm.Parameters.Append(comm.CreateParameter("@type", DataTypeEnum.adBoolean, , , editQuery))
Call comm.Parameters.Append(comm.CreateParameter("@code", DataTypeEnum.adChar, , 3, nKode))
Call comm.Parameters.Append(comm.CreateParameter("@name", DataTypeEnum.adVarChar, , 30, nNama))
Call conn.Open
comm.ActiveConnection = conn
Call comm.Execute
Call ClearParameter(comm)
Call conn.Close
If (editQuery) Then
With frmArea.lvArea.SelectedItem
.ListSubItems(1).Text = nNama
End With
Else
Set lx = frmArea.lvArea.ListItems.Add(, , nKode, , 1)
Call lx.ListSubItems.Add(, , nNama)
Call lx.EnsureVisible
lx.Selected = True
End If
Exit Sub
NoSave:
Call CloseConnection(Err)
End Sub
Private Function ExistCode(ByVal nCode As String)
On Error GoTo NoExist
Dim ec As Boolean
ec = True
comm.CommandText = "AreaCodeExist"
comm.CommandType = CommandTypeEnum.adCmdStoredProc
Call comm.Parameters.Append(comm.CreateParameter("@code", DataTypeEnum.adVarChar, , 3, nCode))
Call comm.Parameters.Append(comm.CreateParameter("@exist", DataTypeEnum.adBoolean, ParameterDirectionEnum.adParamOutput))
Call conn.Open
comm.ActiveConnection = conn
Call comm.Execute
ec = CBool(comm.Parameters(1).Value)
Call ClearParameter(comm)
Call conn.Close
ExistCode = (ec)
Exit Function
NoExist:
Call CloseConnection(Err)
ExistCode = (True)
End Function
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?