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;
}
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;
}
}
}
}
/// <summary>
/// Refresh the list of data fields using specified view name.
/// </summary>
private List <PXFieldSchema> RefreshFieldsList(PXDataSourceViewSchema schema, RMReportMaint graph)
{
PX.Data.PXFieldState[] fields = schema.GetFields();
List <PXFieldSchema> list = new List <PXFieldSchema>();
if (fields != null)
{
foreach (PX.Data.PXFieldState f in fields)
{
if (String.IsNullOrEmpty(f.Name) || !f.Name.StartsWith("DataSource", StringComparison.OrdinalIgnoreCase) && !f.Name.StartsWith("Request", StringComparison.OrdinalIgnoreCase) && !f.Name.StartsWith("UsrRequest", StringComparison.OrdinalIgnoreCase))
{
continue;
}
string dsField = f.Name;
if (dsField.StartsWith("DataSource", StringComparison.OrdinalIgnoreCase))
{
dsField = dsField.Substring(10);
}
else if (f.Name.StartsWith("Request", StringComparison.OrdinalIgnoreCase))
{
dsField = dsField.Substring(7);
}
else
{
dsField = "Usr" + dsField.Substring(10);
}
PXFieldState dsState = graph.DataSourceByID.Cache.GetStateExt(null, dsField) as PXFieldState;
if (dsState == null || !dsState.Visible)
{
continue;
}
TypeCode dataType = Type.GetTypeCode(f.DataType);
if (dataType == TypeCode.Object)
{
continue;
}
PXFieldSchema item = new PXFieldSchema(true, f.Name, dataType);
item.ControlType = PXSchemaGenerator.GetControlType(f);
item.PrimaryKey = f.PrimaryKey;
item.ReadOnly = f.IsReadOnly;
item.AllowNull = f.Nullable;
item.MaxLength = (f.Length > 0) ? f.Length : 0;
item.Precision = (f.Precision > 0) ? f.Precision : 0;
item.Caption = f.DisplayName;
item.ViewName = f.ViewName;
item.HintField = f.DescriptionName;
item.FieldList = f.FieldList;
item.HeaderList = f.HeaderList;
item.DefaultValue = f.DefaultValue;
list.Add(item);
}
}
return(list);
}
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;
}
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;
}
}
}
}
/// <summary>
/// Refresh the list of data fields using specified view name.
/// </summary>
private List<PXFieldSchema> RefreshFieldsList(PXDataSourceViewSchema schema, RMReportMaint graph)
{
PX.Data.PXFieldState[] fields = schema.GetFields();
List<PXFieldSchema> list = new List<PXFieldSchema>();
if (fields != null)
{
foreach (PX.Data.PXFieldState f in fields)
{
if (String.IsNullOrEmpty(f.Name) || !f.Name.StartsWith("DataSource", StringComparison.OrdinalIgnoreCase) && !f.Name.StartsWith("Request", StringComparison.OrdinalIgnoreCase) && !f.Name.StartsWith("UsrRequest", StringComparison.OrdinalIgnoreCase))
continue;
string dsField = f.Name;
if (dsField.StartsWith("DataSource", StringComparison.OrdinalIgnoreCase))
dsField = dsField.Substring(10);
else if (f.Name.StartsWith("Request", StringComparison.OrdinalIgnoreCase))
dsField = dsField.Substring(7);
else
dsField = "Usr" + dsField.Substring(10);
PXFieldState dsState = graph.DataSourceByID.Cache.GetStateExt(null, dsField) as PXFieldState;
if (dsState == null || !dsState.Visible) continue;
TypeCode dataType = Type.GetTypeCode(f.DataType);
if (dataType == TypeCode.Object) continue;
PXFieldSchema item = new PXFieldSchema(true, f.Name, dataType);
item.ControlType = PXSchemaGenerator.GetControlType(f);
item.PrimaryKey = f.PrimaryKey;
item.ReadOnly = f.IsReadOnly;
item.AllowNull = f.Nullable;
item.MaxLength = (f.Length > 0) ? f.Length : 0;
item.Precision = (f.Precision > 0) ? f.Precision : 0;
item.Caption = f.DisplayName;
item.ViewName = f.ViewName;
item.HintField = f.DescriptionName;
item.FieldList = f.FieldList;
item.HeaderList = f.HeaderList;
item.DefaultValue = f.DefaultValue;
list.Add(item);
}
}
return list;
}
