frmnotelist.frm

金算盘软件代码

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

Private Sub Form_Deactivate()
    frmMain.SetEditUnEnabled
End Sub

'
'窗体 Form 控件
'
Private Sub Form_Load()
    Dim i As Integer
    Dim intSortCol As Integer
    On Error GoTo ErrHandle
'    Me.Hide
'    Me.Left = -30000
    MsgForm.PleaseWait
    Me.HelpContextID = 80006
    frmMain.mnuToolNote.Tag = Me.hwnd
    '付款条件列表窗体初始化
    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.InitFlexGrid
    mclsList.ListSet.ViewId = intViewID
    
'    Set datTerm.Resultset = GetList() '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 mclsMainControl = gclsSys.MainControls.Add(Me)
    
    '设置钩子对象
    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
     Exit Sub
    Dim edtErrReturn As ErrDealType
ErrHandle:
    edtErrReturn = Errors.ErrorsDeal
    
    If edtErrReturn = edtResume Then
         Resume
    Else
         On Error Resume Next
         Unload MsgForm
         Unload Me
    End If
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
        MsgBox "请先关闭备忘录卡片！", vbExclamation
        Cancel = True
        frmNoteListCard.Show
        frmNoteListCard.ZOrder 0
    End If
End Sub

Private Sub Form_Unload(Cancel As Integer)
    On Error Resume Next
    frmMain.mnuEditInActive.Caption = "停用(&H)"
    If Not mclsList Is Nothing Then mclsList.SaveListSet
    frmMain.mnuToolNote.Tag = 0
    Set mclsSubClass = Nothing
    Set mclsSubClassform = Nothing
    Set mclsList = Nothing
    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_KeyPress(KeyAscii As Integer)
    On Error Resume Next
    If KeyAscii = vbKeyEscape Then
        Unload Me
    ElseIf KeyAscii = vbKeyReturn Then
        BKKEY Me.ActiveControl.hwnd, vbKeyTab
    End If
End Sub
Private Sub Form_Activate()
    SetHelpID Me.HelpContextID
    gclsSys.CurrFormName = Me.hwnd
    mclsMainControl_ChildActive
    '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
    UpdateMenuStatus
'    cboFindKind_Click
End Sub

'查找条件类型 ComboBox 控件
Private Sub cboFindKind_Click()
    Dim i As Integer
    Dim intWidth As Integer
    Dim strFind As String
    Dim intSortCol As Integer
    
    mclsList.ReGetColCaption
    With msgTerm
        .Redraw = False
        For i = 1 To .Cols - 1
            If .TextMatrix(0, i) = cboFindKind.Text Then
                '保存新排序列内容
                If .RowHeight(.Row) > 0 Then
                   strFind = .TextMatrix(.Row, i)
                Else
                   strFind = ""
                End If
                '重新排序
                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
    
    SetHelpID Me.HelpContextID
    '响应消息
    For Each vntMessage In mclsMainControl.Messages
        If vntMessage = Message.msgnote Then '接收到付款条件改变消息
            mclsMainControl_ToolRefresh
            mclsMainControl.Messages.Remove CStr(vntMessage) '清除付款条件改变消息
        End If
    Next
    mclsMainControl.Messages.Clear
    UpdateMenuStatus
End Sub

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

Private Sub mclsMainControl_ListReportMenu(ByVal intIndex As Integer)
    mclsMainControl_FilePrint
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 And frmMain.mnuEditEdit.Enabled 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 .ColSel > 0 And .Row > 0 And .MouseRow > 0 Then
                If x > .ColPos(1) And x < .ColPos(2) Then
                    .MousePointer = flexHourglass
                    '完成标志
                    'Finished
                    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 .ColSel > 0 And .MouseRow > 0 And .Row > 0 Then
                If x > .ColPos(1) And x < .ColPos(2) Then
                    '完成标志
                    'Finished
                    mclsMainControl_EditInActive
                End If
            End If
            UpdateMenuStatus
        End If
    End With
End Sub

'
'响应主控对象事件
'

'编辑卡片
Private Sub mclsMainControl_EditEdit()
    Dim lngID As Long
    lngID = TermID
    Me.Enabled = False
    If lngID > 0 Then
        If CheckIDUsed("Note", "lngNoteID", lngID) Then
            frmNoteListCard.EditCard lngID
        Else
            ShowMsg 0, "该备忘录不存在，不能进行修改！", vbExclamation + MB_TASKMODAL, "修改备忘录"
            mclsMainControl_ToolRefresh
        End If
    End If
    Me.Enabled = True
End Sub

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

'删除记录
Private Sub mclsMainControl_EditDel()
    Dim lngID As Long
    'Dim recRecordset As Recordset
    
    lngID = TermID
'    If mIsShowCard Then
'        If lngID = frmTermCard.TermID Then
'            MsgBox "不能删除当前编辑的付款条件！", vbExclamation
'            frmTermCard.SetFocus
'            Exit Sub
'        End If
'    End If
    
   ' Set recRecordset = GetByTermID(lngID)
    'If recRecordset.RecordCount = 0 Then    '当前付款条件已被其他用户删除
    '    mclsMainControl_ToolRefresh
    'Else
'        If IsUseTermID(lngID) Then
'            MsgBox "当前编辑的付款条件正在使用，不能删除！", vbExclamation
'        Else
            'If recRecordset!blnIsdetail Then
               If mIsShowCard Then
                    If lngID = frmNoteListCard.getID And lngID > 0 Then
                        MsgBox "不能删除当前编辑的备忘录！", vbExclamation
                        frmNoteListCard.Show
                        frmNoteListCard.ZOrder 0
                        Exit Sub
                    End If
                End If
                If frmNoteListCard.DelCard(lngID) Then
                   ' mclsMainControl_ToolRefresh
                   With msgTerm
                    .RowHeight(.Row) = 0
                    .RowData(.Row) = 1
                    mclsList.SetFlexRow
                   End With
                    gclsSys.SendMessage CStr(Me.hwnd), Message.msglog
                End If