public override SqlProvider FormatMin(LambdaExpression minExpression) { var selectSql = ResolveExpression.ResolveMin(minExpression); var fromTableSql = FormatTableName(); var whereSql = ResolveExpression.ResolveWhereList(); string noneSql = ""; var joinSql = ResolveExpression.ResolveJoinSql(JoinList, ref noneSql); SqlString = $"{selectSql} {fromTableSql}{joinSql} {whereSql} "; return(this); }
public override SqlProvider FormatSum(LambdaExpression sumExpression) { var selectSql = ResolveExpression.ResolveSum(sumExpression); var fromTableSql = FormatTableName(); var nolockSql = ResolveExpression.ResolveWithNoLock(Context.Set.NoLock); var whereSql = ResolveExpression.ResolveWhereList(); string noneSql = ""; var joinSql = ResolveExpression.ResolveJoinSql(JoinList, ref noneSql); SqlString = $"{selectSql} {fromTableSql} {nolockSql} {joinSql} {whereSql} "; return(this); }
public override SqlProvider FormatCount() { var selectSql = "SELECT COUNT(1)"; var fromTableSql = FormatTableName(); var nolockSql = ResolveExpression.ResolveWithNoLock(Context.Set.NoLock); var whereSql = ResolveExpression.ResolveWhereList(); string noneSql = ""; var joinSql = ResolveExpression.ResolveJoinSql(JoinList, ref noneSql); var groupSql = ResolveExpression.ResolveGroupBy(); var havingSql = ResolveExpression.ResolveHaving(); if (!Context.Set.IsDistinct) { if (string.IsNullOrEmpty(groupSql)) { SqlString = $"{selectSql} {fromTableSql} {nolockSql} {joinSql} {whereSql}"; } else { selectSql = ResolveExpression.ResolveSelect(null); SqlString = $"SELECT COUNT(*) FROM( {selectSql} {fromTableSql} {nolockSql} {joinSql} {whereSql} {groupSql} {havingSql} )T"; } } else { //字段解析字符 string countBySql = ResolveExpression.ResolveSelect(null); SqlString = $@"SELECT COUNT(*) FROM( {countBySql} {fromTableSql} {nolockSql} {joinSql} {whereSql} )T"; } return(this); }
public override SqlProvider FormatGet <T>() { var selectSql = ResolveExpression.ResolveSelect(1); var fromTableSql = FormatTableName(); var nolockSql = ResolveExpression.ResolveWithNoLock(Context.Set.NoLock); var whereSql = ResolveExpression.ResolveWhereList(); var joinSql = ResolveExpression.ResolveJoinSql(JoinList, ref selectSql); var groupSql = ResolveExpression.ResolveGroupBy(); var havingSql = ResolveExpression.ResolveHaving(); var orderbySql = ResolveExpression.ResolveOrderBy(); SqlString = $"{selectSql} {fromTableSql} {nolockSql} {joinSql} {whereSql} {groupSql} {havingSql} {orderbySql}"; return(this); }
public override SqlProvider FormatToPageList <T>(int pageIndex, int pageSize) { var orderbySql = ResolveExpression.ResolveOrderBy(); var selectSql = ResolveExpression.ResolveSelect(null); var fromTableSql = FormatTableName(); var whereSql = ResolveExpression.ResolveWhereList(); var joinSql = ResolveExpression.ResolveJoinSql(JoinList, ref selectSql); var groupSql = ResolveExpression.ResolveGroupBy(); var havingSql = ResolveExpression.ResolveHaving(); SqlString = $@" {selectSql} {fromTableSql} {joinSql} {whereSql} {groupSql} {havingSql} {orderbySql} LIMIT {((pageIndex - 1) * pageSize)},{pageSize};"; return(this); }