利率表.frm

来自「C/S模块」· FRM 代码 · 共 194 行

VERSION 5.00
Begin VB.Form Form14 
   BackColor       =   &H00FFC0C0&
   Caption         =   "Form14"
   ClientHeight    =   6915
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   11295
   LinkTopic       =   "Form14"
   Picture         =   "利率表.frx":0000
   ScaleHeight     =   6915
   ScaleWidth      =   11295
   StartUpPosition =   3  '窗口缺省
   Begin VB.Frame Frame1 
      BackColor       =   &H00FFC0C0&
      Caption         =   "利率表"
      Height          =   4815
      Left            =   2640
      TabIndex        =   0
      Top             =   960
      Width           =   4575
      Begin VB.CommandButton Command4 
         Caption         =   "修改"
         Height          =   495
         Left            =   120
         Picture         =   "利率表.frx":4F4CC
         Style           =   1  'Graphical
         TabIndex        =   13
         Top             =   3960
         Width           =   1335
      End
      Begin VB.CommandButton Command3 
         Caption         =   "返回"
         Height          =   495
         Left            =   3240
         Picture         =   "利率表.frx":57DA2
         Style           =   1  'Graphical
         TabIndex        =   12
         Top             =   3960
         Width           =   975
      End
      Begin VB.CommandButton Command2 
         Caption         =   "两年定期"
         Height          =   495
         Index           =   3
         Left            =   120
         Picture         =   "利率表.frx":60678
         Style           =   1  'Graphical
         TabIndex        =   11
         Top             =   1800
         Width           =   1455
      End
      Begin VB.CommandButton Command2 
         Caption         =   "三年定期"
         Height          =   495
         Index           =   2
         Left            =   120
         Picture         =   "利率表.frx":68F4E
         Style           =   1  'Graphical
         TabIndex        =   10
         Top             =   2520
         Width           =   1455
      End
      Begin VB.CommandButton Command2 
         Caption         =   "一年定期"
         Height          =   495
         Index           =   1
         Left            =   120
         Picture         =   "利率表.frx":71824
         Style           =   1  'Graphical
         TabIndex        =   9
         Top             =   1080
         Width           =   1455
      End
      Begin VB.CommandButton Command2 
         Caption         =   "活期"
         Height          =   495
         Index           =   0
         Left            =   120
         Picture         =   "利率表.frx":7A0FA
         Style           =   1  'Graphical
         TabIndex        =   8
         Top             =   360
         Width           =   1455
      End
      Begin VB.CommandButton Command1 
         Caption         =   "提交"
         Height          =   495
         Left            =   1680
         Picture         =   "利率表.frx":829D0
         Style           =   1  'Graphical
         TabIndex        =   7
         Top             =   3960
         Width           =   1335
      End
      Begin VB.TextBox Text1 
         Height          =   495
         Left            =   2040
         TabIndex        =   6
         Top             =   360
         Width           =   2175
      End
      Begin VB.TextBox Text2 
         Height          =   495
         Left            =   2040
         TabIndex        =   5
         Top             =   1080
         Width           =   2175
      End
      Begin VB.TextBox Text3 
         Height          =   495
         Left            =   2040
         TabIndex        =   4
         Top             =   1800
         Width           =   2175
      End
      Begin VB.TextBox Text4 
         Height          =   495
         Left            =   2040
         TabIndex        =   3
         Top             =   2520
         Width           =   2175
      End
      Begin VB.CommandButton Command5 
         Caption         =   "五年定期"
         Height          =   495
         Left            =   120
         Picture         =   "利率表.frx":8B2A6
         Style           =   1  'Graphical
         TabIndex        =   2
         Top             =   3240
         Width           =   1455
      End
      Begin VB.TextBox Text5 
         Height          =   495
         Left            =   2040
         TabIndex        =   1
         Top             =   3240
         Width           =   2175
      End
   End
End
Attribute VB_Name = "Form14"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
 If Text1.Text = "" Or Text2.Text = "" Or Text3.Text = "" Or Text4.Text = "" Or Text5.Text = "" Then
        MsgBox "请填写完整利率信息！"
        Text1.SetFocus
        Exit Sub
        ElseIf Not IsNumeric(Text1.Text) Or Not IsNumeric(Text2.Text) Or Not IsNumeric(Text3.Text) Or Not IsNumeric(Text4.Text) Or Not IsNumeric(Text5.Text) Then
        MsgBox "利率为数字"
        Text1.SetFocus
        Exit Sub
        ElseIf Text1.Text >= 1 Or Text2.Text >= 1 Or Text3.Text >= 1 Or Text4.Text >= 1 Or Text5.Text >= 1 Then
        MsgBox "利率信息不正确！"
        Text1.SetFocus
        Exit Sub
  Else
       Call openconn
        rs.Open "select * from rate_xx053_06 ", conn, adOpenDynamic, adLockOptimistic
         If rs.BOF And rs.EOF Then
         MsgBox "利率修改不成功！"
         rs.Close
         Else
         rs.Fields(0) = Trim(Text1.Text)
         rs.Fields(1) = Trim(Text2.Text)
         rs.Fields(2) = Trim(Text3.Text)
         rs.Fields(3) = Trim(Text4.Text)
         rs.Fields(4) = Trim(Text5.Text)
         rs.Update
         rs.Close
         MsgBox "修改利率成功！"
         Unload Me
        Form11.Show
        End If
  End If
End Sub

Private Sub Command3_Click()
 Unload Me
  Form11.Show
End Sub

Private Sub Command4_Click()
         Text1.Enabled = True
         Text2.Enabled = True
         Text3.Enabled = True
         Text4.Enabled = True
         Text5.Enabled = True
End Sub