开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 企业管理 > 查看源码
-
资源名称：ERPSYS.zip　[点击查看]
上传用户：zhpu1995
上传日期：2013-09-06
资源大小：61151k
文件大小：44k
源码类别：

企业管理

开发平台：

Visual Basic

-：源码内容
  1. VERSION 5.00
  2. Object = "{BEEECC20-4D5F-4F8B-BFDC-5D9B6FBDE09D}#1.0#0"; "vsflex8.ocx"
  3. Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
  4. Begin VB.Form Report_FrmSuppList 
  5.    Caption         =   "供应商余额表"
  6.    ClientHeight    =   8595
  7.    ClientLeft      =   315
  8.    ClientTop       =   390
  9.    ClientWidth     =   11820
  10.    HelpContextID   =   5001
  11.    Icon            =   "统计分析_供应商余额查询列表.frx":0000
  12.    KeyPreview      =   -1  'True
  13.    LinkTopic       =   "Form1"
  14.    MDIChild        =   -1  'True
  15.    ScaleHeight     =   8595
  16.    ScaleWidth      =   11820
  17.    WindowState     =   2  'Maximized
  18.    Begin MSComctlLib.Toolbar GsToolbar 
  19.       Height          =   525
  20.       Left            =   9330
  21.       TabIndex        =   3
  22.       Top             =   30
  23.       Width           =   2475
  24.       _ExtentX        =   4366
  25.       _ExtentY        =   926
  26.       ButtonWidth     =   1455
  27.       ButtonHeight    =   926
  28.       Appearance      =   1
  29.       Style           =   1
  30.       ImageList       =   "ImageList2"
  31.       _Version        =   393216
  32.       BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
  33.          NumButtons      =   3
  34.          BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  35.             Caption         =   "保存格式"
  36.             Key             =   "bcgs"
  37.             ImageKey        =   "bcgs"
  38.          EndProperty
  39.          BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  40.             Caption         =   "默认列宽"
  41.             Key             =   "hfmrgs"
  42.             ImageKey        =   "mrlk"
  43.          EndProperty
  44.          BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  45.             Caption         =   "显示项目"
  46.             Key             =   "szxsxm"
  47.             ImageKey        =   "xsxm"
  48.          EndProperty
  49.       EndProperty
  50.    End
  51.    Begin VB.PictureBox Pic_Title 
  52.       Height          =   1095
  53.       Left            =   0
  54.       Picture         =   "统计分析_供应商余额查询列表.frx":1042
  55.       ScaleHeight     =   1035
  56.       ScaleWidth      =   11715
  57.       TabIndex        =   1
  58.       Top             =   570
  59.       Width           =   11775
  60.       Begin VB.Label Lab_Foreign 
  61.          AutoSize        =   -1  'True
  62.          BackStyle       =   0  'Transparent
  63.          Caption         =   "币别:"
  64.          Height          =   180
  65.          Left            =   7320
  66.          TabIndex        =   8
  67.          Top             =   780
  68.          Width           =   450
  69.       End
  70.       Begin VB.Label Lab_Kjqj 
  71.          AutoSize        =   -1  'True
  72.          BackStyle       =   0  'Transparent
  73.          Caption         =   "会计期间:"
  74.          Height          =   180
  75.          Left            =   4800
  76.          TabIndex        =   7
  77.          Top             =   780
  78.          Width           =   810
  79.       End
  80.       Begin VB.Label Lab_Person 
  81.          AutoSize        =   -1  'True
  82.          BackStyle       =   0  'Transparent
  83.          Caption         =   "经办人:"
  84.          Height          =   180
  85.          Left            =   2460
  86.          TabIndex        =   6
  87.          Top             =   780
  88.          Width           =   630
  89.       End
  90.       Begin VB.Label Lab_Dept 
  91.          AutoSize        =   -1  'True
  92.          BackStyle       =   0  'Transparent
  93.          Caption         =   "部门:"
  94.          Height          =   180
  95.          Left            =   300
  96.          TabIndex        =   5
  97.          Top             =   780
  98.          Width           =   450
  99.       End
  100.       Begin VB.Label Lab_Title 
  101.          AutoSize        =   -1  'True
  102.          BackColor       =   &H80000018&
  103.          BackStyle       =   0  'Transparent
  104.          Caption         =   "供应商余额表"
  105.          BeginProperty Font 
  106.             Name            =   "宋体"
  107.             Size            =   12
  108.             Charset         =   134
  109.             Weight          =   700
  110.             Underline       =   0   'False
  111.             Italic          =   0   'False
  112.             Strikethrough   =   0   'False
  113.          EndProperty
  114.          ForeColor       =   &H00000000&
  115.          Height          =   240
  116.          Index           =   4
  117.          Left            =   510
  118.          TabIndex        =   2
  119.          Top             =   210
  120.          Width           =   1530
  121.       End
  122.    End
  123.    Begin VB.Timer Timer1 
  124.       Enabled         =   0   'False
  125.       Interval        =   1
  126.       Left            =   7620
  127.       Top             =   90
  128.    End
  129.    Begin VSFlex8Ctl.VSFlexGrid CxbbGrid 
  130.       Height          =   7305
  131.       Left            =   30
  132.       TabIndex        =   0
  133.       Top             =   1710
  134.       Width           =   11775
  135.       _cx             =   5080
  136.       _cy             =   5080
  137.       Appearance      =   1
  138.       BorderStyle     =   1
  139.       Enabled         =   -1  'True
  140.       BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
  141.          Name            =   "宋体"
  142.          Size            =   9
  143.          Charset         =   134
  144.          Weight          =   400
  145.          Underline       =   0   'False
  146.          Italic          =   0   'False
  147.          Strikethrough   =   0   'False
  148.       EndProperty
  149.       MousePointer    =   0
  150.       BackColor       =   16777215
  151.       ForeColor       =   -2147483640
  152.       BackColorFixed  =   13826538
  153.       ForeColorFixed  =   -2147483630
  154.       BackColorSel    =   -2147483635
  155.       ForeColorSel    =   -2147483634
  156.       BackColorBkg    =   -2147483636
  157.       BackColorAlternate=   16777215
  158.       GridColor       =   -2147483633
  159.       GridColorFixed  =   -2147483632
  160.       TreeColor       =   -2147483632
  161.       FloodColor      =   192
  162.       SheetBorder     =   -2147483642
  163.       FocusRect       =   1
  164.       HighLight       =   1
  165.       AllowSelection  =   -1  'True
  166.       AllowBigSelection=   -1  'True
  167.       AllowUserResizing=   0
  168.       SelectionMode   =   0
  169.       GridLines       =   1
  170.       GridLinesFixed  =   2
  171.       GridLineWidth   =   1
  172.       Rows            =   50
  173.       Cols            =   10
  174.       FixedRows       =   1
  175.       FixedCols       =   1
  176.       RowHeightMin    =   0
  177.       RowHeightMax    =   0
  178.       ColWidthMin     =   0
  179.       ColWidthMax     =   0
  180.       ExtendLastCol   =   0   'False
  181.       FormatString    =   ""
  182.       ScrollTrack     =   0   'False
  183.       ScrollBars      =   3
  184.       ScrollTips      =   0   'False
  185.       MergeCells      =   0
  186.       MergeCompare    =   0
  187.       AutoResize      =   -1  'True
  188.       AutoSizeMode    =   0
  189.       AutoSearch      =   0
  190.       AutoSearchDelay =   2
  191.       MultiTotals     =   -1  'True
  192.       SubtotalPosition=   1
  193.       OutlineBar      =   0
  194.       OutlineCol      =   0
  195.       Ellipsis        =   0
  196.       ExplorerBar     =   0
  197.       PicturesOver    =   0   'False
  198.       FillStyle       =   0
  199.       RightToLeft     =   0   'False
  200.       PictureType     =   0
  201.       TabBehavior     =   0
  202.       OwnerDraw       =   0
  203.       Editable        =   0
  204.       ShowComboButton =   1
  205.       WordWrap        =   0   'False
  206.       TextStyle       =   0
  207.       TextStyleFixed  =   0
  208.       OleDragMode     =   0
  209.       OleDropMode     =   0
  210.       DataMode        =   0
  211.       VirtualData     =   -1  'True
  212.       DataMember      =   ""
  213.       ComboSearch     =   3
  214.       AutoSizeMouse   =   -1  'True
  215.       FrozenRows      =   0
  216.       FrozenCols      =   0
  217.       AllowUserFreezing=   0
  218.       BackColorFrozen =   0
  219.       ForeColorFrozen =   0
  220.       WallPaperAlignment=   9
  221.       AccessibleName  =   ""
  222.       AccessibleDescription=   ""
  223.       AccessibleValue =   ""
  224.       AccessibleRole  =   24
  225.       Begin MSComctlLib.ImageList ImageList2 
  226.          Left            =   0
  227.          Top             =   0
  228.          _ExtentX        =   1005
  229.          _ExtentY        =   1005
  230.          BackColor       =   -2147483643
  231.          ImageWidth      =   16
  232.          ImageHeight     =   16
  233.          MaskColor       =   12632256
  234.          _Version        =   393216
  235.          BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
  236.             NumListImages   =   40
  237.             BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  238.                Picture         =   "统计分析_供应商余额查询列表.frx":35106
  239.                Key             =   "sz"
  240.             EndProperty
  241.             BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  242.                Picture         =   "统计分析_供应商余额查询列表.frx":354A0
  243.                Key             =   "dy"
  244.             EndProperty
  245.             BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  246.                Picture         =   "统计分析_供应商余额查询列表.frx":3583A
  247.                Key             =   "yl"
  248.             EndProperty
  249.             BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  250.                Picture         =   "统计分析_供应商余额查询列表.frx":35BD4
  251.                Key             =   "xg"
  252.             EndProperty
  253.             BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  254.                Picture         =   "统计分析_供应商余额查询列表.frx":35F6E
  255.                Key             =   "zh"
  256.             EndProperty
  257.             BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  258.                Picture         =   "统计分析_供应商余额查询列表.frx":36308
  259.                Key             =   "sh"
  260.             EndProperty
  261.             BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  262.                Picture         =   "统计分析_供应商余额查询列表.frx":366A2
  263.                Key             =   "bc"
  264.             EndProperty
  265.             BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  266.                Picture         =   "统计分析_供应商余额查询列表.frx":36A3C
  267.                Key             =   "fq"
  268.             EndProperty
  269.             BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  270.                Picture         =   "统计分析_供应商余额查询列表.frx":36DD6
  271.                Key             =   "bz"
  272.             EndProperty
  273.             BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  274.                Picture         =   "统计分析_供应商余额查询列表.frx":37170
  275.                Key             =   "tc"
  276.             EndProperty
  277.             BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  278.                Picture         =   "统计分析_供应商余额查询列表.frx":3750A
  279.                Key             =   "bcgs"
  280.             EndProperty
  281.             BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  282.                Picture         =   "统计分析_供应商余额查询列表.frx":378A4
  283.                Key             =   "mrlk"
  284.             EndProperty
  285.             BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  286.                Picture         =   "统计分析_供应商余额查询列表.frx":37C3E
  287.                Key             =   "xsxm"
  288.             EndProperty
  289.             BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  290.                Picture         =   "统计分析_供应商余额查询列表.frx":37FD8
  291.                Key             =   "first"
  292.             EndProperty
  293.             BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  294.                Picture         =   "统计分析_供应商余额查询列表.frx":38372
  295.                Key             =   "prev"
  296.             EndProperty
  297.             BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  298.                Picture         =   "统计分析_供应商余额查询列表.frx":3870C
  299.                Key             =   "next"
  300.             EndProperty
  301.             BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  302.                Picture         =   "统计分析_供应商余额查询列表.frx":38AA6
  303.                Key             =   "last"
  304.             EndProperty
  305.             BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  306.                Picture         =   "统计分析_供应商余额查询列表.frx":38E40
  307.                Key             =   "xx"
  308.             EndProperty
  309.             BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  310.                Picture         =   "统计分析_供应商余额查询列表.frx":391DA
  311.                Key             =   "define"
  312.             EndProperty
  313.             BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  314.                Picture         =   "统计分析_供应商余额查询列表.frx":39574
  315.                Key             =   "exec"
  316.             EndProperty
  317.             BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  318.                Picture         =   "统计分析_供应商余额查询列表.frx":3990E
  319.                Key             =   "xz"
  320.             EndProperty
  321.             BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  322.                Picture         =   "统计分析_供应商余额查询列表.frx":39CA8
  323.                Key             =   "sc"
  324.             EndProperty
  325.             BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  326.                Picture         =   "统计分析_供应商余额查询列表.frx":3A042
  327.                Key             =   "sx"
  328.             EndProperty
  329.             BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  330.                Picture         =   "统计分析_供应商余额查询列表.frx":3A3DC
  331.                Key             =   "cx"
  332.             EndProperty
  333.             BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  334.                Picture         =   "统计分析_供应商余额查询列表.frx":3A776
  335.                Key             =   "zd"
  336.             EndProperty
  337.             BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  338.                Picture         =   "统计分析_供应商余额查询列表.frx":3AB10
  339.                Key             =   "dz"
  340.             EndProperty
  341.             BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  342.                Picture         =   "统计分析_供应商余额查询列表.frx":3AEAA
  343.                Key             =   "ph"
  344.             EndProperty
  345.             BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  346.                Picture         =   "统计分析_供应商余额查询列表.frx":3B244
  347.                Key             =   "fz"
  348.             EndProperty
  349.             BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  350.                Picture         =   "统计分析_供应商余额查询列表.frx":3B5DE
  351.                Key             =   "dw"
  352.             EndProperty
  353.             BeginProperty ListImage30 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  354.                Picture         =   "统计分析_供应商余额查询列表.frx":3B978
  355.                Key             =   "hf"
  356.             EndProperty
  357.             BeginProperty ListImage31 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  358.                Picture         =   "统计分析_供应商余额查询列表.frx":3BD12
  359.                Key             =   "pz"
  360.             EndProperty
  361.             BeginProperty ListImage32 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  362.                Picture         =   "统计分析_供应商余额查询列表.frx":3C0AC
  363.                Key             =   "check"
  364.             EndProperty
  365.             BeginProperty ListImage33 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  366.                Picture         =   "统计分析_供应商余额查询列表.frx":3C446
  367.                Key             =   "qs"
  368.             EndProperty
  369.             BeginProperty ListImage34 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  370.                Picture         =   "统计分析_供应商余额查询列表.frx":3C7E0
  371.                Key             =   "fullcheck"
  372.             EndProperty
  373.             BeginProperty ListImage35 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  374.                Picture         =   "统计分析_供应商余额查询列表.frx":3CB7A
  375.                Key             =   "qq"
  376.             EndProperty
  377.             BeginProperty ListImage36 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  378.                Picture         =   "统计分析_供应商余额查询列表.frx":3CF14
  379.                Key             =   "bcw"
  380.             EndProperty
  381.             BeginProperty ListImage37 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  382.                Picture         =   "统计分析_供应商余额查询列表.frx":3D2AE
  383.                Key             =   "ye"
  384.             EndProperty
  385.             BeginProperty ListImage38 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  386.                Picture         =   "统计分析_供应商余额查询列表.frx":3D648
  387.                Key             =   ""
  388.             EndProperty
  389.             BeginProperty ListImage39 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  390.                Picture         =   "统计分析_供应商余额查询列表.frx":3D9E2
  391.                Key             =   "frist"
  392.             EndProperty
  393.             BeginProperty ListImage40 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  394.                Picture         =   "统计分析_供应商余额查询列表.frx":3DD7C
  395.                Key             =   "dj"
  396.             EndProperty
  397.          EndProperty
  398.       End
  399.    End
  400.    Begin MSComctlLib.Toolbar SzToolbar 
  401.       Align           =   1  'Align Top
  402.       Height          =   555
  403.       Left            =   0
  404.       TabIndex        =   4
  405.       Top             =   0
  406.       Width           =   11820
  407.       _ExtentX        =   20849
  408.       _ExtentY        =   979
  409.       ButtonWidth     =   820
  410.       ButtonHeight    =   926
  411.       AllowCustomize  =   0   'False
  412.       Appearance      =   1
  413.       Style           =   1
  414.       ImageList       =   "ImageList1"
  415.       _Version        =   393216
  416.       BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
  417.          NumButtons      =   12
  418.          BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  419.             Caption         =   "设置"
  420.             Key             =   "ymsz"
  421.             ImageKey        =   "sz"
  422.          EndProperty
  423.          BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  424.             Caption         =   "打印"
  425.             Key             =   "dy"
  426.             ImageKey        =   "dy"
  427.          EndProperty
  428.          BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  429.             Caption         =   "预览"
  430.             Key             =   "yl"
  431.             ImageKey        =   "yl"
  432.          EndProperty
  433.          BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  434.             Style           =   3
  435.          EndProperty
  436.          BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  437.             Caption         =   "查询"
  438.             Key             =   "cx"
  439.             ImageKey        =   "cx"
  440.          EndProperty
  441.          BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  442.             Object.Visible         =   0   'False
  443.             Caption         =   "单据"
  444.             Key             =   "Bill"
  445.             ImageKey        =   "pz"
  446.          EndProperty
  447.          BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  448.             Object.Visible         =   0   'False
  449.             Style           =   3
  450.          EndProperty
  451.          BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  452.             Object.Visible         =   0   'False
  453.             Caption         =   "新增"
  454.             Key             =   "xz"
  455.             ImageKey        =   "xz"
  456.          EndProperty
  457.          BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  458.             Object.Visible         =   0   'False
  459.             Caption         =   "删除"
  460.             Key             =   "sc"
  461.             ImageKey        =   "sc"
  462.          EndProperty
  463.          BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  464.             Style           =   3
  465.          EndProperty
  466.          BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  467.             Caption         =   "帮助"
  468.             Key             =   "bz"
  469.             ImageKey        =   "bz"
  470.          EndProperty
  471.          BeginProperty Button12 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  472.             Caption         =   "退出"
  473.             Key             =   "fh"
  474.             ImageKey        =   "tc"
  475.          EndProperty
  476.       EndProperty
  477.       BorderStyle     =   1
  478.       Begin MSComctlLib.ImageList ImageList1 
  479.          Left            =   6990
  480.          Top             =   30
  481.          _ExtentX        =   1005
  482.          _ExtentY        =   1005
  483.          BackColor       =   -2147483643
  484.          ImageWidth      =   16
  485.          ImageHeight     =   16
  486.          MaskColor       =   12632256
  487.          _Version        =   393216
  488.          BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
  489.             NumListImages   =   34
  490.             BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  491.                Picture         =   "统计分析_供应商余额查询列表.frx":3E116
  492.                Key             =   "sz"
  493.             EndProperty
  494.             BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  495.                Picture         =   "统计分析_供应商余额查询列表.frx":3E4B0
  496.                Key             =   "dy"
  497.             EndProperty
  498.             BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  499.                Picture         =   "统计分析_供应商余额查询列表.frx":3E84A
  500.                Key             =   "yl"
  501.             EndProperty
  502.             BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  503.                Picture         =   "统计分析_供应商余额查询列表.frx":3EBE4
  504.                Key             =   "xg"
  505.             EndProperty
  506.             BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  507.                Picture         =   "统计分析_供应商余额查询列表.frx":3EF7E
  508.                Key             =   "zh"
  509.             EndProperty
  510.             BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  511.                Picture         =   "统计分析_供应商余额查询列表.frx":3F318
  512.                Key             =   "sh"
  513.             EndProperty
  514.             BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  515.                Picture         =   "统计分析_供应商余额查询列表.frx":3F6B2
  516.                Key             =   "bc"
  517.             EndProperty
  518.             BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  519.                Picture         =   "统计分析_供应商余额查询列表.frx":3FA4C
  520.                Key             =   "fq"
  521.             EndProperty
  522.             BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  523.                Picture         =   "统计分析_供应商余额查询列表.frx":3FDE6
  524.                Key             =   "bz"
  525.             EndProperty
  526.             BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  527.                Picture         =   "统计分析_供应商余额查询列表.frx":40180
  528.                Key             =   "tc"
  529.             EndProperty
  530.             BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  531.                Picture         =   "统计分析_供应商余额查询列表.frx":4051A
  532.                Key             =   "bcgs"
  533.             EndProperty
  534.             BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  535.                Picture         =   "统计分析_供应商余额查询列表.frx":408B4
  536.                Key             =   "mrlk"
  537.             EndProperty
  538.             BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  539.                Picture         =   "统计分析_供应商余额查询列表.frx":40C4E
  540.                Key             =   "xsxm"
  541.             EndProperty
  542.             BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  543.                Picture         =   "统计分析_供应商余额查询列表.frx":40FE8
  544.                Key             =   "first"
  545.             EndProperty
  546.             BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  547.                Picture         =   "统计分析_供应商余额查询列表.frx":41382
  548.                Key             =   "prev"
  549.             EndProperty
  550.             BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  551.                Picture         =   "统计分析_供应商余额查询列表.frx":4171C
  552.                Key             =   "next"
  553.             EndProperty
  554.             BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  555.                Picture         =   "统计分析_供应商余额查询列表.frx":41AB6
  556.                Key             =   "last"
  557.             EndProperty
  558.             BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  559.                Picture         =   "统计分析_供应商余额查询列表.frx":41E50
  560.                Key             =   "xx"
  561.             EndProperty
  562.             BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  563.                Picture         =   "统计分析_供应商余额查询列表.frx":421EA
  564.                Key             =   "define"
  565.             EndProperty
  566.             BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  567.                Picture         =   "统计分析_供应商余额查询列表.frx":42584
  568.                Key             =   "exec"
  569.             EndProperty
  570.             BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  571.                Picture         =   "统计分析_供应商余额查询列表.frx":4291E
  572.                Key             =   "xz"
  573.             EndProperty
  574.             BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  575.                Picture         =   "统计分析_供应商余额查询列表.frx":42CB8
  576.                Key             =   "sc"
  577.             EndProperty
  578.             BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  579.                Picture         =   "统计分析_供应商余额查询列表.frx":43052
  580.                Key             =   "sx"
  581.             EndProperty
  582.             BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  583.                Picture         =   "统计分析_供应商余额查询列表.frx":433EC
  584.                Key             =   "cx"
  585.             EndProperty
  586.             BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  587.                Picture         =   "统计分析_供应商余额查询列表.frx":43786
  588.                Key             =   "zd"
  589.             EndProperty
  590.             BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  591.                Picture         =   "统计分析_供应商余额查询列表.frx":43B20
  592.                Key             =   "dz"
  593.             EndProperty
  594.             BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  595.                Picture         =   "统计分析_供应商余额查询列表.frx":43EBA
  596.                Key             =   "ph"
  597.             EndProperty
  598.             BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  599.                Picture         =   "统计分析_供应商余额查询列表.frx":44254
  600.                Key             =   "fz"
  601.             EndProperty
  602.             BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  603.                Picture         =   "统计分析_供应商余额查询列表.frx":445EE
  604.                Key             =   "dw"
  605.             EndProperty
  606.             BeginProperty ListImage30 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  607.                Picture         =   "统计分析_供应商余额查询列表.frx":44988
  608.                Key             =   "hf"
  609.             EndProperty
  610.             BeginProperty ListImage31 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  611.                Picture         =   "统计分析_供应商余额查询列表.frx":44D22
  612.                Key             =   "pz"
  613.             EndProperty
  614.             BeginProperty ListImage32 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  615.                Picture         =   "统计分析_供应商余额查询列表.frx":450BC
  616.                Key             =   "check"
  617.             EndProperty
  618.             BeginProperty ListImage33 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  619.                Picture         =   "统计分析_供应商余额查询列表.frx":45456
  620.                Key             =   "AllCheck"
  621.             EndProperty
  622.             BeginProperty ListImage34 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  623.                Picture         =   "统计分析_供应商余额查询列表.frx":457F0
  624.                Key             =   "AllNoCheck"
  625.             EndProperty
  626.          EndProperty
  627.       End
  628.    End
  629. End
  630. Attribute VB_Name = "Report_FrmSuppList"
  631. Attribute VB_GlobalNameSpace = False
  632. Attribute VB_Creatable = False
  633. Attribute VB_PredeclaredId = True
  634. Attribute VB_Exposed = False
  635. '**************************************************************************
  636. '*    模 块 名 称 :供应商余额列表
  637. '*    功 能 描 述 :对每个会计期间的期初余额、本期应付、本期实付和期末余额按照供应商进行汇总显示
  638. '*    程序员姓名  :陈恩宇
  639. '*    最后修改人  :陈恩宇
  640. '*    最后修改时间:2001/12/13
  641. '*    备        注:程序中所有依实际情况自定义部分均用[>>  <<]括起
  642. '**************************************************************************
  643. Dim ReportTitle As String                '报表主标题
  644. Dim Str_QueryCondi As String             '用户录入查询条件
  645. Dim Rec_BillID As New ADODB.Recordset    '用户查询单据ID动态集
  647. '以下为固定使用变量
  648. Dim Dyymctbl As New DY_Dyymsz            '打印页面窗体变量
  649. Dim GridCode As String                   '显示网格网格代码
  650. Dim GridInf() As Variant                 '整个网格设置信息
  651. Dim Tsxx As String                       '系统提示信息
  652. Dim Qslz As Long                         '网格隐藏(非操作显示)列数
  653. Dim Sjhgd As Double                      '网格数据行高度
  654. Dim Sfxshjwg As Boolean                  '是否显示合计网格
  655. Dim GridBoolean() As Boolean             '网格列信息(布尔型)
  656. Dim GridStr()  As String                 '网格列信息(字符型)
  657. Dim GridInt() As Integer                 '网格列信息(整型)
  658. Dim Szzls As Integer                     '数组总列数(网格列数-1)
  660. Private Sub Form_Resize()                '根据窗体大小来调整网格,标题栏大小(Fixed)
  661.     
  662.     On Error Resume Next
  663.     
  664.     With CxbbGrid
  665.         .Width = Me.Width - 160
  666.         .Height = Me.Height - .Top - 400
  667.     End With
  668.     
  669.     With Pic_Title
  670.         .Width = Me.Width - 160
  671.     End With
  672.     
  673.     GsToolbar.Left = Me.Width - GsToolbar.Width - 140
  675. End Sub
  677. Private Sub Form_Load()                                                   '窗体装入
  678.   
  679.     '调入打印页面设置窗体
  680.     ReportTitle = "供应商余额表"
  681.     XtReportCode = "Ap_SuppBalanceList"
  682.     Load Dyymctbl
  683.   
  684.     '调整标题栏及网格、格式工具条位置(Fixed)
  685.     Pic_Title.Left = 40
  686.     Pic_Title.Top = SzToolbar.Top + SzToolbar.Height - 10
  687.     CxbbGrid.Left = Pic_Title.Left
  688.     CxbbGrid.Top = Pic_Title.Top + Pic_Title.Height + 20
  689.  
  690.     '调 入 网 格(Fixed)
  691.     GridCode = "Ap_SuppBalanceList"
  692.     Call BzWgcsh(CxbbGrid, GridCode, GridInf(), GridBoolean(), GridInt(), GridStr())
  693.   
  694.     Qslz = GridInf(1)
  695.     Sjhgd = GridInf(2)
  696.     Sfxshjwg = GridInf(7)
  697.     Szzls = CxbbGrid.Cols - 1
  699. End Sub
  701. Private Sub Form_Unload(Cancel As Integer)                                  '窗体卸载
  703.     '卸载条件窗体
  704.     Report_FrmSuppQuery.UnloadCheck.Value = 1
  705.     Unload Report_FrmSuppQuery
  706.     
  707.     '卸载打印页面设置窗体
  708.     Unload Dyymctbl
  710. End Sub
  712. Private Sub CxbbGrid_BeforeMoveColumn(ByVal Col As Long, Position As Long)           '网格列发生移动时自动交换网格索引信息
  713.     Call FnBln_RefreshArray(Col, Position, GridStr(), GridInf())
  714. End Sub
  716. Private Sub GsToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)       '网格格式调整(Fixed)
  717.     
  718.     Select Case Button.Key
  719.         Case "bcgs"                                          '保存表格格式
  720.             Call Bcwggs(CxbbGrid, GridCode, GridStr())
  721.         Case "hfmrgs"                                        '恢复默认格式
  722.             Call Hfmrgs(CxbbGrid, GridCode, GridStr())
  723.         Case "szxsxm"                                        '设置显示项目
  724.             Call Szxsxm(CxbbGrid, GridCode)
  725.     End Select
  727. End Sub
  729. Private Sub SzToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)
  730.     
  731.     Select Case Button.Key
  732.         Case "ymsz"                                          '页面设置
  733.             Dyymctbl.Show 1
  734.         Case "yl"                                            '预 览
  735.             Call bbyl(True)
  736.         Case "dy"                                            '打 印
  737.             Call bbyl(False)
  738.         Case "cx"                                            '查 询
  739.             Report_FrmSuppQuery.Show 1
  740.         Case "bz"                                            '帮 助
  741.             Call F1bz
  742.         Case "fh"                                            '退 出
  743.             Unload Me
  744.     End Select
  746. End Sub
  748. Private Sub Timer1_Timer()                                 '在窗体激活后调入查询程序
  749.     
  750.     Timer1.Enabled = False
  751.     Xt_Wait.Show
  752.     Xt_Wait.Refresh
  753.    
  754.     '加快显示速度
  755.     CxbbGrid.Redraw = False
  756.  
  757.     '生成查询结果
  758.     Call Sub_Query(0)
  759.    
  760.     CxbbGrid.Redraw = True
  761.     
  762.     Xt_Wait.Hide
  764. End Sub
  766. Private Sub Sub_Query(Int_QueryType As Integer)                                     '生成查询结果(Define)
  767.     
  768.     '过程参数:Int_QueryType 0-"点确定按钮"查询  1-"刷新"查询
  769.     Dim Rec_Query As New ADODB.Recordset        '查询结果动态集
  770.     Dim Coljsq As Long                          '网格列计数器
  771.     Dim Jsqte As Integer                        '临时动态计数器
  772.     Dim TempForCur As String                    '临时币别代码
  773.     Dim BanTotal(8) As Single                   '计算供应商余额合计
  775.     '以下为自定义部分[
  776.  
  777.     If Int_QueryType = 0 Then   '0-"点确定按钮"查询
  778.         With Report_FrmSuppQuery
  779.             
  780.             '填充表头部门内容
  781.             Report_FrmSuppList.Lab_Dept = "部门: " & .LrText(3).Text
  782.             Report_FrmSuppList.Lab_Person = "经办人: " & .LrText(4).Text
  783.             Report_FrmSuppList.Lab_Kjqj = "会计期间: " & .Cmb_Kjqj.Text
  784.             If Trim(.LrText(2).Text) <> "" Then
  785.                 Report_FrmSuppList.Lab_Foreign = "币别: " & .LrText(2).Text
  786.                 TempForCur = Trim(.LrText(2).Tag)
  787.             Else
  788.                 Report_FrmSuppList.Lab_Foreign = "币别: " & XtSCurrName
  789.                 TempForCur = XtSCurrCode
  790.             End If
  791.             
  792.             '生成查询条件
  793.             Str_QueryCondi = " where 1=1 and RPFlag = 'AP' "
  794.          
  795.             For Jsqte = 1 To 6
  796.                 Select Case Jsqte
  797.                     Case 1  '会计期间
  798.                         If Trim(.Cmb_Kjqj.Text) <> "" Then
  799.                             Str_QueryCondi = Str_QueryCondi & " and KjYear = " & Val(Mid(.Cmb_Kjqj.Text, 1, 4)) & " And Period = " & Val(Mid(.Cmb_Kjqj.Text, 6, 2))
  800.                         End If
  801.                     Case 2  '供应商(起)
  802.                         If Trim(.LrText(0).Text) <> "" Then
  803.                             Str_QueryCondi = Str_QueryCondi & " and PsCode >= '" & Trim(.LrText(0).Tag) & "'"
  804.                         End If
  805.                     Case 3  '供应商(止)
  806.                         If Trim(.LrText(1).Text) <> "" Then
  807.                             Str_QueryCondi = Str_QueryCondi & " and PsCode <= '" & Trim(.LrText(1).Tag) & "'"
  808.                         End If
  809.                     Case 4  '币别
  810.                         If Trim(.LrText(2).Text) <> "" Then
  811.                             Str_QueryCondi = Str_QueryCondi & " And ForeignCurrCode='" & Trim(.LrText(2).Tag) & "'"
  812.                         End If
  813.                     Case 5  '部门
  814.                         If Trim(.LrText(3).Text) <> "" Then
  815.                             Str_QueryCondi = Str_QueryCondi & " And DeptCode= '" & Trim(.LrText(3).Tag) & "'"
  816.                         End If
  817.                     Case 6 '经办人
  818.                         If Trim(.LrText(4).Text) <> "" Then
  819.                             Str_QueryCondi = Str_QueryCondi & " And PersonCode= '" & Trim(.LrText(4).Tag) & "'"
  820.                         End If
  821.                 
  822.                 End Select
  823.             Next Jsqte
  824.         End With
  825.     Else
  826.         '1-"刷新"查询
  827.     End If
  828.      
  829.     Sqlstr = "SELECT PsCode,SupplierName,Sum(YbNcye)YbNcye ,Sum(YbQcye)YbQcye,Sum(YbYsje)YbYsje,Sum(YbSsje)YbSsje, " & _
  830.              " Sum(YbQmye)YbQmye,Sum(BbNcye)BbNcye,Sum(BbQcye)BbQcye,Sum(BbYsje)BbYsje,Sum(BbSsje)BbSsje, " & _
  831.              " Sum(BbQmye)BbQmye FROM Ap_V_AccSumList " & Str_QueryCondi & " Group By PsCode,SupplierName Order By PsCode,SupplierName"
  833.     Set Rec_Query = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
  834.     With Rec_Query
  835.         CxbbGrid.Rows = CxbbGrid.FixedRows
  836.         Jsqte = CxbbGrid.FixedRows
  837.         Do While Not .EOF
  838.             CxbbGrid.AddItem ""
  839.             
  840.             '[>>自定义填充内容
  841.             CxbbGrid.TextMatrix(Jsqte, Sydz("001", GridStr(), Szzls)) = Trim(.Fields("PsCode") & "")             '供应商编码
  842.             CxbbGrid.TextMatrix(Jsqte, Sydz("002", GridStr(), Szzls)) = Trim(.Fields("SupplierName") & "")       '供应商名称
  843.             
  844.             '期初借贷(应付与应付方向相反)
  845.             Select Case Val(.Fields!BbQcye)                                                                      '借贷方向
  846.                 Case Is > 0
  847.                     CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = "贷"
  848.                 Case Is < 0
  849.                     CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = "借"
  850.                 Case Else
  851.                     CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = "平"
  852.             End Select
  853.             If Val(.Fields!BbQcye) <> 0 Then
  854.                 CxbbGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = Abs(Val(.Fields("BbQcye")))          '本币期初余额
  855.             End If
  856.             CxbbGrid.TextMatrix(Jsqte, Sydz("007", GridStr(), Szzls)) = Val(Val(.Fields("BbYsje")))              '本币应付金额
  857.             CxbbGrid.TextMatrix(Jsqte, Sydz("009", GridStr(), Szzls)) = Val(Val(.Fields("BbSsJe")))              '本币实付金额
  858.             
  859.             Select Case Val(.Fields!BbQmye)                                                                      '期末余额方向
  860.                 Case Is > 0
  861.                     CxbbGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls)) = "贷"
  862.                 Case Is < 0
  863.                     CxbbGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls)) = "借"
  864.                 Case Else
  865.                     CxbbGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls)) = "平"
  866.             End Select
  867.             
  868.             If Val(.Fields!BbQmye) <> 0 Then
  869.                 CxbbGrid.TextMatrix(Jsqte, Sydz("012", GridStr(), Szzls)) = Abs(Val(.Fields("BbQmye")))          '本币期末余额
  870.             End If
  871.             
  872.             If TempForCur <> XtSCurrCode Then
  873.                 If Val(.Fields!BbQcye) <> 0 Then
  874.                     CxbbGrid.TextMatrix(Jsqte, Sydz("004", GridStr(), Szzls)) = Abs(Val(.Fields("YbQcye")))      '原币期初余额
  875.                 End If
  876.                 CxbbGrid.TextMatrix(Jsqte, Sydz("006", GridStr(), Szzls)) = Val(Val(.Fields("YbYsje")))          '原币应付金额
  877.                 CxbbGrid.TextMatrix(Jsqte, Sydz("008", GridStr(), Szzls)) = Val(Val(.Fields("YbSsje")))          '原币实付金额
  878.                 If Val(.Fields!BbQmye) <> 0 Then
  879.                     CxbbGrid.TextMatrix(Jsqte, Sydz("011", GridStr(), Szzls)) = Abs(Val(.Fields("YbQmye")))      '原币期末余额
  880.                 End If
  881.             End If
  883.             '<<]
  884.             '计算供应商余额合计
  885.             BanTotal(1) = BanTotal(1) + .Fields("YbQcye")
  886.             BanTotal(2) = BanTotal(2) + .Fields("BbQcye")
  887.             BanTotal(3) = BanTotal(3) + .Fields("YbYsje")
  888.             BanTotal(4) = BanTotal(4) + .Fields("Bbysje")
  889.             BanTotal(5) = BanTotal(5) + .Fields("YbSsje")
  890.             BanTotal(6) = BanTotal(6) + .Fields("BbSsje")
  891.             BanTotal(7) = BanTotal(7) + .Fields("YbQmye")
  892.             BanTotal(8) = BanTotal(8) + .Fields("BbQmye")
  893.             '设置数据行高度(Fixed)
  894.             CxbbGrid.RowHeight(Jsqte) = Sjhgd
  895.             
  896.             '动态集指针加1,同时将计数器加1(Fixed)
  897.             .MoveNext
  898.             Jsqte = Jsqte + 1
  899.             
  900.             If .EOF Then
  901.                 CxbbGrid.AddItem ""
  902.                 CxbbGrid.RowHeight(Jsqte) = Sjhgd
  903.                 CxbbGrid.TextMatrix(Jsqte, Sydz("002", GridStr(), Szzls)) = "  合  计"
  904.                 If BanTotal(2) <> 0 Then            '期初余额方向(与应付方向相反)
  905.                     If BanTotal(2) > 0 Then
  906.                         CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = "贷"
  907.                     Else
  908.                         CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = "借"
  909.                     End If
  910.                 Else
  911.                     CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = "平"
  912.                 End If
  913.                 
  914.                 If BanTotal(1) <> 0 And TempForCur <> XtSCurrCode Then                                           '原币期初余额
  915.                     CxbbGrid.TextMatrix(Jsqte, Sydz("004", GridStr(), Szzls)) = Abs(BanTotal(1))
  916.                 End If
  917.                 If BanTotal(2) <> 0 Then                                                                         '本币期初余额
  918.                     CxbbGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = Abs(BanTotal(2))
  919.                 End If
  920.                 If TempForCur <> XtSCurrCode Then                                                                '原币本期应付
  921.                     CxbbGrid.TextMatrix(Jsqte, Sydz("006", GridStr(), Szzls)) = Val(BanTotal(3))
  922.                 End If
  923.                     
  924.                 CxbbGrid.TextMatrix(Jsqte, Sydz("007", GridStr(), Szzls)) = Val(BanTotal(4))                     '本币本期应付
  925.                 
  926.                 If TempForCur <> XtSCurrCode Then                                                                '原币本期实付
  927.                     CxbbGrid.TextMatrix(Jsqte, Sydz("008", GridStr(), Szzls)) = Val(BanTotal(5))
  928.                 End If
  929.                                                                         
  930.                 CxbbGrid.TextMatrix(Jsqte, Sydz("009", GridStr(), Szzls)) = Val(BanTotal(6))                     '本币本期实付
  931.                 
  932.                 If BanTotal(8) <> 0 Then                                                                         '期末余额方向
  933.                     If BanTotal(8) > 0 Then
  934.                         CxbbGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls)) = "贷"
  935.                     Else
  936.                         CxbbGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls)) = "借"
  937.                     End If
  938.                 Else
  939.                     CxbbGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls)) = "平"
  940.                 End If
  941.                 
  942.                 If BanTotal(7) <> 0 And TempForCur <> XtSCurrCode Then                                           '原币期末余额
  943.                     CxbbGrid.TextMatrix(Jsqte, Sydz("011", GridStr(), Szzls)) = Abs(BanTotal(7))
  944.                 End If
  945.                 If BanTotal(8) <> 0 Then                                                                         '本币期末余额
  946.                     CxbbGrid.TextMatrix(Jsqte, Sydz("012", GridStr(), Szzls)) = Abs(BanTotal(8))
  947.                 End If
  948.                 
  949.                  '合计清零
  950.                 For I = 1 To 8
  951.                     BanTotal(I) = 0
  952.                 Next I
  953.                 CxbbGrid.Cell(flexcpBackColor, Jsqte, 0, , CxbbGrid.Cols - 1) = "&H00F7F3EC"
  954.                 Jsqte = Jsqte + 1
  955.             End If
  956.         Loop
  957.         
  958.     End With
  960.     ']以上为用户自定义部分
  962. End Sub
  964. '[>>===================以下为根据实际业务需要自定义过程区域=============================<<]
  966. Private Sub bbyl(bbylte As Boolean)                    '报表打印预览
  967.     
  968.     Dim Bbzbt$, Bbxbt() As String, bbxbtzzxs() As Integer, Bbxbtgs As Integer
  969.     Dim Bbbwh() As String, Bbbwhzzxs() As Integer, Bbbwhgs As Integer
  970.     Bbxbtgs = 2                                          '报 表 小 标 题 行 数
  971.     Bbbwhgs = 0                                          '报 表 表 尾 行 数
  972.     
  973.     ReDim Bbxbt(1 To Bbxbtgs)
  974.     ReDim bbxbtzzxs(1 To Bbxbtgs)
  975.     If Bbbwhgs <> 0 Then
  976.         ReDim Bbbwh(1 To Bbbwhgs)
  977.         ReDim Bbbwhzzxs(1 To Bbbwhgs)
  978.     End If
  979.     
  980.     Bbzbt = ReportTitle
  981.     Bbxbt(1) = Space(2) + Fun_FormatOutPut(Lab_Dept, 25) + Fun_FormatOutPut(Lab_Person, 25) + Fun_FormatOutPut(Lab_Kjqj, 25) + Fun_FormatOutPut(Lab_Foreign, 25)
  982.     bbxbtzzxs(1) = 0                                     '报表行组织形式(0-居左 1-居中 2-居右)
  983.     Call Scyxsjb(CxbbGrid)                               '生成报表数据
  984.     Call Scdybb(Dyymctbl, Bbzbt, Bbxbt(), bbxbtzzxs(), Bbxbtgs, Bbbwh(), Bbbwhzzxs(), Bbbwhgs, bbylte)
  985.     If Not bbylte Then
  986.         Unload DY_Tybbyldy
  987.     End If
  989. End Sub