itemadjust.cls

金算盘软件代码

End Sub

'------------------------------
'从GRID上某一单元格内取出字符串
'------------------------------
Public Function strGrdCell(ByVal lngRow As Long, ByVal lngCol As Long) As String
    Dim lngR As Long, lngC As Long
    Dim blnB As Boolean
    Dim strTmp As String
    Dim blnOldRefresh As Boolean
    If lngCol > frmName.GrdCol.Cols - 1 Then
        strGrdCell = GetTextFromRowProperty(lngRow, lngCol)
        Exit Function
    End If
     
     blnOldRefresh = My.blnRefresh
    If lngRow > frmName.GrdCol.Rows - 1 Or lngCol > frmName.GrdCol.Cols - 1 Or _
       lngRow < 0 Or lngCol < 0 Then
        Exit Function
    End If
    If ColProperty(lngCol).lngCtrType = tCurrency Then
        strTmp = Trim(frmName.GrdCol.TextMatrix(lngRow, lngCol))
        If strTmp <> "" Then
            My.blnRefresh = False
            lngR = frmName.GrdCol.Row
            lngC = frmName.GrdCol.col
            frmName.GrdCol.Row = lngRow
            frmName.GrdCol.col = lngCol
            If CLng(frmName.GrdCol.CellForeColor) = CLng(RGB(255, 0, 0)) Then
                strTmp = "-" & strTmp
            End If
            frmName.GrdCol.Row = lngR
            frmName.GrdCol.col = lngC
            My.blnRefresh = blnOldRefresh
        End If
'        If blnFilterCama Then
'            strGrdCell = FilterString(strTmp, ",")
'        Else
            strGrdCell = strTmp
'        End If
    Else
        strGrdCell = frmName.GrdCol.TextMatrix(lngRow, lngCol)
    End If
End Function
Public Sub Form_key_Down(ByVal KeyCode As Long)
    Dim bCancel As Long
    HookHe_OnMessage frmName.hWnd, WM_KEYDOWN, KeyCode, 0, bCancel
End Sub

Private Sub HookHe_OnMessage(ByVal hWnd As Long, ByVal Msg As Long, ByVal wParam As Long, ByVal lParam As Long, bCancel As Long)
    On Error Resume Next
    If Msg = WM_CHAR Or Msg = WM_KEYDOWN Or Msg = WM_KEYUP Then
        If m_bBusy Then
            bCancel = 1
            Exit Sub
        End If
        If mblnNotRespondKeyPress Then
            Exit Sub
        End If
    End If
    If Msg = WM_KEYDOWN Then
          If Not (frmName.refInput.ReferVisible Or frmName.refInput1.ReferVisible Or frmName.dtmInput.IsDropDown = 1) Then
            If wParam = 38 Or wParam = 40 Then
                mblnReadOnly = (Not My.blnMayChange) Or frmName.chkPrint(1).Value = 1 '权限控制
                If mblnReadOnly Then
                    If My.bytRegion = FNote Then
                        If wParam = 38 Then
                            If frmName.GrdCol.Row = 1 Then
                                mblnKeyDown = True
                            End If
                        ElseIf wParam = 40 Then
                            If frmName.GrdCol.Row = frmName.GrdCol.Rows - 1 Then
                                mblnKeyDown = True
                            End If
                        End If
                    Else
                        mblnKeyDown = True
                    End If
                Else
                    mblnKeyDown = True
                End If
            ElseIf wParam = 37 Then ' left
                If My.bytRegion = FField Or My.bytRegion = FHead Or My.bytRegion = FNote Or My.bytRegion = FGrid Or My.bytRegion = FcmdFooter Or My.bytRegion = FFooter Then
                    If Not ctrInput Is Nothing Then
                        If ctrInput.Name = "picInput" Then
                            If NewQ.SelStart = 0 Then
                                mblnKeyDown = True
                            End If
                        Else
                            If ctrInput.SelStart = 0 Then
                                mblnKeyDown = True
                            End If
                        End If
                    Else
                        mblnKeyDown = True
                    End If
                Else
                    mblnKeyDown = True
                End If
            ElseIf wParam = 39 Then 'right
                If My.bytRegion = FField Or My.bytRegion = FHead Or My.bytRegion = FNote Or My.bytRegion = FGrid Or My.bytRegion = FcmdFooter Or My.bytRegion = FFooter Then
                    If Not ctrInput Is Nothing Then
                        If ctrInput.Name = "picInput" Then
                            If NewQ.SelStart = Len(NewQ.Text) Then
                                mblnKeyDown = True
                            End If
                        Else
                            If ctrInput.SelStart = Len(ctrInput.Text) Then
                                mblnKeyDown = True
                            End If
                        End If
                    Else
                        mblnKeyDown = True
                    End If
                Else
                    mblnKeyDown = True
                End If
            ElseIf wParam = 27 Then
                mblnKeyDown = True
            End If
        End If
        If wParam = 9 Or wParam = 13 Then
            mblnKeyDown = True
        End If
    End If
    If Msg = WM_KEYUP Then
        If mblnKeyDown = False Then Exit Sub
        mblnKeyDown = False
        If wParam = 13 Then
            If GetKeyState(17) < 0 Then
                Exit Sub
            End If
        End If
        If (frmName.refInput.ReferVisible Or frmName.refInput1.ReferVisible Or frmName.dtmInput.IsDropDown = 1) Then
             Exit Sub
        End If
        
        If wParam = 37 Or wParam = 38 Or wParam = 39 Or wParam = 40 Or wParam = 9 Or wParam = 13 Then  'TAB键处理程序
            m_bBusy = True
            TabOrder (wParam)
            m_bBusy = False
        ElseIf wParam = 27 Then 'ESCAPE
            Reload
        End If
    End If
