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