📄 ygchx.frm
字号:
VERSION 5.00
Begin VB.Form Form9
BorderStyle = 3 'Fixed Dialog
Caption = "员工查询"
ClientHeight = 2205
ClientLeft = 45
ClientTop = 435
ClientWidth = 5955
LinkTopic = "Form9"
LockControls = -1 'True
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
ScaleHeight = 2205
ScaleWidth = 5955
ShowInTaskbar = 0 'False
Begin VB.CommandButton Command2
Caption = "查 询"
BeginProperty Font
Name = "楷体_GB2312"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 450
Left = 4800
TabIndex = 12
Top = 1600
Width = 1000
End
Begin VB.TextBox Text2
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 1320
TabIndex = 10
Top = 600
Width = 1455
End
Begin VB.TextBox Text1
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 1320
TabIndex = 9
Top = 120
Width = 1455
End
Begin VB.TextBox Text6
Alignment = 2 'Center
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 4800
MaxLength = 2
TabIndex = 8
Top = 1080
Width = 975
End
Begin VB.TextBox Text5
Alignment = 2 'Center
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 1680
MaxLength = 2
TabIndex = 7
Top = 1080
Width = 735
End
Begin VB.TextBox Text4
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 4320
TabIndex = 6
Top = 600
Width = 1455
End
Begin VB.TextBox Text3
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 4320
TabIndex = 5
Top = 120
Width = 1455
End
Begin VB.Label Label4
Caption = "否是离职："
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 3120
TabIndex = 13
Top = 1140
Width = 1580
End
Begin VB.Label Label7
Caption = "模糊查询：只要任意思输入一项就可以进查询。"
BeginProperty Font
Name = "楷体_GB2312"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 255
Left = 240
TabIndex = 11
Top = 1698
Width = 4455
End
Begin VB.Label Label5
Caption = "性 别："
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 120
TabIndex = 4
Top = 1138
Width = 1305
End
Begin VB.Label Label6
Caption = "职 务："
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 3120
TabIndex = 3
Top = 658
Width = 1305
End
Begin VB.Label Label3
Caption = "部 门："
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 3120
TabIndex = 2
Top = 178
Width = 1305
End
Begin VB.Label Label2
Caption = "姓 名："
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 120
TabIndex = 1
Top = 658
Width = 1305
End
Begin VB.Label Label1
Caption = "工 号："
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 285
Left = 120
TabIndex = 0
Top = 178
Width = 1305
End
End
Attribute VB_Name = "Form9"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command2_Click()
Dim result As String
Text1.Text = Trim(Text1.Text)
Text2.Text = Trim(Text2.Text)
Text3.Text = Trim(Text3.Text)
Text4.Text = Trim(Text4.Text)
Text5.Text = Trim(Text5.Text)
Text6.Text = Trim(Text6.Text)
'rst.Open "select * from bumeibiao where 部门名称= '" & Text3.Text & "'", con
' bm = rst!编号
'rst.Close
'rst.Open "select * from zhiwubiao where 职务名称=' " & Text4.Text & "'", con
' zhw = rst!编号
'rst.Close
'If Text6.Text = "是" Then lz = True Else lz = flase
If Text1.Text <> "" Then result = result & " and 工号 like '%" & Text1.Text & "%'"
If Text2.Text <> "" Then result = result & " and 姓名 like '%" & Text2.Text & "%'"
'If Text3.Text <> "" Then result = result & "and 部门编号 '%" & Text3.Text & "%' "
'If Text4.Text <> "" Then result = result & " and 职务编号 like '%" & Text4.Text & "%'"
If Text5.Text <> "" Then result = result & " and 性别 like '%" & Text5.Text & "%'"
'If Text6.Text <> "" Then result = result & " and 是否离职 like '%" & True & "%'"
If result = "" Then
MsgBox "没有输入条件"
Else
DataEnvironment1.rsCommand1.Open "select * from zhigongbiao where true " & result
DataReport1.Show
DataReport1.Refresh
DataEnvironment1.rsCommand1.Close
End If
End Sub
Private Sub Form_Load()
Form9.Top = MDIForm1.Height / 4
Form9.Left = MDIForm1.Width / 4
DataEnvironment1.Connection1.ConnectionString = s
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -