VB开发的ERP系统

   End
End
Attribute VB_Name = "XT_Main"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'**************************************
'*    模 块 名 称 :应付系统主窗体
'*    功 能 描 述 :作为系统主界面
'*    程序员姓名  : 张建忠
'*    最后修改人  : 张建忠
'*    最后修改时间:2001/12/25
'**************************************
Dim Tsxx As String                           '系统提示信息

'主窗体击活
Private Sub MDIForm_Activate()
    Timer1.Enabled = True
End Sub

Private Sub MDIForm_Load()
   
    '调入主操作界面
    Xt_Control.Show

End Sub

Private Sub MDIForm_QueryUnload(Cancel As Integer, UnloadMode As Integer)
        
    On Error Resume Next
    
    Dim Jsqte As Integer
    If Not Tcxt Then
        Cancel = True
    Else
        Unload_TF = True
        For Jsqte = 0 To Forms.Count - 1
            Unload Forms(Jsqte)
        Next Jsqte
        End
    End If

End Sub

'************以下为自定义部分**********
'文件
Private Sub Ap_Register_Click()                 '重新注册
    XT_login.Show 1
End Sub

Private Sub Ap_quit_Click()                     '退出系统
    Unload XT_Main
End Sub

'基础设置
Private Sub Ap_SystemPara_Click()               '系统参数设置
    Call Xt_Control.Zxxymk(Me.Ap_SystemPara.Name)
End Sub

Private Sub Ap_BaseAcc_Click()                  '基本科目设置
    Call Xt_Control.Zxxymk(Me.Ap_BaseAcc.Name)
End Sub

Private Sub Ap_SupplierAcc_Click()              '供应商科目设置
    Call Xt_Control.Zxxymk(Me.Ap_SupplierAcc.Name)
End Sub

Private Sub Ap_MateAcc_Click()                  '物料科目设置
    Call Xt_Control.Zxxymk(Me.Ap_MateAcc.Name)
End Sub

Private Sub Ap_BillAge_Click()                  '账龄区间设置
    Call Xt_Control.Zxxymk(Me.Ap_BillAge.Name)
End Sub

Private Sub Ap_BankAcc_Click()                  '银行帐户设置
    Call Xt_Control.Zxxymk(Me.Ap_BankAcc.Name)
End Sub

'系统初始化
Private Sub Ap_QcOtherBill_Click()              '期初应付单
    Call Xt_Control.Zxxymk(Me.Ap_QcOtherBill.Name)
End Sub

Private Sub Ap_BeginAPNote_Click()              '期初应付票据
    Call Xt_Control.Zxxymk(Me.Ap_BeginAPNote.Name)
End Sub

'应付单据处理
Private Sub Ap_InvPostAcc_Click()               '发票过帐
    Call Xt_Control.Zxxymk(Me.Ap_InvPostAcc.Name)
End Sub

Private Sub Ap_OtherBill_Click()                '其他应付单
    Call Xt_Control.Zxxymk(Me.Ap_OtherBill.Name)
End Sub

Private Sub Ap_OtherBillList_Click()            '其他应付单列表
    Call Xt_Control.Zxxymk(Me.Ap_OtherBillList.Name)
End Sub

'付款处理
Private Sub Ap_PayBill_Click()                  '付款结算单
    Call Xt_Control.Zxxymk(Me.Ap_PayBill.Name)
End Sub

Private Sub Ap_PayBillList_Click()              '付款结算单列表
    Call Xt_Control.Zxxymk(Me.Ap_PayBillList.Name)
End Sub

Private Sub Ap_Note_Click()                     '应付票据
    Call Xt_Control.Zxxymk(Me.Ap_Note.Name)
End Sub

Private Sub Ap_NoteList_Click()                 '应付票据列表
    Call Xt_Control.Zxxymk(Me.Ap_NoteList.Name)
End Sub

'核销处理
Private Sub Ap_BillCancel_Click()               '单据核销
    Call Xt_Control.Zxxymk(Me.Ap_BillCancel.Name)
End Sub

Private Sub Ap_CancelQuery_Click()              '核销查询
    Call Xt_Control.Zxxymk(Me.Ap_CancelQuery.Name)
End Sub

'制作凭证
Private Sub Ap_InvoiceVouch_Click()             '采购发票制作凭证
    Call Xt_Control.Zxxymk(Me.Ap_InvoiceVouch.Name)
End Sub

Private Sub Ap_OtherVouch_Click()               '其它应付制作凭证
    Call Xt_Control.Zxxymk(Me.Ap_OtherVouch.Name)
End Sub

Private Sub Ap_PayVouch_Click()                 '付款结算制作凭证
    Call Xt_Control.Zxxymk(Me.Ap_PayVouch.Name)
End Sub

Private Sub Ap_NoteVouch_Click()                '应付票据制作凭证
    Call Xt_Control.Zxxymk(Me.Ap_NoteVouch.Name)
