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

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

企业管理

开发平台：

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_FrmCusList 
  5.    Caption         =   "客户余额列表"
  6.    ClientHeight    =   8595
  7.    ClientLeft      =   315
  8.    ClientTop       =   390
  9.    ClientWidth     =   11820
  10.    HelpContextID   =   20803
  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_FrmCusList"
  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. '*    最后修改人  :陈恩宇
  641. '*    最后修改时间:2001/12/13
  642. '*    备        注:程序中所有依实际情况自定义部分均用[>>  <<]括起
  643. '**************************************************************************
  644. Dim ReportTitle As String                '报表主标题
  645. Dim Str_QueryCondi As String             '用户录入查询条件
  646. Dim Rec_BillID As New ADODB.Recordset    '用户查询单据ID动态集
  648. '以下为固定使用变量
  649. Dim Dyymctbl As New DY_Dyymsz            '打印页面窗体变量
  650. Dim GridCode As String                   '显示网格网格代码
  651. Dim GridInf() As Variant                 '整个网格设置信息
  652. Dim Tsxx As String                       '系统提示信息
  653. Dim Qslz As Long                         '网格隐藏(非操作显示)列数
  654. Dim Sjhgd As Double                      '网格数据行高度
  655. Dim Sfxshjwg As Boolean                  '是否显示合计网格
  656. Dim GridBoolean() As Boolean             '网格列信息(布尔型)
  657. Dim GridStr()  As String                 '网格列信息(字符型)
  658. Dim GridInt() As Integer                 '网格列信息(整型)
  659. Dim Szzls As Integer                     '数组总列数(网格列数-1)
  661. Private Sub Form_Resize()                '根据窗体大小来调整网格,标题栏大小(Fixed)
  662.     
  663.     On Error Resume Next
  664.     
  665.     With CxbbGrid
  666.         .Width = Me.Width - 160
  667.         .Height = Me.Height - .Top - 400
  668.     End With
  669.     
  670.     With Pic_Title
  671.         .Width = Me.Width - 160
  672.     End With
  673.     
  674.     GsToolbar.Left = Me.Width - GsToolbar.Width - 140
  676. End Sub
  678. Private Sub Form_Load()                                                   '窗体装入
  679.   
  680.     '调入打印页面设置窗体
  681.     ReportTitle = "客户余额列表"
  682.     XtReportCode = "Ar_CusBalanceList"
  683.     Load Dyymctbl
  684.   
  685.     '调整标题栏及网格、格式工具条位置(Fixed)
  686.     Pic_Title.Left = 40
  687.     Pic_Title.Top = SzToolbar.Top + SzToolbar.Height - 10
  688.     CxbbGrid.Left = Pic_Title.Left
  689.     CxbbGrid.Top = Pic_Title.Top + Pic_Title.Height + 20
  690.  
  691.     '调 入 网 格(Fixed)
  692.     GridCode = "Ar_CusBalanceList"
  693.     Call BzWgcsh(CxbbGrid, GridCode, GridInf(), GridBoolean(), GridInt(), GridStr())
  694.   
  695.     Qslz = GridInf(1)
  696.     Sjhgd = GridInf(2)
  697.     Sfxshjwg = GridInf(7)
  698.     Szzls = CxbbGrid.Cols - 1
  700. End Sub
  702. Private Sub Form_Unload(Cancel As Integer)                                  '窗体卸载
  704.     '卸载条件窗体
  705.     Report_FrmCusQuery.UnloadCheck.Value = 1
  706.     Unload Report_FrmCusQuery
  707.     
  708.     '卸载打印页面设置窗体
  709.     Unload Dyymctbl
  711. End Sub
  713. Private Sub CxbbGrid_BeforeMoveColumn(ByVal Col As Long, Position As Long)           '网格列发生移动时自动交换网格索引信息
  714.     Call FnBln_RefreshArray(Col, Position, GridStr(), GridInf())
  715. End Sub
  717. Private Sub GsToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)       '网格格式调整(Fixed)
  718.     
  719.     Select Case Button.Key
  720.         Case "bcgs"                                          '保存表格格式
  721.             Call Bcwggs(CxbbGrid, GridCode, GridStr())
  722.         Case "hfmrgs"                                        '恢复默认格式
  723.             Call Hfmrgs(CxbbGrid, GridCode, GridStr())
  724.         Case "szxsxm"                                        '设置显示项目
  725.             Call Szxsxm(CxbbGrid, GridCode)
  726.     End Select
  728. End Sub
  730. Private Sub SzToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)
  731.     
  732.     Select Case Button.Key
  733.         Case "ymsz"                                          '页面设置
  734.             Dyymctbl.Show 1
  735.         Case "yl"                                            '预 览
  736.             Call bbyl(True)
  737.         Case "dy"                                            '打 印
  738.             Call bbyl(False)
  739.         Case "cx"                                            '查 询
  740.             Report_FrmCusQuery.Show 1
  741.         Case "bz"                                            '帮 助
  742.             Call F1bz
  743.         Case "fh"                                            '退 出
  744.             Unload Me
  745.     End Select
  747. End Sub
  749. Private Sub Timer1_Timer()                                 '在窗体激活后调入查询程序
  750.     
  751.     Timer1.Enabled = False
  752.     Xt_Wait.Show
  753.     Xt_Wait.Refresh
  754.    
  755.     '加快显示速度
  756.     CxbbGrid.Redraw = False
  757.  
  758.     '生成查询结果
  759.     Call Sub_Query(0)
  760.    
  761.     CxbbGrid.Redraw = True
  762.     
  763.     Xt_Wait.Hide
  765. End Sub
  767. Private Sub Sub_Query(Int_QueryType As Integer)                                     '生成查询结果(Define)
  768.     
  769.     '过程参数:Int_QueryType 0-"点确定按钮"查询  1-"刷新"查询
  770.     Dim Rec_Query As New ADODB.Recordset        '查询结果动态集
  771.     Dim Coljsq As Long                          '网格列计数器
  772.     Dim jsqte As Integer                        '临时动态计数器
  773.     Dim TempForCur As String                    '临时币别代码
  774.     Dim BanTotal(8) As Single                   '计算客户余额合计
  776.     '以下为自定义部分[
  777.  
  778.     If Int_QueryType = 0 Then   '0-"点确定按钮"查询
  779.         With Report_FrmCusQuery
  780.             
  781.             '填充表头部门内容
  782.             Report_FrmCusList.Lab_Dept = "部门: " & .LrText(3).Text
  783.             Report_FrmCusList.Lab_Person = "经办人: " & .LrText(4).Text
  784.             Report_FrmCusList.Lab_Kjqj = "会计期间: " & .Cmb_Kjqj.Text
  785.             If Trim(.LrText(2).Text) <> "" Then
  786.                 Report_FrmCusList.Lab_Foreign = "币别: " & .LrText(2).Text
  787.                 TempForCur = Trim(.LrText(2).Tag)
  788.             Else
  789.                 Report_FrmCusList.Lab_Foreign = "币别: " & XtSCurrName
  790.                 TempForCur = XtSCurrCode
  791.             End If
  792.             
  793.             '生成查询条件
  794.             Str_QueryCondi = " where 1=1 and RPFlag = 'AR' "
  795.          
  796.             For jsqte = 1 To 6
  797.                 Select Case jsqte
  798.                     Case 1  '会计期间
  799.                         If Trim(.Cmb_Kjqj.Text) <> "" Then
  800.                             Str_QueryCondi = Str_QueryCondi & " and KjYear = " & Val(Mid(.Cmb_Kjqj.Text, 1, 4)) & " And Period = " & Val(Mid(.Cmb_Kjqj.Text, 6, 2))
  801.                         End If
  802.                     Case 2  '客户(起)
  803.                         If Trim(.LrText(0).Text) <> "" Then
  804.                             Str_QueryCondi = Str_QueryCondi & " and PsCode >= '" & Trim(.LrText(0).Tag) & "'"
  805.                         End If
  806.                     Case 3  '客户(止)
  807.                         If Trim(.LrText(1).Text) <> "" Then
  808.                             Str_QueryCondi = Str_QueryCondi & " and PsCode <= '" & Trim(.LrText(1).Tag) & "'"
  809.                         End If
  810.                     Case 4  '币别
  811.                         If Trim(.LrText(2).Text) <> "" Then
  812.                             Str_QueryCondi = Str_QueryCondi & " And ForeignCurrCode='" & Trim(.LrText(2).Tag) & "'"
  813.                         End If
  814.                     Case 5  '部门
  815.                         If Trim(.LrText(3).Text) <> "" Then
  816.                             Str_QueryCondi = Str_QueryCondi & " And DeptCode= '" & Trim(.LrText(3).Tag) & "'"
  817.                         End If
  818.                     Case 6 '经办人
  819.                         If Trim(.LrText(4).Text) <> "" Then
  820.                             Str_QueryCondi = Str_QueryCondi & " And PersonCode= '" & Trim(.LrText(4).Tag) & "'"
  821.                         End If
  822.                 
  823.                 End Select
  824.             Next jsqte
  825.         End With
  826.     Else
  827.         '1-"刷新"查询
  828.         If Str_QueryCondi = "" Then
  829.             Str_QueryCondi = " where 1=2 "
  830.         End If
  831.     End If
  832.      
  833.     Sqlstr = "SELECT PsCode,CusName,Sum(YbNcye)YbNcye ,Sum(YbQcye)YbQcye,Sum(YbYsje)YbYsje,Sum(YbSsje)YbSsje, " & _
  834.              " Sum(YbQmye)YbQmye,Sum(BbNcye)BbNcye,Sum(BbQcye)BbQcye,Sum(BbYsje)BbYsje,Sum(BbSsje)BbSsje, " & _
  835.              " Sum(BbQmye)BbQmye FROM Ar_v_CurBalanceList " & Str_QueryCondi & " Group By PsCode,CusName Order By PsCode,CusName"
  837.     Set Rec_Query = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
  838.     With Rec_Query
  839.         CxbbGrid.Rows = CxbbGrid.FixedRows
  840.         jsqte = CxbbGrid.FixedRows
  841.         Do While Not .EOF
  842.             CxbbGrid.AddItem ""
  843.             
  844.             '[>>自定义填充内容
  845.             CxbbGrid.TextMatrix(jsqte, Sydz("001", GridStr(), Szzls)) = Trim(.Fields("PsCode") & "")             '客户编码
  846.             CxbbGrid.TextMatrix(jsqte, Sydz("002", GridStr(), Szzls)) = Trim(.Fields("CusName") & "")            '客户名称
  847.             
  848.             '期初借贷方向
  849.             Select Case Val(.Fields!BbQcye)
  850.                 Case Is < 0
  851.                     CxbbGrid.TextMatrix(jsqte, Sydz("003", GridStr(), Szzls)) = "贷"
  852.                 Case Is > 0
  853.                     CxbbGrid.TextMatrix(jsqte, Sydz("003", GridStr(), Szzls)) = "借"
  854.                 Case Else
  855.                     CxbbGrid.TextMatrix(jsqte, Sydz("003", GridStr(), Szzls)) = "平"
  856.             End Select
  857.             If Val(.Fields!BbQcye) <> 0 Then
  858.                 CxbbGrid.TextMatrix(jsqte, Sydz("005", GridStr(), Szzls)) = Abs(Val(.Fields("BbQcye")))          '本币期初余额
  859.             End If
  860.             CxbbGrid.TextMatrix(jsqte, Sydz("007", GridStr(), Szzls)) = Val(Val(.Fields("BbYsje")))              '本币应收金额
  861.             CxbbGrid.TextMatrix(jsqte, Sydz("009", GridStr(), Szzls)) = Val(Val(.Fields("BbSsJe")))              '本币实收金额
  862.             
  863.             '期末借贷方向
  864.             Select Case Val(.Fields!BbQmye)
  865.                 Case Is < 0
  866.                     CxbbGrid.TextMatrix(jsqte, Sydz("010", GridStr(), Szzls)) = "贷"
  867.                 Case Is > 0
  868.                     CxbbGrid.TextMatrix(jsqte, Sydz("010", GridStr(), Szzls)) = "借"
  869.                 Case Else
  870.                     CxbbGrid.TextMatrix(jsqte, Sydz("010", GridStr(), Szzls)) = "平"
  871.             End Select
  872.             
  873.             If Val(.Fields!BbQmye) <> 0 Then
  874.                 CxbbGrid.TextMatrix(jsqte, Sydz("012", GridStr(), Szzls)) = Abs(Val(.Fields("BbQmye")))          '本币期末余额
  875.             End If
  876.             
  877.             If TempForCur <> XtSCurrCode Then
  878.                 If Val(.Fields!BbQcye) <> 0 Then
  879.                     CxbbGrid.TextMatrix(jsqte, Sydz("004", GridStr(), Szzls)) = Abs(Val(.Fields("YbQcye")))      '原币期初余额
  880.                 End If
  881.                 CxbbGrid.TextMatrix(jsqte, Sydz("006", GridStr(), Szzls)) = Val(Val(.Fields("YbYsje")))          '原币应收金额
  882.                 CxbbGrid.TextMatrix(jsqte, Sydz("008", GridStr(), Szzls)) = Val(Val(.Fields("YbSsje")))          '原币实收金额
  883.                 If Val(.Fields!BbQmye) <> 0 Then
  884.                     CxbbGrid.TextMatrix(jsqte, Sydz("011", GridStr(), Szzls)) = Abs(Val(.Fields("YbQmye")))      '原币期末余额
  885.                 End If
  886.             End If
  888.             '<<]
  889.             '计算客户余额合计
  890.             BanTotal(1) = BanTotal(1) + .Fields("YbQcye")   '原币期初余额合计
  891.             BanTotal(2) = BanTotal(2) + .Fields("BbQcye")   '本币期初余额合计
  892.             BanTotal(3) = BanTotal(3) + .Fields("YbYsje")   '原币应收金额合计
  893.             BanTotal(4) = BanTotal(4) + .Fields("Bbysje")   '本币应收金额合计
  894.             BanTotal(5) = BanTotal(5) + .Fields("YbSsje")   '原币实收金额合计
  895.             BanTotal(6) = BanTotal(6) + .Fields("BbSsje")   '本币实收金额合计
  896.             BanTotal(7) = BanTotal(7) + .Fields("YbQmye")   '原币期末余额合计
  897.             BanTotal(8) = BanTotal(8) + .Fields("BbQmye")   '原币期末余额合计
  898.             
  899.             '设置数据行高度(Fixed)
  900.             CxbbGrid.RowHeight(jsqte) = Sjhgd
  901.             
  902.             '动态集指针加1,同时将计数器加1(Fixed)
  903.             .MoveNext
  904.             jsqte = jsqte + 1
  905.             
  906.             If .EOF Then
  907.                 CxbbGrid.AddItem ""
  908.                 CxbbGrid.RowHeight(jsqte) = Sjhgd
  909.                 CxbbGrid.TextMatrix(jsqte, Sydz("002", GridStr(), Szzls)) = "  合  计"              '摘要
  910.                 If BanTotal(2) <> 0 Then
  911.                     If BanTotal(2) < 0 Then                                                         '借贷方向
  912.                         CxbbGrid.TextMatrix(jsqte, Sydz("003", GridStr(), Szzls)) = "贷"
  913.                     Else
  914.                         CxbbGrid.TextMatrix(jsqte, Sydz("003", GridStr(), Szzls)) = "借"
  915.                     End If
  916.                 Else
  917.                     CxbbGrid.TextMatrix(jsqte, Sydz("003", GridStr(), Szzls)) = "平"
  918.                 End If
  919.                 If BanTotal(1) <> 0 And TempForCur <> XtSCurrCode Then                              '原币期初余额
  920.                     CxbbGrid.TextMatrix(jsqte, Sydz("004", GridStr(), Szzls)) = Abs(BanTotal(1))
  921.                 End If
  922.                 If BanTotal(2) <> 0 Then                                                            '本币期初余额
  923.                     CxbbGrid.TextMatrix(jsqte, Sydz("005", GridStr(), Szzls)) = Abs(BanTotal(2))
  924.                 End If
  925.                 If TempForCur <> XtSCurrCode Then                                                   '原币本期应收
  926.                     CxbbGrid.TextMatrix(jsqte, Sydz("006", GridStr(), Szzls)) = Val(BanTotal(3))
  927.                 End If
  928.                 CxbbGrid.TextMatrix(jsqte, Sydz("007", GridStr(), Szzls)) = Val(BanTotal(4))        '本币本期应收
  929.                 If TempForCur <> XtSCurrCode Then                                                   '原币本期实收
  930.                     CxbbGrid.TextMatrix(jsqte, Sydz("008", GridStr(), Szzls)) = Val(BanTotal(5))
  931.                 End If
  932.                 CxbbGrid.TextMatrix(jsqte, Sydz("009", GridStr(), Szzls)) = Val(BanTotal(6))        '本币本期实收
  933.                 If BanTotal(8) <> 0 Then
  934.                     If BanTotal(8) < 0 Then                                                         '借贷方向
  935.                         CxbbGrid.TextMatrix(jsqte, Sydz("010", GridStr(), Szzls)) = "贷"
  936.                     Else
  937.                         CxbbGrid.TextMatrix(jsqte, Sydz("010", GridStr(), Szzls)) = "借"
  938.                     End If
  939.                 Else
  940.                     CxbbGrid.TextMatrix(jsqte, Sydz("010", GridStr(), Szzls)) = "平"
  941.                 End If
  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.                 
  954.                 '设置合计行颜色
  955.                 CxbbGrid.Cell(flexcpBackColor, jsqte, 0, , CxbbGrid.Cols - 1) = "&H00F7F3EC"
  956.                 jsqte = jsqte + 1
  957.             End If
  958.         Loop
  959.         
  960.     End With
  962.     ']以上为用户自定义部分
  964. End Sub
  966. '[>>===================以下为根据实际业务需要自定义过程区域=============================<<]
  968. Private Sub bbyl(bbylte As Boolean)                    '报表打印预览
  969.     
  970.     Dim Bbzbt$, Bbxbt() As String, bbxbtzzxs() As Integer, Bbxbtgs As Integer
  971.     Dim Bbbwh() As String, Bbbwhzzxs() As Integer, Bbbwhgs As Integer
  972.     Bbxbtgs = 2                                          '报 表 小 标 题 行 数
  973.     Bbbwhgs = 0                                          '报 表 表 尾 行 数
  974.     
  975.     ReDim Bbxbt(1 To Bbxbtgs)
  976.     ReDim bbxbtzzxs(1 To Bbxbtgs)
  977.     If Bbbwhgs <> 0 Then
  978.         ReDim Bbbwh(1 To Bbbwhgs)
  979.         ReDim Bbbwhzzxs(1 To Bbbwhgs)
  980.     End If
  981.     
  982.     Bbzbt = ReportTitle
  983.     Bbxbt(1) = Space(2) + Fun_FormatOutPut(Lab_Dept, 25) + Fun_FormatOutPut(Lab_Person, 25) + Fun_FormatOutPut(Lab_Kjqj, 25) + Fun_FormatOutPut(Lab_Foreign, 25)
  984.     bbxbtzzxs(1) = 0                                     '报表行组织形式(0-居左 1-居中 2-居右)
  985.     Call Scyxsjb(CxbbGrid)                               '生成报表数据
  986.     Call Scdybb(Dyymctbl, Bbzbt, Bbxbt(), bbxbtzzxs(), Bbxbtgs, Bbbwh(), Bbbwhzzxs(), Bbbwhgs, bbylte)
  987.     If Not bbylte Then
  988.         Unload DY_Tybbyldy
  989.     End If
  991. End Sub