public object ToProperty(DataContext context, IDataReader datareader, QueryState queryState, string fieldPath) { if (!queryState.GetJoinData(fieldPath, out object value)) { string aliasName = queryState.GetAliasName(fieldPath); foreach (DataFieldInfo info in this.relateInfos) { string name = string.Format("{0}_{1}", aliasName, info.FieldName); if (queryState.CheckSelectField(aliasName)) { object obj = datareader[name]; if (Object.Equals(obj, DBNull.Value) || Object.Equals(obj, null)) { queryState.SetJoinData(fieldPath, null); return(null); } } else { queryState.SetJoinData(fieldPath, null); return(null); } } if (queryState.CheckSelectField(aliasName)) { //object item = Activator.CreateInstance(this.RelateMapping.ObjectType); //queryState.SetJoinData(fieldPath, item); //this.relateEntityMapping.LoadJoinTableData(context, datareader, item, queryState, fieldPath); //value = item; value = this.relateEntityMapping.LoadJoinTableData(context, datareader, queryState, fieldPath); } else { queryState.SetJoinData(fieldPath, null); return(null); } } return(value); }
public virtual object LoadJoinTableData(DataContext context, IDataReader dataReader, QueryState queryState, string fieldPath) { var item = Activator.CreateInstance(ObjectType); queryState.SetJoinData(fieldPath, item); var aliasName = queryState.GetAliasName(fieldPath); foreach (var field in _fieldList) { var name = $"{aliasName}_{field.Name}"; if (queryState.CheckSelectField(name)) { var obj = dataReader[name]; var value = field.ToProperty(obj); if (!Equals(value, null)) { field.Handler.Set(item, value); } } } if (_collectionRelationFields.Count > 0) { foreach (var mapping in _collectionRelationFields) { mapping.Handler.Set(item, mapping.ToProperty(context, item, true)); } } foreach (var mapping in _singleRelationFields) { var path = $"{fieldPath}.{mapping.FieldName}"; var value = mapping.ToProperty(context, dataReader, queryState, path); if (!Equals(value, null)) { mapping.Handler.Set(item, value); } } if (IsDataEntity && item is DataEntity entity) { entity.SetContext(context); } return(item); }
//public virtual void LoadJoinTableData(DataContext context, IDataReader datareader, object item, QueryState queryState, string fieldPath) //{ // string aliasName = queryState.GetAliasName(fieldPath); // foreach (DataFieldMapping field in this._fieldList) { // string name = string.Format("{0}_{1}", aliasName, field.Name); // if (queryState.CheckSelectField(name)) { // object obj = datareader[name]; // object value = field.ToProperty(obj); // if (!Object.Equals(value, null)) { // field.Handler.Set(item, value); // } // } // } // if (_collectionRelationFields.Count > 0) { // foreach (CollectionRelationFieldMapping mapping in _collectionRelationFields) { // mapping.Handler.Set(item, mapping.ToProperty(context, item, true)); // } // } // foreach (SingleRelationFieldMapping mapping in _singleRelationFields) { // string fpath = string.Format("{0}.{1}", fieldPath, mapping.FieldName); // object value = mapping.ToProperty(context, datareader, queryState, fpath); // if (!Object.Equals(value, null)) { // mapping.Handler.Set(item, value); // } // } // if (item is DataEntity entity) { // entity.SetContext(context); // entity.LoadDataComplete(); // } //} public virtual object LoadJoinTableData(DataContext context, IDataReader datareader, QueryState queryState, string fieldPath) { object item = Activator.CreateInstance(this.ObjectType); queryState.SetJoinData(fieldPath, item); string aliasName = queryState.GetAliasName(fieldPath); foreach (DataFieldMapping field in this._fieldList) { string name = string.Format("{0}_{1}", aliasName, field.Name); if (queryState.CheckSelectField(name)) { object obj = datareader[name]; object value = field.ToProperty(obj); if (!Object.Equals(value, null)) { field.Handler.Set(item, value); } } } if (_collectionRelationFields.Count > 0) { foreach (CollectionRelationFieldMapping mapping in _collectionRelationFields) { mapping.Handler.Set(item, mapping.ToProperty(context, item, true)); } } foreach (SingleRelationFieldMapping mapping in _singleRelationFields) { string fpath = string.Format("{0}.{1}", fieldPath, mapping.FieldName); object value = mapping.ToProperty(context, datareader, queryState, fpath); if (!Object.Equals(value, null)) { mapping.Handler.Set(item, value); } } if (_isDataEntity) { DataEntity entity = item as DataEntity; entity.SetContext(context); } return(item); }