public insertselect(ddl db, Fields fields, FieldInfo pk_for_auto_newid_seq)
{
Top = 0;
Distinct = false;
Tables = null;
Joins = null;
Where = null;
GroupBy = null;
Having = null;
OrderBy = null;
Fields = new selectlist();
foreach (Field f in fields)
{
if (pk_for_auto_newid_seq != null && f.Name == pk_for_auto_newid_seq.Name) /* [dlatikay 20110729] we can easily auto-increment for the next free integer PK value herein */
{
Fields.Add(new selectfield(new selectstatement(
new selectlist()
{
new selectfield(selectfunctiondef.max_inc, f.Name)
},
new tableexpressions(pk_for_auto_newid_seq.DeclaringType),
null,
null
), f.Name));
}
else
{
Fields.Add(new selectparam(db.MakeParamName(f.Name), f.Name, f.Type, f.Size));
}
}
}
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, 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 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 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 updateselect(ddl db, Fields fields)
{
Top = 0;
Distinct = false;
Tables = null;
Joins = null;
Where = new whereclause(fields.PKQueryExpression(db));
GroupBy = null;
Having = null;
OrderBy = null;
Fields = new selectlist();
foreach (Field f in fields)
{
if (!f.PrimaryKeyConstituent)
{
Fields.Add(new selectparam(db.MakeParamName(f.Name), f.Name, f.Type, f.Size));
}
}
}
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 insertstatement(string targettable, selectlist targetfields, insertselect source)
{
TargetTable = targettable;
TargetFields = targetfields;
Source = source;
}
public updatestatement(tableexpression targettable, selectlist targetfields, selectstatement source)
{
TargetTable = targettable;
TargetFields = targetfields;
Source = source;
}
public updatestatement(string targettablename, selectlist targetfields, selectstatement source)
{
TargetTable = new tableexpression(targettablename);
TargetFields = targetfields;
Source = source;
}
public insertstatement(Type targettable, selectlist targetfields, unionstatement source)
{
TargetTable = targettable.Name;
TargetFields = targetfields;
Source = source;
}
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)
{
}
public selectlist(selectlist to_be_appended_initially)
{
this.AddRange(to_be_appended_initially);
}
