--连表
(1)from (1-J)<left_table><join_type> join <right_table> on <on_predicate>
(1-A)<left_table><apply_type> apply <right_table_expression> as <alias>
(1-P)<left_table> pivot (<pivot_specification>) as <alias>
(1-U)<left_table> unpivot (<unpivot_specification>) as <alias>
--查询条件
(2)where <where_pridicate>
--分组
(3)group by <group_by_specification>
--分组条件
(4)having<having_predicate>
--排序
(6)order by<order_by_list>
注:sql语句先where筛选再gruop by分组再having查询条件最后order by
public List<Plan601.Work.Model.V_TONGJI> Search(int? repair, int? plan_type, string arr, DateTime? from, DateTime? to)
{
StringBuilder sql = new StringBuilder("select v.flowtype, count(*) as CN, v.createyear from");
sql.Appen