DataEnvironmentczh.Dsr
上传用户:xiao_xia32
上传日期:2022-07-21
资源大小:1174k
文件大小:44k
源码类别:

企业管理

开发平台:

Visual Basic

  1. VERSION 5.00
  2. Begin {C0E45035-5775-11D0-B388-00A0C9055D8E} DataEnvironment1 
  3.    ClientHeight    =   4950
  4.    ClientLeft      =   0
  5.    ClientTop       =   0
  6.    ClientWidth     =   7215
  7.    _ExtentX        =   12726
  8.    _ExtentY        =   8731
  9.    FolderFlags     =   7
  10.    TypeLibGuid     =   "{81F71D5F-E0F4-11D2-B02B-00104B27C07F}"
  11.    TypeInfoGuid    =   "{81F71D60-E0F4-11D2-B02B-00104B27C07F}"
  12.    TypeInfoCookie  =   0
  13.    Version         =   4
  14.    NumConnections  =   1
  15.    BeginProperty Connection1 
  16.       ConnectionName  =   "Connection1"
  17.       ConnDispId      =   1001
  18.       SourceOfData    =   3
  19.       ConnectionSource=   "Provider=MSDASQL.1;Persist Security Info=False;User ID=SA;Data Source=LandaMis"
  20.       IsSQL           =   -1  'True
  21.       QuoteChar       =   34
  22.       SeparatorChar   =   46
  23.    EndProperty
  24.    NumRecordsets   =   9
  25.    BeginProperty Recordset1 
  26.       CommandName     =   "Cmd_工资条"
  27.       CommDispId      =   1002
  28.       RsDispId        =   1003
  29.       CommandText     =   $"DataEnvironment1.dsx":0000
  30.       ActiveConnectionName=   "Connection1"
  31.       CommandType     =   1
  32.       GroupingName    =   "Cmd_工资条_Grouping"
  33.       IsRSReturning   =   -1  'True
  34.       NumFields       =   31
  35.       BeginProperty Field1 
  36.          Precision       =   0
  37.          Size            =   10
  38.          Scale           =   0
  39.          Type            =   200
  40.          Name            =   "部门名称"
  41.          Caption         =   "部门名称"
  42.       EndProperty
  43.       BeginProperty Field2 
  44.          Precision       =   0
  45.          Size            =   20
  46.          Scale           =   0
  47.          Type            =   200
  48.          Name            =   "姓名"
  49.          Caption         =   "姓名"
  50.       EndProperty
  51.       BeginProperty Field3 
  52.          Precision       =   7
  53.          Size            =   4
  54.          Scale           =   0
  55.          Type            =   4
  56.          Name            =   "岗位工资"
  57.          Caption         =   "岗位工资"
  58.       EndProperty
  59.       BeginProperty Field4 
  60.          Precision       =   7
  61.          Size            =   4
  62.          Scale           =   0
  63.          Type            =   4
  64.          Name            =   "效益工资"
  65.          Caption         =   "效益工资"
  66.       EndProperty
  67.       BeginProperty Field5 
  68.          Precision       =   7
  69.          Size            =   4
  70.          Scale           =   0
  71.          Type            =   4
  72.          Name            =   "基本福利"
  73.          Caption         =   "基本福利"
  74.       EndProperty
  75.       BeginProperty Field6 
  76.          Precision       =   7
  77.          Size            =   4
  78.          Scale           =   0
  79.          Type            =   4
  80.          Name            =   "工龄"
  81.          Caption         =   "工龄"
  82.       EndProperty
  83.       BeginProperty Field7 
  84.          Precision       =   7
  85.          Size            =   4
  86.          Scale           =   0
  87.          Type            =   4
  88.          Name            =   "司龄工资"
  89.          Caption         =   "司龄工资"
  90.       EndProperty
  91.       BeginProperty Field8 
  92.          Precision       =   7
  93.          Size            =   4
  94.          Scale           =   0
  95.          Type            =   4
  96.          Name            =   "加班津贴"
  97.          Caption         =   "加班津贴"
  98.       EndProperty
  99.       BeginProperty Field9 
  100.          Precision       =   7
  101.          Size            =   4
  102.          Scale           =   0
  103.          Type            =   4
  104.          Name            =   "夜班津贴"
  105.          Caption         =   "夜班津贴"
  106.       EndProperty
  107.       BeginProperty Field10 
  108.          Precision       =   7
  109.          Size            =   4
  110.          Scale           =   0
  111.          Type            =   4
  112.          Name            =   "值班津贴"
  113.          Caption         =   "值班津贴"
  114.       EndProperty
  115.       BeginProperty Field11 
  116.          Precision       =   7
  117.          Size            =   4
  118.          Scale           =   0
  119.          Type            =   4
  120.          Name            =   "特勤津贴"
  121.          Caption         =   "特勤津贴"
  122.       EndProperty
  123.       BeginProperty Field12 
  124.          Precision       =   7
  125.          Size            =   4
  126.          Scale           =   0
  127.          Type            =   4
  128.          Name            =   "销售奖金"
  129.          Caption         =   "销售奖金"
  130.       EndProperty
  131.       BeginProperty Field13 
  132.          Precision       =   7
  133.          Size            =   4
  134.          Scale           =   0
  135.          Type            =   4
  136.          Name            =   "月奖"
  137.          Caption         =   "月奖"
  138.       EndProperty
  139.       BeginProperty Field14 
  140.          Precision       =   7
  141.          Size            =   4
  142.          Scale           =   0
  143.          Type            =   4
  144.          Name            =   "奖励基金"
  145.          Caption         =   "奖励基金"
  146.       EndProperty
  147.       BeginProperty Field15 
  148.          Precision       =   7
  149.          Size            =   4
  150.          Scale           =   0
  151.          Type            =   4
  152.          Name            =   "小计"
  153.          Caption         =   "小计"
  154.       EndProperty
  155.       BeginProperty Field16 
  156.          Precision       =   7
  157.          Size            =   4
  158.          Scale           =   0
  159.          Type            =   4
  160.          Name            =   "公积金"
  161.          Caption         =   "公积金"
  162.       EndProperty
  163.       BeginProperty Field17 
  164.          Precision       =   7
  165.          Size            =   4
  166.          Scale           =   0
  167.          Type            =   4
  168.          Name            =   "大病统筹"
  169.          Caption         =   "大病统筹"
  170.       EndProperty
  171.       BeginProperty Field18 
  172.          Precision       =   7
  173.          Size            =   4
  174.          Scale           =   0
  175.          Type            =   4
  176.          Name            =   "养老保险"
  177.          Caption         =   "养老保险"
  178.       EndProperty
  179.       BeginProperty Field19 
  180.          Precision       =   7
  181.          Size            =   4
  182.          Scale           =   0
  183.          Type            =   4
  184.          Name            =   "失业保险"
  185.          Caption         =   "失业保险"
  186.       EndProperty
  187.       BeginProperty Field20 
  188.          Precision       =   7
  189.          Size            =   4
  190.          Scale           =   0
  191.          Type            =   4
  192.          Name            =   "扣事假"
  193.          Caption         =   "扣事假"
  194.       EndProperty
  195.       BeginProperty Field21 
  196.          Precision       =   7
  197.          Size            =   4
  198.          Scale           =   0
  199.          Type            =   4
  200.          Name            =   "扣病假"
  201.          Caption         =   "扣病假"
  202.       EndProperty
  203.       BeginProperty Field22 
  204.          Precision       =   7
  205.          Size            =   4
  206.          Scale           =   0
  207.          Type            =   4
  208.          Name            =   "过失扣款"
  209.          Caption         =   "过失扣款"
  210.       EndProperty
  211.       BeginProperty Field23 
  212.          Precision       =   7
  213.          Size            =   4
  214.          Scale           =   0
  215.          Type            =   4
  216.          Name            =   "公司扣款"
  217.          Caption         =   "公司扣款"
  218.       EndProperty
  219.       BeginProperty Field24 
  220.          Precision       =   7
  221.          Size            =   4
  222.          Scale           =   0
  223.          Type            =   4
  224.          Name            =   "应税额"
  225.          Caption         =   "应税额"
  226.       EndProperty
  227.       BeginProperty Field25 
  228.          Precision       =   7
  229.          Size            =   4
  230.          Scale           =   0
  231.          Type            =   4
  232.          Name            =   "扣所得税"
  233.          Caption         =   "扣所得税"
  234.       EndProperty
  235.       BeginProperty Field26 
  236.          Precision       =   7
  237.          Size            =   4
  238.          Scale           =   0
  239.          Type            =   4
  240.          Name            =   "代扣房租"
  241.          Caption         =   "代扣房租"
  242.       EndProperty
  243.       BeginProperty Field27 
  244.          Precision       =   7
  245.          Size            =   4
  246.          Scale           =   0
  247.          Type            =   4
  248.          Name            =   "扣餐费"
  249.          Caption         =   "扣餐费"
  250.       EndProperty
  251.       BeginProperty Field28 
  252.          Precision       =   7
  253.          Size            =   4
  254.          Scale           =   0
  255.          Type            =   4
  256.          Name            =   "其他扣款"
  257.          Caption         =   "其他扣款"
  258.       EndProperty
  259.       BeginProperty Field29 
  260.          Precision       =   7
  261.          Size            =   4
  262.          Scale           =   0
  263.          Type            =   4
  264.          Name            =   "应发额"
  265.          Caption         =   "应发额"
  266.       EndProperty
  267.       BeginProperty Field30 
  268.          Precision       =   7
  269.          Size            =   4
  270.          Scale           =   0
  271.          Type            =   4
  272.          Name            =   "荣誉津贴"
  273.          Caption         =   "荣誉津贴"
  274.       EndProperty
  275.       BeginProperty Field31 
  276.          Precision       =   7
  277.          Size            =   4
  278.          Scale           =   0
  279.          Type            =   4
  280.          Name            =   "实发工资"
  281.          Caption         =   "实发工资"
  282.       EndProperty
  283.       NumGroups       =   0
  284.       ParamCount      =   2
  285.       BeginProperty P1 
  286.          RealName        =   "Param1"
  287.          Direction       =   1
  288.          Precision       =   10
  289.          Scale           =   0
  290.          Size            =   4
  291.          DataType        =   3
  292.          HostType        =   3
  293.          Required        =   -1  'True
  294.       EndProperty
  295.       BeginProperty P2 
  296.          RealName        =   "Param2"
  297.          Direction       =   1
  298.          Precision       =   10
  299.          Scale           =   0
  300.          Size            =   4
  301.          DataType        =   3
  302.          HostType        =   3
  303.          Required        =   -1  'True
  304.       EndProperty
  305.       RelationCount   =   0
  306.       AggregateCount  =   0
  307.    EndProperty
  308.    BeginProperty Recordset2 
  309.       CommandName     =   "Cmd_员工统计"
  310.       CommDispId      =   1042
  311.       RsDispId        =   1050
  312.       CommandText     =   $"DataEnvironment1.dsx":0167
  313.       ActiveConnectionName=   "Connection1"
  314.       CommandType     =   1
  315.       Expanded        =   -1  'True
  316.       IsRSReturning   =   -1  'True
  317.       NumFields       =   4
  318.       BeginProperty Field1 
  319.          Precision       =   0
  320.          Size            =   20
  321.          Scale           =   0
  322.          Type            =   200
  323.          Name            =   "部门"
  324.          Caption         =   "部门"
  325.       EndProperty
  326.       BeginProperty Field2 
  327.          Precision       =   0
  328.          Size            =   8
  329.          Scale           =   0
  330.          Type            =   200
  331.          Name            =   "用工类型"
  332.          Caption         =   "用工类型"
  333.       EndProperty
  334.       BeginProperty Field3 
  335.          Precision       =   0
  336.          Size            =   2
  337.          Scale           =   0
  338.          Type            =   200
  339.          Name            =   "性别"
  340.          Caption         =   "性别"
  341.       EndProperty
  342.       BeginProperty Field4 
  343.          Precision       =   10
  344.          Size            =   4
  345.          Scale           =   0
  346.          Type            =   3
  347.          Name            =   "人数"
  348.          Caption         =   "人数"
  349.       EndProperty
  350.       NumGroups       =   0
  351.       ParamCount      =   0
  352.       RelationCount   =   0
  353.       AggregateCount  =   0
  354.    EndProperty
  355.    BeginProperty Recordset3 
  356.       CommandName     =   "Cmd_年龄文化职位"
  357.       CommDispId      =   1051
  358.       RsDispId        =   1054
  359.       CommandText     =   "dbo.V_职位年龄文化"
  360.       ActiveConnectionName=   "Connection1"
  361.       CommandType     =   2
  362.       dbObjectType    =   2
  363.       IsRSReturning   =   -1  'True
  364.       NumFields       =   4
  365.       BeginProperty Field1 
  366.          Precision       =   0
  367.          Size            =   20
  368.          Scale           =   0
  369.          Type            =   200
  370.          Name            =   "职位类别"
  371.          Caption         =   "职位类别"
  372.       EndProperty
  373.       BeginProperty Field2 
  374.          Precision       =   0
  375.          Size            =   12
  376.          Scale           =   0
  377.          Type            =   200
  378.          Name            =   "年龄范围"
  379.          Caption         =   "年龄范围"
  380.       EndProperty
  381.       BeginProperty Field3 
  382.          Precision       =   0
  383.          Size            =   20
  384.          Scale           =   0
  385.          Type            =   200
  386.          Name            =   "学历"
  387.          Caption         =   "学历"
  388.       EndProperty
  389.       BeginProperty Field4 
  390.          Precision       =   10
  391.          Size            =   4
  392.          Scale           =   0
  393.          Type            =   3
  394.          Name            =   "人数"
  395.          Caption         =   "人数"
  396.       EndProperty
  397.       NumGroups       =   0
  398.       ParamCount      =   0
  399.       RelationCount   =   0
  400.       AggregateCount  =   0
  401.    EndProperty
  402.    BeginProperty Recordset4 
  403.       CommandName     =   "Cmd_人员增减变动"
  404.       CommDispId      =   1056
  405.       RsDispId        =   1060
  406.       CommandText     =   "SELECT 员工号, 姓名, 性别, 出生日期, 进入公司时间, 部门, 岗位, 原任职单位, 离职档案转出单位, 离职时间 FROM 员工基本信息"
  407.       ActiveConnectionName=   "Connection1"
  408.       CommandType     =   1
  409.       IsRSReturning   =   -1  'True
  410.       NumFields       =   10
  411.       BeginProperty Field1 
  412.          Precision       =   0
  413.          Size            =   10
  414.          Scale           =   0
  415.          Type            =   200
  416.          Name            =   "员工号"
  417.          Caption         =   "员工号"
  418.       EndProperty
  419.       BeginProperty Field2 
  420.          Precision       =   0
  421.          Size            =   30
  422.          Scale           =   0
  423.          Type            =   200
  424.          Name            =   "姓名"
  425.          Caption         =   "姓名"
  426.       EndProperty
  427.       BeginProperty Field3 
  428.          Precision       =   0
  429.          Size            =   2
  430.          Scale           =   0
  431.          Type            =   200
  432.          Name            =   "性别"
  433.          Caption         =   "性别"
  434.       EndProperty
  435.       BeginProperty Field4 
  436.          Precision       =   23
  437.          Size            =   16
  438.          Scale           =   3
  439.          Type            =   135
  440.          Name            =   "出生日期"
  441.          Caption         =   "出生日期"
  442.       EndProperty
  443.       BeginProperty Field5 
  444.          Precision       =   23
  445.          Size            =   16
  446.          Scale           =   3
  447.          Type            =   135
  448.          Name            =   "进入公司时间"
  449.          Caption         =   "进入公司时间"
  450.       EndProperty
  451.       BeginProperty Field6 
  452.          Precision       =   0
  453.          Size            =   20
  454.          Scale           =   0
  455.          Type            =   200
  456.          Name            =   "部门"
  457.          Caption         =   "部门"
  458.       EndProperty
  459.       BeginProperty Field7 
  460.          Precision       =   0
  461.          Size            =   20
  462.          Scale           =   0
  463.          Type            =   200
  464.          Name            =   "岗位"
  465.          Caption         =   "岗位"
  466.       EndProperty
  467.       BeginProperty Field8 
  468.          Precision       =   0
  469.          Size            =   20
  470.          Scale           =   0
  471.          Type            =   200
  472.          Name            =   "原任职单位"
  473.          Caption         =   "原任职单位"
  474.       EndProperty
  475.       BeginProperty Field9 
  476.          Precision       =   0
  477.          Size            =   20
  478.          Scale           =   0
  479.          Type            =   200
  480.          Name            =   "离职档案转出单位"
  481.          Caption         =   "离职档案转出单位"
  482.       EndProperty
  483.       BeginProperty Field10 
  484.          Precision       =   23
  485.          Size            =   16
  486.          Scale           =   3
  487.          Type            =   135
  488.          Name            =   "离职时间"
  489.          Caption         =   "离职时间"
  490.       EndProperty
  491.       NumGroups       =   0
  492.       ParamCount      =   0
  493.       RelationCount   =   0
  494.       AggregateCount  =   0
  495.    EndProperty
  496.    BeginProperty Recordset5 
  497.       CommandName     =   "Cmd_个人所得税"
  498.       CommDispId      =   1061
  499.       RsDispId        =   1065
  500.       CommandText     =   $"DataEnvironment1.dsx":030C
  501.       ActiveConnectionName=   "Connection1"
  502.       CommandType     =   1
  503.       IsRSReturning   =   -1  'True
  504.       NumFields       =   7
  505.       BeginProperty Field1 
  506.          Precision       =   7
  507.          Size            =   4
  508.          Scale           =   0
  509.          Type            =   4
  510.          Name            =   "税率"
  511.          Caption         =   "税率"
  512.       EndProperty
  513.       BeginProperty Field2 
  514.          Precision       =   10
  515.          Size            =   4
  516.          Scale           =   0
  517.          Type            =   3
  518.          Name            =   "同一税率人数"
  519.          Caption         =   "同一税率人数"
  520.       EndProperty
  521.       BeginProperty Field3 
  522.          Precision       =   15
  523.          Size            =   8
  524.          Scale           =   0
  525.          Type            =   5
  526.          Name            =   "人民币金额"
  527.          Caption         =   "人民币金额"
  528.       EndProperty
  529.       BeginProperty Field4 
  530.          Precision       =   7
  531.          Size            =   4
  532.          Scale           =   0
  533.          Type            =   4
  534.          Name            =   "减费用额"
  535.          Caption         =   "减费用额"
  536.       EndProperty
  537.       BeginProperty Field5 
  538.          Precision       =   15
  539.          Size            =   8
  540.          Scale           =   0
  541.          Type            =   5
  542.          Name            =   "应纳税所得额"
  543.          Caption         =   "应纳税所得额"
  544.       EndProperty
  545.       BeginProperty Field6 
  546.          Precision       =   7
  547.          Size            =   4
  548.          Scale           =   0
  549.          Type            =   4
  550.          Name            =   "速算扣除数"
  551.          Caption         =   "速算扣除数"
  552.       EndProperty
  553.       BeginProperty Field7 
  554.          Precision       =   15
  555.          Size            =   8
  556.          Scale           =   0
  557.          Type            =   5
  558.          Name            =   "扣缴所得额"
  559.          Caption         =   "扣缴所得额"
  560.       EndProperty
  561.       NumGroups       =   0
  562.       ParamCount      =   2
  563.       BeginProperty P1 
  564.          RealName        =   "Param1"
  565.          Direction       =   1
  566.          Precision       =   10
  567.          Scale           =   0
  568.          Size            =   4
  569.          DataType        =   3
  570.          HostType        =   3
  571.          Required        =   -1  'True
  572.       EndProperty
  573.       BeginProperty P2 
  574.          RealName        =   "Param2"
  575.          Direction       =   1
  576.          Precision       =   10
  577.          Scale           =   0
  578.          Size            =   4
  579.          DataType        =   3
  580.          HostType        =   3
  581.          Required        =   -1  'True
  582.       EndProperty
  583.       RelationCount   =   0
  584.       AggregateCount  =   0
  585.    EndProperty
  586.    BeginProperty Recordset6 
  587.       CommandName     =   "cmd_工资统计"
  588.       CommDispId      =   1066
  589.       RsDispId        =   1071
  590.       CommandText     =   $"DataEnvironment1.dsx":03FC
  591.       ActiveConnectionName=   "Connection1"
  592.       CommandType     =   1
  593.       IsRSReturning   =   -1  'True
  594.       NumFields       =   12
  595.       BeginProperty Field1 
  596.          Precision       =   10
  597.          Size            =   4
  598.          Scale           =   0
  599.          Type            =   3
  600.          Name            =   "月份"
  601.          Caption         =   "月份"
  602.       EndProperty
  603.       BeginProperty Field2 
  604.          Precision       =   10
  605.          Size            =   4
  606.          Scale           =   0
  607.          Type            =   3
  608.          Name            =   "年度"
  609.          Caption         =   "年度"
  610.       EndProperty
  611.       BeginProperty Field3 
  612.          Precision       =   0
  613.          Size            =   10
  614.          Scale           =   0
  615.          Type            =   200
  616.          Name            =   "员工号"
  617.          Caption         =   "员工号"
  618.       EndProperty
  619.       BeginProperty Field4 
  620.          Precision       =   0
  621.          Size            =   30
  622.          Scale           =   0
  623.          Type            =   200
  624.          Name            =   "姓名"
  625.          Caption         =   "姓名"
  626.       EndProperty
  627.       BeginProperty Field5 
  628.          Precision       =   7
  629.          Size            =   4
  630.          Scale           =   0
  631.          Type            =   4
  632.          Name            =   "基本工资"
  633.          Caption         =   "基本工资"
  634.       EndProperty
  635.       BeginProperty Field6 
  636.          Precision       =   7
  637.          Size            =   4
  638.          Scale           =   0
  639.          Type            =   4
  640.          Name            =   "岗位工资"
  641.          Caption         =   "岗位工资"
  642.       EndProperty
  643.       BeginProperty Field7 
  644.          Precision       =   7
  645.          Size            =   4
  646.          Scale           =   0
  647.          Type            =   4
  648.          Name            =   "考核分奖金"
  649.          Caption         =   "考核分奖金"
  650.       EndProperty
  651.       BeginProperty Field8 
  652.          Precision       =   7
  653.          Size            =   4
  654.          Scale           =   0
  655.          Type            =   4
  656.          Name            =   "加班费小计"
  657.          Caption         =   "加班费小计"
  658.       EndProperty
  659.       BeginProperty Field9 
  660.          Precision       =   7
  661.          Size            =   4
  662.          Scale           =   0
  663.          Type            =   4
  664.          Name            =   "医疗包干"
  665.          Caption         =   "医疗包干"
  666.       EndProperty
  667.       BeginProperty Field10 
  668.          Precision       =   7
  669.          Size            =   4
  670.          Scale           =   0
  671.          Type            =   4
  672.          Name            =   "子女医疗包干"
  673.          Caption         =   "子女医疗包干"
  674.       EndProperty
  675.       BeginProperty Field11 
  676.          Precision       =   7
  677.          Size            =   4
  678.          Scale           =   0
  679.          Type            =   4
  680.          Name            =   "过节费"
  681.          Caption         =   "过节费"
  682.       EndProperty
  683.       BeginProperty Field12 
  684.          Precision       =   7
  685.          Size            =   4
  686.          Scale           =   0
  687.          Type            =   4
  688.          Name            =   "实发工资"
  689.          Caption         =   "实发工资"
  690.       EndProperty
  691.       NumGroups       =   0
  692.       ParamCount      =   2
  693.       BeginProperty P1 
  694.          RealName        =   "Param1"
  695.          Direction       =   1
  696.          Precision       =   10
  697.          Scale           =   0
  698.          Size            =   4
  699.          DataType        =   3
  700.          HostType        =   3
  701.          Required        =   -1  'True
  702.       EndProperty
  703.       BeginProperty P2 
  704.          RealName        =   "Param2"
  705.          Direction       =   1
  706.          Precision       =   10
  707.          Scale           =   0
  708.          Size            =   4
  709.          DataType        =   3
  710.          HostType        =   3
  711.          Required        =   -1  'True
  712.       EndProperty
  713.       RelationCount   =   0
  714.       AggregateCount  =   0
  715.    EndProperty
  716.    BeginProperty Recordset7 
  717.       CommandName     =   "Cmd_部门月工资"
  718.       CommDispId      =   1072
  719.       RsDispId        =   1084
  720.       CommandText     =   $"DataEnvironment1.dsx":04A3
  721.       ActiveConnectionName=   "Connection1"
  722.       CommandType     =   1
  723.       IsRSReturning   =   -1  'True
  724.       NumFields       =   35
  725.       BeginProperty Field1 
  726.          Precision       =   0
  727.          Size            =   10
  728.          Scale           =   0
  729.          Type            =   200
  730.          Name            =   "部门名称"
  731.          Caption         =   "部门名称"
  732.       EndProperty
  733.       BeginProperty Field2 
  734.          Precision       =   10
  735.          Size            =   4
  736.          Scale           =   0
  737.          Type            =   3
  738.          Name            =   "人数"
  739.          Caption         =   "人数"
  740.       EndProperty
  741.       BeginProperty Field3 
  742.          Precision       =   15
  743.          Size            =   8
  744.          Scale           =   0
  745.          Type            =   5
  746.          Name            =   "岗位工资"
  747.          Caption         =   "岗位工资"
  748.       EndProperty
  749.       BeginProperty Field4 
  750.          Precision       =   15
  751.          Size            =   8
  752.          Scale           =   0
  753.          Type            =   5
  754.          Name            =   "效益工资"
  755.          Caption         =   "效益工资"
  756.       EndProperty
  757.       BeginProperty Field5 
  758.          Precision       =   15
  759.          Size            =   8
  760.          Scale           =   0
  761.          Type            =   5
  762.          Name            =   "基本福利"
  763.          Caption         =   "基本福利"
  764.       EndProperty
  765.       BeginProperty Field6 
  766.          Precision       =   15
  767.          Size            =   8
  768.          Scale           =   0
  769.          Type            =   5
  770.          Name            =   "工龄"
  771.          Caption         =   "工龄"
  772.       EndProperty
  773.       BeginProperty Field7 
  774.          Precision       =   15
  775.          Size            =   8
  776.          Scale           =   0
  777.          Type            =   5
  778.          Name            =   "司龄工资"
  779.          Caption         =   "司龄工资"
  780.       EndProperty
  781.       BeginProperty Field8 
  782.          Precision       =   15
  783.          Size            =   8
  784.          Scale           =   0
  785.          Type            =   5
  786.          Name            =   "加班津贴"
  787.          Caption         =   "加班津贴"
  788.       EndProperty
  789.       BeginProperty Field9 
  790.          Precision       =   15
  791.          Size            =   8
  792.          Scale           =   0
  793.          Type            =   5
  794.          Name            =   "夜班津贴"
  795.          Caption         =   "夜班津贴"
  796.       EndProperty
  797.       BeginProperty Field10 
  798.          Precision       =   15
  799.          Size            =   8
  800.          Scale           =   0
  801.          Type            =   5
  802.          Name            =   "值班津贴"
  803.          Caption         =   "值班津贴"
  804.       EndProperty
  805.       BeginProperty Field11 
  806.          Precision       =   15
  807.          Size            =   8
  808.          Scale           =   0
  809.          Type            =   5
  810.          Name            =   "特勤津贴"
  811.          Caption         =   "特勤津贴"
  812.       EndProperty
  813.       BeginProperty Field12 
  814.          Precision       =   15
  815.          Size            =   8
  816.          Scale           =   0
  817.          Type            =   5
  818.          Name            =   "销售奖金"
  819.          Caption         =   "销售奖金"
  820.       EndProperty
  821.       BeginProperty Field13 
  822.          Precision       =   15
  823.          Size            =   8
  824.          Scale           =   0
  825.          Type            =   5
  826.          Name            =   "月奖"
  827.          Caption         =   "月奖"
  828.       EndProperty
  829.       BeginProperty Field14 
  830.          Precision       =   15
  831.          Size            =   8
  832.          Scale           =   0
  833.          Type            =   5
  834.          Name            =   "奖励基金"
  835.          Caption         =   "奖励基金"
  836.       EndProperty
  837.       BeginProperty Field15 
  838.          Precision       =   15
  839.          Size            =   8
  840.          Scale           =   0
  841.          Type            =   5
  842.          Name            =   "小计"
  843.          Caption         =   "小计"
  844.       EndProperty
  845.       BeginProperty Field16 
  846.          Precision       =   15
  847.          Size            =   8
  848.          Scale           =   0
  849.          Type            =   5
  850.          Name            =   "公积金"
  851.          Caption         =   "公积金"
  852.       EndProperty
  853.       BeginProperty Field17 
  854.          Precision       =   15
  855.          Size            =   8
  856.          Scale           =   0
  857.          Type            =   5
  858.          Name            =   "大病统筹"
  859.          Caption         =   "大病统筹"
  860.       EndProperty
  861.       BeginProperty Field18 
  862.          Precision       =   15
  863.          Size            =   8
  864.          Scale           =   0
  865.          Type            =   5
  866.          Name            =   "养老保险"
  867.          Caption         =   "养老保险"
  868.       EndProperty
  869.       BeginProperty Field19 
  870.          Precision       =   15
  871.          Size            =   8
  872.          Scale           =   0
  873.          Type            =   5
  874.          Name            =   "失业保险"
  875.          Caption         =   "失业保险"
  876.       EndProperty
  877.       BeginProperty Field20 
  878.          Precision       =   15
  879.          Size            =   8
  880.          Scale           =   0
  881.          Type            =   5
  882.          Name            =   "扣事假"
  883.          Caption         =   "扣事假"
  884.       EndProperty
  885.       BeginProperty Field21 
  886.          Precision       =   15
  887.          Size            =   8
  888.          Scale           =   0
  889.          Type            =   5
  890.          Name            =   "扣病假"
  891.          Caption         =   "扣病假"
  892.       EndProperty
  893.       BeginProperty Field22 
  894.          Precision       =   15
  895.          Size            =   8
  896.          Scale           =   0
  897.          Type            =   5
  898.          Name            =   "过失扣款"
  899.          Caption         =   "过失扣款"
  900.       EndProperty
  901.       BeginProperty Field23 
  902.          Precision       =   15
  903.          Size            =   8
  904.          Scale           =   0
  905.          Type            =   5
  906.          Name            =   "公司扣款"
  907.          Caption         =   "公司扣款"
  908.       EndProperty
  909.       BeginProperty Field24 
  910.          Precision       =   15
  911.          Size            =   8
  912.          Scale           =   0
  913.          Type            =   5
  914.          Name            =   "应税额"
  915.          Caption         =   "应税额"
  916.       EndProperty
  917.       BeginProperty Field25 
  918.          Precision       =   15
  919.          Size            =   8
  920.          Scale           =   0
  921.          Type            =   5
  922.          Name            =   "扣所得税"
  923.          Caption         =   "扣所得税"
  924.       EndProperty
  925.       BeginProperty Field26 
  926.          Precision       =   15
  927.          Size            =   8
  928.          Scale           =   0
  929.          Type            =   5
  930.          Name            =   "代扣房租"
  931.          Caption         =   "代扣房租"
  932.       EndProperty
  933.       BeginProperty Field27 
  934.          Precision       =   15
  935.          Size            =   8
  936.          Scale           =   0
  937.          Type            =   5
  938.          Name            =   "扣餐费"
  939.          Caption         =   "扣餐费"
  940.       EndProperty
  941.       BeginProperty Field28 
  942.          Precision       =   15
  943.          Size            =   8
  944.          Scale           =   0
  945.          Type            =   5
  946.          Name            =   "其他扣款"
  947.          Caption         =   "其他扣款"
  948.       EndProperty
  949.       BeginProperty Field29 
  950.          Precision       =   15
  951.          Size            =   8
  952.          Scale           =   0
  953.          Type            =   5
  954.          Name            =   "代扣会费"
  955.          Caption         =   "代扣会费"
  956.       EndProperty
  957.       BeginProperty Field30 
  958.          Precision       =   15
  959.          Size            =   8
  960.          Scale           =   0
  961.          Type            =   5
  962.          Name            =   "应发额"
  963.          Caption         =   "应发额"
  964.       EndProperty
  965.       BeginProperty Field31 
  966.          Precision       =   15
  967.          Size            =   8
  968.          Scale           =   0
  969.          Type            =   5
  970.          Name            =   "荣誉津贴"
  971.          Caption         =   "荣誉津贴"
  972.       EndProperty
  973.       BeginProperty Field32 
  974.          Precision       =   15
  975.          Size            =   8
  976.          Scale           =   0
  977.          Type            =   5
  978.          Name            =   "其他补贴"
  979.          Caption         =   "其他补贴"
  980.       EndProperty
  981.       BeginProperty Field33 
  982.          Precision       =   15
  983.          Size            =   8
  984.          Scale           =   0
  985.          Type            =   5
  986.          Name            =   "实发工资"
  987.          Caption         =   "实发工资"
  988.       EndProperty
  989.       BeginProperty Field34 
  990.          Precision       =   10
  991.          Size            =   4
  992.          Scale           =   0
  993.          Type            =   3
  994.          Name            =   "年度"
  995.          Caption         =   "年度"
  996.       EndProperty
  997.       BeginProperty Field35 
  998.          Precision       =   10
  999.          Size            =   4
  1000.          Scale           =   0
  1001.          Type            =   3
  1002.          Name            =   "月份"
  1003.          Caption         =   "月份"
  1004.       EndProperty
  1005.       NumGroups       =   0
  1006.       ParamCount      =   2
  1007.       BeginProperty P1 
  1008.          RealName        =   "Param1"
  1009.          Direction       =   1
  1010.          Precision       =   10
  1011.          Scale           =   0
  1012.          Size            =   4
  1013.          DataType        =   3
  1014.          HostType        =   3
  1015.          Required        =   -1  'True
  1016.       EndProperty
  1017.       BeginProperty P2 
  1018.          RealName        =   "Param2"
  1019.          Direction       =   1
  1020.          Precision       =   10
  1021.          Scale           =   0
  1022.          Size            =   4
  1023.          DataType        =   3
  1024.          HostType        =   3
  1025.          Required        =   -1  'True
  1026.       EndProperty
  1027.       RelationCount   =   0
  1028.       AggregateCount  =   0
  1029.    EndProperty
  1030.    BeginProperty Recordset8 
  1031.       CommandName     =   "Cmd_个人月工资"
  1032.       CommDispId      =   1077
  1033.       RsDispId        =   1087
  1034.       CommandText     =   $"DataEnvironment1.dsx":0838
  1035.       ActiveConnectionName=   "Connection1"
  1036.       CommandType     =   1
  1037.       Grouping        =   -1  'True
  1038.       GroupingName    =   "Cmd_个人月工资_Grouping"
  1039.       Expanded        =   -1  'True
  1040.       DetailExpanded  =   -1  'True
  1041.       IsRSReturning   =   -1  'True
  1042.       NumFields       =   35
  1043.       BeginProperty Field1 
  1044.          Precision       =   23
  1045.          Size            =   16
  1046.          Scale           =   3
  1047.          Type            =   135
  1048.          Name            =   "发薪日期"
  1049.          Caption         =   "发薪日期"
  1050.       EndProperty
  1051.       BeginProperty Field2 
  1052.          Precision       =   0
  1053.          Size            =   10
  1054.          Scale           =   0
  1055.          Type            =   200
  1056.          Name            =   "部门名称"
  1057.          Caption         =   "部门名称"
  1058.       EndProperty
  1059.       BeginProperty Field3 
  1060.          Precision       =   0
  1061.          Size            =   10
  1062.          Scale           =   0
  1063.          Type            =   200
  1064.          Name            =   "员工号"
  1065.          Caption         =   "员工号"
  1066.       EndProperty
  1067.       BeginProperty Field4 
  1068.          Precision       =   0
  1069.          Size            =   20
  1070.          Scale           =   0
  1071.          Type            =   200
  1072.          Name            =   "姓名"
  1073.          Caption         =   "姓名"
  1074.       EndProperty
  1075.       BeginProperty Field5 
  1076.          Precision       =   7
  1077.          Size            =   4
  1078.          Scale           =   0
  1079.          Type            =   4
  1080.          Name            =   "岗位工资"
  1081.          Caption         =   "岗位工资"
  1082.       EndProperty
  1083.       BeginProperty Field6 
  1084.          Precision       =   7
  1085.          Size            =   4
  1086.          Scale           =   0
  1087.          Type            =   4
  1088.          Name            =   "效益工资"
  1089.          Caption         =   "效益工资"
  1090.       EndProperty
  1091.       BeginProperty Field7 
  1092.          Precision       =   7
  1093.          Size            =   4
  1094.          Scale           =   0
  1095.          Type            =   4
  1096.          Name            =   "基本福利"
  1097.          Caption         =   "基本福利"
  1098.       EndProperty
  1099.       BeginProperty Field8 
  1100.          Precision       =   7
  1101.          Size            =   4
  1102.          Scale           =   0
  1103.          Type            =   4
  1104.          Name            =   "工龄"
  1105.          Caption         =   "工龄"
  1106.       EndProperty
  1107.       BeginProperty Field9 
  1108.          Precision       =   7
  1109.          Size            =   4
  1110.          Scale           =   0
  1111.          Type            =   4
  1112.          Name            =   "司龄工资"
  1113.          Caption         =   "司龄工资"
  1114.       EndProperty
  1115.       BeginProperty Field10 
  1116.          Precision       =   7
  1117.          Size            =   4
  1118.          Scale           =   0
  1119.          Type            =   4
  1120.          Name            =   "加班津贴"
  1121.          Caption         =   "加班津贴"
  1122.       EndProperty
  1123.       BeginProperty Field11 
  1124.          Precision       =   7
  1125.          Size            =   4
  1126.          Scale           =   0
  1127.          Type            =   4
  1128.          Name            =   "夜班津贴"
  1129.          Caption         =   "夜班津贴"
  1130.       EndProperty
  1131.       BeginProperty Field12 
  1132.          Precision       =   7
  1133.          Size            =   4
  1134.          Scale           =   0
  1135.          Type            =   4
  1136.          Name            =   "值班津贴"
  1137.          Caption         =   "值班津贴"
  1138.       EndProperty
  1139.       BeginProperty Field13 
  1140.          Precision       =   7
  1141.          Size            =   4
  1142.          Scale           =   0
  1143.          Type            =   4
  1144.          Name            =   "特勤津贴"
  1145.          Caption         =   "特勤津贴"
  1146.       EndProperty
  1147.       BeginProperty Field14 
  1148.          Precision       =   7
  1149.          Size            =   4
  1150.          Scale           =   0
  1151.          Type            =   4
  1152.          Name            =   "销售奖金"
  1153.          Caption         =   "销售奖金"
  1154.       EndProperty
  1155.       BeginProperty Field15 
  1156.          Precision       =   7
  1157.          Size            =   4
  1158.          Scale           =   0
  1159.          Type            =   4
  1160.          Name            =   "月奖"
  1161.          Caption         =   "月奖"
  1162.       EndProperty
  1163.       BeginProperty Field16 
  1164.          Precision       =   7
  1165.          Size            =   4
  1166.          Scale           =   0
  1167.          Type            =   4
  1168.          Name            =   "奖励基金"
  1169.          Caption         =   "奖励基金"
  1170.       EndProperty
  1171.       BeginProperty Field17 
  1172.          Precision       =   7
  1173.          Size            =   4
  1174.          Scale           =   0
  1175.          Type            =   4
  1176.          Name            =   "小计"
  1177.          Caption         =   "小计"
  1178.       EndProperty
  1179.       BeginProperty Field18 
  1180.          Precision       =   7
  1181.          Size            =   4
  1182.          Scale           =   0
  1183.          Type            =   4
  1184.          Name            =   "公积金"
  1185.          Caption         =   "公积金"
  1186.       EndProperty
  1187.       BeginProperty Field19 
  1188.          Precision       =   7
  1189.          Size            =   4
  1190.          Scale           =   0
  1191.          Type            =   4
  1192.          Name            =   "大病统筹"
  1193.          Caption         =   "大病统筹"
  1194.       EndProperty
  1195.       BeginProperty Field20 
  1196.          Precision       =   7
  1197.          Size            =   4
  1198.          Scale           =   0
  1199.          Type            =   4
  1200.          Name            =   "养老保险"
  1201.          Caption         =   "养老保险"
  1202.       EndProperty
  1203.       BeginProperty Field21 
  1204.          Precision       =   7
  1205.          Size            =   4
  1206.          Scale           =   0
  1207.          Type            =   4
  1208.          Name            =   "失业保险"
  1209.          Caption         =   "失业保险"
  1210.       EndProperty
  1211.       BeginProperty Field22 
  1212.          Precision       =   7
  1213.          Size            =   4
  1214.          Scale           =   0
  1215.          Type            =   4
  1216.          Name            =   "扣事假"
  1217.          Caption         =   "扣事假"
  1218.       EndProperty
  1219.       BeginProperty Field23 
  1220.          Precision       =   7
  1221.          Size            =   4
  1222.          Scale           =   0
  1223.          Type            =   4
  1224.          Name            =   "扣病假"
  1225.          Caption         =   "扣病假"
  1226.       EndProperty
  1227.       BeginProperty Field24 
  1228.          Precision       =   7
  1229.          Size            =   4
  1230.          Scale           =   0
  1231.          Type            =   4
  1232.          Name            =   "过失扣款"
  1233.          Caption         =   "过失扣款"
  1234.       EndProperty
  1235.       BeginProperty Field25 
  1236.          Precision       =   7
  1237.          Size            =   4
  1238.          Scale           =   0
  1239.          Type            =   4
  1240.          Name            =   "公司扣款"
  1241.          Caption         =   "公司扣款"
  1242.       EndProperty
  1243.       BeginProperty Field26 
  1244.          Precision       =   7
  1245.          Size            =   4
  1246.          Scale           =   0
  1247.          Type            =   4
  1248.          Name            =   "应税额"
  1249.          Caption         =   "应税额"
  1250.       EndProperty
  1251.       BeginProperty Field27 
  1252.          Precision       =   7
  1253.          Size            =   4
  1254.          Scale           =   0
  1255.          Type            =   4
  1256.          Name            =   "扣所得税"
  1257.          Caption         =   "扣所得税"
  1258.       EndProperty
  1259.       BeginProperty Field28 
  1260.          Precision       =   7
  1261.          Size            =   4
  1262.          Scale           =   0
  1263.          Type            =   4
  1264.          Name            =   "代扣房租"
  1265.          Caption         =   "代扣房租"
  1266.       EndProperty
  1267.       BeginProperty Field29 
  1268.          Precision       =   7
  1269.          Size            =   4
  1270.          Scale           =   0
  1271.          Type            =   4
  1272.          Name            =   "扣餐费"
  1273.          Caption         =   "扣餐费"
  1274.       EndProperty
  1275.       BeginProperty Field30 
  1276.          Precision       =   7
  1277.          Size            =   4
  1278.          Scale           =   0
  1279.          Type            =   4
  1280.          Name            =   "其他扣款"
  1281.          Caption         =   "其他扣款"
  1282.       EndProperty
  1283.       BeginProperty Field31 
  1284.          Precision       =   7
  1285.          Size            =   4
  1286.          Scale           =   0
  1287.          Type            =   4
  1288.          Name            =   "代扣会费"
  1289.          Caption         =   "代扣会费"
  1290.       EndProperty
  1291.       BeginProperty Field32 
  1292.          Precision       =   7
  1293.          Size            =   4
  1294.          Scale           =   0
  1295.          Type            =   4
  1296.          Name            =   "应发额"
  1297.          Caption         =   "应发额"
  1298.       EndProperty
  1299.       BeginProperty Field33 
  1300.          Precision       =   7
  1301.          Size            =   4
  1302.          Scale           =   0
  1303.          Type            =   4
  1304.          Name            =   "荣誉津贴"
  1305.          Caption         =   "荣誉津贴"
  1306.       EndProperty
  1307.       BeginProperty Field34 
  1308.          Precision       =   7
  1309.          Size            =   4
  1310.          Scale           =   0
  1311.          Type            =   4
  1312.          Name            =   "其他补贴"
  1313.          Caption         =   "其他补贴"
  1314.       EndProperty
  1315.       BeginProperty Field35 
  1316.          Precision       =   7
  1317.          Size            =   4
  1318.          Scale           =   0
  1319.          Type            =   4
  1320.          Name            =   "实发工资"
  1321.          Caption         =   "实发工资"
  1322.       EndProperty
  1323.       NumGroups       =   0
  1324.       ParamCount      =   2
  1325.       BeginProperty P1 
  1326.          RealName        =   "Param1"
  1327.          Direction       =   1
  1328.          Precision       =   10
  1329.          Scale           =   0
  1330.          Size            =   4
  1331.          DataType        =   3
  1332.          HostType        =   3
  1333.          Required        =   -1  'True
  1334.          ParamValue      =   "1999"
  1335.       EndProperty
  1336.       BeginProperty P2 
  1337.          RealName        =   "Param2"
  1338.          Direction       =   1
  1339.          Precision       =   10
  1340.          Scale           =   0
  1341.          Size            =   4
  1342.          DataType        =   3
  1343.          HostType        =   3
  1344.          Required        =   -1  'True
  1345.          ParamValue      =   "1"
  1346.       EndProperty
  1347.       RelationCount   =   0
  1348.       AggregateCount  =   0
  1349.    EndProperty
  1350.    BeginProperty Recordset9 
  1351.       CommandName     =   "Cmd_工会会费"
  1352.       CommDispId      =   1088
  1353.       RsDispId        =   -1
  1354.       ActiveConnectionName=   "Connection1"
  1355.       CommandType     =   1
  1356.       NumFields       =   0
  1357.       NumGroups       =   0
  1358.       ParamCount      =   0
  1359.       RelationCount   =   0
  1360.       AggregateCount  =   0
  1361.    EndProperty
  1362. End
  1363. Attribute VB_Name = "DataEnvironment1"
  1364. Attribute VB_GlobalNameSpace = False
  1365. Attribute VB_Creatable = True
  1366. Attribute VB_PredeclaredId = True
  1367. Attribute VB_Exposed = False
  1368. Private Sub rsCommand2_WillChangeField(ByVal cFields As Long, ByVal Fields As Variant, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
  1369. End Sub
  1370. Private Sub rsCmd_个人月工资_WillChangeField(ByVal cFields As Long, ByVal Fields As Variant, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
  1371. End Sub