frmconfig.frm

考勤机管理软件,用于统计某段时间某个部门或者某个员工在某段内迟到与早退次数.

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form frmKQJData 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "考勤机设置"
   ClientHeight    =   5220
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   6105
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   5220
   ScaleWidth      =   6105
   ShowInTaskbar   =   0   'False
   Begin VB.Frame Frame3 
      Height          =   1680
      Left            =   90
      TabIndex        =   4
      Top             =   3465
      Width           =   5910
      Begin VB.CommandButton BtnClose 
         Caption         =   "关闭"
         Height          =   405
         Left            =   4230
         TabIndex        =   6
         Top             =   1080
         Width           =   1440
      End
      Begin MSComctlLib.ProgressBar ProgressBar 
         Height          =   195
         Left            =   270
         TabIndex        =   5
         Top             =   675
         Width           =   5370
         _ExtentX        =   9472
         _ExtentY        =   344
         _Version        =   393216
         Appearance      =   1
      End
   End
   Begin VB.Frame Frame2 
      Height          =   1680
      Left            =   90
      TabIndex        =   2
      Top             =   1755
      Width           =   5910
      Begin VB.CommandButton BtnGetKQPreData 
         Caption         =   "上传上次数据"
         Height          =   405
         Left            =   4230
         TabIndex        =   3
         Top             =   1080
         Width           =   1440
      End
      Begin VB.Image Image2 
         Height          =   480
         Left            =   315
         Picture         =   "frmConfig.frx":0000
         Top             =   315
         Width           =   480
      End
      Begin VB.Label Label2 
         Caption         =   "一般不要点上传上次考勤数据,否则数据库中就会有重复考勤数据存在,对报表的提取出来速度有影响。"
         Height          =   375
         Left            =   1305
         TabIndex        =   8
         Top             =   315
         Width           =   4380
      End
   End
   Begin VB.Frame Frame1 
      Height          =   1680
      Left            =   90
      TabIndex        =   0
      Top             =   45
      Width           =   5910
      Begin VB.CommandButton BtnGetKQData 
         Caption         =   "上传考勤数据"
         Height          =   405
         Left            =   4230
         TabIndex        =   1
         Top             =   1080
         Width           =   1440
      End
      Begin VB.Image Image1 
         Height          =   480
         Left            =   360
         Picture         =   "frmConfig.frx":1982
         Top             =   360
         Width           =   480
      End
      Begin VB.Label Label1 
         Caption         =   "如果成功上传后的当前考勤数据意外丢失或被破坏,则可以点上传上次考勤数据进行补救;只要上次考勤数据有效,则就可以多次上传。"
         Height          =   780
         Left            =   1305
         TabIndex        =   7
         Top             =   315
         Width           =   4335
      End
   End
End
Attribute VB_Name = "frmKQJData"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Private Sub BtnClose_Click()
    Unload Me
End Sub

Private Sub Form_Load()
    Me.Icon = MDI.Icon
    Me.Caption = "提取数据"
End Sub

Private Sub BtnGetKQData_Click()
    ProgressBar.Value = 0
    MDI.KQJ.GetKQData
'    DelEchoRecord
End Sub

Private Sub BtnGetKQPreData_Click()
    ProgressBar.Value = 0
    MDI.KQJ.GetKQPreData
'    DelEchoRecord
End Sub

Private Sub DelEchoRecord()
On Error Resume Next

    con.Execute "select distinct InDate,InCode,InTime into Tmp from InData"
    Sleep (200)
    
    con.Execute "drop table InData"
    Sleep (200)
    
    con.Execute "select * into InData from Tmp"
    Sleep (200)
    
    con.Execute "drop table Tmp"
    Sleep (200)

End Sub


'    Dim sCmd As String
'    Dim sState As String
'    Dim tmpl As Long
'    Dim tmpb As Byte
'    Dim i As Integer
'    Dim s As String
'
'    If nCmd = CmdTransferData Then
'        sCmd = "CmdTransferData"
'        tmpl = 0
'        If nState = StateFirstSegment Then
'            ProgressBar.Max = lParam
'            ProgressBar.Value = 0
'            tmpl = Len(sData) / 20
'        ElseIf nState = StateContinueSegment Then
'            tmpl = Len(sData) / 20
'        ElseIf nState = Success Then
'            tmpl = Len(sData) / 20
'            Debug.Print "Max = " + Str(ProgressBar.Max) + ",Value = " + Str(ProgressBar.Value)
'        End If
'        ProgressBar.Value = ProgressBar.Value + tmpl
''----------------------------------------------------------------------------
'
''--------------------------------------------------------CmdTransferPreData
'    ElseIf nCmd = CmdTransferPreData Then
'        sCmd = "CmdTransferPreData"
'        tmpl = 0
'        If nState = StateFirstSegment Then
'            ProgressBar.Max = lParam
'            ProgressBar.Value = 0
'            tmpl = Len(sData) / 20
'        ElseIf nState = StateContinueSegment Then
'            tmpl = Len(sData) / 20
'        ElseIf nState = Success Then
'            tmpl = Len(sData) / 20
'            Debug.Print "Max = " + Str(ProgressBar.Max) + ",Value = " + Str(ProgressBar.Value)
'            MsgBox ""
'        End If
'        ProgressBar.Value = ProgressBar.Value + tmpl
'    End If
'
''    s = "nCmd = " + sCmd + ", nState = " + sState + " sData = " + sData + " lParam = " + str(lParam)
'    InData (sData)
'    MsgBox "完成", vbInformation, "提示"
''    TxtInfo.Text = TxtInfo.Text + s + vbCrLf
''    TxtInfo.SelLength = Len(TxtInfo.Text)