📄 frm_customer_riches_edit.frm
字号:
Top = 2880
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "印刷颜色"
ForeColor = &H00000000&
Height = 180
Index = 8
Left = 5960
TabIndex = 68
Top = 3240
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "复制要求"
Height = 180
Index = 11
Left = 680
TabIndex = 67
Top = 2520
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "品质要求"
Height = 180
Index = 12
Left = 680
TabIndex = 66
Top = 2880
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "包装方式"
ForeColor = &H00000000&
Height = 180
Index = 15
Left = 5955
TabIndex = 65
Top = 3600
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "信息完整"
ForeColor = &H00000000&
Height = 180
Index = 18
Left = 680
TabIndex = 64
Top = 1800
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "质量等级"
ForeColor = &H00000000&
Height = 180
Index = 19
Left = 680
TabIndex = 63
Top = 2160
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "节目源种类"
Height = 180
Index = 20
Left = 5780
TabIndex = 62
Top = 720
Width = 900
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "菲林索引"
ForeColor = &H00000000&
Height = 180
Index = 22
Left = 5960
TabIndex = 61
Top = 2160
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "印刷参照"
Height = 180
Index = 27
Left = 5960
TabIndex = 60
Top = 2520
Width = 720
End
Begin VB.Label Label3
AutoSize = -1 'True
Caption = "地区名称"
Height = 180
Left = 680
TabIndex = 59
Top = 720
Width = 720
End
Begin VB.Label Label4
AutoSize = -1 'True
Caption = "客户编码"
Height = 180
Left = 680
TabIndex = 58
Top = 1080
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "母盘刻字要求"
Height = 180
Index = 5
Left = 370
TabIndex = 57
Top = 3960
Width = 1080
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "节目种类"
ForeColor = &H00000000&
Height = 180
Index = 21
Left = 5960
TabIndex = 56
Top = 1080
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "委托书编码"
ForeColor = &H00000000&
Height = 180
Index = 10
Left = 5775
TabIndex = 55
Top = 4320
Width = 900
End
Begin VB.Label Label2
AutoSize = -1 'True
Caption = "地区编码"
Height = 180
Left = 680
TabIndex = 54
Top = 360
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "印刷要求"
Height = 180
Index = 13
Left = 680
TabIndex = 53
Top = 3240
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "包装要求"
Height = 180
Index = 14
Left = 680
TabIndex = 52
Top = 3600
Width = 720
End
End
Begin MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 555
Left = 0
TabIndex = 38
Top = 0
Width = 11265
_ExtentX = 19870
_ExtentY = 979
ButtonWidth = 2090
ButtonHeight = 926
Appearance = 1
Style = 1
ImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 9
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "第一条记录"
Object.ToolTipText = "第一条记录"
ImageIndex = 1
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "前一条记录"
Object.ToolTipText = "前一条记录"
ImageIndex = 2
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "后一条记录"
Object.ToolTipText = "后一条记录"
ImageIndex = 3
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "最后一条记录"
Object.ToolTipText = "最后一条记录"
ImageIndex = 4
EndProperty
BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "添加(Add)"
Object.ToolTipText = "添加此客户新的财产"
ImageIndex = 5
EndProperty
BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "保存(Save)"
Object.ToolTipText = "保存现操作的客户财产"
ImageIndex = 6
EndProperty
BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "取消(Cancle)"
Object.ToolTipText = "取消此次操作"
ImageIndex = 7
EndProperty
BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "退出(Exit)"
Object.ToolTipText = "退出客户财产编辑"
ImageIndex = 8
EndProperty
EndProperty
End
End
Attribute VB_Name = "Frm_Customer_Riches_Edit"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim M_Repair_Information As Boolean
Dim M_Repair_QualityLevel As Boolean
Dim M_Repair_CopyRequest As Boolean
Dim M_Repair_QualityRequest As Boolean
Dim M_Repair_LiaoHao As Boolean
Dim M_Repair_ArtName As Boolean
Dim M_Repair_StemperNumber As Boolean
Dim M_Repair_ArtFuntainKind As Boolean
Dim M_Repair_ArtKind As Boolean
Dim M_Repair_StemperLetteringRequest As Boolean
Dim M_Repair_ChiselSpeed As Boolean
Dim M_Repair_StemperInHold As Boolean
Dim M_Repair_FeilinIndex As Boolean
Dim M_Repair_PressConsult As Boolean
Dim M_Repair_PressMode As Boolean
Dim M_Repair_PressColor As Boolean
Dim M_Repair_CommissionNumber As Boolean
Dim M_Repair_PressRequest As Boolean
Dim M_Repair_PackRequest As Boolean
Dim M_Repair_PackMode As Boolean
Dim M_Repair_Press_In_Hold As Boolean
Dim Q_Repair_Stemper_Amount As Boolean
Dim Q_Repair_Art_Fountain_State As Boolean
Dim Q_Repair_Feilin_State As Boolean
Dim Q_Repair_Store_Code As Boolean
Dim Q_Repair_Memo As Boolean
Dim S_Repair_Press_Machine_code As Boolean
Dim S_Repair_Edition_State As Boolean
Dim S_Repair_Expert_Color_ink As Boolean
Dim S_Repair_Color_Stylebook As Boolean
Dim S_Repair_Badness_Rate As Boolean
Dim S_Repair_Remain_Good_Count As Boolean
Dim S_Repair_3000 As Boolean
Private Sub Area_Customer_Info()
On Error GoTo err
Set Cn_Area = New ADODB.Connection
Cn_Area.Open Cs
Set Rs_Area = New ADODB.Recordset
Rs_Area.Open "select * from Area_Customer where 客户编码 ='" & Left(AreaCustomer_Key, 5) & "'order by 地区编码,客户编码", Cn_Area, adOpenKeyset, adLockOptimistic, adCmdText
If Rs_Area.RecordCount <> 0 Then
If IsNull(Rs_Area!地区编码) = False Then Me.txt_M_Fields(0).text = Rs_Area!地区编码
If IsNull(Rs_Area!地区名称) = False Then Me.txt_M_Fields(1).text = Rs_Area!地区名称
If IsNull(Rs_Area!客户编码) = False Then Me.txt_M_Fields(2).text = Rs_Area!客户编码
If IsNull(Rs_Area!客户名称) = False Then Me.txt_M_Fields(3).text = Rs_Area!客户名称
End If
Rs_Area.Close
Cn_Area.Close
Me.txt_M_Fields(0).Enabled = False
Me.txt_M_Fields(1).Enabled = False
Me.txt_M_Fields(2).Enabled = False
Me.txt_M_Fields(3).Enabled = False
Me.txt_M_Fields(6).Enabled = False
' Me.txt_M_Fields(10).Enabled = False
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub Customer_Riches_info()
On Error GoTo err
'营销部录入部份
If IsNull(Rs_CR!信息完整) = False Then Me.cob_M_Fields(0).text = Rs_CR!信息完整 Else Me.cob_M_Fields(0).text = ""
If IsNull(Rs_CR!质量等级) = False Then Me.cob_M_Fields(1).text = Rs_CR!质量等级 Else Me.cob_M_Fields(1).text = ""
If IsNull(Rs_CR!复制要求) = False Then Me.txt_M_Fields(4).text = Rs_CR!复制要求 Else Me.txt_M_Fields(4).text = ""
If IsNull(Rs_CR!品质要求) = False Then Me.txt_M_Fields(5).text = Rs_CR!品质要求 Else Me.txt_M_Fields(5).text = ""
If IsNull(Rs_CR!内编码) = False Then Me.txt_M_Fields(6).text = Rs_CR!内编码 Else Me.txt_M_Fields(6).text = ""
If IsNull(Rs_CR!料号) = False Then Me.txt_M_Fields(13).text = Rs_CR!料号 Else Me.txt_M_Fields(13).text = ""
If IsNull(Rs_CR!节目名称) = False Then Me.txt_M_Fields(7).text = Rs_CR!节目名称 Else Me.txt_M_Fields(7).text = ""
If IsNull(Rs_CR!母盘号码) = False Then Me.txt_M_Fields(8).text = Rs_CR!母盘号码 Else Me.txt_M_Fields(8).text = ""
If IsNull(Rs_CR!节目源种类) = False Then Me.cob_M_Fields(2).text = Rs_CR!节目源种类 Else Me.cob_M_Fields(2).text = ""
If IsNull(Rs_CR!节目种类) = False Then Me.cob_M_Fields(3).text = Rs_CR!节目种类 Else Me.cob_M_Fields(3).text = ""
If IsNull(Rs_CR!母盘刻字要求) = False Then Me.txt_M_Fields(9).text = Rs_CR!母盘刻字要求 Else Me.txt_M_Fields(9).text = ""
If IsNull(Rs_CR!刻录速度) = False Then Me.cob_M_Fields(4).text = Rs_CR!刻录速度 Else Me.cob_M_Fields(4).text = ""
If IsNull(Rs_CR!母盘内孔) = False Then Me.cob_M_Fields(5).text = Rs_CR!母盘内孔 Else Me.cob_M_Fields(5).text = ""
If IsNull(Rs_CR!菲林索引) = False Then Me.txt_M_Fields(10).text = Rs_CR!菲林索引 Else Me.txt_M_Fields(10).text = ""
If IsNull(Rs_CR!印刷参照) = False Then Me.cob_M_Fields(6).text = Rs_CR!印刷参照 Else Me.cob_M_Fields(6).text = ""
If IsNull(Rs_CR!印刷方式) = False Then Me.cob_M_Fields(7).text = Rs_CR!印刷方式 Else Me.cob_M_Fields(7).text = ""
If IsNull(Rs_CR!印刷颜色) = False Then Me.cob_M_Fields(8).text = Rs_CR!印刷颜色 Else Me.cob_M_Fields(8).text = ""
If IsNull(Rs_CR!委托书编码) = False Then Me.cob_M_Fields(9).text = Rs_CR!委托书编码 Else Me.cob_M_Fields(9).text = ""
If IsNull(Rs_CR!印刷要求) = False Then Me.txt_M_Fields(11).text = Rs_CR!印刷要求 Else Me.txt_M_Fields(11).text = ""
If IsNull(Rs_CR!包装要求) = False Then Me.txt_M_Fields(12).text = Rs_CR!包装要求 Else Me.txt_M_Fields(12).text = ""
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -