public selectstatement(int top, bool distinct, selectlist fields, tableexpressions tables, joinstatements joins, whereclause where)
{
Top = top;
Distinct = distinct;
Fields = fields;
Tables = tables;
Joins = joins;
Where = where;
}
public selectstatement(int top, bool distinct, selectlist fields, tableexpressions tables, joinstatements joins, whereclause where, groupbystatement group, whereclause having, orderbystatement order)
{
Top = top;
Distinct = distinct;
Fields = fields;
Tables = tables;
Joins = joins;
Where = where;
GroupBy = group;
Having = having;
OrderBy = order;
}
public selectstatement(selectlist fields, tableexpressions tables, joinstatements joins, whereclause where)
: this(0, false, fields, tables, joins, where, null, null, null)
{
//Top = 0;
//Distinct = false;
//Fields = fields;
//Tables = tables;
//Joins = joins;
//Where = where;
//GroupBy = null;
//Having = null;
//OrderBy = null;
}
public selectstatement(selectlist fields, tableexpressions tables, joinstatements joins, whereclause where, groupbystatement group, whereclause having, orderbystatement order)
: this(0, false, fields, tables, joins, where, group, having, order)
{
//Top = 0;
//Distinct = false;
//Fields = fields;
//Tables = tables;
//Joins = joins;
//Where = where;
//GroupBy = group;
//Having = having;
//OrderBy = order;
}
public plainselect_update(selectlist fields, string table, whereclause where)
{
Top = 0;
Distinct = false;
Tables = new tableexpressions()
{
new tableexpression(table)
};
Joins = null;
Where = where;
GroupBy = null;
Having = null;
OrderBy = null;
Fields = fields;
}
public plainselect_where(string[] fields, string table, whereclause where)
{
Top = 0;
Distinct = false;
Tables = new tableexpressions()
{
new tableexpression(table)
};
Joins = null;
Where = where;
GroupBy = null;
Having = null;
OrderBy = null;
Fields = new selectlist();
foreach (string f in fields)
{
Fields.Add(new selectfield(f));
}
}
public insertselect(selectlist fields, tableexpressions tables, joinstatements joins, whereclause where)
: base(fields, tables, joins, where)
{
}
public insertselect(selectlist fields, tableexpressions tables, joinstatements joins, whereclause where, groupbystatement group, whereclause having, orderbystatement order)
: base(fields, tables, joins, where, group, having, order)
{
}
public insertselect(int top, bool distinct, selectlist fields, tableexpressions tables, joinstatements joins, whereclause where)
: base(top, distinct, fields, tables, joins, where)
{
}
public insertselect(int top, bool distinct, selectlist fields, tableexpressions tables, joinstatements joins, whereclause where, groupbystatement group, whereclause having, orderbystatement order)
: base(top, distinct, fields, tables, joins, where, group, having, order)
{
}