?? 進(jìn)銷(xiāo)存管理系統(tǒng).frm
字號(hào):
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.MDIForm 進(jìn)銷(xiāo)存管理系統(tǒng)
BackColor = &H00C0C0FF&
Caption = "進(jìn)銷(xiāo)存管理系統(tǒng)"
ClientHeight = 5805
ClientLeft = 165
ClientTop = 855
ClientWidth = 7935
LinkTopic = "MDIForm1"
StartUpPosition = 3 'Windows Default
Begin MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 795
Left = 0
TabIndex = 0
Top = 0
Width = 7935
_ExtentX = 13996
_ExtentY = 1402
ButtonWidth = 1455
ButtonHeight = 1349
Style = 1
ImageList = "ImageList1"
HotImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 8
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "供應(yīng)商"
Key = "供應(yīng)商資料"
Object.ToolTipText = "供應(yīng)商資料"
ImageIndex = 1
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "客戶(hù)"
Key = "客戶(hù)資料"
Object.ToolTipText = "客戶(hù)資料"
ImageIndex = 2
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "商品"
Key = "商品資料"
Object.ToolTipText = "商品資料"
ImageIndex = 3
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "采購(gòu)單"
Key = "采購(gòu)單"
Object.ToolTipText = "采購(gòu)單"
ImageIndex = 4
EndProperty
BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "采購(gòu)入庫(kù)"
Key = "采購(gòu)入庫(kù)"
Object.ToolTipText = "采購(gòu)入庫(kù)"
ImageIndex = 5
EndProperty
BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "銷(xiāo)售單"
Key = "銷(xiāo)售單"
Object.ToolTipText = "銷(xiāo)售單"
ImageIndex = 6
EndProperty
BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "銷(xiāo)售出庫(kù)"
Key = "銷(xiāo)售出庫(kù)"
Object.ToolTipText = "銷(xiāo)售出庫(kù)"
ImageIndex = 7
EndProperty
BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "重新登錄"
Key = "重新登錄"
Object.ToolTipText = "重新登錄"
ImageIndex = 8
EndProperty
EndProperty
BorderStyle = 1
End
Begin MSComctlLib.ImageList ImageList1
Left = 0
Top = 840
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 32
ImageHeight = 32
MaskColor = 12632256
UseMaskColor = 0 'False
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 13
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "進(jìn)銷(xiāo)存管理系統(tǒng).frx":0000
Key = ""
Object.Tag = "1"
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "進(jìn)銷(xiāo)存管理系統(tǒng).frx":0854
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "進(jìn)銷(xiāo)存管理系統(tǒng).frx":1130
Key = ""
Object.Tag = "2"
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "進(jìn)銷(xiāo)存管理系統(tǒng).frx":1984
Key = ""
Object.Tag = "3"
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "進(jìn)銷(xiāo)存管理系統(tǒng).frx":21D8
Key = ""
Object.Tag = "5"
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "進(jìn)銷(xiāo)存管理系統(tǒng).frx":2A2C
Key = ""
Object.Tag = "6"
EndProperty
BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "進(jìn)銷(xiāo)存管理系統(tǒng).frx":3280
Key = ""
EndProperty
BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "進(jìn)銷(xiāo)存管理系統(tǒng).frx":3B5C
Key = ""
EndProperty
BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "進(jìn)銷(xiāo)存管理系統(tǒng).frx":4438
Key = ""
EndProperty
BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "進(jìn)銷(xiāo)存管理系統(tǒng).frx":4D14
Key = ""
EndProperty
BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "進(jìn)銷(xiāo)存管理系統(tǒng).frx":5030
Key = ""
EndProperty
BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "進(jìn)銷(xiāo)存管理系統(tǒng).frx":534C
Key = ""
EndProperty
BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "進(jìn)銷(xiāo)存管理系統(tǒng).frx":5668
Key = ""
EndProperty
EndProperty
End
Begin VB.Menu 資料管理
Caption = "【資料管理】"
Begin VB.Menu 供應(yīng)商資料
Caption = "供應(yīng)商資料"
End
Begin VB.Menu 商品資料
Caption = "商品資料"
End
Begin VB.Menu 客戶(hù)資料
Caption = "客戶(hù)資料"
End
End
Begin VB.Menu 采購(gòu)管理
Caption = "【采購(gòu)管理】"
Begin VB.Menu 采購(gòu)單
Caption = "采購(gòu)單"
End
Begin VB.Menu 采購(gòu)入庫(kù)
Caption = "采購(gòu)入庫(kù)"
End
Begin VB.Menu 采購(gòu)查詢(xún)
Caption = "采購(gòu)查詢(xún)"
End
End
Begin VB.Menu 銷(xiāo)售管理
Caption = "【銷(xiāo)售管理】"
Begin VB.Menu 銷(xiāo)售單
Caption = "銷(xiāo)售單"
End
Begin VB.Menu 銷(xiāo)售出庫(kù)
Caption = "銷(xiāo)售出庫(kù)"
End
Begin VB.Menu 銷(xiāo)售查詢(xún)
Caption = "銷(xiāo)售查詢(xún)"
End
End
Begin VB.Menu 庫(kù)存管理
Caption = "【庫(kù)存管理】"
Begin VB.Menu 庫(kù)存維護(hù)
Caption = "庫(kù)存維護(hù)"
End
Begin VB.Menu 價(jià)格管理
Caption = "價(jià)格管理"
End
Begin VB.Menu 庫(kù)存盤(pán)點(diǎn)
Caption = "庫(kù)存盤(pán)點(diǎn)"
End
End
Begin VB.Menu 統(tǒng)計(jì)分析
Caption = "【統(tǒng)計(jì)分析】"
Begin VB.Menu 采購(gòu)單分析
Caption = "采購(gòu)單分析"
End
Begin VB.Menu 銷(xiāo)售單分析
Caption = "銷(xiāo)售單分析"
End
Begin VB.Menu 銷(xiāo)售利潤(rùn)
Caption = "銷(xiāo)售利潤(rùn)"
End
End
Begin VB.Menu 系統(tǒng)管理
Caption = "【系統(tǒng)管理】"
Begin VB.Menu 用戶(hù)管理
Caption = "用戶(hù)管理"
End
Begin VB.Menu 密碼維護(hù)
Caption = "密碼維護(hù)"
End
Begin VB.Menu 重新登錄
Caption = "重新登錄"
End
Begin VB.Menu line
Caption = "-"
End
Begin VB.Menu 初期建賬
Caption = "初期建賬"
End
End
End
Attribute VB_Name = "進(jìn)銷(xiāo)存管理系統(tǒng)"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub MDIForm_Load()
Dim rst As ADODB.Recordset
Dim SQL As String
Dim msg As String
Dim rights As String '保存記錄中的權(quán)限值
'查找權(quán)限
SQL = " select 權(quán)限 from 用戶(hù)信息表 where 用戶(hù)ID='" & UserID & "'"
Set rst = SelectSQL(SQL, msg)
If rst.RecordCount > 0 Then
rights = Trim(rst.Fields(0))
rst.Close
Else
MsgBox ("沒(méi)有用戶(hù)信息！")
Exit Sub
End If
'設(shè)置權(quán)限
If InStr(rights, "資料管理") Then
資料管理.Enabled = True
Me.Toolbar1.Buttons(1).Enabled = True
Me.Toolbar1.Buttons(2).Enabled = True
Me.Toolbar1.Buttons(3).Enabled = True
Else
資料管理.Enabled = False
Me.Toolbar1.Buttons(1).Enabled = False
Me.Toolbar1.Buttons(2).Enabled = False
Me.Toolbar1.Buttons(3).Enabled = False
End If
If InStr(rights, "采購(gòu)管理") Then
采購(gòu)管理.Enabled = True
Me.Toolbar1.Buttons(4).Enabled = True
Me.Toolbar1.Buttons(5).Enabled = True
Else
采購(gòu)管理.Enabled = False
Me.Toolbar1.Buttons(4).Enabled = False
Me.Toolbar1.Buttons(5).Enabled = False
End If
If InStr(rights, "銷(xiāo)售管理") Then
銷(xiāo)售管理.Enabled = True
Me.Toolbar1.Buttons(6).Enabled = True
Me.Toolbar1.Buttons(7).Enabled = True
Else
銷(xiāo)售管理.Enabled = False
Me.Toolbar1.Buttons(6).Enabled = False
Me.Toolbar1.Buttons(7).Enabled = False
End If
庫(kù)存管理.Enabled = InStr(rights, "庫(kù)存管理")
統(tǒng)計(jì)分析.Enabled = InStr(rights, "統(tǒng)計(jì)分析")
用戶(hù)管理.Enabled = InStr(rights, "用戶(hù)管理")
End Sub
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Index
Case 1:
Call 供應(yīng)商資料_Click '調(diào)入供應(yīng)商資料
Case 2:
Call 客戶(hù)資料_Click '調(diào)入客戶(hù)資料
Case 3:
Call 商品資料_Click '調(diào)入商品資料
Case 4:
Call 采購(gòu)單_Click '調(diào)入采購(gòu)單
Case 5:
Call 采購(gòu)入庫(kù)_Click '調(diào)入采購(gòu)入庫(kù)
Case 6:
Call 銷(xiāo)售單_Click '調(diào)入銷(xiāo)售單
Case 7:
Call 銷(xiāo)售出庫(kù)_Click '調(diào)入銷(xiāo)售出庫(kù)
Case 8:
Call 重新登錄_Click '調(diào)入重新登錄
End Select
End Sub
Private Sub 供應(yīng)商資料_Click()
A供應(yīng)商資料.Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 商品資料_Click()
A商品資料.Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 客戶(hù)資料_Click()
A客戶(hù)資料.Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 采購(gòu)單_Click()
B采購(gòu)單.Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 采購(gòu)入庫(kù)_Click()
B采購(gòu)入庫(kù).Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 采購(gòu)查詢(xún)_Click()
B采購(gòu)查詢(xún).Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 銷(xiāo)售單_Click()
C銷(xiāo)售單.Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 銷(xiāo)售出庫(kù)_Click()
C銷(xiāo)售出庫(kù).Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 銷(xiāo)售查詢(xún)_Click()
C銷(xiāo)售查詢(xún).Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 庫(kù)存維護(hù)_Click()
D庫(kù)存維護(hù).Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 價(jià)格管理_Click()
D價(jià)格管理.Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 庫(kù)存盤(pán)點(diǎn)_Click()
D庫(kù)存盤(pán)點(diǎn).Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 采購(gòu)單分析_Click()
E采購(gòu)單分析.Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 銷(xiāo)售單分析_Click()
E銷(xiāo)售單分析.Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 銷(xiāo)售利潤(rùn)_Click()
E銷(xiāo)售利潤(rùn).Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 用戶(hù)管理_Click()
F用戶(hù)管理.Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 密碼維護(hù)_Click()
F密碼維護(hù).Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
Private Sub 重新登錄_Click()
F重新登錄.Show
Unload Me
End Sub
Private Sub 初期建賬_Click()
F初期建賬.Show
進(jìn)銷(xiāo)存管理系統(tǒng).Enabled = False
End Sub
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -