📄 tea_cx.frm
字号:
VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form Form15
BackColor = &H00FFC0C0&
Caption = "教师信息查询"
ClientHeight = 7005
ClientLeft = 60
ClientTop = 345
ClientWidth = 10470
LinkTopic = "Form15"
MDIChild = -1 'True
ScaleHeight = 7005
ScaleWidth = 10470
WindowState = 2 'Maximized
Begin VB.CommandButton Command3
Caption = "查询结果导出"
Enabled = 0 'False
Height = 495
Left = 6720
TabIndex = 28
Top = 6240
Width = 1575
End
Begin MSFlexGridLib.MSFlexGrid myFlexGrid
Height = 5535
Left = 3720
TabIndex = 27
Top = 480
Width = 7815
_ExtentX = 13785
_ExtentY = 9763
_Version = 393216
Cols = 19
FixedCols = 0
BackColorBkg = 16761024
End
Begin VB.Frame Frame1
BackColor = &H00FFC0C0&
Caption = "请输入查询条件"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 6735
Left = 120
TabIndex = 0
Top = 120
Width = 3375
Begin VB.ComboBox Combo2
Height = 300
Index = 3
ItemData = "Tea_cx.frx":0000
Left = 1080
List = "Tea_cx.frx":0010
TabIndex = 32
Text = "="
Top = 4080
Width = 615
End
Begin VB.ComboBox Combo2
Height = 300
Index = 2
ItemData = "Tea_cx.frx":0022
Left = 1080
List = "Tea_cx.frx":0032
TabIndex = 31
Text = "="
Top = 3480
Width = 615
End
Begin VB.ComboBox Combo2
Height = 300
Index = 1
ItemData = "Tea_cx.frx":0044
Left = 1080
List = "Tea_cx.frx":0054
TabIndex = 30
Text = "="
Top = 2400
Width = 615
End
Begin VB.ComboBox Combo2
Height = 300
Index = 0
ItemData = "Tea_cx.frx":0066
Left = 1080
List = "Tea_cx.frx":0076
TabIndex = 29
Text = "="
Top = 1800
Width = 615
End
Begin VB.CommandButton Command2
Caption = "重置条件"
Height = 375
Left = 1920
TabIndex = 25
Top = 6120
Width = 1095
End
Begin VB.CommandButton Command1
Caption = "开始查询"
Height = 375
Left = 120
TabIndex = 24
Top = 6120
Width = 1095
End
Begin VB.TextBox Text1
Height = 270
Index = 3
Left = 1440
TabIndex = 23
Top = 5640
Width = 1095
End
Begin VB.TextBox Text1
Height = 270
Index = 2
Left = 1080
TabIndex = 21
Top = 5160
Width = 1095
End
Begin VB.ComboBox Combo1
Height = 300
Index = 6
ItemData = "Tea_cx.frx":0088
Left = 1440
List = "Tea_cx.frx":0092
TabIndex = 19
Top = 4680
Width = 855
End
Begin VB.ComboBox Combo1
Height = 300
Index = 3
ItemData = "Tea_cx.frx":009E
Left = 1080
List = "Tea_cx.frx":00A0
TabIndex = 18
Top = 2880
Width = 1335
End
Begin VB.ComboBox Combo1
Height = 300
Index = 2
ItemData = "Tea_cx.frx":00A2
Left = 1800
List = "Tea_cx.frx":00A4
TabIndex = 17
Top = 2400
Width = 1455
End
Begin VB.ComboBox Combo1
Height = 300
Index = 1
ItemData = "Tea_cx.frx":00A6
Left = 1800
List = "Tea_cx.frx":00A8
TabIndex = 16
Top = 1800
Width = 975
End
Begin VB.ComboBox Combo1
Height = 300
Index = 5
ItemData = "Tea_cx.frx":00AA
Left = 1800
List = "Tea_cx.frx":00BD
TabIndex = 13
Top = 4080
Width = 855
End
Begin VB.ComboBox Combo1
Height = 300
Index = 4
ItemData = "Tea_cx.frx":00D0
Left = 1800
List = "Tea_cx.frx":00D2
TabIndex = 11
Top = 3480
Width = 1455
End
Begin VB.ComboBox Combo1
Height = 300
Index = 0
ItemData = "Tea_cx.frx":00D4
Left = 1080
List = "Tea_cx.frx":00DE
TabIndex = 6
Top = 1320
Width = 855
End
Begin VB.TextBox Text1
Height = 270
Index = 1
Left = 1080
TabIndex = 4
Top = 840
Width = 1335
End
Begin VB.TextBox Text1
Height = 270
Index = 0
Left = 1080
MaxLength = 8
TabIndex = 2
Top = 360
Width = 1335
End
Begin VB.Label Label12
BackColor = &H00FFC0C0&
Caption = "参加工作日期："
Height = 255
Left = 240
TabIndex = 22
Top = 5640
Width = 1335
End
Begin VB.Label Label11
BackColor = &H00FFC0C0&
Caption = "出生年月："
Height = 255
Left = 240
TabIndex = 20
Top = 5160
Width = 975
End
Begin VB.Label Label10
BackColor = &H00FFC0C0&
Caption = "是否为班导师："
Height = 255
Left = 240
TabIndex = 15
Top = 4680
Width = 1455
End
Begin VB.Label Label9
BackColor = &H00FFC0C0&
Caption = "级"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 2760
TabIndex = 14
Top = 4080
Width = 255
End
Begin VB.Label Label8
BackColor = &H00FFC0C0&
Caption = "岗位级别："
Height = 255
Left = 240
TabIndex = 12
Top = 4080
Width = 1095
End
Begin VB.Label Label7
BackColor = &H00FFC0C0&
Caption = "职 务："
Height = 255
Left = 240
TabIndex = 10
Top = 3480
Width = 975
End
Begin VB.Label Label6
BackColor = &H00FFC0C0&
Caption = "所属系部："
Height = 255
Left = 240
TabIndex = 9
Top = 2880
Width = 975
End
Begin VB.Label Label5
BackColor = &H00FFC0C0&
Caption = "职 称："
Height = 255
Left = 240
TabIndex = 8
Top = 2400
Width = 975
End
Begin VB.Label Label4
BackColor = &H00FFC0C0&
Caption = "学 历："
Height = 255
Left = 240
TabIndex = 7
Top = 1800
Width = 975
End
Begin VB.Label Label3
BackColor = &H00FFC0C0&
Caption = "性 别："
Height = 255
Left = 240
TabIndex = 5
Top = 1320
Width = 975
End
Begin VB.Label Label2
BackColor = &H00FFC0C0&
Caption = "教师姓名："
Height = 255
Left = 240
TabIndex = 3
Top = 840
Width = 975
End
Begin VB.Label Label1
BackColor = &H00FFC0C0&
Caption = "职工号："
Height = 255
Left = 240
TabIndex = 1
Top = 360
Width = 735
End
End
Begin VB.Label Label13
BackColor = &H00FFC0C0&
Caption = "查询结果显示："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 3720
TabIndex = 26
Top = 120
Width = 1575
End
End
Attribute VB_Name = "Form15"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Attribute VB_Ext_KEY = "RVB_UniqueId" ,"41FF01F8039C"
Attribute VB_Ext_KEY = "RVB_ModelStereotype" ,"Form"
Dim mrc
Private mrc1 As ADODB.Recordset '定义记录集
Dim txtSQL
Private txtSQL1 As String '定义SQL字符串
Dim temp As Integer '定义临时变量
Private Sub Command1_Click() '开始查询按钮
Dim i As Integer '判断是否填写查询条件
For i = 0 To 3
If Text1(i).Text <> "" Then GoTo search
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -