📄 frminfind.frm
字号:
Picture = "frmInFind.frx":1A0A
Key = ""
EndProperty
BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmInFind.frx":1E5E
Key = ""
EndProperty
BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmInFind.frx":22B2
Key = ""
EndProperty
BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmInFind.frx":4FBC
Key = ""
EndProperty
BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmInFind.frx":6CC6
Key = ""
EndProperty
BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmInFind.frx":97D0
Key = ""
EndProperty
EndProperty
End
Begin MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 795
Left = 0
TabIndex = 2
Top = 0
Width = 9090
_ExtentX = 16034
_ExtentY = 1402
ButtonWidth = 1032
ButtonHeight = 1349
Appearance = 1
Style = 1
ImageList = "ImageList2"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 9
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "查询"
ImageIndex = 12
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "全部"
ImageIndex = 11
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "打印"
ImageIndex = 10
EndProperty
BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "退出"
ImageIndex = 9
EndProperty
BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.Visible = 0 'False
Caption = "确定"
ImageIndex = 6
EndProperty
BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.Visible = 0 'False
Caption = "取消"
ImageIndex = 7
EndProperty
EndProperty
BorderStyle = 1
End
Begin MSComCtl2.DTPicker DTPicker1
Height = 300
Left = 5670
TabIndex = 10
Top = 1485
Width = 1455
_ExtentX = 2566
_ExtentY = 529
_Version = 393216
Enabled = 0 'False
Format = 24641537
CurrentDate = 35067
End
Begin MSComCtl2.DTPicker DTPicker2
Height = 300
Left = 7110
TabIndex = 19
Top = 1485
Width = 1455
_ExtentX = 2566
_ExtentY = 529
_Version = 393216
Enabled = 0 'False
Format = 24641537
CurrentDate = 35067
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "供货单位"
Height = 180
Index = 9
Left = 4875
TabIndex = 18
Top = 1125
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "进货时间"
Height = 180
Index = 2
Left = 4800
TabIndex = 17
Top = 1575
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "支付方式"
Height = 180
Index = 1
Left = 795
TabIndex = 16
Top = 1545
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "进货单编号"
Height = 180
Index = 0
Left = 660
TabIndex = 15
Top = 1125
Width = 900
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "发票类型"
Height = 180
Index = 10
Left = 780
TabIndex = 14
Top = 2100
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "发票号码"
Height = 180
Index = 11
Left = 4785
TabIndex = 13
Top = 2055
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "验货人"
Height = 180
Index = 12
Left = 960
TabIndex = 12
Top = 2505
Width = 540
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "操作员"
Height = 180
Index = 13
Left = 4965
TabIndex = 11
Top = 2490
Width = 540
End
End
Attribute VB_Name = "frmInFind"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'15
Dim s As String
Private Sub Check1_Click()
If Check1.Value = 1 Then Text2.Enabled = True Else Text2.Enabled = False
End Sub
Private Sub Check2_Click()
If Check2.Value = 1 Then Text9.Enabled = True Else Text9.Enabled = False
End Sub
Private Sub Check3_Click()
If Check3.Value = 1 Then
Text1.Enabled = True
Else
Text1.Enabled = False
End If
End Sub
Private Sub Check4_Click()
If Check4.Value = 1 Then
DTPicker1.Enabled = True
DTPicker2.Enabled = True
Else
DTPicker1.Enabled = False
DTPicker2.Enabled = False
End If
End Sub
Private Sub Check5_Click()
If Check5.Value = 1 Then
Combo1.Enabled = True
Else
Combo1.Enabled = False
End If
End Sub
Private Sub Check6_Click()
If Check6.Value = 1 Then
Text12.Enabled = True
Else
Text12.Enabled = False
End If
End Sub
Private Sub Check7_Click()
If Check7.Value = 1 Then
Combo2.Enabled = True
Else
Combo2.Enabled = False
End If
End Sub
Private Sub Check8_Click()
If Check8.Value = 1 Then
Combo3.Enabled = True
Else
Combo3.Enabled = False
End If
End Sub
Private Sub Form_Load()
On Error GoTo eH
MFG.MergeCol(0) = True
MFG.MergeCol(1) = True
MFG.MergeCol(2) = True
MFG.MergeCol(3) = True
MFG.MergeCol(4) = True
MFG.MergeCol(5) = True
MFG.MergeCol(6) = True
MFG.MergeCol(7) = True
ADO.ConnectionString = g_cnnStr
ADO.RecordSource = "select * from 进货单"
ADO.Refresh
If g_rst.State = 1 Then g_rst.Close
Combo1.Clear
g_rst.Open "select * from 发票类型"
While Not g_rst.EOF
Combo1.AddItem g_rst!发票类型
g_rst.MoveNext
Wend
If g_rst.State = 1 Then g_rst.Close
Text1.Clear
g_rst.Open "select * from 支付方式"
While Not g_rst.EOF
Text1.AddItem g_rst!支付方式
g_rst.MoveNext
Wend
If g_rst.State = 1 Then g_rst.Close
Combo2.Clear
g_rst.Open "select 人员姓名 from 工作人员"
While Not g_rst.EOF
Combo2.AddItem g_rst!人员姓名
g_rst.MoveNext
Wend
If g_rst.State = 1 Then g_rst.Close
Combo3.Clear
g_rst.Open "select 人员姓名 from 工作人员"
While Not g_rst.EOF
Combo3.AddItem g_rst!人员姓名
g_rst.MoveNext
Wend
Exit Sub
eH:
MsgBox em & vbNewLine & "错误号:1501" & vbNewLine & "错误描述:" & Err.Description
End Sub
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
On Error GoTo eH
Select Case Button.Caption
Case "查询"
MFG.Clear
g_SQL = ""
If Check1.Value = 1 Then
g_SQL = g_SQL + "进货单编号=" & Val(Text2) & " and "
End If
If Check2.Value = 1 Then
g_SQL = g_SQL + "供货单位='" & Text9 & "' and "
End If
If Check3.Value = 1 Then
g_SQL = g_SQL + "支付方式='" & Text1 & "' and "
End If
If Check4.Value = 1 Then
g_SQL = g_SQL + "进货日期>=#" & DTPicker1.Value & "# and 进货日期<=#" & DTPicker2.Value & "# and "
End If
If Check5.Value = 1 Then
g_SQL = g_SQL + "发票类型='" & Combo1 & "' and "
End If
If Check6.Value = 1 Then
g_SQL = g_SQL + "发票号码='" & Text12 & "' and "
End If
If Check7.Value = 1 Then
g_SQL = g_SQL + "验货人='" & Combo2 & "' and "
End If
If Check8.Value = 1 Then
g_SQL = g_SQL + "操作员='" & Combo3 & "' and "
End If
If g_SQL = "" Then Exit Sub
g_SQL = Mid(g_SQL, 1, Len(g_SQL) - 4)
s = g_SQL
g_SQL = "select * from 进货单 where " & g_SQL + " order by 进货单编号 asc"
ADO.RecordSource = g_SQL
ADO.Refresh
Case "全部"
ADO.RecordSource = "select * from 进货单"
ADO.Refresh
s = ""
Case "打印"
If drIn.Visible = True Then Unload drIn
If DE.rsIn_分组.State = 1 Then DE.rsIn_分组.Close
DE.rsIn_分组.Filter = s
DE.rsIn_分组.Open
drIn.Show 1
Case "退出"
Unload Me
End Select
Exit Sub
eH:
MsgBox em & vbNewLine & "错误号:1502" & vbNewLine & "错误描述:" & Err.Description
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -