frmclassitemlist.frm

金算盘软件代码

        txtFind.Text = ""
        mclsList.FindNoChange = blnFindNoChange
        cmdAgain.Enabled = False
    End If
End Sub

'重画Form
Private Sub RedrawForm()
    '重画MS FlexGrid 控件
    On Error Resume Next
    With msgTerm
        .Left = ListFormLeft
        .Width = Me.ScaleWidth - ListFormLeft - ListFormRight
        .Height = Me.ScaleHeight - ListUpAreaHeight - ListDownAreaHeight
    End With
    
    '重画其余控件
    txtFind.Width = Me.ScaleWidth - txtFind.Left - ListFormBottom - cmdAgain.Width - 15
    cmdAgain.Left = txtFind.Left + txtFind.Width
    cmdClass2(0).top = Me.ScaleHeight - cmdClass2(0).Height - ListFormBottom
    cmdClass2(1).top = cmdClass2(0).top
   
    chkShowAll.top = cmdClass2(0).top
    chkShowAll.Left = Me.ScaleWidth - chkShowAll.Width - ListFormBottom
End Sub

Private Sub cmdClass2_Click(Index As Integer)
    Select Case Index
        Case 0
             MakeListEditMenu
             PopupMenu frmMain.mnuListEdit, , cmdClass2(0).Left, cmdClass2(0).top + cmdClass2(0).Height
        
        Case 1
            MakeListReportMenu
            PopupMenu frmMain.mnuListReport, , cmdClass2(1).Left, cmdClass2(1).top + cmdClass2(1).Height
    End Select
End Sub

'
'窗体 Form 控件
'
Private Sub Form_Load()
    Dim i As Integer
    Dim intSortCol As Integer
    Me.Hide
    Me.Left = -30000
    MsgForm.PleaseWait
    SetHelpID Me.hwnd, 30013
    '付款条件列表窗体初始化
    Debug.Print "Load Start: ", Timer
    Set mclsList = New list
    mclsList.FlexNoChange = True
    mclsList.FindNoChange = True
    Set mclsList.FlexGrid = msgTerm
    Set mclsList.FindKind = cboFindKind
    Set mclsList.Find = txtFind
    Set mclsList.Again = cmdAgain
    mclsList.ListSet.ViewId = intViewID
    mclsList.InitFlexGrid
'    Set datTerm.Resultset = GetList()
'
'    If Not datTerm.Resultset.EOF Then datTerm.Resultset.MoveLast
'    datTerm.Resultset.Close
'    'Set datTerm.Recordset = Nothing
'    mclsList.SetFlexGrid
'    mclsList.InitcboFindKind
'    mclsList.FlexNoChange = False
'    mclsList.FindNoChange = False
'
'
'    With msgTerm
'        If .Rows > 1 Then msgTerm.Row = 1
'        .col = 0
'        .ColSel = .Cols - 1
'    End With
'    Debug.Print "Load End: ", Timer
'    mclsList.DoShowAll False
'    UpdateMenuStatus
    
    '设置钩子对象
    Set mclsSubClass = New SubClass32.SubClass
    mclsSubClass.hwnd = msgTerm.hwnd
    mclsSubClass.Messages(WM_PAINT) = True
    mclsSubClass.Messages(WM_LBUTTONUP) = True
    mclsSubClass.Messages(WM_LBUTTONDOWN) = True
    mclsSubClass.Messages(WM_MOUSEMOVE) = True
    Set mclsSubClassform = New SubClass32.SubClass
    mclsSubClassform.hwnd = Me.hwnd
    mclsSubClassform.Messages(WM_GETMINMAXINFO) = True
    Unload MsgForm
    Set mclsMainControl = gclsSys.MainControls.Add(Me)
End Sub

'右键菜单
Private Sub Form_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
    If Button = vbRightButton And frmMain.ActiveForm Is Me Then
        MakeListEditMenu
        PopupMenu frmMain.mnuListEdit
    End If
End Sub

Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
    If UnloadMode = vbFormControlMenu And mIsShowCard Then
        ShowMsg Me.hwnd, "请先关闭项目卡片！", vbExclamation, "项目核算卡片"
        Cancel = True
        'frmClass2listCard.SetFocus
        frmClass2ListCard.Show
        frmClass2ListCard.ZOrder 0
    End If
End Sub

Private Sub Form_Unload(Cancel As Integer)
    If mIsShowCard Then Unload frmClass2ListCard
    mclsList.SaveListSet
    gclsSys.MainControls.Remove Me
    Set mclsMainControl = Nothing
End Sub

Private Sub Form_Resize()
  
    On Error Resume Next
    If Me.WindowState = 1 Then Exit Sub
    If Me.Left + Me.Width < 0 Or Me.Left > Screen.Width Then
       Me.Left = 300
    End If
    RedrawForm
End Sub

Private Sub Form_Activate()
    mclsMainControl_ChildActive
    gclsSys.CurrFormName = Me.hwnd
'    If msgTerm.Enabled Then msgTerm.SetFocus
    msgTerm.Redraw = True
    UpdateMenuStatus
   ' If (Me.Left + Me.Width < 0 Or Me.Left > Screen.Width) Then Me.Left = 300
    If Me.WindowState = 1 Then Me.WindowState = 0
End Sub


'
'显示全部记录/未停用记录 CheckBox 控件
'
Private Sub chkShowAll_Click()
    msgTerm.Redraw = False
    mclsList.DoShowAll chkShowAll.Value
    msgTerm.Redraw = True
    'cboFindKind_Click
    UpdateMenuStatus
End Sub

'
'查找条件类型 ComboBox 控件
'
Private Sub cboFindKind_Click()
    Dim i As Integer
    Dim intWidth As Integer
    Dim strFind As String
    Dim intSortCol As Integer
    
    With msgTerm
        .Redraw = False
        For i = 1 To .Cols - 1
            If .TextMatrix(0, i) = cboFindKind.Text Then
                '保存新排序列内容
                strFind = .TextMatrix(.Row, i)
                '重新排序
                mclsList.FixrowSortBold i
                Exit For
            End If
       Next
    End With
   
     '恢复以前选定行
    If msgTerm.Rows > 1 Then
        If txtFind.Text = strFind Then
            txtFind_Change
        Else
            txtFind.Text = strFind
        End If
    End If
    msgTerm.Redraw = True
End Sub

Private Sub mclsMainControl_ChildActive()
     '响应消息
     Dim vntMessage As Variant
     gclsSys.CurrFormName = Me.hwnd
    For Each vntMessage In mclsMainControl.Messages
        If vntMessage = Message.msgClass2 Then '接收到付款条件改变消息
            mclsMainControl_ToolRefresh
            mclsMainControl.Messages.Remove CStr(vntMessage) '清除付款条件改变消息
        End If
    Next
    mclsMainControl.Messages.Clear
    UpdateMenuStatus
End Sub

'记事薄
Private Sub mclsMainControl_EditNotepad()
    Dim i As Integer
    Dim strCode As String
    Dim strName As String
    Dim strResult As String
    Dim recCurren As rdoResultset
    Dim strSql As String
    With msgTerm
        If .Row > 0 Then
            For i = 0 To mclsList.ListSet.FixColumns - 1
                If .TextMatrix(0, 2 + i) = "项目编码" Then
                    strCode = .TextMatrix(.Row, 2 + i)
                ElseIf .TextMatrix(0, i + 2) = "项目名称" Then
                    strName = .TextMatrix(.Row, 2 + i)
                End If
            Next
        End If
    End With
    Set recCurren = GetByTermID(TermID)
    strResult = frmNotePad.EditCard("项目核算", strCode, strName, IIf(IsNull(recCurren!strNotes), "", recCurren!strNotes))
    recCurren.Close
    If strResult = "" Then Exit Sub
    strSql = "Update  Class2 set strNotes='" & strResult & "' Where lngClassID=" & TermID
    gclsBase.ExecSQL (strSql)
End Sub

Private Sub mclsMainControl_FilePrintSetup()
    Dim MyPrintSet As PrintClass
    Set MyPrintSet = New PrintClass
    MyPrintSet.PrintSetUp gclsBase.BaseDB, mclsList.FlexGrid, , , , 20, " ," & gclsBase.BaseName & "," & gclsBase.OperatorName
End Sub

Private Sub mclsMainControl_ListReportMenu(ByVal intIndex As Integer)
    Select Case intIndex
        Case 0
        
        'Case 2
            ClassTable
    End Select
End Sub

Private Sub mclsSubClassForm_WndProc(Msg As Long, wParam As Long, lParam As Long, Result As Long)
    Dim MinMax As MINMAXINFO

    If Msg = WM_GETMINMAXINFO Then
        CopyMemory MinMax, ByVal lParam, Len(MinMax)
        
        MinMax.ptMinTrackSize.x = 430
        MinMax.ptMinTrackSize.y = 250
        
        CopyMemory ByVal lParam, MinMax, Len(MinMax)
        Result = 0
    End If
End Sub



'
'查找内容 TextBox 控件
'
Private Sub txtFind_Change()
      mclsList.TextFind txtFind.Text
End Sub

Private Sub txtFind_KeyDown(KeyCode As Integer, Shift As Integer)
    Dim intSelLen As Integer
    If KeyCode = 8 Then
        intSelLen = txtFind.SelLength
        If txtFind.SelStart > 0 Then txtFind.SelStart = txtFind.SelStart - 1
        txtFind.SelLength = intSelLen + 1
    End If
End Sub


' FLEXGRID控件
'

