Summary
This system chiefly accomplishes the stock managem
The Access 2000 that the system adopted among Micr
The keyword: the data base, SQL's language, vb6.0,
Warehouse management.
第三章 Visual Basic下的控件所实现的功能
1. Align属性定义工具条在窗体中的位置
第四章 系统总体规划
仓库管理系统
系统功能结构图
___ 主界面具体实现见下图
5.2基础资料设置的实现
图3
Option Explicit
Public LoginSucceeded As Boolean
'检查正确的密码
If txtPassword = Me.DCboUserName.BoundText
Else
Else
Option Explicit
Private rsSys As ADODB.Recordset
Private cmSys As ADODB.Command
Public Function connstring() As String
"Security Info=False;Data Source=" & App.Path
End Function
Private Sub MDIForm_Load()
Dim strSQL As String
'Dim rsSys As ADODB.Recordset
Dim Conjxc As ADODB.Connection
Set Conjxc = New ADODB.Connection
Conjxc.ConnectionString = connstring
Dim rsSys As ADODB.Recordset
Conjxc.Open 'adOpenDynamic, adLockOptimistic
Set rsSys = New ADODB.Recordset
'rsSys.MoveFirst
If rsSys!offline Then
Me.mnuAct_dj.Enabled = False
Me.mnuSql.Enabled = False
Me.mnuReport.Enabled = False
Me.mnuSys_trans.Enabled = False
Me.mnuSys_start.Enabled = True
Me.mnuSys_begqty.Enabled = True
Else
Me.mnuAct_dj.Enabled = True
Me.mnuSql.Enabled = True
Me.mnuReport.Enabled = True
Me.mnuSys_trans.Enabled = True
Me.mnuSys_start.Enabled = False
Me.mnuSys_begqty.Enabled = False
End If
'Set cmSys = New ADODB.Command
End Sub
'Private Sub MDIForm_Load()
'End Sub
Private Sub MDIForm_QueryUnload(Cancel As Integer,
Call mnuExit_Click
If intNumWindows > 0 Then
Cancel = True
End If
Set rsSys = Nothing
Set cmSys = Nothing
End Sub
Private Sub mnuEdit_other_Click()
FrmOtherEdit.Show
End Sub
Private Sub mnuEdit_ps_Click()
FrmPsEdit.Show
End Sub
Private Sub mnuEdit_sales_Click()
FrmSaleEdit.Show
End Sub
Private Sub mnuExit_Click()
If intNumWindows = 0 Then
Unload Me
Else
MsgBox "请关闭所有子程序后再关闭该主程序!", vbCritical, "提
End If
End Sub
Private Sub mnuRec_other_Click()
FrmOtherChk.Show
End Sub
Private Sub mnuRec_ps_Click()
FrmPsChk.Show
End Sub
Private Sub mnuRec_sales_Click()
FrmSaleChk.Show
End Sub
Private Sub mnuReport_DetailUse_Click()
FrmRptDetUse.Show
End Sub
Private Sub mnuReport_Mat_Click()
FrmRptMat.Show
End Sub
Private Sub mnuReport_TotalUse_Click()
FrmRptTotUse.Show
End Sub
Private Sub mnuReport_TotalYearUse_Click()
FrmRptYearUse.Show
End Sub
Private Sub mnuSet_department_Click()
FrmSetDep.Show
End Sub
Private Sub mnuSet_employee_Click()
FrmSetEmp.Show
End Sub
Private Sub mnuSet_product_Click()
FrmSetPro.Show
End Sub
Private Sub mnuSet_protype_Click()
FrmSetPrTy.Show
End Sub
Private Sub mnuSet_supplier_Click()
FrmSetSup.Show
End Sub
Private Sub mnuSql_djother_Click()
FrmOtherSql.Show
End Sub
Private Sub mnuSql_djps_Click()
FrmPsSql.Show
End Sub
Private Sub mnuSql_djsales_Click()
FrmSaleSql.Show
End Sub
Private Sub mnuSys_begqty_Click()
FrmSetMattmp.Show
End Sub
Private Sub mnuSys_delete_Click()
Dim intDel As Integer
Dim strSQL As String
If intDel = vbYes Then
MsgBox "资料删除完毕!", vbInformation, "资料删除"
End If
Me.mnuAct_dj.Enabled = False
Me.mnuSql.Enabled = False
Me.mnuReport.Enabled = False
Me.mnuSys_trans.Enabled = False
Me.mnuSys_start.Enabled = True
Me.mnuSys_begqty.Enabled = True
End Sub
Private Sub mnuSys_start_Click()
Dim strBeg As String
Dim strYear, strMonth As String
Dim strSQL As String
If IsDate(strBeg) Then
Me.mnuAct_dj.Enabled = True
Me.mnuSql.Enabled = True
Me.mnuReport.Enabled = True
Me.mnuSys_trans.Enabled = True
Me.mnuSys_start.Enabled = False
MsgBox "系统已正式启用!", vbInformation, "系统启用"
Else
MsgBox "日期格式错误!", vbCritical, "启用错误"
Exit Sub
End If
End Sub
Private Sub mnuSys_trans_Click()
Dim strBeg As String
Dim strYear, strMonth As String
Dim strSQL As String
If IsDate(strBeg) Then
Set rsSys = New ADODB.Recordset
" price" & strYear & strMonth & "=pric
MsgBox "月份结转完毕!", vbInformation, "月终结转
Else
MsgBox "该月份已经月终结转!", vbCritical, "月终结转
End If
Else
MsgBox "日期格式错误!", vbCritical, "启用错误"
Exit Sub
End If
End Sub
Private Sub mnuSys_user_Click()
FrmSetUser.Show
End Sub
BOOK THIRD.--IN THE YEAR 1817
MM.
BOOK SIXTH.--LE PETIT-PICPUS
BOOK FIRST.-WATERLOO
BOOK EIGHTH.--THE WICKED POOR MAN
MARINGO
AUSTERLITS
GOD; THE KING; HONOR AND THE LADIES; BY DUCRAY D