上传用户:zhpu1995
上传日期:2013-09-06
资源大小:61151k
文件大小:34k
源码类别:

企业管理

开发平台:

Visual Basic

  1. VERSION 5.00
  2. Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "TABCTL32.OCX"
  3. Begin VB.Form Cask_AppertainOuListQuery 
  4.    BorderStyle     =   3  'Fixed Dialog
  5.    Caption         =   "附属物出库单列表查询条件"
  6.    ClientHeight    =   5235
  7.    ClientLeft      =   45
  8.    ClientTop       =   330
  9.    ClientWidth     =   5130
  10.    Icon            =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":0000
  11.    KeyPreview      =   -1  'True
  12.    LinkTopic       =   "Form1"
  13.    MaxButton       =   0   'False
  14.    MinButton       =   0   'False
  15.    ScaleHeight     =   5235
  16.    ScaleWidth      =   5130
  17.    ShowInTaskbar   =   0   'False
  18.    StartUpPosition =   1  '所有者中心
  19.    Begin VB.CheckBox UnloadCheck 
  20.       Caption         =   "卸载窗体"
  21.       Height          =   615
  22.       Left            =   6030
  23.       TabIndex        =   20
  24.       Top             =   4500
  25.       Width           =   825
  26.    End
  27.    Begin VB.CommandButton QdCommand 
  28.       Caption         =   "确定(&O)"
  29.       Height          =   300
  30.       Left            =   2730
  31.       TabIndex        =   17
  32.       Top             =   4860
  33.       Width           =   1120
  34.    End
  35.    Begin VB.CommandButton QxCommand 
  36.       Caption         =   "取消(&C)"
  37.       Height          =   300
  38.       Left            =   3930
  39.       TabIndex        =   18
  40.       Top             =   4860
  41.       Width           =   1120
  42.    End
  43.    Begin VB.CommandButton Cmd_Clear 
  44.       Caption         =   "全清"
  45.       Height          =   300
  46.       Left            =   60
  47.       TabIndex        =   19
  48.       Top             =   4860
  49.       Width           =   1120
  50.    End
  51.    Begin TabDlg.SSTab SSTab1 
  52.       Height          =   4665
  53.       Left            =   60
  54.       TabIndex        =   21
  55.       Top             =   90
  56.       Width           =   4995
  57.       _ExtentX        =   8811
  58.       _ExtentY        =   8229
  59.       _Version        =   393216
  60.       Style           =   1
  61.       Tabs            =   2
  62.       TabHeight       =   520
  63.       TabCaption(0)   =   "基本条件"
  64.       TabPicture(0)   =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":08CA
  65.       Tab(0).ControlEnabled=   -1  'True
  66.       Tab(0).Control(0)=   "Frame1"
  67.       Tab(0).Control(0).Enabled=   0   'False
  68.       Tab(0).ControlCount=   1
  69.       TabCaption(1)   =   "辅助条件"
  70.       TabPicture(1)   =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":08E6
  71.       Tab(1).ControlEnabled=   0   'False
  72.       Tab(1).Control(0)=   "Frame3"
  73.       Tab(1).Control(0).Enabled=   0   'False
  74.       Tab(1).ControlCount=   1
  75.       Begin VB.Frame Frame1 
  76.          Height          =   4215
  77.          Left            =   120
  78.          TabIndex        =   36
  79.          Top             =   330
  80.          Width           =   4755
  81.          Begin VB.TextBox LrText 
  82.             Height          =   300
  83.             Index           =   9
  84.             Left            =   990
  85.             TabIndex        =   9
  86.             Text            =   "9"
  87.             Top             =   3270
  88.             Width           =   3345
  89.          End
  90.          Begin VB.TextBox LrText 
  91.             Height          =   300
  92.             Index           =   2
  93.             Left            =   990
  94.             TabIndex        =   2
  95.             Text            =   "2"
  96.             Top             =   592
  97.             Width           =   3615
  98.          End
  99.          Begin VB.TextBox LrText 
  100.             Height          =   300
  101.             Index           =   0
  102.             Left            =   990
  103.             TabIndex        =   0
  104.             Text            =   "0"
  105.             Top             =   210
  106.             Width           =   1365
  107.          End
  108.          Begin VB.TextBox LrText 
  109.             Height          =   300
  110.             Index           =   1
  111.             Left            =   2940
  112.             TabIndex        =   1
  113.             Text            =   "1"
  114.             Top             =   210
  115.             Width           =   1365
  116.          End
  117.          Begin VB.Frame Frame2 
  118.             Caption         =   "审核状态"
  119.             Height          =   555
  120.             Left            =   165
  121.             TabIndex        =   46
  122.             Top             =   3570
  123.             Width           =   4455
  124.             Begin VB.OptionButton Opt_Check 
  125.                Caption         =   "已审核"
  126.                Height          =   195
  127.                Index           =   2
  128.                Left            =   3210
  129.                TabIndex        =   49
  130.                Top             =   270
  131.                Width           =   1005
  132.             End
  133.             Begin VB.OptionButton Opt_Check 
  134.                Caption         =   "未审核"
  135.                Height          =   195
  136.                Index           =   1
  137.                Left            =   1665
  138.                TabIndex        =   48
  139.                Top             =   270
  140.                Width           =   915
  141.             End
  142.             Begin VB.OptionButton Opt_Check 
  143.                Caption         =   "全部"
  144.                Height          =   195
  145.                Index           =   0
  146.                Left            =   180
  147.                TabIndex        =   47
  148.                Top             =   240
  149.                Value           =   -1  'True
  150.                Width           =   855
  151.             End
  152.          End
  153.          Begin VB.TextBox LrText 
  154.             Height          =   300
  155.             Index           =   3
  156.             Left            =   990
  157.             TabIndex        =   3
  158.             Text            =   "3"
  159.             Top             =   974
  160.             Width           =   3345
  161.          End
  162.          Begin VB.TextBox LrText 
  163.             Height          =   300
  164.             Index           =   4
  165.             Left            =   990
  166.             TabIndex        =   4
  167.             Text            =   "4"
  168.             Top             =   1356
  169.             Width           =   3345
  170.          End
  171.          Begin VB.CommandButton Ydcommand1 
  172.             Height          =   300
  173.             Index           =   0
  174.             Left            =   2340
  175.             Picture         =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":0902
  176.             Style           =   1  'Graphical
  177.             TabIndex        =   45
  178.             Top             =   210
  179.             Visible         =   0   'False
  180.             Width           =   300
  181.          End
  182.          Begin VB.TextBox LrText 
  183.             Height          =   300
  184.             Index           =   7
  185.             Left            =   990
  186.             TabIndex        =   7
  187.             Text            =   "7"
  188.             Top             =   2502
  189.             Width           =   3345
  190.          End
  191.          Begin VB.TextBox LrText 
  192.             Height          =   300
  193.             Index           =   6
  194.             Left            =   990
  195.             TabIndex        =   6
  196.             Text            =   "6"
  197.             Top             =   2120
  198.             Width           =   3345
  199.          End
  200.          Begin VB.TextBox LrText 
  201.             Height          =   300
  202.             Index           =   5
  203.             Left            =   990
  204.             TabIndex        =   5
  205.             Text            =   "5"
  206.             Top             =   1738
  207.             Width           =   3345
  208.          End
  209.          Begin VB.TextBox LrText 
  210.             Height          =   300
  211.             Index           =   8
  212.             Left            =   990
  213.             TabIndex        =   8
  214.             Text            =   "8"
  215.             Top             =   2884
  216.             Width           =   3345
  217.          End
  218.          Begin VB.CommandButton Ydcommand1 
  219.             Height          =   300
  220.             Index           =   1
  221.             Left            =   4290
  222.             Picture         =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":0C8C
  223.             Style           =   1  'Graphical
  224.             TabIndex        =   44
  225.             Top             =   210
  226.             Visible         =   0   'False
  227.             Width           =   300
  228.          End
  229.          Begin VB.CommandButton Ydcommand1 
  230.             Height          =   300
  231.             Index           =   3
  232.             Left            =   4320
  233.             Picture         =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":1016
  234.             Style           =   1  'Graphical
  235.             TabIndex        =   43
  236.             Top             =   974
  237.             Visible         =   0   'False
  238.             Width           =   300
  239.          End
  240.          Begin VB.CommandButton Ydcommand1 
  241.             Height          =   300
  242.             Index           =   4
  243.             Left            =   4320
  244.             Picture         =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":13A0
  245.             Style           =   1  'Graphical
  246.             TabIndex        =   42
  247.             Top             =   1345
  248.             Visible         =   0   'False
  249.             Width           =   300
  250.          End
  251.          Begin VB.CommandButton Ydcommand1 
  252.             Height          =   300
  253.             Index           =   6
  254.             Left            =   4320
  255.             Picture         =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":172A
  256.             Style           =   1  'Graphical
  257.             TabIndex        =   41
  258.             Top             =   2115
  259.             Visible         =   0   'False
  260.             Width           =   300
  261.          End
  262.          Begin VB.CommandButton Ydcommand1 
  263.             Height          =   300
  264.             Index           =   7
  265.             Left            =   4320
  266.             Picture         =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":1AB4
  267.             Style           =   1  'Graphical
  268.             TabIndex        =   40
  269.             Top             =   2500
  270.             Visible         =   0   'False
  271.             Width           =   300
  272.          End
  273.          Begin VB.CommandButton Ydcommand1 
  274.             Height          =   300
  275.             Index           =   8
  276.             Left            =   4320
  277.             Picture         =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":1E3E
  278.             Style           =   1  'Graphical
  279.             TabIndex        =   39
  280.             Top             =   2885
  281.             Visible         =   0   'False
  282.             Width           =   300
  283.          End
  284.          Begin VB.CommandButton Ydcommand1 
  285.             Height          =   300
  286.             Index           =   5
  287.             Left            =   4320
  288.             Picture         =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":21C8
  289.             Style           =   1  'Graphical
  290.             TabIndex        =   38
  291.             Top             =   1730
  292.             Visible         =   0   'False
  293.             Width           =   300
  294.          End
  295.          Begin VB.CommandButton Ydcommand1 
  296.             Height          =   300
  297.             Index           =   9
  298.             Left            =   4320
  299.             Picture         =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":2552
  300.             Style           =   1  'Graphical
  301.             TabIndex        =   37
  302.             Top             =   3270
  303.             Visible         =   0   'False
  304.             Width           =   300
  305.          End
  306.          Begin VB.Line Line3 
  307.             X1              =   2700
  308.             X2              =   2880
  309.             Y1              =   360
  310.             Y2              =   360
  311.          End
  312.          Begin VB.Label Label1 
  313.             AutoSize        =   -1  'True
  314.             Caption         =   "状态:"
  315.             Height          =   180
  316.             Index           =   8
  317.             Left            =   150
  318.             TabIndex        =   58
  319.             Top             =   3270
  320.             Width           =   450
  321.          End
  322.          Begin VB.Label Label1 
  323.             AutoSize        =   -1  'True
  324.             Caption         =   "附属物:"
  325.             Height          =   180
  326.             Index           =   7
  327.             Left            =   150
  328.             TabIndex        =   57
  329.             Top             =   2895
  330.             Width           =   630
  331.          End
  332.          Begin VB.Label Label1 
  333.             AutoSize        =   -1  'True
  334.             Caption         =   "单据号:"
  335.             Height          =   180
  336.             Index           =   0
  337.             Left            =   150
  338.             TabIndex        =   56
  339.             Top             =   660
  340.             Width           =   630
  341.          End
  342.          Begin VB.Label Label1 
  343.             AutoSize        =   -1  'True
  344.             Caption         =   "仓库:"
  345.             Height          =   180
  346.             Index           =   11
  347.             Left            =   150
  348.             TabIndex        =   55
  349.             Top             =   1380
  350.             Width           =   450
  351.          End
  352.          Begin VB.Label Label1 
  353.             AutoSize        =   -1  'True
  354.             Caption         =   "业务类型:"
  355.             Height          =   180
  356.             Index           =   2
  357.             Left            =   150
  358.             TabIndex        =   54
  359.             Top             =   1770
  360.             Width           =   810
  361.          End
  362.          Begin VB.Label Label1 
  363.             AutoSize        =   -1  'True
  364.             Caption         =   "客户:"
  365.             Height          =   180
  366.             Index           =   1
  367.             Left            =   150
  368.             TabIndex        =   53
  369.             Top             =   2175
  370.             Width           =   450
  371.          End
  372.          Begin VB.Label Label1 
  373.             AutoSize        =   -1  'True
  374.             Caption         =   "部门:"
  375.             Height          =   180
  376.             Index           =   3
  377.             Left            =   150
  378.             TabIndex        =   52
  379.             Top             =   2535
  380.             Width           =   450
  381.          End
  382.          Begin VB.Label Label1 
  383.             AutoSize        =   -1  'True
  384.             Caption         =   "日期:"
  385.             Height          =   180
  386.             Index           =   10
  387.             Left            =   150
  388.             TabIndex        =   51
  389.             Top             =   270
  390.             Width           =   450
  391.          End
  392.          Begin VB.Label Label1 
  393.             AutoSize        =   -1  'True
  394.             Caption         =   "包装物:"
  395.             Height          =   180
  396.             Index           =   13
  397.             Left            =   150
  398.             TabIndex        =   50
  399.             Top             =   1020
  400.             Width           =   630
  401.          End
  402.       End
  403.       Begin VB.Frame Frame5 
  404.          Height          =   3495
  405.          Left            =   -74910
  406.          TabIndex        =   26
  407.          Top             =   420
  408.          Width           =   5640
  409.          Begin VB.Label Label1 
  410.             AutoSize        =   -1  'True
  411.             Caption         =   "数量:"
  412.             Height          =   180
  413.             Index           =   15
  414.             Left            =   300
  415.             TabIndex        =   30
  416.             Top             =   855
  417.             Width           =   450
  418.          End
  419.          Begin VB.Label Label1 
  420.             AutoSize        =   -1  'True
  421.             Caption         =   "金额:"
  422.             Height          =   180
  423.             Index           =   16
  424.             Left            =   300
  425.             TabIndex        =   29
  426.             Top             =   405
  427.             Width           =   450
  428.          End
  429.          Begin VB.Line Line2 
  430.             Index           =   0
  431.             X1              =   2925
  432.             X2              =   3165
  433.             Y1              =   480
  434.             Y2              =   480
  435.          End
  436.          Begin VB.Line Line2 
  437.             Index           =   1
  438.             X1              =   2910
  439.             X2              =   3150
  440.             Y1              =   975
  441.             Y2              =   975
  442.          End
  443.          Begin VB.Label Label1 
  444.             AutoSize        =   -1  'True
  445.             Caption         =   "货区:"
  446.             Height          =   180
  447.             Index           =   17
  448.             Left            =   300
  449.             TabIndex        =   28
  450.             Top             =   1755
  451.             Width           =   450
  452.          End
  453.          Begin VB.Label Label1 
  454.             AutoSize        =   -1  'True
  455.             Caption         =   "部门:"
  456.             Height          =   180
  457.             Index           =   18
  458.             Left            =   300
  459.             TabIndex        =   27
  460.             Top             =   1305
  461.             Width           =   450
  462.          End
  463.       End
  464.       Begin VB.Frame Frame3 
  465.          Height          =   4215
  466.          Left            =   -74880
  467.          TabIndex        =   22
  468.          Top             =   330
  469.          Width           =   4755
  470.          Begin VB.TextBox LrText 
  471.             Height          =   300
  472.             Index           =   16
  473.             Left            =   3045
  474.             TabIndex        =   16
  475.             Text            =   "16"
  476.             Top             =   1779
  477.             Width           =   1545
  478.          End
  479.          Begin VB.TextBox LrText 
  480.             Height          =   300
  481.             Index           =   15
  482.             Left            =   1170
  483.             TabIndex        =   15
  484.             Text            =   "15"
  485.             Top             =   1779
  486.             Width           =   1545
  487.          End
  488.          Begin VB.TextBox LrText 
  489.             Height          =   300
  490.             Index           =   14
  491.             Left            =   3045
  492.             TabIndex        =   14
  493.             Text            =   "14"
  494.             Top             =   1380
  495.             Width           =   1545
  496.          End
  497.          Begin VB.CommandButton Ydcommand1 
  498.             Height          =   300
  499.             Index           =   12
  500.             Left            =   4290
  501.             Picture         =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":28DC
  502.             Style           =   1  'Graphical
  503.             TabIndex        =   34
  504.             Top             =   990
  505.             Visible         =   0   'False
  506.             Width           =   300
  507.          End
  508.          Begin VB.CommandButton Ydcommand1 
  509.             Height          =   300
  510.             Index           =   11
  511.             Left            =   4290
  512.             Picture         =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":2C66
  513.             Style           =   1  'Graphical
  514.             TabIndex        =   33
  515.             Top             =   600
  516.             Visible         =   0   'False
  517.             Width           =   300
  518.          End
  519.          Begin VB.CommandButton Ydcommand1 
  520.             Height          =   300
  521.             Index           =   10
  522.             Left            =   4290
  523.             Picture         =   "包装物管理系统_单据列表_附属物出库单列表查询条件(单据式).frx":2FF0
  524.             Style           =   1  'Graphical
  525.             TabIndex        =   32
  526.             Top             =   210
  527.             Visible         =   0   'False
  528.             Width           =   300
  529.          End
  530.          Begin VB.TextBox LrText 
  531.             Height          =   300
  532.             Index           =   13
  533.             Left            =   1170
  534.             TabIndex        =   13
  535.             Text            =   "13"
  536.             Top             =   1380
  537.             Width           =   1545
  538.          End
  539.          Begin VB.TextBox LrText 
  540.             Height          =   300
  541.             Index           =   12
  542.             Left            =   1170
  543.             TabIndex        =   12
  544.             Text            =   "12"
  545.             Top             =   990
  546.             Width           =   3135
  547.          End
  548.          Begin VB.TextBox LrText 
  549.             Height          =   300
  550.             Index           =   10
  551.             Left            =   1170
  552.             TabIndex        =   10
  553.             Text            =   "10"
  554.             Top             =   210
  555.             Width           =   3135
  556.          End
  557.          Begin VB.TextBox LrText 
  558.             Height          =   300
  559.             Index           =   11
  560.             Left            =   1170
  561.             TabIndex        =   11
  562.             Text            =   "11"
  563.             Top             =   600
  564.             Width           =   3135
  565.          End
  566.          Begin VB.Line Line4 
  567.             X1              =   2790
  568.             X2              =   2970
  569.             Y1              =   1890
  570.             Y2              =   1890
  571.          End
  572.          Begin VB.Line Line1 
  573.             X1              =   2790
  574.             X2              =   2970
  575.             Y1              =   1530
  576.             Y2              =   1530
  577.          End
  578.          Begin VB.Label Label1 
  579.             AutoSize        =   -1  'True
  580.             Caption         =   "附属物数量:"
  581.             Height          =   180
  582.             Index           =   14
  583.             Left            =   150
  584.             TabIndex        =   35
  585.             Top             =   1830
  586.             Width           =   990
  587.          End
  588.          Begin VB.Label Label1 
  589.             AutoSize        =   -1  'True
  590.             Caption         =   "运输方式:"
  591.             Height          =   180
  592.             Index           =   12
  593.             Left            =   150
  594.             TabIndex        =   31
  595.             Top             =   270
  596.             Width           =   810
  597.          End
  598.          Begin VB.Label Label1 
  599.             AutoSize        =   -1  'True
  600.             Caption         =   "制单人:"
  601.             Height          =   180
  602.             Index           =   6
  603.             Left            =   150
  604.             TabIndex        =   25
  605.             Top             =   1050
  606.             Width           =   630
  607.          End
  608.          Begin VB.Label Label1 
  609.             AutoSize        =   -1  'True
  610.             Caption         =   "经手人:"
  611.             Height          =   180
  612.             Index           =   4
  613.             Left            =   150
  614.             TabIndex        =   24
  615.             Top             =   660
  616.             Width           =   630
  617.          End
  618.          Begin VB.Label Label1 
  619.             AutoSize        =   -1  'True
  620.             Caption         =   "包装物数量:"
  621.             Height          =   180
  622.             Index           =   9
  623.             Left            =   150
  624.             TabIndex        =   23
  625.             Top             =   1440
  626.             Width           =   990
  627.          End
  628.       End
  629.    End
  630. End
  631. Attribute VB_Name = "Cask_AppertainOuListQuery"
  632. Attribute VB_GlobalNameSpace = False
  633. Attribute VB_Creatable = False
  634. Attribute VB_PredeclaredId = True
  635. Attribute VB_Exposed = False
  636. '******************************************************************
  637. '*    模 块 名 称 :附属物入库单列表查询条件
  638. '*    功 能 描 述 :
  639. '*    程序员姓名  :邹力
  640. '*    最后修改人  :
  641. '*    最后修改时间:2001/12/17
  642. '*    备        注:程序中所有依实际情况自定义部分均用[>>  <<]括起
  643. '******************************************************************
  644. Dim Tsxx As String                       '系统信息提示
  645. '以下为固定使用变量(文本框)
  646. Dim Textvar() As Variant                 '存储变体型文本框信息
  647. Dim Textboolean() As Boolean             '存储布尔型文本框信息
  648. Dim Textint() As Integer                 '存储整型文本框信息
  649. Dim Textstr() As String                  '存储字符型文本框信息
  650. Dim Max_Text_Index As Integer            '最大录入文本框索引值
  651. Dim TextGroupCode As String              '文本框录入分组编码
  652. Dim TextValiLock As Boolean              '文本框失去焦点是否进行有效性控制判断
  653. Dim TextValiJudgeLock() As Boolean       '文本框录入有效性判断控制锁
  654. Dim CurTextIndex As Integer              '当前文本框索引值
  655. Dim TextChangeLock As Boolean            '文本框内容变换控制锁
  656. Dim Bln_Cancel As Boolean                '取消按钮信息传递
  657. Private Sub Form_KeyPress(KeyAscii As Integer)   '控 制 焦 点 转 移(Fixed)
  658.     Dim jdzygs As Integer                         '控件焦点转移个数
  659.     jdzygs = 30
  660.     Select Case KeyAscii
  661.         Case vbKeyReturn
  662.             If Kjjdzy(jdzygs) Then
  663.                 KeyAscii = 0
  664.             End If
  665.         Case 39           '屏蔽"'"
  666.             KeyAscii = 0
  667.     End Select
  668. End Sub
  669. Private Sub Form_Load()
  670.    
  671.     '以下为文本框处理程序(Fixed)
  672.     TextGroupCode = "Cask_AppertainOuList"
  673.     Call Drwbkxx(TextGroupCode, Textvar(), Textboolean(), Textint(), Textstr())  '读入文本框录入信息
  674.     Call Wbkcsh
  675.    
  676.     '[>>初始化查询条件默认值
  677.     LrText(0).Text = Format(Xtrq, "yyyy-mm-dd")
  678.     LrText(1).Text = Format(Xtrq, "yyyy-mm-dd")
  679.     '<<]
  680.    
  681. End Sub
  682. Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)          '查询条件窗体卸载
  683.     '查询条件窗体卸载时判断是否因为结果窗体卸载,如是则卸载,否则隐藏
  684.     If UnloadCheck.Value <> 1 Then
  685.         Cancel = 1
  686.         Me.Hide
  687.     End If
  688.     
  689. End Sub
  690. Private Sub QdCommand_Click()                                   '确 定
  691.     '录入条件有效性判断(Fixed)
  692.     If Not Lrtjyxxpd Then
  693.         Exit Sub
  694.     End If
  695.     Me.Hide
  696.         
  697.     '[>>激活查询过程结果窗体
  698.     
  699.     Cask_AppertainOuList.Timer1.Enabled = True
  700.     Cask_AppertainOuList.SetFocus
  701.     
  702.     '<<]
  703. End Sub
  704. Private Sub QxCommand_Click()                                    '取消(Fixed)
  705.     Me.Hide
  706. End Sub
  707. Private Function Lrtjyxxpd() As Boolean                          '用户录入条件有效性判断
  708.     Dim Jsqte As Integer
  709.     Lrtjyxxpd = False
  710.  
  711.     '对需要进行事后判断的文本框录入内容进行有效性判断 (Fixed)
  712.     For Jsqte = 0 To Max_Text_Index
  713.         If Textint(Jsqte, 9) = 0 Or Textint(Jsqte, 9) = 2 Then
  714.             If Not TextYxxpd(Jsqte) Then
  715.                 Exit Function
  716.             End If
  717.         End If
  718.     Next Jsqte
  719.    
  720.     '[>>以下为依据实际情况自定义部分
  721.  
  722.     '查询日期范围应由小到大
  723.     If LrText(0).Text > LrText(1).Text And Trim(LrText(1).Text) <> "" Then
  724.         Tsxx = "查询日期范围应由小到大!"
  725.         Call Xtxxts(Tsxx, 0, 4)
  726.         SSTab1.Tab = 0
  727.         LrText(0).SetFocus
  728.         Exit Function
  729.     End If
  730.     If Val(LrText(13).Text) > Val(LrText(14).Text) And Trim(LrText(14).Text) <> "" Then
  731.         Tsxx = "查询包装物数量范围应由小到大!"
  732.         Call Xtxxts(Tsxx, 0, 4)
  733.         SSTab1.Tab = 1
  734.         LrText(13).SetFocus
  735.         Exit Function
  736.     End If
  737.     
  738.     If Val(LrText(15).Text) > Val(LrText(16).Text) And Trim(LrText(16).Text) <> "" Then
  739.         Tsxx = "查询附属物数量范围应由小到大!"
  740.         Call Xtxxts(Tsxx, 0, 4)
  741.         SSTab1.Tab = 1
  742.         LrText(15).SetFocus
  743.         Exit Function
  744.     End If
  745.     '<<]以上为依据实际情况自定义部分
  746.  
  747.     Lrtjyxxpd = True
  748. End Function
  749. Private Sub Cmd_Clear_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)    '将用户输入条件全部清除(可选)
  750.     '清除文本框(Fixed)
  751.     For Jsqte = 0 To Max_Text_Index
  752.         LrText(Jsqte).Tag = ""
  753.         LrText(Jsqte).Text = ""
  754.     Next Jsqte
  755.    Opt_Check(0).Value = True
  756.     '[>>
  757.     '此处可以写入其他清除条件程序
  758.     '<<]
  759.   
  760. End Sub
  761. '*************以下为文本框录入处理程序(固定不变部分)*************'
  762. Private Sub Wbklrwbcl(Index As Integer)    '文本框录入事后处理程序
  763.   
  764.     '以下为依据实际情况自定义部分[
  765.     '在此填写文本框录入事后处理程序
  766.     ']以上为依据实际情况自定义部分
  767.   
  768. End Sub
  769. Private Sub LrText_Change(Index As Integer)
  770.    
  771.     '屏蔽程序改变控制
  772.     If TextChangeLock Then
  773.         Exit Sub
  774.     End If
  775.     
  776.     TextValiJudgeLock(Index) = False    '打开有效性判断锁
  777.     
  778.     '限制字段录入长度
  779.           
  780.     TextChangeLock = True  '加锁(防止执行Lrtext_Change)
  781.     Call TextChangeLimit(LrText(Index), Textint(Index, 1))  '去掉无效字符
  782.     
  783.     Select Case Textint(Index, 1)
  784.         Case 8, 11      '金额型
  785.             Call Sjgskz(LrText(Index), Xtjezws - Xtjexsws - 1, Xtjexsws)
  786.         Case 9, 12      '数量型
  787.             Call Sjgskz(LrText(Index), Xtslzws - Xtslxsws - 1, Xtslxsws)
  788.         Case 10          '单价型
  789.             Call Sjgskz(LrText(Index), Xtdjzws - Xtdjxsws - 1, Xtdjxsws)
  790.         Case Else        '其他小数类型控制
  791.             If Textint(Index, 6) <> 0 Or Textint(Index, 7) <> 0 Then
  792.                 Call Sjgskz(LrText(Index), Textint(Index, 6), Textint(Index, 7))
  793.             End If
  794.     End Select
  795.         
  796.     TextChangeLock = False '解锁
  797. End Sub
  798. Private Sub LrText_GotFocus(Index As Integer)                                                 '文本框得到焦点,显示相应信息
  799.     Call TextShow(Index)
  800.     CurTextIndex = Index
  801.     LrText(Index).SelStart = Len(LrText(Index))
  802. End Sub
  803. Private Sub LrText_KeyDown(Index As Integer, KeyCode As Integer, Shift As Integer)            '字段按F2键提供帮助
  804.     
  805.     Select Case KeyCode
  806.         Case vbKeyF2
  807.             Call Text_Help(Index)
  808.     End Select
  809. End Sub
  810. Private Sub LrText_KeyPress(Index As Integer, KeyAscii As Integer)                            '文本框录入事中控制
  811.     Call InputFieldLimit(LrText(Index), Textint(Index, 1), KeyAscii)
  812. End Sub
  813. Private Sub LrText_LostFocus(Index As Integer)                                                '文本框失去焦点
  814.     '显示相应信息但不能进行有效性判断
  815.   
  816. End Sub
  817. Private Sub Ydcommand1_MouseDown(Index As Integer, Button As Integer, Shift As Integer, x As Single, y As Single)     '按钮提供帮助
  818.     Call Text_Help(Index)
  819. End Sub
  820. Private Sub Text_Help(Index As Integer)                                                       '录入字段帮助
  821.     If Not Textboolean(Index, 1) Then
  822.         Exit Sub
  823.     End If
  824.      
  825.     '调用帮助
  826.     Call Drbmhelp(Textint(Index, 2), Textstr(Index, 4), Trim(LrText(Index).Text))
  827.   
  828.     '根据设置选择显示编码和名称,并进行存储
  829.     If Len(Xtfhcs) <> 0 Then
  830.         If Textint(Index, 3) = 1 Then
  831.             LrText(Index).Text = Xtfhcsfz
  832.             LrText(Index).Tag = Xtfhcs
  833.         Else
  834.             LrText(Index).Text = Xtfhcs
  835.             LrText(Index).Tag = Xtfhcsfz
  836.         End If
  837.     End If
  838.    
  839.     LrText(Index).SetFocus
  840. End Sub
  841. Private Sub TextShow(Index As Integer)        '文本框得到焦点,显示相应信息
  842.     '填写文本框得到焦点,进行相应信息处理程序
  843.    
  844. End Sub
  845. Private Sub Wbkcsh()                          '录入文本框初始化
  846.     
  847.     Dim Jsqte As Integer
  848.   
  849.     '最大录入文本框索引值
  850.     Max_Text_Index = Textvar(1)
  851.   
  852.     ReDim TextValiJudgeLock(Max_Text_Index)
  853.     For Jsqte = 0 To Max_Text_Index
  854.         If Len(Trim(Textstr(Jsqte, 1))) <> 0 Then
  855.             If Textboolean(Jsqte, 1) Then
  856.                 If Jsqte <> 0 And Not Textboolean(Jsqte, 3) Then
  857.                     Load Ydcommand1(Jsqte)
  858.                 End If
  859.                 Ydcommand1(Jsqte).Visible = True
  860.                 Ydcommand1(Jsqte).Move LrText(Jsqte).Left + LrText(Jsqte).Width, LrText(Jsqte).Top
  861.             End If
  862.             TextChangeLock = True
  863.             LrText(Jsqte).Text = ""
  864.             LrText(Jsqte).Tag = ""
  865.             If Textint(Jsqte, 5) <> 0 Then
  866.                 LrText(Jsqte).MaxLength = Textint(Jsqte, 5)
  867.             End If
  868.             TextChangeLock = False
  869.         End If
  870.         TextValiJudgeLock(Jsqte) = True
  871.     Next Jsqte
  872. End Sub
  873. Private Function TextYxxpd(Index As Integer) As Boolean           '文本框有效性判断
  874.     
  875.     Dim Sqlstr As String
  876.     Dim Findrec As ADODB.Recordset
  877.   
  878.     '文本框内容未曾改变不进行有效性判断
  879.     If TextValiJudgeLock(Index) Then
  880.         TextYxxpd = True
  881.         Exit Function
  882.     End If
  883.   
  884.     '文本框内容为空认为有效,并清空其Tag值
  885.     If Trim(LrText(Index)) = "" Then
  886.         LrText(Index).Tag = ""
  887.         Call Wbklrwbcl(Index)
  888.         TextValiJudgeLock(Index) = True
  889.         TextYxxpd = True
  890.         Exit Function
  891.     End If
  892.   
  893.     '可在此加入不做有效性判断的理由
  894.   
  895.     Select Case Textint(Index, 4)
  896.         Case 1      '编码型
  897.             Sqlstr = Trim(Textstr(Index, 5))
  898.             Sqlstr = Replace(Sqlstr, "@", "'" + Trim(LrText(Index).Text) + "'")
  899.             Set Findrec = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
  900.             If Findrec.EOF Then
  901.                 Call Xtxxts(Trim(Textstr(Index, 6)), 0, 1)
  902.                 LrText(Index).SetFocus
  903.                 Exit Function
  904.             Else
  905.                 Select Case Textint(Index, 3)
  906.                     Case 0
  907.                         If Len(Trim(Textstr(Index, 2))) <> 0 Then
  908.                             LrText(Index).Text = Trim(Findrec.Fields(Trim(Textstr(Index, 2))))
  909.                         End If
  910.                         If Len(Trim(Textstr(Index, 3) & "")) <> 0 Then
  911.                             LrText(Index).Tag = Trim(Findrec.Fields(Trim(Textstr(Index, 3))))
  912.                         End If
  913.                     Case 1
  914.                         If Len(Trim(Textstr(Index, 3) & "")) <> 0 Then
  915.                             LrText(Index).Text = Trim(Findrec.Fields(Trim(Textstr(Index, 3))))
  916.                         End If
  917.                         If Len(Trim(Textstr(Index, 2))) <> 0 Then
  918.                             LrText(Index).Tag = Trim(Findrec.Fields(Trim(Textstr(Index, 2))))
  919.                         End If
  920.                 End Select
  921.             End If
  922.         Case 2      '日期型
  923.             If IsDate(LrText(Index).Text) Then
  924.                 LrText(Index).Text = Format(LrText(Index).Text, "yyyy-mm-dd")
  925.                 If Val(Mid(LrText(Index), 1, 4)) < 1900 Then
  926.                     LrText(Index).Text = "1900" + Mid(LrText(Index), 5, 6)
  927.                 End If
  928.             Else
  929.                 Tsxx = "非法公历日期!(格式:" + Format(Date, "yyyy-mm-dd") + ")"
  930.                 Call Xtxxts(Tsxx, 0, 1)
  931.                 LrText(Index).SetFocus
  932.                 Exit Function
  933.             End If
  934.         Case 3      '其他类型
  935.     End Select
  936.     
  937.     '如果有效则加锁,用户不改变内容则不再进行有效性判断
  938.     TextValiJudgeLock(Index) = True
  939.     '调用文本框事后处理程序
  940.     Call Wbklrwbcl(Index)
  941.    
  942.     '有效性判断通过则返回True
  943.     TextYxxpd = True
  944.    
  945. End Function