'双击FLEXGRID调用卡片
Private Sub msgTerm_DblClick()
    If msgTerm.MouseRow > 0 And msgTerm.ColSel > 0 And msgTerm.MouseCol > 1 Then
        mclsMainControl_EditEdit
    End If
End Sub

'单击FLEXGRID停用列,停用或启用当前记录
Private Sub msgTerm_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
    Dim blnCancel As Boolean
    
    With msgTerm
        If Button = vbLeftButton Then
            If chkShowAll.Value = 1 And .ColSel > 0 And .Row > 0 And .MouseRow > 0 Then
                If x > .ColPos(1) And x < .ColPos(2) Then
                    .MousePointer = flexHourglass
                    mclsMainControl_EditInActive
                    .MousePointer = flexDefault
                End If
            End If
        Else
            Form_MouseDown Button, Shift, x, y
        End If
    End With
End Sub

'鼠标左键弹起时，更新菜单
Private Sub msgTerm_MouseUp(Button As Integer, Shift As Integer, x As Single, y As Single)
  
   With msgTerm
        If Button = vbLeftButton Then
            If chkShowAll.Value = 1 And .ColSel > 0 And .MouseRow > 0 Then
                If x > .ColPos(1) And x < .ColPos(2) Then
                    mclsMainControl_EditInActive
                End If
            End If
            UpdateMenuStatus
        End If
    End With
End Sub

'
'响应主控对象事件
'

'编辑卡片
Private Sub mclsMainControl_EditEdit()
    Me.Enabled = False
    If TermID > 0 Then frmClass2ListCard.EditCard TermID, vbModeless
    Me.Enabled = True
End Sub

'新增卡片
Private Sub mclsMainControl_EditNew()
   frmClass2ListCard.AddCard
End Sub

'删除记录
Private Sub mclsMainControl_EditDel()
    Dim lngID As Long
   ' Dim recRecordset As rdoResultset
    lngID = TermID
    If mIsShowCard Then
        If lngID = frmClass2ListCard.ClassID Then
            MsgBox "不能删除当前编辑的项目！", vbExclamation
            frmClass2ListCard.Show
            frmClass2ListCard.ZOrder 0
            Exit Sub
        End If
    End If

    If frmClass2ListCard.DelCard(lngID) Then
        UpDatePreFlage
        With msgTerm
            .RowHeight(.Row) = 0
            .RowData(.Row) = 1
            mclsList.SetFlexRow
        End With
        gclsSys.SendMessage CStr(0), Message.msgClass2
    End If
    UpdateMenuStatus
   ' If Not frmClass2ListCard.Visible Then
    Unload frmClass2ListCard
End Sub

'停用/启用记录
Private Sub mclsMainControl_EditInActive()
'     If UpdateTermInActive(TermID, Not TermIsInActive) Then
'        With msgTerm
'            If chkShowAll.Value Then
'                If .TextMatrix(.Row, 1) = "" Then
'                    .TextMatrix(.Row, 1) = "√"
'                Else
'                    .TextMatrix(.Row, 1) = ""
'                End If
'            Else
'                .TextMatrix(.Row, 1) = "√"
'                .RowHeight(.Row) = 0
'                mclsList.SetFlexRow
'            End If
'        End With
'        '发出付款条件消息
'        gclsSys.SendMessage CStr(Me.hWnd), Message.msgClass
'    End If
    CeaseLower
    UpdateMenuStatus
End Sub

'全部显示/显示未停用记录
Private Sub mclsMainControl_EditShowAll()
    frmMain.mnuEditShowAll.Checked = Not frmMain.mnuEditShowAll.Checked
    If chkShowAll.Value = 0 Then
        chkShowAll.Value = 1
    Else
        chkShowAll.Value = 0
    End If
End Sub

'引用编码
Private Sub mclsMainControl_EditUse()
    UseCode Message.msgClass2, TermID
    Me.ZOrder 1
End Sub

'筛选
Private Sub mclsMainControl_EditFilter()
   ' mclsList.Filter intViewID
    Dim blnFlage As Boolean
'    If Not mblnIsSaveListset Then
'        If Not FindlngViewID(intViewID) Then mclsList.ListSet.SaveList
'        mblnIsSaveListset = True
'    End If
    If mclsList.ListSet.ListID < 1 Then mclsList.ListSet.SaveList
    Filter.ShowFilter mclsList.ListSet.ListID, 1, , , , , blnFlage
    If Not blnFlage Then Exit Sub
    mclsList.SaveListSet
    mclsList.ListSet.ViewId = intViewID
    msgTerm.Cols = 0
    Set datTerm.Resultset = GetList()
    If Not datTerm.Resultset.EOF Then datTerm.Resultset.MoveLast
    datTerm.Resultset.Close
    'Set datTerm.Recordset = Nothing
    mclsList.SetFlexGrid