📄 frmxskh.frm
字号:
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 195
Index = 7
Left = 270
TabIndex = 12
Top = 3872
Width = 945
End
Begin VB.Label Label
Caption = "联系人:"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 195
Index = 8
Left = 450
TabIndex = 11
Top = 4380
Width = 765
End
End
Begin VSFlex7Ctl.VSFlexGrid Flex
Height = 6135
Index = 0
Left = 60
TabIndex = 20
Top = 120
Width = 2775
_cx = 4895
_cy = 10821
_ConvInfo = 1
Appearance = 1
BorderStyle = 1
Enabled = -1 'True
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
MousePointer = 0
BackColor = -2147483643
ForeColor = -2147483640
BackColorFixed = -2147483633
ForeColorFixed = -2147483630
BackColorSel = -2147483635
ForeColorSel = -2147483634
BackColorBkg = -2147483636
BackColorAlternate= -2147483643
GridColor = -2147483633
GridColorFixed = -2147483632
TreeColor = -2147483632
FloodColor = 192
SheetBorder = -2147483642
FocusRect = 1
HighLight = 1
AllowSelection = -1 'True
AllowBigSelection= -1 'True
AllowUserResizing= 1
SelectionMode = 1
GridLines = 1
GridLinesFixed = 2
GridLineWidth = 1
Rows = 2
Cols = 3
FixedRows = 1
FixedCols = 1
RowHeightMin = 0
RowHeightMax = 0
ColWidthMin = 0
ColWidthMax = 0
ExtendLastCol = 0 'False
FormatString = "|<客户编码|<客户名称"
ScrollTrack = 0 'False
ScrollBars = 3
ScrollTips = 0 'False
MergeCells = 0
MergeCompare = 0
AutoResize = -1 'True
AutoSizeMode = 0
AutoSearch = 0
AutoSearchDelay = 2
MultiTotals = -1 'True
SubtotalPosition= 1
OutlineBar = 0
OutlineCol = 0
Ellipsis = 0
ExplorerBar = 0
PicturesOver = 0 'False
FillStyle = 0
RightToLeft = 0 'False
PictureType = 0
TabBehavior = 0
OwnerDraw = 0
Editable = 0
ShowComboButton = -1 'True
WordWrap = 0 'False
TextStyle = 0
TextStyleFixed = 0
OleDragMode = 0
OleDropMode = 0
DataMode = 0
VirtualData = -1 'True
DataMember = ""
ComboSearch = 3
AutoSizeMouse = -1 'True
FrozenRows = 0
FrozenCols = 0
AllowUserFreezing= 0
BackColorFrozen = 0
ForeColorFrozen = 0
WallPaperAlignment= 9
End
End
Attribute VB_Name = "frmXsKh"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'QQ:75347626
'MSN:whailin2000@hotmail.com
Option Explicit
Const FlexKh = 0
Const TxtKhCode = 0
Const TxtKhMc = 1
Const TxtKhTel = 2
Const TxtKhFax = 3
Const TxtKhEmail = 4
Const TxtKhWww = 5
Const TxtKhAdd = 6
Const TxtKhPCode = 7
Const TxtKhLinkMan = 8
Const ChkKhIsStop = 0
Const CmdAdd = 0
Const CmdDel = 2
Const CmdSave = 3
Dim OKh As Kh
Dim OKhs As Khs
Private Sub Command_Click(Index As Integer)
On Error GoTo Errorhandle
Select Case Index
Case CmdAdd
AddRecord
Case CmdDel
Delrecord
Case CmdSave
SaveRecord
End Select
Exit Sub
Errorhandle:
MsgBox Err.Description
End Sub
Private Sub Form_Load()
On Error GoTo Errorhandle
LoadDataIntoGrid
Exit Sub
Errorhandle:
MsgBox Err.Description
End Sub
Private Sub LoadDataIntoGrid()
Dim ItemStr As String
Dim mKh As Kh
On Error GoTo Errorhandle
Flex(FlexKh).Rows = 1
Set OKhs = New Khs
OKhs.Fillbydb "KHTYPE=1"
For Each mKh In OKhs
ItemStr = vbTab & mKh.KhCode & vbTab & mKh.KhMc
Flex(FlexKh).AddItem ItemStr
Flex(FlexKh).RowData(Flex(FlexKh).Rows - 1) = mKh.KhKey
Next
If Flex(FlexKh).Rows > 1 Then
Flex(FlexKh).Row = 1
Set OKh = OKhs(CStr(Flex(FlexKh).RowData(1)))
SetValueToControl
Else
Set OKh = Nothing
Clearcontrol
End If
Exit Sub
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub AddRecord()
On Error GoTo Errorhandle
Set OKh = New Kh
Clearcontrol
Text(TxtKhCode).SetFocus
Exit Sub
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub Clearcontrol()
On Error GoTo Errorhandle
Text(TxtKhCode).Text = ""
Text(TxtKhMc).Text = ""
Text(TxtKhTel).Text = ""
Text(TxtKhFax).Text = ""
Text(TxtKhEmail).Text = ""
Text(TxtKhWww).Text = ""
Text(TxtKhAdd).Text = ""
Text(TxtKhPCode).Text = ""
Text(TxtKhLinkMan).Text = ""
Check(ChkKhIsStop).Value = vbUnchecked
Exit Sub
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub SaveRecord()
On Error GoTo Errorhandle
SetValueToObject
If OKh.KhId = -1 Then
OKhs.Add OKh
ChgGrid "ADD"
Else
OKh.Save
ChgGrid "CHG"
End If
Exit Sub
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub SetValueToObject()
On Error GoTo Errorhandle
OKh.KhType = 1
OKh.KhCode = Trim(Text(TxtKhCode).Text)
OKh.KhMc = Trim(Text(TxtKhMc).Text)
OKh.KhTel = Trim(Text(TxtKhTel).Text)
OKh.KhFax = Trim(Text(TxtKhFax).Text)
OKh.KhEmail = Trim(Text(TxtKhEmail).Text)
OKh.KhWww = Trim(Text(TxtKhWww).Text)
OKh.KhAdd = Trim(Text(TxtKhAdd).Text)
OKh.KhPCode = Trim(Text(TxtKhPCode).Text)
OKh.KhLinkMan = Trim(Text(TxtKhLinkMan).Text)
OKh.KhIsStop = Check(ChkKhIsStop)
Exit Sub
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub ChgGrid(RecordName As String)
Dim ItemStr As String
On Error GoTo Errorhandle
If RecordName = "ADD" Then
ItemStr = vbTab & OKh.KhCode & vbTab & OKh.KhMc
Flex(FlexKh).AddItem ItemStr
Flex(FlexKh).RowData(Flex(FlexKh).Rows - 1) = OKh.KhKey
Flex(FlexKh).Row = Flex(FlexKh).Rows - 1
Else
Flex(FlexKh).TextMatrix(Flex(FlexKh).Row, 1) = Text(TxtKhCode).Text
Flex(FlexKh).TextMatrix(Flex(FlexKh).Row, 2) = Text(TxtKhMc).Text
End If
Exit Sub
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub Delrecord()
On Error GoTo Errorhandle
If Flex(FlexKh).Rows = 1 Then
Exit Sub
End If
If MsgBox("您真的要删除吗？", vbYesNo) = vbYes Then
OKhs.Remove CStr(OKh.KhKey)
Flex(FlexKh).RemoveItem Flex(FlexKh).Row
If Flex(FlexKh).Rows = 1 Then
Set OKh = Nothing
Clearcontrol
Else
Set OKh = OKhs(CStr(Flex(FlexKh).RowData(Flex(FlexKh).Row)))
SetValueToControl
End If
End If
Exit Sub
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub Flex_RowColChange(Index As Integer)
On Error GoTo Errorhandle
If Flex(FlexKh).Rows >= 1 Then
Set OKh = OKhs(CStr(Flex(FlexKh).RowData(Flex(FlexKh).Row)))
SetValueToControl
Else
Set OKh = Nothing
Clearcontrol
End If
Exit Sub
Errorhandle:
MsgBox Err.Description
End Sub
Private Sub SetValueToControl()
On Error GoTo Errorhandle
Text(TxtKhCode).Text = OKh.KhCode
Text(TxtKhMc).Text = OKh.KhMc
Text(TxtKhTel).Text = OKh.KhTel
Text(TxtKhFax).Text = OKh.KhFax
Text(TxtKhEmail).Text = OKh.KhEmail
Text(TxtKhWww).Text = OKh.KhWww
Text(TxtKhAdd).Text = OKh.KhAdd
Text(TxtKhPCode).Text = OKh.KhPCode
Text(TxtKhLinkMan).Text = OKh.KhLinkMan
Check(ChkKhIsStop).Value = OKh.KhIsStop
Exit Sub
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub Form_Unload(Cancel As Integer)
On Error GoTo Errorhandle
Set OKh = Nothing
Set OKhs = Nothing
Exit Sub
Errorhandle:
MsgBox Err.Description
End Sub
Private Sub Form_Resize()
On Error GoTo Errorhandle
Resize_ALL Me
Exit Sub
Errorhandle:
MsgBox Err.Description
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -