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

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

企业管理

开发平台：

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 CL_MakeVoucher 
  5.    Caption         =   "生成凭证"
  6.    ClientHeight    =   6690
  7.    ClientLeft      =   60
  8.    ClientTop       =   345
  9.    ClientWidth     =   10065
  10.    HelpContextID   =   130407
  11.    Icon            =   "处理_生成凭证.frx":0000
  12.    LinkTopic       =   "Form2"
  13.    MDIChild        =   -1  'True
  14.    ScaleHeight     =   6690
  15.    ScaleWidth      =   10065
  16.    Begin VB.PictureBox Pic_Title 
  17.       BackColor       =   &H00FFFFFF&
  18.       Height          =   1035
  19.       Left            =   0
  20.       Picture         =   "处理_生成凭证.frx":1042
  21.       ScaleHeight     =   975
  22.       ScaleWidth      =   11715
  23.       TabIndex        =   4
  24.       Top             =   570
  25.       Width           =   11775
  26.       Begin VB.Label Lab_Title 
  27.          AutoSize        =   -1  'True
  28.          BackColor       =   &H80000018&
  29.          BackStyle       =   0  'Transparent
  30.          Caption         =   "单据列表"
  31.          BeginProperty Font 
  32.             Name            =   "宋体"
  33.             Size            =   12
  34.             Charset         =   134
  35.             Weight          =   700
  36.             Underline       =   0   'False
  37.             Italic          =   0   'False
  38.             Strikethrough   =   0   'False
  39.          EndProperty
  40.          ForeColor       =   &H00000000&
  41.          Height          =   240
  42.          Index           =   4
  43.          Left            =   480
  44.          TabIndex        =   7
  45.          Top             =   210
  46.          Width           =   1020
  47.       End
  48.       Begin VB.Label Lbl_TitleMess 
  49.          AutoSize        =   -1  'True
  50.          BackStyle       =   0  'Transparent
  51.          Caption         =   "月份:"
  52.          Height          =   195
  53.          Index           =   0
  54.          Left            =   750
  55.          TabIndex        =   6
  56.          Top             =   750
  57.          Width           =   405
  58.       End
  59.       Begin VB.Label Lbl_TitleText 
  60.          AutoSize        =   -1  'True
  61.          BackStyle       =   0  'Transparent
  62.          Caption         =   "仓库"
  63.          ForeColor       =   &H00000000&
  64.          Height          =   195
  65.          Index           =   0
  66.          Left            =   1260
  67.          TabIndex        =   5
  68.          Top             =   750
  69.          Width           =   360
  70.       End
  71.    End
  72.    Begin VB.Timer Timer1 
  73.       Enabled         =   0   'False
  74.       Interval        =   1
  75.       Left            =   510
  76.       Top             =   510
  77.    End
  78.    Begin VB.Timer Timer2 
  79.       Interval        =   1
  80.       Left            =   990
  81.       Top             =   510
  82.    End
  83.    Begin VSFlex8Ctl.VSFlexGrid CxbbGrid 
  84.       Height          =   4965
  85.       Left            =   90
  86.       TabIndex        =   0
  87.       Top             =   1800
  88.       Width           =   9885
  89.       _cx             =   5080
  90.       _cy             =   5080
  91.       Appearance      =   1
  92.       BorderStyle     =   1
  93.       Enabled         =   -1  'True
  94.       BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
  95.          Name            =   "MS Sans Serif"
  96.          Size            =   8.25
  97.          Charset         =   0
  98.          Weight          =   400
  99.          Underline       =   0   'False
  100.          Italic          =   0   'False
  101.          Strikethrough   =   0   'False
  102.       EndProperty
  103.       MousePointer    =   0
  104.       BackColor       =   -2147483643
  105.       ForeColor       =   -2147483640
  106.       BackColorFixed  =   -2147483633
  107.       ForeColorFixed  =   -2147483630
  108.       BackColorSel    =   -2147483635
  109.       ForeColorSel    =   -2147483634
  110.       BackColorBkg    =   -2147483636
  111.       BackColorAlternate=   -2147483643
  112.       GridColor       =   -2147483633
  113.       GridColorFixed  =   -2147483632
  114.       TreeColor       =   -2147483632
  115.       FloodColor      =   192
  116.       SheetBorder     =   -2147483642
  117.       FocusRect       =   1
  118.       HighLight       =   1
  119.       AllowSelection  =   -1  'True
  120.       AllowBigSelection=   -1  'True
  121.       AllowUserResizing=   0
  122.       SelectionMode   =   0
  123.       GridLines       =   1
  124.       GridLinesFixed  =   2
  125.       GridLineWidth   =   1
  126.       Rows            =   50
  127.       Cols            =   10
  128.       FixedRows       =   1
  129.       FixedCols       =   1
  130.       RowHeightMin    =   0
  131.       RowHeightMax    =   0
  132.       ColWidthMin     =   0
  133.       ColWidthMax     =   0
  134.       ExtendLastCol   =   0   'False
  135.       FormatString    =   ""
  136.       ScrollTrack     =   0   'False
  137.       ScrollBars      =   3
  138.       ScrollTips      =   0   'False
  139.       MergeCells      =   0
  140.       MergeCompare    =   0
  141.       AutoResize      =   -1  'True
  142.       AutoSizeMode    =   0
  143.       AutoSearch      =   0
  144.       AutoSearchDelay =   2
  145.       MultiTotals     =   -1  'True
  146.       SubtotalPosition=   1
  147.       OutlineBar      =   0
  148.       OutlineCol      =   0
  149.       Ellipsis        =   0
  150.       ExplorerBar     =   0
  151.       PicturesOver    =   0   'False
  152.       FillStyle       =   0
  153.       RightToLeft     =   0   'False
  154.       PictureType     =   0
  155.       TabBehavior     =   0
  156.       OwnerDraw       =   0
  157.       Editable        =   0
  158.       ShowComboButton =   1
  159.       WordWrap        =   0   'False
  160.       TextStyle       =   0
  161.       TextStyleFixed  =   0
  162.       OleDragMode     =   0
  163.       OleDropMode     =   0
  164.       DataMode        =   0
  165.       VirtualData     =   -1  'True
  166.       DataMember      =   ""
  167.       ComboSearch     =   3
  168.       AutoSizeMouse   =   -1  'True
  169.       FrozenRows      =   0
  170.       FrozenCols      =   0
  171.       AllowUserFreezing=   0
  172.       BackColorFrozen =   0
  173.       ForeColorFrozen =   0
  174.       WallPaperAlignment=   9
  175.       AccessibleName  =   ""
  176.       AccessibleDescription=   ""
  177.       AccessibleValue =   ""
  178.       AccessibleRole  =   24
  179.    End
  180.    Begin MSComctlLib.Toolbar SzToolbar 
  181.       Align           =   1  'Align Top
  182.       Height          =   555
  183.       Left            =   0
  184.       TabIndex        =   1
  185.       Top             =   0
  186.       Width           =   10065
  187.       _ExtentX        =   17754
  188.       _ExtentY        =   979
  189.       ButtonWidth     =   820
  190.       ButtonHeight    =   926
  191.       AllowCustomize  =   0   'False
  192.       Appearance      =   1
  193.       Style           =   1
  194.       ImageList       =   "ImageList1"
  195.       _Version        =   393216
  196.       BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
  197.          NumButtons      =   20
  198.          BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  199.             Caption         =   "设置"
  200.             Key             =   "ymsz"
  201.             ImageKey        =   "sz"
  202.          EndProperty
  203.          BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  204.             Caption         =   "打印"
  205.             Key             =   "dy"
  206.             ImageKey        =   "dy"
  207.          EndProperty
  208.          BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  209.             Caption         =   "预览"
  210.             Key             =   "yl"
  211.             ImageKey        =   "yl"
  212.          EndProperty
  213.          BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  214.             Style           =   3
  215.          EndProperty
  216.          BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  217.             Caption         =   "单据"
  218.             Key             =   "dj"
  219.             ImageKey        =   "dj"
  220.          EndProperty
  221.          BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  222.             Style           =   4
  223.          EndProperty
  224.          BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  225.             Caption         =   "查询"
  226.             Key             =   "cx"
  227.             ImageKey        =   "cx"
  228.          EndProperty
  229.          BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  230.             Style           =   4
  231.          EndProperty
  232.          BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  233.             Caption         =   "全选"
  234.             Key             =   "qx"
  235.             ImageKey        =   "qx"
  236.          EndProperty
  237.          BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  238.             Caption         =   "全消"
  239.             Key             =   "qxi"
  240.             ImageKey        =   "qxi"
  241.          EndProperty
  242.          BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  243.             Style           =   3
  244.          EndProperty
  245.          BeginProperty Button12 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  246.             Caption         =   "生成"
  247.             Key             =   "shc"
  248.             ImageKey        =   "shc"
  249.          EndProperty
  250.          BeginProperty Button13 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  251.             Caption         =   "合成"
  252.             Key             =   "hc"
  253.             ImageKey        =   "hc"
  254.          EndProperty
  255.          BeginProperty Button14 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  256.             Style           =   3
  257.          EndProperty
  258.          BeginProperty Button15 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  259.             Caption         =   "修改"
  260.             Key             =   "xg"
  261.             ImageKey        =   "xg"
  262.          EndProperty
  263.          BeginProperty Button16 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  264.             Caption         =   "删除"
  265.             Key             =   "sc"
  266.             ImageKey        =   "sc"
  267.          EndProperty
  268.          BeginProperty Button17 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  269.             Caption         =   "凭证"
  270.             Key             =   "pz"
  271.             ImageKey        =   "pz"
  272.          EndProperty
  273.          BeginProperty Button18 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  274.             Style           =   3
  275.          EndProperty
  276.          BeginProperty Button19 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  277.             Caption         =   "帮助"
  278.             Key             =   "bz"
  279.             ImageKey        =   "bz"
  280.          EndProperty
  281.          BeginProperty Button20 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  282.             Caption         =   "退出"
  283.             Key             =   "fh"
  284.             ImageKey        =   "tc"
  285.          EndProperty
  286.       EndProperty
  287.       BorderStyle     =   1
  288.       Begin MSComctlLib.Toolbar GsToolbar 
  289.          Height          =   525
  290.          Left            =   7560
  291.          TabIndex        =   3
  292.          Top             =   0
  293.          Width           =   2475
  294.          _ExtentX        =   4366
  295.          _ExtentY        =   926
  296.          ButtonWidth     =   1455
  297.          ButtonHeight    =   926
  298.          Appearance      =   1
  299.          Style           =   1
  300.          ImageList       =   "ImageList1"
  301.          _Version        =   393216
  302.          BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
  303.             NumButtons      =   3
  304.             BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  305.                Caption         =   "保存格式"
  306.                Key             =   "bcgs"
  307.                ImageKey        =   "bcgs"
  308.             EndProperty
  309.             BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  310.                Caption         =   "默认列宽"
  311.                Key             =   "hfmrgs"
  312.                ImageKey        =   "mrlk"
  313.             EndProperty
  314.             BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
  315.                Caption         =   "显示项目"
  316.                Key             =   "szxsxm"
  317.                ImageKey        =   "xsxm"
  318.             EndProperty
  319.          EndProperty
  320.       End
  321.       Begin VB.Timer Timer3 
  322.          Enabled         =   0   'False
  323.          Left            =   30
  324.          Top             =   510
  325.       End
  326.    End
  327.    Begin MSComctlLib.ImageList ImageList1 
  328.       Left            =   9090
  329.       Top             =   30
  330.       _ExtentX        =   1005
  331.       _ExtentY        =   1005
  332.       BackColor       =   -2147483643
  333.       ImageWidth      =   16
  334.       ImageHeight     =   16
  335.       MaskColor       =   12632256
  336.       _Version        =   393216
  337.       BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
  338.          NumListImages   =   24
  339.          BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  340.             Picture         =   "处理_生成凭证.frx":35106
  341.             Key             =   "sz"
  342.          EndProperty
  343.          BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  344.             Picture         =   "处理_生成凭证.frx":354A0
  345.             Key             =   "qx"
  346.          EndProperty
  347.          BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  348.             Picture         =   "处理_生成凭证.frx":3583A
  349.             Key             =   "qxi"
  350.          EndProperty
  351.          BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  352.             Picture         =   "处理_生成凭证.frx":35BD4
  353.             Key             =   "pz"
  354.          EndProperty
  355.          BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  356.             Picture         =   "处理_生成凭证.frx":35F6E
  357.             Key             =   "hc"
  358.          EndProperty
  359.          BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  360.             Picture         =   "处理_生成凭证.frx":36308
  361.             Key             =   "dy"
  362.          EndProperty
  363.          BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  364.             Picture         =   "处理_生成凭证.frx":366A2
  365.             Key             =   "yl"
  366.          EndProperty
  367.          BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  368.             Picture         =   "处理_生成凭证.frx":36A3C
  369.             Key             =   "cx"
  370.          EndProperty
  371.          BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  372.             Picture         =   "处理_生成凭证.frx":36DD6
  373.             Key             =   "dj"
  374.          EndProperty
  375.          BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  376.             Picture         =   "处理_生成凭证.frx":37170
  377.             Key             =   "sx"
  378.          EndProperty
  379.          BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  380.             Picture         =   "处理_生成凭证.frx":3750A
  381.             Key             =   "first"
  382.          EndProperty
  383.          BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  384.             Picture         =   "处理_生成凭证.frx":378A4
  385.             Key             =   "prev"
  386.          EndProperty
  387.          BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  388.             Picture         =   "处理_生成凭证.frx":37C3E
  389.             Key             =   "next"
  390.          EndProperty
  391.          BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  392.             Picture         =   "处理_生成凭证.frx":37FD8
  393.             Key             =   "last"
  394.          EndProperty
  395.          BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  396.             Picture         =   "处理_生成凭证.frx":38372
  397.             Key             =   "bz"
  398.          EndProperty
  399.          BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  400.             Picture         =   "处理_生成凭证.frx":3870C
  401.             Key             =   "tc"
  402.          EndProperty
  403.          BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  404.             Picture         =   "处理_生成凭证.frx":38AA6
  405.             Key             =   "bcgs"
  406.          EndProperty
  407.          BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  408.             Picture         =   "处理_生成凭证.frx":38E40
  409.             Key             =   "mrlk"
  410.          EndProperty
  411.          BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  412.             Picture         =   "处理_生成凭证.frx":391DA
  413.             Key             =   "xsxm"
  414.          EndProperty
  415.          BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  416.             Picture         =   "处理_生成凭证.frx":39574
  417.             Key             =   "check"
  418.          EndProperty
  419.          BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  420.             Picture         =   "处理_生成凭证.frx":3990E
  421.             Key             =   "xz"
  422.          EndProperty
  423.          BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  424.             Picture         =   "处理_生成凭证.frx":39CA8
  425.             Key             =   "xg"
  426.          EndProperty
  427.          BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  428.             Picture         =   "处理_生成凭证.frx":3A042
  429.             Key             =   "sc"
  430.          EndProperty
  431.          BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628} 
  432.             Picture         =   "处理_生成凭证.frx":3A3DC
  433.             Key             =   "shc"
  434.          EndProperty
  435.       EndProperty
  436.    End
  437.    Begin VB.Label DdtsLabel 
  438.       AutoSize        =   -1  'True
  439.       BackColor       =   &H00C0C0C0&
  440.       BackStyle       =   0  'Transparent
  441.       Caption         =   "正在调入数据,请稍等..."
  442.       BeginProperty Font 
  443.          Name            =   "宋体"
  444.          Size            =   10.5
  445.          Charset         =   134
  446.          Weight          =   400
  447.          Underline       =   0   'False
  448.          Italic          =   0   'False
  449.          Strikethrough   =   0   'False
  450.       EndProperty
  451.       ForeColor       =   &H000000FF&
  452.       Height          =   210
  453.       Left            =   960
  454.       TabIndex        =   2
  455.       Top             =   960
  456.       Visible         =   0   'False
  457.       Width           =   2550
  458.    End
  459. End
  460. Attribute VB_Name = "CL_MakeVoucher"
  461. Attribute VB_GlobalNameSpace = False
  462. Attribute VB_Creatable = False
  463. Attribute VB_PredeclaredId = True
  464. Attribute VB_Exposed = False
  465. '**************************************************************************
  466. '*    模 块 名 称 :生成凭证列表
  467. '*    功 能 描 述 :
  468. '*    程序员姓名  :杨波
  469. '*    最后修改人  :杨波
  470. '*    最后修改时间:2001/12/18
  471. '*    备        注:程序中所有依实际情况自定义部分均用[>>  <<]括起
  472. '**************************************************************************
  473. Dim ReportTitle As String                '报表主标题
  474. Dim Str_QueryCondi As String             '用户录入查询条件
  475. Dim Rec_BillID As New ADODB.Recordset    '用户查询单据ID动态集
  477. '以下为固定使用变量
  478. Dim Dyymctbl As New DY_Dyymsz            '打印页面窗体变量
  479. Dim GridCode As String                   '显示网格网格代码
  480. Dim GridInf() As Variant                 '整个网格设置信息
  481. Dim Tsxx As String                       '系统提示信息
  482. Dim Qslz As Long                         '网格隐藏(非操作显示)列数
  483. Dim Sjhgd As Double                      '网格数据行高度
  484. Dim Sfxshjwg As Boolean                  '是否显示合计网格
  485. Dim GridBoolean() As Boolean             '网格列信息(布尔型)
  486. Dim GridStr()  As String                 '网格列信息(字符型)
  487. Dim GridInt() As Integer                 '网格列信息(整型)
  488. Dim Szzls As Integer                     '数组总列数(网格列数-1)
  490. Dim MListId As String                    '生成凭证单据的ID号条件集
  491. Dim MPzType As Integer                   '0为生成，1为合并生成
  494. Private Sub Form_Resize()                '根据窗体大小来调整网格,标题栏大小(Fixed)
  495.     
  496.     On Error Resume Next
  497.     With CxbbGrid
  498.         .Width = Me.Width - 160
  499.         .Height = Me.Height - .Top - 400
  500.     End With
  501.     With Pic_Title
  502.         .Width = Me.Width - 160
  503.     End With
  504.   
  505.     GsToolbar.Left = Me.Width - GsToolbar.Width - 160
  506.     
  507. End Sub
  509. Private Sub Form_Load()                                                   '窗体装入
  510.     
  511.     '调入打印页面设置窗体
  512.     If CL_MakeVoucherFind.Opti_bill1.Value = True Then
  513.         ReportTitle = "单据列表"
  514.     Else
  515.         ReportTitle = "凭证列表"
  516.     End If
  517.     XtReportCode = "Chhs_MakeVoucher"
  518.     Load Dyymctbl
  519.     
  520.     '调整标题栏及网格、格式工具条位置(Fixed)
  521.     Pic_Title.Left = 40
  522.     Pic_Title.Top = SzToolbar.Top + SzToolbar.Height - 10
  523.     CxbbGrid.Left = Pic_Title.Left
  524.     CxbbGrid.Top = Pic_Title.Top + Pic_Title.Height + 20
  525.     
  526.     '调 入 网 格(Fixed)
  527.     GridCode = "Chhs_MakeVoucher"
  528.     Call BzWgcsh(CxbbGrid, GridCode, GridInf(), GridBoolean(), GridInt(), GridStr())
  529.     
  530.     Qslz = GridInf(1)
  531.     Sjhgd = GridInf(2)
  532.     Sfxshjwg = GridInf(7)
  533.     Szzls = CxbbGrid.Cols - 1
  534.     
  535.     Lbl_TitleText(0) = CStr(Xtyear) + "." + CStr(PGNowmon)
  536.     
  537. End Sub
  539. Private Sub Form_Unload(Cancel As Integer)                                  '窗体卸载
  540.     
  541.     '卸载条件窗体
  542.     CL_MakeVoucherFind.UnloadCheck.Value = 1
  543.     Unload CL_MakeVoucherFind
  544.     
  545.     '卸载打印页面设置窗体
  546.     Unload Dyymctbl
  547.     
  548. End Sub
  550. Private Sub CxbbGrid_BeforeMoveColumn(ByVal Col As Long, Position As Long)           '网格列发生移动时自动交换网格索引信息
  551.     
  552.     Call FnBln_RefreshArray(Col, Position, GridStr(), GridInf())
  553.     
  554. End Sub
  556. Private Sub GsToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)                '网格格式调整(Fixed)
  557.     
  558.     Select Case Button.Key
  559.     Case "bcgs"                                          '保存表格格式
  560.         Call Bcwggs(CxbbGrid, GridCode, GridStr())
  561.     Case "hfmrgs"                                        '恢复默认格式
  562.         Call Hfmrgs(CxbbGrid, GridCode, GridStr())
  563.     Case "szxsxm"                                        '设置显示项目
  564.         Call Szxsxm(CxbbGrid, GridCode)
  565.     End Select
  566.     
  567. End Sub
  571. Private Sub SzToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)
  572.     
  573.     Dim count As Integer
  574.     Dim countsub As Integer
  575.     Dim IsInType As Boolean
  576.     Dim IsOutType As Boolean
  577.     Dim IsType As Boolean
  578.     Dim Rectemp As New ADODB.Recordset
  579.     
  580.     Select Case Button.Key
  581.         
  582.         Case "ymsz"                                          '页面设置
  583.             Dyymctbl.Show 1
  584.         Case "yl"                                            '预 览
  585.             Call bbyl(True)
  586.         Case "dy"                                            '打 印
  587.             Call bbyl(False)
  588.         Case "shc"                                           '生成
  589.             MListId = ""
  590.             MPzType = 0
  591.             Call MakePz
  592.         Case "hc"                                            '合成
  593.             MListId = ""
  594.             MPzType = 1
  596.             For count = CxbbGrid.FixedRows To CxbbGrid.Rows - CxbbGrid.FixedRows
  597.                 If CxbbGrid.TextMatrix(count, Sydz("001", GridStr(), Szzls)) Then
  598.                     For countsub = CxbbGrid.FixedRows To CxbbGrid.Rows - CxbbGrid.FixedRows
  599.                         If CxbbGrid.TextMatrix(countsub, Sydz("001", GridStr(), Szzls)) Then
  600.                             If CxbbGrid.TextMatrix(count, 7) = CxbbGrid.TextMatrix(countsub, 7) Then
  601.                                 IsType = False
  602.                             Else
  603.                                 IsType = True
  604.                                 Exit For
  605.                             End If
  606.                         End If
  607.                     Next countsub
  608.                     If IsType Then
  609.                         Exit For
  610.                     End If
  611.                 End If
  612.             Next count
  614.             If IsType Then
  615.                 Tsxx = "出、入库单据不能合并生成"
  616.                 Call Xtxxts(Tsxx, 0, 4)
  617.             Else
  618.                 Call MakePz
  619.             End If
  620.             
  621.         Case "qx"                                            '全选
  622.             For count = CxbbGrid.FixedRows To CxbbGrid.Rows - CxbbGrid.FixedRows
  623.                 CxbbGrid.TextMatrix(count, Sydz("001", GridStr(), Szzls)) = 1
  624.             Next
  625.             
  626.         Case "qxi"                                           '全消
  627.             For count = CxbbGrid.FixedRows To CxbbGrid.Rows - CxbbGrid.FixedRows
  628.                 CxbbGrid.TextMatrix(count, Sydz("001", GridStr(), Szzls)) = 0
  629.             Next
  630.             
  631.         Case "dj"                                             '显示单据
  632.         
  633.             If CxbbGrid.Rows <> CxbbGrid.FixedRows Then
  634.                 Call ShowBill
  635.             End If
  636.             
  637.         Case "sc"
  638.             Call Sub_DelVouch
  639.         Case "xg"
  640.             If CxbbGrid.Rows = CxbbGrid.FixedRows Then
  641.                 Exit Sub
  642.             End If
  643.             CL_PzFrm.Timer1.Enabled = True
  644.             CL_PzFrm.lbl_Tag = "3"
  645.             CL_PzFrm.Lab_VouchId = Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 10))
  646.             CL_PzFrm.Show 1
  647.         Case "pz"
  648.             If CxbbGrid.Rows = CxbbGrid.FixedRows Then
  649.                 Exit Sub
  650.             End If
  651.             
  652.             Set Rectemp = Cw_DataEnvi.DataConnect.Execute("Select vouchid from chhs_list where VouchId=" & Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 10)) & "")
  653.             If Rectemp.EOF Then
  654.                 Tsxx = "此凭证已被其他用户删除!"
  655.                 Call Xtxxts(Tsxx, 0, 4)
  656.                 Exit Sub
  657.             End If
  658.             
  659.             CL_PzFrm.Timer1.Enabled = True
  660.             CL_PzFrm.lbl_Tag = "2"
  661.             CL_PzFrm.Lab_VouchId = Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 10))
  662.             CL_PzFrm.Show 1
  663.             
  664.         Case "cx"                                             '查询
  665.             CL_MakeVoucherFind.Show 1
  666.         Case "bz"                                             '帮 助
  667.             Call F1bz
  668.         Case "fh"                                             '退 出
  669.             Unload Me
  670.     End Select
  671.     
  672. End Sub
  674. Private Sub Timer1_Timer()                                 '在窗体激活后调入查询程序
  675.     
  676.     Timer1.Enabled = False
  677.     Xt_Wait.Show
  678.     Xt_Wait.Refresh
  679.     
  680.     '加快显示速度
  681.     CxbbGrid.Redraw = False
  682.     
  683.     '生成查询结果
  684.     Call Sub_Query
  685.     
  686.     CxbbGrid.Redraw = True
  687.     
  688.     Xt_Wait.Hide
  689.     
  690. End Sub
  692. Private Sub Sub_Query()                                     '生成查询结果(Define)
  693.     
  694.     Dim Rec_Query As New ADODB.Recordset        '查询结果动态集
  695.     Dim Str_QueryCondi As String                '用户录入查询条件
  696.     Dim SqlStr As String                        '查询字符串
  697.     Dim Coljsq As Long                          '网格列计数器
  698.     Dim Jsqte As Integer                        '临时动态计数器
  699.     Dim VouchNoValue As String                  '记录上一张凭证标识
  700.     Dim count As Integer
  701.     Dim billtype_flag As Boolean
  702.     
  703.     Dim BillNumValue As String
  704.     Dim WhNameValue As String
  705.     Dim BillNameValue As String
  706.  
  707.     '以下为用户自定义部分[
  709.     With CL_MakeVoucherFind
  710.         
  711.         If CL_MakeVoucherFind.Opti_bill1.Value Then
  712.             Str_QueryCondi = "SELECT * FROM Chhs_V_List LEFT OUTER JOIN Gy_Whlimit ON Chhs_V_List.WhCode = Gy_Whlimit.WhCode WHERE Gy_Whlimit.Czybm='" & Xtczybm & "' AND Vouchid=0 AND KjYear='" & PGKjYear & "' AND Period='" & PGNowmon & "' AND StartFlag<>1 "
  713.             CxbbGrid.ColHidden(Sydz("001", GridStr(), Szzls)) = False
  714.             Call Sub_OperStatus("0")
  715.         Else
  716.             If CL_MakeVoucherFind.Opti_bill2.Value Then
  717.                 Str_QueryCondi = "SELECT * FROM Chhs_V_List LEFT OUTER JOIN Gy_Whlimit ON Chhs_V_List.WhCode = Gy_Whlimit.WhCode WHERE Gy_Whlimit.Czybm='" & Xtczybm & "' AND Vouchid<>0 AND KjYear='" & PGKjYear & "' AND Period='" & PGNowmon & "'"
  718.                 CxbbGrid.ColHidden(Sydz("001", GridStr(), Szzls)) = True
  719.                 Call Sub_OperStatus("1")
  720.             End If
  721.         End If
  722.         
  723.         For Jsqte = 1 To 8
  724.             
  725.             Select Case Jsqte
  726.                 
  727.                 Case 1    '仓库
  728.                     If Trim(.LrText(0).Text) <> "" Then
  729.                         Str_QueryCondi = Str_QueryCondi & " AND Chhs_V_List.WhCode='" & Trim(.LrText(0).Tag) & "'"
  730.                     End If
  731.                     
  732.                 Case 2    '存货分类
  733.                     If Trim(.LrText(1).Text) <> "" Then
  734.                         Str_QueryCondi = Str_QueryCondi & " AND InvSortcode like '" & Trim(.LrText(1).Tag) & "%'"
  735.                     End If
  736.                     
  737.                 Case 3    '存货编码
  738.                     If Trim(.LrText(2).Text) <> "" Then
  739.                         Str_QueryCondi = Str_QueryCondi & " AND MNumber ='" & Trim(.LrText(2).Text) & "'"
  740.                     End If
  741.                     
  742.                 Case 4    '日期
  743.                     If Trim(.LrText(3).Text) <> "" Then
  744.                         Str_QueryCondi = Str_QueryCondi & " And Chhs_V_List.BillDate>=' " & Trim(.LrText(3).Text) & "'"
  745.                     End If
  746.                 Case 5    '日期
  747.                     If Trim(.LrText(4).Text) <> "" Then
  748.                         Str_QueryCondi = Str_QueryCondi & " And Chhs_V_List.BillDate<=' " & Trim(.LrText(4).Text) & "'"
  749.                     End If
  750.                     
  751.                 Case 6    '部门
  752.                     If Trim(.LrText(5).Text) <> "" Then
  753.                         Str_QueryCondi = Str_QueryCondi & " AND DeptCode='" & Trim(.LrText(5).Tag) & "'"
  754.                     End If
  755.                     
  756.                 Case 7   '记帐人
  757.                     If Trim(.LrText(6).Text) <> "" Then
  758.                         Str_QueryCondi = Str_QueryCondi & " AND ChalkitupMan='" & Trim(.LrText(6).Text) & "'"
  759.                     End If
  760.                 
  761.                 Case 8
  762.                     Str_QueryCondi = Str_QueryCondi + CL_MakeVoucherFind.SqlStr
  763.                     
  764.             End Select
  765.             
  766.         Next Jsqte
  767.         
  768.         Str_QueryCondi = Str_QueryCondi + " ORDER BY BiLLCode+Chhs_V_List.WhCode+BillNum"
  769.         
  770.     End With
  772.     Set Rec_Query = Cw_DataEnvi.DataConnect.Execute(Str_QueryCondi)
  773.     
  774.     With Rec_Query
  775.     
  776.         CxbbGrid.Rows = CxbbGrid.FixedRows
  777.         Jsqte = CxbbGrid.FixedRows
  778.         
  779.         Do While Not .EOF
  780.         
  781.             If CL_MakeVoucherFind.Opti_bill1.Value Then
  782.             
  783.                 BillNumValue = Trim(CxbbGrid.TextMatrix(Jsqte - 1, Sydz("002", GridStr(), Szzls)))
  784.                 WhNameValue = Trim(CxbbGrid.TextMatrix(Jsqte - 1, Sydz("005", GridStr(), Szzls)))
  785.                 BillNameValue = Trim(CxbbGrid.TextMatrix(Jsqte - 1, Sydz("009", GridStr(), Szzls)))
  786.                 
  787.                 If Not (BillNumValue = Trim(.Fields("BillNum")) And WhNameValue = Trim(.Fields("WhName")) And BillNameValue = Trim(.Fields("BillName"))) Then
  788.                     
  789.                     If Jsqte >= CxbbGrid.Rows Then
  790.                         CxbbGrid.AddItem ""
  791.                     End If
  792.                  
  793.                     CxbbGrid.TextMatrix(Jsqte, 1) = Val(.Fields("ListID"))                  '单据ID
  794.                     CxbbGrid.TextMatrix(Jsqte, 2) = Val(.Fields("InoutSubId"))              '收发记录子表ID
  795.                     CxbbGrid.TextMatrix(Jsqte, 3) = Trim(.Fields("WhCode"))                 '仓库编码
  796.                     CxbbGrid.TextMatrix(Jsqte, 4) = Val(.Fields("InoutAdjustSubId"))        '调整单子表ID
  797.     '                CxbbGrid.TextMatrix(Jsqte, 5) = Val(.Fields("receipt_id"))             '材料入库单子表ID
  798.                     CxbbGrid.TextMatrix(Jsqte, 6) = Trim(.Fields("BillCode"))               '单据类型
  799.                     CxbbGrid.TextMatrix(Jsqte, 7) = Trim(.Fields("InoutFlag"))              '收发标志
  800.                     If Trim(.Fields("BillCode")) = "1307" Then
  801.                         CxbbGrid.TextMatrix(Jsqte, 8) = Trim(.Fields("ListId") & "")        '明细帐ID
  802.                     Else
  803.                         CxbbGrid.TextMatrix(Jsqte, 8) = Trim(.Fields("InoutMainId") & "")   '收发记录主表ID
  804.                     End If
  805.                     CxbbGrid.TextMatrix(Jsqte, 9) = Val(.Fields("InoutAdjustMainId"))       '调整单主表ID
  806.                     CxbbGrid.TextMatrix(Jsqte, 10) = Val(.Fields("vouchId"))                '凭证ID
  807.                         
  808.                     '如果为同一张凭证则不再输出制单日期和凭证号
  809.                     
  810.                     CxbbGrid.TextMatrix(Jsqte, Sydz("001", GridStr(), Szzls)) = 0                                     '选择
  811.                     CxbbGrid.TextMatrix(Jsqte, Sydz("002", GridStr(), Szzls)) = .Fields("BillNum")                    '单据号
  812.                     CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = Format(Trim(.Fields("ChalkDate") & ""), "yyyy-mm-dd")       '记帐日期
  813.                     CxbbGrid.TextMatrix(Jsqte, Sydz("004", GridStr(), Szzls)) = Format(Trim(.Fields("BillDate") & ""), "yyyy-mm-dd")        '单据日期
  814.                     CxbbGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = Trim(.Fields("WhName") & "")          '仓库
  815.                     CxbbGrid.TextMatrix(Jsqte, Sydz("006", GridStr(), Szzls)) = Trim(.Fields("ChalkitupMan") & "")    '记帐人
  816.                     CxbbGrid.TextMatrix(Jsqte, Sydz("007", GridStr(), Szzls)) = Trim(.Fields("InOutClassName") & "")  '收发类别
  817.                     If .Fields("vouchId") <> 0 Then
  818.                         CxbbGrid.TextMatrix(Jsqte, Sydz("008", GridStr(), Szzls)) = Mid(Trim(Str(10000 + .Fields("vouchNO"))), 2, 4)                '凭证号
  819.                     End If
  820.                     CxbbGrid.TextMatrix(Jsqte, Sydz("009", GridStr(), Szzls)) = Trim(.Fields("BillName"))             '单据类型
  821.                     
  822.                     CxbbGrid.RowHeight(Jsqte) = Sjhgd
  823.                     Jsqte = Jsqte + 1
  824.                 End If
  825.             Else
  826.                 BillNumValue = Trim(CxbbGrid.TextMatrix(Jsqte - 1, Sydz("002", GridStr(), Szzls)))
  827.                 VouchNoValue = Trim(CxbbGrid.TextMatrix(Jsqte - 1, Sydz("008", GridStr(), Szzls)))
  828.                 BillNameValue = Trim(CxbbGrid.TextMatrix(Jsqte - 1, Sydz("009", GridStr(), Szzls)))
  829.                 
  830.                 If Not (BillNumValue = Trim(.Fields("BillNum")) And Val(VouchNoValue) = Trim(.Fields("vouchNO")) And BillNameValue = Trim(.Fields("BillName"))) Then
  831.                     If Jsqte >= CxbbGrid.Rows Then
  832.                         CxbbGrid.AddItem ""
  833.                     End If
  834.                  
  835.                     CxbbGrid.TextMatrix(Jsqte, 1) = Val(.Fields("ListID"))                  '单据ID
  836.                     CxbbGrid.TextMatrix(Jsqte, 2) = Val(.Fields("InoutSubId"))              '收发记录子表ID
  837.                     CxbbGrid.TextMatrix(Jsqte, 3) = Trim(.Fields("WhCode"))                 '仓库编码
  838.                     CxbbGrid.TextMatrix(Jsqte, 4) = Val(.Fields("InoutAdjustSubId"))        '调整单子表ID
  839.     '                CxbbGrid.TextMatrix(Jsqte, 5) = Val(.Fields("receipt_id"))             '材料入库单子表ID
  840.                     CxbbGrid.TextMatrix(Jsqte, 6) = Trim(.Fields("BillCode"))               '单据类型
  841.                     CxbbGrid.TextMatrix(Jsqte, 7) = Trim(.Fields("InoutFlag"))              '收发标志
  842.                     If Trim(.Fields("BillCode")) = "1307" Then
  843.                         CxbbGrid.TextMatrix(Jsqte, 8) = Trim(.Fields("ListId") & "")        '明细帐ID
  844.                     Else
  845.                         CxbbGrid.TextMatrix(Jsqte, 8) = Trim(.Fields("InoutMainId") & "")   '收发记录主表ID
  846.                     End If
  847.                     CxbbGrid.TextMatrix(Jsqte, 9) = Val(.Fields("InoutAdjustMainId"))       '调整单主表ID
  848.                     CxbbGrid.TextMatrix(Jsqte, 10) = Val(.Fields("vouchId"))                '凭证ID
  849.                         
  850.                     '如果为同一张凭证则不再输出制单日期和凭证号
  851.                     
  852.                     CxbbGrid.TextMatrix(Jsqte, Sydz("001", GridStr(), Szzls)) = 0                                     '选择
  853.                     CxbbGrid.TextMatrix(Jsqte, Sydz("002", GridStr(), Szzls)) = .Fields("BillNum")                    '单据号
  854.                     CxbbGrid.TextMatrix(Jsqte, Sydz("003", GridStr(), Szzls)) = Format(Trim(.Fields("ChalkDate") & ""), "yyyy-mm-dd")       '记帐日期
  855.                     CxbbGrid.TextMatrix(Jsqte, Sydz("004", GridStr(), Szzls)) = Format(Trim(.Fields("BillDate") & ""), "yyyy-mm-dd")        '单据日期
  856.                     CxbbGrid.TextMatrix(Jsqte, Sydz("005", GridStr(), Szzls)) = Trim(.Fields("WhName") & "")          '仓库
  857.                     CxbbGrid.TextMatrix(Jsqte, Sydz("006", GridStr(), Szzls)) = Trim(.Fields("ChalkitupMan") & "")    '记帐人
  858.                     CxbbGrid.TextMatrix(Jsqte, Sydz("007", GridStr(), Szzls)) = Trim(.Fields("InOutClassName") & "")  '收发类别
  859.                     If .Fields("vouchId") <> 0 And Not IsNull(.Fields("vouchNO")) Then
  860.                         CxbbGrid.TextMatrix(Jsqte, Sydz("008", GridStr(), Szzls)) = Mid(Trim(Str(10000 + .Fields("vouchNO"))), 2, 4)                '凭证号
  861.                     End If
  862.                     CxbbGrid.TextMatrix(Jsqte, Sydz("009", GridStr(), Szzls)) = Trim(.Fields("BillName"))             '单据类型
  863.                     
  864.                     CxbbGrid.RowHeight(Jsqte) = Sjhgd
  865.                     Jsqte = Jsqte + 1
  866.                     
  867.                 End If
  868.             End If
  869.             
  870.             .MoveNext
  871.             
  872.         Loop
  873.         
  874.     End With
  875.     
  876.     ']以上为用户自定义部分
  877.     
  878. End Sub
  880. Private Sub CxbbGrid_DblClick()                                              '用户双击网格调入相应单据
  881.     
  882.     '非数据行退出
  883.     If CxbbGrid.Row < CxbbGrid.FixedRows Then
  884.         Exit Sub
  885.     End If
  886.     If CL_MakeVoucherFind.Opti_bill1 Then
  887.         If CxbbGrid.TextMatrix(CxbbGrid.Row, Sydz("001", GridStr(), Szzls)) Then
  888.             CxbbGrid.TextMatrix(CxbbGrid.Row, Sydz("001", GridStr(), Szzls)) = 0
  889.         Else
  890.             CxbbGrid.TextMatrix(CxbbGrid.Row, Sydz("001", GridStr(), Szzls)) = 1
  891.         End If
  892.     End If
  893.     
  894. End Sub
  896. Private Sub Sub_AddBill()                                              '新增单据
  897.     
  898.     With MS_FrmDjsDdlr
  899.         
  900.         '设置单据处理为填制单据状态
  901.         Xtcdcs = "1"
  902.         
  903.         .Show 1
  904.     End With
  905.     
  906.     If Xtfhcs = "1" Then
  907.         Tsxx = "销售订单发生变化,是否刷新销售订单列表?"
  908.         yhAnswer = Xtxxts(Tsxx, 2, 2)
  909.         If yhAnswer = 1 Then
  910.             Xt_Wait.Show
  911.             Xt_Wait.Refresh
  912.             
  913.             '加快显示速度
  914.             CxbbGrid.Redraw = False
  915.             
  916.             '生成查询结果
  917.             Call Sub_Query
  918.             
  919.             CxbbGrid.Redraw = True
  920.             Xt_Wait.Hide
  921.         End If
  922.     End If
  923.     
  924. End Sub
  926. Private Sub Sub_DeleteBill()                                            '删除选中当前销售订单
  927.     
  928.     Dim YAnswer As Integer
  929.     Dim Lng_BillID As Long           '单据标识
  930.     
  931.     '非数据行退出
  932.     If CxbbGrid.Row < CxbbGrid.FixedRows Or Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0)) = 0 Then
  933.         Exit Sub
  934.     End If
  935.     
  936.     Tsxx = "请确认是否删除当前销售订单?"
  937.     yhAnswer = Xtxxts(Tsxx, 2, 2)
  938.     
  939.     If yhAnswer = 1 Then
  940.         '1.判断当前销售订单是否允许删除
  941.         If Not Fun_AllowDelete Then
  942.             Exit Sub
  943.         End If
  944.         
  945.         '2.删除单据所有内容
  946.         Lng_BillID = Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0))
  947.         On Error GoTo Swcwcl
  948.         Cw_DataEnvi.DataConnect.BeginTrans
  949.         Cw_DataEnvi.DataConnect.Execute ("Delete XS_OrderBillMain Where OrderBillMainId=" & Lng_BillID)        '删除单据主表内容
  950.         Cw_DataEnvi.DataConnect.Execute ("Delete XS_OrderBillSub Where OrderBillMainId=" & Lng_BillID)         '删除单据子表内容
  951.         Cw_DataEnvi.DataConnect.CommitTrans
  952.         
  953.         '删除网格中单据数据
  954.         Jsqte = CxbbGrid.FixedRows
  955.         Do While Jsqte <= CxbbGrid.Rows - 1
  956.             If Val(CxbbGrid.TextMatrix(Jsqte, 0)) = Lng_BillID Then
  957.                 CxbbGrid.RemoveItem (CxbbGrid.Row)
  958.             Else
  959.                 Jsqte = Jsqte + 1
  960.             End If
  961.         Loop
  962.     Else
  963.         Exit Sub
  964.     End If
  965.     Exit Sub
  966. Swcwcl:
  967.     Cw_DataEnvi.DataConnect.RollbackTrans
  968.     Tsxx = "删除销售订单过程中出现未知错误,程序自动恢复删除前状态!"
  969.     Call Xtxxts(Tsxx, 0, 1)
  970.     Exit Sub
  971.     
  972. End Sub
  974. Private Function Fun_AllowDelete() As Boolean                                        '判断当前单据是否允许删除
  975.     
  976.     Dim Rectemp As New ADODB.Recordset     '临时使用动态集
  977.     Dim SqlStr As String                   '查询字符串
  978.     Dim Lng_BillID As Long                 '单据ID
  979.     
  980.     Lng_BillID = Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 0))
  981.     SqlStr = "Select Checker From XS_OrderBillMain Where OrderBillMainId=" & Lng_BillID
  982.     Set Rectemp = Cw_DataEnvi.DataConnect.Execute(SqlStr)
  983.     With Rectemp
  984.         If Not .EOF Then
  985.             If Trim(.Fields("Checker") & "") <> "" Then
  986.                 Tsxx = "该销售订单已审核确认,不能删除!"
  987.                 Call Xtxxts(Tsxx, 0, 4)
  988.                 Exit Function
  989.             End If
  990.         End If
  991.     End With
  992.     Fun_AllowDelete = True
  993.     
  994. End Function
  996. Private Sub bbyl(bbylte As Boolean)                    '报表打印预览
  997.     
  998.     Dim Bbzbt$, Bbxbt() As String, bbxbtzzxs() As Integer, Bbxbtgs As Integer
  999.     Dim Bbbwh() As String, Bbbwhzzxs() As Integer, Bbbwhgs As Integer
  1000.     Bbxbtgs = 1                                          '报 表 小 标 题 行 数
  1001.     Bbbwhgs = 0                                          '报 表 表 尾 行 数
  1002.     ReDim Bbxbt(1 To Bbxbtgs)
  1003.     ReDim bbxbtzzxs(1 To Bbxbtgs)
  1004.     If Bbbwhgs <> 0 Then
  1005.         ReDim Bbbwh(1 To Bbbwhgs)
  1006.         ReDim Bbbwhzzxs(1 To Bbbwhgs)
  1007.     End If
  1008.     Bbzbt = ReportTitle
  1009.     Bbxbt(1) = ""
  1010.     bbxbtzzxs(1) = 0                                     '报表行组织形式(0-居左 1-居中 2-居右)
  1011.     Call Scyxsjb(CxbbGrid)                               '生成报表数据
  1012.     Call Scdybb(Dyymctbl, Bbzbt, Bbxbt(), bbxbtzzxs(), Bbxbtgs, Bbbwh(), Bbbwhzzxs(), Bbbwhgs, bbylte)
  1013.     If Not bbylte Then
  1014.         Unload DY_Tybbyldy
  1015.     End If
  1016.     
  1017. End Sub
  1019. Private Sub Sub_OperStatus(Str_Status As String)
  1020.     
  1021.     Select Case Str_Status
  1022.         Case "0"
  1023.             SzToolbar.Buttons("qx").Enabled = True
  1024.             SzToolbar.Buttons("qxi").Enabled = True
  1025.             SzToolbar.Buttons("shc").Enabled = True
  1026.             SzToolbar.Buttons("hc").Enabled = True
  1027.             SzToolbar.Buttons("xg").Enabled = False
  1028.             SzToolbar.Buttons("sc").Enabled = False
  1029.             SzToolbar.Buttons("pz").Enabled = False
  1030.         
  1031.         Case "1"
  1032.             SzToolbar.Buttons("xg").Enabled = True
  1033.             SzToolbar.Buttons("sc").Enabled = True
  1034.             SzToolbar.Buttons("pz").Enabled = True
  1035.             SzToolbar.Buttons("qx").Enabled = False
  1036.             SzToolbar.Buttons("qxi").Enabled = False
  1037.             SzToolbar.Buttons("shc").Enabled = False
  1038.             SzToolbar.Buttons("hc").Enabled = False
  1039.             
  1040.     End Select
  1041.     
  1042. End Sub
  1044. Private Sub ShowBill()
  1046.     Dim Rectemp As New ADODB.Recordset
  1047.     Dim Load_Form As Form
  1048.     Dim BillCode As String
  1049.     Dim SqlStr As String
  1050.     
  1051.     If Trim(CxbbGrid.TextMatrix(CxbbGrid.Row, 8)) = "" Then
  1052.         Tsxx = "此单据已被其他用户删除!"
  1053.         Call Xtxxts(Tsxx, 0, 4)
  1054.         Exit Sub
  1055.     End If
  1057.     BillCode = Trim(CxbbGrid.TextMatrix(CxbbGrid.Row, 6))
  1058.     
  1059.     If BillCode = "1301" Or BillCode = "1302" Then
  1060.         SqlStr = "SELECT InOutAdjustMainId From Chhs_InOutAdjustMain Where InOutAdjustMainId=" & Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 9)) + 0
  1061.     ElseIf BillCode = "1303" Then
  1062.         SqlStr = "SELECT PlanAdjustMainId From Chhs_PlanAdjustMain Where PlanAdjustMainId=" & Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 9)) + 0
  1063.     ElseIf BillCode = "1307" Then
  1064.         SqlStr = "SELECT DiffBillId From Chhs_DiffBill Where whcode='" & Trim(CxbbGrid.TextMatrix(CxbbGrid.Row, 3)) & "'AND Chhs_DiffBill.KjYear=" & PGKjYear & ""
  1065.     Else
  1066.         SqlStr = "SELECT InOutMainId From Gy_InOutMain Where InOutMainId=" & Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 8)) + 0
  1067.     End If
  1068.     
  1069.     Set Rectemp = Cw_DataEnvi.DataConnect.Execute(SqlStr)
  1070.     If Rectemp.EOF Then
  1071.         Tsxx = "此单据已被其他用户删除!"
  1072.         Call Xtxxts(Tsxx, 0, 4)
  1073.         Exit Sub
  1074.     End If
  1075.         
  1077.     '根据单据类型和主表ID号显示单据
  1078.     Select Case BillCode
  1079.         
  1080.         Case "1212"      '材料入库单
  1081.             Set Load_Form = DJ_MateInBill
  1082.             
  1083.         Case "1202"      '产品入库单
  1084.             Set Load_Form = DJ_ProdInBill
  1085.           
  1086.         Case "1203"      '其它入库单
  1087.             Set Load_Form = DJ_OtherInBill
  1088.             
  1089.         Case "1204"      '材料出库单
  1090.             Set Load_Form = DJ_MateOutBill
  1091.         
  1092.         Case "1205"      '销售出库单
  1093.             Set Load_Form = DJ_SellOutBill
  1094.           
  1095.         Case "1206"      '其它出库单
  1096.             Set Load_Form = DJ_OtherOutBill
  1097.         
  1098.         Case "1301"      '入库单调整
  1099.             Set Load_Form = DJ_AdjustInbill
  1100.           
  1101.         Case "1302"      '出库单调整
  1102.             Set Load_Form = DJ_AdjustOutBill
  1103.             
  1104.         Case "1303"      '计划调整单
  1105.             Set Load_Form = DJ_AdjustPlan
  1106.             
  1107.         Case "1304"      '蓝字暂估单
  1108.             Set Load_Form = Eval_BlueBill
  1109.             Xtcdcsfz = "StartFlag=0 and Kjyear='" & PGKjYear & "' and Period='" & PGNowmon & "' "
  1110.             
  1111.         Case "1305"      '红字回冲单
  1112.             Set Load_Form = Eval_RedBill
  1113.             Xtcdcsfz = "StartFlag=0 and Kjyear='" & PGKjYear & "' and Period='" & PGNowmon & "' "
  1114.         
  1115.         Case "1307"      '差异结转单
  1116.             
  1117.             Set Load_Form = CL_DiscrepancyChange
  1118.             
  1119.         Case Else
  1120.             Exit Sub
  1121.     End Select
  1122.     
  1123.     Xtcdcs = "3"
  1124.     Select Case BillCode
  1125.         Case "1301", "1302", "1303"
  1126.             XT_BillID = CxbbGrid.TextMatrix(CxbbGrid.Row, 9)
  1127.             Xtcdcsfz = XT_BillID
  1128.         Case "1307"
  1129.             CL_DiscrepancyChange.lbl_Tstext(0) = CStr(PGKjYear) + "." + Str(PGNowmon)
  1130.             CL_DiscrepancyChange.lbl_Tstext(0).Tag = PGNowmon
  1131.             CL_DiscrepancyChange.Query_Cond = "Chhs_v_DiffBill.whcode='" & Trim(CxbbGrid.TextMatrix(CxbbGrid.Row, 3)) & "' AND Chhs_v_DiffBill.KjYear=" & PGKjYear
  1132.         Case Else
  1133.             XT_BillID = CxbbGrid.TextMatrix(CxbbGrid.Row, 8)
  1134.     End Select
  1135.     
  1136.     Load_Form.Show 1
  1137.     Set Load_Form = Nothing
  1139. End Sub
  1141. '生成凭证前进行判断
  1142. Private Sub MakePz()
  1144.     Dim count As Integer
  1146.     For count = CxbbGrid.FixedRows To CxbbGrid.Rows - CxbbGrid.FixedRows
  1147.         If CxbbGrid.TextMatrix(count, Sydz("001", GridStr(), Szzls)) Then
  1148.             If InStr(1, "1301,1302,1303,1304,1305", CxbbGrid.TextMatrix(count, 6)) = 0 And Val(CxbbGrid.TextMatrix(count, 8)) = 0 Then
  1149.                 Tsxx = "单据号为:" & CxbbGrid.TextMatrix(count, Sydz("002", GridStr(), Szzls)) & "  仓库为:" & CxbbGrid.TextMatrix(count, Sydz("005", GridStr(), Szzls)) & ",在收发记录中不存在"
  1150.                 Call Xtxxts(Tsxx, 0, 4)
  1151.                 Exit Sub
  1152.             End If
  1153.             If Trim(MListId) = "" Then
  1154.                 Select Case CxbbGrid.TextMatrix(count, 6)
  1155.                     Case "1301", "1302", "1303"
  1156.                         MListId = MListId + "InoutAdjustMainId= " & CxbbGrid.TextMatrix(count, 9) & ""
  1157.                     Case "1307"
  1158.                         MListId = MListId + "ListId= " & CxbbGrid.TextMatrix(count, 8) & ""
  1159.                     Case Else
  1160.                         MListId = MListId + "InoutMainId= " & CxbbGrid.TextMatrix(count, 8) & ""
  1161.                 End Select
  1162.             Else
  1163.                 Select Case CxbbGrid.TextMatrix(count, 6)
  1164.                     Case "1301", "1302", "1303"
  1165.                         MListId = MListId + " or InoutAdjustMainId= " & CxbbGrid.TextMatrix(count, 9) & ""
  1166.                     Case "1307"
  1167.                         MListId = MListId + " or ListId= " & CxbbGrid.TextMatrix(count, 8) & ""
  1168.                     Case Else
  1169.                         MListId = MListId + " or InoutMainId= " & CxbbGrid.TextMatrix(count, 8) & ""
  1170.                 End Select
  1171.             End If
  1172.         End If
  1173.     Next
  1174.     
  1175.     MListId = "(" & MListId & ")"
  1176.     
  1177.     If Trim(MListId) <> "()" Then
  1178.         CL_MakeVoucherSub.Show 1
  1179.     Else
  1180.         Tsxx = "请先选择要生成凭证的单据"
  1181.         Call Xtxxts(Tsxx, 0, 4)
  1182.     End If
  1184. End Sub
  1186. '删除凭证
  1187. Private Sub Sub_DelVouch()
  1188.     
  1189.     Dim VouchId As Long
  1190.     Dim ListId As Long
  1191.     Dim Jsqte As Long
  1192.     Dim yhAnswer As Integer
  1193.     
  1194.     '不能删除凭证的条件
  1195.     If CxbbGrid.Rows = CxbbGrid.FixedRows Then
  1196.         Exit Sub
  1197.     End If
  1198.     
  1199.     '删除凭证
  1200.     
  1201.     VouchId = Val(CxbbGrid.TextMatrix(CxbbGrid.Row, 10))
  1202.     
  1203.     Tsxx = "请确认是否删除当前单据?"
  1204.     yhAnswer = Xtxxts(Tsxx, 2, 2)
  1205.     If yhAnswer = 1 Then
  1206.        
  1207.         Cw_DataEnvi.DataConnect.BeginTrans
  1208.        
  1209.         '删除单据内容
  1210.         Cw_DataEnvi.DataConnect.Execute ("DELETE chhs_VouchSub WHERE VouchId=" & VouchId & "")
  1211.         Cw_DataEnvi.DataConnect.Execute ("DELETE Chhs_VouchMain WHERE VouchId=" & VouchId & "")
  1212.         
  1213.        
  1214.         '删除网格行
  1215.         Do While Jsqte <= CxbbGrid.Rows - CxbbGrid.FixedRows
  1216.             If Val(CxbbGrid.TextMatrix(Jsqte, 10)) = VouchId Then
  1217.                 ListId = Val(CxbbGrid.TextMatrix(Jsqte, 1))
  1218.                 Cw_DataEnvi.DataConnect.Execute ("UPDATE Chhs_list SET Vouchid=0 WHERE ListID=" & ListId & "")
  1219.                 CxbbGrid.RemoveItem (Jsqte)
  1220.             Else
  1221.                   Jsqte = Jsqte + 1
  1222.             End If
  1223.         Loop
  1224.               
  1225.        Tsxx = "删除完毕!"
  1226.        Call Xtxxts(Tsxx, 0, 4)
  1227.               
  1228.        Cw_DataEnvi.DataConnect.CommitTrans
  1229.               
  1230.    End If
  1231.     
  1232.     
  1233. End Sub
  1235. Public Property Get ListId() As Variant
  1236.     ListId = MListId
  1237. End Property
  1239. Public Property Get PzType() As Integer
  1240.     PzType = MPzType
  1241. End Property