public Expression2SqlCore <T> Sum(Expression <Func <T, object> > expression)
{
_sqlPack.Clear();
_sqlPack.IsSingleTable = true;
Expression2SqlProvider.Sum(expression.Body, _sqlPack);
return(this);
}
public Expression2SqlCore <T> Update(Expression <Func <object> > expression = null)
{
_sqlPack.Clear();
_sqlPack.IsSingleTable = true;
_sqlPack += "update " + typeof(T).Name + " set ";
Expression2SqlProvider.Update(expression.Body, _sqlPack);
return(this);
}
private Expression2SqlCore <T> JoinParser2 <T2, T3>(Expression <Func <T2, T3, bool> > expression,
string leftOrRightJoin = "")
{
var joinTableName = typeof(T3).Name;
_sqlPack.SetTableAlias(joinTableName);
_sqlPack.Sql.AppendFormat("\n{0}join {1} on", leftOrRightJoin,
joinTableName + " " + _sqlPack.GetTableAlias(joinTableName));
Expression2SqlProvider.Join(expression.Body, _sqlPack);
return(this);
}
public Expression2SqlCore <T> Count(Expression <Func <T, object> > expression = null)
{
_sqlPack.Clear();
_sqlPack.IsSingleTable = true;
if (expression == null)
{
_sqlPack.Sql.AppendFormat("select count(*) from {0}", typeof(T).Name);
}
else
{
Expression2SqlProvider.Count(expression.Body, _sqlPack);
}
return(this);
}
public Expression2SqlCore <T> Select <T2, T3>(Expression <Func <T, T2, T3, object> > expression = null)
{
var sql = SelectParser(typeof(T), typeof(T2), typeof(T3));
if (expression == null)
{
_sqlPack.Sql.AppendFormat(sql, "*");
}
else
{
Expression2SqlProvider.Select(expression.Body, _sqlPack);
_sqlPack.Sql.AppendFormat(sql, _sqlPack.SelectFieldsStr);
}
return(this);
}
public Expression2SqlCore <T> Select <T2, T3, T4, T5, T6, T7, T8, T9, T10>(
Expression <Func <T, T2, T3, T4, T5, T6, T7, T8, T9, T10, object> > expression = null)
{
var sql = SelectParser(typeof(T), typeof(T2), typeof(T3), typeof(T4), typeof(T5), typeof(T6), typeof(T7),
typeof(T8), typeof(T9), typeof(T10));
if (expression == null)
{
_sqlPack.Sql.AppendFormat(sql, "*");
}
else
{
Expression2SqlProvider.Select(expression.Body, _sqlPack);
_sqlPack.Sql.AppendFormat(sql, _sqlPack.SelectFieldsStr);
}
return(this);
}
public Expression2SqlCore <T> OrderBy(Expression <Func <T, object> > expression)
{
_sqlPack += "\norder by ";
Expression2SqlProvider.OrderBy(expression.Body, _sqlPack);
return(this);
}
public Expression2SqlCore <T> GroupBy(Expression <Func <T, object> > expression)
{
_sqlPack += "\ngroup by ";
Expression2SqlProvider.GroupBy(expression.Body, _sqlPack);
return(this);
}
public Expression2SqlCore <T> Where(Expression <Func <T, bool> > expression)
{
_sqlPack += "\nwhere";
Expression2SqlProvider.Where(expression.Body, _sqlPack);
return(this);
}
