AggregateNode.cs source code in C# .NET

                        
Code:
                         / Dotnetfx_Vista_SP2 / Dotnetfx_Vista_SP2 / 8.0.50727.4016 / DEVDIV / depot / DevDiv / releases / whidbey / NetFxQFE / ndp / fx / src / Data / System / Data / Filter / AggregateNode.cs / 1 / AggregateNode.cs
                        

                        
                            //------------------------------------------------------------------------------ 
// 
//     Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// [....] 
// [....]
//----------------------------------------------------------------------------- 
 
namespace System.Data {
    using System; 
    using System.Diagnostics;
    using System.Collections.Generic;
    using System.ComponentModel;
 
    internal enum Aggregate {
        None = FunctionId.none, 
        Sum = FunctionId.Sum, 
        Avg = FunctionId.Avg,
        Min = FunctionId.Min, 
        Max = FunctionId.Max,
        Count = FunctionId.Count,
        StDev = FunctionId.StDev,   // Statistical standard deviation
        Var = FunctionId.Var,       // Statistical variance 
    }
 
    internal sealed class AggregateNode : ExpressionNode { 
        private readonly AggregateType type;
        private readonly Aggregate aggregate; 
        private readonly bool local;     // set to true if the aggregate calculated localy (for the current table)

        private readonly string relationName;
        private readonly string columnName; 

        // 
 
        private DataTable childTable;
        private DataColumn column; 
        private DataRelation relation;

        internal AggregateNode(DataTable table, FunctionId aggregateType, string columnName) :
            this(table, aggregateType, columnName, true, null) { 
        }
 
        internal AggregateNode(DataTable table, FunctionId aggregateType, string columnName, string relationName) : 
            this(table, aggregateType, columnName, false, relationName) {
        } 

        internal AggregateNode(DataTable table, FunctionId aggregateType, string columnName, bool local, string relationName) : base(table) {
            Debug.Assert(columnName != null, "Invalid parameter column name (null).");
            this.aggregate = (Aggregate)(int)aggregateType; 

            if (aggregateType == FunctionId.Sum) 
                this.type = AggregateType.Sum; 
            else if (aggregateType == FunctionId.Avg)
                this.type = AggregateType.Mean; 
            else if (aggregateType == FunctionId.Min)
                this.type = AggregateType.Min;
            else if (aggregateType == FunctionId.Max)
                this.type = AggregateType.Max; 
            else if (aggregateType == FunctionId.Count)
                this.type = AggregateType.Count; 
            else if (aggregateType == FunctionId.Var) 
                this.type = AggregateType.Var;
            else if (aggregateType == FunctionId.StDev) 
                this.type = AggregateType.StDev;
            else {
                throw ExprException.UndefinedFunction(Function.FunctionName[(Int32)aggregateType]);
            } 

            this.local = local; 
            this.relationName = relationName; 
            this.columnName = columnName;
        } 
        internal override void Bind(DataTable table, List list) {
            BindTable(table);
            if (table == null)
                throw ExprException.AggregateUnbound(this.ToString()); 

            if (local) { 
                relation = null; 
            }
            else { 
                DataRelationCollection relations;
                relations = table.ChildRelations;

                if (relationName == null) { 
                    // must have one and only one relation
 
                    if (relations.Count > 1) { 
                        throw ExprException.UnresolvedRelation(table.TableName, this.ToString());
                    } 
                    if (relations.Count == 1) {
                        relation = relations[0];
                    }
                    else { 
                        throw ExprException.AggregateUnbound(this.ToString());
                    } 
                } 
                else {
                    relation = relations[relationName]; 
                }
            }

            childTable = (relation == null) ? table : relation.ChildTable; 

            this.column = childTable.Columns[columnName]; 
 
            if (column == null)
                throw ExprException.UnboundName(columnName); 

            // add column to the dependency list, do not add duplicate columns

            Debug.Assert(column != null, "Failed to bind column " + columnName); 

            int i; 
            for (i = 0; i < list.Count; i++) { 
                // walk the list, check if the current column already on the list
                DataColumn dataColumn = (DataColumn)list[i]; 
                if (column == dataColumn) {
                    break;
                }
            } 
            if (i >= list.Count) {
                list.Add(column); 
            } 

            // SQLBU 383715: Staleness of computed values in expression column as the relationship end columns are not being added to the dependent column list. 
            AggregateNode.Bind(relation, list);
        }

        internal static void Bind(DataRelation relation, List list) 
        {
            if (null != relation) { 
                // add the ends of the relationship the expression depends on 
                foreach (DataColumn c in relation.ChildColumnsReference) {
                    if (!list.Contains(c)) { 
                        list.Add(c);
                    }
                }
                foreach (DataColumn c in relation.ParentColumnsReference) { 
                    if (!list.Contains(c)) {
                        list.Add(c); 
                    } 
                }
            } 
        }

        internal override object Eval() {
            return Eval(null, DataRowVersion.Default); 
        }
 
        internal override object Eval(DataRow row, DataRowVersion version) { 
            if (childTable == null)
                throw ExprException.AggregateUnbound(this.ToString()); 

            DataRow[] rows;

            if (local) { 
                rows = new DataRow[childTable.Rows.Count];
                childTable.Rows.CopyTo(rows, 0); 
            } 
            else {
                if (row == null) { 
                    throw ExprException.EvalNoContext();
                }
                if (relation == null) {
                    throw ExprException.AggregateUnbound(this.ToString()); 
                }
                rows = row.GetChildRows(relation, version); 
            } 

            int[] records; 
            if (version == DataRowVersion.Proposed) {
                version = DataRowVersion.Default;
            }
 
            List recordList = new List();
 
            for (int i = 0; i < rows.Length; i++) { 
                if (rows[i].RowState == DataRowState.Deleted) {
                    if (DataRowAction.Rollback != rows[i]._action) { 
                        continue;
                    }
                    Debug.Assert(DataRowVersion.Original == version, "wrong version");
                    version = DataRowVersion.Original; 
                }
                else if ((DataRowAction.Rollback == rows[i]._action) && (rows[i].RowState == DataRowState.Added)) { 
                    continue; // WebData 91297 
                }
                if (version == DataRowVersion.Original && rows[i].oldRecord == -1) { 
                    continue;
                }
                recordList.Add(rows[i].GetRecordFromVersion(version));
            } 
            records = recordList.ToArray();
 
            return column.GetAggregateValue(records, type); 
        }
 
        // Helper for the DataTable.Compute method
        internal override object Eval(int[] records) {
            if (childTable == null)
                throw ExprException.AggregateUnbound(this.ToString()); 
            if (!local) {
                throw ExprException.ComputeNotAggregate(this.ToString()); 
            } 
            return column.GetAggregateValue(records, type);
        } 

        internal override bool IsConstant() {
            return false;
        } 

        internal override bool IsTableConstant() { 
            return local; 
        }
 
        internal override bool HasLocalAggregate() {
            return local;
        }
 
        internal override bool HasRemoteAggregate() {
            return !local; 
        } 

        internal override bool DependsOn(DataColumn column) { 
            if (this.column == column) {
                return true;
            }
            if (this.column.Computed) { 
                return this.column.DataExpression.DependsOn(column);
            } 
            return false; 
        }
 
        internal override ExpressionNode Optimize() {
            return this;
        }
    } 
}

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
//------------------------------------------------------------------------------ 
// 
//     Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// [....] 
// [....]
//----------------------------------------------------------------------------- 
 
namespace System.Data {
    using System; 
    using System.Diagnostics;
    using System.Collections.Generic;
    using System.ComponentModel;
 
    internal enum Aggregate {
        None = FunctionId.none, 
        Sum = FunctionId.Sum, 
        Avg = FunctionId.Avg,
        Min = FunctionId.Min, 
        Max = FunctionId.Max,
        Count = FunctionId.Count,
        StDev = FunctionId.StDev,   // Statistical standard deviation
        Var = FunctionId.Var,       // Statistical variance 
    }
 
    internal sealed class AggregateNode : ExpressionNode { 
        private readonly AggregateType type;
        private readonly Aggregate aggregate; 
        private readonly bool local;     // set to true if the aggregate calculated localy (for the current table)

        private readonly string relationName;
        private readonly string columnName; 

        // 
 
        private DataTable childTable;
        private DataColumn column; 
        private DataRelation relation;

        internal AggregateNode(DataTable table, FunctionId aggregateType, string columnName) :
            this(table, aggregateType, columnName, true, null) { 
        }
 
        internal AggregateNode(DataTable table, FunctionId aggregateType, string columnName, string relationName) : 
            this(table, aggregateType, columnName, false, relationName) {
        } 

        internal AggregateNode(DataTable table, FunctionId aggregateType, string columnName, bool local, string relationName) : base(table) {
            Debug.Assert(columnName != null, "Invalid parameter column name (null).");
            this.aggregate = (Aggregate)(int)aggregateType; 

            if (aggregateType == FunctionId.Sum) 
                this.type = AggregateType.Sum; 
            else if (aggregateType == FunctionId.Avg)
                this.type = AggregateType.Mean; 
            else if (aggregateType == FunctionId.Min)
                this.type = AggregateType.Min;
            else if (aggregateType == FunctionId.Max)
                this.type = AggregateType.Max; 
            else if (aggregateType == FunctionId.Count)
                this.type = AggregateType.Count; 
            else if (aggregateType == FunctionId.Var) 
                this.type = AggregateType.Var;
            else if (aggregateType == FunctionId.StDev) 
                this.type = AggregateType.StDev;
            else {
                throw ExprException.UndefinedFunction(Function.FunctionName[(Int32)aggregateType]);
            } 

            this.local = local; 
            this.relationName = relationName; 
            this.columnName = columnName;
        } 
        internal override void Bind(DataTable table, List list) {
            BindTable(table);
            if (table == null)
                throw ExprException.AggregateUnbound(this.ToString()); 

            if (local) { 
                relation = null; 
            }
            else { 
                DataRelationCollection relations;
                relations = table.ChildRelations;

                if (relationName == null) { 
                    // must have one and only one relation
 
                    if (relations.Count > 1) { 
                        throw ExprException.UnresolvedRelation(table.TableName, this.ToString());
                    } 
                    if (relations.Count == 1) {
                        relation = relations[0];
                    }
                    else { 
                        throw ExprException.AggregateUnbound(this.ToString());
                    } 
                } 
                else {
                    relation = relations[relationName]; 
                }
            }

            childTable = (relation == null) ? table : relation.ChildTable; 

            this.column = childTable.Columns[columnName]; 
 
            if (column == null)
                throw ExprException.UnboundName(columnName); 

            // add column to the dependency list, do not add duplicate columns

            Debug.Assert(column != null, "Failed to bind column " + columnName); 

            int i; 
            for (i = 0; i < list.Count; i++) { 
                // walk the list, check if the current column already on the list
                DataColumn dataColumn = (DataColumn)list[i]; 
                if (column == dataColumn) {
                    break;
                }
            } 
            if (i >= list.Count) {
                list.Add(column); 
            } 

            // SQLBU 383715: Staleness of computed values in expression column as the relationship end columns are not being added to the dependent column list. 
            AggregateNode.Bind(relation, list);
        }

        internal static void Bind(DataRelation relation, List list) 
        {
            if (null != relation) { 
                // add the ends of the relationship the expression depends on 
                foreach (DataColumn c in relation.ChildColumnsReference) {
                    if (!list.Contains(c)) { 
                        list.Add(c);
                    }
                }
                foreach (DataColumn c in relation.ParentColumnsReference) { 
                    if (!list.Contains(c)) {
                        list.Add(c); 
                    } 
                }
            } 
        }

        internal override object Eval() {
            return Eval(null, DataRowVersion.Default); 
        }
 
        internal override object Eval(DataRow row, DataRowVersion version) { 
            if (childTable == null)
                throw ExprException.AggregateUnbound(this.ToString()); 

            DataRow[] rows;

            if (local) { 
                rows = new DataRow[childTable.Rows.Count];
                childTable.Rows.CopyTo(rows, 0); 
            } 
            else {
                if (row == null) { 
                    throw ExprException.EvalNoContext();
                }
                if (relation == null) {
                    throw ExprException.AggregateUnbound(this.ToString()); 
                }
                rows = row.GetChildRows(relation, version); 
            } 

            int[] records; 
            if (version == DataRowVersion.Proposed) {
                version = DataRowVersion.Default;
            }
 
            List recordList = new List();
 
            for (int i = 0; i < rows.Length; i++) { 
                if (rows[i].RowState == DataRowState.Deleted) {
                    if (DataRowAction.Rollback != rows[i]._action) { 
                        continue;
                    }
                    Debug.Assert(DataRowVersion.Original == version, "wrong version");
                    version = DataRowVersion.Original; 
                }
                else if ((DataRowAction.Rollback == rows[i]._action) && (rows[i].RowState == DataRowState.Added)) { 
                    continue; // WebData 91297 
                }
                if (version == DataRowVersion.Original && rows[i].oldRecord == -1) { 
                    continue;
                }
                recordList.Add(rows[i].GetRecordFromVersion(version));
            } 
            records = recordList.ToArray();
 
            return column.GetAggregateValue(records, type); 
        }
 
        // Helper for the DataTable.Compute method
        internal override object Eval(int[] records) {
            if (childTable == null)
                throw ExprException.AggregateUnbound(this.ToString()); 
            if (!local) {
                throw ExprException.ComputeNotAggregate(this.ToString()); 
            } 
            return column.GetAggregateValue(records, type);
        } 

        internal override bool IsConstant() {
            return false;
        } 

        internal override bool IsTableConstant() { 
            return local; 
        }
 
        internal override bool HasLocalAggregate() {
            return local;
        }
 
        internal override bool HasRemoteAggregate() {
            return !local; 
        } 

        internal override bool DependsOn(DataColumn column) { 
            if (this.column == column) {
                return true;
            }
            if (this.column.Computed) { 
                return this.column.DataExpression.DependsOn(column);
            } 
            return false; 
        }
 
        internal override ExpressionNode Optimize() {
            return this;
        }
    } 
}

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
                        

                        

                        
                        

Link Menu

This book is available now!
Buy at Amazon US or
Buy at Amazon UK

• HtmlFormWrapper.cs
• TreeViewImageIndexConverter.cs
• ScriptResourceHandler.cs
• CustomCredentialPolicy.cs
• PresentationSource.cs
• EnumValAlphaComparer.cs
• ContentType.cs
• odbcmetadatacolumnnames.cs
• ProfileServiceManager.cs
• UndoEngine.cs
• ByeOperation11AsyncResult.cs
• TransferRequestHandler.cs
• MobileFormsAuthentication.cs
• BamlReader.cs
• EmbeddedMailObject.cs
• UpnEndpointIdentity.cs
• tibetanshape.cs
• ValueQuery.cs
• WebServiceEnumData.cs
• DataGridAutoFormatDialog.cs
• CreateUserWizardStep.cs
• XmlDownloadManager.cs
• ServicePrincipalNameElement.cs
• ErrorInfoXmlDocument.cs
• FormViewDeletedEventArgs.cs
• MsmqBindingMonitor.cs
• Socket.cs
• PassportAuthenticationEventArgs.cs
• ImageEditor.cs
• ServiceModelEnhancedConfigurationElementCollection.cs
• SqlSupersetValidator.cs
• XmlDictionaryReaderQuotasElement.cs
• MethodImplAttribute.cs
• CodeTypeDeclaration.cs
• Vector3DCollectionValueSerializer.cs
• FtpWebRequest.cs
• ContentElement.cs
• AuthorizationRuleCollection.cs
• CompositeFontParser.cs
• IFlowDocumentViewer.cs
• KeyEventArgs.cs
• ObjectToIdCache.cs
• XappLauncher.cs
• TextContainerChangedEventArgs.cs
• xmlfixedPageInfo.cs
• ListViewGroup.cs
• MailWebEventProvider.cs
• ExtenderProvidedPropertyAttribute.cs
• KeyPullup.cs
• TextServicesContext.cs
• ColorPalette.cs
• ChannelServices.cs
• ButtonChrome.cs
• AvtEvent.cs
• ConfigurationSectionGroup.cs
• Container.cs
• TextControl.cs
• ProjectedSlot.cs
• DataErrorValidationRule.cs
• PlacementWorkspace.cs
• BindingSource.cs
• BinaryFormatter.cs
• DocumentApplicationJournalEntry.cs
• Win32PrintDialog.cs
• CharConverter.cs
• SpellerInterop.cs
• EnumerableCollectionView.cs
• Base64Decoder.cs
• TraceProvider.cs
• OledbConnectionStringbuilder.cs
• AppDomainShutdownMonitor.cs
• NetworkAddressChange.cs
• PrimitiveType.cs
• DesignTimeValidationFeature.cs
• QilParameter.cs
• ObjectFactoryCodeDomTreeGenerator.cs
• TypeConverterHelper.cs
• LinqDataSourceValidationException.cs
• StandardToolWindows.cs
• DataGridTextBox.cs
• AccessorTable.cs
• ScriptControlManager.cs
• AuthenticationService.cs
• LogSwitch.cs
• TraceSource.cs
• Buffer.cs
• EntityContainerAssociationSetEnd.cs
• DrawingAttributes.cs
• MenuItem.cs
• XmlSignificantWhitespace.cs
• CustomValidator.cs
• WebPermission.cs
• glyphs.cs
• DetailsViewPageEventArgs.cs
• Vector3DCollection.cs
• SqlUserDefinedAggregateAttribute.cs
• ListViewSelectEventArgs.cs
• ToolBar.cs
• RangeBase.cs
• DataBindingCollection.cs