发布华军软件站SQL补丁包(2-13)

--错误提示：纠正了时间段容纳字符串太短的错误，及班级列表不能显示备注而出错,纠正学生选课后，班级人数不变的错误
--针对版本：School V3.0 2006-02-07日版
--安装方法：打开查询分析器，选择School3数据库，执行即可

ALTER TABLE [Class] ALTER column [TimeSegmentName] varchar(500) null
GO

ALTER VIEW dbo.ClassView
AS
SELECT dbo.Class.ClassID, dbo.Class.ClassName, dbo.Class.CourseID,
      dbo.Class.TeacherID, dbo.Class.CycName, dbo.Class.TimeSegmentName,
      dbo.Class.ClassRoomID, dbo.Class.CourseHours, dbo.Class.StartDate,
      dbo.Class.EndDate, dbo.Class.SystemDate, dbo.Class.SchoolID,
      dbo.Class.ClassCount, dbo.Class.PlanCount, dbo.Class.Monday, dbo.Class.Tuesday,
      dbo.Class.Wednesday, dbo.Class.Thursday, dbo.Class.Friday, dbo.Class.Saturday,
      dbo.Class.Sunday, dbo.Class.CycHoursInfo, dbo.Class.ClassFee,
      dbo.Class.ClassBookFee, dbo.School.SchoolName, dbo.School.SchoolNO,
      dbo.ClassRoom.ClassRoomName, dbo.ClassRoom.Seating, dbo.School.SchoolLock,
      dbo.ClassRoom.ClassRoomLock, dbo.Users.UserName,
      dbo.CourseView.CourseName, dbo.CourseView.CourseNO,
      dbo.CourseView.CourseLock, dbo.CourseView.SerialCourseID,
      dbo.CourseView.SerialCourseName, dbo.CourseView.SerialCourseLock,
      dbo.CourseView.SubjectID, dbo.CourseView.SubjectName,
      dbo.CourseView.SubjectLock, dbo.Class.CCTimeIng, dbo.Class.Remark
FROM dbo.Class INNER JOIN
      dbo.School ON dbo.Class.SchoolID = dbo.School.SchoolID INNER JOIN
      dbo.CourseView ON dbo.Class.CourseID = dbo.CourseView.CourseID INNER JOIN
      dbo.Users ON dbo.Class.TeacherID = dbo.Users.UserID INNER JOIN
      dbo.ClassRoom ON dbo.Class.ClassRoomID = dbo.ClassRoom.ClassRoomID

GO

ALTER TRIGGER TRMyClass_Insert
ON dbo.MyClass
AFTER Insert AS
Declare @ClassID varchar(50),@StudentID varchar(50),@ClassCount int,@NewClassName varchar(50)

Select DISTINCT @ClassID=ClassID,@StudentID=StudentID from inserted

Select @ClassCount = ClassCount from Student where StudentID = @StudentID
Select @NewClassName = ClassName from [Class] where ClassID = @ClassID

Update Student set ClassCount= @ClassCount + 1,NewClassName=@NewClassName where StudentID = @StudentID
--更新班级学生人数
exec ClassFactCont @ClassID
GO
-------------------------------------------2006-2-13日，麦田工作室