End Sub


Private Sub mclsSubClass_WndProc(Msg As Long, wParam As Long, lParam As Long, Result As Long)
    Dim lngX As Long, lngY As Long
    Dim sinX As Single, sinY As Single
    Dim lngCnt As Long
    Dim i As Integer, mOldRow As Integer, mOldCol As Integer
    Dim intRow As Integer
    Static blnColDrag As Boolean

    lngX = (lParam Mod (2 ^ 16)) * Screen.TwipsPerPixelX
    lngY = (lParam \ (2 ^ 16)) * Screen.TwipsPerPixelY
    sinX = lngX
    sinY = lngY
    If Msg = WM_LBUTTONUP Then
        mclsSubClass.CallWndProc Msg, wParam, lParam
        '确保第0列不被拖出
        If blnColDrag Then
            blnColDrag = False
            If frmName.GrdCol.ColWidth(0) > 0 Then frmName.GrdCol.ColWidth(0) = 0
            For i = 1 To frmName.GrdCol.Cols - 1
                If ColProperty(i).blnUsable = False Then
                    If frmName.GrdCol.ColWidth(i) <> 0 Then frmName.GrdCol.ColWidth(i) = 0
                Else
                    If ColProperty(i).lngCtrType = TRefer Or ColProperty(i).lngCtrType = TRecList Then
                        If frmName.GrdCol.ColWidth(i) < 500 Then frmName.GrdCol.ColWidth(i) = 500
                    Else
                        If frmName.GrdCol.ColWidth(i) < 100 Then frmName.GrdCol.ColWidth(i) = 100
                    End If
                End If
            Next i
            With frmName.GrdCol
                My.blnRefresh = False
'                If .ColWidth(.col) < 490 Then
'                    .ColWidth(.col) = 490
'                End If
                If My.bytRegion = FGrid Or My.bytRegion = FPicture Then
                    If My.bytIndex <> .col Then
                        .col = My.bytIndex
                    End If
                     GrdInputButtonLocal .Row, .col
                End If
                TotalRowAdjust
                My.blnRefresh = True
                'frmname.Refresh
            End With
        End If
        Exit Sub
    End If
    
    If Msg = WM_LBUTTONDOWN Then        '鼠标左键按下
        With frmName.GrdCol
            If .MouseRow < .FixedRows Then    '点中固定行
                '判断鼠标是否点中列线以便拖动
                i = .MouseCol
                If lngX >= .ColPos(i) + .ColWidth(i) - 50 Or lngX <= .ColPos(i) + 50 Then
                    blnColDrag = True
                End If
            End If
        End With
        mclsSubClass.CallWndProc Msg, wParam, lParam
        Exit Sub
    End If
    
    If Msg = WM_PAINT Then
    '取Paint事件矩形区域
        If My.blnRefresh Then
            '取Paint事件矩形区域
            If Not m_pBusy Then
                m_pBusy = True
                GetUpdateRect frmName.GrdCol.hWnd, GridClipRect, False
                mclsSubClass.CallWndProc Msg, wParam, lParam
                If frmName.GrdCol.Visible Then
                    DrawGridLine
                    'DrawReadOnlyCol
                End If
                m_pBusy = False
            End If
        End If
    Else
        mclsSubClass.CallWndProc Msg, wParam, lParam
    End If
