protected void Page_Load(object sender, EventArgs e)
{
T graph = (T)ds.DataGraph;
this.gridSub = this.tab.FindControl("gridSub") as PXGrid;
this.gridAttachments = this.tab.FindControl("gridAttachments") as PXGrid;
WikiPage curr = (WikiPage)graph.Caches[typeof(WikiPage)].Current;
if (!this.hasQueryParams && curr != null && !this.Page.IsPostBack && !this.Page.IsCallback)
{
this.ds.DataGraph.Clear();
this.Response.Redirect(this.Request.RawUrl + "?wiki=" + curr.WikiID.GetValueOrDefault().ToString() + "&parent=" + curr.ParentUID.GetValueOrDefault().ToString() + "&name=" + curr.Name);
return;
}
WikiReader reader = PXGraph.CreateInstance <WikiReader>();
this.edtWikiText = (PXWikiEdit)this.tab.DataControls["edtWikiText"];
this.edtWikiText.PreviewSettings = new PXWikiSettings(this.Page, reader).Relative;
this.edtWikiText.FileNamePrefix = curr == null ? null : curr.Name;
this.edtWikiText.FileUploaded += new PXFileUploadEventHandler(editor_FileUploaded);
graph.GetFileUrl = Request.GetWebsiteAuthority().GetLeftPart(UriPartial.Authority) + ResolveUrl("~/Frames/GetFile.ashx");
graph.CurrentAttachmentGuid = PX.Common.GUID.CreateGuid((string)gridAttachments.DataValues["FileID"]).GetValueOrDefault();
PXEntryStatus recStatus = ds.DataGraph.Caches[typeof(WikiPage)].GetStatus(curr);
if (recStatus == PXEntryStatus.Deleted || recStatus == PXEntryStatus.Inserted || recStatus == PXEntryStatus.InsertedDeleted)
{
edtWikiText.AttachFileEnabled = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsCallback)
{
PXGrid grid = this.tab.FindControl("grdFilter") as PX.Web.UI.PXGrid;
if (grid != null)
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "gridFilterID", "var grdFilterID=\"" + grid.ClientID + "\";", true);
grid = this.tab.FindControl("grdResults") as PX.Web.UI.PXGrid;
if (grid != null)
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "gridResultsID", "var grdResultsID=\"" + grid.ClientID + "\";", true);
grid = this.tab.FindControl("grdSorts") as PX.Web.UI.PXGrid;
if (grid != null)
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "gridSortsID", "var grdSortsID=\"" + grid.ClientID + "\";", true);
grid = this.tab.FindControl("grdWheres") as PX.Web.UI.PXGrid;
if (grid != null)
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "grdWheres", "var grdWheresID=\"" + grid.ClientID + "\";", true);
grid = this.tab.FindControl("grdGroupBy") as PX.Web.UI.PXGrid;
if (grid != null)
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "grdGroupBy", "var grdGroupByID=\"" + grid.ClientID + "\";", true);
PXSplitContainer sp1 = this.tab.FindControl("sp1") as PXSplitContainer;
grid = sp1.FindControl("grdJoins") as PX.Web.UI.PXGrid;
if (grid != null)
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "grdJoins", "var grdJoinsID=\"" + grid.ClientID + "\";", true);
grid = sp1.FindControl("grdOns") as PX.Web.UI.PXGrid;
if (grid != null)
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "grdOns", "var grdOnsID=\"" + grid.ClientID + "\";", true);
this.ClientScript.RegisterArrayDeclaration("relativeDatesVariables", String.Join(",", RelativeDatesManager.AllVariables.Select(v => String.Concat("\"", v, "\""))));
}
}
protected void Page_Init(object sender, EventArgs e)
{
if (PXAccess.FeatureInstalled <FeaturesSet.construction>())
{
PXGrid grid = tab.FindControl("grid1") as PXGrid;
grid.SyncPosition = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
PXGrid grid = this.tab.FindControl("gridPreparedData") as PXGrid;
if (grid != null)
{
grid.RepaintColumns = true;
grid.GenerateColumnsBeforeRepaint = true;
}
}
protected void OnInitialised()
{
PXGrid gridKeys = sp1.FindControl("gridKeys") as PXGrid;
PXGrid gridChanges = sp1.FindControl("gridChanges") as PXGrid;
CreateColumns(ds.GetSchema("Keys"), gridKeys);
CreateColumns(ds.GetSchema("Changes"), gridChanges);
AddFastFilterFields(gridKeys);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsCallback)
{
//Register variable to perform user friendly grid row selecting
PXGrid grid = this.gridCompanies;
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "gridCompaniesID", "var grdCompaniesID=\"" + grid.ClientID + "\";", true);
this.Page.ClientScript.RegisterHiddenField("__FORCELOGOUT", "1");
}
}
protected void CreateColumns(PXDataSourceViewSchema schema, PXGrid grid)
{
List<string> list = new List<string>();
foreach (PXGridColumn col in grid.Levels[0].Columns)
{
if (!String.IsNullOrEmpty(col.DataField))
{
list.Add(col.DataField);
}
}
foreach (PXFieldState field in schema.GetFields())
{
if (!AUAuditInquire.FORBIDDEN_COLUMNS.Contains(field.Name) && field.Name.EndsWith(AUAuditInquire.VIRTUAL_FIELD_SUFFIX) && !list.Contains(field.Name))
{
PXGridColumn col = new PXGridColumn();
col.DataField = field.Name;
col.DataType = Type.GetTypeCode(field.DataType);
col.TextAlign = HorizontalAlign.Right;
col.Width = Unit.Pixel(120);
switch (col.DataType)
{
case TypeCode.Boolean:
col.Width = Unit.Pixel(60);
col.Type = GridColumnType.CheckBox;
col.TextAlign = HorizontalAlign.Center;
break;
case TypeCode.DateTime:
col.TextAlign = HorizontalAlign.Left;
col.DisplayFormat = "g";
break;
case TypeCode.String:
col.TextAlign = HorizontalAlign.Left;
break;
}
col.Visible = true;
col.Header.Text = field.DisplayName == field.Name
? field.DisplayName.Substring(0, field.DisplayName.Length - AUAuditInquire.VIRTUAL_FIELD_SUFFIX.Length)
: field.DisplayName;
col.AllowShowHide = AllowShowHide.Server;
grid.Columns.Add(col);
}
list.Remove(field.Name);
}
foreach (string field in list)
{
PXGridColumn col = GetColumn(grid, field);
if (col != null) grid.Levels[0].Columns.Remove(col);
}
grid.FastFilterFields = grid.Columns.Items.Select(col => col.DataField).ToArray();
//if (grid.Levels[0].Columns.Count <= 1) grid.AllowAutoHide = true;
}
//Select view to generate grid columns
protected void OnGridLayoutLoad(object sender, PXGridLayoutEventArgs e)
{
PXGrid grid = sender as PXGrid;
PXGraph graph = grid.DataGraph;
int startRow = 0;
int maximumRows = 0;
int totalRows = 0;
graph.ExecuteSelect("Changes", new object[0], new object[0], new string[0], new bool[0], new PXFilterRow[0], ref startRow, maximumRows, ref totalRows);
}
private PXGridColumn GetColumn(PXGrid grid, String name)
{
foreach (PXGridColumn col in grid.Levels[0].Columns)
{
if (col.DataField == name)
{
return(col);
}
}
return(null);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsCallback)
{
PXGrid grid = this.tab.FindControl("gridMapping") as PX.Web.UI.PXGrid;
if (grid != null)
{
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "gridID", "var gridID=\"" + grid.ClientID + "\";", true);
}
}
}
protected PXGrid GetExceptionalObsoleteValueGrid()
{
PXGrid gridExceptionalObsoleteValue = null;
PXSplitContainer container = tab.FindControl("sp2") as PXSplitContainer;
if (container != null)
{
gridExceptionalObsoleteValue = container.FindControl("gridValueExceptionalObsolete") as PXGrid;
}
return(gridExceptionalObsoleteValue);
}
protected PXGrid GetExceptionalValueGrid()
{
PXGrid gridValueExceptional = null;
PXSplitContainer container = tab.FindControl("sp1") as PXSplitContainer;
if (container != null)
{
gridValueExceptional = container.FindControl("gridValueExceptional") as PXGrid;
}
return(gridValueExceptional);
}
protected PXGrid GetValueGrid()
{
PXGrid gridValue = null;
PXSplitContainer container = tab.FindControl("sp1") as PXSplitContainer;
if (container != null)
{
gridValue = container.FindControl("gridValue") as PXGrid;
}
return(gridValue);
}
protected void grd_EditorsCreated_RelativeDates(object sender, EventArgs e)
{
PXGrid grid = sender as PXGrid;
if (grid != null)
{
PXDateTimeEdit de = grid.PrimaryLevel.GetStandardEditor(GridStandardEditor.Date) as PXDateTimeEdit;
if (de != null)
{
de.ShowRelativeDates = true;
}
}
}
protected void InitializeDynamicGrid(PXGrid grid, TranslationMaint graph, string gridDataMember)
{
if (grid != null && graph != null && graph.LanguageFilter.Current != null && !string.IsNullOrEmpty(gridDataMember))
{
if (!string.IsNullOrEmpty(graph.LanguageFilter.Current.Language))
{
CreateColumns(ds.GetSchema(gridDataMember).GetFields(), grid, graph.Translator.Locales, graph.LanguageFilter.Current.Language.Split(TranslationMaint.MultilingualTranslator.LANGUAGE_SEPARATOR));
}
else
{
DeleteOldColumns(ds.GetSchema(gridDataMember).GetFields(), grid, graph.Translator.LocaleKeys);
}
}
}
protected void Page_Init(object sender, EventArgs e)
{
AUAuditInquire graph = ds.DataGraph as AUAuditInquire;
graph.OnInitialised += OnInitialised;
PXGrid gridKeys = sp1.FindControl("gridKeys") as PXGrid;
PXGrid gridChanges = sp1.FindControl("gridChanges") as PXGrid;
gridKeys.AllowAutoHide = false;
gridKeys.RepaintColumns = true;
gridChanges.AllowAutoHide = false;
gridChanges.RepaintColumns = true;
}
protected void CreateColumns(PXDataSourceViewSchema schema, PXGrid grid)
{
var gridColumn = sp1.FindControl("gridColumn") as PXGrid;
List <string> list = new List <string>();
foreach (PXGridColumn col in grid.Levels[0].Columns)
{
if (!String.IsNullOrEmpty(col.DataField))
{
list.Add(col.DataField);
}
}
foreach (PXFieldState field in schema.GetFields())
{
if (field.Name.Length <= 3 || field.Name.EndsWith("_StyleID"))
{
if (!list.Contains(field.Name))
{
PXGridColumn col = new PXGridColumn();
col.DataField = field.Name;
col.DataType = Type.GetTypeCode(field.DataType);
col.Width = Unit.Pixel(150);
col.Header.Text = field.DisplayName;
col.AllowShowHide = AllowShowHide.Server;
if (grid == gridColumn)
{
col.TextField = field.Name + "_Text";
}
else if (field.Name.Length <= 3)
{
col.EditorID = "edColHeader";
}
grid.Columns.Add(col);
}
}
list.Remove(field.Name);
}
foreach (string field in list)
{
foreach (PXGridColumn col in grid.Levels[0].Columns)
{
if (col.DataField == field)
{
grid.Levels[0].Columns.Remove(col);
break;
}
}
}
}
protected void resetGridPaging(object sender, EventArgs e)
{
PXGrid valueGrid = GetValueGrid();
if (valueGrid != null)
{
valueGrid.PageIndex = 0;
}
PXGrid obsoleteValueGrid = GetObsoleteValueGrid();
if (obsoleteValueGrid != null)
{
obsoleteValueGrid.PageIndex = 0;
}
}
protected void DeleteOldColumns(IEnumerable <PXFieldState> schemaFields, PXGrid grid, string[] locales)
{
PXGridColumn[] columnsToDelete = grid.Levels[0].Columns
.Cast <PXGridColumn>()
.Where(column => locales.Contains(column.DataField))
.ToArray();
List <string> fastFilterFieldsList = new List <string>(grid.FastFilterFields);
foreach (PXGridColumn column in columnsToDelete)
{
grid.Levels[0].Columns.Remove(column);
fastFilterFieldsList.Remove(column.DataField);
}
grid.FastFilterFields = fastFilterFieldsList.ToArray();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsCallback)
{
var sp1 = tab.FindControl("sp1") as PXSplitContainer;
PXGrid grLeft = sp1.FindControl("gridObjects") as PXGrid;
PXGrid grRight = sp1.FindControl("gridFields") as PXGrid;
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "vartab", "var tabId = '" + tab.ClientID + "';", true);
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "varGridLeft", "var grLeft = '" + grLeft.ClientID + "';", true);
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "varGridRight", "var grRight = '" + grRight.ClientID + "';", true);
Control grid = this.tab.FindControl("grid");
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "gridID", "var gridRevisionsID=\"" + grid.ClientID + "\";", true);
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "dsID", "var dsID=\"" + this.ds.ClientID + "\";", true);
}
}
private int GetPredAIndex(PXGrid grid)
{
int predAIndex = 0;
foreach (PXGridColumn column in grid.Columns)
{
if (!string.Equals(column.Header.Text, " A", StringComparison.OrdinalIgnoreCase))
{
predAIndex++;
}
else
{
break;
}
}
predAIndex--;
return(predAIndex);
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Page.IsCallback)
{
return;
}
PXGrid grid = this.tab.FindControl("grid") as PXGrid;
PXGrid grid2 = this.tab.FindControl("grid2") as PXGrid;
grid.ActionBar.Actions.EditRecord.Enabled = true;
grid2.ActionBar.Actions.EditRecord.Enabled = true;
grid.ActionBar.Actions.EditRecord.Text = PX.Data.PXMessages.LocalizeNoPrefix(PX.Objects.GL.Messages.ViewBatch);
grid.ActionBar.Actions.EditRecord.Tooltip = PX.Data.PXMessages.LocalizeNoPrefix(PX.Objects.GL.Messages.ttipViewBatch);
grid2.ActionBar.Actions.EditRecord.Text = PX.Data.PXMessages.LocalizeNoPrefix(PX.Objects.GL.Messages.ViewBatch);
grid2.ActionBar.Actions.EditRecord.Tooltip = PX.Data.PXMessages.LocalizeNoPrefix(PX.Objects.GL.Messages.ttipViewBatch);
}
protected void CreateColumns(IEnumerable <PXFieldState> schemaFields, PXGrid grid, Dictionary <string, string> locales, string[] languages)
{
if (locales != null)
{
List <string> list = grid.Levels[0].Columns
.Cast <PXGridColumn>()
.Where(col => !string.IsNullOrEmpty(col.DataField))
.Select(col => col.DataField)
.Concat(TranslationMaint.MultilingualTranslator.FORBIDDEN_COLUMNS)
.ToList();
PXFieldState[] dynamicFields = schemaFields
.Where(field => list.All(col => string.Compare(field.Name, col, StringComparison.InvariantCultureIgnoreCase) != 0))
.ToArray();
//Array.Sort(dynamicFields, (f1, f2) => string.Compare(locales[f1.Name], locales[f2.Name], StringComparison.InvariantCultureIgnoreCase));
foreach (PXFieldState field in dynamicFields)
{
PXGridColumn col = new PXGridColumn
{
DataField = field.Name,
DataType = TypeCode.String,
Multiline = true,
TextAlign = HorizontalAlign.Left,
Width = Unit.Pixel(250),
Visible = true,
AllowShowHide = AllowShowHide.Server,
};
col.Header.Text = locales[field.Name];
grid.Columns.Add(col);
}
List <PXGridColumn> columnsToDelete = grid.Levels[0].Columns
.Cast <PXGridColumn>()
.Where(column => locales.ContainsKey(column.DataField) && !languages.Contains(column.DataField))
.ToList();
foreach (PXGridColumn column in columnsToDelete)
{
grid.Levels[0].Columns.Remove(column);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsCallback)
{
PXGrid grid = this.tab.FindControl("grdFilter") as PX.Web.UI.PXGrid;
if (grid != null)
{
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "gridFilterID", "var grdFilterID=\"" + grid.ClientID + "\";", true);
}
grid = this.tab.FindControl("grdResults") as PX.Web.UI.PXGrid;
if (grid != null)
{
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "gridResultsID", "var grdResultsID=\"" + grid.ClientID + "\";", true);
}
grid = this.tab.FindControl("grdSorts") as PX.Web.UI.PXGrid;
if (grid != null)
{
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "gridSortsID", "var grdSortsID=\"" + grid.ClientID + "\";", true);
}
grid = this.tab.FindControl("grdWheres") as PX.Web.UI.PXGrid;
if (grid != null)
{
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "grdWheres", "var grdWheresID=\"" + grid.ClientID + "\";", true);
}
grid = this.tab.FindControl("grdGroupBy") as PX.Web.UI.PXGrid;
if (grid != null)
{
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "grdGroupBy", "var grdGroupByID=\"" + grid.ClientID + "\";", true);
}
PXSplitContainer sp1 = this.tab.FindControl("sp1") as PXSplitContainer;
grid = sp1.FindControl("grdJoins") as PX.Web.UI.PXGrid;
if (grid != null)
{
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "grdJoins", "var grdJoinsID=\"" + grid.ClientID + "\";", true);
}
grid = sp1.FindControl("grdOns") as PX.Web.UI.PXGrid;
if (grid != null)
{
this.Page.ClientScript.RegisterClientScriptBlock(GetType(), "grdOns", "var grdOnsID=\"" + grid.ClientID + "\";", true);
}
}
}
private void AddFastFilterFields(PXGrid grid)
{
if (grid != null && grid.Levels != null && grid.Levels[0] != null && grid.Levels[0].Columns != null)
{
List <string> fastFilterFields = new List <string>();
for (int i = 0; i < grid.Levels[0].Columns.Count; i++)
{
if (!string.IsNullOrEmpty(grid.Levels[0].Columns[i].DataField))
{
fastFilterFields.Add(grid.Levels[0].Columns[i].DataField);
}
}
if (fastFilterFields.Count > 0)
{
grid.FastFilterFields = fastFilterFields.ToArray();
}
}
}
private void AddFastFilterFields(PXGrid grid)
{
if (grid != null && grid.Levels != null && grid.Levels[0] != null && grid.Levels[0].Columns != null)
{
List<string> fastFilterFields = new List<string>();
for (int i = 0; i < grid.Levels[0].Columns.Count; i++)
{
if (!string.IsNullOrEmpty(grid.Levels[0].Columns[i].DataField))
{
fastFilterFields.Add(grid.Levels[0].Columns[i].DataField);
}
}
if (fastFilterFields.Count > 0)
{
grid.FastFilterFields = fastFilterFields.ToArray();
}
}
}
protected void Page_Init(object sender, EventArgs e)
{
var mainContainer = this.tab.Items.Items.First(ti => String.Equals(ti.Key, "Subitems", StringComparison.OrdinalIgnoreCase)).TemplateContainer.Controls;
if (mainContainer.Count != 0)
mainContainer[1].Visible = false;
PXGraph graph = this.ds.DataGraph;
List<string> views = (from view in graph.Views where view.Key.StartsWith("SubItem_") select view.Key).ToList();
PXSplitContainer parentContainer = null;
List<object> segments = null;
if (graph.Views.ContainsKey("DimensionsSubItem"))
segments = graph.Views["DimensionsSubItem"].SelectMulti();
for(int i=0; i<views.Count; i++)
{
ControlCollection controls = mainContainer;
if (i == views.Count - 1)
{
if (parentContainer != null)
controls = parentContainer.TemplateContainer2.Controls;
}
else
{
PXSplitContainer container = new PXSplitContainer();
container.ID = "splitSubItem" + i;
container.SplitterPosition = 300;
container.Height = 600;
container.SkinID = "Horizontal";
container.AutoSize.Enabled = true;
container.AutoSize.Container = DockContainer.Window;
if (parentContainer == null)
mainContainer.Add(container);
else
parentContainer.TemplateContainer2.Controls.Add(container);
container.ApplyStyleSheetSkin(this.Page);
controls = container.TemplateContainer1.Controls;
parentContainer = container;
}
PXGrid grid = new PXGrid();
grid.ID = "gridSubItem" + i;
grid.DataSourceID = this.ds.ID;
grid.Levels.Add(new PXGridLevel()
{
DataMember = views[i]
});
grid.AutoSize.Enabled = true;
grid.Height = new Unit(150, UnitType.Pixel);
grid.Width = new Unit(100,UnitType.Percentage);
grid.Style.Add(HtmlTextWriterStyle.ZIndex, "100");
grid.SkinID = "ShortList";
//grid.ActionBar.ActionsVisible = false;
//grid.ActionBar.PagerVisible = ActionVisible.False;
grid.Columns.Add(new PXGridColumn()
{
DataField = "Active",
Type = GridColumnType.CheckBox,
AllowCheckAll = true,
Width = new Unit(75, UnitType.Pixel)
});
grid.Columns.Add(new PXGridColumn()
{
DataField = "Value",
Width = new Unit(100, UnitType.Pixel)
});
grid.Columns.Add(new PXGridColumn()
{
DataField = "Descr",
Width = new Unit(250, UnitType.Pixel)
});
if (segments != null && segments.Count > i)
{
grid.Caption = ((Segment) segments[i]).Descr;
grid.CaptionVisible = true;
}
controls.Add(grid);
grid.ApplyStyleSheetSkin(this.Page);
grid.AutoAdjustColumns = false;
}
}
protected void Page_Init(object sender, EventArgs e)
{
var mainContainer = this.tab.Items.Items.First(ti => String.Equals(ti.Key, "Subitems", StringComparison.OrdinalIgnoreCase)).TemplateContainer.Controls;
if (mainContainer.Count != 0)
{
mainContainer[1].Visible = false;
}
PXGraph graph = this.ds.DataGraph;
List <string> views = (from view in graph.Views where view.Key.StartsWith("SubItem_") select view.Key).ToList();
PXSplitContainer parentContainer = null;
List <object> segments = null;
if (graph.Views.ContainsKey("DimensionsSubItem"))
{
segments = graph.Views["DimensionsSubItem"].SelectMulti();
}
for (int i = 0; i < views.Count; i++)
{
ControlCollection controls = mainContainer;
if (i == views.Count - 1)
{
if (parentContainer != null)
{
controls = parentContainer.TemplateContainer2.Controls;
}
}
else
{
PXSplitContainer container = new PXSplitContainer();
container.ID = "splitSubItem" + i;
container.SplitterPosition = 600 / views.Count;
container.Height = 600;
container.SkinID = "Horizontal";
container.AutoSize.Enabled = true;
if (parentContainer == null)
{
mainContainer.Add(container);
}
else
{
parentContainer.TemplateContainer2.Controls.Add(container);
}
container.ApplyStyleSheetSkin(this.Page);
controls = container.TemplateContainer1.Controls;
parentContainer = container;
}
PXGrid grid = new PXGrid();
grid.ID = "gridSubItem" + i;
grid.DataSourceID = this.ds.ID;
grid.Levels.Add(new PXGridLevel()
{
DataMember = views[i]
});
grid.AutoSize.Enabled = true;
grid.Height = new Unit(150, UnitType.Pixel);
grid.Width = new Unit(100, UnitType.Percentage);
grid.Style.Add(HtmlTextWriterStyle.ZIndex, "100");
grid.SkinID = "DetailsInTab";
//grid.ActionBar.ActionsVisible = false;
//grid.ActionBar.PagerVisible = ActionVisible.False;
grid.Columns.Add(new PXGridColumn()
{
DataField = "Active",
Type = GridColumnType.CheckBox,
TextAlign = HorizontalAlign.Center,
AllowCheckAll = true,
Width = new Unit(75, UnitType.Pixel)
});
grid.Columns.Add(new PXGridColumn()
{
DataField = "Value",
Width = new Unit(100, UnitType.Pixel)
});
grid.Columns.Add(new PXGridColumn()
{
DataField = "Descr",
Width = new Unit(250, UnitType.Pixel)
});
if (segments != null && segments.Count > i)
{
grid.Caption = ((Segment)segments[i]).Descr;
grid.CaptionVisible = true;
}
controls.Add(grid);
grid.ApplyStyleSheetSkin(this.Page);
grid.AutoAdjustColumns = false;
}
}
protected void CreateColumns(PXDataSourceViewSchema schema, PXGrid grid)
{
List <string> list = new List <string>();
foreach (PXGridColumn col in grid.Levels[0].Columns)
{
if (!String.IsNullOrEmpty(col.DataField))
{
list.Add(col.DataField);
}
}
foreach (PXFieldState field in schema.GetFields())
{
if (!AUAuditInquire.FORBIDDEN_COLUMNS.Contains(field.Name) && field.Name.EndsWith(AUAuditInquire.VIRTUAL_FIELD_SUFFIX) && !list.Contains(field.Name))
{
PXGridColumn col = new PXGridColumn();
col.DataField = field.Name;
col.DataType = Type.GetTypeCode(field.DataType);
col.TextAlign = HorizontalAlign.Right;
col.Width = Unit.Pixel(120);
switch (col.DataType)
{
case TypeCode.Boolean:
col.Width = Unit.Pixel(60);
col.Type = GridColumnType.CheckBox;
col.TextAlign = HorizontalAlign.Center;
break;
case TypeCode.DateTime:
col.TextAlign = HorizontalAlign.Left;
col.DisplayFormat = "g";
break;
case TypeCode.String:
col.TextAlign = HorizontalAlign.Left;
break;
}
col.Visible = true;
col.Header.Text = field.DisplayName == field.Name
? field.DisplayName.Substring(0, field.DisplayName.Length - AUAuditInquire.VIRTUAL_FIELD_SUFFIX.Length)
: field.DisplayName;
col.AllowShowHide = AllowShowHide.Server;
grid.Columns.Add(col);
}
list.Remove(field.Name);
}
foreach (string field in list)
{
PXGridColumn col = GetColumn(grid, field);
if (col != null)
{
grid.Levels[0].Columns.Remove(col);
}
}
grid.FastFilterFields = grid.Columns.Items.Select(col => col.DataField).ToArray();
//if (grid.Levels[0].Columns.Count <= 1) grid.AllowAutoHide = true;
}
private PXGridColumn GetColumn(PXGrid grid, String name)
{
foreach (PXGridColumn col in grid.Levels[0].Columns)
{
if (col.DataField == name) return col;
}
return null;
}
protected void CreateColumns(PXDataSourceViewSchema schema, PXGrid grid)
{
var gridColumn = sp1.FindControl("gridColumn") as PXGrid;
List<string> list = new List<string>();
foreach (PXGridColumn col in grid.Levels[0].Columns)
{
if (!String.IsNullOrEmpty(col.DataField))
{
list.Add(col.DataField);
}
}
foreach (PXFieldState field in schema.GetFields())
{
if (field.Name.Length <= 3 || field.Name.EndsWith("_StyleID"))
{
if (!list.Contains(field.Name))
{
PXGridColumn col = new PXGridColumn();
col.DataField = field.Name;
col.DataType = Type.GetTypeCode(field.DataType);
col.Width = Unit.Pixel(150);
col.Header.Text = field.DisplayName;
col.AllowShowHide = AllowShowHide.Server;
if (grid == gridColumn)
{
col.TextField = field.Name + "_Text";
}
else if (field.Name.Length <= 3)
{
col.EditorID = "edColHeader";
}
grid.Columns.Add(col);
}
}
list.Remove(field.Name);
}
foreach (string field in list)
{
foreach (PXGridColumn col in grid.Levels[0].Columns)
{
if (col.DataField == field)
{
grid.Levels[0].Columns.Remove(col);
break;
}
}
}
}
protected void grid_OnLoad(object sender, EventArgs e)
{
PXGrid grid = (PXGrid)sender;
grid.ActionBar.Position = ActionsPosition.None;
}
private int GetPredAIndex(PXGrid grid)
{
int predAIndex = 0;
foreach (PXGridColumn column in grid.Columns)
{
if (!string.Equals(column.Header.Text, " A", StringComparison.OrdinalIgnoreCase))
predAIndex++;
else
break;
}
predAIndex--;
return predAIndex;
}
