protected sealed override string OnParseUpdate()
{
var builder = new StringBuilder();
builder.AppendFormat("Update {0}", MsSqlHelper.FormatSymbolName(Name)).AppendLine();
var retriever = new SqlMemberExpressionRetriever();
foreach (var column in Columns)
{
column.Accept(retriever);
}
using (var e = retriever.Members.GetEnumerator())
{
if (!e.MoveNext())
{
throw new InvalidOperationException("parameter count is zero");
}
builder.AppendFormat("Set [{0}] = @{0}", e.Current.Name).AppendLine();
while (e.MoveNext())
{
builder.AppendFormat(", [{0}] = @{0}", e.Current.Name).AppendLine();
}
}
builder.AppendFormat("From {0}", MsSqlHelper.FormatSymbolName(Name));
//foreach (var inner in _inners)
//{
// builder.AppendLine();
// inner.Parser();
// builder.Append(inner.Sql);
//}
if (Condition != null)
{
builder.AppendLine();
builder.Append("Where ");
var visitor = new MsSqlExpressionVisitor();
var expre = MsSqlExpressionVisitor.LogicExpression(Condition);
expre.Accept(visitor);
builder.Append(visitor.Complier());
}
return(builder.ToString());
}
protected sealed override string OnParseDelete()
{
var builder = new StringBuilder();
builder.AppendFormat("Delete From {0}", MsSqlHelper.FormatSymbolName(Name));
//foreach (var inner in _inners)
//{
// builder.AppendLine();
// inner.Parser();
// builder.Append(inner.Sql);
//}
if (Condition != null)
{
builder.AppendLine();
builder.Append("Where ");
var visitor = new MsSqlExpressionVisitor();
var expre = MsSqlExpressionVisitor.LogicExpression(Condition);
expre.Accept(visitor);
builder.Append(visitor.Complier());
}
return(builder.ToString());
}
protected sealed override string OnParseSelect()
{
var builder = new StringBuilder("Select ");
if (Top != null)
{
builder.AppendFormat("Top {0} ", Top.Value);
}
if (Columns.Count == 0)
{
builder.AppendLine("*");
}
else
{
using (var e = Columns.GetEnumerator())
{
e.MoveNext();
var visitor = new MsSqlExpressionVisitor();
e.Current.Accept(visitor);
builder.AppendFormat("{0}", visitor.Complier()).AppendLine();
while (e.MoveNext())
{
visitor.Reset();
e.Current.Accept(visitor);
builder.AppendFormat(", {0}", visitor.Complier()).AppendLine();
}
}
}
builder.AppendFormat("From {0}", MsSqlHelper.FormatSymbolName(Name));
if (Condition != null)
{
builder.AppendLine();
builder.Append("Where ");
var visitor = new MsSqlExpressionVisitor();
var expre = MsSqlExpressionVisitor.LogicExpression(Condition);
expre.Accept(visitor);
builder.Append(visitor.Complier());
}
if (Groups != null)
{
builder.AppendLine();
builder.AppendFormat("Group By {0}", string.Join(", ", Groups.Select(p => string.Format("[{0}]", p.Name))));
}
if (SortOrders != null)
{
using (var e = SortOrders.GetEnumerator())
{
if (e.MoveNext())
{
builder.AppendLine();
builder.AppendFormat("Order By [{0}] {1}", e.Current.Member.Name, e.Current.Ascending ? "Asc" : "Desc");
while (e.MoveNext())
{
builder.Append(", ");
builder.AppendFormat("[{0}] {1}", e.Current.Member.Name, e.Current.Ascending ? "Asc" : "Desc");
}
}
}
}
if (RowOffset != null)
{
//offset 5*2 rows fetch next 5 rows only
builder.AppendLine();
builder.Append("Offset ").Append(RowOffset.Offset).Append(" Rows Fetch Next ").Append(RowOffset.Count).Append(" Rows Only");
}
return(builder.ToString());
}