📄 form2.frm
字号:
VERSION 5.00
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "msadodc.ocx"
Object = "{CDE57A40-8B86-11D0-B3C6-00A0C90AEA82}#1.0#0"; "msdatgrd.ocx"
Begin VB.Form Form2
AutoRedraw = -1 'True
BorderStyle = 1 'Fixed Single
Caption = "查询"
ClientHeight = 10410
ClientLeft = 45
ClientTop = 435
ClientWidth = 13155
LinkTopic = "Form2"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 10410
ScaleWidth = 13155
StartUpPosition = 3 'Windows Default
Begin VB.CommandButton Command6
Caption = "把现实视图倒入到excel文件"
Height = 375
Left = 10440
TabIndex = 41
Top = 4560
Width = 2415
End
Begin MSAdodcLib.Adodc Adodc3
Height = 330
Left = 3240
Top = 9960
Width = 2520
_ExtentX = 4445
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = ""
Caption = "Adodc3"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin MSDataGridLib.DataGrid DataGrid1
Bindings = "Form2.frx":0000
Height = 4095
Left = 120
TabIndex = 39
Top = 240
Width = 12735
_ExtentX = 22463
_ExtentY = 7223
_Version = 393216
HeadLines = 1
RowHeight = 15
BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ColumnCount = 2
BeginProperty Column00
DataField = ""
Caption = ""
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column01
DataField = ""
Caption = ""
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
SplitCount = 1
BeginProperty Split0
BeginProperty Column00
EndProperty
BeginProperty Column01
EndProperty
EndProperty
End
Begin VB.Frame Frame11
Caption = "结果设置"
Height = 4695
Left = 10320
TabIndex = 30
Top = 5040
Width = 2535
Begin VB.Frame Frame10
Caption = "定制排列次序"
Height = 1935
Left = 480
TabIndex = 35
Top = 2640
Width = 1695
Begin VB.ComboBox Combo3
Height = 315
Left = 120
TabIndex = 38
Text = "id"
Top = 480
Width = 1455
End
Begin VB.OptionButton Option3
Caption = "升序asc"
Height = 255
Left = 120
TabIndex = 37
Top = 1080
Value = -1 'True
Width = 1335
End
Begin VB.OptionButton Option4
Caption = "降序dsc"
Height = 375
Left = 120
TabIndex = 36
Top = 1440
Width = 1335
End
End
Begin VB.Frame Frame9
Caption = "定制显示示图"
Height = 2175
Left = 480
TabIndex = 31
Top = 240
Width = 1695
Begin VB.CommandButton Command3
Caption = "定制查询的显字段"
Height = 615
Left = 120
TabIndex = 33
Top = 1320
Width = 1455
End
Begin VB.CommandButton Command4
Caption = "恢复显示所有字段"
Height = 615
Left = 120
TabIndex = 32
Top = 480
Width = 1455
End
Begin VB.Label Label1
Caption = "在这里您可以定制显示的字段"
Height = 255
Left = 120
TabIndex = 34
Top = 600
Width = 1335
End
End
End
Begin VB.CommandButton Command5
Caption = "刷新"
Height = 375
Left = 8760
TabIndex = 29
Top = 4560
Width = 1455
End
Begin VB.Frame Frame1
Caption = "查询条件"
Height = 4695
Left = 120
TabIndex = 0
Top = 5040
Width = 10095
Begin VB.CommandButton Command2
Caption = "重执条件"
Height = 735
Left = 1320
TabIndex = 28
Top = 480
Width = 855
End
Begin VB.Frame Frame8
Caption = "连接方法"
Height = 975
Left = 240
TabIndex = 21
Top = 3600
Width = 3015
Begin VB.OptionButton Option2
Caption = "or"
Height = 495
Index = 2
Left = 1320
TabIndex = 27
Top = 360
Width = 855
End
Begin VB.OptionButton Option1
Caption = "and"
Height = 495
Index = 2
Left = 120
TabIndex = 26
Top = 360
Width = 615
End
End
Begin VB.Frame Frame7
Caption = "连接方法"
Height = 975
Left = 240
TabIndex = 20
Top = 2520
Width = 3015
Begin VB.OptionButton Option2
Caption = "or"
Height = 495
Index = 1
Left = 1320
TabIndex = 25
Top = 240
Width = 735
End
Begin VB.OptionButton Option1
Caption = "and"
Height = 495
Index = 1
Left = 120
TabIndex = 24
Top = 240
Width = 615
End
End
Begin VB.Frame Frame6
Caption = "连接方法"
Height = 975
Left = 240
TabIndex = 19
Top = 1440
Width = 3015
Begin VB.OptionButton Option2
Caption = "or"
Height = 495
Index = 0
Left = 1320
TabIndex = 23
Top = 240
Width = 615
End
Begin VB.OptionButton Option1
Caption = "and"
Height = 495
Index = 0
Left = 120
TabIndex = 22
Top = 240
Width = 615
End
End
Begin VB.Frame Frame5
Caption = "条件4"
Enabled = 0 'False
Height = 975
Left = 3480
TabIndex = 9
Top = 3600
Width = 6375
Begin VB.TextBox Text1
Height = 375
Index = 3
Left = 3000
TabIndex = 12
Text = "Text1"
Top = 360
Width = 3015
End
Begin VB.ComboBox Combo2
Height = 315
Index = 3
Left = 1800
TabIndex = 11
Text = "模糊等于"
Top = 360
Width = 1095
End
Begin VB.ComboBox Combo1
Height = 315
Index = 3
Left = 240
Style = 2 'Dropdown List
TabIndex = 10
Top = 360
Width = 1455
End
End
Begin VB.Frame Frame4
Caption = "条件3"
Enabled = 0 'False
Height = 975
Left = 3480
TabIndex = 5
Top = 2520
Width = 6375
Begin VB.ComboBox Combo1
Height = 315
Index = 2
Left = 240
Style = 2 'Dropdown List
TabIndex = 15
Top = 360
Width = 1455
End
Begin VB.ComboBox Combo2
Height = 315
Index = 2
Left = 1800
TabIndex = 14
Text = "模糊等于"
Top = 360
Width = 1095
End
Begin VB.TextBox Text1
Height = 375
Index = 2
Left = 3000
TabIndex = 13
Text = "Text1"
Top = 360
Width = 3015
End
End
Begin VB.Frame Frame3
Caption = "条件2"
Enabled = 0 'False
Height = 975
Left = 3480
TabIndex = 4
Top = 1440
Width = 6375
Begin VB.ComboBox Combo1
Height = 315
Index = 1
Left = 240
Style = 2 'Dropdown List
TabIndex = 18
Top = 360
Width = 1455
End
Begin VB.ComboBox Combo2
Height = 315
Index = 1
Left = 1800
TabIndex = 17
Text = "模糊等于"
Top = 360
Width = 1095
End
Begin VB.TextBox Text1
Height = 375
Index = 1
Left = 3000
TabIndex = 16
Text = "Text1"
Top = 360
Width = 3015
End
End
Begin VB.Frame Frame2
Caption = "条件1"
Height = 975
Left = 3480
TabIndex = 3
Top = 360
Width = 6375
Begin VB.TextBox Text1
Height = 375
Index = 0
Left = 3000
TabIndex = 8
Text = " 1"
Top = 360
Width = 3015
End
Begin VB.ComboBox Combo2
Height = 315
Index = 0
Left = 1800
TabIndex = 7
Text = "等于"
Top = 360
Width = 1095
End
Begin VB.ComboBox Combo1
Height = 315
Index = 0
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -