// Used by Janitor.Fody
private void DisposeManaged()
{
CellsCollection.Clear();
ColumnsCollection.Clear();
RowsCollection.Clear();
MergedRanges.RemoveAll();
}
public void Add(Int32 row, Int32 column, XLCell cell)
{
Count++;
IncrementUsage(RowsUsed, row);
IncrementUsage(ColumnsUsed, column);
if (!RowsCollection.TryGetValue(row, out Dictionary <int, XLCell> columnsCollection))
{
columnsCollection = new Dictionary <int, XLCell>();
RowsCollection.Add(row, columnsCollection);
}
columnsCollection.Add(column, cell);
if (row > MaxRowUsed)
{
MaxRowUsed = row;
}
if (column > MaxColumnUsed)
{
MaxColumnUsed = column;
}
if (Deleted.TryGetValue(row, out HashSet <int> delHash))
{
delHash.Remove(column);
}
}
public int FirstColumnUsed(int rowStart, int columnStart, int rowEnd, int columnEnd, XLCellsUsedOptions options,
Func <IXLCell, Boolean> predicate = null)
{
int finalRow = rowEnd > MaxRowUsed ? MaxRowUsed : rowEnd;
int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd;
int firstColumnUsed = finalColumn;
var found = false;
for (int ro = rowStart; ro <= finalRow; ro++)
{
if (RowsCollection.TryGetValue(ro, out Dictionary <Int32, XLCell> columnsCollection))
{
for (int co = columnStart; co <= firstColumnUsed; co++)
{
if (columnsCollection.TryGetValue(co, out XLCell cell) &&
!cell.IsEmpty(options) &&
(predicate == null || predicate(cell)) &&
co <= firstColumnUsed)
{
firstColumnUsed = co;
found = true;
break;
}
}
}
}
return(found ? firstColumnUsed : 0);
}
public void Dispose()
{
CellsCollection.Clear();
ColumnsCollection.Clear();
RowsCollection.Clear();
MergedRanges.RemoveAll();
}
public DunaGridView()
{
this.InitializeComponent();
BaseGrid b = new BaseGrid();
baseGridsContainer1.Items.Add(b);
baseGridsPinnedCols.Items.Add(new BaseGrid());
PinnedRow nr = new PinnedRow();
PinnedRow nr2 = new PinnedRow();
baseGridsContainer1.Items.Add(nr);
baseGridsPinnedCols.Items.Add(nr2);
/*components.FilterRow fr = new components.FilterRow();
* components.FilterRow fr2 = new components.FilterRow();
*
* baseGridsContainer1.Items.Add(fr);
*
* baseGridsPinnedCols.Items.Add(fr2);*/
this.DoubleBuffered = true;
this.ResizeRedraw = true;
//prida datareadery do kolekce
this.data_readers.Add(new BindingSourceDataReader(this.data_readers));
this.rows = new RowsCollection(this);
nr.Rows = rows;
nr2.Rows = rows;
dunaGridHeaderRow1.NeedRefresh += new EventHandler(dunaGridHeaderRow1_NeedRefresh);
dunaGridRowSelectorsColumn1.NeedRefresh += new EventHandler(dunaGridHeaderRow1_NeedRefresh);
}
public Row this[int rowIndex]
{
get
{
var row = new RowsCollection(_dataTable);
return(row[rowIndex]);
}
}
public Int32 MaxColumnInRow(Int32 row)
{
if (RowsCollection.TryGetValue(row, out Dictionary <Int32, XLCell> columnsCollection) &&
columnsCollection.Any())
{
return(columnsCollection.Keys.Max());
}
return(0);
}
public void Clear()
{
Count = 0;
RowsUsed.Clear();
ColumnsUsed.Clear();
RowsCollection.Clear();
MaxRowUsed = 0;
MaxColumnUsed = 0;
}
public XLCell GetCell(Int32 row, Int32 column)
{
if (row > MaxRowUsed || column > MaxColumnUsed)
{
return(null);
}
if (RowsCollection.TryGetValue(row, out Dictionary <Int32, XLCell> columnsCollection))
{
return(columnsCollection.TryGetValue(column, out XLCell cell) ? cell : null);
}
return(null);
}
public Int32 MaxRowInColumn(Int32 column)
{
for (int row = MaxRowUsed; row >= 1; row--)
{
if (RowsCollection.TryGetValue(row, out Dictionary <Int32, XLCell> columnsCollection) &&
columnsCollection.ContainsKey(column))
{
return(row);
}
}
return(0);
}
private Dictionary <int, int> VratiOznaceneRacune(RowsCollection rowsCollection)
{
Dictionary <int, int> oznaceni = new Dictionary <int, int>();
foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in rowsCollection)
{
if (row.Cells["Ozn"].Value.ToString() == "True")
{
oznaceni.Add(Convert.ToInt32(row.Cells["IDRACUN"].Value), Convert.ToInt32(row.Cells["RACUNGODINAIDGODINE"].Value));
}
}
return(oznaceni);
}
internal IEnumerable <XLCell> GetCells(Func <IXLCell, Boolean> predicate)
{
for (int ro = 1; ro <= MaxRowUsed; ro++)
{
if (RowsCollection.TryGetValue(ro, out Dictionary <Int32, XLCell> columnsCollection))
{
for (int co = 1; co <= MaxColumnUsed; co++)
{
if (columnsCollection.TryGetValue(co, out XLCell cell) &&
(predicate == null || predicate(cell)))
{
yield return(cell);
}
}
}
}
}
public void Remove(Int32 row, Int32 column)
{
Count--;
var rowRemoved = DecrementUsage(RowsUsed, row);
var columnRemoved = DecrementUsage(ColumnsUsed, column);
if (rowRemoved && row == MaxRowUsed)
{
MaxRowUsed = RowsUsed.Keys.Any()
? RowsUsed.Keys.Max()
: 0;
}
if (columnRemoved && column == MaxColumnUsed)
{
MaxColumnUsed = ColumnsUsed.Keys.Any()
? ColumnsUsed.Keys.Max()
: 0;
}
if (Deleted.TryGetValue(row, out HashSet <Int32> delHash))
{
if (!delHash.Contains(column))
{
delHash.Add(column);
}
}
else
{
delHash = new HashSet <int>();
delHash.Add(column);
Deleted.Add(row, delHash);
}
if (RowsCollection.TryGetValue(row, out Dictionary <Int32, XLCell> columnsCollection))
{
columnsCollection.Remove(column);
if (columnsCollection.Count == 0)
{
RowsCollection.Remove(row);
}
}
}
public void RemoveAll(Int32 rowStart, Int32 columnStart,
Int32 rowEnd, Int32 columnEnd)
{
int finalRow = rowEnd > MaxRowUsed ? MaxRowUsed : rowEnd;
int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd;
for (int ro = rowStart; ro <= finalRow; ro++)
{
if (RowsCollection.TryGetValue(ro, out Dictionary <int, XLCell> columnsCollection))
{
for (int co = columnStart; co <= finalColumn; co++)
{
if (columnsCollection.ContainsKey(co))
{
Remove(ro, co);
}
}
}
}
}
public IEnumerable <XLSheetPoint> GetSheetPoints(Int32 rowStart, Int32 columnStart,
Int32 rowEnd, Int32 columnEnd)
{
int finalRow = rowEnd > MaxRowUsed ? MaxRowUsed : rowEnd;
int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd;
for (int ro = rowStart; ro <= finalRow; ro++)
{
if (RowsCollection.TryGetValue(ro, out Dictionary <Int32, XLCell> columnsCollection))
{
for (int co = columnStart; co <= finalColumn; co++)
{
if (columnsCollection.ContainsKey(co))
{
yield return(new XLSheetPoint(ro, co));
}
}
}
}
}
private void SetActiveRow(UltraGrid grid, string tagName)
{
if (!string.IsNullOrEmpty(tagName))
{
RowsCollection sr = grid.Rows;
if (sr.Count > 0)
{
foreach (UltraGridRow row in sr)
{
row.Selected = false;
if (row.Cells[colHeaderTagName].Text == tagName)
{
row.Selected = true;
grid.ActiveRow = row;
}
}
LoadSelectedTagServers();
}
}
}
private void aCheckBoxUIElement_ElementClick(Object sender, Infragistics.Win.UIElementEventArgs e)
{
// Get the CheckBoxUIElement that was clicked
CheckBoxUIElement aCheckBoxUIElement = (CheckBoxUIElement)e.Element;
// Get the Header associated with this particular element
Infragistics.Win.UltraWinGrid.ColumnHeader aColumnHeader = (Infragistics.Win.UltraWinGrid.ColumnHeader)aCheckBoxUIElement.GetAncestor(typeof(HeaderUIElement)).GetContext(typeof(Infragistics.Win.UltraWinGrid.ColumnHeader));
// Set the Tag on the Header to the new CheckState
aColumnHeader.Tag = aCheckBoxUIElement.CheckState;
// So that we can apply various changes only to the relevant Rows collection that the header belongs to
HeaderUIElement aHeaderUIElement = aCheckBoxUIElement.GetAncestor(typeof(HeaderUIElement)) as HeaderUIElement;
RowsCollection hRows = aHeaderUIElement.GetContext(typeof(RowsCollection)) as RowsCollection;
// Raise an event so the programmer can do something when the CheckState changes
if (_CLICKED != null)
{
_CLICKED(this, new HeaderCheckBoxEventArgs(aColumnHeader, aCheckBoxUIElement.CheckState, hRows));
}
}
internal IEnumerable <XLCell> GetCells(Int32 rowStart, Int32 columnStart,
Int32 rowEnd, Int32 columnEnd,
Func <IXLCell, Boolean> predicate = null)
{
int finalRow = rowEnd > MaxRowUsed ? MaxRowUsed : rowEnd;
int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd;
for (int ro = rowStart; ro <= finalRow; ro++)
{
if (RowsCollection.TryGetValue(ro, out Dictionary <Int32, XLCell> columnsCollection))
{
for (int co = columnStart; co <= finalColumn; co++)
{
if (columnsCollection.TryGetValue(co, out XLCell cell) &&
(predicate == null || predicate(cell)))
{
yield return(cell);
}
}
}
}
}
public int LastRowUsed(int rowStart, int columnStart, int rowEnd, int columnEnd, XLCellsUsedOptions options,
Func <IXLCell, Boolean> predicate = null)
{
int finalRow = rowEnd > MaxRowUsed ? MaxRowUsed : rowEnd;
int finalColumn = columnEnd > MaxColumnUsed ? MaxColumnUsed : columnEnd;
for (int ro = finalRow; ro >= rowStart; ro--)
{
if (RowsCollection.TryGetValue(ro, out Dictionary <Int32, XLCell> columnsCollection))
{
for (int co = finalColumn; co >= columnStart; co--)
{
if (columnsCollection.TryGetValue(co, out XLCell cell) &&
!cell.IsEmpty(options) &&
(predicate == null || predicate(cell)))
{
return(ro);
}
}
}
}
return(0);
}
public void ExtendTest(int rowCount)
{
var target = new RowsCollection();
var lifeLineStub = new Mock <Lifeline>(MockBehavior.Loose, null, null, null, 0);
Lifeline lifeline = lifeLineStub.Object;
var rowMocks = new Stack <Mock>();
for (int i = 0; i < rowCount; i++)
{
var rowMock = new Mock <Row>(MockBehavior.Strict, 0);
rowMocks.Push(rowMock);
rowMock.Setup(row => row.Extend(lifeline));
Row targetRow = rowMock.Object;
target.Add(targetRow);
}
target.Extend(lifeline);
foreach (var rowMock in rowMocks)
{
rowMock.VerifyAll();
}
}
public Boolean Contains(Int32 row, Int32 column)
{
return(RowsCollection.TryGetValue(row, out Dictionary <Int32, XLCell> columnsCollection) &&
columnsCollection.ContainsKey(column));
}
public void Dispose()
{
ColumnsCollection.Dispose();
RowsCollection.Dispose();
MergedRanges.Dispose();
}
object ICustomSummaryCalculator.EndCustomSummary(SummarySettings summarySettings, RowsCollection rows)
{
if (decimal.Compare(this.totalsati, decimal.Zero) > 0)
{
return(DB.RoundUP(decimal.Divide(decimal.Multiply(DB.RoundUP(decimal.Divide(this.totalbruto, this.totalsati)), 85M), 100M)));
}
return(0);
}
/// <summary>
/// Costruttore vuoto. Crea l'oggetto inizializzando a vuote le collezioni di righe, colonne e celle.
/// </summary>
public Range()
{
_rows = new RowsCollection(this);
_cols = new ColumnsCollection(this);
_cells = new CellsCollection(this);
}
object ICustomSummaryCalculator.EndCustomSummary(SummarySettings summarySettings, RowsCollection rows)
{
return(this.totals);
}
void ICustomSummaryCalculator.BeginCustomSummary(SummarySettings summarySettings, RowsCollection rows)
{
this.totalsati = new decimal();
this.totalbruto = new decimal();
}
public object EndCustomSummary(SummarySettings summarySettings, RowsCollection rows)
{
return(total);
}
public DunaGridView()
{
this.InitializeComponent();
BaseGrid b = new BaseGrid();
baseGridsContainer1.Items.Add(b);
baseGridsPinnedCols.Items.Add(new BaseGrid());
PinnedRow nr = new PinnedRow();
PinnedRow nr2 = new PinnedRow();
baseGridsContainer1.Items.Add(nr);
baseGridsPinnedCols.Items.Add(nr2);
/*components.FilterRow fr = new components.FilterRow();
components.FilterRow fr2 = new components.FilterRow();
baseGridsContainer1.Items.Add(fr);
baseGridsPinnedCols.Items.Add(fr2);*/
this.DoubleBuffered = true;
this.ResizeRedraw = true;
//prida datareadery do kolekce
this.data_readers.Add(new BindingSourceDataReader(this.data_readers));
this.rows = new RowsCollection(this);
nr.Rows = rows;
nr2.Rows = rows;
dunaGridHeaderRow1.NeedRefresh += new EventHandler(dunaGridHeaderRow1_NeedRefresh);
dunaGridRowSelectorsColumn1.NeedRefresh += new EventHandler(dunaGridHeaderRow1_NeedRefresh);
}
public HeaderCheckBoxEventArgs(Infragistics.Win.UltraWinGrid.ColumnHeader hdrColumnHeader, CheckState chkCheckState, RowsCollection Rows)
{
mvarColumnHeader = hdrColumnHeader;
mvarCheckState = chkCheckState;
mvarRowsCollection = Rows;
}
public HeaderCheckBoxEventArgs(Infragistics.Win.UltraWinGrid.ColumnHeader columnHeader, CheckState checkState, RowsCollection rowsCollection)
{
_columnHeader = columnHeader;
_checkState = checkState;
_rowsCollection = rowsCollection;
}
private RiepilogoAssemblea calcolaRiepilogo(RowsCollection rows)
{
RiepilogoAssemblea riepilogo = new RiepilogoAssemblea();
foreach (UltraGridRow row in rows)
{
if (checkAbilitatoAllaVotazione(row))
{
riepilogo.Presenti++;
var bfavorebole = (bool) row.Cells["favorevole"].Value;
var bcontrario = (bool)row.Cells["contrario"].Value;
var bastenuto = (bool)row.Cells["astenuto"].Value;
if (bfavorebole || bcontrario || bastenuto) riepilogo.Voti++;
riepilogo.MillesimiRealiTotali += (decimal)row.Cells["MillesimiProprietaConvocato"].Value;
if (bfavorebole)
{
riepilogo.Favorevoli++;
riepilogo.MillesimiRealiVotazione += (decimal)row.Cells["MillesimiProprietaConvocato"].Value;
}
if (bcontrario)
{
riepilogo.Contrari++;
riepilogo.MillesimiRealiVotazione += (decimal)row.Cells["MillesimiProprietaConvocato"].Value;
}
if (bastenuto)
{
riepilogo.Astenuti++;
}
}
riepilogo.Convocati++;
}
return riepilogo;
}
public void BeginCustomSummary(SummarySettings summarySettings, RowsCollection rows)
{
total = 0;
}
private RiepilogoAssemblea calcolaRiepilogo(RowsCollection rows)
{
RiepilogoAssemblea riepilogo = new RiepilogoAssemblea();
foreach (UltraGridRow row in rows)
{
if (bool.Parse(row.Cells["CheckEntrata"].Text))
{
riepilogo.Presenti++;
riepilogo.MillesimiRealiVotazione += (decimal)row.Cells["MillesimiProprietaConvocato"].Value;
}
riepilogo.MillesimiRealiTotali += (decimal)row.Cells["MillesimiProprietaConvocato"].Value;
riepilogo.Convocati++;
}
return riepilogo;
}
