scores.cls

来自「成绩管理系统,使用VB6.0编写,相当不错,可以用于课程设计」· CLS 代码 · 共 82 行

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "Scores"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
Public ArrangeId As Long
Public Student_Id As Long
Public Score As Integer

Public Sub Init()
  ArrangeId = 0
  Student_Id = 0
  Score = 0
End Sub

Public Sub Delete(ByVal TmpAid As Long, _
                  ByVal TmpSid As Long)
  SqlStmt = "DELETE FROM Scores WHERE ArrangeId=" + Trim(TmpAid) _
          + " And Student_Id=" + Trim(TmpSid)
  SQLExt (SqlStmt)
End Sub

Public Function GetScore(ByVal TmpAid As Long, _
                         ByVal TmpSid As Long) As Integer
  Dim rs As New ADODB.Recordset
  SqlStmt = "SELECT Score FROM Scores WHERE ArrangeId=" _
          + Trim(TmpAid) + " And Student_Id=" + Trim(TmpSid)
  Set rs = QueryExt(SqlStmt)
  If rs.EOF Then
    GetScore = 0
    Exit Function
  Else
    If IsNull(rs.Fields(0)) Then
      GetScore = 0
    Else
      GetScore = rs.Fields(0)
    End If
  End If
  rs.Close
End Function

Public Function In_DB(ByVal TmpAid As Long, _
                      ByVal TmpSid As Long) As Boolean
  Dim rs As New ADODB.Recordset
  SqlStmt = "SELECT Score FROM Scores WHERE ArrangeId=" _
          + Trim(TmpAid) + " And Student_Id=" + Trim(TmpSid)
  Set rs = QueryExt(SqlStmt)
  If rs.EOF Then
    In_DB = False
  Else
    In_DB = True
  End If

  rs.Close
End Function

Public Sub Insert()
  SqlStmt = "INSERT INTO Scores Values(" + Trim(ArrangeId) + "," _
          + Trim(Student_Id) + "," + Trim(Score) + ")"
  SQLExt (SqlStmt)
End Sub

Public Sub Update(ByVal TmpAid As Long, _
                  ByVal TmpSid As Long)
  SqlStmt = "Update Scores Set Score=" + Trim(Score) + " WHERE ArrangeId=" _
          + Trim(TmpAid) + " And Student_Id=" + Trim(TmpSid)
  SQLExt (SqlStmt)
End Sub