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