public override SqlProvider FormatToPageList <T>(int pageIndex, int pageSize) { var orderbySql = ResolveExpression.ResolveOrderBy(); var selectSql = ResolveExpression.ResolveSelect(null); 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(); SqlString = $@"SELECT T.* FROM ( SELECT ROW_NUMBER() OVER ( {orderbySql} ) AS ROWNUMBER, {(new Regex("SELECT").Replace(selectSql, "", 1))} {fromTableSql} {nolockSql}{joinSql} {whereSql} {groupSql} {havingSql} ) T WHERE ROWNUMBER BETWEEN {((pageIndex - 1) * pageSize) + 1} AND {pageIndex * pageSize};"; return(this); }
public override SqlProvider FormatToList <T>() { var topNum = DataBaseContext <T>().QuerySet.TopNum; 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(); var orderbySql = ResolveExpression.ResolveOrderBy(); SqlString = $@" {selectSql} {fromTableSql} {joinSql} {whereSql} {groupSql} {havingSql} {orderbySql}"; if (topNum.HasValue) { SqlString = $"{SqlString} LIMIT {topNum} "; } return(this); }
public override SqlProvider FormatGet <T>() { 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(); var orderbySql = ResolveExpression.ResolveOrderBy(); SqlString = $@"SELECT T.* FROM( {selectSql} {fromTableSql} {joinSql} {whereSql} {groupSql} {havingSql} {orderbySql} ) T LIMIT 0,1"; 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); }