📄 frmcargo.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.Form frmCargo
BorderStyle = 3 'Fixed Dialog
Caption = "商品信息"
ClientHeight = 4380
ClientLeft = 45
ClientTop = 330
ClientWidth = 7605
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 4380
ScaleWidth = 7605
ShowInTaskbar = 0 'False
StartUpPosition = 3 '窗口缺省
Begin VB.Frame Frame1
Height = 3645
Left = 60
TabIndex = 0
Top = 630
Width = 7455
Begin VB.PictureBox ptcPicture
Height = 1665
Left = 3720
ScaleHeight = 1605
ScaleWidth = 3435
TabIndex = 26
Top = 180
Width = 3495
End
Begin VB.TextBox txtNeapStock
Height = 315
Left = 4830
TabIndex = 25
Top = 3150
Width = 1995
End
Begin VB.TextBox txtTopStock
Height = 315
Left = 1230
TabIndex = 23
Top = 3150
Width = 1995
End
Begin VB.TextBox txtJobPrice
Height = 315
Left = 4830
TabIndex = 21
Top = 2730
Width = 1995
End
Begin VB.TextBox txtCostPrice
Height = 315
Left = 1230
TabIndex = 19
Top = 2730
Width = 1995
End
Begin VB.TextBox txtRetailPrice
Height = 315
Left = 4830
TabIndex = 17
Top = 2340
Width = 1995
End
Begin VB.ComboBox cboColor
Height = 300
Left = 1230
TabIndex = 15
Top = 2340
Width = 1995
End
Begin VB.ComboBox cboUnit
Height = 300
Left = 4830
TabIndex = 13
Top = 1920
Width = 1995
End
Begin VB.ComboBox cboGoodsSmallTypeID
Height = 300
Left = 1230
Style = 2 'Dropdown List
TabIndex = 11
Top = 1920
Width = 1995
End
Begin VB.ComboBox cboGoodsBigTypeID
Height = 300
Left = 1230
Style = 2 'Dropdown List
TabIndex = 9
Top = 1500
Width = 1995
End
Begin VB.ComboBox cboGoodsBandID
Height = 300
Left = 1230
Style = 2 'Dropdown List
TabIndex = 7
Top = 1080
Width = 1995
End
Begin VB.TextBox txtCargoName
Height = 315
Left = 1230
TabIndex = 5
Top = 660
Width = 1995
End
Begin VB.TextBox txtCargoID
Height = 315
Left = 1230
TabIndex = 1
Top = 240
Width = 1995
End
Begin VB.Label Label12
Caption = "最低库存："
Height = 225
Left = 3780
TabIndex = 24
Top = 3195
Width = 945
End
Begin VB.Label Label11
Caption = "最高库存："
Height = 225
Left = 270
TabIndex = 22
Top = 3195
Width = 945
End
Begin VB.Label Label10
Caption = "批发单价："
Height = 225
Left = 3780
TabIndex = 20
Top = 2775
Width = 945
End
Begin VB.Label Label9
Caption = "成本单价："
Height = 225
Left = 270
TabIndex = 18
Top = 2775
Width = 945
End
Begin VB.Label Label8
Caption = "零销单价："
Height = 225
Left = 3780
TabIndex = 16
Top = 2378
Width = 945
End
Begin VB.Label Label7
Caption = "颜色："
Height = 225
Left = 270
TabIndex = 14
Top = 2378
Width = 945
End
Begin VB.Label Label6
Caption = "单位："
Height = 225
Left = 3780
TabIndex = 12
Top = 1958
Width = 945
End
Begin VB.Label Label5
Caption = "小类编号："
Height = 225
Left = 270
TabIndex = 10
Top = 1958
Width = 945
End
Begin VB.Label Label4
Caption = "大类编号："
Height = 225
Left = 270
TabIndex = 8
Top = 1538
Width = 945
End
Begin VB.Label Label3
Caption = "品牌代码："
Height = 225
Left = 270
TabIndex = 6
Top = 1118
Width = 945
End
Begin VB.Label Label2
Caption = "商品名称："
Height = 225
Left = 270
TabIndex = 4
Top = 705
Width = 945
End
Begin VB.Label Label1
Caption = "商品编号："
Height = 225
Left = 270
TabIndex = 2
Top = 285
Width = 945
End
End
Begin MSComctlLib.ImageList ImgOperation
Left = 5880
Top = 60
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 19
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":0000
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":5F42
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":6C1C
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":8926
Key = ""
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":94F8
Key = ""
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":C202
Key = ""
EndProperty
BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":C51C
Key = ""
EndProperty
BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":C96E
Key = ""
EndProperty
BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":10330
Key = ""
EndProperty
BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":108CA
Key = ""
EndProperty
BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":10E64
Key = ""
EndProperty
BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":1173E
Key = ""
EndProperty
BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":11898
Key = ""
EndProperty
BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":11C32
Key = ""
EndProperty
BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":11FCC
Key = ""
EndProperty
BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":12366
Key = ""
EndProperty
BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":12700
Key = ""
EndProperty
BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":12A1A
Key = ""
EndProperty
BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "frmCargo.frx":132F4
Key = ""
EndProperty
EndProperty
End
Begin MSComctlLib.Toolbar tlbOperate
Height = 540
Left = 0
TabIndex = 3
Top = 0
Width = 7530
_ExtentX = 13282
_ExtentY = 953
ButtonWidth = 820
ButtonHeight = 953
AllowCustomize = 0 'False
Wrappable = 0 'False
Style = 1
ImageList = "ImgOperation"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 12
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "新增"
Style = 3
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "保存"
Key = "update"
Object.ToolTipText = "保存"
ImageIndex = 9
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "撤消"
Key = "cancel"
ImageIndex = 10
EndProperty
BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "首页"
Key = "first"
ImageIndex = 13
EndProperty
BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "前页"
Key = "prev"
ImageIndex = 14
EndProperty
BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "下页"
Key = "next"
ImageIndex = 15
EndProperty
BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "末页"
Key = "last"
ImageIndex = 16
EndProperty
BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "关闭"
Key = "quit"
Object.ToolTipText = "关闭"
ImageIndex = 19
EndProperty
BeginProperty Button12 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
EndProperty
End
End
Attribute VB_Name = "frmCargo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public P_SID As String
Private Sub cboGoodsSmallTypeID_Click()
Dim sql As String
Dim Ars As New ADODB.Recordset
If Trim(cboGoodsBigTypeID.Text) <> "" Then
sql = "Select GoodsSmallTypeID from GoodsSmallGenus Where GoodsBigTypeID='" & Trim(cboGoodsBigTypeID.Text) & "'"
Set Ars = SQLDB.Execute(sql)
Do While Not Ars.EOF
cboGoodsSmallTypeID.AddItem Ars("GoodsSmallTypeID")
Ars.MoveNext
cboGoodsSmallTypeID.ListIndex = 0
Loop
End If
End Sub
Private Sub Form_Load()
Dim sql As String
Dim Ars As New ADODB.Recordset
'初使化下拉框
Initcbo
'显示数据
If P_SID <> "" Then
sql = "Select * from Cargo Where CargoID='" & P_SID & "'"
Set Ars = SQLDB.Execute(sql)
If Not Ars.EOF Then
txtCargoID.Text = Ars("CargoID")
txtCargoName.Text = Ars("CargoName")
cboGoodsBandID.ListIndex = getComIndex(cboGoodsBandID, Ars("GoodsBandID"))
cboGoodsBigTypeID.ListIndex = getComIndex(cboGoodsBigTypeID, Ars("GoodsBigTypeID"))
cboGoodsSmallTypeID.ListIndex = getComIndex(cboGoodsSmallTypeID, Ars("GoodsSmallTypeID"))
cboUnit.ListIndex = getComIndex(cboUnit, Ars("Unit"))
cboColor.ListIndex = getComIndex(cboColor, Ars("Color"))
txtRetailPrice.Text = Ars("RetailPrice")
txtCostPrice.Text = Ars("CostPrice")
txtJobPrice.Text = Ars("JobPrice")
txtTopStock.Text = Ars("TopStock")
txtNeapStock.Text = Ars("NeapStock")
End If
End If
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -