dataenv.dsr
来自「本系统主要完成对教师基本信息、教师授课信息和教师工资情况的管理」· DSR 代码 · 共 910 行 · 第 1/2 页
DSR
910 行
BeginProperty Field2
Precision = 0
Size = 10
Scale = 0
Type = 202
Name = "teacher.Name"
Caption = "teacher.Name"
EndProperty
BeginProperty Field3
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "dept_id"
Caption = "dept_id"
EndProperty
BeginProperty Field4
Precision = 0
Size = 8
Scale = 0
Type = 7
Name = "Birthday"
Caption = "Birthday"
EndProperty
BeginProperty Field5
Precision = 0
Size = 2
Scale = 0
Type = 202
Name = "Sex"
Caption = "Sex"
EndProperty
BeginProperty Field6
Precision = 0
Size = 30
Scale = 0
Type = 202
Name = "Address"
Caption = "Address"
EndProperty
BeginProperty Field7
Precision = 0
Size = 15
Scale = 0
Type = 202
Name = "tel"
Caption = "tel"
EndProperty
BeginProperty Field8
Precision = 0
Size = 536870910
Scale = 0
Type = 203
Name = "resume"
Caption = "resume"
EndProperty
BeginProperty Field9
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Schooling"
Caption = "Schooling"
EndProperty
BeginProperty Field10
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Title"
Caption = "Title"
EndProperty
BeginProperty Field11
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "course.Serial"
Caption = "course.Serial"
EndProperty
BeginProperty Field12
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "course.Name"
Caption = "course.Name"
EndProperty
BeginProperty Field13
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "Period"
Caption = "Period"
EndProperty
BeginProperty Field14
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "typeid"
Caption = "typeid"
EndProperty
NumGroups = 0
ParamCount = 2
BeginProperty P1
RealName = "teacher.id"
Direction = 1
Precision = 255
Scale = 255
Size = 510
DataType = 202
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P2
RealName = "course.id"
Direction = 1
Precision = 255
Scale = 255
Size = 510
DataType = 202
HostType = 8
Required = -1 'True
EndProperty
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset10
CommandName = "AddCourse"
CommDispId = 1385
RsDispId = 1394
CommandText = $"DataEnv.dsx":00EF
ActiveConnectionName= "Con"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 4
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "serial"
Caption = "serial"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "name"
Caption = "name"
EndProperty
BeginProperty Field3
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "period"
Caption = "period"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "typename"
Caption = "typename"
EndProperty
NumGroups = 0
ParamCount = 2
BeginProperty P1
RealName = "course.typid"
Direction = 1
Precision = 255
Scale = 255
Size = 510
DataType = 202
HostType = 8
Required = -1 'True
EndProperty
BeginProperty P2
RealName = "department.id"
Direction = 1
Precision = 255
Scale = 255
Size = 510
DataType = 202
HostType = 8
Required = -1 'True
EndProperty
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset11
CommandName = "OneTeach"
CommDispId = 1408
RsDispId = 1416
CommandText = $"DataEnv.dsx":017B
ActiveConnectionName= "Con"
CommandType = 1
IsRSReturning = -1 'True
NumFields = 4
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Serial"
Caption = "Serial"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "Name"
Caption = "Name"
EndProperty
BeginProperty Field3
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "Period"
Caption = "Period"
EndProperty
BeginProperty Field4
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "typeid"
Caption = "typeid"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset12
CommandName = "pay"
CommDispId = 1425
RsDispId = 1426
CommandText = "pay"
ActiveConnectionName= "Con"
CommandType = 2
dbObjectType = 1
Locktype = 3
GroupingName = "pay_分组"
IsRSReturning = -1 'True
NumFields = 8
BeginProperty Field1
Precision = 10
Size = 4
Scale = 0
Type = 3
Name = "ID"
Caption = "ID"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "num"
Caption = "num"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "name"
Caption = "name"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "sex"
Caption = "sex"
EndProperty
BeginProperty Field5
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "depart"
Caption = "depart"
EndProperty
BeginProperty Field6
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "pay"
Caption = "pay"
EndProperty
BeginProperty Field7
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "date"
Caption = "date"
EndProperty
BeginProperty Field8
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "sum"
Caption = "sum"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset13
CommandName = "payadd"
CommDispId = 1427
RsDispId = 1450
CommandText = "SELECT num, pay, `date` FROM pay"
ActiveConnectionName= "Con"
CommandType = 1
Locktype = 3
IsRSReturning = -1 'True
NumFields = 3
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "num"
Caption = "num"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "pay"
Caption = "pay"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "date"
Caption = "date"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset14
CommandName = "payviewa"
CommDispId = 1428
RsDispId = 1457
CommandText = "SELECT num, name, sex, depart, pay, `date` FROM pay"
ActiveConnectionName= "Con"
CommandType = 1
Locktype = 3
Expanded = -1 'True
IsRSReturning = -1 'True
NumFields = 6
BeginProperty Field1
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "num"
Caption = "num"
EndProperty
BeginProperty Field2
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "name"
Caption = "name"
EndProperty
BeginProperty Field3
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "sex"
Caption = "sex"
EndProperty
BeginProperty Field4
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "depart"
Caption = "depart"
EndProperty
BeginProperty Field5
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "pay"
Caption = "pay"
EndProperty
BeginProperty Field6
Precision = 0
Size = 50
Scale = 0
Type = 202
Name = "date"
Caption = "date"
EndProperty
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
BeginProperty Recordset15
CommandName = "rptpayp"
CommDispId = 1431
RsDispId = -1
ActiveConnectionName= "Con"
CommandType = 1
Locktype = 3
NumFields = 0
NumGroups = 0
ParamCount = 0
RelationCount = 0
AggregateCount = 0
EndProperty
End
Attribute VB_Name = "DataEnv"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Attribute VB_Ext_KEY = "RVB_ModelStereotype" ,"DataEnvironment"
Private Sub DataEnvironment_Initialize()
''ADO中的数据连接所使用的字段
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Password=;Data Source="
strConn = strConn & App.Path & "\teacher.mdb" & ";Persist Security Info=True"
Con.ConnectionString = strConn
End Sub
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?