?? frmmerch.frm
字號:
BorderStyle = 0 'Transparent
Height = 270
Left = 30
Top = 4125
Width = 2655
End
End
Begin MySuperMarket.XPButton cmdSearch
Height = 345
Left = 3480
TabIndex = 11
Top = 660
Width = 975
_extentx = 1720
_extenty = 609
caption = "高級(&S)"
capalign = 2
backstyle = 2
cgradient = 0
font = "frmMerch.frx":0198
mode = 0
value = 0 'False
enabled = 0 'False
cback = -2147483633
End
Begin MSComctlLib.ImageList ImageList1
Left = 8760
Top = 5520
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 4
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmMerch.frx":01BC
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmMerch.frx":0556
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmMerch.frx":08F0
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmMerch.frx":0C8A
Key = ""
EndProperty
EndProperty
End
Begin MySuperMarket.FCombo cboPage
Height = 300
Left = 5280
TabIndex = 3
Top = 690
Width = 1215
_extentx = 2143
_extenty = 529
font = "frmMerch.frx":1024
listindex = -1
enabledtext = 0 'False
enabledtext = 0 'False
End
Begin VB.PictureBox PicTop
BackColor = &H00808080&
BorderStyle = 0 'None
Height = 450
Left = 45
ScaleHeight = 30
ScaleMode = 3 'Pixel
ScaleWidth = 452
TabIndex = 0
TabStop = 0 'False
Top = 45
Width = 6780
Begin VB.Image imgIcon
Height = 480
Left = 60
Top = -15
Width = 480
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "商品管理"
BeginProperty Font
Name = "宋體"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FFFFFF&
Height = 210
Left = 600
TabIndex = 1
Top = 120
Width = 900
End
End
Begin MSComctlLib.ListView List1
Height = 3975
Left = 240
TabIndex = 2
Top = 1140
Width = 4320
_ExtentX = 7620
_ExtentY = 7011
View = 3
LabelEdit = 1
MultiSelect = -1 'True
LabelWrap = -1 'True
HideSelection = 0 'False
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
SmallIcons = "ImageList1"
ForeColor = -2147483640
BackColor = -2147483643
Appearance = 1
NumItems = 8
BeginProperty ColumnHeader(1) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Text = "名稱"
Object.Width = 2646
EndProperty
BeginProperty ColumnHeader(2) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 1
Text = "價格"
Object.Width = 1587
EndProperty
BeginProperty ColumnHeader(3) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 2
Text = "條形碼"
Object.Width = 2646
EndProperty
BeginProperty ColumnHeader(4) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 3
Text = "庫存數(shù)"
Object.Width = 1349
EndProperty
BeginProperty ColumnHeader(5) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 4
Text = "打折"
Object.Width = 979
EndProperty
BeginProperty ColumnHeader(6) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Alignment = 2
SubItemIndex = 5
Text = "狀態(tài)"
Object.Width = 1191
EndProperty
BeginProperty ColumnHeader(7) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 6
Text = "廠商"
Object.Width = 2117
EndProperty
BeginProperty ColumnHeader(8) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 7
Text = "供應商"
Object.Width = 2117
EndProperty
End
Begin MySuperMarket.XButton cmdFirst
Height = 300
Left = 4560
TabIndex = 4
Top = 690
Width = 300
_extentx = 529
_extenty = 529
caption = ""
mousedowncolor = 12363422
mouseoncolor = 14204854
stylecolor = 6956042
style3dcolor1 = 6956042
style3dcolor2 = 6956042
style = 1
font = "frmMerch.frx":1048
picture = "frmMerch.frx":106C
End
Begin MySuperMarket.XButton cmdNext
Height = 300
Left = 6600
TabIndex = 5
Top = 690
Width = 300
_extentx = 529
_extenty = 529
caption = ""
mousedowncolor = 12363422
mouseoncolor = 14204854
stylecolor = 6956042
style3dcolor1 = 6956042
style3dcolor2 = 6956042
style = 1
font = "frmMerch.frx":1606
picture = "frmMerch.frx":162A
End
Begin MySuperMarket.XButton cmdLast
Height = 300
Left = 6960
TabIndex = 6
Top = 690
Width = 300
_extentx = 529
_extenty = 529
caption = ""
mousedowncolor = 12363422
mouseoncolor = 14204854
stylecolor = 6956042
style3dcolor1 = 6956042
style3dcolor2 = 6956042
style = 1
font = "frmMerch.frx":1BC4
picture = "frmMerch.frx":1BE8
End
Begin MySuperMarket.XButton cmdPre
Height = 300
Left = 4920
TabIndex = 7
Top = 690
Width = 300
_extentx = 529
_extenty = 529
caption = ""
mousedowncolor = 12363422
mouseoncolor = 14204854
stylecolor = 6956042
style3dcolor1 = 6956042
style3dcolor2 = 6956042
style = 1
font = "frmMerch.frx":2182
picture = "frmMerch.frx":21A6
End
Begin MySuperMarket.XPButton cmdDel
Height = 345
Left = 2400
TabIndex = 8
Top = 660
Width = 975
_extentx = 1720
_extenty = 609
caption = "刪除(&D)"
capalign = 2
backstyle = 2
font = "frmMerch.frx":2740
mode = 0
value = 0 'False
cback = -2147483633
End
Begin MySuperMarket.XPButton cmdEdit
Height = 345
Left = 1320
TabIndex = 9
Top = 660
Width = 975
_extentx = 1720
_extenty = 609
caption = "修改(&E)"
capalign = 2
backstyle = 2
font = "frmMerch.frx":2764
mode = 0
value = 0 'False
cback = -2147483633
End
Begin MySuperMarket.XPButton cmdAdd
Height = 345
Left = 240
TabIndex = 10
Top = 660
Width = 975
_extentx = 1931
_extenty = 609
caption = "添加(&A)"
capalign = 2
backstyle = 2
font = "frmMerch.frx":2788
mode = 0
value = 0 'False
cback = -2147483633
End
End
Attribute VB_Name = "frmMerch"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim strCurSQL1 As String, strCurSQL2 As String, strCurSQL3 As String
Dim lngCurPageSize As Long
Dim NoChangeSQL As Boolean
Public xChangeItem As String
Private Sub cboFactory_Click()
ChangeSQL
End Sub
Private Sub ChangeSQL()
If NoChangeSQL Then Exit Sub
strCurSQL2 = "Where "
If cboFactory.ListIndex > 0 Then strCurSQL2 = strCurSQL2 & "FactoryName='" & cboFactory.Text & "' and "
If cboProvide.ListIndex > 0 Then strCurSQL2 = strCurSQL2 & "ProvideName='" & cboProvide.Text & "' and "
Select Case cboState.ListIndex
Case 1
strCurSQL2 = strCurSQL2 & "SalesProPrice is not null and SalesProDateS<='" & Date & "' and SalesProDateE>='" & Date & "' and "
Case 2
strCurSQL2 = strCurSQL2 & "MerchNum<=CautionNum and "
Case 3
strCurSQL2 = strCurSQL2 & "AllowSale=0 and "
End Select
LoadMerchSQL strCurSQL1 & strCurSQL2 & strCurSQL3, 1, lngCurPageSize
End Sub
Private Sub cboPage_Click()
If cboPage.Enabled = False Then Exit Sub
If cboPage.ListIndex = 0 Then
LoadMerchSQL strCurSQL1 & strCurSQL2 & strCurSQL3, 1
Else
LoadMerchSQL strCurSQL1 & strCurSQL2 & strCurSQL3, cboPage.ListIndex, lngCurPageSize
End If
End Sub
Private Sub cboProvide_Click()
ChangeSQL
End Sub
Private Sub cboState_Click()
ChangeSQL
End Sub
Private Sub cmdAdd_Click()
If lstFactory.ListCount <= 0 Or lstProvide.ListCount <= 0 Then
If MsgBox("添加商品之前，您必須分別擁有至少一個的廠商或供貨商。" & vbCrLf & vbCrLf & "現(xiàn)在馬上添加廠商或供貨商？", vbInformation + vbOKCancel) = vbOK Then
frmMain.cmdLeft_Click (4)
End If
Exit Sub
End If
xChangeItem = ""
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -