📄 dataenvironment1.dsr
字号:
VERSION 5.00
Begin {C0E45035-5775-11D0-B388-00A0C9055D8E} DataEnvironment1
ClientHeight = 9495
ClientLeft = 0
ClientTop = 0
ClientWidth = 11295
_ExtentX = 19923
_ExtentY = 16748
FolderFlags = 5
TypeLibGuid = "{59319A41-82A4-4B74-8D61-D0B53E449776}"
TypeInfoGuid = "{7F43AF57-BF2F-44B8-8CC0-DF50702E1982}"
TypeInfoCookie = 0
Version = 4
NumConnections = 1
BeginProperty Connection1
ConnectionName = "Connection1"
ConnDispId = 1001
SourceOfData = 3
ConnectionSource= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data\Shop.mdb;Persist Security Info=False"
Expanded = -1 'True
QuoteChar = 96
SeparatorChar = 46
EndProperty
NumRecordsets = 5
BeginProperty Recordset1
CommandName = "Command1"
CommDispId = 1002
RsDispId = 1007
CommandText = "销售查询表"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 2
Expanded = -1 'True
IsRSReturning = -1 'True
NumFields = 8
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "商品编号"
Caption = "商品编号"
EndProperty
BeginProperty Field2
Precision = 0
Size = 20
Scale = 0
Type = 202
Name = "商品名称"
Caption = "商品名称"
EndProperty
BeginProperty Field3
Precision = 0
Size = 15
Scale = 0
Type = 202
Name = "销售日期"
Caption = "销售日期"
EndProperty
BeginProperty Field4
Precision = 0
Size = 15
Scale = 0
Type = 202
Name = "销售时间"
Caption = "销售时间"
EndProperty
BeginProperty Field5
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "销售数量"
Caption = "销售数量"
EndProperty
BeginProperty Field6
Precision = 7
Size = 4
Scale = 0
Type = 4
Name = "单价"
Caption = "单价"
EndProperty
BeginProperty Field7
Precision = 0
Size = 5
Scale = 0
Type = 202
Name = "单位"
Caption = "单位"
EndProperty
BeginProperty Field8
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "总金额"
Caption = "总金额"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset2
CommandName = "Command2"
CommDispId = 1008
RsDispId = 1011
CommandText = "生产厂家表"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
Expanded = -1 'True
IsRSReturning = -1 'True
NumFields = 4
BeginProperty Field1
Precision = 0
Size = 15
Scale = 0
Type = 202
Name = "省份"
Caption = "省份"
EndProperty
BeginProperty Field2
Precision = 0
Size = 20
Scale = 0
Type = 202
Name = "厂名"
Caption = "厂名"
EndProperty
BeginProperty Field3
Precision = 0
Size = 20
Scale = 0
Type = 202
Name = "联系方式"
Caption = "联系方式"
EndProperty
BeginProperty Field4
Precision = 0
Size = 20
Scale = 0
Type = 202
Name = "网址"
Caption = "网址"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset3
CommandName = "Command3"
CommDispId = 1012
RsDispId = 1015
CommandText = "入库查询表"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 2
Expanded = -1 'True
IsRSReturning = -1 'True
NumFields = 5
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "商品编号"
Caption = "商品编号"
EndProperty
BeginProperty Field2
Precision = 0
Size = 20
Scale = 0
Type = 202
Name = "商品名称"
Caption = "商品名称"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "入库时间"
Caption = "入库时间"
EndProperty
BeginProperty Field4
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "入库批次"
Caption = "入库批次"
EndProperty
BeginProperty Field5
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "数量"
Caption = "数量"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset4
CommandName = "Command4"
CommDispId = 1016
RsDispId = 1019
CommandText = "种类表"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
Expanded = -1 'True
IsRSReturning = -1 'True
NumFields = 2
BeginProperty Field1
Precision = 0
Size = 20
Scale = 0
Type = 202
Name = "种类名"
Caption = "种类名"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "说明"
Caption = "说明"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset5
CommandName = "Command5"
CommDispId = 1020
RsDispId = 1023
CommandText = "密码表"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
IsRSReturning = -1 'True
NumFields = 3
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "用户名"
Caption = "用户名"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "密码"
Caption = "密码"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -