changemanager.cs

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

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

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

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

    public int Insert(IEntity obj)
    {
      ChangeEntity entity = (ChangeEntity)obj;
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Insert Into changes(change_studentID,change_changeType,change_reason,change_date) Values(@ChnageStudentID,@ChangeChangeType,@ChangeReason,@ChangeDate)");
      objCommand.Parameters.Add("@ChnageStudentID",entity.ChangeStudentID);
      objCommand.Parameters.Add("@ChangeChangeType",entity.ChangeChnageType);
      objCommand.Parameters.Add("@ChangeReason",entity.ChangeReason);
      objCommand.Parameters.Add("@ChangeDate",entity.ChangeDate);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
      return 0;
    }

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

    public int Update(IEntity obj)
    {
      ChangeEntity entity = (ChangeEntity)obj;
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Update changes Set change_changeType=@ChangeChangeType,change_reason=@ChangeReason Where change_ID=@ChangeID");
      objCommand.Parameters.Add("@ChangeChangeType",entity.ChangeChnageType);
      objCommand.Parameters.Add("@ChangeReason",entity.ChangeReason);
      objCommand.Parameters.Add("@ChangeID",entity.ChangeID);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
      return 0;
    }
	}
}