frmpayableinfo.frm

金算盘软件代码

   End
   Begin VB.Shape Shape1 
      BackColor       =   &H00FFFFFF&
      BackStyle       =   1  'Opaque
      BorderColor     =   &H80000010&
      Height          =   1485
      Index           =   1
      Left            =   30
      Top             =   210
      Width           =   6210
   End
   Begin VB.Shape Shape1 
      BackColor       =   &H80000010&
      BackStyle       =   1  'Opaque
      BorderColor     =   &H80000010&
      Height          =   1485
      Index           =   0
      Left            =   105
      Top             =   300
      Width           =   6240
   End
End
Attribute VB_Name = "frmPayableInfo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'---------------------------------
'应付单回款资料
'王兴元
'1998年7月
'提供给外部调用的方法
'   SetList(frmName,ActivityID)
'---------------------------------
Private WithEvents mclsSubClass As SubClass32.SubClass          '“钩子”对象
Attribute mclsSubClass.VB_VarHelpID = -1
Private mclsGrid As Grid
Private ActivityID1 As Long
Private ActivityTypeID1 As Long
Private blnBz As Boolean
Private frm As Form

Private lngCurID As Long
Private lngActID As Long
Private lngDepID As Long
Private lngEmpID As Long
Private lngJobID As Long
Private lngClsID1 As Long
Private lngClsID2 As Long
Private lngCustomerID As Long
Private strRate As String
Private strAmount As String
Private strCurrAmount As String

Private intCurDec As Integer
Private intRateDec As Integer



