?? frmckd.frm
字號:
Caption = "領用部門"
Height = 255
Left = 0
TabIndex = 9
Top = 195
Width = 855
End
End
Begin VB.Frame Frame3
Height = 495
Left = 4050
TabIndex = 4
Top = 240
Width = 1935
Begin MSComCtl2.DTPicker DTPicker1
Height = 285
Left = 520
TabIndex = 5
Top = 150
Width = 1335
_ExtentX = 2355
_ExtentY = 503
_Version = 393216
Format = 58916865
CurrentDate = 36146
End
Begin VB.Label Label3
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "日期"
Height = 255
Left = 0
TabIndex = 6
Top = 195
Width = 495
End
Begin VB.Line Line4
BorderColor = &H80000003&
X1 = 465
X2 = 465
Y1 = 120
Y2 = 480
End
Begin VB.Line Line5
BorderColor = &H80000005&
X1 = 480
X2 = 480
Y1 = 120
Y2 = 600
End
End
Begin VB.Frame Frame8
Height = 495
Left = 7080
TabIndex = 1
Top = 240
Width = 2085
Begin VB.TextBox pdbh
Height = 300
Left = 880
Locked = -1 'True
TabIndex = 12
Top = 150
Width = 1125
End
Begin VB.Label Label8
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "憑單編號"
Height = 255
Left = 0
TabIndex = 3
Top = 225
Width = 855
End
Begin VB.Line Line14
BorderColor = &H80000003&
X1 = 825
X2 = 825
Y1 = 120
Y2 = 480
End
Begin VB.Line Line15
BorderColor = &H80000005&
X1 = 840
X2 = 840
Y1 = 120
Y2 = 600
End
End
Begin VB.Label Label5
Alignment = 2 'Center
ForeColor = &H00FF0000&
Height = 375
Left = 180
TabIndex = 36
Top = 3600
Width = 2895
End
End
Begin VB.Label Label1
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "出 庫 單"
BeginProperty Font
Name = "MS Sans Serif"
Size = 13.5
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 60
TabIndex = 10
Top = 30
Width = 9195
End
Begin VB.Line Line1
X1 = 2910
X2 = 6420
Y1 = 360
Y2 = 360
End
End
Attribute VB_Name = "FRMckd"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim pdbh1 As Long
Dim pdbh2 As Long
Dim StrFLG As Integer
Dim HJj As Double
Private Sub Command1_Click()
FRMrkd.PrintForm
'DataGrid1.Row = 5
'DataGrid1.Col = 0
'DataGrid1.Text = "1"
End Sub
Private Sub Command2_Click()
If YJBM = "服務管理部" And EJBM = "物資組" Then
For i = 0 To ListView1.ListItems.Count - 1
If ListView1.ListItems(i + 1).Selected = True Then
pdbh1 = ListView1.ListItems.Item(i + 1)
End If
Next
Adodc1.RecordSource = "select * from 出庫明細表 where 憑單編號=" & pdbh1 & ""
Adodc1.Refresh
If pdbh1 = 0 Then
MsgBox "請選擇要處理的單據！"
Exit Sub
End If
Sql = "select * from 出庫憑單表 where 憑單編號=" & pdbh1 & ""
Set rs = ConnWZ.Execute(Sql)
Combo1 = rs("接收部門")
DTPicker1.Value = rs("出庫日期")
pdbh = pdbh1
ComboZG = rs("主管")
JSRR = rs("經手人")
ComboZG.Enabled = False
Combo1.Enabled = False
JSRR.Enabled = False
DataGrid1.Columns("數量").Locked = True
DataGrid1.Columns("使用人").Locked = True
DataGrid1.Columns("領用類別").Locked = True
DataGrid1.Columns("領用類別").Button = False
Combo1.Locked = True
End If
ListView1.ListItems.Clear
StrFLG = 1
Me.Height = 4890
End Sub
Private Sub Command3_Click()
Me.Height = 6465
ListView1.ColumnHeaders.Add , , "憑單編號"
ListView1.ColumnHeaders.Add , , "領用部門"
Sql = "select * from 出庫憑單表 where 處理狀態='待處理' ORDER BY 憑單編號"
Set rs = ConnWZ.Execute(Sql)
j = rs.RecordCount
For i = 0 To rs.RecordCount - 1
If Not IsNull(rs("憑單編號")) Then ListView1.ListItems.Add , "g + " & i, Trim(rs("憑單編號"))
If Not IsNull(rs("接收部門")) Then ListView1.ListItems(i + 1).SubItems(1) = Trim(rs("接收部門"))
rs.MoveNext
Next
End Sub
Private Sub Command4_Click()
ListView1.ListItems.Clear
Me.Height = 4890
End Sub
Private Sub DataGrid1_AfterColEdit(ByVal ColIndex As Integer)
If YJBM = "服務管理部" And EJBM = "物資組" Then
If ColIndex = 7 Then
S = DataGrid1.Row
DataGrid1.Col = 7
DataGrid1.Row = S
sll = DataGrid1.Text
DataGrid1.Col = 8
DataGrid1.Row = S
djj = DataGrid1.Text
If IsNumeric(djj) = False Then
MsgBox "請輸入數字！"
DataGrid1.Col = 8
DataGrid1.Row = S
DataGrid1.Text = 0
DataGrid1.Col = 15
DataGrid1.Row = S
DataGrid1.Text = 0
Exit Sub
End If
DataGrid1.Col = 15
DataGrid1.Row = S
DataGrid1.Text = sll
DataGrid1.Col = 9
DataGrid1.Row = S
jje = djj * sll
DataGrid1.Text = jje
End If
End If
End Sub
Private Sub DataGrid1_AfterColUpdate(ByVal ColIndex As Integer)
If YJBM = "服務管理部" And EJBM = "物資組" Then
On Error Resume Next
If ColIndex = 1 Then
t = DataGrid1.Row
DataGrid1.Col = 1
DataGrid1.Row = t
bbh = Val(DataGrid1.Text)
If IsNumeric(bbh) = False Then
MsgBox "請輸入數字！"
DataGrid1.Col = 1
DataGrid1.Row = t
DataGrid1.Text = 0
Exit Sub
End If
Sql = "select * from 商品目錄表 where 商品編號=" & bbh & ""
Set rs = ConnWZ.Execute(Sql)
DataGrid1.Col = 2
DataGrid1.Row = t
DataGrid1.Text = Trim(rs("名稱"))
strmc = Trim(rs("名稱"))
DataGrid1.Col = 3
DataGrid1.Row = t
DataGrid1.Text = Trim(rs("大類"))
DataGrid1.Col = 4
DataGrid1.Row = t
DataGrid1.Text = Trim(rs("子類"))
DataGrid1.Col = 5
DataGrid1.Row = t
DataGrid1.Text = Trim(rs("計量單位"))
DataGrid1.Col = 6
DataGrid1.Row = t
DataGrid1.Text = Trim(rs("規格型號"))
DataGrid1.Col = 8
DataGrid1.Row = t
DataGrid1.Text = Trim(rs("單價"))
DataGrid1.Col = 7
DataGrid1.Row = t
ssl = DataGrid1.Text
DataGrid1.Col = 9
DataGrid1.Row = t
DataGrid1.Text = ssl * Val(Trim(rs("單價")))
W = DataGrid1.Row
DataGrid1.Col = 7
DataGrid1.Row = W
ssll = DataGrid1.Text
DataGrid1.Col = 15
DataGrid1.Row = S
DataGrid1.Text = ssll
If ssll = "" Then GoTo 1000
'報警
DataGrid1.Col = 1
DataGrid1.Row = t
bbh = Val(DataGrid1.Text)
SL = 0
sql1 = "select * from 入庫明細表 where 商品編號=" & bbh & ""
Set RsKCCKCX = ConnWZ.Execute(sql1)
Do While Not RsKCCKCX.EOF
SL = SL + Val(RsKCCKCX("數量"))
RsKCCKCX.MoveNext
Loop
sql1 = "select * from 出庫明細表 where 商品編號=" & bbh & ""
Set RsKCCKCX = ConnWZ.Execute(sql1)
Do While Not RsKCCKCX.EOF
SL = SL - Val(RsKCCKCX("數量"))
RsKCCKCX.MoveNext
Loop
If SL < Val(ssll) Then
MsgBox "庫存量只有" & SL & ". 無法出庫！"
DataGrid1.Col = 7
DataGrid1.Row = W
DataGrid1.Text = 0
End If
'顯示庫存量
1000: SL = 0
sql1 = "select * from 入庫明細表 where 商品編號=" & bbh & ""
Set RsKCCKCX = ConnWZ.Execute(sql1)
Do While Not RsKCCKCX.EOF
SL = SL + Val(RsKCCKCX("數量"))
RsKCCKCX.MoveNext
Loop
sql1 = "select * from 出庫明細表 where 商品編號=" & bbh & ""
Set RsKCCKCX = ConnWZ.Execute(sql1)
Do While Not RsKCCKCX.EOF
SL = SL - Val(RsKCCKCX("數量"))
RsKCCKCX.MoveNext
Loop
If SL = "" Then SL = 0
Label5 = strmc & "庫存量為:" & SL & ""
End If
If ColIndex = 7 Then
W = DataGrid1.Row
DataGrid1.Col = 7
DataGrid1.Row = W
ssll = DataGrid1.Text
If IsNumeric(ssll) = False Then
MsgBox "請輸入數字！"
DataGrid1.Col = 7
DataGrid1.Row = W
DataGrid1.Text = 0
DataGrid1.Col = 15
DataGrid1.Row = S
DataGrid1.Text = 0
Exit Sub
End If
DataGrid1.Col = 7
t = DataGrid1.Row
DataGrid1.Row = t
ssl = DataGrid1.Text
DataGrid1.Col = 8
DataGrid1.Row = t
ddj = DataGrid1.Text
DataGrid1.Col = 9
DataGrid1.Row = t
DataGrid1.Text = Val(ssl) * Val(ddj)
DataGrid1.Col = 15
DataGrid1.Row = S
DataGrid1.Text = ssll
t = DataGrid1.Row
DataGrid1.Col = 1
DataGrid1.Row = t
bbh = Val(DataGrid1.Text)
sql1 = "select * from 入庫明細表 where 商品編號=" & bbh & ""
Set RsKCCKCX = ConnWZ.Execute(sql1)
Do While Not RsKCCKCX.EOF
SL = SL + Val(RsKCCKCX("數量"))
RsKCCKCX.MoveNext
Loop
sql1 = "select * from 出庫明細表 where 商品編號=" & bbh & ""
Set RsKCCKCX = ConnWZ.Execute(sql1)
Do While Not RsKCCKCX.EOF
SL = SL - Val(RsKCCKCX("數量"))
RsKCCKCX.MoveNext
If SL < Val(ssll) Then
MsgBox "庫存量只有" & SL & ". 無法出庫！"
DataGrid1.Col = 7
DataGrid1.Row = W
DataGrid1.Text = 0
End If
End If
End If
End Sub
Private Sub DataGrid1_ButtonClick(ByVal ColIndex As Integer)
If ColIndex = 10 Then
List2.Move DataGrid1.Left + DataGrid1.Columns(10).Left + Frame1.Left, DataGrid1.Top + (DataGrid1.Row + 1) * (DataGrid1.RowHeight + 10) + DataGrid1.Columns(10).Top, DataGrid1.Columns(10).Width, List2.Height
List2.Visible = True
End If
End Sub
Private Sub DataGrid1_Click()
If YJBM = "服務管理部" And EJBM = "物資組" Then
Combo1.Enabled = False
pdbh.Enabled = False
DTPicker1.Enabled = False
If pdbh = "" Then
MsgBox "請先填寫憑單編號"
Exit Sub
End If
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -