📄 frmhpck.frm
字号:
VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Object = "{6B7E6392-850A-101B-AFC0-4210102A8DA7}#1.3#0"; "COMCTL32.OCX"
Object = "{4406B9AC-521E-476B-AF25-3D2C36110576}#3.0#0"; "CommandSCE.ocx"
Begin VB.Form frmCKDCX
BorderStyle = 4 'Fixed ToolWindow
Caption = "货品出库"
ClientHeight = 5175
ClientLeft = 45
ClientTop = 285
ClientWidth = 9405
Icon = "frmHPCK.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 5175
ScaleWidth = 9405
ShowInTaskbar = 0 'False
StartUpPosition = 3 'Windows Default
Begin VB.TextBox TeJEHJ
Appearance = 0 'Flat
Height = 270
Left = 4410
TabIndex = 17
Top = 225
Width = 1035
End
Begin VB.TextBox CoCK
Appearance = 0 'Flat
Height = 270
Left = 7095
TabIndex = 16
Top = 1140
Width = 1350
End
Begin VB.TextBox TeCKDH
Appearance = 0 'Flat
Height = 270
Left = 1080
TabIndex = 7
Top = 765
Width = 1110
End
Begin VB.TextBox TeCKKH
Appearance = 0 'Flat
Height = 270
Left = 1080
TabIndex = 6
Top = 1125
Width = 2505
End
Begin VB.TextBox TeCGY
Appearance = 0 'Flat
Height = 270
Left = 7080
TabIndex = 5
Top = 765
Width = 1190
End
Begin VB.TextBox TeCKZT
Appearance = 0 'Flat
Height = 270
Left = 4725
TabIndex = 4
Top = 765
Width = 1035
End
Begin VB.TextBox TeCKRQ
Appearance = 0 'Flat
Height = 270
Left = 1350
TabIndex = 3
Top = 315
Width = 1275
End
Begin VB.TextBox TeJBR
Appearance = 0 'Flat
Height = 270
Left = 4725
TabIndex = 2
Top = 1125
Width = 1190
End
Begin VB.Data Data1
Caption = "Data1"
Connect = "Access"
DatabaseName = ""
DefaultCursorType= 0 'DefaultCursor
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Height = 345
Left = 2685
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = ""
Top = 3690
Width = 2505
End
Begin ComctlLib.StatusBar StatusBar1
Align = 2 'Align Bottom
Height = 330
Left = 0
TabIndex = 0
Top = 4845
Width = 9405
_ExtentX = 16589
_ExtentY = 582
SimpleText = ""
_Version = 327682
BeginProperty Panels {0713E89E-850A-101B-AFC0-4210102A8DA7}
NumPanels = 3
BeginProperty Panel1 {0713E89F-850A-101B-AFC0-4210102A8DA7}
Object.Width = 9349
MinWidth = 9349
TextSave = ""
Key = ""
Object.Tag = ""
EndProperty
BeginProperty Panel2 {0713E89F-850A-101B-AFC0-4210102A8DA7}
Style = 6
Alignment = 2
Object.Width = 2117
MinWidth = 2117
TextSave = "2004-8-30"
Key = ""
Object.Tag = ""
EndProperty
BeginProperty Panel3 {0713E89F-850A-101B-AFC0-4210102A8DA7}
Style = 5
Object.Width = 1764
MinWidth = 1764
TextSave = "20:35"
Key = ""
Object.Tag = ""
EndProperty
EndProperty
End
Begin MSDBGrid.DBGrid DBGrid1
Align = 2 'Align Bottom
Bindings = "frmHPCK.frx":058A
Height = 3270
Left = 0
OleObjectBlob = "frmHPCK.frx":059A
TabIndex = 1
Top = 1575
Width = 9405
End
Begin CSCommandSCE.CommandSCE CmOK
Height = 330
Left = 6720
TabIndex = 15
Top = 150
Width = 570
_ExtentX = 1005
_ExtentY = 582
IconAlign = 0
Icon = "frmHPCK.frx":0F40
Caption = "确 认"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin VB.Label Label1
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "金额合计："
Height = 285
Left = 3390
TabIndex = 18
Top = 300
Width = 1005
End
Begin VB.Label Label2
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "制单日期："
Height = 285
Left = 330
TabIndex = 14
Top = 405
Width = 1005
End
Begin VB.Label Label3
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "单 号："
Height = 285
Left = 105
TabIndex = 13
Top = 840
Width = 915
End
Begin VB.Label Label4
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "客 户："
Height = 285
Left = 105
TabIndex = 12
Top = 1185
Width = 915
End
Begin VB.Label Label5
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "状 态："
Height = 285
Left = 3705
TabIndex = 11
Top = 840
Width = 1005
End
Begin VB.Label Label6
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "出库仓："
Height = 285
Left = 6060
TabIndex = 10
Top = 1185
Width = 1005
End
Begin VB.Label Label7
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "仓管员："
Height = 285
Left = 6060
TabIndex = 9
Top = 840
Width = 1005
End
Begin VB.Label Label15
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "经办人："
Height = 285
Left = 3930
TabIndex = 8
Top = 1185
Width = 765
End
End
Attribute VB_Name = "frmCKDCX"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim DB As Database, Rs As Recordset
Dim SQL As String
Private Sub CmOK_Click()
Dim CKMXSQL As String
With FrmCKHP
.TeCKDH = TeCKDH
.TeCKRQ = TeCKRQ
.TeCKKH = TeCKKH
.TeCGY = TeCGY
.TeJBR = TeJBR
.CoCK = CoCK
.TeJEHJ = TeJEHJ
.TeCKZT = TeCKZT
End With
CKMXSQL = "select 序号,货品名称,货品规格,数量,单位,单价,金额,货品说明 from DH_HP出库单明细 WHERE 单号=" + "'" & TeCKDH + "'"
Set DB = OpenDatabase("D:\DBB\DATA.mdb")
Set Rs = DB.OpenRecordset(CKMXSQL)
Set FrmCKHP.Data1.Recordset = Rs
Unload Me
End Sub
Private Sub Form_Load()
SQL = "select 单号,制单日期,客户,经办人,仓管员,出库仓,金额合计,状态 from DH_HP出库单"
Set DB = OpenDatabase("D:\DBB\DATA.mdb")
Set Rs = DB.OpenRecordset(SQL)
Set Data1.Recordset = Rs
Data1.Visible = False
End Sub
'过滤Null类型数据
Function NoNull(xValue As Variant) As Variant
If IsNull(xValue) Then
NoNull = ""
Else
NoNull = xValue
End If
End Function
Private Sub DBGrid1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Dim i As Integer
SQL = "select 单号,制单日期,客户,经办人,仓管员,出库仓,金额合计,状态 from DH_HP出库单"
Set DB = OpenDatabase("D:\DBB\DATA.mdb")
Set Rs = DB.OpenRecordset(SQL)
Set Data1.Recordset = Rs
For i = 0 To DBGrid1.RowContaining(Y)
TeCKDH = Rs("单号")
TeCKKH = Rs("客户")
TeCKRQ = Rs("制单日期")
TeJBR = NoNull(Rs("经办人"))
TeCGY = NoNull(Rs("仓管员"))
CoCK = NoNull(Rs("出库仓"))
TeJEHJ = Rs("金额合计")
TeCKZT = NoNull(Rs("状态"))
Rs.MoveNext
Next i
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -