📄 frmzhaopinregister.frm
字号:
DataField = "健康状况"
DataSource = "Adodc1"
ForeColor = &H00FF0000&
Height = 285
Left = 3045
MaxLength = 10
TabIndex = 11
Top = 2160
Width = 1425
End
Begin VB.TextBox txt电话号码
BackColor = &H00C0FFFF&
DataField = "电话号码"
DataSource = "Adodc1"
ForeColor = &H00FF0000&
Height = 285
Left = 5640
MaxLength = 15
TabIndex = 7
Top = 960
Width = 1620
End
Begin VB.TextBox txt家庭住址
BackColor = &H00C0FFFF&
DataField = "家庭住址"
DataSource = "Adodc1"
ForeColor = &H00FF0000&
Height = 285
Left = 1125
MaxLength = 50
TabIndex = 6
Top = 960
Width = 3255
End
Begin VB.TextBox txt籍贯
BackColor = &H00C0FFFF&
DataField = "籍贯"
DataSource = "Adodc1"
ForeColor = &H00FF0000&
Height = 285
Left = 3510
MaxLength = 40
TabIndex = 4
Top = 360
Width = 2025
End
Begin VB.TextBox txt姓名
BackColor = &H00C0FFFF&
DataField = "姓名"
BeginProperty DataFormat
Type = 0
Format = "王王王王"
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
DataSource = "Adodc1"
ForeColor = &H00FF0000&
Height = 285
Left = 765
MaxLength = 8
TabIndex = 2
Top = 360
Width = 930
End
Begin MSMask.MaskEdBox msk出生年月
Bindings = "frmZhaopinRegister.frx":D512
BeginProperty DataFormat
Type = 0
Format = "yyyy-MM-dd"
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
Height = 285
Left = 1125
TabIndex = 10
Top = 2160
Width = 1215
_ExtentX = 2143
_ExtentY = 503
_Version = 393216
BackColor = 12648447
ForeColor = 16711680
AllowPrompt = -1 'True
MaxLength = 10
Mask = "####-##-##"
PromptChar = "_"
End
Begin VB.Label Label2
Caption = "双击此框打开选择表单"
ForeColor = &H00C00000&
Height = 240
Left = 1800
TabIndex = 61
Top = 3675
Width = 1815
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
Caption = "邮政编码"
ForeColor = &H00FF0000&
Height = 180
Index = 16
Left = 4680
TabIndex = 60
Top = 1605
Width = 720
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
Caption = "联络地址"
ForeColor = &H00FF0000&
Height = 180
Index = 15
Left = 285
TabIndex = 59
Top = 1575
Width = 720
End
Begin VB.Label lblFieldLabel
Caption = "文化程度"
ForeColor = &H00FF0000&
Height = 405
Index = 14
Left = 5625
TabIndex = 58
Top = 330
Width = 375
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
Caption = "担保人业务工号"
ForeColor = &H00FF0000&
Height = 180
Index = 9
Left = 225
TabIndex = 56
Top = 3405
Width = 1260
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
Caption = "担保人姓名"
ForeColor = &H00FF0000&
Height = 180
Index = 10
Left = 4065
TabIndex = 43
Top = 3405
Width = 900
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
Caption = "身份证号码"
ForeColor = &H00FF0000&
Height = 180
Index = 8
Left = 240
TabIndex = 42
Top = 2805
Width = 900
End
Begin VB.Label lblFieldLabel
Caption = "就业情况"
ForeColor = &H00FF0000&
Height = 405
Index = 7
Left = 4545
TabIndex = 41
Top = 2115
Width = 375
End
Begin VB.Label lblFieldLabel
Caption = "健康状况"
ForeColor = &H00FF0000&
Height = 405
Index = 6
Left = 2490
TabIndex = 40
Top = 2130
Width = 375
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
Caption = "出生年月"
ForeColor = &H00FF0000&
Height = 180
Index = 5
Left = 300
TabIndex = 39
Top = 2205
Width = 720
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
Caption = "电话号码"
ForeColor = &H00FF0000&
Height = 180
Index = 4
Left = 4695
TabIndex = 38
Top = 1005
Width = 720
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
Caption = "家庭住址"
ForeColor = &H00FF0000&
Height = 180
Index = 3
Left = 255
TabIndex = 37
Top = 960
Width = 720
End
Begin VB.Label lblFieldLabel
AutoSize = -1 'True
Caption = "籍贯"
ForeColor = &H00FF0000&
Height = 180
Index = 2
Left = 3045
TabIndex = 36
Top = 405
Width = 360
End
Begin VB.Label lblFieldLabel
AutoSize = -1 'True
Caption = "性别"
ForeColor = &H00FF0000&
Height = 180
Index = 1
Left = 1845
TabIndex = 35
Top = 405
Width = 360
End
Begin VB.Label lblFieldLabel
AutoSize = -1 'True
Caption = "姓名"
ForeColor = &H00FF0000&
Height = 180
Index = 0
Left = 300
TabIndex = 34
Top = 405
Width = 360
End
End
Begin VB.Frame Frame1
BackColor = &H00C0C0C0&
Height = 3975
Left = -74760
TabIndex = 32
Top = 480
Width = 7455
Begin VB.TextBox txt消费概况
BackColor = &H00C0FFFF&
DataField = "消费概况"
DataSource = "Adodc1"
ForeColor = &H00FF0000&
Height = 2925
Left = 1560
Locked = -1 'True
MultiLine = -1 'True
ScrollBars = 2 'Vertical
TabIndex = 29
Top = 480
Width = 5415
End
Begin VB.Label lblFieldLabel
Alignment = 1 'Right Justify
AutoSize = -1 'True
Caption = "消费概况:"
ForeColor = &H00FF0000&
Height = 255
Index = 13
Left = 480
TabIndex = 47
Top = 480
Width = 855
End
End
End
Begin VB.Label Label4
BackColor = &H00C0C0C0&
Caption = "核准工号"
ForeColor = &H00FF0000&
Height = 255
Left = 240
TabIndex = 57
Top = 795
Width = 735
End
Begin VB.Label Label3
BackColor = &H00C0C0C0&
Caption = "填表聘用日期"
ForeColor = &H00FF0000&
Height = 255
Left = 6720
TabIndex = 55
Top = 700
Width = 1215
End
Begin VB.Label Label1
Alignment = 2 'Center
BackColor = &H00C0C0C0&
Caption = "业务员招聘登记表"
BeginProperty Font
Name = "宋体"
Size = 21.75
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 495
Left = 2640
TabIndex = 0
Top = 120
Width = 3975
End
End
Attribute VB_Name = "frmZhaopinRegister"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim InputVar As Boolean
Dim AddNewOrModify As Boolean
Dim Sql As String
Sub LockedOrNo(InputVar As Boolean)
txt业务员工号.Locked = InputVar
txt姓名.Locked = InputVar
cob性别.Locked = InputVar
txt籍贯.Locked = InputVar
txt家庭住址.Locked = InputVar
txt电话号码.Locked = InputVar
txt联络地址.Locked = InputVar
txt邮政编码.Locked = InputVar
txt健康状况.Locked = InputVar
txt就业情况.Locked = InputVar
txt身份证号码.Locked = InputVar
cob文化程度.Locked = InputVar
txt担保人业务工号.Locked = InputVar
txt担保人姓名.Locked = InputVar
txt银行名称.Locked = InputVar
txt户口帐号.Locked = InputVar
cob存折种类.Locked = InputVar
cmdPicModify.Visible = Not InputVar
cmdPicSave.Visible = Not InputVar
txt消费概况.Locked = InputVar
msk填表聘用日期.Enabled = Not InputVar
msk出生年月.Enabled = Not InputVar
cmdFirst.Enabled = InputVar
cmdNext.Enabled = InputVar
cmdPrevious.Enabled = InputVar
cmdLast.Enabled = InputVar
cmdAddNew.Enabled = InputVar
cmdModify.Enabled = InputVar
cmdCancel.Enabled = Not InputVar
cmdSave.Enabled = Not InputVar
End Sub
Sub SaveRecordToYGZL(AddNewOrModify As Boolean)
Dim Sql As String
If AddNewOrModify = True Then
Adodc2.Recordset("工号") = txt业务员工号.Text
Adodc2.Recordset("姓名") = txt姓名.Text
Adodc2.Recordset("等级") = "D"
Adodc2.Recordset("担保人工号") = txt担保人业务工号.Text
Adodc2.Recordset("担保人姓名") = txt担保人姓名.Text
Adodc2.Recordset("原始担保人工号") = txt担保人业务工号.Text
Adodc2.Recordset("当月积分") = 0
Adodc2.Recordset("累计积分") = 0
Adodc2.Recordset("历史积分") = 0
Adodc2.Recordset("提成") = 0
Adodc2.Recordset("个人绩效奖") = 0
Adodc2.Recordset("网络绩效奖") = 0
Adodc2.Recordset("绩效奖系数") = 0
Adodc2.Recordset("伙食津贴") = 0
Adodc2.Recordset("差旅津贴") = 0
Adodc2.Recordset("应聘日期") = msk填表聘用日期.Text
Adodc2.Recordset("晋升日期") = msk填表聘用日期.Text
Adodc2.Recordset("A层次") = 0
'Adodc2.Recordset("B层次") = 0
Adodc2.Recordset("几线A") = 0
Adodc2.Recordset("结算日期") = msk填表聘用日期.Text
Adodc2.Recordset("是否初始化") = False
Adodc2.Recordset.Update
Else
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -