f_fulifeidayin.frm

公司人员综合管理系统 提供公司人员的简历、工资账目、考勤、医疗纪录、失业保险等情况

VERSION 5.00
Begin VB.Form F_FuliFeiDaYin 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "福利费"
   ClientHeight    =   6090
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   11910
   BeginProperty Font 
      Name            =   "宋体"
      Size            =   9
      Charset         =   134
      Weight          =   400
      Underline       =   0   'False
      Italic          =   0   'False
      Strikethrough   =   0   'False
   EndProperty
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   Moveable        =   0   'False
   ScaleHeight     =   6090
   ScaleWidth      =   11910
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  'CenterScreen
   WindowState     =   2  'Maximized
   Begin VB.ComboBox Combo1 
      Height          =   300
      Left            =   6600
      TabIndex        =   7
      Top             =   240
      Width           =   1695
   End
   Begin VB.TextBox Text1 
      Height          =   285
      Left            =   840
      TabIndex        =   3
      Top             =   240
      Width           =   1455
   End
   Begin VB.TextBox Text2 
      Height          =   285
      Left            =   3480
      TabIndex        =   2
      Top             =   240
      Width           =   1455
   End
   Begin VB.CommandButton cmdPrint 
      Caption         =   "打印预览"
      Height          =   300
      Left            =   8640
      TabIndex        =   1
      Top             =   240
      Width           =   1095
   End
   Begin VB.CommandButton cmdClose 
      Caption         =   "关闭"
      Height          =   300
      Left            =   10200
      TabIndex        =   0
      Top             =   240
      Width           =   1095
   End
   Begin VB.Label Label3 
      Caption         =   "福利项目"
      Height          =   255
      Left            =   5280
      TabIndex        =   6
      Top             =   240
      Width           =   1095
   End
   Begin VB.Label Label1 
      Caption         =   "年度"
      Height          =   255
      Left            =   120
      TabIndex        =   5
      Top             =   240
      Width           =   1095
   End
   Begin VB.Label Label2 
      Caption         =   "月份"
      Height          =   255
      Left            =   2520
      TabIndex        =   4
      Top             =   240
      Width           =   975
   End
End
Attribute VB_Name = "F_FuliFeiDaYin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdClose_Click()
RSGL.Enabled = True
Unload Me

End Sub

Private Sub cmdPrint_Click()
Dim NianDu As Integer
Dim YueFen As Integer

If IsNumeric(Text1) And IsNumeric(Text2) And Combo1.Text <> "" Then
  NianDu = CDbl(Text1)
  YueFen = CDbl(Text2)

DataEnvironment1.Commands("Cmd_福利费_Grouping").Parameters("param1").Value = NianDu
DataEnvironment1.Commands("Cmd_福利费_Grouping").Parameters("param2").Value = YueFen
DataEnvironment1.Commands("Cmd_福利费_Grouping").Parameters("param3").Value = Combo1.Text

DRP_福利费.Show
Else
  MsgBox "请选择年度、月份、和费用项目!"
End If
End Sub



Private Sub Form_Load()

SqlFeiYongXiangMu = "select  distinct 费用项目 from 福利费用"
  Set RsFeiYongXiangMu = db.Execute(SqlFeiYongXiangMu)
   
  While Not RsFeiYongXiangMu.EOF
    Combo1.AddItem Trim(RsFeiYongXiangMu("费用项目"))
    RsFeiYongXiangMu.MoveNext

  Wend
  
End Sub