fbdxzadd.frm

为个人用户开发的车险秘书系统

VERSION 5.00
Object = "{AAFC76DD-CA60-4286-B6D9-3F60CB53A409}#1.0#0"; "data.ocx"
Begin VB.Form Fbdxzadd 
   Caption         =   "险种管理"
   ClientHeight    =   3435
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   10650
   LinkTopic       =   "Form1"
   MDIChild        =   -1  'True
   ScaleHeight     =   3435
   ScaleWidth      =   10650
   Begin VB.Frame Frame6 
      BackColor       =   &H00FFC0C0&
      BorderStyle     =   0  'None
      Caption         =   "Frame6"
      Height          =   3495
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   10695
      Begin VB.TextBox Tad 
         Appearance      =   0  'Flat
         Enabled         =   0   'False
         Height          =   375
         Index           =   0
         Left            =   1560
         TabIndex        =   7
         Top             =   240
         Width           =   2295
      End
      Begin VB.TextBox Tad 
         Appearance      =   0  'Flat
         Height          =   375
         Index           =   1
         Left            =   5520
         TabIndex        =   6
         Top             =   240
         Width           =   1935
      End
      Begin VB.TextBox Tad 
         Appearance      =   0  'Flat
         Height          =   375
         Index           =   2
         Left            =   5520
         TabIndex        =   5
         Top             =   720
         Width           =   1935
      End
      Begin VB.TextBox Tad 
         Appearance      =   0  'Flat
         Height          =   375
         Index           =   3
         Left            =   8520
         TabIndex        =   4
         Top             =   240
         Width           =   1935
      End
      Begin VB.TextBox Tad 
         Appearance      =   0  'Flat
         Height          =   375
         Index           =   4
         Left            =   1560
         TabIndex        =   3
         Top             =   720
         Width           =   2295
      End
      Begin VB.TextBox Tad 
         Appearance      =   0  'Flat
         Height          =   1695
         Index           =   5
         Left            =   1560
         TabIndex        =   2
         Top             =   1200
         Width           =   8895
      End
      Begin OsenXPControls2.CommandButton CommandButton1 
         Height          =   375
         Left            =   7920
         TabIndex        =   1
         Top             =   3000
         Width           =   1335
         _ExtentX        =   2355
         _ExtentY        =   661
         BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "MS Sans Serif"
            Size            =   8.25
            Charset         =   0
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Caption         =   "确定  "
         ForeColor       =   -2147483642
         ForeHover       =   0
      End
      Begin OsenXPControls2.CommandButton CommandButton2 
         Height          =   375
         Left            =   9360
         TabIndex        =   8
         Top             =   3000
         Width           =   1215
         _ExtentX        =   2143
         _ExtentY        =   661
         BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "MS Sans Serif"
            Size            =   8.25
            Charset         =   0
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Caption         =   "取消  "
         ForeColor       =   -2147483642
         ForeHover       =   0
      End
      Begin VB.Label Label49 
         AutoSize        =   -1  'True
         BackStyle       =   0  'Transparent
         Caption         =   "保险合同编号:"
         Height          =   195
         Index           =   0
         Left            =   360
         TabIndex        =   14
         Top             =   360
         Width           =   1125
      End
      Begin VB.Label Label49 
         AutoSize        =   -1  'True
         BackStyle       =   0  'Transparent
         Caption         =   "可供购买的险种:"
         Height          =   195
         Index           =   1
         Left            =   4140
         TabIndex        =   13
         Top             =   360
         Width           =   1305
      End
      Begin VB.Label Label49 
         AutoSize        =   -1  'True
         BackStyle       =   0  'Transparent
         Caption         =   "基本保险金额:"
         Height          =   195
         Index           =   2
         Left            =   4320
         TabIndex        =   12
         Top             =   840
         Width           =   1125
      End
      Begin VB.Label Label49 
         AutoSize        =   -1  'True
         BackStyle       =   0  'Transparent
         Caption         =   "险种组合:"
         Height          =   195
         Index           =   3
         Left            =   7680
         TabIndex        =   11
         Top             =   360
         Width           =   765
      End
      Begin VB.Label Label49 
         AutoSize        =   -1  'True
         BackStyle       =   0  'Transparent
         Caption         =   "投保人数:"
         Height          =   195
         Index           =   5
         Left            =   720
         TabIndex        =   10
         Top             =   840
         Width           =   765
      End
      Begin VB.Label Label49 
         AutoSize        =   -1  'True
         BackStyle       =   0  'Transparent
         Caption         =   "说明:"
         Height          =   195
         Index           =   6
         Left            =   1080
         TabIndex        =   9
         Top             =   1320
         Width           =   405
      End
   End
End
Attribute VB_Name = "Fbdxzadd"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub CommandButton1_Click()
    Dim sql As String
    Dim vnum As String
    
    If Tad(1).Text = "" Then
        MsgBox "信息内容填写不完整！"
        Exit Sub
    End If
    If Trim$(Tad(4).Text) = "" Then
        vnum = 0
    Else
        vnum = Trim$(Tad(4).Text)
    End If
    
    'If Tshow.Text = "change" Then
    '    sql = "update additional set mai='" & Trim$(Tad(1).Text) & "',fee='" & Trim$(Tad(2).Text) & "',xadd='" & Trim$(Tad(3).Text) & "',num=" & vnum & ",mark='" & Trim$(Tad(5).Text) & "' where id=" & Trim$(ListViewjt.SelectedItem.Text)
    'Else
        sql = "insert into additional(bid,mai,fee,xadd,num,mark) " & _
        " values('" & Trim$(Tad(0).Text) & "','" & Trim$(Tad(1).Text) & "','" & Trim$(Tad(2).Text) & "','" & Trim$(Tad(3).Text) & "','" & Trim$(Tad(4).Text) & "','" & Trim$(Tad(5).Text) & "')"
    'End If
    'MsgBox sql
    conn.Execute sql
    
    FbdNew.Timer1.Enabled = True
    Unload Me
End Sub

Private Sub CommandButton2_Click()
    Unload Me
End Sub

Private Sub Form_Load()
    Fbdxzadd.Move (FbdNew.ScaleWidth - Me.Width) / 2, (FbdNew.ScaleHeight - Me.Height) / 2
    
    Call ExplodeForm(Me, 1500)
    
    Tad(0).Text = FbdNew.Tmsg.Text
End Sub

Private Sub Form_Unload(Cancel As Integer)
    Call ImplodeForm(Me, 1500, 800, 800)
End Sub