Example #1
0
        //ctor
        public MatrixGroupView(MatrixGroupControl i_Control) : base(i_Control as ExControl)
        {
            this._RootGroupInfo = new Webb.Reports.ExControls.Data.FieldGroupInfo(Webb.Data.PublicDBFieldConverter.AvialableFields[0].ToString());
            this._RootGroupInfo.ColumnHeading = "New Group";
            this._Fitler = new Webb.Data.DBFilter();
            this._Styles = new ExControlStyles();
            this._Styles.LoadDefaultStyle();                //08-14-2008@Scott
            this._ShowRowIndicators    = false;
            this._CellSizeAutoAdapting = CellSizeAutoAdaptingTypes.OneLine;

            this._HaveHeader = true;

            this._HeightPerPage = 0;
            this._SectionRoot   = false;
        }
        //fuction
        public override void CalculateResult(DataTable i_Table)
        {
            ChangeTypesFor3D();

            if (i_Table != null)
            {
                Webb.Collections.Int32Collection rows = new Int32Collection();

                Webb.Data.DBFilter dbFilter = this.Filter.Copy();

                if (this.ExControl != null && this.ExControl.Report != null)
                {
                    rows = this.ExControl.Report.Filter.GetFilteredRows(i_Table);                    //2009-5-25 11:02:57@Simon Add this Code

                    dbFilter.Add(this.ExControl.Report.Filter);
                }

                if (this.DenominatorFilter == null)
                {
                    if (this.Repeat)
                    {
                        this.DenominatorFilter = dbFilter;
                    }
                    else if (this.ExControl != null && this.ExControl.Report != null && this.ExControl.Report.OneValuePerPage)
                    {
                        this.DenominatorFilter = dbFilter;
                    }
                    else
                    {
                        this.DenominatorFilter = new Webb.Data.DBFilter();
                    }
                }

                rows = this.OneValueScFilter.Filter.GetFilteredRows(i_Table, rows);

                rows = this.RepeatFilter.Filter.GetFilteredRows(i_Table, rows);                                                 //Added this code at 2008-12-26 12:22:40@Simon

                this.Filter = AdvFilterConvertor.GetAdvFilter(DataProvider.VideoPlayBackManager.AdvReportFilters, this.Filter); //2009-4-29 11:37:37@Simon Add UpdateAdvFilter

                rows = this.Filter.GetFilteredRows(i_Table, rows);

                this._Chart = this.Settings.CreateChart(i_Table, rows);
            }
            else
            {
                this._Chart = this.Settings.CreateChart(null, null);
            }
        }
 //ctor
 public SimpleGroupView(SimpleGroupingControl i_Control) : base(i_Control as ExControl)
 {
     this._RootGroupInfo = new Webb.Reports.ExControls.Data.FieldGroupInfo(Webb.Data.PublicDBFieldConverter.AvialableFields[0].ToString());
     this._RootGroupInfo.ColumnHeading = "New Group";
     this._Fitler = new Webb.Data.DBFilter();
     this._Styles = new ExControlStyles();
     this._Styles.LoadDefaultStyle();    //08-14-2008@Scott
     this._ShowRowIndicators    = false;
     this._CellSizeAutoAdapting = CellSizeAutoAdaptingTypes.WordWrap;
     this._OneValuePerPage      = false;
     this._HaveHeader           = true;
     this._SizeSelfAdapting     = false;
     this._TopCount             = 0;
     this._Total           = false;
     this._TotalTitle      = "Total";
     this._SectionTitle    = string.Empty;
     this._SectionInOneRow = true;
     this._TotalColumns    = new Int32Collection();
     this._HeightPerPage   = 0;
 }
Example #4
0
        /// <summary>
        /// Calculate grouped result
        /// </summary>
        /// <param name="i_Table">data source</param>
        public override void CalculateResult(DataTable i_Table)
        {
            //If have no data source ,clear group struct
            if (i_Table == null)
            {
                this.RootGroupInfo.ClearGroupResult(this._RootGroupInfo);

                return;
            }

            //Filter rows
            Webb.Collections.Int32Collection m_Rows = new Int32Collection();

            if (this.ExControl != null && this.ExControl.Report != null)
            {
                m_Rows = this.ExControl.Report.Filter.GetFilteredRows(i_Table);  //2009-5-25 11:02:57@Simon Add this Code
            }

            m_Rows = this.OneValueScFilter.Filter.GetFilteredRows(i_Table, m_Rows);                                         //06-04-2008@Scott

            m_Rows = this.RepeatFilter.Filter.GetFilteredRows(i_Table, m_Rows);                                             //Added this code at 2008-12-26 12:22:40@Simon

            this.Filter = AdvFilterConvertor.GetAdvFilter(DataProvider.VideoPlayBackManager.AdvReportFilters, this.Filter); //2009-4-29 11:37:37@Simon Add UpdateAdvFilter

            m_Rows = this.Filter.GetFilteredRows(i_Table, m_Rows);                                                          //06-04-2008@Scott

            DataTable table = this.GradingSectionCollection.CalcualteGradeTable(i_Table, m_Rows);

            Webb.Data.DBFilter filter = new Webb.Data.DBFilter();

            Int32Collection rows = filter.GetFilteredRows(table);

            this._RootGroupInfo.CalculateGroupResult(table, rows, rows, this._RootGroupInfo);

            GradingSectionCollection.TruncateRowIdIntoPlayId(table, this._RootGroupInfo);
        }
Example #5
0
        public GradingView(SerializationInfo info, StreamingContext context) : base(info, context)
        {
            try
            {
                _GradingSectionCollection = (Webb.Reports.ExControls.Data.GradingSectionCollection)info.GetValue("_GradingSectionCollection", typeof(Webb.Reports.ExControls.Data.GradingSectionCollection));
            }
            catch
            {
                _GradingSectionCollection = new GradingSectionCollection();
            }
            try
            {
                _RootGroupInfo = (Webb.Reports.ExControls.Data.GroupInfo)info.GetValue("_RootGroupInfo", typeof(Webb.Reports.ExControls.Data.GroupInfo));
            }
            catch
            {
                _RootGroupInfo = new FieldGradingInfo();
            }
            try
            {
                _CellSizeAutoAdapting = (Webb.Reports.ExControls.Views.CellSizeAutoAdaptingTypes)info.GetValue("_CellSizeAutoAdapting", typeof(Webb.Reports.ExControls.Views.CellSizeAutoAdaptingTypes));
            }
            catch
            {
                _CellSizeAutoAdapting = CellSizeAutoAdaptingTypes.NotUse;
            }
            try
            {
                _Filter = (Webb.Data.DBFilter)info.GetValue("_Filter", typeof(Webb.Data.DBFilter));
            }
            catch
            {
                _Filter = new Webb.Data.DBFilter();
            }
            try
            {
                _TopCount = info.GetInt32("_TopCount");
            }
            catch
            {
                _TopCount = 0;
            }
            try
            {
                _ShowRowIndicators = info.GetBoolean("_ShowRowIndicators");
            }
            catch
            {
                _ShowRowIndicators = false;
            }
            try
            {
                _HaveHeader = info.GetBoolean("_HaveHeader");
            }
            catch
            {
                _HaveHeader = true;
            }
            try
            {
                _SectionInOneRow = info.GetBoolean("_SectionInOneRow");
            }
            catch
            {
                _SectionInOneRow = true;
            }
            try
            {
                _HeaderRows = (Webb.Collections.Int32Collection)info.GetValue("_HeaderRows", typeof(Webb.Collections.Int32Collection));
            }
            catch
            {
                _HeaderRows = new Int32Collection();
            }
            try
            {
                _SectionRows = (Webb.Collections.Int32Collection)info.GetValue("_SectionRows", typeof(Webb.Collections.Int32Collection));
            }
            catch
            {
                _SectionRows = new Int32Collection();
            }
            try
            {
                _TotalRows = (Webb.Collections.Int32Collection)info.GetValue("_TotalRows", typeof(Webb.Collections.Int32Collection));
            }
            catch
            {
                _TotalRows = new Int32Collection();
            }

            try
            {
                _ColumnsWidth = (Webb.Collections.Int32Collection)info.GetValue("_ColumnsWidth", typeof(Webb.Collections.Int32Collection));
            }
            catch
            {
                _ColumnsWidth = new Int32Collection();
            }
            try
            {
                _RowsHight = (Webb.Collections.Int32Collection)info.GetValue("_RowsHight", typeof(Webb.Collections.Int32Collection));
            }
            catch
            {
                _RowsHight = new Int32Collection();
            }
            try
            {
                _Styles = (Webb.Reports.ExControls.Styles.ExControlStyles)info.GetValue("_Styles", typeof(Webb.Reports.ExControls.Styles.ExControlStyles));
            }
            catch
            {
                _Styles = new ExControlStyles();
            }
            try
            {
                _HeadersData = (HeadersData)info.GetValue("_HeadersData", typeof(Webb.Reports.ExControls.Data.HeadersData));
            }
            catch
            {
                _HeadersData = null;
            }
            try
            {
                _OurBordersSetting = (Webb.Reports.ExControls.Views.OurBordersSetting)info.GetValue("_OurBordersSetting", typeof(Webb.Reports.ExControls.Views.OurBordersSetting));
            }
            catch
            {
                _OurBordersSetting = new OurBordersSetting();
            }
        }