📄 dejxc.dsr
字号:
Name = "user_flag"
Caption = "user_flag"
EndProperty
BeginProperty Field14
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "min_num"
Caption = "min_num"
EndProperty
BeginProperty Field15
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "max_num"
Caption = "max_num"
EndProperty
BeginProperty Field16
Precision = 0
Size = 536870910
Scale = 0
Type = 203
Name = "ps_demo"
Caption = "ps_demo"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset15
CommandName = "comdw"
CommDispId = 1086
RsDispId = 1093
CommandText = "SELECT * FROM dwtable ORDER BY dw_id"
ActiveConnectionName= "Conjxc"
CommandType = 1
Locktype = 4
IsRSReturning = -1 'True
NumFields = 2
BeginProperty Field1
Precision = 0
Size = 3
Scale = 0
Type = 202
Name = "dw_id"
Caption = "dw_id"
EndProperty
BeginProperty Field2
Precision = 0
Size = 8
Scale = 0
Type = 202
Name = "dw_name"
Caption = "dw_name"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset16
CommandName = "comcounter"
CommDispId = 1094
RsDispId = 1144
CommandText = "SELECT * FROM counterid"
ActiveConnectionName= "Conjxc"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 3
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "TableName"
Caption = "TableName"
EndProperty
BeginProperty Field2
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "CountNum"
Caption = "CountNum"
EndProperty
BeginProperty Field3
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "precountnum"
Caption = "precountnum"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset17
CommandName = "comproqty"
CommDispId = 1099
RsDispId = 1109
CommandText = "select b.*,a.qty,a.p_depid from mat_detail as a,Product as b where a.p_id=b.p_id order by product_code"
ActiveConnectionName= "Conjxc"
CommandType = 1
Locktype = 4
IsRSReturning = -1 'True
NumFields = 18
BeginProperty Field1
Precision = 0
Size = 8
Scale = 0
Type = 202
Name = "p_id"
Caption = "p_id"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "product_name"
Caption = "product_name"
EndProperty
BeginProperty Field3
Precision = 0
Size = 20
Scale = 0
Type = 202
Name = "product_eno"
Caption = "product_eno"
EndProperty
BeginProperty Field4
Precision = 0
Size = 20
Scale = 0
Type = 202
Name = "product_code"
Caption = "product_code"
EndProperty
BeginProperty Field5
Precision = 0
Size = 20
Scale = 0
Type = 202
Name = "product_model"
Caption = "product_model"
EndProperty
BeginProperty Field6
Precision = 0
Size = 4
Scale = 0
Type = 202
Name = "type_id"
Caption = "type_id"
EndProperty
BeginProperty Field7
Precision = 0
Size = 8
Scale = 0
Type = 202
Name = "unit"
Caption = "unit"
EndProperty
BeginProperty Field8
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "product_cos"
Caption = "product_cos"
EndProperty
BeginProperty Field9
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "product_pst"
Caption = "product_pst"
EndProperty
BeginProperty Field10
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "product_pmm"
Caption = "product_pmm"
EndProperty
BeginProperty Field11
Precision = 5
Size = 2
Scale = 0
Type = 2
Name = "daze"
Caption = "daze"
EndProperty
BeginProperty Field12
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "product_time"
Caption = "product_time"
EndProperty
BeginProperty Field13
Precision = 0
Size = 2
Scale = 0
Type = 11
Name = "user_flag"
Caption = "user_flag"
EndProperty
BeginProperty Field14
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "min_num"
Caption = "min_num"
EndProperty
BeginProperty Field15
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "max_num"
Caption = "max_num"
EndProperty
BeginProperty Field16
Precision = 0
Size = 536870910
Scale = 0
Type = 203
Name = "ps_demo"
Caption = "ps_demo"
EndProperty
BeginProperty Field17
Precision = 7
Size = 4
Scale = 0
Type = 4
Name = "qty"
Caption = "qty"
EndProperty
BeginProperty Field18
Precision = 0
Size = 1
Scale = 0
Type = 204
Name = "p_depid"
Caption = "p_depid"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset18
CommandName = "commatsale"
CommDispId = 1116
RsDispId = 1118
CommandText = "select * from mat_sale order by p_id"
ActiveConnectionName= "Conjxc"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 8
BeginProperty Field1
Precision = 0
Size = 8
Scale = 0
Type = 202
Name = "p_id"
Caption = "p_id"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "p_name"
Caption = "p_name"
EndProperty
BeginProperty Field3
Precision = 0
Size = 3
Scale = 0
Type = 202
Name = "dw_id"
Caption = "dw_id"
EndProperty
BeginProperty Field4
Precision = 0
Size = 8
Scale = 0
Type = 202
Name = "p_depid"
Caption = "p_depid"
EndProperty
BeginProperty Field5
Precision = 0
Size = 4
Scale = 0
Type = 202
Name = "type_id"
Caption = "type_id"
EndProperty
BeginProperty Field6
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "unit_price"
Caption = "unit_price"
EndProperty
BeginProperty Field7
Precision = 7
Size = 4
Scale = 0
Type = 4
Name = "qty"
Caption = "qty"
EndProperty
BeginProperty Field8
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "price"
Caption = "price"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset19
CommandName = "Comcustomer"
CommDispId = 1135
RsDispId = 1148
CommandText = "select * from customer order by c_id"
ActiveConnectionName= "Conjxc"
CommandType = 1
Locktype = 4
IsRSReturning = -1 'True
NumFields = 20
BeginProperty Field1
Precision = 0
Size = 8
Scale = 0
Type = 202
Name = "c_id"
Caption = "c_id"
EndProperty
BeginProperty Field2
Precision = 0
Size = 16
Scale = 0
Type = 202
Name = "c_fname"
Caption = "c_fname"
EndProperty
BeginProperty Field3
Precision = 0
Size = 16
Scale = 0
Type = 202
Name = "c_mname"
Caption = "c_mname"
EndProperty
BeginProperty Field4
Precision = 0
Size = 15
Scale = 0
Type = 202
Name = "c_baby1"
Caption = "c_baby1"
EndProperty
BeginProperty Field5
Precision = 0
Size = 2
Scale = 0
Type = 202
Name = "c_sex1"
Caption = "c_sex1"
EndProperty
BeginProperty Field6
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "c_bdate1"
Caption = "c_bdate1"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -