frmbdssc.frm

银行代发薪资管理系统,跟金融有关的,想学这方面可以参考一下

VERSION 5.00
Begin VB.Form frm表达式生成 
   Caption         =   "条件及表达式生成"
   ClientHeight    =   3540
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   5550
   ControlBox      =   0   'False
   LinkTopic       =   "Form1"
   ScaleHeight     =   3540
   ScaleWidth      =   5550
   StartUpPosition =   1  '所有者中心
   Begin VB.Frame Frame2 
      Caption         =   "字段选择"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   825
      Left            =   60
      TabIndex        =   7
      Top             =   2280
      Width           =   4065
      Begin VB.ComboBox Combo3 
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   360
         Left            =   180
         TabIndex        =   8
         Top             =   300
         Width           =   3795
      End
   End
   Begin VB.TextBox Text1 
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   1095
      Left            =   60
      MaxLength       =   256
      MultiLine       =   -1  'True
      ScrollBars      =   2  'Vertical
      TabIndex        =   6
      Top             =   1140
      Width           =   4065
   End
   Begin VB.CommandButton Command2 
      Cancel          =   -1  'True
      Caption         =   "放弃(&Q)"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   345
      Left            =   4260
      TabIndex        =   4
      Top             =   720
      Width           =   1155
   End
   Begin VB.CommandButton Command1 
      Caption         =   "确定(&E)"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   345
      Left            =   4260
      TabIndex        =   3
      Top             =   210
      Width           =   1185
   End
   Begin VB.Frame Frame1 
      Caption         =   "运算符选择:"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   705
      Left            =   60
      TabIndex        =   0
      Top             =   60
      Width           =   4065
      Begin VB.ComboBox Combo2 
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   360
         Left            =   1980
         TabIndex        =   2
         Text            =   "逻辑运算符"
         Top             =   270
         Width           =   1875
      End
      Begin VB.ComboBox Combo1 
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   360
         Left            =   210
         TabIndex        =   1
         Text            =   "数值运算符"
         Top             =   240
         Width           =   1695
      End
   End
   Begin VB.Label Label1 
      Caption         =   "表达式:"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   90
      TabIndex        =   5
      Top             =   840
      Width           =   825
   End
End
Attribute VB_Name = "frm表达式生成"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Combo1_Click()
Text1.Text = Text1.Text + Combo1.Text
End Sub

Private Sub Combo2_Click()
Text1.Text = Text1.Text + Combo2.Text
End Sub

Private Sub Combo3_Click()
'    If Combo3.Text = "应发合计" Then
'       Text1.Text = Text1.Text + "应发合计"
'       GoTo en:
'    End If
'    If Combo3.Text = "代扣合计" Then
'       Text1.Text = Text1.Text + "代扣合计"
'       GoTo en:
'    End If
'    If Combo3.Text = "实发金额" Then
'       Text1.Text = Text1.Text + "实发金额"
'       GoTo en:
'    End If
tb1.MoveFirst
i = 5
Do While i <= 28
    If tb1.Fields(i).Name = Combo3.Text Then
        Text1.Text = Text1.Text + tb1.Fields(i).Name
        Exit Do
    Else
        i = i + 1
    End If
Loop
en: End Sub

Private Sub Command1_Click()
bds = Text1.Text
Unload Me
End Sub

Private Sub Command2_Click()
bds = bds
Unload Me
End Sub

Private Sub Form_Load()
Combo1.AddItem "+"
Combo1.AddItem "-"
Combo1.AddItem "*"
Combo1.AddItem "/"
Combo1.AddItem "("
Combo1.AddItem ")"
Combo2.AddItem "="
Combo2.AddItem ">"
Combo2.AddItem "<"
Combo2.AddItem "<="
Combo2.AddItem ">="
Combo2.AddItem "<>"
Combo2.AddItem "AND"
Combo2.AddItem "OR"
Combo2.AddItem "NOT"
Text1.Text = bds
tb1.MoveFirst
Combo3.Clear
i = 5
Do While i <= 28
    'If Len(Trim(tb1.Fields(i).Name)) > 0 Then
    Combo3.AddItem tb1.Fields(i).Name
    i = i + 1
Loop
'Combo3.AddItem "应发合计"
'Combo3.AddItem "代扣合计"
'Combo3.AddItem "实发金额"
End Sub