frmbdssc.frm

工资管理系统（VB）基于vb开发的工资管理系统,希望大家有用

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  'CenterOwner
   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             =   270
         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
    hxfi = 1
    Do While hxfi <= 34
       If tb1.Fields(hxfi - 1).Value = Combo3.Text Then
          Text1.Text = Text1.Text + tb1.Fields(hxfi - 1).Name
          Exit Do
       Else
          hxfi = hxfi + 1
       End If
    Loop

EN: End Sub

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



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

Private Sub DBGrid1_DblClick()
Text1.Text = Text1.Text + Data1.Recordset("ZDMC")
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 = hxfbds
tb1.MoveFirst
Combo3.Clear
hxfi = 1
Do While hxfi <= 34
   If Len(Trim(tb1.Fields(hxfi - 1).Value)) > 0 Then Combo3.AddItem tb1.Fields(hxfi - 1).Value
   hxfi = hxfi + 1
Loop
Combo3.AddItem "应发合计"
Combo3.AddItem "代扣合计"
Combo3.AddItem "实发现金"
End Sub