?? cls_grade.cls
字號:
VERSION 1.0 CLASS
BEGIN
MultiUse = -1 'True
Persistable = 0 'NotPersistable
DataBindingBehavior = 0 'vbNone
DataSourceBehavior = 0 'vbNone
MTSTransactionMode = 0 'NotAnMTSObject
END
Attribute VB_Name = "Cls_Grade"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = True
Option Explicit
Dim mycnt As Cls_Connect
Private Sub Class_Initialize()
Set mycnt = New Cls_Connect
End Sub
Public Function QueryGradeClassID()
'只有班級編號一個字段的記錄,且不重復
mycnt.QryName = "select DISTINCT ClassID from ClassInfo"
mycnt.openQry
End Function
Public Property Get GetQryGradeClassID() As Recordset
'返回課程編號的記錄
Set GetQryGradeClassID = mycnt.MQueryRs
End Property
Public Function PrcGradeSemIDByClassID(classid As String)
'按班級編號調用存儲過程
mycnt.PrcName = "QueryGradeSemID"
mycnt.PrcPra = "@pra"
mycnt.OpenPrc classid
End Function
Public Function PrcGradeStudentIDByClassID(studentid As String)
'按班級編號調用存儲過程,為獲取學生編號
mycnt.PrcName = "QueryGradeStudentID"
mycnt.PrcPra = "@pra"
mycnt.OpenPrc studentid
End Function
Public Sub OpenGradeInfo()
' 打開成績表
mycnt.RcdName = "GradeInfo "
mycnt.openRcd
End Sub
Public Property Get GetGradeRs() As Recordset
'返回成績表的記錄
Set GetGradeRs = mycnt.MRecordset
End Property
Public Function PrcGradeStat(classid As String)
mycnt.PrcName = "QueryGradeStat"
mycnt.PrcPra = "@pra"
mycnt.OpenPrc classid
End Function
Public Property Get GetGrade() As Recordset
Set GetGrade = mycnt.MStoreProcRS
End Property
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -