studentsystem.cs

c#编写“三层体系结构的应用-学员管理系统2(界”

using System;
using System.Data;

namespace Aptech.Student.Business
{
	using Aptech.Student.DataAccess;
	using Aptech.Student.Common;

	//created by autocode
	public class StudentSystem
	{
		public StudentSystem()
		{
		}

		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;
		}

	}
}