bos_forcontract.cls

金蝶地磅称重插件

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "BOS_ForContract"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = True
'''''''''''''''''''''''''''''''''''''''''''''''
''外贸合同
''建立日期：2005-12-15
''建立人：倪树祥
'''''''''''''''''''''''''''''''''''''''''''''''''
Option Explicit
'定义 BillEvent 接口. 必须具有的声明, 以此来获得事件
Private WithEvents m_BillInterface  As BillEvent
Attribute m_BillInterface.VB_VarHelpID = -1
'定义 ListEvents 接口. 必须具有的声明, 以此来获得事件
Private WithEvents m_ListInterface  As ListEvents
Attribute m_ListInterface.VB_VarHelpID = -1
 
Public Sub Show(ByVal oBosInterface As Object)
    'BillEvent 接口实现
    '注意: 此方法必须存在, 请勿修改
    Select Case VBA.TypeName(oBosInterface)
        Case "BillEvent"
            Set m_BillInterface = oBosInterface
        Case "ListEvents"
            Set m_ListInterface = oBosInterface
    End Select
End Sub

Private Sub Class_Terminate()
    '释放接口对象
    '注意: 此方法必须存在, 请勿修改
    Set m_BillInterface = Nothing
    Set m_ListInterface = Nothing
    
End Sub

Private Sub m_BillInterface_MultiCheck(ByVal lCheckMode As Long, ByVal lCheckMaxLevel As Long, ByVal lBusinessLevel As Long, ByVal lCheckLevel As Long, ByVal lCheckStatus As Long, bSendCheckMessage As Boolean, bSendAcceptMessage As Boolean, sMessageTitle As String, sMessage As String, Cancel As Boolean)
    UpdateChecker 1, lCheckLevel
    
End Sub

Private Sub m_BillInterface_UnMultiCheck(ByVal lCheckMode As Long, ByVal lCheckMaxLevel As Long, ByVal lBusinessLevel As Long, ByVal lCheckStatus As Long, ByVal lLastCheckFrom As Long, ByVal lLastCheckTo As Long, bSendMessage As Boolean, Cancel As Boolean)
    
    UpdateChecker 2, lLastCheckTo
End Sub

Private Sub m_ListInterface_MultiCheck(ByVal lCheckMode As Long, ByVal lCheckMaxLevel As Long, ByVal lBusinessLevel As Long, ByVal lCheckLevel As Long, ByVal lCheckStatus As Long, bSendCheckMessage As Boolean, bSendAcceptMessage As Boolean, sMessageTitle As String, sMessage As String, Cancel As Boolean)
    UpdateChecker 11, lCheckLevel
End Sub

Private Sub m_ListInterface_UnMultiCheck(ByVal lCheckMode As Long, ByVal lCheckMaxLevel As Long, ByVal lBusinessLevel As Long, ByVal lCheckStatus As Long, ByVal lLastCheckFrom As Long, ByVal lLastCheckTo As Long, bSendMessage As Boolean, Cancel As Boolean)
    UpdateChecker 12, lLastCheckTo
End Sub

Private Sub UpdateChecker(ByVal iCheckType As Integer, lCheckLevel As Long)
'iCheckType = 1:单据审核，2:单据反审,11:序时簿审核,12:序时簿反审。
    Dim strSql As String
    Dim strCondi As String
    Dim dctCurrRow As Dictionary
    
    If lCheckLevel <= 0 Then Exit Sub
    
    Select Case iCheckType
        Case 1 '单据审核
            strSql = m_BillInterface.K3Lib.User.UserName
            strCondi = " where FID = " & m_BillInterface.CurBillID
        Case 2 '单据反审
            strSql = ""
        strCondi = " where FID = " & m_BillInterface.CurBillID
        Case 11 '序时簿审核
            strSql = m_ListInterface.K3Lib.User.UserName
            Set dctCurrRow = m_ListInterface.GetCurrentSelRowInfo()
            strCondi = "where FID = " & dctCurrRow.GetValue("FID")
        Case 12 '序时簿反审
            strSql = ""
            Set dctCurrRow = m_ListInterface.GetCurrentSelRowInfo()
            strCondi = "where FID = " & dctCurrRow.GetValue("FID")
    End Select
      
    Select Case lCheckLevel
        Case 1 '科长
            Select Case iCheckType
                Case 1, 2 '1:单据审核，2:单据反审
                    m_BillInterface.SetFieldValue "FDeptChecker", strSql
                    strSql = "update t_EP_PB_ForContract set FDeptChecker = '" & strSql & "'" & strCondi
                    m_BillInterface.K3Lib.UpdateData strSql
                Case 11, 12 '11:序时簿审核,12:序时簿反审。
                    strSql = "update t_EP_PB_ForContract set FDeptChecker = '" & strSql & "'" & strCondi
                    m_ListInterface.K3Lib.UpdateData strSql
            End Select
            
        Case 2 '部长
            Select Case iCheckType
                Case 1, 2 '1:单据审核，2:单据反审
                    m_BillInterface.SetFieldValue "FMainChecker", strSql
                    strSql = "update t_EP_PB_ForContract set FMainChecker = '" & strSql & "'" & strCondi
                    m_BillInterface.K3Lib.UpdateData strSql
                Case 11, 12 '11:序时簿审核,12:序时簿反审。
                    strSql = "update t_EP_PB_ForContract set FMainChecker = '" & strSql & "'" & strCondi
                    m_ListInterface.K3Lib.UpdateData strSql
            End Select
            
        Case 3 '主管经理
            Select Case iCheckType
                Case 1, 2 '1:单据审核，2:单据反审
                    m_BillInterface.SetFieldValue "FSubChair", strSql
                    strSql = "update t_EP_PB_ForContract set FSubChair = '" & strSql & "'" & strCondi
                    m_BillInterface.K3Lib.UpdateData strSql
                Case 11, 12 '11:序时簿审核,12:序时簿反审。
                    strSql = "update t_EP_PB_ForContract set FSubChair = '" & strSql & "'" & strCondi
                    m_ListInterface.K3Lib.UpdateData strSql
            End Select
        Case 4 '财务
        Select Case iCheckType
            Case 1, 2 '1:单据审核，2:单据反审
                m_BillInterface.SetFieldValue "FComChecker", strSql
                strSql = "update t_EP_PB_ForContract set FComChecker = '" & strSql & "'" & strCondi
                m_BillInterface.K3Lib.UpdateData strSql
            Case 11, 12 '11:序时簿审核,12:序时簿反审。
                strSql = "update t_EP_PB_ForContract set FComChecker = '" & strSql & "'" & strCondi
                m_ListInterface.K3Lib.UpdateData strSql
        End Select
    End Select
End Sub