public string VisibleColumnsToString() { string strVisible = ""; try { GridColsCollection columns = VisibleColumns(); foreach (GridColsColumn sColumn in columns) { if (sColumn.Visible == true) { if (string.IsNullOrEmpty(strVisible)) { strVisible = sColumn.ColumnName; } else { strVisible += _SortDelimeter + sColumn.ColumnName; } } } } catch (Exception ex) { } return(strVisible); }
private void RemoveExcelColumns(ref DataTable dt) { try { GridColsCollection cols = columnData.VisibleColumns(); DataColumn col = null; //this has to be done in reverse order (RemoveAt) //OR by name(Remove) or it will have undesired result for (int i = dt.Columns.Count - 1; i >= 0; i--) { col = dt.Columns[i]; if (cols.ItemByColumnName(col.ColumnName) == null && col.ColumnName != "WorkAreaID" && col.ColumnName != " ") { dt.Columns.Remove(col); } } if (dt.Columns.Contains("A")) { dt.Columns.Remove("A"); } if (dt.Columns.Contains("X")) { dt.Columns.Remove("X"); } dt.AcceptChanges(); } catch (Exception ex) { LogUtility.LogException(ex); } }
public GridColsCollection SortableColumns() { GridColsCollection sColumns = new GridColsCollection(); foreach (GridColsColumn sColumn in _Columns) { if (sColumn.CanSort == true) { sColumns.Add(sColumn.ColumnName, sColumn.DisplayName, sColumn.Visible, sColumn.CanSort); sColumns.Item(sColumns.Count - 1).ColumnIndex = sColumn.ColumnIndex; sColumns.Item(sColumns.Count - 1).Viewable = sColumn.Viewable; } } return(Columns); }
private void FormatExcelRows(ref DataTable dt) { GridColsCollection cols = columnData.VisibleColumns(); bool hasArchive = false; hasArchive = (cols.ItemByColumnName("ARCHIVE") != null); if (hasArchive) { dt.Columns.Add("ARCHIVE_NEW"); } int flag = 0; if (hasArchive) { foreach (DataRow row in dt.Rows) { if (hasArchive) { if (int.TryParse(row["ARCHIVE"].ToString(), out flag) && flag == 1) { row["ARCHIVE_NEW"] = "Yes"; } else { row["ARCHIVE_NEW"] = "No"; } } } dt.Columns["ARCHIVE_NEW"].SetOrdinal(dt.Columns["ARCHIVE"].Ordinal); dt.Columns.Remove("ARCHIVE"); dt.Columns["ARCHIVE_NEW"].ColumnName = "ARCHIVE"; } dt.Columns.Add(" "); dt.Columns.Add(" "); if (dt.Columns.Contains("WTS_SystemID")) { dt.Columns["WTS_SystemID"].SetOrdinal(dt.Columns.Count - 1); } dt.AcceptChanges(); }
public GridColsCollection VisibleColumns() { GridColsCollection columns = new GridColsCollection(); GridColsColumn gcc = null; for (int i = 0; i <= _Columns.Count; i++) { gcc = _Columns.ItemByColumnOrder(i); if ((gcc == null) == false && gcc.Visible == true) { columns.Add(gcc.ColumnName, gcc.DisplayName, gcc.Visible, gcc.CanSort); columns.Item(columns.Count - 1).ColumnIndex = gcc.ColumnIndex; columns.Item(columns.Count - 1).Viewable = gcc.Viewable; } } return(columns); }
private void RenameExcelColumns(ref DataTable dt) { GridColsCollection cols = columnData.VisibleColumns(); GridColsColumn gcCol = null; DataColumn col = null; for (int i = dt.Columns.Count - 1; i >= 0; i--) { col = dt.Columns[i]; gcCol = cols.ItemByColumnName(col.ColumnName); if (gcCol != null) { dt.Columns[col.ColumnName].ColumnName = gcCol.DisplayName; } } dt.AcceptChanges(); }
public GridColsCollection CurrentOrderedColumns() { GridColsCollection oColumns = new GridColsCollection(); for (int i = 0; i < _Columns.Count; i++) { GridColsColumn testColumn = _Columns.ItemByColumnOrder(i); if ((testColumn == null) == false) { if (testColumn.CanReorder == true & testColumn.Viewable == true) { oColumns.Add(testColumn.ColumnName, testColumn.DisplayName, testColumn.Visible, testColumn.CanSort); oColumns.Item(oColumns.Count - 1).ColumnIndex = testColumn.ColumnIndex; oColumns.Item(oColumns.Count - 1).Viewable = testColumn.Viewable; } } } return(oColumns); }
public string[] VisibleColumnNamesArray() { GridColsCollection columns = VisibleColumns(); if ((columns == null) || columns.Count == 0) { return(new string[] { "" }); } string[] colArray = new string[columns.Count + 1]; GridColsColumn gcc = null; for (int i = 0; i <= columns.Count; i++) { gcc = columns.ItemByColumnOrder(i); if ((gcc != null) && gcc.Visible) { colArray[i] = gcc.ColumnName; } } return(colArray); }