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