资源名称:ERPSYS.zip [点击查看]
上传用户:zhpu1995
上传日期:2013-09-06
资源大小:61151k
文件大小:41k
源码类别:
企业管理
开发平台:
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 XJ_FrmXjllfpjg
- Caption = "现金流量数据分配"
- ClientHeight = 7680
- ClientLeft = 315
- ClientTop = 390
- ClientWidth = 11880
- HelpContextID = 5001
- Icon = "现金流量_凭证现金流量分配结果.frx":0000
- KeyPreview = -1 'True
- LinkTopic = "Form1"
- MDIChild = -1 'True
- ScaleHeight = 7680
- ScaleWidth = 11880
- WindowState = 2 'Maximized
- Begin VB.PictureBox Pic_Title
- Height = 780
- Left = 0
- Picture = "现金流量_凭证现金流量分配结果.frx":1042
- ScaleHeight = 720
- ScaleWidth = 11805
- TabIndex = 3
- Top = 570
- Width = 11865
- Begin VB.Label Label1
- Appearance = 0 'Flat
- BackColor = &H80000005&
- BackStyle = 0 'Transparent
- Caption = "现金流量科目记录"
- ForeColor = &H80000008&
- Height = 195
- Index = 1
- Left = 8670
- TabIndex = 10
- Top = 300
- Width = 1515
- End
- Begin VB.Label Lab_Color
- Appearance = 0 'Flat
- BackColor = &H00F7F3EC&
- BorderStyle = 1 'Fixed Single
- ForeColor = &H80000008&
- Height = 195
- Index = 2
- Left = 8430
- TabIndex = 9
- Top = 270
- Width = 195
- End
- Begin VB.Label tsLabel
- BackColor = &H80000018&
- BackStyle = 0 'Transparent
- Caption = "现金流量数据调整"
- BeginProperty Font
- Name = "宋体"
- Size = 14.25
- Charset = 134
- Weight = 700
- Underline = 0 'False
- Italic = 0 'False
- Strikethrough = 0 'False
- EndProperty
- ForeColor = &H00000000&
- Height = 450
- Index = 4
- Left = 525
- TabIndex = 8
- Top = 180
- Width = 2640
- End
- Begin VB.Label Lab_TitleMess
- BackStyle = 0 'Transparent
- Caption = "会计期间:"
- Height = 225
- Left = 5310
- TabIndex = 7
- Top = 270
- Width = 915
- End
- Begin VB.Label Lab_TitleText
- BackStyle = 0 'Transparent
- ForeColor = &H00000000&
- Height = 165
- Left = 6225
- TabIndex = 6
- Top = 270
- Width = 1455
- End
- Begin VB.Label Label1
- Appearance = 0 'Flat
- BackColor = &H80000005&
- BackStyle = 0 'Transparent
- Caption = "有错凭证"
- ForeColor = &H80000008&
- Height = 195
- Index = 0
- Left = 10545
- TabIndex = 5
- Top = 300
- Width = 795
- End
- Begin VB.Label Lab_Color
- Appearance = 0 'Flat
- BackColor = &H008080FF&
- BorderStyle = 1 'Fixed Single
- ForeColor = &H80000008&
- Height = 195
- Index = 1
- Left = 10275
- TabIndex = 4
- Top = 270
- Width = 195
- End
- End
- Begin VSFlex8Ctl.VSFlexGrid CxbbGrid
- Height = 4950
- Left = 30
- TabIndex = 0
- Top = 1410
- Width = 11865
- _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
- End
- Begin MSComctlLib.Toolbar GsToolbar
- Height = 525
- Left = 9465
- TabIndex = 2
- Top = 30
- Width = 2475
- _ExtentX = 4366
- _ExtentY = 926
- ButtonWidth = 1455
- ButtonHeight = 926
- AllowCustomize = 0 'False
- Appearance = 1
- Style = 1
- ImageList = "ImageList1"
- _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 VB.Timer Timer1
- Enabled = 0 'False
- Interval = 1
- Left = 7620
- Top = 90
- End
- Begin MSComctlLib.Toolbar SzToolbar
- Align = 1 'Align Top
- Height = 555
- Left = 0
- TabIndex = 1
- Top = 0
- Width = 11880
- _ExtentX = 20955
- _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 = 9
- BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "设置"
- Key = "sz"
- 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}
- Caption = "凭证"
- Key = "pz"
- ImageKey = "pz"
- EndProperty
- BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Style = 3
- EndProperty
- BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "帮助"
- Key = "bz"
- ImageKey = "bz"
- EndProperty
- BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628}
- Caption = "退出"
- Key = "fh"
- ImageKey = "tc"
- EndProperty
- EndProperty
- BorderStyle = 1
- Begin MSComctlLib.ImageList ImageList1
- Left = 6840
- Top = 0
- _ExtentX = 1005
- _ExtentY = 1005
- BackColor = -2147483643
- ImageWidth = 16
- ImageHeight = 16
- MaskColor = 12632256
- _Version = 393216
- BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
- NumListImages = 32
- BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":35106
- Key = "sz"
- EndProperty
- BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":354A0
- Key = "dy"
- EndProperty
- BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3583A
- Key = "yl"
- EndProperty
- BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":35BD4
- Key = "xg"
- EndProperty
- BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":35F6E
- Key = "zh"
- EndProperty
- BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":36308
- Key = "sh"
- EndProperty
- BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":366A2
- Key = "bc"
- EndProperty
- BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":36A3C
- Key = "fq"
- EndProperty
- BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":36DD6
- Key = "bz"
- EndProperty
- BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":37170
- Key = "tc"
- EndProperty
- BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3750A
- Key = "bcgs"
- EndProperty
- BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":378A4
- Key = "mrlk"
- EndProperty
- BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":37C3E
- Key = "xsxm"
- EndProperty
- BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":37FD8
- Key = "first"
- EndProperty
- BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":38372
- Key = "prev"
- EndProperty
- BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3870C
- Key = "next"
- EndProperty
- BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":38AA6
- Key = "last"
- EndProperty
- BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":38E40
- Key = "xx"
- EndProperty
- BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":391DA
- Key = "define"
- EndProperty
- BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":39574
- Key = "exec"
- EndProperty
- BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3990E
- Key = "xz"
- EndProperty
- BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":39CA8
- Key = "sc"
- EndProperty
- BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3A042
- Key = "sx"
- EndProperty
- BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3A3DC
- Key = "cx"
- EndProperty
- BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3A776
- Key = "zd"
- EndProperty
- BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3AB10
- Key = "dz"
- EndProperty
- BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3AEAA
- Key = "ph"
- EndProperty
- BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3B244
- Key = "fz"
- EndProperty
- BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3B5DE
- Key = "dw"
- EndProperty
- BeginProperty ListImage30 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3B978
- Key = "hf"
- EndProperty
- BeginProperty ListImage31 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3BD12
- Key = "pz"
- EndProperty
- BeginProperty ListImage32 {2C247F27-8591-11D1-B16A-00C0F0283628}
- Picture = "现金流量_凭证现金流量分配结果.frx":3C0AC
- Key = "check"
- EndProperty
- EndProperty
- End
- End
- Begin VSFlex8Ctl.VSFlexGrid WglrGrid
- Height = 1155
- Left = 0
- TabIndex = 11
- Top = 6420
- Width = 9195
- _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 = 12632256
- 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
- End
- Begin VB.Frame Frame1
- Height = 1275
- Left = 9210
- TabIndex = 12
- Top = 6330
- Width = 2655
- Begin VB.Label Label1
- BackStyle = 0 'Transparent
- Caption = "凭证金额合计:"
- Height = 225
- Index = 3
- Left = 150
- TabIndex = 16
- Top = 510
- Width = 1215
- End
- Begin VB.Label Lab_Pzjehj
- BackStyle = 0 'Transparent
- ForeColor = &H00C00000&
- Height = 225
- Left = 1350
- TabIndex = 15
- Top = 510
- Width = 1095
- End
- Begin VB.Label Label1
- BackStyle = 0 'Transparent
- Caption = "分配金额合计:"
- Height = 225
- Index = 2
- Left = 150
- TabIndex = 14
- Top = 900
- Width = 1215
- End
- Begin VB.Label Lab_Fpje
- BackStyle = 0 'Transparent
- ForeColor = &H00C00000&
- Height = 255
- Left = 1350
- TabIndex = 13
- Top = 900
- Width = 1245
- End
- End
- End
- Attribute VB_Name = "XJ_FrmXjllfpjg"
- Attribute VB_GlobalNameSpace = False
- Attribute VB_Creatable = False
- Attribute VB_PredeclaredId = True
- Attribute VB_Exposed = False
- '*****************************************************************
- '* 模 块 名 称 :现金流量数据调整
- '* 功 能 描 述 :
- '* 程序员姓名 :张建忠
- '* 最后修改人 :张建忠
- '* 最后修改时间:2001/12/03
- '* 备 注:程序中所有依实际情况自定义部分均用[>> <<]括起
- '*****************************************************************
- Dim Tsxx As String '系统提示信息
- Dim ReportTitle As String '报表主标题
- Dim Lng_VouchId As Long '分配现金流量凭证ID
- '以下为固定使用变量(凭证列表)
- Dim Dyymctbl As New DY_Dyymsz '打印页面窗体变量
- Dim GridCode As String '显示网格网格代码
- Dim GridInf() As Variant '整个网格设置信息
- 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)
- '以下为固定使用变量(现金流量分配网格)
- Dim GridCode1 As String '显示网格网格代码
- Dim GridInf1() As Variant '整个网格设置信息
- Dim Qslz1 As Long '网格隐藏(非操作显示)列数
- Dim Sjhgd1 As Double '网格数据行高度
- Dim Sfxshjwg1 As Boolean '是否显示合计网格
- Dim GridBoolean1() As Boolean '网格列信息(布尔型)
- Dim GridStr1() As String '网格列信息(字符型)
- Dim GridInt1() As Integer '网格列信息(整型)
- Dim Szzls1 As Integer '数组总列数(网格列数-1)
- Private Sub Form_Load() '窗体装入
- '调入打印页面设置窗体
- XtReportCode = "Cwzz_jzpzcx"
- Load Dyymctbl
- ReportTitle = "现金流量数据调整"
- '调整标题栏及网格、格式工具条位置
- 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
- '调 入 网 格(凭证列表)
- GridCode = "Cwzz_jzpzcx"
- Call BzWgcsh(CxbbGrid, GridCode, GridInf(), GridBoolean(), GridInt(), GridStr())
- Qslz = GridInf(1)
- Sjhgd = GridInf(2)
- Sfxshjwg = GridInf(7)
- Szzls = CxbbGrid.Cols - 1
- '调 入 网 格(现金流量分配情况)
- GridCode1 = "Cwzz_xjllsjtz" '网格属性编码
- Call BzWgcsh(WglrGrid, GridCode1, GridInf1(), GridBoolean1(), GridInt1(), GridStr1())
- Qslz1 = GridInf1(1)
- Sjhgd1 = GridInf1(2)
- Sfxshjwg1 = GridInf1(7)
- Szzls1 = WglrGrid.Cols - 1
- '调整标题位置
- SetTitlePos tsLabel(4)
- End Sub
- Private Sub Form_Unload(Cancel As Integer) '窗体卸载
- '卸载条件窗体
- XJ_FrmXjllfptj.UnloadCheck.Value = 1
- Unload XJ_FrmXjllfptj
- '卸载打印页面设置窗体
- 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) '表格格式设置(通用)
- 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 "sz" '页面设置
- Dyymctbl.Show 1
- Case "yl" '预 览
- Call bbyl(True)
- Case "dy" '打 印
- Call bbyl(False)
- Case "cx" '查 询
- XJ_FrmXjllfptj.Show 1
- Case "pz" '凭 证
- Call Sub_Drpz
- 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
- '生成查询结果
- On Error Resume Next
- Call Sub_Query
- CxbbGrid.Select CxbbGrid.Rows - 1, 1
- CxbbGrid.Select 1, 1
- '显示当前凭证现金流量分配情况
- Call CxbbGrid_RowColChange
- CxbbGrid.Redraw = True
- Xt_Wait.Hide
- End Sub
- Private Sub Sub_Query() '生成查询结果
- Dim Rec_Query As New ADODB.Recordset '查询结果动态集
- Dim Str_QueryCondi As String '用户录入查询条件
- Dim Sqlstr As String '查询字符串
- Dim Coljsq As Long '网格列计数器
- Dim Jsqte As Integer '临时动态计数器
- Dim Int_VouchID% '记录上一张凭证标识
- Dim Dbl_Jfhj#, Dbl_Dfhj# '每张凭证借贷方合计
- '以下为用户自定义部分[
- With XJ_FrmXjllfptj
- '显示查询会计期间
- Lab_TitleText.Caption = .Combo_Kjqj.Text
- Str_QueryCondi = " where 1=1 "
- For Jsqte = 1 To 6
- Select Case Jsqte
- Case 1 '凭证范围
- Select Case Trim(.Combo_Pzfw.Text)
- Case "未记帐凭证"
- Str_QueryCondi = Str_QueryCondi & " and b.BookFlag=0"
- Case "记帐凭证"
- Str_QueryCondi = Str_QueryCondi & " and b.BookFlag=1"
- End Select
- Case 2 '凭证类别
- If GetComboKey(.Imgebo_VouchClass, 0) <> "" Then
- Str_QueryCondi = Str_QueryCondi & " and b.VouchClassCode='" & Trim(GetComboKey(.Imgebo_VouchClass, 0)) & "'"
- End If
- Case 3 '会计期间
- If Trim(.Combo_Kjqj.Text) <> "" Then
- Str_QueryCondi = Str_QueryCondi & " and b.Year='" & Mid(Trim(.Combo_Kjqj.Text), 1, 4) & "' and b.Period='" & Mid(Trim(.Combo_Kjqj.Text), 6, 2) & "'"
- End If
- Case 4 '凭证号范围(起始)
- Str_QueryCondi = Str_QueryCondi & " and b.VouchNo>= " & Val(.LrText(0).Text)
- Case 5 '凭证号范围(终止)
- If Val(.LrText(1)) <> 0 Then
- Str_QueryCondi = Str_QueryCondi & " and b.VouchNo<= " & Val(.LrText(1).Text)
- End If
- Case 6 '科目号
- If Trim(.LrText(2)) <> "" Then
- Str_QueryCondi = Str_QueryCondi & " and b.Ccode like '" & Trim(.LrText(2).Text) & "%'"
- End If
- End Select
- Next Jsqte
- End With
- Sqlstr = "SELECT a.*,Cwzz_AccCode.Cname,Cwzz_AccCode.CashFlowFlag From Cwzz_V_AccVouch a LEFT OUTER JOIN " & _
- " Cwzz_AccCode ON " & _
- " a.Ccode = Cwzz_AccCode.Ccode" & _
- " Where EXISTS (SELECT * From Cwzz_V_AccVouch b LEFT OUTER JOIN Cwzz_AccCode ON " & _
- " b.Ccode = Cwzz_AccCode.Ccode" & Str_QueryCondi & " AND a.VouchID=b.VouchID and Cwzz_AccCode.CashFlowFlag=1) " & _
- " Order by Year,Period,VouchClassCode,VouchNo,SerialID"
- Set Rec_Query = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
- With Rec_Query
- CxbbGrid.Rows = CxbbGrid.FixedRows
- CxbbGrid.Rows = CxbbGrid.FixedRows + .RecordCount
- Jsqte = CxbbGrid.FixedRows
- Do While Not .EOF
- If Jsqte >= CxbbGrid.Rows Then
- CxbbGrid.AddItem ""
- End If
- CxbbGrid.TextMatrix(Jsqte, 0) = .Fields("VouchID") '凭证ID
- '如果为同一张凭证则不再输出制单日期和凭证号
- If Int_VouchID <> .Fields("VouchID") Then
- Int_VouchID = .Fields("VouchID") '凭证ID
- CxbbGrid.TextMatrix(Jsqte, Sydz("001", GridStr(), Szzls)) = .Fields("Ddate") '制单日期
- CxbbGrid.TextMatrix(Jsqte, Sydz("002", GridStr(), Szzls)) = Trim(.Fields("VouchClassCode") & "") + "-" + Mid(Trim(Str(10000 + .Fields("VouchNo"))), 2, 4) '凭证号
- End If
- '产生现金流量科目记录变色显示
- If .Fields("CashFlowFlag") Then
- CxbbGrid.Cell(flexcpBackColor, Jsqte, 0, , CxbbGrid.Cols - 1) = Lab_Color(2).BackColor
- End If
- CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = Trim(.Fields("Digest") & "") '摘要
- CxbbGrid.TextMatrix(Jsqte, Sydz("004", GridStr(), Szzls)) = Trim(.Fields("Ccode") & "") '科目编码
- CxbbGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = Trim(.Fields("Cname") & "") '科目名称
- If .Fields("Jfje") <> 0 Then '借方金额
- CxbbGrid.TextMatrix(Jsqte, Sydz("006", GridStr(), Szzls)) = Trim(Str(.Fields("Jfje")))
- End If
- If .Fields("Dfje") <> 0 Then '贷方金额
- CxbbGrid.TextMatrix(Jsqte, Sydz("007", GridStr(), Szzls)) = Trim(Str(.Fields("Dfje")))
- End If
- CxbbGrid.TextMatrix(Jsqte, Sydz("008", GridStr(), Szzls)) = Trim(.Fields("Bill") & "") '制单人
- CxbbGrid.TextMatrix(Jsqte, Sydz("009", GridStr(), Szzls)) = Trim(.Fields("Checker") & "") '审核人
- CxbbGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls)) = Trim(.Fields("Book") & "") '记帐人
- CxbbGrid.TextMatrix(Jsqte, Sydz("011", GridStr(), Szzls)) = Trim(.Fields("VouchSource") & "") '凭证来源
- If .Fields("ErrorFlag") Then '有错凭证(红色显示)
- CxbbGrid.Cell(flexcpBackColor, Jsqte, 0, , CxbbGrid.Cols - 1) = Lab_Color(1).BackColor
- End If
- '计算本张凭证合计
- Dbl_Jfhj = Dbl_Jfhj + .Fields("Jfje")
- Dbl_Dfhj = Dbl_Dfhj + .Fields("Dfje")
- CxbbGrid.RowHeight(Jsqte) = Sjhgd
- Jsqte = Jsqte + 1
- .MoveNext
- If .EOF Then
- CxbbGrid.AddItem ""
- CxbbGrid.RowHeight(Jsqte) = Sjhgd
- CxbbGrid.TextMatrix(Jsqte, 0) = Int_VouchID '凭证ID
- CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = "合 计"
- If Dbl_Jfhj <> 0 Then '借方合计
- CxbbGrid.TextMatrix(Jsqte, Sydz("006", GridStr(), Szzls)) = Trim(Str(Dbl_Jfhj))
- End If
- If Dbl_Dfhj <> 0 Then '贷方合计
- CxbbGrid.TextMatrix(Jsqte, Sydz("007", GridStr(), Szzls)) = Trim(Str(Dbl_Dfhj))
- End If
- '合计清零
- Dbl_Jfhj = 0
- Dbl_Dfhj = 0
- Jsqte = Jsqte + 1
- Else
- If Int_VouchID <> .Fields("VouchID") Then
- CxbbGrid.AddItem ""
- CxbbGrid.RowHeight(Jsqte) = Sjhgd
- CxbbGrid.TextMatrix(Jsqte, 0) = Int_VouchID '凭证ID
- CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = "合 计"
- If Dbl_Jfhj <> 0 Then '借方合计
- CxbbGrid.TextMatrix(Jsqte, Sydz("006", GridStr(), Szzls)) = Trim(Str(Dbl_Jfhj))
- End If
- If Dbl_Dfhj <> 0 Then '贷方合计
- CxbbGrid.TextMatrix(Jsqte, Sydz("007", GridStr(), Szzls)) = Trim(Str(Dbl_Dfhj))
- End If
- '合计清零
- Dbl_Jfhj = 0
- Dbl_Dfhj = 0
- Jsqte = Jsqte + 1
- End If
- End If
- Loop
- End With
- ']以上为用户自定义部分
- End Sub
- Private Sub CxbbGrid_DblClick() '用户双击网格进行现金流量调整
- If Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0)) <> 0 Then
- Xtcdcs = CxbbGrid.TextMatrix(CxbbGrid.Row, 0)
- XJ_FrmXjllsjtz.Show 1
- '显示当前凭证现金流量分配情况
- Lng_VouchId = Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0))
- Call Sub_XjllQuery(Lng_VouchId)
- End If
- End Sub
- Private Sub CxbbGrid_KeyPress(KeyAscii As Integer) '用户按回车键进行现金流量调整
- If KeyAscii = vbKeyReturn Then
- Call CxbbGrid_DblClick
- End If
- End Sub
- Private Sub Sub_Drpz() '调入相应凭证
- Dim RecTemp As New ADODB.Recordset
- '非数据行退出
- If CxbbGrid.Row < CxbbGrid.FixedRows Then
- Exit Sub
- End If
- Sqlstr = "SELECT VouchID From Cwzz_AccVouchMain" & _
- " Where VouchID=" & Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0))
- Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
- With RecTemp
- If .EOF Then
- Tsxx = "此凭证已被其他用户删除!"
- Call Xtxxts(Tsxx, 0, 4)
- Exit Sub
- Else
- With PZ_JzpzclFrm
- '填充查询凭证标识
- .Lab_VouchId = Trim(CxbbGrid.TextMatrix(CxbbGrid.Row, 0))
- '设置凭证处理为明细帐联查凭证状态
- .Lab_Pzclzt.Caption = "4"
- .Show 1
- End With
- End If
- End With
- End Sub
- Private Sub CxbbGrid_RowColChange() '显示当前凭证现金流量分配情况
- If Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0)) <> Lng_VouchId Then
- Lng_VouchId = Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0))
- Call Sub_XjllQuery(Lng_VouchId)
- End If
- End Sub
- Private Sub Sub_XjllQuery(Lng_VouchId1 As Long) '显示当前凭证分配金额
- Dim Sqlstr As String '查询字符串
- Dim RecTemp As New ADODB.Recordset '临时使用动态集
- Dim Jsqte As Long '临时计数器
- Sqlstr = "SELECT Jfjehj=isnull(sum(Jfje),0) From Cwzz_AccVouchSub Where VouchID=" & Lng_VouchId
- Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
- If Not RecTemp.EOF Then
- Lab_Pzjehj.Caption = RecTemp.Fields("Jfjehj")
- End If
- Sqlstr = "SELECT Cwzz_CashFlowData.*,Cwzz_CashFlowItem.CashFlowName From Cwzz_CashFlowData LEFT OUTER JOIN Cwzz_CashFlowItem ON" & _
- " Cwzz_CashFlowData.CashFlowId = Cwzz_CashFlowItem.CashFlowId Where Cwzz_CashFlowData.VouchID=" & Lng_VouchId1 & " Order By CashFlowDataID"
- Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
- With RecTemp
- WglrGrid.Clear 1
- WglrGrid.Rows = .RecordCount + WglrGrid.FixedRows
- Jsqte = WglrGrid.FixedRows
- Do While Not .EOF
- If Jsqte >= WglrGrid.Rows Then
- WglrGrid.AddItem ""
- End If
- WglrGrid.TextMatrix(Jsqte, 0) = "*" '有效记录标识
- WglrGrid.TextMatrix(Jsqte, 1) = Trim(.Fields("CashFlowID") & "") '现金流量项目ID
- WglrGrid.TextMatrix(Jsqte, Sydz("001", GridStr1(), Szzls1)) = Trim(.Fields("CashFlowName") & "") '部门编码
- If .Fields("Fpje") <> 0 Then '分配金额
- WglrGrid.TextMatrix(Jsqte, Sydz("002", GridStr1(), Szzls1)) = .Fields("Fpje")
- End If
- '<<]
- WglrGrid.RowHeight(Jsqte) = Sjhgd1
- .MoveNext
- Jsqte = Jsqte + 1
- Loop
- End With
- '计算分配金额
- Call Sub_Jsfpje
- End Sub
- Private Sub Sub_Jsfpje() '计算凭证分配现金流量金额
- Dim Dbl_Fpje As Double
- Dbl_Fpje = 0
- With WglrGrid
- For Jsqte = .FixedRows To .Rows - 1
- If .TextMatrix(Jsqte, 0) = "*" Then
- Dbl_Fpje = Dbl_Fpje + Val(.TextMatrix(Jsqte, Sydz("002", GridStr1(), Szzls1)))
- End If
- Next Jsqte
- End With
- If Dbl_Fpje = 0 Then
- Lab_Fpje.Caption = ""
- Else
- Lab_Fpje.Caption = Dbl_Fpje
- End If
- 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 = ReportTitle
- Bbxbt(1) = " "
- 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