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

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

企业管理

开发平台：

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 KF_FrmMateOutList 
  5.    Caption         =   "材料出库单列表"
  6.    ClientHeight    =   8595
  7.    ClientLeft      =   315
  8.    ClientTop       =   390
  9.    ClientWidth     =   11820
  10.    HelpContextID   =   1214004
  11.    Icon            =   "出库_材料出库单列表.frx":0000
  12.    KeyPreview      =   -1  'True
  13.    LinkTopic       =   "Form1"
  14.    MDIChild        =   -1  'True
  15.    ScaleHeight     =   8595
  16.    ScaleWidth      =   11820
  17.    WindowState     =   2  'Maximized
  18.    Begin MSComctlLib.Toolbar GsToolbar 
  19.       Height          =   525
  20.       Left            =   9330
  21.       TabIndex        =   3
  22.       Top             =   30
  23.       Width           =   2475
  24.       _ExtentX        =   4366
  25.       _ExtentY        =   926
  26.       ButtonWidth     =   1455
  27.       ButtonHeight    =   926
  28.       Appearance      =   1
  29.       Style           =   1
  30.       ImageList       =   "ImageList2"
  31.       _Version        =   393216
  32.       BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
  33.          NumButtons      =   3
  34.          BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  35.             Caption         =   "保存格式"
  36.             Key             =   "bcgs"
  37.             ImageKey        =   "bcgs"
  38.          EndProperty
  39.          BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  40.             Caption         =   "默认列宽"
  41.             Key             =   "hfmrgs"
  42.             ImageKey        =   "mrlk"
  43.          EndProperty
  44.          BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  45.             Caption         =   "显示项目"
  46.             Key             =   "szxsxm"
  47.             ImageKey        =   "xsxm"
  48.          EndProperty
  49.       EndProperty
  50.    End
  51.    Begin VB.PictureBox Pic_Title 
  52.       Height          =   825
  53.       Left            =   0
  54.       Picture         =   "出库_材料出库单列表.frx":1042
  55.       ScaleHeight     =   765
  56.       ScaleWidth      =   11715
  57.       TabIndex        =   1
  58.       Top             =   570
  59.       Width           =   11775
  60.       Begin VB.Label Lab_Title 
  61.          BackColor       =   &H80000018&
  62.          BackStyle       =   0  'Transparent
  63.          Caption         =   "材料出库单列表"
  64.          BeginProperty Font 
  65.             Name            =   "宋体"
  66.             Size            =   12
  67.             Charset         =   134
  68.             Weight          =   700
  69.             Underline       =   0   'False
  70.             Italic          =   0   'False
  71.             Strikethrough   =   0   'False
  72.          EndProperty
  73.          ForeColor       =   &H00000000&
  74.          Height          =   300
  75.          Index           =   4
  76.          Left            =   480
  77.          TabIndex        =   2
  78.          Top             =   210
  79.          Width           =   2715
  80.       End
  81.    End
  82.    Begin VB.Timer Timer1 
  83.       Enabled         =   0   'False
  84.       Interval        =   1
  85.       Left            =   7620
  86.       Top             =   90
  87.    End
  88.    Begin VSFlex8Ctl.VSFlexGrid CxbbGrid 
  89.       Height          =   7545
  90.       Left            =   0
  91.       TabIndex        =   0
  92.       Top             =   1470
  93.       Width           =   11775
  94.       _cx             =   5080
  95.       _cy             =   5080
  96.       Appearance      =   1
  97.       BorderStyle     =   1
  98.       Enabled         =   -1  'True
  99.       BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
  100.          Name            =   "宋体"
  101.          Size            =   9
  102.          Charset         =   134
  103.          Weight          =   400
  104.          Underline       =   0   'False
  105.          Italic          =   0   'False
  106.          Strikethrough   =   0   'False
  107.       EndProperty
  108.       MousePointer    =   0
  109.       BackColor       =   16777215
  110.       ForeColor       =   -2147483640
  111.       BackColorFixed  =   13826538
  112.       ForeColorFixed  =   -2147483630
  113.       BackColorSel    =   -2147483635
  114.       ForeColorSel    =   -2147483634
  115.       BackColorBkg    =   -2147483636
  116.       BackColorAlternate=   16777215
  117.       GridColor       =   -2147483633
  118.       GridColorFixed  =   -2147483632
  119.       TreeColor       =   -2147483632
  120.       FloodColor      =   192
  121.       SheetBorder     =   -2147483642
  122.       FocusRect       =   1
  123.       HighLight       =   1
  124.       AllowSelection  =   -1  'True
  125.       AllowBigSelection=   -1  'True
  126.       AllowUserResizing=   0
  127.       SelectionMode   =   0
  128.       GridLines       =   1
  129.       GridLinesFixed  =   2
  130.       GridLineWidth   =   1
  131.       Rows            =   50
  132.       Cols            =   10
  133.       FixedRows       =   1
  134.       FixedCols       =   1
  135.       RowHeightMin    =   0
  136.       RowHeightMax    =   0
  137.       ColWidthMin     =   0
  138.       ColWidthMax     =   0
  139.       ExtendLastCol   =   0   'False
  140.       FormatString    =   ""
  141.       ScrollTrack     =   0   'False
  142.       ScrollBars      =   3
  143.       ScrollTips      =   0   'False
  144.       MergeCells      =   0
  145.       MergeCompare    =   0
  146.       AutoResize      =   -1  'True
  147.       AutoSizeMode    =   0
  148.       AutoSearch      =   0
  149.       AutoSearchDelay =   2
  150.       MultiTotals     =   -1  'True
  151.       SubtotalPosition=   1
  152.       OutlineBar      =   0
  153.       OutlineCol      =   0
  154.       Ellipsis        =   0
  155.       ExplorerBar     =   0
  156.       PicturesOver    =   0   'False
  157.       FillStyle       =   0
  158.       RightToLeft     =   0   'False
  159.       PictureType     =   0
  160.       TabBehavior     =   0
  161.       OwnerDraw       =   0
  162.       Editable        =   0
  163.       ShowComboButton =   1
  164.       WordWrap        =   0   'False
  165.       TextStyle       =   0
  166.       TextStyleFixed  =   0
  167.       OleDragMode     =   0
  168.       OleDropMode     =   0
  169.       DataMode        =   0
  170.       VirtualData     =   -1  'True
  171.       DataMember      =   ""
  172.       ComboSearch     =   3
  173.       AutoSizeMouse   =   -1  'True
  174.       FrozenRows      =   0
  175.       FrozenCols      =   0
  176.       AllowUserFreezing=   0
  177.       BackColorFrozen =   0
  178.       ForeColorFrozen =   0
  179.       WallPaperAlignment=   9
  180.       AccessibleName  =   ""
  181.       AccessibleDescription=   ""
  182.       AccessibleValue =   ""
  183.       AccessibleRole  =   24
  184.       Begin MSComctlLib.ImageList ImageList2 
  185.          Left            =   0
  186.          Top             =   0
  187.          _ExtentX        =   1005
  188.          _ExtentY        =   1005
  189.          BackColor       =   -2147483643
  190.          ImageWidth      =   16
  191.          ImageHeight     =   16
  192.          MaskColor       =   12632256
  193.          _Version        =   393216
  194.          BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
  195.             NumListImages   =   40
  196.             BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  197.                Picture         =   "出库_材料出库单列表.frx":1DF82
  198.                Key             =   "sz"
  199.             EndProperty
  200.             BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  201.                Picture         =   "出库_材料出库单列表.frx":1E31C
  202.                Key             =   "dy"
  203.             EndProperty
  204.             BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  205.                Picture         =   "出库_材料出库单列表.frx":1E6B6
  206.                Key             =   "yl"
  207.             EndProperty
  208.             BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  209.                Picture         =   "出库_材料出库单列表.frx":1EA50
  210.                Key             =   "xg"
  211.             EndProperty
  212.             BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  213.                Picture         =   "出库_材料出库单列表.frx":1EDEA
  214.                Key             =   "zh"
  215.             EndProperty
  216.             BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  217.                Picture         =   "出库_材料出库单列表.frx":1F184
  218.                Key             =   "sh"
  219.             EndProperty
  220.             BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  221.                Picture         =   "出库_材料出库单列表.frx":1F51E
  222.                Key             =   "bc"
  223.             EndProperty
  224.             BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  225.                Picture         =   "出库_材料出库单列表.frx":1F8B8
  226.                Key             =   "fq"
  227.             EndProperty
  228.             BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  229.                Picture         =   "出库_材料出库单列表.frx":1FC52
  230.                Key             =   "bz"
  231.             EndProperty
  232.             BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  233.                Picture         =   "出库_材料出库单列表.frx":1FFEC
  234.                Key             =   "tc"
  235.             EndProperty
  236.             BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  237.                Picture         =   "出库_材料出库单列表.frx":20386
  238.                Key             =   "bcgs"
  239.             EndProperty
  240.             BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  241.                Picture         =   "出库_材料出库单列表.frx":20720
  242.                Key             =   "mrlk"
  243.             EndProperty
  244.             BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  245.                Picture         =   "出库_材料出库单列表.frx":20ABA
  246.                Key             =   "xsxm"
  247.             EndProperty
  248.             BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  249.                Picture         =   "出库_材料出库单列表.frx":20E54
  250.                Key             =   "first"
  251.             EndProperty
  252.             BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  253.                Picture         =   "出库_材料出库单列表.frx":211EE
  254.                Key             =   "prev"
  255.             EndProperty
  256.             BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  257.                Picture         =   "出库_材料出库单列表.frx":21588
  258.                Key             =   "next"
  259.             EndProperty
  260.             BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  261.                Picture         =   "出库_材料出库单列表.frx":21922
  262.                Key             =   "last"
  263.             EndProperty
  264.             BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  265.                Picture         =   "出库_材料出库单列表.frx":21CBC
  266.                Key             =   "xx"
  267.             EndProperty
  268.             BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  269.                Picture         =   "出库_材料出库单列表.frx":22056
  270.                Key             =   "define"
  271.             EndProperty
  272.             BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  273.                Picture         =   "出库_材料出库单列表.frx":223F0
  274.                Key             =   "exec"
  275.             EndProperty
  276.             BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  277.                Picture         =   "出库_材料出库单列表.frx":2278A
  278.                Key             =   "xz"
  279.             EndProperty
  280.             BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  281.                Picture         =   "出库_材料出库单列表.frx":22B24
  282.                Key             =   "sc"
  283.             EndProperty
  284.             BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  285.                Picture         =   "出库_材料出库单列表.frx":22EBE
  286.                Key             =   "sx"
  287.             EndProperty
  288.             BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  289.                Picture         =   "出库_材料出库单列表.frx":23258
  290.                Key             =   "cx"
  291.             EndProperty
  292.             BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  293.                Picture         =   "出库_材料出库单列表.frx":235F2
  294.                Key             =   "zd"
  295.             EndProperty
  296.             BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  297.                Picture         =   "出库_材料出库单列表.frx":2398C
  298.                Key             =   "dz"
  299.             EndProperty
  300.             BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  301.                Picture         =   "出库_材料出库单列表.frx":23D26
  302.                Key             =   "ph"
  303.             EndProperty
  304.             BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  305.                Picture         =   "出库_材料出库单列表.frx":240C0
  306.                Key             =   "fz"
  307.             EndProperty
  308.             BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  309.                Picture         =   "出库_材料出库单列表.frx":2445A
  310.                Key             =   "dw"
  311.             EndProperty
  312.             BeginProperty ListImage30 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  313.                Picture         =   "出库_材料出库单列表.frx":247F4
  314.                Key             =   "hf"
  315.             EndProperty
  316.             BeginProperty ListImage31 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  317.                Picture         =   "出库_材料出库单列表.frx":24B8E
  318.                Key             =   "pz"
  319.             EndProperty
  320.             BeginProperty ListImage32 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  321.                Picture         =   "出库_材料出库单列表.frx":24F28
  322.                Key             =   "check"
  323.             EndProperty
  324.             BeginProperty ListImage33 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  325.                Picture         =   "出库_材料出库单列表.frx":252C2
  326.                Key             =   "qs"
  327.             EndProperty
  328.             BeginProperty ListImage34 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  329.                Picture         =   "出库_材料出库单列表.frx":2565C
  330.                Key             =   "fullcheck"
  331.             EndProperty
  332.             BeginProperty ListImage35 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  333.                Picture         =   "出库_材料出库单列表.frx":259F6
  334.                Key             =   "qq"
  335.             EndProperty
  336.             BeginProperty ListImage36 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  337.                Picture         =   "出库_材料出库单列表.frx":25D90
  338.                Key             =   "bcw"
  339.             EndProperty
  340.             BeginProperty ListImage37 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  341.                Picture         =   "出库_材料出库单列表.frx":2612A
  342.                Key             =   "ye"
  343.             EndProperty
  344.             BeginProperty ListImage38 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  345.                Picture         =   "出库_材料出库单列表.frx":264C4
  346.                Key             =   ""
  347.             EndProperty
  348.             BeginProperty ListImage39 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  349.                Picture         =   "出库_材料出库单列表.frx":2685E
  350.                Key             =   "frist"
  351.             EndProperty
  352.             BeginProperty ListImage40 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  353.                Picture         =   "出库_材料出库单列表.frx":26BF8
  354.                Key             =   "dj"
  355.             EndProperty
  356.          EndProperty
  357.       End
  358.    End
  359.    Begin MSComctlLib.Toolbar SzToolbar 
  360.       Align           =   1  'Align Top
  361.       Height          =   555
  362.       Left            =   0
  363.       TabIndex        =   4
  364.       Top             =   0
  365.       Width           =   11820
  366.       _ExtentX        =   20849
  367.       _ExtentY        =   979
  368.       ButtonWidth     =   820
  369.       ButtonHeight    =   926
  370.       AllowCustomize  =   0   'False
  371.       Appearance      =   1
  372.       Style           =   1
  373.       ImageList       =   "ImageList1"
  374.       _Version        =   393216
  375.       BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
  376.          NumButtons      =   12
  377.          BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  378.             Caption         =   "设置"
  379.             Key             =   "ymsz"
  380.             ImageKey        =   "sz"
  381.          EndProperty
  382.          BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  383.             Caption         =   "打印"
  384.             Key             =   "dy"
  385.             ImageKey        =   "dy"
  386.          EndProperty
  387.          BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  388.             Caption         =   "预览"
  389.             Key             =   "yl"
  390.             ImageKey        =   "yl"
  391.          EndProperty
  392.          BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  393.             Style           =   3
  394.          EndProperty
  395.          BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  396.             Caption         =   "查询"
  397.             Key             =   "cx"
  398.             ImageKey        =   "cx"
  399.          EndProperty
  400.          BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  401.             Caption         =   "单据"
  402.             Key             =   "Bill"
  403.             ImageKey        =   "pz"
  404.          EndProperty
  405.          BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  406.             Style           =   3
  407.          EndProperty
  408.          BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  409.             Caption         =   "新增"
  410.             Key             =   "xz"
  411.             ImageKey        =   "xz"
  412.          EndProperty
  413.          BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  414.             Caption         =   "删除"
  415.             Key             =   "sc"
  416.             ImageKey        =   "sc"
  417.          EndProperty
  418.          BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  419.             Style           =   3
  420.          EndProperty
  421.          BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  422.             Caption         =   "帮助"
  423.             Key             =   "bz"
  424.             ImageKey        =   "bz"
  425.          EndProperty
  426.          BeginProperty Button12 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  427.             Caption         =   "退出"
  428.             Key             =   "fh"
  429.             ImageKey        =   "tc"
  430.          EndProperty
  431.       EndProperty
  432.       BorderStyle     =   1
  433.       Begin MSComctlLib.ImageList ImageList1 
  434.          Left            =   6990
  435.          Top             =   30
  436.          _ExtentX        =   1005
  437.          _ExtentY        =   1005
  438.          BackColor       =   -2147483643
  439.          ImageWidth      =   16
  440.          ImageHeight     =   16
  441.          MaskColor       =   12632256
  442.          _Version        =   393216
  443.          BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
  444.             NumListImages   =   32
  445.             BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  446.                Picture         =   "出库_材料出库单列表.frx":26F92
  447.                Key             =   "sz"
  448.             EndProperty
  449.             BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  450.                Picture         =   "出库_材料出库单列表.frx":2732C
  451.                Key             =   "dy"
  452.             EndProperty
  453.             BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  454.                Picture         =   "出库_材料出库单列表.frx":276C6
  455.                Key             =   "yl"
  456.             EndProperty
  457.             BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  458.                Picture         =   "出库_材料出库单列表.frx":27A60
  459.                Key             =   "xg"
  460.             EndProperty
  461.             BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  462.                Picture         =   "出库_材料出库单列表.frx":27DFA
  463.                Key             =   "zh"
  464.             EndProperty
  465.             BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  466.                Picture         =   "出库_材料出库单列表.frx":28194
  467.                Key             =   "sh"
  468.             EndProperty
  469.             BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  470.                Picture         =   "出库_材料出库单列表.frx":2852E
  471.                Key             =   "bc"
  472.             EndProperty
  473.             BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  474.                Picture         =   "出库_材料出库单列表.frx":288C8
  475.                Key             =   "fq"
  476.             EndProperty
  477.             BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  478.                Picture         =   "出库_材料出库单列表.frx":28C62
  479.                Key             =   "bz"
  480.             EndProperty
  481.             BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  482.                Picture         =   "出库_材料出库单列表.frx":28FFC
  483.                Key             =   "tc"
  484.             EndProperty
  485.             BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  486.                Picture         =   "出库_材料出库单列表.frx":29396
  487.                Key             =   "bcgs"
  488.             EndProperty
  489.             BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  490.                Picture         =   "出库_材料出库单列表.frx":29730
  491.                Key             =   "mrlk"
  492.             EndProperty
  493.             BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  494.                Picture         =   "出库_材料出库单列表.frx":29ACA
  495.                Key             =   "xsxm"
  496.             EndProperty
  497.             BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  498.                Picture         =   "出库_材料出库单列表.frx":29E64
  499.                Key             =   "first"
  500.             EndProperty
  501.             BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  502.                Picture         =   "出库_材料出库单列表.frx":2A1FE
  503.                Key             =   "prev"
  504.             EndProperty
  505.             BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  506.                Picture         =   "出库_材料出库单列表.frx":2A598
  507.                Key             =   "next"
  508.             EndProperty
  509.             BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  510.                Picture         =   "出库_材料出库单列表.frx":2A932
  511.                Key             =   "last"
  512.             EndProperty
  513.             BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  514.                Picture         =   "出库_材料出库单列表.frx":2ACCC
  515.                Key             =   "xx"
  516.             EndProperty
  517.             BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  518.                Picture         =   "出库_材料出库单列表.frx":2B066
  519.                Key             =   "define"
  520.             EndProperty
  521.             BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  522.                Picture         =   "出库_材料出库单列表.frx":2B400
  523.                Key             =   "exec"
  524.             EndProperty
  525.             BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  526.                Picture         =   "出库_材料出库单列表.frx":2B79A
  527.                Key             =   "xz"
  528.             EndProperty
  529.             BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  530.                Picture         =   "出库_材料出库单列表.frx":2BB34
  531.                Key             =   "sc"
  532.             EndProperty
  533.             BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  534.                Picture         =   "出库_材料出库单列表.frx":2BECE
  535.                Key             =   "sx"
  536.             EndProperty
  537.             BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  538.                Picture         =   "出库_材料出库单列表.frx":2C268
  539.                Key             =   "cx"
  540.             EndProperty
  541.             BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  542.                Picture         =   "出库_材料出库单列表.frx":2C602
  543.                Key             =   "zd"
  544.             EndProperty
  545.             BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  546.                Picture         =   "出库_材料出库单列表.frx":2C99C
  547.                Key             =   "dz"
  548.             EndProperty
  549.             BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  550.                Picture         =   "出库_材料出库单列表.frx":2CD36
  551.                Key             =   "ph"
  552.             EndProperty
  553.             BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  554.                Picture         =   "出库_材料出库单列表.frx":2D0D0
  555.                Key             =   "fz"
  556.             EndProperty
  557.             BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  558.                Picture         =   "出库_材料出库单列表.frx":2D46A
  559.                Key             =   "dw"
  560.             EndProperty
  561.             BeginProperty ListImage30 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  562.                Picture         =   "出库_材料出库单列表.frx":2D804
  563.                Key             =   "hf"
  564.             EndProperty
  565.             BeginProperty ListImage31 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  566.                Picture         =   "出库_材料出库单列表.frx":2DB9E
  567.                Key             =   "pz"
  568.             EndProperty
  569.             BeginProperty ListImage32 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  570.                Picture         =   "出库_材料出库单列表.frx":2DF38
  571.                Key             =   "check"
  572.             EndProperty
  573.          EndProperty
  574.       End
  575.    End
  576. End
  577. Attribute VB_Name = "KF_FrmMateOutList"
  578. Attribute VB_GlobalNameSpace = False
  579. Attribute VB_Creatable = False
  580. Attribute VB_PredeclaredId = True
  581. Attribute VB_Exposed = False
  583. '**************************************************************************
  584. '*    模 块 名 称 :材料出库单列表
  585. '*    功 能 描 述 :
  586. '*    程序员姓名  :赵宇光
  587. '*    最后修改人  :赵宇光
  588. '*    最后修改时间:2001/11/29
  589. '*    备        注:程序中所有依实际情况自定义部分均用[>>  <<]括起
  590. '**************************************************************************
  591. Dim ReportTitle As String                '报表主标题
  592. Dim Str_QueryCondi As String             '用户录入查询条件
  593. Dim Rec_BillID As New ADODB.Recordset    '用户查询单据ID动态集
  594. Dim intFatherID() As Integer
  595. Dim intChildID() As Integer
  596. Dim IsQc() As Boolean
  597. Dim intCount As Integer
  598. Dim Str_RightEdit As String                     '单据编辑(新增、修改、删除)权限索引
  599. '以下为固定使用变量
  600. Dim Dyymctbl As New DY_Dyymsz            '打印页面窗体变量
  601. Dim GridCode As String                   '显示网格网格代码
  602. Dim GridInf() As Variant                 '整个网格设置信息
  603. Dim Tsxx As String                       '系统提示信息
  604. Dim Qslz As Long                         '网格隐藏(非操作显示)列数
  605. Dim Sjhgd As Double                      '网格数据行高度
  606. Dim Sfxshjwg As Boolean                  '是否显示合计网格
  607. Dim GridBoolean() As Boolean             '网格列信息(布尔型)
  608. Dim GridStr()  As String                 '网格列信息(字符型)
  609. Dim GridInt() As Integer                 '网格列信息(整型)
  610. Dim Szzls As Integer                     '数组总列数(网格列数-1)
  612. Private Sub Form_Resize()                '根据窗体大小来调整网格,标题栏大小(Fixed)
  613.     On Error Resume Next
  614.     With CxbbGrid
  615.         .Width = Me.Width - 160
  616.         .Height = Me.Height - .Top - 400
  617.     End With
  618.     With Pic_Title
  619.         .Width = Me.Width - 160
  620.     End With
  621.     
  622.     GsToolbar.Left = Me.Width - GsToolbar.Width - 140
  624. End Sub
  626. Private Sub Form_Load()                                                   '窗体装入
  627.     '单据权限索引设置
  628.     Str_RightEdit = "Kf_MateOut_edit"
  629.     '调入打印页面设置窗体
  630.     ReportTitle = "材料出库单列表"
  631.     XtReportCode = "kf_MateOutList"
  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 = "kf_MateOutList"
  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.     KF_FrmMateOutQuery.UnloadCheck.Value = 1
  655.     Unload KF_FrmMateOutQuery
  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.             KF_FrmMateOutQuery.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                        '临时动态计数器
  729.     Dim adoRe As New ADODB.Recordset
  730.     
  731.     '以下为自定义部分[
  732.  
  733.     If Int_QueryType = 0 Then   '0-"点确定按钮"查询
  734.         With KF_FrmMateOutQuery
  735.          
  736.             '生成查询条件
  737.             Str_QueryCondi = " where 1=1 "
  738.             For jsqte = 0 To 12
  739.                 Select Case jsqte
  740.                     Case 0              '开始日期--------结束日期
  741.                         If Trim(.LrText(0).Text) <> "" Then
  742.                             If Trim(.LrText(1).Text) <> "" Then
  743.                                 Str_QueryCondi = Str_QueryCondi & " and billdate between '" & CDate(Trim(.LrText(0).Text)) & "' and '" & CDate(Trim(.LrText(1).Text)) & "'"
  744.                             Else
  745.                                 Str_QueryCondi = Str_QueryCondi & " and billdate>='" & CDate(Trim(.LrText(0).Text)) & "'"
  746.                             End If
  747.                         Else
  748.                            If Trim(.LrText(1).Text) <> "" Then
  749.                               Str_QueryCondi = Str_QueryCondi & " and billdate<='" & CDate(Trim(.LrText(1).Text)) & "'"
  750.                            Else
  751.                            End If
  752.                         End If
  753.                     Case 1                  '单据号
  754.                         If Trim(.LrText(2).Text) <> "" Then
  755.                             Str_QueryCondi = Str_QueryCondi & " And BillNum>='" & Trim(.LrText(2).Text) & "'"
  756.                         End If
  757.                     Case 2                  '单据号
  758.                         If Trim(.LrText(3).Text) <> "" Then
  759.                             Str_QueryCondi = Str_QueryCondi & " And BillNum<='" & Trim(.LrText(3).Text) & "'"
  760.                         End If
  761.                     Case 3                  '仓库
  762.                         If Trim(.LrText(4).Tag) <> "" Then
  763.                             Str_QueryCondi = Str_QueryCondi & " And WhCode='" & Trim(.LrText(4).Tag) & "'"
  764.                         End If
  765.                     Case 4                  '领料申请单号
  766.                         If Trim(.LrText(5).Tag) <> "" Then
  767.                             Str_QueryCondi = Str_QueryCondi & " And IssueID=" & Trim(.LrText(5).Tag)
  768.                         End If
  769.                     Case 5                  '领料部门
  770.                         If Trim(.LrText(6).Tag) <> "" Then
  771.                             Str_QueryCondi = Str_QueryCondi & " and deptCode ='" & Trim(.LrText(6).Tag) & "'"
  772.                         End If
  773.                     Case 6                  '物料分类
  774.                         If Trim(.LrText(7).Text) <> "" Then
  775.                             Str_QueryCondi = Str_QueryCondi & " and InvSortCode like '" & Trim(.LrText(7).Tag) & "%'"
  776.                         End If
  777.                     Case 7                  '物料编码
  778.                         If Trim(.LrText(8).Text) <> "" Then
  779.                             Str_QueryCondi = Str_QueryCondi & " and MNumber = '" & Trim(.LrText(8).Text) & "'"
  780.                         End If
  781.                     Case 8                  '数量
  782.                         If Trim(.LrText(11).Text) <> "" Then
  783.                             Str_QueryCondi = Str_QueryCondi & " And FactIssueQuan>=" & Val(.LrText(11).Text)
  784.                         End If
  785.                     Case 9                  '数量
  786.                         If Trim(.LrText(12).Text) <> "" Then
  787.                             Str_QueryCondi = Str_QueryCondi & " And FactIssueQuan<=" & Val(.LrText(12).Text)
  788.                         End If
  789.                     Case 10                 '金额
  790.                         If Trim(.LrText(9).Text) <> "" Then
  791.                             Str_QueryCondi = Str_QueryCondi & " And IssueMoney>=" & Val(.LrText(9).Text)
  792.                         End If
  793.                     Case 11                 '金额
  794.                         If Trim(.LrText(10).Text) <> "" Then
  795.                             Str_QueryCondi = Str_QueryCondi & " And IssueMoney<=" & Val(.LrText(10).Text)
  796.                         End If
  797.                     Case 12                 '货区
  798.                         If Trim(.LrText(13).Text) <> "" Then
  799.                             Str_QueryCondi = Str_QueryCondi & " And MArea like '" & Trim(.LrText(13).Tag) & "%'"
  800.                         End If
  801.                 End Select
  802.             Next jsqte
  803.         End With
  804.     Else
  805.         '1-"刷新"查询
  806.         If Str_QueryCondi = "" Then
  807.             Str_QueryCondi = " where 1=2 "
  808.         End If
  809.     End If
  810.     '审核状态
  811.     If KF_FrmMateOutQuery.OptCheck(1) Then   '未审核
  812.         Str_QueryCondi = Str_QueryCondi & " and KFChecker=''"
  813.     End If
  814.     If KF_FrmMateOutQuery.OptCheck(2) Then   '已审核
  815.         Str_QueryCondi = Str_QueryCondi & " and KFChecker<>''"
  816.     End If
  818.      
  819.     Sqlstr = "SELECT * From KF_V_MateOut " & Str_QueryCondi & " order by  InOutMainId"
  820.            
  822.     Set Rec_Query = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
  823.     With Rec_Query
  824.         CxbbGrid.Rows = CxbbGrid.FixedRows
  825.         jsqte = CxbbGrid.FixedRows
  826.         Do While Not .EOF
  827.             CxbbGrid.AddItem ""
  828.             '[>>自定义填充内容
  829.             CxbbGrid.TextMatrix(jsqte, 0) = .Fields("InOutMainId")                                                  '材料出库单ID(主要用来查询定位用)
  830.             CxbbGrid.TextMatrix(jsqte, Sydz("001", GridStr(), Szzls)) = Format(.Fields("BillDate"), "yyyy-mm-dd")               '订单日期
  831.             CxbbGrid.TextMatrix(jsqte, Sydz("002", GridStr(), Szzls)) = Trim(.Fields("whName") & "")                '仓库名称
  832.             CxbbGrid.TextMatrix(jsqte, Sydz("003", GridStr(), Szzls)) = Trim(.Fields("billnum") & "")               '单据号
  833.             CxbbGrid.TextMatrix(jsqte, Sydz("004", GridStr(), Szzls)) = Trim(.Fields("DeptName") & "")              '部门
  834.             CxbbGrid.TextMatrix(jsqte, Sydz("005", GridStr(), Szzls)) = Trim(.Fields("IssueNum") & "")              '申请单号
  835.             CxbbGrid.TextMatrix(jsqte, Sydz("006", GridStr(), Szzls)) = Trim(.Fields("mnumber") & "")               '物料编码
  836.             CxbbGrid.TextMatrix(jsqte, Sydz("007", GridStr(), Szzls)) = Trim(.Fields("mname") & "")                 '物料名称
  837.             CxbbGrid.TextMatrix(jsqte, Sydz("008", GridStr(), Szzls)) = Trim(.Fields("Model") & "")                 '规格型号
  838.             CxbbGrid.TextMatrix(jsqte, Sydz("009", GridStr(), Szzls)) = Trim(.Fields("BatchNum") & "")              '批次
  839.             CxbbGrid.TextMatrix(jsqte, Sydz("010", GridStr(), Szzls)) = Trim(.Fields("Mareaname") & "")             '货区
  840.             
  841.             If .Fields("FactIssuequan") <> 0 Then                                                                            '单重
  842.                 CxbbGrid.TextMatrix(jsqte, Sydz("011", GridStr(), Szzls)) = .Fields("FactIssuequan")
  843.             End If
  844.             If .Fields("price") <> 0 Then                                                                           '单价
  845.                 CxbbGrid.TextMatrix(jsqte, Sydz("012", GridStr(), Szzls)) = .Fields("price")
  846.             End If
  847.             If .Fields("IssueMoney") <> 0 Then                                                                      '数量
  848.                 CxbbGrid.TextMatrix(jsqte, Sydz("013", GridStr(), Szzls)) = .Fields("IssueMoney")
  849.             End If
  851.             CxbbGrid.TextMatrix(jsqte, Sydz("014", GridStr(), Szzls)) = Trim(.Fields("Maker") & "")                 '制单人
  852.             CxbbGrid.TextMatrix(jsqte, Sydz("015", GridStr(), Szzls)) = Trim(.Fields("KFChecker") & "")             '审核人
  853.             CxbbGrid.TextMatrix(jsqte, Sydz("016", GridStr(), Szzls)) = Trim(.Fields("ChalkitupMan") & "")          '记帐人
  854.             
  855.             '<<]
  856.             '设置数据行高度(Fixed)
  857.             CxbbGrid.RowHeight(jsqte) = Sjhgd
  858.             '设置背景颜色
  859.             If .Fields("RedBlueFlag") = 1 Then
  860.                 CxbbGrid.Cell(flexcpForeColor, jsqte, Qslz, jsqte, CxbbGrid.Cols - 1) = &HFF&
  861.             End If
  862.      
  863.             '动态集指针加1,同时将计数器加1(Fixed)
  864.             .MoveNext
  865.             jsqte = jsqte + 1
  866.         Loop
  867.     End With
  869.     ']以上为用户自定义部分
  871. End Sub
  873. Private Sub CxbbGrid_DblClick()                                              '用户双击网格调入相应单据
  874.     
  875.     Dim RecTemp As New ADODB.Recordset               '临时使用动态集
  877.     '当第一次查询结果为空时,判断总记录行是否与固定行数相同,如相同则出现错误(双表头出现此情况)
  878.     If CxbbGrid.Rows = CxbbGrid.FixedRows Then
  879.         Exit Sub
  880.     End If
  881.     '非数据行退出
  882.     If CxbbGrid.Row < CxbbGrid.FixedRows Or Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0)) = 0 Then
  883.         Exit Sub
  884.     End If
  886.     Sqlstr = "SELECT InOutMainID From gy_inoutMain Where InOutMainID=" & Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0))
  887.     Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
  888.     With RecTemp
  889.         If .EOF Then
  890.             Tsxx = "此材料出库单已被其他用户删除!"
  891.             Call Xtxxts(Tsxx, 0, 4)
  892.             Exit Sub
  893.         Else
  894.             '调入单据处理窗体
  895.             With KF_FrmMateOut
  896.                 
  897.                 '填充查询单据标识
  898.                 XT_BillID = CxbbGrid.TextMatrix(CxbbGrid.Row, 0)
  899.                 Xtcdcsfz = Str_QueryCondi
  900.                 
  901.                 '设置单据处理为列表查询(修改)状态
  902.                 Xtcdcs = "2"
  903.                 .Show 1
  904.             End With
  905.             If Xtfhcs = "1" Then
  906.                 Tsxx = "材料出库单发生变化,是否刷新材料出库单列表?"
  907.                 Yhanswer = Xtxxts(Tsxx, 2, 2)
  908.                 If Yhanswer = 1 Then
  909.                     Xt_Wait.Show
  910.                     Xt_Wait.Refresh
  911.    
  912.                     '加快显示速度
  913.                     CxbbGrid.Redraw = False
  914.  
  915.                     '生成查询结果
  916.                     Call Sub_Query(1)
  917.    
  918.                     CxbbGrid.Redraw = True
  919.                     Xt_Wait.Hide
  920.                 End If
  921.             End If
  922.         End If
  923.     End With
  925. End Sub
  927. Private Sub Sub_AddBill()                                              '新增单据
  928.     '判断用户是否有此功能执行权限,如有则写上机日志(进入)
  929.      If Not Security_Log(Str_RightEdit, Xtczybm, 1, True) Then
  930.         Exit Sub
  931.      End If
  932.    
  933.     With KF_FrmMateOut
  934.    
  935.         '设置单据处理为填制单据状态
  936.         Xtcdcs = "1"
  937.         .Show 1
  938.     End With
  939.        
  940.     If Xtfhcs = "1" Then
  941.         Tsxx = "材料出库单发生变化,是否刷新材料出库单列表?"
  942.         Yhanswer = Xtxxts(Tsxx, 2, 2)
  943.         If Yhanswer = 1 Then
  944.             Xt_Wait.Show
  945.             Xt_Wait.Refresh
  946.    
  947.             '加快显示速度
  948.             CxbbGrid.Redraw = False
  949.  
  950.             '生成查询结果
  951.             Call Sub_Query(1)
  952.    
  953.             CxbbGrid.Redraw = True
  954.             Xt_Wait.Hide
  955.         End If
  956.     End If
  957.    
  958. End Sub
  960. Private Sub Sub_DeleteBill()                                            '删除选中当前材料出库单
  961.     
  962.     Dim YAnswer As Integer
  963.     Dim Lng_BillID As Long           '单据标识
  964.     Dim Rec_Sub As New Recordset
  965.     Dim strSQL As String
  966.     Dim LsJs As Integer
  967.     Dim StrTemp1 As String
  968.     
  969.     '当第一次查询结果为空时,判断总记录行是否与固定行数相同,如相同则出现错误(双表头出现此情况)
  970.     If CxbbGrid.Rows = CxbbGrid.FixedRows Then
  971.         Exit Sub
  972.     End If
  973.     '判断用户是否有此功能执行权限,如有则写上机日志(进入)
  974.      If Not Security_Log(Str_RightEdit, Xtczybm, 1, True) Then
  975.         Exit Sub
  976.      End If
  977.   
  978.     '非数据行退出
  979.     If CxbbGrid.Row < CxbbGrid.FixedRows Or Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0)) = 0 Then
  980.         Exit Sub
  981.     End If
  982.   
  983.     Tsxx = "请确认是否删除当前材料出库单?"
  984.     Yhanswer = Xtxxts(Tsxx, 2, 2)
  985.   
  986.     If Yhanswer = 1 Then
  987.         '1.判断当前材料出库单是否允许删除
  988.         If Not Fun_AllowDelete Then
  989.             Exit Sub
  990.         End If
  991.   
  992.         '2.删除单据所有内容
  993.         Lng_BillID = Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0))
  994.         On Error GoTo Swcwcl
  995.         Cw_DataEnvi.DataConnect.BeginTrans
  996.         
  997.         strSQL = "SELECT InOutMainID,MArea,WhCode,MNumber,FactIssueQuan,BatchNum,IssueID FROM KF_V_MateOut " & _
  998.                 "WHERE InOutMainID=" & Lng_BillID
  999.         Set Rec_Sub = Cw_DataEnvi.DataConnect.Execute(strSQL)
  1000.         With Rec_Sub
  1001.             If Not .EOF Then
  1002.              .MoveFirst
  1003.              For LsJs = 1 To .RecordCount
  1004.                  StrTemp1 = Trim(.Fields("MArea") & "")
  1005.                     '1修改现存量
  1006.                     Cw_DataEnvi.DataConnect.Execute (" KF_SP_ChangeQuan '" & Trim(.Fields("WhCode")) & "','" & StrTemp1 & "','" & Trim(.Fields("mnumber")) & "','" & Trim(.Fields("batchnum")) & "'," & Val(.Fields("factIssuequan")) & ",0")
  1007.                     '2修改物料表
  1008.                     Cw_DataEnvi.DataConnect.Execute ("Update gy_material set NowStorage=NowStorage+(" & Val(.Fields("factIssuequan")) & ") where mNumber='" & Trim(.Fields("mnumber")) & "'")
  1009.                     '3修改领料申请数量
  1010.                     If Trim(.Fields("IssueID") & "") <> "" Then
  1011.                         Cw_DataEnvi.DataConnect.Execute ("Update KF_IssueSub set factIssuequan=factIssuequan-(" & Val(.Fields("factIssuequan")) & ") where mnumber='" & Trim(.Fields("mnumber")) & "' and IssueMainId=" & Val(.Fields("IssueID")))
  1012.                         Cw_DataEnvi.DataConnect.Execute ("Update gy_material set AllocateStorage=AllocateStorage+(" & Val(.Fields("factIssuequan")) & ") where mNumber='" & Trim(.Fields("mnumber")) & "'")
  1013.                     End If
  1014.                     '4修改已经出库数量
  1015.                     If Trim(.Fields("batchnum") & "") <> "" Then
  1016.                         If BatchJudge(Trim(.Fields("WhCode")), Trim(.Fields("mnumber")), Trim(.Fields("batchnum")), intCount, intFatherID(), intChildID(), IsQc(), True) = 0 Then
  1017.                             Call RestoreQuan(intCount, intFatherID(), intChildID(), IsQc(), .Fields("factissuequan"), True)
  1018.                         End If
  1019.                     End If
  1020.                     .MoveNext
  1021.                 Next LsJs
  1022.             End If
  1023.         End With
  1025.         Rec_Sub.Close
  1026.         Set Rec_Sub = Nothing
  1027.         
  1028.         Cw_DataEnvi.DataConnect.Execute ("Delete Gy_InoutSub Where InOutMainID=" & Val(Lng_BillID))
  1029.         Cw_DataEnvi.DataConnect.Execute ("Delete gy_inoutMain Where InOutMainID=" & Val(Lng_BillID))
  1030.         Cw_DataEnvi.DataConnect.CommitTrans
  1031.       
  1032.         '删除网格中单据数据
  1033.         jsqte = CxbbGrid.FixedRows
  1034.         Do While jsqte <= CxbbGrid.Rows - 1
  1035.             If Val(CxbbGrid.TextMatrix(jsqte, 0)) = Lng_BillID Then
  1036.                 CxbbGrid.RemoveItem (jsqte)
  1037.             Else
  1038.                 jsqte = jsqte + 1
  1039.             End If
  1040.         Loop
  1041.     Else
  1042.         Exit Sub
  1043.     End If
  1044.     Exit Sub
  1045. Swcwcl:
  1046.     Cw_DataEnvi.DataConnect.RollbackTrans
  1047.     Tsxx = "删除材料出库单过程中出现未知错误,程序自动恢复删除前状态!"
  1048.     Call Xtxxts(Tsxx, 0, 1)
  1049.     Exit Sub
  1050.   
  1051. End Sub
  1052. Private Function Fun_AllowDel() As Boolean
  1053.     Dim RecTemp As New ADODB.Recordset     '临时使用动态集
  1054.     Fun_AllowDel = False
  1055.     Sqlstr = "Select useFlag From KF_Operation Where operationName='" & Trim(CxbbGrid.TextMatrix(CxbbGrid.Row, Sydz("005", GridStr(), Szzls))) & "'"
  1056.     Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
  1057.     With RecTemp
  1058.         If Not .EOF Then
  1059.             If CBool(.Fields("UseFlag")) = True Then
  1060.                 Tsxx = "该单据由系统生成,不允许修改或删除!"
  1061.                 Call Xtxxts(Tsxx, 0, 4)
  1062.                 Exit Function
  1063.             End If
  1064.         End If
  1065.     End With
  1066.     Fun_AllowDel = True
  1068. End Function
  1070. Private Function Fun_AllowDelete() As Boolean                                        '判断当前单据是否允许删除
  1071.   
  1072.     Dim RecTemp As New ADODB.Recordset     '临时使用动态集
  1073.     Dim Sqlstr As String                   '查询字符串
  1074.     Dim Lng_BillID As Long                 '单据ID
  1075.   
  1076.     Lng_BillID = Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0))
  1077.     Sqlstr = "Select KFChecker,ChalkitupMan,CheckFlag From Gy_InoutMain Where InOutMainId=" & Lng_BillID
  1078.     Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
  1079.     With RecTemp
  1080.         If Not .EOF Then
  1081.             If Trim(.Fields("KFChecker") & "") <> "" Then
  1082.                 Tsxx = "该单据已审核确认,不能修改或删除!"
  1083.                 Call Xtxxts(Tsxx, 0, 4)
  1084.                 Exit Function
  1085.             End If
  1086.             If CBool(.Fields("CheckFlag")) = True Then
  1087.                 Tsxx = "该单据已结帐,不能修改或删除!"
  1088.                 Call Xtxxts(Tsxx, 0, 4)
  1089.                 Exit Function
  1090.             End If
  1091.             If Trim(.Fields("ChalkitupMan") & "") <> "" Then
  1092.                 Tsxx = "该单据在物料核算系统已经记帐,不能修改或删除!"
  1093.                 Call Xtxxts(Tsxx, 0, 4)
  1094.                 Exit Function
  1095.             End If
  1096.         End If
  1097.     End With
  1099.     Fun_AllowDelete = True
  1100.   
  1101. End Function
  1103. Private Sub bbyl(bbylte As Boolean)                    '报表打印预览
  1104.     
  1105.     Dim Bbzbt$, Bbxbt() As String, bbxbtzzxs() As Integer, Bbxbtgs As Integer
  1106.     Dim Bbbwh() As String, Bbbwhzzxs() As Integer, Bbbwhgs As Integer
  1107.     Bbxbtgs = 1                                          '报 表 小 标 题 行 数
  1108.     Bbbwhgs = 0                                          '报 表 表 尾 行 数
  1109.     ReDim Bbxbt(1 To Bbxbtgs)
  1110.     ReDim bbxbtzzxs(1 To Bbxbtgs)
  1111.     If Bbbwhgs <> 0 Then
  1112.         ReDim Bbbwh(1 To Bbbwhgs)
  1113.         ReDim Bbbwhzzxs(1 To Bbbwhgs)
  1114.     End If
  1115.     Bbzbt = ReportTitle
  1116.     Bbxbt(1) = ""
  1117.     bbxbtzzxs(1) = 0                                     '报表行组织形式(0-居左 1-居中 2-居右)
  1118.     Call Scyxsjb(CxbbGrid)                               '生成报表数据
  1119.     Call Scdybb(Dyymctbl, Bbzbt, Bbxbt(), bbxbtzzxs(), Bbxbtgs, Bbbwh(), Bbbwhzzxs(), Bbbwhgs, bbylte)
  1120.     If Not bbylte Then
  1121.         Unload DY_Tybbyldy
  1122.     End If
  1124. End Sub