'lngActivityID:应付单号
Public Sub SetList(frmName As Form, ByVal ActivityID As Long)
    Dim strSql As String
    Dim recTemp As rdoResultset
    Dim i As Integer
    Dim dblMoney As Double
    Dim Que As rdoQuery
    
    On Error GoTo Err
    
    Screen.MousePointer = vbHourglass
    '===================判断有无付款记录====================
    If gclsBase.ControlAccount Then
            strSql = "SELECT DECODE(zSPBillInfo.strSource,'0',QARAPInit.lngARAPInitID," _
                        & "'2',ItemActivityQuery.lngActivityID," _
                        & "ActivityQuery.Activity_lngActivityID) AS 付款ID, " _
                        & "DECODE(zSPBillInfo.strSource,'0',QARAPInit.strDate," _
                        & "'2',ItemActivityQuery.strDate,"
            strSql = strSql & "ActivityQuery.strDate) AS 日期, ' ' AS 单据类型, " _
                        & "DECODE(zSPBillInfo.strSource,'0',QARAPInit.strReceiptNo," _
                        & "'2',ItemActivityQuery.strReceiptNo," _
                        & "ActivityQuery.strReceiptNo) || TO_CHAR(DECODE(zSPBillInfo.strSource,'0'," _
                        & "QARAPInit.lngReceiptNo,'2'," _
                        & "ItemActivityQuery.lngReceiptNo,ActivityQuery.lngReceiptNo),'0000') AS 单据号, "
            strSql = strSql & "zSPBillInfo.dblCurrPaymentAmount AS 付款金额, " _
                        & "zSPBillInfo.dblCurrDisCount AS 折扣金额, 0 AS 应付余额, " _
                        & "zSPBillInfo.lngActivityTypeID AS 业务类型ID, DECODE(zSpBillInfo.strSource,'0'," _
                        & "QARAPInit.bytCurrencyDec,DECODE(zSpBillInfo.strSource,'2'," _
                        & "ItemActivityQuery.bytCurrencyDec,ActivityQuery.bytCurrencyDec)) AS bytCurrencyDec, " _
                        & "zSPBillInfo.strSource AS strSource "
            strSql = strSql & "FROM zSPBillInfo,QArApInit,ItemActivityQuery,ActivityQuery " _
                        & " WHERE zSPBillInfo.lngCashActivityDetailID = " _
                        & "QArApInit.lngARAPInitID(+) AND zSPBillInfo.lngCashActivityDetailID = " _
                        & "ActivityQuery.lngActivityDetailID(+) AND  " _
                        & "zSPBillInfo.lngCashActivityDetailID = ItemActivityQuery.lngActivityDetailID(+) " _
                        & "AND zSPBillInfo.dblCurrPaymentAmount <> 0 AND " _
                        & "zSPBillInfo.lngActivityID =" & ActivityID
    Else
            strSql = "SELECT DECODE(zSpBillInfoNotControlAccount.strSource,'0'," _
                        & "ARAPInitQuery.lngARAPInitID,'2'," _
                        & "ItemActivityQuery.lngActivityID,'3'," _
                        & "VoucherQuery.lngVoucherID1,ActivityQuery.Activity_lngActivityID) AS 付款ID, " _
                        & "DECODE(zSpBillInfoNotControlAccount.strSource,'0',ArapInitQuery.strDate," _
                        & "'1',ActivityQuery.strDate," _
                        & "'2',ItemActivityQuery.strDate," _
                        & "VoucherQuery.strDate) AS 日期,"
            strSql = strSql & "' ' AS 单据类型, DECODE(zSpBillInfoNotControlAccount.strSource,'0'," _
                        & "VoucherType.strVoucherTypeCode,'2'," _
                        & "ItemActivityQuery.strReceiptNo,'3'," _
                        & "VoucherType.strVoucherTypeCode,ActivityQuery.strReceiptNo) || "
            strSql = strSql & "TO_CHAR(DECODE(zSpBillInfoNotControlAccount.strSource,'0'," _
                        & "ARAPInitQuery.intVoucherNo,'2'," _
                        & "ItemActivityQuery.lngReceiptNo,'3'," _
                        & "VoucherQuery.intVoucherNO,ActivityQuery.lngReceiptNo),'0000') AS 单据号, " _
                        & "zSpBillInfoNotControlAccount.dblCurrPaymentAmount AS 付款金额, " _
                        & "zSpBillInfoNotControlAccount.dblCurrDisCount AS 折扣金额, 0 AS 应付余额, " _
                        & "zSpBillInfoNotControlAccount.lngActivityTypeID AS 业务类型ID, "
            strSql = strSql & "DECODE(zSpBillInfoNotControlAccount.strSource,'2'," _
                        & "ItemActivityQuery.bytCurrencyDec,'3'," _
                        & "VoucherQuery.bytCurrencyDec,'0'," _
                        & "ARAPInitQuery.bytCurrencyDec,ActivityQuery.bytCurrencyDec) as bytCurrencyDec," _
                        & "zSpBillInfoNotControlAccount.strSource AS strSource "
            strSql = strSql & "FROM zSpBillInfoNotControlAccount,VoucherType,ActivityType,ActivityQuery,ItemActivityQuery " _
                        & ",ArapInitQuery,VoucherQuery" _
                        & " WHERE zSpBillInfoNotControlAccount.lngActivityTypeID = VoucherType.lngVoucherTypeID(+) " _
                        & "and zSpBillInfoNotControlAccount.lngActivityTypeID = ActivityType.lngActivityTypeID(+) " _
                        & "and zSpBillInfoNotControlAccount.lngCashActivityDetailID = ActivityQuery.lngActivityDetailID(+) " _
                        & "and zSpBillInfoNotControlAccount.lngCashActivityDetailID = ItemActivityQuery.lngActivityDetailID(+) "
            strSql = strSql & "and zSpBillInfoNotControlAccount.lngCashActivityDetailID = ArapInitQuery.lngARAPInitID(+) " _
                        & "and zSpBillInfoNotControlAccount.lngCashActivityDetailID = VoucherQuery.lngVoucherDetailID(+) " _
                        & "and zSpBillInfoNotControlAccount.dblCurrPaymentAmount <> 0 " _
                        & "and zSpBillInfoNotControlAccount.lngActivityID = " & ActivityID
    End If
    Set recTemp = gclsBase.BaseDB.OpenResultset(strSql, rdOpenStatic)
    
    '===================有付款记录====================
    Set datGrid.Resultset = recTemp
    '显示"应付单信息"
    With frmPayableInfo
        .lblField(0).Caption = frmName.lblHead(1).Caption  '单位
        lngCustomerID = C2lng(frmName.lblHead(0).Tag)
        .lblField(1).Caption = frmName.lblField(1).Caption   '单据号
        .lblField(2).Caption = cutString(frmName.lblField(15).Caption)  '付款条件
        .lblField(3).Caption = frmName.lblField(2).Caption   '日期
        .lblField(4).Caption = cutString(frmName.lblField(12).Caption)  '币种
        .lblField(5).Caption = cutString(frmName.lblField(4).Caption)  '部门
        .lblField(6).Caption = cutString(frmName.lblField(3).Caption)  '业务员
        .lblField(7).Caption = GetLabel(frmName.lblField(10))
    End With
    '---------------GET OTHER ID-------------------------
        lngCurID = frmName.GetOtherID(12)   'CurrencyID
        lngActID = frmName.GetOtherID(5)    'lngAccountID
        lngCustomerID = C2lng(frmName.lblHead(0).Tag)   'lngCustomerID
        lngDepID = frmName.GetOtherID(4)    'lngDepartmentID
        lngEmpID = frmName.GetOtherID(3)    'lngEmployeeID
        lngJobID = frmName.GetOtherID(8)    'lngJobID
        lngClsID1 = frmName.GetOtherID(7)    'lngClassID1
        lngClsID2 = frmName.GetOtherID(6)    'lngClassID2
        Call BillPublic.CurRateDec(lngCurID, intCurDec, intRateDec)
        lblField(7).Caption = Format(lblField(7).Caption, FormatString(intCurDec))
        strRate = Format(GetLabel(frmName.lblField(11)), FormatString(intRateDec))   'Rate
        strAmount = Format(GetLabel(frmName.lblField(9)), FormatString(gclsBase.NaturalCurDec)) 'strAmount
    '------------------END ------------------------------

    '显示"付款信息":将生成结果绑定到MSFlexGrid控件中:
    If Not recTemp Is Nothing Then
        If Not (recTemp.BOF And recTemp.EOF) Then
            recTemp.MoveLast
            recTemp.MoveFirst
        End If
    End If
    '-------------计算“余额”--------------
    dblMoney = C2Dbl(lblField(7).Caption)
    With grdList
        If grdList.Rows > 1 Then
            For i = 1 To grdList.Rows - 1
                .TextMatrix(i, 4) = Format(C2Dbl(.TextMatrix(i, 4)), FormatString(C2Dbl(.TextMatrix(i, 8))))
                .TextMatrix(i, 5) = Format(C2Dbl(.TextMatrix(i, 5)), FormatString(C2Dbl(.TextMatrix(i, 8))))
                dblMoney = dblMoney - C2Dbl(.TextMatrix(i, 4)) - C2Dbl(.TextMatrix(i, 5))
                .TextMatrix(i, 6) = Format(C2Dbl(dblMoney), FormatString(C2Dbl(.TextMatrix(i, 8))))
                '写单据类型
                Call ID2str(i, .TextMatrix(i, 9))
            Next i
        End If
    End With
    grdList.ColWidth(1) = 990
    If gclsBase.ControlAccount Then
        grdList.ColWidth(2) = 1057
    Else
        If grdList.Rows = grdList.FixedRows Then
            grdList.ColWidth(2) = 0
            grdList.TextMatrix(0, 3) = "凭证字号"
        ElseIf grdList.ColWidth(2) <> 0 Then
            grdList.ColWidth(2) = 1057
        End If
    End If
    grdList.ColWidth(3) = 825
    grdList.ColWidth(4) = 1340
    grdList.ColWidth(5) = 1340
    grdList.ColWidth(6) = 1340
    grdList.ColWidth(7) = 0
    grdList.ColWidth(8) = 0
    grdList.ColWidth(9) = 0
    If gclsBase.ControlAccount = False Then
        #If conVersionType = 16 Then
            grdList.ColWidth(2) = 0
        #End If
    End If
    mclsGrid.ColOfs = 1
    mclsGrid.SetupStyle
    grdList.ColSel = grdList.Cols - 1
    blnBz = False
    If grdList.Rows = grdList.FixedRows Then
        cmdButton(1).Enabled = False
    End If
    Screen.MousePointer = vbDefault
    frmPayableInfo.Show vbModal
    Set recTemp = Nothing
    If blnBz Then
        ShowBill ActivityTypeID1, ActivityID1
    End If
    Unload Me
    Exit Sub
