public RelationLinkType TryAddField(SingleRelationFieldMapping relateMapping) { var last = items[items.Count - 1]; if (!Equals(relateMapping.MasterMapping, last.DataMapping)) { throw new LightDataException(string.Format(SR.RelationFieldError, relateMapping.MasterMapping.ObjectType, relateMapping.FieldName)); } var keys = relateMapping.GetKeyPairs(); if (keys.Length != keyCount) { return(RelationLinkType.NoMatch); } var masters = new string[keyCount]; var relates = new string[keyCount]; for (var i = 0; i < keyCount; i++) { masters[i] = keys[i].MasterKey; relates[i] = keys[i].RelateKey; } if (!IsMatch(last.Keys, masters)) { return(RelationLinkType.NoMatch); } PrevFieldPath = LastFieldPath; LastFieldPath = $"{last.CurrentFieldPath}.{relateMapping.FieldName}"; var len = items.Count - 1; for (var i = 0; i < len; i++) { var item = items[i]; if (Equals(relateMapping.RelateMapping, item.DataMapping)) { if (IsMatch(item.Keys, relates)) { CycleFieldPath = item.CurrentFieldPath; return(RelationLinkType.Cycle); } throw new LightDataException(string.Format(SR.RelationFieldKeyNotMatch, relateMapping.MasterMapping.ObjectType, relateMapping.FieldName)); } } var relateItem = new RelationItem { DataMapping = relateMapping.RelateMapping, FieldMapping = relateMapping, PrevFieldPath = PrevFieldPath, CurrentFieldPath = LastFieldPath, Keys = relates }; items.Add(relateItem); return(RelationLinkType.AddLink); }
public RelationLinkType TryAddField(SingleRelationFieldMapping relateMapping) { RelationItem last = items[items.Count - 1]; if (!Object.Equals(relateMapping.MasterMapping, last.DataMapping)) { throw new LightDataException(string.Format(SR.RelationFieldError, relateMapping.MasterMapping.ObjectType, relateMapping.FieldName)); } RelationKey[] keys = relateMapping.GetKeyPairs(); if (keys.Length != keyCount) { return(RelationLinkType.NoMatch); } string[] masters = new string[this.keyCount]; string[] relates = new string[this.keyCount]; for (int i = 0; i < this.keyCount; i++) { masters[i] = keys[i].MasterKey; relates[i] = keys[i].RelateKey; } if (!IsMatch(last.Keys, masters)) { return(RelationLinkType.NoMatch); } prevFieldPath = lastFieldPath; lastFieldPath = string.Format("{0}.{1}", last.CurrentFieldPath, relateMapping.FieldName); int len = items.Count - 1; for (int i = 0; i < len; i++) { RelationItem item = items[i]; if (Object.Equals(relateMapping.RelateMapping, item.DataMapping)) { if (IsMatch(item.Keys, relates)) { cycleFieldPath = item.CurrentFieldPath; return(RelationLinkType.Cycle); } else { throw new LightDataException(string.Format(SR.RelationFieldKeyNotMatch, relateMapping.MasterMapping.ObjectType, relateMapping.FieldName)); } } } RelationItem relateItem = new RelationItem() { DataMapping = relateMapping.RelateMapping, FieldMapping = relateMapping, PrevFieldPath = prevFieldPath, CurrentFieldPath = lastFieldPath, Keys = relates }; items.Add(relateItem); return(RelationLinkType.AddLink); }
public RelationLink(SingleRelationFieldMapping rootRelationMapping, string fieldPath) { if (rootRelationMapping == null) { throw new ArgumentNullException(nameof(rootRelationMapping)); } //this.rootRelationMapping = rootRelationMapping; var keys = rootRelationMapping.GetKeyPairs(); keyCount = keys.Length; var masters = new string[keyCount]; var relates = new string[keyCount]; for (var i = 0; i < keyCount; i++) { masters[i] = keys[i].MasterKey; relates[i] = keys[i].RelateKey; } LastFieldPath = $"{fieldPath}.{rootRelationMapping.FieldName}"; PrevFieldPath = fieldPath; var masterItem = new RelationItem { DataMapping = rootRelationMapping.MasterMapping, FieldMapping = null, //PrevFieldPath = prevFieldPath, CurrentFieldPath = PrevFieldPath, Keys = masters }; var relateItem = new RelationItem { DataMapping = rootRelationMapping.RelateMapping, FieldMapping = rootRelationMapping, PrevFieldPath = PrevFieldPath, CurrentFieldPath = LastFieldPath, Keys = relates }; items.Add(masterItem); items.Add(relateItem); }
public RelationLink(SingleRelationFieldMapping rootRelationMapping, string fieldPath) { if (rootRelationMapping == null) { throw new ArgumentNullException(nameof(rootRelationMapping)); } //this.rootRelationMapping = rootRelationMapping; RelationKey[] keys = rootRelationMapping.GetKeyPairs(); this.keyCount = keys.Length; string[] masters = new string[this.keyCount]; string[] relates = new string[this.keyCount]; for (int i = 0; i < this.keyCount; i++) { masters[i] = keys[i].MasterKey; relates[i] = keys[i].RelateKey; } lastFieldPath = string.Format("{0}.{1}", fieldPath, rootRelationMapping.FieldName); prevFieldPath = fieldPath; RelationItem masterItem = new RelationItem() { DataMapping = rootRelationMapping.MasterMapping, FieldMapping = null, //PrevFieldPath = prevFieldPath, CurrentFieldPath = prevFieldPath, Keys = masters }; RelationItem relateItem = new RelationItem() { DataMapping = rootRelationMapping.RelateMapping, FieldMapping = rootRelationMapping, PrevFieldPath = prevFieldPath, CurrentFieldPath = lastFieldPath, Keys = relates }; items.Add(masterItem); items.Add(relateItem); }
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); } }