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

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

企业管理

开发平台：

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_FrmAccAgeList 
  5.    Caption         =   "账龄分析表"
  6.    ClientHeight    =   8595
  7.    ClientLeft      =   315
  8.    ClientTop       =   390
  9.    ClientWidth     =   11820
  10.    HelpContextID   =   20804
  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            =   9210
  21.       TabIndex        =   3
  22.       Top             =   30
  23.       Width           =   2595
  24.       _ExtentX        =   4577
  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_Date 
  61.          AutoSize        =   -1  'True
  62.          BackStyle       =   0  'Transparent
  63.          Caption         =   "截止日期:"
  64.          Height          =   180
  65.          Left            =   8820
  66.          TabIndex        =   8
  67.          Top             =   780
  68.          Width           =   810
  69.       End
  70.       Begin VB.Label Lab_Foreign 
  71.          AutoSize        =   -1  'True
  72.          BackStyle       =   0  'Transparent
  73.          Caption         =   "币别:"
  74.          Height          =   180
  75.          Left            =   6040
  76.          TabIndex        =   7
  77.          Top             =   780
  78.          Width           =   450
  79.       End
  80.       Begin VB.Label Lab_Person 
  81.          AutoSize        =   -1  'True
  82.          BackStyle       =   0  'Transparent
  83.          Caption         =   "经办人:"
  84.          Height          =   180
  85.          Left            =   3080
  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           =   1275
  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            =   0
  132.       TabIndex        =   0
  133.       Top             =   1680
  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_FrmAccAgeList"
  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/29
  641. '*    备        注:程序中所有依实际情况自定义部分均用[>>  <<]括起
  642. '**************************************************************************
  643. Dim ReportTitle As String                '报表主标题
  644. Dim Str_QueryCondi As String             '用户录入查询条件
  645. Dim Rec_BillID As New ADODB.Recordset    '用户查询单据ID动态集
  646. Dim FillCol As Integer                   '填充网格列
  647. Dim AccAge() As Single                   '账龄区间对应的最长值
  648. Dim BeginCol As Integer                  '填充起始列值
  650. '以下为固定使用变量
  651. Dim Dyymctbl As New DY_Dyymsz            '打印页面窗体变量
  652. Dim GridCode As String                   '显示网格网格代码
  653. Dim GridInf() As Variant                 '整个网格设置信息
  654. Dim Tsxx As String                       '系统提示信息
  655. Dim Qslz As Long                         '网格隐藏(非操作显示)列数
  656. Dim Sjhgd As Double                      '网格数据行高度
  657. Dim Sfxshjwg As Boolean                  '是否显示合计网格
  658. Dim GridBoolean() As Boolean             '网格列信息(布尔型)
  659. Dim GridStr()  As String                 '网格列信息(字符型)
  660. Dim GridInt() As Integer                 '网格列信息(整型)
  661. Dim Szzls As Integer                     '数组总列数(网格列数-1)
  663. Private Sub Form_Resize()                '根据窗体大小来调整网格,标题栏大小(Fixed)
  664.     
  665.     On Error Resume Next
  666.     
  667.     With CxbbGrid
  668.         .Width = Me.Width - 160
  669.         .Height = Me.Height - .Top - 400
  670.     End With
  671.     
  672.     With Pic_Title
  673.         .Width = Me.Width - 160
  674.     End With
  675.     
  676.     GsToolbar.Left = Me.Width - GsToolbar.Width - 140
  678. End Sub
  680. Private Sub Form_Load()                                                   '窗体装入
  681.   
  682.     '调入打印页面设置窗体
  683.     ReportTitle = "账龄分析表"
  684.     XtReportCode = "Ar_AccAgeAnalyse"
  685.     Load Dyymctbl
  686.   
  687.     '调整标题栏及网格、格式工具条位置(Fixed)
  688.     Pic_Title.Left = 40
  689.     Pic_Title.Top = SzToolbar.Top + SzToolbar.Height - 10
  690.     CxbbGrid.Left = Pic_Title.Left
  691.     CxbbGrid.Top = Pic_Title.Top + Pic_Title.Height + 20
  692.  
  693.     '调 入 网 格(Fixed)
  694.     GridCode = "Ar_AccAgeAnalyse"
  695.     Call BzWgcsh(CxbbGrid, GridCode, GridInf(), GridBoolean(), GridInt(), GridStr())
  696.   
  697.     Qslz = GridInf(1)
  698.     Sjhgd = GridInf(2)
  699.     Sfxshjwg = GridInf(7)
  700.     Szzls = CxbbGrid.Cols - 1
  702. End Sub
  704. Private Sub Form_Unload(Cancel As Integer)                                  '窗体卸载
  706.     '卸载条件窗体
  707.     Report_FrmAccAgeQuery.UnloadCheck.Value = 1
  708.     Unload Report_FrmAccAgeQuery
  709.     
  710.     '卸载打印页面设置窗体
  711.     Unload Dyymctbl
  713. End Sub
  715. Private Sub CxbbGrid_BeforeMoveColumn(ByVal Col As Long, Position As Long)           '网格列发生移动时自动交换网格索引信息
  716.     Call FnBln_RefreshArray(Col, Position, GridStr(), GridInf())
  717. End Sub
  719. Private Sub GsToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)       '网格格式调整(Fixed)
  720.     
  721.     Select Case Button.Key
  722.         Case "bcgs"                                          '保存表格格式
  723.             Call Bcwggs(CxbbGrid, GridCode, GridStr())
  724.         Case "hfmrgs"                                        '恢复默认格式
  725.             Call Hfmrgs(CxbbGrid, GridCode, GridStr())
  726.         Case "szxsxm"                                        '设置显示项目
  727.             Call Szxsxm(CxbbGrid, GridCode)
  728.     End Select
  730. End Sub
  732. Private Sub SzToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)
  733.     
  734.     Select Case Button.Key
  735.         Case "ymsz"                                          '页面设置
  736.             Dyymctbl.Show 1
  737.         Case "yl"                                            '预 览
  738.             Call bbyl(True)
  739.         Case "dy"                                            '打 印
  740.             Call bbyl(False)
  741.         Case "cx"                                            '查 询
  742.             Report_FrmAccAgeQuery.Show 1
  743.         Case "bz"                                            '帮 助
  744.             Call F1bz
  745.         Case "fh"                                            '退 出
  746.             Unload Me
  747.     End Select
  749. End Sub
  751. Private Sub Timer1_Timer()                                 '在窗体激活后调入查询程序
  752.     
  753.     Timer1.Enabled = False
  754.     Xt_Wait.Show
  755.     Xt_Wait.Refresh
  756.    
  757.     '加快显示速度
  758.     CxbbGrid.Redraw = False
  759.  
  760.     '生成查询结果
  761.     Call Sub_Query(0)
  762.    
  763.     CxbbGrid.Redraw = True
  764.     
  765.     Xt_Wait.Hide
  767. End Sub
  769. Private Sub Sub_Query(Int_QueryType As Integer)                                     '生成查询结果(Define)
  770.     
  771.     '过程参数:Int_QueryType 0-"点确定按钮"查询  1-"刷新"查询
  772.     Dim Rec_Query As New ADODB.Recordset        '查询结果动态集
  773.     Dim Coljsq As Long                          '网格列计数器
  774.     Dim jsqte As Integer                        '临时动态计数器
  775.     Dim TempForCur As String                    '临时币别代码
  776.     Dim Str_FillGrid As String                  '填充网格数据
  777.     Dim TotalYe As Double                       '汇总余额
  778.     Dim TmpJsq As Integer                       '临时计数器
  779.     Dim Rec_Temp As New ADODB.Recordset         '过期数值查询结果动态集
  780.     Dim Str_Bill As String                      '存储过程代码
  781.     Dim GqTotal() As Double                     '过期数组
  782.     Dim Str_Foreign As String                   '币别编码
  783.     Dim Str_Department As String                '部门编码
  784.     Dim Str_Person As String                    '经办人编码
  785.     Dim Str_Date As Date                        '截止日期
  787.     
  788.     '填充网格表头内容
  789.     Str_FillGrid = "Select MinBillAge,MaxBillAge,REPLACE (BEDays,'过期','')BEDays From RP_BillAge Where RPFlag='Ar' Order by MinBillAge "
  790.     Call Sub_FillGrid(Str_FillGrid)
  791.     
  792.     '如果没有设置帐龄区间,则不能进行帐龄区间的统计
  793.     If FillCol < 1 Then
  794.         Tsxx = "请在基础设置中设置帐龄区间后查询!"
  795.         Call Xtxxts(Tsxx, 0, 4)
  796.         Exit Sub
  797.     End If
  798.    
  799.     '定义过期数组
  800.     ReDim GqTotal(FillCol) As Double
  802.     '以下为自定义部分[
  803.  
  804.     If Int_QueryType = 0 Then   '0-"点确定按钮"查询
  805.         With Report_FrmAccAgeQuery
  806.             
  807.             '填充表头部分内容
  808.             Report_FrmAccAgeList.Lab_Dept = "部门: " & .LrText(4).Text
  809.             Report_FrmAccAgeList.Lab_Person = "经办人: " & .LrText(5).Text
  810.             Report_FrmAccAgeList.Lab_Date = "截止日期: " & .LrText(0).Text
  811.             If Trim(.LrText(3).Text) <> "" Then
  812.                 Report_FrmAccAgeList.Lab_Foreign = "币别: " & .LrText(3).Text
  813.                 TempForCur = Trim(.LrText(3).Tag)
  814.             Else
  815.                 Report_FrmAccAgeList.Lab_Foreign = "币别: " & XtSCurrName
  816.                 TempForCur = XtSCurrCode
  817.             End If
  818.             
  819.             Str_Date = CDate(.LrText(0).Text)
  820.             Str_Foreign = Trim(.LrText(3).Tag & "")
  821.             Str_Department = Trim(.LrText(4).Tag & "")
  822.             Str_Person = Trim(.LrText(5).Tag & "")
  823.             
  824.             '生成查询条件
  825.             Str_QueryCondi = " where 1=1 and RPFlag = 'AR' and OverStatus=0 and BillItemCode in (20,21,11,10) and (StartFlag=0 or (startFlag=1 and Checker<>''))"
  826.          
  827.             For jsqte = 1 To 6
  828.                 Select Case jsqte
  829.                     Case 1  '截止日期
  830.                         If Trim(.LrText(0).Text) <> "" Then
  831.                             Str_QueryCondi = Str_QueryCondi & " and BillDate <= '" & CDate(.LrText(0).Text) & "'"
  832.                         End If
  833.                     Case 2  '客户(起)
  834.                         If Trim(.LrText(1).Text) <> "" Then
  835.                             Str_QueryCondi = Str_QueryCondi & " and PsCode >= '" & Trim(.LrText(1).Tag) & "'"
  836.                         End If
  837.                     Case 3  '客户(止)
  838.                         If Trim(.LrText(2).Text) <> "" Then
  839.                             Str_QueryCondi = Str_QueryCondi & " and PsCode <= '" & Trim(.LrText(2).Tag) & "'"
  840.                         End If
  841.                     Case 4  '币别
  842.                         If Trim(.LrText(3).Text) <> "" Then
  843.                             Str_QueryCondi = Str_QueryCondi & " And ForeignCurrCode='" & Trim(.LrText(3).Tag) & "'"
  844.                         End If
  845.                     Case 5  '部门
  846.                         If Trim(.LrText(4).Text) <> "" Then
  847.                             Str_QueryCondi = Str_QueryCondi & " And DeptCode= '" & Trim(.LrText(4).Tag) & "'"
  848.                         End If
  849.                     Case 6 '经办人
  850.                         If Trim(.LrText(5).Text) <> "" Then
  851.                             Str_QueryCondi = Str_QueryCondi & " And PersonCode= '" & Trim(.LrText(5).Tag) & "'"
  852.                         End If
  853.                 
  854.                 End Select
  855.             
  856.             Next jsqte
  857.             
  858.         End With
  859.     Else
  860.         '1-"刷新"查询
  861.     End If
  862.      
  863.     Sqlstr = "SELECT PsCode,CusName,Sum(YbYsje)YbYsje ,Sum(BbYsje)BbYsje,Sum(YbCancelje)YbCancelje,Sum(BbCancelje)BbCancelje " & _
  864.              " FROM Ar_v_AccMxList " & Str_QueryCondi & " Group By PsCode,CusName Order By PsCode"
  866.     Set Rec_Query = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
  867.     With Rec_Query
  868.         CxbbGrid.Rows = CxbbGrid.FixedRows
  869.         jsqte = CxbbGrid.FixedRows
  870.         Do While Not .EOF
  871.             CxbbGrid.AddItem ""
  872.             
  873.             '[>>自定义填充内容
  874.             CxbbGrid.TextMatrix(jsqte, Sydz("001", GridStr(), Szzls)) = Trim(.Fields("PsCode") & "")                            '客户编码
  875.             CxbbGrid.TextMatrix(jsqte, Sydz("002", GridStr(), Szzls)) = Trim(.Fields("CusName") & "")                           '客户名称
  876.             If Str_Foreign <> "" Then
  877.                 If Val(.Fields("YbYsje")) <> Val(.Fields("YbCancelje")) Then
  878.                     CxbbGrid.TextMatrix(jsqte, Sydz("003", GridStr(), Szzls)) = Val(.Fields("YbYsje")) - Val(.Fields("YbCancelje"))  '原币应付金额
  879.                 End If
  880.             Else
  881.                 If Val(.Fields("BbYsje")) <> Val(.Fields("BbCancelje")) Then
  882.                     CxbbGrid.TextMatrix(jsqte, Sydz("003", GridStr(), Szzls)) = Val(.Fields("BbYsje")) - Val(.Fields("BbCancelje"))  '本币应付金额
  883.                 End If
  884.             End If
  885.                
  886.                 '调用存储过程填充过期数值
  887.                 For TmpJsq = 0 To FillCol
  888.                  
  889.                     If TmpJsq <> FillCol Then
  890.                         Str_Bill = "Ar_Sp_AccAgeAnalyse '" & Rec_Query!PsCode & "' ,'" & Str_Foreign & "','" & Str_Department & "','" & Str_Person & "','" & AccAge(TmpJsq) & "','" & AccAge(TmpJsq + 1) & "','" & Str_Date & "'"
  891.                     Else
  892.                         Str_Bill = "Ar_Sp_AccAgeAnalyse '" & Rec_Query!PsCode & "' ,'" & Str_Foreign & "','" & Str_Department & "','" & Str_Person & "','" & AccAge(TmpJsq) & "','" & -1 & "','" & Str_Date & "'"
  893.                     End If
  894.                     
  895.                     Set Rec_Temp = Cw_DataEnvi.DataConnect.Execute(Str_Bill)
  896.                     If Not Rec_Temp.EOF Then
  897.                         With CxbbGrid
  898.                             If Str_Foreign <> "" Then
  899.                                 If Val((Rec_Temp!GqNumberYb) & "") <> 0 Then
  900.                                     .TextMatrix(jsqte, TmpJsq + 4) = Format(Val((Rec_Temp!GqNumberYb) & ""), "#,##0.00")            '过期金额
  901.                                 End If
  902.                                 GqTotal(TmpJsq) = GqTotal(TmpJsq) + Val(Rec_Temp!GqNumberYb & "")
  903.                             Else
  904.                                 If Val((Rec_Temp!GqNumber) & "") <> 0 Then
  905.                                     .TextMatrix(jsqte, TmpJsq + 4) = Format(Val((Rec_Temp!GqNumber) & ""), "#,##0.00")              '过期金额
  906.                                 End If
  907.                                 GqTotal(TmpJsq) = GqTotal(TmpJsq) + Val(Rec_Temp!GqNumber & "")
  908.                             End If
  909.                             
  910.                         End With
  911.                     End If
  912.     
  913.                 Next TmpJsq
  914.             '<<]
  915.             
  916.             '重新汇总客户余额
  917.             If Str_Foreign <> "" Then
  918.                 TotalYe = TotalYe + .Fields("YbYsje") - .Fields("YbCancelje")
  919.             Else
  920.                 TotalYe = TotalYe + .Fields("BbYsje") - .Fields("BbCancelje")
  921.             End If
  922.             
  923.             '设置数据行高度(Fixed)
  924.             CxbbGrid.RowHeight(jsqte) = Sjhgd
  926.             '动态集指针加1,同时将计数器加1(Fixed)
  927.             .MoveNext
  928.             jsqte = jsqte + 1
  929.             
  930.             If .EOF Then
  931.                 '填充合计金额
  932.                 CxbbGrid.AddItem ""
  933.                 CxbbGrid.RowHeight(jsqte) = Sjhgd
  934.                 CxbbGrid.TextMatrix(jsqte, Sydz("002", GridStr(), Szzls)) = "  合  计"              '摘要
  935.                 CxbbGrid.TextMatrix(jsqte, Sydz("003", GridStr(), Szzls)) = TotalYe                 '填充余额合计
  936.                 
  937.                 '填充过期合计数
  938.                 For TmpJsq = 0 To FillCol                                                           '填充过期余额合计
  939.                     CxbbGrid.TextMatrix(jsqte, TmpJsq + 4) = Format(GqTotal(TmpJsq), "#,##0.00")
  940.                 Next TmpJsq
  941.                 
  942.                 '设置合计行颜色
  943.                 CxbbGrid.Cell(flexcpBackColor, jsqte, 0, , CxbbGrid.Cols - 1) = "&H00F7F3EC"
  944.                 jsqte = jsqte + 1
  945.                 
  946.                 '填充占总金额比例
  947.                 CxbbGrid.AddItem ""
  948.                 CxbbGrid.RowHeight(jsqte) = Sjhgd
  949.                 CxbbGrid.TextMatrix(jsqte, Sydz("002", GridStr(), Szzls)) = "  占总额(%)"           '摘要
  950.                 CxbbGrid.TextMatrix(jsqte, Sydz("003", GridStr(), Szzls)) = "100"                   '余额百分比
  951.                 
  952.                 If TotalYe <> 0 Then
  953.                     For TmpJsq = 0 To FillCol                                                       '填充过期余额百分比
  954.                         CxbbGrid.TextMatrix(jsqte, TmpJsq + 4) = Format(GqTotal(TmpJsq) / TotalYe * 100, "#,##0.00")
  955.                     Next TmpJsq
  956.                 End If
  957.                 
  958.                 '设置余额百分比记录行颜色
  959.                 CxbbGrid.Cell(flexcpBackColor, jsqte, 0, , CxbbGrid.Cols - 1) = "&H00C0E0FF"
  960.                 
  961.             End If
  962.         Loop
  963.         
  964.     End With
  966.     ']以上为用户自定义部分
  968. End Sub
  970. '填充网格表头数据内容
  971. Private Sub Sub_FillGrid(Str_Grid As String)
  972.     
  973.     Dim Rec_FillGrid As New Recordset               '网格列标题动态集
  974.     Dim jsq As Integer, Rowjsq As Integer
  975.     Dim Coljsq As Integer
  976.     Dim ArrayNum As Integer
  977.     
  978.     '打开账龄区间设置动态集
  979.     Set Rec_FillGrid = Cw_DataEnvi.DataConnect.Execute(Str_Grid)
  980.     FillCol = Rec_FillGrid.RecordCount
  981.     If FillCol < 1 Then Exit Sub
  982.     
  983.         '根据帐龄区间设置各个帐龄分析区间段的最小值
  984.         '<<
  985.         ReDim AccAge(FillCol) As Single
  986.     
  987.         Rec_FillGrid.MoveFirst
  988.         ArrayNum = 0
  989.         Do While Not Rec_FillGrid.EOF
  990.             ArrayNum = ArrayNum + 1
  991.             AccAge(ArrayNum) = Trim(Rec_FillGrid.Fields("MinBillAge") & "")
  992.             Rec_FillGrid.MoveNext
  993.         Loop
  994.         '>>
  995.     
  996.     '填充网格表头数据
  997.     Rec_FillGrid.MoveFirst
  998.     With CxbbGrid
  999.         '设置网格属性
  1000.         .BackColorFixed = &H8000000F                                           '固定行背景色 ('&H80000018)
  1001.         .Cols = Qslz + 4 + Rec_FillGrid.RecordCount
  1002.         .AllowUserResizing = flexResizeBoth
  1003.         .SelectionMode = flexSelectionByRow
  1004.         .ExplorerBar = flexExNone                                              '网格列是否可移动及排序
  1005.         .ScrollTips = True
  1006.         .WordWrap = True
  1007.         
  1008.         For jsq = Qslz To .Cols - 1
  1009.             .ColHidden(jsq) = False
  1010.         Next jsq
  1011.         
  1012.         '填 充 网 格 标 题
  1013.         For Rowjsq = 0 To .FixedRows - 1
  1014.             If Rowjsq = 0 Then
  1015.                 .MergeRow(Rowjsq) = True
  1016.                 .RowHeight(Rowjsq) = Sjhgd * 1.8
  1017.                 .TextMatrix(Rowjsq, Qslz) = "客户编码"
  1018.                 .TextMatrix(Rowjsq, Qslz + 1) = "客户名称"
  1019.                 .TextMatrix(Rowjsq, Qslz + 2) = "余额"
  1020.                 .TextMatrix(Rowjsq, Qslz + 3) = "未到期"
  1021.                 
  1022.                 .TextMatrix(Rowjsq + 1, Qslz) = "客户编码"
  1023.                 .TextMatrix(Rowjsq + 1, Qslz + 1) = "客户名称"
  1024.                 .TextMatrix(Rowjsq + 1, Qslz + 2) = "余额"
  1025.                 .TextMatrix(Rowjsq + 1, Qslz + 3) = "未到期"
  1026.                 
  1027.                 BeginCol = Qslz + 4             '定义起始列
  1028.                 
  1029.                 '从数据表填充网格列
  1030.                 If Not Rec_FillGrid.EOF Then
  1031.                     Rec_FillGrid.MoveFirst
  1032.                     For Coljsq = (Qslz + 4) To (.Cols - 1)
  1033.                         .TextMatrix(Rowjsq, Coljsq) = "过期天数"
  1034.                         .TextMatrix(Rowjsq + 1, Coljsq) = Trim(Rec_FillGrid.Fields("BEDays") & "")
  1035.                         Rec_FillGrid.MoveNext
  1036.                     Next Coljsq
  1037.                 End If
  1038.             
  1039.             End If
  1040.         Next Rowjsq
  1041.         
  1042.         '数 据 网 格 高 度
  1043.         For Rowjsq = 0 To .FixedRows - 1
  1044.             .RowHeight(Rowjsq) = 250
  1045.         Next Rowjsq
  1046.         
  1047.          '定 义 录 入 字 段 属 性
  1048.         For Coljsq = (Qslz + 4) To .Cols - 1
  1049.             .MergeCol(Coljsq) = True
  1050.             .ColAlignment(Coljsq) = flexAlignRightTop
  1051.             .FixedAlignment(Coljsq) = flexAlignCenterCenter
  1053.         Next Coljsq
  1054.              
  1055.         '定义网格列宽度
  1056.         For Coljsq = 4 To .Cols - 1
  1057.             .ColWidth(Coljsq) = Sjhgd * 5
  1058.         Next Coljsq
  1059.     
  1060.     End With
  1062. End Sub
  1064. '[>>===================以下为根据实际业务需要自定义过程区域=============================<<]
  1066. Private Sub bbyl(bbylte As Boolean)                    '报表打印预览
  1067.     
  1068.     Dim Bbzbt$, Bbxbt() As String, bbxbtzzxs() As Integer, Bbxbtgs As Integer
  1069.     Dim Bbbwh() As String, Bbbwhzzxs() As Integer, Bbbwhgs As Integer
  1070.     Bbxbtgs = 2                                          '报 表 小 标 题 行 数
  1071.     Bbbwhgs = 0                                          '报 表 表 尾 行 数
  1072.     
  1073.     ReDim Bbxbt(1 To Bbxbtgs)
  1074.     ReDim bbxbtzzxs(1 To Bbxbtgs)
  1075.     If Bbbwhgs <> 0 Then
  1076.         ReDim Bbbwh(1 To Bbbwhgs)
  1077.         ReDim Bbbwhzzxs(1 To Bbbwhgs)
  1078.     End If
  1079.     
  1080.     Bbzbt = ReportTitle
  1081.     Bbxbt(1) = Space(2) + Fun_FormatOutPut(Lab_Dept, 28) + Fun_FormatOutPut(Lab_Person, 28) + Fun_FormatOutPut(Lab_Foreign, 28) + Fun_FormatOutPut(Lab_Date, 28)
  1082.     bbxbtzzxs(1) = 0                                     '报表行组织形式(0-居左 1-居中 2-居右)
  1083.     Call Scyxsjb(CxbbGrid)                               '生成报表数据
  1084.     Call Scdybb(Dyymctbl, Bbzbt, Bbxbt(), bbxbtzzxs(), Bbxbtgs, Bbbwh(), Bbbwhzzxs(), Bbbwhgs, bbylte)
  1085.     If Not bbylte Then
  1086.         Unload DY_Tybbyldy
  1087.     End If
  1089. End Sub