frmcheckkq.frm

企业人事管理系统,有考勤,人员管理等功能,值得研究,也是我付费弄来的,绝对超值

VERSION 5.00
Object = "{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0"; "FM20.DLL"
Begin VB.Form frmCheckKQInfo 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "查询员工考勤信息"
   ClientHeight    =   2250
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   5085
   Icon            =   "frmCheckKQ.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   2250
   ScaleWidth      =   5085
   ShowInTaskbar   =   0   'False
   Begin VB.TextBox txtID 
      Height          =   375
      Left            =   2280
      TabIndex        =   1
      Top             =   120
      Width           =   2415
   End
   Begin VB.CheckBox chkID 
      Caption         =   "员工编号"
      Height          =   375
      Left            =   480
      TabIndex        =   0
      Top             =   120
      Width           =   1695
   End
   Begin MSForms.CommandButton cmdExit 
      Height          =   375
      Left            =   2880
      TabIndex        =   3
      Top             =   1560
      Width           =   1095
      Caption         =   "返回"
      PicturePosition =   327683
      Size            =   "1931;661"
      FontName        =   "宋体"
      FontHeight      =   180
      FontCharSet     =   134
      FontPitchAndFamily=   34
      ParagraphAlign  =   3
   End
   Begin MSForms.CommandButton cmdOK 
      Height          =   375
      Left            =   1080
      TabIndex        =   2
      Top             =   1560
      Width           =   1095
      Caption         =   "确定"
      PicturePosition =   327683
      Size            =   "1931;661"
      Picture         =   "frmCheckKQ.frx":0442
      FontName        =   "宋体"
      FontHeight      =   180
      FontCharSet     =   134
      FontPitchAndFamily=   34
      ParagraphAlign  =   3
   End
End
Attribute VB_Name = "frmCheckKQInfo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdExit_Click()
 Unload Me
End Sub

Private Sub cmdOk_Click()
   Dim strHead As String
  ' Dim strHead1 As String
  ' Dim strHead2 As String
  ' Dim strHead3 As String
   Dim strAdd As String
   Dim strSql As String
  
  strHead = "select t_br.工号,t_br.姓名,当前日期,出入标志,上班时间,下班时间,迟到次数,早退次数,假期开始时间,特殊加班天数,正常加班天数,加班日期,出差天数,出差目的地,出差开始时间 from t_br,AttendanceInfo,LeaveInfo,OverTimeInfo,ErrandInfo where t_br.工号=AttendanceInfo.工号 and AttendanceInfo.工号=LeaveInfo.工号 and LeaveInfo.工号=OverTimeInfo.工号 and OverTimeInfo.工号=ErrandInfo.工号"
   
  If chkID.Value = 1 And Trim(txtID.Text) <> "" Then
     strAdd = strAdd & " and t_br.工号='" & Trim(txtID.Text) & "'"
  End If
  'If chkInOutDate.Value = 1 Then
   '  strAdd = strAdd & " and 当前日期>= #" & dtpFrom1 & "# and  当前日期<=#" & dtpTo1 & "#"
 ' End If
  
 'If chkLeaveDate.Value = 1 Then
  'strAdd = strAdd & " and 假期开始时间>= #" & dtpFrom2 & "# and 假期开始时间<=#" & dtpTo2 & "#"
  'End If
 'If chkOverTimeDate.Value = 1 Then
  'strAdd = strAdd & " and 加班日期>= #" & dtpFrom3 & "# and 加班日期<=#" & dtpTo3 & "#"
 'End If
 'If chkErrandDate.Value = 1 Then
  ' strAdd = strAdd & " and 出差开始时间>= #" & dtpFrom4 & "# and 出差开始时间<=#" & dtpTo4 & "#"
  
 'End If
  ' strSql = strHead & strAdd

 'MsgBox strSql
 frmAllCQInfoList.showgrid1 (strSql)
 frmAllCQInfoList.Show
 'txtID.Text = ""
' Unload Me

End Sub