public AggregateJoinModel(AggregateModel model, string aliasTableName, JoinConnect connect, QueryExpression query, QueryExpression having, OrderExpression order, JoinSetting setting)
{
this._model = model;
this._connect = connect;
this._query = query;
this._having = having;
this._order = order;
this._aliasTableName = aliasTableName;
this._joinMapping = model.OutputMapping;
if ((setting & JoinSetting.NoDataSetEntityNull) == JoinSetting.NoDataSetEntityNull)
{
_noDataSetEntityNull = true;
}
}
public AggregateJoinModel(AggregateModel model, string aliasTableName, JoinConnect connect, QueryExpression query, QueryExpression having, OrderExpression order, JoinSetting setting)
{
Model = model;
Connect = connect;
Query = query;
Having = having;
Order = order;
AliasTableName = aliasTableName;
JoinMapping = model.OutputDataMapping;
if ((setting & JoinSetting.NoDataSetEntityNull) == JoinSetting.NoDataSetEntityNull)
{
NoDataSetEntityNull = true;
}
}
public SelectJoinModel(SelectModel model, string aliasTableName, JoinConnect connect, QueryExpression query, OrderExpression order, JoinSetting setting)
{
this._model = model;
this._connect = connect;
this._query = query;
this._order = order;
this._aliasTableName = aliasTableName;
this._joinMapping = model.JoinTableMapping;
if ((setting & JoinSetting.QueryDistinct) == JoinSetting.QueryDistinct)
{
_distinct = true;
}
if ((setting & JoinSetting.NoDataSetEntityNull) == JoinSetting.NoDataSetEntityNull)
{
_noDataSetEntityNull = true;
}
}
public SelectJoinModel(SelectModel model, string aliasTableName, JoinConnect connect, QueryExpression query, OrderExpression order, JoinSetting setting)
{
Model = model;
Connect = connect;
Query = query;
Order = order;
AliasTableName = aliasTableName;
JoinMapping = model.JoinTableMapping;
if ((setting & JoinSetting.QueryDistinct) == JoinSetting.QueryDistinct)
{
Distinct = true;
}
if ((setting & JoinSetting.NoDataSetEntityNull) == JoinSetting.NoDataSetEntityNull)
{
NoDataSetEntityNull = true;
}
}
public EntityJoinModel(DataEntityMapping mapping, string aliasTableName, JoinConnect connect, QueryExpression query, OrderExpression order, JoinSetting setting)
{
this._mapping = mapping;
//this._selector = AllSelector.Value;
this._connect = connect;
this._query = query;
this._order = order;
this._aliasTableName = aliasTableName;
this._joinMapping = mapping;
if ((setting & JoinSetting.QueryDistinct) == JoinSetting.QueryDistinct)
{
_distinct = true;
}
if ((setting & JoinSetting.NoDataSetEntityNull) == JoinSetting.NoDataSetEntityNull)
{
_noDataSetEntityNull = true;
}
}
private void LoadJoinRelate()
{
LoadEntityMapping(RootMapping, null);
var joinSelector = new JoinSelector();
var items = new List <RelationItem>();
// var relationItemDict = new Dictionary<string, RelationItem>();
var tIndex = 0;
foreach (var link in linkList)
{
var sItems = link.GetRelationItems();
foreach (var item in sItems)
{
if (!items.Contains(item))
{
if (item.FieldMapping == null && tIndex != 0)
{
continue;
}
item.AliasName = "T" + tIndex;
tIndex++;
items.Add(item);
// relationItemDict.Add(item.CurrentFieldPath, item);
}
}
}
var rootItem = items[0];
mapDict.Add(items[0].CurrentFieldPath, items[0]);
var rootInfoList = new List <DataFieldInfo>();
foreach (var field in RootMapping.DataEntityFields)
{
var info = new DataFieldInfo(field);
var aliasName = $"{rootItem.AliasName}_{info.FieldName}";
var alias = new AliasDataFieldInfo(info, aliasName, rootItem.AliasName);
joinSelector.SetAliasDataField(alias);
rootInfoList.Add(alias);
fieldInfoDict.Add($"{items[0].CurrentFieldPath}.{field.IndexName}", alias);
}
tableInfoDict.Add(items[0].CurrentFieldPath, rootInfoList.ToArray());
for (var i = 1; i < items.Count; i++)
{
var mItem = items[i];
mapDict.Add(mItem.CurrentFieldPath, mItem);
var fieldMapping = mItem.FieldMapping;
var mapping = fieldMapping.RelateMapping;
DataFieldExpression expression = null;
var rItem = mapDict[mItem.PrevFieldPath];
var mAlias = rItem.AliasName;
var rAlias = mItem.AliasName;
var relations = fieldMapping.CreateDataFieldInfoRelations(mAlias, rAlias);
foreach (var relation in relations)
{
var mInfo = relation.MasterInfo;
var rInfo = relation.RelateInfo;
var keyExpression = new DataFieldOnMatchExpression(mInfo, rInfo, QueryPredicate.Eq);
expression = DataFieldExpression.And(expression, keyExpression);
}
var infoList = new List <DataFieldInfo>();
foreach (var field in mapping.DataEntityFields)
{
var info = new DataFieldInfo(field);
var aliasName = $"{rAlias}_{info.FieldName}";
var alias = new AliasDataFieldInfo(info, aliasName, rAlias);
joinSelector.SetAliasDataField(alias);
infoList.Add(alias);
fieldInfoDict.Add($"{mItem.CurrentFieldPath}.{field.Name}", alias);
}
tableInfoDict.Add(mItem.CurrentFieldPath, infoList.ToArray());
var connect = new JoinConnect(JoinType.LeftJoin, expression);
var model = new EntityJoinModel(mapping, rAlias, connect, null, null, JoinSetting.None);
selector = joinSelector;
models.Add(model);
}
}
void LoadJoinRelate()
{
LoadEntityMapping(this.rootMapping, null);
JoinSelector joinSelector = new JoinSelector();
List <RelationItem> items = new List <RelationItem>();
Dictionary <string, RelationItem> relationItemDict = new Dictionary <string, RelationItem>();
int tindex = 0;
foreach (RelationLink link in linkList)
{
RelationItem[] sitems = link.GetRelationItems();
foreach (RelationItem item in sitems)
{
if (!items.Contains(item))
{
if (item.FieldMapping == null && tindex != 0)
{
continue;
}
item.AliasName = "T" + tindex;
tindex++;
items.Add(item);
relationItemDict.Add(item.CurrentFieldPath, item);
}
}
}
//if (this.rootMapping != items [0].DataMapping) {
// throw new LightDataException (RE.RelationMapEntityMappingError);
//}
RelationItem rootItem = items[0];
mapDict.Add(items[0].CurrentFieldPath, items[0]);
List <DataFieldInfo> rootInfoList = new List <DataFieldInfo>();
foreach (DataFieldMapping field in this.rootMapping.DataEntityFields)
{
DataFieldInfo info = new DataFieldInfo(field);
string aliasName = string.Format("{0}_{1}", rootItem.AliasName, info.FieldName);
AliasDataFieldInfo alias = new AliasDataFieldInfo(info, aliasName, rootItem.AliasName);
//alias.AliasTablesName = rootItem.AliasName;
joinSelector.SetAliasDataField(alias);
rootInfoList.Add(alias);
fieldInfoDict.Add(string.Format("{0}.{1}", items[0].CurrentFieldPath, field.IndexName), alias);
}
tableInfoDict.Add(items[0].CurrentFieldPath, rootInfoList.ToArray());
for (int i = 1; i < items.Count; i++)
{
RelationItem mitem = items[i];
mapDict.Add(mitem.CurrentFieldPath, mitem);
SingleRelationFieldMapping fieldMapping = mitem.FieldMapping;
DataEntityMapping mapping = fieldMapping.RelateMapping;
DataFieldExpression expression = null;
//DataFieldInfoRelation [] relations = fieldMapping.GetDataFieldInfoRelations ();
RelationItem ritem = mapDict[mitem.PrevFieldPath];
string malias = ritem.AliasName;
string ralias = mitem.AliasName;
DataFieldInfoRelation[] relations = fieldMapping.CreateDataFieldInfoRelations(malias, ralias);
foreach (DataFieldInfoRelation relation in relations)
{
DataFieldInfo minfo = relation.MasterInfo;
//minfo.AliasTableName = malias;
DataFieldInfo rinfo = relation.RelateInfo;
//rinfo.AliasTableName = ralias;
DataFieldMatchExpression keyExpression = new DataFieldMatchExpression(minfo, rinfo, QueryPredicate.Eq);
expression = DataFieldExpression.And(expression, keyExpression);
//expression = DataFieldExpression.And (expression, minfo == rinfo);
}
List <DataFieldInfo> infoList = new List <DataFieldInfo>();
foreach (DataFieldMapping field in mapping.DataEntityFields)
{
DataFieldInfo info = new DataFieldInfo(field);
string aliasName = string.Format("{0}_{1}", ralias, info.FieldName);
AliasDataFieldInfo alias = new AliasDataFieldInfo(info, aliasName, ralias);
//alias.AliasTableName = ralias;
joinSelector.SetAliasDataField(alias);
infoList.Add(alias);
fieldInfoDict.Add(string.Format("{0}.{1}", mitem.CurrentFieldPath, field.Name), alias);
}
tableInfoDict.Add(mitem.CurrentFieldPath, infoList.ToArray());
JoinConnect connect = new JoinConnect(JoinType.LeftJoin, expression);
EntityJoinModel model = new EntityJoinModel(mapping, ralias, connect, null, null, JoinSetting.None);
this.selector = joinSelector;
this.models.Add(model);
}
}