📄 构成表查询.frm
字号:
VERSION 5.00
Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "TABCTL32.OCX"
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form seekfortable
BorderStyle = 1 'Fixed Single
Caption = "构成表查询"
ClientHeight = 3030
ClientLeft = 45
ClientTop = 330
ClientWidth = 5550
Icon = "构成表查询.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 3030
ScaleWidth = 5550
StartUpPosition = 1 '所有者中心
Begin VB.CheckBox chkLike
Caption = "启用模糊查询"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 375
Left = 1560
TabIndex = 13
Top = 1080
Width = 1575
End
Begin VB.CommandButton cmdCancel
BackColor = &H00F9FDE6&
Caption = "取消"
Height = 375
Left = 4320
Style = 1 'Graphical
TabIndex = 6
Top = 2520
Width = 1095
End
Begin VB.CommandButton cmdOK
BackColor = &H00F9FDE6&
Caption = "确定"
Height = 375
Left = 3000
Style = 1 'Graphical
TabIndex = 5
Top = 2520
Width = 1095
End
Begin TabDlg.SSTab stbQuery
Height = 2295
Left = 120
TabIndex = 0
Top = 120
Width = 5295
_ExtentX = 9340
_ExtentY = 4048
_Version = 393216
Tabs = 2
TabsPerRow = 2
TabHeight = 520
TabCaption(0) = "查询构成基本信息"
TabPicture(0) = "构成表查询.frx":08CA
Tab(0).ControlEnabled= -1 'True
Tab(0).Control(0)= "lblQueryValue"
Tab(0).Control(0).Enabled= 0 'False
Tab(0).Control(1)= "lblQueryItem"
Tab(0).Control(1).Enabled= 0 'False
Tab(0).Control(2)= "txtQueryValue"
Tab(0).Control(2).Enabled= 0 'False
Tab(0).Control(3)= "cmbQueryItem"
Tab(0).Control(3).Enabled= 0 'False
Tab(0).ControlCount= 4
TabCaption(1) = "查询相关日期信息"
TabPicture(1) = "构成表查询.frx":08E6
Tab(1).ControlEnabled= 0 'False
Tab(1).Control(0)= "Combo1"
Tab(1).Control(1)= "cmbDateItem"
Tab(1).Control(2)= "dtpDateValue"
Tab(1).Control(3)= "lblDateValue"
Tab(1).Control(4)= "lblQueryoperater"
Tab(1).Control(5)= "LblQuery"
Tab(1).ControlCount= 6
Begin VB.ComboBox Combo1
BackColor = &H00FEE4D1&
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 330
ItemData = "构成表查询.frx":0902
Left = -73080
List = "构成表查询.frx":0912
Style = 2 'Dropdown List
TabIndex = 10
Top = 960
Width = 735
End
Begin VB.ComboBox cmbDateItem
BackColor = &H00FEE4D1&
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 330
Left = -74640
Style = 2 'Dropdown List
TabIndex = 8
Top = 960
Width = 1695
End
Begin VB.ComboBox cmbQueryItem
BackColor = &H00FEE4D1&
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 330
Left = 1440
Style = 2 'Dropdown List
TabIndex = 4
Top = 1440
Width = 3135
End
Begin VB.TextBox txtQueryValue
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 315
Left = 1440
TabIndex = 3
Top = 600
Width = 3135
End
Begin MSComCtl2.DTPicker dtpDateValue
Height = 375
Left = -71880
TabIndex = 11
Top = 960
Width = 1815
_ExtentX = 3201
_ExtentY = 661
_Version = 393216
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
CalendarBackColor= 16777215
CalendarTitleBackColor= 8388608
CalendarTitleForeColor= 16777215
Format = 69074944
CurrentDate = 39000
End
Begin VB.Label lblDateValue
AutoSize = -1 'True
Caption = "日期"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = -71640
TabIndex = 12
Top = 600
Width = 420
End
Begin VB.Label lblQueryoperater
AutoSize = -1 'True
Caption = "运算符"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = -72720
TabIndex = 9
Top = 600
Width = 630
End
Begin VB.Label LblQuery
AutoSize = -1 'True
Caption = "查询"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = -74640
TabIndex = 7
Top = 600
Width = 420
End
Begin VB.Label lblQueryItem
AutoSize = -1 'True
Caption = "查询项目："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 360
TabIndex = 2
Top = 1560
Width = 1050
End
Begin VB.Label lblQueryValue
AutoSize = -1 'True
Caption = "查询内容："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 360
TabIndex = 1
Top = 600
Width = 1050
End
End
End
Attribute VB_Name = "seekfortable"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Fieldname As String '要查询的字段名
Private FieldValue As Variant '要查询的值
Private Operater As String '操作符
Private strFilter As String '查询字符串
Private Sub cmbDateItem_Click()
Select Case cmbDateItem.ListIndex
Case 0
Fieldname = "设计日期"
End Select
End Sub
Private Sub cmbQueryItem_Click()
With cmbQueryItem
Select Case .ListIndex
Case 0
Fieldname = "阶层"
Case 1
Fieldname = "部品番号"
Case 2
Fieldname = "部品名称"
Case 3
Fieldname = "图面代号"
Case 4
Fieldname = "规格与材料"
Case 5
Fieldname = "数量"
Case 6
Fieldname = "单位"
Case 7
Fieldname = "备注"
End Select
End With
End Sub
Private Sub cmdCancel_Click()
Unload Me
End Sub
Private Sub Combo1_Click()
Operater = Combo1.List(Combo1.ListIndex)
End Sub
Private Sub Form_Load()
MakeCenter Me
cmbQueryItem.AddItem "阶层"
cmbQueryItem.AddItem "部品番号"
cmbQueryItem.AddItem "部品名称"
cmbQueryItem.AddItem "图面代号"
cmbQueryItem.AddItem "规格与材料"
cmbQueryItem.AddItem "数量"
cmbQueryItem.AddItem "单位"
cmbQueryItem.AddItem "备注"
cmbQueryItem.ListIndex = 0 '默认第一项
cmbDateItem.AddItem "设计日期"
cmbDateItem.ListIndex = 0
stbQuery.Tab = 0 '默认第一项
Fieldname = "部品番号" '默认第一次就选择部品番号这个字段
Combo1.ListIndex = 0 '默认第一项
End Sub
Private Sub CancelButton_Click()
Unload Me
End Sub
Private Sub stbQuery_Click(PreviousTab As Integer)
If stbQuery.Tab = 1 Then
chkLike.Visible = False
Else
chkLike.Visible = True
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -