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);
}