public QColumnValueCondition(QColumnBase column1, string op, object value)
{
leftColumn = column1;
this.op = op;
this.value = value;
isSetValaue = true;
}
public void OrderBy(QColumnBase column, OrderType orderType = OrderType.Asc)
{
if (_jump)
{
_jump = false; return;
}
_orderBys.Add(new OrderItem(column, orderType));
}
public void GroupBy(QColumnBase column, params QColumnBase[] columns)
{
if (_jump)
{
_jump = false; return;
}
_groupBy.Add(column);
foreach (var item in columns)
{
_groupBy.Add(item);
}
}
public override string Delete(List <QTable> tables, QColumnBase pk, string tableName, string fromtable, string jointables, string where)
{
return($"DELETE t1 FROM {fromtable} {jointables} WHERE {where};");
}
public int SelectCount(QColumnBase distinctColumn)
{
var column = ((IColumnConvert)distinctColumn).ToSql(Provider, _tables.Count);
return(getCount(column));
}
public override string Delete(List <QTable> tables, QColumnBase pk, string tableName, string fromtable, string jointables, string where)
{
return("DELETE t1 FROM " + fromtable
+ " " + jointables
+ " WHERE " + where);
}
//internal new QColumnBase leftColumn;
//internal new QColumnBase rightColumn;
public QJoinCondition(QColumnBase column1, string op, QColumnBase column2)
: base(column1, op, column2)
{
//leftColumn = column1;
//rightColumn = column2;
}
public QColumnColumnCondition(QColumnBase column1, string op, QColumnBase column2)
{
leftColumn = column1;
Op = op;
rightColumn = column2;
}
public QColumnValueCondition(QColumnBase column1, string op)
{
leftColumn = column1;
this.op = op;
}
public OrderItem(QColumnBase column, OrderType orderType)
{
this.column = column;
this.orderType = orderType;
}
public override string Delete(List <QTable> tables, QColumnBase pk, string tableName, string fromtable, string jointables, string where)
{
//http://bbs.csdn.net/topics/340167958
return($"DELETE distinctrow t1.* FROM {fromtable} {jointables} WHERE {where};");
}
