using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using DBOMSqlSharp;
namespace FATIHVAIO.AdventureWorks2008R2.Production
{
public class WorkOrderRouting : SqlTable
{
static int InstanceCount = 0;
SqlForeignKeyColumn<AdventureWorks2008R2.Production.WorkOrder> _WorkOrderID;
SqlColumn<int?> _ProductID;
SqlColumn<Int16?> _OperationSequence;
SqlForeignKeyColumn<AdventureWorks2008R2.Production.Location> _LocationID;
SqlColumn<DateTime?> _ScheduledStartDate;
SqlColumn<DateTime?> _ScheduledEndDate;
SqlColumn<DateTime?> _ActualStartDate;
SqlColumn<DateTime?> _ActualEndDate;
SqlColumn<decimal?> _ActualResourceHrs;
SqlColumn<decimal?> _PlannedCost;
SqlColumn<decimal?> _ActualCost;
SqlColumn<DateTime?> _ModifiedDate;
public SqlForeignKeyColumn<AdventureWorks2008R2.Production.WorkOrder> WorkOrderID
{
get
{
return this._WorkOrderID;
}
}
public SqlColumn<int?> ProductID
{
get
{
return this._ProductID;
}
}
public SqlColumn<Int16?> OperationSequence
{
get
{
return this._OperationSequence;
}
}
public SqlForeignKeyColumn<AdventureWorks2008R2.Production.Location> LocationID
{
get
{
return this._LocationID;
}
}
public SqlColumn<DateTime?> ScheduledStartDate
{
get
{
return this._ScheduledStartDate;
}
}
public SqlColumn<DateTime?> ScheduledEndDate
{
get
{
return this._ScheduledEndDate;
}
}
public SqlColumn<DateTime?> ActualStartDate
{
get
{
return this._ActualStartDate;
}
}
public SqlColumn<DateTime?> ActualEndDate
{
get
{
return this._ActualEndDate;
}
}
public SqlColumn<decimal?> ActualResourceHrs
{
get
{
return this._ActualResourceHrs;
}
}
public SqlColumn<decimal?> PlannedCost
{
get
{
return this._PlannedCost;
}
}
public SqlColumn<decimal?> ActualCost
{
get
{
return this._ActualCost;
}
}
public SqlColumn<DateTime?> ModifiedDate
{
get
{
return this._ModifiedDate;
}
}
public override string ConnectionString
{
get
{
return FATIHVAIOServer.ConnectionString;
}
}
public WorkOrderRouting() : base("WorkOrderRouting", "WorkOrderRouting", "7", "Production")
{
WorkOrderRouting.InstanceCount++;
this.instanceName = this.schema_name + "_" + this.name + "_" + WorkOrderRouting.InstanceCount.ToString();
_WorkOrderID = new SqlForeignKeyColumn<AdventureWorks2008R2.Production.WorkOrder>(this, null, "WorkOrderID", 4, 10, "", false);
_ProductID = new SqlColumn<int?>(this, null, "ProductID", 4, 10, "", false, false, false, false);
_OperationSequence = new SqlColumn<Int16?>(this, null, "OperationSequence", 2, 5, "", false, false, false, false);
_LocationID = new SqlForeignKeyColumn<AdventureWorks2008R2.Production.Location>(this, null, "LocationID", 2, 5, "", false);
_ScheduledStartDate = new SqlColumn<DateTime?>(this, null, "ScheduledStartDate", 8, 23, "", false, false, false, false);
_ScheduledEndDate = new SqlColumn<DateTime?>(this, null, "ScheduledEndDate", 8, 23, "", false, false, false, false);
_ActualStartDate = new SqlColumn<DateTime?>(this, null, "ActualStartDate", 8, 23, "", false, true, false, false);
_ActualEndDate = new SqlColumn<DateTime?>(this, null, "ActualEndDate", 8, 23, "", false, true, false, false);
_ActualResourceHrs = new SqlColumn<decimal?>(this, null, "ActualResourceHrs", 5, 9, "", false, true, false, false);
_PlannedCost = new SqlColumn<decimal?>(this, null, "PlannedCost", 8, 19, "", false, false, false, false);
_ActualCost = new SqlColumn<decimal?>(this, null, "ActualCost", 8, 19, "", false, true, false, false);
_ModifiedDate = new SqlColumn<DateTime?>(this, null, "ModifiedDate", 8, 23, "", false, false, false, false);
}
public WorkOrderRouting(int? id) : this()
{
}
~WorkOrderRouting()
{
WorkOrderRouting.InstanceCount--;
}
}
}