dejxc.dsr
来自「里面的内容包括：基盘存管理本信息管理库存管理入库管理出库管理等功能」· DSR 代码 · 共 1,227 行 · 第 1/3 页
DSR
1,227 行
Locktype = 4
IsRSReturning = -1 'True
NumFields = 6
BeginProperty Field1
Precision = 0
Size = 8
Scale = 0
Type = 202
Name = "p_id"
Caption = "p_id"
EndProperty
BeginProperty Field2
Precision = 7
Size = 4
Scale = 0
Type = 4
Name = "qty"
Caption = "qty"
EndProperty
BeginProperty Field3
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "price"
Caption = "price"
EndProperty
BeginProperty Field4
Precision = 7
Size = 4
Scale = 0
Type = 4
Name = "qty0111"
Caption = "qty0111"
EndProperty
BeginProperty Field5
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "price0111"
Caption = "price0111"
EndProperty
BeginProperty Field6
Precision = 7
Size = 4
Scale = 0
Type = 4
Name = "qty0603"
Caption = "qty0603"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset10
CommandName = "ComOtHA"
CommDispId = 1040
RsDispId = 1043
CommandText = "select * from other_head_a order by other_id"
ActiveConnectionName= "Conjxc"
CommandType = 1
Locktype = 4
IsRSReturning = -1 'True
NumFields = 7
BeginProperty Field1
Precision = 0
Size = 9
Scale = 0
Type = 202
Name = "other_id"
Caption = "other_id"
EndProperty
BeginProperty Field2
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "other_date"
Caption = "other_date"
EndProperty
BeginProperty Field3
Precision = 0
Size = 2
Scale = 0
Type = 202
Name = "other_type_id"
Caption = "other_type_id"
EndProperty
BeginProperty Field4
Precision = 0
Size = 4
Scale = 0
Type = 202
Name = "other_rid"
Caption = "other_rid"
EndProperty
BeginProperty Field5
Precision = 0
Size = 8
Scale = 0
Type = 202
Name = "other_maker"
Caption = "other_maker"
EndProperty
BeginProperty Field6
Precision = 0
Size = 12
Scale = 0
Type = 202
Name = "other_car"
Caption = "other_car"
EndProperty
BeginProperty Field7
Precision = 0
Size = 536870910
Scale = 0
Type = 203
Name = "other_demo"
Caption = "other_demo"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset11
CommandName = "ComOrderType"
CommDispId = 1044
RsDispId = 1049
CommandText = "select * from order_type order by type_id"
ActiveConnectionName= "Conjxc"
CommandType = 1
Locktype = 4
IsRSReturning = -1 'True
NumFields = 2
BeginProperty Field1
Precision = 0
Size = 2
Scale = 0
Type = 202
Name = "type_id"
Caption = "type_id"
EndProperty
BeginProperty Field2
Precision = 0
Size = 18
Scale = 0
Type = 202
Name = "type_name"
Caption = "type_name"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset12
CommandName = "ComSaleType"
CommDispId = 1050
RsDispId = 1051
CommandText = "select * from sale_type order by type_id"
ActiveConnectionName= "Conjxc"
CommandType = 1
Locktype = 4
IsRSReturning = -1 'True
NumFields = 2
BeginProperty Field1
Precision = 0
Size = 2
Scale = 0
Type = 202
Name = "type_id"
Caption = "type_id"
EndProperty
BeginProperty Field2
Precision = 0
Size = 18
Scale = 0
Type = 202
Name = "type_name"
Caption = "type_name"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset13
CommandName = "ComSaleHA"
CommDispId = 1052
RsDispId = 1053
CommandText = "select * from sale_head_a order by sale_id"
ActiveConnectionName= "Conjxc"
CommandType = 1
Locktype = 4
IsRSReturning = -1 'True
NumFields = 8
BeginProperty Field1
Precision = 0
Size = 9
Scale = 0
Type = 202
Name = "sale_id"
Caption = "sale_id"
EndProperty
BeginProperty Field2
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "sale_date"
Caption = "sale_date"
EndProperty
BeginProperty Field3
Precision = 0
Size = 2
Scale = 0
Type = 202
Name = "sale_type_id"
Caption = "sale_type_id"
EndProperty
BeginProperty Field4
Precision = 0
Size = 4
Scale = 0
Type = 202
Name = "sale_rid"
Caption = "sale_rid"
EndProperty
BeginProperty Field5
Precision = 0
Size = 4
Scale = 0
Type = 202
Name = "sale_user"
Caption = "sale_user"
EndProperty
BeginProperty Field6
Precision = 0
Size = 8
Scale = 0
Type = 202
Name = "sale_maker"
Caption = "sale_maker"
EndProperty
BeginProperty Field7
Precision = 0
Size = 12
Scale = 0
Type = 202
Name = "sale_car"
Caption = "sale_car"
EndProperty
BeginProperty Field8
Precision = 0
Size = 536870910
Scale = 0
Type = 203
Name = "sale_demo"
Caption = "sale_demo"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset14
CommandName = "ComSaleDA"
CommDispId = 1054
RsDispId = 1055
CommandText = "select * from sale_detail_a order by sale_id"
ActiveConnectionName= "Conjxc"
CommandType = 1
Locktype = 4
IsRSReturning = -1 'True
NumFields = 5
BeginProperty Field1
Precision = 0
Size = 9
Scale = 0
Type = 202
Name = "sale_id"
Caption = "sale_id"
EndProperty
BeginProperty Field2
Precision = 0
Size = 8
Scale = 0
Type = 202
Name = "p_id"
Caption = "p_id"
EndProperty
BeginProperty Field3
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "unit_price"
Caption = "unit_price"
EndProperty
BeginProperty Field4
Precision = 7
Size = 4
Scale = 0
Type = 4
Name = "qty"
Caption = "qty"
EndProperty
BeginProperty Field5
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "price"
Caption = "price"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset15
CommandName = "ComMatDetail"
CommDispId = 1056
RsDispId = 1057
CommandText = "select * from mat_detail order by p_id"
ActiveConnectionName= "Conjxc"
CommandType = 1
Locktype = 4
IsRSReturning = -1 'True
NumFields = 3
BeginProperty Field1
Precision = 0
Size = 8
Scale = 0
Type = 202
Name = "p_id"
Caption = "p_id"
EndProperty
BeginProperty Field2
Precision = 7
Size = 4
Scale = 0
Type = 4
Name = "qty"
Caption = "qty"
EndProperty
BeginProperty Field3
Precision = 19
Size = 8
Scale = 0
Type = 6
Name = "unit_price"
Caption = "unit_price"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset16
CommandName = "ComPsHB"
CommDispId = 1058
RsDispId = 1059
CommandText = "select * from ps_head_b order by ps_id"
ActiveConnectionName= "Conjxc"
CommandType = 1
Locktype = 4
IsRSReturning = -1 'True
NumFields = 6
BeginProperty Field1
Precision = 0
Size = 9
Scale = 0
Type = 202
Name = "ps_id"
Caption = "ps_id"
EndProperty
BeginProperty Field2
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "ps_date"
Caption = "ps_date"
EndProperty
BeginProperty Field3
Precision = 0
Size = 8
Scale = 0
Type = 202
Name = "ps_rid"
Caption = "ps_rid"
EndProperty
BeginProperty Field4
Precision = 0
Size = 8
Scale = 0
Type = 202
Name = "ps_maker"
Caption = "ps_maker"
EndProperty
BeginProperty Field5
Precision = 0
Size = 12
Scale = 0
Type = 202
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?