arrangement.cls

成绩管理系统,使用VB6.0编写,相当不错,可以用于课程设计

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "Arrangement"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
Public ArrangeId As Long
Public LessonId As Long
Public Class_Id As Long
Public TermId As String
Public Teacher As String
Public Hours As Integer
Public LessonType As String

Public Sub Init()
  ArrangeId = 0
  LessonId = 0
  Class_Id = 0
  TermId = 0
  Teacher = ""
  Hours = 0
  LessonType = ""
End Sub

'删除数据
Public Sub Delete(ByVal TmpId As Long)
  SqlStmt = "DELETE FROM Arrangement WHERE ArrangeId=" + Trim(Str(TmpId))
  SQLExt (SqlStmt)
End Sub

Public Function GetId(ByVal tid As Long, ByVal cid As Long, ByVal lid As Long) As Long
  Dim rs As New ADODB.Recordset
  SqlStmt = "SELECT ArrangeId FROM Arrangement WHERE LessonId=" + Trim(lid) _
        + " AND Class_Id=" + Trim(cid) + " AND TermId=" + Trim(tid)
  Set rs = QueryExt(SqlStmt)
  If rs.EOF Then
    GetId = 0
  Else
    If IsNull(rs.Fields(0)) Then
      GetId = ""
    Else
      GetId = rs.Fields(0)
    End If
  End If
  rs.Close
End Function

Public Function GetInfo(ByVal TmpId As Long) As Boolean
  If TmpId <= 0 Then
    GetInfo = False
    Init
    Exit Function
  End If
  
  ArrangeId = TmpId
  Dim rs As New ADODB.Recordset
  SqlStmt = "SELECT * FROM Arrangement WHERE ArrangeId=" + Trim(Str(TmpId))
  Set rs = QueryExt(SqlStmt)
  If rs.EOF Then
    GetInfo = False
    Init
  Else
    If IsNull(rs.Fields(1)) Then
      TermId = ""
    Else
      TermId = rs.Fields(1)
    End If
    
    If IsNull(rs.Fields(2)) Then
      LessonId = ""
    Else
      LessonId = rs.Fields(2)
    End If
    
    If IsNull(rs.Fields(3)) Then
      Class_Id = ""
    Else
      Class_Id = rs.Fields(3)
    End If
    
    If IsNull(rs.Fields(4)) Then
      Teacher = ""
    Else
      Teacher = Trim(rs.Fields(4))
    End If

    If IsNull(rs.Fields(5)) Then
      Hours = 0
    Else
      Hours = rs.Fields(5)
    End If
    
    If IsNull(rs.Fields(6)) Then
      LessonType = ""
    Else
      LessonType = Trim(rs.Fields(6))
    End If
  End If

  GetInfo = True
End Function

Public Sub Insert()
  SqlStmt = "INSERT INTO Arrangement (TermId, LessonId, Class_Id, Teacher, Hours," _
     + " LessonType) Values(" + Trim(TermId) + "," + Trim(LessonId) _
     + "," + Trim(Class_Id) + ",'" + Trim(Teacher) + "'," + Trim(Str(Hours)) + ",'" _
     + Trim(LessonType) + "')"
  SQLExt (SqlStmt)
End Sub

Public Sub Update(ByVal OriId As Long)
  SqlStmt = "Update Arrangement Set LessonId=" + Trim(LessonId) + ", TermId=" _
          + Trim(TermId) + ", Class_Id=" + Trim(Class_Id) + ",Teacher='" + Trim(Teacher) _
          + "',Hours=" + Trim(Str(Hours)) + ", LessonType='" + Trim(LessonType) _
          + "' WHERE ArrangeId=" + Trim(Str(OriId))
  SQLExt (SqlStmt)
End Sub