DataObjectBase.cs

SQLSERVER
--------------------------------------------------------------------------------------------------
using System;
using System.Data;

namespace Temco.EPMS.DataAccessForWF
{
 public abstract class DataObjectBase : DataAccessBase
 {
  public void Save(DataTable dataTable)
  {
   //   SetID(dataTable);
   SaveDataTable(dataTable);
  }
 
  public DataTable List()
  {
   return FetchDataTable(GetSelectStatement(), "Table");
  }
  
  protected virtual DataTable ListBySql(string sqlStatement)
  {
   return FetchDataTable(sqlStatement, "Table");
  }

  protected virtual int Execute(string sqlStatement)
  {
   return ExecuteNonQuery(sqlStatement);
  }

  public DataTable GetByID(long id)
  {
   return FetchDataTable(GetSelectStatement() + " where " + GetIDColumnName() + " = " + id, "Table");
  }

  public DataTable GetByID(string id)
  {
   return FetchDataTable(GetSelectStatement() + " where " + GetIDColumnName() + " = '" + id+"'", "Table");
  }

  protected abstract string GetSelectStatement();

  protected abstract string GetIDColumnName();

  //protected abstract void SetID(DataTable dataTable);
 }
}


ORCALE
--------------------------------------------------------------------------------------
using System;
using System.Data;
using System.Data.OracleClient;

namespace Temco.DataAccess
{
 public abstract class DataObjectBase : DataAccessBase
 {
  public void Save(DataTable dataTable)
  {
   //   SetID(dataTable);
   SaveDataTable(dataTable);
  }
 
  public DataTable List()
  {
   return FetchDataTable(GetSelectStatement(), "Table");
  }
  
  protected virtual DataTable ListBySql(string sqlStatement)
  {
   return FetchDataTable(sqlStatement, "Table");
  }

  protected virtual int Execute(string sqlStatement)
  {
   return ExecuteNonQuery(sqlStatement);
  }

  public DataTable GetByID(long id)
  {
   return FetchDataTable(GetSelectStatement() + " where " + GetIDColumnName() + " = " + id, "Table");
  }

  public DataTable GetByID(string id)
  {
   return FetchDataTable(GetSelectStatement() + " where " + GetIDColumnName() + " = '" + id+"'", "Table");
  }
//  public DataTable GetByMID(string id)
//  {
//   return FetchDataTable(GetStatement() + " where " + GetIDColumnName() + " = '" + id+"'", "Table");
//  }

  
  protected abstract string GetSelectStatement();

  protected abstract string GetIDColumnName();

  //protected abstract void SetID(DataTable dataTable);
 }
}