public string BuildEntityQuery(Guid ID, Guid treeNodeID)
{
StringBuilder sql = new StringBuilder();
//-collect from and join values-
Aspect.Model.Query.FieldsSQLBuilder dictionaryQuery = new DictionaryFieldsSQLBuilder(UserFields, Provider, treeNodeID);
StringBuilder join = new StringBuilder();
join.Append(dictionaryQuery.Join);
StringBuilder from = new StringBuilder();
from.Append(dictionaryQuery.From);
//
Aspect.Domain.DictionaryTree entity = Provider.DictionaryTrees.Single(d => d.ID == treeNodeID);
//item.Dictionary.TableName
string where = WhereClause.BuildExpression(string.Format("[{0}].[{1}]", entity.Alias, entity.PK), ID.ToString());
//
sql.AppendFormat(SqlTemplate,
from.ToString(),
join.ToString(),
where,
string.Empty,
entity.Dictionary.TableName,
entity.PK,
entity.Alias);
return sql.ToString();
}
public string BuildListQuery(Guid treeNodeID)
{
StringBuilder sql = new StringBuilder();
//--
string where = WhereClause.BuildExpression(SearchSource.Convert(this.SearchExpression));
//-collect from and join values-
Aspect.Model.Query.FieldsSQLBuilder dictionaryQuery = new DictionaryFieldsSQLBuilder(UserFields, Provider, treeNodeID);
StringBuilder join = new StringBuilder();
join.Append(dictionaryQuery.Join);
StringBuilder from = new StringBuilder();
from.Append(dictionaryQuery.From);
Aspect.Domain.DictionaryTree entity = Provider.DictionaryTrees.Single(d => d.ID == treeNodeID);
sql.AppendFormat(SqlTemplate,
from.ToString(),
join.ToString(),
where,
OrderExpression.OrderClause,
entity.Dictionary.TableName,
entity.PK,
entity.Alias);
return sql.ToString();
}