classmanager.cs

来自「c#开发宝典 光盘内容。本光盘主要为书中的源程序」· CS 代码 · 共 64 行

using System;
using System.Data.OleDb;
using StudentsMIS.DataAccess;

namespace StudentsMIS.Business
{
	/// <summary>
	/// ClassManager实现了对Class表的选、增、删、改。
	/// </summary>
	public class ClassManager
	{
		public ClassManager()
		{
			
		}

    public IEntity Select(string id)
    {
      return new ClassEntity();
    }

    public int Insert(IEntity obj)
    {
      ClassEntity entity = (ClassEntity)obj;
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Select class_ID From classes Where class_ID=@ClassID");
      objCommand.Parameters.Add("@ClassID",entity.ClassID);
      if(objCommand.ExecuteReader().HasRows)
      {
        CommandCloser.CloseOleDbCommand(objCommand);
        return 0;
      }
      objCommand = CommandBuilder.BuildOleDbCommand("Insert Into classes(class_ID,class_name,class_headTeacher,class_speciality) Values(@ClassID,@ClassHame,@ClassHeadTeacher,@ClassSpeciality)");
      objCommand.Parameters.Add("@ClassID",entity.ClassID);
      objCommand.Parameters.Add("@ClassHame",entity.ClassName);
      objCommand.Parameters.Add("@ClassHeadTeacher",entity.ClassHeadTeacher);
      objCommand.Parameters.Add("@ClassSpeciality",entity.ClassSpecialityID);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
      return 1;
    }

    public void Delete(string id)
    {
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Delete From classes Where class_ID=@ClassID");
      objCommand.Parameters.Add("@ClassID",id);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
    }

    public int Update(IEntity obj)
    {
      ClassEntity entity = (ClassEntity)obj;
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Update Classes Set class_name=@ClassName,class_headTeacher=@ClassHeadTeacher,class_speciality=@ClassSpeciality Where class_ID=@ClassID");
      objCommand.Parameters.Add("@ClassName",entity.ClassName);
      objCommand.Parameters.Add("@ClassHeadTeacher",entity.ClassHeadTeacher);
      objCommand.Parameters.Add("@ClassSpeciality",entity.ClassSpecialityID);
      objCommand.Parameters.Add("@ClassID",entity.ClassID);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
      return 0;
    }    
	}
}