frmemployee.frm

人事档案管理系统(PB)/人事工资管理系统/干部信息管理系统/投标报价与合同管理系统/... 超市...

    On Error GoTo Err_LoadRecords
    
    Dim ctl As Control, i As Long
    
    m_flgLoading = True
    
    Dim aEmployee As Employee
    Set aEmployee = m_Employee
    
    
    Dim vTimeCards As COMEXDataSource
    Set vTimeCards = aEmployee.TimeCards
    
    
    With m_Employee
        For i = 1 To .GetFieldCount
            On Error Resume Next
            Set ctl = Controls(.GetFieldName(i))
            If Err = 0 Then
                Select Case TypeName(ctl)
                    Case "Label"
                    Case "TextBox", "ComboBox", "MaskEdBox"
                        ctl = .GetData(i)
                    Case "CheckBox"
                        ctl.Value = Abs(.GetData(i))
                    Case "DTPicker"
                        ctl.Value = .GetData(i)
                End Select
            End If
        Next
    End With
    
    Set Me.DataEditGrid1(0).DataSource = vTimeCards
    m_EnableAttr = iForm_Attributes
    EnableToolbar False
    m_flgLoading = False
Done_LoadRecords:
    Exit Sub
Err_LoadRecords:
    ErrorMsg Err.Number, Err.Description, "LoadRecords", mcstrMod
    Resume Done_LoadRecords
End Sub

 
Private Sub Address_Change()
    On Error GoTo Err_Address_Change
    If m_flgLoading Then Exit Sub
    m_Employee.SetDatabyname Address.Name, Address
    EnableToolbar True
    Exit Sub
Err_Address_Change:
    With Address
        .SelStart = 0
        .SelLength = Len(.Text)
        .SelText = m_Employee.GetDataByName(Address.Name)
    End With
End Sub
Private Sub Address_LostFocus()
    On Error Resume Next
    Address = m_Employee.GetDataByName(Address.Name)
End Sub
 
Private Sub BillingRate_Change()
    On Error GoTo Err_BillingRate_Change
    If m_flgLoading Then Exit Sub
    m_Employee.SetDatabyname BillingRate.Name, BillingRate
    EnableToolbar True
    Exit Sub
Err_BillingRate_Change:
    With BillingRate
        .SelStart = 0
        .SelLength = Len(.Text)
        .SelText = m_Employee.GetDataByName(BillingRate.Name)
    End With
End Sub
Private Sub BillingRate_LostFocus()
    On Error Resume Next
    BillingRate = m_Employee.GetDataByName(BillingRate.Name)
End Sub
 
Private Sub City_Change()
    On Error GoTo Err_City_Change
    If m_flgLoading Then Exit Sub
    m_Employee.SetDatabyname City.Name, City
    EnableToolbar True
    Exit Sub
Err_City_Change:
    With City
        .SelStart = 0
        .SelLength = Len(.Text)
        .SelText = m_Employee.GetDataByName(City.Name)
    End With
End Sub
Private Sub City_LostFocus()
    On Error Resume Next
    City = m_Employee.GetDataByName(City.Name)
End Sub
 
Private Sub Country_Change()
    On Error GoTo Err_Country_Change
    If m_flgLoading Then Exit Sub
    m_Employee.SetDatabyname Country.Name, Country
    EnableToolbar True
    Exit Sub
Err_Country_Change:
    With Country
        .SelStart = 0
        .SelLength = Len(.Text)
        .SelText = m_Employee.GetDataByName(Country.Name)
    End With
End Sub
Private Sub Country_LostFocus()
    On Error Resume Next
    Country = m_Employee.GetDataByName(Country.Name)
End Sub
 
Private Sub EmployeeID_Change()
    On Error GoTo Err_EmployeeID_Change
    If m_flgLoading Then Exit Sub
    m_Employee.SetDatabyname EmployeeID.Name, EmployeeID
    EnableToolbar True
    Exit Sub
Err_EmployeeID_Change:
    With EmployeeID
        .SelStart = 0
        .SelLength = Len(.Text)
        .SelText = m_Employee.GetDataByName(EmployeeID.Name)
    End With
End Sub
Private Sub EmployeeID_LostFocus()
    On Error Resume Next
    EmployeeID = m_Employee.GetDataByName(EmployeeID.Name)
End Sub
 
Private Sub Extension_Change()
    On Error GoTo Err_Extension_Change
    If m_flgLoading Then Exit Sub
    m_Employee.SetDatabyname Extension.Name, Extension
    EnableToolbar True
    Exit Sub
