123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568 |
- using System;
- using System.Collections;
- using FastReport.Data;
- namespace FastReport.CrossView
- {
- /// <summary>
- /// Contains a set of properties and methods to hold and manipulate the CrossView descriptors.
- /// </summary>
- /// <remarks>
- /// This class contains three collections of descriptors such as <see cref="Columns"/>,
- /// <see cref="Rows"/> and <see cref="Cells"/>. Descriptors are filled from FastCube Slice.
- /// </remarks>
- public class CrossViewData
- {
- #region Fields
- private CrossViewHeader columns;
- private CrossViewHeader rows;
- private CrossViewCells cells;
- internal int[] columnDescriptorsIndexes;
- internal int[] rowDescriptorsIndexes;
- internal int[] columnTerminalIndexes;
- internal int[] rowTerminalIndexes;
- #endregion
- #region FastCube properties (temporary)
- private CubeSourceBase cubeSource;
- /// <summary>
- ///
- /// </summary>
- public int XAxisFieldsCount { get { return cubeSource != null ? cubeSource.XAxisFieldsCount : 0; } }
- /// <summary>
- ///
- /// </summary>
- public int YAxisFieldsCount { get { return cubeSource != null ? cubeSource.YAxisFieldsCount : 0; } }
- /// <summary>
- ///
- /// </summary>
- public int MeasuresCount { get { return cubeSource != null ? cubeSource.MeasuresCount : 0; } }
- /// <summary>
- ///
- /// </summary>
- public int MeasuresLevel { get { return cubeSource != null ? cubeSource.MeasuresLevel : 0; } }
- /// <summary>
- ///
- /// </summary>
- public bool MeasuresInXAxis { get { return cubeSource != null ? cubeSource.MeasuresInXAxis : false; } }
- /// <summary>
- ///
- /// </summary>
- public bool MeasuresInYAxis { get { return cubeSource != null ? cubeSource.MeasuresInYAxis : false; } }
- /// <summary>
- ///
- /// </summary>
- public int DataColumnCount { get { return cubeSource != null ? cubeSource.DataColumnCount : 0; } }
- /// <summary>
- ///
- /// </summary>
- public int DataRowCount { get { return cubeSource != null ? cubeSource.DataRowCount : 0; } }
- /// <summary>
- ///
- /// </summary>
- public bool SourceAssigned { get { return cubeSource != null; } }
- #if !DOTNET_4
- private string intArrayToString(int[] intArray)
- {
- string res = "";
- foreach (int item in intArray)
- {
- if (res != "")
- res += ",";
- res += item.ToString();
- }
- return res;
- }
- private int[] stringToIntArray(string str)
- {
- string[] strArray = str.Split(',');
- int[] res = new int[strArray.Length];
- for (int i = 0; i < strArray.Length; i++)
- {
- res[i] = int.Parse(strArray[i]);
- }
- return res;
- }
- #endif
- /// <summary>
- ///
- /// </summary>
- public string ColumnDescriptorsIndexes
- {
- #if DOTNET_4
- get { return string.Join(",", columnDescriptorsIndexes); }
- set { columnDescriptorsIndexes = Array.ConvertAll(value.Split(','), int.Parse); }
- #else
- get { return intArrayToString(columnDescriptorsIndexes); }
- set { columnDescriptorsIndexes = stringToIntArray(value); }
- #endif
- }
- /// <summary>
- ///
- /// </summary>
- public string RowDescriptorsIndexes
- {
- #if DOTNET_4
- get { return string.Join(",", rowDescriptorsIndexes); }
- set { rowDescriptorsIndexes = Array.ConvertAll(value.Split(','), int.Parse); }
- #else
- get { return intArrayToString(rowDescriptorsIndexes); }
- set { rowDescriptorsIndexes = stringToIntArray(value); }
- #endif
- }
- /// <summary>
- ///
- /// </summary>
- public string ColumnTerminalIndexes
- {
- #if DOTNET_4
- get { return string.Join(",", columnTerminalIndexes); }
- set { columnTerminalIndexes = Array.ConvertAll(value.Split(','), int.Parse); }
- #else
- get { return intArrayToString(columnTerminalIndexes); }
- set { columnTerminalIndexes = stringToIntArray(value); }
- #endif
- }
- /// <summary>
- ///
- /// </summary>
- public string RowTerminalIndexes
- {
- #if DOTNET_4
- get { return string.Join(",", rowTerminalIndexes); }
- set { rowTerminalIndexes = Array.ConvertAll(value.Split(','), int.Parse); }
- #else
- get { return intArrayToString(rowTerminalIndexes); }
- set { rowTerminalIndexes = stringToIntArray(value); }
- #endif
- }
- internal CubeSourceBase CubeSource
- {
- get { return cubeSource; }
- set
- {
- if (cubeSource != value)
- {
- cubeSource = value;
- }
- }
- }
- internal void CreateDescriptors()
- {
- columnDescriptorsIndexes = new int[0];
- rowDescriptorsIndexes = new int[0];
- columnTerminalIndexes = new int[0];
- rowTerminalIndexes = new int[0];
- CrossViewHeaderDescriptor crossViewHeaderDescriptor;
- Columns.Clear();
- Rows.Clear();
- Cells.Clear();
- if (!SourceAssigned)
- return;
- int cell = 0;
- for (int i = 0; i < XAxisFieldsCount; i++)
- {
- cell = 0;
- if (MeasuresInXAxis && (MeasuresLevel <= i))
- {
- if (MeasuresLevel == i)
- {
- for (int k = 0; k <= i; k++)
- {
- for (int j = 0; j < MeasuresCount; j++)
- {
- if (k == i)
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor("", CubeSource.GetMeasureName(j), false, false, true);
- crossViewHeaderDescriptor.cellsize = 1;
- crossViewHeaderDescriptor.levelsize = XAxisFieldsCount - i;
- }
- else
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor(CubeSource.GetXAxisFieldName(k), CubeSource.GetMeasureName(j), false, false, true);
- crossViewHeaderDescriptor.cellsize = (XAxisFieldsCount - i);
- crossViewHeaderDescriptor.levelsize = 1;
- }
- crossViewHeaderDescriptor.level = i;
- crossViewHeaderDescriptor.cell = cell;
- cell += crossViewHeaderDescriptor.cellsize;
- Columns.Add(crossViewHeaderDescriptor);
- if ((j == 0) && (k == 0))
- {
- Array.Resize(ref rowDescriptorsIndexes, rowDescriptorsIndexes.Length + 1);
- rowDescriptorsIndexes[rowDescriptorsIndexes.Length - 1] = Columns.Count - 1;
- }
- if ((k == i) || (i == (XAxisFieldsCount - 1)))
- {
- Array.Resize(ref columnTerminalIndexes, columnTerminalIndexes.Length + 1);
- columnTerminalIndexes[columnTerminalIndexes.Length - 1] = Columns.Count - 1;
- }
- }
- }
- }
- else
- {
- for (int j = 0; j < MeasuresCount; j++)
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor(CubeSource.GetXAxisFieldName(i), "", false, false, false);
- crossViewHeaderDescriptor.level = i;
- crossViewHeaderDescriptor.levelsize = 1;
- crossViewHeaderDescriptor.cell = cell;
- crossViewHeaderDescriptor.cellsize = XAxisFieldsCount - i;
- cell += crossViewHeaderDescriptor.cellsize;
- Columns.Add(crossViewHeaderDescriptor);
- if (j == 0)
- {
- Array.Resize(ref rowDescriptorsIndexes, rowDescriptorsIndexes.Length + 1);
- rowDescriptorsIndexes[rowDescriptorsIndexes.Length - 1] = Columns.Count - 1;
- }
- if (i == 1)
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor("", "", false, true, false);
- }
- else
- if (i == (MeasuresLevel + 1))
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor(CubeSource.GetXAxisFieldName(i - 2), "", true, false, false);
- }
- else
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor(CubeSource.GetXAxisFieldName(i - 1), "", true, false, false);
- }
- crossViewHeaderDescriptor.level = i;
- crossViewHeaderDescriptor.levelsize = XAxisFieldsCount - i;
- crossViewHeaderDescriptor.cell = cell;
- crossViewHeaderDescriptor.cellsize = 1;
- cell += crossViewHeaderDescriptor.cellsize;
- Columns.Add(crossViewHeaderDescriptor);
- if ((crossViewHeaderDescriptor.level + crossViewHeaderDescriptor.levelsize == XAxisFieldsCount))
- {
- Array.Resize(ref columnTerminalIndexes, columnTerminalIndexes.Length + 1);
- columnTerminalIndexes[columnTerminalIndexes.Length - 1] = Columns.Count - 1;
- }
- }
- }
- }
- else
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor(CubeSource.GetXAxisFieldName(i), "", false, false, false);
- crossViewHeaderDescriptor.level = i;
- crossViewHeaderDescriptor.levelsize = 1;
- crossViewHeaderDescriptor.cell = cell;
- if (MeasuresInXAxis)
- {
- crossViewHeaderDescriptor.cellsize = (XAxisFieldsCount - i - 1) * MeasuresCount;
- if (crossViewHeaderDescriptor.cellsize == 0)
- crossViewHeaderDescriptor.cellsize = MeasuresCount;
- }
- else
- {
- crossViewHeaderDescriptor.cellsize = XAxisFieldsCount - i;
- }
- cell += crossViewHeaderDescriptor.cellsize;
- Columns.Add(crossViewHeaderDescriptor);
- if ((crossViewHeaderDescriptor.level + crossViewHeaderDescriptor.levelsize == XAxisFieldsCount))
- {
- Array.Resize(ref columnTerminalIndexes, columnTerminalIndexes.Length + 1);
- columnTerminalIndexes[columnTerminalIndexes.Length - 1] = Columns.Count - 1;
- }
- Array.Resize(ref rowDescriptorsIndexes, rowDescriptorsIndexes.Length + 1);
- rowDescriptorsIndexes[rowDescriptorsIndexes.Length - 1] = Columns.Count - 1;
- if (i == 0)
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor("", "", false, true, false);
- }
- else
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor(CubeSource.GetXAxisFieldName(i - 1), "", true, false, false);
- }
- crossViewHeaderDescriptor.level = i;
- crossViewHeaderDescriptor.cell = cell;
- if (MeasuresInXAxis)
- {
- crossViewHeaderDescriptor.levelsize = MeasuresLevel - i;
- crossViewHeaderDescriptor.cellsize = MeasuresCount;
- }
- else
- {
- crossViewHeaderDescriptor.levelsize = XAxisFieldsCount - i;
- crossViewHeaderDescriptor.cellsize = 1;
- }
- cell += crossViewHeaderDescriptor.cellsize;
- Columns.Add(crossViewHeaderDescriptor);
- if ((crossViewHeaderDescriptor.level + crossViewHeaderDescriptor.levelsize == XAxisFieldsCount))
- {
- Array.Resize(ref columnTerminalIndexes, columnTerminalIndexes.Length + 1);
- columnTerminalIndexes[columnTerminalIndexes.Length - 1] = Columns.Count - 1;
- }
- }
- }
- if (Columns.Count == 0)
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor("", "", false, true, false);
- crossViewHeaderDescriptor.level = 0;
- crossViewHeaderDescriptor.levelsize = 1;
- crossViewHeaderDescriptor.cell = 0;
- crossViewHeaderDescriptor.cellsize = 1;
- Columns.Add(crossViewHeaderDescriptor);
- Array.Resize(ref rowDescriptorsIndexes, rowDescriptorsIndexes.Length + 1);
- rowDescriptorsIndexes[rowDescriptorsIndexes.Length - 1] = Columns.Count - 1;
- Array.Resize(ref columnTerminalIndexes, columnTerminalIndexes.Length + 1);
- columnTerminalIndexes[columnTerminalIndexes.Length - 1] = Columns.Count - 1;
- }
- for (int i = 0; i < YAxisFieldsCount; i++)
- {
- cell = 0;
- if (MeasuresInYAxis && (MeasuresLevel <= i))
- {
- if (MeasuresLevel == i)
- {
- for (int k = 0; k <= i; k++)
- {
- for (int j = 0; j < MeasuresCount; j++)
- {
- if (k == i)
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor("", CubeSource.GetMeasureName(j), false, false, true);
- crossViewHeaderDescriptor.cellsize = 1;
- crossViewHeaderDescriptor.levelsize = YAxisFieldsCount - i;
- }
- else
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor(CubeSource.GetYAxisFieldName(k), CubeSource.GetMeasureName(j), false, false, true);
- crossViewHeaderDescriptor.cellsize = (YAxisFieldsCount - i);
- crossViewHeaderDescriptor.levelsize = 1;
- }
- crossViewHeaderDescriptor.level = i;
- crossViewHeaderDescriptor.cell = cell;
- cell += crossViewHeaderDescriptor.cellsize;
- Rows.Add(crossViewHeaderDescriptor);
- if ((j == 0) && (k == 0))
- {
- Array.Resize(ref columnDescriptorsIndexes, columnDescriptorsIndexes.Length + 1);
- columnDescriptorsIndexes[columnDescriptorsIndexes.Length - 1] = Rows.Count - 1;
- }
- if ((k == i) || (i == (YAxisFieldsCount - 1)))
- {
- Array.Resize(ref rowTerminalIndexes, rowTerminalIndexes.Length + 1);
- rowTerminalIndexes[rowTerminalIndexes.Length - 1] = Rows.Count - 1;
- }
- }
- }
- }
- else
- {
- for (int j = 0; j < MeasuresCount; j++)
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor(CubeSource.GetYAxisFieldName(i), "", false, false, false);
- crossViewHeaderDescriptor.level = i;
- crossViewHeaderDescriptor.levelsize = 1;
- crossViewHeaderDescriptor.cell = cell;
- crossViewHeaderDescriptor.cellsize = YAxisFieldsCount - i;
- cell += crossViewHeaderDescriptor.cellsize;
- Rows.Add(crossViewHeaderDescriptor);
- if (j == 0)
- {
- Array.Resize(ref columnDescriptorsIndexes, columnDescriptorsIndexes.Length + 1);
- columnDescriptorsIndexes[columnDescriptorsIndexes.Length - 1] = Rows.Count - 1;
- }
- if (i == 1)
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor("", "", false, true, false);
- }
- else
- if (i == (MeasuresLevel + 1))
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor(CubeSource.GetYAxisFieldName(i - 2), "", true, false, false);
- }
- else
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor(CubeSource.GetYAxisFieldName(i - 1), "", true, false, false);
- }
- crossViewHeaderDescriptor.level = i;
- crossViewHeaderDescriptor.levelsize = YAxisFieldsCount - i;
- crossViewHeaderDescriptor.cell = cell;
- crossViewHeaderDescriptor.cellsize = 1;
- cell += crossViewHeaderDescriptor.cellsize;
- Rows.Add(crossViewHeaderDescriptor);
- if ((crossViewHeaderDescriptor.level + crossViewHeaderDescriptor.levelsize == YAxisFieldsCount))
- {
- Array.Resize(ref rowTerminalIndexes, rowTerminalIndexes.Length + 1);
- rowTerminalIndexes[rowTerminalIndexes.Length - 1] = Rows.Count - 1;
- }
- }
- }
- }
- else
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor(CubeSource.GetYAxisFieldName(i), "", false, false, false);
- crossViewHeaderDescriptor.level = i;
- crossViewHeaderDescriptor.levelsize = 1;
- crossViewHeaderDescriptor.cell = cell;
- if (MeasuresInYAxis)
- {
- crossViewHeaderDescriptor.cellsize = (YAxisFieldsCount - i - 1) * MeasuresCount;
- if (crossViewHeaderDescriptor.cellsize == 0)
- crossViewHeaderDescriptor.cellsize = MeasuresCount;
- }
- else
- {
- crossViewHeaderDescriptor.cellsize = YAxisFieldsCount - i;
- }
- cell += crossViewHeaderDescriptor.cellsize;
- Rows.Add(crossViewHeaderDescriptor);
- if ((crossViewHeaderDescriptor.level + crossViewHeaderDescriptor.levelsize == YAxisFieldsCount))
- {
- Array.Resize(ref rowTerminalIndexes, rowTerminalIndexes.Length + 1);
- rowTerminalIndexes[rowTerminalIndexes.Length - 1] = Rows.Count - 1;
- }
- Array.Resize(ref columnDescriptorsIndexes, columnDescriptorsIndexes.Length + 1);
- columnDescriptorsIndexes[columnDescriptorsIndexes.Length - 1] = Rows.Count - 1;
- if (i == 0)
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor("", "", false, true, false);
- }
- else
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor(CubeSource.GetYAxisFieldName(i - 1), "", true, false, false);
- }
- crossViewHeaderDescriptor.level = i;
- crossViewHeaderDescriptor.cell = cell;
- if (MeasuresInYAxis)
- {
- crossViewHeaderDescriptor.levelsize = MeasuresLevel - i;
- crossViewHeaderDescriptor.cellsize = MeasuresCount;
- }
- else
- {
- crossViewHeaderDescriptor.levelsize = YAxisFieldsCount - i;
- crossViewHeaderDescriptor.cellsize = 1;
- }
- cell += crossViewHeaderDescriptor.cellsize;
- Rows.Add(crossViewHeaderDescriptor);
- if ((crossViewHeaderDescriptor.level + crossViewHeaderDescriptor.levelsize == YAxisFieldsCount))
- {
- Array.Resize(ref rowTerminalIndexes, rowTerminalIndexes.Length + 1);
- rowTerminalIndexes[rowTerminalIndexes.Length - 1] = Rows.Count - 1;
- }
- }
- }
- if (Rows.Count == 0)
- {
- crossViewHeaderDescriptor = new CrossViewHeaderDescriptor("", "", false, true, false);
- crossViewHeaderDescriptor.level = 0;
- crossViewHeaderDescriptor.levelsize = 1;
- crossViewHeaderDescriptor.cell = 0;
- crossViewHeaderDescriptor.cellsize = 1;
- Rows.Add(crossViewHeaderDescriptor);
- Array.Resize(ref columnDescriptorsIndexes, columnDescriptorsIndexes.Length + 1);
- columnDescriptorsIndexes[columnDescriptorsIndexes.Length - 1] = Rows.Count - 1;
- Array.Resize(ref rowTerminalIndexes, rowTerminalIndexes.Length + 1);
- rowTerminalIndexes[rowTerminalIndexes.Length - 1] = Rows.Count - 1;
- }
- CrossViewCellDescriptor crossViewCellDescriptor;
- for (int i = 0; i < columnTerminalIndexes.Length; i++)
- {
- for (int j = 0; j < rowTerminalIndexes.Length; j++)
- {
- crossViewCellDescriptor = new CrossViewCellDescriptor(Columns[columnTerminalIndexes[i]].fieldName, Rows[rowTerminalIndexes[j]].fieldName, Columns[columnTerminalIndexes[i]].measureName + Rows[rowTerminalIndexes[j]].measureName, Columns[columnTerminalIndexes[i]].isTotal, Rows[rowTerminalIndexes[j]].isTotal, Columns[columnTerminalIndexes[i]].isGrandTotal, Rows[rowTerminalIndexes[j]].isGrandTotal);
- crossViewCellDescriptor.x = i;
- crossViewCellDescriptor.y = j;
- Cells.Add(crossViewCellDescriptor);
- }
- }
- }
- internal CrossViewHeaderDescriptor GetRowDescriptor(int index)
- {
- int tempXAxisFieldsCount = (!SourceAssigned) ? 1 : XAxisFieldsCount;
- if (index < tempXAxisFieldsCount)
- {
- return Columns[rowDescriptorsIndexes[index]];
- }
- else
- {
- return Rows[rowTerminalIndexes[index - tempXAxisFieldsCount]];
- }
- }
- internal CrossViewHeaderDescriptor GetColumnDescriptor(int index)
- {
- int tempYAxisFieldsCount = (!SourceAssigned) ? 1 : YAxisFieldsCount;
- if (index < tempYAxisFieldsCount)
- {
- return Rows[columnDescriptorsIndexes[index]];
- }
- else
- {
- return Columns[columnTerminalIndexes[index - tempYAxisFieldsCount]];
- }
- }
- #endregion
- #region Properties
- /// <summary>
- /// Gets a collection of column descriptors.
- /// </summary>
- /// <remarks>
- /// Note: after you change something in this collection, call the
- /// <see cref="CrossViewObject.BuildTemplate"/> method to refresh the CrossView.
- /// </remarks>
- public CrossViewHeader Columns
- {
- get { return columns; }
- }
- /// <summary>
- /// Gets a collection of row descriptors.
- /// </summary>
- /// <remarks>
- /// Note: after you change something in this collection, call the
- /// <see cref="CrossViewObject.BuildTemplate"/> method to refresh the CrossView.
- /// </remarks>
- public CrossViewHeader Rows
- {
- get { return rows; }
- }
- /// <summary>
- /// Gets a collection of data cell descriptors.
- /// </summary>
- /// <remarks>
- /// Note: after you change something in this collection, call the
- /// <see cref="CrossViewObject.BuildTemplate"/> method to refresh the CrossView.
- /// </remarks>
- public CrossViewCells Cells
- {
- get { return cells; }
- }
- #endregion
- #region Public Methods
- #endregion
- internal CrossViewData()
- {
- columns = new CrossViewHeader();
- columns.Name = "CrossViewColumns";
- rows = new CrossViewHeader();
- rows.Name = "CrossViewRows";
- cells = new CrossViewCells();
- cells.Name = "CrossViewCells";
- CreateDescriptors();
- }
- }
- }
|