📄 fzkhadd.frm
字号:
Height = 195
Index = 12
Left = 8460
TabIndex = 38
Top = 840
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "职务："
Height = 180
Index = 11
Left = 4440
TabIndex = 37
Top = 360
Width = 540
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "发动机号："
Height = 180
Index = 8
Left = 5930
TabIndex = 36
Top = 840
Width = 900
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "车辆价格："
Height = 180
Index = 7
Left = 360
TabIndex = 35
Top = 840
Width = 900
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "单位及地址："
Height = 180
Index = 6
Left = 5760
TabIndex = 34
Top = 1785
Width = 1080
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "到期日："
Height = 180
Index = 5
Left = 8480
TabIndex = 33
Top = 1320
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "厂牌型号："
Height = 180
Index = 4
Left = 8280
TabIndex = 32
Top = 360
Width = 900
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "车牌号："
Height = 180
Index = 3
Left = 2700
TabIndex = 31
Top = 825
Width = 720
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "手机："
Height = 180
Index = 2
Left = 6280
TabIndex = 30
Top = 360
Width = 540
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "性别："
Height = 180
Index = 1
Left = 2880
TabIndex = 29
Top = 360
Width = 540
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "准客户姓名："
Height = 180
Index = 0
Left = 190
TabIndex = 28
Top = 360
Width = 1080
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "理赔情况："
Height = 180
Index = 9
Left = 2520
TabIndex = 27
Top = 1800
Width = 900
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "颜色："
Height = 180
Index = 10
Left = 4440
TabIndex = 26
Top = 1320
Width = 540
End
End
Begin 保险秘书.isButton isBCancel
Height = 375
Left = 9480
TabIndex = 6
Top = 4560
Width = 1335
_ExtentX = 2355
_ExtentY = 661
Icon = "FzkhAdd.frx":0000
Style = 5
Caption = " 取 消"
IconAlign = 1
Tooltiptitle = ""
ToolTipIcon = 0
ToolTipType = 0
ttForeColor = 0
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin 保险秘书.isButton isBok
Height = 375
Left = 7920
TabIndex = 5
Top = 4560
Width = 1335
_ExtentX = 2355
_ExtentY = 661
Icon = "FzkhAdd.frx":059A
Style = 5
Caption = " 确认提交"
IconAlign = 1
Tooltiptitle = ""
ToolTipIcon = 0
ToolTipType = 0
ttForeColor = 0
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin VB.TextBox Tmark
Appearance = 0 'Flat
Height = 1935
Left = 120
MultiLine = -1 'True
TabIndex = 2
Top = 2520
Width = 5175
End
Begin VB.TextBox Tother
Appearance = 0 'Flat
Height = 1935
Left = 5400
MultiLine = -1 'True
TabIndex = 1
Top = 2520
Width = 5415
End
Begin VB.Label Label3
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "险种需求："
Height = 195
Left = 6060
TabIndex = 4
Top = 2280
Width = 900
End
Begin VB.Label Label2
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "备注栏："
Height = 195
Left = 660
TabIndex = 3
Top = 2280
Width = 720
End
End
End
Attribute VB_Name = "FzkhAdd"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub Form_Load()
Me.Move (Fzkh.ScaleWidth - Me.Width) / 2, (Fzkh.ScaleHeight - Me.Height) / 2
Call ExplodeForm(Me, 1500)
With Osex
.AddItem "男"
.AddItem "女"
.ListIndex = 0
End With
With Occ
.AddItem "成交"
.AddItem "未成交"
.ListIndex = 0
End With
With Olp
.AddItem "有赔偿"
.AddItem "上年无赔"
.ListIndex = 0
End With
Call showsel(Oys, "车辆颜色")
Call showsel(Ocb, "承保公司名称")
Odq.Text = Date
End Sub
Private Sub Form_Unload(Cancel As Integer)
Call ImplodeForm(Me, 1500, 800, 800)
Odq.Text = Date
End Sub
Private Sub isBCancel_Click()
Unload Me
End Sub
Private Sub isBOk_Click()
If Trim$(Tmsg(0).Text) = "" Then
MsgBox "信息填写不完整！"
Exit Sub
End If
Call sqlinsert
Fzkh.Timer1.Enabled = True
End Sub
Private Sub sqlinsert()
Dim sql As String
Dim vdb As Boolean
Dim vnum As Integer
Dim znu As String
sql = "select count(name) from zpeo where name='" & Trim$(Tmsg(0).Text) & "'"
vdb = ExcSql
If vdb = True Then
vnum = conn.Execute(sql)(0)
If vnum > 0 Then
MsgBox "改用户名已经存在！请更改其他名称。"
Exit Sub
End If
If Trim$(Tmsg(11).Text) = "" Then
znu = "0"
End If
sql = "insert into znpeo(name,sex,zw,tel,addr,cp,cl,cph,fj,cj,se,enddate,lp,bf,gs,cc,mark,other,do_time,nnum,znum) values('" & Tmsg(0).Text & "','" & Osex.Text & "','" & Tmsg(1) & "','" & Tmsg(2).Text & "','" & Tmsg(5).Text & "','" & Tmsg(4).Text & "'" & _
",'" & Tmsg(8).Text & "','" & Tmsg(3).Text & "','" & Tmsg(7).Text & "','" & Tmsg(6).Text & "','" & Oys.Text & "',#" & Odq.Text & "# " & _
",'" & Olp.Text & "','" & Tmsg(9).Text & "','" & Ocb.Text & "','" & Occ.Text & "','" & Tmark.Text & "','" & Tother.Text & "',#" & Now() & "#,'" & Tmsg(10).Text & "'," & znu & ")"
Call exsql(sql)
'MsgBox sql
Unload Me
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -