QueryExpressionVisitor.cs 5.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158
  1. using Ant.DbExpressions;
  2. using Ant.ORM;
  3. using Ant.Query.QueryExpressions;
  4. using Ant.Query.QueryState;
  5. using Ant.Utility;
  6. using System.Collections.Generic;
  7. namespace Ant.Query.Visitors
  8. {
  9. class QueryExpressionVisitor : QueryExpressionVisitor<IQueryState>
  10. {
  11. static QueryExpressionVisitor _reducer = new QueryExpressionVisitor();
  12. QueryExpressionVisitor()
  13. {
  14. }
  15. public static IQueryState VisitQueryExpression(QueryExpression queryExpression)
  16. {
  17. return queryExpression.Accept(_reducer);
  18. }
  19. public override IQueryState Visit(RootQueryExpression exp)
  20. {
  21. IQueryState queryState = new RootQueryState(exp.ElementType);
  22. return queryState;
  23. }
  24. /// <summary>
  25. /// 构建Where
  26. /// </summary>
  27. /// <param name="exp"></param>
  28. /// <returns></returns>
  29. public override IQueryState Visit(WhereExpression exp)
  30. {
  31. IQueryState prevState = exp.PrevExpression.Accept(this);
  32. IQueryState state = prevState.Accept(exp);
  33. return state;
  34. }
  35. /// <summary>
  36. /// 构建Orderby
  37. /// </summary>
  38. /// <param name="exp"></param>
  39. /// <returns></returns>
  40. public override IQueryState Visit(OrderExpression exp)
  41. {
  42. IQueryState prevState = exp.PrevExpression.Accept(this);
  43. IQueryState state = prevState.Accept(exp);
  44. return state;
  45. }
  46. /// <summary>
  47. /// 构建Select
  48. /// </summary>
  49. /// <param name="exp"></param>
  50. /// <returns></returns>
  51. public override IQueryState Visit(SelectExpression exp)
  52. {
  53. IQueryState prevState = exp.PrevExpression.Accept(this);
  54. IQueryState state = prevState.Accept(exp);
  55. return state;
  56. }
  57. /// <summary>
  58. /// 构建分页
  59. /// </summary>
  60. /// <param name="exp"></param>
  61. /// <returns></returns>
  62. public override IQueryState Visit(SkipExpression exp)
  63. {
  64. IQueryState prevState = exp.PrevExpression.Accept(this);
  65. IQueryState state = prevState.Accept(exp);
  66. return state;
  67. }
  68. /// <summary>
  69. /// 构建Top
  70. /// </summary>
  71. /// <param name="exp"></param>
  72. /// <returns></returns>
  73. public override IQueryState Visit(TakeExpression exp)
  74. {
  75. IQueryState prevState = exp.PrevExpression.Accept(this);
  76. IQueryState state = prevState.Accept(exp);
  77. return state;
  78. }
  79. /// <summary>
  80. /// 构建函数
  81. /// </summary>
  82. /// <param name="exp"></param>
  83. /// <returns></returns>
  84. public override IQueryState Visit(AggregateQueryExpression exp)
  85. {
  86. IQueryState prevState = exp.PrevExpression.Accept(this);
  87. IQueryState state = prevState.Accept(exp);
  88. return state;
  89. }
  90. /// <summary>
  91. /// 构建Join
  92. /// </summary>
  93. /// <param name="exp"></param>
  94. /// <returns></returns>
  95. public override IQueryState Visit(JoinQueryExpression exp)
  96. {
  97. ResultElement resultElement = new ResultElement();
  98. IQueryState qs = QueryExpressionVisitor.VisitQueryExpression(exp.PrevExpression);
  99. FromQueryResult fromQueryResult = qs.ToFromQueryResult();
  100. DbFromTableExpression fromTable = fromQueryResult.FromTable;
  101. resultElement.FromTable = fromTable;
  102. List<IMappingObjectExpression> moeList = new List<IMappingObjectExpression>();
  103. moeList.Add(fromQueryResult.MappingObjectExpression);
  104. foreach (JoiningQueryInfo joiningQueryInfo in exp.JoinedQueries)
  105. {
  106. JoinQueryResult joinQueryResult = JoinQueryExpressionVisitor.VisitQueryExpression(joiningQueryInfo.Query.QueryExpression, resultElement, joiningQueryInfo.JoinType, joiningQueryInfo.Condition, moeList);
  107. var nullChecking = DbExpression.CaseWhen(new DbCaseWhenExpression.WhenThenExpressionPair(joinQueryResult.JoinTable.Condition, DbConstantExpression.One), DbConstantExpression.Null, DbConstantExpression.One.Type);
  108. if (joiningQueryInfo.JoinType == JoinType.LeftJoin)
  109. {
  110. joinQueryResult.MappingObjectExpression.SetNullChecking(nullChecking);
  111. }
  112. else if (joiningQueryInfo.JoinType == JoinType.RightJoin)
  113. {
  114. foreach (IMappingObjectExpression item in moeList)
  115. {
  116. item.SetNullChecking(nullChecking);
  117. }
  118. }
  119. else if (joiningQueryInfo.JoinType == JoinType.FullJoin)
  120. {
  121. joinQueryResult.MappingObjectExpression.SetNullChecking(nullChecking);
  122. foreach (IMappingObjectExpression item in moeList)
  123. {
  124. item.SetNullChecking(nullChecking);
  125. }
  126. }
  127. fromTable.JoinTables.Add(joinQueryResult.JoinTable);
  128. moeList.Add(joinQueryResult.MappingObjectExpression);
  129. }
  130. IMappingObjectExpression moe = SelectorExpressionVisitor.VisitSelectExpression(exp.Selector, moeList);
  131. resultElement.MappingObjectExpression = moe;
  132. GeneralQueryState queryState = new GeneralQueryState(resultElement);
  133. return queryState;
  134. }
  135. /// <summary>
  136. /// 构建分组
  137. /// </summary>
  138. /// <param name="exp"></param>
  139. /// <returns></returns>
  140. public override IQueryState Visit(GroupingQueryExpression exp)
  141. {
  142. IQueryState prevState = exp.PrevExpression.Accept(this);
  143. IQueryState state = prevState.Accept(exp);
  144. return state;
  145. }
  146. }
  147. }