📄 dataenvironmentstore.dsr
字号:
VERSION 5.00
Begin {C0E45035-5775-11D0-B388-00A0C9055D8E} DataEnvironmentStore
ClientHeight = 9045
ClientLeft = 0
ClientTop = 0
ClientWidth = 8940
_ExtentX = 15769
_ExtentY = 15954
FolderFlags = 7
TypeLibGuid = "{95CEFA26-7980-4766-8E9E-8B8D0085E732}"
TypeInfoGuid = "{72B9F017-6E38-4543-A798-8813AD792CCA}"
TypeInfoCookie = 0
Version = 4
NumConnections = 1
BeginProperty Connection1
ConnectionName = "Store"
ConnDispId = 1001
SourceOfData = 3
ConnectionSource= "Provider=SQLOLEDB.1;Persist Security Info=False"
IsSQL = -1 'True
QuoteChar = 34
SeparatorChar = 46
EndProperty
NumRecordsets = 4
BeginProperty Recordset1
CommandName = "CmdStoreRoom"
CommDispId = 1002
RsDispId = 1008
CommandText = "select * from StoreRoom order by storeroom,location"
ActiveConnectionName= "Store"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 4
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 129
Name = "StoreID"
Caption = "StoreID"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 129
Name = "StoreRoom"
Caption = "StoreRoom"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 129
Name = "Location"
Caption = "Location"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 129
Name = "Description"
Caption = "Description"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset2
CommandName = "CmdStoreIN"
CommDispId = 1009
RsDispId = 1012
CommandText = $"DataEnvironmentStore.dsx":0000
ActiveConnectionName= "Store"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 33
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 129
Name = "StoreInID"
Caption = "StoreInID"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 129
Name = "StoreInType"
Caption = "StoreInType"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 129
Name = "Item"
Caption = "Item"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 129
Name = "UnitPrice"
Caption = "UnitPrice"
EndProperty
BeginProperty Field5
Precision = 0
Size = 50
Scale = 0
Type = 129
Name = "Currency1"
Caption = "Currency1"
EndProperty
BeginProperty Field6
Precision = 0
Size = 50
Scale = 0
Type = 129
Name = "Qty"
Caption = "Qty"
EndProperty
BeginProperty Field7
Precision = 0
Size = 50
Scale = 0
Type = 129
Name = "StoreRoom"
Caption = "StoreRoom"
EndProperty
BeginProperty Field8
Precision = 0
Size = 50
Scale = 0
Type = 129
Name = "Location"
Caption = "Location"
EndProperty
BeginProperty Field9
Precision = 0
Size = 50
Scale = 0
Type = 129
Name = "FillinPerson"
Caption = "FillinPerson"
EndProperty
BeginProperty Field10
Precision = 23
Size = 16
Scale = 3
Type = 135
Name = "FillinTime"
Caption = "FillinTime"
EndProperty
BeginProperty Field11
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Model"
Caption = "Model"
EndProperty
BeginProperty Field12
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Item"
Caption = "Item"
EndProperty
BeginProperty Field13
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Drawing"
Caption = "Drawing"
EndProperty
BeginProperty Field14
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Name"
Caption = "Name"
EndProperty
BeginProperty Field15
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Specification"
Caption = "Specification"
EndProperty
BeginProperty Field16
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Color"
Caption = "Color"
EndProperty
BeginProperty Field17
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Unit"
Caption = "Unit"
EndProperty
BeginProperty Field18
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "MB"
Caption = "MB"
EndProperty
BeginProperty Field19
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "IT"
Caption = "IT"
EndProperty
BeginProperty Field20
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "ST"
Caption = "ST"
EndProperty
BeginProperty Field21
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Inspect"
Caption = "Inspect"
EndProperty
BeginProperty Field22
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Capacity"
Caption = "Capacity"
EndProperty
BeginProperty Field23
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "NWeight"
Caption = "NWeight"
EndProperty
BeginProperty Field24
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "RWeight"
Caption = "RWeight"
EndProperty
BeginProperty Field25
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "PackWeight"
Caption = "PackWeight"
EndProperty
BeginProperty Field26
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "PackVolume"
Caption = "PackVolume"
EndProperty
BeginProperty Field27
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "PackType"
Caption = "PackType"
EndProperty
BeginProperty Field28
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "PackQty"
Caption = "PackQty"
EndProperty
BeginProperty Field29
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "ProLow"
Caption = "ProLow"
EndProperty
BeginProperty Field30
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "ProHigh"
Caption = "ProHigh"
EndProperty
BeginProperty Field31
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Valid"
Caption = "Valid"
EndProperty
BeginProperty Field32
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "AlarmDays"
Caption = "AlarmDays"
EndProperty
BeginProperty Field33
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Remark"
Caption = "Remark"
EndProperty
NumGroups = 0
ParamCount = 3
BeginProperty P1
RealName = "Param1"
UserName = "StartDate"
Direction = 1
Precision = 0
Scale = 0
Size = 16
DataType = 135
HostType = 7
Required = -1 'True
EndProperty
BeginProperty P2
RealName = "Param2"
UserName = "EndDate"
Direction = 1
Precision = 0
Scale = 0
Size = 16
DataType = 135
HostType = 7
Required = -1 'True
EndProperty
BeginProperty P3
RealName = "Param3"
UserName = "Type"
Direction = 1
Precision = 0
Scale = 0
Size = 50
DataType = 200
HostType = 8
Required = -1 'True
EndProperty
RelationCount = 0
AggregateCount = 0
EndProperty
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -