changetypemanager.cs

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

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

namespace StudentsMIS.Business
{
	/// <summary>
	/// ChangeTypeManager 的摘要说明。
	/// </summary>
	public class ChangeTypeManager
	{
		public ChangeTypeManager()
		{
			
		}

    public int Insert(string id,string typeName)
    {
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Select * From changeTypes Where changeType_ID=@ChnageTypeID");
      objCommand.Parameters.Add("@ChnageTypeID",id);
      if(objCommand.ExecuteReader().HasRows)
      {
        CommandCloser.CloseOleDbCommand(objCommand);
        return 0;
      }
      objCommand = CommandBuilder.BuildOleDbCommand("Select * From changeTypes Where changeType_name=@ChangeTypeName");
      objCommand.Parameters.Add("@ChangeTypeName",typeName);
      if(objCommand.ExecuteReader().HasRows)
      {
        CommandCloser.CloseOleDbCommand(objCommand);
        return 1;
      }
      objCommand = CommandBuilder.BuildOleDbCommand("Insert Into changeTypes(changeType_ID,changeType_name) Values(@ChangeTypeID,@ChangeTypeName)");
      objCommand.Parameters.Add("@ChangeTypeID",id);
      objCommand.Parameters.Add("@ChangeTypeName",typeName);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
      return 2;
    }

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

    public int Update(string id,string typeName)
    {
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Select * From changeTypes Where changeType_name=@ChangeTypeName");
      objCommand.Parameters.Add("@ChangeTypeName",typeName);
      if(objCommand.ExecuteReader().HasRows)
      {
        CommandCloser.CloseOleDbCommand(objCommand);
        return 0;
      }
      objCommand = CommandBuilder.BuildOleDbCommand("Update changeTypes Set changeType_name=@ChangeTypeName Where changeType_ID=@ChangeTypeID");
      objCommand.Parameters.Add("@ChangeTypeName",typeName);
      objCommand.Parameters.Add("@ChangeTypeID",id);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
      return 1;
    }
	}
}