📄 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
Loop
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 + -