frmtimecard.frm

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

    On Error GoTo Err_EmployeeID_Click
    m_TimeCard.SetDatabyname EmployeeID.Name, EmployeeID
    EnableToolbar True
    Exit Sub
Err_EmployeeID_Click:
    EmployeeID = m_TimeCard.GetDataByName(EmployeeID.Name)
End Sub
Private Sub EmployeeID_LostFocus()
    On Error Resume Next
    EmployeeID = m_TimeCard.GetDataByName(EmployeeID.Name)
End Sub
 
Private Sub TimeCardID_Change()
    On Error GoTo Err_TimeCardID_Change
    If m_flgLoading Then Exit Sub
    m_TimeCard.SetDatabyname TimeCardID.Name, TimeCardID
    EnableToolbar True
    Exit Sub
Err_TimeCardID_Change:
    With TimeCardID
        .SelStart = 0
        .SelLength = Len(.Text)
        .SelText = m_TimeCard.GetDataByName(TimeCardID.Name)
    End With
End Sub
Private Sub TimeCardID_LostFocus()
    On Error Resume Next
    TimeCardID = m_TimeCard.GetDataByName(TimeCardID.Name)
End Sub



Private Sub tabListview_Click(PreviousTab As Integer)
        
  Me.DataEditGrid1(0).Visible = (tabListview.Tab = 0)
  Me.DataEditGrid1(1).Visible = (tabListview.Tab = 1)
  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 "TimeCardID"
                    Hidden = True
            End Select
            Dim vTimeCardExpense As New TimeCardExpense
            Select Case ColName
                Case "ExpenseAmount"
                    ColName = "销售金额"
                    AutoNumber = False
                    Alignment = 2
                Case "ExpenseCodeID"
                    ColName = "运输方式"
                    AutoNumber = False
                    Alignment = 2
                    ControlType = fcComboBx
                    ComboMaskList = vTimeCardExpense.GetExpenseCodesList
                Case "ExpenseDescription"
                    ColName = "备注"
                    AutoNumber = False
                    Alignment = 0
                Case "ProjectID"
                    ColName = "合同编号"
                    AutoNumber = False
                    Alignment = 2
                    ControlType = fcComboBx
                    ComboMaskList = vTimeCardExpense.GetProjectsList
                Case "TimeCardExpenseID"
                    ColName = "发票编号"
                    AutoNumber = True
                    Alignment = 2
                Case "TimeCardID"
                    ColName = "合同记录编号"
                    AutoNumber = False
                    Alignment = 2
                    ControlType = fcComboBx
                    ComboMaskList = vTimeCardExpense.GetTimeCardsList
                Case "ExpenseDate"
                    ColName = "开票日期"
                    AutoNumber = False
                    Alignment = 1
                    ControlType = fcDateTimePick
            End Select
        Case 1
            Select Case ColName
                Case "TimeCardID"
                    Hidden = True
            End Select
            Dim vTimeCardHour As New TimeCardHour
            Select Case ColName
                Case "发货期数"
                    ColName = "Billable Hours"
                    AutoNumber = False
                    Alignment = 2
                Case "每期发货数"
                    ColName = "Billing Rate"
                    AutoNumber = False
                    Alignment = 2
                Case "ProjectID"
                    ColName = "合同编号"
                    AutoNumber = False
                    Alignment = 2
                    ControlType = fcComboBx
                    ComboMaskList = vTimeCardHour.GetProjectsList
                Case "TimeCardDetailID"
                    ColName = "发货单编码"
                    AutoNumber = True
                    Alignment = 2
                Case "TimeCardID"
                    ColName = "合同纪录编号"
                    AutoNumber = False
                    Alignment = 2
                    ControlType = fcComboBx
                    ComboMaskList = vTimeCardHour.GetTimeCardsList
                Case "WorkCodeID"
                    ColName = "签字级别"
                    AutoNumber = False
                    Alignment = 2
                    ControlType = fcComboBx
                    ComboMaskList = vTimeCardHour.GetWorkCodesList
                Case "WorkDescription"
                    ColName = "备注"
                    AutoNumber = False
                    Alignment = 0
                Case "DateWorked"
                    ColName = "发货日期"
                    AutoNumber = False
                    Alignment = 1
                    ControlType = fcDateTimePick
            End Select
    End Select
End Sub

Private Sub Form_Activate()
    m_Toolbar.Activate m_Guid
End Sub

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

    tabListview_Click 0
        ThinBorder DataEditGrid1(0).hwnd, False
        ThinBorder DataEditGrid1(1).hwnd, False
    CaptionBar1.Caption = Caption
    Set CaptionBar1.Picture = Me.Icon
    
        strCombo = vTimeCard.GetEmployeesList
    FillCombo EmployeeID, strCombo
    EmployeeID.Tag = strCombo
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_TimeCard.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 = (TimeCardID.Top + TimeCardID.height + 100)
                .height = Me.ScaleHeight - .Top
                .width = Me.ScaleWidth
                DataEditGrid1(0).Move 100, 100, .width - 200, .height - 450
                DataEditGrid1(1).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, aTimeCard As TimeCard
    
    Set aTimeCard = m_TimeCard
    Select Case tabListview.Tab
        Case 0
                Dim vTimeCardExpense As TimeCardExpense
                Set vItem = New TimeCardExpense
                Set frmX = New frmTimeCardExpense
                Set vTimeCardExpense = aTimeCard.TimeCardExpenses(DataEditGrid1(tabListview.Tab).CurrentRecord)
                vItem.Load vTimeCardExpense.TimeCardExpenseID
        Case 1
                Dim vTimeCardHour As TimeCardHour
                Set vItem = New TimeCardHour
                Set frmX = New frmTimeCardHour
                Set vTimeCardHour = aTimeCard.TimeCardHours(DataEditGrid1(tabListview.Tab).CurrentRecord)
                vItem.Load vTimeCardHour.TimeCardDetailID
    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_TimeCard = 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 aTimeCard As TimeCard
    Set aTimeCard = m_TimeCard
    aTimeCard.Load aTimeCard.TimeCardID, True
    Set m_TimeCard = aTimeCard
    LoadRecords
End Sub

Private Function iForm_Save() As Boolean
    DataEditGrid1(tabListview.Tab).Update
    If m_TimeCard.Save Then
        Set m_Store = m_TimeCard.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