studentsystem.cs

大二做的课程设计。一个学生信息管理系统

using System;
using System.Collections.Generic;
using System.Text;

namespace StudentLibrary.Business
{
    using StudentLibrary.DataAccess;
    //created by autocode
    public class StudentSystem
    {
        public StudentSystem()
        {
        }
        /// <summary>
        /// 功能：处理事务，级联删除
        /// </summary>
        /// <param name="iClassId">班级ID</param>
        /// <returns>成功返回true</returns>
        public bool DeleteClass(
            int iClassId)
        {
            DataBaseOperate dbo = new DataBaseOperate();
            Students students = new Students(dbo);
            Classs classs = new Classs(dbo);
            Courses courses = new Courses(dbo);
            Scores scores = new Scores(dbo);
            try
            {
                //事务开始
                dbo.StartTransation();

                scores.DeleteScore(
                    -1,
                    -1,
                    -1,
                    iClassId);

                students.DeleteStudent(
                    -1,
                    iClassId);

                courses.DeleteCourse(
                    -1,
                    -1,
                    iClassId);

                classs.DeleteClass(
                    iClassId);
                //事务提交
                dbo.Commit();
            }
            catch (Exception e)
            {
                dbo.CloseDataBase();
                dbo.Dispose();
                classs.Dispose();
                students.Dispose();
                throw (new ApplicationException("操作数据库发生错误：" + e.Message));
            }
            //以下为关闭数据库，释放资源
            dbo.CloseDataBase();
            dbo.Dispose();
            classs.Dispose();
            students.Dispose();
            return true;
        }

    }
}