End Sub

Private Sub mclsHook_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 = lngDefaultWidth \ Screen.TwipsPerPixelX
        MinMax.ptMinTrackSize.y = lngDefaultHeight \ Screen.TwipsPerPixelY
        MinMax.ptMaxTrackSize.x = 1800
        MinMax.ptMaxTrackSize.y = 1600
        
        CopyMemory ByVal lParam, MinMax, Len(MinMax)
        Result = 0
        Exit Sub
    End If
        

    If Msg = WM_PAINT Then
        If My.blnRefresh Then
            '取Paint事件矩形区域
            GetUpdateRect frmName.hWnd, FormClipRect, False
            mclsHook.CallWndProc Msg, wParam, lParam
            If frmName.GrdCol.Visible Then DrawTotalBox
        End If
    Else
        mclsHook.CallWndProc Msg, wParam, lParam
    End If
End Sub

Private Sub DrawGridLine()
    
    Dim intI As Integer
    Dim lngL As Long
    Dim lngT As Long
    Dim lngR As Long
    Dim lngB As Long
    
    Dim hdc As Long
    
    My.blnRefresh = False
    With frmName.GrdCol
    hdc = GetDC(.hWnd)
        '画GRID网格线
        '画竖线
        lngT = 0
        lngB = .Height
        intI = 1
        lngL = .ColPos(intI) + .ColWidth(intI) - Screen.TwipsPerPixelX
        lngR = lngL
        DrawALine hdc, lngL, 0, lngL, lngB, GridClipRect.Left, GridClipRect.top, GridClipRect.Right, GridClipRect.Bottom, frmColor.lngGridLineColor
        For intI = .LeftCol To .Cols - 1
            lngL = .ColPos(intI) + .ColWidth(intI) - Screen.TwipsPerPixelX
            lngR = lngL
            If lngL >= .width Then
                Exit For
            Else
                DrawALine hdc, lngL, 0, _
                               lngL, lngB, _
                            GridClipRect.Left, GridClipRect.top, GridClipRect.Right, GridClipRect.Bottom, frmColor.lngGridLineColor
            End If
        Next intI
        For intI = 1 To 40
            '画水平线
            If .RowHeight(0) * intI > .Height Then Exit For
                If .Row > 0 And (intI = .Row - .TopRow + 1 Or intI = .Row + 1 - .TopRow + 1) Then
                    DrawBLine hdc, 0, .RowHeight(0) * intI - Screen.TwipsPerPixelY, _
                           .width, .RowHeight(0) * intI - Screen.TwipsPerPixelY, _
                             CLng(RGB(0, 0, 255))
                Else
                    DrawBLine hdc, 0, .RowHeight(0) * intI - Screen.TwipsPerPixelY, _
                           .width, .RowHeight(0) * intI - Screen.TwipsPerPixelY, _
                            SeparateLineColor
                End If
        Next intI
        If frmName.chkPrint(1).Value <> 0 Then
            DrawAIcon frmName.GrdCol.hWnd, .Left + (.width - 140 * Screen.TwipsPerPixelX) \ 2, .RowHeight(0) + (.Height - .RowHeight(0) - 70 * Screen.TwipsPerPixelY) \ 2, 1024
            Utility.RemoveFormResPicture (1024)
        End If
    My.blnRefresh = True
    ReleaseDC .hWnd, hdc
    End With