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

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

企业管理

开发平台：

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 Xs_R_ConsignThing 
  5.    Caption         =   "发货单执行情况查询结果"
  6.    ClientHeight    =   8595
  7.    ClientLeft      =   315
  8.    ClientTop       =   390
  9.    ClientWidth     =   11820
  10.    HelpContextID   =   5001
  11.    Icon            =   "发货单执行情况查询结果.frx":0000
  12.    KeyPreview      =   -1  'True
  13.    LinkTopic       =   "Form1"
  14.    MDIChild        =   -1  'True
  15.    ScaleHeight     =   8595
  16.    ScaleWidth      =   11820
  17.    WindowState     =   2  'Maximized
  18.    Begin MSComctlLib.Toolbar GsToolbar 
  19.       Height          =   525
  20.       Left            =   10050
  21.       TabIndex        =   3
  22.       Top             =   30
  23.       Width           =   1755
  24.       _ExtentX        =   3096
  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.             Object.Visible         =   0   'False
  46.             Caption         =   "显示项目"
  47.             Key             =   "szxsxm"
  48.             ImageKey        =   "xsxm"
  49.          EndProperty
  50.       EndProperty
  51.    End
  52.    Begin VB.PictureBox Pic_Title 
  53.       BackColor       =   &H00FFFFFF&
  54.       Height          =   825
  55.       Left            =   0
  56.       Picture         =   "发货单执行情况查询结果.frx":1042
  57.       ScaleHeight     =   765
  58.       ScaleWidth      =   11715
  59.       TabIndex        =   1
  60.       Top             =   570
  61.       Width           =   11775
  62.       Begin VB.Label Lab_Title 
  63.          BackColor       =   &H80000018&
  64.          BackStyle       =   0  'Transparent
  65.          Caption         =   "发货单执行情况"
  66.          BeginProperty Font 
  67.             Name            =   "宋体"
  68.             Size            =   12
  69.             Charset         =   134
  70.             Weight          =   700
  71.             Underline       =   0   'False
  72.             Italic          =   0   'False
  73.             Strikethrough   =   0   'False
  74.          EndProperty
  75.          ForeColor       =   &H00000000&
  76.          Height          =   300
  77.          Index           =   4
  78.          Left            =   480
  79.          TabIndex        =   2
  80.          Top             =   210
  81.          Width           =   2715
  82.       End
  83.    End
  84.    Begin VB.Timer Timer1 
  85.       Enabled         =   0   'False
  86.       Interval        =   1
  87.       Left            =   7620
  88.       Top             =   90
  89.    End
  90.    Begin VSFlex8Ctl.VSFlexGrid CxbbGrid 
  91.       Height          =   7545
  92.       Left            =   0
  93.       TabIndex        =   0
  94.       Top             =   1470
  95.       Width           =   11775
  96.       _cx             =   5080
  97.       _cy             =   5080
  98.       Appearance      =   1
  99.       BorderStyle     =   1
  100.       Enabled         =   -1  'True
  101.       BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
  102.          Name            =   "宋体"
  103.          Size            =   9
  104.          Charset         =   134
  105.          Weight          =   400
  106.          Underline       =   0   'False
  107.          Italic          =   0   'False
  108.          Strikethrough   =   0   'False
  109.       EndProperty
  110.       MousePointer    =   0
  111.       BackColor       =   16777215
  112.       ForeColor       =   -2147483640
  113.       BackColorFixed  =   13826538
  114.       ForeColorFixed  =   -2147483630
  115.       BackColorSel    =   -2147483635
  116.       ForeColorSel    =   -2147483634
  117.       BackColorBkg    =   -2147483636
  118.       BackColorAlternate=   16777215
  119.       GridColor       =   -2147483633
  120.       GridColorFixed  =   -2147483632
  121.       TreeColor       =   -2147483632
  122.       FloodColor      =   192
  123.       SheetBorder     =   -2147483642
  124.       FocusRect       =   1
  125.       HighLight       =   1
  126.       AllowSelection  =   -1  'True
  127.       AllowBigSelection=   -1  'True
  128.       AllowUserResizing=   0
  129.       SelectionMode   =   0
  130.       GridLines       =   1
  131.       GridLinesFixed  =   2
  132.       GridLineWidth   =   1
  133.       Rows            =   50
  134.       Cols            =   10
  135.       FixedRows       =   1
  136.       FixedCols       =   1
  137.       RowHeightMin    =   0
  138.       RowHeightMax    =   0
  139.       ColWidthMin     =   0
  140.       ColWidthMax     =   0
  141.       ExtendLastCol   =   0   'False
  142.       FormatString    =   ""
  143.       ScrollTrack     =   0   'False
  144.       ScrollBars      =   3
  145.       ScrollTips      =   0   'False
  146.       MergeCells      =   0
  147.       MergeCompare    =   0
  148.       AutoResize      =   -1  'True
  149.       AutoSizeMode    =   0
  150.       AutoSearch      =   0
  151.       AutoSearchDelay =   2
  152.       MultiTotals     =   -1  'True
  153.       SubtotalPosition=   1
  154.       OutlineBar      =   0
  155.       OutlineCol      =   0
  156.       Ellipsis        =   0
  157.       ExplorerBar     =   0
  158.       PicturesOver    =   0   'False
  159.       FillStyle       =   0
  160.       RightToLeft     =   0   'False
  161.       PictureType     =   0
  162.       TabBehavior     =   0
  163.       OwnerDraw       =   0
  164.       Editable        =   0
  165.       ShowComboButton =   1
  166.       WordWrap        =   0   'False
  167.       TextStyle       =   0
  168.       TextStyleFixed  =   0
  169.       OleDragMode     =   0
  170.       OleDropMode     =   0
  171.       DataMode        =   0
  172.       VirtualData     =   -1  'True
  173.       DataMember      =   ""
  174.       ComboSearch     =   3
  175.       AutoSizeMouse   =   -1  'True
  176.       FrozenRows      =   0
  177.       FrozenCols      =   0
  178.       AllowUserFreezing=   0
  179.       BackColorFrozen =   0
  180.       ForeColorFrozen =   0
  181.       WallPaperAlignment=   9
  182.       AccessibleName  =   ""
  183.       AccessibleDescription=   ""
  184.       AccessibleValue =   ""
  185.       AccessibleRole  =   24
  186.       Begin MSComctlLib.ImageList ImageList2 
  187.          Left            =   0
  188.          Top             =   0
  189.          _ExtentX        =   1005
  190.          _ExtentY        =   1005
  191.          BackColor       =   -2147483643
  192.          ImageWidth      =   16
  193.          ImageHeight     =   16
  194.          MaskColor       =   12632256
  195.          _Version        =   393216
  196.          BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
  197.             NumListImages   =   40
  198.             BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  199.                Picture         =   "发货单执行情况查询结果.frx":35106
  200.                Key             =   "sz"
  201.             EndProperty
  202.             BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  203.                Picture         =   "发货单执行情况查询结果.frx":354A0
  204.                Key             =   "dy"
  205.             EndProperty
  206.             BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  207.                Picture         =   "发货单执行情况查询结果.frx":3583A
  208.                Key             =   "yl"
  209.             EndProperty
  210.             BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  211.                Picture         =   "发货单执行情况查询结果.frx":35BD4
  212.                Key             =   "xg"
  213.             EndProperty
  214.             BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  215.                Picture         =   "发货单执行情况查询结果.frx":35F6E
  216.                Key             =   "zh"
  217.             EndProperty
  218.             BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  219.                Picture         =   "发货单执行情况查询结果.frx":36308
  220.                Key             =   "sh"
  221.             EndProperty
  222.             BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  223.                Picture         =   "发货单执行情况查询结果.frx":366A2
  224.                Key             =   "bc"
  225.             EndProperty
  226.             BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  227.                Picture         =   "发货单执行情况查询结果.frx":36A3C
  228.                Key             =   "fq"
  229.             EndProperty
  230.             BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  231.                Picture         =   "发货单执行情况查询结果.frx":36DD6
  232.                Key             =   "bz"
  233.             EndProperty
  234.             BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  235.                Picture         =   "发货单执行情况查询结果.frx":37170
  236.                Key             =   "tc"
  237.             EndProperty
  238.             BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  239.                Picture         =   "发货单执行情况查询结果.frx":3750A
  240.                Key             =   "bcgs"
  241.             EndProperty
  242.             BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  243.                Picture         =   "发货单执行情况查询结果.frx":378A4
  244.                Key             =   "mrlk"
  245.             EndProperty
  246.             BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  247.                Picture         =   "发货单执行情况查询结果.frx":37C3E
  248.                Key             =   "xsxm"
  249.             EndProperty
  250.             BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  251.                Picture         =   "发货单执行情况查询结果.frx":37FD8
  252.                Key             =   "first"
  253.             EndProperty
  254.             BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  255.                Picture         =   "发货单执行情况查询结果.frx":38372
  256.                Key             =   "prev"
  257.             EndProperty
  258.             BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  259.                Picture         =   "发货单执行情况查询结果.frx":3870C
  260.                Key             =   "next"
  261.             EndProperty
  262.             BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  263.                Picture         =   "发货单执行情况查询结果.frx":38AA6
  264.                Key             =   "last"
  265.             EndProperty
  266.             BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  267.                Picture         =   "发货单执行情况查询结果.frx":38E40
  268.                Key             =   "xx"
  269.             EndProperty
  270.             BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  271.                Picture         =   "发货单执行情况查询结果.frx":391DA
  272.                Key             =   "define"
  273.             EndProperty
  274.             BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  275.                Picture         =   "发货单执行情况查询结果.frx":39574
  276.                Key             =   "exec"
  277.             EndProperty
  278.             BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  279.                Picture         =   "发货单执行情况查询结果.frx":3990E
  280.                Key             =   "xz"
  281.             EndProperty
  282.             BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  283.                Picture         =   "发货单执行情况查询结果.frx":39CA8
  284.                Key             =   "sc"
  285.             EndProperty
  286.             BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  287.                Picture         =   "发货单执行情况查询结果.frx":3A042
  288.                Key             =   "sx"
  289.             EndProperty
  290.             BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  291.                Picture         =   "发货单执行情况查询结果.frx":3A3DC
  292.                Key             =   "cx"
  293.             EndProperty
  294.             BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  295.                Picture         =   "发货单执行情况查询结果.frx":3A776
  296.                Key             =   "zd"
  297.             EndProperty
  298.             BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  299.                Picture         =   "发货单执行情况查询结果.frx":3AB10
  300.                Key             =   "dz"
  301.             EndProperty
  302.             BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  303.                Picture         =   "发货单执行情况查询结果.frx":3AEAA
  304.                Key             =   "ph"
  305.             EndProperty
  306.             BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  307.                Picture         =   "发货单执行情况查询结果.frx":3B244
  308.                Key             =   "fz"
  309.             EndProperty
  310.             BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  311.                Picture         =   "发货单执行情况查询结果.frx":3B5DE
  312.                Key             =   "dw"
  313.             EndProperty
  314.             BeginProperty ListImage30 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  315.                Picture         =   "发货单执行情况查询结果.frx":3B978
  316.                Key             =   "hf"
  317.             EndProperty
  318.             BeginProperty ListImage31 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  319.                Picture         =   "发货单执行情况查询结果.frx":3BD12
  320.                Key             =   "pz"
  321.             EndProperty
  322.             BeginProperty ListImage32 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  323.                Picture         =   "发货单执行情况查询结果.frx":3C0AC
  324.                Key             =   "check"
  325.             EndProperty
  326.             BeginProperty ListImage33 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  327.                Picture         =   "发货单执行情况查询结果.frx":3C446
  328.                Key             =   "qs"
  329.             EndProperty
  330.             BeginProperty ListImage34 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  331.                Picture         =   "发货单执行情况查询结果.frx":3C7E0
  332.                Key             =   "fullcheck"
  333.             EndProperty
  334.             BeginProperty ListImage35 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  335.                Picture         =   "发货单执行情况查询结果.frx":3CB7A
  336.                Key             =   "qq"
  337.             EndProperty
  338.             BeginProperty ListImage36 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  339.                Picture         =   "发货单执行情况查询结果.frx":3CF14
  340.                Key             =   "bcw"
  341.             EndProperty
  342.             BeginProperty ListImage37 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  343.                Picture         =   "发货单执行情况查询结果.frx":3D2AE
  344.                Key             =   "ye"
  345.             EndProperty
  346.             BeginProperty ListImage38 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  347.                Picture         =   "发货单执行情况查询结果.frx":3D648
  348.                Key             =   ""
  349.             EndProperty
  350.             BeginProperty ListImage39 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  351.                Picture         =   "发货单执行情况查询结果.frx":3D9E2
  352.                Key             =   "frist"
  353.             EndProperty
  354.             BeginProperty ListImage40 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  355.                Picture         =   "发货单执行情况查询结果.frx":3DD7C
  356.                Key             =   "dj"
  357.             EndProperty
  358.          EndProperty
  359.       End
  360.    End
  361.    Begin MSComctlLib.Toolbar SzToolbar 
  362.       Align           =   1  'Align Top
  363.       Height          =   555
  364.       Left            =   0
  365.       TabIndex        =   4
  366.       Top             =   0
  367.       Width           =   11820
  368.       _ExtentX        =   20849
  369.       _ExtentY        =   979
  370.       ButtonWidth     =   820
  371.       ButtonHeight    =   926
  372.       AllowCustomize  =   0   'False
  373.       Appearance      =   1
  374.       Style           =   1
  375.       ImageList       =   "ImageList1"
  376.       _Version        =   393216
  377.       BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
  378.          NumButtons      =   12
  379.          BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  380.             Caption         =   "设置"
  381.             Key             =   "ymsz"
  382.             ImageKey        =   "sz"
  383.          EndProperty
  384.          BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  385.             Caption         =   "打印"
  386.             Key             =   "dy"
  387.             ImageKey        =   "dy"
  388.          EndProperty
  389.          BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  390.             Caption         =   "预览"
  391.             Key             =   "yl"
  392.             ImageKey        =   "yl"
  393.          EndProperty
  394.          BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  395.             Style           =   3
  396.          EndProperty
  397.          BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  398.             Caption         =   "查询"
  399.             Key             =   "cx"
  400.             ImageKey        =   "cx"
  401.          EndProperty
  402.          BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  403.             Object.Visible         =   0   'False
  404.             Caption         =   "单据"
  405.             Key             =   "Bill"
  406.             ImageKey        =   "pz"
  407.          EndProperty
  408.          BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  409.             Object.Visible         =   0   'False
  410.             Style           =   3
  411.          EndProperty
  412.          BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  413.             Object.Visible         =   0   'False
  414.             Caption         =   "新增"
  415.             Key             =   "xz"
  416.             ImageKey        =   "xz"
  417.          EndProperty
  418.          BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  419.             Object.Visible         =   0   'False
  420.             Caption         =   "删除"
  421.             Key             =   "sc"
  422.             ImageKey        =   "sc"
  423.          EndProperty
  424.          BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  425.             Style           =   3
  426.          EndProperty
  427.          BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  428.             Caption         =   "帮助"
  429.             Key             =   "bz"
  430.             ImageKey        =   "bz"
  431.          EndProperty
  432.          BeginProperty Button12 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  433.             Caption         =   "退出"
  434.             Key             =   "fh"
  435.             ImageKey        =   "tc"
  436.          EndProperty
  437.       EndProperty
  438.       BorderStyle     =   1
  439.       Begin MSComctlLib.ImageList ImageList1 
  440.          Left            =   6990
  441.          Top             =   30
  442.          _ExtentX        =   1005
  443.          _ExtentY        =   1005
  444.          BackColor       =   -2147483643
  445.          ImageWidth      =   16
  446.          ImageHeight     =   16
  447.          MaskColor       =   12632256
  448.          _Version        =   393216
  449.          BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
  450.             NumListImages   =   32
  451.             BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  452.                Picture         =   "发货单执行情况查询结果.frx":3E116
  453.                Key             =   "sz"
  454.             EndProperty
  455.             BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  456.                Picture         =   "发货单执行情况查询结果.frx":3E4B0
  457.                Key             =   "dy"
  458.             EndProperty
  459.             BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  460.                Picture         =   "发货单执行情况查询结果.frx":3E84A
  461.                Key             =   "yl"
  462.             EndProperty
  463.             BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  464.                Picture         =   "发货单执行情况查询结果.frx":3EBE4
  465.                Key             =   "xg"
  466.             EndProperty
  467.             BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  468.                Picture         =   "发货单执行情况查询结果.frx":3EF7E
  469.                Key             =   "zh"
  470.             EndProperty
  471.             BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  472.                Picture         =   "发货单执行情况查询结果.frx":3F318
  473.                Key             =   "sh"
  474.             EndProperty
  475.             BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  476.                Picture         =   "发货单执行情况查询结果.frx":3F6B2
  477.                Key             =   "bc"
  478.             EndProperty
  479.             BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  480.                Picture         =   "发货单执行情况查询结果.frx":3FA4C
  481.                Key             =   "fq"
  482.             EndProperty
  483.             BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  484.                Picture         =   "发货单执行情况查询结果.frx":3FDE6
  485.                Key             =   "bz"
  486.             EndProperty
  487.             BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  488.                Picture         =   "发货单执行情况查询结果.frx":40180
  489.                Key             =   "tc"
  490.             EndProperty
  491.             BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  492.                Picture         =   "发货单执行情况查询结果.frx":4051A
  493.                Key             =   "bcgs"
  494.             EndProperty
  495.             BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  496.                Picture         =   "发货单执行情况查询结果.frx":408B4
  497.                Key             =   "mrlk"
  498.             EndProperty
  499.             BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  500.                Picture         =   "发货单执行情况查询结果.frx":40C4E
  501.                Key             =   "xsxm"
  502.             EndProperty
  503.             BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  504.                Picture         =   "发货单执行情况查询结果.frx":40FE8
  505.                Key             =   "first"
  506.             EndProperty
  507.             BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  508.                Picture         =   "发货单执行情况查询结果.frx":41382
  509.                Key             =   "prev"
  510.             EndProperty
  511.             BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  512.                Picture         =   "发货单执行情况查询结果.frx":4171C
  513.                Key             =   "next"
  514.             EndProperty
  515.             BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  516.                Picture         =   "发货单执行情况查询结果.frx":41AB6
  517.                Key             =   "last"
  518.             EndProperty
  519.             BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  520.                Picture         =   "发货单执行情况查询结果.frx":41E50
  521.                Key             =   "xx"
  522.             EndProperty
  523.             BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  524.                Picture         =   "发货单执行情况查询结果.frx":421EA
  525.                Key             =   "define"
  526.             EndProperty
  527.             BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  528.                Picture         =   "发货单执行情况查询结果.frx":42584
  529.                Key             =   "exec"
  530.             EndProperty
  531.             BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  532.                Picture         =   "发货单执行情况查询结果.frx":4291E
  533.                Key             =   "xz"
  534.             EndProperty
  535.             BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  536.                Picture         =   "发货单执行情况查询结果.frx":42CB8
  537.                Key             =   "sc"
  538.             EndProperty
  539.             BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  540.                Picture         =   "发货单执行情况查询结果.frx":43052
  541.                Key             =   "sx"
  542.             EndProperty
  543.             BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  544.                Picture         =   "发货单执行情况查询结果.frx":433EC
  545.                Key             =   "cx"
  546.             EndProperty
  547.             BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  548.                Picture         =   "发货单执行情况查询结果.frx":43786
  549.                Key             =   "zd"
  550.             EndProperty
  551.             BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  552.                Picture         =   "发货单执行情况查询结果.frx":43B20
  553.                Key             =   "dz"
  554.             EndProperty
  555.             BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  556.                Picture         =   "发货单执行情况查询结果.frx":43EBA
  557.                Key             =   "ph"
  558.             EndProperty
  559.             BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  560.                Picture         =   "发货单执行情况查询结果.frx":44254
  561.                Key             =   "fz"
  562.             EndProperty
  563.             BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  564.                Picture         =   "发货单执行情况查询结果.frx":445EE
  565.                Key             =   "dw"
  566.             EndProperty
  567.             BeginProperty ListImage30 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  568.                Picture         =   "发货单执行情况查询结果.frx":44988
  569.                Key             =   "hf"
  570.             EndProperty
  571.             BeginProperty ListImage31 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  572.                Picture         =   "发货单执行情况查询结果.frx":44D22
  573.                Key             =   "pz"
  574.             EndProperty
  575.             BeginProperty ListImage32 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  576.                Picture         =   "发货单执行情况查询结果.frx":450BC
  577.                Key             =   "check"
  578.             EndProperty
  579.          EndProperty
  580.       End
  581.    End
  582. End
  583. Attribute VB_Name = "Xs_R_ConsignThing"
  584. Attribute VB_GlobalNameSpace = False
  585. Attribute VB_Creatable = False
  586. Attribute VB_PredeclaredId = True
  587. Attribute VB_Exposed = False
  588. '**************************************************************************
  589. '*    模 块 名 称 :发货单执行情况查询结果
  590. '*    功 能 描 述 :
  591. '*    程序员姓名  :李建伟
  592. '*    最后修改人  :李建伟
  593. '*    最后修改时间:2001/10/06
  594. '*    备        注:程序中所有依实际情况自定义部分均用[>>  <<]括起
  595. '**************************************************************************
  596. Dim ReportTitle As String                '报表主标题
  597. Dim Str_QueryCondi As String             '用户录入查询条件
  598. Dim Rec_BillID As New ADODB.Recordset    '用户查询单据ID动态集
  600. '以下为固定使用变量
  601. Dim Dyymctbl As New DY_Dyymsz            '打印页面窗体变量
  602. Dim GridCode As String                   '显示网格网格代码
  603. Dim GridInf() As Variant                 '整个网格设置信息
  604. Dim Tsxx As String                       '系统提示信息
  605. Dim Qslz As Long                         '网格隐藏(非操作显示)列数
  606. Dim Sjhgd As Double                      '网格数据行高度
  607. Dim Sfxshjwg As Boolean                  '是否显示合计网格
  608. Dim GridBoolean() As Boolean             '网格列信息(布尔型)
  609. Dim GridStr()  As String                 '网格列信息(字符型)
  610. Dim GridInt() As Integer                 '网格列信息(整型)
  611. Dim Szzls As Integer                     '数组总列数(网格列数-1)
  613. Private Sub Form_Resize()                '根据窗体大小来调整网格,标题栏大小(Fixed)
  614.     On Error Resume Next
  615.     With CxbbGrid
  616.         .Width = Me.Width - 160
  617.         .Height = Me.Height - .Top - 400
  618.     End With
  619.     With Pic_Title
  620.         .Width = Me.Width - 160
  621.     End With
  622.     
  623.     GsToolbar.Left = Me.Width - GsToolbar.Width - 140
  625. End Sub
  627. Private Sub Form_Load()                                                   '窗体装入
  628.   
  629.     '调入打印页面设置窗体
  630.     ReportTitle = "发货单执行情况"
  631.     XtReportCode = "Xs_R_ConsignThing"
  632.     Load Dyymctbl
  633.       
  634.     '调整标题栏及网格、格式工具条位置(Fixed)
  635.     Pic_Title.Left = 40
  636.     Pic_Title.Top = SzToolbar.Top + SzToolbar.Height - 10
  637.     CxbbGrid.Left = Pic_Title.Left
  638.     CxbbGrid.Top = Pic_Title.Top + Pic_Title.Height + 20
  639.      
  640.     '调 入 网 格(Fixed)
  641.     GridCode = "Xs_R_ConsignThing"
  642.     Call BzWgcsh(CxbbGrid, GridCode, GridInf(), GridBoolean(), GridInt(), GridStr())
  643.       
  644.     Qslz = GridInf(1)
  645.     Sjhgd = GridInf(2)
  646.     Sfxshjwg = GridInf(7)
  647.     Szzls = CxbbGrid.Cols - 1
  649. End Sub
  651. Private Sub Form_Unload(Cancel As Integer)                                  '窗体卸载
  653.     '卸载条件窗体
  654.     Xs_R_ConsignThingQuery.UnloadCheck.Value = 1
  655.     Unload Xs_R_ConsignThingQuery
  656.     
  657.     '卸载打印页面设置窗体
  658.     Unload Dyymctbl
  660. End Sub
  662. Private Sub CxbbGrid_BeforeMoveColumn(ByVal Col As Long, Position As Long)           '网格列发生移动时自动交换网格索引信息
  663.     Call FnBln_RefreshArray(Col, Position, GridStr(), GridInf())
  664. End Sub
  666. Private Sub GsToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)                '网格格式调整(Fixed)
  667.   
  668.     Select Case Button.Key
  669.         Case "bcgs"                                          '保存表格格式
  670.             Call Bcwggs(CxbbGrid, GridCode, GridStr())
  671.         Case "hfmrgs"                                        '恢复默认格式
  672.             Call Hfmrgs(CxbbGrid, GridCode, GridStr())
  673.         Case "szxsxm"                                        '设置显示项目
  674.             Call Szxsxm(CxbbGrid, GridCode)
  675.     End Select
  677. End Sub
  679. Private Sub SzToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)
  680.     
  681.     Select Case Button.Key
  682.         Case "ymsz"                                          '页面设置
  683.             Dyymctbl.Show 1
  684.         Case "yl"                                            '预 览
  685.             Call bbyl(True)
  686.         Case "dy"                                            '打 印
  687.             Call bbyl(False)
  688.         Case "cx"                                            '查 询
  689.             Xs_R_ConsignThingQuery.Show 1
  690.         Case "Bill"                                          '单 据
  691.             Call CxbbGrid_DblClick
  692.         Case "xz"                                            '新 增
  693.             Call Sub_AddBill
  694.         Case "sc"                                            '删 除
  695.             Call Sub_DeleteBill
  696.         Case "bz"                                            '帮 助
  697.             Call F1bz
  698.         Case "fh"                                            '退 出
  699.            Unload Me
  700.     End Select
  702. End Sub
  704. Private Sub Timer1_Timer()                                 '在窗体激活后调入查询程序
  705.     
  706.     Timer1.Enabled = False
  707.     Xt_Wait.Show
  708.     Xt_Wait.Refresh
  709.    
  710.     '加快显示速度
  711.     CxbbGrid.Redraw = False
  712.  
  713.     '生成查询结果
  714.     Call Sub_Query(0)
  715.    
  716.     CxbbGrid.Redraw = True
  717.     
  718.     Xt_Wait.Hide
  720. End Sub
  722. Private Sub Sub_Query(Int_QueryType As Integer)                                     '生成查询结果(Define)
  723.     
  724.     '过程参数:Int_QueryType 0-"点确定按钮"查询  1-"刷新"查询
  726.     Dim Rec_Query As New ADODB.Recordset        '查询结果动态集
  727.     Dim Coljsq As Long                          '网格列计数器
  728.     Dim Jsqte As Long                           '临时动态计数器
  730.     '以下为自定义部分[
  731.     '隐藏需要变化的列
  732.     CxbbGrid.ColHidden(1) = True
  733.     CxbbGrid.ColHidden(2) = True
  734.     CxbbGrid.ColHidden(3) = True
  735.     CxbbGrid.ColHidden(4) = True
  736.     CxbbGrid.ColHidden(5) = True
  737.     CxbbGrid.ColHidden(6) = True
  738.     CxbbGrid.ColHidden(7) = True
  739.     CxbbGrid.ColHidden(8) = True
  740.     CxbbGrid.ColHidden(17) = True
  741.     CxbbGrid.ColHidden(18) = True
  742.     CxbbGrid.ColHidden(19) = True
  743.     CxbbGrid.ColHidden(20) = True
  744.     CxbbGrid.ColHidden(21) = True
  745.     If Int_QueryType = 0 Then   '0-"点确定按钮"查询
  746.         With Xs_R_ConsignThingQuery
  747.          
  748.             '生成查询条件
  749.             Str_QueryCondi = " where 1=1 "
  750.             For Jsqte = 1 To 13
  751.                 Select Case Jsqte
  752.                     Case 1  '查询日期范围(起始)
  753.                         If Trim(.LrText(0).Text) <> "" Then
  754.                             Str_QueryCondi = Str_QueryCondi & " And ConsignDate>=' " & Trim(.LrText(0).Text) & "'"
  755.                         End If
  756.                     Case 2  '查询日期范围(终止)
  757.                         If Trim(.LrText(1).Text) <> "" Then
  758.                             Str_QueryCondi = Str_QueryCondi & " And ConsignDate<= ' " & Trim(.LrText(1).Text) & "'"
  759.                         End If
  760.                     Case 3  '部门名称
  761.                         If Trim(.LrText(2).Text) <> "" Then
  762.                             Str_QueryCondi = Str_QueryCondi & " and DeptCode = '" & Trim(.LrText(2).Tag) & "'"
  763.                         End If
  764.                     Case 4  '客户
  765.                         If Trim(.LrText(3).Text) <> "" Then
  766.                             Str_QueryCondi = Str_QueryCondi & " and CusCode = '" & Trim(.LrText(3).Tag) & "'"
  767.                         End If
  768.                     Case 5  '销售员
  769.                         If Trim(.LrText(4).Text) <> "" Then
  770.                             Str_QueryCondi = Str_QueryCondi & " and PersonCode = '" & Trim(.LrText(4).Tag) & "'"
  771.                         End If
  772.                     Case 6  '仓库
  773.                         If Trim(.LrText(5).Text) <> "" Then
  774.                             Str_QueryCondi = Str_QueryCondi & " and StorageCode = '" & Trim(.LrText(5).Tag) & "'"
  775.                         End If
  776.                     Case 7  '发货单号(Like)
  777.                         If Trim(.LrText(6).Text) <> "" Then
  778.                             Str_QueryCondi = Str_QueryCondi & " And ConsignCode like '" & Trim(.LrText(6).Text) & "%'"
  779.                         End If
  780.                     Case 8  '存货编码
  781.                         If Trim(.LrText(7).Text) <> "" Then
  782.                             Str_QueryCondi = Str_QueryCondi & " and WareCode = '" & Trim(.LrText(7).Text) & "'"
  783.                         End If
  784.                     Case 9  '销售类型
  785.                         If Trim(.LrText(9).Text) <> "" Then
  786.                             Str_QueryCondi = Str_QueryCondi & " and SellTypeCode = '" & Trim(.LrText(9).Tag) & "'"
  787.                         End If
  788.                     Case 10  '地区
  789.                         If Trim(.LrText(8).Text) <> "" Then
  790.                             Str_QueryCondi = Str_QueryCondi & " and AreaCode = '" & Trim(.LrText(8).Tag) & "'"
  791.                         End If
  792.                     Case 11   '开票状态
  793.                         If Not .Opt_Check(0).Value Then
  794.                             If .Opt_Check(1).Value Then
  795.                                 Str_QueryCondi = Str_QueryCondi & " and  RecQuantity=InvQuantity  "
  796.                             ElseIf .Opt_Check(2).Value Then
  797.                                 Str_QueryCondi = Str_QueryCondi & " and  RecQuantity-InvQuantity>0  "
  798.                             End If
  799.                         End If
  800.                     Case 12   '回款状态
  801.                         If Not .Opt_Check(3).Value Then
  802.                             If .Opt_Check(4).Value Then
  803.                                 Str_QueryCondi = Str_QueryCondi & " and  SettleallFlag='1' "
  804.                             ElseIf .Opt_Check(5).Value Then
  805.                                 Str_QueryCondi = Str_QueryCondi & " and  SettleallFlag='0' "
  806.                             End If
  807.                         End If
  808.                     Case 13   '统计方式
  809.                              '汇总
  810.                             If .Opt_Check(6).Value Then
  811.                                 Str_QueryCondi = Str_QueryCondi & " group by "
  812.                                 '部门
  813.                                 If .Opt_Check(8).Value Then
  814.                                     CxbbGrid.ColHidden(1) = False
  815.                                     Str_QueryCondi = Str_QueryCondi & " DeptName "
  816.                                     Sqlstr = "SELECT DeptName,Sum(Quantity) Quantity,Sum(CapitalWhole) CapitalWhole,Sum(RecQuantity) RecQuantity,Sum(CapReturnMoney) CapReturnMoney,Sum(InvQuantity) InvQuantity,Sum(CapInvoiceMoney) CapInvoiceMoney from Xs_V_ConsignBill " & Str_QueryCondi
  817.                                 ElseIf .Opt_Check(9).Value Then
  818.                                     '客户
  819.                                     CxbbGrid.ColHidden(2) = False
  820.                                     Str_QueryCondi = Str_QueryCondi & " CusName "
  821.                                     Sqlstr = "SELECT CusName,Sum(Quantity) Quantity,Sum(CapitalWhole) CapitalWhole,Sum(RecQuantity) RecQuantity,Sum(CapReturnMoney) CapReturnMoney,Sum(InvQuantity) InvQuantity,Sum(CapInvoiceMoney) CapInvoiceMoney from Xs_V_ConsignBill " & Str_QueryCondi
  822.                                 ElseIf .Opt_Check(10).Value Then
  823.                                     '销售员
  824.                                     CxbbGrid.ColHidden(3) = False
  825.                                     Str_QueryCondi = Str_QueryCondi & " PersonName "
  826.                                     Sqlstr = "SELECT PersonName,Sum(Quantity) Quantity,Sum(CapitalWhole) CapitalWhole,Sum(RecQuantity) RecQuantity,Sum(CapReturnMoney) CapReturnMoney,Sum(InvQuantity) InvQuantity,Sum(CapInvoiceMoney) CapInvoiceMoney from Xs_V_ConsignBill " & Str_QueryCondi
  827.                                 ElseIf .Opt_Check(11).Value Then
  828.                                     '仓库
  829.                                     CxbbGrid.ColHidden(4) = False
  830.                                     Str_QueryCondi = Str_QueryCondi & " WhName "
  831.                                     Sqlstr = "SELECT WhName,Sum(Quantity) Quantity,Sum(CapitalWhole) CapitalWhole,Sum(RecQuantity) RecQuantity,Sum(CapReturnMoney) CapReturnMoney,Sum(InvQuantity) InvQuantity,Sum(CapInvoiceMoney) CapInvoiceMoney from Xs_V_ConsignBill " & Str_QueryCondi
  832.                                 ElseIf .Opt_Check(12).Value Then
  833.                                     '发货单号
  834.                                     CxbbGrid.ColHidden(5) = False
  835.                                     Str_QueryCondi = Str_QueryCondi & " ConsignCode "
  836.                                     Sqlstr = "SELECT ConsignCode,Sum(Quantity) Quantity,Sum(CapitalWhole) CapitalWhole,Sum(RecQuantity) RecQuantity,Sum(CapReturnMoney) CapReturnMoney,Sum(InvQuantity) InvQuantity,Sum(CapInvoiceMoney) CapInvoiceMoney from Xs_V_ConsignBill " & Str_QueryCondi
  837.                                 ElseIf .Opt_Check(13).Value Then
  838.                                     '货物
  839.                                     CxbbGrid.ColHidden(6) = False
  840.                                     CxbbGrid.ColHidden(7) = False
  841.                                     CxbbGrid.ColHidden(8) = False
  842.                                     Str_QueryCondi = Str_QueryCondi & " MName,Model,SaleUnitName "
  843.                                     Sqlstr = "SELECT MName,Model,SaleUnitName,Sum(Quantity) Quantity,Sum(CapitalWhole) CapitalWhole,Sum(RecQuantity) RecQuantity,Sum(CapReturnMoney) CapReturnMoney,Sum(InvQuantity) InvQuantity,Sum(CapInvoiceMoney) CapInvoiceMoney from Xs_V_ConsignBill " & Str_QueryCondi
  844.                                 End If
  845.                             ElseIf .Opt_Check(7).Value Then
  846.                                 '明细
  847.                                 CxbbGrid.ColHidden(17) = False
  848.                                 CxbbGrid.ColHidden(18) = False
  849.                                 CxbbGrid.ColHidden(19) = False
  850.                                 CxbbGrid.ColHidden(20) = False
  851.                                 CxbbGrid.ColHidden(21) = False
  852.                                 Str_QueryCondi = Str_QueryCondi & " order by "
  853.                                 If .Opt_Check(8).Value Then
  854.                                     '部门
  855.                                     CxbbGrid.ColHidden(1) = False
  856.                                     CxbbGrid.ColHidden(17) = True
  857.                                     Str_QueryCondi = Str_QueryCondi & " DeptCode "
  858.                                 ElseIf .Opt_Check(9).Value Then
  859.                                     '客户
  860.                                     CxbbGrid.ColHidden(2) = False
  861.                                     CxbbGrid.ColHidden(18) = True
  862.                                     Str_QueryCondi = Str_QueryCondi & " CusCode "
  863.                                 ElseIf .Opt_Check(10).Value Then
  864.                                     '销售员
  865.                                     CxbbGrid.ColHidden(3) = False
  866.                                     CxbbGrid.ColHidden(19) = True
  867.                                     Str_QueryCondi = Str_QueryCondi & " PersonCode "
  868.                                 ElseIf .Opt_Check(11).Value Then
  869.                                     '仓库
  870.                                     CxbbGrid.ColHidden(4) = False
  871.                                     CxbbGrid.ColHidden(20) = True
  872.                                     Str_QueryCondi = Str_QueryCondi & " StorageCode "
  873.                                 ElseIf .Opt_Check(12).Value Then
  874.                                     '发货单号
  875.                                     CxbbGrid.ColHidden(5) = False
  876.                                     CxbbGrid.ColHidden(21) = True
  877.                                     Str_QueryCondi = Str_QueryCondi & " ConsignCode "
  878.                                 ElseIf .Opt_Check(13).Value Then
  879.                                     '货物
  880.                                     CxbbGrid.ColHidden(6) = False
  881.                                     CxbbGrid.ColHidden(7) = False
  882.                                     CxbbGrid.ColHidden(8) = False
  883.                                     Str_QueryCondi = Str_QueryCondi & " WareCode "
  884.                                 End If
  885.                                 Sqlstr = "SELECT ConsignCode,DeptName,CusName,PersonName,WhName,MName,Model,SaleUnitName,Quantity,CapitalWhole,RecQuantity,CapReturnMoney,InvQuantity,CapInvoiceMoney from Xs_V_ConsignBill " & Str_QueryCondi
  886.                             End If
  887.                 End Select
  888.             Next Jsqte
  889.         End With
  890.     Else
  891.         '1-"刷新"查询
  892.         If Str_QueryCondi = "" Then
  893.             Str_QueryCondi = " where 1=1 "
  894.         End If
  895.     End If
  896.     Set Rec_Query = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
  897.     With Rec_Query
  898.         CxbbGrid.Rows = CxbbGrid.FixedRows
  899.         Jsqte = CxbbGrid.FixedRows
  900.         Do While Not .EOF
  901.             CxbbGrid.AddItem ""
  902.             '[>>自定义填充内容
  903.             If Xs_R_ConsignThingQuery.Opt_Check(6).Value = True Then
  904.                 If Xs_R_ConsignThingQuery.Opt_Check(8).Value Then
  905.                     CxbbGrid.TextMatrix(Jsqte, Sydz("001", GridStr(), Szzls)) = Trim(.Fields("DeptName") & "")                  '部门名称
  906.                 ElseIf Xs_R_ConsignThingQuery.Opt_Check(9).Value Then
  907.                     CxbbGrid.TextMatrix(Jsqte, Sydz("002", GridStr(), Szzls)) = Trim(.Fields("CusName") & "")                   '客户
  908.                 ElseIf Xs_R_ConsignThingQuery.Opt_Check(10).Value Then
  909.                     CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = Trim(.Fields("PersonName") & "")                '销售员
  910.                 ElseIf Xs_R_ConsignThingQuery.Opt_Check(11).Value Then
  911.                     CxbbGrid.TextMatrix(Jsqte, Sydz("004", GridStr(), Szzls)) = Trim(.Fields("WhName") & "")                    '仓库名称
  912.                 ElseIf Xs_R_ConsignThingQuery.Opt_Check(12).Value Then
  913.                     CxbbGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = Trim(.Fields("ConsignCode") & "")                '发货单号
  914.                 ElseIf Xs_R_ConsignThingQuery.Opt_Check(13).Value Then
  915.                     CxbbGrid.TextMatrix(Jsqte, Sydz("006", GridStr(), Szzls)) = Trim(.Fields("MName") & "")                     '存货名称
  916.                     CxbbGrid.TextMatrix(Jsqte, Sydz("007", GridStr(), Szzls)) = Trim(.Fields("Model") & "")                     '规格
  917.                     CxbbGrid.TextMatrix(Jsqte, Sydz("008", GridStr(), Szzls)) = Trim(.Fields("SaleUnitName") & "")              '单位
  918.                 End If
  919.             Else
  920.                 CxbbGrid.TextMatrix(Jsqte, Sydz("001", GridStr(), Szzls)) = Trim(.Fields("DeptName") & "")                 '部门名称
  921.                 CxbbGrid.TextMatrix(Jsqte, Sydz("002", GridStr(), Szzls)) = Trim(.Fields("CusName") & "")                  '客户
  922.                 CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = Trim(.Fields("PersonName") & "")               '销售员
  923.                 CxbbGrid.TextMatrix(Jsqte, Sydz("004", GridStr(), Szzls)) = Trim(.Fields("WhName") & "")                   '仓库
  924.                 CxbbGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = Trim(.Fields("ConsignCode") & "")              '发货单号
  925.                 CxbbGrid.TextMatrix(Jsqte, Sydz("006", GridStr(), Szzls)) = Trim(.Fields("MName") & "")                    '存货名称
  926.                 CxbbGrid.TextMatrix(Jsqte, Sydz("007", GridStr(), Szzls)) = Trim(.Fields("Model") & "")                    '规格
  927.                 CxbbGrid.TextMatrix(Jsqte, Sydz("008", GridStr(), Szzls)) = Trim(.Fields("SaleUnitName") & "")             '单位
  928.                 CxbbGrid.TextMatrix(Jsqte, Sydz("017", GridStr(), Szzls)) = Trim(.Fields("DeptName") & "")                 '部门名称
  929.                 CxbbGrid.TextMatrix(Jsqte, Sydz("018", GridStr(), Szzls)) = Trim(.Fields("CusName") & "")                  '客户
  930.                 CxbbGrid.TextMatrix(Jsqte, Sydz("019", GridStr(), Szzls)) = Trim(.Fields("PersonName") & "")                '销售员
  931.                 CxbbGrid.TextMatrix(Jsqte, Sydz("020", GridStr(), Szzls)) = Trim(.Fields("WhName") & "")                    '仓库
  932.                 CxbbGrid.TextMatrix(Jsqte, Sydz("021", GridStr(), Szzls)) = Trim(.Fields("ConsignCode") & "")               '发货单号
  933.             End If
  934.             If Val(Trim(.Fields("Quantity") & "")) <> 0 Then
  935.                 CxbbGrid.TextMatrix(Jsqte, Sydz("009", GridStr(), Szzls)) = Trim(.Fields("Quantity") & "")                  '数量
  936.             End If
  937.             If Val(Trim(.Fields("RecQuantity") & "")) <> 0 Then
  938.                 CxbbGrid.TextMatrix(Jsqte, Sydz("010", GridStr(), Szzls)) = Trim(.Fields("RecQuantity") & "")               '实收数量
  939.             End If
  940.             If Val(Trim(.Fields("CapitalWhole") & "")) <> 0 Then
  941.                 CxbbGrid.TextMatrix(Jsqte, Sydz("011", GridStr(), Szzls)) = Trim(.Fields("CapitalWhole") & "")              '应收金额
  942.             End If
  943.             If Val(Trim(.Fields("CapReturnMoney") & "")) <> 0 Then
  944.                 CxbbGrid.TextMatrix(Jsqte, Sydz("012", GridStr(), Szzls)) = Trim(.Fields("CapReturnMoney") & "")            '回款金额
  945.             End If
  946.             If Val(Trim(.Fields("CapitalWhole") & "")) - Val(Trim(.Fields("CapReturnMoney") & "")) <> 0 Then
  947.                 CxbbGrid.TextMatrix(Jsqte, Sydz("013", GridStr(), Szzls)) = Val(Trim(.Fields("CapitalWhole") & "")) - Val(Trim(.Fields("CapReturnMoney") & ""))         '未回款金额
  948.             End If
  949.             If Val(Trim(.Fields("RecQuantity") & "")) - Val(Trim(.Fields("InvQuantity") & "")) <> 0 Then
  950.                 CxbbGrid.TextMatrix(Jsqte, Sydz("014", GridStr(), Szzls)) = Val(Trim(.Fields("RecQuantity") & "")) - Val(Trim(.Fields("InvQuantity") & ""))             '未开票数量
  951.             End If
  952.             If Val(Trim(.Fields("InvQuantity") & "")) <> 0 Then
  953.                 CxbbGrid.TextMatrix(Jsqte, Sydz("015", GridStr(), Szzls)) = Trim(.Fields("InvQuantity") & "")               '开票数量
  954.             End If
  955.             If Val(Trim(.Fields("CapInvoiceMoney") & "")) <> 0 Then
  956.                 CxbbGrid.TextMatrix(Jsqte, Sydz("016", GridStr(), Szzls)) = Trim(.Fields("CapInvoiceMoney") & "")           '开票金额
  957.             End If
  958.             '<<]
  959.             '设置数据行高度(Fixed)
  960.             CxbbGrid.RowHeight(Jsqte) = Sjhgd
  961.      
  962.             '动态集指针加1,同时将计数器加1(Fixed)
  963.             .MoveNext
  964.             Jsqte = Jsqte + 1
  965.         Loop
  966.         
  967.     End With
  968.     '合计
  969.     CxbbGrid.AddItem ""
  970.     CxbbGrid.TextMatrix(CxbbGrid.Rows - 1, Sydz("001", GridStr(), Szzls)) = "合计"
  971.     CxbbGrid.TextMatrix(CxbbGrid.Rows - 1, Sydz("002", GridStr(), Szzls)) = "合计"
  972.     CxbbGrid.TextMatrix(CxbbGrid.Rows - 1, Sydz("003", GridStr(), Szzls)) = "合计"
  973.     CxbbGrid.TextMatrix(CxbbGrid.Rows - 1, Sydz("004", GridStr(), Szzls)) = "合计"
  974.     CxbbGrid.TextMatrix(CxbbGrid.Rows - 1, Sydz("005", GridStr(), Szzls)) = "合计"
  975.     CxbbGrid.TextMatrix(CxbbGrid.Rows - 1, Sydz("006", GridStr(), Szzls)) = "合计"
  976.     For Coljsq = Qslz To CxbbGrid.Cols - 1
  977.         Call Sjhj(Coljsq)
  978.     Next Coljsq
  979.     ']以上为用户自定义部分
  981. End Sub
  982. Private Sub Sjhj(Hjwgl As Long)                                         '网格列数据合计
  983.     
  984.     Dim Hjjg As Double
  985.     If Not GridBoolean(Hjwgl, 4) Then
  986.         Exit Sub
  987.     End If
  988.     With CxbbGrid
  989.         Hjjg = 0
  990.         For Jsqte = .FixedRows To .Rows - 2
  991.                 If Trim(.TextMatrix(Jsqte, Hjwgl)) <> "" Then
  992.                     Hjjg = Hjjg + Val(.TextMatrix(Jsqte, Hjwgl))
  993.                 End If
  994.         Next Jsqte
  995.         If GridBoolean(Hjwgl, 5) And Hjjg = 0 Then
  996.             CxbbGrid.TextMatrix(.Rows - 1, Hjwgl) = ""
  997.         Else
  998.             CxbbGrid.TextMatrix(.Rows - 1, Hjwgl) = Hjjg
  999.         End If
  1000.     End With
  1002. End Sub
  1004. Private Sub CxbbGrid_DblClick()                                              '用户双击网格调入相应单据
  1005.     
  1006.     Dim RecTemp As New ADODB.Recordset               '临时使用动态集
  1007.     '当第一次查询结果为空时,判断总记录行是否与固定行数相同,如相同则出现错误(双表头出现此情况)
  1008.     If CxbbGrid.Rows = CxbbGrid.FixedRows Then
  1009.         Exit Sub
  1010.     End If
  1011.     '非数据行退出
  1012.     If CxbbGrid.Row < CxbbGrid.FixedRows Or Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0)) = 0 Then
  1013.         Exit Sub
  1014.     End If
  1016.     Sqlstr = "SELECT OrderBillMainId From XS_OrderBillMain Where OrderBillMainId=" & Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0))
  1017.     Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
  1018.     With RecTemp
  1019.         If .EOF Then
  1020.             Tsxx = "此销售订单已被其他用户删除!"
  1021.             Call Xtxxts(Tsxx, 0, 4)
  1022.             Exit Sub
  1023.         Else
  1024.             '调入单据处理窗体
  1025.             With Xs_O_OrderBill
  1026.                 
  1027.                 '填充查询单据标识
  1028.                 .Lab_BillId = CxbbGrid.TextMatrix(CxbbGrid.Row, 0)
  1029.                 .Str_QueryCondi = Str_QueryCondi
  1030.                 
  1031.                 '设置单据处理为列表查询(修改)状态
  1032.                 .Lab_Djclzt.Caption = "2"
  1033.                 .Show 1
  1034.             End With
  1035.             If Xtfhcs = "1" Then
  1036.                 Tsxx = "销售订单发生变化,是否刷新销售订单列表?"
  1037.                 Yhanswer = Xtxxts(Tsxx, 2, 2)
  1038.                 If Yhanswer = 1 Then
  1039.                     Xt_Wait.Show
  1040.                     Xt_Wait.Refresh
  1041.    
  1042.                     '加快显示速度
  1043.                     CxbbGrid.Redraw = False
  1044.  
  1045.                     '生成查询结果
  1046.                     Call Sub_Query(1)
  1047.    
  1048.                     CxbbGrid.Redraw = True
  1049.                     Xt_Wait.Hide
  1050.                 End If
  1051.             End If
  1052.         End If
  1053.     End With
  1055. End Sub
  1057. Private Sub Sub_AddBill()                                              '新增单据
  1058.    
  1059.     With Xs_O_OrderBill
  1060.    
  1061.         '设置单据处理为填制单据状态
  1062.         .Lab_Djclzt.Caption = "1"
  1063.          
  1064.         .Show 1
  1065.     End With
  1066.        
  1067.     If Xtfhcs = "1" Then
  1068.         Tsxx = "销售订单发生变化,是否刷新销售订单列表?"
  1069.         Yhanswer = Xtxxts(Tsxx, 2, 2)
  1070.         If Yhanswer = 1 Then
  1071.             Xt_Wait.Show
  1072.             Xt_Wait.Refresh
  1073.    
  1074.             '加快显示速度
  1075.             CxbbGrid.Redraw = False
  1076.  
  1077.             '生成查询结果
  1078.             Call Sub_Query(1)
  1079.    
  1080.             CxbbGrid.Redraw = True
  1081.             Xt_Wait.Hide
  1082.         End If
  1083.     End If
  1084.    
  1085. End Sub
  1087. Private Sub Sub_DeleteBill()                                            '删除选中当前销售订单
  1088.     
  1089.     Dim YAnswer As Integer
  1090.     Dim Lng_BillID As Long           '单据标识
  1091.   
  1092.     '非数据行退出
  1093.     If CxbbGrid.Row < CxbbGrid.FixedRows Or Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0)) = 0 Then
  1094.         Exit Sub
  1095.     End If
  1096.   
  1097.     Tsxx = "请确认是否删除当前销售订单?"
  1098.     Yhanswer = Xtxxts(Tsxx, 2, 2)
  1099.   
  1100.     If Yhanswer = 1 Then
  1101.         '1.判断当前销售订单是否允许删除
  1102.         If Not Fun_AllowDelete Then
  1103.             Exit Sub
  1104.         End If
  1105.   
  1106.         '2.删除单据所有内容
  1107.         Lng_BillID = Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0))
  1108.         On Error GoTo Swcwcl
  1109.         Cw_DataEnvi.DataConnect.BeginTrans
  1110.         Cw_DataEnvi.DataConnect.Execute ("Delete XS_OrderBillMain Where OrderBillMainId=" & Lng_BillID)        '删除单据主表内容
  1111.         Cw_DataEnvi.DataConnect.Execute ("Delete XS_OrderBillSub Where OrderBillMainId=" & Lng_BillID)         '删除单据子表内容
  1112.         Cw_DataEnvi.DataConnect.CommitTrans
  1113.       
  1114.         '删除网格中单据数据
  1115.         Jsqte = CxbbGrid.FixedRows
  1116.         Do While Jsqte <= CxbbGrid.Rows - 1
  1117.             If Val(CxbbGrid.TextMatrix(Jsqte, 0)) = Lng_BillID Then
  1118.                 CxbbGrid.RemoveItem (CxbbGrid.Row)
  1119.             Else
  1120.                 Jsqte = Jsqte + 1
  1121.             End If
  1122.         Loop
  1123.     Else
  1124.         Exit Sub
  1125.     End If
  1126.     Exit Sub
  1127. Swcwcl:
  1128.     Cw_DataEnvi.DataConnect.RollbackTrans
  1129.     Tsxx = "删除销售订单过程中出现未知错误,程序自动恢复删除前状态!"
  1130.     Call Xtxxts(Tsxx, 0, 1)
  1131.     Exit Sub
  1132.   
  1133. End Sub
  1135. Private Function Fun_AllowDelete() As Boolean                                        '判断当前单据是否允许删除
  1136.   
  1137.     Dim RecTemp As New ADODB.Recordset     '临时使用动态集
  1138.     Dim Sqlstr As String                   '查询字符串
  1139.     Dim Lng_BillID As Long                 '单据ID
  1140.   
  1141.     Lng_BillID = Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0))
  1142.     Sqlstr = "Select Checker From XS_OrderBillMain Where OrderBillMainId=" & Lng_BillID
  1143.     Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
  1144.     With RecTemp
  1145.         If Not .EOF Then
  1146.             If Trim(.Fields("Checker") & "") <> "" Then
  1147.                 Tsxx = "该销售订单已审核确认,不能删除!"
  1148.                 Call Xtxxts(Tsxx, 0, 4)
  1149.                 Exit Function
  1150.             End If
  1151.             End If
  1152.     End With
  1153.     Fun_AllowDelete = True
  1154.   
  1155. End Function
  1157. Private Sub bbyl(bbylte As Boolean)                    '报表打印预览
  1158.     
  1159.     Dim Bbzbt$, Bbxbt() As String, bbxbtzzxs() As Integer, Bbxbtgs As Integer
  1160.     Dim Bbbwh() As String, Bbbwhzzxs() As Integer, Bbbwhgs As Integer
  1161.     Bbxbtgs = 1                                          '报 表 小 标 题 行 数
  1162.     Bbbwhgs = 0                                          '报 表 表 尾 行 数
  1163.     ReDim Bbxbt(1 To Bbxbtgs)
  1164.     ReDim bbxbtzzxs(1 To Bbxbtgs)
  1165.     If Bbbwhgs <> 0 Then
  1166.         ReDim Bbbwh(1 To Bbbwhgs)
  1167.         ReDim Bbbwhzzxs(1 To Bbbwhgs)
  1168.     End If
  1169.     Bbzbt = ReportTitle
  1170.     Bbxbt(1) = ""
  1171.     bbxbtzzxs(1) = 0                                     '报表行组织形式(0-居左 1-居中 2-居右)
  1172.     Call Scyxsjb(CxbbGrid)                               '生成报表数据
  1173.     Call Scdybb(Dyymctbl, Bbzbt, Bbxbt(), bbxbtzzxs(), Bbxbtgs, Bbbwh(), Bbbwhzzxs(), Bbbwhgs, bbylte)
  1174.     If Not bbylte Then
  1175.         Unload DY_Tybbyldy
  1176.     End If
  1178. End Sub