Err_Extension_Change:
    With Extension
        .SelStart = 0
        .SelLength = Len(.Text)
        .SelText = m_Employee.GetDataByName(Extension.Name)
    End With
End Sub
Private Sub Extension_LostFocus()
    On Error Resume Next
    Extension = m_Employee.GetDataByName(Extension.Name)
End Sub
 
Private Sub FirstName_Change()
    On Error GoTo Err_FirstName_Change
    If m_flgLoading Then Exit Sub
    m_Employee.SetDatabyname FirstName.Name, FirstName
    EnableToolbar True
    Exit Sub
Err_FirstName_Change:
    With FirstName
        .SelStart = 0
        .SelLength = Len(.Text)
        .SelText = m_Employee.GetDataByName(FirstName.Name)
    End With
End Sub
Private Sub FirstName_LostFocus()
    On Error Resume Next
    FirstName = m_Employee.GetDataByName(FirstName.Name)
End Sub
 
Private Sub LastName_Change()
    On Error GoTo Err_LastName_Change
    If m_flgLoading Then Exit Sub
    m_Employee.SetDatabyname LastName.Name, LastName
    EnableToolbar True
    Exit Sub
Err_LastName_Change:
    With LastName
        .SelStart = 0
        .SelLength = Len(.Text)
        .SelText = m_Employee.GetDataByName(LastName.Name)
    End With
End Sub
Private Sub LastName_LostFocus()
    On Error Resume Next
    LastName = m_Employee.GetDataByName(LastName.Name)
End Sub

Private Sub PostalCode_Change()
    On Error GoTo Err_PostalCode_Change
    If m_flgLoading Then Exit Sub
    m_Employee.SetDatabyname PostalCode.Name, PostalCode
    EnableToolbar True
    Exit Sub
Err_PostalCode_Change:
    PostalCode = m_Employee.GetDataByName(PostalCode.Name)
End Sub
Private Sub PostalCode_LostFocus()
    On Error Resume Next
    PostalCode = m_Employee.GetDataByName(PostalCode.Name)
End Sub
 
Private Sub StateOrProvince_Change()
    On Error GoTo Err_StateOrProvince_Change
    If m_flgLoading Then Exit Sub
    m_Employee.SetDatabyname StateOrProvince.Name, StateOrProvince
    EnableToolbar True
    Exit Sub
Err_StateOrProvince_Change:
    With StateOrProvince
        .SelStart = 0
        .SelLength = Len(.Text)
        .SelText = m_Employee.GetDataByName(StateOrProvince.Name)
    End With
End Sub
Private Sub StateOrProvince_LostFocus()
    On Error Resume Next
    StateOrProvince = m_Employee.GetDataByName(StateOrProvince.Name)
End Sub
 
Private Sub Title_Change()
    On Error GoTo Err_Title_Change
    If m_flgLoading Then Exit Sub
    m_Employee.SetDatabyname Title.Name, Title
    EnableToolbar True
    Exit Sub
Err_Title_Change:
    With Title
        .SelStart = 0
        .SelLength = Len(.Text)
        .SelText = m_Employee.GetDataByName(Title.Name)
    End With
End Sub
Private Sub Title_LostFocus()
    On Error Resume Next
    Title = m_Employee.GetDataByName(Title.Name)
End Sub

Private Sub WorkPhone_Change()
    On Error GoTo Err_WorkPhone_Change
    If m_flgLoading Then Exit Sub
    m_Employee.SetDatabyname WorkPhone.Name, WorkPhone
    EnableToolbar True
    Exit Sub
Err_WorkPhone_Change:
    WorkPhone = m_Employee.GetDataByName(WorkPhone.Name)
End Sub
Private Sub WorkPhone_LostFocus()
    On Error Resume Next
    WorkPhone = m_Employee.GetDataByName(WorkPhone.Name)
End Sub



Private Sub tabListview_Click(PreviousTab As Integer)
        
  Me.DataEditGrid1(0).Visible = (tabListview.Tab = 0)
  Me.Refresh
End Sub

Private Sub DataEditGrid1_Dirty(Index As Integer)
    EnableToolbar True
End Sub

Private Sub DataEditGrid1_FetchColumnSetup(Index As Integer, ColName As String, ControlType As FieldControlType, ComboMaskList As String, Alignment As FieldControlAlign, Hidden As Boolean, AutoNumber As Boolean)
    Select Case Index
        Case 0
            Select Case ColName
                Case "EmployeeID"
                    Hidden = True
            End Select
            Dim vTimeCard As New TimeCard
            Select Case ColName
                Case "DateEntered"
                    ColName = "录入时间"
                    AutoNumber = False
                    Alignment = 1
                    ControlType = fcDateTimePick
                Case "EmployeeID"
                    ColName = "员工编号"
                    AutoNumber = False
                    Alignment = 2
                    ControlType = fcComboBx
                    ComboMaskList = vTimeCard.GetEmployeesList
                Case "TimeCardID"
                    ColName = "记录编号"
                    AutoNumber = True
                    Alignment = 2
            End Select
    End Select
