📄 dataenvironment1.dsr
字号:
VERSION 5.00
Begin {C0E45035-5775-11D0-B388-00A0C9055D8E} DataEnvironment1
ClientHeight = 4620
ClientLeft = 0
ClientTop = 0
ClientWidth = 6495
_ExtentX = 11456
_ExtentY = 8149
FolderFlags = 5
TypeLibGuid = "{100399C0-0F4A-4C53-A7C2-C4B0B193C87D}"
TypeInfoGuid = "{E991558A-1A1F-4DEF-9CBA-8DF69A78D388}"
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;Initial Catalog=hussain"
Expanded = -1 'True
IsSQL = -1 'True
QuoteChar = 34
SeparatorChar = 46
EndProperty
NumRecordsets = 8
BeginProperty Recordset1
CommandName = "Cotton_Seed_Purchase"
CommDispId = 1032
RsDispId = 1035
CommandText = "dbo.CSeedPurchase"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
Expanded = -1 'True
IsRSReturning = -1 'True
NumFields = 15
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "PCINo"
Caption = "PCINo"
EndProperty
BeginProperty Field2
Precision = 23
Size = 16
Scale = 3
Type = 135
Name = "PDate"
Caption = "PDate"
EndProperty
BeginProperty Field3
Precision = 18
Size = 19
Scale = 0
Type = 131
Name = "SupCode"
Caption = "SupCode"
EndProperty
BeginProperty Field4
Precision = 0
Size = 10
Scale = 0
Type = 129
Name = "SupName"
Caption = "SupName"
EndProperty
BeginProperty Field5
Precision = 18
Size = 19
Scale = 0
Type = 131
Name = "TotalBag"
Caption = "TotalBag"
EndProperty
BeginProperty Field6
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "W/Bag"
Caption = "W/Bag"
EndProperty
BeginProperty Field7
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "Rate/Mn"
Caption = "Rate/Mn"
EndProperty
BeginProperty Field8
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "SalesTax"
Caption = "SalesTax"
EndProperty
BeginProperty Field9
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "Lb/Bag"
Caption = "Lb/Bag"
EndProperty
BeginProperty Field10
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "OtherExp"
Caption = "OtherExp"
EndProperty
BeginProperty Field11
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "PExp"
Caption = "PExp"
EndProperty
BeginProperty Field12
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "TMounds"
Caption = "TMounds"
EndProperty
BeginProperty Field13
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "TLbExp"
Caption = "TLbExp"
EndProperty
BeginProperty Field14
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "TSalesTax"
Caption = "TSalesTax"
EndProperty
BeginProperty Field15
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "NetAmount"
Caption = "NetAmount"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset2
CommandName = "Castic_Soda_Purchase"
CommDispId = 1036
RsDispId = 1039
CommandText = "dbo.CasticSodaPurchase"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
IsRSReturning = -1 'True
NumFields = 11
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "PSINo"
Caption = "PSINo"
EndProperty
BeginProperty Field2
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "SuppCode"
Caption = "SuppCode"
EndProperty
BeginProperty Field3
Precision = 0
Size = 10
Scale = 0
Type = 129
Name = "SupName"
Caption = "SupName"
EndProperty
BeginProperty Field4
Precision = 23
Size = 16
Scale = 3
Type = 135
Name = "PDate"
Caption = "PDate"
EndProperty
BeginProperty Field5
Precision = 18
Size = 19
Scale = 0
Type = 131
Name = "TotalBags"
Caption = "TotalBags"
EndProperty
BeginProperty Field6
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "Rate/Mn"
Caption = "Rate/Mn"
EndProperty
BeginProperty Field7
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "W/Bag"
Caption = "W/Bag"
EndProperty
BeginProperty Field8
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "LbExp"
Caption = "LbExp"
EndProperty
BeginProperty Field9
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "OExp"
Caption = "OExp"
EndProperty
BeginProperty Field10
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "TMn"
Caption = "TMn"
EndProperty
BeginProperty Field11
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "NAmount"
Caption = "NAmount"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset3
CommandName = "Oil_Refining"
CommDispId = 1044
RsDispId = 1047
CommandText = "dbo.OilRefining"
ActiveConnectionName= "Connection1"
CommandType = 2
dbObjectType = 1
Expanded = -1 'True
IsRSReturning = -1 'True
NumFields = 7
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "RefNo"
Caption = "RefNo"
EndProperty
BeginProperty Field2
Precision = 23
Size = 16
Scale = 3
Type = 135
Name = "RefDate"
Caption = "RefDate"
EndProperty
BeginProperty Field3
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "CrudeOilMnUsed"
Caption = "CrudeOilMnUsed"
EndProperty
BeginProperty Field4
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "CasticSodaMnCosm"
Caption = "CasticSodaMnCosm"
EndProperty
BeginProperty Field5
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "RefOilMnProd"
Caption = "RefOilMnProd"
EndProperty
BeginProperty Field6
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "OilDirtMnProd"
Caption = "OilDirtMnProd"
EndProperty
BeginProperty Field7
Precision = 15
Size = 8
Scale = 0
Type = 5
Name = "Shortage"
Caption = "Shortage"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset4
CommandName = "Command1"
CommDispId = 1048
RsDispId = 1052
CommandText = "dbo.Sale_Master_Table"
ActiveConnectionName= "Connection1"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -