入库程序代码:
Private Sub asPopup3_Click(Cancel As Boolean)
If Val(Text1.Text) <= 0 Then
MsgBox "请输入入库数量!"
Exit Sub
End If
If DBCombo2.Text = "" Then
MsgBox "请选择入库材料名称!"
Exit Sub
End If
If DBCombo4.Text = "" Then
MsgBox "请选择经手人!"
Exit Sub
End If
Dim a As Integer
a = MsgBox("********你确定此操作吗?**********" & vbCrLf _
& "材料名称:" & DBCombo2.Text & vbCrLf _
& "原库存量:" & Label4.Caption & Label5.Caption & vbCrLf _
& "本次入库:" & Text1.Text & Label5.Caption & " 单价:" & Text2.Text & "元" & vbCrLf _
& "供应商:" & DBCombo3.Text & vbCrLf _
& "经手人:" & DBCombo4.Text & vbCrLf _
, vbExclamation + vbOKCancel + vbApplicationModal, "提示")
If a = 1 Then
Data5.Recordset.AddNew
Data5.Recordset("名称") = DBCombo2.Text
Data5.Recordset("供应商") = DBCombo3.Text
Data5.Recordset("数量") = Text1.Text
Data5.Recordset("单价") = Text2.Text
Data5.Recordset("经手") = DBCombo4.Text
Data5.Recordset("日期") = Date
Data5.Recordset("时间") = Time
Data5.UpdateRecord
Data5.Recordset.Bookmark = Data5.Recordset.LastModified
'************************
Data2.Recordset.Edit
Data2.Recordset("数量") = Val(Label4.Caption) + Val(Text1.Text)
Data2.Recordset.Update
MsgBox "入库成功!"
asPopup4.Enabled = True
End If
If a = 2 Then Exit Sub
End Sub
Private Sub asPopup4_Click(Cancel As Boolean)
DataReport1.Show
DataReport1.Sections(2).Controls("Label1").Caption = "入库单据"
DataReport1.Sections(2).Controls("Label2").Caption = CStr(DBCombo2.Text)
DataReport1.Sections(2).Controls("Label3").Caption = "数量:" & CStr(Text1.Text)
DataReport1.Sections(2).Controls("Label4").Caption = "供应商:" & CStr(DBCombo3.Text)
DataReport1.Sections(2).Controls("Label5").Caption = "单价:" & CStr(Text2.Text)
DataReport1.Sections(2).Controls("Label6").Caption = "经手人:" & CStr(DBCombo4.Text)
DataReport1.Sections(2).Controls("Label7").Caption = "时间:" & CStr(Date) & " " & CStr(Time) & " " & CStr(Data5.Recordset("ID"))
asPopup4.Enabled = False
End Sub
Private Sub DBCombo2_Click(Area As Integer)
If DBCombo1.Text = "" Then
MsgBox "请先选择类别!"
Exit Sub
End If
Dim SQL As String
SQL = "SELECT ID, 分类, 单位, 名称, 备注, 数量 FROM 库存材料表 WHERE 分类 = '" & CStr(DBCombo1.Text) & "'"
Data2.Visible = False
Data2.DatabaseName = App.Path & "\库存管理.mdb"
Data2.RecordSource = SQL
Data2.Refresh
DBCombo2.Refresh
Timer1.Enabled = True
Timer1.Interval = 2000
End Sub
Private Sub DBCombo3_Click(Area As Integer)
Timer2.Enabled = True
Timer2.Interval = 2000
End Sub
Private Sub DBCombo4_Click(Area As Integer)
Timer3.Enabled = True
Timer3.Interval = 2000
End Sub
Private Sub Form_Load()
MakeWindow Me
' AlwaysOnTop Me, True
Me.Top = MDIFrmMain.Height / 2 - Me.Height / 2 - 1000
Me.Left = MDIFrmMain.Width / 2 - Me.Width / 2
Data1.DatabaseName = App.Path & "\库存管理.mdb"
Data1.Connect = ";pwd=lee1012"
Data1.RecordSource = "材料分类表"
Data1.Refresh
Data1.Visible = False
Data2.DatabaseName = App.Path & "\库存管理.mdb"
Data2.Connect = ";pwd=lee1012"
Data2.RecordSource = "库存材料表"
Data2.Refresh
Data2.Visible = False
Data3.DatabaseName = App.Path & "\库存管理.mdb"
Data3.Connect = ";pwd=lee1012"
Data3.RecordSource = "供应商表"
Data3.Refresh
Data3.Visible = False
Data4.DatabaseName = App.Path & "\库存管理.mdb"
Data4.Connect = ";pwd=lee1012"
Data4.RecordSource = "员工表"
Data4.Refresh
Data4.Visible = False
Data5.DatabaseName = App.Path & "\库存管理.mdb"
Data5.Connect = ";pwd=lee1012"
Data5.RecordSource = "入库表"
Data5.Refresh
Data5.Visible = False
asPopup4.Enabled = False
End Sub
Private Sub Form_Unload(Cancel As Integer)
Dim MyStr As String
MyStr = "中央电大(麒麟分校2004春计算机班冯胜楠)设计,王老师指导"
MDIFrmMain.MovingText1.MsgChar = MyStr
End Sub
Private Sub imgTitleClose_Click()
Unload Me
End Sub
Private Sub imgTitleLeft_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
DoDrag Me
End Sub
Private Sub imgTitleMain_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
DoDrag Me
End Sub
Private Sub imgTitleMinimize_Click()
Me.WindowState = 1
End Sub
Private Sub imgTitleRight_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
DoDrag Me
End Sub
Private Sub lblTitle_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
DoDrag Me
End Sub
Private Sub Timer1_Timer()
Data2.Recordset.FindFirst "名称 ='" & DBCombo2.Text & "'"
If Data2.Recordset.NoMatch = True Then
MsgBox "Err", 0, "提示"
Timer1.Enabled = False
Exit Sub
Timer1.Enabled = False
End If
Label4.Caption = Data2.Recordset("数量")
Label5.Caption = Data2.Recordset("单位")
Timer1.Enabled = False
Dim MyStr As String
MyStr = CStr(DBCombo2.Text) & " 原库存量" & CStr(Label4.Caption) & CStr(Label5.Caption)
MDIFrmMain.MovingText1.MsgChar = MyStr
End Sub
Private Sub Timer2_Timer()
If DBCombo3.Text = "" Then
MsgBox "没有选择供应商!"
Timer2.Enabled = False
Exit Sub
End If
Data3.Recordset.FindFirst "名称 ='" & DBCombo3.Text & "'"
If Data3.Recordset.NoMatch = True Then
MsgBox "Err", 0, "提示"
Timer2.Enabled = False
Exit Sub
End If
Dim MyStr As String
MyStr = CStr(Data3.Recordset("名称")) & " 地址:" & CStr(Data3.Recordset("地址")) & " 联系人:" & CStr(Data3.Recordset("联系人")) & " 电话:" & CStr(Data3.Recordset("电话")) & " 备注:" & CStr(Data3.Recordset("备注"))
MDIFrmMain.MovingText1.MsgChar = MyStr
Timer2.Enabled = False
End Sub
Private Sub Timer3_Timer()
If DBCombo4.Text = "" Then
MsgBox "没有选择供应商!"
Timer3.Enabled = False
Exit Sub
End If
Data4.Recordset.FindFirst "姓名 ='" & DBCombo4.Text & "'"
If Data4.Recordset.NoMatch = True Then
MsgBox "Err", 0, "提示"
Timer3.Enabled = False
Exit Sub
End If
Dim MyStr As String
MyStr = CStr(Data4.Recordset("姓名")) & " 职务:" & CStr(Data4.Recordset("职务")) & " 电话:" & CStr(Data4.Recordset("电话"))
MDIFrmMain.MovingText1.MsgChar = MyStr
Timer2.Enabled = False
End Sub
评论0