📄 dataenvironment1.dsr
字号:
Scale = 0
Type = 11
Name = "EFT"
Caption = "EFT"
EndProperty
BeginProperty Field21
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "Totalb4dis"
Caption = "Totalb4dis"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset14
CommandName = "salesitems"
CommDispId = 1093
RsDispId = 1096
CommandText = "sales_items"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
Locktype = 3
IsRSReturning = -1 'True
NumFields = 6
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "index"
Caption = "index"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "item"
Caption = "item"
EndProperty
BeginProperty Field3
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "qty"
Caption = "qty"
EndProperty
BeginProperty Field4
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "billno"
Caption = "billno"
EndProperty
BeginProperty Field5
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "price"
Caption = "price"
EndProperty
BeginProperty Field6
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "notes"
Caption = "notes"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset15
CommandName = "billno"
CommDispId = 1097
RsDispId = 1102
CommandText = "billno"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
Locktype = 3
IsRSReturning = -1 'True
NumFields = 3
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "BillSafix"
Caption = "BillSafix"
EndProperty
BeginProperty Field2
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "LastBillNo"
Caption = "LastBillNo"
EndProperty
BeginProperty Field3
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "Year"
Caption = "Year"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset16
CommandName = "rptSalesSummry"
CommDispId = 1103
RsDispId = 1113
CommandText = $"DataEnvironment1.dsx":008A
ActiveConnectionName= "Connection1"
CommandType = 1
Prepared = -1 'True
Locktype = 3
IsRSReturning = -1 'True
NumFields = 4
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "bill"
Caption = "bill"
EndProperty
BeginProperty Field2
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "Bdate"
Caption = "Bdate"
EndProperty
BeginProperty Field3
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "total"
Caption = "total"
EndProperty
BeginProperty Field4
Precision = 0
Size = 2
Scale = 0
Type = 11
Name = "CashSales"
Caption = "CashSales"
Control = "CheckBox"
ControlGuid = "{0CA5C780-7C71-11D0-B223-00A0C908FB55}"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset17
CommandName = "itm"
CommDispId = 1114
RsDispId = 1117
CommandText = "items"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
IsRSReturning = -1 'True
NumFields = 22
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "code"
Caption = "code"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "description"
Caption = "description"
EndProperty
BeginProperty Field3
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "A_price"
Caption = "A_price"
EndProperty
BeginProperty Field4
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "B_price"
Caption = "B_price"
EndProperty
BeginProperty Field5
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "index"
Caption = "index"
EndProperty
BeginProperty Field6
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "CatCode"
Caption = "CatCode"
EndProperty
BeginProperty Field7
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "Inhand"
Caption = "Inhand"
EndProperty
BeginProperty Field8
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "RLevel"
Caption = "RLevel"
EndProperty
BeginProperty Field9
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "CLevel"
Caption = "CLevel"
EndProperty
BeginProperty Field10
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "minMarkupP"
Caption = "minMarkupP"
EndProperty
BeginProperty Field11
Precision = 0
Size = 2
Scale = 0
Type = 11
Name = "CanSellAtCost"
Caption = "CanSellAtCost"
EndProperty
BeginProperty Field12
Precision = 0
Size = 2
Scale = 0
Type = 11
Name = "CanSellBelowCost"
Caption = "CanSellBelowCost"
EndProperty
BeginProperty Field13
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "CostPrice"
Caption = "CostPrice"
EndProperty
BeginProperty Field14
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "maxDiscountP"
Caption = "maxDiscountP"
EndProperty
BeginProperty Field15
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "memDiscountP"
Caption = "memDiscountP"
EndProperty
BeginProperty Field16
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "type"
Caption = "type"
EndProperty
BeginProperty Field17
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "brand"
Caption = "brand"
EndProperty
BeginProperty Field18
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "size"
Caption = "size"
EndProperty
BeginProperty Field19
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "color"
Caption = "color"
EndProperty
BeginProperty Field20
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "origin"
Caption = "origin"
EndProperty
BeginProperty Field21
Precision = 0
Size = 536870910
Scale = 0
Type = 203
Name = "memo"
Caption = "memo"
EndProperty
BeginProperty Field22
Precision = 0
Size = 2
Scale = 0
Type = 11
Name = "inactive"
Caption = "inactive"
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 + -