📄 frmhwkcquery.frm
字号:
VERSION 5.00
Object = "{D76D7128-4A96-11D3-BD95-D296DC2DD072}#1.0#0"; "Vsflex7.ocx"
Begin VB.Form frmHwKcQuery
Caption = "货物库存查询"
ClientHeight = 5790
ClientLeft = 1125
ClientTop = 2460
ClientWidth = 9660
LinkTopic = "Form1"
LockControls = -1 'True
ScaleHeight = 5790
ScaleWidth = 9660
Begin VB.Frame Frame
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 1665
Index = 0
Left = 60
TabIndex = 1
Top = 30
Width = 9465
Begin VB.TextBox Text
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 330
Index = 1
Left = 1440
TabIndex = 7
Top = 720
Width = 2925
End
Begin VB.ComboBox Combo
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 330
Index = 0
Left = 1440
TabIndex = 4
Top = 1140
Width = 2145
End
Begin VB.TextBox Text
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 330
Index = 0
Left = 1440
TabIndex = 3
Top = 270
Width = 2925
End
Begin VB.CommandButton Command
Caption = "查询(&R)"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Index = 0
Left = 5490
TabIndex = 2
Top = 270
Width = 1515
End
Begin VB.Label Label
Caption = "货物名称:"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 195
Index = 1
Left = 240
TabIndex = 8
Top = 780
Width = 945
End
Begin VB.Label Label
Caption = "仓库:"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 195
Index = 2
Left = 660
TabIndex = 6
Top = 1185
Width = 765
End
Begin VB.Label Label
Caption = "货物编码:"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 195
Index = 0
Left = 240
TabIndex = 5
Top = 330
Width = 945
End
End
Begin VSFlex7Ctl.VSFlexGrid Flex
Height = 3795
Index = 0
Left = 60
TabIndex = 0
Top = 1860
Width = 9435
_cx = 16642
_cy = 6694
_ConvInfo = 1
Appearance = 1
BorderStyle = 1
Enabled = -1 'True
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
MousePointer = 0
BackColor = -2147483643
ForeColor = -2147483640
BackColorFixed = -2147483633
ForeColorFixed = -2147483630
BackColorSel = -2147483635
ForeColorSel = -2147483634
BackColorBkg = -2147483636
BackColorAlternate= -2147483643
GridColor = -2147483633
GridColorFixed = -2147483632
TreeColor = -2147483632
FloodColor = 192
SheetBorder = -2147483642
FocusRect = 1
HighLight = 1
AllowSelection = -1 'True
AllowBigSelection= -1 'True
AllowUserResizing= 1
SelectionMode = 1
GridLines = 1
GridLinesFixed = 2
GridLineWidth = 1
Rows = 2
Cols = 9
FixedRows = 1
FixedCols = 1
RowHeightMin = 0
RowHeightMax = 0
ColWidthMin = 0
ColWidthMax = 0
ExtendLastCol = 0 'False
FormatString = "|<仓库名称|<货物编码|<货物名称|<计量单位|>期初数量|>本期收入数量|>本期发出数量|>本期结存数量"
ScrollTrack = 0 'False
ScrollBars = 3
ScrollTips = 0 'False
MergeCells = 0
MergeCompare = 0
AutoResize = -1 'True
AutoSizeMode = 0
AutoSearch = 0
AutoSearchDelay = 2
MultiTotals = -1 'True
SubtotalPosition= 1
OutlineBar = 0
OutlineCol = 0
Ellipsis = 0
ExplorerBar = 0
PicturesOver = 0 'False
FillStyle = 0
RightToLeft = 0 'False
PictureType = 0
TabBehavior = 0
OwnerDraw = 0
Editable = 0
ShowComboButton = -1 'True
WordWrap = 0 'False
TextStyle = 0
TextStyleFixed = 0
OleDragMode = 0
OleDropMode = 0
DataMode = 0
VirtualData = -1 'True
DataMember = ""
ComboSearch = 3
AutoSizeMouse = -1 'True
FrozenRows = 0
FrozenCols = 0
AllowUserFreezing= 0
BackColorFrozen = 0
ForeColorFrozen = 0
WallPaperAlignment= 9
End
End
Attribute VB_Name = "frmHwKcQuery"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'QQ:75347626
'MSN:whailin2000@hotmail.com
Option Explicit
Const FlexHwKc = 0
Const TxtHwKc_HwBmCode = 0
Const TxtHwKc_HwBmMc = 1
Const CBxHwKc_HwCkMc = 0
Const CmdQuery = 0
Private Sub Command_Click(Index As Integer)
On Error GoTo Errorhandle
Select Case Index
Case CmdQuery
LoadDataIntoGrid
End Select
Exit Sub
Errorhandle:
MsgBox Err.Description
End Sub
Private Sub Form_Load()
On Error GoTo Errorhandle
FillComboWithSql Me, Combo(CBxHwKc_HwCkMc), "SELECT HwCkMc,HwCkNO FROM HwCkREC ORDER BY HwCkMc", "HWCKNO"
Exit Sub
Errorhandle:
MsgBox Err.Description
End Sub
Private Function GetWhereStr() As String
Dim WhereStr As String
On Error GoTo Errorhandle
If Trim(Text(TxtHwKc_HwBmCode).Text) <> "" Then
WhereStr = WhereStr & " AND HWBMCODE LIKE '" & Trim(Text(TxtHwKc_HwBmCode).Text) & "%'"
End If
If Trim(Text(TxtHwKc_HwBmMc).Text) <> "" Then
WhereStr = WhereStr & " AND HWBMMC LIKE '%" & Trim(Text(TxtHwKc_HwBmMc).Text) & "%'"
End If
If Trim(Combo(CBxHwKc_HwCkMc).Text) <> "" Then
WhereStr = WhereStr & " AND HWCKMC LIKE '" & Trim(Combo(CBxHwKc_HwCkMc).Text) & "%'"
End If
If WhereStr <> "" Then
WhereStr = Mid(WhereStr, 5)
End If
GetWhereStr = WhereStr
Exit Function
Errorhandle:
Err.Raise vbObjectError + 1, , Err.Description
End Function
Private Sub LoadDataIntoGrid()
Dim SqlStr As String, WhereStr As String
Dim ItemStr As String
Dim Rs As ADODB.Recordset
On Error GoTo Errorhandle
Flex(FlexHwKc).Rows = 1
WhereStr = GetWhereStr
SqlStr = "SELECT HWCKMC,HWBMCODE,HWBMMC,HWBMDW,HWKCLQTY,HWKCIQTY,HWKCOQTY,HWKCQTY FROM HWKCREC,HWCKREC,HWBMREC WHERE HWCKNO=HWKC_HWCKNO AND HWBMNO=HWKC_HWBMNO "
If WhereStr <> "" Then
SqlStr = SqlStr & " AND " & WhereStr
End If
SqlStr = SqlStr & " ORDER BY HWCKMC,HWBMCODE "
Set Rs = Conn.Execute(SqlStr)
Do While Not Rs.EOF
ItemStr = vbTab & Rs("HWCKMC") & vbTab & Rs("HWBMCODE") & vbTab & Rs("HWBMMC") & vbTab & Rs("HWBMDW") & vbTab & Rs("HWKCLQTY") & vbTab & Rs("HWKCIQTY") & vbTab & Rs("HWKCOQTY") & vbTab & Rs("HWKCQTY")
Flex(FlexHwKc).AddItem ItemStr
Rs.MoveNext
Loop
Rs.Close
Set Rs = Nothing
Exit Sub
Errorhandle:
If Not Rs Is Nothing Then
Rs.Close
Set Rs = Nothing
End If
Err.Raise vbObjectError + 1, , Err.Description
End Sub
Private Sub Form_Resize()
On Error GoTo Errorhandle
Resize_ALL Me
Exit Sub
Errorhandle:
MsgBox Err.Description
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -