DataEnvironment1.Dsr
资源名称:dbbase.rar [点击查看]
上传用户:xiao_xia32
上传日期:2022-07-21
资源大小:1174k
文件大小:50k
源码类别:
企业管理
开发平台:
Visual Basic
- VERSION 5.00
- Begin {C0E45035-5775-11D0-B388-00A0C9055D8E} DataEnvironment1
- ClientHeight = 9630
- ClientLeft = 0
- ClientTop = 0
- ClientWidth = 10965
- _ExtentX = 19341
- _ExtentY = 16986
- FolderFlags = 5
- TypeLibGuid = "{8D1C249C-B4BA-11D2-9257-00104B369F59}"
- TypeInfoGuid = "{8D1C249D-B4BA-11D2-9257-00104B369F59}"
- TypeInfoCookie = 0
- Version = 4
- NumConnections = 1
- BeginProperty Connection1
- ConnectionName = "Connection1"
- ConnDispId = 1001
- SourceOfData = 3
- ConnectionSource= "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=STEVENSERVER"
- Expanded = -1 'True
- IsSQL = -1 'True
- QuoteChar = 34
- SeparatorChar = 46
- EndProperty
- NumRecordsets = 15
- BeginProperty Recordset1
- CommandName = "Command1"
- CommDispId = 1002
- RsDispId = 1005
- CommandText = "dbo.领取明细表"
- ActiveConnectionName= "Connection1"
- CommandType = 2
- dbObjectType = 1
- IsRSReturning = -1 'True
- NumFields = 9
- BeginProperty Field1
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "ID"
- Caption = "ID"
- EndProperty
- BeginProperty Field2
- Precision = 0
- Size = 20
- Scale = 0
- Type = 129
- Name = "商品名称"
- Caption = "商品名称"
- EndProperty
- BeginProperty Field3
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "商品编号"
- Caption = "商品编号"
- EndProperty
- BeginProperty Field4
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "数量"
- Caption = "数量"
- EndProperty
- BeginProperty Field5
- Precision = 19
- Size = 8
- Scale = 0
- Type = 6
- Name = "金额"
- Caption = "金额"
- EndProperty
- BeginProperty Field6
- Precision = 0
- Size = 20
- Scale = 0
- Type = 129
- Name = "领取单位"
- Caption = "领取单位"
- EndProperty
- BeginProperty Field7
- Precision = 0
- Size = 10
- Scale = 0
- Type = 129
- Name = "领取人"
- Caption = "领取人"
- EndProperty
- BeginProperty Field8
- Precision = 0
- Size = 10
- Scale = 0
- Type = 129
- Name = "管理员"
- Caption = "管理员"
- EndProperty
- BeginProperty Field9
- Precision = 23
- Size = 16
- Scale = 3
- Type = 135
- Name = "领取日期"
- Caption = "领取日期"
- EndProperty
- NumGroups = 0
- ParamCount = 0
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset2
- CommandName = "DHSP"
- CommDispId = 1009
- RsDispId = -1
- CommandText = "SELECT * FROM 动火审批记录表 where 编号=?"
- ActiveConnectionName= "Connection1"
- CommandType = 1
- Expanded = -1 'True
- NumFields = 0
- NumGroups = 0
- ParamCount = 1
- BeginProperty P1
- RealName = "Param1"
- Direction = 1
- Precision = 10
- Scale = 0
- Size = 4
- DataType = 3
- HostType = 3
- Required = -1 'True
- EndProperty
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset3
- CommandName = "物品明细帐"
- CommDispId = 1011
- RsDispId = 1107
- CommandText = "SELECT * FROM 物品明细帐 WHERE (日期 >= ?) AND (日期 <= ?)"
- ActiveConnectionName= "Connection1"
- CommandType = 1
- IsRSReturning = -1 'True
- NumFields = 11
- BeginProperty Field1
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "id"
- Caption = "id"
- EndProperty
- BeginProperty Field2
- Precision = 23
- Size = 16
- Scale = 3
- Type = 135
- Name = "日期"
- Caption = "日期"
- EndProperty
- BeginProperty Field3
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "名称"
- Caption = "名称"
- EndProperty
- BeginProperty Field4
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "商品编号"
- Caption = "商品编号"
- EndProperty
- BeginProperty Field5
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "物资子类"
- Caption = "物资子类"
- EndProperty
- BeginProperty Field6
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "数量"
- Caption = "数量"
- EndProperty
- BeginProperty Field7
- Precision = 19
- Size = 8
- Scale = 0
- Type = 6
- Name = "单价"
- Caption = "单价"
- EndProperty
- BeginProperty Field8
- Precision = 19
- Size = 8
- Scale = 0
- Type = 6
- Name = "金额"
- Caption = "金额"
- EndProperty
- BeginProperty Field9
- Precision = 0
- Size = 4
- Scale = 0
- Type = 200
- Name = "收入或支出"
- Caption = "收入或支出"
- EndProperty
- BeginProperty Field10
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "去向"
- Caption = "去向"
- EndProperty
- BeginProperty Field11
- Precision = 19
- Size = 8
- Scale = 0
- Type = 6
- Name = "合计"
- Caption = "合计"
- EndProperty
- NumGroups = 0
- ParamCount = 2
- BeginProperty P1
- RealName = "Param1"
- Direction = 1
- Precision = 23
- Scale = 3
- Size = 16
- DataType = 135
- HostType = 7
- Required = -1 'True
- EndProperty
- BeginProperty P2
- RealName = "Param2"
- Direction = 1
- Precision = 23
- Scale = 3
- Size = 16
- DataType = 135
- HostType = 7
- Required = -1 'True
- EndProperty
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset4
- CommandName = "物品分类帐"
- CommDispId = 1034
- RsDispId = 1114
- CommandText = "SELECT * FROM 物品明细帐 WHERE (物资子类 = ?)"
- ActiveConnectionName= "Connection1"
- CommandType = 1
- IsRSReturning = -1 'True
- NumFields = 11
- BeginProperty Field1
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "id"
- Caption = "id"
- EndProperty
- BeginProperty Field2
- Precision = 23
- Size = 16
- Scale = 3
- Type = 135
- Name = "日期"
- Caption = "日期"
- EndProperty
- BeginProperty Field3
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "名称"
- Caption = "名称"
- EndProperty
- BeginProperty Field4
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "商品编号"
- Caption = "商品编号"
- EndProperty
- BeginProperty Field5
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "物资子类"
- Caption = "物资子类"
- EndProperty
- BeginProperty Field6
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "数量"
- Caption = "数量"
- EndProperty
- BeginProperty Field7
- Precision = 19
- Size = 8
- Scale = 0
- Type = 6
- Name = "单价"
- Caption = "单价"
- EndProperty
- BeginProperty Field8
- Precision = 19
- Size = 8
- Scale = 0
- Type = 6
- Name = "金额"
- Caption = "金额"
- EndProperty
- BeginProperty Field9
- Precision = 0
- Size = 4
- Scale = 0
- Type = 200
- Name = "收入或支出"
- Caption = "收入或支出"
- EndProperty
- BeginProperty Field10
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "去向"
- Caption = "去向"
- EndProperty
- BeginProperty Field11
- Precision = 19
- Size = 8
- Scale = 0
- Type = 6
- Name = "合计"
- Caption = "合计"
- EndProperty
- NumGroups = 0
- ParamCount = 1
- BeginProperty P1
- RealName = "Param1"
- Direction = 1
- Precision = 20
- Scale = 0
- Size = 20
- DataType = 200
- HostType = 8
- Required = -1 'True
- EndProperty
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset5
- CommandName = "物品外运"
- CommDispId = 1039
- RsDispId = 1045
- CommandText = "SELECT *, 编号 FROM 物品外运登记表 WHERE (编号 = ?)"
- ActiveConnectionName= "Connection1"
- CommandType = 1
- IsRSReturning = -1 'True
- NumFields = 16
- BeginProperty Field1
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "编号"
- Caption = "编号"
- EndProperty
- BeginProperty Field2
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "申报部门"
- Caption = "申报部门"
- EndProperty
- BeginProperty Field3
- Precision = 23
- Size = 16
- Scale = 3
- Type = 135
- Name = "日期"
- Caption = "日期"
- EndProperty
- BeginProperty Field4
- Precision = 0
- Size = 50
- Scale = 0
- Type = 200
- Name = "运出准确时间"
- Caption = "运出准确时间"
- EndProperty
- BeginProperty Field5
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "物品名称"
- Caption = "物品名称"
- EndProperty
- BeginProperty Field6
- Precision = 0
- Size = 8
- Scale = 0
- Type = 200
- Name = "规格"
- Caption = "规格"
- EndProperty
- BeginProperty Field7
- Precision = 0
- Size = 8
- Scale = 0
- Type = 200
- Name = "单位"
- Caption = "单位"
- EndProperty
- BeginProperty Field8
- Precision = 7
- Size = 4
- Scale = 0
- Type = 4
- Name = "数量"
- Caption = "数量"
- EndProperty
- BeginProperty Field9
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "外运车牌号"
- Caption = "外运车牌号"
- EndProperty
- BeginProperty Field10
- Precision = 7
- Size = 4
- Scale = 0
- Type = 4
- Name = "车数"
- Caption = "车数"
- EndProperty
- BeginProperty Field11
- Precision = 0
- Size = 255
- Scale = 0
- Type = 200
- Name = "外运原因"
- Caption = "外运原因"
- EndProperty
- BeginProperty Field12
- Precision = 23
- Size = 16
- Scale = 3
- Type = 135
- Name = "返还日期"
- Caption = "返还日期"
- EndProperty
- BeginProperty Field13
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "保安负责人"
- Caption = "保安负责人"
- EndProperty
- BeginProperty Field14
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "出口警卫负责人"
- Caption = "出口警卫负责人"
- EndProperty
- BeginProperty Field15
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "部门负责人"
- Caption = "部门负责人"
- EndProperty
- BeginProperty Field16
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "编号"
- Caption = "编号"
- EndProperty
- NumGroups = 0
- ParamCount = 1
- BeginProperty P1
- RealName = "Param1"
- Direction = 1
- Precision = 10
- Scale = 0
- Size = 4
- DataType = 3
- HostType = 3
- Required = -1 'True
- EndProperty
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset6
- CommandName = "动火审批"
- CommDispId = 1046
- RsDispId = 1052
- CommandText = $"DataEnvironment1.dsx":0000
- ActiveConnectionName= "Connection1"
- CommandType = 1
- IsRSReturning = -1 'True
- NumFields = 14
- BeginProperty Field1
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "编号"
- Caption = "编号"
- EndProperty
- BeginProperty Field2
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "申报部门"
- Caption = "申报部门"
- EndProperty
- BeginProperty Field3
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "编号"
- Caption = "编号"
- EndProperty
- BeginProperty Field4
- Precision = 23
- Size = 16
- Scale = 3
- Type = 135
- Name = "日期"
- Caption = "日期"
- EndProperty
- BeginProperty Field5
- Precision = 0
- Size = 50
- Scale = 0
- Type = 200
- Name = "动火地点"
- Caption = "动火地点"
- EndProperty
- BeginProperty Field6
- Precision = 7
- Size = 4
- Scale = 0
- Type = 4
- Name = "数量"
- Caption = "数量"
- EndProperty
- BeginProperty Field7
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "原因"
- Caption = "原因"
- EndProperty
- BeginProperty Field8
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "动火种类"
- Caption = "动火种类"
- EndProperty
- BeginProperty Field9
- Precision = 0
- Size = 50
- Scale = 0
- Type = 200
- Name = "防火措施"
- Caption = "防火措施"
- EndProperty
- BeginProperty Field10
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "操作人"
- Caption = "操作人"
- EndProperty
- BeginProperty Field11
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "操作证号码"
- Caption = "操作证号码"
- EndProperty
- BeginProperty Field12
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "监护人"
- Caption = "监护人"
- EndProperty
- BeginProperty Field13
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "签发人"
- Caption = "签发人"
- EndProperty
- BeginProperty Field14
- Precision = 0
- Size = 255
- Scale = 0
- Type = 200
- Name = "施工内容"
- Caption = "施工内容"
- EndProperty
- NumGroups = 0
- ParamCount = 1
- BeginProperty P1
- RealName = "Param1"
- Direction = 1
- Precision = 10
- Scale = 0
- Size = 4
- DataType = 3
- HostType = 3
- Required = -1 'True
- EndProperty
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset7
- CommandName = "停车证领用"
- CommDispId = 1053
- RsDispId = 1057
- CommandText = "SELECT 编号, 车号, 部门, 签发日期, 有效期, 备注 FROM 机动车专用停车证表 WHERE (编号 = ?)"
- ActiveConnectionName= "Connection1"
- CommandType = 1
- IsRSReturning = -1 'True
- NumFields = 6
- BeginProperty Field1
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "编号"
- Caption = "编号"
- EndProperty
- BeginProperty Field2
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "车号"
- Caption = "车号"
- EndProperty
- BeginProperty Field3
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "部门"
- Caption = "部门"
- EndProperty
- BeginProperty Field4
- Precision = 23
- Size = 16
- Scale = 3
- Type = 135
- Name = "签发日期"
- Caption = "签发日期"
- EndProperty
- BeginProperty Field5
- Precision = 7
- Size = 4
- Scale = 0
- Type = 4
- Name = "有效期"
- Caption = "有效期"
- EndProperty
- BeginProperty Field6
- Precision = 0
- Size = 255
- Scale = 0
- Type = 200
- Name = "备注"
- Caption = "备注"
- EndProperty
- NumGroups = 0
- ParamCount = 1
- BeginProperty P1
- RealName = "Param1"
- Direction = 1
- Precision = 20
- Scale = 0
- Size = 20
- DataType = 200
- HostType = 8
- Required = -1 'True
- EndProperty
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset8
- CommandName = "Cmd_员工统计"
- CommDispId = 1058
- RsDispId = 1063
- CommandText = $"DataEnvironment1.dsx":00A9
- ActiveConnectionName= "Connection1"
- CommandType = 1
- IsRSReturning = -1 'True
- NumFields = 4
- BeginProperty Field1
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "部门"
- Caption = "部门"
- EndProperty
- BeginProperty Field2
- Precision = 0
- Size = 8
- Scale = 0
- Type = 200
- Name = "用工类型"
- Caption = "用工类型"
- EndProperty
- BeginProperty Field3
- Precision = 0
- Size = 2
- Scale = 0
- Type = 200
- Name = "性别"
- Caption = "性别"
- EndProperty
- BeginProperty Field4
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "人数"
- Caption = "人数"
- EndProperty
- NumGroups = 0
- ParamCount = 0
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset9
- CommandName = "Cmd_年龄文化职位"
- CommDispId = 1064
- RsDispId = 1069
- CommandText = "dbo.V_职位年龄文化"
- ActiveConnectionName= "Connection1"
- CommandType = 2
- dbObjectType = 2
- IsRSReturning = -1 'True
- NumFields = 4
- BeginProperty Field1
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "职位类别"
- Caption = "职位类别"
- EndProperty
- BeginProperty Field2
- Precision = 0
- Size = 12
- Scale = 0
- Type = 200
- Name = "年龄范围"
- Caption = "年龄范围"
- EndProperty
- BeginProperty Field3
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "学历"
- Caption = "学历"
- EndProperty
- BeginProperty Field4
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "人数"
- Caption = "人数"
- EndProperty
- NumGroups = 0
- ParamCount = 0
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset10
- CommandName = "Cmd_人员增减变动"
- CommDispId = 1070
- RsDispId = 1075
- CommandText = "SELECT 员工号, 姓名, 性别, 出生日期, 进入公司时间, 部门, 岗位, 原任职单位, 离职档案转出单位, 离职时间 FROM 员工基本信息"
- ActiveConnectionName= "Connection1"
- CommandType = 1
- IsRSReturning = -1 'True
- NumFields = 10
- BeginProperty Field1
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "员工号"
- Caption = "员工号"
- EndProperty
- BeginProperty Field2
- Precision = 0
- Size = 30
- Scale = 0
- Type = 200
- Name = "姓名"
- Caption = "姓名"
- EndProperty
- BeginProperty Field3
- Precision = 0
- Size = 2
- Scale = 0
- Type = 200
- Name = "性别"
- Caption = "性别"
- EndProperty
- BeginProperty Field4
- Precision = 23
- Size = 16
- Scale = 3
- Type = 135
- Name = "出生日期"
- Caption = "出生日期"
- EndProperty
- BeginProperty Field5
- Precision = 23
- Size = 16
- Scale = 3
- Type = 135
- Name = "进入公司时间"
- Caption = "进入公司时间"
- EndProperty
- BeginProperty Field6
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "部门"
- Caption = "部门"
- EndProperty
- BeginProperty Field7
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "岗位"
- Caption = "岗位"
- EndProperty
- BeginProperty Field8
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "原任职单位"
- Caption = "原任职单位"
- EndProperty
- BeginProperty Field9
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "离职档案转出单位"
- Caption = "离职档案转出单位"
- EndProperty
- BeginProperty Field10
- Precision = 23
- Size = 16
- Scale = 3
- Type = 135
- Name = "离职时间"
- Caption = "离职时间"
- EndProperty
- NumGroups = 0
- ParamCount = 0
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset11
- CommandName = "cmd_工资统计"
- CommDispId = 1082
- RsDispId = 1087
- CommandText = $"DataEnvironment1.dsx":024E
- ActiveConnectionName= "Connection1"
- CommandType = 1
- IsRSReturning = -1 'True
- NumFields = 12
- BeginProperty Field1
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "月份"
- Caption = "月份"
- EndProperty
- BeginProperty Field2
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "年度"
- Caption = "年度"
- EndProperty
- BeginProperty Field3
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "员工号"
- Caption = "员工号"
- EndProperty
- BeginProperty Field4
- Precision = 0
- Size = 30
- Scale = 0
- Type = 200
- Name = "姓名"
- Caption = "姓名"
- EndProperty
- BeginProperty Field5
- Precision = 7
- Size = 4
- Scale = 0
- Type = 4
- Name = "基本工资"
- Caption = "基本工资"
- EndProperty
- BeginProperty Field6
- Precision = 7
- Size = 4
- Scale = 0
- Type = 4
- Name = "岗位工资"
- Caption = "岗位工资"
- EndProperty
- BeginProperty Field7
- Precision = 7
- Size = 4
- Scale = 0
- Type = 4
- Name = "考核分奖金"
- Caption = "考核分奖金"
- EndProperty
- BeginProperty Field8
- Precision = 7
- Size = 4
- Scale = 0
- Type = 4
- Name = "加班费小计"
- Caption = "加班费小计"
- EndProperty
- BeginProperty Field9
- Precision = 7
- Size = 4
- Scale = 0
- Type = 4
- Name = "医疗包干"
- Caption = "医疗包干"
- EndProperty
- BeginProperty Field10
- Precision = 7
- Size = 4
- Scale = 0
- Type = 4
- Name = "子女医疗包干"
- Caption = "子女医疗包干"
- EndProperty
- BeginProperty Field11
- Precision = 7
- Size = 4
- Scale = 0
- Type = 4
- Name = "过节费"
- Caption = "过节费"
- EndProperty
- BeginProperty Field12
- Precision = 7
- Size = 4
- Scale = 0
- Type = 4
- Name = "实发工资"
- Caption = "实发工资"
- EndProperty
- NumGroups = 0
- ParamCount = 2
- BeginProperty P1
- RealName = "Param1"
- Direction = 1
- Precision = 10
- Scale = 0
- Size = 4
- DataType = 3
- HostType = 3
- Required = -1 'True
- EndProperty
- BeginProperty P2
- RealName = "Param2"
- Direction = 1
- Precision = 10
- Scale = 0
- Size = 4
- DataType = 3
- HostType = 3
- Required = -1 'True
- EndProperty
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset12
- CommandName = "Cmd_福利费"
- CommDispId = 1088
- RsDispId = 1090
- CommandText = $"DataEnvironment1.dsx":02F5
- ActiveConnectionName= "Connection1"
- CommandType = 1
- Grouping = -1 'True
- GroupingName = "Cmd_福利费_Grouping"
- SummaryExpanded = -1 'True
- DetailExpanded = -1 'True
- IsRSReturning = -1 'True
- NumFields = 10
- BeginProperty Field1
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "年度"
- Caption = "年度"
- EndProperty
- BeginProperty Field2
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "月份"
- Caption = "月份"
- EndProperty
- BeginProperty Field3
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "员工号"
- Caption = "员工号"
- EndProperty
- BeginProperty Field4
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "姓名"
- Caption = "姓名"
- EndProperty
- BeginProperty Field5
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "部门"
- Caption = "部门"
- EndProperty
- BeginProperty Field6
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "岗位"
- Caption = "岗位"
- EndProperty
- BeginProperty Field7
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "用工类型"
- Caption = "用工类型"
- EndProperty
- BeginProperty Field8
- Precision = 0
- Size = 50
- Scale = 0
- Type = 200
- Name = "费用类型"
- Caption = "费用类型"
- EndProperty
- BeginProperty Field9
- Precision = 0
- Size = 100
- Scale = 0
- Type = 200
- Name = "费用项目"
- Caption = "费用项目"
- EndProperty
- BeginProperty Field10
- Precision = 7
- Size = 4
- Scale = 0
- Type = 4
- Name = "费用金额"
- Caption = "费用金额"
- EndProperty
- NumGroups = 3
- BeginProperty Grouping1
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "年度"
- Caption = "年度"
- EndProperty
- BeginProperty Grouping2
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "月份"
- Caption = "月份"
- EndProperty
- BeginProperty Grouping3
- Precision = 0
- Size = 100
- Scale = 0
- Type = 200
- Name = "费用项目"
- Caption = "费用项目"
- EndProperty
- ParamCount = 3
- BeginProperty P1
- RealName = "Param1"
- Direction = 1
- Precision = 10
- Scale = 0
- Size = 4
- DataType = 3
- HostType = 3
- Required = -1 'True
- EndProperty
- BeginProperty P2
- RealName = "Param2"
- Direction = 1
- Precision = 10
- Scale = 0
- Size = 4
- DataType = 3
- HostType = 3
- Required = -1 'True
- EndProperty
- BeginProperty P3
- RealName = "Param3"
- Direction = 1
- Precision = 100
- Scale = 0
- Size = 100
- DataType = 200
- HostType = 8
- Required = -1 'True
- EndProperty
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset13
- CommandName = "Command2"
- CommDispId = 1094
- RsDispId = 1103
- CommandText = "dbo.出库明细表"
- ActiveConnectionName= "Connection1"
- CommandType = 2
- dbObjectType = 1
- IsRSReturning = -1 'True
- NumFields = 22
- BeginProperty Field1
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "凭单编号"
- Caption = "凭单编号"
- EndProperty
- BeginProperty Field2
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "商品编号"
- Caption = "商品编号"
- EndProperty
- BeginProperty Field3
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "名称"
- Caption = "名称"
- EndProperty
- BeginProperty Field4
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "物资大类"
- Caption = "物资大类"
- EndProperty
- BeginProperty Field5
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "物资子类"
- Caption = "物资子类"
- EndProperty
- BeginProperty Field6
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "计量单位"
- Caption = "计量单位"
- EndProperty
- BeginProperty Field7
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "规格型号"
- Caption = "规格型号"
- EndProperty
- BeginProperty Field8
- Precision = 19
- Size = 8
- Scale = 0
- Type = 6
- Name = "数量"
- Caption = "数量"
- EndProperty
- BeginProperty Field9
- Precision = 19
- Size = 8
- Scale = 0
- Type = 6
- Name = "单价"
- Caption = "单价"
- EndProperty
- BeginProperty Field10
- Precision = 0
- Size = 50
- Scale = 0
- Type = 200
- Name = "金额"
- Caption = "金额"
- EndProperty
- BeginProperty Field11
- Precision = 0
- Size = 6
- Scale = 0
- Type = 200
- Name = "领用类别"
- Caption = "领用类别"
- EndProperty
- BeginProperty Field12
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "接收部门"
- Caption = "接收部门"
- EndProperty
- BeginProperty Field13
- Precision = 0
- Size = 255
- Scale = 0
- Type = 200
- Name = "备注"
- Caption = "备注"
- EndProperty
- BeginProperty Field14
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "是否退库"
- Caption = "是否退库"
- EndProperty
- BeginProperty Field15
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "是否报废"
- Caption = "是否报废"
- EndProperty
- BeginProperty Field16
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "盘实"
- Caption = "盘实"
- EndProperty
- BeginProperty Field17
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "盘亏"
- Caption = "盘亏"
- EndProperty
- BeginProperty Field18
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "ID"
- Caption = "ID"
- EndProperty
- BeginProperty Field19
- Precision = 23
- Size = 16
- Scale = 3
- Type = 135
- Name = "出库日期"
- Caption = "出库日期"
- EndProperty
- BeginProperty Field20
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "经手人"
- Caption = "经手人"
- EndProperty
- BeginProperty Field21
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "处理状态"
- Caption = "处理状态"
- EndProperty
- BeginProperty Field22
- Precision = 0
- Size = 10
- Scale = 0
- Type = 200
- Name = "使用人"
- Caption = "使用人"
- EndProperty
- NumGroups = 0
- ParamCount = 0
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset14
- CommandName = "KC_库存量"
- CommDispId = 1108
- RsDispId = 1113
- CommandText = "dbo.KC_库存量"
- ActiveConnectionName= "Connection1"
- CommandType = 2
- dbObjectType = 2
- IsRSReturning = -1 'True
- NumFields = 8
- BeginProperty Field1
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "名称"
- Caption = "名称"
- EndProperty
- BeginProperty Field2
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "商品编号"
- Caption = "商品编号"
- EndProperty
- BeginProperty Field3
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "子类"
- Caption = "子类"
- EndProperty
- BeginProperty Field4
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "计量单位"
- Caption = "计量单位"
- EndProperty
- BeginProperty Field5
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "规格型号"
- Caption = "规格型号"
- EndProperty
- BeginProperty Field6
- Precision = 19
- Size = 8
- Scale = 0
- Type = 6
- Name = "单价"
- Caption = "单价"
- EndProperty
- BeginProperty Field7
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "数量"
- Caption = "数量"
- EndProperty
- BeginProperty Field8
- Precision = 19
- Size = 8
- Scale = 0
- Type = 6
- Name = "金额"
- Caption = "金额"
- EndProperty
- NumGroups = 0
- ParamCount = 0
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- BeginProperty Recordset15
- CommandName = "SP_商品目录"
- CommDispId = 1115
- RsDispId = 1119
- CommandText = "dbo.商品目录表"
- ActiveConnectionName= "Connection1"
- CommandType = 2
- dbObjectType = 1
- IsRSReturning = -1 'True
- NumFields = 10
- BeginProperty Field1
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "商品编号"
- Caption = "商品编号"
- EndProperty
- BeginProperty Field2
- Precision = 0
- Size = 20
- Scale = 0
- Type = 129
- Name = "名称"
- Caption = "名称"
- EndProperty
- BeginProperty Field3
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "大类"
- Caption = "大类"
- EndProperty
- BeginProperty Field4
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "子类"
- Caption = "子类"
- EndProperty
- BeginProperty Field5
- Precision = 0
- Size = 20
- Scale = 0
- Type = 129
- Name = "计量单位"
- Caption = "计量单位"
- EndProperty
- BeginProperty Field6
- Precision = 0
- Size = 20
- Scale = 0
- Type = 200
- Name = "规格型号"
- Caption = "规格型号"
- EndProperty
- BeginProperty Field7
- Precision = 19
- Size = 8
- Scale = 0
- Type = 6
- Name = "单价"
- Caption = "单价"
- EndProperty
- BeginProperty Field8
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "最高存储"
- Caption = "最高存储"
- EndProperty
- BeginProperty Field9
- Precision = 10
- Size = 4
- Scale = 0
- Type = 3
- Name = "最低存储"
- Caption = "最低存储"
- EndProperty
- BeginProperty Field10
- Precision = 0
- Size = 255
- Scale = 0
- Type = 129
- Name = "备注"
- Caption = "备注"
- EndProperty
- NumGroups = 0
- ParamCount = 0
- RelationCount = 0
- AggregateCount = 0
- EndProperty
- End
- Attribute VB_Name = "DataEnvironment1"
- Attribute VB_GlobalNameSpace = False
- Attribute VB_Creatable = True
- Attribute VB_PredeclaredId = True
- Attribute VB_Exposed = False