i-
资源名称:ERPSYS.zip [点击查看]
上传用户:zhpu1995
上传日期:2013-09-06
资源大小:61151k
文件大小:43k
源码类别:
企业管理
开发平台:
Visual Basic
- VERSION 5.00
- Object = "{BEEECC20-4D5F-4F8B-BFDC-5D9B6FBDE09D}#1.0#0"; "vsflex8.ocx"
- Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
- Begin VB.Form Zbfx_Mate
- Caption = "总帐"
- ClientHeight = 6420
- ClientLeft = 60
- ClientTop = 345
- ClientWidth = 11580
- HelpContextID = 130502
- Icon = "帐簿分析_总帐.frx":0000
- KeyPreview = -1 'True
- LinkTopic = "Form2"
- MDIChild = -1 'True
- ScaleHeight = 6420
- ScaleWidth = 11580
- WindowState = 2 'Maximized
- Begin VB.Timer Timer1
- Enabled = 0 'False
- Interval = 1
- Left = 7620
- Top = 90
- End
- Begin MSComctlLib.ImageCombo Com_Mnumber
- Height = 315
- Left = 1140
- TabIndex = 0
- Top = 1380
- Width = 3645
- _ExtentX = 6429
- _ExtentY = 556
- _Version = 393216
- ForeColor = -2147483640
- BackColor = -2147483643
- End
- Begin MSComctlLib.Toolbar GsToolbar
- Height = 525
- Left = 9330
- TabIndex = 1
- Top = 30
- Width = 2475
- _ExtentX = 4366
- _ExtentY = 926
- ButtonWidth = 1455
- ButtonHeight = 926
- Appearance = 1
- Style = 1
- ImageList = "ImageList2"
- _Version = 393216
- BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
- NumButtons = 3
- BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "保存格式"
- Key = "bcgs"
- ImageKey = "bcgs"
- EndProperty
- BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "默认列宽"
- Key = "hfmrgs"
- ImageKey = "mrlk"
- EndProperty
- BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "显示项目"
- Key = "szxsxm"
- ImageKey = "xsxm"
- EndProperty
- EndProperty
- End
- Begin VSFlex8Ctl.VSFlexGrid CxbbGrid
- Height = 7155
- Left = 0
- TabIndex = 2
- Top = 1860
- Width = 11775
- _cx = 5080
- _cy = 5080
- Appearance = 1
- BorderStyle = 1
- Enabled = -1 'True
- BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
- Name = "宋体"
- Size = 9
- Charset = 134
- Weight = 400
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- MousePointer = 0
- BackColor = 16777215
- ForeColor = -2147483640
- BackColorFixed = 13826538
- ForeColorFixed = -2147483630
- BackColorSel = -2147483635
- ForeColorSel = -2147483634
- BackColorBkg = -2147483636
- BackColorAlternate= 16777215
- GridColor = -2147483633
- GridColorFixed = -2147483632
- TreeColor = -2147483632
- FloodColor = 192
- SheetBorder = -2147483642
- FocusRect = 1
- HighLight = 1
- AllowSelection = -1 'True
- AllowBigSelection= -1 'True
- AllowUserResizing= 0
- SelectionMode = 0
- GridLines = 1
- GridLinesFixed = 2
- GridLineWidth = 1
- Rows = 50
- Cols = 10
- FixedRows = 1
- FixedCols = 1
- RowHeightMin = 0
- RowHeightMax = 0
- ColWidthMin = 0
- ColWidthMax = 0
- ExtendLastCol = 0 'False
- FormatString = ""
- ScrollTrack = 0 'False
- ScrollBars = 3
- ScrollTips = 0 'False
- MergeCells = 0
- MergeCompare = 0
- AutoResize = -1 'True
- AutoSizeMode = 0
- AutoSearch = 0
- AutoSearchDelay = 2
- MultiTotals = -1 'True
- SubtotalPosition= 1
- OutlineBar = 0
- OutlineCol = 0
- Ellipsis = 0
- ExplorerBar = 0
- PicturesOver = 0 'False
- FillStyle = 0
- RightToLeft = 0 'False
- PictureType = 0
- TabBehavior = 0
- OwnerDraw = 0
- Editable = 0
- ShowComboButton = 1
- WordWrap = 0 'False
- TextStyle = 0
- TextStyleFixed = 0
- OleDragMode = 0
- OleDropMode = 0
- DataMode = 0
- VirtualData = -1 'True
- DataMember = ""
- ComboSearch = 3
- AutoSizeMouse = -1 'True
- FrozenRows = 0
- FrozenCols = 0
- AllowUserFreezing= 0
- BackColorFrozen = 0
- ForeColorFrozen = 0
- WallPaperAlignment= 9
- AccessibleName = ""
- AccessibleDescription= ""
- AccessibleValue = ""
- AccessibleRole = 24
- Begin MSComctlLib.ImageList ImageList2
- Left = 0
- Top = 0
- _ExtentX = 1005
- _ExtentY = 1005
- BackColor = -2147483643
- ImageWidth = 16
- ImageHeight = 16
- MaskColor = 12632256
- _Version = 393216
- BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
- NumListImages = 40
- BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":1042
- Key = "sz"
- EndProperty
- BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":13DC
- Key = "dy"
- EndProperty
- BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":1776
- Key = "yl"
- EndProperty
- BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":1B10
- Key = "xg"
- EndProperty
- BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":1EAA
- Key = "zh"
- EndProperty
- BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":2244
- Key = "sh"
- EndProperty
- BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":25DE
- Key = "bc"
- EndProperty
- BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":2978
- Key = "fq"
- EndProperty
- BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":2D12
- Key = "bz"
- EndProperty
- BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":30AC
- Key = "tc"
- EndProperty
- BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":3446
- Key = "bcgs"
- EndProperty
- BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":37E0
- Key = "mrlk"
- EndProperty
- BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":3B7A
- Key = "xsxm"
- EndProperty
- BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":3F14
- Key = "first"
- EndProperty
- BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":42AE
- Key = "prev"
- EndProperty
- BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":4648
- Key = "next"
- EndProperty
- BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":49E2
- Key = "last"
- EndProperty
- BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":4D7C
- Key = "xx"
- EndProperty
- BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":5116
- Key = "define"
- EndProperty
- BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":54B0
- Key = "exec"
- EndProperty
- BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":584A
- Key = "xz"
- EndProperty
- BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":5BE4
- Key = "sc"
- EndProperty
- BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":5F7E
- Key = "sx"
- EndProperty
- BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":6318
- Key = "cx"
- EndProperty
- BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":66B2
- Key = "zd"
- EndProperty
- BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":6A4C
- Key = "dz"
- EndProperty
- BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":6DE6
- Key = "ph"
- EndProperty
- BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":7180
- Key = "fz"
- EndProperty
- BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":751A
- Key = "dw"
- EndProperty
- BeginProperty ListImage30 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":78B4
- Key = "hf"
- EndProperty
- BeginProperty ListImage31 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":7C4E
- Key = "pz"
- EndProperty
- BeginProperty ListImage32 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":7FE8
- Key = "check"
- EndProperty
- BeginProperty ListImage33 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":8382
- Key = "qs"
- EndProperty
- BeginProperty ListImage34 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":871C
- Key = "fullcheck"
- EndProperty
- BeginProperty ListImage35 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":8AB6
- Key = "qq"
- EndProperty
- BeginProperty ListImage36 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":8E50
- Key = "bcw"
- EndProperty
- BeginProperty ListImage37 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":91EA
- Key = "ye"
- EndProperty
- BeginProperty ListImage38 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":9584
- Key = ""
- EndProperty
- BeginProperty ListImage39 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":991E
- Key = "frist"
- EndProperty
- BeginProperty ListImage40 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":9CB8
- Key = "dj"
- EndProperty
- EndProperty
- End
- End
- Begin MSComctlLib.Toolbar SzToolbar
- Align = 1 'Align Top
- Height = 555
- Left = 0
- TabIndex = 3
- Top = 0
- Width = 11580
- _ExtentX = 20426
- _ExtentY = 979
- ButtonWidth = 820
- ButtonHeight = 926
- AllowCustomize = 0 'False
- Appearance = 1
- Style = 1
- ImageList = "ImageList1"
- _Version = 393216
- BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
- NumButtons = 10
- BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "设置"
- Key = "ymsz"
- ImageKey = "sz"
- EndProperty
- BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "打印"
- Key = "dy"
- ImageKey = "dy"
- EndProperty
- BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "预览"
- Key = "yl"
- ImageKey = "yl"
- EndProperty
- BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Style = 3
- EndProperty
- BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "查询"
- Key = "cx"
- ImageKey = "cx"
- EndProperty
- BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Style = 4
- EndProperty
- BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "明细"
- Key = "mx"
- ImageKey = "mx"
- EndProperty
- BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Key = "fg"
- Style = 4
- EndProperty
- BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "帮助"
- Key = "bz"
- ImageKey = "bz"
- EndProperty
- BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "退出"
- Key = "fh"
- ImageKey = "tc"
- EndProperty
- EndProperty
- BorderStyle = 1
- Begin MSComctlLib.ImageList ImageList1
- Left = 6990
- Top = 30
- _ExtentX = 1005
- _ExtentY = 1005
- BackColor = -2147483643
- ImageWidth = 16
- ImageHeight = 16
- MaskColor = 12632256
- _Version = 393216
- BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
- NumListImages = 38
- BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":A052
- Key = "sz"
- EndProperty
- BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":A3EC
- Key = "dy"
- EndProperty
- BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":A786
- Key = "yl"
- EndProperty
- BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":AB20
- Key = "xg"
- EndProperty
- BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":AEBA
- Key = "zh"
- EndProperty
- BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":B254
- Key = "sh"
- EndProperty
- BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":B5EE
- Key = "bc"
- EndProperty
- BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":B988
- Key = "fq"
- EndProperty
- BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":BD22
- Key = "bz"
- EndProperty
- BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":C0BC
- Key = "tc"
- EndProperty
- BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":C456
- Key = "bcgs"
- EndProperty
- BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":C7F0
- Key = "mrlk"
- EndProperty
- BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":CB8A
- Key = "xsxm"
- EndProperty
- BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":CF24
- Key = "first"
- EndProperty
- BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":D2BE
- Key = "prev"
- EndProperty
- BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":D658
- Key = "next"
- EndProperty
- BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":D9F2
- Key = "last"
- EndProperty
- BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":DD8C
- Key = "xx"
- EndProperty
- BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":E126
- Key = "define"
- EndProperty
- BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":E4C0
- Key = "exec"
- EndProperty
- BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":E85A
- Key = "xz"
- EndProperty
- BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":EBF4
- Key = "sc"
- EndProperty
- BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":EF8E
- Key = "sx"
- EndProperty
- BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":F328
- Key = "cx"
- EndProperty
- BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":F6C2
- Key = "zd"
- EndProperty
- BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":FA5C
- Key = "dz"
- EndProperty
- BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":FDF6
- Key = "ph"
- EndProperty
- BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":10190
- Key = "fz"
- EndProperty
- BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":1052A
- Key = "dw"
- EndProperty
- BeginProperty ListImage30 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":108C4
- Key = "hf"
- EndProperty
- BeginProperty ListImage31 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":10C5E
- Key = "pz"
- EndProperty
- BeginProperty ListImage32 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":10FF8
- Key = "check"
- EndProperty
- BeginProperty ListImage33 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":11392
- Key = "mx"
- EndProperty
- BeginProperty ListImage34 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":1172C
- Key = "jz"
- EndProperty
- BeginProperty ListImage35 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":11AC6
- Key = "hz"
- EndProperty
- BeginProperty ListImage36 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":11E60
- Key = "dj"
- EndProperty
- BeginProperty ListImage37 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":121FA
- Key = "cy"
- EndProperty
- BeginProperty ListImage38 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "帐簿分析_总帐.frx":12594
- Key = "zhh"
- EndProperty
- EndProperty
- End
- End
- Begin VB.PictureBox Pic_Title
- BackColor = &H00FFFFFF&
- Height = 1245
- Left = 0
- Picture = "帐簿分析_总帐.frx":1292E
- ScaleHeight = 1185
- ScaleWidth = 11715
- TabIndex = 4
- Top = 570
- Width = 11775
- Begin VB.Label Lab_Title
- AutoSize = -1 'True
- BackColor = &H80000018&
- BackStyle = 0 'Transparent
- Caption = "总帐"
- BeginProperty Font
- Name = "宋体"
- Size = 12
- Charset = 134
- Weight = 700
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- ForeColor = &H00000000&
- Height = 240
- Index = 0
- Left = 480
- TabIndex = 10
- Top = 210
- Width = 510
- End
- Begin VB.Label Lbl_TitleMess
- AutoSize = -1 'True
- BackStyle = 0 'Transparent
- Caption = "规格型号:"
- Height = 195
- Index = 1
- Left = 5010
- TabIndex = 9
- Top = 840
- Width = 765
- End
- Begin VB.Label Lbl_TitleMess
- AutoSize = -1 'True
- BackStyle = 0 'Transparent
- Caption = "存货:"
- Height = 195
- Index = 0
- Left = 570
- TabIndex = 8
- Top = 840
- Width = 405
- End
- Begin VB.Label Lbl_TitleText
- AutoSize = -1 'True
- BackStyle = 0 'Transparent
- Caption = "仓库"
- ForeColor = &H00000000&
- Height = 195
- Index = 0
- Left = 5850
- TabIndex = 7
- Top = 840
- Width = 360
- End
- Begin VB.Label Lbl_TitleText
- AutoSize = -1 'True
- BackStyle = 0 'Transparent
- Caption = "仓库"
- ForeColor = &H00000000&
- Height = 195
- Index = 1
- Left = 8970
- TabIndex = 6
- Top = 840
- Width = 360
- End
- Begin VB.Label Lbl_TitleMess
- AutoSize = -1 'True
- BackStyle = 0 'Transparent
- Caption = "仓库:"
- Height = 180
- Index = 2
- Left = 8430
- TabIndex = 5
- Top = 840
- Width = 450
- End
- End
- End
- Attribute VB_Name = "Zbfx_Mate"
- Attribute VB_GlobalNameSpace = False
- Attribute VB_Creatable = False
- Attribute VB_PredeclaredId = True
- Attribute VB_Exposed = False
- '**************************************************************************
- '* 模 块 名 称 :总帐
- '* 功 能 描 述 :
- '* 程序员姓名 :白凤英
- '* 最后修改人 :白凤英
- '* 最后修改时间:2001/12/14
- '* 备 注:程序中所有依实际情况自定义部分均用[>> <<]括起
- '**************************************************************************
- Dim mMnumber As String '存货编码
- Dim ReportTitle As String '报表主标题
- Dim Str_QueryCondi As String '用户录入查询条件
- Dim Rec_BillID As New ADODB.Recordset '用户查询单据ID动态集
- '以下为固定使用变量
- Dim Dyymctbl As New DY_Dyymsz '打印页面窗体变量
- Dim GridCode As String '显示网格网格代码
- Dim GridInf() As Variant '整个网格设置信息
- Dim Tsxx As String '系统提示信息
- Dim Qslz As Long '网格隐藏(非操作显示)列数
- Dim Sjhgd As Double '网格数据行高度
- Dim Sfxshjwg As Boolean '是否显示合计网格
- Dim GridBoolean() As Boolean '网格列信息(布尔型)
- Dim GridStr() As String '网格列信息(字符型)
- Dim GridInt() As Integer '网格列信息(整型)
- Dim Szzls As Integer '数组总列数(网格列数-1)
- Private Sub Com_Mnumber_Click() '存货列表
- Dim strCode As String
- Xt_Wait.Show
- Xt_Wait.Refresh
- strCode = Mid(Com_Mnumber.ComboItems.Item(Com_Mnumber.SelectedItem.Index).Key, 2, 20)
- mMnumber = strCode
- Lbl_TitleText(0) = Com_Mnumber.ComboItems.Item(Com_Mnumber.SelectedItem.Index).Tag
- Call Sub_Query(1, strCode)
- Unload Xt_Wait
- End Sub
- Private Sub Form_Resize() '根据窗体大小来调整网格,标题栏大小(Fixed)
- On Error Resume Next
- With CxbbGrid
- .Width = Me.Width - 160
- .Height = Me.Height - .Top - 400
- End With
- With Pic_Title
- .Width = Me.Width - 160
- End With
- GsToolbar.Left = Me.Width - GsToolbar.Width - 140
- End Sub
- Private Sub Form_Load() '窗体装入
- '调入打印页面设置窗体
- ReportTitle = "总帐"
- XtReportCode = "Chhs_Mate"
- Load Dyymctbl
- '调整标题栏及网格、格式工具条位置(Fixed)
- Pic_Title.Left = 40
- Pic_Title.Top = SzToolbar.Top + SzToolbar.Height - 10
- CxbbGrid.Left = Pic_Title.Left
- CxbbGrid.Top = Pic_Title.Top + Pic_Title.Height + 20
- '调 入 网 格(Fixed)
- GridCode = "Chhs_Mate"
- Call BzWgcsh(CxbbGrid, GridCode, GridInf(), GridBoolean(), GridInt(), GridStr())
- Qslz = GridInf(1)
- Sjhgd = GridInf(2)
- Sfxshjwg = GridInf(7)
- Szzls = CxbbGrid.Cols - 1
- '清除表头内容
- Lbl_TitleText(0) = ""
- Lbl_TitleText(1) = ""
- End Sub
- Private Sub Form_Unload(Cancel As Integer) '窗体卸载
- '卸载条件窗体
- Zbfx_MateCond.UnloadCheck.Value = 1
- Unload Zbfx_MateCond
- '卸载打印页面设置窗体
- Unload Dyymctbl
- End Sub
- Private Sub CxbbGrid_BeforeMoveColumn(ByVal Col As Long, Position As Long) '网格列发生移动时自动交换网格索引信息
- Call FnBln_RefreshArray(Col, Position, GridStr(), GridInf())
- End Sub
- Private Sub GsToolbar_ButtonClick(ByVal Button As MSComctlLib.Button) '网格格式调整(Fixed)
- Select Case Button.Key
- Case "bcgs" '保存表格格式
- Call Bcwggs(CxbbGrid, GridCode, GridStr())
- Case "hfmrgs" '恢复默认格式
- Call Hfmrgs(CxbbGrid, GridCode, GridStr())
- Case "szxsxm" '设置显示项目
- Call Szxsxm(CxbbGrid, GridCode)
- End Select
- End Sub
- Private Sub SzToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)
- Select Case Button.Key
- Case "ymsz" '页面设置
- Dyymctbl.Show 1
- Case "yl" '预 览
- Call bbyl(True)
- Case "dy" '打 印
- Call bbyl(False)
- Case "cx" '查 询
- Zbfx_MateCond.Show 1
- Case "mx" '明 细
- Call Sub_Mx
- Case "bz" '帮 助
- Call F1bz
- Case "fh" '退 出
- Unload Me
- End Select
- End Sub
- Private Sub Timer1_Timer() '在窗体激活后调入查询程序
- Timer1.Enabled = False
- Xt_Wait.Show
- Xt_Wait.Refresh
- '加快显示速度
- CxbbGrid.Redraw = False
- '生成查询结果
- Call Sub_Query(0, "")
- CxbbGrid.Redraw = True
- Xt_Wait.Hide
- If Qmclcy And Trim(Lbl_TitleText(0).Tag) = "计划价法" Then
- CxbbGrid.ColHidden(Sydz("012", GridStr(), Szzls)) = False
- CxbbGrid.ColHidden(Sydz("013", GridStr(), Szzls)) = False
- CxbbGrid.ColHidden(Sydz("014", GridStr(), Szzls)) = False
- Else
- CxbbGrid.ColHidden(Sydz("012", GridStr(), Szzls)) = True
- CxbbGrid.ColHidden(Sydz("013", GridStr(), Szzls)) = True
- CxbbGrid.ColHidden(Sydz("014", GridStr(), Szzls)) = True
- End If
- End Sub
- Private Sub Sub_Query(Int_QueryType As Integer, Mnumber As String) '生成查询结果(Define)
- '过程参数:Int_QueryType 0-"点确定按钮"查询 1-"刷新"查询
- Dim Rec_Query As Recordset '查询结果动态集
- Dim Coljsq As Long '网格列计数器
- Dim Jsqte As Long '临时动态计数器
- Dim Str1 As String
- Dim NewCombox As ComboItem
- '以下为自定义部分[
- If Int_QueryType = 0 Then '0-"点确定按钮"查询
- With Zbfx_MateCond
- '生成查询条件
- Str_QueryCondi = " where kjyear= " & Xtyear
- For Jsqte = 0 To 5
- Select Case Jsqte
- Case 0 '月份(起始)
- Str_QueryCondi = Str_QueryCondi & " And a.period>= '" & .Com_QsMon.ItemData(.Com_QsMon.ListIndex) & "'"
- Case 1 '月份(终止)
- Str_QueryCondi = Str_QueryCondi & " And a.period<= '" & .Com_JzMon.ItemData(.Com_JzMon.ListIndex) & "'"
- Case 2 '仓库
- Str_QueryCondi = Str_QueryCondi & " And a.whcode='" & Trim(.LrText(0).Tag) & "'"
- Case 3 '存货分类(Like)
- If Trim(.LrText(1).Text) <> "" Then
- Str_QueryCondi = Str_QueryCondi & " And a.invsortcode like '" & Trim(.LrText(1).Tag) & "%'"
- End If
- Case 4 '查询存货范围(起始)
- If Trim(.LrText(2).Text) <> "" Then
- Str_QueryCondi = Str_QueryCondi & " And a.mnumber>='" & Trim(.LrText(2).Text) & "'"
- End If
- Case 5 '查询存货范围(终止)
- If Trim(.LrText(3).Text) <> "" Then
- Str_QueryCondi = Str_QueryCondi & " And a.mnumber<= '" & Trim(.LrText(3).Text) & "'"
- End If
- End Select
- Next Jsqte
- End With
- '填充存货列表
- SqlStr = "SELECT Distinct Mnumber,Mname,Model FROM Chhs_V_Mate a " & Trim(Str_QueryCondi)
- Xtbmczdm = SqlStr
- Com_Mnumber.Enabled = True
- Com_Mnumber.Text = ""
- Call FillImageCombo(Com_Mnumber, "Chhs_List", 0)
- If Com_Mnumber.ComboItems.count > 0 Then
- Mnumber = Mid(Com_Mnumber.ComboItems.Item(1).Key, 2, 20)
- mMnumber = Mnumber
- End If
- Else
- If Str_QueryCondi = "" Then
- Str_QueryCondi = " where 1=2"
- End If
- End If
- CxbbGrid.Rows = CxbbGrid.FixedRows
- SqlStr = "SELECT * FROM Chhs_V_Mate a " & Trim(Str_QueryCondi) & " and a.mnumber='" & Mnumber & "' order by a.period "
- Set Rec_Query = Cw_DataEnvi.DataConnect.Execute(SqlStr)
- With Rec_Query
- If Not .EOF Then
- '填充期初数据
- CxbbGrid.AddItem ""
- Jsqte = CxbbGrid.Rows - 1
- CxbbGrid.RowHeight(Jsqte) = Sjhgd
- CxbbGrid.TextMatrix(Jsqte, Sydz("002", GridStr(), Szzls)) = " 期初结存"
- Lbl_TitleText(0).Tag = Trim(.Fields("pricemode"))
- CxbbGrid.TextMatrix(Jsqte, Sydz("009", GridStr(), Szzls)) = .Fields("StartQuan") + 0
- If .Fields("StartPrice") <> 0 Then '计划单价
- CxbbGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls)) = .Fields("StartPrice") + 0
- End If
- CxbbGrid.TextMatrix(Jsqte, Sydz("011", GridStr(), Szzls)) = .Fields("StartMoney") + 0
- If .Fields("StartDiff") <> 0 Then '计划金额
- CxbbGrid.TextMatrix(Jsqte, Sydz("014", GridStr(), Szzls)) = .Fields("StartDiff") + 0
- End If
- End If
- End With
- SqlStr = "SELECT * FROM Chhs_V_Mate a " & Trim(Str_QueryCondi) & " and a.mnumber='" & Mnumber & "' order by a.period "
- Set Rec_Query = Cw_DataEnvi.DataConnect.Execute(SqlStr)
- With Rec_Query
- Do While Not .EOF
- '日常数据
- If .Fields("inmoney") <> 0 Or .Fields("outmoney") <> 0 Or .Fields("jfdiff") <> 0 Or .Fields("dfdiff") <> 0 Then
- CxbbGrid.AddItem ""
- Jsqte = CxbbGrid.Rows - 1
- CxbbGrid.RowHeight(Jsqte) = Sjhgd
- CxbbGrid.TextMatrix(Jsqte, Sydz("001", GridStr(), Szzls)) = .Fields("period")
- CxbbGrid.TextMatrix(Jsqte, Sydz("002", GridStr(), Szzls)) = " 本月合计"
- '入库
- If .Fields("InQuan") <> 0 Then '数量
- CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = .Fields("InQuan") + 0
- End If
- If .Fields("InPrice") <> 0 Then '计划单价
- CxbbGrid.TextMatrix(Jsqte, Sydz("004", GridStr(), Szzls)) = .Fields("InPrice") + 0
- End If
- If .Fields("InMoney") <> 0 Then '计划金额
- CxbbGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = .Fields("InMoney") + 0
- End If
- '出库
- If .Fields("OutQuan") <> 0 Then '数量
- CxbbGrid.TextMatrix(Jsqte, Sydz("006", GridStr(), Szzls)) = .Fields("OutQuan") + 0
- End If
- If .Fields("OutPrice") <> 0 Then '实际单价
- CxbbGrid.TextMatrix(Jsqte, Sydz("007", GridStr(), Szzls)) = .Fields("OutPrice") + 0
- End If
- If .Fields("OutMoney") <> 0 Then '实际金额
- CxbbGrid.TextMatrix(Jsqte, Sydz("008", GridStr(), Szzls)) = .Fields("OutMoney") + 0
- End If
- '结存
- CxbbGrid.TextMatrix(Jsqte, Sydz("009", GridStr(), Szzls)) = Val(CxbbGrid.TextMatrix(Jsqte - 1, Sydz("009", GridStr(), Szzls))) + Val(.Fields("inquan")) - Val(.Fields("outquan"))
- CxbbGrid.TextMatrix(Jsqte, Sydz("011", GridStr(), Szzls)) = Val(CxbbGrid.TextMatrix(Jsqte - 1, Sydz("011", GridStr(), Szzls))) + Val(.Fields("inmoney")) - Val(.Fields("outmoney"))
- If Val(CxbbGrid.TextMatrix(Jsqte, Sydz("009", GridStr(), Szzls))) <> 0 Then
- CxbbGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls)) = Val(CxbbGrid.TextMatrix(Jsqte, Sydz("011", GridStr(), Szzls))) / Val(CxbbGrid.TextMatrix(Jsqte, Sydz("009", GridStr(), Szzls)))
- End If
- If Val(CxbbGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls))) = 0 Then
- CxbbGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls)) = ""
- End If
- '差异
- If .Fields("JfDiff") <> 0 Then '借方差异
- CxbbGrid.TextMatrix(Jsqte, Sydz("012", GridStr(), Szzls)) = .Fields("JfDiff") + 0
- End If
- If .Fields("DfDiff") <> 0 Then '贷方差异
- CxbbGrid.TextMatrix(Jsqte, Sydz("013", GridStr(), Szzls)) = .Fields("DfDiff") + 0
- End If
- CxbbGrid.TextMatrix(Jsqte, Sydz("014", GridStr(), Szzls)) = Val(CxbbGrid.TextMatrix(Jsqte - 1, Sydz("014", GridStr(), Szzls))) + Val(.Fields("jfdiff")) - Val(.Fields("dfdiff"))
- If Val(CxbbGrid.TextMatrix(Jsqte, Sydz("014", GridStr(), Szzls))) = 0 Then
- CxbbGrid.TextMatrix(Jsqte, Sydz("014", GridStr(), Szzls)) = ""
- End If
- End If
- .MoveNext
- Loop
- End With
- ']以上为用户自定义部分
- Set Rec_Query = Nothing
- End Sub
- Private Sub Sub_Mx() '明细
- If Com_Mnumber.ComboItems.count = 0 Then Exit Sub
- '明细帐
- Xtcdcs = "Chhs_List"
- Xtcdcsfz = Com_Mnumber.SelectedItem.Index
- Load Zbfx_ListCond
- With Zbfx_ListCond
- .Lbl_Year = Zbfx_MateCond.Lbl_Year
- .Com_QsMon.ListIndex = Zbfx_MateCond.Com_QsMon.ListIndex
- .Com_JzMon.ListIndex = Zbfx_MateCond.Com_JzMon.ListIndex
- .LrText(0).Text = Zbfx_MateCond.LrText(0).Text
- .LrText(0).Tag = Zbfx_MateCond.LrText(0).Tag
- .LrText(1).Text = Zbfx_MateCond.LrText(1).Text
- .LrText(1).Tag = Zbfx_MateCond.LrText(1).Tag
- .LrText(2).Text = Zbfx_MateCond.LrText(2).Text
- .LrText(3).Text = Zbfx_MateCond.LrText(3)
- End With
- Zbfx_List.Show
- Zbfx_List.Lbl_TitleText(0).Tag = Lbl_TitleText(0).Tag
- Zbfx_List.Timer1.Enabled = True
- End Sub
- Private Sub bbyl(bbylte As Boolean) '报表打印预览
- Dim Bbzbt$, Bbxbt() As String, bbxbtzzxs() As Integer, Bbxbtgs As Integer
- Dim Bbbwh() As String, Bbbwhzzxs() As Integer, Bbbwhgs As Integer
- Bbxbtgs = 1 '报 表 小 标 题 行 数
- Bbbwhgs = 0 '报 表 表 尾 行 数
- ReDim Bbxbt(1 To Bbxbtgs)
- ReDim bbxbtzzxs(1 To Bbxbtgs)
- If Bbbwhgs <> 0 Then
- ReDim Bbbwh(1 To Bbbwhgs)
- ReDim Bbbwhzzxs(1 To Bbbwhgs)
- End If
- Bbzbt = Lab_Title(0)
- Bbxbt(1) = Fun_FormatOutPut("存货:" + Trim(Com_Mnumber.Text), 40)
- Bbxbt(1) = Bbxbt(1) + Fun_FormatOutPut("规格型号:" + Trim(Lbl_TitleText(0)), 40)
- Bbxbt(1) = Bbxbt(1) + Fun_FormatOutPut("仓库:" + Trim(Lbl_TitleText(1)), 20)
- bbxbtzzxs(1) = 0 '报表行组织形式(0-居左 1-居中 2-居右)
- Call Scyxsjb(CxbbGrid) '生成报表数据
- Call Scdybb(Dyymctbl, Bbzbt, Bbxbt(), bbxbtzzxs(), Bbxbtgs, Bbbwh(), Bbbwhzzxs(), Bbbwhgs, bbylte)
- If Not bbylte Then
- Unload DY_Tybbyldy
- End If
- End Sub