public QueryJoinDef AddJoin(QuerySourceDef source, SqlSourceJoinType joinType) { Def.Sources.Add(source); if (!String.IsNullOrWhiteSpace(source.Alias)) { _sourceAliases.Add(source.Alias, source); } else { _sourceAliasNo++; while (_sourceAliases.ContainsKey("source" + _sourceAliasNo)) { _sourceAliasNo++; } source.Alias = "source" + _sourceAliasNo; _sourceAliases.Add(source.Alias, source); } var join = new QueryJoinDef { Source = source, Operation = joinType }; Def.Joins.Add(join); return(join); }
public SqlQueryJoin(SqlQuerySource source, SqlQuerySource target, SqlSourceJoinType joinType, Guid attrDefId) { Source = source; Target = target; JoinType = joinType; SqlQuerySource attrSource; JoinAttrDef = Source.FindAttributeDef(attrDefId); if (JoinAttrDef != null) { attrSource = Source; } else { JoinAttrDef = Target.FindAttributeDef(attrDefId); attrSource = Target; IsTargetAttribute = true; } // if (JoinAttrDef.Type.Id == (short)CissaDataType.Doc) if (JoinAttrDef != null) { JoinAttribute = attrSource.GetAttribute(JoinAttrDef.Id); } }
public SqlBuilder AddJoin(SqlSourceJoinType type, string source) { if (Joins == null) { Joins = new List <SqlSourceJoin>(); } Joins.Add(new SqlSourceJoin(type, source)); return(this); }
public SqlBuilder AddJoin(SqlSourceJoinType type, string source, params object[] args) { AddJoin(type, String.Format(source, args)); return(this); }
public SqlSourceJoin(SqlSourceJoinType type, string source) { Type = type; Source = source; }
public SqlQueryJoin(SqlQuerySource target, SqlSourceJoinType joinType) { // Source = source; Target = target; JoinType = joinType; }