Err:
    ShowMsg Me.hwnd, "系统出错！", MB_SYSTEMMODAL + MB_ICONEXCLAMATION, "提示信息"
    Screen.MousePointer = vbDefault
End Sub

Private Sub Form_Activate()
    SetHelpID C2lng(Me.HelpContextID)
End Sub

Private Sub Form_Resize()
    Dim i As Integer
    If Me.WindowState = 1 Then Exit Sub
    For i = 0 To cmdButton.Count - 1
        cmdButton(i).Visible = False
    Next i
    Label2.Visible = False
    Label3.Visible = False
    Shape1(0).Visible = False
    Shape1(1).Visible = False
    For i = 0 To lblField.Count - 1
        Label1(i).Height = 195
        Label1(i).Visible = False
        lblField(i).Visible = False
        lblField(i).Height = 195
    Next i
    
    Label2.Move 50, 50, 920, 210
    Shape1(1).Move 50, 50 + Label2.Height + 30, Me.ScaleWidth - cmdButton(0).width - 300
    Shape1(0).Move 80, Shape1(1).top + 30, Shape1(1).width, Shape1(1).Height
    Label3.Move 50, Shape1(0).top + Shape1(0).Height + 30, 920, 210
    
    grdList.Move 50, Label3.top + Label3.Height + 30, _
            Me.ScaleWidth - cmdButton(0).width - 300, _
            Me.ScaleHeight - Label3.top - Label3.Height - 50 - 30
    
    Dim WidthRate  As Integer
    WidthRate = Int(Shape1(1).width / 3)
    
    Label1(0).Left = Shape1(1).Left + 120
    Label1(0).top = Shape1(1).top + 225
    Label1(0).width = 795
    
    Label1(1).Left = Label1(0).Left
    Label1(1).width = 795
    Label1(1).top = Label1(0).top + Label1(0).Height + 225
    
    Label1(2).Left = Label1(0).Left
    Label1(2).width = 795
    Label1(2).top = Label1(1).top + Label1(1).Height + 225
    
    Label1(3).Left = Shape1(1).Left + WidthRate + 550
    Label1(3).width = 450
    Label1(3).top = Label1(1).top
    
    Label1(4).Left = Label1(3).Left
    Label1(4).width = 450
    Label1(4).top = Label1(2).top
    
    Label1(5).Left = Shape1(1).Left + 2 * WidthRate + 50
    Label1(5).width = 585
    Label1(5).top = Label1(0).top
    
    Label1(6).Left = Label1(5).Left
    Label1(6).width = 585
    Label1(6).top = Label1(1).top
    
    Label1(7).Left = Label1(5).Left
    Label1(7).width = 585
    Label1(7).top = Label1(2).top
    
    lblField(0).Left = Label1(0).Left + Label1(0).width + 50
    lblField(0).width = Label1(5).Left - lblField(0).Left - 50
    lblField(0).top = Label1(0).top
    
    lblField(1).Left = lblField(0).Left
    lblField(1).width = Label1(3).Left - lblField(1).Left - 50
    lblField(1).top = Label1(1).top