|
|
/*
'===============================================================================
' Generated From - CSharp_dOOdads_BusinessEntity.vbgen
'
' ** IMPORTANT **
' How to Generate your stored procedures:
'
' SQL = SQL_StoredProcs.vbgen
' ACCESS = Access_StoredProcs.vbgen
' ORACLE = Oracle_StoredProcs.vbgen
' FIREBIRD = FirebirdStoredProcs.vbgen
' POSTGRESQL = PostgreSQL_StoredProcs.vbgen
'
' The supporting base class SqlClientEntity is in the Architecture directory in "dOOdads".
'
' This object is 'abstract' which means you need to inherit from it to be able
' to instantiate it. This is very easilly done. You can override properties and
' methods in your derived class, this allows you to regenerate this class at any
' time and not worry about overwriting custom code.
'
' NEVER EDIT THIS FILE.
'
' public class YourObject : _YourObject
' {
'
' }
'
'===============================================================================
*/
// Generated by MyGeneration Version # (1.2.0.2)
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using System.Collections.Specialized;
using MyGeneration.dOOdads;
namespace WebAppPatterns.Bizlayer
{
public abstract class _OrderDetail : SqlClientEntity
{
public _OrderDetail()
{
this.QuerySource = "OrderDetail";
this.MappingName = "OrderDetail";
}
//=================================================================
// public Overrides void AddNew()
//=================================================================
//
//=================================================================
public override void AddNew()
{
base.AddNew();
}
public override void FlushData()
{
this._whereClause = null;
this._aggregateClause = null;
base.FlushData();
}
//=================================================================
// public Function LoadAll() As Boolean
//=================================================================
// Loads all of the records in the database, and sets the currentRow to the first row
//=================================================================
public bool LoadAll()
{
ListDictionary parameters = null;
return base.LoadFromSql("[" + this.SchemaStoredProcedure + "proc_OrderDetailLoadAll]", parameters);
}
//=================================================================
// public Overridable Function LoadByPrimaryKey() As Boolean
//=================================================================
// Loads a single row of via the primary key
//=================================================================
public virtual bool LoadByPrimaryKey(int OrderID, int ProductID)
{
ListDictionary parameters = new ListDictionary();
parameters.Add(Parameters.OrderID, OrderID);
parameters.Add(Parameters.ProductID, ProductID);
return base.LoadFromSql("[" + this.SchemaStoredProcedure + "proc_OrderDetailLoadByPrimaryKey]", parameters);
}
#region Parameters
protected class Parameters
{
public static SqlParameter OrderID
{
get
{
return new SqlParameter("@OrderID", SqlDbType.Int, 0);
}
}
public static SqlParameter ProductID
{
get
{
return new SqlParameter("@ProductID", SqlDbType.Int, 0);
}
}
public static SqlParameter Quantity
{
get
{
return new SqlParameter("@Quantity", SqlDbType.Int, 0);
}
}
}
#endregion
#region ColumnNames
public class ColumnNames
{
public const string OrderID = "OrderID";
public const string ProductID = "ProductID";
public const string Quantity = "Quantity";
static public string ToPropertyName(string columnName)
{
if(ht == null)
{
ht = new Hashtable();
ht[OrderID] = _OrderDetail.PropertyNames.OrderID;
ht[ProductID] = _OrderDetail.PropertyNames.ProductID;
ht[Quantity] = _OrderDetail.PropertyNames.Quantity;
}
return (string)ht[columnName];
}
static private Hashtable ht = null;
}
#endregion
#region PropertyNames
public class PropertyNames
{
public const string OrderID = "OrderID";
public const string ProductID = "ProductID";
public const string Quantity = "Quantity";
static public string ToColumnName(string propertyName)
{
if(ht == null)
{
ht = new Hashtable();
ht[OrderID] = _OrderDetail.ColumnNames.OrderID;
ht[ProductID] = _OrderDetail.ColumnNames.ProductID;
ht[Quantity] = _OrderDetail.ColumnNames.Quantity;
}
return (string)ht[propertyName];
}
static private Hashtable ht = null;
}
#endregion
#region StringPropertyNames
public class StringPropertyNames
{
public const string OrderID = "s_OrderID";
public const string ProductID = "s_ProductID";
public const string Quantity = "s_Quantity";
}
#endregion
#region Properties
public virtual int OrderID
{
get
{
return base.Getint(ColumnNames.OrderID);
}
set
{
base.Setint(ColumnNames.OrderID, value);
}
}
public virtual int ProductID
{
get
{
return base.Getint(ColumnNames.ProductID);
}
set
{
base.Setint(ColumnNames.ProductID, value);
}
}
public virtual int Quantity
{
get
{
return base.Getint(ColumnNames.Quantity);
}
set
{
base.Setint(ColumnNames.Quantity, value);
}
}
#endregion
#region String Properties
public virtual string s_OrderID
{
get
{
return this.IsColumnNull(ColumnNames.OrderID) ? string.Empty : base.GetintAsString(ColumnNames.OrderID);
}
set
{
if(string.Empty == value)
this.SetColumnNull(ColumnNames.OrderID);
else
this.OrderID = base.SetintAsString(ColumnNames.OrderID, value);
}
}
public virtual string s_ProductID
{
get
{
return this.IsColumnNull(ColumnNames.ProductID) ? string.Empty : base.GetintAsString(ColumnNames.ProductID);
}
set
{
if(string.Empty == value)
this.SetColumnNull(ColumnNames.ProductID);
else
this.ProductID = base.SetintAsString(ColumnNames.ProductID, value);
}
}
public virtual string s_Quantity
{
get
{
return this.IsColumnNull(ColumnNames.Quantity) ? string.Empty : base.GetintAsString(ColumnNames.Quantity);
}
set
{
if(string.Empty == value)
this.SetColumnNull(ColumnNames.Quantity);
else
this.Quantity = base.SetintAsString(ColumnNames.Quantity, value);
}
}
#endregion
#region Where Clause
public class WhereClause
{
public WhereClause(BusinessEntity entity)
{
this._entity = entity;
}
public TearOffWhereParameter TearOff
{
get
{
if(_tearOff == null)
{
_tearOff = new TearOffWhereParameter(this);
}
return _tearOff;
}
}
#region WhereParameter TearOff's
public class TearOffWhereParameter
{
public TearOffWhereParameter(WhereClause clause)
{
this._clause = clause;
}
public WhereParameter OrderID
{
get
{
WhereParameter where = new WhereParameter(ColumnNames.OrderID, Parameters.OrderID);
this._clause._entity.Query.AddWhereParameter(where);
return where;
}
}
public WhereParameter ProductID
{
get
{
WhereParameter where = new WhereParameter(ColumnNames.ProductID, Parameters.ProductID);
this._clause._entity.Query.AddWhereParameter(where);
return where;
}
}
public WhereParameter Quantity
{
get
{
WhereParameter where = new WhereParameter(ColumnNames.Quantity, Parameters.Quantity);
this._clause._entity.Query.AddWhereParameter(where);
return where;
}
}
private WhereClause _clause;
}
#endregion
public WhereParameter OrderID
{
get
{
if(_OrderID_W == null)
{
_OrderID_W = TearOff.OrderID;
}
return _OrderID_W;
}
}
public WhereParameter ProductID
{
get
{
if(_ProductID_W == null)
{
_ProductID_W = TearOff.ProductID;
}
return _ProductID_W;
}
}
public WhereParameter Quantity
{
get
{
if(_Quantity_W == null)
{
_Quantity_W = TearOff.Quantity;
}
return _Quantity_W;
}
}
private WhereParameter _OrderID_W = null;
private WhereParameter _ProductID_W = null;
private WhereParameter _Quantity_W = null;
public void WhereClauseReset()
{
_OrderID_W = null;
_ProductID_W = null;
_Quantity_W = null;
this._entity.Query.FlushWhereParameters();
}
private BusinessEntity _entity;
private TearOffWhereParameter _tearOff;
}
public WhereClause Where
{
get
{
if(_whereClause == null)
{
_whereClause = new WhereClause(this);
}
return _whereClause;
}
}
private WhereClause _whereClause = null;
#endregion
#region Aggregate Clause
public class AggregateClause
{
public AggregateClause(BusinessEntity entity)
{
this._entity = entity;
}
public TearOffAggregateParameter TearOff
{
get
{
if(_tearOff == null)
{
_tearOff = new TearOffAggregateParameter(this);
}
return _tearOff;
}
}
#region AggregateParameter TearOff's
public class TearOffAggregateParameter
{
public TearOffAggregateParameter(AggregateClause clause)
{
this._clause = clause;
}
public AggregateParameter OrderID
{
get
{
AggregateParameter aggregate = new AggregateParameter(ColumnNames.OrderID, Parameters.OrderID);
this._clause._entity.Query.AddAggregateParameter(aggregate);
return aggregate;
}
}
public AggregateParameter ProductID
{
get
{
AggregateParameter aggregate = new AggregateParameter(ColumnNames.ProductID, Parameters.ProductID);
this._clause._entity.Query.AddAggregateParameter(aggregate);
return aggregate;
}
}
public AggregateParameter Quantity
{
get
{
AggregateParameter aggregate = new AggregateParameter(ColumnNames.Quantity, Parameters.Quantity);
this._clause._entity.Query.AddAggregateParameter(aggregate);
return aggregate;
}
}
private AggregateClause _clause;
}
#endregion
public AggregateParameter OrderID
{
get
{
if(_OrderID_W == null)
{
_OrderID_W = TearOff.OrderID;
}
return _OrderID_W;
}
}
public AggregateParameter ProductID
{
get
{
if(_ProductID_W == null)
{
_ProductID_W = TearOff.ProductID;
}
return _ProductID_W;
}
}
public AggregateParameter Quantity
{
get
{
if(_Quantity_W == null)
{
_Quantity_W = TearOff.Quantity;
}
return _Quantity_W;
}
}
private AggregateParameter _OrderID_W = null;
private AggregateParameter _ProductID_W = null;
private AggregateParameter _Quantity_W = null;
public void AggregateClauseReset()
{
_OrderID_W = null;
_ProductID_W = null;
_Quantity_W = null;
this._entity.Query.FlushAggregateParameters();
}
private BusinessEntity _entity;
private TearOffAggregateParameter _tearOff;
}
public AggregateClause Aggregate
{
get
{
if(_aggregateClause == null)
{
_aggregateClause = new AggregateClause(this);
}
return _aggregateClause;
}
}
private AggregateClause _aggregateClause = null;
#endregion
protected override IDbCommand GetInsertCommand()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[" + this.SchemaStoredProcedure + "proc_OrderDetailInsert]";
CreateParameters(cmd);
return cmd;
}
protected override IDbCommand GetUpdateCommand()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[" + this.SchemaStoredProcedure + "proc_OrderDetailUpdate]";
CreateParameters(cmd);
return cmd;
}
protected override IDbCommand GetDeleteCommand()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[" + this.SchemaStoredProcedure + "proc_OrderDetailDelete]";
SqlParameter p;
p = cmd.Parameters.Add(Parameters.OrderID);
p.SourceColumn = ColumnNames.OrderID;
p.SourceVersion = DataRowVersion.Current;
p = cmd.Parameters.Add(Parameters.ProductID);
p.SourceColumn = ColumnNames.ProductID;
p.SourceVersion = DataRowVersion.Current;
return cmd;
}
private IDbCommand CreateParameters(SqlCommand cmd)
{
SqlParameter p;
p = cmd.Parameters.Add(Parameters.OrderID);
p.SourceColumn = ColumnNames.OrderID;
p.SourceVersion = DataRowVersion.Current;
p = cmd.Parameters.Add(Parameters.ProductID);
p.SourceColumn = ColumnNames.ProductID;
p.SourceVersion = DataRowVersion.Current;
p = cmd.Parameters.Add(Parameters.Quantity);
p.SourceColumn = ColumnNames.Quantity;
p.SourceVersion = DataRowVersion.Current;
return cmd;
}
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I have been involved in professional software development for over 15 years, focusing on distributed applications on both Microsoft and Java platforms.
I also like long walks on the beach and a sense of humor and don't like mean people
Submit an article or tip