资源名称:ERPSYS.zip [点击查看]
上传用户:zhpu1995
上传日期:2013-09-06
资源大小:61151k
文件大小:16k
源码类别:
企业管理
开发平台:
Visual Basic
- VERSION 5.00
- Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
- Begin VB.MDIForm XT_Main
- BackColor = &H00FF0000&
- Caption = "百利/ERP5.0-应付系统"
- ClientHeight = 6510
- ClientLeft = 1380
- ClientTop = 1440
- ClientWidth = 11835
- Icon = "系统_主界面.frx":0000
- WindowState = 2 'Maximized
- Begin VB.Timer Timer1
- Interval = 1
- Left = 3360
- Top = 1380
- End
- Begin MSComctlLib.StatusBar StatusBar1
- Align = 2 'Align Bottom
- Height = 375
- Left = 0
- TabIndex = 0
- Top = 6135
- Width = 11835
- _ExtentX = 20876
- _ExtentY = 661
- _Version = 393216
- BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628}
- NumPanels = 6
- BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628}
- AutoSize = 2
- Object.Width = 5292
- MinWidth = 5292
- Key = "OperStatus"
- EndProperty
- BeginProperty Panel2 {8E3867AB-8586-11D1-B16A-00C0F0283628}
- Object.Width = 5292
- MinWidth = 5292
- Key = "zt"
- EndProperty
- BeginProperty Panel3 {8E3867AB-8586-11D1-B16A-00C0F0283628}
- AutoSize = 2
- Object.Width = 2117
- MinWidth = 2117
- Key = "czy"
- EndProperty
- BeginProperty Panel4 {8E3867AB-8586-11D1-B16A-00C0F0283628}
- AutoSize = 2
- Object.Width = 3519
- MinWidth = 3528
- Key = "rq"
- EndProperty
- BeginProperty Panel5 {8E3867AB-8586-11D1-B16A-00C0F0283628}
- Style = 5
- Object.Width = 1411
- MinWidth = 1411
- TextSave = "16:44"
- Key = "sj"
- EndProperty
- BeginProperty Panel6 {8E3867AB-8586-11D1-B16A-00C0F0283628}
- AutoSize = 2
- Object.Width = 3519
- MinWidth = 3528
- Key = "rjbb"
- EndProperty
- EndProperty
- End
- Begin MSComctlLib.ImageList ImageList1
- Left = 11070
- Top = 510
- _ExtentX = 1005
- _ExtentY = 1005
- BackColor = -2147483643
- ImageWidth = 16
- ImageHeight = 16
- MaskColor = 12632256
- _Version = 393216
- BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
- NumListImages = 8
- BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":1042
- Key = "stb"
- EndProperty
- BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":1496
- Key = "xttb"
- EndProperty
- BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":18EE
- Key = "qx"
- EndProperty
- BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":1D4E
- Key = "kplr"
- EndProperty
- BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":21A2
- Key = "kpgl"
- EndProperty
- BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":2602
- Key = "tcxt"
- EndProperty
- BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":291E
- Key = "szk"
- EndProperty
- BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "系统_主界面.frx":2D76
- Key = "gnqx"
- EndProperty
- EndProperty
- End
- Begin VB.Menu Ap_File
- Caption = "文件(&F)"
- Index = 101
- Begin VB.Menu Ap_Register
- Caption = "重新注册(&R)"
- End
- Begin VB.Menu v5
- Caption = "-"
- End
- Begin VB.Menu Ap_quit
- Caption = "退出系统(&Q)"
- End
- End
- Begin VB.Menu Ap_Base
- Caption = "设置(&I)"
- Begin VB.Menu Ap_SystemPara
- Caption = "系统参数设置(&S)"
- End
- Begin VB.Menu Ap_BaseAcc
- Caption = "基本科目设置(&B)"
- End
- Begin VB.Menu Ap_SupplierAcc
- Caption = "供应商科目设置(&U)"
- End
- Begin VB.Menu Ap_MateAcc
- Caption = "物料科目设置(&M)"
- End
- Begin VB.Menu Ap_BillAge
- Caption = "账龄区间设置(&A)"
- End
- Begin VB.Menu Ap_BankAcc
- Caption = "银行帐户设置(&N)"
- End
- End
- Begin VB.Menu Ap_SysFormat
- Caption = "初始化(&O)"
- Begin VB.Menu Ap_QcOtherBill
- Caption = "期初应付单(&P)"
- End
- Begin VB.Menu Ap_BeginAPNote
- Caption = "期初应付票据(&I)"
- End
- End
- Begin VB.Menu Ap_BillManage
- Caption = "单据(&B)"
- Begin VB.Menu Ap_InvPostAcc
- Caption = "发票过帐(&P)"
- End
- Begin VB.Menu Ap_OtherBill
- Caption = "其他应付单(&O)"
- End
- Begin VB.Menu Ap_OtherBillList
- Caption = "其他应付单列表(&L)"
- End
- End
- Begin VB.Menu Ap_PayManage
- Caption = "付款(&P)"
- Begin VB.Menu Ap_PayBill
- Caption = "付款结算单(&B)"
- End
- Begin VB.Menu Ap_PayBillList
- Caption = "付款结算单列表(&L)"
- End
- Begin VB.Menu Ap_Note
- Caption = "应付票据(&N)"
- End
- Begin VB.Menu Ap_NoteList
- Caption = "应付票据列表(&I)"
- End
- End
- Begin VB.Menu Ap_CancelMana
- Caption = "核销(&C)"
- Begin VB.Menu Ap_BillCancel
- Caption = "单据核销(&B)"
- End
- Begin VB.Menu Ap_CancelQuery
- Caption = "核销查询(&Q)"
- End
- End
- Begin VB.Menu Ap_Vouch
- Caption = "凭证(&V)"
- Begin VB.Menu Ap_InvoiceVouch
- Caption = "采购发票制作凭证(&I)"
- End
- Begin VB.Menu Ap_OtherVouch
- Caption = "其他应付制作凭证(&O)"
- End
- Begin VB.Menu Ap_PayVouch
- Caption = "付款结算制作凭证(&P)"
- End
- Begin VB.Menu Ap_NoteVouch
- Caption = "应付票据制作凭证(&N)"
- End
- Begin VB.Menu Ap_NoteChangeVouch
- Caption = "票据变动制作凭证(&C)"
- End
- Begin VB.Menu Ap_CancelVouch
- Caption = "单据核销制作凭证(&A)"
- End
- End
- Begin VB.Menu Ap_TotalAnalyse
- Caption = "统计(&A)"
- Begin VB.Menu Ap_AccList
- Caption = "应付明细帐(&L)"
- End
- Begin VB.Menu Ap_AccSum
- Caption = "应付总帐(&S)"
- End
- Begin VB.Menu Ap_SuppBalance
- Caption = "供应商余额表(&B)"
- End
- Begin VB.Menu Ap_AccAgeAnalyse
- Caption = "账龄分析(&A)"
- End
- End
- Begin VB.Menu Ap_EOMManage
- Caption = "月末处理(&M)"
- Begin VB.Menu Ap_EOMMana
- Caption = "月末结帐(&E)"
- End
- End
- Begin VB.Menu Ap_Tool
- Caption = "工具(&T)"
- Begin VB.Menu Ap_gnbmjsq
- Caption = "计算器(&S)"
- End
- Begin VB.Menu Ap_gnbmkjrl
- Caption = "会计日历(&C)"
- End
- End
- Begin VB.Menu mnuwindows
- Caption = "窗口(&W)"
- WindowList = -1 'True
- Begin VB.Menu mnuWindowsCascade
- Caption = "层叠(&C)"
- End
- Begin VB.Menu mnuWindowsTileHorizontal
- Caption = "横向平铺(&H)"
- End
- Begin VB.Menu mnuWindowTileVertical
- Caption = "纵向平铺(&V)"
- End
- Begin VB.Menu mnuWindowArrangeIcons
- Caption = "排列图标(&A)"
- End
- End
- Begin VB.Menu Ap_bz
- Caption = "帮助(&H)"
- Begin VB.Menu Ap_xtbz
- Caption = "系统帮助(&S)"
- End
- Begin VB.Menu Ap_gy
- Caption = "关于(&A)"
- End
- 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