📄 frmfind.frm
字号:
Text = "与或"
Object.Width = 1411
EndProperty
BeginProperty ColumnHeader(3) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 2
Text = "字段名"
Object.Width = 1764
EndProperty
BeginProperty ColumnHeader(4) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 3
Text = "条件"
Object.Width = 1411
EndProperty
BeginProperty ColumnHeader(5) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 4
Text = "字段值"
Object.Width = 6174
EndProperty
BeginProperty ColumnHeader(6) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 5
Key = "rk"
Object.Width = 706
EndProperty
End
Begin VB.Label Label8
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "查询结果"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 120
TabIndex = 3
Top = 120
Width = 1935
End
End
Begin MSComctlLib.ImageList ImgListToolBar
Left = 5040
Top = 0
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 20
ImageHeight = 20
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 9
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmFind.frx":6E25
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmFind.frx":6F45
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmFind.frx":7399
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmFind.frx":77ED
Key = ""
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmFind.frx":7C41
Key = ""
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmFind.frx":7D61
Key = ""
EndProperty
BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmFind.frx":7E81
Key = ""
EndProperty
BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmFind.frx":7FA1
Key = ""
EndProperty
BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmFind.frx":80B5
Key = ""
EndProperty
EndProperty
End
Begin MSComctlLib.Toolbar Tbar
Align = 1 'Align Top
Height = 420
Left = 0
TabIndex = 38
Top = 0
Width = 7080
_ExtentX = 12488
_ExtentY = 741
ButtonWidth = 1455
ButtonHeight = 688
Appearance = 1
Style = 1
TextAlignment = 1
ImageList = "ImgListToolBar"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 6
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "打开"
Key = "BtnOpen"
Object.ToolTipText = "打开"
ImageIndex = 2
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "保存"
Key = "BtnSave"
Object.ToolTipText = "保存"
ImageIndex = 1
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "返回"
Key = "BtnBack"
Object.ToolTipText = "返回"
ImageIndex = 8
EndProperty
BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "退出"
Key = "BtnQuit"
Object.ToolTipText = "退出"
ImageIndex = 9
EndProperty
BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
EndProperty
EndProperty
End
Begin MSComDlg.CommonDialog CmnDlg
Left = 6480
Top = 4320
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin VB.Image HImgDrag
Height = 765
Left = 7200
MousePointer = 7 'Size N S
Top = 4800
Width = 120
End
End
Attribute VB_Name = "FrmFind"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public gWidthRate As Single '宽度比例
Public gHeightRate As Single '高度比例
Const gBorderWidth = 60 '控件间距
Public VDragFlag As Boolean '垂直拖动标志
Public HDragFlag As Boolean '水平拖动标志
Dim gTypeCode() As String '全局档案类型数组，对应cbxtypecode中的选项
Dim gQueryField() As String '全局查询字段3维数组，1维对应CbxFieldName中的选项2维对应数据类型3维对应该字段的数据字典
Public Function ListValue(Table_Name As String, Field_Name As String)
On Error GoTo Err
Dim rd As Recordset
Dim sql As String
CbxFieldValue.Visible = True
TxtValue.Visible = False
MaskRQ.Visible = False
CbxFieldValue.Clear
sql = "select * from " + Table_Name_Sys + ""
Set rd = gDbFish.OpenRecordset(sql)
While Not rd.EOF
CbxFieldValue.AddItem Trim(rd.Fields(Field_Name))
rd.MoveNext
Wend
If CbxFieldValue.ListCount > 1 Then CbxFieldValue.ListIndex = 0
Err:
End Function
Private Sub CbxCon_Change()
On Error GoTo Err
CbxFieldValue.SetFocus
TxtValue.SetFocus
MaskRQ.SetFocus
Err:
End Sub
Private Sub CbxFieldName_Change()
On Error GoTo Err
Dim tIndex As Integer
If CbxFieldName.ListCount < 1 Then Exit Sub
'tIndex = CbxFieldName.ListIndex + 1
'设置操作符
'有数据字典
Select Case CbxFieldName.Text
Case "产品类型"
Table_Name_Sys = "product_kind"
Field_Name = "pd_kind_name"
Call ListValue(Table_Name, Field_Name)
Case "厂家名称"
Table_Name_Sys = "factory_info"
Field_Name = "fct_name"
Call ListValue(Table_Name, Field_Name)
Case "入库经办人"
Table_Name_Sys = "login_info"
Field_Name = "user_name"
Call ListValue(Table_Name, Field_Name)
Case "出库经办人"
Table_Name_Sys = "login_info"
Field_Name = "user_name"
Call ListValue(Table_Name, Field_Name)
Case "出库日期"
CbxFieldValue.Visible = False
TxtValue.Visible = False
MaskRQ.Visible = True
MaskRQ.Text = "????年??月??日"
Case "入库日期"
CbxFieldValue.Visible = False
TxtValue.Visible = False
MaskRQ.Visible = True
MaskRQ.Text = "????年??月??日"
Case Else
CbxFieldValue.Visible = False
MaskRQ.Visible = False
TxtValue.Visible = True
TxtValue.Text = ""
End Select
Err:
End Sub
Private Sub CbxFieldName_Click()
Call CbxFieldName_Change
End Sub
Private Sub CbxTypeCode_Change()
On Error GoTo Err
Dim Type_No As String
Me.MousePointer = 11
LVResult.ColumnHeaders.Clear
LVCondition.ListItems.Clear
LVSQL.ListItems.Clear
LVResult.ListItems.Clear
Select Case CbxTypeCode.Text
Case "入库情况"
Type_No = 1
Table_Name = "product_in"
Call AddViewField(Type_No)
Call AddQueryField(Type_No)
Case "出库情况"
Type_No = 2
Table_Name = "product_out"
Call AddViewField(Type_No)
Call AddQueryField(Type_No)
Case "库存情况"
Type_No = 3
Table_Name = "product_stock"
Call AddViewField(Type_No)
Call AddQueryField(Type_No)
End Select
CmdSel(0).Enabled = True
CmdSel(1).Enabled = True
CmdExecute.Enabled = False
Err:
Me.MousePointer = 0
End Sub
'在CbxTypeCode里添加字段
Private Function AddQueryField(Field_Type As String) As Boolean
On Error GoTo Err
Dim rd As Recordset
Dim sql As String
Dim i As String
Dim n As String
n = 0
CbxFieldName.Clear
sql = "select * from field_name where field_name_type='" + Field_Type + "'"
Set rd = gDbFish.OpenRecordset(sql)
While Not rd.EOF
n = n + 1
rd.MoveNext
Wend
i = 1
'1维字段名，2维字段类型，3维数据字典，重定义数组
ReDim gQueryField(1 To n, 1 To 3) As String
Set rd = gDbFish.OpenRecordset(sql)
While Not rd.EOF
CbxFieldName.AddItem Trim(rd.Fields("field_name_ch"))
gQueryField(i, 1) = Trim(rd.Fields("field_name_en"))
gQueryField(i, 2) = ConvertNull(rd.Fields("data_type"))
gQueryField(i, 3) = ConvertNull(rd.Fields("system_dict_type"))
rd.MoveNext
i = i + 1
Wend
'SBar.Panels(2).Text = "当前记录数:" + ConvertNull(i)
If CbxFieldName.ListCount > 0 Then CbxFieldName.ListIndex = 0
AddQueryField = True
Exit Function
Err:
AddQueryField = False
End Function
'显示LVViewField里的字段
Private Sub AddViewField(Field_Type As String)
Dim rd As Recordset
Dim sql As String
LVViewField.ListItems.Clear
sql = "select * from field_name where field_name_type='" + Field_Type + "'"
Set rd = gDbFish.OpenRecordset(sql)
While Not rd.EOF
LVViewField.ListItems.Add , "@F " + rd.Fields("field_name_en"), Trim(rd.Fields("field_name_ch"))
rd.MoveNext
Wend
End Sub
Private Sub CbxTypeCode_Click()
Call CbxTypeCode_Change
End Sub
Private Sub CmdAdd_Click()
On Error GoTo Err
Dim tLCItem As ListItem 'LVCondition
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -