public Column(ITagMapping tagMapping, string table_name, string column_name, string alias)
{
_TagMapping = tagMapping;
_ColumnName = column_name;
_TableName = table_name;
_Alias = alias;
}
public void InsertTagMapping(ITagMapping tag)
{
List <DbParameter> parameters;
string insert = InsertStatement("TagMapping", tag, out parameters);
DataAccess.ExecuteNonQuery(insert, parameters);
}
/// <summary>
/// Creates a new <see cref="CreateTableSQLCommand"/> instance.
/// </summary>
/// <param name="tableName">Name of the table.</param>
public AlterTableSQLCommand(ITagMapping tag, string tableName, AlterTypeEnum alterType)
{
_AlterType = alterType;
_TableName = tableName;
_TagMapping = tag;
_ColumnDefinitions = new ArrayList();
_ForeignKeys = new ArrayList();
}
public override bool Equals(object obj)
{
ITagMapping mapping = obj as ITagMapping;
if (mapping != null)
{
return(mapping.FileID == this.FileID && mapping.TagID == this.TagID);
}
return(false);
}
public SelectStatement(ITagMapping tag): base(tag)
{
SelectList = new ExpressionCollection();
_IsDistinct = false;
_SelectedAllColumns = false;
_Limit = 0;
_Offset = 0;
_FromClause = new FromClause();
_WhereClause = new WhereClause(BinaryLogicOperator.And);
_OrderByClause = new OrderByClause(this);
}
public AggregateFunction(ITagMapping tag, AggregateFunctionEnum type, ISQLExpression exp)
{
_ValueExpression = exp;
_Type = type;
_TagMapping = tag;
}
public TableSource(ITagMapping tag, string tableName) : this(tag, tableName, String.Empty)
{
}
public TableSource(ITagMapping tag, string tableName, string tableAlias) : base (tag, tableAlias)
{
_TableName = tableName;
}
public CreateTableSQLCommand(ITagMapping tag, string schema, string tableName)
: this(tag, tableName)
{
_Schema = schema;
}
public Table(ITagMapping tag, string tableAlias)
{
_TableAlias = tableAlias;
_TagMapping = tag;
}
public void InsertTagMapping(ITagMapping tag)
{
throw new NotImplementedException();
}
public SQLCommand(ITagMapping tag, string tableName)
{
_TagMapping = tag;
_TableName = tableName;
}
public MultipledKey(ITagMapping tagMapping)
: base(tagMapping, "")
{ }
public Parameter(ITagMapping tag, string name)
{
_Name = name;
_TagMapping = tag;
_UseParentValue = false;
}
public Table(ITagMapping tag) : this(tag, String.Empty)
{
}
public Column(ITagMapping tagMapping, string table_name, string column_name)
{
_TagMapping = tagMapping;
_ColumnName = column_name;
_TableName = table_name;
}
public CastExpression(ITagMapping tag, ISQLExpression expression, DbType dbType)
{
_Expression = expression;
_DbType = dbType;
_TagMapping = tag;
}
public InsertCommand(ITagMapping tag, string table_name, SelectStatement select_command) : base (tag, table_name)
{
_SelectStatement = select_command;
}
public InsertCommand(ITagMapping tag, string table_name) : base (tag, table_name)
{
}
public SelectItem(ITagMapping tagMapping, string column_name, string column_alias) : this(tagMapping, String.Empty, column_name, column_alias)
{
//
// TODO : ajoutez ici la logique du constructeur
//
}
public void DeleteTagMapping(ITagMapping tag)
{
DataAccess.ExecuteNonQuery(string.Format("delete from TagMapping where TagID = {0} and FileID = {1}", tag.TagID, tag.FileID));
}
public SelectItem(ITagMapping tagMapping, string table_alias, string column_name, string column_alias) : base (tagMapping, table_alias, column_name)
{
_ColumnAlias = column_alias;
}
public CaseExpression(ITagMapping tagMapping, string column_alias) : this(tagMapping, null, column_alias)
{
}
public void DeleteTagMapping(ITagMapping tag)
{
throw new NotImplementedException();
}
public DropTableSQLCommand(ITagMapping tag, string table_name): base (tag, table_name)
{
}
/// <summary>
/// Creates a new <see cref="CreateTableSQLCommand"/> instance.
/// </summary>
/// <param name="tableName">Name of the table.</param>
public CreateTableSQLCommand(ITagMapping tag, string tableName)
{
_TableName = tableName;
_ColumnDefinitions = new SortedList();
_TagMapping = tag;
}
//private ITagMapping _TagMapping;
public UnionStatement(ITagMapping tag)
: base(tag)
{
//_TagMapping = tag;
}
public UpdateCommand(ITagMapping tag, string table_name) : base (tag, table_name)
{
}
public DeleteCommand(ITagMapping tag, string table_name, WhereClause condition): base (tag, table_name)
{
_Condition = condition;
}
public CacheEntry(ITagMapping mapping)
{
_Mapping = mapping;
}
public CaseExpression(ITagMapping tagMapping, ISQLExpression expressiontToEval, string column_alias) : base(tagMapping, String.Empty, String.Empty, column_alias)
{
_ExpressionToEval = expressiontToEval;
_TestExpressions = new CaseTestCollection();
}
