f_fulifeidayin.frm

功能齐全的人事工资管理系统 vb+acce

VERSION 5.00
Object = "{0BA686C6-F7D3-101A-993E-0000C0EF6F5E}#1.0#0"; "THREED32.OCX"
Begin VB.Form F_FuliFeiDaYin 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "福利费"
   ClientHeight    =   6090
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   11910
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   Moveable        =   0   'False
   ScaleHeight     =   6090
   ScaleWidth      =   11910
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  '屏幕中心
   WindowState     =   2  'Maximized
   Begin Threed.SSCommand cmdPrint 
      Height          =   375
      Left            =   9000
      TabIndex        =   3
      Top             =   240
      Width           =   1095
      _Version        =   65536
      _ExtentX        =   1931
      _ExtentY        =   661
      _StockProps     =   78
      Caption         =   "&P.打印预览"
      Font3D          =   3
   End
   Begin VB.ComboBox Combo1 
      Height          =   300
      Left            =   6600
      TabIndex        =   2
      Top             =   240
      Width           =   1695
   End
   Begin VB.TextBox Text1 
      Appearance      =   0  'Flat
      Height          =   285
      Left            =   840
      TabIndex        =   0
      Top             =   248
      Width           =   1455
   End
   Begin VB.TextBox Text2 
      Appearance      =   0  'Flat
      Height          =   285
      Left            =   3480
      TabIndex        =   1
      Top             =   240
      Width           =   1455
   End
   Begin Threed.SSCommand cmdClose 
      Height          =   375
      Left            =   10320
      TabIndex        =   4
      Top             =   240
      Width           =   1095
      _Version        =   65536
      _ExtentX        =   1931
      _ExtentY        =   661
      _StockProps     =   78
      Caption         =   "&Q.关  闭"
      Font3D          =   3
   End
   Begin VB.Label Label3 
      Caption         =   "福利项目"
      Height          =   255
      Left            =   5280
      TabIndex        =   7
      Top             =   263
      Width           =   1095
   End
   Begin VB.Label Label1 
      Caption         =   "年度"
      Height          =   255
      Left            =   120
      TabIndex        =   6
      Top             =   263
      Width           =   1095
   End
   Begin VB.Label Label2 
      Caption         =   "月  份"
      Height          =   255
      Left            =   2520
      TabIndex        =   5
      Top             =   263
      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 Combo1_KeyPress(KeyAscii As Integer)
If KeyAscii = vbKeyReturn Then
    SendKeys "{TAB}"
End If
End Sub

Private Sub Form_Load()

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

  Wend
  
End Sub

Private Sub Text1_KeyPress(KeyAscii As Integer)

If KeyAscii = vbKeyReturn Then
    SendKeys "{TAB}"
End If

End Sub

Private Sub Text2_KeyPress(KeyAscii As Integer)
If KeyAscii = vbKeyReturn Then
    SendKeys "{TAB}"
End If
End Sub