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 WHERE ROWNUM<=1"; return(this); }
public override SqlProvider FormatGet <T>() { var selectSql = ResolveExpression.ResolveSelect(EntityCache.QueryEntity(typeof(T)), Context.Set.SelectExpression, null, Params); var fromTableSql = FormatTableName(); var joinSql = ResolveExpression.ResolveJoinSql(JoinList, ref selectSql, Context.Set.SelectExpression); var whereSql = string.Empty; //表查询条件 var whereParamsList = ResolveExpression.ResolveWhereList(Context.Set, ref whereSql, Params); var orderbySql = ResolveExpression.ResolveOrderBy(Context.Set); SqlString = $@"SELECT T.* FROM( {selectSql} {fromTableSql} {joinSql} {whereSql} {orderbySql} ) T LIMIT 0,1"; return(this); }
public override SqlProvider FormatGet <T>() { var selectSql = ResolveExpression.ResolveSelect(EntityCache.QueryEntity(typeof(T)), Context.Set.SelectExpression, null, Params); var fromTableSql = FormatTableName(); var joinSql = ResolveExpression.ResolveJoinSql(JoinList, ref selectSql, Context.Set.SelectExpression); var whereSql = ResolveExpression.ResolveWhereList(Context.Set); var groupSql = ResolveExpression.ResolveGroupBy(Context.Set); var havingSql = ResolveExpression.ResolveHaving(Context.Set); var orderbySql = ResolveExpression.ResolveOrderBy(Context.Set); SqlString = $@"SELECT T.* FROM( {selectSql} {fromTableSql} {joinSql} {whereSql} {groupSql} {havingSql} {orderbySql} ) T WHERE ROWNUM<=1"; return(this); }
public override SqlProvider FormatGet <T>() { var selectSql = ResolveExpression.ResolveSelect(EntityCache.QueryEntity(typeof(T)), Context.Set.SelectExpression, 1, Params); var fromTableSql = FormatTableName(); var nolockSql = ResolveExpression.ResolveWithNoLock(Context.Set.NoLock); var joinSql = ResolveExpression.ResolveJoinSql(JoinList, ref selectSql, Context.Set.SelectExpression); var whereSql = ResolveExpression.ResolveWhereList(Context.Set, Params); var groupSql = ResolveExpression.ResolveGroupBy(Context.Set, "Group"); var orderbySql = ResolveExpression.ResolveOrderBy(Context.Set); SqlString = $"{selectSql} {fromTableSql} {nolockSql} {joinSql} {whereSql} {groupSql} {orderbySql}"; 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); }