📄 frmconfig.frm
字号:
Top = 75
Width = 2940
Begin VB.CommandButton cmdAdd_k
Caption = "添加"
Enabled = 0 'False
Height = 375
Left = 1890
TabIndex = 30
Top = 2790
Width = 915
End
Begin VB.CommandButton cmdDelete_k
Caption = "删除"
Enabled = 0 'False
Height = 375
Left = 900
TabIndex = 29
Top = 2790
Width = 915
End
Begin VB.TextBox txtYb_k
Height = 330
Left = 900
TabIndex = 23
Top = 2295
Width = 1905
End
Begin VB.TextBox txtDz_k
Height = 330
Left = 900
TabIndex = 22
Top = 1305
Width = 1905
End
Begin VB.TextBox txtLxr_k
Height = 330
Left = 900
TabIndex = 21
Top = 810
Width = 1905
End
Begin VB.TextBox txtKhm
Height = 330
Left = 900
TabIndex = 20
Top = 315
Width = 1905
End
Begin VB.TextBox txtDh_k
Height = 330
Left = 900
TabIndex = 19
Top = 1800
Width = 1905
End
Begin VB.Label Label10
Alignment = 1 'Right Justify
Caption = "电话："
Height = 285
Left = 135
TabIndex = 28
Top = 1890
Width = 735
End
Begin VB.Label Label9
Alignment = 1 'Right Justify
Caption = "地址："
Height = 285
Left = 135
TabIndex = 27
Top = 1395
Width = 735
End
Begin VB.Label Label8
Alignment = 1 'Right Justify
Caption = "联系人："
Height = 285
Left = 135
TabIndex = 26
Top = 900
Width = 735
End
Begin VB.Label Label7
Alignment = 1 'Right Justify
Caption = "客户名："
Height = 285
Left = 135
TabIndex = 25
Top = 405
Width = 735
End
Begin VB.Label Label6
Alignment = 1 'Right Justify
Caption = "邮编："
Height = 285
Left = 135
TabIndex = 24
Top = 2385
Width = 735
End
End
Begin VB.Frame Frame3
Caption = "客户"
Height = 3435
Left = -74820
TabIndex = 3
Top = 75
Width = 3840
Begin MSComctlLib.ListView lvwKh
Height = 2985
Left = 135
TabIndex = 42
Top = 270
Width = 3435
_ExtentX = 6059
_ExtentY = 5265
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = -1 'True
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = -2147483643
Appearance = 1
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
NumItems = 0
End
End
Begin VB.Frame Frame2
Caption = "编辑"
Height = 3435
Left = -71130
TabIndex = 2
Top = 75
Width = 2940
Begin VB.CommandButton cmdDelete_g
Caption = "删除"
Enabled = 0 'False
Height = 375
Left = 900
TabIndex = 18
Top = 2790
Width = 915
End
Begin VB.CommandButton cmdAdd_g
Caption = "添加"
Enabled = 0 'False
Height = 375
Left = 1890
TabIndex = 17
Top = 2790
Width = 915
End
Begin VB.TextBox txtDh_g
Height = 330
Left = 900
TabIndex = 16
Top = 1800
Width = 1905
End
Begin VB.TextBox txtGys
Height = 330
Left = 900
TabIndex = 14
Top = 315
Width = 1905
End
Begin VB.TextBox txtLxr_g
Height = 330
Left = 900
TabIndex = 13
Top = 810
Width = 1905
End
Begin VB.TextBox txtDz_g
Height = 330
Left = 900
TabIndex = 12
Top = 1305
Width = 1905
End
Begin VB.TextBox txtYb_g
Height = 330
Left = 900
TabIndex = 11
Top = 2295
Width = 1905
End
Begin VB.Label Label4
Alignment = 1 'Right Justify
Caption = "邮编："
Height = 285
Left = 135
TabIndex = 15
Top = 2385
Width = 735
End
Begin VB.Label Label1
Alignment = 1 'Right Justify
Caption = "供应商："
Height = 285
Left = 135
TabIndex = 10
Top = 405
Width = 735
End
Begin VB.Label Label2
Alignment = 1 'Right Justify
Caption = "联系人："
Height = 285
Left = 135
TabIndex = 9
Top = 900
Width = 735
End
Begin VB.Label Label3
Alignment = 1 'Right Justify
Caption = "地址："
Height = 285
Left = 135
TabIndex = 8
Top = 1395
Width = 735
End
Begin VB.Label Label5
Alignment = 1 'Right Justify
Caption = "电话："
Height = 285
Left = 135
TabIndex = 7
Top = 1890
Width = 735
End
End
Begin VB.Frame Frame1
Caption = "供应商"
Height = 3435
Left = -74820
TabIndex = 1
Top = 75
Width = 3840
Begin MSComctlLib.ListView lvwGys
Height = 2985
Left = 135
TabIndex = 43
Top = 270
Width = 3435
_ExtentX = 6059
_ExtentY = 5265
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = -1 'True
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = -2147483643
Appearance = 1
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
NumItems = 0
End
End
End
Begin VB.Label lbl
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "[供应商]、[联系人] 必填"
ForeColor = &H000000FF&
Height = 240
Left = 4275
TabIndex = 46
Top = 180
Width = 2805
End
Begin VB.Label Label16
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "配置系统的数据字典"
BeginProperty Font
Name = "楷体_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000C0&
Height = 240
Left = 225
TabIndex = 45
Top = 135
Width = 2295
End
Begin VB.Label Label15
BackColor = &H00FFFFFF&
Height = 510
Left = 0
TabIndex = 44
Top = 0
Width = 7395
End
End
Attribute VB_Name = "frmConfig"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim intGysKey As Integer 'gyszd_key
'load供应商信息(table:gyszd)
Public Sub lvwGys_Fill()
Dim itmX 'As ListItem
lvwGys.ListItems.Clear
With rstMain
If .State = adStateOpen Then .Close
.Open "select * from gyszd"
If Not .BOF Then .MoveFirst
While Not .EOF
Set itmX = lvwGys.ListItems.Add(, "gyszd" & CStr(!gyszd_key), !gys & "")
itmX.SubItems(1) = !lxr & ""
itmX.SubItems(2) = !dh & ""
itmX.SubItems(3) = !dz & ""
itmX.SubItems(4) = !yb & ""
.MoveNext
Wend
.Close
End With
End Sub
'load客户信息(table:khzd)
Public Sub lvwKh_Fill()
Dim itmX 'As ListItem
lvwKh.ListItems.Clear
With rstMain
If .State = adStateOpen Then .Close
.Open "select * from khzd"
If Not .BOF Then .MoveFirst
While Not .EOF
Set itmX = lvwKh.ListItems.Add(, "khzd" & CStr(!khzd_key), !khmc & "")
itmX.SubItems(1) = !lxr & ""
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -