📄 frmfreight.frm
字号:
VERSION 5.00
Object = "{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0"; "FM20.DLL"
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Object = "{0ECD9B60-23AA-11D0-B351-00A0C9055D8E}#6.0#0"; "MSHFLXGD.OCX"
Begin VB.Form frmFreight
Caption = "仓库部分_合同信息"
ClientHeight = 9015
ClientLeft = 4065
ClientTop = 675
ClientWidth = 6885
ForeColor = &H80000008&
Icon = "frmFreight.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
ScaleHeight = 3244.265
ScaleMode = 0 'User
ScaleWidth = 6885
Begin VB.CommandButton cmdExit
Caption = "退出"
Height = 510
Left = 5040
Picture = "frmFreight.frx":08CA
Style = 1 'Graphical
TabIndex = 25
ToolTipText = "退出输入窗口"
Top = 45
Width = 525
End
Begin VB.CommandButton cmdNew
Caption = "增加"
Enabled = 0 'False
Height = 510
Left = 360
Picture = "frmFreight.frx":0C9D
Style = 1 'Graphical
TabIndex = 24
ToolTipText = "增加一条新记录"
Top = 45
Width = 525
End
Begin VB.CommandButton cmdDelete
Caption = "删除"
Enabled = 0 'False
Height = 510
Left = 1320
Picture = "frmFreight.frx":1267
Style = 1 'Graphical
TabIndex = 23
ToolTipText = "删除当前记录"
Top = 45
Width = 525
End
Begin VB.CommandButton cmdSave
Caption = "保存"
Enabled = 0 'False
Height = 510
Left = 1800
Picture = "frmFreight.frx":18FD
Style = 1 'Graphical
TabIndex = 22
ToolTipText = "保存输入内容"
Top = 45
Width = 525
End
Begin VB.CommandButton cmdCancel
Caption = "取消"
Height = 510
Left = 3360
Picture = "frmFreight.frx":1F93
Style = 1 'Graphical
TabIndex = 21
ToolTipText = "退出输入窗口"
Top = 45
Width = 525
End
Begin VB.CommandButton cmdEdit
Caption = "修改"
Enabled = 0 'False
Height = 510
Left = 840
Picture = "frmFreight.frx":255D
Style = 1 'Graphical
TabIndex = 20
ToolTipText = "修改当前记录"
Top = 45
Width = 525
End
Begin VB.CommandButton cmdView
Caption = "预览"
Enabled = 0 'False
Height = 510
Left = 3960
Picture = "frmFreight.frx":2B27
Style = 1 'Graphical
TabIndex = 19
ToolTipText = "预览报表"
Top = 45
Width = 525
End
Begin VB.CommandButton cmdPrint
Caption = "打印"
Enabled = 0 'False
Height = 510
Left = 4440
Picture = "frmFreight.frx":30F1
Style = 1 'Graphical
TabIndex = 18
ToolTipText = "打印报表"
Top = 45
Width = 525
End
Begin VB.CommandButton cmdSearch
Caption = "查询"
Enabled = 0 'False
Height = 510
Left = 2400
Picture = "frmFreight.frx":3787
Style = 1 'Graphical
TabIndex = 17
ToolTipText = "按条件查询单据"
Top = 45
Width = 525
End
Begin VB.CommandButton cmdtaxis
Caption = "排序"
Height = 510
Left = 2880
Picture = "frmFreight.frx":3D11
Style = 1 'Graphical
TabIndex = 16
ToolTipText = "退出输入窗口"
Top = 45
Width = 525
End
Begin VB.PictureBox axButton4
Height = 525
Left = 4920
ScaleHeight = 465
ScaleWidth = 45
TabIndex = 26
Top = 30
Width = 105
End
Begin VB.PictureBox axButton3
Height = 525
Left = 3840
ScaleHeight = 465
ScaleWidth = 45
TabIndex = 27
Top = 30
Width = 105
End
Begin VB.TextBox txtRow
Height = 300
Left = 6120
TabIndex = 12
Top = 105
Visible = 0 'False
Width = 330
End
Begin MSHierarchicalFlexGridLib.MSHFlexGrid MfgZY
Bindings = "frmFreight.frx":3E5B
Height = 5175
Left = 240
TabIndex = 0
Top = 720
Width = 6375
_ExtentX = 11245
_ExtentY = 9128
_Version = 393216
BackColor = -2147483628
Cols = 6
BackColorSel = 16752029
ForeColorSel = -2147483625
WordWrap = -1 'True
AllowBigSelection= 0 'False
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_NumberOfBands = 1
_Band(0).Cols = 6
_Band(0).GridLinesBand= 1
_Band(0).TextStyleBand= 0
_Band(0).TextStyleHeader= 0
_Band(0)._NumMapCols= 6
_Band(0)._MapCol(0)._Name= "CONTACT_ID"
_Band(0)._MapCol(0)._RSIndex= 0
_Band(0)._MapCol(0)._Alignment= 7
_Band(0)._MapCol(1)._Name= "CONSIG_NAME"
_Band(0)._MapCol(1)._RSIndex= 1
_Band(0)._MapCol(2)._Name= "IN_OUT"
_Band(0)._MapCol(2)._RSIndex= 2
_Band(0)._MapCol(3)._Name= "PERSON"
_Band(0)._MapCol(3)._RSIndex= 3
_Band(0)._MapCol(4)._Name= "START_DATE"
_Band(0)._MapCol(4)._RSIndex= 4
_Band(0)._MapCol(5)._Name= "PRICES"
_Band(0)._MapCol(5)._RSIndex= 5
_Band(0)._MapCol(5)._Alignment= 7
_Band(0)._MapCol(5)._Hidden= -1 'True
End
Begin VB.PictureBox axButton2
Enabled = 0 'False
ForeColor = &H80000011&
Height = 540
Index = 0
Left = 2280
ScaleHeight = 480
ScaleWidth = 60
TabIndex = 5
Top = 0
Width = 120
End
Begin VB.PictureBox axButton1
Enabled = 0 'False
Height = 705
Left = 240
ScaleHeight = 645
ScaleWidth = 6345
TabIndex = 6
Top = 0
Width = 6405
Begin VB.PictureBox axButton2
Enabled = 0 'False
ForeColor = &H80000011&
Height = 540
Index = 1
Left = 0
ScaleHeight = 480
ScaleWidth = 60
TabIndex = 29
Top = 0
Width = 120
End
End
Begin VB.Frame fra1
Caption = "合同管理"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 2055
Left = 240
TabIndex = 7
Top = 6840
Width = 6405
Begin VB.TextBox txtZY
Enabled = 0 'False
Height = 300
Index = 4
Left = 4680
MaxLength = 10
TabIndex = 4
Text = "linximing"
Top = 840
Width = 1320
End
Begin VB.TextBox txtZY
Enabled = 0 'False
Height = 300
Index = 6
Left = 4680
MaxLength = 9
TabIndex = 28
Text = "￥0.00"
Top = 1440
Visible = 0 'False
Width = 1335
End
Begin VB.TextBox txtZY
Enabled = 0 'False
Height = 300
Index = 2
Left = 4680
MaxLength = 10
TabIndex = 2
Top = 360
Width = 1320
End
Begin VB.TextBox txtZY
Enabled = 0 'False
Height = 300
Index = 1
Left = 1440
MaxLength = 8
TabIndex = 1
Top = 360
Width = 1575
End
Begin VB.TextBox txtZY
Enabled = 0 'False
Height = 300
Index = 3
Left = 1440
MaxLength = 1
TabIndex = 3
Top = 840
Width = 1545
End
Begin MSComCtl2.DTPicker DtpZZ
CausesValidation= 0 'False
Height = 300
Left = 1440
TabIndex = 13
Top = 1440
Visible = 0 'False
Width = 1800
_ExtentX = 3175
_ExtentY = 529
_Version = 393216
Enabled = 0 'False
CalendarBackColor= -2147483624
CalendarTitleBackColor= 32768
CalendarTitleForeColor= -2147483639
CalendarTrailingForeColor= 12632256
CheckBox = -1 'True
Format = 23789568
CurrentDate = 37642
End
Begin VB.TextBox txtZY
Enabled = 0 'False
Height = 300
Index = 5
Left = 1440
MaxLength = 50
TabIndex = 14
Top = 1440
Width = 1800
End
Begin VB.Label Label5
Caption = "总 收 费："
Height = 375
Left = 3480
TabIndex = 32
Top = 1440
Visible = 0 'False
Width = 1095
End
Begin VB.Label Label6
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "签 署 日 期："
Height = 255
Left = 0
TabIndex = 15
Top = 1440
Width = 1260
End
Begin VB.Label Label1
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "合 同 编 号："
Height = 255
Left = 0
TabIndex = 11
Top = 360
Width = 1260
End
Begin VB.Label Label2
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "委托者姓名："
Height = 255
Left = 3120
TabIndex = 10
Top = 360
Width = 1260
End
Begin VB.Label Label3
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "执 行 标 记："
Height = 255
Left = 0
TabIndex = 9
Top = 840
Width = 1260
End
Begin VB.Label Label4
Alignment = 1 'Right Justify
BackStyle = 0 'Transparent
Caption = "签署经手人："
Height = 255
Index = 0
Left = 3240
TabIndex = 8
Top = 840
Width = 1140
End
End
Begin MSForms.CommandButton Cmd2
Height = 585
Left = 3600
TabIndex = 31
Top = 6000
Width = 2865
VariousPropertyBits= 19
Caption = "办理出库"
PicturePosition = 524294
Size = "5054;1032"
Picture = "frmFreight.frx":3E70
FontName = "宋体"
FontEffects = 1073741825
FontHeight = 300
FontCharSet = 134
FontPitchAndFamily= 34
ParagraphAlign = 3
FontWeight = 700
End
Begin MSForms.CommandButton cmd1
Height = 585
Left = 240
TabIndex = 30
Top = 6000
Width = 2985
VariousPropertyBits= 19
Caption = "验收入库"
PicturePosition = 524294
Size = "5265;1032"
Picture = "frmFreight.frx":4325
FontName = "宋体"
FontEffects = 1073741825
FontHeight = 300
FontCharSet = 134
FontPitchAndFamily= 34
ParagraphAlign = 3
FontWeight = 700
End
End
Attribute VB_Name = "frmFreight"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private cnDB As New ADODB.Connection
Private rs As New ADODB.Recordset
Private ButtonStatus As String
Private Sub Cmd1_Click()
If txtZY(1).Text <> "" Then
con_id = txtZY(1).Text
Else
MsgBox "没有选中要登记货物的合同编号！请在表中选择！", vbInformation + vbOKOnly, "提示"
SetTextNull
If MfgZY.Rows >= 1 Then
SetButton True
Else
cmdNew.Enabled = True
End If
'cmdEdit.Enabled = False
'cmdDelete.Enabled = False
DtpZZ.Visible = False
txtZY(4).Enabled = True
MfgZY.Enabled = True
gTaxisSQL = ""
gQuerySQL = ""
Call SetFormData(SetSQL("", "")) '设置窗口显示数据
End If
Unload Me
frmWar_In.Show 1
End Sub
Private Sub Cmd2_Click()
If txtZY(1).Text <> "" Then
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -