3rdpartylibs/fastreports.wpf/FastReport/Forms/DataViewForm.cs

using System;
using System.Data;
using System.Windows.Forms;
using System.Collections;
using FastReport.Data;
using FastReport.Utils;


namespace FastReport.Forms
{
    internal partial class DataViewForm : BaseForm
    {
        #region Fields

        private DataSourceBase data;
        private int currentFirstRow;
        private int rowsOnPage;
        private int rowsCount;

        #endregion Fields

        #region Properties

        private int CurrentFirstRow
        {
            get { return currentFirstRow; }
            set
            {
                if (value >= 0 && value < RowsCount)
                {
                    currentFirstRow = value;
                }
            }
        }

        private int RowsOnPage
        {
            get { return rowsOnPage; }
        }

        private int RowsCount
        {
            get { return rowsCount; }
        }

        #endregion Properties

        #region Private Methods

        private void Init()
        {
            Text = data.Alias;
            Icon = Res.GetIcon(222, this.Dpi());
        }

        private void CalcRowsOnPage()
        {
            rowsOnPage = (int)(ClientRectangle.Height - stStatus.Height - grid.RowTemplate.Height * 1.5f) / grid.RowTemplate.Height;
            if (RowsOnPage >= RowsCount)
            {
                CurrentFirstRow = 0;
            }
        }

        private string GetStatusString()
        {
            if (RowsOnPage > 0)
            {
                if (RowsOnPage == 1)
                {
                    return String.Format(Res.Get("Designer,ToolWindow,Dictionary,RowMofNRows"), CurrentFirstRow + 1, RowsCount);
                }
                else if (CurrentFirstRow == RowsCount - 1)
                {
                    return String.Format(Res.Get("Designer,ToolWindow,Dictionary,RowMofNRows"), CurrentFirstRow + 1, RowsCount);
                }
                else
                {
                    int lastRowOnPage = CurrentFirstRow + RowsOnPage;
                    if (lastRowOnPage > RowsCount)
                    {
                        lastRowOnPage = RowsCount;
                    }
                    return String.Format(Res.Get("Designer,ToolWindow,Dictionary,RowsKtoLofNRows"), CurrentFirstRow + 1, lastRowOnPage, RowsCount);
                }
            }
            return String.Format(Res.Get("Designer,ToolWindow,Dictionary,NRows"), RowsCount);
        }

        private void FillGridWithNRows()
        {
            if (data is TableDataSource)
            {
                DataTable fullTable = (data as TableDataSource).Table;
                DataTable table = new DataTable(fullTable.TableName);
                table = fullTable.Clone();
                for (int i = 0, j = CurrentFirstRow; i < RowsOnPage && j < RowsCount; i++, j++)
                {
                    table.ImportRow(fullTable.Rows[j]);
                }

                // this limitation in 655 columns is needed to avoid error with FillWeight sum more than 65535
                if (table.Columns.Count <= 655)
                {
                    grid.DataSource = table;
                }
                else
                {
                    grid.Columns.Clear();
                    grid.Rows.Clear();
                    int i = 0;
                    while (i < Math.Min(655,table.Columns.Count))
                    {
                        if (data.Columns[i].Enabled)
                        {
                            DataColumn col = table.Columns[i];
                            DataGridViewTextBoxColumn dc = new DataGridViewTextBoxColumn();
                            dc.Frozen = false;
                            dc.HeaderText = col.ColumnName;
                            grid.Columns.Add(dc);
                        }
                        i++;
                    }
                    foreach (DataRow row in table.Rows)
                    {
                        grid.Rows.Add(row);
                    }
                }
            }
            else
            {
                bool setDataSourse = false;
                IList list = new ArrayList();
                for (int i = 0, j = CurrentFirstRow; i < RowsOnPage && j < RowsCount; i++, j++)
                {

                    if (data.Rows[j] is IList)
                    {

                        list = (data.Rows[j] as IList);

                        if (j == CurrentFirstRow)
                        {
                            for (int k = 0; k < list.Count; k++)
                            {
                                grid.Columns.Add("Column " + (k + 1).ToString(), "Column " + (k + 1).ToString());
                            }
                        }

                        grid.Rows.Add();
                        for (int k = 0; k < list.Count; k++)
                        {
                            grid.Rows[j].Cells[k].Value = list[k];
                        }
                    }
                    else
                    {
                        if (data.Rows[j] is ValueType)
                        {
                            if (j == CurrentFirstRow)
                                grid.Columns.Add("Column 1", "Column 1");
                            grid.Rows.Add(data.Rows[j]);
                        }
                        else
                        {
                            list.Add(data.Rows[j]);
                            setDataSourse = true;
                        }

                    }
                }
                if (setDataSourse)
                    grid.DataSource = list;
            }
        }

        private void UpdateButtons()
        {
            if (RowsCount <= RowsOnPage || RowsOnPage <= 0)
            {
                btnFirst.Enabled = false;
                btnPrior.Enabled = false;
                btnNext.Enabled = false;
                btnLast.Enabled = false;
            }
            else
            {
                if (CurrentFirstRow < RowsOnPage)
                {
                    btnFirst.Enabled = false;
                    btnPrior.Enabled = false;
                    btnNext.Enabled = true;
                    btnLast.Enabled = true;
                }
                else if (RowsOnPage > (RowsCount - CurrentFirstRow) || CurrentFirstRow == RowsCount - 1 || (CurrentFirstRow + RowsOnPage) == RowsCount)
                {
                    btnFirst.Enabled = true;
                    btnPrior.Enabled = true;
                    btnNext.Enabled = false;
                    btnLast.Enabled = false;
                }
                else
                {
                    btnFirst.Enabled = true;
                    btnPrior.Enabled = true;
                    btnNext.Enabled = true;
                    btnLast.Enabled = true;
                }
            }
            lblRows.Text = GetStatusString();
        }

        #endregion Private Methods

        #region Event Handlers

        private void btnFirst_Click(object sender, EventArgs e)
        {
            CurrentFirstRow = 0;
            FillGridWithNRows();
            UpdateButtons();
        }

        private void btnPrior_Click(object sender, EventArgs e)
        {
            CurrentFirstRow -= RowsOnPage;
            FillGridWithNRows();
            UpdateButtons();
        }

        private void btnNext_Click(object sender, EventArgs e)
        {
            CurrentFirstRow += RowsOnPage;
            FillGridWithNRows();
            UpdateButtons();
        }

        private void btnLast_Click(object sender, EventArgs e)
        {
            if (RowsOnPage == 1)
            {
                CurrentFirstRow = RowsCount - 1;
            }
            else
            {
                CurrentFirstRow = RowsCount % RowsOnPage == 0 ? RowsCount - RowsOnPage : RowsCount - RowsCount % RowsOnPage;
            }
            FillGridWithNRows();
            UpdateButtons();
        }

        private void DataViewForm_SizeChanged(object sender, EventArgs e)
        {
            CalcRowsOnPage();
            FillGridWithNRows();
            UpdateButtons();
        }

        private void DataViewForm_Shown(object sender, EventArgs e)
        {
            int i = 0;
            while (i < grid.Columns.Count)
            {
                Column c = data.Columns.FindByName(grid.Columns[i].HeaderText);
                if (c != null)
                {
                    if (c.Enabled)
                        grid.Columns[i].HeaderText = c.Alias;
                    else
                    {
                        grid.Columns.RemoveAt(i);
                        i--;
                    }
                }
                i++;
            }
        }

        private void grid_DataError(object sender, DataGridViewDataErrorEventArgs e)
        {
            e.Cancel = true;
        }

        #endregion Event Handlers

        public override void UpdateDpiDependencies()
        {
            base.UpdateDpiDependencies();
            grid.RowTemplate.Height = this.LogicalToDevice(19);
            stStatus.AutoSize = false;
            stStatus.Font = Font;
            stStatus.Height = this.LogicalToDevice(26);
            btnFirst.Image = GetImage(185);
            btnPrior.Image = GetImage(186);
            btnNext.Image = GetImage(187);
            btnLast.Image = GetImage(188);
        }

        public DataViewForm(DataSourceBase data)
        {
            this.data = data;
            CanSaveRestoreState = true;

            InitializeComponent();
            Localize();
            Init();
            UIUtils.CheckRTL(this);
            UpdateDpiDependencies();

            currentFirstRow = 0;
            if (data is TableDataSource)
            {
                rowsCount = (data as TableDataSource).Table.Rows.Count;
            }
            else
            {
                rowsCount = data.Rows.Count;
            }

            // calc number of rows on page
            CalcRowsOnPage();

            // fill grid with RowsOnPage rows starting from CurrentFirstRow
            FillGridWithNRows();
            UpdateButtons();

            this.SizeChanged += new System.EventHandler(this.DataViewForm_SizeChanged);
        }

    }
}