gp.frm

小巧的个人股票、资金管理系统

VERSION 5.00
Begin VB.Form frmfl 
   BackColor       =   &H0080C0FF&
   BorderStyle     =   1  'Fixed Single
   Caption         =   "费率设置"
   ClientHeight    =   2625
   ClientLeft      =   3675
   ClientTop       =   4110
   ClientWidth     =   5070
   Icon            =   "gp.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   2625
   ScaleWidth      =   5070
   Begin VB.CommandButton CmdNO 
      Appearance      =   0  'Flat
      BackColor       =   &H80000009&
      Caption         =   "取消"
      Height          =   375
      Left            =   3840
      MaskColor       =   &H00FFFFFF&
      Picture         =   "gp.frx":030A
      Style           =   1  'Graphical
      TabIndex        =   7
      Top             =   1800
      UseMaskColor    =   -1  'True
      Width           =   975
   End
   Begin VB.CommandButton cmbxg 
      Appearance      =   0  'Flat
      BackColor       =   &H80000009&
      Caption         =   "修改"
      Height          =   375
      Left            =   3840
      MaskColor       =   &H00FFFFFF&
      Picture         =   "gp.frx":0614
      Style           =   1  'Graphical
      TabIndex        =   6
      Top             =   1080
      UseMaskColor    =   -1  'True
      Width           =   975
   End
   Begin VB.CommandButton CmdOK 
      Appearance      =   0  'Flat
      BackColor       =   &H80000009&
      Caption         =   "确定"
      Default         =   -1  'True
      Height          =   375
      Left            =   3840
      MaskColor       =   &H00FFFFFF&
      Picture         =   "gp.frx":0A56
      Style           =   1  'Graphical
      TabIndex        =   5
      Top             =   360
      UseMaskColor    =   -1  'True
      Width           =   975
   End
   Begin VB.Frame frm 
      BackColor       =   &H0080C0FF&
      Caption         =   "费率"
      ForeColor       =   &H00FF0000&
      Height          =   1935
      Left            =   240
      TabIndex        =   0
      Top             =   240
      Width           =   3375
      Begin VB.TextBox txtyh 
         Appearance      =   0  'Flat
         ForeColor       =   &H000000FF&
         Height          =   375
         Left            =   1560
         TabIndex        =   4
         Text            =   "txtyh"
         Top             =   1080
         Width           =   1335
      End
      Begin VB.TextBox txtsx 
         Appearance      =   0  'Flat
         ForeColor       =   &H000000FF&
         Height          =   375
         Left            =   1560
         TabIndex        =   3
         Text            =   "txtsx"
         Top             =   480
         Width           =   1335
      End
      Begin VB.Label lb2 
         Appearance      =   0  'Flat
         BackColor       =   &H80000005&
         BackStyle       =   0  'Transparent
         Caption         =   "印花税："
         ForeColor       =   &H00FF0000&
         Height          =   375
         Left            =   360
         TabIndex        =   2
         Top             =   1080
         Width           =   1095
      End
      Begin VB.Label lb1 
         Appearance      =   0  'Flat
         BackColor       =   &H80000005&
         BackStyle       =   0  'Transparent
         Caption         =   "手续费率："
         ForeColor       =   &H00FF0000&
         Height          =   495
         Left            =   360
         TabIndex        =   1
         Top             =   480
         Width           =   1215
      End
   End
End
Attribute VB_Name = "frmfl"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
'Download by http://www.codefans.net
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public dbs As Database
Public rec As Recordset
Private Sub cmbxg_Click()
  txtsx.Enabled = True
  txtyh.Enabled = True
  txtsx.SetFocus
End Sub
Private Sub CmdNO_Click()
  Unload Me
End Sub
Private Sub CmdOK_Click()
  dbs.Execute "UPDATE 费率 SET 手续费率 =" & txtsx.Text & "  ,印花税率=" & txtyh.Text & ";" _
            & ""
  txtsx.Enabled = False
  txtyh.Enabled = False
  Unload Me
End Sub
Private Sub Form_Load()
  filename = App.Path & "\股票.mdb"
  Set dbs = OpenDatabase(filename)
  Set rec = dbs.OpenRecordset("费率")
  txtsx.Text = rec.Fields(1)
  txtyh.Text = rec.Fields(2)
  txtsx.Enabled = False
  txtyh.Enabled = False
  frmfl.Left = 3500
  frmfl.Top = 1000
End Sub