End Sub

Private Sub Form_Activate()
    m_Toolbar.Activate m_Guid
End Sub

Private Sub Form_Load()
        Dim vEmployee As New Employee, strCombo As String
    m_Guid = GUID
    m_Toolbar.Attach Me, m_Guid

    tabListview_Click 0
        ThinBorder DataEditGrid1(0).hwnd, False
    CaptionBar1.Caption = Caption
    Set CaptionBar1.Picture = Me.Icon

        PostalCode.Mask = "#####"

        WorkPhone.Mask = "(###)###-####"
    
End Sub

Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
    If m_EnableAttr And tbSave Then
        Select Case MsgBox("Record has been changed. Do you want To save it?" _
            , vbYesNoCancel + vbQuestion)
            Case vbYes
                m_Employee.Save
            Case vbNo
            Case vbCancel
                Cancel = True
        End Select
    End If
End Sub

Private Sub Form_Resize()
        On Error Resume Next
        If Me.WindowState <> vbMinimized Then
            With CaptionBar1
                .Move 0, .Top, Me.ScaleWidth, .height
            End With
            With tabListview
                .Left = 0
                .Top = (WorkPhone.Top + WorkPhone.height + 100)
                .height = Me.ScaleHeight - .Top
                .width = Me.ScaleWidth
                DataEditGrid1(0).Move 100, 100, .width - 200, .height - 450
            End With
        End If
End Sub

Private Sub Form_Unload(Cancel As Integer)
    m_Toolbar.Detach m_Guid
End Sub

Private Sub LoadFormView()
    On Error GoTo Err_LoadFormView
    Dim vItem As Object, frmX As Object, aEmployee As Employee
    
    Set aEmployee = m_Employee
    Select Case tabListview.Tab
        Case 0
                Dim vTimeCard As TimeCard
                Set vItem = New TimeCard
                Set frmX = New frmTimeCard
                Set vTimeCard = aEmployee.TimeCards(DataEditGrid1(tabListview.Tab).CurrentRecord)
                vItem.Load vTimeCard.TimeCardID, True
    End Select
    frmX.Component vItem
    frmX.Show
Done_LoadFormView:
    Exit Sub
Err_LoadFormView:
    If Err <> 91 Then ErrorMsg Err.Number, Err.Description, "LoadFormView", mcstrMod
    Resume Done_LoadFormView
End Sub

Private Sub iForm_MainMenu()
    'n/a
End Sub

Private Property Get iForm_Attributes() As ToolBarItems
    iForm_Attributes = tbCancel + tbCloseMe + tbRefresh + tbSave + tbDeleteRow + tbShowFormView
End Property

Private Sub iForm_Cancel()
    Set m_Employee = m_Store.CopyMe
    LoadRecords
End Sub

Private Sub iForm_CloseMe()
    Unload Me
End Sub

Private Sub iForm_delete()
    'n/a
End Sub

Private Property Get iForm_EnableAttributes() As ToolBarItems
    iForm_EnableAttributes = m_EnableAttr
End Property

Private Sub iForm_Find(ByVal Key As String)
    'n/a
End Sub

Private Sub iForm_Refresh()
    Dim aEmployee As Employee
    Set aEmployee = m_Employee
    aEmployee.Load aEmployee.EmployeeID, True
    Set m_Employee = aEmployee
    LoadRecords
End Sub

Private Function iForm_Save() As Boolean
    DataEditGrid1(tabListview.Tab).Update
    If m_Employee.Save Then
        Set m_Store = m_Employee.CopyMe
        iForm_Refresh
    End If
End Function

Private Sub iForm_AddNew()
    'n/a
End Sub

Private Sub iForm_ShowFormView()
        LoadFormView
End Sub

Private Property Get iForm_FindSubTools() As cFindSubTools
    'n/a
End Property

Private Sub iForm_HelpAbout()
    'n/a
End Sub

Private Function iForm_OpenDB() As Boolean
    'n/a
End Function

Private Sub iForm_DeleteRow()
    DataEditGrid1(tabListview.Tab).delete
End Sub

Private Sub iForm_PrintOut()
    'n/a
End Sub