End Sub

Private Sub Ap_NoteChangeVouch_Click()          '票据变动制作凭证
    Call Xt_Control.Zxxymk(Me.Ap_NoteChangeVouch.Name)
End Sub

Private Sub Ap_CancelVouch_Click()              '单据核销制作凭证
    Call Xt_Control.Zxxymk(Me.Ap_CancelVouch.Name)
End Sub

'统计分析
Private Sub Ap_AccList_Click()                  '应付明细帐
    Call Xt_Control.Zxxymk(Me.Ap_AccList.Name)
End Sub

Private Sub Ap_AccSum_Click()                   '应付总帐
    Call Xt_Control.Zxxymk(Me.Ap_AccSum.Name)
End Sub

Private Sub Ap_SuppBalance_Click()              '供应商余额表
    Call Xt_Control.Zxxymk(Me.Ap_SuppBalance.Name)
End Sub

Private Sub Ap_AccAgeAnalyse_Click()            '账龄分析
    Call Xt_Control.Zxxymk(Me.Ap_AccAgeAnalyse.Name)
End Sub

'月末处理
Private Sub Ap_EOMMana_Click()                  '月末处理
    Call Xt_Control.Zxxymk(Me.Ap_EOMMana.Name)
End Sub

'工具
Private Sub Ap_gnbmjsq_Click()                  '计算器
    Call Xt_Control.Zxxymk(Me.Ap_gnbmjsq.Name)
End Sub

Private Sub Ap_gnbmkjrl_Click()                 '会计日历
    Call Xt_Control.Zxxymk(Me.Ap_gnbmkjrl.Name)
End Sub

'帮助
Private Sub Ap_xtbz_Click()                     '系统帮助
    Call Xt_Control.Zxxymk(Me.Ap_xtbz.Name)
End Sub

Private Sub Ap_gy_Click()                       '系统关于
    Call Xt_Control.Zxxymk(Me.Ap_gy.Name)
End Sub

'*************************
Private Sub mnuWindowArrangeIcons_Click()                                   '窗口排列图标
    Me.Arrange vbArrangeIcons
End Sub

Private Sub mnuWindowTileVertical_Click()                                   '窗口横向平铺
    Me.Arrange vbTileVertical
End Sub

Private Sub mnuWindowTileHorizontal_Click()                                 '窗口纵向平铺
    Me.Arrange vbTileHorizontal
End Sub

Private Sub mnuWindowCascade_Click()                                        '窗口层叠
    Me.Arrange vbCascade
End Sub

'************************'以下为程序固定不变部分*********************'

Private Function Tcxt() As Boolean                                       '退出系统提示
    Dim Answer As Integer
    Tsxx = "请确认是否退出系统？"
    Answer = Xtxxts(Tsxx, 2, 2)
    If Answer = 1 Then
        Tcxt = True
    Else
        Tcxt = False
    End If

End Function

Private Sub Timer1_Timer()                                        '在窗体激活后调入程序
    
    Timer1.Enabled = False
    If XT_login.QdCheck.Value = 1 Then
        Call Xtcsh
        XT_login.QdCheck.Value = 0
    End If

End Sub

Private Sub Xtcsh()                                               '系统主控制台及全局变量初始化
    
    With XT_login
        Xtczybm = Trim(Mid(.CzyCombo.Text, 1, InStr(1, .CzyCombo.Text, "-") - 1))
        Xtczy = Trim(Mid(.CzyCombo.Text, InStr(1, .CzyCombo.Text, "-") + 1, Len(.CzyCombo.Text)))
        Xtztbm = Trim(Mid(.ZtCombo.Text, 1, InStr(1, .ZtCombo.Text, "-") - 1))
        Xtdwm = Trim(Mid(.ZtCombo.Text, InStr(1, .ZtCombo.Text, "-") + 1, Len(.ZtCombo.Text)))
        Xtkjqjgs = 12
        '业务操作日期
        Xtrq = CDate(.CzrqText.Text)

        '用户选择系统年度
        Xtyear = Val(.KjyearCombo.Text)
        
        '用户选择系统会计期间
        Set Xtrlrec = Cw_DataEnvi.DataConnect.Execute("Select * From Gy_kjrlb where qsrq<='" + .CzrqText.Text + "' and zzrq>='" + .CzrqText.Text + "'")
        If Not Xtrlrec.EOF Then
            Xtmm = Xtrlrec.Fields("Period")
        End If
        
    End With
    
    With XT_Main.StatusBar1
        .Panels("OperStatus") = "就绪"
        .Panels("zt").Text = Xtdwm
        .Panels("czy").Text = Xtczy
        .Panels("rq").Text = "业务日期:" + Format(Xtrq, "yyyy-mm-dd")
        .Panels("rjbb").Text = "【百利/ERP】"
    End With

End Sub