?? kumanage.frm
字號:
VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form kumanage
BackColor = &H0080FF80&
Caption = "庫房管理"
ClientHeight = 7830
ClientLeft = 60
ClientTop = 345
ClientWidth = 11880
LinkTopic = "Form1"
MaxButton = 0 'False
ScaleHeight = 7830
ScaleWidth = 11880
WindowState = 2 'Maximized
Begin VB.Frame Frame3
BackColor = &H0080FF80&
Height = 1095
Left = 600
TabIndex = 3
Top = 6480
Width = 9255
Begin VB.CommandButton cmdexit
Caption = "退出"
Height = 375
Left = 7560
TabIndex = 8
Top = 480
Width = 975
End
Begin VB.CommandButton cmdcancel
Caption = "取消"
Height = 375
Left = 5880
TabIndex = 7
Top = 480
Width = 975
End
Begin VB.CommandButton cmddel
Caption = "刪除明細(xì)"
Height = 375
Left = 4200
TabIndex = 6
Top = 480
Width = 975
End
Begin VB.CommandButton cmdmodify
Caption = "修改明細(xì)"
Height = 375
Left = 2400
TabIndex = 5
Top = 480
Width = 975
End
Begin VB.CommandButton cmdadd
Caption = "增加明細(xì)"
Height = 375
Left = 480
TabIndex = 4
Top = 480
Width = 975
End
End
Begin VB.Frame Frame2
BackColor = &H0080FF80&
Caption = "貨物明細(xì)"
Height = 1815
Left = 600
TabIndex = 1
Top = 4560
Width = 10815
Begin VB.ComboBox Combo1
BackColor = &H0000FFFF&
Height = 300
Left = 120
TabIndex = 11
Text = "Combo1"
Top = 2280
Visible = 0 'False
Width = 1095
End
Begin VB.TextBox Text1
BackColor = &H0000FFFF&
Height = 525
Left = 0
TabIndex = 10
Top = 1560
Visible = 0 'False
Width = 975
End
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid2
Height = 2295
Left = 120
TabIndex = 9
Top = 240
Width = 10695
_ExtentX = 18865
_ExtentY = 4048
_Version = 393216
End
End
Begin VB.Frame Frame1
BackColor = &H0080FF80&
Caption = "進(jìn)出清單"
Height = 4215
Left = 600
TabIndex = 0
Top = 360
Width = 10815
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1
Height = 3735
Left = 120
TabIndex = 2
Top = 240
Width = 10695
_ExtentX = 18865
_ExtentY = 6588
_Version = 393216
End
End
End
Attribute VB_Name = "kumanage"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim rs_data2 As New ADODB.Recordset
Dim select_row As String
Dim showgrid2 As Boolean
Dim rs_custom As New ADODB.Recordset
Dim jinchu As String '入出庫標(biāo)志
Dim modify As Boolean '修改狀態(tài)標(biāo)志
Private Sub cmdadd_Click()
On Error GoTo adderror
Dim r As Integer
Dim i As Integer
If rs_data2.BOF = True Then
MsgBox "沒有明細(xì)記錄無法添加！", vbOKOnly
Exit Sub
ElseIf cmdadd.Caption = "增加明細(xì)" Then
cmdadd.Caption = "確定"
cmdexit.Enabled = False
cmdmodify.Enabled = False
cmddel.Enabled = False
cmdcancel.Enabled = True
Text1.Text = ""
With MSFlexGrid2
.Rows = rs_data2.RecordCount + 2
.Row = rs_data2.RecordCount + 1
.Col = 0
.Text = rs_data2.Fields("貨單號")
.Col = 1
.Text = rs_data2.Fields("日期")
.Col = 2
.Text = rs_data2.Fields("貨源地")
.Col = 3
End With
nextpos MSFlexGrid2.Row, MSFlexGrid2.Col
Else
rs_data2.AddNew
For i = 0 To 8
MSFlexGrid2.Col = i
If i = 4 Or i = 7 Then
If jinchu = "出庫" Then
rs_data2.Fields(i) = -CDbl(Trim(MSFlexGrid2.Text))
Else
rs_data2.Fields(i) = CDbl(Trim(MSFlexGrid2.Text))
End If
Else
rs_data2.Fields(i) = MSFlexGrid2.Text
End If
Next i
rs_data2.Update
MsgBox "增加信息成功！", vbOKOnly + vbExclamation, ""
cmdadd.Caption = "增加明細(xì)"
cmdmodify.Enabled = True
cmddel.Enabled = True
cmdexit.Enabled = True
cmdcancel.Enabled = False
Combo1.Visible = False
End If
Exit Sub
adderror:
MsgBox Err.Description
'End If
'End If
End Sub
Private Sub cmdcancel_Click()
If cmdadd.Caption = "確定" Then
cmdadd.Caption = "增加明細(xì)"
cmdmodify.Enabled = True
ElseIf cmdmodify.Caption = "確定" Then
cmdmodify.Caption = "修改明細(xì)"
cmdadd.Enabled = True
End If
Text1.Visible = False
cmddel.Enabled = True
cmdexit.Enabled = True
cmdcancel.Enabled = False
showdata
End Sub
Private Sub cmddel_Click()
Dim answer As String
Dim delete_row As String
Dim cmd As New Command
Dim sql As String
On Error GoTo delerror
Set cmd.ActiveConnection = conn
If rs_data2.BOF = True Then
MsgBox "已經(jīng)沒有明細(xì)記錄，只能刪除當(dāng)前進(jìn)出清單", vbOKOnly
delete_row = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 0)
sql = "Delete from 入出庫 where 貨單號 ='" & delete_row & "'"
cmd.CommandText = sql
cmd.Execute
Unload Me
Else
answer = MsgBox("確定要刪除嗎？", vbYesNo, "")
If answer = vbYes Then
delete_row = MSFlexGrid2.TextMatrix(MSFlexGrid2.Row, 3)
sql = "Delete from 貨物詳況 where 物品名稱 ='" & delete_row & "'"
cmd.CommandText = sql
cmd.Execute
MsgBox "成功刪除！", vbOKOnly + vbExclamation, ""
MSFlexGrid1_Click
Else
Exit Sub
End If
End If
Exit Sub
delerror:
MsgBox Err.Description
End Sub
Private Sub cmdexit_Click()
Unload Me
End Sub
Private Sub cmdmodify_Click()
On Error GoTo modifyerror
Dim i As Integer
Dim j As Integer
If rs_data2.BOF = True Then
MsgBox "沒有明細(xì)記錄無法修改！", vbOKOnly
Exit Sub
Else
If modify = False Then
MsgBox "無法修改,請選擇貨物!", vbOKOnly + vbExclamation, ""
Exit Sub
Else
If cmdmodify.Caption = "修改明細(xì)" Then
cmdmodify.Caption = "確定"
cmdexit.Enabled = False
cmdadd.Enabled = False
cmddel.Enabled = False
cmdcancel.Enabled = True
MSFlexGrid2.Row = 1
MSFlexGrid2.Col = 3
Text1.Text = MSFlexGrid2.Text
nextpos MSFlexGrid2.Row, MSFlexGrid2.Col
Else
MSFlexGrid2.Row = 1
For i = 0 To rs_data2.RecordCount - 1
MSFlexGrid2.Row = i + 1
For j = 0 To 8
MSFlexGrid2.Col = j
If j = 4 Or j = 7 Then
If jinchu = "出庫" Then
rs_data2.Fields(j) = -CDbl(Trim(MSFlexGrid2.Text))
Else
rs_data2.Fields(j) = CDbl(Trim(MSFlexGrid2.Text))
End If
Else
rs_data2.Fields(j) = MSFlexGrid2.Text
End If
Next j
Next i
rs_data2.Update
MsgBox "修改信息成功！", vbOKOnly + vbExclamation, ""
cmdmodify.Caption = "修改明細(xì)"
cmdadd.Enabled = True
cmddel.Enabled = True
cmdexit.Enabled = True
cmdcancel.Enabled = False
Combo1.Visible = False
Text1.Visible = False
End If
End If
End If
modifyerror:
If Err.Number <> 0 Then
MsgBox Err.Description
End If
End Sub
Private Sub Combo1_Click()
MSFlexGrid2.Text = Combo1.Text
Combo1.Visible = False
If MSFlexGrid2.Row <> MSFlexGrid2.Rows - 1 Then '如果不是最后一行
MSFlexGrid2.Row = MSFlexGrid2.Row + 1
MSFlexGrid2.Col = 3
nextpos MSFlexGrid2.Row, MSFlexGrid2.Col
End If
End Sub
Private Sub Combo1_KeyPress(KeyAscii As Integer)
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -